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

        public static int s_SystemVersion = 139;

        public static int GetLedgerColumnCount()

                return (Enum.GetNames(typeof(FrmConstructionLedger.GridColumn)).Length - 1);

                return 0;

            int Columncnt = GetLedgerColumnCount();

                if (ExcuteRec.ConstructionCode == 0) return true;

                if (ExcuteRec.GroupCount == 0) return true;

                // ----- 明細文字をセットする

                if (!DetailDB.UpdateFeild(DetailRec.ConstructionCode,

                                            (int)IOConstructionLedgerDetail.TableColumn.SecondString,

                                            DetailRec.SecondString,

                                            DetailRec.GroupCount,

                                            DetailRec.LineCount,

                                            false))

                {

                    return false;

                }

                if (CurrentPara.BoolExecParameter.Count > 0) frm.ReqSumDspFlag = CurrentPara.BoolExecParameter[0];

        private int         m_CompanyCode = 0;                      // 協力会社コード

        private int         m_TargetDate = 0;                       // 対象年月     

        private int         m_SeqNo = 0;                            // 連番

        private int         m_LineCount = 0;                        // 行番号    

        private long        m_BillPrice = 0;                        // 請求金額    

        private long        m_DiscountPrice = 0;                    // 値引き金額    

        private long        m_OffsetPrice = 0;                      // 相殺金額    

        private long        m_NextCoPrice = 0;                      // 次回繰越    

        private long        m_HighwPrice = 0;                       // 高速代     

        private long        m_HardwPrice = 0;                       // 金物代     

        private long        m_IndsWasteTax = 0;                     // 産廃税       

        private long        m_CnstrPrice = 0;                       // 協力金

        private int         m_CnstrPriceExist = -1;                 // 協力金有無

        private int         m_ApprovalPersonCode = 0;               // 承認担当者コード

        private DateTime    m_ApprovalDate = DateTime.MinValue;     // 担当者承認日付

        private int         m_ApprovalEndFlg = 0;                   // 承認完了フラグ

        private DateTime    m_EntryDate = DateTime.Now;             // 登録日付

        private DateTime    m_UpdateDate = DateTime.Now;            // 更新日付

                        strActionSQL.AppendFormat(" APPROVALDATE = STR_TO_DATE('{0}','%Y/%m/%d')", DateTime.Now.ToShortDateString());

            // ?I?????\???`?F?b?N

            if (txtHoppesDate.Enabled)

            {

                DialogResult dtRet = MessageBox.Show("?\?????????????A?I??????????H"

                                                        , "?I???m?F"

                                                        , MessageBoxButtons.OKCancel

                                                        , MessageBoxIcon.Question);

                if (dtRet == DialogResult.Cancel) return;

            }

            // ?I?????\???`?F?b?N

            if (txtHoppesDate.Enabled)

            {

                DialogResult dtRet = MessageBox.Show("?\?????????????A?I??????????H"

                                                        , "?I???m?F"

                                                        , MessageBoxButtons.OKCancel

                                                        , MessageBoxIcon.Question);

                if (dtRet == DialogResult.Cancel) return;

            }

        /// ????????I???g?p???t???O

        private bool m_ReqSumSelFlag = false;

        /// ????????\?????t???O

        private bool m_ReqSumDspFlag = false;

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

        private int m_ReqSumTargetMonth = 0;

        /// <summary>

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

        /// </summary>

        private int m_ReqSumCompany = 0;

        /// ??????

        private int m_TargetDetailNo = -1;

        /// <summary>

        /// ??????J??????u

        /// </summary>

        private int m_TargetColumn = 0;

        /// <summary>

        /// ?????????A?g???z

        /// </summary>

        private int m_AddingRequestPrice = 0;

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

        private List<BillingDataDetail> m_BillDetailList = new List<BillingDataDetail>();

        /// ????????I???g?p???t???O

        public bool ReqSumSelFlag

            get { return m_ReqSumSelFlag; }

            set { m_ReqSumSelFlag = value; }

        /// ????????\?????t???O

        public bool ReqSumDspFlag

            get { return m_ReqSumDspFlag; }

            set { m_ReqSumDspFlag = value; }

        /// <summary>

        /// ??????

        /// </summary>

        public int TargetDetailNo

        {

            get { return m_TargetDetailNo; }

            set { m_TargetDetailNo = value; }

        }

        /// <summary>

        /// ??????J??????u

        /// </summary>

        public int TargetColumn

        {

            get { return m_TargetColumn; }

            set { m_TargetColumn = value; }

        }

        /// <summary>

        /// ?????????A?g???z

        /// </summary>

        public int AddingRequestPrice

        {

            get { return m_AddingRequestPrice; }

            set { m_AddingRequestPrice = value; }

        }

        /// <summary>

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

        /// </summary>

        public List<BillingDataDetail> BillDetailList

        {

            get { return m_BillDetailList; }

            set { m_BillDetailList = value; }

        }

                if (m_ReqSumSelFlag)

            if (m_ReqSumSelFlag)

                EventArgs wkE = new EventArgs();

                btnSelect_Click(sender, wkE);

        #region ?x?????V?K????{?^??????

        /// <summary>

        /// ?x?????V?K????{?^??????

        /// </summary>

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

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

        private void btnCreate_Click(object sender, EventArgs e)

        {

            // ?V?K??????

            if (!ReqSumNewMakeOutPut()) return;

            this.Close();

        }

        #endregion

        #region ?x?????I???{?^??????

        /// <summary>

        /// ?x?????I???{?^??????

        /// </summary>

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

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

        private void btnSelect_Click(object sender, EventArgs e)

        {

            // ?I???s?Z?b?g

            if (!ReqSumSelectOutPut()) return;

            this.Close();

        }

        #endregion

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.dgvAllDisplay.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle8;

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

            this.Column1.DefaultCellStyle = dataGridViewCellStyle9;

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

            this.Column5.DefaultCellStyle = dataGridViewCellStyle10;

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

            this.Column6.DefaultCellStyle = dataGridViewCellStyle11;

            dataGridViewCellStyle12.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;

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

            dataGridViewCellStyle12.Format = "N0";

            dataGridViewCellStyle12.NullValue = null;

            this.Column7.DefaultCellStyle = dataGridViewCellStyle12;

            dataGridViewCellStyle13.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;

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

            this.Column12.DefaultCellStyle = dataGridViewCellStyle13;

            dataGridViewCellStyle14.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleRight;

            this.Column9.DefaultCellStyle = dataGridViewCellStyle14;

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

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

  <metadata name="lblCellTotal.Locked" type="System.Boolean, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">

    <value>True</value>

  </metadata>

                    if (m_ReqSumSelFlag)

        #region 行追加が可能な位置かを判定し、行番号をセットする

        /// 行追加が可能な位置かを判定し、行番号をセットする

        private bool CheckNewMakeRow(ref int InsertCnt)

                bool bRet = false;

                InsertCnt = 0;

                    bRet = true;

                {

                    // 空白行で施工費のすぐ後は対象とする

                    if (CommonMotions.cnvInt(wrkRow.Cells[(int)GridColumn.GroupCount].Value) == (int)DataGroup.ConstructionCosts)

                        bRet = true;

                return bRet;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 行を追加する

        /// <summary>

        /// 行を追加する

        /// </summary>

        private void AddLineData()

        {

            try

            {

                DataGridView dgv = dgvAllDisplay;

                DataGridViewRow CurRow = dgv.CurrentRow;

                // 追加できるかの判定

                int InsertCnt = 0;

                if(!CheckNewMakeRow(ref InsertCnt)) return;

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

                // 請求まとめ選択時

                if (m_ReqSumSelFlag)

                {

                    // 協力業者セット

                    SetCompanyData(SetData);

                }

        #region 請求まとめ行選択処理

        /// 請求まとめ行選択処理

        private bool ReqSumSelectOutPut()

                m_TargetDetailNo = -1;

                m_TargetColumn = 0;

                DataGridViewRow CurRow = dgv.CurrentRow;

                // 施工費以外の選択は処理しない

                if (CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.GroupCount].Value) != (int)DataGroup.ConstructionCosts)

                    return false;

                // 選択業者と同じかのチェック

                if (m_ReqSumCompany != CommonMotions.cnvInt(CurRow.Cells[(int)GridColumn.CompanyCode].Value))

                {

                    MessageBox.Show("選択された業者が違います。", "業者選択エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                // 行セット

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

                // 列セット

                DateTime dtStWork = CommonMotions.cnvDate(m_DspLabelCtrl[(int)DspLblCtrlName.StartingDate].Text);

                DateTime dtTarGetWork = new DateTime((m_ReqSumTargetMonth / 100), (m_ReqSumTargetMonth % 100), 1);

                m_TargetColumn = ClsChangeLedgerData.CalcTargetMonthToColumn(dtStWork, dtTarGetWork);

                return true;

                return false;

        #region 請求まとめ行新規作成処理

        /// <summary>

        /// 請求まとめ行新規作成処理

        /// </summary>

        private bool ReqSumNewMakeOutPut()

        {

            try

            {

                // 追加判定

                int nWkCnt = 0;

                if (!CheckNewMakeRow(ref nWkCnt)) return false;

                DialogResult dtRet = MessageBox.Show("工事台帳に新規で協力会社を追加します。",

                                                        "追加確認",

                                                        MessageBoxButtons.OKCancel,

                                                        MessageBoxIcon.Exclamation);

                if (dtRet == DialogResult.Cancel) return true;

                // 行を追加する（返信パラメタ行・列もセットする）

                AddLineData();

                // 行色変更

                SelectRowChangeColor(m_BeforeGridRow);

                // 台帳保存

                if (!DataEntryProcess()) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 協力会社名セット

        /// <summary>

        /// 協力会社名セット

        /// </summary>

        /// <param name="SetRow"></param>

        private void SetCompanyData(DataGridViewRow SetRow)

        {

            IOMSubContractor CompDB = new IOMSubContractor();

            try

            {

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(CompDB.CreatePrimarykeyString(m_ReqSumCompany));

                SubContractorMaster CompRec = new SubContractorMaster();

                if (!CompDB.SelectAction(strSQL.ToString(), ref CompRec)) return;

                SetRow.Cells[(int)GridColumn.CompanyType].Value = (int)CommonDefine.CodeDataType.Subconstractor;

                SetRow.Cells[(int)GridColumn.CompanyCode].Value = CompRec.CompanyCode;

                SetRow.Cells[(int)GridColumn.CompanyName].Value = CompRec.CompanyName;

                // ----- 行・列番号セット

                // 行セット

                m_TargetDetailNo = CommonMotions.cnvInt(SetRow.Cells[(int)GridColumn.DetailNo].Value);

                // 列セット

                DateTime dtStWork = CommonMotions.cnvDate(m_DspLabelCtrl[(int)DspLblCtrlName.StartingDate].Text);

                DateTime dtTarGetWork = new DateTime((m_ReqSumTargetMonth / 100), (m_ReqSumTargetMonth % 100), 1);

                m_TargetColumn = ClsChangeLedgerData.CalcTargetMonthToColumn(dtStWork, dtTarGetWork);

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                CompDB.close(); CompDB = null;

            }

        }

        #endregion

                if (!m_ReqSumSelFlag) return;

                label4.Visible = false;

                m_DspLabelCtrl[(int)DspLblCtrlName.CreateDate].Visible = false;

                if (nCompanyCode == m_ReqSumCompany)

                    clrBack = lblReqSumType01.BackColor;

                    clrFore = lblReqSumType01.ForeColor;

                    foreach (BillingDataDetail DataCurRec in m_BillDetailList)

                    {

                        if (nCompanyCode == DataCurRec.CompanyCode)

                        {   // 対象業者一致

                            if (nDetailNo == DataCurRec.ConstructionRowCnt)

                            {   // 対象行の一致

                                clrBack = lblReqSumType02.BackColor;

                                clrFore = lblReqSumType02.ForeColor;

                                break;

                            }

                            else

                            {      // 行が一致しない

                                clrBack = lblReqSumType01.BackColor;

                                clrFore = lblReqSumType01.ForeColor;

                            }

                    string Attendee = CommonMotions.cnvString(wrkRow.Cells[(int)DispGridColumn4.Attendee].Value).Replace("'", "’");

                    string ContentsText = CommonMotions.cnvString(wrkRow.Cells[(int)DispGridColumn4.ContentsText].Value).Replace("'", "’");

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

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

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

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

            // btnPrint

            // 

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

            this.btnPrint.BackColor = System.Drawing.Color.DarkSeaGreen;

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

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

            this.btnPrint.Location = new System.Drawing.Point(920, 655);

            this.btnPrint.Name = "btnPrint";

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

            this.btnPrint.TabIndex = 19;

            this.btnPrint.Text = "印　刷";

            this.btnPrint.UseVisualStyleBackColor = false;

            this.btnPrint.Click += new System.EventHandler(this.btnPrint_Click);

            // 

            // btnCancel

            // 

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

            this.btnCancel.BackColor = System.Drawing.Color.Red;

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

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

            this.btnCancel.Location = new System.Drawing.Point(1048, 655);

            this.btnCancel.Name = "btnCancel";

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

            this.btnCancel.TabIndex = 20;

            this.btnCancel.Text = "印刷中止";

            this.btnCancel.UseVisualStyleBackColor = false;

            this.btnCancel.Visible = false;

            this.btnCancel.Click += new System.EventHandler(this.btnCancel_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(8, 655);

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

            // 

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

                StringBuilder sql = new StringBuilder();

                sql.Append(ioExcute.CreatePrimarykeyString(m_nLeaderConstructionCode));

                sql.AppendFormat(" AND ColumnCount = {0}", ClsChangeLedgerData.GetLedgerColumnCount());

                ConstructionLedgerExcute lstExcute = new ConstructionLedgerExcute();

                if (!ioExcute.SelectAction(sql.ToString(), ref lstExcute)) return tcol;

                tcol = ClsChangeLedgerData.CalcTargetMonthToColumn(lstExcute.TargetMonth, dtTarget);

                SetApprovalInitParametar(ref DepCode, ref PersonCode);

                    case (int)DispColumn.DetailName:    // ????????

                    case (int)DispColumn.Bikou:         // ?R?????g

                    case (int)DispColumn.DetailName:    // ????????

                    case (int)DispColumn.Bikou:         // ?R?????g

                        // ?l??`?F?b?N?i?????????X?t???O??ON???????j

                        string sCurVal = CommonMotions.cnvString(CurRow.Cells[e.ColumnIndex].Value);

                        if (CommonMotions.cnvString(m_BeforeValue) == sCurVal) return;

                        break;

                        int nCurVal = CommonMotions.cnvInt(CurRow.Cells[e.ColumnIndex].Value);

                        // ?l??`?F?b?N?i?????????X?t???O??ON???????j

                        if (CommonMotions.cnvInt(m_BeforeValue) == nCurVal) return;

                // ?x???????????????????l???\???S????

                switch (e.ColumnIndex)

                {

                    case (int)DispColumn.KojiSeikyu:

                    case (int)DispColumn.KojiNebiki:

                    case (int)DispColumn.KojiSousai:

                    case (int)DispColumn.KojiKosoku:

                    case (int)DispColumn.KojiKanamono:

                    case (int)DispColumn.KyoryokuUmu:

                        // ?\???O???????S????????Z?b?g????

                        if (CommonMotions.cnvDate(CurRow.Cells[(int)DispColumn.RowType].Value) == DateTime.MinValue.Date)

                        {

                            CurRow.Cells[(int)DispColumn.TantoShoninCode].Value = CommonMotions.LoginUserData.PersonCode;   // ?\???S????

                            CurRow.Cells[(int)DispColumn.TantoShonin].Value = CommonMotions.LoginUserData.PersonName;       // ?\???S?????

                        }

                        break;

                    default:

                        break;

                }

            try

            {

                // ????J??????O??????????

                if (e.ColumnIndex != (int)DispColumn.DetailName && e.ColumnIndex < (int)DispColumn.SomuSeikyu) return;

                if ((int)DispColumn.KyoryokuUmu <= e.ColumnIndex) return;