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

                    return;

                }

                // フォーム表示

                frm.ShowDialog();

            }

        /// </summary>

        private void InitializeComponent()

        {

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

            this.panel1 = new System.Windows.Forms.Panel();

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

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

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

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

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

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

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

            this.button1.TabIndex = 3;

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

            this.button1.UseVisualStyleBackColor = true;

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

            // 

            // Registration

            | System.Windows.Forms.AnchorStyles.Left) 

            | System.Windows.Forms.AnchorStyles.Right)));

            this.dgvMaster.BackgroundColor = System.Drawing.Color.White;

            this.dgvMaster.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;

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

            this.KB,

            this.OrderersDivision,

            this.OrderersCode,

            this.OrderersName,

            this.ConstructionCode,

            this.ConstructionName,

            this.BillPrice,

            // 

            // KB

            // 

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

            this.KB.Name = "KB";

            this.KB.ReadOnly = true;

            // 

            // No

            // 

            this.No.HeaderText = "No.";

            this.No.Name = "No";

            this.No.ReadOnly = true;

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

            this.OrderersName.Width = 200;

            // 

            // ConstructionCode

            // 

            this.ConstructionCode.HeaderText = "■工事番号";

            // 

            // BillPrice

            // 

            this.BillPrice.HeaderText = "請求金額\r\n（税抜）";

            this.BillPrice.Name = "BillPrice";

            this.BillPrice.ReadOnly = true;

            // 

            // TaxPrice

            // 

            this.TaxPrice.HeaderText = "請求金額\r\n（消費税）";

            this.TaxPrice.Name = "TaxPrice";

            this.TaxPrice.ReadOnly = true;

            // 

            // DepositAmountCash

            // 

            this.DepositAmountCash.HeaderText = "入金金額\r\n（振込）";

            this.DepositAmountCash.Name = "DepositAmountCash";

            this.DepositAmountCash.ReadOnly = true;

            // 

            // DepositAmountBill

            // 

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

            this.DepositAmountBill.Name = "DepositAmountBill";

            this.DepositAmountBill.ReadOnly = true;

            // 

            // DepositAmount

            // 

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

            this.DepositAmount.Name = "DepositAmount";

            this.DepositAmount.ReadOnly = true;

            // 

            // TaxAmount

            // 

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

            this.TaxAmount.Name = "TaxAmount";

            this.TaxAmount.ReadOnly = true;

            // 

            // DiscountAmount

            // 

            this.DiscountAmount.HeaderText = "値引金額";

            this.DiscountAmount.Name = "DiscountAmount";

            this.DiscountAmount.ReadOnly = true;

            // 

            // CnstrPrice

            // 

            this.CnstrPrice.HeaderText = "協力金";

            this.CnstrPrice.Name = "CnstrPrice";

            this.CnstrPrice.ReadOnly = true;

            // 

            // Fees

            // 

            this.Fees.HeaderText = "手数料";

            this.Fees.Name = "Fees";

            this.Fees.ReadOnly = true;

            // 

            // OtherAdjustments

            // 

            this.OtherAdjustments.HeaderText = "送料";

            this.OtherAdjustments.Name = "OtherAdjustments";

            this.OtherAdjustments.ReadOnly = true;

            // 

            // CarryAmount

            // 

            this.CarryAmount.HeaderText = "差分";

            this.CarryAmount.Name = "CarryAmount";

            this.CarryAmount.ReadOnly = true;

            // 

            // PersonName

            // 

            this.PersonName.HeaderText = "確認";

            this.PersonName.Name = "PersonName";

            this.PersonName.ReadOnly = true;

            // 

            // NoteDD

            // 

            this.NoteDD.HeaderText = "備考";

            this.NoteDD.Name = "NoteDD";

            this.NoteDD.ReadOnly = true;

        private System.Windows.Forms.DataGridViewTextBoxColumn OrderersDivision;

        private System.Windows.Forms.DataGridViewTextBoxColumn OrderersCode;

        private System.Windows.Forms.DataGridViewTextBoxColumn OrderersName;

        private System.Windows.Forms.DataGridViewTextBoxColumn ConstructionCode;

        private System.Windows.Forms.DataGridViewTextBoxColumn ConstructionName;

        private System.Windows.Forms.DataGridViewTextBoxColumn BillPrice;

        {

            // 請求書データ（自動入力）

            KB = 0,                                                             // ■KB

            RequestMonth,                                                       // ■請求月

            RequestNo,                                                          // ■請求書No.

            OrderersDivision,                                                   // ■発注者区分

            OrderersCode,                                                       // ■発注者コード

            OrderersName,                                                       // 請求先名・請求日

            ConstructionCode,                                                   // ■工事番号

            ConstructionName,                                                   // 現場名

            BillPrice,                                                          // 請求金額 (税抜)

            ConstructionPersonCode,                                             // ■工事担当者

            ConstrSubPersonCode,                                                // ■工事副担当

            ConstructionInstructor,                                             // ■指導員

            PersonName,                                                         // 担当者名

            DepartmentCode,                                                     // ■部署コード

        }

        #endregion

        #region 入金確認行区分

        /// <summary>

        /// 入金確認行区分

            public int OrderersDivision;

            public int OrderersCode;

            public string OrderersName;

            public List<Deposit> Deposits = new List<Deposit>();

            public List<Deposit> VisibleDeposits

            {

        /// エラー行

        /// </summary>

        private List<int> m_lstErrorRow = new List<int>();

        #endregion

        #region コンストラクタ

                {

                    DepositBtn.Visible = false;

                }

            }

            catch (Exception ex)

            {

            }

            finally

            {

                IoDd.close();

                IoDd = null;

            }

                            var headerIndex = DetectHeaderIndex(e.RowIndex);

                            UpdateDepositOrdererRows(depositOrderer, headerIndex);

                        }

                        {

                            if (MessageBox.Show("担当者確認を外しますか？", "担当者確認", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)

                            {

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

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

                o.OrderersName = CommonMotions.cnvString(invoice[(int)GetDataFirst.OrderersName]);

                if (o.KB == (int)paymentLineClass.detailLine)

                {

                    o.No = no;

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

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

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

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

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

                sql.Append("  FROM ");

                sql.Append("   ON H.REQCONSTRUCTIONCODE = CBI.CONSTRUCTIONCODE ");

                sql.Append("  WHERE ");

                sql.AppendFormat("   H.REQUESTMONTH = {0} ",m_Select_TargetDate);

                sql.Append(" ) ");

                sql.Append(" UNION ( ");

                sql.Append("  SELECT ");

                sql.Append("   , CBI.CONSTRUCTIONPERSONCODE ");

                sql.Append("   , CBI.CONSTRSUBPERSONCODE ");

                sql.Append("   , CBI.CONSTRUCTIONINSTRUCTOR ");

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

                sql.Append("   , PICM.DEPARTMENTCODE ");

                sql.Append("  FROM ");

                sql.Append("   ON CBI.CONSTRUCTIONPERSONCODE = PICM.PERSONCODE ");

                sql.Append("  WHERE ");

                sql.AppendFormat("   I.REQUESTMONTH = {0} ", m_Select_TargetDate);

                sql.Append(" ) ");

                sql.Append(" ORDER BY ");

                sql.Append("  ORDERERSDIVISION ");

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

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

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

                }

                else if(tgl == 2)

                {

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

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

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

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

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

                    // 入金合計と請求合計の差異があった場合は色を変更する

                    long depositAmount = SumDepositAmountCash + SumDepositAmountBill;

                    long requestAmount = SumRequestBill + SumRequestTax;

                    {

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

                        ordererRow.Cells[(int)DispColumn.DepositAmountCash].Style.ForeColor = Color.Red;

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

                    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.No].Value = depositOrderer.No;

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

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

                    ordererRow.Cells[(int)DispColumn.No].Style.BackColor = Color.FromArgb(192, 255, 192);

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

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

                    index = 0;

                    foreach (var depositDetail in depositOrderer.VisibleDepositDetails)

                    {

                -1,                     // ■発注者区分

                -1,                     // ■発注先コード

                0,                      // 請求先名・請求日

                -1,                     // ■工事番号

                0,                      // 現場名

                0,                      // 請求金額 (税抜)

                }

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

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

                {

                    return true;

                }

                sql.AppendFormat("   H.REQUESTMONTH = {0} ", depositOrderer.RequestMonth);

                sql.AppendFormat("   AND H.ORDERERSDIVISION = {0} ", depositOrderer.OrderersDivision);

                sql.AppendFormat("   AND H.ORDERERSCODE = {0} ", depositOrderer.OrderersCode);

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

                {

                    return false;

                    }

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

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

                    {

                        return true;

                    }

            }

            if ((tcol == (int)DispColumn.DepositAmount) ||                  // 入金金額(税抜)

               (tcol == (int)DispColumn.DiscountAmount) ||                  // 値引金額

               (tcol == (int)DispColumn.CnstrPrice) ||                      // 協力金

               (tcol == (int)DispColumn.Fees) ||                            // 手数料

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

    <value>True</value>

  </metadata>

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

    <value>True</value>

  </metadata>