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

        #region 承認処理：デフォルト承認受付番号

        /// <summary>

        /// 承認処理：デフォルト承認受付番号

        /// </summary>

        public static int s_Default_OrderNo = 1;

        #endregion

        #region 見積書入力：固定項目キー

        /// <summary>

        /// 見積書入力：固定項目キー

        /// </summary>

        public enum EstimateTotalSeqNo

        {

            /// <summary>

            /// 合計：'A'

            /// </summary>

            ToTal1 = 0,

            /// <summary>

            /// 端数処理：'B'

            /// </summary>

            ToTal2,

            /// <summary>

            /// 改め合計：'C'

            /// </summary>

            ToTal3,

            /// <summary>

            /// 消費税相当額：'D'

            /// </summary>

            ToTal4,

            /// <summary>

            /// 総計：'E'

            /// </summary>

            ToTal5,

        }

        #endregion

        #region 見積書入力：固定項目キー文字列

        /// <summary>

        /// 見積書入力：固定項目キー文字列

        /// </summary>

        /// <param name="estimatetotalseqNo"></param>

        /// <returns></returns>

        public static string GetEstimateTotalSeqNo(this EstimateTotalSeqNo estimatetotalseqNo)

        {

            string[] names = { "A", "B", "C", "D", "E" };

            return names[(int)estimatetotalseqNo];

        }

        #endregion

        #region 注文書入力：印刷対象金額

        /// <summary>

        /// 印刷対象金額

        /// </summary>

        public static int s_PrintOutPrice = 300000;

        #endregion

        #region 汎用データ：コードデータ種別

        /// 汎用データ：コードデータ種別

        public enum CodeDataType

        #region 工事リンク情報：リンク種別

        /// <summary>

        /// 工事リンク情報：リンク種別

        /// </summary>

        public enum LinkDataType

        {

            /// <summary>

            /// 0:増減工事

            /// </summary>

            FluctuationType = 0,

            /// <summary>

            /// 1:結合工事

            /// </summary>

            JoinType,

        }

        #endregion

        /// <summary>

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

        /// </summary>

            /// 1:増減親データ

            /// 2:増減子データ

        #region 工事基本情報：結合工事フラグ

        /// 工事基本情報：結合工事フラグ

        public enum BaseInfoJoinFlg

            /// 0:結合無通常データ

            Standard = 0,

            /// 1:結合親データ

            JoinParent,

            /// <summary>

            /// 2:結合子データ

            /// </summary>

            JoinChildren,

        #region 工事詳細台帳明細：担当中フラグ

        /// 担当中フラグ

        /// </summary>

        public enum SalaryOperateKind

        {

            /// <summary>

            /// 担当終了

            /// </summary>

            Complate = 0,

            /// <summary>

            /// 担当中

            /// </summary>

            Oparateing,

        }

        #endregion

        #region 工事詳細台帳明細：増減工事フラグ

        /// <summary>

            Normal = 0,

        #region 工事詳細台帳明細：注文書発行フラグ

        /// <summary>

        /// 工事詳細台帳明細：注文書発行フラグ

        /// </summary>

        public enum PurchaseOrderFlg

        {

            /// <summary>

            /// 未作成

            /// </summary>

            NoCreate = 0,

            /// <summary>

            /// 作成中

            /// </summary>

            Making = 1,

        }

        #endregion

        #region 登録完了メッセージ表示

        /// <summary>

        /// 登録完了メッセージ表示

        /// </summary>

        /// <param name="strTitle"></param>

        public static void EntryEndMessage(string strTitle)

        {

            try

            {

                string strMes = string.Format("{0} 登録完了しました。", strTitle);

                MessageBox.Show(strMes, "登録完了メッセージ", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

            catch (Exception ex)

            {

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

            }

        }

        public static void EntryEndMessage(string strTitle, string strTitle2)

        {

            try

            {

                string strMes = string.Format("{0} {1}完了しました。", strTitle, strTitle2);

                string strGuidance = string.Format("{0}完了メッセージ", strTitle2);

                MessageBox.Show(strMes, strGuidance, MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

            catch (Exception ex)

            {

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

            }

        }

        #region 削除完了メッセージ表示

        /// <summary>

        /// 削除完了メッセージ表示

        /// </summary>

        /// <param name="strTitle"></param>

        public static void RemoveEndMessage(string strTitle)

        {

            try

            {

                string strMes = string.Format("{0} 削除完了しました。", strTitle);

                MessageBox.Show(strMes, "削除完了メッセージ", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #endregion

                string strSQL = ApprDB.CreatePrimarykeyString(Rec.ConstructionCode, Rec.ApprovalCode, Rec.OrderNo, Rec.SeqNo);

        public static bool SetPrimaryRecStatus(int ConstructionCode, int ApprovalCode, int OrderNO, int Status)

                //string strSQL = ApprDB.CreatePrimarykeyString(ConstructionCode, ApprovalCode, OrderNO, 1);

                //ProcessApproval DataRec = new ProcessApproval();

                //// データがあるかをチェックする

                //if (!ApprDB.SelectAction(strSQL, ref DataRec)) return false;

                //DataRec.ApprovalStatus = Status;

                //if (!ApprDB.UpdateAction(strSQL, DataRec)) return false;

                if (!ApprDB.UpdateFeild(ConstructionCode,

                                        (int)IOProcessApproval.ColumnName.ApprovalStatus,

                                        Status,

                                        true,

                                        ApprovalCode,

                                        OrderNO,

                                        1)) return false;

        public static bool CheckPetition(int ConstructionCode, int ApprovalCode, int ApprovalCount)

                string strSQL = ApprDB.CreatePrimarykeyString(ConstructionCode, ApprovalCode, ApprovalCount, 1);

        public static bool CheckApproval(int ConstructionCode, int ApprovalCode, int Approvalcount)

                string strData = ApprDB.CreatePrimarykeyString(ConstructionCode, ApprovalCode, Approvalcount, 1);

        public static bool CheckApprovalData(int ConstructionCode, int ApprovalCode, int OrderNo)

                int DepartmentCode = GetFromConstructionAndApprovalTheDepartment(ConstructionCode, ApprovalCode, OrderNo);

                string strData = ApprDB.CreatePrimarykeyString(ConstructionCode, ApprovalCode, OrderNo);

        public static int GetFromConstructionAndApprovalTheDepartment(int ConstructionCode, int ApprovalCode, int OrderNo)

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

        public static int GetApprovalDataCount(int ConstructionCode, int ApprovalCode, int ApprovalCount)

                string strSQL = paDB.CreatePrimarykeyString(ConstructionCode, ApprovalCode, ApprovalCount);

        #region 関連データすべて削除

        /// <summary>

        /// 関連データすべて削除

        /// </summary>

        /// <returns></returns>

        public static bool RemoveAllelationData(int RemoveCode)

        {

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

            IOConstructionBaseInfoDetail DB02 = new IOConstructionBaseInfoDetail(); // 工事基本情報明細

            IOConstructionLink DB03 = new IOConstructionLink();                     // 工事増減情報

            IOProcessApproval DB04 = new IOProcessApproval();                       // 承認データ

            IOConstructionProgressDate DB05 = new IOConstructionProgressDate();     // 案件進捗日付データ

            IOEstimateData DB06 = new IOEstimateData();                             // 積算見積書データ

            IOEstimateDataBody DB07 = new IOEstimateDataBody();                     // 積算見積書ページデータ

            IOEstimateDataDetail DB08 = new IOEstimateDataDetail();                 // 積算見積書明細データ

            IOEstimateBudget DB09 = new IOEstimateBudget();                         // 積算予算書データ

            IOEstimateBudgetDetail DB10 = new IOEstimateBudgetDetail();             // 積算予算書明細データ

            IOConstructionBudget DB11 = new IOConstructionBudget();                 // 工事予算書データ

            IOOrdersPriceData DB12 = new IOOrdersPriceData();		                // 受注金額データ

            IOConstructionBudgetDetail DB13 = new IOConstructionBudgetDetail();     // 工事予算書明細データ

            IOConstructionLedger DB14 = new IOConstructionLedger();                 // 工事詳細台帳データ

            IOConstructionLedgerDetail DB15 = new IOConstructionLedgerDetail();     // 工事詳細台帳明細データ

            IOConstructionLedgerExcute DB16 = new IOConstructionLedgerExcute();     // 工事詳細台帳実行データ

            IOPurchaseOrder DB17 = new IOPurchaseOrder();			                // 注文書データ

            IOPurchaseOrderDetail DB18 = new IOPurchaseOrderDetail();               // 注文書明細データ

            IOProceedingsData DB19 = new IOProceedingsData();                       // 発注者打ち合わせ議事録データ

            IOProceedingsDataAttendee DB20 = new IOProceedingsDataAttendee();       // 発注者打ち合わせ議事録データ（出席者）

            IOProceedingsDataDetail DB21 = new IOProceedingsDataDetail();           // 発注者打ち合わせ議事録データ（明細）

            IODailyDataConstruction DB22 = new IODailyDataConstruction();           // 日報データ

            IODailyDataDetail DB23 = new IODailyDataDetail();                       // 日報データ (明細)

            IODailyDataVehicles DB24 = new IODailyDataVehicles();                   // 日報データ (車両)

            IODailyDataMaterials DB25 = new IODailyDataMaterials();                 // 日報データ (資材)

            IODailyDataSubcontractors DB26 = new IODailyDataSubcontractors();       // 日報データ (協力業者指示)

            IODailyDataField DB27 = new IODailyDataField();                         // 日報データ (現場巡回)

            try

            {

                // 工事情報存在確認

                string strExists = DB01.CreatePrimarykeyString(RemoveCode);

                ConstructionBaseInfo BaseRec = new ConstructionBaseInfo();

                if (!DB01.SelectAction(strExists, ref BaseRec)) return false;

                List<int> RemoveList = new List<int>();

                List<int> UpdateLinkList = new List<int>();

                RemoveList.Add(RemoveCode);

                // 増減工事親確認

                if (BaseRec.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Parent)

                {

                    GetLinkageCode(RemoveCode, DB03, ref RemoveList, false);

                }

                // 結合工事親確認

                if (BaseRec.JoinFlg == (int)CommonDefine.BaseInfoJoinFlg.JoinParent)

                {

                    GetLinkageCode(RemoveCode, DB03, ref UpdateLinkList, true);

                }

                DB01.connect(); DB02.connect(); DB03.connect(); DB04.connect(); DB05.connect(); DB06.connect();

                DB07.connect(); DB08.connect(); DB09.connect(); DB10.connect(); DB11.connect(); DB12.connect();

                DB13.connect(); DB14.connect(); DB15.connect(); DB16.connect(); DB17.connect(); DB18.connect();

                DB19.connect(); DB20.connect(); DB21.connect(); DB22.connect(); DB23.connect(); DB24.connect();

                DB25.connect(); DB26.connect(); DB27.connect();

                DB01.beginTran(); DB02.beginTran(); DB03.beginTran(); DB04.beginTran(); DB05.beginTran(); DB06.beginTran();

                DB07.beginTran(); DB08.beginTran(); DB09.beginTran(); DB10.beginTran(); DB11.beginTran(); DB12.beginTran();

                DB13.beginTran(); DB14.beginTran(); DB15.beginTran(); DB16.beginTran(); DB17.beginTran(); DB18.beginTran();

                DB19.beginTran(); DB20.beginTran(); DB21.beginTran(); DB22.beginTran(); DB23.beginTran(); DB24.beginTran();

                DB25.beginTran(); DB26.beginTran(); DB27.beginTran();

                bool ProcSuccess = true;

                string strRemove = string.Empty;

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

                {

                    strRemove = DB01.CreatePrimarykeyString(RemoveList[i]);

                    if (!DB01.DeleteAction(strRemove, false)) { ProcSuccess = false; break; }

                    if (!DB02.DeleteAction(strRemove, false)) { ProcSuccess = false; break; }

                    DB03.DeleteAction(strRemove, false);

                    DB04.DeleteAction(strRemove, false);

                    DB05.DeleteAction(strRemove, false);

                    DB06.DeleteAction(strRemove, false);

                    DB07.DeleteAction(strRemove, false);

                    DB08.DeleteAction(strRemove, false);

                    DB09.DeleteAction(strRemove, false);

                    DB10.DeleteAction(strRemove, false);

                    DB11.DeleteAction(strRemove, false);

                    DB12.DeleteAction(strRemove, false);

                    DB13.DeleteAction(strRemove, false);

                    DB14.DeleteAction(strRemove, false);

                    DB15.DeleteAction(strRemove, false);

                    DB16.DeleteAction(strRemove, false);

                    DB17.DeleteAction(strRemove, false);

                    DB18.DeleteAction(strRemove, false);

                    DB19.DeleteAction(strRemove, false);

                    DB20.DeleteAction(strRemove, false);

                    DB21.DeleteAction(strRemove, false);

                    DB22.DeleteAction(strRemove, false);

                    DB23.DeleteAction(strRemove, false);

                    DB24.DeleteAction(strRemove, false);

                    DB25.DeleteAction(strRemove, false);

                    DB26.DeleteAction(strRemove, false);

                    DB27.DeleteAction(strRemove, false);

                }

                // 結合工事リンク情報更新（1件目は削除済み）

                if (ProcSuccess)

                {

                    // 増減工事親確認

                    if (BaseRec.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Parent)

                    {

                        for (int i = 1; i < RemoveList.Count; i++)

                        {

                            if (!DB01.UpdateFeild(RemoveList[i]

                                                , (int)IOConstructionBaseInfo.TableColumn.TyingFlg

                                                , (int)CommonDefine.BaseInfoTyingFlg.Standard

                                                , false))

                            {

                                ProcSuccess = false;

                                break;

                            }

                        }

                    }

                    // 結合工事親確認

                    if (BaseRec.JoinFlg == (int)CommonDefine.BaseInfoJoinFlg.JoinParent)

                    {

                        for (int i = 1; i < UpdateLinkList.Count; i++)

                        {

                            if (!DB01.UpdateFeild(UpdateLinkList[i]

                                                , (int)IOConstructionBaseInfo.TableColumn.JoinFlg

                                                , (int)CommonDefine.BaseInfoJoinFlg.Standard

                                                , false))

                            {

                                ProcSuccess = false;

                                break;

                            }

                        }

                    }

                }

                // ＤＢ終了処理

                if (ProcSuccess)

                {

                    DB01.commit(); DB02.commit(); DB03.commit(); DB04.commit(); DB05.commit(); DB06.commit();

                    DB07.commit(); DB08.commit(); DB09.commit(); DB10.commit(); DB11.commit(); DB12.commit();

                    DB13.commit(); DB14.commit(); DB15.commit(); DB16.commit(); DB17.commit(); DB18.commit();

                    DB19.commit(); DB20.commit(); DB21.commit(); DB22.commit(); DB23.commit(); DB24.commit();

                    DB25.commit(); DB26.commit(); DB27.commit();

                }

                else

                {

                    DB01.rollback(); DB02.rollback(); DB03.rollback(); DB04.rollback(); DB05.rollback(); DB06.rollback();

                    DB07.rollback(); DB08.rollback(); DB09.rollback(); DB10.rollback(); DB11.rollback(); DB12.rollback();

                    DB13.rollback(); DB14.rollback(); DB15.rollback(); DB16.rollback(); DB17.rollback(); DB18.rollback();

                    DB19.rollback(); DB20.rollback(); DB21.rollback(); DB22.rollback(); DB23.rollback(); DB24.rollback();

                    DB25.rollback(); DB26.rollback(); DB27.rollback();

                }

                return ProcSuccess;

            }

            catch (Exception ex)

            {

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

                return false;

            }

            finally

            {

                DB01.close(); DB02.close(); DB03.close(); DB04.close(); DB05.close(); DB06.close();

                DB07.close(); DB08.close(); DB09.close(); DB10.close(); DB11.close(); DB12.close();

                DB13.close(); DB14.close(); DB15.close(); DB16.close(); DB17.close(); DB18.close();

                DB19.close(); DB20.close(); DB21.close(); DB22.close(); DB23.close(); DB24.close();

                DB25.close(); DB26.close(); DB27.close();

                DB01 = null; DB02 = null; DB03 = null; DB04 = null; DB05 = null; DB06 = null;

                DB07 = null; DB08 = null; DB09 = null; DB10 = null; DB11 = null; DB12 = null;

                DB13 = null; DB14 = null; DB15 = null; DB16 = null; DB17 = null; DB18 = null;

                DB19 = null; DB20 = null; DB21 = null; DB22 = null; DB23 = null; DB24 = null;

                DB25 = null; DB26 = null; DB27 = null;

            }

        }

        #endregion

        #region 工事リンクコード取得

        /// <summary>

        /// 工事リンクコード取得

        /// </summary>

        private static void GetLinkageCode(int RemoveCode, IOConstructionLink LinkDB, ref List<int> RemoveList, bool bJoin = true)

        {

            try

            {

                string strSQL = "SELECT FLUCTUATIONCODE FROM CONSTRUCTIONLINK";

                strSQL += LinkDB.CreatePrimarykeyString(RemoveCode);

                if (bJoin)

                    strSQL += string.Format(" AND LINKTYPE = {0}", (int)CommonDefine.LinkDataType.JoinType);

                else

                    strSQL += string.Format(" AND LINKTYPE = {0}", (int)CommonDefine.LinkDataType.FluctuationType);

                ArrayList arList = new ArrayList();

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

                foreach (object[] CurRec in arList)

                {

                    RemoveList.Add(CommonMotions.cnvInt(CurRec[0]));

                }

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 結合親工事番号取得処理

        /// <summary>

        /// 結合親工事番号取得処理

        /// </summary>

        /// <param name="DataList"></param>

        /// <param name="bFirst"></param>

        public static void GetParentData(int SearchCode, ref ArrayList DataList, ref int FuncCnt)

        {

            IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();

            try

            {

                int iStatus = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("非 受 注")).Key;

                DataList.Clear();

                // 結合工事表示

                string strParent = "SELECT DISTINCT(A.CONSTRUCTIONCODE), B.REQUESTEDDATE, 0, 0, 0, 0, F.DETAILSTRING, B.JOINFLG";

                strParent += " FROM CONSTRUCTIONLINK A";

                strParent += " LEFT OUTER JOIN CONSTRUCTIONBASEINFODETAIL F ON (F.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE";

                strParent += string.Format(" AND F.DETAILNO = {0})", (int)ConstructionBaseInfoDetail.DetailDataNo.ConstructionName);

                strParent += " , CONSTRUCTIONBASEINFO B";

                strParent += string.Format(" WHERE A.FLUCTUATIONCODE = {0}", SearchCode);

                switch (FuncCnt)

                {

                    case 0:

                    case 2:

                        // 結合タイプよりデータを検索

                        strParent += string.Format(" AND A.LINKTYPE = {0}", (int)CommonDefine.LinkDataType.JoinType);

                        break;

                    case 1:

                        // 増減タイプよりデータを検索

                        strParent += string.Format(" AND A.LINKTYPE = {0}", (int)CommonDefine.LinkDataType.FluctuationType);

                        break;

                }

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

                strParent += string.Format(" AND B.CONSTRUCTIONSTATUSFLG != {0}", iStatus);

                if (!BaseDB.ExecuteReader(strParent, ref DataList))

                {

                    FuncCnt = 3;

                    return;

                }

                FuncCnt++;

                if (DataList.Count == 0)

                {

                    if (FuncCnt > 2) return;

                    // 3回目までは再起呼出

                    GetParentData(SearchCode, ref DataList, ref FuncCnt);

                    return;

                }

                // 結合の元データ以外はクリア

                object[] objRec = (object[])DataList[0];

                if (CommonMotions.cnvInt(objRec[7]) != (int)CommonDefine.BaseInfoJoinFlg.JoinParent)

                {

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

                    DataList.Clear();

                    GetParentData(SecondCode, ref DataList, ref FuncCnt);

                }

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                BaseDB.close(); BaseDB = null;

            }

        }

        #endregion

        #region 結合親工事の工事進捗状態をセットする

        /// <summary>

        /// 結合親工事の工事進捗状態をセットする

        /// </summary>

        public static bool SetParentConstrStatus(IOConstructionBaseInfo BaseDB, int TargetCode)

        {

            try

            {

                // 対象の工事情報を取得する

                string strSQL = BaseDB.CreatePrimarykeyString(TargetCode);

                ConstructionBaseInfo BaseRec = new ConstructionBaseInfo();

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

                // 結合工事では無ければ処理しない

                if (BaseRec.JoinFlg == (int)CommonDefine.BaseInfoJoinFlg.Standard) return true;

                // 対象の親番号を取得する

                int ParentCode = ClsProcessExist.GetParentConstrCode(TargetCode);

                // 結合している工事番号をすべて取得する

                strSQL = "SELECT A.CONSTRUCTIONCODE, A.FLUCTUATIONCODE, D.JOINFLG, B.FLUCTUATIONCODE, C.JOINFLG FROM CONSTRUCTIONLINK A";

                strSQL += " LEFT JOIN CONSTRUCTIONLINK B ON B.CONSTRUCTIONCODE = A.FLUCTUATIONCODE";

                strSQL += " LEFT JOIN CONSTRUCTIONBASEINFO C ON C.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE";

                strSQL += " , CONSTRUCTIONBASEINFO D";

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

                strSQL += " AND D.CONSTRUCTIONCODE = A.FLUCTUATIONCODE";

                strSQL += " ORDER BY D.JOINFLG ASC, C.JOINFLG ASC";

                ArrayList arList = new ArrayList();

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

                if (arList.Count == 0) return false;

                List<int> CodeList = new List<int>();

                int FCode = 0;

                int SCode = 0;

                foreach (object[] objRec in arList)

                {

                    FCode = CommonMotions.cnvInt(objRec[1]);

                    SCode = CommonMotions.cnvInt(objRec[3]);

                    if (FCode != 0) CodeList.Add(FCode);

                    if (SCode != 0) CodeList.Add(SCode);

                }

                // 工事進捗を取得する

                strSQL = "SELECT MIN(CONSTRUCTIONSTATUSFLG), MAX(CONSTRUCTIONSTATUSFLG)";

                strSQL += " FROM CONSTRUCTIONBASEINFO";

                strSQL += " WHERE CONSTRUCTIONCODE IN (";

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

                {

                    if (i != 0) strSQL += ", ";

                    strSQL += CodeList[i].ToString();

                }

                strSQL += ")";

                arList.Clear();

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

                if (arList.Count == 0) return false;

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

                int MinStat = CommonMotions.cnvInt(StatRec[0]);

                int MaxStat = CommonMotions.cnvInt(StatRec[1]);

                // 親工事進捗更新

                if (!BaseDB.UpdateFeild(ParentCode, (int)IOConstructionBaseInfo.TableColumn.ConstructionStatusFlg, MinStat, false))

                {

                    return false;

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

                    if (CurRec.CompanyType != (int)CommonDefine.CodeDataType.Person) continue;

        #region 結合工事作成処理

        /// <summary>

        /// 結合工事作成処理

        /// </summary>

        /// <returns></returns>

        public static bool MakeJoinForBudgetData(int ConstructionCode, List<int> DateCodeList)

        {

            FrmConstructionLedger frm = new FrmConstructionLedger();

            try

            {

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

                if (ConstructionCode == 0) return false;

                // 工事コードのセット

                frm.ConstructionCode = ConstructionCode;

                // 見えない画面を出す

                frm.WindowState = FormWindowState.Minimized;

                frm.Hide();

                // フォーム非表示

                frm.Visible = false;

                bool bSuccess = true;

                // データ追加処理

                frm.JoiningCodeList = DateCodeList;

                if (!frm.JoinDataLedger)

                {

                    bSuccess = false;

                    return bSuccess;

                }

                // データ保存処理

                if (!frm.SaveLedgerData)

                {

                    bSuccess = false;

                    return bSuccess;

                }

                // データ削除処理

                if (!frm.RemoveJoinLedger)

                {

                    bSuccess = false;

                    return bSuccess;

                }

                return bSuccess;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

            finally

            {

                // 画面を閉じる

                frm.Close();

                frm.Dispose(); frm = null;

            }

        }

        #endregion

        #region 結合工事疑似ロールバック処理

        /// <summary>

        /// 結合工事疑似ロールバック処理

        /// </summary>

        /// <returns></returns>

        public static bool PseudoRollBackForBudgetData(int ConstructionCode, List<int> DateCodeList)

        {

            FrmConstructionLedger frm = new FrmConstructionLedger();

            try

            {

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

                if (ConstructionCode == 0) return false;

                bool bSuccess = true;

                // 工事コードのセット

                frm.ConstructionCode = ConstructionCode;

                // データ追加処理

                frm.JoiningCodeList = DateCodeList;

                frm.SetRollBackFlg = true;

                // データ削除処理

                if (!frm.RemoveJoinLedger)

                {

                    bSuccess = false;

                    return bSuccess;

                }

                return bSuccess;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

            finally

            {

                frm.Dispose(); frm = null;

            }

        }

        #endregion

            Proceedings = 17,                   // 17:打合せ議事録入力

            DRWork = 18,                        // 18:出勤日報

            PurchaseOrderStatus = 19,           // 19:注文書発給一覧

            OrderJoin = 20,                     // 20:工事結合

            ConstructionSplit = 21,             // 21:工事分割

            //Division = 112,                   // 112:区分マスタ

                                                                                { (int)ProcessExecuteNo.Proceedings,            "打合せ議事録－入力"},

                                                                                //{ (int)ProcessExecuteNo.DailyReportList,        "出勤日報－入力"},

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

                            ProcessExecuteNo_DepartmentExpenssList(m_ProcControlPara[NowPoint]);

                            break;

                        case (int)ProcessExecuteNo.ConstructionLedgerList:              // 12:工事詳細台帳一覧

                        case (int)ProcessExecuteNo.ConstructionLedger:                  // 13:工事詳細台帳

                        case (int)ProcessExecuteNo.TAndPCosts:                          // 14:交通費及び購入品入力

                        case (int)ProcessExecuteNo.DRList:                              // 15:工事日報一覧

                        case (int)ProcessExecuteNo.DRConstruction:                      // 16:工事日報入力

                        case (int)ProcessExecuteNo.Proceedings:                         // 17:打合せ議事録入力

                        case (int)ProcessExecuteNo.DRWork:                              // 18:出勤日報入力

                        case (int)ProcessExecuteNo.PurchaseOrderStatus:                 // 19:注文書発給一覧

                            ProcessExecuteNo_PurchaseOrderStatus(m_ProcControlPara[NowPoint]);

                        case (int)ProcessExecuteNo.OrderJoin:                           // 20:工事結合

                            ProcessExecuteNo_OrderJoin(m_ProcControlPara[NowPoint]);

                        case (int)ProcessExecuteNo.ConstructionSplit:                   // 21:工事分割

                            ProcessExecuteNo_ConstructionSplit(m_ProcControlPara[NowPoint]);

                            break;

                if (CurrentPara.IntExecParameter.Count > 2) frm.OrderNo = CurrentPara.IntExecParameter[2];

                // 直接表示フラグのセット

                if (CurrentPara.BoolExecParameter.Count > 0)

                {

                    frm.DirectFlg = CurrentPara.BoolExecParameter[0];

                }

        #region 部署別台帳一覧

        /// 部署別台帳一覧

        public static void ProcessExecuteNo_DepartmentExpenssList(ProcessParameter CurrentPara)

            //　部署別台帳一覧

            FrmDepExpenssList frm = new FrmDepExpenssList();

                int ProcessNo = (int)ProcessExecuteNo.DepartmentExpenssList;

                // 起動・編集フラグ

                int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference;

                if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg))

                {

                    BackProcess();

                    return;

                }

        #region 工事詳細台帳一覧（個人指定）

        /// 工事詳細台帳一覧（個人指定）

        public static void ProcessExecuteNo_ConstrLedgerPersonList(ProcessParameter CurrentPara)

            //　工事詳細台帳一覧

            FrmLedgerStatus frm = new FrmLedgerStatus();

                int ProcessNo = (int)ProcessExecuteNo.ConstructionLedgerList;

                // 起動・編集フラグ

                int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference;

                if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg))

                {

                    BackProcess();

                    return;

                }

                // 次起動プロセスセット

                frm.ExecuteFlg = CurrentPara.IntExecParameter[0];

                // 初期選択無しフラグ

                frm.FirstStartFlg = false;

                // 初期選択年度

                frm.FirstStartPeriod = CurrentPara.IntExecParameter[1];

                // 初期選択部署コード

                frm.FirstStartDepartmentCode = CurrentPara.IntExecParameter[2];

                // 初期選択担当者コード

                frm.FirstStartPersonCode = CurrentPara.IntExecParameter[3];

        #region 注文書発給一覧

        /// 注文書発給一覧

        /// <param name="CurrentPara"></param>

        public static void ProcessExecuteNo_PurchaseOrderStatus(ProcessParameter CurrentPara)

            //　注文書発給一覧

            FrmPurchaseOrderStatus frm = new FrmPurchaseOrderStatus();

        #region 工事結合

        /// 工事結合

        /// <param name="CurrentPara"></param>

        public static void ProcessExecuteNo_OrderJoin(ProcessParameter CurrentPara)

            //　工事結合

            FrmConstructionJoin frm = new FrmConstructionJoin();

                // フォーム表示

                frm.ShowDialog();

            }

            catch (Exception ex)

            {

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

                BackProcess();

            }

            finally

            {

                frm.Dispose(); frm = null;

            }

        }

        #endregion

        #region 工事分割

        /// <summary>

        /// 工事分割

        /// </summary>

        /// <param name="CurrentPara"></param>

        public static void ProcessExecuteNo_ConstructionSplit(ProcessParameter CurrentPara)

        {

            //　工事分割

            FrmConstructionSplit frm = new FrmConstructionSplit();

            try

            {

                frm.OrderNo = CurrentPara.IntExecParameter[2];

                for (int i = 3; i < CurrentPara.IntExecParameter.Count; i++)

                {

                    frm.PurchaseOrderSeqNo.Add(CurrentPara.IntExecParameter[i]);

                }

        #region 結合工事フラグ

        /// <summary>

        /// 結合工事フラグ

        /// </summary>

        private static int m_BaseInfoJoinFlg = 0;

        #region 増減工事フラグ

        /// <summary>

        /// 増減工事フラグ

        /// </summary>

        private static int m_BaseInfoTyingFlg = 0;

        #endregion

        #region 結合親工事コード

        /// <summary>

        /// 結合親工事コード

        /// </summary>

        private static int m_SearchCode = 0;

        #endregion

        #region 結合構成工事コード

        /// <summary>

        /// 結合構成工事コード

        /// </summary>

        private static List<int> m_CodeList = new List<int>();

        #endregion

        #region 機能承認回数

        /// <summary>

        /// 機能承認回数

        /// </summary>

        private static int m_OrderNo = 1;

        #endregion

        #endregion

        #region 機能承認回数

        /// <summary>

        /// 機能承認回数

        /// </summary>

        public static int OrderNo

        {

            get { return m_OrderNo; }

            set { m_OrderNo = value; }

        }

        #endregion

        #region 増減工事・結合工事の場合は親コードを返す

        /// 増減工事・結合工事の場合は親コードを返す

        /// <param name="InputCode"></param>

        public static int GetParentConstrCode(int InputCode)

                // 工事情報取得

                string strBase = BaseDB.CreatePrimarykeyString(InputCode);

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

                // 結合工事のチェック

                if (BaseRec.JoinFlg != (int)CommonDefine.BaseInfoJoinFlg.Standard)

                {

                    // 結合工事は結合親工事番号を返す

                    int FuncCnt = 0;

                    ArrayList ParList = new ArrayList();

                    ClsChangeBaseInfoData.GetParentData(InputCode, ref ParList, ref FuncCnt);

                    // データ無はエラー

                    if (ParList.Count == 0) return InputCode;

                    object[] objRec = (object[])ParList[0];

                    return CommonMotions.cnvInt(objRec[0]);

                }

                else

                {

                    // 増減工事でない場合はそのまま工事コードを返す

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

                }

                // 増減工事の場合は親コードを検索する

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

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

                return InputCode;

        #region 結合・増減の対象リストを作成する

        /// <summary>

        /// 結合・増減の対象リストを作成する

        /// </summary>

        /// <param name="CodeList"></param>

        public static void GetTargetList(IOConstructionBaseInfo BaseDB, ref List<int> CodeList, bool ParentAdd)

        {

            try

            {

                // 親工事番号を取得する

                int ParentCode = ClsProcessExist.GetParentConstrCode(m_ConstructionCode);

                // データ無はエラー

                if (ParentCode == 0) return;

                // 対象工事の結合・増減を確認する

                string strSQL = "SELECT CONSTRUCTIONCODE, JoinFlg FROM CONSTRUCTIONBASEINFO A";

                strSQL += BaseDB.CreatePrimarykeyString(m_ConstructionCode);

                ArrayList BaseList = new ArrayList();

                if (!BaseDB.ExecuteReader(strSQL, ref BaseList)) return;

                if (BaseList.Count == 0) return;

                bool bJoinFlg = true;

                object[] objRec1 = (object[])BaseList[0];

                if (CommonMotions.cnvInt(objRec1[1]) == (int)CommonDefine.BaseInfoJoinFlg.Standard) bJoinFlg = false;

                int iCode = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("非 受 注")).Key;

                int LinkJoin = (int)CommonDefine.LinkDataType.JoinType;

                int LinkFluctuation = (int)CommonDefine.LinkDataType.FluctuationType;

                if (bJoinFlg)

                {

                    // 結合工事

                    strSQL = "SELECT A.FLUCTUATIONCODE, D.FLUCTUATIONCODE";

                    strSQL += " FROM CONSTRUCTIONLINK A";

                    strSQL += string.Format(" LEFT OUTER JOIN CONSTRUCTIONBASEINFO B ON B.CONSTRUCTIONCODE = A.FLUCTUATIONCODE AND B.CONSTRUCTIONSTATUSFLG != {0}", iCode);

                    strSQL += string.Format(" LEFT JOIN CONSTRUCTIONLINK D ON D.CONSTRUCTIONCODE = A.FLUCTUATIONCODE AND D.LINKTYPE = {0}", LinkFluctuation);

                    strSQL += string.Format(" LEFT OUTER JOIN CONSTRUCTIONBASEINFO F ON F.CONSTRUCTIONCODE = D.CONSTRUCTIONCODE AND F.CONSTRUCTIONSTATUSFLG != {0}", iCode);

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

                    strSQL += string.Format(" AND A.LINKTYPE = {0}", LinkJoin);

                    strSQL += " ORDER BY A.FLUCTUATIONCODE ASC";

                    // 親工事の追加

                    if (ParentAdd) CodeList.Add(ParentCode);

                }

                else

                {

                    // 増減工事

                    strSQL = "SELECT A.CONSTRUCTIONCODE, A.FLUCTUATIONCODE";

                    strSQL += " FROM CONSTRUCTIONLINK A";

                    strSQL += string.Format(" LEFT OUTER JOIN CONSTRUCTIONBASEINFO B ON B.CONSTRUCTIONCODE = A.FLUCTUATIONCODE AND B.CONSTRUCTIONSTATUSFLG != {0}", iCode);

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

                    strSQL += string.Format(" AND A.LINKTYPE = {0}", LinkFluctuation);

                    strSQL += " ORDER BY A.FLUCTUATIONCODE ASC";

                    // 親工事の追加

                    CodeList.Add(ParentCode);

                }