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

            /// 0:全日振分

            /// 1:振分無

            /// 2:日数入力

        public static int s_SystemVersion = 103;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("SELECT");

                strSQL.Append(" A.DISPLAYORDER");

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

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

                strSQL.Append(", B.SEQNO");

                strSQL.Append(", B.APPROVALSTATUS");

                strSQL.Append(" FROM APPROVALMASTER A");

                strSQL.Append(" LEFT JOIN PERSONAPPROVAL B");

                strSQL.Append(" ON B.PERSONCODEAPPROVAL = A.APPROVALPERSON");

                strSQL.Append(" AND B.APPROVALCODE = A.APPROVALCODE");

                strSQL.AppendFormat(" AND DATE(B.ORDERDATE) = STR_TO_DATE('{0}','%Y/%m/%d')", OrderDate.ToShortDateString());

                strSQL.AppendFormat(" AND B.ORDERNO = {0} AND B.SEQNO != {1}", OrderNo, s_PrimartyRecord);

                strSQL.AppendFormat(" WHERE A.APPROVALCODE = {0}", ApprovalCode);

                strSQL.Append(" AND A.DEPARTMENTCODE = ");

                strSQL.Append(" (SELECT C.DEPARTMENTCODE");

                strSQL.Append(" FROM PERSONINCHARGEMASTER C");

                strSQL.AppendFormat(" WHERE C.PERSONCODE = {0})", PersonCode);

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

                if (!ApprDB.ExecuteReader(strSQL.ToString(), ref DataList)) return false;

                // 経過月数より列番号取得する

                ColCnt = CalcTargetMonthToColumn(LedgerRec.ConstructionStart, NowDates);

            int Columncnt = Enum.GetNames(typeof(FrmConstructionLedger.GridColumn)).Length;

            // 自分のハンドルをリストへセットする

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.ConstructionBaseInfo;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.EstimateInput;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.EstimatePrint;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.ConstructionBudget;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.PurchaseOrderEntry;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.ConstructionLedger;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.TAndPCosts;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.DRConstruction;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.Proceedings;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.DRWork;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

                // ----- パラメータセット

                // 手間・業者区分

                // メニュー起動フラグ

                if (CurrentPara.BoolExecParameter.Count > 0) frm.FirstFlg = CurrentPara.BoolExecParameter[0];

                // 承認一覧画面よりのパラメタ対象月

                if (CurrentPara.DateExecParameter.Count > 0) frm.ParaTargetDate = CommonMotions.cnvInt(CurrentPara.DateExecParameter[0].ToString("yyyyMM"));

                // 支払担当者コード

                if (CurrentPara.IntExecParameter.Count > 1) frm.PaymentPersonCode = CurrentPara.IntExecParameter[1];

            int ProcessNo = (int)ClsExcute.ProcessExecuteNo.RequestInput;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;

        #region 定数

        public enum ApprovalEndFlgDef

        {

            /// <summary>

            /// 0:承認未定

            /// </summary>

            UnKown = 0,

            /// <summary>

            /// 1:承認

            /// </summary>

            Approval,

        }

        #endregion

using ProcessManagement.DB.MySql;

        #region 承認処理フラグ

        /// <summary>

        /// 承認処理フラグ

        /// </summary>

        private enum AppStatusDef

        {

            /// <summary>

            /// 0:無処理

            /// </summary>

            NonStatus = 0,

            /// <summary>

            /// 1:申請

            /// </summary>

            Pettion,

            /// <summary>

            /// 2:最終承認

            /// </summary>

            Approval,

            /// <summary>

            /// 3:不承認・保留・取消

            /// </summary>

            NoApproval,

        }

        #endregion

        #region 支払承認データ作成

        /// <summary>

        /// 支払承認データ作成

        /// </summary>

        /// <returns></returns>

        private bool CreatePaymentApprovalInfo(int nAppStat)

        {

            IOPaymentApprovalInfo PayAppInfoDB = new IOPaymentApprovalInfo();

            IOPaymentDataDetail PayDetailDB = new IOPaymentDataDetail();

            try

            {

                DataGridView dgv = dgvEntryData;

                int nTergetRowCnt = -1;

                // 承認順序取得

                for (int i = 0; i < dgv.RowCount; i++)

                {

                    int nPersonCode = CommonMotions.cnvInt(dgv.Rows[i].Cells[(int)DispGridColumn.ApprovalCode].Value);

                    if (nPersonCode == CommonMotions.LoginUserData.PersonCode)

                    {

                        nTergetRowCnt = i;

                        break;

                    }

                }

                if (nTergetRowCnt < 0) return false;

                bool bSuccess = true;

                ArrayList arData = null;

                if (m_ArrayParam.Count > 0)

                {   // 請求まとめ画面よりの起動はパラメータセット

                    arData = m_ArrayParam[0];

                }

                else

                {   // 承認時はメニューの起動はデータを作る

                    arData = new ArrayList();

                    SearchPayAppInfo(PayAppInfoDB, ref arData);

                }

                PayAppInfoDB.connect(); PayAppInfoDB.beginTran();

                PayDetailDB.connect(); PayDetailDB.beginTran();

                for (int i = 0; i < arData.Count; i++)

                {

                    PaymentApprovalInfo PaIWork = (PaymentApprovalInfo)arData[i];

                    // キー項目のどれかが0のデータは対象外

                    if (PaIWork.CompanyCode == 0 || PaIWork.TargetDate == 0

                        || PaIWork.SeqNo == 0 || PaIWork.LineCount == 0) continue;

                    switch (nAppStat)

                    {

                        case (int)AppStatusDef.Pettion:

                            // 1:申請

                            // 支払承認情報データ作成

                            if (!PaymentApprovalInfoCreate(PayAppInfoDB, PaIWork, nTergetRowCnt))

                            {

                                bSuccess = false;

                                break;

                            }

                            // 支払明細データ更新

                            if (!PaymentDataDetailUpdate(PayDetailDB, PaIWork, nAppStat))

                            {

                                bSuccess = false;

                                break;

                            }

                            break;

                        case (int)AppStatusDef.Approval:

                            // 2:最終承認

                            // 支払承認情報データ作成

                            if (!PaymentApprovalInfoCreate(PayAppInfoDB, PaIWork, nTergetRowCnt))

                            {

                                bSuccess = false;

                                break;

                            }

                            // 支払明細データ更新

                            if (!PaymentDataDetailUpdate(PayDetailDB, PaIWork, nAppStat))

                            {

                                bSuccess = false;

                                break;

                            }

                            break;

                        case (int)AppStatusDef.NoApproval:

                            // 3:不承認・保留・取消

                            // 支払承認情報データ削除

                            if (PaymentApprovalInfoRemove(PayAppInfoDB, PaIWork))

                            {

                                bSuccess = false;

                                break;

                            }

                            break;

                        default:

                            // 0:無処理・その他

                            if (!PaymentApprovalInfoCreate(PayAppInfoDB, PaIWork, nTergetRowCnt))

                            {

                                bSuccess = false;

                                break;

                            }

                            break;

                    }

                }

                if (!bSuccess)

                {

                    PayAppInfoDB.rollback();

                    PayDetailDB.rollback();

                }

                PayAppInfoDB.commit();

                PayDetailDB.commit();

                return bSuccess;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

            finally

            {

                PayAppInfoDB.close(); PayAppInfoDB = null;

                PayDetailDB.close(); PayDetailDB = null;

            }

        }

        #endregion

        #region 支払承認情報データ作成

        /// <summary>

        /// 支払承認情報データ作成

        /// </summary>

        /// <returns></returns>

        private bool PaymentApprovalInfoCreate(IOPaymentApprovalInfo PayAppInfoDB

                                                , PaymentApprovalInfo DataRec

                                                , int nTergetRowCnt)

        {

            try

            {

                DataGridView dgv = dgvEntryData;

                // DBデータ存在確認チェック

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(PayAppInfoDB.CreatePrimarykeyString(DataRec.CompanyCode

                                                                    , DataRec.TargetDate

                                                                    , DataRec.SeqNo

                                                                    , DataRec.LineCount

                                                                    , nTergetRowCnt));

                List<PaymentApprovalInfo> PayAppInfoList = new List<PaymentApprovalInfo>();

                if (!PayAppInfoDB.SelectAction(strSQL.ToString(), ref PayAppInfoList, false)) return false;

                // 存在すれば処理しない

                if (PayAppInfoList.Count > 0) return true;

                // 存在しなければ追加

                int PersonCode = CommonMotions.cnvInt(dgv.Rows[nTergetRowCnt].Cells[(int)DispGridColumn.ApprovalCode].Value);

                string PersonName = CommonMotions.cnvString(dgv.Rows[nTergetRowCnt].Cells[(int)DispGridColumn.ApprovalName].Value);

                int Authority = CommonMotions.cnvInt(dgv.Rows[nTergetRowCnt].Cells[(int)DispGridColumn.ApprovalAuthority].Value);

                DataRec.ApprovalNo = nTergetRowCnt;         // 承認順序

                DataRec.ApprovalPerson = PersonCode;        // 承認者番号

                DataRec.ApprovalPersonName = PersonName;    // 承認者名

                DataRec.ApprovalAuthority = Authority;      // 承認権限

                DataRec.ApprovalDate = DateTime.Now.Date;   // 承認日付

                if (!PayAppInfoDB.InsertAction(DataRec, false)) return false;

                return true;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

        }

        #endregion

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

        /// <summary>

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

        /// </summary>

        /// <returns></returns>

        private bool PaymentDataDetailUpdate(IOPaymentDataDetail PayDetailDB, PaymentApprovalInfo PaIWork, int nAppStat)

        {

            try

            {

                StringBuilder strActionSQL = new StringBuilder();

                // 支払明細データ更新

                switch (nAppStat)

                {

                    case (int)AppStatusDef.Pettion:

                        // 申請時

                        strActionSQL.AppendFormat(" APPROVALPERSONCODE = {0}", CommonMotions.LoginUserData.PersonCode);

                        strActionSQL.AppendFormat(", APPROVALDATE = STR_TO_DATE('{0}','%Y/%m/%d')", DateTime.Now.ToShortDateString());

                        break;

                    case (int)AppStatusDef.Approval:

                        // 承認時

                        strActionSQL.AppendFormat(" APPROVALENDFLG = {0}", (int)PaymentDataDetail.ApprovalEndFlgDef.Approval);

                        break;

                    case (int)AppStatusDef.NoApproval:

                        // 保留等取消し時

                        strActionSQL.AppendFormat(" APPROVALENDFLG = {0}", (int)PaymentDataDetail.ApprovalEndFlgDef.UnKown);

                        break;

                    default:

                        // その他

                        strActionSQL.Clear();

                        break;

                }

                if (strActionSQL.ToString().Length < 1) return true;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("UPDATE paymentdatadetail SET");

                strSQL.Append(strActionSQL.ToString());

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

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

                return true;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 支払承認情報データ削除

        /// <summary>

        /// 支払承認情報データ削除

        /// </summary>

        /// <returns></returns>

        private bool PaymentApprovalInfoRemove(IOPaymentApprovalInfo PayAppDB, PaymentApprovalInfo PaIWork)

        {

            try

            {

                StringBuilder strDel = new StringBuilder();

                strDel.Append(PayAppDB.CreatePrimarykeyString(PaIWork.CompanyCode,

                                            PaIWork.TargetDate,

                                            PaIWork.SeqNo,

                                            PaIWork.LineCount,

                                            PaIWork.ApprovalNo));

                List<PaymentApprovalInfo> InfoList = new List<PaymentApprovalInfo>();

                if (PayAppDB.SelectAction(strDel.ToString(), ref InfoList) && InfoList.Count > 0)

                {

                    PayAppDB.DeleteAction(strDel.ToString(), false);

                }

                return true;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

        }

        #endregion

            ApprovalAuthority,

                PettionNextProcess();

            try

                int iNextProcessNo = 0;

                // ----- ???????Z?b?g

                switch (m_ApprovalCode)

                {

                    case (int)ClsExcute.ApprovalListNo.DRWorkApproval:                      // 8:?o???????F

                        iNextProcessNo = (int)ClsExcute.ProcessExecuteNo.DRWork;

                        break;

                    case (int)ClsExcute.ApprovalListNo.CostomerRegistApproval:              // 9:??????o?^???F

                        iNextProcessNo = (int)ClsExcute.ProcessExecuteNo.CostomerRegist;

                        break;

                    case (int)ClsExcute.ApprovalListNo.SubConstregistApproval:              // 10:??????o?^???F

                        iNextProcessNo = (int)ClsExcute.ProcessExecuteNo.SubConstrRegist;

                        break;

                    case (int)ClsExcute.ApprovalListNo.FeePayment:                          // 11:???x??

                        iNextProcessNo = (int)ClsExcute.ProcessExecuteNo.RequestSummaryList;

                        break;

                    case (int)ClsExcute.ApprovalListNo.SubConstrPayment:                    // 12:???x??

                        iNextProcessNo = (int)ClsExcute.ProcessExecuteNo.RequestSummaryList;

                        break;

                }

                if (iNextProcessNo == 0) return;

                // ----- ?N???v???Z?X???

                int NowPoint = ClsExcute.NextProcess(iNextProcessNo);

                // ???E???x??????????????

                ClsExcute.ProcControlPara[NowPoint].ArrayParameter.Clear();

                switch (m_ApprovalCode)

                {

                    case (int)ClsExcute.ApprovalListNo.FeePayment:                          // 11:???x??

                        ClsExcute.ProcControlPara[NowPoint].IntExecParameter.Add((int)CommonDefine.LabourKinds.Labor);

                        ClsExcute.ProcControlPara[NowPoint].BoolExecParameter.Add(false);

                        break;

                    case (int)ClsExcute.ApprovalListNo.SubConstrPayment:                    // 12:???x??

                        ClsExcute.ProcControlPara[NowPoint].IntExecParameter.Add((int)CommonDefine.LabourKinds.Normal);

                        ClsExcute.ProcControlPara[NowPoint].BoolExecParameter.Add(false);

                        break;

                }

                // ----- ?S????R?[?h?Z?b?g

                ClsExcute.ProcControlPara[NowPoint].IntExecParameter.Add(m_PersonCode);

                // ??t??

                ClsExcute.ProcControlPara[NowPoint].DateExecParameter.Add(m_SearchDate);

                // ??t???

                ClsExcute.ProcControlPara[NowPoint].IntExecParameter.Add(m_SearchSeqNo);

                m_bTargetFlg = true;

                m_bEndFlg = true;

                this.Close();

            }

            catch (Exception ex)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            // dgvEntryData

            // 

            this.dgvEntryData.AllowUserToAddRows = false;

            this.dgvEntryData.AllowUserToDeleteRows = false;

            this.dgvEntryData.AllowUserToResizeColumns = false;

            this.dgvEntryData.AllowUserToResizeRows = false;

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

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

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

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

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

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

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

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

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

            this.dgvEntryData.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle15;

            this.dgvEntryData.ColumnHeadersHeight = 24;

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

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

            this.Column01,

            this.Column02,

            this.Column03,

            this.Column06,

            this.Column07,

            this.Column04,

            this.Column05,

            this.Column08});

            this.dgvEntryData.EnableHeadersVisualStyles = false;

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

            this.dgvEntryData.Name = "dgvEntryData";

            this.dgvEntryData.RowHeadersVisible = false;

            this.dgvEntryData.RowHeadersWidth = 20;

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

            this.dgvEntryData.RowTemplate.Height = 24;

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

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

            this.dgvEntryData.TabIndex = 8;

            // 

            // Column01

            // 

            this.Column01.Frozen = true;

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

            this.Column01.Name = "Column01";

            this.Column01.ReadOnly = true;

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

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

            this.Column01.Visible = false;

            this.Column01.Width = 5;

            // 

            // Column02

            // 

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

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

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

            this.Column02.DefaultCellStyle = dataGridViewCellStyle16;

            this.Column02.Frozen = true;

            this.Column02.HeaderText = "№";

            this.Column02.Name = "Column02";

            this.Column02.ReadOnly = true;

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

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

            this.Column02.Width = 44;

            // 

            // Column03

            // 

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

            this.Column03.DefaultCellStyle = dataGridViewCellStyle17;

            this.Column03.Frozen = true;

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

            this.Column03.Name = "Column03";

            this.Column03.ReadOnly = true;

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

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

            this.Column03.Width = 150;

            // 

            // Column06

            // 

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

            this.Column06.DefaultCellStyle = dataGridViewCellStyle18;

            this.Column06.Frozen = true;

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

            this.Column06.Name = "Column06";

            this.Column06.ReadOnly = true;

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

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

            this.Column06.Width = 125;

            // 

            // Column07

            // 

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

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

            this.Column07.DefaultCellStyle = dataGridViewCellStyle19;

            this.Column07.Frozen = true;

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

            this.Column07.Name = "Column07";

            this.Column07.ReadOnly = true;

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

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

            this.Column07.Width = 120;

            // 

            // Column04

            // 

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

            this.Column04.DefaultCellStyle = dataGridViewCellStyle20;

            this.Column04.HeaderText = "所　属";

            this.Column04.Name = "Column04";

            this.Column04.ReadOnly = true;

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

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

            this.Column04.Width = 145;

            // 

            // Column05

            // 

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

            this.Column05.DefaultCellStyle = dataGridViewCellStyle21;

            this.Column05.HeaderText = "役　職";

            this.Column05.Name = "Column05";

            this.Column05.ReadOnly = true;

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

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

            this.Column05.Width = 157;

            // 

            // Column08

            // 

            this.Column08.HeaderText = "最終承認区分";

            this.Column08.Name = "Column08";

            this.Column08.Visible = false;

            // 

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

        private System.Windows.Forms.Button btnRePetition;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column08;

  <metadata name="toolTip1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">

    <value>17, 17</value>

  </metadata>

  <metadata name="toolTip1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">

    <value>17, 17</value>

  </metadata>

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

    <value>True</value>

                // 申請者と最初の承認者が同じ場合は申請時に承認するため以外は以下の処理無

                if (!m_dispLabelControl[(int)DispHeader.PetitionName].Text.Equals(m_dispLabelControl[(int)DispHeader.ApprovalName].Text))

                    return true;

                // 申請・承認レコード更新

                if (!ApprovalDataUpDate((int)CommonDefine.ApprovalStatus.Approval))

                    MessageBox.Show("承認に失敗しました。", "承認エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                int AppStat = (int)AppStatusDef.NonStatus;

                            AppStat = (int)AppStatusDef.Approval;

                            CreatePaymentApprovalInfo(AppStat);

                // システム権限によってデータアクセスに制限がある

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

                    // システム管理者（すべて対象）

                else if (CommonMotions.LoginUserSecurity.SecRank == CommonDefine.SecurityRankList[(int)CommonDefine.SecurityRankPos.SpecialAuthority].Key)

                {

                    // 経営者アクセス

                }

                    // ログイン者が申請者以外は取消しできない

                    if (pRec.PersonCode != CommonMotions.LoginUserData.PersonCode) return;

                strSQL.Append("SELECT");

                strSQL.Append(" IFNULL(D.APPROVALSTATUS, -1),");                    // 0

                strSQL.Append(" DATE_FORMAT(D.PETITIONAPPROVALDATE,'%Y/%m/%d'),");  // 1

                strSQL.Append(" D.INPUTCOMMENT,");                                  // 2

                strSQL.Append(" B.PersonName,");                                    // 3

                strSQL.Append(" B.DisplayString,");                                 // 4

                strSQL.Append(" C.DepartmentString,");                              // 5

                strSQL.Append(" A.APPROVALPERSON,");                                // 6

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

                strSQL.Append(" A.ApprovalAuthority");                              // 8

                strSQL.Append(" And D.APPROVALCODE = A.APPROVALCODE");

                int LastApproval = 0;

                    LastApproval = 0;

                    LastApproval = CommonMotions.cnvInt(objrec[8]);

                                                            strPersonPosion,

                                                            LastApproval);

        #region 申請後のデータ更新処理を行う

        /// 申請後のデータ更新処理を行う

        private bool PettionNextProcess()

                        // 支払承認情報データ作成処理

                        if (!CreatePaymentApprovalInfo((int)AppStatusDef.Pettion)) return false;