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

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

                        var maxSeqNo = Dlist.Max(x => x.seqNo);

                        Dlist[i].AddEdit = 0;

                        dgv1.Rows[i].Cells[(int)DispColumn.seqNo].Value = maxSeqNo + 1;

                    int seqno = (int)dgv1.Rows[e.RowIndex].Cells[(int)DispColumn.seqNo].Value;

                    int maxSeq = Dlist.Max(x => x.seqNo) + 1;

                    if (seqno == maxSeq)

                        && (string.IsNullOrEmpty(Dlist[i].depositAmountCash.ToString()) || Dlist[i].depositAmountCash == 0)

                        && (string.IsNullOrEmpty(Dlist[i].depositAmountBill.ToString()) || Dlist[i].depositAmountBill == 0)

                       )

                    if (string.IsNullOrEmpty(Dlist[i].depositDate) &&

                        (

                          !(string.IsNullOrEmpty(Dlist[i].depositAmountCash.ToString()) || Dlist[i].depositAmountCash == 0)

                           || !(string.IsNullOrEmpty(Dlist[i].depositAmountBill.ToString()) || Dlist[i].depositAmountBill == 0)

                        )

                       )

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

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

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

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

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

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

            this.KB = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.TaxAmount = new System.Windows.Forms.DataGridViewTextBoxColumn();

            // Registration

            // 

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

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

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

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

            this.Registration.Location = new System.Drawing.Point(1071, 585);

            this.Registration.Name = "Registration";

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

            this.Registration.TabIndex = 6;

            this.Registration.Text = "登　録";

            this.Registration.UseVisualStyleBackColor = false;

            this.Registration.Click += new System.EventHandler(this.Registration_Click);

            // 

            // btnEnd

            // 

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

            this.btnEnd.BackColor = System.Drawing.Color.Blue;

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

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

            this.btnEnd.Location = new System.Drawing.Point(1197, 585);

            this.btnEnd.Name = "btnEnd";

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

            this.btnEnd.TabIndex = 7;

            this.btnEnd.Text = "終　了";

            this.btnEnd.UseVisualStyleBackColor = false;

            this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);

            // 

            // lblCellTotal

            // 

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

            this.lblCellTotal.AutoSize = true;

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

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

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

            this.lblCellTotal.Location = new System.Drawing.Point(190, 595);

            this.lblCellTotal.Name = "lblCellTotal";

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

            this.lblCellTotal.TabIndex = 31;

            // 

            // DepositBtn

            // 

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

            this.DepositBtn.BackColor = System.Drawing.Color.Silver;

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

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

            this.DepositBtn.Location = new System.Drawing.Point(856, 585);

            this.DepositBtn.Name = "DepositBtn";

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

            this.DepositBtn.TabIndex = 32;

            this.DepositBtn.Text = "入金入力";

            this.DepositBtn.UseVisualStyleBackColor = false;

            this.DepositBtn.Click += new System.EventHandler(this.DepositBtn_Click);

            // 

            this.KB,

            this.TaxAmount,

            this.dgvMaster.MouseUp += new System.Windows.Forms.MouseEventHandler(this.DataGridView_MouseUp);

            // KB

            // 

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

            this.KB.DefaultCellStyle = dataGridViewCellStyle2;

            this.KB.HeaderText = "行区分";

            this.KB.Name = "KB";

            this.KB.ReadOnly = true;

            this.KB.Resizable = System.Windows.Forms.DataGridViewTriState.False;

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

            this.KB.Visible = false;

            // 

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

            this.No.DefaultCellStyle = dataGridViewCellStyle3;

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

            this.BillPrice.DefaultCellStyle = dataGridViewCellStyle4;

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

            this.TaxPrice.DefaultCellStyle = dataGridViewCellStyle5;

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

            this.DepositAmountCash.DefaultCellStyle = dataGridViewCellStyle6;

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

            this.DepositAmountBill.DefaultCellStyle = dataGridViewCellStyle7;

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

            this.DepositAmount.DefaultCellStyle = dataGridViewCellStyle8;

            this.DepositAmount.HeaderText = "入金金額\r\n（税抜）";

            // TaxAmount

            // 

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

            this.TaxAmount.DefaultCellStyle = dataGridViewCellStyle9;

            this.TaxAmount.HeaderText = "入金金額\r\n（消費税）";

            this.TaxAmount.Name = "TaxAmount";

            this.TaxAmount.ReadOnly = true;

            this.TaxAmount.Resizable = System.Windows.Forms.DataGridViewTriState.False;

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

            this.TaxAmount.Width = 140;

            // 

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

            this.DiscountAmount.DefaultCellStyle = dataGridViewCellStyle10;

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

            this.CnstrPrice.DefaultCellStyle = dataGridViewCellStyle11;

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

            this.Fees.DefaultCellStyle = dataGridViewCellStyle12;

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

            this.OtherAdjustments.DefaultCellStyle = dataGridViewCellStyle13;

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

            this.CarryAmount.DefaultCellStyle = dataGridViewCellStyle14;

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

            this.PersonName.DefaultCellStyle = dataGridViewCellStyle15;

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

            this.NoteDD.DefaultCellStyle = dataGridViewCellStyle16;

            this.Controls.Add(this.DepositBtn);

            this.Controls.Add(this.lblCellTotal);

            this.PerformLayout();

        private System.Windows.Forms.Label lblCellTotal;

        private System.Windows.Forms.Button DepositBtn;

        private System.Windows.Forms.DataGridViewTextBoxColumn KB;

        private System.Windows.Forms.DataGridViewTextBoxColumn TaxAmount;

            KB = 0,                                                             // ■KB

            No,                                                             // No.

            DepositAmount,                                                      // 入金金額（税抜）

            TaxAmount,                                                          // 入金金額（消費税）

            DepositAmount,                                                      // 入金金額（税抜き）

            TaxAmount,                                                          // 入金金額（消費税）

        #region 金額最大最小値

        #endregion

            public long TaxAmount;

                // 入金入力ができる権限以外は入金入力ボタンを非表示

                if (CommonMotions.LoginUserData.DepartmentCode == CommonDefine.s_GeneralAffairsDevision ||

                    m_UserInfo.m_Type == CommonDefine.SecurityRankPos.SpecialAuthority)

                {

                    DepositBtn.Visible = true;

                }

                else

                {

                    DepositBtn.Visible = false;

                }

                //dgvMaster.CellDoubleClick += DataGridView_DoubleCellClick;

                //dgvMaster.CellEnter += DataGridView_CellEnter;

                //dgvMaster.CellValueChanged += DataGridView_CellValueChanged;

        #region 入金入力ボタンクリック時のイベント

        /// <summary>

        /// 入金入力ボタンクリック時のイベント

        /// </summary>

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

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

        private void DepositBtn_Click(object sender, EventArgs e)

        {

            dgvMaster.CellDoubleClick -= DataGridView_DoubleCellClick;

            dgvMaster.CellEnter -= DataGridView_CellEnter;

            dgvMaster.CellValueChanged -= DataGridView_CellValueChanged;

            try

            {

                var cells = dgvMaster.Rows[dgvMaster.CurrentCell.RowIndex].Cells;

                var checkTargetMonth = CommonMotions.cnvInt(cells[(int)DispColumn.RequestMonth].Value);

                // 行インデックスが不正な場合はスルー

                if (dgvMaster.CurrentCell.RowIndex == -1 || checkTargetMonth == 0)

                {

                    return;

                }

                // 入金入力画面の表示

                if (CommonMotions.LoginUserData.DepartmentCode == CommonDefine.s_GeneralAffairsDevision ||

                    m_UserInfo.m_Type == CommonDefine.SecurityRankPos.SpecialAuthority)

                {

                    if (isDirty && MessageBox.Show("データに変更があります、登録せずに入金入力を行いますか？", "終了確認", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)

                    {

                        return;

                    }

                    var orderersDiv = CommonMotions.cnvInt(cells[(int)DispColumn.OrderersDivision].Value);

                    var orderersCode = CommonMotions.cnvInt(cells[(int)DispColumn.OrderersCode].Value);

                    string reqDate = CommonMotions.cnvInt(cells[(int)DispColumn.RequestMonth].Value).ToString();

                    EntryDeposit(orderersDiv, orderersCode, reqDate);

                    return;

                }

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                dgvMaster.CellDoubleClick += DataGridView_DoubleCellClick;

                dgvMaster.CellEnter += DataGridView_CellEnter;

                dgvMaster.CellValueChanged += DataGridView_CellValueChanged;

            }

        }

        #endregion

                            TaxAmount = depositDetail.TaxAmount,

                var cells = dgvMaster.Rows[e.RowIndex].Cells;

                var checkTargetMonth = CommonMotions.cnvInt(cells[(int)DispColumn.RequestMonth].Value);

                if (e.RowIndex == -1 || checkTargetMonth ==0)

                    if (CommonMotions.LoginUserData.DepartmentCode == CommonDefine.s_GeneralAffairsDevision ||

                        if (isDirty && MessageBox.Show("データに変更があります、登録せずに入金入力を行いますか？", "終了確認", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)

                        {

                            return;

                        }

                    if (m_UserInfo.m_Type != CommonDefine.SecurityRankPos.SpecialAuthority)

                        if (CommonMotions.cnvInt(dgvMaster[(int)DispColumn.ConfirmationPersonCode, e.RowIndex].Value) != CommonMotions.LoginUserData.PersonCode)

                        {

                            return;

                        }

                (tcol == (int)DispColumn.TaxAmount) ||

            bool sumDataCheck = false;

                    (e.ColumnIndex == (int)DispColumn.TaxAmount) ||

                    || e.ColumnIndex == (int)DispColumn.TaxAmount

                            sumDataCheck = true;

                        case (int)DispColumn.TaxAmount:

                            depositDetail.TaxAmount = amount;

                            bUpdateCarryAmount = true;

                            sumDataCheck = true;

                            break;

                            sumDataCheck = true;

                            sumDataCheck = true;

                            sumDataCheck = true;

                            sumDataCheck = true;

                            sumDataCheck = true;

                        long DepositAmount = depositDetail.DepositAmount + depositDetail.TaxAmount + depositDetail.DiscountAmount

                //編集したカラムの修正

                UpdateDepositOrdererRows(depositOrderer, e.RowIndex);

                //合計行の修正

                if (sumDataCheck)

                {

                    var sumRowIndex = DetectSumIndex(e.RowIndex);

                    var depositOrdererSum = new DepositOrderer();

                    depositOrdererSum.KB = 3;

                    depositOrdererSum.OrderersCode = depositOrderer.OrderersCode;

                    depositOrdererSum.OrderersDivision = depositOrderer.OrderersDivision;

                    depositOrdererSum.RequestMonth = depositOrderer.RequestMonth;

                    UpdateDepositOrdererRows(depositOrdererSum, sumRowIndex);

                }

            bool sumDataBool = false;

            bool lastSumDataCheck = false;

            int invoiceDataCount = invoiceData.Count();

            int dataCount = 0;

            var oSumV = new DepositOrderer();

            var oEmpty = new DepositOrderer();

                // 最終行確認用

                dataCount = dataCount + 1;

                if (o.KB == 1)

                    // 最終行ではない場合は合計行と空行を挿入する

                    if (invoiceDataCount != dataCount)

                    {

                        if (sumDataBool == true)

                        {

                            // 合計行用のデータを追加

                            data.Add(oSumV);

                            // 空行用のデータを追加

                            data.Add(oEmpty);

                            sumDataBool = false;

                            lastSumDataCheck = false;

                        }

                    }

                    if (sumDataBool == false)

                    {

                        //合計行用データの作成

                        var oSum = new DepositOrderer();

                        var dSum = new Deposit();

                        oSum.KB = 3;

                        oSum.RequestMonth = m_Select_TargetDate;

                        oSum.OrderersCode = CommonMotions.cnvInt(invoice[(int)GetDataFirst.OrderersCode]);

                        oSum.OrderersDivision = CommonMotions.cnvInt(invoice[(int)GetDataFirst.OrderersDivision]);

                        oSum.Deposits = new List<Deposit>();

                        dSum.SeqNo = CommonMotions.cnvInt(invoice[(int)GetDataFirst.SeqNoD]);

                        dSum.DepositDate = CommonMotions.cnvString(invoice[(int)GetDataFirst.DepositDate]);

                        dSum.DepositAmountCash = CommonMotions.cnvLong(invoice[(int)GetDataFirst.DepositAmountCash]);

                        dSum.DepositAmountBill = CommonMotions.cnvLong(invoice[(int)GetDataFirst.DepositAmountBill]);

                        dSum.Note = CommonMotions.cnvString(invoice[(int)GetDataFirst.NoteD]);

                        oSum.Deposits.Add(dSum);

                        oSumV = oSum;

                        //空行用のデータの作成

                        var oEmp = new DepositOrderer();

                        oEmpty.KB = 4;

                        oEmp.RequestMonth = m_Select_TargetDate;

                        oEmp.OrderersCode = CommonMotions.cnvInt(invoice[(int)GetDataFirst.OrderersCode]);

                        oEmp.OrderersDivision = CommonMotions.cnvInt(invoice[(int)GetDataFirst.OrderersDivision]);

                        oEmpty = oEmp;

                        sumDataBool = true;

                        lastSumDataCheck = true;

                    }

                dd.TaxAmount = CommonMotions.cnvLong(invoice[(int)GetDataFirst.TaxAmount]);

                //dd.Visible = CheckPermission(dd.DepartmentCode, dd.ConstructionPersonCode, dd.ConstrSubPersonCode, dd.ConstructionInstructor);

                dd.Visible = true;

                // 最終行かつ最後の請求データに請求書データがない場合に合計行のみ追加する

                if (lastSumDataCheck && invoiceDataCount == dataCount)

                {

                    // 合計行用のデータを追加

                    data.Add(oSumV);

                }

                sql.Append("   , NULL AS TAXAMOUNT ");

                sql.Append("   , DPDE.TAXAMOUNT ");

        #region 入金明細の合計を取得

        /// <summary>

        /// 入金合計を取得

        /// </summary>

        /// <returns></returns>

        private ArrayList DepositDetailSumCalc(int orderersDiv, int orderersCd, int targetDate)

        {

            var ivD = new IODepositData();

            try

            {

                var sql = new StringBuilder();

                sql.Append(" SELECT ");

                sql.Append("   SUM(DEPOSITAMOUNT) ");

                sql.Append("   , SUM(TAXAMOUNT) ");

                sql.Append("   , SUM(DISCOUNTAMOUNT) ");

                sql.Append("   , SUM(CNSTRPRICE) ");

                sql.Append("   , SUM(FEES) ");

                sql.Append("   , SUM(OTHERADJUSTMENTS) ");

                sql.Append("   , SUM(DIFFERENCEAMOUNT) ");

                sql.Append(" FROM ");

                sql.Append("   DEPOSITDATADETAIL ");

                sql.Append(" WHERE ");

                sql.AppendFormat(" ORDERERSDIVISION = {0} ", orderersDiv);

                sql.AppendFormat(" AND ORDERERSCODE = {0} ", orderersCd);

                sql.AppendFormat(" AND TARGETDATE = {0} ", targetDate);

                var data = new ArrayList();

                if (!ivD.ExecuteReader(sql.ToString(), ref data))

                {

                    return new ArrayList();

                }

                return data;

            }

            catch (Exception ex)

            {

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

                return new ArrayList();

            }

            finally

            {

                ivD.close();

                ivD = null;

            }

        }

        #endregion

                    // 表示権限確認

                    var visibleCheck = CheckPermission(depositOrderer);

                    dgvMaster.Rows[position].Visible = visibleCheck;

                    ordererRow.Cells[(int)DispColumn.KB].Style.BackColor = Color.Gainsboro;

                    ordererRow.Cells[(int)DispColumn.KB].Value = depositOrderer.KB;

                    ordererRow.Cells[(int)DispColumn.DepositAmountCash].Style.BackColor = Color.Gainsboro;

                    ordererRow.Cells[(int)DispColumn.DepositAmountBill].Style.BackColor = Color.Gainsboro;

                        row.Cells[(int)DispColumn.TaxAmount].Style.BackColor = Color.Gainsboro;

                        row.Cells[(int)DispColumn.TaxAmount].ReadOnly = true;

                        index++;

                    }

                }

                // 合計行の表示

                else if (depositOrderer.KB == 3)

                {

                    // 表示権限確認

                    var visibleCheck = CheckPermission(depositOrderer);

                    dgvMaster.Rows[position].Visible = visibleCheck;

                    ordererRow.Cells[(int)DispColumn.KB].Value = depositOrderer.KB;

                    ordererRow.Cells[(int)DispColumn.OrderersName].Value = "合計";

                    ordererRow.Cells[(int)DispColumn.RequestMonth].Value = depositOrderer.RequestMonth;

                    ordererRow.Cells[(int)DispColumn.OrderersDivision].Value = depositOrderer.OrderersDivision;

                    ordererRow.Cells[(int)DispColumn.OrderersCode].Value = depositOrderer.OrderersCode;

                    // 入金金額の合計を算出

                    int tgl = 1;

                    var DepositSum = DepositSumCalc(depositOrderer.OrderersDivision, depositOrderer.OrderersCode, depositOrderer.RequestMonth, tgl).OfType<object[]>();

                    int SumDepositAmountCash = 0;

                    int SumDepositAmountBill = 0;

                    foreach (var sum in DepositSum)

                    {

                        SumDepositAmountCash = CommonMotions.cnvInt(sum[0]);

                        SumDepositAmountBill = CommonMotions.cnvInt(sum[1]);

                    }

                    //請求金額合計の合計を算出

                    var RequestSum = RequestSumCalc(depositOrderer.OrderersDivision, depositOrderer.OrderersCode, depositOrderer.RequestMonth, tgl).OfType<object[]>();

                    int SumRequestBill = 0;

                    int SumRequestTax = 0;

                    foreach (var sum in RequestSum)

                    {

                        SumRequestBill = CommonMotions.cnvInt(sum[0]);

                        SumRequestTax = CommonMotions.cnvInt(sum[1]);

                    }

                    SetPrice(ordererRow.Cells, (int)DispColumn.DepositAmountCash, (long)SumDepositAmountCash);

                    SetPrice(ordererRow.Cells, (int)DispColumn.DepositAmountBill, (long)SumDepositAmountBill);

                    // 入金明細金額の合計を算出

                    var DepositDetailSum = DepositDetailSumCalc(depositOrderer.OrderersDivision, depositOrderer.OrderersCode, depositOrderer.RequestMonth).OfType<object[]>();

                    int DepositAmountSum = 0;

                    int TaxAmountSum = 0;

                    int DiscountAmountSum = 0;

                    int CnstrPriceSum = 0;

                    int FeesSum = 0;

                    int OtherAdjustmentsSum = 0;

                    int DifferenceAmountSum = 0;

                    for (int dgvRowCnt = 0; dgvRowCnt < dgvMaster.RowCount; dgvRowCnt++)

                    {

                        // 明細行が明細区分で発注者コードと発注者区分が同一のカラムの計算を行う。

                        if (CommonMotions.cnvInt(dgvMaster.Rows[dgvRowCnt].Cells[(int)DispColumn.KB].Value) == 2

                            && CommonMotions.cnvInt(dgvMaster.Rows[dgvRowCnt].Cells[(int)DispColumn.OrderersDivision].Value) == CommonMotions.cnvInt(ordererRow.Cells[(int)DispColumn.OrderersDivision].Value)

                            && CommonMotions.cnvInt(dgvMaster.Rows[dgvRowCnt].Cells[(int)DispColumn.OrderersCode].Value) == CommonMotions.cnvInt(ordererRow.Cells[(int)DispColumn.OrderersCode].Value))

                            DepositAmountSum += CommonMotions.cnvInt(dgvMaster.Rows[dgvRowCnt].Cells[(int)DispColumn.DepositAmount].Value);

                            TaxAmountSum += CommonMotions.cnvInt(dgvMaster.Rows[dgvRowCnt].Cells[(int)DispColumn.TaxAmount].Value);

                            DiscountAmountSum += CommonMotions.cnvInt(dgvMaster.Rows[dgvRowCnt].Cells[(int)DispColumn.DiscountAmount].Value);

                            CnstrPriceSum += CommonMotions.cnvInt(dgvMaster.Rows[dgvRowCnt].Cells[(int)DispColumn.CnstrPrice].Value);

                            FeesSum += CommonMotions.cnvInt(dgvMaster.Rows[dgvRowCnt].Cells[(int)DispColumn.Fees].Value);

                            OtherAdjustmentsSum += CommonMotions.cnvInt(dgvMaster.Rows[dgvRowCnt].Cells[(int)DispColumn.OtherAdjustments].Value);

                            DifferenceAmountSum += CommonMotions.cnvInt(dgvMaster.Rows[dgvRowCnt].Cells[(int)DispColumn.DifferentAmount].Value);

                    }

                    ordererRow.Cells[(int)DispColumn.No].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.RequestMonth].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.OrderersName].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.DepositAmountCash].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.DepositAmountBill].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.ConstructionCode].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.RequestNo].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.ConstructionName].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.OrderNo].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.TaxPrice].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.BillPrice].Style.BackColor = Color.LightGoldenrodYellow;

                    SetPrice(ordererRow.Cells, (int)DispColumn.BillPrice, SumRequestBill);

                    SetPrice(ordererRow.Cells, (int)DispColumn.TaxPrice, SumRequestTax);

                    ordererRow.Cells[(int)DispColumn.DepositAmount].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.TaxAmount].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.DiscountAmount].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.CnstrPrice].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.Fees].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.OtherAdjustments].Style.BackColor = Color.LightGoldenrodYellow;

                    if (DifferenceAmountSum < 0)

                    {

                        ordererRow.Cells[(int)DispColumn.DifferentAmount].Style.BackColor = Color.Yellow;

                    else

                    {

                        ordererRow.Cells[(int)DispColumn.DifferentAmount].Style.BackColor = Color.LightGoldenrodYellow;

                    }

                    SetPrice(ordererRow.Cells, (int)DispColumn.DepositAmount, DepositAmountSum);

                    SetPrice(ordererRow.Cells, (int)DispColumn.TaxAmount, TaxAmountSum);

                    SetPrice(ordererRow.Cells, (int)DispColumn.DiscountAmount, DiscountAmountSum);

                    SetPrice(ordererRow.Cells, (int)DispColumn.CnstrPrice, CnstrPriceSum);

                    SetPrice(ordererRow.Cells, (int)DispColumn.Fees, FeesSum);

                    SetPrice(ordererRow.Cells, (int)DispColumn.OtherAdjustments, OtherAdjustmentsSum);

                    SetPrice(ordererRow.Cells, (int)DispColumn.DifferentAmount, DifferenceAmountSum);

                    ordererRow.Cells[(int)DispColumn.DepositAmount].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.TaxAmount].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.DiscountAmount].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.CnstrPrice].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.Fees].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.OtherAdjustments].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.NoteDD].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.ConfirmationPersonCode].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.ConfirmationDate].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.ConfirmationEndFlg].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.ConstructionPersonCode].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.ConstrSubPersonCode].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.ConstructionInstructor].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.DepartmentCode].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.PersonName].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.NoteDD].Style.BackColor = Color.LightGoldenrodYellow;

                // 空行を追加

                else if (depositOrderer.KB == 4)

                {

                    // 表示権限確認

                    var visibleCheck = CheckPermission(depositOrderer);

                    dgvMaster.Rows[position].Visible = visibleCheck;

                    ordererRow.Cells[(int)DispColumn.KB].Value = depositOrderer.KB;

                    ordererRow.Cells[(int)DispColumn.RequestMonth].Value = depositOrderer.RequestMonth;

                    ordererRow.Cells[(int)DispColumn.OrderersDivision].Value = depositOrderer.OrderersDivision;

                    ordererRow.Cells[(int)DispColumn.OrderersCode].Value = depositOrderer.OrderersCode;

                    ordererRow.Cells[(int)DispColumn.No].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.RequestMonth].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.OrderersName].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.DepositAmountCash].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.DepositAmountBill].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.ConstructionCode].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.RequestNo].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.ConstructionName].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.OrderNo].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.TaxPrice].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.BillPrice].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.DepositAmount].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.TaxAmount].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.DiscountAmount].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.CnstrPrice].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.Fees].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.OtherAdjustments].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.DifferentAmount].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.DepositAmount].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.TaxAmount].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.DiscountAmount].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.CnstrPrice].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.Fees].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.OtherAdjustments].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.NoteDD].ReadOnly = true;

                    ordererRow.Cells[(int)DispColumn.ConfirmationPersonCode].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.ConfirmationDate].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.ConfirmationEndFlg].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.ConstructionPersonCode].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.ConstrSubPersonCode].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.ConstructionInstructor].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.DepartmentCode].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.PersonName].Style.BackColor = Color.White;

                    ordererRow.Cells[(int)DispColumn.NoteDD].Style.BackColor = Color.White;

                }

                // 明細行の表示

                    // 表示権限のチェックを行う

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

                        m_UserInfo.m_Type != CommonDefine.SecurityRankPos.SpecialAuthority)

                    {

                        var visibleCheck = CheckDepositDetailPermission(depositOrderer);

                        dgvMaster.Rows[position].Visible = visibleCheck;

                    }

                    ordererRow.Cells[(int)DispColumn.KB].Value = depositOrderer.KB;

                        SetPrice(row.Cells, (int)DispColumn.TaxAmount, depositDetail.TaxAmount);

                        row.Cells[(int)DispColumn.TaxAmount].Style.BackColor = Color.LightCyan;

                        long DepositAmount = depositDetail.DepositAmount + depositDetail.TaxAmount + depositDetail.DiscountAmount

                            row.Cells[(int)DispColumn.TaxAmount].ReadOnly = false;

                            row.Cells[(int)DispColumn.TaxAmount].ReadOnly = true;

        #region 指定行から合計行を検索

        /// <summary>

        /// 指定行から合計行を検索

        /// </summary>

        /// <param name="index"></param>

        /// <returns></returns>

        private int DetectSumIndex(int index)

        {

            for (var i = index; i >= 0; i++)

            {

                if (CommonMotions.cnvInt(dgvMaster.Rows[i].Cells[(int)DispColumn.KB].Value) == 3)

                {

                    return i;

                }

            }

            return 0;

        }

        #endregion

                0,                      // KB

                2,                      // 入金金額（税抜）

                2,                      // 入金金額（消費税）

        #region 請求行の表示権限のチェックを実施する。

        /// 請求行の表示権限のチェックを実施する。

        private bool CheckDepositDetailPermission(DepositOrderer depositOrderer)

            var ioCbi = new IOConstructionBaseInfo();

            var SalesDepCodeData = 0;

            var SalesPersonCodeData = 0;

            var SalesSubDepCodeData = 0;

            var SalesSubPersonCodeData = 0;

            var ConstrDepCodeData = 0;

            var ConstructionPersonCodeData = 0;

            var ConstrSubDepCodeData = 0;

            var ConstrSubPersonCodeData = 0;

            var ConstrInstrDepCodeData = 0;

            var ConstructionInstructorData = 0;

            try

            {

                var doDepDetails = depositOrderer.VisibleDepositDetails;

                var data = new ArrayList();

                var sql = new StringBuilder();

                sql.Append(" SELECT ");

                sql.Append(" SALESDEPCODE ");

                sql.Append(" , SALESPERSONCODE ");

                sql.Append(" , SALESSUBDEPCODE ");

                sql.Append(" , SALESSUBPERSONCODE ");

                sql.Append(" , CONSTRDEPCODE ");

                sql.Append(" , CONSTRUCTIONPERSONCODE ");

                sql.Append(" , CONSTRSUBDEPCODE ");

                sql.Append(" , CONSTRSUBPERSONCODE ");

                sql.Append(" , CONSTRINSTRDEPCODE ");

                sql.Append(" , CONSTRUCTIONINSTRUCTOR ");

                sql.Append(" FROM CONSTRUCTIONBASEINFO ");

                sql.AppendFormat(" WHERE CONSTRUCTIONCODE  = {0}; ", doDepDetails[0].ConstructionCode);

                if (!ioCbi.ExecuteReader(sql.ToString(), ref data))

                {

                    return false;

                }

                foreach (object[] work in data)

                {

                    SalesDepCodeData = CommonMotions.cnvInt(work[0]);

                    SalesPersonCodeData = CommonMotions.cnvInt(work[1]);

                    SalesSubDepCodeData = CommonMotions.cnvInt(work[2]);

                    SalesSubPersonCodeData = CommonMotions.cnvInt(work[3]);

                    ConstrDepCodeData = CommonMotions.cnvInt(work[4]);

                    ConstructionPersonCodeData = CommonMotions.cnvInt(work[5]);

                    ConstrSubDepCodeData = CommonMotions.cnvInt(work[6]);

                    ConstrSubPersonCodeData = CommonMotions.cnvInt(work[7]);

                    ConstrInstrDepCodeData = CommonMotions.cnvInt(work[8]);

                    ConstructionInstructorData = CommonMotions.cnvInt(work[9]);

                }

                // 特別権限と総務は表示

                if (CommonMotions.LoginUserData.DepartmentCode == CommonDefine.s_GeneralAffairsDevision ||

                        m_UserInfo.m_Type == CommonDefine.SecurityRankPos.SpecialAuthority)

                {

                    return true;

                }

                // 複数部署対象、または自部署のみ対象

                else if ((m_UserInfo.m_SecRange == ClsSecurityPermission.SecRangeType.MultiDepartment) || 

                    (m_UserInfo.m_SecRange == ClsSecurityPermission.SecRangeType.OneDepartment))

                {

                    if (CommonMotions.LoginUserData.DepartmentCode == SalesDepCodeData ||

                        CommonMotions.LoginUserData.DepartmentCode == SalesSubDepCodeData ||

                        CommonMotions.LoginUserData.DepartmentCode == ConstrDepCodeData ||

                        CommonMotions.LoginUserData.DepartmentCode == ConstrSubDepCodeData ||

                        CommonMotions.LoginUserData.DepartmentCode == ConstrInstrDepCodeData)

                    {

                        return true;

                    }

                }

                // 自分の担当の場合は表示

                else if(CommonMotions.LoginUserData.PersonCode == SalesPersonCodeData ||

                    CommonMotions.LoginUserData.PersonCode == SalesSubPersonCodeData ||

                    CommonMotions.LoginUserData.PersonCode == ConstructionPersonCodeData ||

                CommonMotions.LoginUserData.PersonCode == ConstrSubPersonCodeData ||

                CommonMotions.LoginUserData.PersonCode == ConstructionInstructorData)

                {

                    return true;

                }

                return false;

            }