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

        /// 工数単位日数

        /// </summary>

        public static double s_ManHourUnitDays = 3.0;

        public static double s_ManHourUnitMonth = 30.0;

        #endregion

            Fluctuates,

        }

        #endregion

    }

}

        private static PersonInChargeMaster m_LoginUserData = new PersonInChargeMaster();

        /// <summary>

        /// 建築工事費の構成

        /// </summary>

        //private static Dictionary<int, string> m_StructureTypeName = new Dictionary<int, string>();

            get { return m_ProductVersionInfo; }

        }

        #endregion

        #region 初期化

                // 管理マスタ取得

                SetSystemMaster();

            }

            catch (Exception ex)

            {

        }

        #endregion

        /// <summary>

        /// 定義ファイル読込

        /// </summary>

            Proceedings,                        // 16:発注者打ち合わせ議事録入力

            DailyReportList,                    // 17:日報一覧

            DailyReport,                        // 18:日報全般

        }

        #endregion

                        case (int)ProcessExecuteNo.DepartmentExpenssList:               // 19:部署別台帳一覧

                            ProcessExecuteNo_DepartmentExpenssList(m_ProcControlPara[NowPoint]);

                            break;

                        #endregion

                        #region マスタメンテ

        }

        #endregion

        #endregion

        #region マスタメンテナンス

        // ----------------- メンテナンス起動

        #region 管理マスタ

            IOMessageBoardTerget mbtDB = new IOMessageBoardTerget();

            try

            {

                // キーコードセット

                WriteData.RecordNumber = mbdDB.SelectMaxMessageBoardDataKeyCount("", false) + 1;

        /// 初期化処理成否フラグ

        /// </summary>

        private bool m_bExecuteFlg = true;

        /// <summary>

        /// </summary>

        /// <summary>

        /// </summary>

        #endregion

        #region コンストラクタ

        /// <returns></returns>

        public void FirstExecute()

        {

            try

            {

                // 本日の初回起動がされている場合は処理しない

                // 初期化に失敗したら処理しない

                if (!m_bExecuteFlg) return;

                // データチェック

                // 日付の期限チェックを行う

                // 見積有効期限切れを非受注へ移行する

                // 工事詳細台帳の給与を加算する

            }

            catch (Exception ex)

            {

                int PCode = CommonDefine.ExePrimaryCode.First(x => x.Value.Equals("初回起動日付")).Key;

                // 日付読込

                string strSQL = seDB.CreatePrimarykeyString(PCode);

                {

                }

                // 前回起動日を取得する

                return true;

            }

        /// 日付変更

        /// </summary>

        /// <returns></returns>

        {

            IOSystemExecute seDB = new IOSystemExecute();

            try

            {

                return true;

            }

                List<TermMaster> tmList = new List<TermMaster>();

                if (!tmDB.SelectAction(strSQL, ref tmList)) return false;

                // データセット

                {

                    // キーが違えばArrayテーブルへ追加する

                    {

                        CheckList = new TermMasterList();

                    }

                }

                return true;

            }

            catch (Exception ex)

        /// <summary>

        /// 日付の期限チェックを行う

        /// </summary>

        {

            IOConstructionBaseInfo cbiDB = new IOConstructionBaseInfo();

            try

                string strSQL = " WHERE CONSTRUCTIONSTATUSFLG IN (SELECT DISTINCT CONSTRUCTIONSTATUSFLG FROM TERMMASTER)";

                strSQL = " ORDER BY CONSTRUCTIONSTATUSFLG ASC, CONSTRUCTIONCODE ASC";

                List<ConstructionBaseInfo> cbiList = new List<ConstructionBaseInfo>();

                // 経過日数を取得する

                TimeSpan ts = DateTime.Now - StartDate;

                    StartDate = DateTime.Now.AddDays(-1);

                }

                // 経過日数分処理を行う

                for (int ix = 0; ix < diffDays; ix++)

                {

                        // 増減工事の子は処理しない

                        if (wrkRec.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Tying) continue;

                        // チェック

                    }

                }

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

        {

            try

            {

                // 初期化に失敗していたら処理しない

                if (!m_bExecuteFlg) return false;

                // 取得データの進捗状態がチェック判定テーブルにあるかの存在チェック

                bool exestFlg = false;

                int itblCnt = 0;

                {

                    {

                        exestFlg = true;

                        itblCnt = i;

                    }

                }

                // 取得データがチェック判定以外は処理しない

                // エラーチェック

                foreach (TermMaster wrkCheck in Termtbl)

                {

                        sBackColor = wrkCheck.BackColor;

                        sForeColor = wrkCheck.ForeColor;

                        // 掲示板にメッセージを載せない場合があるのでフラグ制御

                        if (bCreateMessage)

                    }

                }

            }

            catch (Exception ex)

            {

                // メッセージフラグを自動に設定する

                WriteData.MessageFlag = (int)CommonDefine.MessageFlg.Secretary;

                // 掲示板へメッセージを載せる

                ClsMessageBoradAccess.CreateMessage(WriteData, WriteDetail);

        /// <summary>

        /// 見積有効期限が経過したデータを非受注へ変更する

        /// </summary>

        {

            IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();

            try

                if (!BaseDB.ExecuteReader(strSQL, ref arList))

                {

                    logger.ErrorFormat("工事基本情報更新エラー　非受注案件移行処理失敗：{0}：{1}", CommonMotions.GetMethodName(), strSQL);

                }

                object[] wrkcount = (object[])arList[0];

                // 対象データが存在すれば更新する

                strSQL = string.Format("UPDATE CONSTRUCTIONBASEINFO SET CONSTRUCTIONSTATUSFLG = {0}", iCode1);

                if (!BaseDB.ExecuteNonQuery(strSQL))

                {

                    logger.ErrorFormat("工事基本情報更新エラー　非受注案件移行処理失敗：{0}：{1}", CommonMotions.GetMethodName(), strSQL);

                }

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

        /// <summary>

        /// 工事詳細台帳の給与を加算する

        /// </summary>

        {

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

            try

                string strSQL = " WHERE ComplateFlg <> 1 ORDER BY ConstructionStart ASC";

                List<ConstructionLedger> LedgerList = new List<ConstructionLedger>();

                // エラーもしくはデータが無い場合は処理しない

                foreach (ConstructionLedger CurRec in LedgerList)

                {

                    // 給与を加算する

                    if (!ClsChangeLedgerData.CalculatePayment(CurRec.ConstructionCode, DateTime.Now, false)) break;

                }

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

        public void Initialize()

        {

            // DB接続情報作成

        }

        #endregion

            Qualification,

            SealPrintName,

            EmployeeClassFlg,

            DeleteFlg,

            EntryDate,

            UpdateDate,

            strcmd += ", Qualification";

            strcmd += ", SealPrintName";

            strcmd += ", EmployeeClassFlg";

            strcmd += ", DeleteFlg";

            strcmd += ", TO_CHAR(EntryDate, 'YYYY/MM/DD HH24:MI:ss')";

                {

                    strcmd = "INSERT INTO PersonInChargeMaster";

                    strcmd += " VALUES (";

                    strcmd += string.Format("  {0}", work.PersonCode);

                    strcmd += string.Format(", '{0}'", work.Qualification);

                    strcmd += string.Format(", '{0}'", work.SealPrintName);

                    strcmd += string.Format(", {0}", work.EmployeeClassFlg);

                    strcmd += string.Format(", {0}", work.DeleteFlg.ToString());

                    strcmd += ", TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

                strcmd += string.Format(", Qualification = '{0}'", data.Qualification);

                strcmd += string.Format(", SealPrintName = '{0}'", data.SealPrintName);

                strcmd += string.Format(", EmployeeClassFlg = {0}", data.EmployeeClassFlg.ToString());

                strcmd += string.Format(", DeleteFlg = {0}", data.DeleteFlg);

                strcmd += ", UpdateDate = TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

                wrk.Qualification = objwrk[(int)NameColumn.Qualification].ToString();

                wrk.SealPrintName = objwrk[(int)NameColumn.SealPrintName].ToString();

                wrk.EmployeeClassFlg = int.Parse(objwrk[(int)NameColumn.EmployeeClassFlg].ToString());

                wrk.DeleteFlg = int.Parse(objwrk[(int)NameColumn.DeleteFlg].ToString());

                wrk.EntryDate = DateTime.Parse(objwrk[(int)NameColumn.EntryDate].ToString());

            wrk.SealPrintName = string.Empty;       // 印鑑表示名

            wrk.EmployeeClassFlg = 0;               // 社員区分

            wrk.DeleteFlg = 0;                      // 削除フラグ

            wrk.EntryDate = DateTime.MinValue;      // 登録日付

        }

        #endregion

        public int SelectMaxPersonCodeCount(string AddSQLString, bool bConnect = true)

        {

            //Oracle インターフェース

            return iRet;

        }

        public int SelectMaxDisplayCount(string AddSQLString, bool bConnect = true)

        {

            //Oracle インターフェース

            return iRet;

        }

        /// <summary>

        /// 主キー検索の文字列を返す

        /// </summary>

        /// <summary>

        /// システム起動確認データフィールド並び

        /// </summary>

        {

            PrimaryCode = 0,

            TargetDate,

        #endregion

        /// <summary>

        /// </summary>

        /// <param name="AddSQLString">検索条件SQL文字列</param>

        /// <param name="data">システム起動確認データデータ</param>

            return strcmd;

        }

        public bool SelectAction(string AddSQLString, ref List<SystemExecute> data, bool bConnect = true)

        {

            //Oracle インターフェース

                return false;

            }

        }

        public bool SelectAction(string AddSQLString, ref SystemExecute data, bool bConnect = true)

        {

            //Oracle インターフェース

                return false;

            }

        }

        /// <summary>

        /// </summary>

        /// <param name="data">システム起動確認データデータ</param>

        /// <returns>true：成功 false：失敗</returns>

        {

            string strcmd = "INSERT INTO SystemExecute";

            strcmd += " VALUES (";

            strcmd += string.Format("{0}", work.PrimaryCode);

            strcmd += string.Format(", TO_DATE('{0}','YYYY/MM/DD')", work.TargetDate.ToShortDateString());

            return strcmd;

        }

        public bool InsertAction(List<SystemExecute> data, bool bConnect = true)

        {

            string strcmd = "";

                return false;

            }

        }

        public bool InsertAction(SystemExecute data, bool bConnect = true)

        {

            string strcmd = "";

                return false;

            }

        }

        /// <summary>

        /// システム起動確認データ更新

        /// </summary>

                return false;

            }

        }

        /// <summary>

        /// システム起動確認データ削除

        /// </summary>

                return false;

            }

        }

        /// <summary>

        /// OracleDataReaderより構造体へセットする

        /// </summary>

        /// <param name="reader">OracleDataReader</param>

            try

            {

                // データ取得

            }

            catch (OracleException oraex)

            {

        #endregion

        /// <summary>

        /// 主キー検索の文字列を返す

        /// </summary>

        private int         m_ConstructionStatusFlg = -1;	                    // 工事状態フラグ

        private int         m_ConstructionType = 0;                             // 工事種別区分名称コード

        private int         m_EstimateType = 1;                                 // 見積種別

        private DateTime    m_BillingDate = DateTime.MinValue;	                // 請求日

        private int         m_BillingSplitFlg = 1;                              // 請求回数フラグ

        private DateTime    m_BillingSendDate = DateTime.MinValue;              // 請求書郵送/手渡し日

        private string      m_SealPrintName = string.Empty;     // 印鑑表示名

        private int         m_EmployeeClassFlg = 0;             // 社員区分

        private int         m_DeleteFlg = 0;                    // 削除フラグ

        private DateTime    m_EntryDate = DateTime.MinValue;    // 登録日付

        private DateTime    m_UpdateDate = DateTime.MinValue;   // 更新日付

            set { m_EmployeeClassFlg = value; }

        }

        /// <summary>

        /// 削除フラグ

        /// </summary>

        public int DeleteFlg

        private bool SetcmbDepartment()

        {

            IOMDepartment depDB = new IOMDepartment();

            bool bSave = m_initDataLoad;

            m_initDataLoad = true;

            try

                cmbDepartment.Text = "";

                string strSQL = string.Empty;

                // ?V?X?e????????????f?[?^?A?N?Z?X???????????

                {

                    // ??????

                    // ???g?p??i???????A?N?Z?X??\?j

                }

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

                List<KeyValuePair<int, string>> ConstructionDataList = new List<KeyValuePair<int, string>>();

                ConstructionDataList.Add(new KeyValuePair<int, string>(0, ""));

                {

                    ConstructionDataList.Add(keyval);

                }

                string strSQL = "SELECT SUM(ORDERSDECISIONPRICE) FROM CONSTRUCTIONBASEINFO";

                strSQL += string.Format(" WHERE (TRUNC(CONSTRUCTIONCODE / 100) = {0})", (int)(m_ConstructionCode / 100));

                strSQL += " GROUP BY TRUNC(CONSTRUCTIONCODE / 100)";

                ArrayList Arlist = new ArrayList();

                ExecutionAmount = iInput;                                                     // ???s???z

                AmountConfigRate = (iInput / OrdersDecisionPrice) * 100.0;          // ???z?\????

            }

            catch (Exception ex)

            {

                                        IOMPersonInCharge PersonDB,

                                        IOConstructionLink cbLinkDB,

                                        int TotalOrdersPrice,

        {

            try

            {

                // ----- ???????????H??????i?[?G???A

                // ?H????????????

                ConstructionBaseInfo BaseRec = new ConstructionBaseInfo();

                string strBase = cbiDB.CreatePrimarykeyString(ProcConstrCode);

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

                DateTime StDate = BaseRec.ConstructionPeriodStart;

                DateTime EdDate = BaseRec.ConstructionPeriodEnd;

                if (StDate != LedgerRec.ConstructionStart) bChangeCode = false;

                if (EdDate != LedgerRec.ConstructionEnd) bChangeCode = false;

                return true;

            }

            catch (Exception ex)

                        {false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false},     // 77:?H?????S??????

                        {false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false},     // 78:?w????????

                        {false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false},     // 79:?H?????S????R?[?h

        };

        //?@0:???????|1:?????o?|2:????C?H???|3:?? ?? ???|4:??|5:???????p

        //?|6:?{?H?????|7:?{?H?J?n?|8:?{?H?????|9:?????????|10:?????????|11:???

                        { true,  true,  true,  true,  true,  true,  true,  false, false, false, false, false, false, false, false, false,  true,  true},   // 78:?w????????

                        { true,  true,  true,  true,  true,  true,  true,  false, false, false, false, false, false, false, false, false,  true,  true},   // 79:?H?????S????R?[?h

                        { true,  true,  true,  true,  true,  true,  true,  true,  true,  true,  true,  true,  true,  true,  false, false,  true,  true},    // ?y??I?z+ 4:?H?????t???O

        //  0:???????|1:?????o?|2:????C?H???|3:????|4:??|5:???????p

        //?|6:?{?H?????|7:?{?H?J?n?|8:?{?H?????|9:?????????|10:?????????|11:???

            IOConstructionLedger LedgerDB = new IOConstructionLedger();                 // ?H???????f?[?^

            IOConstructionLedgerDetail LedgerDDB = new IOConstructionLedgerDetail();    // ?H??????????f?[?^

            IOConstructionLedgerExcute LedgerEDB = new IOConstructionLedgerExcute();    // ?H???????x?????f?[?^

            try

            {

                //?f?[?^?`?F?b?N

                ConstructionBaseInfo BaseRec = new ConstructionBaseInfo();

                cbiDB.SelectAction(strTyCheck, ref BaseRec);

                if (BaseRec.TyingFlg != (int)CommonDefine.BaseInfoTyingFlg.Standard) TyingDataFlag = true;

                //if ((pnlFluctuation.Visible == true && rdbExistsFluctuation.Checked == true) || (pnlFluctuation.Visible == false)) LastDateUpDate = true;

                // ?????H????e????????q??????????H???I??????????

                    return false;

                }

                // ?H???????f?[?^?X?V

                {

                    MessageBox.Show("?H???????f?[?^?X?V?G???[????B", "?X?V?G???[", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    cbiDB.rollback();

                LedgerDDB.commit();

                LedgerEDB.commit();

                // ?o?^?????????t???O?N???A

                m_bChengeAns = false;

                    // 画面クローズ

                    Handle.SubFormHandle.Close();

                }

            }

            catch (System.Exception ex)

        /// <param name="e"></param>

        private void FrmConstructionBudget_KeyDown(object sender, KeyEventArgs e)

        {

        }

        #endregion

                    dTotal += CommonMotions.cnvDouble(dgv.Rows[c.RowIndex].Cells[c.ColumnIndex].Value);

                    if (CommonMotions.chkNumeric(dgv.Rows[c.RowIndex].Cells[c.ColumnIndex].Value)) NumericCnt++;

                }

                string strTotal = CommonMotions.cnvTruncate(dTotal).ToString("#,#");

                if (dTotal - System.Math.Floor(dTotal) != 0) strTotal = dTotal.ToString("#,#.00");

        }

        #endregion

        #region ???S????U?????t????

        /// <summary>

        /// ???S????U?????t????

        {

            CalcExpenese();

        }

        #endregion

    }

}

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

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

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

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

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

            this.radioButton4 = new System.Windows.Forms.RadioButton();

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

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

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

            this.panel1.SuspendLayout();

            this.pnlGroup2.SuspendLayout();

            this.pnlGroup1.SuspendLayout();

            this.pnlApproval.SuspendLayout();

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

            this.panel1.Controls.Add(this.lblLabel06);

            this.panel1.Controls.Add(this.label23);

            this.panel1.Controls.Add(this.pnlGroup2);

            this.panel1.Controls.Add(this.label10);

            this.panel1.Controls.Add(this.label8);

            this.label23.Text = "発注者名称";

            this.label23.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;

            // 

            // pnlGroup2

            // 

            this.pnlGroup2.BackColor = System.Drawing.Color.Beige;

            // button1

            // 

            this.button1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));

            this.button1.Name = "button1";

            this.button1.Size = new System.Drawing.Size(37, 35);

            this.button1.TabIndex = 101;

            // button2

            // 

            this.button2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));

            this.button2.Name = "button2";

            this.button2.Size = new System.Drawing.Size(37, 35);

            this.button2.TabIndex = 101;

            this.button2.Visible = false;

            this.button2.Click += new System.EventHandler(this.button2_Click);

            // 

            // FrmConstructionBudget

            // 

            this.AutoScaleDimensions = new System.Drawing.SizeF(96F, 96F);

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

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

            this.ClientSize = new System.Drawing.Size(1344, 692);

            this.Controls.Add(this.button2);

            this.Controls.Add(this.button1);

            this.Controls.Add(this.btnOtherProc);

            this.Load += new System.EventHandler(this.FrmConstructionBudget_Load);

            this.Shown += new System.EventHandler(this.FrmConstructionBudget_Shown);

            this.SizeChanged += new System.EventHandler(this.FrmConstructionBudget_SizeChanged);

            this.panel1.ResumeLayout(false);

            this.panel1.PerformLayout();

            this.pnlGroup2.ResumeLayout(false);

            this.pnlGroup2.PerformLayout();

            this.pnlGroup1.ResumeLayout(false);

        private System.Windows.Forms.RadioButton radioButton3;

        private System.Windows.Forms.RadioButton radioButton2;

        private System.Windows.Forms.RadioButton radioButton1;

        private System.Windows.Forms.RadioButton radioButton5;

        private System.Windows.Forms.RadioButton radioButton4;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column1;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column13;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column16;

        private System.Windows.Forms.DataGridViewTextBoxColumn Column17;

        private System.Windows.Forms.Label label9;

        private System.Windows.Forms.TextBox textBox2;

        private System.Windows.Forms.RadioButton radioButton6;

        private System.Windows.Forms.Panel pnlGroup1;

        private System.Windows.Forms.Panel pnlGroup2;

        private System.Windows.Forms.Label lblLabel06;

        private System.Windows.Forms.Label label23;

        private System.Windows.Forms.Button button1;

        private System.Windows.Forms.Button button2;

    }

}

                PersonInChargeMaster picRec = new PersonInChargeMaster();

                if(!picDB.SelectAction(strPerson,ref picRec)) return false;

                // 部署経費率マスタ取得

                string strSQL = "SELECT A.NAMESTRING, NVL(B.EXPENSESRATIO, 0), B.NAMECODE";

                strSQL += " FROM DIVISIONMASTER A";

            m_DspLabelCtrl[(int)DspLblCtrlName.SalaryDays] = textBox1;

            m_DspLabelCtrl[(int)DspLblCtrlName.A_SalaryDays] = textBox2;

            // データ行数

            int DispLineCnt = Enum.GetNames(typeof(CostsRowLine)).Length;