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

        public static int s_SystemVersion = 178;

                frm.DivisionCode = (int)DivisionMaster.DivisionMasterCodeDef.OrderDivision;

                frm.DivisionCode = (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses;

        public enum DivisionMasterCodeDef

                strSQL.AppendFormat(" LEFT JOIN DIVISIONMASTER E1 ON E1.DIVISIONCODE = {0} AND E1.NAMECODE = E.NAMECODE", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);

                strSQL.AppendFormat(" LEFT JOIN DIVISIONMASTER F1 ON F1.DIVISIONCODE = {0} AND F1.NAMECODE = F.NAMECODE", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);

                strSQL.AppendFormat(" LEFT JOIN DIVISIONMASTER G1 ON G1.DIVISIONCODE = {0} AND G1.NAMECODE = G.NAMECODE", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);

                strSQL.AppendFormat(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);

                string strSQL = dvDB.CreatePrimarykeyString((int)DivisionMaster.DivisionMasterCodeDef.OrderDivision) + " And DeleteFlg = 0 ORDER BY DISPLAYORDER";

                    //// ?f?[?^????????????????i?R?????g?N???A????????S??X?V???j

                    //if (CommonMotions.chkObjectIsNull(wrkTextBox.Text)) continue;

                    //if (wrkTextBox.Text.Length == 0) continue;

                strSQL += string.Format(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);

                        if (nExecPrice == 0 || nHopePrice < nExecPrice)

                                        , (int)DivisionMaster.DivisionMasterCodeDef.OrderDivision

                strSQL += string.Format(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);

            this.label9.Text = "当期予測給与";

                    // 明細データ削除処理

                    if (!RecordCopyDeleteDetail(iToCode, (int)ConstructionBaseInfoDetail.DataNoDef.Note2, DB2))

                    {

                        DB1.rollback();

                        DB2.rollback();

                        DB3.rollback();

                        DB4.rollback();

                        DB5.rollback();

                        return false;

                    }

                    cbRec.TyingFlg = (int)ConstructionBaseInfo.TyingFlgDef.Standard;                // 紐付データフラグ

                    cbRec.InspectPlanningDate = DateTime.MinValue;                                  // 検査予定日 

                    cbRec.InspectExecuteDate = DateTime.MinValue;                                   // 検査実行日 

                    cbRec.RevCompleteDate = DateTime.MinValue;                                      // 検査是正完了日 

        #region 明細データ削除処理

        /// <summary>

        /// 明細データ削除処理

        /// </summary>

        /// <returns></returns>

        public bool RecordCopyDeleteDetail(int ConstrCode, int DelOverCode, IOConstructionBaseInfoDetail DB2)

        {

            try

            {

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(DB2.CreatePrimarykeyString(ConstrCode));

                strSQL.AppendFormat(" And DetailNo > {0}", DelOverCode);

                if (!DB2.DeleteAction(strSQL.ToString(), false))

                {

                    MessageBox.Show("工事基本情報明細、作成後削除に失敗しました。", "コピー処理エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                return true;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(2), ex.Message);

                return false;

            }

        }

        #endregion

                int DivisionCode = (int)DivisionMaster.DivisionMasterCodeDef.OrderDivision;

            this.label6.Text = "当期予測給与";

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle11 = new System.Windows.Forms.DataGridViewCellStyle();

            this.lblCellTotal = new System.Windows.Forms.Label();

            this.dgvMain = new ProcessManagement.Forms.CustomControls.DataGridViewEX();

            ((System.ComponentModel.ISupportInitialize)(this.dgvMain)).BeginInit();

            // lblCellTotal

            // 

            this.lblCellTotal.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));

            this.lblCellTotal.AutoSize = true;

            this.lblCellTotal.BackColor = System.Drawing.Color.Black;

            this.lblCellTotal.Font = new System.Drawing.Font("ＭＳ 明朝", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.lblCellTotal.ForeColor = System.Drawing.Color.White;

            this.lblCellTotal.Location = new System.Drawing.Point(200, 559);

            this.lblCellTotal.Name = "lblCellTotal";

            this.lblCellTotal.Size = new System.Drawing.Size(0, 13);

            this.lblCellTotal.TabIndex = 53;

            // 

            // dgvMain

            // 

            this.dgvMain.AllowUserToAddRows = false;

            this.dgvMain.AllowUserToDeleteRows = false;

            this.dgvMain.AllowUserToResizeColumns = false;

            this.dgvMain.AllowUserToResizeRows = false;

            dataGridViewCellStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));

            this.dgvMain.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;

            this.dgvMain.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 

            | System.Windows.Forms.AnchorStyles.Left) 

            | System.Windows.Forms.AnchorStyles.Right)));

            this.dgvMain.BackgroundColor = System.Drawing.Color.White;

            this.dgvMain.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Control;

            dataGridViewCellStyle2.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold);

            dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.WindowText;

            dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight;

            dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText;

            dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True;

            this.dgvMain.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2;

            this.dgvMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing;

            this.dgvMain.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {

            this.Column1,

            this.Column2,

            this.Column3,

            this.Column4,

            this.Column5,

            this.Column6,

            this.Column7,

            this.Column8});

            dataGridViewCellStyle11.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;

            dataGridViewCellStyle11.BackColor = System.Drawing.SystemColors.Window;

            dataGridViewCellStyle11.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold);

            dataGridViewCellStyle11.ForeColor = System.Drawing.SystemColors.ControlText;

            dataGridViewCellStyle11.SelectionBackColor = System.Drawing.Color.LightSeaGreen;

            dataGridViewCellStyle11.SelectionForeColor = System.Drawing.SystemColors.HighlightText;

            dataGridViewCellStyle11.WrapMode = System.Windows.Forms.DataGridViewTriState.False;

            this.dgvMain.DefaultCellStyle = dataGridViewCellStyle11;

            this.dgvMain.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;

            this.dgvMain.EnableHeadersVisualStyles = false;

            this.dgvMain.Location = new System.Drawing.Point(7, 50);

            this.dgvMain.Name = "dgvMain";

            this.dgvMain.RowHeadersVisible = false;

            this.dgvMain.RowHeadersWidth = 20;

            this.dgvMain.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing;

            this.dgvMain.RowTemplate.Height = 21;

            this.dgvMain.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.CellSelect;

            this.dgvMain.Size = new System.Drawing.Size(1120, 496);

            this.dgvMain.TabIndex = 52;

            this.dgvMain.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvMain_CellDoubleClick);

            this.dgvMain.SelectionChanged += new System.EventHandler(this.dgvMain_SelectionChanged);

            this.dgvMain.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dgvMain_MouseUp);

            // 

            this.Column2.HeaderText = "工事部署";

            this.Column2.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.Column3.HeaderText = "工事担当";

            ((System.ComponentModel.ISupportInitialize)(this.dgvMain)).EndInit();

            ConstrStatus,

        #region 合計行固定コード

        /// <summary>

        /// 合計行固定コード

        /// </summary>

        private const int s_TotalCode = 999999999;

        #endregion

                Color wrkBackColor = Color.White;

                Color wrkForeColor = Color.Black;

                // 奇数行は色を変える

                if ((CurrentRow % 2) > 0)

                {

                    wrkBackColor = dgv.AlternatingRowsDefaultCellStyle.BackColor;

                    wrkForeColor = dgv.AlternatingRowsDefaultCellStyle.ForeColor;

                }

                if (CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.ConstrCode].Value) == s_TotalCode)

                {

                    wrkBackColor = s_RowTotalBackColor;

                    wrkForeColor = s_RowTotalForeColor;

                }

                    CurRow.Cells[i].Style.BackColor = wrkBackColor;

                    CurRow.Cells[i].Style.ForeColor = wrkForeColor;

                // ?????H????????X?g

                List<int> nConstrCodeList = new List<int>();

                List<KeyValuePair<int, string>> ExpList = new List<KeyValuePair<int, string>>();

                // ???v?G???A

                long[] TotalArea = null;

                SetNotCreateRowData(ref nConstrCodeList, ref ExpList, ref TotalArea);

                SetCreateRowData(ExpList, ref TotalArea);

                DisplayTotalRow((int)RowTitleNum.AllTotal, TotalArea);

        private enum GetDataEnum

            /// 0:?????\????

            DepDisp = 0,

            /// 1:?????R?[?h

            DepCode,

            /// 2:??????

            DepName,

            /// 3:?H?????

            ConstrCode,

            /// 4:?H??????

            ConstrName,

            /// 5:?S????\????

            ManDisp,

            /// 6:?H???S??????

            ManCode,

            /// 7:?S?????

            ManName,

            /// 8:???

            OrderDate,

            /// 9:????z

            OrValue,

            /// 10:?{?H???t???O

            Stat,

            /// 11:?o??\????

            ExpDisp,

            /// 12:?o??R?[?h

            ExpCode,

            /// 13:?o????

            ExpName,

            /// 14:?o??

            ExpRaito,

            /// 15:?o????z

            ExpVal,

        private void SetNotCreateRowData(ref List<int> nConstrCodeList, ref List<KeyValuePair<int, string>> ExpList, ref long[] TotalArea)

            long[] CurTotalArea = null;

                #region ???r?p?k

                strSQL.Append("SELECT");

                strSQL.Append(" C1.DISPLAYORDER AS DepDisp");

                strSQL.Append(", C1.DepartmentCode AS DepCode");

                strSQL.Append(", A1.DetailString As DepName");

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

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

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

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

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

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

                strSQL.Append(", ifNull(Bud.OrdersDecisionPrice, A.ORDERSDECISIONPRICE) As OrValue");

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

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

                strSQL.Append(", Budget.ComponentCode As ExpCode");

                strSQL.Append(", ExpName.NameString As ExpName");

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

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

                strSQL.Append(" FROM");

                strSQL.Append(" CONSTRUCTIONBASEINFO A");

                strSQL.Append(" INNER JOIN CONSTRUCTIONBASEINFODETAIL E1");

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

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

                strSQL.Append(" LEFT JOIN CONSTRUCTIONBASEINFODETAIL A1");

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

                strSQL.Append(" LEFT JOIN CONSTRUCTIONBUDGET AS Bud");

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

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

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

                strSQL.Append(" LEFT JOIN DEPARTMENTMASTER C1");

                strSQL.Append("       On C1.DEPARTMENTCODE = A.ConstrDepCode");

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

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

                strSQL.Append(" LEFT JOIN DEPARTMENTEXPENSESMASTER D1");

                strSQL.Append("       ON D1.DEPARTMENTCODE = C1.DEPARTMENTCODE");

                strSQL.AppendFormat(" AND D1.EXPENSESPERIOD = {0}", SelectPeriod);

                strSQL.Append("       AND D1.NameCode = ExpName.NameCode");

                strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER B1");

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

                strSQL.Append(" WHERE");

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

                strSQL.Append(" And");

                strSQL.Append(TargetStatusSQL("A."));

                strSQL.Append(" And NOT EXISTS(");

                strSQL.Append("         SELECT * FROM processapproval As Approval");

                strSQL.Append("         WHERE");

                strSQL.Append("            Approval.ConstructionCode = A.CONSTRUCTIONCODE");

                strSQL.AppendFormat("      And Approval.ApprovalCode = {0}", (int)ClsExcute.ApprovalListNo.ConstructionBudgetApproval);

                strSQL.Append("            And Approval.SeqNo = 1");

                strSQL.AppendFormat("      And Approval.ApprovalStatus = {0})", (int)CommonDefine.ApprovalStatus.Approval);

                strSQL.Append(" ORDER BY DepDisp, ManDisp, ConstrCode, ExpDisp");

                #endregion

                ArrayList DataArList = new ArrayList();

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

                if (DataArList.Count == 0) return;

                // ?????????X?g??

                GetProcList(DataArList, ref nConstrCodeList, ref ExpList);

                DataGridView dgv = dgvMain;

                dgv.Rows.Clear();

                // ?O???b?h??o??????????

                CreateExpensesColumn(ExpList);

                // ???????v?G???A??????

                int TotalColCnt = ExpList.Count + 1;

                CurTotalArea = new long[TotalColCnt];

                // ?????v?G???A??????

                TotalArea = new long[TotalColCnt];

                long[] ExpensesVal = new long[TotalColCnt];

                object[] DspData = new object[dgv.ColumnCount];

                object[] FirstWork = (object[])DataArList[0];

                string strBreakDep = CommonMotions.cnvString(FirstWork[(int)GetDataEnum.DepName]);

                foreach(int CurData in nConstrCodeList)

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

                    CreateRowData(DataArList, CurData, ExpList, ref DspData, ref ExpensesVal);

                    // ??????????1?s?J????

                    string strDepName = CommonMotions.cnvString(DspData[(int)GridColumn.DepartmentName]);

                    if (strBreakDep != strDepName) dgv.Rows.Add(1);

                    strBreakDep = strDepName;

                    int RowIndex = dgv.Rows.Add(1);

                    DataGridViewRow dgvRow = dgv.Rows[RowIndex];

                    foreach(DataGridViewCell CurCell in dgvRow.Cells)

                        switch (CurCell.ColumnIndex)

                        {

                            case 0:

                                CurCell.Value = (ino++);

                                break;

                            case 1:                 // ??????

                            case 2:                 // ?S?????

                            case 3:                 // ?H?????

                            case 4:                 // ?H??????                 

                            case 5:                 // ???

                            case 6:                 // ?{?H???

                                CurCell.Value = DspData[CurCell.ColumnIndex];

                                break;

                            default:                // ????z->?o??S??

                                CurCell.Value = CommonMotions.cnvLong(DspData[CurCell.ColumnIndex]).ToString("#,0");

                                break;

                        }

                    // ???????v???Z

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

                        CurTotalArea[i] += ExpensesVal[(i)];

                // ???v???Z

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

                {

                    TotalArea[i] += CurTotalArea[i];

                }

        #region ?????\???p?f?[?^??SQL??

        /// ?????\???p?f?[?^??SQL??

        private string TargetStatusSQL(string strArias = "")

            StringBuilder strSQL = new StringBuilder();

                List<int> stat = new List<int>();

                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?? ?? ??")).Key);           // 3

                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("??@?@??")).Key);           // 4

                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("???????p")).Key);           // 5

                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?{?H????")).Key);           // 6

                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?{?H?J?n")).Key);           // 7

                strSQL.AppendFormat(" {0}ConstructionStatusFlg IN (", strArias);

                bool bFirst = true;

                foreach (int CurData in stat)

                {

                    if (!bFirst) strSQL.Append(", ");

                    strSQL.AppendFormat("{0}", CurData);

                    bFirst = false;

                }

                strSQL.Append(")");

                return strSQL.ToString();

            }

            catch (Exception ex)

            {

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

                return string.Empty;

            }

        }

        #endregion

        #region ?????????X?g??

        /// <summary>

        /// ?????????X?g??

        /// </summary>

        private void GetProcList(ArrayList DatArList

                                , ref List<int> nConstrCodeList

                                , ref List<KeyValuePair<int, string>> ExpList)

        {

            try

            {

                int BKey1 = 0;

                foreach (object[] objRec in DatArList)

                {

                    // ???H???????X?g??????

                    int nCode = CommonMotions.cnvInt(objRec[(int)GetDataEnum.ConstrCode]);

                    if (BKey1 != nCode)

                    {

                        nConstrCodeList.Add(nCode);

                        BKey1 = nCode;

                    }

                    // ?o????????X?g??????

                    int nExpCode = CommonMotions.cnvInt(objRec[(int)GetDataEnum.ExpCode]);

                    if (nExpCode < 1) continue;

                    if (!ExpList.Exists(x => x.Key == nExpCode))

                    {

                        string strName = CommonMotions.cnvString(objRec[(int)GetDataEnum.ExpName]);

                        ExpList.Add(new KeyValuePair<int, string>(nExpCode, strName));

                    }

                }

            catch (Exception ex)

        /// ?x???????G???A

        private bool bCreateColumn = false;

        private DataGridViewColumn[] m_GridExpColList = null;

        private DataGridViewCellStyle[] m_GridExpCellStyleList = null;

        #region ?O???b?h??o??????????

        /// <summary>

        /// ?O???b?h??o??????????

        /// </summary>

        private void CreateExpensesColumn(List<KeyValuePair<int, string>> ExpList)

                if (bCreateColumn) return;

                DataGridView dgv = dgvMain;

                int nAddColCnt = ExpList.Count;

                m_GridExpColList = new DataGridViewColumn[nAddColCnt];

                m_GridExpCellStyleList=new DataGridViewCellStyle[nAddColCnt];

                for (int i = 0; i < nAddColCnt; i++)

                    // ?X?^?C????

                    m_GridExpCellStyleList[i] = new DataGridViewCellStyle();

                    m_GridExpCellStyleList[i].Alignment = DataGridViewContentAlignment.MiddleRight;

                    m_GridExpCellStyleList[i].Font = new System.Drawing.Font("Century", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

                    // ?Z????

                    m_GridExpColList[i] = new DataGridViewColumn();

                    m_GridExpColList[i].CellTemplate = new DataGridViewTextBoxCell();

                    dgv.Columns.Add(m_GridExpColList[i]);

                    // ?J????????

                    m_GridExpColList[i].CellTemplate = new DataGridViewTextBoxCell();

                    m_GridExpColList[i].DefaultCellStyle = m_GridExpCellStyleList[i];

                    m_GridExpColList[i].HeaderText = ExpList[i].Value;

                    m_GridExpColList[i].Name = string.Format("ColExpenses{0}", (i + 1));

                    m_GridExpColList[i].ReadOnly = true;

                    m_GridExpColList[i].Resizable = DataGridViewTriState.False;

                    m_GridExpColList[i].SortMode = DataGridViewColumnSortMode.NotSortable;

                    m_GridExpColList[i].Width = 100;

                }

                bCreateColumn = true;

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region ?s?f?[?^??

        /// <summary>

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

        /// </summary>

        private void CreateRowData(ArrayList DataArList

                                    , int CurData

                                    , List<KeyValuePair<int, string>> ExpList

                                    , ref object[] DspData

                                    , ref long[] ExpensesVal)

        {

            try

            {

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

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

                int GridColCnt = Enum.GetNames(typeof(GridColumn)).Length;

                bool bCompSw = false;

                foreach (object[] ObjRec in DataArList)

                {

                    // ?Y???H????O??????????

                    int nCode = CommonMotions.cnvInt(ObjRec[(int)GetDataEnum.ConstrCode]);

                    if (nCode != CurData)

                        if (bCompSw) break;

                        continue;

                    // ?f?[?^???Z?b?g????

                    DspData[(int)GridColumn.DepartmentName] = ObjRec[(int)GetDataEnum.DepName];         // 1:??????

                    DspData[(int)GridColumn.PersonName] = ObjRec[(int)GetDataEnum.ManName];             // 2:?S?????

                    DspData[(int)GridColumn.ConstrCode] = ObjRec[(int)GetDataEnum.ConstrCode];          // 3:?H?????

                    DspData[(int)GridColumn.ConstrName] = ObjRec[(int)GetDataEnum.ConstrName];          // 4:?H??????                 

                    DspData[(int)GridColumn.OrderDate] = 

                        CommonMotions.cnvDate(ObjRec[(int)GetDataEnum.OrderDate]).ToShortDateString();  // 5:???

                    int nStat = CommonMotions.cnvInt(ObjRec[(int)GetDataEnum.Stat]);                    // 6:?{?H???

                    DspData[(int)GridColumn.ConstrStatus] = CommonDefine.ProjectsStatus[nStat];

                    DspData[(int)GridColumn.OrdersPrice] = ObjRec[(int)GetDataEnum.OrValue];            // 7:????z

                    ExpensesVal[0] = CommonMotions.cnvInt(ObjRec[(int)GetDataEnum.OrValue]);

                    int nExpIndex = ExpArraryIndex(ObjRec, ExpList);

                    DspData[GridColCnt + nExpIndex] = ObjRec[(int)GetDataEnum.ExpVal];                  // 8??~:?o??S??

                    ExpensesVal[nExpIndex + 1] = CommonMotions.cnvInt(ObjRec[(int)GetDataEnum.ExpVal]);

                    bCompSw = true;

        #region ?o???\????u????????

        /// <summary>

        /// ?o???\????u????????

        /// </summary>

        /// <param name="ObjRec"></param>

        /// <param name="ExpList"></param>

        /// <returns></returns>

        private int ExpArraryIndex(object[] ObjRec, List<KeyValuePair<int, string>> ExpList)

        {

            try

            {

                int nIndex = 0;

                // ?o??R?[?h??

                int nExpNo = CommonMotions.cnvInt(ObjRec[(int)GetDataEnum.ExpCode]);

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

                {

                    if (ExpList[i].Key == nExpNo)

                    {

                        nIndex = i;

                        break;

                    }

                }

                return nIndex;

            }

            catch (System.Exception ex)

            {

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

                return 0;

            }

        }

        #endregion

        private void SetCreateRowData(List<KeyValuePair<int, string>> ExpList, ref long[] TotalArea)

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("SELECT");

                strSQL.Append(" A.COMPLATEFLG");

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

                strSQL.Append(", SUM(A.COMPANYEXPENSES)");

                strSQL.Append(", SUM(A.DEPARTMENTEXPENSES)");

                strSQL.Append(", SUM(A.SALESEXPENSES)");

                strSQL.Append(" FROM");

                strSQL.Append(" CONSTRUCTIONLEDGER A");

                strSQL.Append(", CONSTRUCTIONBASEINFO B");

                strSQL.Append(", PERSONINCHARGEMASTER C");

                strSQL.Append(" WHERE A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE"); ;

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

                strSQL.AppendFormat(" AND B.CONSTRUCTIONSTATUSFLG != {0}", iCode1);

                strSQL.Append(" AND C.PERSONCODE = B.CONSTRUCTIONPERSONCODE");

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

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

                strSQL.Append(" GROUP BY A.COMPLATEFLG");

                strSQL.Append(" ORDER BY 1");

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

                int TotalColCnt = ExpList.Count + 1;

                    CurTotalArea[0] += OrdersDecisionPrice;   // ????z

                    CurTotalArea[1] += ExpensesPrice1;     // ???o??

                    CurTotalArea[2] += ExpensesPrice2;  // ?????o??

                    CurTotalArea[3] += ExpensesPrice3;      // ?c??o??

                    // ???v???Z

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

                    {

                        TotalArea[i] += CurTotalArea[i];

                    }

                dgv.Rows[TotalRow].Cells[(int)GridColumn.ConstrCode].Value = s_TotalCode;

                int GridColCnt = dgv.ColumnCount;

                int nDataCnt = 0;

                for (int i = (int)GridColumn.OrdersPrice; i < GridColCnt; i++, nDataCnt++)

                    dgv.Rows[TotalRow].Cells[i].Value = TotalArea[nDataCnt].ToString("#,0");

                int GridColCnt = dgv.ColumnCount;