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

        public static int s_SystemVersion = 99;

            /// 1:発注者区分登録

            /// 2:工事種別登録

            /// 3:工事経費名称登録

            this.grpExample1.Text = "施工状態変更より1カ月経過時";

                        case (int)FrmConstructionBudget.DataGroup.CommonTempCosts:

                // 変更フラグON

                m_bChengeAns = true;

                // 変更フラグON

                m_bChengeAns = true;

        private void CreateSecuritySQL(ref StringBuilder strSQL)

                    strSQL.Append(" And (A.SalesPersonCode IN (Select A1.PersonCode From PersonInChargeMaster A1");

                    strSQL.AppendFormat(" Where A1.DepartmentCode IN (SELECT A2.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A2 WHERE A2.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    strSQL.AppendFormat(" Or (A.ConstructionStatusFlg >= {0}", iStatus);

                    strSQL.Append(" And (A.ConstructionPersonCode IN (Select A3.PersonCode From PersonInChargeMaster A3");

                    strSQL.AppendFormat(" Where A3.DepartmentCode IN (SELECT A4.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A4 WHERE A4.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    strSQL.Append(" Or A.CONSTRSUBPERSONCODE IN (Select A5.PersonCode From PersonInChargeMaster A5");

                    strSQL.AppendFormat(" Where A5.DepartmentCode IN (SELECT A6.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A6 WHERE A6.PERSONCODE = {0}))", CommonMotions.LoginUserData.PersonCode);

                    strSQL.Append(" Or A.ConstructionInstructor IN (Select A7.PersonCode From PersonInChargeMaster A7");

                    strSQL.AppendFormat(" Where A7.DepartmentCode IN (SELECT A8.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A8 WHERE A8.PERSONCODE = {0}))))", CommonMotions.LoginUserData.PersonCode);

                    strSQL.AppendFormat(" Or (A.ConstructionStatusFlg >= {0} And A.ConstructionPersonCode = 0)", iStatus);          // ????????????o???H???S??????????????????\??

                    strSQL.AppendFormat(" Or (A.ConstructionStatusFlg = {0}", iStatus2);                                            // ???????p??????p???????????????

                    strSQL.AppendFormat(" And A.TransferConstruction = {0}))", CommonMotions.LoginUserData.DepartmentCode);

                    strSQL.AppendFormat(" And (A.SalesPersonCode = {0}", CommonMotions.LoginUserData.PersonCode);

                    strSQL.AppendFormat(" Or (A.ConstructionStatusFlg > {0}", iStatus);

                    strSQL.AppendFormat(" And (A.ConstructionPersonCode = {0}", CommonMotions.LoginUserData.PersonCode);

                    strSQL.AppendFormat(" Or A.CONSTRSUBPERSONCODE = {0}", CommonMotions.LoginUserData.PersonCode);

                    strSQL.AppendFormat(" Or A.ConstructionInstructor = {0})))", CommonMotions.LoginUserData.PersonCode);

        private void CreateInitSQL1(ref StringBuilder strSQL)

            StringBuilder strSub1 = new StringBuilder();

            StringBuilder strSub2 = new StringBuilder();

                StringBuilder strSecurity = new StringBuilder();

                strSub1.Append("SELECT A.CONSTRUCTIONCODE");

                strSub1.Append(", B.DETAILSTRING");

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

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

                strSub1.Append(", ''");

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

                strSub1.Append(", D.DEPARTMENTSTRING");

                strSub1.Append(", D.DISPLAYORDER");

                strSub1.Append(", C.DISPLAYORDER");

                // strSub1.Append(", E.COMPLATEFLG"); 2017/10/30 ?????o???????????????????????

                strSub1.Append(", 0");

                strSub1.Append(" FROM CONSTRUCTIONBASEINFO A");

                strSub1.Append(", CONSTRUCTIONBASEINFODETAIL B");

                strSub1.Append(", PERSONINCHARGEMASTER C");

                strSub1.Append(", DEPARTMENTMASTER D");

                // strSub1.Append(", CONSTRUCTIONLEDGER E"); 2017/10/30 ?????o???????????????????????

                strSub1.Append(" WHERE NOT EXISTS (SELECT * FROM DAILYDATACONSTRUCTION Z WHERE Z.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE AND Z.PERSONCODE = A.CONSTRUCTIONPERSONCODE)");

                strSub1.AppendFormat(" And A.TyingFlg != {0}", (int)ConstructionBaseInfo.TyingFlgDef.Tying);

                strSub1.AppendFormat(" AND ((A.CONSTRUCTIONSTATUSFLG < {0})", iCode);

                strSub1.AppendFormat(" OR (A.CONSTRUCTIONSTATUSFLG = {0}", iCode);

                strSub1.AppendFormat(" AND STR_TO_DATE('{0}','%Y/%m/%d') <= DATE(A.BILLINGDATE)))", DateTime.Now.AddDays(-7).ToShortDateString());

                    strSub1.AppendFormat(" AND (A.ConstructionPersonCode = {0} OR A.ConstructionInstructor = {0} OR A.ConstrSubPersonCode = {0})", PersonCode);

                strSub1.AppendFormat(" AND (A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE AND B.DETAILNO = {0})", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);

                strSub1.Append(" AND A.CONSTRUCTIONPERSONCODE = C.PERSONCODE");

                    strSub1.AppendFormat(" AND C.DEPARTMENTCODE = {0}", DepartmentCode);

                strSub1.AppendFormat(" AND A.CONSTRUCTIONPERIOD = {0}", numUDConstPro.Value);

                strSub1.Append(" AND C.DEPARTMENTCODE = D.DEPARTMENTCODE");

                // strSub1.Append(" AND E.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE"); 2017/10/30 ?????o???????????????????????

                strSub2.Append(" UNION (SELECT A.CONSTRUCTIONCODE, B.DETAILSTRING , D.PERSONCODE, D.PERSONNAME, MAX(DATE_FORMAT(C.DAILYDATADATE,'%Y/%m/%d'))");

                strSub2.Append(" , E.DEPARTMENTCODE, E.DEPARTMENTSTRING, E.DISPLAYORDER, D.DISPLAYORDER, F.COMPLATEFLG");

                strSub2.Append(" FROM CONSTRUCTIONBASEINFO A, CONSTRUCTIONBASEINFODETAIL B, DAILYDATACONSTRUCTION C, PERSONINCHARGEMASTER D, DEPARTMENTMASTER E, CONSTRUCTIONLEDGER F");

                strSub2.AppendFormat(" WHERE A.CONSTRUCTIONPERIOD = {0}", numUDConstPro.Value);

                    strSub2.AppendFormat(" AND (A.ConstructionPersonCode = {0} OR A.ConstructionInstructor = {0} OR A.ConstrSubPersonCode = {0})", PersonCode);

                strSub2.AppendFormat(" AND (A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE AND B.DETAILNO = {0})", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);

                strSub2.Append(" AND A.CONSTRUCTIONCODE = C.CONSTRUCTIONCODE");

                strSub2.Append(" AND C.PERSONCODE = D.PERSONCODE");

                    strSub2.AppendFormat(" AND D.DEPARTMENTCODE = {0}", DepartmentCode);

                strSub2.Append(" AND D.DEPARTMENTCODE = E.DEPARTMENTCODE");

                strSub2.Append(" AND F.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE");

                strSQL.Append(strSub1.ToString() + strSecurity.ToString() + strSub2.ToString() + strSecurity.ToString());

                strSQL.Append(" GROUP BY A.CONSTRUCTIONCODE, B.DETAILSTRING, D.PERSONCODE, D.PERSONNAME, E.DEPARTMENTCODE, E.DEPARTMENTSTRING, E.DISPLAYORDER, D.DISPLAYORDER, F.COMPLATEFLG)");

                strSQL.Append(" ORDER BY 10 ASC, 8 ASC, 9 ASC, 6 ASC, 7 ASC, 3 ASC");

        private void CreateInitSQL2(ref StringBuilder strSQL)

            StringBuilder strSub1 = new StringBuilder();

            StringBuilder strSub2 = new StringBuilder();

                StringBuilder strSecurity = new StringBuilder();

                strSub1.Append("SELECT A.CONSTRUCTIONCODE");

                strSub1.Append(", B.DETAILSTRING");

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

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

                strSub1.Append(", ''");

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

                strSub1.Append(", D.DEPARTMENTSTRING");

                strSub1.Append(", D.DISPLAYORDER");

                strSub1.Append(", C.DISPLAYORDER");

                // strSub1.Append(", E.COMPLATEFLG"); 2017/10/30 ?????o???????????????????????

                strSub1.Append(", 0");

                strSub1.Append(" FROM CONSTRUCTIONBASEINFO A");

                strSub1.Append(", CONSTRUCTIONBASEINFODETAIL B");

                strSub1.Append(", PERSONINCHARGEMASTER C");

                strSub1.Append(", DEPARTMENTMASTER D");

                // strSub1.Append(", CONSTRUCTIONLEDGER E"); 2017/10/30 ?????o???????????????????????

                strSub1.Append(" WHERE NOT EXISTS (SELECT * FROM PROCEEDINGSDATA Z WHERE Z.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)");

                strSub1.AppendFormat(" And A.TyingFlg != {0}", (int)ConstructionBaseInfo.TyingFlgDef.Tying);

                strSub1.AppendFormat(" AND ((A.CONSTRUCTIONSTATUSFLG < {0})", iCode);

                strSub1.AppendFormat(" OR (A.CONSTRUCTIONSTATUSFLG = {0}", iCode);

                strSub1.AppendFormat(" AND STR_TO_DATE('{0}','%Y/%m/%d') <= DATE(A.BILLINGDATE)))", DateTime.Now.AddDays(-7).ToShortDateString());

                    strSub1.AppendFormat(" AND (A.ConstructionPersonCode = {0} OR A.ConstructionInstructor = {0} OR A.ConstrSubPersonCode = {0})", PersonCode);

                strSub1.AppendFormat(" AND (A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE AND B.DETAILNO = {0})", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);

                strSub1.Append(" AND A.CONSTRUCTIONPERSONCODE = C.PERSONCODE");

                    strSub1.AppendFormat(" AND C.DEPARTMENTCODE = {0}", DepartmentCode);

                strSub1.AppendFormat(" AND A.CONSTRUCTIONPERIOD = {0}", numUDConstPro.Value);

                strSub1.Append(" AND C.DEPARTMENTCODE = D.DEPARTMENTCODE");

                // strSub1.Append(" AND E.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE"); 2017/10/30 ?????o???????????????????????

                strSub2.Append(" UNION (SELECT A.CONSTRUCTIONCODE, B.DETAILSTRING , D.PERSONCODE, D.PERSONNAME, MAX(DATE_FORMAT(C.PROCEEDINGSDATADATE,'%Y/%m/%d'))");

                strSub2.Append(" , E.DEPARTMENTCODE, E.DEPARTMENTSTRING, E.DISPLAYORDER, D.DISPLAYORDER, F.COMPLATEFLG");

                strSub2.Append(" FROM CONSTRUCTIONBASEINFO A, CONSTRUCTIONBASEINFODETAIL B, PROCEEDINGSDATA C, PERSONINCHARGEMASTER D, DEPARTMENTMASTER E, CONSTRUCTIONLEDGER F");

                strSub2.AppendFormat(" WHERE A.CONSTRUCTIONPERIOD = {0}", numUDConstPro.Value);

                    strSub2.AppendFormat(" AND (A.ConstructionPersonCode = {0} OR A.ConstructionInstructor = {0} OR A.ConstrSubPersonCode = {0})", PersonCode);

                strSub2.AppendFormat(" AND (A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE AND B.DETAILNO = {0})", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);

                strSub2.Append(" AND A.CONSTRUCTIONCODE = C.CONSTRUCTIONCODE");

                strSub2.Append(" AND D.PERSONCODE = A.CONSTRUCTIONPERSONCODE");

                    strSub2.AppendFormat(" AND D.DEPARTMENTCODE = {0}", DepartmentCode);

                strSub2.Append(" AND D.DEPARTMENTCODE = E.DEPARTMENTCODE");

                strSub2.Append(" AND F.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE");

                strSQL.Append(strSub1.ToString() + strSecurity.ToString() + strSub2.ToString() + strSecurity.ToString());

                strSQL.Append(" GROUP BY A.CONSTRUCTIONCODE, B.DETAILSTRING, D.PERSONCODE, D.PERSONNAME, E.DEPARTMENTCODE, E.DEPARTMENTSTRING, E.DISPLAYORDER, D.DISPLAYORDER, F.COMPLATEFLG)");

                strSQL.Append(" ORDER BY 10 ASC, 8 ASC, 9 ASC, 6 ASC, 7 ASC, 3 ASC");

        private void CreateInitSQL(ref StringBuilder strSQL)

                StringBuilder strSQL = new StringBuilder();

                if (!cbiDB.ExecuteReader(strSQL.ToString(), ref arData)) return;

        private long[] m_TotalArea;

        /// 経費率マスタレコード数

        /// </summary>

        private int m_ExpensesMasterCount = 3;

        /// <summary>

                m_TotalArea = new long[TotalColCnt];

            /// <summary>

            /// ?H???\?Z???F?O???[?v??

            /// </summary>

            GroupCount,

            /// <summary>

            /// ?H???\?Z???F?s?J?E???g

            /// </summary>

            LineCount,

            /// <summary>

            /// ?H???\?Z???F???s???z

            /// </summary>

            ExecutionAmount,

            /// <summary>

            /// ?H???\?Z???F???z??

            /// </summary>

            AmountConfigRate,

            long[] CurTotalArea = new long[TotalColCnt];

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("(SELECT C1.DISPLAYORDER");

                strSQL.Append(", A.CONSTRUCTIONCODE");

                strSQL.Append(", A.ORDERSDECISIONPRICE");

                strSQL.Append(", A.CONSTRUCTIONSTATUSFLG");

                strSQL.Append(", A.CONSTRUCTIONPERSONCODE");

                strSQL.Append(", C1.DEPARTMENTSTRING");

                strSQL.Append(", B1.PERSONNAME");

                strSQL.Append(", D1.EXPENSESRAITO");

                strSQL.Append(", D2.EXPENSESRAITO");

                strSQL.Append(", D3.EXPENSESRAITO");

                strSQL.Append(", E1.DETAILSTRING");

                strSQL.Append(", B1.DISPLAYORDER");

                strSQL.Append(", A.ORDERDATE");

                strSQL.Append(", Budget.GroupCount");

                strSQL.Append(", Budget.LineCount");

                strSQL.Append(", Budget.ExecutionAmount");

                strSQL.Append(", Budget.AmountConfigRate");

                strSQL.Append(", ExpName.DisplayOrder");

                strSQL.Append(" FROM CONSTRUCTIONBASEINFO A");

                strSQL.Append(" LEFT JOIN constructionbudgetdetail AS Budget");

                strSQL.Append(" ON Budget.ConstructionCode = A.ConstructionCode");

                strSQL.AppendFormat(" And Budget.GroupCount = {0}", (int)FrmConstructionBudget.DataGroup.Expenses);

                strSQL.Append(" LEFT JOIN divisionmaster AS ExpName");

                strSQL.AppendFormat(" ON ExpName.DivisionCode = {0}", (int)DivisionMaster.DivisionMasterCodeDefine.ConstructionExpenses);

                strSQL.Append(" And ExpName.NameCode = Budget.ComponentCode");

                strSQL.Append(", PERSONINCHARGEMASTER B1");

                strSQL.Append(", DEPARTMENTMASTER C1");

                strSQL.AppendFormat(" LEFT JOIN DEPARTMENTEXPENSESMASTER D1 ON D1.DEPARTMENTCODE = C1.DEPARTMENTCODE AND D1.EXPENSESPERIOD = {0} AND D1.NameCode = 3", SelectPeriod);

                strSQL.AppendFormat(" LEFT JOIN DEPARTMENTEXPENSESMASTER D2 ON D2.DEPARTMENTCODE = C1.DEPARTMENTCODE AND D2.EXPENSESPERIOD = {0} AND D2.NameCode = 2", SelectPeriod);

                strSQL.AppendFormat(" LEFT JOIN DEPARTMENTEXPENSESMASTER D3 ON D3.DEPARTMENTCODE = C1.DEPARTMENTCODE AND D3.EXPENSESPERIOD = {0} AND D3.NameCode = 1", SelectPeriod);

                strSQL.Append(", CONSTRUCTIONBASEINFODETAIL E1");

                strSQL.Append(" WHERE NOT EXISTS (SELECT * FROM CONSTRUCTIONLEDGER A1 WHERE A1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)");

                strSQL.AppendFormat(" AND A.CONSTRUCTIONPERIOD = {0}", SelectPeriod);

                strSQL.AppendFormat(" AND A.TYINGFLG != {0}", (int)ConstructionBaseInfo.TyingFlgDef.Tying);

                strSQL.AppendFormat(" AND A.JOINFLG != {0}", (int)ConstructionBaseInfo.JoinFlgDef.JoinChildren);

                strSQL.AppendFormat(" And ({0} <= A.ConstructionStatusFlg And A.ConstructionStatusFlg <= {1})", iCode1, iCode2);

                strSQL.Append(" AND B1.PERSONCODE = A.CONSTRUCTIONPERSONCODE");

                strSQL.Append(" AND C1.DEPARTMENTCODE = B1.DEPARTMENTCODE");

                strSQL.Append(" AND E1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE");

                strSQL.AppendFormat(" AND E1.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);

                if (DepartmantCode > 0) strSQL.AppendFormat(" AND C1.DEPARTMENTCODE = {0}", DepartmantCode);

                if (PersonCode > 0) strSQL.AppendFormat(" AND B1.PERSONCODE = {0}", PersonCode);

                strSQL.Append(")");

                strSQL.Append(" ORDER BY 1, 12, 2, 18");

                if (!BaseDB.ExecuteReader(strSQL.ToString(), ref DatArList)) return;

                string workDepName = string.Empty;

                int ConstrCode = 0;

                int ConstrStatus = 0;

                long OrdersDecisionPrice = 0;

                long[] ExpensesVal = new long[3];

                string [] strValue = new string[2];

                DateTime dtOrderDate = DateTime.Now;

                for (int nDataCount = 0; nDataCount < DatArList.Count; nDataCount++)

                    object[] objGetArry = (object[])DatArList[nDataCount];

                    // ?H???????

                    ConstrCode = CommonMotions.cnvInt(objGetArry[(int)DetilData.ConstructionCode]);

                    Array.Clear(ExpensesVal, 0, ExpensesVal.Length);

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

                    int DataCnt = DatArList.Cast<object[]>().Where(x => CommonMotions.cnvInt(x[(int)DetilData.ConstructionCode]) == ConstrCode).Count();

                    if (DataCnt == 1)

                    {

                        SetNotCreatedOneceRow(objGetArry

                                                , ref ConstrStatus

                                                , ref OrdersDecisionPrice

                                                , ref ExpensesVal

                                                , ref workDepName

                                                , ref strValue

                                                , ref dtOrderDate);

                    }

                    else

                    {

                        SetNotCreatedMultiRow(DatArList

                                                , ConstrCode

                                                , ref ConstrStatus

                                                , ref OrdersDecisionPrice

                                                , ref ExpensesVal

                                                , ref workDepName

                                                , ref strValue

                                                , ref dtOrderDate

                                                , ref nDataCount);

                    }

                    else

                    {

                        workDepName = string.Empty;

                    }

                                    , workDepName                                   // ??????

                                    , strValue[0]                                   // ?S?????

                                    , ConstrCode                                    // ?H?????

                                    , strValue[1]                                   // ?H??????

                                    , dtOrderDate.ToShortDateString()               // ???

                                    , CommonDefine.ProjectsStatus[ConstrStatus]     // ?{?H???

                                    , OrdersDecisionPrice.ToString("#,0")           // ????z

                                    , ExpensesVal[0].ToString("#,0")                // ???o??

                                    , ExpensesVal[1].ToString("#,0")                // ?????o??

                                    , ExpensesVal[2].ToString("#,0")                // ?c??o??

                    CurTotalArea[(int)GridColumn.OrdersPrice] += OrdersDecisionPrice;                                   // ????z

                    CurTotalArea[(int)GridColumn.CompanyExpeses] += ExpensesVal[0];                                     // ???o??

                    CurTotalArea[(int)GridColumn.DepartmentExpeses] += ExpensesVal[1];                                  // ?????o??

                    CurTotalArea[(int)GridColumn.SaleseExpeses] += ExpensesVal[2];                                      // ?c??o??

        #region ???????P?s????

        /// <summary>

        /// ???????P?s????

        /// </summary>

        private void SetNotCreatedOneceRow(object[] objGetArry

                                            , ref int ConstrStatus

                                            , ref long OrdersDecisionPrice

                                            , ref long[] ExpensesVal

                                            , ref string DepName

                                            , ref string[] strValue

                                            , ref DateTime dtOrderDate)

        {

            try

            {

                ConstrStatus = CommonMotions.cnvInt(objGetArry[(int)DetilData.ConstructionStatusFlg]);                  // ?{?H???t???O

                OrdersDecisionPrice = CommonMotions.cnvLong(objGetArry[(int)DetilData.OrdersDecisionPrice]);            // ????z

                double ExpensesRaito1 = CommonMotions.cnvDouble(objGetArry[(int)DetilData.ExpensesRaito1]) / 100.0;     // ???o??

                double ExpensesRaito2 = CommonMotions.cnvDouble(objGetArry[(int)DetilData.ExpensesRaito2]) / 100.0;     // ?????o??

                double ExpensesRaito3 = CommonMotions.cnvDouble(objGetArry[(int)DetilData.ExpensesRaito3]) / 100.0;     // ?c??o??

                ExpensesVal[0] = CommonMotions.cnvRound(OrdersDecisionPrice * ExpensesRaito1);

                ExpensesVal[1] = CommonMotions.cnvRound(OrdersDecisionPrice * ExpensesRaito2);

                ExpensesVal[2] = CommonMotions.cnvRound(OrdersDecisionPrice * ExpensesRaito3);

                DepName = CommonMotions.cnvString(objGetArry[(int)DetilData.DepartmentString]);                         // ????????

                strValue[0] = CommonMotions.cnvString(objGetArry[(int)DetilData.PersonName]);                           // ?S?????

                strValue[1] = CommonMotions.cnvString(objGetArry[(int)DetilData.ConstrName]);                           // ?H??????

                dtOrderDate = CommonMotions.cnvDate(objGetArry[(int)DetilData.OrderDate]);                              // ???

            }

            catch (System.Exception ex)

            {

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

            }

        }

        #endregion

        #region ???????????s????

        /// <summary>

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

        /// </summary>

        private void SetNotCreatedMultiRow(ArrayList DatArList

                                            , int ConstrCode

                                            , ref int ConstrStatus

                                            , ref long OrdersDecisionPrice

                                            , ref long[] ExpensesVal

                                            , ref string DepName

                                            , ref string[] strValue

                                            , ref DateTime dtOrderDate

                                            , ref int nDataCount)

        {

            try

            {

                object[] TargetData = DatArList.Cast<object[]>().Where(x => CommonMotions.cnvInt(x[(int)DetilData.ConstructionCode]) == ConstrCode).ToArray();

                object[] FirstRec = (object[])TargetData[0];

                ConstrStatus = CommonMotions.cnvInt(FirstRec[(int)DetilData.ConstructionStatusFlg]);                    // ?{?H???t???O

                OrdersDecisionPrice = CommonMotions.cnvLong(FirstRec[(int)DetilData.OrdersDecisionPrice]);              // ????z

                DepName = CommonMotions.cnvString(FirstRec[(int)DetilData.DepartmentString]);                           // ????????

                strValue[0] = CommonMotions.cnvString(FirstRec[(int)DetilData.PersonName]);                             // ?S?????

                strValue[1] = CommonMotions.cnvString(FirstRec[(int)DetilData.ConstrName]);                             // ?H??????

                dtOrderDate = CommonMotions.cnvDate(FirstRec[(int)DetilData.OrderDate]);                                // ???

                for (int i = 0; i < TargetData.Length; i++)

                {

                    if (i < m_ExpensesMasterCount)

                    {

                        object[] objRec = (object[])TargetData[i];

                        switch (i)

                        {

                            case 0:

                                ExpensesVal[0] = CommonMotions.cnvLong(objRec[(int)DetilData.ExecutionAmount]);

                                break;

                            case 1:

                                ExpensesVal[2] = CommonMotions.cnvLong(objRec[(int)DetilData.ExecutionAmount]);

                                break;

                            case 2:

                                ExpensesVal[1] = CommonMotions.cnvLong(objRec[(int)DetilData.ExecutionAmount]);

                                break;

                        }

                        if (i != 0) nDataCount++;

                    }

                }

            }

            catch (System.Exception ex)

            {

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

            }

        }

        #endregion

                long[] CurTotalArea = new long[TotalColCnt];

        private void DisplayTotalRow(int TitleNo, long[] TotalArea, bool AddBrankRow = true)

        private void InsertZeroTotalRow(int TitleNo, long[] TotalArea)

[assembly: AssemblyVersion("1.0.0.99")]

[assembly: AssemblyFileVersion("1.0.0.99")]