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

                if (CommonMotions.BasePeriodYear())

                    strSQL.AppendFormat(" Base.ConstructionPeriod = {0}", TargetYear);

                else

                    strSQL.AppendFormat(" Base.ConstructionYear = {0}", TargetYear);

                if (CommonMotions.BasePeriodYear())

                    strSQL.AppendFormat(" Base.ConstructionPeriod = {0}", PrevTargetYear);

                else

                    strSQL.AppendFormat(" Base.ConstructionYear = {0}", PrevTargetYear);

                    if (CommonMotions.BasePeriodYear())

                        strSQL.Append(" Base.ConstructionPeriod");

                    else

                        strSQL.Append(" Base.ConstructionYear");

                    if (CommonMotions.BasePeriodYear())

                        strSQL.AppendFormat(" Base.ConstructionPeriod = {0}", TargetYear);

                    else

                        strSQL.AppendFormat(" Base.ConstructionYear = {0}", TargetYear);

                    if (CommonMotions.BasePeriodYear())

                        strSQL.Append(" Base.ConstructionPeriod");

                    else

                        strSQL.Append(" Base.ConstructionYear");

                    if (CommonMotions.BasePeriodYear())

                        strSQL.AppendFormat(" Base.ConstructionPeriod = {0}", PrevTargetYear);

                    else

                        strSQL.AppendFormat(" Base.ConstructionYear = {0}", PrevTargetYear);

                // 直接表示年月が設定されていればセットする

                if (CurrentPara.IntExecParameter.Count > 0)

                    frm.DirectMonth = CurrentPara.IntExecParameter[0];

        #region 定数

            /// <summary>

            /// 入金入力

            /// </summary>

            PaymentEntry,

        private static string[] s_SQLPart1 = new string[] { "SELECT A.CONSTRUCTIONCODE, A.CONSTRUCTIONPERIOD, A.CONSTRUCTIONYEAR, B.DETAILSTRING, A.CONSTRUCTIONSTATUSFLG,",

            CONSTRUCTIONYEAR,

                    int nYear = 0;

                    if (CommonMotions.BasePeriodYear())

                        nYear = CommonMotions.cnvInt(objwrk[(int)GetData.CONSTRUCTIONPERIOD]);

                    else

                        nYear = CommonMotions.cnvInt(objwrk[(int)GetData.CONSTRUCTIONYEAR]);

                                                    , strSalesDepName

                                                    , strSalesName

                                                    , strConstDepName

                                                    , strConstName

                                                    , strConstrName

                                                    , strStatus

                                                    , FlgString

                                                    , nYear

                                                    , CommonMotions.cnvStringCodeFromInt(ConstrCode, "-", 8)

                                                    , OrderNo

                                                    );

                if (CommonMotions.BasePeriodYear())

                    strSQL.Append(" A.CONSTRUCTIONPERIOD");

                else

                    strSQL.Append(" A.ConstructionYear");

                    if (CommonMotions.BasePeriodYear())

                        strSQL.AppendFormat(" Where A1.ConstructionPeriod = {0}", nTargetCount);

                    else

                        strSQL.AppendFormat(" Where A1.ConstructionYear = {0}", nTargetCount);

                    if (CommonMotions.BasePeriodYear())

                        strSQL.AppendFormat(" Where A2.ConstructionPeriod = {0}", nTargetCount);

                    else

                        strSQL.AppendFormat(" Where A2.ConstructionYear = {0}", nTargetCount);

                    if (CommonMotions.BasePeriodYear())

                        strSQL.AppendFormat(" Where A3.ConstructionPeriod = {0}", nTargetCount);

                    else

                        strSQL.AppendFormat(" Where A3.ConstructionYear = {0}", nTargetCount);

                    if (CommonMotions.BasePeriodYear())

                        strSQL.AppendFormat(" Where A4.ConstructionPeriod = {0}", nTargetCount);

                    else

                        strSQL.AppendFormat(" Where A4.ConstructionYear = {0}", nTargetCount);

                    if (CommonMotions.BasePeriodYear())

                        strSQL.AppendFormat(" (C.ConstructionPeriod = {0}", nTargetCount);

                    else

                        strSQL.AppendFormat(" (C.ConstructionYear = {0}", nTargetCount);

                StringBuilder strSQL = new StringBuilder();

                if (CommonMotions.BasePeriodYear())

                    strSQL.Append("SELECT MIN(CONSTRUCTIONPERIODSTART), MAX(CONSTRUCTIONPERIODEND) FROM CONSTRUCTIONBASEINFO");

                else

                    strSQL.Append("SELECT MIN(ConstructionYear), MAX(ConstructionYear) FROM CONSTRUCTIONBASEINFO");

                strSQL.AppendFormat(" WHERE (TRUNCATE(CONSTRUCTIONCODE / 100,0) = {0})", CommonMotions.cnvTruncate(m_ConstructionCode / 100));

                strSQL.AppendFormat(" AND (TYINGFLG = {0} OR TYINGFLG = {1})"

                strSQL.AppendFormat(" AND DATE(CONSTRUCTIONPERIODSTART) != STR_TO_DATE('{0}', '%Y/%m/%d')", DateTime.MinValue.ToShortDateString());

                if (!BaseDB.ExecuteReader(strSQL.ToString(), ref Arlist, false)) return;

                // ?????????o?????????

                if (!GetExpensesList())

                    MessageBox.Show("?o??????????????????", "?G???[?\??", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    this.Close();

                    return;

                // 指導員給与

                CreateInstructorCosts(true);

                // 副担当者給与経費

                CreateAssistantCosts(true);

                // 担当者給与経費

                CreatePayrollCosts(true);

                        GetExpensesList();

                // ?????????o?????????

                if (!GetExpensesList())

                    MessageBox.Show("?o??????????????????", "?G???[?\??", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    this.Close();

                    return;

                int nPreiod = 0;

                if (CommonMotions.BasePeriodYear())

                    nPreiod = m_ConstructionBaseInfo.ConstructionPeriod;

                else

                    nPreiod = m_ConstructionBaseInfo.ConstructionYear;

                // 工事予算書より人件費ブロックを取り込む

                DispDataFromConstructionBudget4(DetailList);

                if (CommonMotions.BasePeriodYear())

                    work.ConstructionPeriod = m_ConstructionBaseInfo.ConstructionPeriod;

                else

                    work.ConstructionPeriod = m_ConstructionBaseInfo.ConstructionYear;

                        GetExpensesList();

                if (CommonMotions.BasePeriodYear())

                    strSQL.AppendFormat("            And Base.ConstructionPeriod = {0}", BusinessPeriod);

                else

                    strSQL.AppendFormat("            And Base.ConstructionYear = {0}", BusinessPeriod);

                if (CommonMotions.BasePeriodYear())

                    strSQL.AppendFormat("            And Base.ConstructionPeriod = {0}", BusinessPeriod + 1);

                else

                    strSQL.AppendFormat("            And Base.ConstructionYear = {0}", BusinessPeriod + 1);

                    if (CommonMotions.BasePeriodYear())

                        strSQL.AppendFormat("    And C.CONSTRUCTIONPERIOD = {0}", TargetYear);

                    else

                        strSQL.AppendFormat("    And C.ConstructionYear = {0}", TargetYear);

                    if (CommonMotions.BasePeriodYear())

                        strSQL.AppendFormat("     And B.CONSTRUCTIONPERIOD = {0}", TargetYear);

                    else

                        strSQL.AppendFormat("     And B.ConstructionYear = {0}", TargetYear);

                if (CommonMotions.BasePeriodYear())

                    strSQL.AppendFormat(" AND A.ConstructionPeriod = {0}", TargetYear);

                else

                    strSQL.AppendFormat(" AND A.ConstructionYear = {0}", TargetYear);

                if (CommonMotions.BasePeriodYear())

                    strSQL.AppendFormat(" AND C.ConstructionPeriod = {0}", TargetYear);

                else

                    strSQL.AppendFormat(" AND C.ConstructionYear = {0}", TargetYear);

                if (CommonMotions.BasePeriodYear())

                    strSQL.AppendFormat(" AND C.ConstructionPeriod = {0}", TargetYear);

                else

                    strSQL.AppendFormat(" AND C.ConstructionYear = {0}", TargetYear);

        //private void CreateConstStartAndEndDate(ref DateTime dtStart, ref DateTime dtEnd, int PersonCode = 0)

        //{

        //    IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();

        //    try

        //    {

        //        StringBuilder strSQL = new StringBuilder();

        //        strSQL.Append("SELECT MIN(B.CONSTRUCTIONPERIODSTART) ,MAX(B.CONSTRUCTIONPERIODEND)");

        //        strSQL.Append(" FROM CONSTRUCTIONLEDGER A, CONSTRUCTIONBASEINFO B");

        //        strSQL.Append(" WHERE A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE");

        //        strSQL.AppendFormat(" AND A.CONSTRUCTIONPERIOD = {0}", numUDConstPro.Value);

        //        if (PersonCode != 0) strSQL.AppendFormat(" AND B.CONSTRSUBPERSONCODE = {0}", PersonCode);

        //        strSQL.AppendFormat(" AND DATE_FORMAT(B.CONSTRUCTIONPERIODSTART,'%Y/%m/%d') != '{0}'", DateTime.MinValue.ToShortDateString());

        //        strSQL.AppendFormat(" AND DATE_FORMAT(B.CONSTRUCTIONPERIODEND,'%Y/%m/%d') != '{0}'", DateTime.MinValue.ToShortDateString());

        //        ArrayList arList = new ArrayList();

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

        //        object[] objList = (object[])arList[0];

        //        dtStart = CommonMotions.cnvDate(objList[0]);

        //        dtEnd = CommonMotions.cnvDate(objList[2]);

        //    }

        //    catch (Exception ex)

        //    {

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

        //    }

        //    finally

        //    {

        //        BaseDB.close(); BaseDB = null;

        //    }

        //}

        //private DateTime GetConstructionDate(int PersonCode, bool bStart = true)

        //{

        //    IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();

        //    try

        //    {

        //        // ????????O?C?????[?U?[

        //        if (PersonCode == 0) PersonCode = CommonMotions.LoginUserData.PersonCode;

        //        // ?J?n????

        //        StringBuilder strSQL = new StringBuilder();

        //        strSQL.Append("SELECT A.CONSTRUCTIONPERSONCODE, MIN(B.CONSTRUCTIONSTART) FROM CONSTRUCTIONBASEINFO A, CONSTRUCTIONBUDGET B");

        //        // ?I???w???I????MAX???X

        //        if (!bStart) strSQL.Replace("MIN(B.CONSTRUCTIONSTART)", "MAX(B.CONSTRUCTIONEND)");

        //        strSQL.AppendFormat(" WHERE A.CONSTRUCTIONPERSONCODE = {0}", PersonCode);

        //        strSQL.AppendFormat("  AND A.CONSTRUCTIONPERIOD = {0}", numUDConstPro.Value);

        //        strSQL.Append(" AND A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE GROUP BY A.CONSTRUCTIONPERSONCODE");

        //        ArrayList ArrayList = new ArrayList();

        //        if (!BaseDB.ExecuteReader(strSQL.ToString(), ref ArrayList)) return DateTime.MinValue;

        //        if (ArrayList.Count == 0) return DateTime.MinValue;

        //        object[] objRec = (object[])ArrayList[0];

        //        return CommonMotions.cnvDate(objRec[1]);

        //    }

        //    catch (Exception ex)

        //    {

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

        //        return DateTime.MinValue;

        //    }

        //    finally

        //    {

        //        BaseDB.close(); BaseDB = null;

        //    }

        //}

                if (m_DispPeriod)

                {

                    if (CommonMotions.BasePeriodYear())

                        strSQL.AppendFormat(" And Base.ConstructionPeriod = {0}", numUDConstPro.Value);

                    else

                        strSQL.AppendFormat(" And Base.ConstructionYear = {0}", numUDConstPro.Value);

                }

                if (CommonMotions.BasePeriodYear())

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

                else

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

        //private const string StaticSQL1 = "SELECT A.ConstructionCode, A.ConstructionPeriod, B.DetailString, A.SalesPersonCode, A.ConstructionPersonCode, A.ConstructionStatusFlg ";

        //private const string StaticSQL2 = "From ConstructionBaseInfo A, ConstructionBaseInfoDetail B";

        //private DateTime GetConstructionDate(int PersonCode, bool bStart = true)

        //{

        //    IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();

        //    try

        //    {

        //        // ????????O?C?????[?U?[

        //        if (PersonCode == 0) PersonCode = CommonMotions.LoginUserData.PersonCode;

        //        // ?J?n????

        //        StringBuilder strSQL = new StringBuilder();

        //        strSQL.Append("SELECT A.CONSTRUCTIONPERSONCODE, MIN(B.CONSTRUCTIONSTART) FROM CONSTRUCTIONBASEINFO A, CONSTRUCTIONBUDGET B");

        //        // ?I???w???I????MAX???X

        //        if (!bStart) strSQL.Replace("MIN(B.CONSTRUCTIONSTART)", "MAX(B.CONSTRUCTIONEND)");

        //        strSQL.AppendFormat(" WHERE A.CONSTRUCTIONPERSONCODE = {0}", PersonCode);

        //        strSQL.AppendFormat("  AND A.CONSTRUCTIONPERIOD = {0}", numUDConstPro.Value);

        //        strSQL.Append(" AND A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE GROUP BY A.CONSTRUCTIONPERSONCODE");

        //        ArrayList ArrayList = new ArrayList();

        //        if (!BaseDB.ExecuteReader(strSQL.ToString(), ref ArrayList)) return DateTime.MinValue;

        //        if (ArrayList.Count == 0) return DateTime.MinValue;

        //        object[] objRec = (object[])ArrayList[0];

        //        return CommonMotions.cnvDate(objRec[1]);

        //    }

        //    catch (Exception ex)

        //    {

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

        //        return DateTime.MinValue;

        //    }

        //    finally

        //    {

        //        BaseDB.close(); BaseDB = null;

        //    }

        //}

        //public static void CreateDepCombBoxSQL(ref StringBuilder strSQL, int nTargetCount, bool bInput = false)

        //{

        //    try

        //    {

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

        //        bool bNowSeason = CommonMotions.CheckNowSeason(nTargetCount);

        //        strSQL.Append("SELECT");

        //        strSQL.Append(" A.DEPARTMENTCODE");

        //        strSQL.Append(", A.DEPARTMENTSTRING");

        //        strSQL.Append(", A.DISPLAYORDER");

        //        strSQL.Append(", COUNT(*)");

        //        strSQL.Append(" FROM");

        //        if (bNowSeason)

        //        {

        //            // ??????v???C?}???e?[?u????????}?X?^

        //            strSQL.Append(" DEPARTMENTMASTER A");

        //        }

        //        else

        //        {   // ?????f?[?^??H????????????

        //            strSQL.Append(" (");

        //            strSQL.Append("Select");

        //            strSQL.Append(" A1.SalesDepCode As DEPARTMENTCODE");

        //            strSQL.Append(", B1.DetailString As DEPARTMENTSTRING");

        //            strSQL.Append(", ifnull(C1.DisplayOrder, 10) As DISPLAYORDER");

        //            strSQL.Append(" From Constructionbaseinfo As A1");

        //            strSQL.Append("  Inner Join constructionbaseinfodetail As B1");

        //            strSQL.Append("        On B1.ConstructionCode = A1.ConstructionCode");

        //            strSQL.AppendFormat("  And B1.DetailNo = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.SalesDepartmentName);

        //            strSQL.Append("  Left Join departmentmaster As C1");

        //            strSQL.Append("       On C1.DepartmentCode = A1.SalesDepCode");

        //            strSQL.AppendFormat(" Where A1.ConstructionPeriod = {0}", nTargetCount);

        //            strSQL.Append("       And A1.SalesDepCode != 0");

        //            strSQL.Append(" Union Select");

        //            strSQL.Append(" A2.ConstrDepCode As DEPARTMENTCODE");

        //            strSQL.Append(", B2.DetailString As DEPARTMENTSTRING");

        //            strSQL.Append(", ifnull(C2.DisplayOrder, 10) As DISPLAYORDER");

        //            strSQL.Append(" From Constructionbaseinfo As A2");

        //            strSQL.Append(" Inner Join constructionbaseinfodetail As B2");

        //            strSQL.Append("       On B2.ConstructionCode = A2.ConstructionCode");

        //            strSQL.AppendFormat(" And B2.DetailNo = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstrDepartmentName);

        //            strSQL.Append(" Left Join departmentmaster As C2");

        //            strSQL.Append("      On C2.DepartmentCode = A2.ConstrDepCode");

        //            strSQL.AppendFormat(" Where A2.ConstructionPeriod = {0}", nTargetCount);

        //            strSQL.Append("       And A2.ConstrDepCode != 0");

        //            strSQL.Append(" Union Select");

        //            strSQL.Append(" A3.ConstrSubDepCode As DEPARTMENTCODE");

        //            strSQL.Append(", B3.DetailString As DEPARTMENTSTRING");

        //            strSQL.Append(", ifnull(C3.DisplayOrder, 10) As DISPLAYORDER");

        //            strSQL.Append(" From Constructionbaseinfo As A3");

        //            strSQL.Append(" Inner Join constructionbaseinfodetail As B3");

        //            strSQL.Append("       On B3.ConstructionCode = A3.ConstructionCode");

        //            strSQL.AppendFormat(" And B3.DetailNo = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstrSubDepartmentName);

        //            strSQL.Append(" Left Join departmentmaster As C3");

        //            strSQL.Append("      On C3.DepartmentCode = A3.ConstrSubDepCode");

        //            strSQL.AppendFormat(" Where A3.ConstructionPeriod = {0}", nTargetCount);

        //            strSQL.Append("       And A3.ConstrSubDepCode != 0");

        //            strSQL.Append(" Union Select");

        //            strSQL.Append(" A4.ConstrInstrDepCode As DEPARTMENTCODE");

        //            strSQL.Append(", B4.DetailString As DEPARTMENTSTRING");

        //            strSQL.Append(", ifnull(C4.DisplayOrder, 10) As DISPLAYORDER");

        //            strSQL.Append(" From Constructionbaseinfo As A4");

        //            strSQL.Append(" Inner Join constructionbaseinfodetail As B4");

        //            strSQL.Append("       On B4.ConstructionCode = A4.ConstructionCode");

        //            strSQL.AppendFormat(" And B4.DetailNo = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.InstrDepartmentName);

        //            strSQL.Append(" Left Join departmentmaster As C4");

        //            strSQL.Append("      On C4.DepartmentCode = A4.ConstrInstrDepCode");

        //            strSQL.AppendFormat(" Where A4.ConstructionPeriod = {0}", nTargetCount);

        //            strSQL.Append("       And A4.ConstrInstrDepCode != 0");

        //            strSQL.Append(") As A");

        //        }

        //        if (bNowSeason)

        //        {   // ???????????

        //            if (!bInput) strSQL.Append(", CONSTRUCTIONBASEINFO C");

        //            strSQL.Append(" WHERE");

        //            // ???????????????

        //            strSQL.AppendFormat(" A.DELETEFLG = {0}", (int)CommonDefine.DataDeleteDef.Exists);

        //            DateTime dtDefaultEnd = CommonMotions.GetOpeningEndDate(nTargetCount, false);

        //            strSQL.AppendFormat(" And DATE(A.StartDate) <= DATE('{0}')", dtDefaultEnd.ToShortDateString());

        //            if (!bInput) strSQL.Append(" And C.ConstrDepCode = A.DepartmentCode");

        //            // ?V?X?e????????O??????Q??}?X?^???f?[?^??

        //            if (CommonMotions.LoginUserData.PersonCode != CommonDefine.AdminCode)

        //            {

        //                // ?Q??????}?X?^????????

        //                strSQL.Append(" And A.DEPARTMENTCODE");

        //                strSQL.Append(" IN (SELECT A1.DEPARTMENTCODE FROM PERSONDEPARTMENTMASTER A1");

        //                strSQL.AppendFormat(" WHERE A1.PERSONCODE = {0})", CommonMotions.LoginUserData.PersonCode);

        //            }

        //        }

        //        else

        //        {   // ??????????

        //            strSQL.Append(", CONSTRUCTIONBASEINFO C");

        //            strSQL.Append(" WHERE");

        //            strSQL.AppendFormat(" (C.ConstructionPeriod = {0}", nTargetCount);

        //            strSQL.Append(" And A.DepartmentCode IN(C.SalesDepCode, C.ConstrDepCode, C.ConstrSubDepCode, C.ConstrInstrDepCode))");

        //        }

        //        strSQL.Append(" GROUP BY A.DEPARTMENTCODE, A.DEPARTMENTSTRING, A.DISPLAYORDER");

        //        strSQL.Append(" ORDER BY A.DISPLAYORDER ASC");

        //    }

        //    catch (Exception ex)

        //    {

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

        //    }

        //}

                    if (CommonMotions.BasePeriodYear())

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

                    else

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

                if (CommonMotions.BasePeriodYear())

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

                else

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

                strSQL.Append(" B.DETAILSTRING, A.CONSTRUCTIONSTATUSFLG,");

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

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

            this.groupBox1 = new ProcessManagement.Forms.CustomControls.GroupBoxEx();

            this.cmbDepartment = new System.Windows.Forms.ComboBox();

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

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

            this.numUDConstPro = new System.Windows.Forms.NumericUpDown();

            this.cmbConstructionPerson = new System.Windows.Forms.ComboBox();

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

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

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

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

            this.btnEnd.Location = new System.Drawing.Point(1107, 550);

            this.Column10,

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

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

            dataGridViewCellStyle12.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold);

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

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

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

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

            this.dgvMain.DefaultCellStyle = dataGridViewCellStyle12;

            this.dgvMain.Size = new System.Drawing.Size(1220, 496);

            this.groupBox1.Location = new System.Drawing.Point(57, 5);

            // Column1

            // 

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

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

            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 = 50;

            // 

            // Column9

            // 

            this.Column9.Frozen = true;

            this.Column9.HeaderText = "部署コード";

            this.Column9.Name = "Column9";

            this.Column9.ReadOnly = true;

            this.Column9.Visible = false;

            // 

            // Column2

            // 

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

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

            this.Column2.DefaultCellStyle = dataGridViewCellStyle4;

            this.Column2.Frozen = true;

            this.Column2.HeaderText = "工事部署";

            this.Column2.Name = "Column2";

            this.Column2.ReadOnly = true;

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

            // 

            // Column3

            // 

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

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

            this.Column3.DefaultCellStyle = dataGridViewCellStyle5;

            this.Column3.Frozen = true;

            this.Column3.HeaderText = "工事担当";

            this.Column3.Name = "Column3";

            this.Column3.ReadOnly = true;

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

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

            // 

            // Column4

            // 

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

            this.Column4.DefaultCellStyle = dataGridViewCellStyle6;

            this.Column4.Frozen = true;

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

            this.Column4.Name = "Column4";

            this.Column4.ReadOnly = true;

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

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

            this.Column4.Visible = false;

            this.Column4.Width = 5;

            // 

            // Column5

            // 

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

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

            this.Column5.DefaultCellStyle = dataGridViewCellStyle7;

            this.Column5.Frozen = true;

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

            this.Column5.Name = "Column5";

            this.Column5.ReadOnly = true;

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

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

            this.Column5.Width = 230;

            // 

            // Column6

            // 

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

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

            this.Column6.DefaultCellStyle = dataGridViewCellStyle8;