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

                if (radioButton1.Checked)

                {

                    wrkFormat.Append(" C.PERSONCODE,");

                    wrkFormat.Append(" C.PERSONNAME,");

                    wrkFormat.Append(" C.DEPARTMENTCODE,");

                    wrkFormat.Append(" C.DEPARTMENTNAME,");

                    wrkFormat.Append(" C.MANDISPORDER,");

                    wrkFormat.Append(" C.DEPDISPORDER,");

                }

                else

                {

                    wrkFormat.Append(" D.PERSONCODE,");

                    wrkFormat.Append(" D.PERSONNAME,");

                    wrkFormat.Append(" D.DEPARTMENTCODE,");

                    wrkFormat.Append(" D.DEPARTMENTNAME,");

                    wrkFormat.Append(" D.MANDISPORDER,");

                    wrkFormat.Append(" D.DEPDISPORDER,");

                }

                wrkFormat.Append("            CA.CONSTRUCTIONCODE");

                wrkFormat.Append("          , CA.CONSTRUCTIONPERSONCODE PERSONCODE");

                wrkFormat.Append("          , CB.PERSONNAME PERSONNAME");

                wrkFormat.Append("          , ifnull(CA.ConstrDepCode, 0) As DEPARTMENTCODE");

                wrkFormat.Append("          , ifnull(CD.DetailString, '') As DEPARTMENTNAME");

                wrkFormat.Append("          , ifnull(CB.DISPLAYORDER, 99999) As MANDISPORDER");

                wrkFormat.Append("          , ifnull(CC.DISPLAYORDER, 99999) As DEPDISPORDER");

                wrkFormat.Append("          FROM CONSTRUCTIONBASEINFO CA");

                wrkFormat.Append("          LEFT JOIN PERSONINCHARGEMASTER CB");

                wrkFormat.Append("               ON CA.CONSTRUCTIONPERSONCODE = CB.PERSONCODE");

                wrkFormat.Append("          LEFT JOIN DEPARTMENTMASTER CC");

                wrkFormat.Append("               ON CA.ConstrDepCode = CC.DEPARTMENTCODE");

                wrkFormat.Append("          LEFT JOIN constructionbaseinfodetail As CD");

                wrkFormat.Append("               ON CD.ConstructionCode = CA.ConstructionCode");

                wrkFormat.AppendFormat("         And CD.DetailNo = {0}) AS C", (int)ConstructionBaseInfoDetail.DataNoDef.SalesDepartmentName);

                wrkFormat.Append(" ON A.CONSTRUCTIONCODE = C.CONSTRUCTIONCODE");

                wrkFormat.Append(" LEFT JOIN (SELECT");

            this.dgvProject014.Resizable = System.Windows.Forms.DataGridViewTriState.False;

        private System.Windows.Forms.Label lblCellTotal;

        private System.Windows.Forms.Button btnTotalDsp;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany001;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany002;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany003;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany004;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany005;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany006;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany007;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany008;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany009;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany010;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany011;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany012;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany013;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany014;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany015;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany016;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany017;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany018;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany019;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany020;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany021;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany022;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany023;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany024;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany025;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany026;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany027;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany028;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany029;

        private System.Windows.Forms.DataGridViewComboBoxColumn dgvCompany030;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany031;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany032;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany033;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany034;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany035;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany036;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany037;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany038;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany039;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany040;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany041;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany042;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany043;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany044;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany045;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany046;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany047;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany048;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany049;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany050;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany051;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany052;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany053;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany054;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany055;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany056;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany057;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany058;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany059;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany060;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany061;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany062;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany063;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany064;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany065;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany066;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany067;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany068;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany069;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany070;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany071;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany072;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany073;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany074;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany075;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany076;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany077;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany078;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany079;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany080;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany081;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany082;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany083;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany084;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany085;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany086;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany087;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany088;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany089;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany090;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany091;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany092;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany093;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany094;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany095;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany096;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany097;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany098;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany099;

        private System.Windows.Forms.DataGridViewTextBoxColumn dgvCompany100;

                sql.Append("           on Cbd.ConstructionCode = Cld.SourceCode ");

                sql.AppendFormat("    when '{0}' then  Bdd.FieldName", s_UnknownString);

                sql.Append("    else Cbd.DetailString");

                sql.Append("       on Bdd.ConstructionCode = Cbi.ConstructionCode) ");

                sql.Append("  left join ConstructionBaseinfoDetail as Cbd");

                sql.Append("       on Cbd.ConstructionCode = Cld.SourceCode ");

                sql.AppendFormat(" and Cbd.DetailNo = {0} ", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);

                sql.Append("  Left join PersonInChargeMaster as AppPName ");

                sql.Append("       on AppPName.PersonCode = AppM.ApprovalPerson ");

                sql.Append("  Left Join personapproval As PersonApp ");

                sql.Append("       On PersonApp.PersonCode = Cbi.ConstructionPersonCode ");

                sql.Append("       And PersonApp.PersonCodeApproval = AppPName.PersonCode ");

                sql.AppendFormat(" And DATE (PersonApp.OrderDate) = '{0}' ", GetTargetDate().ToShortDateString());

                sql.Append("       And  PersonApp.SeqNo > 1");

                sql.Append("  Left Join paymentapprovalinfo As PayApp");

                sql.Append("       On PayApp.COMPANYCODE = Pdd.COMPANYCODE");

                sql.Append("       And PayApp.TARGETDATE = Pdd.TARGETDATE");

                sql.Append("       And PayApp.SEQNO = Pdd.SEQNO");

                sql.Append("       And PayApp.LINECOUNT = Pdd.LINECOUNT");

                sql.Append("       And PayApp.APPROVALPERSON = AppM.ApprovalPerson");

                sql.Append("  Inner Join SubContractorMaster as Scm ");

                int nNotCode = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?? ?? ??")).Key;

                sql.AppendFormat(" And Cbi.ConstructionStatusFlg != {0} ", nNotCode);