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

        public static int s_SystemVersion = 1;

                ArrayList ToData = new ArrayList();

                // 最終承認のチェック

                bool bLastApp = false;

                foreach(object[] CurObj in ToData)

                {

                    int wrkCode = CommonMotions.cnvInt(CurObj[0]);

                    int wrkLast = CommonMotions.cnvInt(CurObj[2]);

                    if(wrkCode== CommonMotions.LoginUserData.PersonCode

                        && wrkLast == (int)ApprovalMaster.ApprovalAuthorityDef.LastApproval)

                    {

                        bLastApp = true;

                        break;

                    }

                }

                string ApprovalName = ClsExcute.AppovalList[ApprovalCode];

                strMsg.AppendFormat("『{0}』 【{1}】", ConstrName, ApprovalName);

                if (StatusFlg == (int)CommonDefine.ApprovalStatus.Petition)

                {

                    strMsg.AppendFormat("　『{0}』を申請します。\r\n", ApprovalName);

                    strMsg.Append("　承認申請関係者、内容を確認の上承認をお願いします。");

                }

                else

                {

                    string strAppStat = CommonDefine.ApprovalStatusString[StatusFlg];

                    strMsg.AppendFormat("　『{0}』の申請を{1}します。\r\n", ApprovalName, strAppStat.Replace("　", ""));

                    if (StatusFlg == (int)CommonDefine.ApprovalStatus.Approval)

                    {

                        if (bLastApp)

                        {

                            strMsg.Append("　最終承認が下りました、");

                        }

                        else

                        {

                            strMsg.Append("　申請途上の承認ですが、");

                        }

                    }

                    strMsg.Append("連絡・指示コメント欄を確認・対応の上、行動してください。\r\n");

                    strMsg.Append("　よろしくお願いします。");

                }

                foreach (object[] CurDat in ToData)

                    // ログイン者は対象にしない。

                    if (CommonMotions.cnvInt(CurDat[0]) == CommonMotions.LoginUserData.PersonCode) continue;

                    wrkTer.ToCode = CommonMotions.cnvInt(CurDat[0]);

                    wrkTer.ToName = CommonMotions.cnvString(CurDat[1]);

        private static bool SetReceiverList(object[] MsgObj, ref ArrayList ToData)

                strSQL.Append("SELECT");

                strSQL.Append(" A.ApprovalPerson");

                strSQL.Append(", B.PersonName");

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

                strSQL.Append(" FROM ApprovalMaster As A");

                    //if (ApprovalPerson == CommonMotions.LoginUserData.PersonCode) continue;

                    int LastApproval= CommonMotions.cnvInt(CurObj[2]);

                    ToData.Add(new object[] { ApprovalPerson, ApprovalName, LastApproval });

                // 申請時は申請データが無いので次へ行く

                if (arrayL.Count < 1) return true;

                foreach (object[] Tardat in ToData)

                    if (CommonMotions.cnvInt(Tardat[0]) == PetitionCode)

                    ToData.Insert(0, new object[] { PetitionCode, PetitionName, 0 });

                        strcmd.AppendFormat(" SourceCode = {0}", value.ToString());

                        strcmd.AppendFormat(" SourceDetailCnt = {0}", value.ToString());

        public void ChangeTabPageVisible()

                PetitionRequestEstimate(ref Rec);

        private void PetitionRequestEstimate(ref ProcessApproval Rec)

                        { false, false, false, false, false, false, false, false, false, true,  false, false, false, false, false, false, false, false},    // 40:?????R?????g

                        { false, false, false, false, false, false, false, false, false, true,  false, false, false, false, false, false, false, false},    // 42:?????????????R?????g

                        { false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false},    // 54:?????m?F??

                        { false, false, false, false, false, false, false, false, false, true,  false, false, false, false, false, false, false, false},    // 86:??????????????

                if (m_DspCtrl[(int)DspCnt.RevCompleteDate].Text.Length < 1

                if (m_DspCtrl[(int)DspCnt.BillingComplateDate].Text.Length < 1

        #region データ行を指定行に作成

        /// <summary>

        /// データ行を指定行に作成する

        /// </summary>

        /// <param name="SetData"></param>

        private void InsertDataRow(int RowPoint, object[] SetData, bool ReadOnlyFlg = false)

        {

            try

            {

                DataGridViewEX dgv = dgvAllDisplay;

                // 行追加

                dgv.Rows.Insert(RowPoint, 1);

                // カレント行取得

                DataGridViewRow CurRow = dgv.Rows[RowPoint];

                // 行データセット

                CurRow.SetValues(SetData);

                // フラグセット

                CurRow.Cells[(int)GridColumn.TitleFlg].Value = "0";

                CurRow.Cells[(int)GridColumn.TotalFlg].Value = "0";

                CurRow.Cells[(int)GridColumn.BlankFlg].Value = "0";

                // 表示した行を書込み禁止にする

                CurRow.ReadOnly = ReadOnlyFlg;

                // 書込み禁止の場合はセル毎のロック制御はしない

                if (ReadOnlyFlg) return;

                // 明細部の編集制御

                int GroupNo = CommonMotions.cnvInt(SetData[(int)GridColumn.GroupCount]);

                // 行のロック

                RowLocking(CurRow, GroupNo);

                // 金額入力の制御

                CurRow.Cells[(int)GridColumn.HopePrice].ReadOnly = false;

                CurRow.Cells[(int)GridColumn.ExecPrice].ReadOnly = false;

                //bool bReadOnly = false;

                //int User = CommonDefine.SecurityRankList[(int)CommonDefine.SecurityRankPos.NormalAuthority].Key;            // 一般ユーザー

                //if (CommonMotions.LoginUserSecurity.SecRank == User) bReadOnly = true;

                //// 工事担当者は希望金額のみ入力が可能

                //CurRow.Cells[(int)GridColumn.ExecPrice].ReadOnly = bReadOnly;

            }

            catch (System.Exception ex)

            {

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

            }

        }

        #endregion

        #region 管理費用の表示セット

        /// <summary>

        /// 管理費用の表示セット

        /// </summary>

        private void SetManagementValue()

        {

            try

            {

                int nPlusRow = 0;

                // 一般管理費の表示

                nPlusRow = SetNormalManagement();

                // 挿入行分行カウントをずらす

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

                {

                    m_CostsRowCount[i] += nPlusRow;

                }

                // 現場管理費の表示

                nPlusRow = SetFieldManagement();

                // 挿入行分行カウントをずらす

                for (int i = (int)CostsRowLine.InstructorRowLine; i <= (int)CostsRowLine.AllTotalRowLine; i++)

                {

                    m_CostsRowCount[i] += nPlusRow;

                }

                // 純利益計算

                CreateNetIncome(false);

                // 合計金額

                CreateAllTotal(false);

            }

            catch (System.Exception ex)

            {

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

            }

        }

        #endregion

        #region 管理費の内部コード

        /// <summary>

        /// 管理費の内部コード

        /// </summary>

        private enum ManagementCostCode

        {

            /// <summary>

            /// 一般管理費

            /// </summary>

            Normal = -1,

            /// <summary>

            /// 現場管理費

            /// </summary>

            Field = -2,

        }

        #endregion

        #region 一般管理費の表示

        /// <summary>

        /// 一般管理費の表示

        /// </summary>

        private int SetNormalManagement()

        {

            IOEstimateDataDetail eddDB = new IOEstimateDataDetail();

            try

            {

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("Select");

                strSQL.Append(" A.ConstructionCode");

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

                strSQL.Append(", ifnull(SUM(B.NegotiationPrice), SUM(A.PriceValue))");

                strSQL.Append(" From estimatedata As A");

                strSQL.Append(" Left Join (Select");

                strSQL.Append("                 BB.ConstructionCode");

                strSQL.Append("               , BB.ComponentCode");

                strSQL.Append("               , BB.NegotiationPrice");

                strSQL.Append("           From estimatebudgetdetail As BB");

                strSQL.AppendFormat("     Where BB.ConstructionCode = {0}", m_ConstructionCode);

                strSQL.AppendFormat("     And BB.ComponentCode in ({0}, {1})"

                                                                          , m_CommonCosts.NormalManagementPublic

                                                                          , m_CommonCosts.NormalManagementPrivate);

                strSQL.Append("           And BB.NegotiationPrice <> 0) As B");

                strSQL.Append("       On B.ConstructionCode = A.ConstructionCode");

                strSQL.Append("       And B.ComponentCode = A.ComponentCode");

                strSQL.Append(" Where");

                strSQL.AppendFormat(" A.ConstructionCode = {0}", m_ConstructionCode);

                strSQL.AppendFormat(" And A.ComponentCode in ({0}, {1})"

                                                                          , m_CommonCosts.NormalManagementPublic

                                                                          , m_CommonCosts.NormalManagementPrivate);

                strSQL.Append(" Group By A.ComponentCode");

                ArrayList arrayList = new ArrayList();

                if (!eddDB.ExecuteReader(strSQL.ToString(), ref arrayList)) return 0;

                if (arrayList.Count < 1) return 0;

                object[] objRec = (object[])arrayList[0];

                long wrkdata = CommonMotions.cnvLong(objRec[2]);

                object[] RowData = new object[Enum.GetNames(typeof(GridColumn)).Length];

                // データセット

                RowData[(int)GridColumn.GroupCount] = -1;

                // パーセント計算

                double OrdersPrice = CommonMotions.cnvDouble(m_DspLabelCtrl[(int)DspLblCtrlName.OrdersPrice].Text.Replace("\\", ""));

                double dExpenses = ((wrkdata / OrdersPrice) * 100.0);

                string strVallue = "一　般　管　理　費";

                RowData[(int)GridColumn.FixFlg] = "*";

                RowData[(int)GridColumn.ComponentCode] = (int)ManagementCostCode.Normal;

                RowData[(int)GridColumn.ItemName] = strVallue;

                RowData[(int)GridColumn.EstimatePrice] = wrkdata.ToString("#,#");

                RowData[(int)GridColumn.NegotiationPrice] = wrkdata.ToString("#,#");

                RowData[(int)GridColumn.Percent] = dExpenses.ToString("0.00");

                // 行表示

                InsertDataRow(1, RowData, true);

                return 1;

            }

            catch (System.Exception ex)

            {

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

                return 0;

            }

            finally

            {

                eddDB.close();eddDB = null;

            }

        }

        #endregion

        #region 現場管理費の表示

        /// <summary>

        /// 現場管理費の表示

        /// </summary>

        private int SetFieldManagement()

        {

            IOEstimateDataDetail eddDB = new IOEstimateDataDetail();

            try

            {

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("Select");

                strSQL.Append(" A.ConstructionCode");

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

                strSQL.Append(", ifnull(SUM(B.NegotiationPrice), SUM(A.PriceValue))");

                strSQL.Append(" From estimatedata As A");

                strSQL.Append(" Left Join (Select");

                strSQL.Append("                 BB.ConstructionCode");

                strSQL.Append("               , BB.ComponentCode");

                strSQL.Append("               , BB.NegotiationPrice");

                strSQL.Append("           From estimatebudgetdetail As BB");

                strSQL.AppendFormat("     Where BB.ConstructionCode = {0}", m_ConstructionCode);

                strSQL.AppendFormat("     And BB.ComponentCode in ({0}, {1})"

                                                                            , m_CommonCosts.FieldManagementPublic

                                                                            , m_CommonCosts.FieldManagementPrivate);

                strSQL.Append("           And BB.NegotiationPrice <> 0) As B");

                strSQL.Append("       On B.ConstructionCode = A.ConstructionCode");

                strSQL.Append("       And B.ComponentCode = A.ComponentCode");

                strSQL.Append(" Where");

                strSQL.AppendFormat(" A.ConstructionCode = {0}", m_ConstructionCode);

                strSQL.AppendFormat(" And A.ComponentCode in ({0}, {1})"

                                                                            , m_CommonCosts.FieldManagementPublic

                                                                            , m_CommonCosts.FieldManagementPrivate);

                strSQL.Append(" Group By A.ComponentCode");

                ArrayList arrayList = new ArrayList();

                if (!eddDB.ExecuteReader(strSQL.ToString(), ref arrayList)) return 0;

                if (arrayList.Count < 1) return 0;

                object[] objRec = (object[])arrayList[0];

                long wrkdata = CommonMotions.cnvLong(objRec[2]);

                object[] RowData = new object[Enum.GetNames(typeof(GridColumn)).Length];

                // データセット

                RowData[(int)GridColumn.GroupCount] = -1;

                // パーセント計算

                double OrdersPrice = CommonMotions.cnvDouble(m_DspLabelCtrl[(int)DspLblCtrlName.OrdersPrice].Text.Replace("\\", ""));

                double dExpenses = ((wrkdata / OrdersPrice) * 100.0);

                string strVallue = "現　場　管　理　費";

                RowData[(int)GridColumn.FixFlg] = "*";

                RowData[(int)GridColumn.ComponentCode] = (int)ManagementCostCode.Field;

                RowData[(int)GridColumn.ItemName] = strVallue;

                RowData[(int)GridColumn.EstimatePrice] = wrkdata.ToString("#,#");

                RowData[(int)GridColumn.NegotiationPrice] = wrkdata.ToString("#,#");

                RowData[(int)GridColumn.Percent] = dExpenses.ToString("0.00");

                // 指導員の上に挿入

                int nRowPoint = m_CostsRowCount[(int)CostsRowLine.InstructorRowLine];

                if (nRowPoint < 1) return 0;

                // 行表示

                InsertDataRow(nRowPoint, RowData, true);

                return 1;

            }

            catch (System.Exception ex)

            {

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

                return 0;

            }

            finally

            {

                eddDB.close(); eddDB = null;

            }

        }

        #endregion

                if (!InitDispData())

                {

                    // データが無い場合は前プロセスデータから表示

                    NotBudgetData();

                }

                // 管理費用の表示セット

                SetManagementValue();

                    // 現場管理費の加算

                    int nInstractorRow = m_CostsRowCount[(int)CostsRowLine.InstructorRowLine];

                    for (int i = nInstractorRow; i > 0; i--)

                    {

                        DataGridViewRow CurRow = dgv.Rows[i];

                        int GroupCode = CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.GroupCount].Value);

                        int CompCode = CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.ComponentCode].Value);

                        if (GroupCode == -1 && CompCode == (int)ManagementCostCode.Field)

                        {

                            EstimatePriceValue += CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.EstimatePrice].Value);

                            NegotiationPriceValue += CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.NegotiationPrice].Value);

                            break;

                        }

                    }

            // データセット

            int RowCnt = m_CostsRowCount[(int)CostsRowLine.AllTotalRowLine];

            if (RowCnt == 0) return;

            dgv.Rows[RowCnt].Cells[(int)GridColumn.EstimatePrice].Value = EstimatePriceValue.ToString("#,0");

            dgv.Rows[RowCnt].Cells[(int)GridColumn.NegotiationPrice].Value = NegotiationPriceValue.ToString("#,0");

            dgv.Rows[RowCnt].Cells[(int)GridColumn.HopePrice].Value = HopePriceValue.ToString("#,0");

            dgv.Rows[RowCnt].Cells[(int)GridColumn.ExecPrice].Value = ExecPriceValue.ToString("#,0");

            dgv.Rows[RowCnt].Cells[(int)GridColumn.Percent].Value = CalculattionPercent((double)ExecPriceValue).ToString("0.00");

                // 空行セット

                AddEmptyRow();

                    // 行位置取得(空行を1行挿入するためここでは最終行をセット)

                    m_CostsRowCount[(int)CostsRowLine.InstructorRowLine] = dgv.RowCount;

                // 割合がセットされていなければ処理しない

                    // 表示行は処理しない

                    int nGroupCode = CommonMotions.cnvInt(wrkRow.Cells[(int)GridColumn.GroupCount].Value);

                    if (nGroupCode < (int)DataGroup.Expenses) continue;

                    work.GroupCount = nGroupCode;

                    // 表示行は処理しない

                    int nGroupCode = CommonMotions.cnvInt(wrkRow.Cells[(int)GridColumn.GroupCount].Value);

                    if (nGroupCode < (int)DataGroup.Expenses) continue;

                    if (nGroupCode == (int)FrmConstructionBudget.DataGroup.CommonTempCosts ||

                        nGroupCode == (int)FrmConstructionBudget.DataGroup.OutSourceCosts ||

                        nGroupCode == (int)FrmConstructionBudget.DataGroup.MyConstruction)

        /// <summary>

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

        /// </summary>

        private List<int> m_SourceCodeList = new List<int>();

            if (e.KeyCode != Keys.Delete && e.KeyCode != Keys.Back) return;

            DataGridViewCell CurCell = dgvAllDisplay.CurrentCell;

            DataGridViewRow CurRow = dgvAllDisplay.CurrentRow;

            int GroupNo = CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.GroupCount].Value);

            // ?{?H???????????

            if (GroupNo != (int)FrmConstructionLedger.DataGroup.ConstructionCosts) return;

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

            if (CurCell.ColumnIndex != (int)GridColumn.CompanyName) return;

            // ??????R?[?h?E??????N???A????

            CurRow.Cells[(int)(int)GridColumn.CompanyType].Value = 0;

            CurRow.Cells[(int)(int)GridColumn.CompanyCode].Value = 0;

            CurRow.Cells[(int)(int)GridColumn.CompanyName].Value = string.Empty;

            m_bChengeAns = true;

            //Convert1();

            PurchaseLineUpdate();

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

            this.btnDispDown = new System.Windows.Forms.Button();

            this.btnDispUp = new System.Windows.Forms.Button();

            this.btnOtherProc = new System.Windows.Forms.Button();

            this.button1 = new System.Windows.Forms.Button();

            this.button2 = new System.Windows.Forms.Button();

            this.btnSelect = new System.Windows.Forms.Button();

            this.btnCreate = new System.Windows.Forms.Button();

            // 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.WhiteSmoke;

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

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

            this.lblCellTotal.Location = new System.Drawing.Point(100, 430);

            this.lblCellTotal.Name = "lblCellTotal";

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

            this.lblCellTotal.TabIndex = 36;

            // 

            // btnDispDown

            // 

            this.btnDispDown.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

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

            this.btnDispDown.Location = new System.Drawing.Point(1300, 418);

            this.btnDispDown.Name = "btnDispDown";

            this.btnDispDown.Size = new System.Drawing.Size(40, 40);

            this.btnDispDown.TabIndex = 42;

            this.btnDispDown.TabStop = false;

            this.btnDispDown.Text = "▼";

            this.btnDispDown.UseVisualStyleBackColor = true;

            this.btnDispDown.Visible = false;

            this.btnDispDown.Click += new System.EventHandler(this.btnDispDown_Click);

            // 

            // btnDispUp

            // 

            this.btnDispUp.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

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

            this.btnDispUp.Location = new System.Drawing.Point(1300, 354);

            this.btnDispUp.Name = "btnDispUp";

            this.btnDispUp.Size = new System.Drawing.Size(40, 40);

            this.btnDispUp.TabIndex = 41;

            this.btnDispUp.TabStop = false;

            this.btnDispUp.Text = "▲";

            this.btnDispUp.UseVisualStyleBackColor = true;

            this.btnDispUp.Visible = false;

            this.btnDispUp.Click += new System.EventHandler(this.btnDispUp_Click);

            // 

            // btnOtherProc

            // 

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

            this.btnOtherProc.BackColor = System.Drawing.Color.SpringGreen;

            this.btnOtherProc.Location = new System.Drawing.Point(7, 656);

            this.btnOtherProc.Name = "btnOtherProc";

            this.btnOtherProc.Size = new System.Drawing.Size(160, 30);

            this.btnOtherProc.TabIndex = 95;

            this.btnOtherProc.TabStop = false;

            this.btnOtherProc.Text = "他の画面へ";

            this.btnOtherProc.UseVisualStyleBackColor = false;

            this.btnOtherProc.Click += new System.EventHandler(this.btnOtherProc_Click);

            // 

            // button1

            // 

            this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));

            this.button1.Location = new System.Drawing.Point(1300, 540);

            this.button1.Name = "button1";

            this.button1.Size = new System.Drawing.Size(37, 35);

            this.button1.TabIndex = 100;

            this.button1.Text = "○";

            this.button1.UseVisualStyleBackColor = true;

            this.button1.Visible = false;

            this.button1.Click += new System.EventHandler(this.button1_Click);

            // 

            // button2

            // 

            this.button2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));

            this.button2.Location = new System.Drawing.Point(1300, 581);

            this.button2.Name = "button2";

            this.button2.Size = new System.Drawing.Size(37, 35);

            this.button2.TabIndex = 101;

            this.button2.Text = "１";

            this.button2.UseVisualStyleBackColor = true;

            this.button2.Visible = false;

            this.button2.Click += new System.EventHandler(this.button2_Click);

            // 

            // btnSelect

            // 

            this.btnSelect.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));

            this.btnSelect.BackColor = System.Drawing.Color.Green;

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

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

            this.btnSelect.Location = new System.Drawing.Point(546, 657);

            this.btnSelect.Name = "btnSelect";

            this.btnSelect.Size = new System.Drawing.Size(120, 30);

            this.btnSelect.TabIndex = 102;

            this.btnSelect.Text = "選　択";

            this.btnSelect.UseVisualStyleBackColor = false;

            this.btnSelect.Visible = false;

            this.btnSelect.Click += new System.EventHandler(this.btnSelect_Click);

            // 

            // btnCreate

            // 

            this.btnCreate.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));

            this.btnCreate.BackColor = System.Drawing.Color.White;

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

            this.btnCreate.ForeColor = System.Drawing.Color.Green;

            this.btnCreate.Location = new System.Drawing.Point(420, 657);

            this.btnCreate.Name = "btnCreate";

            this.btnCreate.Size = new System.Drawing.Size(120, 30);

            this.btnCreate.TabIndex = 103;

            this.btnCreate.Text = "新　規";

            this.btnCreate.UseVisualStyleBackColor = false;

            this.btnCreate.Visible = false;

            this.btnCreate.Click += new System.EventHandler(this.btnCreate_Click);

            // 

                //if (CommonMotions.cnvInt(dgv.Rows[m_BeforeGridRow].Cells[(int)GridColumn.FluctuationFlg].Value) != 0)

                //{

                //    dgv.Rows[m_BeforeGridRow].Cells[(int)GridColumn.No].Style.BackColor = Color.Red;

                //}

                            {

                                //SetBackColor = Color.Red;

                                int nIndex = m_SourceCodeList.IndexOf(CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.SourceCode].Value));

                                SetBackColor = CommonDefine.DefineColorList[nIndex];

                            }

                //CalculateNetIncome();

                dgvAllDisplay.Rows[nSetRow].Cells[(int)GridColumn.EstimatePrice].ToolTipText = "一　般　管　理　費";

                dgvAllDisplay.Rows[nSetRow].Cells[(int)GridColumn.EstimatePrice].ToolTipText = "現　場　管　理　費";

        #region 純利益計算（未使用）

        /// 純利益計算（未使用）

        #region 純利益作成（新規作成時）

        /// 純利益作成（新規作成時）

        #region 表示明細行より対象行数を返す

        /// <summary>

        /// 表示明細行より対象行数を返す

        /// </summary>

        private int RowCountPoint(int nCode, ArrayList DetailList)

        {

            try

            {

                int nPo = 0;

                int i = 0;

                foreach(object[] CurObj in DetailList)

                {

                    // 同じコードの行数を取得する

                    int nCurCode = CommonMotions.cnvInt(CurObj[(int)IOConstructionLedgerDetail.TableColumn.SourceCode]);

                    if (nCurCode == nCode)

                    {

                        nPo = i;

                        break;

                    }

                    i++;

                }

                return nPo;

            }

            catch (Exception ex)

            {

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

                return 0;

            }

        }

        #endregion

        #region 指定コードの発注金額（注文書が無ければ実行金額）を返す

        /// <summary>

        /// 指定コードの発注金額（注文書が無ければ実行金額）を返す

        /// </summary>

        private long GetPurchaseValue(int nCode)

        {

            IOConstructionLedgerDetail cldDB = new IOConstructionLedgerDetail();

            try

            {

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("Select");

                strSQL.Append(" SUM(CASE WHEN ifnull(Odr.OrdersLinePrice, 0) > 0 THEN ifnull(Odr.OrdersLinePrice, 0)");

                strSQL.Append(" ELSE A.ExecutionAmount END) As OrderPrice");

                strSQL.Append(" From constructionledgerdetail As A");

                strSQL.Append("      LEFT JOIN(Select OdrA.ConstructionCode, OdrA.SourceDetailCnt, SUM(OdrA.OrdersLinePrice) As OrdersLinePrice");

                strSQL.Append("                From PurchaseOrderDetail As OdrA");

                strSQL.AppendFormat("          Where OdrA.ConstructionCode = {0}", nCode);

                strSQL.AppendFormat("          And OdrA.SourceCode = {0}", m_ConstructionCode);

                strSQL.AppendFormat("          And OdrA.GroupCount in ({0}, {1})", (int)PurchaseOrderDetail.GroupCountDef.Detail

                                                                                    , (int)PurchaseOrderDetail.GroupCountDef.StatutoryWelfare);

                strSQL.AppendFormat("          Group By OdrA.SourceDetailCnt) As Odr");

                strSQL.AppendFormat("    ON Odr.ConstructionCode = A.SourceCode");

                strSQL.AppendFormat("    And Odr.SourceDetailCnt = A.DetailCount");

                //strSQL.Append(" LEFT JOIN PurchaseOrderDetail As Odr");

                //strSQL.Append("       ON Odr.ConstructionCode = A.SourceCode");

                //strSQL.Append("       And Odr.SourceCode = A.ConstructionCode");

                //strSQL.Append("       And Odr.SourceDetailCnt = A.DetailCount");

                strSQL.AppendFormat(" Where A.ConstructionCode = {0}", m_ConstructionCode);

                strSQL.AppendFormat(" And A.SourceCode = {0}", nCode);

                strSQL.AppendFormat(" And ({0} < A.GroupCount", (int)DataGroup.Expenses);

                strSQL.AppendFormat(" And A.GroupCount < {0})", (int)DataGroup.Instructor);

                ArrayList arrayList = new ArrayList();

                if (!cldDB.ExecuteReader(strSQL.ToString(), ref arrayList)) return 0;

                if (arrayList.Count < 1) return 0;

                object[] objRec = (object[])arrayList[0];

                return CommonMotions.cnvLong(objRec[0]);

            }

            catch (Exception ex)

            {

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

                return 0;

            }

            finally

            {

                cldDB.close(); cldDB = null;

            }

        }

        #endregion

        #region 純利益作成（データ存在時）

        /// <summary>

        /// 純利益作成（データ存在時）

        /// </summary>

        /// <returns></returns>

        private void CreateNetIncome2(ArrayList DetailList)

        {

            try

            {

                DataGridViewEX dgv = dgvAllDisplay;

                int DetailCnt = Enum.GetNames(typeof(IOConstructionLedgerDetail.TableColumn)).Length;

                int SaveLineCnt = -1;

                int nRowCnt = 0;

                long[] DispVal = new long[3];

                List<long> OrderVal = new List<long>();

                List<long> EstVal = new List<long>();

                List<long> ExecVal = new List<long>();

                List<long> PurVal = new List<long>();

                foreach (int CurCode in m_SourceCodeList)

                {

                    int nCnt = RowCountPoint(CurCode, DetailList);

                    object[] DetialObj = (object[])DetailList[nCnt];

                    // 受注金額

                    OrderVal.Add(CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.OrdersPrice]));

                    // 予算金額

                    long wrkEstVal = CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.Budget1_SumOdrVal])

                                + CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.Budget2_SumOdrVal])

                                + CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.Budget3_SumOdrVal])

                                + CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.Budget4_SumOdrVal]);

                    EstVal.Add(wrkEstVal);

                    // 実行金額

                    long wrkExecVal = CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.Budget1_SumExecVal])

                                + CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.Budget2_SumExecVal])

                                + CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.Budget3_SumExecVal])

                                + CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.Budget4_SumExecVal]);

                    ExecVal.Add(wrkExecVal);

                    // 発注金額

                    long wrkExpenses = CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.Budget1_SumExecVal]);

                    long wrkPayVal = CommonMotions.cnvLong(DetialObj[DetailCnt + (int)DetailReadOrder.Budget4_SumExecVal]);

                    PurVal.Add((GetPurchaseValue(CurCode) + wrkExpenses + wrkPayVal));

                    // 予算書金額

                    DispVal[0] = OrderVal.Sum() - EstVal.Sum();

                    // 実行金額

                    DispVal[1] = OrderVal.Sum() - ExecVal.Sum();

                    // 発注金額

                    DispVal[2] = OrderVal.Sum() - PurVal.Sum();

                    // データセット

                    object[] RowData = new object[dgv.Columns.Count];

                    RowData[(int)GridColumn.FixFlg] = "*";

                    RowData[(int)GridColumn.GroupCount] = (int)DataGroup.NetIncome;

                    if (nRowCnt < 1) RowData[(int)GridColumn.ItemName] = s_GroupTitle[(int)DataGroup.NetIncome];

                    RowData[(int)GridColumn.EstimatePrice] = DispVal[0].ToString("#,0");

                    RowData[(int)GridColumn.ExecPrice] = DispVal[1].ToString("#,0");

                    RowData[(int)GridColumn.Percent] = CalculattionPercent((double)DispVal[1]).ToString("0.00");

                    RowData[(int)GridColumn.OrderPrice] = DispVal[2].ToString("#,0");

                    RowData[(int)GridColumn.IndependentFlg] = "1";

                    RowData[(int)GridColumn.SourceCode] = CurCode;

                    // 増減フラグ

                    if (SaveLineCnt > 0) { RowData[(int)GridColumn.FluctuationFlg] = (int)ConstructionLedgerDetail.FlucFlgDef.Fluctuates; }

                    // 行セット

                    CreateDataRow(RowData);

                    // 行位置取得

                    int CurRow = dgv.RowCount - 1;

                    if (SaveLineCnt < 0) SaveLineCnt = CurRow;

                    // 色を付ける

                    dgv.Rows[CurRow].Cells[(int)GridColumn.No].Style.BackColor = CommonDefine.DefineColorList[nRowCnt];

                    nRowCnt++;

                }

                // 行位置セット

                m_CostsRowCount[(int)CostsRowLine.NetIncomeRowLine] = SaveLineCnt;

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

                strcmd.Append(", CASE WHEN BudgetHead.OrdersDecisionPrice > 0 THEN BudgetHead.OrdersDecisionPrice");

                strcmd.Append("  ELSE BASE.OrdersDecisionPrice END");

                strcmd.Append(", Budget1.SumOdrVal");

                strcmd.Append(", Budget1.SumExecVal");

                strcmd.Append(", Budget2.SumOdrVal");

                strcmd.Append(", Budget2.SumExecVal");

                strcmd.Append(", Budget3.SumOdrVal");

                strcmd.Append(", Budget3.SumExecVal");

                strcmd.Append(", Budget4.SumOdrVal");

                strcmd.Append(", Budget4.SumExecVal");

                strcmd.Append("   INNER JOIN CONSTRUCTIONBASEINFO AS BASE");

                strcmd.Append("         ON BASE.CONSTRUCTIONCODE = A.SourceCode");

                //strcmd.Append("      LEFT JOIN(Select OdrA.ConstructionCode, OdrA.SourceDetailCnt, SUM(OdrA.OrdersLinePrice) As OrdersLinePrice");

                //strcmd.Append("                From PurchaseOrderDetail As OdrA");

                //strcmd.AppendFormat("          Where OdrA.GroupCount in ({0}, {1})", (int)PurchaseOrderDetail.GroupCountDef.Detail

                //                                                                    , (int)PurchaseOrderDetail.GroupCountDef.StatutoryWelfare);

                //strcmd.AppendFormat("          Group By OdrA.ConstructionCode, OdrA.SourceDetailCnt) As Odr");

                //strcmd.AppendFormat("    ON Odr.ConstructionCode = A.SourceCode");

                //strcmd.AppendFormat("    And Odr.SourceDetailCnt = A.DetailCount");

                strcmd.Append("         ON Odr.ConstructionCode = A.SourceCode");

                strcmd.Append("         And Odr.SourceCode = A.ConstructionCode");

                strcmd.Append("   LEFT JOIN constructionbudget As BudgetHead");

                strcmd.Append("         ON BudgetHead.ConstructionCode = A.SourceCode");

                // 経費取得

                strcmd.Append("   LEFT JOIN(Select Bdd.ConstructionCode, EstSum.PriceValue As SumOdrVal, SUM(Bdd.ExecutionAmount) As SumExecVal");

                strcmd.Append("             From ConstructionBudgetdetail As Bdd");

                strcmd.Append("                  Left Join(Select EstSumA.ConstructionCode, SUM(EstSumA.PriceValue) AS PriceValue From estimatedata As EstSumA");

                strcmd.AppendFormat("                      Where EstSumA.ConstructionCode = {0}", m_ConstructionCode);

                strcmd.AppendFormat("                      And EstSumA.ComponentCode in ({0}, {1})) As EstSum"

                                                                                                    , m_CommonCosts.NormalManagementPublic

                                                                                                    , m_CommonCosts.NormalManagementPrivate);

                strcmd.Append("                       On EstSum.ConstructionCode = Bdd.ConstructionCode");

                strcmd.AppendFormat("       WHERE Bdd.GroupCount = {0}", (int)FrmConstructionBudget.DataGroup.Expenses);

                strcmd.Append("             Group By Bdd.ConstructionCode) As Budget1 ON Budget1.ConstructionCode = A.SourceCode");

                // 施工費取得

                strcmd.Append("   LEFT JOIN(Select Bdd.ConstructionCode, SUM(Bdd.NegotiationPrice) As SumOdrVal, SUM(Bdd.ExecutionAmount) As SumExecVal");

                strcmd.Append("             From ConstructionBudgetdetail As Bdd");

                strcmd.AppendFormat("       WHERE Bdd.GroupCount In ({0}, {1}, {2})", (int)FrmConstructionBudget.DataGroup.CommonTempCosts

                                                                                    , (int)FrmConstructionBudget.DataGroup.OutSourceCosts

                                                                                    , (int)FrmConstructionBudget.DataGroup.MyConstruction);

                strcmd.Append("             Group By Bdd.ConstructionCode) As Budget2 ON Budget2.ConstructionCode = A.SourceCode");

                // 諸経費取得

                strcmd.Append("   LEFT JOIN(Select Bdd.ConstructionCode, SUM(Bdd.NegotiationPrice) As SumOdrVal, SUM(Bdd.ExecutionAmount) As SumExecVal");

                strcmd.Append("             From ConstructionBudgetdetail As Bdd");

                strcmd.AppendFormat("       Where Bdd.GroupCount In ({0}, {1}, {2}, {3}, {4}, {5})"

                                                                                    , (int)FrmConstructionBudget.DataGroup.PurchaseCosts

                                                                                    , (int)FrmConstructionBudget.DataGroup.VehicleLeaseFee

                                                                                    , (int)FrmConstructionBudget.DataGroup.TransportationCosts

                                                                                    , (int)FrmConstructionBudget.DataGroup.ParkingCosts

                                                                                    , (int)FrmConstructionBudget.DataGroup.RoomChargeCosts

                                                                                    , (int)FrmConstructionBudget.DataGroup.DisposeCosts);

                strcmd.Append("             Group By Bdd.ConstructionCode) As Budget3 ON Budget3.ConstructionCode = A.SourceCode");

                // 人件費取得

                strcmd.Append("   LEFT JOIN(Select Bdd.ConstructionCode, EstSum.PriceValue As SumOdrVal, SUM(Bdd.ExecutionAmount) As SumExecVal");

                strcmd.Append("             From ConstructionBudgetdetail As Bdd");

                strcmd.Append("                  Left Join(Select EstSumA.ConstructionCode, SUM(EstSumA.PriceValue) AS PriceValue From estimatedata As EstSumA");

                strcmd.AppendFormat("                      Where EstSumA.ConstructionCode = {0}", m_ConstructionCode);

                strcmd.AppendFormat("                      And EstSumA.ComponentCode in ({0}, {1})) As EstSum", m_CommonCosts.FieldManagementPublic

                                                                                                    , m_CommonCosts.FieldManagementPrivate);

                strcmd.Append("                       On EstSum.ConstructionCode = Bdd.ConstructionCode");

                strcmd.AppendFormat("       Where Bdd.GroupCount In ({0}, {1}, {2})"

                                                                                    , (int)FrmConstructionBudget.DataGroup.InstructorCosts

                                                                                    , (int)FrmConstructionBudget.DataGroup.AssistantCosts

                                                                                    , (int)FrmConstructionBudget.DataGroup.PayrollExpenses);

                strcmd.Append("             Group By Bdd.ConstructionCode) As Budget4 ON Budget4.ConstructionCode = A.SourceCode");

        #region 表示データ読込順

        /// <summary>

        /// 表示データ読込順

        /// </summary>

        private enum DetailReadOrder

        {

            /// <summary>

            /// +0:支払年月

            /// </summary>

            TargetMonth,

            /// <summary>

            /// +1:支払金額

            /// </summary>

            PaymentAmount,

            /// <summary>

            /// +2:注文書発注金額

            /// </summary>

            OrdersLinePrice,

            /// <summary>

            /// +3:法定福利費率

            /// </summary>

            StatutoryWelfareRate,

            /// <summary>

            /// +4:受注金額

            /// </summary>

            OrdersPrice,

            /// <summary>

            /// +5:工事予算書：経費（予算）

            /// </summary>

            Budget1_SumOdrVal,

            /// <summary>

            /// +6:工事予算書：経費（実行）

            /// </summary>

            Budget1_SumExecVal,

            /// <summary>

            /// +7:工事予算書：施工費（予算）

            /// </summary>

            Budget2_SumOdrVal,

            /// <summary>

            /// +8:工事予算書：施工費（実行）

            /// </summary>

            Budget2_SumExecVal,

            /// <summary>

            /// +9:工事予算書：諸経費（予算）

            /// </summary>

            Budget3_SumOdrVal,

            /// <summary>

            /// +10:工事予算書：諸経費（実行）

            /// </summary>

            Budget3_SumExecVal,

            /// <summary>

            /// +11:工事予算書人件費（予算）

            /// </summary>

            Budget4_SumOdrVal,

            /// <summary>

            /// +12:工事予算書人件費（実行）

            /// </summary>

            Budget4_SumExecVal,

        }

        #endregion