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

        public static int s_SystemVersion = 82;

                    case (int)TableColumn.SourceLineCnt:	// 注文書作成時台帳行番号

        #region 定数

        /// <summary>

        /// 夜間作業フラグ定義

        /// </summary>

        public enum OverTimeDef

        {

            /// <summary>

            /// 通常勤務

            /// </summary>

            Normal = 0,

            /// <summary>

            /// 残業時間

            /// </summary>

            OverTime,

        }

        #endregion

        private DateTime    m_StartTime = DateTime.MinValue;

        private DateTime    m_CompTime = DateTime.MinValue;

        #region 定数

        /// <summary>

        /// グループ番号定義

        /// </summary>

        public enum GroupCountDef

        {

            /// <summary>

            /// 0:発注明細

            /// </summary>

            Detail = 0,

            /// <summary>

            /// 1:発注条件

            /// </summary>

            OrderingCondition,

            /// <summary>

            /// 2:施工条件

            /// </summary>

            InstructionCondition,

            /// <summary>

            /// 法定福利費

            /// </summary>

            StatutoryWelfare = 9,

        }

        #endregion

                strSQL.Append(" UNION (");

                strSQL.Append(" AND A1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE");

                strSQL.Append(" Group by A.CONSTRUCTIONCODE)");

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("SELECT SUM(ORDERSDECISIONPRICE) FROM CONSTRUCTIONBASEINFO");

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

                strSQL.AppendFormat(" AND CONSTRUCTIONSTATUSFLG != {0}", iCode1);

                strSQL.Append(" GROUP BY TRUNCATE(CONSTRUCTIONCODE / 100,0)");

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

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(LedgerDB.CreatePrimarykeyString(m_ConstructionCode));

                if (LedgerDB.SelectAction(strSQL.ToString(), ref LedgerRec)) return true;

                LedgerDB.SelectAction(strSQL.ToString(), ref LedgerRec);

                if (!LedgerDB.UpdateAction(strSQL.ToString(), LedgerRec))

                StringBuilder strSQL = new StringBuilder();

                strSQL.AppendFormat("SELECT COUNT(*) FROM CONSTRUCTIONBASEINFO A WHERE A.CONSTRUCTIONSTATUSFLG != {0}",

                strSQL.Append(" AND A.CONSTRUCTIONCODE IN (SELECT B.FLUCTUATIONCODE FROM CONSTRUCTIONLINK B");

                strSQL.AppendFormat(" WHERE B.CONSTRUCTIONCODE = {0})", OrgCode);

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

                strSQL.Clear();

                strSQL.Append(DB2.CreatePrimarykeyString(ToCode, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName));

                if (!DB2.SelectAction(strSQL.ToString(), ref DetailRec, false)) return false;

                if (!DB2.UpdateAction(strSQL.ToString(), DetailRec, false)) return false;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(cbDB.CreatePrimarykeyString(ToCode));

                if (!cbDB.SelectAction(strSQL.ToString(), ref cbRec, false)) return false;

                if (!cbDB.UpdateAction(strSQL.ToString(), cbRec, false)) return false;

        private void CreateParentSQL(int ConstrCode, ref StringBuilder strSQL)

                strSQL.Append("SELECT A.CONSTRUCTIONCODE,");

                strSQL.Append(" CASE DATE(A.ConstructionPeriodStart2) WHEN DATE('0001/01/01') THEN A.ConstructionPeriodStart ELSE A.ConstructionPeriodStart2 END StDate,");

                strSQL.Append(" CASE DATE(A.ConstructionPeriodEnd2) WHEN DATE('0001/01/01') THEN A.ConstructionPeriodEnd ELSE A.ConstructionPeriodEnd2 END EdDate,");

                strSQL.Append(" B.PERSONCODE B1, B.SEALPRINTNAME B2, B.MONTHLYSALARY B3,");

                strSQL.Append(" C.PERSONCODE C1, C.SEALPRINTNAME C2, C.MONTHLYSALARY C3,");

                strSQL.Append(" D.PERSONCODE D1, D.SEALPRINTNAME D2, D.MONTHLYSALARY D3,");

                strSQL.Append(" E1.NAMESTRING E1, E.EXPENSESRAITO E2, E.NAMECODE E3,");

                strSQL.Append(" F1.NAMESTRING F1, F.EXPENSESRAITO F2, F.NAMECODE F3,");

                strSQL.Append(" G1.NAMESTRING G1, G.EXPENSESRAITO G2, G.NAMECODE G3,");

                strSQL.Append(" A.CONSTRUCTIONPERIOD");

                strSQL.Append(" FROM CONSTRUCTIONBASEINFO A");

                strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER C ON C.PERSONCODE = A.CONSTRSUBPERSONCODE");

                strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER D ON D.PERSONCODE = A.CONSTRUCTIONINSTRUCTOR");

                strSQL.Append(" , PERSONINCHARGEMASTER B");

                strSQL.AppendFormat(" LEFT JOIN DEPARTMENTEXPENSESMASTER E ON E.DEPARTMENTCODE = B.DEPARTMENTCODE AND E.EXPENSESPERIOD = {0} AND E.NAMECODE = 3", ConstrPeriod);

                strSQL.AppendFormat(" LEFT JOIN DIVISIONMASTER E1 ON E1.DIVISIONCODE = {0} AND E1.NAMECODE = E.NAMECODE", (int)DivisionMaster.DivisionMasterCodeDefine.ConstructionExpenses);

                strSQL.AppendFormat(" LEFT JOIN DEPARTMENTEXPENSESMASTER F ON F.DEPARTMENTCODE = B.DEPARTMENTCODE AND F.EXPENSESPERIOD = {0} AND F.NAMECODE = 1", ConstrPeriod);

                strSQL.AppendFormat(" LEFT JOIN DIVISIONMASTER F1 ON F1.DIVISIONCODE = {0} AND F1.NAMECODE = F.NAMECODE", (int)DivisionMaster.DivisionMasterCodeDefine.ConstructionExpenses);

                strSQL.AppendFormat(" LEFT JOIN DEPARTMENTEXPENSESMASTER G ON G.DEPARTMENTCODE = B.DEPARTMENTCODE AND G.EXPENSESPERIOD = {0} AND G.NAMECODE = 2", ConstrPeriod);

                strSQL.AppendFormat(" LEFT JOIN DIVISIONMASTER G1 ON G1.DIVISIONCODE = {0} AND G1.NAMECODE = G.NAMECODE", (int)DivisionMaster.DivisionMasterCodeDefine.ConstructionExpenses);

                strSQL.AppendFormat(" WHERE A.CONSTRUCTIONCODE = {0}", ConstrCode);

                strSQL.Append(" AND B.PERSONCODE = A.CONSTRUCTIONPERSONCODE");

                    StringBuilder strLink = new StringBuilder();

                    strLink.Append(cbLinkDB.CreatePrimarykeyString(m_ConstructionCode));

                    if (cbLinkDB.SelectAction(strLink.ToString(), ref LinkRec, false))

                        strLink.Clear();

                        strLink.AppendFormat(" WHERE FLUCTUATIONCODE = {0}", m_ConstructionCode);

                        if (!cbLinkDB.SelectAction(strLink.ToString(), ref LinkRec, false)) return false;

                StringBuilder strParentSQL = new StringBuilder();

                if (!cbiDB.ExecuteReader(strParentSQL.ToString(), ref ParentData, false)) return false;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(ApprovalDB.CreatePrimarykeyString(m_ConstructionCode,

                                                                1));

                if (ApprovalDB.SelectAction(strSQL.ToString(), ref ProRec, false))

                StringBuilder strBudget = new StringBuilder();

                strBudget.Append(BudgetDB.CreatePrimarykeyString(m_ConstructionCode));

                if (!BudgetDB.SelectAction(strBudget.ToString(), ref BudgetRec, false)) return true;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("SELECT A.NAMESTRING, IFNULL(B.EXPENSESRAITO, 0), B.NAMECODE");

                strSQL.Append(" FROM DIVISIONMASTER A");

                strSQL.Append(" LEFT OUTER JOIN");

                strSQL.AppendFormat(" (SELECT NAMECODE, DEPARTMENTCODE, EXPENSESRAITO FROM DEPARTMENTEXPENSESMASTER WHERE DEPARTMENTCODE = {0}) B", DepartmentCode);

                strSQL.Append(" ON A.NAMECODE = B.NAMECODE");

                strSQL.AppendFormat(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDefine.ConstructionExpenses);

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

                if (!expDB.ExecuteReader(strSQL.ToString(), ref ExpensesList)) return false;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(BudgetDB.CreatePrimarykeyString(BudgetRec.ConstructionCode));

                if (!BudgetDB.UpdateAction(strSQL.ToString(), BudgetRec, false)) return false;

                StringBuilder strDelete = new StringBuilder();

                strDelete.Append(BudgetDDB.CreatePrimarykeyString(m_ConstructionCode, (int)FrmConstructionBudget.DataGroup.Expenses));

                BudgetDDB.DeleteAction(strDelete.ToString(), false);

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(BudgetDDB.CreatePrimarykeyString(m_ConstructionCode, GroupCode));

                bool ExistsFlg = BudgetDDB.SelectAction(strSQL.ToString(), ref DetailRec, false);

                        if (!BudgetDDB.UpdateAction(strSQL.ToString(), DetailRec, false)) return false;

                    if (!BudgetDDB.UpdateAction(strSQL.ToString(), DetailRec, false)) return false;

                StringBuilder strLedger = new StringBuilder();

                strLedger.Append(LedgerDB.CreatePrimarykeyString(ProcConstrCode));

                if (!LedgerDB.SelectAction(strLedger.ToString(), ref LedgerRec, false)) return true;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(LedgerDDB.CreatePrimarykeyString(ProcConstrCode, GroupCode));

                strSQL.AppendFormat(" AND OperatingFlg = {0}", (int)ConstructionLedgerDetail.SalOpeKindDef.Oparateing);

                bool bExists = LedgerDDB.SelectAction(strSQL.ToString(), ref DetailRec, false);

                    strSQL.Clear();

                    strSQL.Append(LedgerDDB.CreatePrimarykeyString(ProcConstrCode, GroupCode));

                    strSQL.Append(" AND CompanyCode = 0");

                    LedgerDDB.DeleteAction(strSQL.ToString(), false);

                //DetailRec.AmountConfigRate = AmountConfigRate;                              // ???z?\????

                // ???????b?Z?[?W

                CommonMotions.EntryEndMessage("???F", "");

                // ???????b?Z?[?W

                CommonMotions.EntryEndMessage("???", "");

                // ???????b?Z?[?W

                CommonMotions.EntryEndMessage("?s???F", "");

            /// ?????s???

            /// </summary>

            DataLineCount,

            /// <summary>

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

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

            // dgvAllDisplay

            // 

            this.dgvAllDisplay.AllowUserToAddRows = false;

            this.dgvAllDisplay.AllowUserToDeleteRows = false;

            this.dgvAllDisplay.AllowUserToResizeColumns = false;

            this.dgvAllDisplay.AllowUserToResizeRows = false;

            this.dgvAllDisplay.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.dgvAllDisplay.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));

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

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

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

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

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

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

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

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

            this.dgvAllDisplay.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;

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

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

            this.Column1,

            this.Column3,

            this.Column27,

            this.Column2,

            this.Column14,

            this.Column15,

            this.Column5,

            this.Column6,

            this.Column18,

            this.Column4,

            this.Column10,

            this.Column7,

            this.Column12,

            this.Column9,

            this.Column13,

            this.Column16,

            this.Column17,

            this.Column8,

            this.Column11,

            this.Column19,

            this.Column20,

            this.Column21,

            this.Column22,

            this.Column23,

            this.Column24,

            this.Column25,

            this.Column26});

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

            this.dgvAllDisplay.Name = "dgvAllDisplay";

            this.dgvAllDisplay.RowHeadersVisible = false;

            this.dgvAllDisplay.RowHeadersWidth = 20;

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

            this.dgvAllDisplay.RowTemplate.Height = 21;

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

            this.dgvAllDisplay.Size = new System.Drawing.Size(1278, 418);

            this.dgvAllDisplay.TabIndex = 35;

            this.dgvAllDisplay.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvAllDisplay_CellDoubleClick);

            this.dgvAllDisplay.CellEnter += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvAllDisplay_CellEnter);

            this.dgvAllDisplay.CellPainting += new System.Windows.Forms.DataGridViewCellPaintingEventHandler(this.dgvAllDisplay_CellPainting);

            this.dgvAllDisplay.CellValidated += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvAllDisplay_CellValidated);

            this.dgvAllDisplay.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvAllDisplay_CellValueChanged);

            this.dgvAllDisplay.SelectionChanged += new System.EventHandler(this.dgvAllDisplay_SelectionChanged);

            this.dgvAllDisplay.KeyDown += new System.Windows.Forms.KeyEventHandler(this.dgvAllDisplay_KeyDown);

            this.dgvAllDisplay.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dgvAllDisplay_MouseUp);

            // 

            // Column27

            // 

            this.Column27.Frozen = true;

            this.Column27.HeaderText = "詳細台帳行番号";

            this.Column27.Name = "Column27";

            this.Column27.ReadOnly = true;

            this.Column27.Visible = false;

            // 

        private System.Windows.Forms.DataGridViewTextBoxColumn Column27;

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

    <value>True</value>

  </metadata>

                    RowData[(int)GridColumn.DataLineCount] = DetailRec.LineCount;

            IOPurchaseOrderDetail PDetailDB = new IOPurchaseOrderDetail();

                PDetailDB.connect(); PDetailDB.beginTran();

                if (!ConstructionLedgerDetailEntry(DetailDB, PDetailDB))

                    PDetailDB.rollback();

                    PDetailDB.rollback();

                PDetailDB.commit();

        private bool ConstructionLedgerDetailEntry(IOConstructionLedgerDetail DetailDB, IOPurchaseOrderDetail PDetailDB)

                int nOldLineCnt = 0;

                List<KeyValuePair<int, int>> PDetailList = new List<KeyValuePair<int, int>>();

                    // 明細行の位置が変わっているかの判定

                    if (CommonMotions.chkObjectIsNull(wrkRow.Cells[(int)GridColumn.DataLineCount].Value)) continue;

                    nOldLineCnt = CommonMotions.cnvInt(wrkRow.Cells[(int)GridColumn.DataLineCount].Value);

                    if (nOldLineCnt == 0) continue;

                    if (nOldLineCnt == RowLineCnt) continue;

                    // 明細行の位置が変わっていた時はリストに追加する

                    PDetailList.Add(new KeyValuePair<int, int>(nOldLineCnt, RowLineCnt));

                if (NewList.Count > 0)

                {

                    if (!DetailDB.InsertAction(NewList, false))

                    {

                        MessageBox.Show("工事詳細台帳明細データ：追加登録に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                        return false;

                    }

                }

                if (PDetailList.Count > 0)

                    if (!SetPurchaseOrderDetailLineCount(PDetailDB, PDetailList))

                    {

                        MessageBox.Show("注文書明細データ：更新登録に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                        return false;

                    }

        #region 注文書明細台帳行番号更新

        /// <summary>

        /// 注文書明細台帳行番号更新

        /// </summary>

        private bool SetPurchaseOrderDetailLineCount(IOPurchaseOrderDetail PDetailDB, List<KeyValuePair<int, int>> PDetailList)

        {

            try

            {

                StringBuilder strSQL = new StringBuilder();

                List<PurchaseOrderDetail> DataList = new List<PurchaseOrderDetail>();

                foreach (KeyValuePair<int, int> CurCount in PDetailList)

                {

                    // 行番号変化リストより更新を行う

                    strSQL.Clear();

                    strSQL.AppendFormat(" Where SourceCode = {0}", m_ConstructionCode);

                    strSQL.AppendFormat(" And SourceLineCnt = {0}", CurCount.Key);

                    DataList.Clear();

                    if (!PDetailDB.SelectAction(strSQL.ToString(), ref DataList, false)) return false;

                    // 注文書が無い場合は処理しない

                    if (DataList.Count == 0) continue;

                    // 注文書があれば行番号を更新する

                    strSQL.Clear();

                    strSQL.Append("UPDATE PurchaseOrderDetail");

                    strSQL.Append(" SET");

                    strSQL.AppendFormat(" SourceLineCnt = {0}", CurCount.Value);

                    strSQL.Append(PDetailDB.CreatePrimarykeyString(DataList[0].ConstructionCode,

                                                                    DataList[0].SeqNo,

                                                                    DataList[0].GroupCount,

                                                                    DataList[0].LineCount));

                    if (!PDetailDB.ExecuteNonQuery(strSQL.ToString(), false)) return false;

                }

                return true;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

        }

        #endregion

                // 完了メッセージ

                CommonMotions.EntryEndMessage("承認", "");

                // 完了メッセージ

                CommonMotions.EntryEndMessage("保留", "");

                // 完了メッセージ

                CommonMotions.EntryEndMessage("不承認", "");

                // ???????b?Z?[?W

                CommonMotions.EntryEndMessage("???F", "");

                // ???????b?Z?[?W

                CommonMotions.EntryEndMessage("???", "");

                // ???????b?Z?[?W

                CommonMotions.EntryEndMessage("?s???F", "");

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

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

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

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

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

            this.cmbDepartment = new ProcessManagement.Forms.CustomControls.ComboBoxEX();

            this.cmbConstructionPerson = new ProcessManagement.Forms.CustomControls.ComboBoxEX();

            this.comboBox1 = new ProcessManagement.Forms.CustomControls.ComboBoxEX();

            this.Column15 = new System.Windows.Forms.DataGridViewCheckBoxColumn();

            this.tabPage2.SuspendLayout();

            this.panel2.SuspendLayout();

            // panel2

            // 

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

            this.panel2.BackColor = System.Drawing.Color.LemonChiffon;

            this.panel2.Controls.Add(this.btnWorkingList);

            this.panel2.Location = new System.Drawing.Point(1102, 3);

            this.panel2.Name = "panel2";

            this.panel2.Size = new System.Drawing.Size(237, 34);

            this.panel2.TabIndex = 106;

            // 

            // btnWorkingList

            // 

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

            this.btnWorkingList.BackColor = System.Drawing.Color.DarkOrange;

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

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

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

            this.btnWorkingList.Name = "btnWorkingList";

            this.btnWorkingList.Size = new System.Drawing.Size(230, 26);

            this.btnWorkingList.TabIndex = 12;

            this.btnWorkingList.Text = "作成状態を表示する";

            this.btnWorkingList.UseVisualStyleBackColor = false;

            this.btnWorkingList.Click += new System.EventHandler(this.btnWorkingList_Click);

            // 

            // dgvAllDisplay

            // 

            this.dgvAllDisplay.AllowUserToAddRows = false;

            this.dgvAllDisplay.AllowUserToDeleteRows = false;

            this.dgvAllDisplay.AllowUserToResizeColumns = false;

            this.dgvAllDisplay.AllowUserToResizeRows = false;

            this.dgvAllDisplay.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) 

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

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

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

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

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

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

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

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

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

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

            this.dgvAllDisplay.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;

            this.dgvAllDisplay.ColumnHeadersHeight = 24;

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

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

            this.Column1,

            this.Column4,

            this.Column3,

            this.Column2,

            this.Column15,

            this.Column5,

            this.Column8,

            this.Column7,

            this.Column6});

            this.dgvAllDisplay.Location = new System.Drawing.Point(8, 39);

            this.dgvAllDisplay.Name = "dgvAllDisplay";

            this.dgvAllDisplay.RowHeadersVisible = false;

            this.dgvAllDisplay.RowHeadersWidth = 20;

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

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

            this.dgvAllDisplay.RowTemplate.DefaultCellStyle.ForeColor = System.Drawing.Color.Black;

            this.dgvAllDisplay.RowTemplate.Height = 24;

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

            this.dgvAllDisplay.Size = new System.Drawing.Size(1310, 458);

            this.dgvAllDisplay.TabIndex = 37;

            this.dgvAllDisplay.CellEnter += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvAllDisplay_CellEnter);

            this.dgvAllDisplay.CellValidated += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvAllDisplay_CellValidated);

            this.dgvAllDisplay.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvAllDisplay_CellValueChanged);

            // 

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

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

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

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

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

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

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

            this.dgvTransport02.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle7;

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

            dataGridViewCellStyle8.Font = new System.Drawing.Font("Century", 9F, System.Drawing.FontStyle.Bold);

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

            this.dataGridViewTextBoxColumn1.DefaultCellStyle = dataGridViewCellStyle8;

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

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

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

            this.dataGridViewTextBoxColumn2.DefaultCellStyle = dataGridViewCellStyle9;

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

            dataGridViewCellStyle10.Font = new System.Drawing.Font("Century", 9F, System.Drawing.FontStyle.Bold);

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

            this.dataGridViewTextBoxColumn3.DefaultCellStyle = dataGridViewCellStyle10;

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

            dataGridViewCellStyle11.Font = new System.Drawing.Font("Century", 9F, System.Drawing.FontStyle.Bold);

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

            this.dataGridViewTextBoxColumn4.DefaultCellStyle = dataGridViewCellStyle11;

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

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

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

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

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

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

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

            this.dgvTransport01.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle12;

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

            dataGridViewCellStyle13.Font = new System.Drawing.Font("Century", 9F, System.Drawing.FontStyle.Bold);

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

            this.dataGridViewTextBoxColumn5.DefaultCellStyle = dataGridViewCellStyle13;

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

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

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

            this.dataGridViewTextBoxColumn6.DefaultCellStyle = dataGridViewCellStyle14;

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

            dataGridViewCellStyle15.Font = new System.Drawing.Font("Century", 9F, System.Drawing.FontStyle.Bold);

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

            this.dataGridViewTextBoxColumn7.DefaultCellStyle = dataGridViewCellStyle15;

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

            dataGridViewCellStyle16.Font = new System.Drawing.Font("Century", 9F, System.Drawing.FontStyle.Bold);

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

            this.dataGridViewTextBoxColumn8.DefaultCellStyle = dataGridViewCellStyle16;

            // cmbDepartment

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

            this.cmbDepartment.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

            this.cmbDepartment.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

            this.cmbDepartment.Font = new System.Drawing.Font("ＭＳ 明朝", 15.75F, System.Drawing.FontStyle.Bold);

            this.cmbDepartment.FormattingEnabled = true;

            this.cmbDepartment.Location = new System.Drawing.Point(437, 4);

            this.cmbDepartment.Name = "cmbDepartment";

            this.cmbDepartment.Size = new System.Drawing.Size(260, 29);

            this.cmbDepartment.TabIndex = 123;

            this.cmbDepartment.TextChanged += new System.EventHandler(this.cmbDepartment_TextChanged);

            this.cmbDepartment.Enter += new System.EventHandler(this.cmbDepartment_Enter);

            // cmbConstructionPerson

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

            this.cmbConstructionPerson.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList;

            this.cmbConstructionPerson.FlatStyle = System.Windows.Forms.FlatStyle.Popup;

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

            this.cmbConstructionPerson.FormattingEnabled = true;

            this.cmbConstructionPerson.Location = new System.Drawing.Point(841, 4);

            this.cmbConstructionPerson.Name = "cmbConstructionPerson";

            this.cmbConstructionPerson.Size = new System.Drawing.Size(200, 29);

            this.cmbConstructionPerson.TabIndex = 124;

            this.cmbConstructionPerson.TextChanged += new System.EventHandler(this.cmbConstructionPerson_TextChanged);

            this.cmbConstructionPerson.Enter += new System.EventHandler(this.cmbConstructionPerson_Enter);

            // comboBox1

            //