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

        #region ?O???b?h?\??

        /// <summary>

        /// ?O???b?h?\??

        /// </summary>

        /// <returns></returns>

        private bool DispGridData()

        {

            IOBillingData IoBd = new IOBillingData();

            ArrayList arData = new ArrayList();

            int DataGoukeiCd_Column = 0;

            int iShoninColumn = 0;

            StringBuilder sql;

            List<ShoninData> lstDefaultShonin = new List<ShoninData>();

            List<PaymentApprovalInfo> PaIList = new List<PaymentApprovalInfo>();

            PaymentApprovalInfo PaInfo = null;

            IOConstructionBaseInfo IoCbi = new IOConstructionBaseInfo();

            IOMPersonInCharge IoMpic = new IOMPersonInCharge();

            ConstructionBaseInfo Cbi = new ConstructionBaseInfo();

            PersonInChargeMaster Picm = new PersonInChargeMaster();

            string KojiTanto = "", KojiTantoCode = "";

            int ConstrDepartmentCode = 0;

            // ?N??????m?F // TODO

            if (ClsExcute.ProcControlPara.Count > 0)

            {

                for (int i = 0; i < ClsExcute.ProcControlPara.Count; i++)

                {

                    if ((ClsExcute.ProcControlPara[i].ArrayParameter != null) && (ClsExcute.ProcControlPara[i].ArrayParameter.Count > 0))

                    {

                        ArrayList obj = ClsExcute.ProcControlPara[i].ArrayParameter[0];

                        PaInfo = (PaymentApprovalInfo)obj[0];

                        if (PaInfo is PaymentApprovalInfo != true)

                        {

                            PaInfo = null;

                        }

                    }

                }

            }

            try

            {

                DataGridView dgv = getShowingView();

                // ???v?l?s?Z?o??P??

                if (m_viewTarget == 0)

                {

                    DataGoukeiCd_Column = (int)ClickGetData.COMPANYCODE;

                }

                else

                {

                    DataGoukeiCd_Column = (int)ClickGetData.CONSTRUCTIONCODE;

                }

                // ?????s??????

                DataGridView_ReadOnlyChange(dgv);

                // ?I?????????

                m_Select_TargetDate = CommonMotions.cnvInt(cmbTargetMonth.SelectedValue);

                // ??U?Z????l??X?C?x???g????????

                dgv.CellValueChanged -= DataGridView_CellValueChanged;

                // ?O???b?h??s??0????

                dgv.Rows.Clear();

                // SQL??

                sql = new StringBuilder();

                if (PaInfo != null)

                {

                    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("  , 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("  , 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.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.CnstrPrice, 0) as CnstrPrice ");

                    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(Pdd.ApprovalDate, '2001/01/01') ");

                    sql.Append("    , '%Y/%m/%d' ");

                    sql.Append("  ) as ApprovalDate ");

                    sql.Append("  , ifnull(Pdd.ApprovalEndFlg, 0) as ApprovalEndFlg ");

                    sql.Append("  , ifnull(Cbi.SalesPersonCode, 0) as SalesPersonCode ");

                    sql.Append("  , ifnull(Cbi.ConstructionPersonCode, 0) as ConstructionPersonCode ");

                    sql.Append("  , ifnull(Cbi.ConstrSubPersonCode, 0) as ConstrSubPersonCode ");

                    sql.Append("  , ifnull(Cbi.ConstructionInstructor, 0) as ConstructionInstructor ");

                    sql.Append("  , Picm2.DepartmentCode ");

                    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(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("      when 0 then '' ");

                    sql.Append("      else '?~' ");

                    sql.Append("      end ");

                    sql.Append("    else '??' ");

                    sql.Append("    end as PaData ");

                    sql.Append("  , null as LinePoint ");

                    sql.Append("  , null as ColPoint ");

                    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("      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("      ) ");

                    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("                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("      ) ");

                    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} ", PaInfo.TargetDate);

                    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("  , DisplayOrder ");

                    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("  , 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("  , ApprovalPersonCode ");

                    sql.Append("  , TantoNM ");

                    sql.Append("  , ApprovalDate ");

                    sql.Append("  , ApprovalEndFlg ");

                    sql.Append("  , SalesPersonCode ");

                    sql.Append("  , ConstructionPersonCode ");

                    sql.Append("  , ConstrSubPersonCode ");

                    sql.Append("  , ConstructionInstructor ");

                    sql.Append("  , DepartmentCode ");

                    sql.Append("  , PurchaseOrderMailingDate ");

                    sql.Append("  , PurchaseOrderReturnDate ");

                    sql.Append("  , PaData ");

                    sql.Append("  , LinePoint ");

                    sql.Append("  , ColPoint ");

                }

                else 

                {

                    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("  , 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("  , 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.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.CnstrPrice, 0) as CnstrPrice ");

                    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(Pdd.ApprovalDate, '2001/01/01') ");

                    sql.Append("    , '%Y/%m/%d' ");

                    sql.Append("  ) as ApprovalDate ");

                    sql.Append("  , ifnull(Pdd.ApprovalEndFlg, 0) as ApprovalEndFlg ");

                    sql.Append("  , ifnull(Cbi.SalesPersonCode, 0) as SalesPersonCode ");

                    sql.Append("  , ifnull(Cbi.ConstructionPersonCode, 0) as ConstructionPersonCode ");

                    sql.Append("  , ifnull(Cbi.ConstrSubPersonCode, 0) as ConstrSubPersonCode ");

                    sql.Append("  , ifnull(Cbi.ConstructionInstructor, 0) as ConstructionInstructor ");

                    sql.Append("  , Picm2.DepartmentCode ");

                    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(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 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("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.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 ( ");

                    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("      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("      ) ");

                    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("        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("  ) ");

                    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(" ");

                    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("  , 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("  , 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.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.CnstrPrice, 0) as CnstrPrice ");

                    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(Pdd.ApprovalDate, '2001/01/01') ");

                    sql.Append("    , '%Y/%m/%d' ");

                    sql.Append("  ) as ApprovalDate ");

                    sql.Append("  , ifnull(Pdd.ApprovalEndFlg, 0) as ApprovalEndFlg ");

                    sql.Append("  , ifnull(Cbi.SalesPersonCode, 0) as SalesPersonCode ");

                    sql.Append("  , ifnull(Cbi.ConstructionPersonCode, 0) as ConstructionPersonCode ");

                    sql.Append("  , ifnull(Cbi.ConstrSubPersonCode, 0) as ConstrSubPersonCode ");

                    sql.Append("  , ifnull(Cbi.ConstructionInstructor, 0) as ConstructionInstructor ");

                    sql.Append("  , Picm2.DepartmentCode ");

                    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(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("      when 0 then '' ");

                    sql.Append("      else '?~' ");

                    sql.Append("      end ");

                    sql.Append("    else '??' ");

                    sql.Append("    end as PaData ");

                    sql.Append("  , null as LinePoint ");

                    sql.Append("  , null as ColPoint ");

                    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("      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("      ) ");

                    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("                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("      ) ");

                    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("    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("  , DisplayOrder ");

                    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("  , 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("  , ApprovalPersonCode ");

                    sql.Append("  , TantoNM ");

                    sql.Append("  , ApprovalDate ");

                    sql.Append("  , ApprovalEndFlg ");

                    sql.Append("  , SalesPersonCode ");

                    sql.Append("  , ConstructionPersonCode ");

                    sql.Append("  , ConstrSubPersonCode ");

                    sql.Append("  , ConstructionInstructor ");

                    sql.Append("  , DepartmentCode ");

                    sql.Append("  , PurchaseOrderMailingDate ");

                    sql.Append("  , PurchaseOrderReturnDate ");

                    sql.Append("  , PaData ");

                    sql.Append("  , LinePoint ");

                    sql.Append("  , ColPoint ");

                }

                if (dgvCompany.Visible == true)         // ???P??\??

                {

                    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 ");

                }

                // ?f?[?^???@???v?E???v???v?Z?????A?S???f?[?^????????

                if (!IoBd.ExecuteReader(sql.ToString(), ref arData)) return false;

                // ?f?[?^?\??

                int icnt = 0;

                int iNo = 1;

                int iGoukeiSeq = 0;

                int iGoukeiCd = -1;

                int iDataCount = 0;

                int iShoninMaxCount = 0;

                foreach (object[] work in arData)

                {

                    // ???v?s??

                    if (iGoukeiCd != CommonMotions.cnvInt(work[DataGoukeiCd_Column]))

                    {

                        if (iGoukeiCd != -1)

                        {

                            // ????\??????????f?[?^?????`?F?b?N

                            iDataCount = dgv.Rows.Cast<DataGridViewRow>().Where(x => CommonMotions.cnvInt(x.Cells[(int)DispColumn.RowType].Value) == 0

                                                                                  && CommonMotions.cnvInt(x.Cells[(int)DispColumn.RowVisible].Value) == 1

                                                                                  && CommonMotions.cnvInt(x.Cells[m_GoukeiCode_Column].Value) == iGoukeiCd)

                                                                         .Count();

                            if (iDataCount > 0)

                            {

                                // ???v?s???

                                MakeGoukeiGyo(dgv, iGoukeiCd);

                                icnt += System.Enum.GetValues(typeof(GoukeiRows)).Length;

                                // ???v?l???

                                setGoukei_DataDisp(dgv, iGoukeiCd);

                            }

                            iNo++;

                        }

                        iGoukeiSeq = 1;

                        iGoukeiCd = CommonMotions.cnvInt(work[DataGoukeiCd_Column]);

                    }

                    dgv.Rows.Add();

                    dgv.Rows[icnt].Cells[(int)DispColumn.CompanyDispOrder].Value = CommonMotions.cnvInt(work[(int)ClickGetData.DisplayOrder]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.ApprovalEndFlg].Value = CommonMotions.cnvInt(work[(int)ClickGetData.ApprovalEndFlg]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.UpdateDate].Value = CommonMotions.cnvString(work[(int)ClickGetData.UpdateDate]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.RowState].Value = DataRowState.Modified;

                    dgv.Rows[icnt].Cells[(int)DispColumn.RowType].Value = 0;

                    dgv.Rows[icnt].Cells[(int)DispColumn.GoukeiSeqNo].Value = iGoukeiSeq;

                    dgv.Rows[icnt].Cells[(int)DispColumn.GroupSeqNo].Value = CommonMotions.cnvInt(work[(int)ClickGetData.SEQNO]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.LineCount].Value = CommonMotions.cnvInt(work[(int)ClickGetData.LINECOUNT]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.No].Value = iNo;

                    dgv.Rows[icnt].Cells[m_Company_Column].Value = CommonMotions.cnvInt(work[(int)ClickGetData.COMPANYCODE]);

                    dgv.Rows[icnt].Cells[m_CompanyNM_Column].Value = CommonMotions.cnvString(work[(int)ClickGetData.COMPANYNAME]);

                    dgv.Rows[icnt].Cells[m_CompanyNM_Column].ToolTipText = CommonMotions.cnvString(work[(int)ClickGetData.COMPANYNAME]);

                    dgv.Rows[icnt].Cells[m_Genba_Column].Value = CommonMotions.cnvInt(work[(int)ClickGetData.CONSTRUCTIONCODE]);

                    dgv.Rows[icnt].Cells[m_GenbaNM_Column].Value = CommonMotions.cnvString(work[(int)ClickGetData.FIELDNAME]);

                    dgv.Rows[icnt].Cells[m_GenbaNM_Column].ToolTipText = CommonMotions.cnvString(work[(int)ClickGetData.FIELDNAME]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.SomuSeikyu].Value = CommonMotions.cnvInt(work[(int)ClickGetData.BILLPRICE]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.SomuKosoku].Value = CommonMotions.cnvInt(work[(int)ClickGetData.HIGHWPRICE]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.SomuKanamono].Value = CommonMotions.cnvInt(work[(int)ClickGetData.HARDWPRICE]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.SomuSannhaiZei].Value = CommonMotions.cnvInt(work[(int)ClickGetData.INDSWASTETAX]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.KojiSeikyu].Value = CommonMotions.cnvInt(work[(int)ClickGetData.KojiSeikyu]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.KojiNebiki].Value = CommonMotions.cnvInt(work[(int)ClickGetData.KojiNebiki]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.KojiSousai].Value = CommonMotions.cnvInt(work[(int)ClickGetData.KojiSousai]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.JikaiKurikosi].Value = CommonMotions.cnvInt(work[(int)ClickGetData.JikaiKurikosi]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.KojiKosoku].Value = CommonMotions.cnvInt(work[(int)ClickGetData.KojiKosoku]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.KojiKanamono].Value = CommonMotions.cnvInt(work[(int)ClickGetData.KojiKanamono]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.KojiSannhaiZei].Value = CommonMotions.cnvInt(work[(int)ClickGetData.KojiSannhaiZei]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.KyoryokuKin].Value = CommonMotions.cnvInt(work[(int)ClickGetData.CnstrPrice]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.KyoryokuUmu].Value = CommonMotions.cnvInt(work[(int)ClickGetData.CNSTRPRICEEXIST]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.CyuumonshoTeisyutu].Value = CommonMotions.cnvString(work[(int)ClickGetData.PurchaseOrderMailingDate]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.CyuumonshoTouchaku].Value = CommonMotions.cnvString(work[(int)ClickGetData.PurchaseOrderReturnDate]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.YosanSho].Value = CommonMotions.cnvString(work[(int)ClickGetData.PaData]);

                    // ?S??????F

                    bool ApprovalPerson = CommonMotions.cnvInt(work[(int)ClickGetData.ApprovalPersonCode]) != 0 ? true : false;

                    bool SekininApproval = false;

                    if (ApprovalPerson == true)

                    {

                        dgv.Rows[icnt].Cells[(int)DispColumn.TantoShoninCode].Value = CommonMotions.cnvInt(work[(int)ClickGetData.ApprovalPersonCode]);

                        dgv.Rows[icnt].Cells[(int)DispColumn.TantoShonin].Value = CommonMotions.cnvString(work[(int)ClickGetData.TantoNM]);

                        dgv.Rows[icnt].Cells[(int)DispColumn.TantoDate].Value = CommonMotions.cnvString(work[(int)ClickGetData.ApprovalDate]);

                        // ?S?????F??f?[?^

                        iShoninColumn = (int)DispColumn.Shonin1Code;

                        if (!GetShonin(CommonMotions.cnvInt(work[(int)ClickGetData.COMPANYCODE]), CommonMotions.cnvInt(work[(int)ClickGetData.SEQNO]), CommonMotions.cnvInt(work[(int)ClickGetData.LINECOUNT]), ref PaIList)) return false;

                        iShoninMaxCount = iShoninMaxCount < PaIList.Count ? PaIList.Count : iShoninMaxCount;

                        foreach (PaymentApprovalInfo pair in PaIList)

                        {

                            dgv.Rows[icnt].Cells[iShoninColumn++].Value = pair.ApprovalPerson;

                            if (pair.ApprovalDate == new DateTime(2001, 01, 01))

                            {

                                dgv.Rows[icnt].Cells[iShoninColumn].Style.ForeColor = Color.Gray;

                            }

                            else

                            {

                                // ???F??????F????????A????????

                                if (SekininApproval == false && (m_UserInfo.m_Type == CommonDefine.SecurityRankPos.LimitedAuthority || m_UserInfo.m_Type == CommonDefine.SecurityRankPos.FreeAuthority))

                                {

                                    if (CommonMotions.LoginUserData.PersonCode == pair.ApprovalPerson)

                                    {

                                        SekininApproval = true;

                                    }

                                }

                            }

                            dgv.Rows[icnt].Cells[iShoninColumn++].Value = pair.ApprovalPersonName;

                            dgv.Rows[icnt].Cells[iShoninColumn++].Value = pair.ApprovalDate;

                            dgv.Rows[icnt].Cells[iShoninColumn++].Value = pair.ApprovalAuthority;

                            dgv.Rows[icnt].Cells[iShoninColumn++].Value = pair.ApprovalNo;

                        }

                    }

                    else

                    {

                        //???????????????????F

                        if (CommonMotions.cnvInt(dgv.Rows[icnt].Cells[m_Genba_Column].Value) != 0)

                        {

                            // ?I???????H????H???S??????????????????

                            string sWhere = IoCbi.CreatePrimarykeyString(CommonMotions.cnvInt(dgv.Rows[icnt].Cells[m_Genba_Column].Value));

                            if (!IoCbi.SelectAction(sWhere, ref Cbi)) throw new Exception("?H????{?????G???[");

                            sWhere = IoMpic.CreatePrimarykeyString(Cbi.ConstructionPersonCode);

                            if (!IoMpic.SelectAction(sWhere, ref Picm)) throw new Exception("?S????}?X?^???G???[");

                            ConstrDepartmentCode = Picm.DepartmentCode;

                            //?H???S????

                            KojiTantoCode = Picm.PersonCode.ToString();

                            KojiTanto = Picm.SealPrintName;

                            //?S??????F???

                            dgv.Rows[icnt].Cells[(int)DispColumn.TantoShoninCode].Value = KojiTantoCode;

                            dgv.Rows[icnt].Cells[(int)DispColumn.TantoShonin].Value = KojiTanto;

                            dgv.Rows[icnt].Cells[(int)DispColumn.TantoShonin].Style.ForeColor = Color.Gray;

                            // ?S????????F?f?[?^

                            int iDefaultDataCount = 0;

                                if (!SetDefaultShonin(dgv, icnt, ConstrDepartmentCode, ref iDefaultDataCount)) return false;

                            iShoninMaxCount = iShoninMaxCount < iDefaultDataCount ? iDefaultDataCount : iShoninMaxCount;

                        }

                        else

                        {

                            dgv.Rows[icnt].Cells[(int)DispColumn.TantoShoninCode].Value = "";

                            dgv.Rows[icnt].Cells[(int)DispColumn.TantoShonin].Value = ""; 

                            dgv.Rows[icnt].Cells[(int)DispColumn.TantoShonin].Style.ForeColor = Color.Gray;

                        }

                    }

                    // ???l???

                    dgv.Rows[icnt].Cells[(int)DispColumn.Bikou].Value = CommonMotions.cnvString(work[(int)ClickGetData.Bikou]);

                    // ?H????????s????A????????

                    dgv.Rows[icnt].Cells[(int)DispColumn.ConstructionLedgerLineNo].Value = CommonMotions.cnvString(work[(int)ClickGetData.ConstructionLedgerLineNo]);

                    dgv.Rows[icnt].Cells[(int)DispColumn.ConstructionLedgerRowNo].Value = CommonMotions.cnvString(work[(int)ClickGetData.ConstructionLedgerRowNo]);

                    // ??????????\????\??

                    // ?????l????

                    dgv.Rows[icnt].Visible = true;

                    dgv.Rows[icnt].Cells[(int)DispColumn.RowVisible].Value = 1;

                    // ?s????O

                    if (CommonMotions.cnvInt(work[(int)ClickGetData.CONSTRUCTIONCODE]) != 0)

                    {

                        // ?s????O???U?s????????

                        dgv.Rows[icnt].Visible = false;

                        dgv.Rows[icnt].Cells[(int)DispColumn.RowVisible].Value = 0;

                        // ?????S??

                        if (m_UserInfo.m_GeneralAffairsFlg == 1)

                        {

                            // ?????????W????S??????Q?????\????A??W??\???????????????????????B

                            dgv.Rows[icnt].Visible = true;

                            dgv.Rows[icnt].Cells[(int)DispColumn.RowVisible].Value = 1;

                        }

                        // ??????????

                        else if (m_UserInfo.m_Type == CommonDefine.SecurityRankPos.SpecialAuthority)

                        {

                            // ?????????W????S??????Q?????\????A??????????????O???W??\?????B

                            dgv.Rows[icnt].Visible = true;

                            dgv.Rows[icnt].Cells[(int)DispColumn.RowVisible].Value = 1;

                        }

                        // ???????A????????

                        else if (m_UserInfo.m_Type == CommonDefine.SecurityRankPos.LimitedAuthority || m_UserInfo.m_Type == CommonDefine.SecurityRankPos.FreeAuthority)

                        {

                            // ?Q????????????`?F?b?N

                            foreach (PersonDepartmentMaster RefDepRec in CommonMotions.LoginUserDepartment)

                            {

                                // ??????????????????????H?????\??????

                                if (RefDepRec.DepartmentCode != CommonMotions.cnvInt(work[(int)ClickGetData.DepartmentCode]))

                                {

                                    dgv.Rows[icnt].Visible = true;

                                    dgv.Rows[icnt].Cells[(int)DispColumn.RowVisible].Value = 1;

                                }

                            }

                        }

                        // ?S??????

                        else if (m_UserInfo.m_Type == CommonDefine.SecurityRankPos.NormalAuthority)

                        {

                            if (m_UserInfo.m_SecRange == ClsSecurityPermission.SecRangeType.InCharge)

                            {

                                // ?c??S??

                                if (CommonMotions.LoginUserData.PersonCode == CommonMotions.cnvInt(work[(int)ClickGetData.SalesPersonCode]))

                                {

                                    dgv.Rows[icnt].Visible = true;

                                    dgv.Rows[icnt].Cells[(int)DispColumn.RowVisible].Value = 1;

                                }

                                // ?H???S??

                                if (CommonMotions.LoginUserData.PersonCode == CommonMotions.cnvInt(work[(int)ClickGetData.ConstructionPersonCode])

                                    || CommonMotions.LoginUserData.PersonCode == CommonMotions.cnvInt(work[(int)ClickGetData.ConstrSubPersonCode])

                                    || CommonMotions.LoginUserData.PersonCode == CommonMotions.cnvInt(work[(int)ClickGetData.ConstructionInstructor]))

                                {

                                    dgv.Rows[icnt].Visible = true;

                                    dgv.Rows[icnt].Cells[(int)DispColumn.RowVisible].Value = 1;

                                }

                            }

                            else if (m_UserInfo.m_SecRange == ClsSecurityPermission.SecRangeType.OneDepartment)

                            {

                                // ?Q????????????`?F?b?N

                                foreach (PersonDepartmentMaster RefDepRec in CommonMotions.LoginUserDepartment)

                                {

                                    // ??????????????????????H?????\??????

                                    if (RefDepRec.DepartmentCode != CommonMotions.cnvInt(work[(int)ClickGetData.DepartmentCode]))

                                    {

                                        dgv.Rows[icnt].Visible = true;

                                        dgv.Rows[icnt].Cells[(int)DispColumn.RowVisible].Value = 1;

                                    }

                                }

                            }

                        }

                    }

                    if (CommonMotions.cnvInt(work[(int)ClickGetData.ApprovalEndFlg]) == 1)

                    {

                        // ??I???F?????????F???????????A?S?????W?s??

                        dgv.Rows[icnt].ReadOnly = true;

                    }

                    else if ((ApprovalPerson == true && m_UserInfo.m_Type == CommonDefine.SecurityRankPos.NormalAuthority)

                          || (SekininApproval == true && m_UserInfo.m_Type == CommonDefine.SecurityRankPos.LimitedAuthority)

                          || (SekininApproval == true && m_UserInfo.m_Type == CommonDefine.SecurityRankPos.FreeAuthority))

                    {

                        // ?H???S??????S??????F?????s?????????A?????@??C??????g????F?????s??????????A?H???S?????????W?s??

                        dgv.Rows[icnt].Cells[(int)DispColumn.KojiSeikyu].ReadOnly = true;

                        dgv.Rows[icnt].Cells[(int)DispColumn.KojiNebiki].ReadOnly = true;

                        dgv.Rows[icnt].Cells[(int)DispColumn.KojiSousai].ReadOnly = true;

                        dgv.Rows[icnt].Cells[(int)DispColumn.KojiKosoku].ReadOnly = true;

                        dgv.Rows[icnt].Cells[(int)DispColumn.KojiKanamono].ReadOnly = true;

                        dgv.Rows[icnt].Cells[(int)DispColumn.KojiSannhaiZei].ReadOnly = true;

                        dgv.Rows[icnt].Cells[(int)DispColumn.KyoryokuUmu].ReadOnly = true;

                    }

                    icnt++;

                    iGoukeiSeq++;

                }

                // ????\??????????f?[?^?????`?F?b?N

                iDataCount = dgv.Rows.Cast<DataGridViewRow>().Where(x => CommonMotions.cnvInt(x.Cells[(int)DispColumn.RowType].Value) == 0

                                                                        && CommonMotions.cnvInt(x.Cells[(int)DispColumn.RowVisible].Value) == 1

                                                                        && CommonMotions.cnvInt(x.Cells[m_GoukeiCode_Column].Value) == iGoukeiCd)

                                                                .Count();

                if (iDataCount > 0)

                {

                    // ???v?s???

                    MakeGoukeiGyo(dgv, iGoukeiCd);

                    // ???v?l???

                    setGoukei_DataDisp(dgv, iGoukeiCd);

                }

                ResetNo();

                // ????F????~????F????\??

                //??U???????????A?s??????X

                int i;

                for (i = (int)DispColumn.Shonin1; i < (int)DispColumn.Bikou; i+=5)

                {

                    dgv.Columns[i].Visible = true;

                }

                for (i = (int)DispColumn.Shonin1 + (iShoninMaxCount * 5); i < (int)DispColumn.Bikou; i++)

                {

                    dgv.Columns[i].Visible = false;

                }

                // ?C?x???g?n???h????o?^

                dgv.CellValueChanged += DataGridView_CellValueChanged;

                // ?{?^??????

                controlButton();

                controlButton_DataCount();

                // ?\?????f?[?^????

                m_Select_DataCount = arData.Count;

                m_bChengeAns = false;

                return true;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);

                return false;

            }

            finally

            {

                IoBd = null;

                IoCbi = null;

                IoMpic = null;

            }

        }

        #endregion

                if (cmbTargetMonth.SelectedValue == null || cmbTargetMonth.SelectedValue.ToString().Length!=6) return;