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

            DepositPersonCode,

            Note,

                    strcmd += string.Format(", {0}", data.DepositPersonCode.ToString());

                    strcmd += string.Format(", '{0}'", data.Note.ToString());

                strcmd += string.Format(",DepositPersonCode =  {0}", data.DepositPersonCode.ToString());

                strcmd += string.Format(",Note =  '{0}'", data.Note.ToString());

        /// 入金明細データフィールド並び

            DifferenceAmount,

            ConfirmationPersonCode,

            ConfirmationDate,

            ConfirmationEndFlg,

            Note,

            EntryDate,

            UpdateDate,

                strcmd += " ,DifferenceAmount";

                strcmd += " ,ConfirmationPersonCode";

                strcmd += " ,DATE_FORMAT(ConfirmationDate, '%Y/%m/%d')";

                strcmd += " ,ConfirmationEndFlg";

                strcmd += string.Format(", {0}", data.DifferenceAmount.ToString());

                strcmd += string.Format(", {0}", data.ConfirmationPersonCode.ToString());

                strcmd += string.Format(", DATE_FORMAT('{0}','%Y/%m/%d')", data.ConfirmationDate.ToShortDateString());

                strcmd += string.Format(", {0}", data.ConfirmationEndFlg.ToString());

                strcmd += string.Format(", '{0}'", data.Note.ToString());

                strcmd += string.Format(" OrderersDivision = {0}", data.OrderersDivision.ToString());

                strcmd += string.Format(",OrderersCode = {0}", data.OrderersCode.ToString());

                strcmd += string.Format(",TargetDate = {0}", data.TargetDate);

                strcmd += string.Format(",RequestNo = {0}", data.RequestNo.ToString());

                strcmd += string.Format(",DifferenceAmount = {0}", data.DifferenceAmount.ToString());

                strcmd += string.Format(",ConfirmationPersonCode = {0}", data.ConfirmationPersonCode.ToString());

                strcmd += string.Format(",ConfirmationDate = DATE_FORMAT('{0}','%Y/%m/%d')", data.ConfirmationDate.ToShortDateString());

                strcmd += string.Format(",ConfirmationEndFlg = {0}", data.ConfirmationEndFlg.ToString());

                strcmd += string.Format(",Note = '{0}'", data.Note.ToString());

                strcmd += string.Format(" where OrderersDivision = {0} and OrderersCode = {1} and TargetDate = {2} and RequestNo = {3} ",

                    data.OrderersDivision, data.OrderersCode, data.TargetDate, data.RequestNo);

                wrk.DifferenceAmount = long.Parse(objwrk[(int)NameColumn.DifferenceAmount].ToString());

                wrk.ConfirmationPersonCode = int.Parse(objwrk[(int)NameColumn.ConfirmationPersonCode].ToString());

                wrk.ConfirmationDate = DateTime.Parse(objwrk[(int)NameColumn.ConfirmationDate].ToString());

                wrk.ConfirmationEndFlg = int.Parse(objwrk[(int)NameColumn.ConfirmationEndFlg].ToString());

                wrk.EntryDate = DateTime.Parse(objwrk[(int)NameColumn.EntryDate].ToString());

                wrk.UpdateDate = DateTime.Parse(objwrk[(int)NameColumn.UpdateDate].ToString());

                wrk.DifferenceAmount = 0;

                wrk.ConfirmationPersonCode = 0;

                wrk.ConfirmationDate = DateTime.MinValue;

                wrk.ConfirmationEndFlg = 0;

        private int m_BusinessPeriod = 0;                       // 営業期

        private long m_DepositAmount = 0;                       // 入金金額

        private long m_DepositAmountCash = 0;                   // 入金金額（現金）

        private long m_DepositAmountBill = 0;                   // 入金金額（手形）

        private int m_DepositPersonCode = 0;                    // 入金担当者コード

        private string m_Note = string.Empty;                   // 備考

        /// 入金担当者コード

        /// </summary>

        public int DepositPersonCode

        {

            get { return m_DepositPersonCode; }

            set { m_DepositPersonCode = value; }

        }

        /// <summary>

        /// 備考

        /// </summary>

        public string Note

        {

            get { return m_Note; }

            set { m_Note = value; }

        }

        /// <summary>

        private int m_OrderersDivision = 0;                         // 発注者区分

        private int m_OrderersCode = 0;                             // 発注者コード

        private string m_TargetDate = string.Empty;                 // 対象年月

        private int m_RequestNo = 0;                                // 請求No

        private int m_OrderNo = 0;                                  // 受付番号

        private long m_DepositAmount = 0;                           // 入金金額

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

        private long m_CnstrPrice = 0;                              // 協力金

        private long m_Fees = 0;                                    // 手数料

        private long m_OtherAdjustments = 0;                        // その他調整

        private long m_DifferenceAmount = 0;                        // 差分

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

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

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

        private string m_Note = string.Empty;                       // 備考

        private DateTime m_EntryDate = DateTime.Now;                // 登録年月日

        private DateTime m_UpdateDate = DateTime.Now;               // 更新年月日

        /// 差額金額

        public long DifferenceAmount

            get { return m_DifferenceAmount; }

            set { m_DifferenceAmount = value; }

        /// 確認担当者コード

        public int ConfirmationPersonCode

            get { return m_ConfirmationPersonCode; }

            set { m_ConfirmationPersonCode = value; }

        /// 担当者確認日付

        public DateTime ConfirmationDate

            get { return m_ConfirmationDate; }

            set { m_ConfirmationDate = value; }

        /// 確認完了フラグ

        public int ConfirmationEndFlg

            get { return m_ConfirmationEndFlg; }

            set { m_ConfirmationEndFlg = value; }

        /// 備考

        /// </summary>

        public string Note

        {

            get { return m_Note; }

            set { m_Note = value; }

        }

        /// <summary>

namespace ProcessManagement.Forms.DataEntry.Request

{

    partial class FrmEntryDeposit

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows Form Designer generated code

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

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

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

            this.dgv1 = new System.Windows.Forms.DataGridView();

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

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

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

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

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

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

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

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

            this.DepositAmountBill = 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();

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

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

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

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

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

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

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

            this.SuspendLayout();

            // 

            // dgv1

            // 

            this.dgv1.AllowUserToAddRows = false;

            this.dgv1.AllowUserToResizeColumns = false;

            this.dgv1.AllowUserToResizeRows = false;

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

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

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

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

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

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

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

            this.dgv1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;

            this.dgv1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing;

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

            this.OrderersDivision,

            this.OrderersCode,

            this.TargetDate,

            this.SeqNo,

            this.BusinessPeriod,

            this.DepositDate,

            this.DepositAmount,

            this.DepositAmountCash,

            this.DepositAmountBill,

            this.DepositPersonCode,

            this.DepositPersonName,

            this.Note});

            this.dgv1.Location = new System.Drawing.Point(12, 63);

            this.dgv1.Name = "dgv1";

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

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

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

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

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

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

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

            this.dgv1.RowHeadersDefaultCellStyle = dataGridViewCellStyle6;

            this.dgv1.RowHeadersVisible = false;

            this.dgv1.RowTemplate.Height = 21;

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

            this.dgv1.Size = new System.Drawing.Size(652, 172);

            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.CellFormatting += new System.Windows.Forms.DataGridViewCellFormattingEventHandler(this.dgv1_CellFormatting_1);

            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.OrderersDivision.Name = "OrderersDivision";

            this.OrderersDivision.ReadOnly = true;

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

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

            this.OrderersDivision.Visible = false;

            // 

            // OrderersCode

            // 

            this.OrderersCode.HeaderText = "■発注者コード";

            this.OrderersCode.Name = "OrderersCode";

            this.OrderersCode.ReadOnly = true;

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

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

            this.OrderersCode.Visible = false;

            // 

            // TargetDate

            // 

            this.TargetDate.HeaderText = "■対象年月";

            this.TargetDate.Name = "TargetDate";

            this.TargetDate.ReadOnly = true;

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

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

            this.TargetDate.Visible = false;

            // 

            // SeqNo

            // 

            this.SeqNo.HeaderText = "■連番";

            this.SeqNo.Name = "SeqNo";

            this.SeqNo.ReadOnly = true;

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

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

            this.SeqNo.Visible = false;

            // 

            // BusinessPeriod

            // 

            this.BusinessPeriod.HeaderText = "■営業期";

            this.BusinessPeriod.Name = "BusinessPeriod";

            this.BusinessPeriod.ReadOnly = true;

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

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

            this.BusinessPeriod.Visible = false;

            // 

            // DepositDate

            // 

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

            this.DepositDate.DefaultCellStyle = dataGridViewCellStyle2;

            this.DepositDate.HeaderText = "入金日";

            this.DepositDate.Name = "DepositDate";

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

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

            // 

            // DepositAmount

            // 

            this.DepositAmount.HeaderText = "■入金金額";

            this.DepositAmount.Name = "DepositAmount";

            this.DepositAmount.ReadOnly = true;

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

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

            this.DepositAmount.Visible = false;

            // 

            // DepositAmountCash

            // 

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

            this.DepositAmountCash.DefaultCellStyle = dataGridViewCellStyle3;

            this.DepositAmountCash.HeaderText = "入金金額（現金）";

            this.DepositAmountCash.Name = "DepositAmountCash";

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

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

            this.DepositAmountCash.Width = 150;

            // 

            // DepositAmountBill

            // 

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

            this.DepositAmountBill.DefaultCellStyle = dataGridViewCellStyle4;

            this.DepositAmountBill.HeaderText = "入金金額（手形）";

            this.DepositAmountBill.Name = "DepositAmountBill";

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

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

            this.DepositAmountBill.Width = 150;

            // 

            // DepositPersonCode

            // 

            this.DepositPersonCode.HeaderText = "■入金担当者コード";

            this.DepositPersonCode.Name = "DepositPersonCode";

            this.DepositPersonCode.ReadOnly = true;

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

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

            this.DepositPersonCode.Visible = false;

            // 

            // DepositPersonName

            // 

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

            this.DepositPersonName.DefaultCellStyle = dataGridViewCellStyle5;

            this.DepositPersonName.HeaderText = "確認者";

            this.DepositPersonName.Name = "DepositPersonName";

            this.DepositPersonName.ReadOnly = true;

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

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

            this.DepositPersonName.Width = 80;

            // 

            // Note

            // 

            this.Note.HeaderText = "備考";

            this.Note.Name = "Note";

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

            this.Note.Width = 200;

            // 

            // btnAccept

            // 

            this.btnAccept.BackColor = System.Drawing.Color.Lime;

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

            this.btnAccept.Location = new System.Drawing.Point(418, 241);

            this.btnAccept.Name = "btnAccept";

            this.btnAccept.Size = new System.Drawing.Size(120, 32);

            this.btnAccept.TabIndex = 12;

            this.btnAccept.Text = "登　録";

            this.btnAccept.UseVisualStyleBackColor = false;

            this.btnAccept.Click += new System.EventHandler(this.btnAccept_Click);

            // 

            // btnEnd

            // 

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

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

            this.btnEnd.Location = new System.Drawing.Point(544, 241);

            this.btnEnd.Name = "btnEnd";

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

            this.btnEnd.TabIndex = 11;

            this.btnEnd.Text = "閉じる";

            this.btnEnd.UseVisualStyleBackColor = false;

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

            // 

            // label1

            // 

            this.label1.BackColor = System.Drawing.Color.Yellow;

            this.label1.Location = new System.Drawing.Point(12, 18);

            this.label1.Name = "label1";

            this.label1.Size = new System.Drawing.Size(106, 25);

            this.label1.TabIndex = 13;

            this.label1.Text = "発注者";

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

            // 

            // OrderersName

            // 

            this.OrderersName.BackColor = System.Drawing.Color.White;

            this.OrderersName.Location = new System.Drawing.Point(124, 18);

            this.OrderersName.Name = "OrderersName";

            this.OrderersName.Size = new System.Drawing.Size(414, 25);

            this.OrderersName.TabIndex = 14;

            this.OrderersName.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;

            // 

            // button1

            // 

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

            this.button1.Location = new System.Drawing.Point(604, 18);

            this.button1.Name = "button1";

            this.button1.Size = new System.Drawing.Size(60, 23);

            this.button1.TabIndex = 15;

            this.button1.Text = "・・・";

            this.button1.UseVisualStyleBackColor = true;

            this.button1.Visible = false;

            this.button1.Click += new System.EventHandler(this.button1_Click);

            // 

            // btnDelete

            // 

            this.btnDelete.BackColor = System.Drawing.Color.Magenta;

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

            this.btnDelete.Location = new System.Drawing.Point(12, 242);

            this.btnDelete.Name = "btnDelete";

            this.btnDelete.Size = new System.Drawing.Size(120, 32);

            this.btnDelete.TabIndex = 16;

            this.btnDelete.Text = "入金削除";

            this.btnDelete.UseVisualStyleBackColor = false;

            this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);

            // 

            // FrmEntryDeposit

            // 

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

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

            this.ClientSize = new System.Drawing.Size(676, 286);

            this.Controls.Add(this.btnDelete);

            this.Controls.Add(this.button1);

            this.Controls.Add(this.OrderersName);

            this.Controls.Add(this.label1);

            this.Controls.Add(this.btnAccept);

            this.Controls.Add(this.btnEnd);

            this.Controls.Add(this.dgv1);

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

            this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog;

            this.Margin = new System.Windows.Forms.Padding(4);

            this.MaximizeBox = false;

            this.MinimizeBox = false;

            this.Name = "FrmEntryDeposit";

            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;

            this.Text = "入金入力";

            this.Load += new System.EventHandler(this.FrmEntryDeposit_Load);

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

            this.ResumeLayout(false);

        }

        #endregion

        private System.Windows.Forms.DataGridView dgv1;

        private System.Windows.Forms.Button btnAccept;

        private System.Windows.Forms.Button btnEnd;

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

        private System.Windows.Forms.DataGridViewTextBoxColumn BusinessPeriod;

        private System.Windows.Forms.DataGridViewTextBoxColumn DepositDate;

        private System.Windows.Forms.DataGridViewTextBoxColumn DepositAmount;

        private System.Windows.Forms.DataGridViewTextBoxColumn DepositAmountCash;

        private System.Windows.Forms.DataGridViewTextBoxColumn DepositAmountBill;

        private System.Windows.Forms.DataGridViewTextBoxColumn DepositPersonCode;

        private System.Windows.Forms.DataGridViewTextBoxColumn DepositPersonName;

        private System.Windows.Forms.DataGridViewTextBoxColumn Note;

        private System.Windows.Forms.Button btnDelete;

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using ProcessManagement.DataModel;

using ProcessManagement.Common;

using ProcessManagement.Forms.SubForms;

using System.Collections;

using ProcessManagement.DB.IOAccess;

using System.Diagnostics;

using System.Threading;

using System.Text.RegularExpressions;

using log4net;

using log4net.Appender;

using log4net.Repository.Hierarchy;

using ProcessManagement.DB.Core;

using ProcessManagement.Forms.Master;

using ProcessManagement.Forms.CustomControls;

using ProcessManagement.Forms.ControlsAction;

namespace ProcessManagement.Forms.DataEntry.Request

{

    public partial class FrmEntryDeposit : Form

    {

        #region ログ使用定義

        //log4netログを使用する

        private static readonly log4net.ILog logger = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

        #endregion

        #region 変数

        /// <summary>

        /// 入金データ

        /// </summary>

        private DepositData m_DepositData = new DepositData();

        /// <summary>

        /// 編集前のセルの内容

        /// </summary>

        private string oldCellValue = "";

        private List<DepositList> Dlist;

        #endregion

        #region 定数

        private const long amount_max = 9999999999;             // 金額最大

        private const long amount_min = -9999999999;            // 金額最小

        #endregion

        #region 入金情報クラス定義

        /// <summary>

        /// 入金情報

        /// </summary>

        private class DepositList

        {

            public int orderersDivision;

            public int orderersCode;

            public int targetDate;

            public int seqNo;

            public string depositDate;

            public long depositAmount;

            public long depositAmountCash;

            public long depositAmountBill;

            public int depositPersonCode;

            public string personName;

            public string note;

            public int AddEdit = 0;

        }

        #endregion

        #region 取得するデータ項目

        /// <summary>

        /// 取得するデータ項目

        /// </summary>

        private enum GetData

        {

            orderersName = 0,

            orderersDivision,

            orderersCode,

            targetDate,

            seqNo,

            depositDate,

            depositAmount,

            depositAmountCash,

            depositAmountBill,

            depositPersonCode,

            personName,

            note,

        }

        #endregion

        #region カラム追加用

        /// <summary>

        /// カラム追加用

        /// </summary>

        private enum DispColumn

        {

            orderersDivision = 0,

            orderersCode,

            targetDate,

            seqNo,

            BusinessPeriod,

            depositDate,

            depositAmount,

            depositAmountCash,

            depositAmountBill,

            depositPersonCode,

            personName,

            note,

        }

        #endregion

        #region プロパティ

        /// <summary>

        /// 入金データ

        /// </summary>

        public DepositData depositdata

        {

            get { return m_DepositData; }

            set { m_DepositData = value; }

        }

        #endregion

        #region コンストラクタ

        public FrmEntryDeposit()

        {

            InitializeComponent();

        }

        #endregion

        #region フォームロード

        /// <summary>

        /// フォームロード

        /// </summary>

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

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

        private void FrmEntryDeposit_Load(object sender, EventArgs e)

        {

            //フォームサイズ固定

            this.MaximizedBounds = new Rectangle(this.Left, this.Top, this.Width, this.Height);

            // 初期表示

            InitDataLoad();

        }

        #endregion

        #region 初期表示処理

        /// <summary>

        /// 初期表示処理

        /// </summary>

        private void InitDataLoad()

        {

            try

            {

                var Dep = SelectDepositData().OfType<object[]>();

                Dlist = new List<DepositList>();

                // 取得情報をリストに入れる

                foreach (var orderer in Dep)

                {

                    var o = new DepositList();

                    string orderersName = CommonMotions.cnvString(orderer[(int)GetData.orderersName]);

                    if (orderersName != null)

                    {

                        OrderersName.Text = orderersName;

                    }

                    o.orderersDivision = CommonMotions.cnvInt(orderer[(int)GetData.orderersDivision]);

                    o.orderersCode = CommonMotions.cnvInt(orderer[(int)GetData.orderersCode]);

                    o.targetDate = CommonMotions.cnvInt(orderer[(int)GetData.targetDate]);

                    o.seqNo = CommonMotions.cnvInt(orderer[(int)GetData.seqNo]);

                    o.depositDate = CommonMotions.cnvString(orderer[(int)GetData.depositDate]);

                    o.depositAmount = CommonMotions.cnvInt(orderer[(int)GetData.depositAmount]);

                    o.depositAmountCash = CommonMotions.cnvInt(orderer[(int)GetData.depositAmountCash]);

                    o.depositAmountBill = CommonMotions.cnvInt(orderer[(int)GetData.depositAmountBill]);

                    o.depositPersonCode = CommonMotions.cnvInt(orderer[(int)GetData.depositPersonCode]);

                    o.personName = CommonMotions.cnvString(orderer[(int)GetData.personName]);

                    o.note = CommonMotions.cnvString(orderer[(int)GetData.note]);

                    o.AddEdit = 0;

                    Dlist.Add(o);

                }

                // 一覧表示

                Display();

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 入金データを取得する

        /// <summary>

        /// 入金データを取得する

        /// </summary>

        /// <returns></returns>

        private ArrayList SelectDepositData()

        {

            var Dep = new IODepositData();

            int Od = depositdata.OrderersDivision;

            int Oc = depositdata.OrderersCode;

            string Tg = depositdata.TargetDate;

            try

            {

                var sql = new StringBuilder();

                sql.Append(" ( ");

                sql.Append("  SELECT ");

                sql.Append("   CONCAT(OrderersName1, '　', OrderersName2) AS ORDERERSNAME ");

                sql.Append("   , ORDERCOTEGORY AS ORDERERSDIVISION ");

                sql.Append("   , ORDERERSCODE AS ORDERERSCODE ");

                sql.AppendFormat("   , {0} AS TARGETDATE ", Tg);

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

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

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

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

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

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

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

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

                sql.Append("  FROM ");

                sql.Append("   ORDERERSMASTER ");

                sql.Append("  WHERE ");

                sql.AppendFormat("   ORDERCOTEGORY = {0} ", Od);

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

                sql.Append(" ) ");

                sql.Append(" UNION ");

                sql.Append(" ( ");

                sql.Append("  SELECT ");

                sql.Append("   NULL AS ORDERERSNAME ");

                sql.Append("   , DEP.ORDERERSDIVISION ");

                sql.Append("   , DEP.ORDERERSCODE ");

                sql.Append("   , DEP.TARGETDATE ");

                sql.Append("   , DEP.SEQNO ");

                sql.Append("   , DATE_FORMAT(DEP.DEPOSITDATE, '%m/%d') AS DEPOSITDATE");

                sql.Append("   , DEP.DEPOSITAMOUNT ");

                sql.Append("   , DEP.DEPOSITAMOUNTCASH ");

                sql.Append("   , DEP.DEPOSITAMOUNTBILL ");

                sql.Append("   , DEP.DEPOSITPERSONCODE ");

                sql.Append("   , PICM.SEALPRINTNAME AS PERSONNAME");

                sql.Append("   , DEP.NOTE ");

                sql.Append("  FROM ");

                sql.Append("   DEPOSITDATA AS DEP ");

                sql.Append("   LEFT OUTER JOIN PERSONINCHARGEMASTER PICM ON ");

                sql.Append("    PICM.PERSONCODE = DEP.DEPOSITPERSONCODE ");

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

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

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

                sql.Append(" ) ");

                sql.Append(" ORDER BY ");

                sql.Append(" ORDERERSNAME ");

                sql.Append(" ,SEQNO ");

                sql.Append(" ; ");

                var data = new ArrayList();

                if (!Dep.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

            {

                Dep.close();

                Dep = null;

            }

        }

        #endregion

        #region 一覧表示

        /// <summary>

        /// 一覧表示

        /// </summary>

        private void Display()

        {

            try

            {

                for (var i = 0; i < Dlist.Count; i++)

                {

                    dgv1.Rows.Add();

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

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

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

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

                    dgv1.Rows[i].Cells[(int)DispColumn.BusinessPeriod].Value = CommonMotions.SystemMasterData.BusinessPeriod;

                    SetPrice(dgv1.Rows[i].Cells, (int)DispColumn.depositAmount, Dlist[i].depositAmountCash + Dlist[i].depositAmountBill);

                    SetPrice(dgv1.Rows[i].Cells, (int)DispColumn.depositAmountCash, Dlist[i].depositAmountCash);

                    SetPrice(dgv1.Rows[i].Cells, (int)DispColumn.depositAmountBill, Dlist[i].depositAmountBill);

                    if (Dlist[i].depositPersonCode != 0)

                    {

                        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;

                        dgv1.Rows[i].Cells[(int)DispColumn.personName].Style.ForeColor = Color.Red;

                    }

                    else

                    {

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

                        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.personName].Style.ForeColor = Color.Gray;

                    }

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

                }

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 金額の設定

        /// <summary>

        /// 金額の設定

        /// </summary>

        /// <param name="cells"></param>

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

        /// <param name="price"></param>

        private void SetPrice(DataGridViewCellCollection cells, int index, long price)

        {

            try

            {

                cells[index].Value = price.ToString("#,0");

                cells[index].Style.ForeColor = Color.Black;

                if (price < 0)

                {

                    cells[index].Style.ForeColor = Color.Red;

                }

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region セル編集開始

        /// <summary>

        /// セル編集開始

        /// </summary>

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

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

        private void dgv1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)

        {

            dgv1.CellBeginEdit -= dgv1_CellBeginEdit;

            dgv1.CellValueChanged -= dgv1_CellValueChanged;

            int tcol = e.ColumnIndex;

            int trow = e.RowIndex;

            try

            {

                if ((tcol == (int)DispColumn.depositAmountCash) ||

                (tcol == (int)DispColumn.depositAmountBill))

                {

                    string val;

                    // セルに値が格納されている場合

                    if (dgv1[tcol, trow].Value != null)

                    {

                        // カンマ区切りを解除

                        val = dgv1[tcol, trow].Value.ToString().Replace(",", string.Empty);

                    }

                    else

                    {

                        // 0を入力

                        val = "0";

                    }

                    dgv1[tcol, trow].Value = val;

                    // 文字色は一律黒

                    dgv1[tcol, trow].Style.ForeColor = Color.Black;

                }

                dgv1.CellBeginEdit += dgv1_CellBeginEdit;

                dgv1.CellValueChanged += dgv1_CellValueChanged;

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region セルフォーカス取得

        /// <summary>

        /// セル編集開始時のイベント

        /// </summary>

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

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

        private void dgv1_CellEnter(object sender, DataGridViewCellEventArgs e)

        {

            try

            {

                if (dgv1.RowCount == 0)

                {

                    return;

                }

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

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region セル編集完了時のイベント

        /// <summary>

        /// セル編集完了時のイベント

        /// </summary>

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

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

        private void dgv1_CellValueChanged(object sender, DataGridViewCellEventArgs e)

        {

            dgv1.CellEnter -= dgv1_CellEnter;

            dgv1.CellValueChanged -= dgv1_CellValueChanged;

            try

            {

                // 行が追加されたときではなく、セルの内容が変更されているときだけ処理を実行する。また金額以外の変更は処理を抜ける。

                if (e.RowIndex == dgv1.NewRowIndex ||

                    !dgv1.IsCurrentCellDirty //||

                    //e.ColumnIndex == (int)DispColumn.depositAmountBill ||

                    //e.ColumnIndex != (int)DispColumn.depositAmountCash

                    )

                {

                    return;

                }

                // 行がなければそのまま返す

                if (dgv1.RowCount == 0)

                {

                    return;

                }

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

                var cellValue = CommonMotions.cnvString(cells[e.ColumnIndex].Value);

                // 値が変わっていなければそのまま返す

                if (oldCellValue == cellValue)

                {

                    return;

                }

                try

                {

                    // 日付の自動編集

                    if (dgv1.Rows[e.RowIndex].Cells[e.ColumnIndex].ColumnIndex == (int)DispColumn.depositDate)

                    {

                        string txtbox = dgv1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();

                        // 日付をyyyy/mm/dd形式で表示する

                        if (txtbox.Length == 0)

                        {

                            return;

                        }

                        // 文字の出現回数カウント

                        if (CommonMotions.chkNumeric(txtbox))

                        {   // 数字のみ入力

                            if (txtbox.ToString().Length <= 4)

                            {

                                txtbox = CommonMotions.cnvInt(txtbox.Substring(0, 2)).ToString("00")

                                    + "/" + CommonMotions.cnvInt(txtbox.Substring(2)).ToString("00");

                            }

                        }

                        else

                        {   // 99/99の入力

                            if (txtbox.ToString().Length <= 5)

                            {

                                txtbox = CommonMotions.cnvInt(txtbox.Substring(0, txtbox.IndexOf("/"))).ToString("00")

                                                + "/" + CommonMotions.cnvInt(txtbox.Substring(txtbox.IndexOf("/") + 1)).ToString("00");

                            }

                        }

                        if (!CommonMotions.chkDate(txtbox.ToString()))

                        {

                            throw new Exception();

                        }

                        dgv1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = txtbox.ToString();

                        cellValue = txtbox.ToString();

                    }

                }

                catch(Exception ex)

                {

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

                    MessageBox.Show("入金日の値が不正です", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    dgv1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = "";

                }

                // 入金情報を編集

                if (e.ColumnIndex == (int)DispColumn.depositAmountCash

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

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

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

                {

                    switch (e.ColumnIndex)

                    {

                        case (int)DispColumn.depositAmountCash:

                            if (cellValue != "")

                                Dlist[e.RowIndex].depositAmountCash = (int)CommonMotions.cnvLong(cellValue);

                            else

                                Dlist[e.RowIndex].depositAmountCash = 0;

                            break;

                        case (int)DispColumn.depositAmountBill:

                            if (cellValue != "")

                                Dlist[e.RowIndex].depositAmountBill = (int)CommonMotions.cnvLong(cellValue);

                            else

                                Dlist[e.RowIndex].depositAmountBill = 0;

                            break;

                        case (int)DispColumn.depositDate:

                            DateTime dt;

                            if (DateTime.TryParse(cellValue, out dt))

                                Dlist[e.RowIndex].depositDate = dt.ToString("yyyy/MM/dd");

                            else

                                Dlist[e.RowIndex].depositDate = "";

                            break;

                        case (int)DispColumn.note:

                            if (cellValue != "")

                                Dlist[e.RowIndex].note = CommonMotions.cnvString(cellValue);

                            else

                                Dlist[e.RowIndex].note = "";

                            break;

                    }

                    if (dgv1.Rows[e.RowIndex].Cells[(int)DispColumn.seqNo].Value == null)

                    {

                        return;

                    }

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

                    if (seqno == Dlist.Count)

                    {

                        Dlist[e.RowIndex].AddEdit = 1;

                    }

                    else

                    {

                        Dlist[e.RowIndex].AddEdit = 2;

                    }

                }

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                dgv1.CellEnter += dgv1_CellEnter;

                dgv1.CellValueChanged += dgv1_CellValueChanged;

            }

        }

        #endregion

        #region 金額セル検証

        /// <summary>

        /// 金額セル検証

        /// </summary>

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

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

        private void dgv1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)

        {

            int tcol = e.ColumnIndex;

            int trow = e.RowIndex;

            if (trow == -1)

            {

                return;

            }

            try

            {

                if ((tcol == (int)DispColumn.depositAmountCash) ||              // 入金金額（振込）

                   (tcol == (int)DispColumn.depositAmountBill))                // 入金金額（手形）

                {

                    // カンマは一旦削除して文字列を取得

                    string str = e.FormattedValue.ToString().Replace(",", string.Empty); ;

                    // 不要な空白は削除

                    str.Trim();

                    // 値が未設定の場合は０とする

                    if (str == "")

                    {

                        str = "0";

                    }

                    long n = 0;

                    if (long.TryParse(str, out n) == true)

                    {

                        if ((n > amount_max) || (n < amount_min))

                        {

                            MessageBox.Show("金額が登録可能範囲(-9,999,999,999～9,999,999,999)を超えました。", "入力エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                            e.Cancel = true;

                        }

                    }

                    else

                    {

                        MessageBox.Show("金額を入力してください", "入力エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                        e.Cancel = true;

                    }

                }

                return;

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region セルフォーマッティング

        /// <summary>

        /// セルフォーマッティング

        /// </summary>

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

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

        private void dgv1_CellFormatting_1(object sender, DataGridViewCellFormattingEventArgs e)

        {

            DataGridView dgv = (DataGridView)sender;

            try

            {

                if (dgv.RowCount == 0)

                    return;

                if (e.ColumnIndex == (int)DispColumn.depositAmountBill ||

                    e.ColumnIndex == (int)DispColumn.depositAmountCash)

                {

                    // マイナス値は赤

                    if (CommonMotions.cnvInt(dgv[e.ColumnIndex, e.RowIndex].Value) < 0)

                    {

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

                    }

                    else

                    {

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

                    }

                    dgv[e.ColumnIndex, e.RowIndex].Value = CommonMotions.cnvInt(dgv[e.ColumnIndex, e.RowIndex].Value).ToString("#,0");

                }

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 削除ボタン押下

        private void btnDelete_Click(object sender, EventArgs e)

        {

            try

            {

                if (MessageBox.Show("選択しているデータを削除します。よろしいですか。", "削除確認", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)

                {

                    return;

                }

                int row = dgv1.CurrentCell.RowIndex;

                Dlist[row].AddEdit = 3;

                //CommonMotions.RemoveEndMessage("入金データ");

                dgv1.Rows[row].Cells[(int)DispColumn.note].Value = "登録ボタンで削除完了";

                dgv1.Rows[row].Cells[(int)DispColumn.note].Style.ForeColor = Color.Red;

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 登録ボタン押下

        private void btnAccept_Click(object sender, EventArgs e)

        {

            dgv1.CellEnter -= dgv1_CellEnter;

            dgv1.CellValueChanged -= dgv1_CellValueChanged;

            var ioDepositData = new IODepositData();

            try

            {

                if (MessageBox.Show("表示中のデータを登録します。", "登録確認", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes)

                {

                    return;

                }

                for (int i = 0; i < Dlist.Count; i++)

                {

                    if (Dlist[i].AddEdit == 0)

                    {

                        continue;

                    }

                    #region 入力内容をチェック

                    // 入金日入力済みで入金金額が入力されていない

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

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

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

                    {

                        // エラー表示

                        MessageBox.Show("入金日が登録されている行に入金金額が入力されていません。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                        return;

                    }

                    // 入金金額入力済みで入金日が入力されていない

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

                        && (!string.IsNullOrEmpty(Dlist[i].depositAmountCash.ToString())

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

                    {

                        // エラー表示

                        MessageBox.Show("入金金額が登録されている行に入金日が入力されていません。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                        return;

                    }

                    #endregion

                    ioDepositData.connect();

                    #region 登録処理

                    string m_note = dgv1.Rows[i].Cells[(int)DispColumn.note].Value.ToString();

                    if (m_note == null)

                    {

                        m_note = "";

                    }

                    var depositData = new DepositData()

                    {

                        OrderersDivision = Dlist[i].orderersDivision,

                        OrderersCode = Dlist[i].orderersCode,

                        TargetDate = Dlist[i].targetDate.ToString(),

                        SeqNo = (int)dgv1.Rows[i].Cells[(int)DispColumn.seqNo].Value,

                        BusinessPeriod = CommonMotions.SystemMasterData.BusinessPeriod,

                        DepositDate = DateTime.Parse(Dlist[i].depositDate),

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

                        DepositAmountCash = Dlist[i].depositAmountCash,

                        DepositAmountBill = Dlist[i].depositAmountBill,

                        DepositPersonCode = (int)dgv1.Rows[i].Cells[(int)DispColumn.depositPersonCode].Value,