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

        /// <summary>

        /// 本体バージョン

        /// </summary>

        /// <summary>

        /// コピー・環境バージョン

                    string ProcName = ClsExcute.ProcessExecuteName[ProcNo].Replace("－", "").Replace("入力", "");

                    ProcList.Add(new KeyValuePair<int, string>(ProcNo, ProcName));

                }

                if (ExistConstructionLedger())

                {

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

                    string ProcName = ClsExcute.ProcessExecuteName[ProcNo].Replace("－", "").Replace("入力", "");

                    ProcList.Add(new KeyValuePair<int, string>(ProcNo, ProcName));

                }

                if (ExistTAndPCosts())

                {

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

        }

        #endregion

        /// <summary>

        /// </summary>

        /// <returns></returns>

        private static bool ExistConstructionLedger()

        }

        #endregion

        /// <summary>

        /// </summary>

        /// <returns></returns>

        private static bool ExistTAndPCosts()

                    case (int)ClsExcute.ProcessExecuteNo.ConstructionBaseInfo:  //  2:工事情報入力

                    case (int)ClsExcute.ProcessExecuteNo.ConstructionBudget:    //  6:工事予算書入力

                    case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:    // 10:注文書印刷

                        bReturn = true;

                        break;

                    default:

        {

            try

            {

                if (!CheckUserAppStat()) return;

                // ???F?????`?F?b?N

        }

        #endregion

        #region ---------->> 指示連絡コメント処理

        #region 指示連絡コメント表示処理

        /// <summary>

                ConstructionLedgerDetail NewDetailRec = new ConstructionLedgerDetail();

                NewDetailRec.ConstructionCode = ProcConstrCode;                                     // ?H?????

                NewDetailRec.GroupCount = GroupCode;                                                // ?O???[?v???

                frm.GetTitileParametar = GroupCode;

                NewDetailRec.FirstString = frm.GetTitleString;                                      // ???????

                NewDetailRec.SecondString = string.Empty;                                           // ?H?????e

                NewDetailRec.CompanyType = (int)CommonDefine.CodeDataType.Person;                   // ??????R?[?h?^?C?v

                NewDetailRec.CompanyCode = ConstructorCode;                                         // ?S????R?[?h

                NewDetailRec.ExecutionAmount = 0;                                                   // ???s???z

                NewDetailRec.SalaryFlg = DetailRec.SalaryFlg;                                       // ???^?U????

                NewDetailRec.SalaryDays = DetailRec.SalaryDays;                                     // ???^?U??????

                NewDetailRec.OperatingFlg = (int)ConstructionLedgerDetail.SalOpeKindDef.Oparateing; // ?S?????t???O

                NewDetailRec.SalaryOnRegist = MonthryCost;                                          // ?o?^?????z???^

            try

            {

                // ?T?u?t?H?[???N??????????????

                // ?Q?????????????

                //if (m_EditLock) return;

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

        /// </summary>

        private static Color s_CommonCalculatedValueFColor = Color.White;

        #endregion

        #region ?O???b?h????s?^?C?g??

        /// <summary>

        /// ?O???b?h????s?^?C?g??

        /// <summary>

        /// ?O???b?h?J???[???F?G???A

        /// </summary>

        #endregion

        #endregion

        /// ?H?????F?t???O

        /// </summary>

        private bool m_ApprovalFlg = false;

        /// <summary>

        /// ?I???{?^???????t???O

        /// </summary>

                {

                    if (pnlApproval.Visible)

                    {

                                        , MessageBoxButtons.OKCancel

                    }

                    else

                    {

                        MessageBox.Show("発注希望金額と実行金額に差異があります、承認できません。"

                                        , MessageBoxButtons.OK

                                        , MessageBoxIcon.Error);

                        return false;

            }

        }

        #endregion

    }

}

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                // 1?s???I??

                dgvAllDisplay.Rows[0].Selected = true;

                // ?s?I??F????

                SelectRowChangeColor(m_BeforeGridRow);

            }

                // 合計値取得

                GetDetailTotal(ref EstimatePriceValue, ref ExecPriceValue, ref PercentValue, ref TotalValue, ref ResultPriceValue, ref MTotal);

                int EstimateValue = OrdersPrice - EstimatePriceValue;

                int ExecValue = OrdersPrice - ExecPriceValue;

                object[] RowData = new object[dgv.Columns.Count];

                // データセット

                RowData[(int)GridColumn.EstimatePrice] = EstimateValue.ToString("#,0");

                RowData[(int)GridColumn.ExecPrice] = ExecValue.ToString("#,0");

                RowData[(int)GridColumn.Percent] = CalculattionPercent((double)ExecValue).ToString("0.00");

                RowData[(int)GridColumn.IndependentFlg] = "1";

                RowData[(int)GridColumn.SourceCode] = m_ConstructionCode;

                // 合計値取得

                GetDetailTotal(ref EstimatePriceValue, ref ExecPriceValue, ref PercentValue, ref TotalValue, ref ResultPriceValue, ref MTotal);

                // 純利益取得

                int NetIncomeLine = m_CostsRowCount[(int)CostsRowLine.NetIncomeRowLine];

                EstimatePriceValue += CommonMotions.cnvInt(dgv.Rows[NetIncomeLine].Cells[(int)GridColumn.EstimatePrice].Value);

                ExecPriceValue += CommonMotions.cnvInt(dgv.Rows[NetIncomeLine].Cells[(int)GridColumn.ExecPrice].Value);

                if (bCreateRow)

                {

                    RowData[(int)GridColumn.EstimatePrice] = EstimatePriceValue.ToString("#,0");

                    RowData[(int)GridColumn.ExecPrice] = ExecPriceValue.ToString("#,0");

                    RowData[(int)GridColumn.Percent] = CalculattionPercent((double)ExecPriceValue).ToString("0.00");

                    // 月毎合計

                    int arrayCnt = 0;

                    dgv.Rows[LineCnt].Cells[(int)GridColumn.EstimatePrice].Value = EstimatePriceValue.ToString("#,0");

                    dgv.Rows[LineCnt].Cells[(int)GridColumn.ExecPrice].Value = ExecPriceValue.ToString("#,0");

                    dgv.Rows[LineCnt].Cells[(int)GridColumn.Percent].Value = CalculattionPercent((double)ExecPriceValue).ToString("0.00");

                    // 月毎合計

                    int arrayCnt = 0;

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

            IOConstructionLedgerDetail DetailDB = new IOConstructionLedgerDetail();

            IOProcessApproval ProAppDB = new IOProcessApproval();

            try

            {

                // 工事詳細台帳データを読み込む

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

using ProcessManagement.DB.Core;

//*---------------------------- 台帳データ取得SQL作成クラス -------------------*

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

//

        /// <summary>

        /// 担当者毎の部署外補助振分を取得する

        /// </summary>

        {

            IOConstructionLedgerDetail DetailDB = new IOConstructionLedgerDetail();

            try

                                                                        , (int)FrmConstructionLedger.DataGroup.Assistant

                                                                        , (int)FrmConstructionLedger.DataGroup.Payroll);

                strSQL.AppendFormat(" AND B.ComponentCode != {0}", DepartmentCode);

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

                // 工事詳細台帳データより他部署の工事で該当部署の補助振分を取得する

                                                                        , (int)FrmConstructionLedger.DataGroup.Assistant

                                                                        , (int)FrmConstructionLedger.DataGroup.Payroll);

                strSQL.AppendFormat(" AND B.ComponentCode = {0}", DepartmentCode);

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

                if (!DetailDB.ExecuteReader(strSQL.ToString(), ref CostValue)) return;

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

        /// </summary>

        private void InitializeComponent()

        {

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.groupBoxEx1.SuspendLayout();

            this.pnlNormal.SuspendLayout();

            // 

            this.label3.BackColor = System.Drawing.Color.Gold;

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

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

            this.label3.Name = "label3";

            this.label3.Size = new System.Drawing.Size(400, 20);

            this.col098,

            this.col99});

            this.dgv1.EnableHeadersVisualStyles = false;

            this.dgv1.Name = "dgv1";

            this.dgv1.RowHeadersVisible = false;

            this.dgv1.RowHeadersWidth = 24;

            this.dgv1.RowTemplate.Height = 21;

            this.dgv1.TabIndex = 10;

            this.dgv1.CellBeginEdit += new System.Windows.Forms.DataGridViewCellCancelEventHandler(this.dgv1_CellBeginEdit);

            this.dgv1.CellEndEdit += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgv1_CellEndEdit);

            // col004

            // 

            this.col004.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.None;

            this.col004.Frozen = true;

            this.col004.HeaderText = "";

            this.col004.Name = "col004";

            // 

            // col005

            // 

            this.col005.Frozen = true;

            this.col005.HeaderText = "";

            this.col005.Name = "col005";

            // 

            // col006

            // 

            this.col006.Frozen = true;

            this.col006.HeaderText = "受注金額";

            this.col006.Name = "col006";

            // 

            // col007

            // 

            this.col007.Frozen = true;

            this.col007.HeaderText = "";

            this.col007.Name = "col007";

            // 

            // col008

            // 

            this.col008.FillWeight = 120F;

            this.col008.Frozen = true;

            this.col008.HeaderText = "合計";

            // 

            // col009

            // 

            this.col009.HeaderText = "1回目";

            this.col009.Name = "col009";

            this.col009.ReadOnly = true;

            // 

            // col010

            // 

            this.col010.HeaderText = "2回目";

            this.col010.Name = "col010";

            this.col010.ReadOnly = true;

            // 

            // col011

            // 

            this.col011.HeaderText = "3回目";

            this.col011.Name = "col011";

            this.col011.ReadOnly = true;

            // 

            // col12

            // 

            this.col12.HeaderText = "4回目";

            this.col12.Name = "col12";

            this.col12.ReadOnly = true;

            // 

            // col13

            // 

            this.col13.HeaderText = "5回目";

            this.col13.Name = "col13";

            this.col13.ReadOnly = true;

            // 

            // col14

            // 

            this.col14.HeaderText = "6回目";

            this.col14.Name = "col14";

            this.col14.ReadOnly = true;

            // 

            // col15

            // 

            this.col15.HeaderText = "7回目";

            this.col15.Name = "col15";

            this.col15.ReadOnly = true;

            // 

            // col16

            // 

            this.col16.HeaderText = "8回目";

            this.col16.Name = "col16";

            this.col16.ReadOnly = true;

            // 

            // col17

            // 

            this.col17.HeaderText = "9回目";

            this.col17.Name = "col17";

            this.col17.ReadOnly = true;

            // 

            // col18

            // 

            this.col18.HeaderText = "10回目";

            this.col18.Name = "col18";

            this.col18.ReadOnly = true;

            // 

            // col19

            // 

            this.col19.HeaderText = "11回目";

            this.col19.Name = "col19";

            this.col19.ReadOnly = true;

            // 

            // col20

            // 

            this.col20.HeaderText = "12回目";

            this.col20.Name = "col20";

            this.col20.ReadOnly = true;

            // 

            // col21

            // 

            this.col21.HeaderText = "13回目";

            this.col21.Name = "col21";

            this.col21.ReadOnly = true;

            // 

            // col22

            // 

            this.col22.HeaderText = "14回目";

            this.col22.Name = "col22";

            this.col22.ReadOnly = true;

            // 

            // col23

            // 

            this.col23.HeaderText = "15回目";

            this.col23.Name = "col23";

            this.col23.ReadOnly = true;

            // 

            // col098

            // 

            this.col098.HeaderText = "残り";

            this.col098.Name = "col098";

            this.col098.ReadOnly = true;

            this.btnEntry.BackColor = System.Drawing.Color.Green;

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

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

            this.btnEntry.Name = "btnEntry";

            this.btnEntry.Size = new System.Drawing.Size(120, 28);

            this.btnEntry.TabIndex = 13;

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

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

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

            this.btnEnd.Name = "btnEnd";

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

            this.btnEnd.TabIndex = 14;

            this.btnAdd.BackColor = System.Drawing.Color.Orange;

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

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

            this.btnAdd.Name = "btnAdd";

            this.btnAdd.Size = new System.Drawing.Size(120, 28);

            this.btnAdd.TabIndex = 12;

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

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

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

            this.btnOtherProc.Name = "btnOtherProc";

            this.btnOtherProc.Size = new System.Drawing.Size(140, 28);

            this.btnOtherProc.TabIndex = 11;

            this.groupBoxEx1.Controls.Add(this.lblReqOrder);

            this.groupBoxEx1.Location = new System.Drawing.Point(5, 52);

            this.groupBoxEx1.Name = "groupBoxEx1";

            this.groupBoxEx1.TabIndex = 18;

            this.groupBoxEx1.TabStop = false;

            // 

            // pnlNormal

            // 

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

            this.pnlNormal.Controls.Add(this.lblApprovalCount);

            this.pnlNormal.Controls.Add(this.button2);

            this.pnlNormal.Controls.Add(this.btnApproval);

            this.pnlNormal.Name = "pnlNormal";

            this.pnlNormal.TabIndex = 8;

            // 

            // lblApprovalCount

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

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

            this.button2.ForeColor = System.Drawing.Color.Red;

            this.button2.Name = "button2";

            this.button2.Size = new System.Drawing.Size(100, 24);

            this.button2.TabIndex = 13;

            // pnlApproval

            // 

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

            this.pnlApproval.Controls.Add(this.btnDeny);

            this.pnlApproval.Controls.Add(this.btnPend);

            this.pnlApproval.Controls.Add(this.btnAgree);

            this.pnlApproval.Name = "pnlApproval";

            this.pnlApproval.TabIndex = 9;

            this.pnlApproval.Visible = false;

            // 

            this.btnAgree.UseVisualStyleBackColor = false;

            this.btnAgree.Click += new System.EventHandler(this.btnAgree_Click);

            // 

            // FrmRequestInput

            // 

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.None;

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

            this.Controls.Add(this.CombinedOrderLabel);

            this.Controls.Add(this.SeparateBillingLabel);

            this.Controls.Add(this.groupBoxEx1);

            this.Controls.Add(this.btnEnd);

            this.Controls.Add(this.label3);

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

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

            this.Name = "FrmRequestInput";

            this.ShowIcon = false;

            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                        case (int)ClsExcute.ProcessExecuteNo.RequestPrint:              // 14:請求書印刷

                        case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint:        // 10:注文書印刷

                            handle = ProcessExecute_PurchaseOrderPrint;

                            break;

                            handle = ProcessExecute_ConstructionLedger;

                            break;

                            handle = ProcessExecute_TAndPCosts;

                            break;

                    }

                                                    new KeyValuePair<int, string>(-1, "日次（施工）管理"),                                                  // ----- タイトル

                                                    new KeyValuePair<int, string>((int)ClsExcute.ProcessExecuteNo.DepartmentExpenssList, string.Empty),     // 11:部署別台帳一覧

                                                    new KeyValuePair<int, string>((int)ClsExcute.ProcessExecuteNo.PriceOfBudget, string.Empty),             // 37:台帳状況確認画面

                                                    new KeyValuePair<int, string>((int)ClsExcute.ProcessExecuteNo.ConstructionLedger, string.Empty),        // 13:工事詳細台帳

                                                    new KeyValuePair<int, string>((int)ClsExcute.ProcessExecuteNo.DRList, string.Empty),                    // 15:工事日報－一覧

                    // 他部署の副担当・指導員を取得する

                    ArrayList OtherArrary = new ArrayList();

                    // 他振分金額を取得する

                    foreach (object[] objRec in OtherArrary)

                    {

                        int PlusMinus = CommonMotions.cnvInt(objRec[0]);

// すべての値を指定するか、下のように '*' を使ってビルドおよびリビジョン番号を 

// 既定値にすることができます:

// [assembly: AssemblyVersion("1.0.*")]

// Log4netを使用する

[assembly: log4net.Config.XmlConfigurator(ConfigFile = @"log4net.config", Watch = true)]