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

                StringBuilder strSQL = new StringBuilder(1200);

        public static int s_SystemVersion = 103;

            /// 未作成

            /// 作成済

            /// 作成しない

        #region 最終承認時：支払明細データ更新

        /// 最終承認時：支払明細データ更新

                strSQL.Append(PayDetailDB.CreatePrimarykeyString(PaIWork.CompanyCode, PaIWork.TargetDate, PaIWork.SeqNo, PaIWork.LineCount));

            CONSTRUCTIONCODE,

                strSQL.Append(" AND NOT EXISTS (SELECT * FROM PURCHASEORDER B1 WHERE B1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)");

                strSQL.AppendFormat(" And ((A.TYINGFLG != {0} AND ({1} <= A.ConstructionStatusFlg And A.ConstructionStatusFlg <= {2}))",

                                                                (int)ConstructionBaseInfo.TyingFlgDef.Tying, ProgressStart, ProgressComplete);

                strSQL.AppendFormat(" OR (A.TYINGFLG = {0} AND ({1} <= A.ConstructionStatusFlg And A.ConstructionStatusFlg <= {2})))",

                                                                (int)ConstructionBaseInfo.TyingFlgDef.Tying, ProgressStart, ProgressComplete2);

                strSQL.Append(" (SELECT AA1.CONSTRUCTIONCODE FROM CONSTRUCTIONBUDGETDETAIL AA1 WHERE (AA1.COMPANYCODE != 0 AND AA1.COMPANYCODE != -1)");

                strSQL.AppendFormat(" AND A1.APPROVALCODE = {0} AND A1.SEQNO = 1", (int)ClsExcute.ApprovalListNo.ConstructionBudgetApproval);

                wrkFormat.Append(", ifnull(App.ApprovalStatus, -1), ifnull(App.OrderNo, 0)");

                wrkFormat.Append(" LEFT JOIN processapproval AS App ON App.ConstructionCode = A.ConstructionCode");

                strSQL.Append(" AND EXISTS (SELECT * FROM PURCHASEORDER B1 WHERE B1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)");

                strSQL.Append(" WHERE");

                strSQL.AppendFormat("  A1.CONSTRUCTIONCODE = {0}", ParentCode);

                btnDataEntry.Visible = !bDisp;

                if (!m_DataAddtionButton)

                {

                    btnDataEntry.Visible = false;

                }

            this.label9.Text = "当期経過給与";

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

            this.ProgressBar = new System.Windows.Forms.ProgressBar();

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

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

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

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

            this.Column14 = 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();

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

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

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

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

            this.label6.Text = "当期経過給与";

            // lblCellTotal

            // 

            this.lblCellTotal.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));

            this.lblCellTotal.AutoSize = true;

            this.lblCellTotal.BackColor = System.Drawing.Color.Black;

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

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

            this.lblCellTotal.Location = new System.Drawing.Point(200, 628);

            this.lblCellTotal.Name = "lblCellTotal";

            this.lblCellTotal.Size = new System.Drawing.Size(0, 13);

            this.lblCellTotal.TabIndex = 29;

            // 

            // ProgressBar

            // 

            this.ProgressBar.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));

            this.ProgressBar.Location = new System.Drawing.Point(5, 619);

            this.ProgressBar.Name = "ProgressBar";

            this.ProgressBar.Size = new System.Drawing.Size(388, 30);

            this.ProgressBar.TabIndex = 30;

            this.ProgressBar.Visible = false;

            // 

            // btnLedgerStatus

            // 

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

            this.btnLedgerStatus.BackColor = System.Drawing.Color.DodgerBlue;

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

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

            this.btnLedgerStatus.Location = new System.Drawing.Point(1185, 5);

            this.btnLedgerStatus.Name = "btnLedgerStatus";

            this.btnLedgerStatus.Size = new System.Drawing.Size(150, 30);

            this.btnLedgerStatus.TabIndex = 48;

            this.btnLedgerStatus.Text = "未作成台帳確認";

            this.btnLedgerStatus.UseVisualStyleBackColor = false;

            this.btnLedgerStatus.Click += new System.EventHandler(this.btnLedgerStatus_Click);

            // 

            // 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.White;

            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.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing;

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

            this.Column3,

            this.Column1,

            this.Column14,

            this.Column5,

            this.Column6,

            this.Column7,

            this.Column8,

            this.Column9,

            this.Column10,

            this.Column12});

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

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

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

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

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

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

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

            this.dgvMaster.DefaultCellStyle = dataGridViewCellStyle13;

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

            this.dgvMaster.EnableHeadersVisualStyles = false;

            this.dgvMaster.Location = new System.Drawing.Point(5, 168);

            this.dgvMaster.Name = "dgvMaster";

            this.dgvMaster.RowHeadersVisible = false;

            this.dgvMaster.RowHeadersWidth = 20;

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

            this.dgvMaster.RowTemplate.Height = 21;

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

            this.dgvMaster.Size = new System.Drawing.Size(1330, 446);

            this.dgvMaster.TabIndex = 5;

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

            this.dgvMaster.SelectionChanged += new System.EventHandler(this.dgvMaster_SelectionChanged);

            this.dgvMaster.Leave += new System.EventHandler(this.dgvMaster_Leave);

            this.dgvMaster.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dgvMaster_MouseUp);

            // 

            // Column3

            // 

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

            this.Column3.DefaultCellStyle = dataGridViewCellStyle3;

            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;

            this.Column3.Visible = false;

            this.Column3.Width = 5;

            // 

            // Column1

            // 

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

            this.Column1.DefaultCellStyle = dataGridViewCellStyle4;

            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;

            // 

            // Column14

            // 

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

            this.Column14.DefaultCellStyle = dataGridViewCellStyle5;

            this.Column14.Frozen = true;

            this.Column14.HeaderText = "部　署";

            this.Column14.Name = "Column14";

            this.Column14.ReadOnly = true;

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

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

            this.Column14.Width = 280;

            // 

            // Column5

            // 

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

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

            this.Column5.DefaultCellStyle = dataGridViewCellStyle6;

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

            // 

            // Column6

            // 

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

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

            this.Column6.DefaultCellStyle = dataGridViewCellStyle7;

            this.Column6.Frozen = true;

            this.Column6.HeaderText = "会社経費";

            this.Column6.Name = "Column6";

            this.Column6.ReadOnly = true;

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

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

            this.Column6.Width = 140;

            // 

            // Column7

            // 

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

            dataGridViewCellStyle8.Font = new System.Drawing.Font("ＭＳ Ｐ明朝", 9F, System.Drawing.FontStyle.Bold);

            this.Column7.DefaultCellStyle = dataGridViewCellStyle8;

            this.Column7.Frozen = true;

            this.Column7.HeaderText = "部署経費";

            this.Column7.Name = "Column7";

            this.Column7.ReadOnly = true;

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

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

            this.Column7.Width = 140;

            // 

            // Column8

            // 

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

            dataGridViewCellStyle9.Font = new System.Drawing.Font("ＭＳ Ｐ明朝", 9F, System.Drawing.FontStyle.Bold);

            this.Column8.DefaultCellStyle = dataGridViewCellStyle9;

            this.Column8.Frozen = true;

            this.Column8.HeaderText = "営業経費";

            this.Column8.Name = "Column8";

            this.Column8.ReadOnly = true;

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

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

            this.Column8.Width = 140;

            // 

            // Column9

            // 

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

            dataGridViewCellStyle10.Font = new System.Drawing.Font("ＭＳ Ｐ明朝", 9F, System.Drawing.FontStyle.Bold);

            this.Column9.DefaultCellStyle = dataGridViewCellStyle10;

            this.Column9.Frozen = true;

            this.Column9.HeaderText = "総支払額";

            this.Column9.Name = "Column9";

            this.Column9.ReadOnly = true;

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

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

            this.Column9.Width = 140;

            // 

            // Column10

            // 

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

            dataGridViewCellStyle11.Font = new System.Drawing.Font("ＭＳ Ｐ明朝", 9F, System.Drawing.FontStyle.Bold);

            this.Column10.DefaultCellStyle = dataGridViewCellStyle11;

            this.Column10.Frozen = true;

            this.Column10.HeaderText = "粗　利";

            this.Column10.Name = "Column10";

            this.Column10.ReadOnly = true;

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

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

            this.Column10.Width = 140;

            // 

            // Column12

            // 

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

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

            this.Column12.DefaultCellStyle = dataGridViewCellStyle12;

            this.Column12.Frozen = true;

            this.Column12.HeaderText = "純利益";

            this.Column12.Name = "Column12";

            this.Column12.ReadOnly = true;

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

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

            this.Column12.Width = 140;

            // 

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

                        if (numUDConstPro.Value <= CommonMotions.SystemMasterData.BusinessPeriod)

                        {

                            workSalary = CommonMotions.CalcElapsedSalary(SalaryDB, stDate, edDate, CurPersonCode);

                        }

                    if (numUDConstPro.Value <= CommonMotions.SystemMasterData.BusinessPeriod)

                    {

                        TotalSalary = CommonMotions.CalcElapsedSalary(SalaryDB, stDate, edDate, PersonCode);

                    }

                strSQL.Append(" LEFT JOIN CONSTRUCTIONLEDGER A ON A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE,");

                strSQL.Append(" DEPARTMENTMASTER D");

                strSQL.Append(" WHERE B.CONSTRUCTIONPERSONCODE = C.PERSONCODE");

                strSQL.Append(" AND C.DEPARTMENTCODE = D.DEPARTMENTCODE");

                //int SetConstructionCode = 0;

                //if (SearchCode == 0)

                //    SetConstructionCode = ParentCode;

                //else

                //    SetConstructionCode = SearchCode;

                //strSQL.Append(" OR ((A.SOURCECODE, A.COMPANYCODE) IN");

                //strSQL.AppendFormat(" (SELECT POR.CONSTRUCTIONCODE, POR.COMPANYCODE FROM PURCHASEORDER POR WHERE POR.CONSTRUCTIONCODE = {0})))", SetConstructionCode);

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

                    // 変更がある場合は協力会社を変更する

                    if (ChangeCompany)

                        // 協力会社名変更

                        TargetField = (int)IOConstructionLedgerDetail.TableColumn.CompanyName;

                        strSQL.Clear();

                        strSQL.Append(LDetailDB.CreatePrimarykeyString(TargetCode));

                        strSQL.AppendFormat(" AND SOURCECODE = {0}", m_ConstructionCode);

                        strSQL.AppendFormat(" AND GROUPCOUNT = {0}", (int)FrmConstructionLedger.DataGroup.ConstructionCosts);

                        strSQL.AppendFormat(" AND COMPANYCODE = {0}", BeforeCode);

                        //strSQL += string.Format(" AND EXECUTIONAMOUNT = {0}", PriceVal);

                        //if (LedgerLine != 0) strSQL.AppendFormat(" AND LINECOUNT = {0}", LedgerLine);

                        strSQL.AppendFormat(" AND LINECOUNT = {0}", LedgerLine);

                        if (!LDetailDB.UpdateFeild(strSQL.ToString(), TargetField, DataTab.EntryTab.Text, false))

                        {

                            LogicalErrorMessage("注文書データ：協力会社名称変更に失敗しました。", "更新エラー", CommonMotions.GetMethodName());

                            return false;

                        }

                        // 協力会社コード変更

                        TargetField = (int)IOConstructionLedgerDetail.TableColumn.CompanyCode;

                        if (!LDetailDB.UpdateFeild(strSQL.ToString(), TargetField, DataTab.OrderCompanyCode, false))

                        {

                            LogicalErrorMessage("注文書データ：協力会社コード変更に失敗しました。", "更新エラー", CommonMotions.GetMethodName());

                            return false;

                        }

                    //strSQL += string.Format(" AND EXECUTIONAMOUNT = {0}", PriceVal);

                    //if (LedgerLine != 0) strSQL.AppendFormat(" AND LINECOUNT = {0}", LedgerLine);

            this.Column4.HeaderText = "注文書作成日";

        #region 注文書データフィールドＳＱＬ作成

        /// <summary>

        /// 注文書データフィールドＳＱＬ作成

        /// </summary>

        /// <param name="Alias"></param>

        /// <returns></returns>

        private string CerateFieldSQL(string Alias)

        {

            try

            {

                StringBuilder strcmd = new StringBuilder();

                strcmd.AppendFormat(" {0}ConstructionCode", Alias);

                strcmd.AppendFormat(",{0}SeqNo", Alias);

                strcmd.AppendFormat(",{0}CompanyCode", Alias);

                strcmd.AppendFormat(",DATE_FORMAT({0}CreateDate, '%Y/%m/%d')", Alias);

                strcmd.AppendFormat(",{0}OrderPrice", Alias);

                strcmd.AppendFormat(",DATE_FORMAT({0}LastRowStringDate, '%Y/%m/%d')", Alias);

                strcmd.AppendFormat(",{0}OrderSheetType", Alias);

                strcmd.AppendFormat(",{0}PaymentTerms", Alias);

                strcmd.AppendFormat(",{0}CashRatio", Alias);

                strcmd.AppendFormat(",{0}BillPeriod", Alias);

                strcmd.AppendFormat(",{0}PrePayments", Alias);

                strcmd.AppendFormat(",{0}PrePaymentsDays", Alias);

                strcmd.AppendFormat(",{0}PrePaymentsPrice", Alias);

                strcmd.AppendFormat(",{0}PartialPayment", Alias);

                strcmd.AppendFormat(",{0}PartialPaymentMounth", Alias);

                strcmd.AppendFormat(",{0}PartialPaymentDay1", Alias);

                strcmd.AppendFormat(",{0}PartialPaymentDay2", Alias);

                strcmd.AppendFormat(",{0}PartialPaymentPrice", Alias);

                strcmd.AppendFormat(",{0}CompletionPayment", Alias);

                strcmd.AppendFormat(",{0}CompletionPaymentDays", Alias);

                strcmd.AppendFormat(",{0}CompletionPaymentPrice", Alias);

                strcmd.AppendFormat(",{0}LeadEngineerCode", Alias);

                strcmd.AppendFormat(",{0}LeadEngineerName", Alias);

                strcmd.AppendFormat(",{0}SafetyOfficerCode", Alias);

                strcmd.AppendFormat(",{0}SafetyOfficerName", Alias);

                strcmd.AppendFormat(",{0}WorkersCount", Alias);

                strcmd.AppendFormat(",DATE_FORMAT({0}PrintoutDate, '%Y/%m/%d')", Alias);

                strcmd.AppendFormat(", DATE_FORMAT({0}EntryDate, '%Y/%m/%d %H:%i:%s')", Alias);

                strcmd.AppendFormat(", DATE_FORMAT({0}UpdateDate, '%Y/%m/%d %H:%i:%s')", Alias);

                return strcmd.ToString();

            }

            catch (System.Exception ex)

            {

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

                return string.Empty;

            }

        }

        #endregion

                string strSQL = "SELECT";

                strSQL += CerateFieldSQL("A.");

                strSQL += " FROM PURCHASEORDER A, PROCESSAPPROVALDETAIL B, PROCESSAPPROVAL C";

                strSQL += string.Format(" WHERE A.CONSTRUCTIONCODE = {0}", m_ConstructionCode);

                strSQL += " AND B.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE";

                strSQL += string.Format(" AND B.APPROVALCODE = {0}", (int)ClsExcute.ApprovalListNo.PurchaseOrderEntryApproval);

                strSQL += string.Format(" AND B.ORDERNO = {0}", m_OrderNo);

                strSQL += " AND B.LINKCODE = A.SEQNO";

                strSQL += " AND C.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE AND C.APPROVALCODE = B.APPROVALCODE AND C.ORDERNO = B.ORDERNO AND C.SEQNO = 1";

                strSQL += string.Format(" AND C.APPROVALSTATUS = {0}", (int)CommonDefine.ApprovalStatus.Approval);

                strSQL += " ORDER BY A.SEQNO";

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

                                            OrderRec.CreateDate.ToShortDateString(),                                                // 注文書作成日

            DepartmentCode,

            ConstructionPerson,

            ApprovalEndFlg,

            SalesPersonCode,

            DepartmentCode,             // ?H???S????????R?[?h

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

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

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

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

            this.Column147});

            // dgvProject

            // 

            this.dgvProject.AllowUserToAddRows = false;

            this.dgvProject.AllowUserToDeleteRows = false;

            this.dgvProject.AllowUserToResizeRows = false;

            this.dgvProject.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.dgvProject.BackgroundColor = System.Drawing.Color.White;

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

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

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

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

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

            this.dgvProject.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle28;

            this.dgvProject.ColumnHeadersHeight = 45;

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

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

            this.Column136,

            this.Column134,

            this.dataGridViewTextBoxColumn1,

            this.Column63,

            this.Column35,

            this.Project_Column1,

            this.Column90,

            this.Column51,

            this.Project_Column2,

            this.Project_Column3,

            this.Project_Column4,

            this.Project_Column5,

            this.Project_Column6,

            this.Column138,

            this.Project_Column7,

            this.Column144,

            this.Project_Column8,

            this.Project_Column9,

            this.Project_Column10,

            this.Project_Column11,

            this.Project_Column12,

            this.Project_Column13,

            this.Project_Column14,

            this.Project_Column15,

            this.Project_Column16,

            this.Project_Column17,

            this.Project_Column18,

            this.Project_Column19,

            this.Column100,

            this.KyouryokuKin_Pro,

            this.Project_Column21,

            this.Project_Column22,

            this.Project_Column23,

            this.Column50,

            this.Project_Column24,

            this.Column78,

            this.Column52,

            this.Project_Column25,

            this.Column79,

            this.Column113,

            this.Column114,

            this.Column53,

            this.Project_Column26,

            this.Column81,

            this.Column115,

            this.Column116,

            this.Column54,

            this.Project_Column27,

            this.Column82,

            this.Column117,

            this.Column118,

            this.Column55,

            this.Project_Column28,

            this.Column83,

            this.Column119,

            this.Column120,

            this.Column56,

            this.Project_Column29,

            this.Column84,

            this.Column121,

            this.Column122,

            this.Column57,

            this.Project_Column30,

            this.Column80,

            this.Column123,

            this.Column124,

            this.Column58,

            this.Project_Column31,

            this.Column85,

            this.Column125,

            this.Column126,

            this.Column59,

            this.Project_Column32,

            this.Column86,

            this.Column127,

            this.Column128,

            this.Column60,

            this.Project_Column33,

            this.Column87,

            this.Column129,

            this.Column130,

            this.Column61,

            this.Project_Column34,

            this.Column88,

            this.Column131,

            this.Column132,

            this.Column21,

            this.Column77,

            this.Column141,

            this.Column142,

            this.Column146,

            this.Column148});

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

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

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

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

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

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

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

            this.dgvProject.DefaultCellStyle = dataGridViewCellStyle58;

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

            this.dgvProject.EnableHeadersVisualStyles = false;

            this.dgvProject.Location = new System.Drawing.Point(10, 114);

            this.dgvProject.Margin = new System.Windows.Forms.Padding(4);

            this.dgvProject.MultiSelect = false;

            this.dgvProject.Name = "dgvProject";

            this.dgvProject.RowHeadersVisible = false;

            this.dgvProject.RowHeadersWidth = 20;

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

            this.dgvProject.RowTemplate.Height = 21;

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

            this.dgvProject.Size = new System.Drawing.Size(1320, 530);

            this.dgvProject.TabIndex = 3;

            this.dgvProject.Visible = false;

            this.dgvProject.CellBeginEdit += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.DataGridView_CellBeginEdit);

            this.dgvProject.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.DataGridView_CellDoubleClick);

            this.dgvProject.CellEnter += new System.Windows.Forms.DataGridViewCellEventHandler(this.DataGridView_CellEnter);

            this.dgvProject.CellFormatting += new System.Windows.Forms.DataGridViewCellFormattingEventHandler(this.DataGridView_CellFormatting);

            this.dgvProject.CellValidated += new System.Windows.Forms.DataGridViewCellEventHandler(this.DataGridView_CellValidated);

            this.dgvProject.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.DataGridView_CellValueChanged);

            this.dgvProject.CurrentCellDirtyStateChanged += new System.EventHandler(this.DataGridView_CurrentCellDirtyStateChanged);

            // 

            // btnShowView

            // 

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

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

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

            this.btnShowView.Margin = new System.Windows.Forms.Padding(4);

            this.btnShowView.Name = "btnShowView";

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

            this.btnShowView.TabIndex = 8;

            this.btnShowView.Text = "表　示";

            this.btnShowView.UseVisualStyleBackColor = false;

            this.btnShowView.Visible = false;

            this.btnShowView.Click += new System.EventHandler(this.btnShowView_Click);

            //