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

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 System.Collections;

using log4net;

using log4net.Appender;

using log4net.Repository.Hierarchy;

using ProcessManagement.Common;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

using ProcessManagement.DB.Core;

using ProcessManagement.Forms.Master;

using ProcessManagement.Forms.DataEntry;

using ProcessManagement.Forms.CustomControls;

using ProcessManagement.Forms.ControlsAction;

using ProcessManagement.Forms.SubForms;

using System.Reflection;

/// <summary>

/// 「売上確認」画面

/// </summary>

namespace ProcessManagement.Forms.DataEntry

{

    public partial class FrmSalesConfirm : Form

    {

        #region 使用定義

        /// <summary>

        /// ロガー

        /// </summary>

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

        #endregion

        #region 定数

        /// <summary>

        /// 承認状態

        /// </summary>

        public enum ApprovalStatus

        {

            None = 0,

            InCharge,

            InApproval,

            Approved,

        }

        /// <summary>

        /// 合計行の見出し

        /// </summary>

        private enum TotalRows

        {

            小計 = 1,

            入金金額,

            調整後金額,

            差額,

        }

        /// <summary>

        /// 表示カラム ※■は非表示セル

        /// </summary>

        private enum DispColumn

        {

            RowType = 0,                                                        // ■編集状態

            No,                                                                 // No

            OrderersDivision,                                                   // ■発注先区分

            OrderersCode,                                                       // ■発注者コード

            SeqNo,                                                              // ■連番

            LineCount,                                                          // ■行番号

            OrderersName,                                                       // 請求先名

            DepositDate,                                                        // 入金日

            DepositAmountCash,                                                  // 入金金額 (振込み)

            DepositAmountBill,                                                  // 入金金額 (手形)

            RequestNo,                                                          // ■請求No.

            OrderNo,                                                            // ■受付番号

            ConstructionName,                                                   // 現場名

            ConstructionName_Raw,                                               // ■現場名 (DB登録値)

            PaymentSchedule,                                                    // 入金予定日

            BillCreationDate,                                                   // 請求日

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

            TaxPrice,                                                           // 請求金額 (消費税)

            DepositAmount,                                                      // 入金金額

            DiscountAmount,                                                     // 値引金額

            CnstrPrice,                                                         // 協力金

            Fees,                                                               // 手数料

            OtherAdjustments,                                                   // その他調整

            CarryAmount,                                                        // 次回繰越

            PersonName,                                                         // 担当者承認

            PersonCode,                                                         // ■担当者コード

            PersonDate,                                                         // ■担当者日付

            ApprovalName_1,                                                     // 承認者１承認

            ApprovalCode_1,                                                     // ■承認者コード_1

            ApprovalAuthority_1,                                                // ■承認権限区分_1

            ApprovalDate_1,                                                     // ■承認日付_1

            ApprovalOrder_1,                                                    // ■承認順番_1

            ApprovalName_2,                                                     // 承認者２承認

            ApprovalCode_2,                                                     // ■承認者コード_2

            ApprovalAuthority_2,                                                // ■承認権限区分_2

            ApprovalDate_2,                                                     // ■承認日付_2

            ApprovalOrder_2,                                                    // ■承認順番_2

            ApprovalName_3,                                                     // 承認者３承認

            ApprovalCode_3,                                                     // ■承認者コード_3

            ApprovalAuthority_3,                                                // ■承認権限区分_3

            ApprovalDate_3,                                                     // ■承認日付_3

            ApprovalOrder_3,                                                    // ■承認順番_3

            ApprovalName_4,                                                     // 承認者４承認

            ApprovalCode_4,                                                     // ■承認者コード_4

            ApprovalAuthority_4,                                                // ■承認権限区分_4

            ApprovalDate_4,                                                     // ■承認日付_4

            ApprovalOrder_4,                                                    // ■承認順番_4

            ApprovalName_5,                                                     // 承認者５承認

            ApprovalCode_5,                                                     // ■承認者コード_5

            ApprovalAuthority_5,                                                // ■承認権限区分_5

            ApprovalDate_5,                                                     // ■承認日付_5

            ApprovalOrder_5,                                                    // ■承認順番_5

            ApprovalName_6,                                                     // 承認者６承認

            ApprovalCode_6,                                                     // ■承認者コード_6

            ApprovalAuthority_6,                                                // ■承認権限区分_6

            ApprovalDate_6,                                                     // ■承認日付_6

            ApprovalOrder_6,                                                    // ■承認順番_6

            ApprovalName_7,                                                     // 承認者７承認

            ApprovalCode_7,                                                     // ■承認者コード_7

            ApprovalAuthority_7,                                                // ■承認権限区分_7

            ApprovalDate_7,                                                     // ■承認日付_7

            ApprovalOrder_7,                                                    // ■承認順番_7

            ApprovalName_8,                                                     // 承認者８承認

            ApprovalCode_8,                                                     // ■承認者コード_8

            ApprovalAuthority_8,                                                // ■承認権限区分_8

            ApprovalDate_8,                                                     // ■承認日付_8

            ApprovalOrder_8,                                                    // ■承認順番_8

            ApprovalName_9,                                                     // 承認者９承認

            ApprovalCode_9,                                                     // ■承認者コード_9

            ApprovalAuthority_9,                                                // ■承認権限区分_9

            ApprovalDate_9,                                                     // ■承認日付_9

            ApprovalOrder_9,                                                    // ■承認順番_9

            ApprovalName_10,                                                    // 承認者１０承認

            ApprovalCode_10,                                                    // ■承認者コード_10

            ApprovalAuthority_10,                                               // ■承認権限区分_10

            ApprovalDate_10,                                                    // ■承認日付_10

            ApprovalOrder_10,                                                   // ■承認順番_10

        }

        /// <summary>

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

        /// </summary>

        private enum ClickGetData

        {

            OrderersDivision = 0,

            OrderersCode,

            TargetDate,

            SeqNo,

            DepositDate,

            DepositAmountCash,

            DepositAmountBill,

            CorporateStatusName,

            CorporateStatusPoint,

            OrderersName1,

            OrderersName2,

            LineCount,

            RequestNo,

            OrderNo,

            DepositAmount,

            DiscountAmount,

            CnstrPrice,

            Fees,

            OtherAdjustments,

            CarryAmount,

            ApprovalPersonCode,

            ApprovalDate,

            ApprovalEndFlg,

            PersonName,

            DepartmentCode,

            BillCreationDate,

            BillPrice,

            TaxPrice,

            ConstructionCode,

            ConstructionPersonCode,

            ConstrSubPersonCode,

            ConstructionInstructor,

            DetailNo,

            DetailString,

            ApprovalPersonName1,

            ApprovalPerson1,

            ApprovalAuthority1,

            ApprovalDate1,

            ApprovalPersonName2,

            ApprovalPerson2,

            ApprovalAuthority2,

            ApprovalDate2,

            ApprovalPersonName3,

            ApprovalPerson3,

            ApprovalAuthority3,

            ApprovalDate3,

            ApprovalPersonName4,

            ApprovalPerson4,

            ApprovalAuthority4,

            ApprovalDate4,

            ApprovalPersonName5,

            ApprovalPerson5,

            ApprovalAuthority5,

            ApprovalDate5,

            ApprovalPersonName6,

            ApprovalPerson6,

            ApprovalAuthority6,

            ApprovalDate6,

            ApprovalPersonName7,

            ApprovalPerson7,

            ApprovalAuthority7,

            ApprovalDate7,

            ApprovalPersonName8,

            ApprovalPerson8,

            ApprovalAuthority8,

            ApprovalDate8,

            ApprovalPersonName9,

            ApprovalPerson9,

            ApprovalAuthority9,

            ApprovalDate9,

            ApprovalPersonName10,

            ApprovalPerson10,

            ApprovalAuthority10,

            ApprovalDate10

        }

        /// <summary>

        /// 承認情報

        /// </summary>

        private class ApproveData

        {

            public int Key { get; set; }

            public string Value { get; set; }

            public int Order { get; set; }

            public int ApprovalAuthority { get; set; }

        }

        /// <summary>

        /// 入金請求先情報

        /// </summary>

        private class DepositOrderer

        {

            public bool Added = false;

            private bool deleted = false;

            public bool Deleted

            {

                get { return deleted && Deposits.All(d => d.Deleted); }

                set

                {

                    deleted = value;

                    foreach (var deposit in Deposits)

                    {

                        deposit.Deleted = value;

                    }

                }

            }

            public int No;

            public int OrderersDivision;

            public int OrderersCode;

            public string OrderersName;

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

            public List<Deposit> VisibleDeposits

            {

                get { return Deposits.Where(d => !d.Deleted).ToList(); }

            }

            public List<DepositDetail> DepositDetails = new List<DepositDetail>();

            public List<DepositDetail> VisibleDepositDetails

            {

                get { return DepositDetails.Where(dd => dd.Visible && !dd.Deleted).ToList(); }

            }

            public int Size

            {

                get { return Math.Max(Math.Max(VisibleDeposits.Count, VisibleDepositDetails.Count), 1); }

            }

            public Deposit FindDepositBySeqNo(int seqNo)

            {

                return Deposits.Find(d => d.SeqNo == seqNo);

            }

            public DepositDetail FindDepositDetailByLineCount(int lineCount)

            {

                return DepositDetails.Find(dd => dd.LineCount == lineCount);

            }

            public int GetNextSeqNo()

            {

                if (Deposits.Count == 0)

                    return 1;

                return Deposits.Max(d => d.SeqNo) + 1;

            }

            public int GetNextLineCount()

            {

                if (DepositDetails.Count == 0)

                    return 1;

                return DepositDetails.Max(dd => dd.LineCount) + 1;

            }

            public bool HasApprovedByStaff

            {

                get

                {

                    if (DepositDetails.Count == 0)

                        return false;

                    return DepositDetails.Any(dd => dd.IsApprovedByStaff);

                }

            }

            public bool HasApprovedByApprover

            {

                get

                {

                    if (DepositDetails.Count == 0)

                        return false;

                    return DepositDetails.Any(dd => dd.IsApprovedByApprover);

                }

            }

            public bool HasApprovedByLastApprover

            {

                get

                {

                    if (DepositDetails.Count == 0)

                        return false;

                    return DepositDetails.Any(dd => dd.IsApprovedByLastApprover);

                }

            }

        }

        /// <summary>

        /// 入金情報

        /// </summary>

        private class Deposit

        {

            public bool Added = false;

            public bool Editted = false;

            public bool Deleted = false;

            public int SeqNo;

            public string DepositDate;

            public long? DepositAmountCash;

            public long? DepositAmountBill;

            public bool CanRemove

            {

                get

                {

                    // 追加行かつ未入力の場合

                    return Added

                        && string.IsNullOrEmpty(DepositDate)

                        && !DepositAmountCash.HasValue

                        && !DepositAmountBill.HasValue;

                }

            }

        }

        /// <summary>

        /// 入金明細情報

        /// </summary>

        private class DepositDetail

        {

            public bool Added = false;

            public bool Editted = false;

            public bool Deleted = false;

            public bool Visible;

            public int SeqNo;

            public int LineCount;

            public int RequestNo;

            public int OrderNo;

            public string ConstructionName;

            public string ConstructionNameRow;

            public string BillCreationDate;

            public long BillPrice;

            public long TaxPrice;

            public long DepositAmount;

            public long DiscountAmount;

            public long CnstrPrice;

            public long Fees;

            public long OtherAdjustments;

            public long CarryAmount;

            public string ApprovalPersonName;

            public int ApprovalPersonCode;

            public string ApprovalDate;

            public int ApprovalEndFlg;

            public int DepartmentCode;

            public int ConstructionCode;

            public int ConstructionPersonCode;

            public int ConstrSubPersonCode;

            public int ConstructionInstructor;

            public ApprovalStatus Status = ApprovalStatus.None;

            public bool UpperApprovalInUser = false;

            public List<DepositApproval> DepositApprovals = new List<DepositApproval>();

            public bool IsApprovedByStaff

            {

                get { return !string.IsNullOrEmpty(ApprovalDate); }

            }

            public bool IsApprovedByApprover

            {

                get

                {

                    if (DepositApprovals.Count == 0)

                        return false;

                    return DepositApprovals.First().ApprovalDate != "";

                }

            }

            public bool IsApprovedByLastApprover

            {

                get

                {

                    if (DepositApprovals.Count == 0)

                        return false;

                    return DepositApprovals.Last().ApprovalDate != "";

                }

            }

        }

        /// <summary>

        /// 入金確認承認情報

        /// </summary>

        private class DepositApproval

        {

            public bool Added = false;

            public bool Editted = false;

            public int ApprovalNo;

            public int ApprovalPerson;

            public string ApprovalPersonName;

            public int ApprovalAuthority;

            public string ApprovalDate;

        }

        private List<DepositOrderer> depositOrderers;

        ///// <summary>編集前のセルの内容</summary>

        //private string oldCellValue = "";

        /// <summary>データ表示の対象営業期</summary>

        private int m_Select_TargetBusinessPeriod = 0;

        /// <summary>データ表示の対象月</summary>

        private int m_Select_TargetDate = 0;

        /// <summary>データ表示の対象部署</summary>

        private int m_Select_TargetDepartment = 0;

        /// <summary>データ表示の対象担当者</summary>

        private int m_Select_TargetPerson = 0;

        /// <summary> ユーザー情報</summary>

        private ClsSecurityPermission.UserInfo m_UserInfo = new ClsSecurityPermission.UserInfo()

        {

            m_Type = CommonDefine.SecurityRankPos.NormalAuthority,

            m_GeneralAffairsFlg = 0,

            m_SecRange = ClsSecurityPermission.SecRangeType.InCharge

        };

        /// <summary> 部署コンボボックス用リスト</summary>

        public List<KeyValuePair<int, String>> listDepartment = new List<KeyValuePair<int, String>>();

        /// <summary> 担当者コンボボックス用リスト</summary>

        public List<KeyValuePair<int, String>> listPerson = new List<KeyValuePair<int, String>>();

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

        public FrmSalesConfirm()

        {

            InitializeComponent();

        }

        #endregion

        #region フォームロード

        /// <summary>

        /// フォームロードイベント

        /// </summary>

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

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

        private void FrmSalesConfirm_Load(object sender, EventArgs e)

        {

            try

            {

                //////////////////////////////////////////////////////////////////////////////

                // ■画面表示時のイベントを停止

                //////////////////////////////////////////////////////////////////////////////

                radioButton1.CheckedChanged -= new System.EventHandler(this.radioButton1_CheckedChanged);

                comboBox1.SelectedIndexChanged -= new System.EventHandler(this.comboBox1_SelectedIndexChanged);

                comboBox2.SelectedIndexChanged -= new System.EventHandler(this.comboBox2_SelectedIndexChanged);

                comboBox3.SelectedIndexChanged -= new System.EventHandler(this.comboBox3_SelectedIndexChanged);

                numericUpDown2.ValueChanged -= new System.EventHandler(this.numericUpDown2_ValueChanged);

                ///////////////////////////////////////////////////////////////////////////

                // ■表示条件設定

                ///////////////////////////////////////////////////////////////////////////

                // 営業期

                int minval = 0;

                int maxval = 0;

                CommonMotions.GetPeriodYear(ref minval, ref maxval);

                // 最大営業期

                numericUpDown2.Maximum = maxval;

                // 最小営業期

                numericUpDown2.Minimum = minval;

                // 初期値は現在の営業期

                numericUpDown2.Value = CommonMotions.SystemMasterData.BusinessPeriod;

                // 対象月

                comboBox1.Items.Add("　");

                for (int iMonthCount = 1; iMonthCount < 13; iMonthCount++)

                {

                    comboBox1.Items.Add(iMonthCount);

                }

                comboBox1.SelectedIndex = 0;

                // 部署

                this.listDepartment = getDepartmentList(0);

                comboBox2.DataSource = listDepartment;

                comboBox2.SelectedIndex = 0;

                // 担当者

                this.listPerson = getPersonList(0);

                comboBox3.DataSource = listPerson;

                comboBox3.SelectedIndex = 0;

                // イベントを停止させているため、強制的に非活性にする

                comboBox1.Enabled = false;

                // 初期フォーカスはラジオボタン（通年）

                radioButton1.Checked = true;

                ///////////////////////////////////////////////////////////////////////////

                // ■一覧表示設定

                ///////////////////////////////////////////////////////////////////////////

                // ユーザ権限設定

                ClsSecurityPermission.SetUserType(m_UserInfo);

                // ちらつきを抑えるため、ダブルバッファリングを有効にする。

                dgvMaster.GetType().InvokeMember("DoubleBuffered", BindingFlags.NonPublic | BindingFlags.Instance | BindingFlags.SetProperty,

                    null, dgvMaster, new object[] { true });

                // 一覧のヘッダ色を設定する

                SetGridHeaderColor();

                // 一覧表示情報を取得する

                DisplayData();

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                radioButton1.CheckedChanged += new System.EventHandler(this.radioButton1_CheckedChanged);

                comboBox1.SelectedIndexChanged += new System.EventHandler(this.comboBox1_SelectedIndexChanged);

                comboBox2.SelectedIndexChanged += new System.EventHandler(this.comboBox2_SelectedIndexChanged);

                comboBox3.SelectedIndexChanged += new System.EventHandler(this.comboBox3_SelectedIndexChanged);

                numericUpDown2.ValueChanged += new System.EventHandler(this.numericUpDown2_ValueChanged);

            }

        }

        #endregion

        #region フォームクローズ

        /// <summary>

        /// フォームクローズイベント

        /// </summary>

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

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

        private void FrmSalesConfirm_FormClosing(object sender, FormClosingEventArgs e)

        {

            try

            {

                //if (m_CloseingProcessOff) return;

                //if (isDirty)

                //{

                //    if (MessageBox.Show("データに変更があります、登録せずに終了してよろしいですか？。", "終了確認"

                //                    , MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)

                //    {

                //        e.Cancel = true;

                //        return;

                //    }

                //}

                // 前プロセスに戻る

                ClsExcute.BackProcess();

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 部署情報取得

        /// <summary>

        /// 部署情報取得

        /// </summary>

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

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

        private List<KeyValuePair<int, String>> getDepartmentList(int iPersonCode)

        {

            var listDepartment = new List<KeyValuePair<int, String>>();

            listDepartment.Add(new KeyValuePair<int, String>(0, "すべて"));

            var listResultSQL = new ArrayList();

            listResultSQL = getDepartmentListQuery(iPersonCode);

            foreach (object[] result in listResultSQL)

            {

                int iDepartmentCode = CommonMotions.cnvInt(result[0]);

                String strDepartmentName = CommonMotions.cnvString(result[1]);

                listDepartment.Add(new KeyValuePair<int, String>(iDepartmentCode, strDepartmentName));

            }

            return listDepartment;

        }

        /// <summary>

        /// 部署情報取得SQL実行

        /// </summary>

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

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

        private ArrayList getDepartmentListQuery(int iPersonCode)

        {

            var depDb = new IODepositData();

            try

            {

                var sql = new StringBuilder();

                sql.Append("SELECT ");

                sql.Append("DEPM.DepartmentCode ");                                          // 部署マスタ．部署コード

                sql.Append(",DEPM.DepartmentString ");                                          // 部署マスタ．部署名

                sql.Append("FROM ");

                sql.Append("departmentmaster DEPM ");                                          // 部署マスタ

                /////////////////////////////////////////////////////////////////////////////

                // 検索条件(動的)START

                /////////////////////////////////////////////////////////////////////////////

                if (!iPersonCode.Equals(0))

                {

                    sql.Append("INNER JOIN personinchargemaster PERIM ");                      // 担当者マスタ

                    sql.Append("ON DEPM.DepartmentCode = PERIM.DepartmentCode ");             // 担当者マスタ．部署コード = 部署マスタ．部署コード

                    sql.AppendFormat("AND PERIM.PersonCode = {0} ", iPersonCode);             // 担当者マスタ．担当者コード = 画面．担当者コード（隠し項目）

                }

                /////////////////////////////////////////////////////////////////////////////

                // 検索条件(動的)END

                /////////////////////////////////////////////////////////////////////////////

                sql.Append("WHERE ");

                sql.Append("DEPM.DeleteFlg = 0 ");                                          // 部署マスタ．削除フラグ = 0

                sql.Append("ORDER BY  ");

                sql.Append("DEPM.DisplayOrder ASC");                                          // 部署マスタ．表示順（昇順）

                var data = new ArrayList();

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

            {

                depDb.close();

                depDb = null;

            }

        }

        #endregion

        #region 担当者情報取得

        /// <summary>

        /// 担当者情報取得

        /// </summary>

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

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

        private List<KeyValuePair<int, String>> getPersonList(int iDepartmentCode)

        {

            var listPerson = new List<KeyValuePair<int, String>>();

            listPerson.Add(new KeyValuePair<int, String>(0, "すべて"));

            var listResultSQL = new ArrayList();

            listResultSQL = getPersonListQuery(iDepartmentCode);

            foreach (object[] result in listResultSQL)

            {

                int iResultPersonCode = CommonMotions.cnvInt(result[0]);

                String strResultPersonName = CommonMotions.cnvString(result[1]);

                listPerson.Add(new KeyValuePair<int, String>(iResultPersonCode, strResultPersonName));

            }

            return listPerson;

        }

        /// <summary>

        /// 担当者情報取得SQL実行

        /// </summary>

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

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

        private ArrayList getPersonListQuery(int iDepartmentCode)

        {

            var depDb = new IODepositData();

            try

            {

                var sql = new StringBuilder();

                sql.Append("SELECT ");

                sql.Append("PERIM.PersonCode ");                                          // 担当者マスタ．担当者コード

                sql.Append(",PERIM.PersonName ");                                          // 担当者マスタ．担当者名

                sql.Append("FROM ");

                sql.Append("personinchargemaster PERIM ");                                          // 担当者マスタ

                sql.Append("WHERE ");

                sql.Append("PERIM.DeleteFlg = 0 ");                                          // 部署マスタ．削除フラグ = 0

                /////////////////////////////////////////////////////////////////////////////

                // 検索条件(動的)START

                /////////////////////////////////////////////////////////////////////////////

                if (!iDepartmentCode.Equals(0))

                {

                    sql.AppendFormat("AND PERIM.DepartmentCode = {0} ", iDepartmentCode);             // 担当者マスタ．担当者コード = 画面．部署コード（隠し項目）

                }

                /////////////////////////////////////////////////////////////////////////////

                // 検索条件(動的)END

                /////////////////////////////////////////////////////////////////////////////

                sql.Append("ORDER BY  ");

                sql.Append("PERIM.DisplayOrder ASC");                                          // 部署マスタ．表示順（昇順）

                var data = new ArrayList();

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

            {

                depDb.close();

                depDb = null;

            }

        }

        #endregion

        #region 入金請求先一覧表示

        /// <summary>

        /// データを表示する。

        /// </summary>

        private void DisplayData()

        {

            try

            {

                ///////////////////////////////////////////////////////////////////////////////////////

                // 表示条件の取得

                ///////////////////////////////////////////////////////////////////////////////////////

                //　営業期

                m_Select_TargetBusinessPeriod = CommonMotions.cnvInt(numericUpDown2.Value);

                //　対象月（月指定が選択されているかつ空白以外の場合のみ）

                if (radioButton2.Checked && !CommonMotions.cnvInt(comboBox1.SelectedItem).Equals("　"))

                {

                    m_Select_TargetDate = CommonMotions.cnvInt(comboBox1.SelectedItem);

                }

                else

                {

                    m_Select_TargetDate = 0;

                }

                //　部署

                m_Select_TargetDepartment = CommonMotions.cnvInt(comboBox2.SelectedValue);

                //  担当者

                m_Select_TargetPerson = CommonMotions.cnvInt(comboBox3.SelectedValue); ;

                ///////////////////////////////////////////////////////////////////////////////////////////

                // データの取得

                ///////////////////////////////////////////////////////////////////////////////////////////

                depositOrderers = new List<DepositOrderer>();

                dgvMaster.Rows.Clear();

                depositOrderers = SelectDepositOrderers();

                // 請求先単位で設定を行う。

                dgvMaster.SuspendLayout();

                for (var i = (int)DispColumn.ApprovalName_1; i <= (int)DispColumn.ApprovalName_10; i += 5)

                    dgvMaster.Columns[i].Visible = false;

                foreach (var deposit in depositOrderers)

                {

                    AddDepositOrdererRows(deposit, dgvMaster.RowCount);

                }

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                dgvMaster.ResumeLayout();

                if (dgvMaster.Rows.Count > 0)

                {

                    dgvMaster.FirstDisplayedScrollingRowIndex = 0;

                    dgvMaster.FirstDisplayedScrollingColumnIndex = 1;

                    dgvMaster.CurrentCell = dgvMaster[1, 0];

                }

            }

        }

        #endregion

        #region 入金請求先一覧作成

        #region 入金請求先一覧作成

        /// <summary>

        /// 入金請求先一覧を取得する。

        /// </summary>

        /// <returns></returns>

        private List<DepositOrderer> SelectDepositOrderers()

        {

            var depositData = SelectDepositDataAll().OfType<object[]>()

                .GroupBy(d =>

                {

                    return string.Format("{0} {1}",

                        CommonMotions.cnvInt(d[(int)ClickGetData.OrderersDivision]),

                        CommonMotions.cnvInt(d[(int)ClickGetData.OrderersCode]));

                });

            var data = new List<DepositOrderer>();

            var no = 1;

            foreach (var deposits in depositData)

            {

                var orderer = deposits.First();

                // 請求先情報

                var o = new DepositOrderer();

                o.OrderersDivision = CommonMotions.cnvInt(orderer[(int)ClickGetData.OrderersDivision]);

                o.OrderersCode = CommonMotions.cnvInt(orderer[(int)ClickGetData.OrderersCode]);

                o.OrderersName = ToOrdererName(CommonMotions.cnvInt(orderer[(int)ClickGetData.CorporateStatusPoint]),

                                        CommonMotions.cnvString(orderer[(int)ClickGetData.CorporateStatusName]),

                                        CommonMotions.cnvString(orderer[(int)ClickGetData.OrderersName1]),

                                        CommonMotions.cnvString(orderer[(int)ClickGetData.OrderersName2]));

                // 表示権限がない場合は次へ

                if (!CheckOrdererPermission(o))

                {

                    continue;

                }

                o.No = no;

                no++;

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

                o.DepositDetails = new List<DepositDetail>();

                // 入金データ情報

                foreach (var deposit in deposits)

                {

                    var d = new Deposit();

                    d.SeqNo = CommonMotions.cnvInt(deposit[(int)ClickGetData.SeqNo]);

                    d.DepositDate = CommonMotions.cnvString(deposit[(int)ClickGetData.DepositDate]);

                    d.DepositAmountCash = CommonMotions.cnvInt(deposit[(int)ClickGetData.DepositAmountCash]);

                    d.DepositAmountBill = CommonMotions.cnvInt(deposit[(int)ClickGetData.DepositAmountBill]);

                    o.Deposits.Add(d);

                }

                // 入金明細データ

                var details = SelectDepositDetailData(o.OrderersDivision, o.OrderersCode).OfType<object[]>();

                foreach (var detail in details)

                {

                    var dd = new DepositDetail();

                    dd.SeqNo = CommonMotions.cnvInt(detail[(int)ClickGetData.SeqNo]);

                    dd.LineCount = CommonMotions.cnvInt(detail[(int)ClickGetData.LineCount]);

                    dd.RequestNo = CommonMotions.cnvInt(detail[(int)ClickGetData.RequestNo]);

                    dd.OrderNo = CommonMotions.cnvInt(detail[(int)ClickGetData.OrderNo]);

                    dd.ConstructionNameRow = CommonMotions.cnvString(detail[(int)ClickGetData.DetailString]);

                    dd.ConstructionName = dd.ConstructionNameRow;

                    if (dd.OrderNo > 1)

                    {

                        dd.ConstructionName += "（" + dd.OrderNo + "回目）";

                    }

                    // 入金予定日未実装

                    dd.BillCreationDate = CommonMotions.cnvString(detail[(int)ClickGetData.BillCreationDate]);

                    dd.BillPrice = CommonMotions.cnvLong(detail[(int)ClickGetData.BillPrice]);

                    dd.TaxPrice = CommonMotions.cnvLong(detail[(int)ClickGetData.TaxPrice]);

                    dd.DepositAmount = CommonMotions.cnvLong(detail[(int)ClickGetData.DepositAmount]);

                    dd.DiscountAmount = CommonMotions.cnvLong(detail[(int)ClickGetData.DiscountAmount]);

                    dd.CnstrPrice = CommonMotions.cnvLong(detail[(int)ClickGetData.CnstrPrice]);

                    dd.Fees = CommonMotions.cnvLong(detail[(int)ClickGetData.Fees]);

                    dd.OtherAdjustments = CommonMotions.cnvLong(detail[(int)ClickGetData.OtherAdjustments]);

                    dd.CarryAmount = CommonMotions.cnvLong(detail[(int)ClickGetData.CarryAmount]);

                    dd.ApprovalPersonCode = CommonMotions.cnvInt(detail[(int)ClickGetData.ApprovalPersonCode]);

                    dd.ApprovalEndFlg = CommonMotions.cnvInt(detail[(int)ClickGetData.ApprovalEndFlg]);

                    dd.ApprovalPersonName = CommonMotions.cnvString(detail[(int)ClickGetData.PersonName]);

                    dd.DepartmentCode = CommonMotions.cnvInt(detail[(int)ClickGetData.DepartmentCode]);

                    dd.ConstructionCode = CommonMotions.cnvInt(detail[(int)ClickGetData.ConstructionCode]);

                    dd.ConstructionPersonCode = CommonMotions.cnvInt(detail[(int)ClickGetData.ConstructionPersonCode]);

                    dd.ConstrSubPersonCode = CommonMotions.cnvInt(detail[(int)ClickGetData.ConstrSubPersonCode]);

                    dd.ConstructionInstructor = CommonMotions.cnvInt(detail[(int)ClickGetData.ConstructionInstructor]);

                    dd.DepositApprovals = new List<DepositApproval>();

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

                    dd.ApprovalDate = "";

                    if (CommonMotions.cnvString(detail[(int)ClickGetData.ApprovalDate]) != "0001-01-01")

                        dd.ApprovalDate = CommonMotions.cnvString(detail[(int)ClickGetData.ApprovalDate]);

                    // 担当者承認済みの場合

                    if (dd.IsApprovedByStaff)

                    {

                        var depositApprovals = new List<DepositApprovalInfo>();

                        if (!SelectApprove(o.OrderersDivision, o.OrderersCode, dd.SeqNo, dd.LineCount, ref depositApprovals))

                            return null;

                        var detectApproval = false;

                        var detectNonApproval = false;

                        var upperApprovalInUser = false;

                        foreach (var appInfo in depositApprovals)

                        {

                            var da = new DepositApproval()

                            {

                                ApprovalNo = appInfo.ApprovalNo,

                                ApprovalPersonName = appInfo.ApprovalPersonName,

                                ApprovalPerson = appInfo.ApprovalPerson,

                                ApprovalAuthority = appInfo.ApprovalAuthority,

                                ApprovalDate = "",

                            };

                            if (appInfo.ApprovalDate != DateTime.MinValue)

                                da.ApprovalDate = appInfo.ApprovalDate.ToString("yyyy-MM-dd");

                            dd.DepositApprovals.Add(da);

                        }

                        // 承認状態を設定

                        if (!detectApproval)

                            dd.Status = ApprovalStatus.InCharge;

                        else if (detectNonApproval)

                            dd.Status = ApprovalStatus.InApproval;

                        else

                            dd.Status = ApprovalStatus.Approved;

                        dd.UpperApprovalInUser = upperApprovalInUser;

                    }

                    // 担当者未承認

                    else

                    {

                        var defaultApproves = new List<ApproveData>();

                        if (!SelectDefaultApprove(dd.DepartmentCode, ref defaultApproves))

                            return null;

                        foreach (var approve in defaultApproves)

                        {

                            var da = new DepositApproval()

                            {

                                Added = true,

                                ApprovalPersonName = approve.Value,

                                ApprovalPerson = approve.Key,

                                ApprovalDate = "",

                                ApprovalNo = approve.Order,

                            };

                            dd.DepositApprovals.Add(da);

                        }

                    }

                    o.DepositDetails.Add(dd);

                }

                data.Add(o);

            }

            return data;

        }

        #endregion

        #region 業者行を追加する

        /// <summary>

        /// 業者行を追加する。

        /// </summary>

        /// <param name="depositOrderer"></param>

        /// <param name="position"></param>

        private void AddDepositOrdererRows(DepositOrderer depositOrderer, int position)

        {

            try

            {

                if (depositOrderer.Deleted)

                    return;

                // 明細行を作成

                dgvMaster.Rows.Insert(position, depositOrderer.Size);

                // いったんすべての行をReadOnlyにしておく

                for (var i = position; i < position + depositOrderer.Size; i++)

                    dgvMaster.Rows[i].ReadOnly = true;

                var ordererRow = dgvMaster.Rows[position];

                // 請求先情報の表示

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

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

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

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

                // 入金情報の表示

                var index = 0;

                foreach (var deposit in depositOrderer.VisibleDeposits)

                {

                    var row = dgvMaster.Rows[position + index];

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

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

                    row.Cells[(int)DispColumn.SeqNo].Value = deposit.SeqNo;

                    row.Cells[(int)DispColumn.DepositDate].Value = deposit.DepositDate;

                    if (deposit.DepositAmountCash.HasValue)

                        SetPrice(row.Cells, (int)DispColumn.DepositAmountCash, deposit.DepositAmountCash.Value);

                    if (deposit.DepositAmountBill.HasValue)

                        SetPrice(row.Cells, (int)DispColumn.DepositAmountBill, deposit.DepositAmountBill.Value);

                    index++;

                }

                index = 0;

                foreach (var depositDetail in depositOrderer.VisibleDepositDetails)

                {

                    var row = dgvMaster.Rows[position + index];

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

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

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

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

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

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

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

                    // TODO 入金予定日

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

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

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

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

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

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

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

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

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

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

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

                    // 担当者未承認

                    if (!depositDetail.IsApprovedByStaff)

                    {

                        row.Cells[(int)DispColumn.PersonName].Style.ForeColor = Color.Gray;

                        row.Cells[(int)DispColumn.PersonDate].Value = "";

                    }

                    var j = (int)DispColumn.ApprovalName_1;

                    foreach (var depositeApproval in depositDetail.DepositApprovals)

                    {

                        row.Cells[j].Value = depositeApproval.ApprovalPersonName;

                        row.Cells[j + 1].Value = depositeApproval.ApprovalPerson;

                        if (depositeApproval.ApprovalDate == "")

                            row.Cells[j].Style.ForeColor = Color.Gray;

                        dgvMaster.Columns[j].Visible = true;

                        j += 5;

                    }

                    index++;

                }

                AddBlankRow(depositOrderer, position);

                AddTotalRow(depositOrderer, position);

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 編集可否判定（入金明細データ）

        #region 編集可否判定

        //private bool CanEditDepositDetail(DepositDetail depositDetail)

        //{

        //    // 担当者の場合

        //    if (m_UserInfo.m_Type == CommonDefine.SecurityRankPos.NormalAuthority)

        //    {

        //        // 承認済みなら編集不可

        //        if (depositDetail.IsApprovedByStaff || depositDetail.IsApprovedByApprover)

        //            return false;

        //    }

        //    // 所属長、統括者の場合

        //    else if (m_UserInfo.m_Type == CommonDefine.SecurityRankPos.LimitedAuthority || m_UserInfo.m_Type == CommonDefine.SecurityRankPos.FreeAuthority)

        //    {

        //        // 上位の承認者でなければ編集不可

        //        if (!IsUpperLevelApprover(depositDetail))

        //            return false;

        //    }

        //    // 特別権限の場合

        //    else if (m_UserInfo.m_Type == CommonDefine.SecurityRankPos.SpecialAuthority)

        //    {

        //        if (depositDetail.IsApprovedByLastApprover)

        //            return false;

        //    }

        //    return m_UserInfo.CanEditDepositDetail;

        //}

        #endregion

        #region 上位承認者存在チェック

        //private bool IsUpperLevelApprover(DepositDetail depositDetail)

        //{

        //    if (depositDetail.DepositApprovals.Count == 0)

        //        return true;

        //    var lastApproverIndex = depositDetail.DepositApprovals.FindLastIndex(da => da.ApprovalDate != "");

        //    var myIndex = depositDetail.DepositApprovals.FindLastIndex(da => da.ApprovalPerson == CommonMotions.LoginUserData.PersonCode);

        //    return myIndex > lastApproverIndex;

        //}

        #endregion

        #endregion

        #region 編集用空白行追加

        /// <summary>

        /// 編集用空白行追加

        /// </summary>

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

        private void AddBlankRow(DepositOrderer depositOrderer, int index)

        {

            var headerIndex = DetectHeaderIndex(index);

            var headerCells = dgvMaster.Rows[headerIndex].Cells;

            var blankIndex = dgvMaster.RowCount;

            for (var i = headerIndex; i < dgvMaster.RowCount; i++)

            {

                var cells = dgvMaster.Rows[i].Cells;

                if (CommonMotions.cnvInt(headerCells[(int)DispColumn.OrderersDivision].Value) != CommonMotions.cnvInt(cells[(int)DispColumn.OrderersDivision].Value)

                    || CommonMotions.cnvInt(headerCells[(int)DispColumn.OrderersCode].Value) != CommonMotions.cnvInt(cells[(int)DispColumn.OrderersCode].Value))

                {

                    blankIndex = i;

                    break;

                }

            }

            dgvMaster.Rows.Insert(blankIndex);

            var row = dgvMaster.Rows[blankIndex];

            row.ReadOnly = true;

            row.Cells[(int)DispColumn.OrderersDivision].Value = headerCells[(int)DispColumn.OrderersDivision].Value;

            row.Cells[(int)DispColumn.OrderersCode].Value = headerCells[(int)DispColumn.OrderersCode].Value;

        }

        #endregion

        #region 合計行の設定を行う

        /// <summary>

        /// 合計行の設定を行う。

        /// </summary>

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

        private void AddTotalRow(DepositOrderer depositOrderer, int index)

        {

            long depositAmountCash = 0;

            long depositAmountBill = 0;

            foreach (var deposit in depositOrderer.Deposits)

            {

                depositAmountCash += deposit.DepositAmountCash.GetValueOrDefault(0);

                depositAmountBill += deposit.DepositAmountBill.GetValueOrDefault(0);

            }

            long billPrice = 0;

            long taxPrice = 0;

            long depositAmount = 0;

            long discountAmount = 0;

            long cnstrPrice = 0;

            long fees = 0;

            long otherAdjustments = 0;

            long carryAmount = 0;

            foreach (var depositDetail in depositOrderer.DepositDetails)

            {

                billPrice += depositDetail.BillPrice;

                taxPrice += depositDetail.TaxPrice;

                depositAmount += depositDetail.DepositAmount;

                discountAmount += depositDetail.DiscountAmount;

                cnstrPrice += depositDetail.CnstrPrice;

                fees += depositDetail.Fees;

                otherAdjustments += depositDetail.OtherAdjustments;

                carryAmount += depositDetail.CarryAmount;

            }

            var headerIndex = DetectHeaderIndex(index);

            var headerCells = dgvMaster.Rows[headerIndex].Cells;

            var subtotalIndex = dgvMaster.RowCount;

            for (var i = headerIndex; i < dgvMaster.RowCount; i++)

            {

                var cells = dgvMaster.Rows[i].Cells;

                if (CommonMotions.cnvInt(headerCells[(int)DispColumn.OrderersDivision].Value) != CommonMotions.cnvInt(cells[(int)DispColumn.OrderersDivision].Value)

                    || CommonMotions.cnvInt(headerCells[(int)DispColumn.OrderersCode].Value) != CommonMotions.cnvInt(cells[(int)DispColumn.OrderersCode].Value))

                {

                    subtotalIndex = i;

                    break;

                }

            }

            dgvMaster.Rows.Insert(subtotalIndex, 4);

            // 小計

            dgvMaster.Rows[subtotalIndex].DefaultCellStyle.BackColor = Color.Coral;

            dgvMaster.Rows[subtotalIndex].ReadOnly = true;

            var subtotalCells = dgvMaster.Rows[subtotalIndex].Cells;

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

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

            subtotalCells[(int)DispColumn.OrderersName].Value = "小計";

            SetPrice(subtotalCells, (int)DispColumn.DepositAmountCash, depositAmountCash);

            SetPrice(subtotalCells, (int)DispColumn.DepositAmountBill, depositAmountBill);

            SetPrice(subtotalCells, (int)DispColumn.BillPrice, billPrice);

            SetPrice(subtotalCells, (int)DispColumn.TaxPrice, taxPrice);

            SetPrice(subtotalCells, (int)DispColumn.DepositAmount, depositAmount);

            SetPrice(subtotalCells, (int)DispColumn.DiscountAmount, discountAmount);

            SetPrice(subtotalCells, (int)DispColumn.CnstrPrice, cnstrPrice);

            SetPrice(subtotalCells, (int)DispColumn.Fees, fees);

            SetPrice(subtotalCells, (int)DispColumn.OtherAdjustments, otherAdjustments);

            SetPrice(subtotalCells, (int)DispColumn.CarryAmount, carryAmount);

            // 入金金額

            dgvMaster.Rows[subtotalIndex + 1].DefaultCellStyle.BackColor = Color.Yellow;

            dgvMaster.Rows[subtotalIndex + 1].ReadOnly = true;

            var depositCells = dgvMaster.Rows[subtotalIndex + 1].Cells;

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

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

            depositCells[(int)DispColumn.OrderersName].Value = "入金金額";

            SetPrice(depositCells, (int)DispColumn.DepositAmountCash, depositAmountCash + depositAmountBill);

            // 調整後金額

            dgvMaster.Rows[subtotalIndex + 2].DefaultCellStyle.BackColor = Color.PaleTurquoise;

            dgvMaster.Rows[subtotalIndex + 2].ReadOnly = true;

            var adjustmentCells = dgvMaster.Rows[subtotalIndex + 2].Cells;

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

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

            adjustmentCells[(int)DispColumn.OrderersName].Value = "調整後金額";

            SetPrice(adjustmentCells, (int)DispColumn.DepositAmountCash, depositAmount);

            // 差額

            dgvMaster.Rows[subtotalIndex + 3].DefaultCellStyle.BackColor = Color.Chartreuse;

            dgvMaster.Rows[subtotalIndex + 3].ReadOnly = true;

            var differentCells = dgvMaster.Rows[subtotalIndex + 3].Cells;

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

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

            differentCells[(int)DispColumn.OrderersName].Value = "差額";

            SetPrice(differentCells, (int)DispColumn.DepositAmountCash, depositAmountCash + depositAmountBill - depositAmount);

        }

        #endregion

        #region ヘッダ制御

        /// <summary>

        /// ヘッダ制御

        /// </summary>

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

        private int DetectHeaderIndex(int index)

        {

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

            {

                if (CommonMotions.cnvString(dgvMaster.Rows[i].Cells[(int)DispColumn.OrderersName].Value) != "")

                {

                    return i;

                }

            }

            return 0;

        }

        #endregion

        #region 金額フォーマット

        /// <summary>

        /// 金額フォーマット

        /// </summary>

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

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

        {

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

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

            if (price < 0)

            {

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

            }

        }

        #endregion

        #region 発注者名フォーマット

        /// <summary>

        /// 発注者名フォーマット

        /// </summary>

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

        private string ToOrdererName(int corporateStatusPoint, string corporateStatusName, string orderersName1, string orderersName2)

        {

            // 発注者名１△発注者名２

            if (corporateStatusPoint == 0)

            {

                if (orderersName2 == "")

                {

                    return orderersName1;

                }

                return orderersName1 + "　" + orderersName2;

            }

            // 法人格名称△発注者名１△発注者名２

            else if (corporateStatusPoint == 1)

            {

                if (orderersName2 == "")

                {

                    return corporateStatusName + "　" + orderersName1;

                }

                return corporateStatusName + orderersName1 + orderersName2;

            }

            // 発注者名１△法人格名称△発注者名２

            if (orderersName2 == "")

            {

                return orderersName1 + "　" + corporateStatusName;

            }

            return orderersName1 + corporateStatusName + orderersName2;

        }

        #endregion

        #region DataGridヘッダ色表示

        /// <summary>

        /// DataGridヘッダ色表示

        /// </summary>

        private void SetGridHeaderColor()

        {

            // ヘッダ色、-1:非表示、0:自動計算、1:総務、2：工事

            int[] mc = {

                -1,                     // ■編集状態

                0,                      // No

                -1,                     // ■発注先区分

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

                -1,                     // ■連番

                -1,                     // ■行番号

                0,                      // 請求先名

                1,                      // 入金日

                1,                      // 入金金額 (振込み)

                1,                      // 入金金額 (手形)

                -1,                     // 請求No.

                -1,                     // 受付番号

                0,                      // 現場名

                -1,                     // ■現場名 (DB登録値)

                0,                      // 入金予定日

                0,                      // 請求日

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

                0,                      // 請求金額 (消費税)

                2,                      // 入金金額

                2,                      // 値引金額

                2,                      // 協力金

                2,                      // 手数料

                2,                      // その他調整

                2,                      // 次回繰越

                0,                      // 担当者承認

                -1,                     // ■担当者コード

                -1,                     // ■担当者日付

                0,                      // 承認者１承認

                -1,                     // ■承認者コード_1

                -1,                     // ■承認権限区分_1

                -1,                     // ■承認日付_1

                -1,                     // ■承認順番_1

                0,                      // 承認者２承認

                -1,                     // ■承認者コード_2

                -1,                     // ■承認権限区分_2

                -1,                     // ■承認日付_2

                -1,                     // ■承認順番_2

                0,                      // 承認者３承認

                -1,                     // ■承認者コード_3

                -1,                     // ■承認権限区分_3

                -1,                     // ■承認日付_3

                -1,                     // ■承認順番_3

                0,                      // 承認者４承認

                -1,                     // ■承認者コード_4

                -1,                     // ■承認権限区分_4

                -1,                     // ■承認日付_4

                -1,                     // ■承認順番_4

                0,                      // 承認者５承認

                -1,                     // ■承認者コード_5

                -1,                     // ■承認権限区分_5

                -1,                     // ■承認日付_5

                -1,                     // ■承認順番_5

                0,                      // 承認者６承認

                -1,                     // ■承認者コード_6

                -1,                     // ■承認権限区分_6

                -1,                     // ■承認日付_6

                -1,                     // ■承認順番_6

                0,                      // 承認者７承認

                -1,                     // ■承認者コード_7

                -1,                     // ■承認権限区分_7

                -1,                     // ■承認日付_7

                -1,                     // ■承認順番_7

                0,                      // 承認者８承認

                -1,                     // ■承認者コード_8

                -1,                     // ■承認権限区分_8

                -1,                     // ■承認日付_8

                -1,                     // ■承認順番_8

                0,                      // 承認者９承認

                -1,                     // ■承認者コード_9

                -1,                     // ■承認権限区分_9

                -1,                     // ■承認日付_9

                -1,                     // ■承認順番_9

                0,                      // 承認者１０承認

                -1,                     // ■承認者コード_10

                -1,                     // ■承認権限区分_10

                -1,                     // ■承認日付_10

                -1,                     // ■承認順番_10

            };

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

            dgvMaster.ColumnHeadersHeight = dgvMaster.ColumnHeadersHeight + 10;

            // ヘッダーセルの値の設定

            for (int i = 0; i < 77; i++)

            {

                // ヘッダーセルの色を設定

                // 総務

                if (mc[i] == 1)

                {

                    dgvMaster.Columns[i].HeaderCell.Style.BackColor = Color.Coral;

                }

                // 工事担当者

                else if (mc[i] == 2)

                {

                    dgvMaster.Columns[i].HeaderCell.Style.BackColor = Color.SkyBlue;

                }

                // 表示・自動計算

                else

                {

                    dgvMaster.Columns[i].HeaderCell.Style.BackColor = Color.PaleGreen;

                }

            }

        }

        #endregion

        #region 表示権限チェック①

        /// <summary>

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

        /// </summary>

        /// <param name="orderer"></param>

        /// <returns></returns>

        private bool CheckOrdererPermission(DepositOrderer orderer)

        {

            try

            {

                // 全部署対象

                if (m_UserInfo.m_SecRange == ClsSecurityPermission.SecRangeType.AllDepartment)

                {

                    return true;

                }

                var ioPdm = new IOMPersonDepartment();

                var arDataPdm = new ArrayList();

                var sql = new StringBuilder();

                sql.Append("select count(*) from ConstructionBaseInfo Cbi ");

                sql.Append("inner join PersonInChargeMaster PicM on PicM.PersonCode = Cbi.ConstructionPersonCode ");

                sql.Append("inner join PersonDepartmentMaster PdM on PdM.DepartmentCode = PicM.DepartmentCode ");

                sql.AppendFormat("where Cbi.OrderersDivision = {0} ", orderer.OrderersDivision);

                sql.AppendFormat("and Cbi.OrderersCode = {0} ", orderer.OrderersCode);

                sql.AppendFormat("and PdM.PersonCode = {0} ", CommonMotions.LoginUserData.PersonCode);

                sql.AppendFormat("and PdM.DepartmentCode = {0} ", CommonMotions.LoginUserData.DepartmentCode);

                // 自部門のみ表示の場合

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

                {

                    sql.Append("and Pdm.AffiliationFlg = 1 ");

                }

                // 担当分のみ対象の場合

                else if (m_UserInfo.m_SecRange == ClsSecurityPermission.SecRangeType.InCharge)

                {

                    sql.AppendFormat("and (Cbi.ConstructionPersonCode = {0} ", CommonMotions.LoginUserData.PersonCode);

                    sql.AppendFormat("or Cbi.ConstrSubPersonCode = {0} ", CommonMotions.LoginUserData.PersonCode);

                    sql.AppendFormat("or Cbi.ConstructionInstructor = {0}) ", CommonMotions.LoginUserData.PersonCode);

                }

                if (!ioPdm.ExecuteReader(sql.ToString(), ref arDataPdm))

                    return false;

                return CommonMotions.cnvInt(((object[])arDataPdm[0])[0]) > 0;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 表示権限チェック②

        /// <summary>

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

        /// </summary>

        /// <param name="DepartmentCode"></param>

        /// <param name="ConstructionPersonCode"></param>

        /// <param name="ConstrSubPersonCode"></param>

        /// <param name="ConstructionInstructor"></param>

        /// <returns></returns>

        private bool CheckPermission(int DepartmentCode, int ConstructionPersonCode, int ConstrSubPersonCode, int ConstructionInstructor)

        {

            try

            {

                // 全部署対象

                if (m_UserInfo.m_SecRange == ClsSecurityPermission.SecRangeType.AllDepartment)

                {

                    return true;

                }

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

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

                {

                    var ioPdm = new IOMPersonDepartment();

                    var arDataPdm = new ArrayList();

                    var sql = new StringBuilder();

                    sql.AppendLine("select Pdm.DepartmentCode ");

                    sql.AppendLine("from PersonDepartmentMaster as Pdm ");

                    sql.AppendFormat("where Pdm.PersonCode = {0} ", CommonMotions.LoginUserData.PersonCode);

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

                    {

                        sql.AppendLine("and Pdm.AffiliationFlg = 1 ");

                    }

                    if (!ioPdm.ExecuteReader(sql.ToString(), ref arDataPdm))

                        return false;

                    foreach (object[] work in arDataPdm)

                    {

                        if (CommonMotions.cnvInt(work[0]) == DepartmentCode)

                        {

                            return true;

                        }

                    }

                    return false;

                }

                // 担当分のみ対象

                else

                {

                    if ((CommonMotions.LoginUserData.PersonCode == ConstructionPersonCode) ||