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

        /// <summary>

        /// 協力業者支払区分

        /// </summary>

        public static List<KeyValuePair<int, string>> s_SubContractorKind = new List<KeyValuePair<int, string>>(){

                                                                            new KeyValuePair<int,string>(0,"通　常　業　者"),

                                                                            new KeyValuePair<int,string>(1,"手　間　業　者")};

        #region 15期以前の経費

        public static List<KeyValuePair<string, double>> BeforeExpenses = new List<KeyValuePair<string, double>>{

                                                                                new KeyValuePair<string, double>("会社経費", 8.0),

                                                                                new KeyValuePair<string, double>("営業経費", 5.0),

                                                                                new KeyValuePair<string, double>("各部署経費", 7.0)};

        ///// <summary>

        ///// 各所属部経費（7％）

        ///// </summary>

        //public static const double PartExpenses = 7.0;

        ///// <summary>

        ///// 事務所経費（8％）

        ///// </summary>

        //public static const double OfficeExpenes = 8.0;

        ///// <summary>

        ///// 営業経費（5％）

        ///// </summary>

        //public static const double SaleseExpenes = 5.0;

        #endregion

        #region 担当者選択区分

        /// <summary>

        /// 担当者選択区分

        /// </summary>

        public enum PersonSelectFlg

        {

            /// <summary>

            /// 無

            /// </summary>

            None = 0,

            /// <summary>

            /// 工事担当者

            /// </summary>

            Creator,

            /// <summary>

            /// 副担当者

            /// </summary>

            Assistant,

            /// <summary>

            /// 指導員

            /// </summary>

            Instructor,

        }

        #endregion

        #region 工事詳細台帳データ作成工事種別

        /// <summary>

        /// 工事詳細台帳データ作成工事種別

        /// </summary>

        public static int[] s_CreateLedgerData = new int[] { 6 };

        #endregion

        #region 工事基本情報：紐付データフラグ

        public enum BaseInfoTyingFlg

        {

            /// <summary>

            /// 0:独立データ

            /// </summary>

            Standard = 0,

            /// <summary>

            /// 1:親データ

            /// </summary>

            Pearent,

            /// <summary>

            /// 2:紐付きデータ

            /// </summary>

            Tying,

        }

        #endregion

                ocDB.close(); ocDB = null;

        #region 工事管理システム専用

        #region 工事種別より工事詳細台帳が作成ＯＫかどうかをチェックする

        /// <summary>

        /// 工事種別より工事詳細台帳が作成ＯＫかどうかをチェックする

        /// </summary>

        /// <param name="ConstructionType"></param>

        /// <returns></returns>

        public static bool CheckCreateLedgerData(int ConstructionStatusFlg, int ConstructionType)

        {

            try

            {

                bool ExcuteFlg = false;

                int[] Status = new int[] { CommonDefine.ProjectsStatus.First(x => x.Value.Equals("営繕部継続工事")).Key };

                for (int i = 0; i < CommonDefine.s_CreateLedgerData.Length; i++)

                {

                    if (ConstructionStatusFlg == Status[i] && ConstructionType == CommonDefine.s_CreateLedgerData[i])

                    {

                        ExcuteFlg = true;

                        break;

                    }

                }

                return ExcuteFlg;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

            finally

            {

                ApprDB.close(); ApprDB = null;

            }

                // 申請部署の取得

            IOProcessApproval ApprovalDB = new IOProcessApproval();

                string strSQL = ApprovalDB.CreatePrimarykeyString(ConstructionCode, ApprovalCode);

                strSQL += " AND SEQNO = 1";

                ProcessApproval ApprovalRec = new ProcessApproval();

                int CurrentPersonCode = 0;

                if (ApprovalDB.SelectAction(strSQL, ref ApprovalRec))

                {   // 申請データがある時はそのデータ

                    CurrentPersonCode = ApprovalRec.PersonCode;

                }

                else

                {

                    // データが無い場合（申請時）はログインユーザー

                    CurrentPersonCode = CommonMotions.LoginUserData.PersonCode;

                }

                ApprovalDB.close(); ApprovalDB = null;

                else if (AppString.Equals("継続案件承認"))

                {

                    CurrentPersonCode = baseRec.ConstructionPersonCode;

                }

                LedgerDB.close(); LedgerDB = null;

                LedgerDetailDB.close(); LedgerDetailDB = null;

        #region 工事詳細台帳データを新規作成する

        /// 工事詳細台帳データを新規作成する

        public static bool MakingLedgerData(int ConstructionCode)

                frm.WindowState = FormWindowState.Minimized;

                if (!frm.SaveLedgerData)

                {

                    frm.Close();                    // 画面を閉じる

                    return false;

                }

                return true;

        #region 工事詳細台帳データに増減データを追加する

        /// <summary>

        /// 工事詳細台帳データに増減データを追加する

        /// </summary>

        /// <param name="ConstructionCode"></param>

        /// <returns></returns>

        public static bool AddingLedgerData(int ConstructionCode)

        {

            IOConstructionLink LinkDB = new IOConstructionLink();

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

            FrmConstructionLedger frm = new FrmConstructionLedger();

            try

            {

                // 工事番号が存在しないデータは更新しない

                if (ConstructionCode == 0) return false;

                // 親の工事を探す

                string strParent = string.Format(" WHERE FluctuationCode = {0}", ConstructionCode);

                ConstructionLink LinkRec = new ConstructionLink();

                if (!LinkDB.SelectAction(strParent, ref LinkRec)) return false;

                // 工事詳細台帳データが無い場合は処理しない

                string strExists = LedgerDB.CreatePrimarykeyString(LinkRec.ConstructionCode);

                ConstructionLedger LedgerList = new ConstructionLedger();

                if (!LedgerDB.SelectAction(strExists, ref LedgerList)) return false;

                // 工事コードのセット

                frm.ConstructionCode = LinkRec.ConstructionCode;

                // 見えない画面を出す

                frm.WindowState = FormWindowState.Minimized;

                frm.Show();

                // フォーム非表示

                frm.Visible = false;

                // データを追加する

                frm.AddingConstrCode = ConstructionCode;

                if (!frm.AddDataLedger)

                {

                    frm.Close();                    // 画面を閉じる

                    return false;

                }

                // データ作成処理

                if (!frm.SaveLedgerData)

                {

                    frm.Close();                    // 画面を閉じる

                    return false;

                }

                // 画面を閉じる

                frm.Close();

                return true;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

            finally

            {

                frm.Dispose(); frm = null;

                LedgerDB.close(); LedgerDB = null;

                LinkDB.close(); LinkDB = null;

            }

        }

        #endregion

                                                                                {14, "工事日報－一覧"},

                                                                    Color.SlateGray,

        #region 紐付きの場合は親コードを返す

        /// 紐付きの場合は親コードを返す

        /// <param name="MyType"></param>

        /// <param name="MyCode"></param>

        /// <returns></returns>

        public static int GetParentConstrCode(int MyCode)

            IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();

            IOConstructionLink LinkDB = new IOConstructionLink();

            try

                string strBase = BaseDB.CreatePrimarykeyString(MyCode);

                ConstructionBaseInfo BaseRec = new ConstructionBaseInfo();

                if (!BaseDB.SelectAction(strBase, ref BaseRec)) return MyCode;

                // 紐付きでない場合は工事コードを返す

                if (BaseRec.TyingFlg != (int)CommonDefine.BaseInfoTyingFlg.Tying) return MyCode;

                string strLink = string.Format(" WHERE FluctuationCode = {0}", MyCode);

                ConstructionLink LinkRec = new ConstructionLink();

                if (!LinkDB.SelectAction(strLink, ref LinkRec)) return MyCode;

                return LinkRec.ConstructionCode;

            catch (Exception ex)

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

                return MyCode;

            finally

                BaseDB.close(); BaseDB = null;

                LinkDB.close(); LinkDB = null;

        }

        #endregion

        #region 実行可能プロセスの一覧を取得する

        /// <summary>

        /// 実行可能プロセスの一覧を取得する

        /// </summary>

        /// <param name="ConctructionCode"></param>

        public static void GetProcessList(ref List<KeyValuePair<int,string>> ProcList, int OperationPrcess)

        {

            try

                // 0:メニューへ戻る

                int MenuProcNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;

                string MenuProcName = "メニューへ戻る";

                ProcList.Add(new KeyValuePair<int, string>(MenuProcNo, MenuProcName));

                // 2:工事情報入力データの存在確認

                if (ExistBaseInfoData())

                {

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

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

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

                }

                // 3:積算見積書入力データ存在確認

                if (ExistEstimateData(OperationPrcess))

                {

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

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

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

                }

                // 4:積算見積書印刷データ存在確認

                if (ExistEstimateDataPrint())

                {

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

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

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

                }

                // 5:積算予算書入力データ存在確認

                if (ExistEstimateBudget(OperationPrcess))

                {

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

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

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

                }

                // 6:工事予算書入力データ存在確認

                if (ExistConstructionBudget())

                {

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

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

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

                }

                // 8:工事案件コピー機能データ存在確認

                if (ExistConstructionDataCopy())

                {

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

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

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

                }

                // 9:注文書入力データ存在確認

                if (ExistPurchaseOrder())

                {

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

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

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

                }

                //10:注文書印刷データ存在確認

                if (ExistPurchasePrint())

                {

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

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

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

                }

                // 12:工事詳細台帳

                if (ExistConstructionLedger())

                {

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

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

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

                }

                // 13:交通費及び購入品入力

                if (ExistTAndPCosts())

                {

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

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

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

                }

                //// 15:日報一覧

                //if (ExistDRConstruction())

                //{

                //    int ProcNo = (int)ClsExcute.ProcessExecuteNo.DRConstruction;

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

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

                //}

            catch (Exception ex)

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

            IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();

                // 工事担当者のセット

                string strSQL = BaseDB.CreatePrimarykeyString(m_ConstructionCode);

                strSQL += " AND CONSTRUCTIONPERSONCODE != 0";

                ConstructionBaseInfo BaseRec = new ConstructionBaseInfo();

                if (!BaseDB.SelectAction(strSQL, ref BaseRec)) return false;

                strSQL = EstimateDB.CreatePrimarykeyString(m_ConstructionCode);

                BaseDB.close(); BaseDB = null;

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

                string strSQL = LedgerDB.CreatePrimarykeyString(m_ConstructionCode);

                ConstructionLedger LedgerRec = new ConstructionLedger();

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

                // 工事予算書データの存在チェック

                strSQL = BudgetDB.CreatePrimarykeyString(m_ConstructionCode);

                ConstructionBudget BudgetRec = new ConstructionBudget();

                if (!BudgetDB.SelectAction(strSQL, ref BudgetRec)) return false;

                LedgerDB.close(); LedgerDB = null;

        #region 15:日報入力存在確認

        /// <summary>

        /// 15:日報入力存在確認

        /// </summary>

        /// <returns></returns>

        private static bool ExistDRConstruction()

        {

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

            try

            {

                // 工事詳細台帳データの存在チェック

                string strSQL = LedgerDB.CreatePrimarykeyString(m_ConstructionCode);

                ConstructionLedger LedgerList = new ConstructionLedger();

                if (!LedgerDB.SelectAction(strSQL, ref LedgerList)) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

            finally

            {

                LedgerDB.close(); LedgerDB = null;

            }

        }

        #endregion

                        sErrorMessage = wrkCheck.SendTitle + "／" + wrkCheck.SendMessage;

                WriteData.MessageTitle = CheckRec.SendTitle;                                              // 伝言タイトル

                // 対象データが存在するかを確認する

                string strSQL = "SELECT COUNT(*) FROM CONSTRUCTIONBASEINFO WHERE TRUNC(ESTIMATESSUBMITTEDDATE) != TO_DATE('0001/01/01','YYYY/MM/DD')";

                strSQL += string.Format(" AND TRUNC(ESTIMATESSUBMITTEDDATE + {0})", s_NonOrderDay);

                strSQL += string.Format(" < TO_DATE('{0}','YYYY/MM/DD')", DateTime.Now.ToShortDateString());

                strSQL += string.Format(" AND CONSTRUCTIONSTATUSFLG IN({0}, {1})", iCode2, iCode3);

                strSQL += string.Format(" AND ESTIMATETYPE IN ({0}, {1})", (int)CommonDefine.BaseInfoEstimateType.Normal, (int)CommonDefine.BaseInfoEstimateType.GetBudget);

                ArrayList arList = new ArrayList();

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

                {

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

                    return;

                }

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

                if (Common.CommonMotions.cnvInt(wrkcount[0]) == 0) return;

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

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

                strSQL += " (SELECT CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO WHERE TRUNC(ESTIMATESSUBMITTEDDATE) != TO_DATE('0001/01/01','YYYY/MM/DD')";

        #region ファイルのハッシュ値と更新日付を確認する

                // 接続できなければ処理しない

                if (!Directory.Exists(CommonDefine.s_UPDATE_FILE_PATH)) return true;

        #endregion

        public enum TableColumn

            TYINGFLG,

            strcmd += ", TyingFlg";

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

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

                wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.CONSTRUCTION_CODE].ToString());

                wrk.TyingFlg = int.Parse(objwrk[(int)TableColumn.TYINGFLG].ToString());

                wrk.ConstructionYear = int.Parse(objwrk[(int)TableColumn.CONSTRUCTION_YEAR].ToString());

                wrk.ConstructionPeriod = int.Parse(objwrk[(int)TableColumn.CONSTRUCTION_PERIOD].ToString());

                wrk.RequestedDate = DateTime.Parse(objwrk[(int)TableColumn.REQUESTED_DATE].ToString());

                wrk.EstimatesSubmitDeadline = DateTime.Parse(objwrk[(int)TableColumn.ESTIMATESSUBMITDEADLINE].ToString());

                wrk.EstimatesSubmittedDate = DateTime.Parse(objwrk[(int)TableColumn.ESTIMATESSUBMITTED_DATE].ToString());

                wrk.ProvisionalOrderDate = DateTime.Parse(objwrk[(int)TableColumn.PROVISIONALORDERDATE].ToString());

                wrk.OrderDate = DateTime.Parse(objwrk[(int)TableColumn.ORDER_DATE].ToString());

                wrk.OrderStartingDate = DateTime.Parse(objwrk[(int)TableColumn.ORDERSTARTINGDATE].ToString());

                wrk.OrderCompletionDate = DateTime.Parse(objwrk[(int)TableColumn.ORDERCOMPLETIONDATE].ToString());

                wrk.PreparationStartDate = DateTime.Parse(objwrk[(int)TableColumn.PREPARATIONSTARTDATE].ToString());

                wrk.ConstructionStartingDate = DateTime.Parse(objwrk[(int)TableColumn.CONSTRUCTIONSTARTINGDATE].ToString());

                wrk.ConstructionCompletionDate = DateTime.Parse(objwrk[(int)TableColumn.CONSTRUCTIONCOMPLETION_DATE].ToString());

                wrk.NonOrderDate = DateTime.Parse(objwrk[(int)TableColumn.NONORDERDATE].ToString());

                wrk.OrdersDecisionPrice = double.Parse(objwrk[(int)TableColumn.ORDERS_DECISION_PRICE].ToString());

                wrk.OrdersDecisionPriceInTax = double.Parse(objwrk[(int)TableColumn.ORDERS_DECISION_PRICE_IN_TAX].ToString());

                wrk.SalesPersonCode = int.Parse(objwrk[(int)TableColumn.SALES_PERSON_CODE].ToString());

                wrk.ConstructionPersonCode = int.Parse(objwrk[(int)TableColumn.CONSTRPERSONCODE].ToString());

                wrk.ConstrSubPersonCode = int.Parse(objwrk[(int)TableColumn.CONSTRSUBPERSONCODE].ToString());

                wrk.ConstructionInstructor = int.Parse(objwrk[(int)TableColumn.CONSTRUCTIONINSTRUCTOR].ToString());

                wrk.TransferConstruction = int.Parse(objwrk[(int)TableColumn.TRANSFERCONSTRUCTION].ToString());

                wrk.TransferConstructionDate = DateTime.Parse(objwrk[(int)TableColumn.TRANSFERCONSTRUCTIONDATE].ToString());

                wrk.OrderersDivision = int.Parse(objwrk[(int)TableColumn.ORDERERS_DIVISION].ToString());

                wrk.OrderersCode = int.Parse(objwrk[(int)TableColumn.ORDERERS_CODE].ToString());

                wrk.EstimatesExpirationDate = DateTime.Parse(objwrk[(int)TableColumn.ESTIMATESEXPIRATIONDATE].ToString());

                wrk.ConstructionPeriodStart = DateTime.Parse(objwrk[(int)TableColumn.CONSTRUCTIONPERIODSTART].ToString());

                wrk.ConstructionPeriodEnd = DateTime.Parse(objwrk[(int)TableColumn.CONSTRUCTIONPERIODEND].ToString());

                wrk.ConstructionPeriodStart2 = DateTime.Parse(objwrk[(int)TableColumn.CONSTRUCTIONPERIODSTART2].ToString());

                wrk.ConstructionPeriodEnd2 = DateTime.Parse(objwrk[(int)TableColumn.CONSTRUCTIONPERIODEND2].ToString());

                wrk.StartDate = DateTime.Parse(objwrk[(int)TableColumn.START_DATE].ToString());

                wrk.EndDate = DateTime.Parse(objwrk[(int)TableColumn.END_DATE].ToString());

                wrk.PurchaseOrderMailingDate = DateTime.Parse(objwrk[(int)TableColumn.PURCHASEORDERMAILINGDATE].ToString());

                wrk.PurchaseOrderReturnDate = DateTime.Parse(objwrk[(int)TableColumn.PURCHASEORDERRETURNDATE].ToString());

                wrk.PurchaseOrderReturnCheckDate = DateTime.Parse(objwrk[(int)TableColumn.PURCHASEORDERRETURNCHECKDATE].ToString());

                wrk.ConsumptionTaxFlg = int.Parse(objwrk[(int)TableColumn.CONSUMPTIONTAX_FLG].ToString());

                wrk.PrimeContractorFlg = int.Parse(objwrk[(int)TableColumn.PRIMECONTRACTOR_FLG].ToString());

                wrk.SalesCostFlg = int.Parse(objwrk[(int)TableColumn.SALESCOST_FLG].ToString());

                wrk.ConstructionStatusFlg = int.Parse(objwrk[(int)TableColumn.CONSTRUCTIONSTATUS_FLG].ToString());

                wrk.ConstructionType = int.Parse(objwrk[(int)TableColumn.CONSTRUCTIONTYPE].ToString());

                wrk.EstimateType = int.Parse(objwrk[(int)TableColumn.ESTIMATETYPE].ToString());

                wrk.BillingStartDate = DateTime.Parse(objwrk[(int)TableColumn.BILLINGSTARTDATE].ToString());

                wrk.BillingDate = DateTime.Parse(objwrk[(int)TableColumn.BILLINGDATE].ToString());

                wrk.BillingSplitFlg = int.Parse(objwrk[(int)TableColumn.BILLINGSPLITFLG].ToString());

                wrk.BillingSendDate = DateTime.Parse(objwrk[(int)TableColumn.BILLINGSENDDATE].ToString());

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

                wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UPDATE_DATE].ToString());

                    case (int)TableColumn.CONSTRUCTION_CODE:

                    case (int)TableColumn.TYINGFLG:

                        strcmd += string.Format(" TyingFlg = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.CONSTRUCTION_YEAR:

                    case (int)TableColumn.CONSTRUCTION_PERIOD:

                    case (int)TableColumn.REQUESTED_DATE:

                    case (int)TableColumn.ESTIMATESSUBMITDEADLINE:

                    case (int)TableColumn.ESTIMATESSUBMITTED_DATE:

                    case (int)TableColumn.ORDER_DATE:

                    case (int)TableColumn.ORDERSTARTINGDATE:

                    case (int)TableColumn.ORDERCOMPLETIONDATE:

                    case (int)TableColumn.CONSTRUCTIONSTARTINGDATE:

                    case (int)TableColumn.CONSTRUCTIONCOMPLETION_DATE:

                    case (int)TableColumn.ORDERS_DECISION_PRICE:

                    case (int)TableColumn.ORDERS_DECISION_PRICE_IN_TAX:

                    case (int)TableColumn.SALES_PERSON_CODE:

                    case (int)TableColumn.CONSTRPERSONCODE:

                    case (int)TableColumn.CONSTRSUBPERSONCODE:

                    case (int)TableColumn.CONSTRUCTIONINSTRUCTOR:

                    case (int)TableColumn.TRANSFERCONSTRUCTION:

                    case (int)TableColumn.TRANSFERCONSTRUCTIONDATE:

                    case (int)TableColumn.ORDERERS_DIVISION:

                    case (int)TableColumn.ORDERERS_CODE:

                    case (int)TableColumn.ESTIMATESEXPIRATIONDATE:

                    case (int)TableColumn.CONSTRUCTIONPERIODSTART:

                    case (int)TableColumn.CONSTRUCTIONPERIODEND:

                    case (int)TableColumn.START_DATE:

                    case (int)TableColumn.END_DATE:

                    case (int)TableColumn.CONSUMPTIONTAX_FLG:

                    case (int)TableColumn.PRIMECONTRACTOR_FLG:

                    case (int)TableColumn.SALESCOST_FLG:

                    case (int)TableColumn.CONSTRUCTIONSTATUS_FLG:

                    case (int)TableColumn.CONSTRUCTIONTYPE:

                    case (int)TableColumn.ESTIMATETYPE:

                    case (int)TableColumn.BILLINGSTARTDATE:

                    case (int)TableColumn.BILLINGDATE:

                    case (int)TableColumn.BILLINGSPLITFLG:

                strcmd = "SELECT NVL(MAX(ConstructionCode), 0) FROM ConstructionBaseInfo" + AddSQLString;

                //strcmd = "UPDATE ConstructionBaseInfo SET EntryDate = TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

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

                //strcmd += CreatePrimarykeyString(FromCode);

                //// SQL実行

                //if (!ExecuteNonQuery(strcmd, bConnect)) return false;

        #region 工事番号の枝番が最大値のものを取得する

        /// <summary>

        /// 工事番号の枝番が最大値のものを取得する

        /// </summary>

        /// <param name="NowCode"></param>

        /// <returns></returns>

        public int CreateNextBranchCounstructionCode(int NowCode)

        {

            IOConstructionBaseInfo cbDB = new IOConstructionBaseInfo();                // 工事基本情報

            try

            {

                int ConstructionCode = -1;

                // 枝番最大値の工事番号取得

                string strSQL = "SELECT NVL(MAX(CONSTRUCTIONCODE), -1) FROM CONSTRUCTIONBASEINFO";

                strSQL += string.Format(" WHERE TRUNC(CONSTRUCTIONCODE / 100) = {0}", CommonMotions.cnvTruncate(NowCode / 100));

                ArrayList arList = new ArrayList();

                // データが無ければ抜ける

                if (!cbDB.ExecuteReader(strSQL, ref arList)) return ConstructionCode;

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

                ConstructionCode = CommonMotions.cnvInt(wrkobj[0]);

                if (ConstructionCode > 1) ConstructionCode++;

                return ConstructionCode;

            }

            catch (System.Exception ex)

            {

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

                return -1;

            }

            finally

            {

                cbDB.close(); cbDB = null;

            }

        }

        #endregion

        public enum TableColumn

                wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.CONSTRUCTION_CODE].ToString());

                wrk.DetailNo = int.Parse(objwrk[(int)TableColumn.DETAIL_NO].ToString());

                wrk.DetailString = objwrk[(int)TableColumn.DETAIL_STRING].ToString();

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

                wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UPDATE_DATE].ToString());

                //strcmd = "UPDATE ConstructionBaseInfoDetail SET EntryDate = TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

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

                //strcmd += CreatePrimarykeyString(FromCode);

                //// SQL実行

                //if (!ExecuteNonQuery(strcmd, bConnect)) return false;

            AssistantCode,              // 副担当者コード

            AssistantName,              // 副担当者名

            AssistantCosts,             // 副担当者給与

            A_SalaryFlg,                // 副担当者給与振分区分

            A_SalaryDays,               // 副担当者振分日数

            I_SalaryFlg,                // 指導員給与振分区分

            I_SalaryDays,               // 指導員振分日数

            strcmd += " ,AssistantCode";                            // 副担当者コード

            strcmd += " ,AssistantName";                            // 副担当者名

            strcmd += " ,AssistantCosts";                           // 副担当者給与

            strcmd += " ,A_SalaryFlg";                              // 副担当者給与振分区分

            strcmd += " ,A_SalaryDays";                             // 副担当者振分日数

            strcmd += " ,I_SalaryFlg";                              // 指導員給与振分区分

            strcmd += " ,I_SalaryDays";                             // 指導員振分日数

                strcmd += string.Format(", {0}", work.AssistantCode);                   // 副担当者コード

                strcmd += string.Format(",'{0}'", work.AssistantName);                  // 副担当者名

                strcmd += string.Format(", {0}", work.AssistantCosts);                  // 副担当者給与

                strcmd += string.Format(", {0}", work.A_SalaryFlg);                     // 副担当者給与振分区分

                strcmd += string.Format(", {0}", work.A_SalaryDays);                    // 副担当者振分日数

                strcmd += string.Format(", {0}", work.I_SalaryFlg);                     // 指導員給与振分区分

                strcmd += string.Format(", {0}", work.I_SalaryDays);                    // 指導員振分日数

                strcmd += string.Format(", AssistantCode = {0}", data.AssistantCode);                   // 副担当者コード

                strcmd += string.Format(", AssistantName = '{0}'", data.AssistantName);                 // 副担当者名

                strcmd += string.Format(", AssistantCosts = {0}", data.AssistantCosts);                 // 副担当者給与

                strcmd += string.Format(", A_SalaryFlg = {0}", data.A_SalaryFlg);                       // 副担当者給与振分区分

                strcmd += string.Format(", A_SalaryDays = {0}", data.A_SalaryDays);                     // 副担当者振分日数

                strcmd += string.Format(", I_SalaryFlg = {0}", data.I_SalaryFlg);                       // 指導員給与振分区分

                strcmd += string.Format(", I_SalaryDays = {0}", data.I_SalaryDays);                     // 指導員振分日数

                wrk.AssistantCode = int.Parse(objwrk[(int)ConstructionBudgetColumn.AssistantCode].ToString());              // 副担当者コード

                wrk.AssistantName = objwrk[(int)ConstructionBudgetColumn.AssistantName].ToString();                         // 副担当者名

                wrk.AssistantCosts = int.Parse(objwrk[(int)ConstructionBudgetColumn.AssistantCosts].ToString());            // 副担当者給与

                wrk.A_SalaryFlg = int.Parse(objwrk[(int)ConstructionBudgetColumn.A_SalaryFlg].ToString());                  // 副担当者給与振分区分

                wrk.A_SalaryDays = int.Parse(objwrk[(int)ConstructionBudgetColumn.A_SalaryDays].ToString());                // 副担当者振分日数

                wrk.I_SalaryFlg = int.Parse(objwrk[(int)ConstructionBudgetColumn.I_SalaryFlg].ToString());                  // 指導員給与振分区分

                wrk.I_SalaryDays = int.Parse(objwrk[(int)ConstructionBudgetColumn.I_SalaryDays].ToString());                // 指導員振分日数

        /// <param name="ConstructionCode"></param>

        /// <param name="GroupCount"></param>

        public string CreatePrimarykeyString(int ConstructionCode, int GroupCount = 0, int LineCount = 0)

                if (GroupCount != 0)

                    strWork += string.Format(" And GroupCount = {0}", GroupCount);

            FluctuationFlg,         // 増減データフラグ

            strcmd += ", FluctuationFlg";           // 増減データフラグ

                strcmd += string.Format(", {0}", work.FluctuationFlg);          // 増減データフラグ

                strcmd += string.Format(", FluctuationFlg = {0}", data.FluctuationFlg);             // 増減データフラグ

                wrk.FluctuationFlg = int.Parse(objwrk[(int)DataColumn.FluctuationFlg].ToString());              // 増減データフラグ

                strcmd = "SELECT NVL(MAX(LineCount), 0) FROM ConstructionLedgerDetail" + AddSQLString;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Collections;

using log4net;

using Oracle.ManagedDataAccess.Client;

using ProcessManagement.DB.Oracle;

using ProcessManagement.DB.Core;

using ProcessManagement.DataModel;

using ProcessManagement.Common;

namespace ProcessManagement.DB.IOAccess

{

    /// <summary>

    /// 工事増減情報ＤＢアクセス

    /// </summary>

    public class IOConstructionLink : OracleProcess

    {

        #region 定義部

        /// <summary>

        /// log4netログを使用する

        /// </summary>

        private static readonly ILog logger = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

        #endregion

        #region 定数

        /// <summary>

        /// 工事増減情報フィールド並び

        /// </summary>

        public enum ConstructionLinkColumn

        {

            CONSTRUCTION_CODE = 0,

            FLUCTUATION_CODE,

            ENTRY_DATE,

            UPDATE_DATE,

        }

        #endregion

        #region プロパティ

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

        /// <param name="ConnectionString"></param>

        public IOConstructionLink()

            : base(DBCommon.Instance.DBConnectString)

        {

        }

        #endregion

        #region SELECT　SQL作成

        /// <summary>

        /// SQL作成

        /// </summary>

        private string CreateSelectSQL()

        {

            // SQL作成（oracleのDateTime型が変換できないのでCharに変換しておく）

            string strcmd = "SELECT";

            strcmd += "  ConstructionCode, FluctuationCode";

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

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

            strcmd += " FROM ConstructionLink";

            return strcmd;

        }

        #endregion