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

                strDelSQL += " (SELECT A1.CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO A1";

                strDelSQL += string.Format(" WHERE (A1.SALESPERSONCODE = {0} OR A1.CONSTRUCTIONPERSONCODE = {0} OR A1.CONSTRSUBPERSONCODE = {0} OR A1.CONSTRUCTIONINSTRUCTOR = {0}))", PersonCode);

                    strSQL += " AND CONSTRUCTIONCODE IN (SELECT A1.CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO A1";

                    strSQL += string.Format(" WHERE (A1.SALESPERSONCODE = {0} OR A1.CONSTRUCTIONPERSONCODE = {0} OR A1.CONSTRSUBPERSONCODE = {0} OR A1.CONSTRUCTIONINSTRUCTOR = {0}))", PersonCode);

        public static bool CalculatePayment(ConstructionLedger LedgerRec, DateTime TargetDate, DateTime lastDate)

                TimeSpan ts = TargetDate - lastDate;

            FrmLedgerStatus frm = new FrmLedgerStatus();

            FrmLedgerStatus frm = new FrmLedgerStatus();

                            if (CurRecRank == 0) CurRecRank = 9;

                            if (CurRecRank == 0) CurRecRank = 9;

            int Rank = 0;

            // 初期値として参照無をセットする

            Range = 0;

                if (CommonMotions.LoginUserData.SecCode == 0) return Rank;

                // 初期値として一般ユーザーをセットする

                Rank = CommonDefine.SecurityRankList[(int)CommonDefine.SecurityRankPos.NormalAuthority].Key;

                string strSQL = " WHERE CONSTRUCTIONSTATUSFLG IN (SELECT DISTINCT A1.CONSTRUCTIONSTATUSFLG FROM TERMMASTER A1)";

                strcmd += "  (PersonCode";      // 担当者コード

                strcmd += " ,DailyDataDate";    // 日報作成日

                strcmd += " ,ConstructionCode"; // 工事番号

                strcmd += " ,SeqNo";            // 明細行番号

                strcmd += " ,JobCategoryCode";  // 職種キー

                strcmd += " ,CompanyCode";      // 協力会社コード

                strcmd += " ,TodayHeadCount";   // 当日人員数

                strcmd += " ,TotalHeadCount";   // 累計人員数

                strcmd += " ,TodayWork";        // 当日作業内容

                strcmd += " ,NextdayWork";      // 翌日作業内容

                strcmd += " ,NextdayHeadCount"; // 翌日人員数

                strcmd += " ,EntryDate";        // 登録年月日

                strcmd += " ,UpdateDate)";      // 更新年月日

        #region 1項目更新処理

        /// <summary>

        /// 1項目の更新を行う

        /// </summary>

        /// <param name="ConstructionCode"></param>

        /// <param name="FeildNo"></param>

        /// <param name="value"></param>

        /// <param name="bConnect"></param>

        /// <returns></returns>

        public bool UpdateFeild(int PersonCode, DateTime DailyDataDate, int ConstructionCode, int SeqNo, int FeildNo, object value, bool bConnect = true)

        {

            string strcmd = "";

            try

            {

                strcmd = "UPDATE DailyDataDetail";

                strcmd += " SET";

                switch (FeildNo)

                {

                    case (int)DataColumn.PersonCode:

                        strcmd += string.Format(" PersonCode = {0}", (int)value);

                        break;

                    case (int)DataColumn.DailyDataDate:

                        strcmd += string.Format(" DailyDataDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());

                        break;

                    case (int)DataColumn.ConstructionCode:

                        strcmd += string.Format(" ConstructionCode = {0}", (int)value);

                        break;

                    case (int)DataColumn.SeqNo:

                        strcmd += string.Format(" SeqNo = {0}", (int)value);

                        break;

                    case (int)DataColumn.JobCategoryCode:

                        strcmd += string.Format(" JobCategoryCode = {0}", (int)value);

                        break;

                    case (int)DataColumn.CompanyCode:

                        strcmd += string.Format(" CompanyCode = {0}", (int)value);

                        break;

                    case (int)DataColumn.TodayHeadCount:

                        strcmd += string.Format(" TodayHeadCount = {0}", (double)value);

                        break;

                    case (int)DataColumn.TotalHeadCount:

                        strcmd += string.Format(" TotalHeadCount = {0}", (double)value);

                        break;

                    case (int)DataColumn.TodayWork:

                        strcmd += string.Format(" TodayWork = '{0}'", CommonMotions.cnvString(value));

                        break;

                    case (int)DataColumn.NextdayWork:

                        strcmd += string.Format(" NextdayWork = '{0}'", CommonMotions.cnvString(value));

                        break;

                    case (int)DataColumn.NextdayHeadCount:

                        strcmd += string.Format(" NextdayHeadCount = {0}", (double)value);

                        break;

                }

                strcmd += ", UpdateDate = TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

                strcmd += CreatePrimarykeyString(PersonCode, DailyDataDate, ConstructionCode, SeqNo);

                if (!ExecuteNonQuery(strcmd, bConnect)) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

                        strSQL += " AND A.DEPARTMENTCODE IN (SELECT A1.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A1";

                        strSQL += string.Format(" WHERE A1.PERSONCODE = {0})", CommonMotions.LoginUserData.PersonCode);

                    strSecurity += string.Format(" And (B.SalesPersonCode IN (Select B1.PersonCode From PersonInChargeMaster B1 Where B1.DepartmentCode = {0})", CommonMotions.LoginUserData.DepartmentCode);

                    strSecurity += string.Format(" Or B.CONSTRUCTIONPERSONCODE IN (Select B2.PersonCode From PersonInChargeMaster B2 Where B2.DepartmentCode = {0})", CommonMotions.LoginUserData.DepartmentCode);

                    strSecurity += string.Format(" Or B.CONSTRSUBPERSONCODE IN (Select B3.PersonCode From PersonInChargeMaster B3 Where B3.DepartmentCode = {0})", CommonMotions.LoginUserData.DepartmentCode);

                    strSecurity += string.Format(" Or B.CONSTRUCTIONINSTRUCTOR IN (Select B4.PersonCode From PersonInChargeMaster B4 Where B4.DepartmentCode = {0}))", CommonMotions.LoginUserData.DepartmentCode);

                // ?????H????H???\?Z???\??????{??????????`?F?b?N????

                if (!CheckLedgerApproval())

                {

                    MessageBox.Show("?{???H?????????????????????B", "?\???G???[", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return;

                }

        #region 増減工事の工事予算書申請時に本体があるかをチェックする

        /// <summary>

        /// 増減工事の工事予算書申請時に本体があるかをチェックする

        /// </summary>

        /// <param name="Rec"></param>

        /// <returns></returns>

        private bool CheckLedgerApproval()

        {

            IOConstructionLink LinkDB = new IOConstructionLink();

            try

            {

                // 工事予算申請時だけのチェック

                int iCode = ClsExcute.AppovalList.First(x => x.Value.Equals("工事予算書承認")).Key;

                if (m_ApprovalCode != iCode) return true;

                // 増減なしの工事・本体工事はチェック無

                if (m_ConstructionBaseInfo.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Standard

                    || m_ConstructionBaseInfo.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Pearent) return true;

                // 増減工事の子データのみ表示

                string strSQL = " SELECT * FROM CONSTRUCTIONLINK A, CONSTRUCTIONLEDGER B";

                strSQL += string.Format(" WHERE A.FLUCTUATIONCODE = {0}", m_ConstructionCode);

                strSQL += " AND B.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE";

                ArrayList arList = new ArrayList();

                if (!LinkDB.ExecuteReader(strSQL, ref arList)) return false;

                if (arList.Count == 0) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

            finally

            {

                LinkDB.close(); LinkDB = null;

            }

        }

        #endregion

                    strSQL += string.Format(" And (A.SalesPersonCode IN (Select A1.PersonCode From PersonInChargeMaster A1 Where A1.DepartmentCode = {0})", CommonMotions.LoginUserData.DepartmentCode);

                    strSQL += string.Format(" Or (A.ConstructionStatusFlg >= {0} And (A.ConstructionPersonCode IN (Select A2.PersonCode From PersonInChargeMaster A2 Where A2.DepartmentCode = {1})",

                    strSQL += string.Format(" Or A.ConstructionInstructor IN (Select A3.PersonCode From PersonInChargeMaster A3 Where A3.DepartmentCode = {0})))", CommonMotions.LoginUserData.DepartmentCode);

            strSQL += " AND A.ConstructionCode IN (SELECT AA1.CONSTRUCTIONCODE FROM CONSTRUCTIONBUDGETDETAIL AA1 WHERE (AA1.COMPANYCODE != 0 AND AA1.COMPANYCODE != -1)";

            strSQL += " GROUP BY AA1.CONSTRUCTIONCODE, AA1.COMPANYCODE HAVING SUM(AA1.ExecutionAmount) >= 300000)";

                        strSQL += " AND A.DEPARTMENTCODE IN (SELECT A1.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A1";

                        strSQL += string.Format(" WHERE A1.PERSONCODE = {0})", CommonMotions.LoginUserData.PersonCode);

                    // ?????????????O

                    if (CommonMotions.LoginUserData.DepartmentCode != CommonDefine.s_GeneralAffairsDevision)

                        cmbDepartment.SelectedValue = CommonMotions.LoginUserData.DepartmentCode;

                    if (CommonMotions.LoginUserData.DepartmentCode != CommonDefine.s_GeneralAffairsDevision)

                if (m_frmAppList != null) m_frmAppList.Dispose();

            try

            {

                m_frmAppList.ConstructionCode = m_ConstructionCode;

                m_frmAppList.EditLock = m_EditLock;

                m_frmAppList.LocationPoint = new Point(this.Right, this.Top);

                //m_frmAppList.ShowInTaskbar = false;

                // ?N???[?X?h?n???h????????????`????

                m_frmAppList.FormClosed += new FormClosedEventHandler(FrmAppList_FormClosed);

                m_frmAppList.Show();

            }

            catch (Exception ex)

            {

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

            }

                    Handle.SubFormHandle.Dispose();

        #region ?o????X?{?^??

        /// <summary>

        /// ?o????X?{?^??

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void btnChangeExpenses_Click(object sender, EventArgs e)

        {

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

            DspChangeExpens();

        }

        #endregion

            try

            {

                textBox1.Enabled = false;

                textBox1.Text = "";

                // ?????w??????????????L

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

                if (radioButton1.Checked)

                    // ???^?o???v?Z

                    if (!m_bInitFlg)

                    {

                        CreatePayrollCosts(false);

                        // ?e???v?s?v?Z

                        CreateGrossProfit(false);

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

                        CreateNetIncome(false);

                        // ???v???z

                        CreateAllTotal(false);

                    }

                else if (radioButton2.Checked)

                {

                    // ???^?o??N???A

                    if (!m_bInitFlg) ClearDetailLine((int)CostsRowLine.ConstructorRowLine);

                }

                else if (radioButton3.Checked)

                {

                    textBox1.Enabled = true;

                    textBox1.Focus();

                }

                // ??X?t???OON

                m_bChengeAns = true;

            catch (Exception ex)

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

            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.button3 = new System.Windows.Forms.Button();

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

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

            // 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(200, 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, 506);

            this.button1.Name = "button1";

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

            this.button1.TabIndex = 101;

            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, 541);

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

            // 

            // button3

            // 

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

            this.button3.Location = new System.Drawing.Point(1300, 576);

            this.button3.Name = "button3";

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

            this.button3.TabIndex = 102;

            this.button3.Text = "２";

            this.button3.UseVisualStyleBackColor = true;

            this.button3.Visible = false;

            this.button3.Click += new System.EventHandler(this.button3_Click);

            // 

            // btnChangeExpenses

            // 

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

            this.btnChangeExpenses.BackColor = System.Drawing.Color.Gold;

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

            this.btnChangeExpenses.Location = new System.Drawing.Point(223, 656);

            this.btnChangeExpenses.Name = "btnChangeExpenses";

            this.btnChangeExpenses.Size = new System.Drawing.Size(130, 30);

            this.btnChangeExpenses.TabIndex = 103;

            this.btnChangeExpenses.Text = "経費変更";

            this.btnChangeExpenses.UseVisualStyleBackColor = false;

            this.btnChangeExpenses.Visible = false;

            this.btnChangeExpenses.Click += new System.EventHandler(this.btnChangeExpenses_Click);

            // 

            // button4

            // 

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

            this.button4.Location = new System.Drawing.Point(1300, 611);

            this.button4.Name = "button4";

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

            this.button4.TabIndex = 104;

            this.button4.Text = "３";

            this.button4.UseVisualStyleBackColor = true;

            this.button4.Visible = false;

            this.button4.Click += new System.EventHandler(this.button4_Click);

            // 

                // 経営者は経費の変更ができる

                // 新セキュリティデータ対応済みかを確認する

                if (CommonMotions.LoginUserData.SecCode == 0)

                {

                    if (CommonMotions.LoginUserData.SecurityManagement == CommonDefine.AdminSecurityManagement)

                    {

                        btnChangeExpenses.Visible = true;

                    }

                }

                else

                {

                    int SRank = (int)CommonDefine.SecurityRankPos.SpecialAuthority;     // 経営者アクセス

                    if (CommonMotions.LoginUserData.PersonCode == CommonDefine.AdminCode

                        || CommonMotions.LoginUserSecurity.SecRank == CommonDefine.SecurityRankList[SRank].Key)

                    {

                        btnChangeExpenses.Visible = true;

                    }

                }

                btnChangeExpenses.Visible = false;                  // 経費変更ボタン

        #region 参照モード

        /// <summary>

        /// 参照モードにして各コントロールへロックをかける

        /// </summary>

        private void SeeModeLock()

        {

            try

            {

                dgvAllDisplay.ReadOnly = true;

                // 各グループボックスを使用禁止にする

                pnlGroup1.Enabled = false;

                pnlGroup2.Enabled = false;

                pnlApproval.Visible = false;

                pnlApprovalButton.Visible = false;

                // 最後にボタンの処理を行う

                btnApprovalList.Visible = false;

                btnDataEntry.Visible = false;

                btnDataDelete.Visible = false;

                btnLineAdd.Visible = false;

                btnLineDel.Visible = false;

                btnChangeExpenses.Visible = false;

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

                    RowData[(int)GridColumn.ComponentCode] = DetailRec.ComponentCode;

                    RowData[(int)GridColumn.ItemCode] = DetailRec.ItemCode;

                    RowData[(int)GridColumn.ComponentCode] = DetailRec.ComponentCode;

                    RowData[(int)GridColumn.ItemCode] = DetailRec.ItemCode;

                    RowData[(int)GridColumn.ComponentCode] = DetailRec.ComponentCode;

                    RowData[(int)GridColumn.ItemCode] = DetailRec.ItemCode;

                    RowData[(int)GridColumn.ComponentCode] = DetailRec.ComponentCode;

                    RowData[(int)GridColumn.ItemCode] = DetailRec.ItemCode;

                    RowData[(int)GridColumn.ComponentCode] = DetailRec.ComponentCode;

                    RowData[(int)GridColumn.ItemCode] = DetailRec.ItemCode;

                    RowData[(int)GridColumn.ComponentCode] = CommonMotions.cnvInt(wrkrec[3]);

                    RowData[(int)GridColumn.ItemCode] = CommonMotions.cnvInt(wrkrec[4]);

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

                //if (DetailRec.AmountConfigRate == 0) return false;

                // 名前がセットされていなければ処理しない

                if (DetailRec.FirstString.Length == 0) return false;

                        //radioButton2.Checked = true;

                        //radioButton3.Checked = true;

        #region 経費変更画面表示

        /// <summary>

        /// 経費変更画面表示

        /// </summary>

        private void DspChangeExpens()

        {

            FrmChangeExpenses frm = new FrmChangeExpenses();

            try

            {

                // データ取得

                ArrayList GridExpens = new ArrayList();

                GetExpensesData(ref GridExpens);

                // パラメタセット

                frm.OrdersPrice = label6.Text;

                frm.GridData = GridExpens;

                // 画面表示

                frm.ShowDialog();

                // 終了時キャンセルは以下を処理しない

                if (frm.EndButton == DialogResult.Cancel) return;

                // データセット

                SetExpensesData(frm.GridData);

                // 合計金額

                CreateAllTotal(false);

                // 変更フラグON

                m_bChengeAns = true;

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                frm.Dispose(); frm = null;

            }

        }

        #endregion

        #region 画面より経費データを取得する

        /// <summary>

        /// 画面より経費データを取得する

        /// </summary>

        /// <param name="GridExpens"></param>

        private void GetExpensesData(ref ArrayList GridExpens)

        {

            try

            {

                DataGridView dgv = dgvAllDisplay;

                for (int i = 0; i < dgv.RowCount; i++)

                {

                    DataGridViewRow CurRow = dgv.Rows[i];

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

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

                    if (GroupNo != (int)DataGroup.Expenses) continue;

                    if (ComponentCode == 0) continue;

                    // 経費を取得する

                    string ExpensName = CommonMotions.cnvString(CurRow.Cells[(int)GridColumn.ItemName].Value);

                    object[] DataRec = new object[] { CurRow.Cells[(int)GridColumn.No].Value,

                                                        CurRow.Cells[(int)GridColumn.ComponentCode].Value,

                                                        ExpensName.Substring(0, ExpensName.IndexOf("(")),

                                                        CurRow.Cells[(int)GridColumn.Percent].Value,

                                                        CurRow.Cells[(int)GridColumn.ExecPrice].Value

                    };

                    GridExpens.Add(DataRec);

                }

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 変更経費表示処理

        /// <summary>

        /// 変更経費表示処理

        /// </summary>

        /// <param name="ExpensList"></param>

        private void SetExpensesData(ArrayList ExpensList)

        {

            try

            {

                if (ExpensList.Count == 0) return;

                DataGridView dgv = dgvAllDisplay;

                int ListCnt = 0;

                for (int i = 0; i < dgv.RowCount; i++)

                {

                    DataGridViewRow CurRow = dgv.Rows[i];

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

                    if (GroupNo != (int)DataGroup.Expenses) continue;

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

                    if (ComponentCode == 0) continue;

                    object[] DataRec = (object[])ExpensList[ListCnt];

                    CurRow.Cells[(int)GridColumn.ItemName].Value = string.Format("{0}({1}%)", DataRec[2], CommonMotions.cnvDouble(DataRec[3]).ToString("0.00"));

                    CurRow.Cells[(int)GridColumn.HopePrice].Value = CommonMotions.cnvInt(DataRec[4]).ToString("#,#");

                    CurRow.Cells[(int)GridColumn.ExecPrice].Value = CommonMotions.cnvInt(DataRec[4]).ToString("#,#");

                    CurRow.Cells[(int)GridColumn.Percent].Value = CommonMotions.cnvDouble(DataRec[3]).ToString("0.00");

                    ListCnt++;

                }

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

                    string strDetail = "SELECT A.CONSTRUCTIONCODE, B.GROUPCOUNT, B.LINECOUNT, MIN(B.COLUMNCOUNT), C.PERSONCODE, C.PERSONNAME, C.MONTHLYSALARY, A.SALARYDAYS";

                    strDetail += " GROUP BY A.CONSTRUCTIONCODE, B.GROUPCOUNT, B.LINECOUNT, C.PERSONCODE, C.PERSONNAME, C.MONTHLYSALARY, A.SALARYDAYS";

                        int SALARYDays = CommonMotions.cnvInt(CurRec[7]);

                        if (SALARYDays != 0) AfterDays = SALARYDays;

                    Handle.SubFormHandle.Dispose();

                    Handle.SubFormHandle.Dispose();

using ProcessManagement.Forms.SubForms;

    public partial class FrmLedgerStatus : Form

        /// <summary>

        /// ????m?F???

        /// </summary>

        private FrmPriceOfBudget m_PriceOfBudget = null;

        public FrmLedgerStatus()

        ~FrmLedgerStatus()

            try

            {

                if (m_CloseingProcessOff) return;

                // ????m?F?????\???????????N???[?Y????

                if (m_PriceOfBudget != null)

                {

                    m_PriceOfBudget.Dispose();

                    m_PriceOfBudget = null;

                }

                // ?O?v???Z?X????

                ClsExcute.BackProcess();

            }

            catch (System.Exception ex)

            {

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

            }

        #region ????m?F?{?^??????

        /// <summary>

        /// ????m?F?{?^??????

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void btnLedgerStatus_Click(object sender, EventArgs e)

        {

            // ?t?H?[?????\?????????????O??\???????????

            if (m_PriceOfBudget != null)

            {

                m_PriceOfBudget.Activate();

                return;

            }

            // ?O??\??

            DispPriceOfBudget();

        }

        #endregion

        #region ????m?F???N???[?Y

        /// <summary>

        /// ????m?F????N???[?Y????????

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void FrmPriceOfBudget_FormClosed(object sender, FormClosedEventArgs e)

        {

            try

            {

                this.Activate();

                // ?n???h???N???A

                m_PriceOfBudget.Dispose();

                m_PriceOfBudget = null;

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

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

            DataDisplay();

    partial class FrmLedgerStatus

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

            this.pnlPayroll.Location = new System.Drawing.Point(6, 36);

            // btnLedgerStatus

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

            this.btnLedgerStatus.BackColor = System.Drawing.Color.DodgerBlue;

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

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

            this.btnLedgerStatus.Location = new System.Drawing.Point(1185, 5);

            this.btnLedgerStatus.Name = "btnLedgerStatus";

            this.btnLedgerStatus.Size = new System.Drawing.Size(150, 30);

            this.btnLedgerStatus.TabIndex = 47;

            this.btnLedgerStatus.Text = "未作成台帳確認";

            this.btnLedgerStatus.UseVisualStyleBackColor = false;

            this.btnLedgerStatus.Click += new System.EventHandler(this.btnLedgerStatus_Click);

            // 

            // FrmLedgerStatus

            // 

            this.Controls.Add(this.btnLedgerStatus);

            this.Name = "FrmLedgerStatus";

        private System.Windows.Forms.Button btnLedgerStatus;

using ProcessManagement.Forms.SubForms;

    partial class FrmLedgerStatus

            // ----- ???????m?F???{?^???\???i?o?c?????????????j

            if (CommonMotions.LoginUserData.SecCode == 0)

            {

                int Master = CommonDefine.SystemManageDiv[(int)CommonDefine.SysManaDivNo.PresidentAuthority].Key;

                if (CommonMotions.LoginUserData.SecurityManagement == Master) btnLedgerStatus.Visible = true;

                else btnLedgerStatus.Visible = false;

            }

            else

            {

                int Master = CommonDefine.SecurityRankList[(int)CommonDefine.SecurityRankPos.SpecialAuthority].Key;

                if (CommonMotions.LoginUserSecurity.SecRank == Master) btnLedgerStatus.Visible = true;

                else btnLedgerStatus.Visible = false;

            }

        private void CreateSecuritySQL(ref string strSecurity)

        private void CreateNewSecuritySQL(ref string strSecurity)

            //string strSQL = string.Empty;

                    strSecurity = " And (D.SalesPersonCode IN (Select A1.PersonCode From PersonInChargeMaster A1";

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