/ - Diff - 工事管理システム製品化対応 - Redmine

リビジョン 209

請求入力（グリッドの行の高さ固定）
請求まとめ（注文書日付取得）

                 // dgv1
                 //
                 this.dgv1.AllowUserToAddRows = false;
                 this.dgv1.AllowUserToResizeColumns = false;
                 this.dgv1.AllowUserToResizeRows = false;
                 this.dgv1.ColumnHeadersHeight = 34;
                 this.dgv1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
                 this.dgv1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {

                     // SQL??
                     sql = new StringBuilder();
                     sql.Append("select ");
                     sql.Append("  ifnull(Bd.SEQNO, 1) as SEQNO ");
                     sql.Append("  , ifnull(Bdd.LINECOUNT, 0) as LINECOUNT ");
                     sql.Append("  , ifnull(Bdd.COMPANYCODE, CLD.CompanyCode) as COMPANYCODE ");
                     sql.Append("  , ifnull(Scm.COMPANYNAME, CLD.CompanyName) as COMPANYNAME ");
                     sql.Append("  ifnull(Bd.SeqNo, 1) as SeqNo ");
                     sql.Append("  , ifnull(Bdd.LineCount, 0) as LineCount ");
                     sql.Append("  , ifnull(Bdd.CompanyCode, Cld.CompanyCode) as CompanyCode ");
                     sql.Append("  , ifnull(Scm.CompanyName, Cld.CompanyName) as CompanyName ");
                     sql.Append("  , Sc.DisplayOrder as DisplayOrder ");
                     sql.Append("  , ifnull(Bdd.CONSTRUCTIONCODE, CL.ConstructionCode) as CONSTRUCTIONCODE ");
                     sql.Append("  , ifnull(Bdd.FIELDNAME, CBD.DetailString) as FIELDNAME ");
                     sql.Append("  , Bdd.BILLPRICE as BILLPRICE ");
                     sql.Append("  , Bdd.HIGHWPRICE as HIGHWPRICE ");
                     sql.Append("  , Bdd.HARDWPRICE as HARDWPRICE ");
                     sql.Append("  , Bdd.INDSWASTETAX as INDSWASTETAX ");
                     sql.Append("  , ifnull(Bdd.ConstructionCode, Cl.ConstructionCode) as ConstructionCode ");
                     sql.Append("  , ifnull(Bdd.FieldName, Cbd.DetailString) as FieldName ");
                     sql.Append("  , Bdd.BillPrice as BillPrice ");
                     sql.Append("  , Bdd.HighwPrice as HighwPrice ");
                     sql.Append("  , Bdd.HardwPrice as HardwPrice ");
                     sql.Append("  , Bdd.IndswasteTax as IndswasteTax ");
                     sql.Append("  , DATE_FORMAT(Bdd.UpdateDate, '%Y/%m/%d %H:%i:%s') as UpdateDate ");
                     sql.Append("  , ifnull(Bdd.Note, '') as Bikou ");
                     sql.Append("  , ifnull(Pdd.BILLPRICE, 0) as KojiSeikyu ");
                     sql.Append("  , ifnull(Pdd.BillPrice, 0) as KojiSeikyu ");
                     sql.Append("  , ifnull(Pdd.DiscountPrice, 0) as KojiNebiki ");
                     sql.Append("  , ifnull(Pdd.OffsetPrice, 0) as KojiSousai ");
                     sql.Append("  , ifnull(Pdd.NextCoPrice, 0) as JikaiKurikosi ");
                     sql.Append("  , ifnull(Pdd.HIGHWPRICE, 0) as KojiKousoku ");
                     sql.Append("  , ifnull(Pdd.HARDWPRICE, 0) as KojiKanamono ");
                     sql.Append("  , ifnull(Pdd.INDSWASTETAX, 0) as KojiSannhaiZei ");
                     sql.Append("  , ifnull(Pdd.HighwPrice, 0) as KojiKousoku ");
                     sql.Append("  , ifnull(Pdd.HardwPrice, 0) as KojiKanamono ");
                     sql.Append("  , ifnull(Pdd.IndswasteTax, 0) as KojiSannhaiZei ");
                     sql.Append("  , ifnull(Pdd.CnstrPrice, 0) as CnstrPrice ");
                     sql.Append("  , ifnull(Pdd.CNSTRPRICEEXIST, - 1) as CNSTRPRICEEXIST ");
                     sql.Append("  , ifnull(Pdd.CnstrPriceExist, - 1) as CnstrPriceExist ");
                     sql.Append("  , ifnull(Pdd.ApprovalPersonCode, 0) as ApprovalPersonCode ");
                     sql.Append("  , ifnull(Picm.SealPrintName, '') as TantoNM ");
                     sql.Append("  , DATE_FORMAT( ");
-...
                     sql.Append("  , ifnull(Cbi.ConstrSubPersonCode, 0) as ConstrSubPersonCode ");
                     sql.Append("  , ifnull(Cbi.ConstructionInstructor, 0) as ConstructionInstructor ");
                     sql.Append("  , Picm2.DepartmentCode ");
                     sql.Append("  , case ifnull(Cbi.PurchaseOrderMailingDate, '') ");
                     sql.Append("    when '' then '' ");
                     sql.Append("  , case ifnull(Pod.SendDate, '') ");
                     sql.Append("    when '' then '?~' ");
                     sql.Append("    when '2001/01/01' then '?~' ");
                     sql.Append("    else '??' ");
                     sql.Append("    end as PurchaseOrderMailingDate ");
                     sql.Append("  , case ifnull(Cbi.PurchaseOrderReturnDate, '') ");
                     sql.Append("    when '' then '' ");
                     sql.Append("  , case ifnull(Pod.ReturnCheckDate, '') ");
                     sql.Append("    when '' then '?~' ");
                     sql.Append("    when '2001/01/01' then '?~' ");
                     sql.Append("    else '??' ");
                     sql.Append("    end as PurchaseOrderReturnDate ");
                     sql.Append("  , case ifnull(Pa.PERSONCODE, 0) ");
                     sql.Append("    when 0 then case Bdd.CONSTRUCTIONCODE ");
                     sql.Append("  , case ifnull(Pa.PersonCode, 0) ");
                     sql.Append("    when 0 then case Cld.ConstructionCode ");
                     sql.Append("      when 0 then '' ");
                     sql.Append("      else '?~' ");
                     sql.Append("      end ");
                     sql.Append("    else '??' ");
                     sql.Append("    end as PaData ");
                     sql.Append("  , CLD.LineCount as LinePoint ");
                     sql.AppendFormat("  , PERIOD_DIFF({0} ,DATE_FORMAT(CL.ConstructionStart, '%Y%m')) + {1} AS ColPoint ", m_Select_TargetDate, Enum.GetNames(typeof(FrmConstructionLedger.GridColumn)).Length - 1);
                     sql.Append("  , Cld.LineCount as LinePoint ");
                     sql.AppendFormat("  , PERIOD_DIFF({0} ,DATE_FORMAT(Cl.ConstructionStart, '%Y%m')) + {1} AS ColPoint ", m_Select_TargetDate, Enum.GetNames(typeof(FrmConstructionLedger.GridColumn)).Length - 1);
                     sql.Append("from ");
                     sql.Append("  ConstructionLedgerDetail as CLD ");
                     sql.Append("  inner join ConstructionLedger as CL on CL.ConstructionCode = CLD.ConstructionCode ");
                     sql.Append("    and CL.ComplateFlg = 0 ");
                     sql.Append("  inner join ConstructionBaseinfoDetail as CBD on CBD.ConstructionCode = CLD.ConstructionCode ");
                     sql.Append("    and CBD.DetailNo = 2 ");
                     sql.Append("  inner join SubContractorMaster as Sc on Sc.COMPANYCODE = CLD.COMPANYCODE ");
                     sql.Append("  ConstructionLedgerDetail as Cld ");
                     sql.Append("  inner join ConstructionLedger as Cl on Cl.ConstructionCode = Cld.ConstructionCode ");
                     sql.Append("    and Cl.ComplateFlg = 0 ");
                     sql.Append("  inner join ConstructionBaseinfoDetail as Cbd on Cbd.ConstructionCode = Cld.ConstructionCode ");
                     sql.Append("    and Cbd.DetailNo = 2 ");
                     sql.Append("  inner join SubContractorMaster as Sc on Sc.COMPANYCODE = Cld.CompanyCode ");
                     sql.AppendFormat("  and Sc.LABOURKIND = {0} ", m_Labourkind);
                     sql.Append("  left join ConstructionLedgerExcute AS CLE on CLE.ConstructionCode = CLD.ConstructionCode ");
                     sql.Append("  and CLE.GroupCount = CLD.GroupCount ");
                     sql.Append("  and CLE.LineCount = CLD.LineCount ");
                     sql.AppendFormat("  and CLE.ColumnCount = (PERIOD_DIFF({0} ,DATE_FORMAT(CL.ConstructionStart, '%Y%m')) + {1}) ", m_Select_TargetDate, Enum.GetNames(typeof(FrmConstructionLedger.GridColumn)).Length - 1);
                     sql.Append("  left join ConstructionLedgerExcute AS Cle on Cle.ConstructionCode = Cld.ConstructionCode ");
                     sql.Append("  and Cle.GroupCount = Cld.GroupCount ");
                     sql.Append("  and Cle.LineCount = Cld.LineCount ");
                     sql.AppendFormat("    and Cle.ColumnCount = (PERIOD_DIFF({0} ,DATE_FORMAT(CL.ConstructionStart, '%Y%m')) + {1}) ", m_Select_TargetDate, Enum.GetNames(typeof(FrmConstructionLedger.GridColumn)).Length - 1);
                     sql.Append("  left join ( ");
                     sql.Append("  BillingData as Bd join ( ");
                     sql.Append("    BillingDataDetail as Bdd join SubContractorMaster as Scm ");
                     sql.Append("      on Bdd.COMPANYCODE = Scm.COMPANYCODE ");
                     sql.AppendFormat("      and Scm.LABOURKIND = {0} ", m_Labourkind);
                     sql.Append("      on Bdd.CompanyCode = Scm.CompanyCode ");
                     sql.AppendFormat("      and Scm.LabourKind = {0} ", m_Labourkind);
                     sql.Append("      left join ( ");
                     sql.Append("        PaymentDataDetail as Pdd ");
                     sql.Append("          left join PersonInChargeMaster as Picm ");
                     sql.Append("            on ifnull(Pdd.ApprovalPersonCode, - 1) = Picm.PERSONCODE ");
                     sql.Append("            on ifnull(Pdd.ApprovalPersonCode, - 1) = Picm.PersonCode ");
                     sql.Append("      ) ");
                     sql.Append("        on Bdd.COMPANYCODE = Pdd.COMPANYCODE ");
                     sql.Append("        and Bdd.TARGETDATE = Pdd.TARGETDATE ");
                     sql.Append("        and Bdd.SEQNO = Pdd.SEQNO ");
                     sql.Append("        and Bdd.LINECOUNT = Pdd.LINECOUNT ");
                     sql.Append("        on Bdd.CompanyCode = Pdd.CompanyCode ");
                     sql.Append("        and Bdd.TargetDate = Pdd.TargetDate ");
                     sql.Append("        and Bdd.SeqNo = Pdd.SeqNo ");
                     sql.Append("        and Bdd.LineCount = Pdd.LineCount ");
                     sql.Append("  ) ");
                     sql.Append("       on Bd.CompanyCode = BdD.CompanyCode ");
                     sql.Append("       and Bd.TargetDate = BdD.TargetDate ");
                     sql.Append("       and Bd.SeqNo = BdD.SeqNo ");
                     sql.AppendFormat("       and Bd.TargetDate = {0} ", m_Select_TargetDate);
                     sql.Append("  ) on Bd.COMPANYCODE = Cld.CompanyCode ");
                     sql.Append("  and Bdd.ConstructionCode = Cld.ConstructionCode ");
                     sql.Append("  left join ( ");
                     sql.Append("    PurchaseOrderDate as Pod ");
                     sql.Append("  ) on Cld.CompanyCode = Pod.CompanyCode ");
                     sql.Append("  and Cld.ConstructionCode = Pod.ConstructionCode ");
                     sql.Append("  left join ( ");
                     sql.Append("    ConstructionBaseInfo as Cbi ");
                     sql.Append("      left join ( ");
                     sql.Append("        ConstructionBaseInfo as Cbi ");
                     sql.Append("          left join ( ");
                     sql.Append("            PersonInChargeMaster as Picm2 ");
                     sql.Append("              left join ApprovalMaster as Am ");
                     sql.Append("                on Picm2.DEPARTMENTCODE = Am.DEPARTMENTCODE ");
                     sql.Append("                and Am.ApprovalCode = 3 ");
                     sql.Append("                and ApprovalAuthority = 1 ");
                     sql.Append("          ) ");
                     sql.Append("            on Cbi.ConstructionPersonCode = Picm2.PERSONCODE ");
                     sql.Append("          left join ProcessApproval as Pa ");
                     sql.Append("            on Cbi.CONSTRUCTIONCODE = Pa.CONSTRUCTIONCODE ");
                     sql.Append("            and Am.APPROVALPERSON = Pa.PERSONCODE ");
                     sql.Append("            and Pa.SEQNO > 1 ");
                     sql.Append("            and Pa.APPROVALSTATUS = 2 ");
                     sql.Append("        PersonInChargeMaster as Picm2 ");
                     sql.Append("          left join ApprovalMaster as Am ");
                     sql.Append("            on Picm2.DepartmentCode = Am.DepartmentCode ");
                     sql.Append("            and Am.ApprovalCode = 3 ");
                     sql.Append("            and ApprovalAuthority = 1 ");
                     sql.Append("      ) ");
                     sql.Append("        on Bdd.CONSTRUCTIONCODE = Cbi.CONSTRUCTIONCODE ");
                     sql.Append("        on Cbi.ConstructionPersonCode = Picm2.PersonCode ");
                     sql.Append("      left join ProcessApproval as Pa ");
                     sql.Append("        on Cbi.ConstructionCode = Pa.ConstructionCode ");
                     sql.Append("        and Am.ApprovalPerson = Pa.PersonCode ");
                     sql.Append("        and Pa.SeqNo > 1 ");
                     sql.Append("        and Pa.ApprovalStatus = 2 ");
                     sql.Append("  ) ");
                     sql.Append("       on Bd.COMPANYCODE = BdD.COMPANYCODE ");
                     sql.Append("       and Bd.TARGETDATE = BdD.TARGETDATE ");
                     sql.Append("       and Bd.SEQNO = BdD.SEQNO ");
                     sql.AppendFormat(" and Bd.TARGETDATE = {0} ", m_Select_TargetDate);
                     sql.Append(") on Bd.COMPANYCODE = CLD.CompanyCode ");
                     sql.Append("and Bdd.CONSTRUCTIONCODE = CLD.CONSTRUCTIONCODE ");
                     sql.Append("    on Cld.ConstructionCode = Cbi.ConstructionCode ");
                     sql.Append("where ");
                     sql.Append("  CLD.GroupCount = 2 ");
                     sql.Append("  and CLD.CompanyCode > 0 ");
                     sql.AppendFormat("  and CLD.CompanyType = {0}", m_Labourkind);
                     sql.Append("  Cld.GroupCount = 2 ");
                     sql.Append("  and Cld.CompanyCode > 0 ");
                     sql.AppendFormat("  and Cld.CompanyType = {0}", m_Labourkind);
                     sql.Append(" ");
                     sql.Append("union ");
                     sql.Append(" ");
                     sql.Append("select ");
                     sql.Append("  ifnull(Bd.SEQNO, 1) as SEQNO ");
                     sql.Append("  , ifnull(Bdd.LINECOUNT, 0) as LINECOUNT ");
                     sql.Append("  , ifnull(Bdd.COMPANYCODE, 0) as COMPANYCODE ");
                     sql.Append("  , ifnull(Scm.COMPANYNAME, \"\") as COMPANYNAME ");
                     sql.Append("  ifnull(Bd.SeqNo, 1) as SeqNo ");
                     sql.Append("  , ifnull(Bdd.LineCount, 0) as LineCount ");
                     sql.Append("  , ifnull(Bdd.CompanyCode, 0) as CompanyCode ");
                     sql.Append("  , ifnull(Scm.CompanyName, \"\") as CompanyName ");
                     sql.Append("  , Scm.DisplayOrder as DisplayOrder ");
                     sql.Append("  , Bdd.CONSTRUCTIONCODE as CONSTRUCTIONCODE ");
                     sql.Append("  , Bdd.FIELDNAME as FIELDNAME ");
                     sql.Append("  , Bdd.BILLPRICE as BILLPRICE ");
                     sql.Append("  , Bdd.HIGHWPRICE as HIGHWPRICE ");
                     sql.Append("  , Bdd.HARDWPRICE as HARDWPRICE ");
                     sql.Append("  , Bdd.INDSWASTETAX as INDSWASTETAX ");
                     sql.Append("  , Bdd.ConstructionCode as ConstructionCode ");
                     sql.Append("  , Bdd.FieldName as FieldName ");
                     sql.Append("  , Bdd.BillPrice as BillPrice ");
                     sql.Append("  , Bdd.HighwPrice as HighwPrice ");
                     sql.Append("  , Bdd.HardwPrice as HardwPrice ");
                     sql.Append("  , Bdd.IndswasteTax as IndswasteTax ");
                     sql.Append("  , DATE_FORMAT(Bdd.UpdateDate, '%Y/%m/%d %H:%i:%s') as UpdateDate ");
                     sql.Append("  , ifnull(Bdd.Note, '') as Bikou ");
                     sql.Append("  , ifnull(Pdd.BILLPRICE, 0) as KojiSeikyu ");
                     sql.Append("  , ifnull(Pdd.BillPrice, 0) as KojiSeikyu ");
                     sql.Append("  , ifnull(Pdd.DiscountPrice, 0) as KojiNebiki ");
                     sql.Append("  , ifnull(Pdd.OffsetPrice, 0) as KojiSousai ");
                     sql.Append("  , ifnull(Pdd.NextCoPrice, 0) as JikaiKurikosi ");
                     sql.Append("  , ifnull(Pdd.HIGHWPRICE, 0) as KojiKousoku ");
                     sql.Append("  , ifnull(Pdd.HARDWPRICE, 0) as KojiKanamono ");
                     sql.Append("  , ifnull(Pdd.INDSWASTETAX, 0) as KojiSannhaiZei ");
                     sql.Append("  , ifnull(Pdd.HighwPrice, 0) as KojiKousoku ");
                     sql.Append("  , ifnull(Pdd.HardwPrice, 0) as KojiKanamono ");
                     sql.Append("  , ifnull(Pdd.IndswasteTax, 0) as KojiSannhaiZei ");
                     sql.Append("  , ifnull(Pdd.CnstrPrice, 0) as CnstrPrice ");
                     sql.Append("  , ifnull(Pdd.CNSTRPRICEEXIST, - 1) as CNSTRPRICEEXIST ");
                     sql.Append("  , ifnull(Pdd.CnstrPriceExist, - 1) as CnstrPriceExist ");
                     sql.Append("  , ifnull(Pdd.ApprovalPersonCode, 0) as ApprovalPersonCode ");
                     sql.Append("  , ifnull(Picm.SealPrintName, '') as TantoNM ");
                     sql.Append("  , DATE_FORMAT( ");
-...
                     sql.Append("  , ifnull(Cbi.ConstrSubPersonCode, 0) as ConstrSubPersonCode ");
                     sql.Append("  , ifnull(Cbi.ConstructionInstructor, 0) as ConstructionInstructor ");
                     sql.Append("  , Picm2.DepartmentCode ");
                     sql.Append("  , case ifnull(Cbi.PurchaseOrderMailingDate, '') ");
                     sql.Append("    when '' then '' ");
                     sql.Append("  , case ifnull(Pod.SendDate, '') ");
                     sql.Append("    when '' then '?~' ");
                     sql.Append("    when '2001/01/01' then '?~' ");
                     sql.Append("    else '??' ");
                     sql.Append("    end as PurchaseOrderMailingDate ");
                     sql.Append("  , case ifnull(Cbi.PurchaseOrderReturnDate, '') ");
                     sql.Append("    when '' then '' ");
                     sql.Append("  , case ifnull(Pod.ReturnCheckDate, '') ");
                     sql.Append("    when '' then '?~' ");
                     sql.Append("    when '2001/01/01' then '?~' ");
                     sql.Append("    else '??' ");
                     sql.Append("    end as PurchaseOrderReturnDate ");
                     sql.Append("  , case ifnull(Pa.PERSONCODE, 0) ");
                     sql.Append("    when 0 then case Bdd.CONSTRUCTIONCODE ");
                     sql.Append("  , case ifnull(Pa.PersonCode, 0) ");
                     sql.Append("    when 0 then case Bdd.ConstructionCode ");
                     sql.Append("      when 0 then '' ");
                     sql.Append("      else '?~' ");
                     sql.Append("      end ");
-...
                     sql.Append("from ");
                     sql.Append("  BillingData as Bd join ( ");
                     sql.Append("    BillingDataDetail as Bdd join SubContractorMaster as Scm ");
                     sql.Append("      on Bdd.COMPANYCODE = Scm.COMPANYCODE ");
                     sql.AppendFormat("      and Scm.LABOURKIND = {0} ", m_Labourkind);
                     sql.Append("      on Bdd.CompanyCode = Scm.CompanyCode ");
                     sql.AppendFormat("      and Scm.LabourKind = {0} ", m_Labourkind);
                     sql.Append("      left join ( ");
                     sql.Append("        PaymentDataDetail as Pdd ");
                     sql.Append("          left join PersonInChargeMaster as Picm ");
                     sql.Append("            on ifnull(Pdd.ApprovalPersonCode, - 1) = Picm.PERSONCODE ");
                     sql.Append("            on ifnull(Pdd.ApprovalPersonCode, - 1) = Picm.PersonCode ");
                     sql.Append("      ) ");
                     sql.Append("        on Bdd.COMPANYCODE = Pdd.COMPANYCODE ");
                     sql.Append("        and Bdd.TARGETDATE = Pdd.TARGETDATE ");
                     sql.Append("        and Bdd.SEQNO = Pdd.SEQNO ");
                     sql.Append("        and Bdd.LINECOUNT = Pdd.LINECOUNT ");
                     sql.Append("        on Bdd.CompanyCode = Pdd.CompanyCode ");
                     sql.Append("        and Bdd.TargetDate = Pdd.TargetDate ");
                     sql.Append("        and Bdd.SeqNo = Pdd.SeqNo ");
                     sql.Append("        and Bdd.LineCount = Pdd.LineCount ");
                     sql.Append("      left join ( ");
                     sql.Append("        ConstructionBaseInfo as Cbi ");
                     sql.Append("          left join ( ");
                     sql.Append("            PersonInChargeMaster as Picm2 ");
                     sql.Append("              left join ApprovalMaster as Am ");
                     sql.Append("                on Picm2.DEPARTMENTCODE = Am.DEPARTMENTCODE ");
                     sql.Append("                on Picm2.DepartmentCode = Am.DepartmentCode ");
                     sql.Append("                and Am.ApprovalCode = 3 ");
                     sql.Append("                and ApprovalAuthority = 1 ");
                     sql.Append("          ) ");
                     sql.Append("            on Cbi.ConstructionPersonCode = Picm2.PERSONCODE ");
                     sql.Append("            on Cbi.ConstructionPersonCode = Picm2.PersonCode ");
                     sql.Append("          left join ProcessApproval as Pa ");
                     sql.Append("            on Cbi.CONSTRUCTIONCODE = Pa.CONSTRUCTIONCODE ");
                     sql.Append("            and Am.APPROVALPERSON = Pa.PERSONCODE ");
                     sql.Append("            and Pa.SEQNO > 1 ");
                     sql.Append("            and Pa.APPROVALSTATUS = 2 ");
                     sql.Append("            on Cbi.ConstructionCode = Pa.ConstructionCode ");
                     sql.Append("            and Am.ApprovalPerson = Pa.PersonCode ");
                     sql.Append("            and Pa.SeqNo > 1 ");
                     sql.Append("            and Pa.ApprovalStatus = 2 ");
                     sql.Append("      ) ");
                     sql.Append("        on Bdd.CONSTRUCTIONCODE = Cbi.CONSTRUCTIONCODE ");
                     sql.Append("        on Bdd.ConstructionCode = Cbi.ConstructionCode ");
                     sql.Append("  ) ");
                     sql.Append("       on Bd.COMPANYCODE = BdD.COMPANYCODE ");
                     sql.Append("       and Bd.TARGETDATE = BdD.TARGETDATE ");
                     sql.Append("       and Bd.SEQNO = BdD.SEQNO ");
                     sql.AppendFormat(" and Bd.TARGETDATE = {0} ", m_Select_TargetDate);
                     sql.Append("       on Bd.CompanyCode = Bdd.CompanyCode ");
                     sql.Append("       and Bd.TargetDate = Bdd.TargetDate ");
                     sql.Append("       and Bd.SeqNo = Bdd.SeqNo ");
                     sql.AppendFormat(" and Bd.TargetDate = {0} ", m_Select_TargetDate);
                     sql.Append("    and Bdd.CONSTRUCTIONCODE = 0 ");
                     sql.Append("  left join ( ");
                     sql.Append("    PurchaseOrderDate as Pod ");
                     sql.Append("  ) on Bd.CompanyCode = Pod.CompanyCode ");
                     sql.Append("  and Bdd.ConstructionCode = Pod.ConstructionCode ");
                     sql.Append(" ");
                     sql.Append("group by ");
                     sql.Append("  SEQNO ");
                     sql.Append("  , LINECOUNT ");
                     sql.Append("  , COMPANYCODE ");
                     sql.Append("  , COMPANYNAME ");
                     sql.Append("  SeqNo ");
                     sql.Append("  , LineCount ");
                     sql.Append("  , CompanyCode ");
                     sql.Append("  , CompanyName ");
                     sql.Append("  , DisplayOrder ");
                     sql.Append("  , CONSTRUCTIONCODE ");
                     sql.Append("  , FIELDNAME ");
                     sql.Append("  , BILLPRICE ");
                     sql.Append("  , HIGHWPRICE ");
                     sql.Append("  , HARDWPRICE ");
                     sql.Append("  , INDSWASTETAX ");
                     sql.Append("  , ConstructionCode ");
                     sql.Append("  , FieldName ");
                     sql.Append("  , BillPrice ");
                     sql.Append("  , HighwPrice ");
                     sql.Append("  , Hardwprice ");
                     sql.Append("  , IndswasteTax ");
                     sql.Append("  , UpdateDate ");
                     sql.Append("  , Bikou ");
                     sql.Append("  , BILLPRICE ");
                     sql.Append("  , DiscountPrice ");
                     sql.Append("  , OffsetPrice ");
                     sql.Append("  , NextCoPrice ");
                     sql.Append("  , HIGHWPRICE ");
                     sql.Append("  , HARDWPRICE ");
                     sql.Append("  , INDSWASTETAX ");
                     sql.Append("  , KojiSeikyu ");
                     sql.Append("  , KojiNebiki ");
                     sql.Append("  , KojiSousai ");
                     sql.Append("  , JikaiKurikosi ");
                     sql.Append("  , KojiKousoku ");
                     sql.Append("  , KojiKanamono ");
                     sql.Append("  , KojiSannhaiZei ");
                     sql.Append("  , CnstrPrice ");
                     sql.Append("  , CNSTRPRICEEXIST ");
                     sql.Append("  , CnstrpriceExist ");
                     sql.Append("  , ApprovalPersonCode ");
                     sql.Append("  , TantoNM ");
                     sql.Append("  , ApprovalDate ");
-...
                     if (dgvCompany.Visible == true)         // ???P??\??
+                    {
                         sql.AppendLine("order by COMPANYCODE ASC, SEQNO DESC, case when CONSTRUCTIONCODE = 0 Then  2099999999 else LINECOUNT end ");
                         sql.AppendLine("order by CompanyCode ASC, SeqNo DESC, case when ConstructionCode = 0 Then  2099999999 else LineCount end ");
+                    }
                     else if (dgvProject.Visible == true)    // ????P??\??
+                    {
                         sql.AppendLine("order by ConstructionPersonCode ASC, CONSTRUCTIONCODE DESC, DISPLAYORDER ASC, SEQNO ASC, LINECOUNT ASC ");
                         sql.AppendLine("order by ConstructionPersonCode ASC, ConstructionCode DESC, DisplayOrder ASC, SEQNO ASC, LineCount ASC ");
+                    }
                     // ?f?[?^???@???v?E???v???v?Z?????A?S???f?[?^????????

                 this.Column64 = new System.Windows.Forms.DataGridViewTextBoxColumn();
                 this.Column139 = new System.Windows.Forms.DataGridViewTextBoxColumn();
                 this.Column140 = new System.Windows.Forms.DataGridViewTextBoxColumn();
                 this.CombinedOrderLabel1 = new System.Windows.Forms.Label();
                 this.CombinedOrderLabel2 = new System.Windows.Forms.Label();
                 this.panel1.SuspendLayout();
                 this.groupBoxEx1.SuspendLayout();
                 ((System.ComponentModel.ISupportInitialize)(this.dgvProject)).BeginInit();
-...
                 this.Column140.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
                 this.Column140.Visible = false;
                 //
                 // CombinedOrderLabel1
                 //
                 this.CombinedOrderLabel1.BackColor = System.Drawing.Color.DimGray;
                 this.CombinedOrderLabel1.Font = new System.Drawing.Font("ＭＳ 明朝", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
                 this.CombinedOrderLabel1.ForeColor = System.Drawing.Color.White;
                 this.CombinedOrderLabel1.Location = new System.Drawing.Point(35, 21);
                 this.CombinedOrderLabel1.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
                 this.CombinedOrderLabel1.Name = "CombinedOrderLabel1";
                 this.CombinedOrderLabel1.Size = new System.Drawing.Size(180, 30);
                 this.CombinedOrderLabel1.TabIndex = 18;
                 this.CombinedOrderLabel1.Text = "手間支払";
                 this.CombinedOrderLabel1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
                 //
                 // CombinedOrderLabel2
                 //
                 this.CombinedOrderLabel2.BackColor = System.Drawing.Color.DimGray;
                 this.CombinedOrderLabel2.Font = new System.Drawing.Font("ＭＳ 明朝", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
                 this.CombinedOrderLabel2.ForeColor = System.Drawing.Color.White;
                 this.CombinedOrderLabel2.Location = new System.Drawing.Point(35, 21);
                 this.CombinedOrderLabel2.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
                 this.CombinedOrderLabel2.Name = "CombinedOrderLabel2";
                 this.CombinedOrderLabel2.Size = new System.Drawing.Size(180, 30);
                 this.CombinedOrderLabel2.TabIndex = 18;
                 this.CombinedOrderLabel2.Text = "業者支払";
                 this.CombinedOrderLabel2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
                 //
                 // FrmRequestSummaryList
                 //
                 this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.None;
                 this.BackColor = System.Drawing.Color.Black;
                 this.ClientSize = new System.Drawing.Size(1578, 846);
                 this.Controls.Add(this.CombinedOrderLabel1);
                 this.Controls.Add(this.CombinedOrderLabel2);
                 this.Controls.Add(this.panel1);
                 this.Controls.Add(this.btnAddProject);
                 this.Controls.Add(this.groupBoxEx1);
-...
             private System.Windows.Forms.DataGridViewTextBoxColumn Column77;
             private System.Windows.Forms.DataGridViewTextBoxColumn Column141;
             private System.Windows.Forms.DataGridViewTextBoxColumn Column142;
             private System.Windows.Forms.Label CombinedOrderLabel1;
             private System.Windows.Forms.Label CombinedOrderLabel2;
+        }
+    }

+            {
                 IOBankBusinessDayMaster IoBbdm = new IOBankBusinessDayMaster();
                 List<BankBusinessDayMaster> LstBbdm = new List<BankBusinessDayMaster>();
                 // ???x???m?F?????x???m?F????\??
                 if (m_Labourkind == 1)
+                {
                     CombinedOrderLabel1.Visible = true;
                     CombinedOrderLabel2.Visible = false;
+                }
                 else
+                {
                     CombinedOrderLabel1.Visible = false;
                     CombinedOrderLabel2.Visible = true;
+                }
                 try
+                {
                     // ?O???b?h?R???{?f?[?^
-...
+            }
             #endregion ???????
             #region ???\?????t???O????????????\??????
             /// <summary>
             /// ???\?????t???O????????????\??????

他の形式にエクスポート: Unified diff

プロジェクト

全般

プロフィール

工事管理システム製品化対応

リビジョン 209