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

        public static int s_SystemVersion = 67;

            ReqSumTotalList = 44,               // 44:手間・通常業者一覧

                                                                                { (int)ProcessExecuteNo.ReqSumTotalList,        "手間・通常業者一覧－表示"},

                        case (int)ProcessExecuteNo.ReqSumTotalList:                     // 44:手間・通常業者一覧

                            break;

        #region 1項目更新処理

        /// <summary>

        /// 1項目の更新を行う

        /// </summary>

        /// <returns></returns>

        public bool UpdateFeild(int SystemCode, int FeildNo, object value, bool bConnect = true)

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.Append("UPDATE SystemMaster");

                strcmd.Append(" SET");

                switch (FeildNo)

                {

                    case (int)SystemColumn.SYSTEMCODE:

                        strcmd.AppendFormat(" SystemCode = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.COMPANYNAME1:

                        strcmd.AppendFormat(" CompanyName1 = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.COMPANYNAME2:

                        strcmd.AppendFormat(" CompanyName2 = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.CEONAME:

                        strcmd.AppendFormat(" CeoName = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.CEOPOSITIONNAME:

                        strcmd.AppendFormat(" CeoName = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.ZIPCODE:

                        strcmd.AppendFormat(" CeoName = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.ADDRESS1:

                        strcmd.AppendFormat(" Address1 = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.ADDRESS2:

                        strcmd.AppendFormat(" Address2 = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.ADDRESS3:

                        strcmd.AppendFormat(" Address3 = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.PHONENUMBER:

                        strcmd.AppendFormat(" PhoneNumber = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.FAXNUMBER:

                        strcmd.AppendFormat(" FaxNumber = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.HOMEPAGEURL:

                        strcmd.AppendFormat(" HomePageURL = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.CONSTRUCTIONEXPENSES:

                        strcmd.AppendFormat(" ConstructionExpenses = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.OFFICEEXPENSES:

                        strcmd.AppendFormat(" OfficeExpenses = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.OPERATINGEXPENSES:

                        strcmd.AppendFormat(" PperatingExpenses = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.CONSUMPTIONTAX:

                        strcmd.AppendFormat(" ConsumptionTax = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.COOPERATIONRATE:

                        strcmd.AppendFormat(" CooperationRate = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.STATUTORYWELFARERATE:

                        strcmd.AppendFormat(" StatutoryWelfareRate = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.FuelPrice:

                        strcmd.AppendFormat(" FuelPrice = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.AreaDistance:

                        strcmd.AppendFormat(" AreaDistance = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.EXCELSAVEPATH:

                        strcmd.AppendFormat(" ExcelSavePath = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.BUSINESSPERIOD:

                        strcmd.AppendFormat(" BusinessPeriod = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.ConstructionYear:

                        strcmd.AppendFormat(" ConstructionYear = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.BusinessBeginningDate:

                        strcmd.AppendFormat(" BusinessBeginningDate = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.ConstructionBeginningDate:

                        strcmd.AppendFormat(" ConstructionBeginningDate = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.ConstructionNoBase:

                        strcmd.AppendFormat(" ConstructionNoBase = {0}", ((int)value).ToString());

                        break;

                    case (int)SystemColumn.SloganString1:

                        strcmd.AppendFormat(" SloganString1 = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.SloganString2:

                        strcmd.AppendFormat(" SloganString2 = '{0}'", value.ToString());

                        break;

                    case (int)SystemColumn.SloganString3:

                        strcmd.AppendFormat(" SloganString3 = '{0}'", value.ToString());

                        break;

                }

                strcmd.Append(", UpdateDate = NOW()");

                strcmd.AppendFormat(" Where SystemCode = {0}", SystemCode);

                if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region ?R?????gToolTip??????

        /// <summary>

        /// ?R?????gToolTip??????

        /// </summary>

        private int s_CommentToolTipLength = 30;

        #endregion

                        treeNode = tvDispData.Nodes.Add(StringBuiltInReturn(CommentList[i].ApproValComment, s_CommentToolTipLength));

        #region 文字列の指定位置に改行コードを入れる

        /// <summary>

        /// 文字列の指定位置に改行コードを入れる

        /// </summary>

        /// <param name="InpString"></param>

        /// <param name="CutLength"></param>

        /// <returns></returns>

        private string StringBuiltInReturn(string InpString, int CutLength)

        {

            try

            {

                List<string> textList = new List<string>();

                for (int i = 0; i < InpString.Length; i += CutLength)

                {

                    if ((i + CutLength) < InpString.Length)

                        textList.Add(InpString.Substring(i, CutLength));

                    else

                        textList.Add(InpString.Substring(i));

                }

                return string.Join("\r\n", textList.ToArray());

            }

            catch (Exception ex)

            {

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

                return string.Empty;

            }

        }

        #endregion

                        tn = treeNode.Nodes.Add(StringBuiltInReturn(DataList[DataIndex].ApproValComment, s_CommentToolTipLength));

                    tvDispData.Nodes.Add(StringBuiltInReturn(DispString, s_CommentToolTipLength));

                    TargetNodes.Nodes.Add(StringBuiltInReturn(DispString, s_CommentToolTipLength));

                NewRec.ApproValComment = strComment.Replace("\r\n", "");

        #region ?R?????gToolTip??????

        /// <summary>

        /// ?R?????gToolTip??????

        /// </summary>

        private int s_CommentToolTipLength = 30;

        #endregion

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

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

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

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

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

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

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

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

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

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

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

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

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

            // dgvEntryData

            // 

            this.dgvEntryData.AllowUserToAddRows = false;

            this.dgvEntryData.AllowUserToDeleteRows = false;

            this.dgvEntryData.AllowUserToResizeColumns = false;

            this.dgvEntryData.AllowUserToResizeRows = false;

            this.dgvEntryData.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));

            this.dgvEntryData.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

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

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

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

            dataGridViewCellStyle1.ForeColor = System.Drawing.Color.White;

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

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

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

            this.dgvEntryData.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;

            this.dgvEntryData.ColumnHeadersHeight = 24;

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

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

            this.Column01,

            this.Column02,

            this.Column03,

            this.Column06,

            this.Column07,

            this.Column04,

            this.Column05});

            this.dgvEntryData.EnableHeadersVisualStyles = false;

            this.dgvEntryData.Location = new System.Drawing.Point(6, 5);

            this.dgvEntryData.Name = "dgvEntryData";

            this.dgvEntryData.RowHeadersVisible = false;

            this.dgvEntryData.RowHeadersWidth = 20;

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

            this.dgvEntryData.RowTemplate.Height = 24;

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

            this.dgvEntryData.Size = new System.Drawing.Size(744, 146);

            this.dgvEntryData.TabIndex = 8;

            // 

            // Column01

            // 

            this.Column01.Frozen = true;

            this.Column01.HeaderText = "承認者コード";

            this.Column01.Name = "Column01";

            this.Column01.ReadOnly = true;

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

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

            this.Column01.Visible = false;

            this.Column01.Width = 5;

            // 

            // Column02

            // 

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

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

            dataGridViewCellStyle2.ForeColor = System.Drawing.Color.Black;

            this.Column02.DefaultCellStyle = dataGridViewCellStyle2;

            this.Column02.Frozen = true;

            this.Column02.HeaderText = "№";

            this.Column02.Name = "Column02";

            this.Column02.ReadOnly = true;

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

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

            this.Column02.Width = 44;

            // 

            // Column03

            // 

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

            this.Column03.DefaultCellStyle = dataGridViewCellStyle3;

            this.Column03.Frozen = true;

            this.Column03.HeaderText = "承認者名";

            this.Column03.Name = "Column03";

            this.Column03.ReadOnly = true;

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

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

            this.Column03.Width = 150;

            // 

            // Column06

            // 

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

            this.Column06.DefaultCellStyle = dataGridViewCellStyle4;

            this.Column06.Frozen = true;

            this.Column06.HeaderText = "承認状態";

            this.Column06.Name = "Column06";

            this.Column06.ReadOnly = true;

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

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

            this.Column06.Width = 125;

            // 

            // Column07

            // 

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

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

            this.Column07.DefaultCellStyle = dataGridViewCellStyle5;

            this.Column07.Frozen = true;

            this.Column07.HeaderText = "処理日付";

            this.Column07.Name = "Column07";

            this.Column07.ReadOnly = true;

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

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

            this.Column07.Width = 120;

            // 

            // Column04

            // 

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

            this.Column04.DefaultCellStyle = dataGridViewCellStyle6;

            this.Column04.HeaderText = "所　属";

            this.Column04.Name = "Column04";

            this.Column04.ReadOnly = true;

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

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

            this.Column04.Width = 145;

            // 

            // Column05

            // 

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

            this.Column05.DefaultCellStyle = dataGridViewCellStyle7;

            this.Column05.HeaderText = "役　職";

            this.Column05.Name = "Column05";

            this.Column05.ReadOnly = true;

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

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

            this.Column05.Width = 157;

            // 

            // btnTargetData

            // 

            this.btnTargetData.BackColor = System.Drawing.Color.DarkCyan;

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

            this.btnTargetData.Location = new System.Drawing.Point(930, 90);

            this.btnTargetData.Name = "btnTargetData";

            this.btnTargetData.Size = new System.Drawing.Size(380, 34);

            this.btnTargetData.TabIndex = 45;

            this.btnTargetData.TabStop = false;

            this.btnTargetData.Text = "承認対象データを見る";

            this.toolTip1.SetToolTip(this.btnTargetData, "承認対象のデータを確認します。");

            this.btnTargetData.UseVisualStyleBackColor = false;

            this.btnTargetData.Click += new System.EventHandler(this.btnTargetData_Click);

            // 

            // btnPetition

            // 

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

            this.btnPetition.Location = new System.Drawing.Point(6, 58);

            this.btnPetition.Name = "btnPetition";

            this.btnPetition.Size = new System.Drawing.Size(240, 30);

            this.btnPetition.TabIndex = 31;

            this.btnPetition.Text = "申　請　す　る";

            this.toolTip1.SetToolTip(this.btnPetition, "承認を申請します。");

            this.btnPetition.UseVisualStyleBackColor = false;

            this.btnPetition.Visible = false;

            this.btnPetition.Click += new System.EventHandler(this.btnPetition_Click);

            // 

            // btnRePetition

            // 

            this.btnRePetition.BackColor = System.Drawing.Color.MediumSeaGreen;

            this.btnRePetition.Location = new System.Drawing.Point(258, 58);

            this.btnRePetition.Name = "btnRePetition";

            this.btnRePetition.Size = new System.Drawing.Size(240, 30);

            this.btnRePetition.TabIndex = 31;

            this.btnRePetition.Text = "再　申　請　す　る";

            this.toolTip1.SetToolTip(this.btnRePetition, "指摘事項等の変更後、再度申請をし直すときに押下します。\r\n初めから承認をやり直します。");

            this.btnRePetition.UseVisualStyleBackColor = false;

            this.btnRePetition.Visible = false;

            this.btnRePetition.Click += new System.EventHandler(this.btnRePetition_Click);

            // 

            this.tvDispData.ItemHeight = 20;

            // label19

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

            this.label19.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            this.label19.Location = new System.Drawing.Point(500, 36);

            this.label19.Name = "label19";

            this.label19.Size = new System.Drawing.Size(36, 25);

            this.label19.TabIndex = 50;

            this.label19.Text = "期";

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

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

                for (int nCommentCnt = 0; nCommentCnt < CommentList.Count; nCommentCnt++)

                    if (CommentList[nCommentCnt].ParentNo == 0)

                        treeNode = tvDispData.Nodes.Add(StringBuiltInReturn(CommentList[nCommentCnt].ApproValComment, s_CommentToolTipLength));

                        GetDataListRecursive(treeNode, CommentList, CommentList[nCommentCnt].ParentNo, ref nCommentCnt);

        #region 文字列の指定位置に改行コードを入れる

        /// <summary>

        /// 文字列の指定位置に改行コードを入れる

        /// </summary>

        /// <param name="InpString"></param>

        /// <param name="CutLength"></param>

        /// <returns></returns>

        private string StringBuiltInReturn(string InpString, int CutLength)

        {

            try

            {

                List<string> textList = new List<string>();

                for (int i = 0; i < InpString.Length; i += CutLength)

                {

                    if ((i + CutLength) < InpString.Length)

                        textList.Add(InpString.Substring(i, CutLength));

                    else

                        textList.Add(InpString.Substring(i));

                }

                return string.Join("\r\n", textList.ToArray());

            }

            catch (Exception ex)

            {

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

                return string.Empty;

            }

        }

        #endregion

                        tn = treeNode.Nodes.Add(StringBuiltInReturn(DataList[DataIndex].ApproValComment, s_CommentToolTipLength));

                    tvDispData.Nodes.Add(StringBuiltInReturn(DispString, s_CommentToolTipLength));

                    TargetNodes.Nodes.Add(StringBuiltInReturn(DispString, s_CommentToolTipLength));

                NewRec.ApproValComment = strComment.Replace("\r\n", "");

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

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.CustomControls;

using ProcessManagement.Forms.ControlsAction;

//*---------------------------- ???E???x??????? ------------------------*

//  2017/08/02  Ver1.0.0.0      Create Source           

//

//

//

//*----------------------------------------------------------------------------*

namespace ProcessManagement.Forms.DataEntry

{

    public partial class FrmReqSumTotalList : Form

    {

        #region ?g?p??`

        //log4net???O???g?p????

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

        #endregion

        #region ??

        /// <summary>

        /// ?\???J????

        /// </summary>

        private enum DispColumn

        {

            No = 0,

            SubconstrCode,

            SubconstrName,

            BeforeValue,

            AfterValue,

            TaxPraice,

            CnstrPrice,

            PaymentValue,

            Note,

        }

        #endregion

        #region ???

        /// <summary>

        /// ???N??

        /// </summary>

        private string m_TargetMonth = string.Empty;

        /// <summary>

        /// ??????

        /// </summary>

        private int m_Labourkind = 0;

        /// <summary>

        /// ?x????

        /// </summary>

        private DateTime m_PayDate = DateTime.Now;

        #endregion

        #region ?v???p?e?B

        /// <summary>

        /// ???N??

        /// </summary>

        public string TargetMonth

        {

            get { return m_TargetMonth; }

            set { m_TargetMonth = value; }

        }

        /// <summary>

        /// ??????

        /// </summary>

        public int Labourkind

        {

            get { return m_Labourkind; }

            set { m_Labourkind = value; }

        }

        /// <summary>

        /// ?x????

        /// </summary>

        public DateTime PayDate

        {

            get { return m_PayDate; }

            set { m_PayDate = value; }

        }

        #endregion

        #region ?R???X?g???N?^

        public FrmReqSumTotalList()

        {

            InitializeComponent();

        }

        #endregion

        #region ?f?X?g???N?^

        ~FrmReqSumTotalList()

        {

            try

            {

                GC.Collect();

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);

            }

        }

        #endregion

        // ---------- ?C?x???g????

        #region ?I???{?^??

        /// <summary>

        /// ?I???{?^???N???b?N

        /// </summary>

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

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

        private void btnEnd_Click(object sender, EventArgs e)

        {

            this.Close();

        }

        #endregion

        #region ?X?V?{?^??

        /// <summary>

        /// ?f?[?^?X?V?{?^??????

        /// </summary>

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

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

        private void btnDataUpDate_Click(object sender, EventArgs e)

        {

            // ?f?[?^?\??

            DataDisplay();

        }

        #endregion

        #region ?t?H?[?????[?h

        /// <summary>

        /// ?????t?H?[?????[?h

        /// </summary>

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

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

        private void FrmReqSumTotalList_Load(object sender, EventArgs e)

        {

            // ?^?C?g???Z?b?g

            InitTitleProc();

            // ?f?[?^?\??

            DataDisplay();

        }

        #endregion

        #region ?Z???_?u???N???b?N

        /// <summary>

        /// ?Z???_?u???N???b?N

        /// </summary>

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

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

        private void dgvMaster_CellDoubleClick(object sender, DataGridViewCellEventArgs e)

        {

            if (e.RowIndex < 0) return;

            // ?f?[?^??????????????

            if (dgvMaster.RowCount == 0) return;

        }

        #endregion

        // ---------- ?\??????

        #region ???????^?C?g???Z?b?g

        /// <summary>

        /// ???????^?C?g???Z?b?g

        /// </summary>

        private void InitTitleProc()

        {

            try

            {

                // ???x???m?F?????x???m?F????\??

                if (m_Labourkind == (int)CommonDefine.LabourKinds.Labor)

                {

                    lblDivision.Text = "????????";

                }

                else

                {

                    lblDivision.Text = "????????";

                }

                string strTitle = string.Empty;

                if (m_TargetMonth.Length > 4)

                    strTitle = string.Format("{0}???Y", m_TargetMonth.Substring(4));

                strTitle += string.Format("?@{0}/{1}????", m_PayDate.Month.ToString("00"), m_PayDate.Day.ToString("00"));

                lblPayInfo.Text = strTitle;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);

            }

        }

        #endregion

        #region ?f?[?^?\??????

        /// <summary>

        /// ?f?[?^?\??????

        /// </summary>

        private void DataDisplay()

        {

            IOPaymentDataDetail PayDB = new IOPaymentDataDetail();

            try

            {

                StringBuilder strSQL = new StringBuilder();

                CreateSQL(ref strSQL);

                ArrayList arList = new ArrayList();

                if (!PayDB.ExecuteReader(strSQL.ToString(), ref arList)) return;

                int ino = 0;

                int nInTax = 0;

                int nOutTax = 0;

                int nOutTotal = 0;

                int[] nTotal = new int[5];

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

                dgvMaster.Rows.Clear();

                foreach (object[] objRec in arList)

                {

                    nInTax = CommonMotions.cnvRound(CommonMotions.cnvDouble(objRec[3]) * (CommonMotions.SystemMasterData.ConsumptionTax / 100.0));

                    nOutTax = CommonMotions.cnvRound(CommonMotions.cnvDouble(objRec[9]) * (CommonMotions.SystemMasterData.ConsumptionTax / 100.0));

                    nOutTotal = 0;

                    for (int i = 9; i < objRec.Length; i++)

                    {

                        nOutTotal += CommonMotions.cnvInt(objRec[i]);

                    }

                    dgvMaster.Rows.Add(++ino,

                                        CommonMotions.cnvInt(objRec[0]),

                                        CommonMotions.cnvString(objRec[1]),

                                        (CommonMotions.cnvInt(objRec[3]) + nInTax).ToString("#,0"),

                                        CommonMotions.cnvInt(objRec[9]).ToString("#,0"),

                                        nOutTax.ToString("#,0"),

                                        CommonMotions.cnvInt(objRec[13]).ToString("#,0"),

                                        nOutTotal.ToString("#,0"),

                                        "");

                    // ???v???Z

                    nTotal[0] += (CommonMotions.cnvInt(objRec[3]) + nInTax);

                    nTotal[1] += CommonMotions.cnvInt(objRec[9]);

                    nTotal[2] += nOutTax;

                    nTotal[3] += CommonMotions.cnvInt(objRec[13]);

                    nTotal[4] += nOutTotal;

                }

                // ???v?\??

                dgvMaster.Rows.Add(1);

                int nTotalLine = dgvMaster.Rows.Add("", "", "???@?@?v",

                                                        nTotal[0].ToString("#,0"),

                                                        nTotal[1].ToString("#,0"),

                                                        nTotal[2].ToString("#,0"),

                                                        nTotal[3].ToString("#,0"),

                                                        nTotal[4].ToString("#,0"));

                dgvMaster.Rows[nTotalLine].Cells[2].Style.Alignment = DataGridViewContentAlignment.MiddleCenter;

                dgvMaster.Rows[nTotalLine].DefaultCellStyle.BackColor = Color.Black;

                dgvMaster.Rows[nTotalLine].DefaultCellStyle.ForeColor = Color.White;

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);

            }

            finally

            {

                if (dgvMaster.RowCount < 24) dgvMaster.RowCount += 24 - dgvMaster.RowCount;

                PayDB.close(); PayDB = null;

            }

        }

        #endregion

        #region ???r?p?k

        /// <summary>

        /// ???r?p?k

        /// </summary>

        /// <param name="strSQL"></param>

        private void CreateSQL(ref StringBuilder strSQL)

        {

            try

            {

                strSQL.Append("select");

                strSQL.Append(" InData.COMPANYCODE");           // 0

                strSQL.Append(", SubConstr.CompanyName");       // 1

                strSQL.Append(", InData.TARGETDATE");           // 2

                strSQL.Append(", InData.BILLPRICE");            // 3

                strSQL.Append(", InData.HIGHWPRICE");           // 4

                strSQL.Append(", InData.HARDWPRICE");           // 5

                strSQL.Append(", InData.INDSWASTETAX");         // 6

                strSQL.Append(", OutData.COMPANYCODE");         // 7

                strSQL.Append(", OutData.TARGETDATE");          // 8

                strSQL.Append(", OutData.BILLPRICE");           // 9

                strSQL.Append(", OutData.HIGHWPRICE");          // 10

                strSQL.Append(", OutData.HARDWPRICE");          // 11

                strSQL.Append(", OutData.INDSWASTETAX");        // 12

                strSQL.Append(", OutData.CNSTRPRICE");          // 13

                strSQL.Append(" From");

                strSQL.Append(" (select");

                strSQL.Append(" Bill.COMPANYCODE AS COMPANYCODE");

                strSQL.Append(", Bill.TARGETDATE AS TARGETDATE");

                strSQL.Append(", SUM(Bill.BILLPRICE) AS BILLPRICE");

                strSQL.Append(", SUM(Bill.HIGHWPRICE) AS HIGHWPRICE");

                strSQL.Append(", SUM(Bill.HARDWPRICE) AS HARDWPRICE");

                strSQL.Append(", SUM(Bill.INDSWASTETAX) AS INDSWASTETAX");

                strSQL.Append(" From");

                strSQL.Append(" billingdatadetail AS Bill");

                strSQL.AppendFormat(" where Bill.TARGETDATE = '{0}'", m_TargetMonth.ToString());

                strSQL.Append(" Group by Bill.COMPANYCODE, Bill.TARGETDATE) AS InData,");

                strSQL.Append(" (select");

                strSQL.Append(" Pay.COMPANYCODE AS COMPANYCODE");

                strSQL.Append(" , Pay.TARGETDATE AS TARGETDATE");

                strSQL.Append(" , SUM(Pay.BILLPRICE) AS BILLPRICE");

                strSQL.Append(" , SUM(Pay.HIGHWPRICE) AS HIGHWPRICE");

                strSQL.Append(" , SUM(Pay.HARDWPRICE) AS HARDWPRICE");

                strSQL.Append(" , SUM(Pay.INDSWASTETAX) AS INDSWASTETAX");

                strSQL.Append(" , SUM(Pay.CNSTRPRICE) AS CNSTRPRICE");

                strSQL.Append(" From paymentdatadetail AS Pay");

                strSQL.AppendFormat(" where Pay.TARGETDATE = '{0}'", m_TargetMonth.ToString());

                strSQL.Append(" Group by Pay.COMPANYCODE, Pay.TARGETDATE) AS OutData");

                strSQL.Append(", subcontractormaster AS SubConstr");

                strSQL.Append(" Where");

                strSQL.Append(" OutData.COMPANYCODE =  InData.COMPANYCODE");

                strSQL.Append("  And OutData.TARGETDATE = InData.TARGETDATE");

                strSQL.Append("  And SubConstr.CompanyCode = InData.COMPANYCODE");

                strSQL.AppendFormat("  And SubConstr.labourKind = {0}", m_Labourkind);

                strSQL.Append(" Order by InData.COMPANYCODE, InData.TARGETDATE");

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);

            }

        }

        #endregion

    }

}

namespace ProcessManagement.Forms.DataEntry

{

    partial class FrmReqSumTotalList

    {

        /// <summary>

        /// 必要なデザイナ変数です。

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// 使用中のリソースをすべてクリーンアップします。

        /// </summary>

        /// <param name="disposing">マネージ リソースが破棄される場合 true、破棄されない場合は false です。</param>

        protected override void Dispose(bool disposing)

        {

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

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows フォーム デザイナで生成されたコード

        /// <summary>

        /// デザイナ サポートに必要なメソッドです。このメソッドの内容を

        /// コード エディタで変更しないでください。

        /// </summary>

        private void InitializeComponent()

        {

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.SuspendLayout();

            // 

            // btnEnd

            // 

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

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

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

            this.btnEnd.Location = new System.Drawing.Point(1152, 658);

            this.btnEnd.Name = "btnEnd";

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

            this.btnEnd.TabIndex = 8;

            this.btnEnd.Text = "終　了";

            this.btnEnd.UseVisualStyleBackColor = false;

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

            // 

            // label1

            // 

            this.label1.Anchor = System.Windows.Forms.AnchorStyles.Top;

            this.label1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(255)))));

            this.label1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

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

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

            this.label1.Location = new System.Drawing.Point(390, 10);

            this.label1.Name = "label1";

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

            this.label1.TabIndex = 6;

            this.label1.Text = "手間・通常業者支払い確認";

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

            // 

            // btnDataUpDate

            // 

            this.btnDataUpDate.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

            this.btnDataUpDate.BackColor = System.Drawing.Color.Aquamarine;

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

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

            this.btnDataUpDate.Location = new System.Drawing.Point(1150, 4);

            this.btnDataUpDate.Name = "btnDataUpDate";

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

            this.btnDataUpDate.TabIndex = 7;

            this.btnDataUpDate.Text = "最新状態に更新";

            this.btnDataUpDate.UseVisualStyleBackColor = false;

            this.btnDataUpDate.Click += new System.EventHandler(this.btnDataUpDate_Click);

            // 

            // lblDivision

            // 

            this.lblDivision.BackColor = System.Drawing.Color.DimGray;

            this.lblDivision.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

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

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

            this.lblDivision.Location = new System.Drawing.Point(6, 6);

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

            this.lblDivision.Name = "lblDivision";

            this.lblDivision.Size = new System.Drawing.Size(140, 30);

            this.lblDivision.TabIndex = 19;

            this.lblDivision.Text = "手間業者払い";

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

            // 

            // lblPayInfo

            // 

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

            this.lblPayInfo.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

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

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

            this.lblPayInfo.Location = new System.Drawing.Point(154, 8);

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

            this.lblPayInfo.Name = "lblPayInfo";

            this.lblPayInfo.Size = new System.Drawing.Size(160, 26);

            this.lblPayInfo.TabIndex = 20;

            this.lblPayInfo.Text = "5月〆　6/10払い";

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

            // 

            // dgvMaster

            // 

            this.dgvMaster.AllowUserToAddRows = false;

            this.dgvMaster.AllowUserToDeleteRows = false;

            this.dgvMaster.AllowUserToResizeColumns = false;

            this.dgvMaster.AllowUserToResizeRows = false;

            dataGridViewCellStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));

            this.dgvMaster.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;

            this.dgvMaster.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 

            | System.Windows.Forms.AnchorStyles.Left) 

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

            this.dgvMaster.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));

            this.dgvMaster.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

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

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

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

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

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

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

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

            this.dgvMaster.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2;

            this.dgvMaster.ColumnHeadersHeight = 24;

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

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

            this.Column1,

            this.Column9,

            this.Column2,

            this.Column3,

            this.Column4,

            this.Column5,

            this.Column6,

            this.Column7,

            this.Column8});

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

            dataGridViewCellStyle10.BackColor = System.Drawing.SystemColors.Window;

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

            dataGridViewCellStyle10.ForeColor = System.Drawing.SystemColors.ControlText;

            dataGridViewCellStyle10.SelectionBackColor = System.Drawing.Color.LightSeaGreen;

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

            dataGridViewCellStyle10.WrapMode = System.Windows.Forms.DataGridViewTriState.False;

            this.dgvMaster.DefaultCellStyle = dataGridViewCellStyle10;

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

            this.dgvMaster.Location = new System.Drawing.Point(6, 44);

            this.dgvMaster.MultiSelect = false;

            this.dgvMaster.Name = "dgvMaster";

            this.dgvMaster.RowHeadersVisible = false;

            this.dgvMaster.RowHeadersWidth = 20;

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

            this.dgvMaster.RowTemplate.Height = 24;

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

            this.dgvMaster.Size = new System.Drawing.Size(1266, 604);

            this.dgvMaster.TabIndex = 5;

            this.dgvMaster.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvMaster_CellDoubleClick);

            // 

            // Column1

            // 

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

            this.Column1.DefaultCellStyle = dataGridViewCellStyle3;

            this.Column1.Frozen = true;

            this.Column1.HeaderText = "№";

            this.Column1.Name = "Column1";

            this.Column1.ReadOnly = true;

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

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

            this.Column1.Width = 46;

            // 

            // Column9

            // 

            this.Column9.Frozen = true;

            this.Column9.HeaderText = "業社番号";

            this.Column9.Name = "Column9";

            this.Column9.ReadOnly = true;

            this.Column9.Visible = false;

            // 

            // Column2

            // 

            this.Column2.Frozen = true;

            this.Column2.HeaderText = "業　社　名　称";

            this.Column2.Name = "Column2";

            this.Column2.ReadOnly = true;

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

            this.Column2.Width = 300;

            // 

            // Column3

            // 

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

            dataGridViewCellStyle4.BackColor = System.Drawing.Color.White;

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

            dataGridViewCellStyle4.ForeColor = System.Drawing.Color.Black;

            this.Column3.DefaultCellStyle = dataGridViewCellStyle4;

            this.Column3.Frozen = true;

            this.Column3.HeaderText = "請求金額（税込）";

            this.Column3.Name = "Column3";

            this.Column3.ReadOnly = true;

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

            this.Column3.Width = 150;

            // 

            // Column4

            // 

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

            dataGridViewCellStyle5.BackColor = System.Drawing.Color.White;

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

            dataGridViewCellStyle5.ForeColor = System.Drawing.Color.Black;

            this.Column4.DefaultCellStyle = dataGridViewCellStyle5;

            this.Column4.Frozen = true;

            this.Column4.HeaderText = "確認後（税抜）";

            this.Column4.Name = "Column4";

            this.Column4.ReadOnly = true;

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

            this.Column4.Width = 150;

            // 

            // Column5

            // 

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

            dataGridViewCellStyle6.BackColor = System.Drawing.Color.White;

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

            dataGridViewCellStyle6.ForeColor = System.Drawing.Color.Black;

            this.Column5.DefaultCellStyle = dataGridViewCellStyle6;

            this.Column5.Frozen = true;

            this.Column5.HeaderText = "消　費　税";

            this.Column5.Name = "Column5";

            this.Column5.ReadOnly = true;

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

            this.Column5.Width = 150;

            // 

            // Column6

            // 

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

            dataGridViewCellStyle7.BackColor = System.Drawing.Color.White;

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

            dataGridViewCellStyle7.ForeColor = System.Drawing.Color.Black;

            this.Column6.DefaultCellStyle = dataGridViewCellStyle7;

            this.Column6.Frozen = true;

            this.Column6.HeaderText = "安全協力金";

            this.Column6.Name = "Column6";

            this.Column6.ReadOnly = true;

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

            this.Column6.Width = 150;

            // 

            // Column7

            // 

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

            dataGridViewCellStyle8.BackColor = System.Drawing.Color.White;

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

            dataGridViewCellStyle8.ForeColor = System.Drawing.Color.Black;

            this.Column7.DefaultCellStyle = dataGridViewCellStyle8;

            this.Column7.Frozen = true;

            this.Column7.HeaderText = "支払確定額";

            this.Column7.Name = "Column7";

            this.Column7.ReadOnly = true;

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