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

            this.label1.Name = "label1";

            this.label1.Size = new System.Drawing.Size(400, 20);

            this.label1.TabIndex = 6;

            this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // btnDataUpDate

            this.Column7.HeaderText = "工　事　名　称";

            this.Column7.Name = "Column7";

            this.Column7.ReadOnly = true;

            // 

            // Column3

            // 

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

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

            this.Column5.DefaultCellStyle = dataGridViewCellStyle8;

            this.Column5.Name = "Column5";

            this.Column5.ReadOnly = true;

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

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

            // 

            // FrmReqApprovalStatus

            // 

                strSQL.Append(", J.DetailString");

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

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

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

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

                strSQL.Append(" From");

                strSQL.Append("  , MIN(ConstructionStatusFlg) AS ConstructionStatusFlg");

                strSQL.Append("  , SUM(OrdersDecisionPrice) AS OrdersDecisionPrice");

                strSQL.Append("  FROM");

                strSQL.Append("  GROUP BY");

                strSQL.Append("  TRUNCATE(ConstructionCode / 100, 0)");

                strSQL.Append("  ) AS B");

                strSQL.Append(" ON B.CONSTRUCTIONCODE = E.CONSTRUCTIONCODE");

                strSQL.Append(" WHERE");

                // ???????I???????????

                strSQL.Append(GetDepartmentString());

                    SetToGridData(arData);

                }

            }

            catch (Exception ex)

            {

        {

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

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = 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 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();

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.dgvMaster.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {

            this.Column1,

            this.Column12,

            this.Column10,

            this.Column6,

            this.Column4,

            this.Column3,

            this.Column2,

            this.Column9,

            this.Column5,

            this.Column13,

            this.Column11});

            this.dgvMaster.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;

            this.dgvMaster.EnableHeadersVisualStyles = false;

            this.dgvMaster.Location = new System.Drawing.Point(8, 101);

            this.dgvMaster.Name = "dgvMaster";

            this.dgvMaster.RowHeadersVisible = false;

            this.dgvMaster.RowHeadersWidth = 20;

            this.dgvMaster.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing;

            // 

            // Column12

            // 

            this.Column12.HeaderText = "請求月";

            this.Column12.Name = "Column12";

            this.Column12.Width = 120;

            // 

            // Column10

            // 

            this.Column10.HeaderText = "部　　署";

            this.Column10.Name = "Column10";

            this.Column10.ReadOnly = true;

            // 

            // Column6

            // 

            this.Column6.HeaderText = "担　当　者";

            this.Column6.Name = "Column6";

            this.Column6.ReadOnly = true;

            // 

            // Column4

            // 

            this.Column4.HeaderText = "宛　名";

            this.Column4.Name = "Column4";

            this.Column4.ReadOnly = true;

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

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

            // 

            // Column7

            // 

            this.Column7.HeaderText = "工　事　名";

            this.Column7.Name = "Column7";

            this.Column7.ReadOnly = true;

            this.Column7.Visible = false;

            this.Column7.Width = 390;

            // 

            // Column3

            // 

            this.Column3.HeaderText = "請求金額";

            this.Column3.Name = "Column3";

            this.Column3.ReadOnly = true;

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

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

            // 

            // Column2

            // 

            this.Column2.HeaderText = "工事コード";

            this.Column2.Name = "Column2";

            this.Column2.ReadOnly = true;

            // 

            // Column9

            // 

            this.Column9.HeaderText = "請求承認日";

            this.Column9.Name = "Column9";

            this.Column9.ReadOnly = true;

            this.Column9.Visible = false;

            this.Column9.Width = 140;

            // 

            // Column5

            // 

            this.Column5.HeaderText = "郵　送　日";

            this.Column5.Name = "Column5";

            this.Column5.ReadOnly = true;

            this.Column11.HeaderText = "請求書番号";

            this.Column11.Name = "Column11";

            this.Column11.ReadOnly = true;

            this.Column11.Visible = false;

            this.Column11.Width = 160;

            // 

        private System.Windows.Forms.Label lblCellTotal;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column1;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column12;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column10;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column6;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column4;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column3;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column2;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column9;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column5;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column13;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column11;

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

    <value>True</value>

  </metadata>

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

    <value>True</value>

  </metadata>

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

    <value>True</value>

  </metadata>

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

    <value>True</value>

  </metadata>

                strSQL.Append(wrkBuff.ToString());

                // ORDER BY ???

                strSQL.Append(", H.INVOICENO DESC");

            }

            catch (Exception ex)

            {

                string strDspNo = string.Empty;

                string strOrderMonth = string.Empty;

                string strRequestAmount = string.Empty;

                int BreakConstrCode = 0;

                int OrderNo = 1;

                int RequestAmount = 0;

                    objwrk = (object[])arData[iy];

                    strOrderName = CommonMotions.cnvString(objwrk[(int)GetData.REQUESTNAME]);

                    {

                    }

                    // ?H??????Z?b?g

                    strConstrName = string.Empty;

                    strConstrName = CommonMotions.cnvString(objwrk[(int)GetData.CONSTRUCTIONNAME]);

                    // ??t????Z?b?g

                    OrderNo = CommonMotions.cnvInt(objwrk[(int)GetData.ORDERNO]);

                    if (OrderNo != 1) strConstrName = string.Format("{0} [{1}???]", strConstrName, OrderNo);

                    Array.Clear(DspDate, 0, DspDate.Length);

                    if (CommonMotions.cnvDate(objwrk[(int)GetData.APPROVALDATE]).Date != DateTime.MinValue.Date)

                        DspDate[2] = CommonMotions.cnvDate(objwrk[(int)GetData.SENDDATE]).ToShortDateString();

                    // ???????u???C?N

                        //???????z?Z?b?g

                        RequestAmount = CommonMotions.cnvInt(objwrk[(int)GetData.REQUESTAMOUNT]);

                     for(int i=1; iy + i < arData.Count;i++)

                            {

                                objNext = (object[])arData[(iy + i)];

?@?@?@?@?@?@?@?@       RequestAmount += CommonMotions.cnvInt(((object[])arData[(iy + i)])[(int)GetData.REQUESTAMOUNT]);

                            }

                            else

                            }

                        }

                           strRequestAmount = RequestAmount.ToString("#,0");

                    dgv.Rows.Add(strDspNo

                                        , CommonMotions.cnvString(objwrk[(int)GetData.DEPARTMENTSTRING])

                                        , CommonMotions.cnvString(objwrk[(int)GetData.PERSONNAME])

                                        , strOrderName

                                        , strRequestAmount

                                        , CommonMotions.cnvInt(objwrk[(int)GetData.MAINCONSTRUCTIONCODE])

                                        , DspDate[0]

                                        , DspDate[2]

                                        , CommonMotions.cnvInt(objwrk[(int)GetData.ORDERNO])

                                        , CommonMotions.cnvInt(objwrk[(int)GetData.INVOICENO])

        }

        #endregion

        /// <summary>

        /// ?w?b?_?s?\??

        /// ???\??????R?????g?A?E?g?A????????????????m?????????

                    // ?O???b?h??Z?b?g?????

                    SetToGridData(arData);

                }

            }

            catch (Exception ex)

            {

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

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

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

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

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

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

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

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

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

            ((System.ComponentModel.ISupportInitialize)(this.dgv1)).BeginInit();

            this.SuspendLayout();

            // 

            this.DepositPersonName,

            this.Note});

            this.dgv1.EnableHeadersVisualStyles = false;

            this.dgv1.Name = "dgv1";

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

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

            this.dgv1.RowHeadersVisible = false;

            this.dgv1.RowTemplate.Height = 21;

            this.dgv1.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.CellSelect;

            this.dgv1.TabIndex = 9;

            this.dgv1.CellBeginEdit += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.dgv1_CellBeginEdit);

            this.dgv1.CellEnter += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgv1_CellEnter);

            this.dgv1.CellValidating += new System.Windows.Forms.DataGridViewCellValidatingEventHandler(this.dgv1_CellValidating);

            this.dgv1.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgv1_CellValueChanged);

            // 

            // OrderersDivision

            // 

            this.OrderersDivision.HeaderText = "■発注者区分";

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

            this.Note.Width = 200;

            // 

            // FrmEntryDeposit

            // 

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.None;

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

            this.Controls.Add(this.btnDelete);

            this.Controls.Add(this.button1);

            this.Controls.Add(this.OrderersName);

        private System.Windows.Forms.Label label1;

        private System.Windows.Forms.Label OrderersName;

        private System.Windows.Forms.Button button1;

        private System.Windows.Forms.DataGridViewTextBoxColumn OrderersDivision;

        private System.Windows.Forms.DataGridViewTextBoxColumn OrderersCode;

        private System.Windows.Forms.DataGridViewTextBoxColumn TargetDate;

        private System.Windows.Forms.DataGridViewTextBoxColumn DepositPersonCode;

        private System.Windows.Forms.DataGridViewTextBoxColumn DepositPersonName;

        private System.Windows.Forms.DataGridViewTextBoxColumn Note;

    }

}

                        dgv1.Rows[i].Cells[(int)DispColumn.seqNo].Value = Dlist[i].seqNo;

                        dgv1.Rows[i].Cells[(int)DispColumn.depositPersonCode].Value = Dlist[i].depositPersonCode;

                        dgv1.Rows[i].Cells[(int)DispColumn.personName].Value = Dlist[i].personName;

                    }

                    else

                    {

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

                        dgv1.Rows[i].Cells[(int)DispColumn.depositPersonCode].Value = CommonMotions.LoginUserData.PersonCode;

                        dgv1.Rows[i].Cells[(int)DispColumn.personName].Value = CommonMotions.LoginUserData.SealPrintName;

                    }

                    dgv1.Rows[i].Cells[(int)DispColumn.note].Value = Dlist[i].note;

                }

        {

            try

            {

                if (dgv1.RowCount == 0)

                {

                    return;

                }

                oldCellValue = CommonMotions.cnvString(dgv1[e.ColumnIndex, e.RowIndex].Value);

            }

            {

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

            }

                        DepositAmount = Dlist[i].depositAmountCash + Dlist[i].depositAmountBill,

                        DepositAmountCash = Dlist[i].depositAmountCash,

                        DepositAmountBill = Dlist[i].depositAmountBill,

                        Note = m_note

                    };

                    #endregion

                }

                CommonMotions.EntryEndMessage("入金入力");

            }

            catch (Exception ex)

            {

                dgv1.CellValueChanged += dgv1_CellValueChanged;

                ioDepositData.close();

                ioDepositData = null;

            }

        }

        #endregion

            this.cbTargetMonth.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

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

            this.cbTargetMonth.FormattingEnabled = true;

            this.cbTargetMonth.Location = new System.Drawing.Point(164, 8);

            this.cbTargetMonth.Name = "cbTargetMonth";

            this.cbTargetMonth.Size = new System.Drawing.Size(100, 24);

            // 

            this.OrderersName.HeaderText = "請求先名/請求日";

            this.OrderersName.Name = "OrderersName";

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

            this.OrderersName.Width = 200;

            // 

                cbTargetMonth.Items.AddRange(lstDate.ToArray());

                cbTargetMonth.SelectedIndex = lstDate.IndexOf(strNow);

                // ユーザ権限設定

                ClsSecurityPermission.SetUserType(m_UserInfo);

        {

            try

            {

                oldCellValue = CommonMotions.cnvString(dgvMaster[e.ColumnIndex, e.RowIndex].Value);

            }

            catch (Exception ex)

            {

                    {

                        case (int)DispColumn.DepositAmount:

                            depositDetail.DepositAmount = amount;

                            bUpdateCarryAmount = true;

                            sumDataCheck = true;

                            break;

                    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;

                    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.ConstructionCode].Style.BackColor = Color.LightGoldenrodYellow;

                    ordererRow.Cells[(int)DispColumn.RequestNo].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;

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

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

                    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;

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

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

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

                        long RequestAmount = depositDetail.BillPrice + depositDetail.TaxPrice;

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

                        SetPrice(row.Cells, (int)DispColumn.DifferentAmount, depositDetail.DifferenceAmount);

                        row.Cells[(int)DispColumn.ConfirmationPersonCode].Value = depositDetail.ConstructionPersonCode;

                        row.Cells[(int)DispColumn.ConfirmationDate].Value = depositDetail.ConfirmationDate;

                        row.Cells[(int)DispColumn.ConfirmationEndFlg].Value = depositDetail.ConfirmationEndFlg;

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

                {

                    // マイナス値は赤

                    {

                        dgv[e.ColumnIndex, e.RowIndex].Style.ForeColor = Color.Red;

                    }

                    else

                    {

                        dgv[e.ColumnIndex, e.RowIndex].Style.ForeColor = SystemColors.ControlText;