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

                        //CaretaBillingLedgerData();

            this.label7.Text = "提　出　日";

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

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

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

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

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

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

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

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

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

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

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

            this.dgvMaster.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;

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

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

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

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

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

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

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

            this.dgvMaster.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2;

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

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

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

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

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

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

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

            this.dgvMaster.DefaultCellStyle = dataGridViewCellStyle13;

            // btnHelp

            // 

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

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

            this.btnHelp.Font = new System.Drawing.Font("MS UI Gothic", 18F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

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

            this.btnHelp.Location = new System.Drawing.Point(1249, 0);

            this.btnHelp.Name = "btnHelp";

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

            this.btnHelp.TabIndex = 116;

            this.btnHelp.TabStop = false;

            this.btnHelp.Text = "？";

            this.btnHelp.UseVisualStyleBackColor = false;

            this.btnHelp.Click += new System.EventHandler(this.btnHelp_Click);

            // 

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

            this.Column1.DefaultCellStyle = dataGridViewCellStyle3;

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

            this.Column12.DefaultCellStyle = dataGridViewCellStyle4;

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

            dataGridViewCellStyle5.Font = new System.Drawing.Font("Century", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.Column8.DefaultCellStyle = dataGridViewCellStyle5;

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

            this.Column10.DefaultCellStyle = dataGridViewCellStyle6;

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

            this.Column6.DefaultCellStyle = dataGridViewCellStyle7;

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

            this.Column4.DefaultCellStyle = dataGridViewCellStyle8;

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

            dataGridViewCellStyle9.Font = new System.Drawing.Font("Century", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.Column3.DefaultCellStyle = dataGridViewCellStyle9;

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

            this.Column2.DefaultCellStyle = dataGridViewCellStyle10;

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

            dataGridViewCellStyle11.Font = new System.Drawing.Font("Century", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.Column9.DefaultCellStyle = dataGridViewCellStyle11;

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

            dataGridViewCellStyle12.Font = new System.Drawing.Font("Century", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            this.Column5.DefaultCellStyle = dataGridViewCellStyle12;

            this.Column5.HeaderText = "提　出　日";

        private System.Windows.Forms.Button btnHelp;

            m_bDirty = true;

                //if (lTotal > 0) return true;

                //// 請求金額０以下はエラー

                //for (int i = ((int)HeaderRowIndex.BillingDate + 1); i < dgv.RowCount; i++)

                //{

                //    DataGridViewRow CurRow = dgv.Rows[i];

                //    int nDgvKind = CommonMotions.cnvInt(CurRow.Cells[(int)ColumnName1.DgvKind].Value);

                //    if (nDgvKind == (int)dgvKind.Header || nDgvKind == (int)dgvKind.Footer) continue;

                //    CurRow.Cells[nCol].Style.BackColor = Color.Red;

                //}

                //ShowMessageBox("請求金額を入力してください。", "入力エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                //return false;

                return true;

                        //lAmount = 0;

                        //for (int i = 0; i < m_nMaxOrderNo; i++)

                        //{

                        //    Dictionary<int, List<RequestDataDetail>> dic = m_lstRequestDataDetail[i];

                        //    if (dic.TryGetValue(ReqDetail.ConstructionCode, out List<RequestDataDetail> wrklst))

                        //    {

                        //        if (dic == null) break;

                        //        lAmount += wrklst.Sum(y => y.TaxAmount);

                        //    }

                        //}

                        //if (lAmount == 0)

            IOConstructionLedgerExcute ioLedger = new IOConstructionLedgerExcute();

            ioLedger.connect(); ioLedger.beginTran();

             RequestHead ReqHead = m_lstRequestHead[m_nMaxOrderNo - 1];

                // 台帳金額加算

                if(!UpdateLedger(ioLedger, ioReqHead))

                {

                    MessageBox.Show("工事台帳更新エラー"

                                    , "登録エラー"

                                    , MessageBoxButtons.OK

                                    , MessageBoxIcon.Error);

                    bRet = false;

                    return bRet;

                }

                ioLedger.commit();

                    ioLedger.rollback();

                ioLedger.close(); ioLedger = null;

        #region 工事台帳更新処理

        /// <summary>

        /// 工事台帳更新処理

        /// </summary>

        /// <param name="ioLedger"></param>

        /// <returns></returns>

        private bool UpdateLedger(IOConstructionLedgerExcute ioLedger, IORequestHead ioReqHead)

        {

            try

            {

                int tcol = m_nMaxOrderNo + (int)ColumnName1.Sum;

                DateTime dtRequest = CommonMotions.cnvDate(dgv1.Rows[(int)HeaderRowIndex.BillingDate].Cells[tcol].Value);

                int ColPoint = ClsChangeLedgerData.CalcTargetMonthToColumn(ioLedger, false, m_ConstructionCode, dtRequest);

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(ioLedger.CreatePrimarykeyString(m_ConstructionCode

                                                                , (int)FrmConstructionLedger.DataGroup.BillingAmount

                                                                , 0

                                                                , ColPoint));

                // 対象データ削除

                ioLedger.DeleteAction(strSQL.ToString(), false);

                // 請求金額取得

                strSQL.Clear();

                strSQL.Append("Select");

                strSQL.Append(" SUM(REQUESTAMOUNT)");

                strSQL.Append(" From REQUESTHEAD");

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

                strSQL.AppendFormat(" And REQUESTMONTH = {0}{1}", dtRequest.Year, dtRequest.Month.ToString("00"));

                ArrayList ReqData = new ArrayList();

                if (!ioReqHead.ExecuteReader(strSQL.ToString(), ref ReqData, false)) return false;

                if (ReqData.Count < 1) return false;

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

                long lValue = CommonMotions.cnvLong(objRec[0]);

                if (lValue == 0) return true;

                ConstructionLedgerExcute DataRec = new ConstructionLedgerExcute();

                DataRec.ConstructionCode = m_ConstructionCode;

                DataRec.GroupCount = (int)FrmConstructionLedger.DataGroup.BillingAmount;

                //DataRec.LineCount

                DataRec.ColumnCount = ColPoint;

                DataRec.PaymentAmount = lValue;

                DataRec.TargetMonth = dtRequest.BeginOfMonth();

                if (!ioLedger.InsertAction(DataRec, false)) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

                //m_bDirty = CheckDataExists();

                // データ保存

                if (!AcceptData()) return false;