/ - Diff - 工事管理システム製品化対応 - Redmine

             /// <summary>
             /// 本体バージョン
             /// </summary>
             public static int s_SystemVersion = 17;
             public static int s_SystemVersion = 19;
             /// <summary>
             /// コピー・環境バージョン

                 CostomerRegistList = 33,            // 33:発注者登録申請一覧
                 CostomerRegist = 34,                // 34:発注者登録申請
                 SubConstrRegistList = 35,           // 35:協力会社登録申請一覧
                 SubConstrRegist = 36                // 36:協力会社登録申請
                 SubConstrRegist = 36,               // 36:協力会社登録申請
                 PriceOfBudget = 37,                 // 37:台帳状況確認画面
+            }
             #endregion
-...
                                                                                     { (int)ProcessExecuteNo.RequestSummaryList,     "請求まとめ－入力"},
                                                                                     { (int)ProcessExecuteNo.PaymentConfirmation,    "入金確認－入力"},
                                                                                     { (int)ProcessExecuteNo.RequestInput,           "請求入力－入力"},
                                                                                     { (int)ProcessExecuteNo.RequestPrint,           "請求書発行－印刷"},
                                                                                     { (int)ProcessExecuteNo.RequestPrint,           "請求書－印刷"},
                                                                                     { (int)ProcessExecuteNo.CostomerRegistList,     "発注者登録申請一覧－表示"},
                                                                                     { (int)ProcessExecuteNo.CostomerRegist,         "発注者登録申請－入力"},
                                                                                     { (int)ProcessExecuteNo.SubConstrRegistList,    "協力会社登録申請一覧－表示"},
                                                                                     { (int)ProcessExecuteNo.SubConstrRegist,        "協力会社登録申請－入力"}
                                                                                     { (int)ProcessExecuteNo.SubConstrRegist,        "協力会社登録申請－入力"},
                                                                                     { (int)ProcessExecuteNo.PriceOfBudget,          "工事台帳状態確認－表示"},
             };
             #endregion

trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsSecurityPermission.cs
696	696	{
697	697	bRet = GetExecutePermission(CommonMotions.LoginUserData.PersonCode, ExecCode, ref Editflg);
698	698	}
699		if (!bRet) Debug.Print("");
	699
700	700	return bRet;
701	701	}
702	702	catch (Exception ex)

             /// 非受注へ移す期間（受注できずに見積提出日より以下の日数を過ぎれば非受注へ移動）
             /// </summary>
             private const int s_NonOrderDay = 93;
             /// <summary>
             /// 非受注時メッセージ
             /// </summary>
             private const string s_NonOrderComment = "受注できずに見積提出日より{0}日を過ぎましたので非受注とします。";
             #endregion
             #region 変数
-...
+                                   }
+                                }
+                            }
                             if (!procflg) break;
+                        }
                         if (!procflg) break;
+                    }
-...
             private bool ChangeNonOrdersData()
+            {
                 IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();
                 IOConstructionBaseInfoDetail DetailDB = new IOConstructionBaseInfoDetail();
                 try
+                {
                     int iCode1 = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("非 受 注")).Key;
-...
                     int iCode3 = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("見積提出")).Key;
                     // 対象データが存在するかを確認する
                     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);
                     string strSQL = "SELECT A.CONSTRUCTIONCODE, B.DETAILSTRING FROM CONSTRUCTIONBASEINFO A";
                     strSQL += " LEFT JOIN CONSTRUCTIONBASEINFODETAIL B ON B.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE";
                     strSQL += string.Format(" AND B.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DetailDataNo.OrdersDecisionComment);
                     string strWHERE = " WHERE TRUNC(A.ESTIMATESSUBMITTEDDATE) != TO_DATE('0001/01/01','YYYY/MM/DD')";
                     strWHERE += string.Format(" AND TRUNC(A.ESTIMATESSUBMITTEDDATE + {0})", s_NonOrderDay);
                     strWHERE += string.Format(" < TO_DATE('{0}','YYYY/MM/DD')", DateTime.Now.ToShortDateString());
                     strWHERE += string.Format(" AND A.CONSTRUCTIONSTATUSFLG IN({0}, {1})", iCode2, iCode3);
                     strWHERE += string.Format(" AND A.ESTIMATETYPE IN ({0}, {1})", (int)CommonDefine.BaseInfoEstimateType.Normal, (int)CommonDefine.BaseInfoEstimateType.GetBudget);
                     strSQL += strWHERE;
                     ArrayList arList = new ArrayList();
                     if (!BaseDB.ExecuteReader(strSQL, ref arList))
+                    {
                         logger.ErrorFormat("工事基本情報更新エラー　非受注案件移行処理失敗：{0}：{1}", CommonMotions.GetMethodName(), strSQL);
                         logger.ErrorFormat("工事基本情報読込エラー　非受注案件移行処理失敗：{0}：{1}", CommonMotions.GetMethodName(), strSQL);
                         return false;
+                    }
                     object[] wrkcount = (object[])arList[0];
                     if (Common.CommonMotions.cnvInt(wrkcount[0]) == 0) return true;
                     // ----- 対象データが存在しなければ抜ける
                     if (arList.Count == 0) return true;
                     // 対象データが存在すれば更新する
                     // ----- 対象データが存在すれば更新する
                     BaseDB.connect(); BaseDB.beginTran();
                     DetailDB.connect(); DetailDB.beginTran();
                     // 工事基本情報データ
                     strSQL = string.Format("UPDATE CONSTRUCTIONBASEINFO SET CONSTRUCTIONSTATUSFLG = {0},", iCode1);
                     strSQL += string.Format(" NONORDERDATE = TO_DATE('{0}','YYYY/MM/DD')", DateTime.Today.ToShortDateString());
                     strSQL += " WHERE CONSTRUCTIONCODE IN";
                     strSQL += " (SELECT CONSTRUCTIONCODE 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);
                     if (!BaseDB.ExecuteNonQuery(strSQL))
                     strSQL += string.Format(" WHERE CONSTRUCTIONCODE IN (SELECT A.CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO A {0})", strWHERE);
                     if (!BaseDB.ExecuteNonQuery(strSQL, false))
+                    {
                         BaseDB.rollback();
                         logger.ErrorFormat("工事基本情報更新エラー　非受注案件移行処理失敗：{0}：{1}", CommonMotions.GetMethodName(), strSQL);
                         return false;
+                    }
                     // 工事基本情報明細データ
                     string strMsg = string.Format(s_NonOrderComment, s_NonOrderDay);
                     string strOrgMsg = string.Empty;
                     foreach (object[] objRec in arList)
+                    {
                         strOrgMsg = string.Empty;
                         strOrgMsg = CommonMotions.cnvString(objRec[1]);
                         if (strOrgMsg.Length != 0)
+                        {
                             strOrgMsg += "\n";
                             strOrgMsg += strMsg;
                             if (strOrgMsg.Length > 120) strOrgMsg = strOrgMsg.Substring(0, 120);
                             if (!DetailDB.UpdateFeild(CommonMotions.cnvInt(objRec[0]),
                                                         (int)IOConstructionBaseInfoDetail.TableColumn.DETAIL_STRING,
                                                         strOrgMsg,
                                                         false,
                                                         (int)ConstructionBaseInfoDetail.DetailDataNo.OrdersDecisionComment))
+                            {
                                 BaseDB.rollback();
                                 DetailDB.rollback();
                                 logger.ErrorFormat("工事基本情報明細更新エラー　非受注案件移行処理失敗：{0}：{1}", CommonMotions.GetMethodName(), strSQL);
                                 return false;
+                            }
+                        }
                         else
+                        {
                             if (!CreateBaseInfoDetail(DetailDB, CommonMotions.cnvInt(objRec[0]), strMsg))
+                            {
                                 BaseDB.rollback();
                                 DetailDB.rollback();
                                 logger.ErrorFormat("工事基本情報明細作成エラー　非受注案件移行処理失敗：{0}：{1}", CommonMotions.GetMethodName(), strSQL);
                                 return false;
+                            }
+                        }
+                    }
                     return true;
+                }
                 catch (Exception ex)
-...
+                }
                 finally
+                {
                     BaseDB.commit();
                     DetailDB.commit();
                     BaseDB.close(); BaseDB = null;
                     DetailDB.close(); DetailDB = null;
+                }
+            }
             #endregion
             #region 工事基本情報明細作成（受注決定申送りコメント）
             /// <summary>
             /// 工事基本情報明細作成（受注決定申送りコメント）
             /// </summary>
             /// <returns></returns>
             private bool CreateBaseInfoDetail(IOConstructionBaseInfoDetail DetailDB, int ConstrCode, string strMsg)
+            {
                 try
+                {
                     ConstructionBaseInfoDetail work = new ConstructionBaseInfoDetail();
                     work.ConstructionCode = ConstrCode;
                     work.DetailNo = (int)ConstructionBaseInfoDetail.DetailDataNo.OrdersDecisionComment;
                     work.DetailString = strMsg;
                     if (!DetailDB.InsertAction(work, false)) return false;
                     return true;
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
                     return false;
+                }
+            }
             #endregion
             #region 工事詳細台帳の給与を加算する
             /// <summary>
             /// 工事詳細台帳の給与を加算する

                     wrk.GrossProfit = double.Parse(objwrk[(int)TableColumn.GrossProfit].ToString());                   // 粗利
                     wrk.Allowance = double.Parse(objwrk[(int)TableColumn.Allowance].ToString());                       // 給与
                     wrk.NetProfit = double.Parse(objwrk[(int)TableColumn.NetProfit].ToString());                       // 純利益
                     wrk.ComplateFlg = double.Parse(objwrk[(int)TableColumn.ComplateFlg].ToString());                   // 入力完了フラグ
                     wrk.IntegrationFlg = int.Parse(objwrk[(int)TableColumn.IntegrationFlg].ToString());                // 受注金額積算フラグ
                     wrk.ComplateFlg = int.Parse(objwrk[(int)TableColumn.ComplateFlg].ToString());                       // 入力完了フラグ
                     wrk.IntegrationFlg = int.Parse(objwrk[(int)TableColumn.IntegrationFlg].ToString());                 // 受注金額積算フラグ
                     wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
                     wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());

     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 IOProceedingsDataAttend : OracleProcess
+        {
             #region 定義部
             /// <summary>
             /// log4netログを使用する
             /// </summary>
             private static readonly ILog logger = LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
             #endregion
             #region 定数
             /// <summary>
             /// データフィールド並び
             /// </summary>
             public enum TableColumn
+            {
                 /// <summary>
                 /// 工事番号
                 /// </summary>
                 ConstructionCode,
                 /// <summary>
                 /// 議事録作成日
                 /// </summary>
                 ProceedingsDataDate,
                 /// <summary>
                 /// 会議時間開始
                 /// </summary>
                 StartMeetingTime,
                 /// <summary>
                 /// データ行番号
                 /// </summary>
                 SeqNo,
                 /// <summary>
                 /// 出席者所属
                 /// </summary>
                 Department,
                 /// <summary>
                 /// 出席者氏名
                 /// </summary>
                 AttendName,
                 /// <summary>
                 /// 登録年月日
                 /// </summary>
                 EntryDate,
                 /// <summary>
                 /// 更新年月日
                 /// </summary>
                 UpdateDate,
+            }
             #endregion
             #region コンストラクタ
             /// <summary>
             /// コンストラクタ
             /// </summary>
             /// <param name="ConnectionString"></param>
             public IOProceedingsDataAttend()
                 : base(DBCommon.Instance.DBConnectString)
+            {
+            }
             #endregion
             #region SQL作成
             /// <summary>
             /// SQL作成
             /// </summary>
             private string CreateSelectSQL()
+            {
                 // SQL作成（oracleのDateTime型が変換できないのでCharに変換しておく）
                 string strcmd = "SELECT";
                 strcmd += " ConstructionCode";                                  // 工事番号
                 strcmd += " ,TO_CHAR(ProceedingsDataDate, 'YYYY/MM/DD')";       // 議事録作成日
                 strcmd += " ,StartMeetingTime";                                 // 会議時間開始
                 strcmd += " ,SeqNo";                                            // データ行番号
                 strcmd += " ,Department";                                       // 出席者所属
                 strcmd += " ,AttendName";                                       // 出席者氏名
                 strcmd += ", TO_CHAR(EntryDate, 'YYYY/MM/DD HH24:MI:ss')";      // 登録年月日
                 strcmd += ", TO_CHAR(UpdateDate, 'YYYY/MM/DD HH24:MI:ss')";     // 更新年月日
                 strcmd += " FROM ProceedingsDataAttend";
                 return strcmd;
+            }
             #endregion
             #region 複数読込み処理
             public bool SelectAction(string AddSQLString, ref List<ProceedingsDataAttend> data, bool bConnect = true)
+            {
                 //Oracle インターフェース
                 string strcmd = "";
                 ArrayList arData = new ArrayList();
                 try
+                {
                     // SQL作成
                     strcmd = CreateSelectSQL() + AddSQLString;
                     // SQL実行
                     if (!ExecuteReader(strcmd, ref arData, bConnect)) return false;
                     // データセット
                     foreach (object[] objwrk in arData)
+                    {
                         ProceedingsDataAttend work = new ProceedingsDataAttend();
                         Reader2Struct(objwrk, ref work);
                         data.Add(work);
+                    }
                     return true;
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
                     return false;
+                }
+            }
             #endregion
             #region 1件読込み処理
             public bool SelectAction(string AddSQLString, ref ProceedingsDataAttend data, bool bConnect = true)
+            {
                 //Oracle インターフェース
                 string strcmd = "";
                 ArrayList arData = new ArrayList();
                 try
+                {
                     strcmd = CreateSelectSQL() + AddSQLString;
                     // SQL実行
                     if (!ExecuteReader(strcmd, ref arData, bConnect)) return false;
                     if (arData.Count == 0) return false;
                     // データセット
                     foreach (object[] objwrk in arData)
+                    {
                         Reader2Struct(objwrk, ref data);
                         break;
+                    }
                     return true;
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
                     return false;
+                }
+            }
             #endregion
             #region 1件追加処理
             /// <summary>
             /// 担当者毎経費データ追加
             /// </summary>
             /// <param name="data">担当者毎経費データデータ</param>
             /// <returns>true：成功 false：失敗</returns>
             public bool InsertAction(ProceedingsDataAttend work, bool bConnect = true)
+            {
                 string strcmd = "";
                 try
+                {
                     strcmd = "INSERT INTO ProceedingsDataAttend";
                     strcmd += " (";
                     bool bFirst = true;
                     foreach (var gender in Enum.GetValues(typeof(TableColumn)))
+                    {
                         if (!bFirst) strcmd += " ,";
                         strcmd += gender.ToString();
                         bFirst = false;
+                    }
                     strcmd += ") VALUES (";
                     strcmd += string.Format(" {0}", work.ConstructionCode);                     // 工事番号
                     strcmd += string.Format(", TO_DATE('{0}','YYYY/MM/DD')"
                                                 , work.ProceedingsDataDate.ToShortDateString());// 議事録作成日
                     strcmd += string.Format(", {0}", work.StartMeetingTime);                    // 会議時間開始
                     strcmd += string.Format(", {0}", work.SeqNo);                               // データ行番号
                     strcmd += string.Format(",'{0}'", work.Department);                         // 出席者所属
                     strcmd += string.Format(",'{0}'", work.AttendName);                         // 出席者氏名
                     strcmd += ", TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";
                     strcmd += ", TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";
                     strcmd = strcmd + ")";
                     if (!ExecuteNonQuery(strcmd, bConnect)) return false;
                     return true;
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
                     return false;
+                }
+            }
             #endregion
             #region 複数追加処理
             public bool InsertAction(List<ProceedingsDataAttend> data, bool bConnect = true)
+            {
                 string strcmd = "";
                 try
+                {
                     foreach (ProceedingsDataAttend work in data)
+                    {
                         if (!InsertAction(work, bConnect)) return false;
+                    }
                     return true;
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
                     return false;
+                }
+            }
             #endregion
             #region 更新処理
             /// <summary>
             /// 担当者毎経費データ更新
             /// </summary>
             /// <param name="AddSQLString">更新条件SQL文字列</param>
             /// <param name="data">担当者毎経費データデータ</param>
             /// <returns>true：成功 false：失敗</returns>
             public bool UpdateAction(string AddSQLString, ProceedingsDataAttend data, bool bConnect = true)
+            {
                 string strcmd = "";
                 try
+                {
                     strcmd = "UPDATE ProceedingsDataAttend";
                     strcmd += " SET";
                     strcmd += string.Format(" ConstructionCode = {0}", data.ConstructionCode);      // 工事番号
                     strcmd += string.Format(",ProceedingsDataDate = TO_DATE('{0}','YYYY/MM/DD')"
                                             , data.ProceedingsDataDate.ToShortDateString());        // 議事録作成日
                     strcmd += string.Format(",StartMeetingTime = {0}", data.StartMeetingTime);      // 会議時間開始
                     strcmd += string.Format(",SeqNo = {0}", data.SeqNo);                            // データ行番号
                     strcmd += string.Format(",Department = '{0}'", data.Department);                // 出席者所属
                     strcmd += string.Format(",AttendName = '{0}'", data.AttendName);                // 出席者氏名
                     strcmd += ", UpdateDate = TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";
                     strcmd += AddSQLString;
                     if (!ExecuteNonQuery(strcmd, bConnect)) return false;
                     return true;
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
                     return false;
+                }
+            }
             #endregion
             #region 削除処理
             /// <summary>
             /// 担当者毎経費データ削除
             /// </summary>
             /// <param name="AddSQLString">削除条件SQL文字列</param>
             /// <param name="data">担当者毎経費データデータ</param>
             /// <returns>true：成功 false：失敗</returns>
             public bool DeleteAction(string AddSQLString, bool bConnect = true)
+            {
                 //Oracle インターフェース
                 string strcmd = "";
                 try
+                {
                     strcmd = string.Format("{0}{1}", "DELETE FROM ProceedingsDataAttend", AddSQLString);
                     if (!ExecuteNonQuery(strcmd, bConnect)) return false;
                     return true;
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
                     return false;
+                }
+            }
             #endregion
             #region データセット処理
             /// <summary>
             /// OracleDataReaderより構造体へセットする
             /// </summary>
             /// <param name="reader">OracleDataReader</param>
             /// <param name="wrk">構造体</param>
             public void Reader2Struct(object[] objwrk, ref ProceedingsDataAttend wrk)
+            {
                 try
+                {
                     // データ取得
                     wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.ConstructionCode].ToString());      // 工事番号
                     wrk.ProceedingsDataDate = DateTime.Parse(objwrk[(int)TableColumn.ProceedingsDataDate].ToString());       // 議事録作成日
                     wrk.StartMeetingTime = int.Parse(objwrk[(int)TableColumn.StartMeetingTime].ToString());      // 会議時間開始
                     wrk.SeqNo = int.Parse(objwrk[(int)TableColumn.SeqNo].ToString());                            // データ行番号
                     wrk.Department = objwrk[(int)TableColumn.Department].ToString();                             // 出席者所属
                     wrk.AttendName = objwrk[(int)TableColumn.AttendName].ToString();                             // 出席者氏名
                     wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
                     wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
+                }
                 catch (OracleException oraex)
+                {
                     logger.ErrorFormat("オラクルエラー：{0}：{1}", CommonMotions.GetMethodName(2), oraex.Message);
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(2), ex.Message);
+                }
+            }
             #endregion
             #region 検索文字列作成処理
             /// <summary>
             /// 主キー検索の文字列を返す
             /// </summary>
             /// <param name="PersonCode"></param>
             /// <param name="ActionDate"></param>
             /// <param name="DataType"></param>
             /// <param name="DataAddCount"></param>
             /// <returns></returns>
             public string CreatePrimarykeyString(int ConstructionCode, DateTime ProceedingsDataDate, int StartMeetingTime = 0, int SeqNo = 0)
+            {
                 string strWork = "";
                 try
+                {
                     strWork = string.Format(" WHERE ConstructionCode = {0}", ConstructionCode);
                     if (ProceedingsDataDate != DateTime.MinValue)
                         strWork += string.Format(" AND ProceedingsDataDate = TO_DATE('{0}','YYYY/MM/DD')", ProceedingsDataDate.ToShortDateString());
                     if (StartMeetingTime != 0)
                         strWork += string.Format(" AND StartMeetingTime = {0}", StartMeetingTime);
                     if (SeqNo != 0)
                         strWork += string.Format(" AND SeqNo = {0}", SeqNo);
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strWork);
+                }
                 return strWork;
+            }
             #endregion
+        }
+    }

             private double      m_GrossProfit = 0;                          // 粗利
             private double      m_Allowance = 0;                            // 給与
             private double      m_NetProfit = 0;                            // 純利益
             private double      m_ComplateFlg = 0;                          // 入力完了フラグ
             private int         m_ComplateFlg = 0;                          // 入力完了フラグ
             private int         m_IntegrationFlg = 0;                       // 受注金額積算フラグ
             private DateTime m_EntryDate = DateTime.Now;                    // 登録日付
-...
             /// <summary>
             /// 入力完了フラグ
             /// </summary>
             public double ComplateFlg
             public int ComplateFlg
+            {
                 get { return m_ComplateFlg; }
                 set { m_ComplateFlg = value; }

     using System;
     using System.Collections.Generic;
     using System.Linq;
     using System.Text;
     namespace ProcessManagement.DataModel
+    {
         /// <summary>
         /// 発注者打ち合わせ議事録データ（出席者）
         /// </summary>
         public class ProceedingsDataAttend
+        {
             #region メンバ変数
             /// <summary>
             /// 工事番号
             /// </summary>
             private int         m_ConstructionCode = 0;
             /// <summary>
             /// 議事録作成日
             /// </summary>
             private DateTime    m_ProceedingsDataDate = DateTime.Now;
             /// <summary>
             /// 会議時間開始
             /// </summary>
             private int         m_StartMeetingTime = 0;
             /// <summary>
             /// データ行番号
             /// </summary>
             private int         m_SeqNo = 0;
             /// <summary>
             /// 出席者所属
             /// </summary>
             private string      m_Department = string.Empty;
             /// <summary>
             /// 出席者氏名
             /// </summary>
             private string      m_AttendName = string.Empty;
             /// <summary>
             /// 登録年月日
             /// </summary>
             private DateTime    m_EntryDate = DateTime.Now;
             /// <summary>
             /// 更新年月日
             /// </summary>
             private DateTime    m_UpdateDate = DateTime.Now;
             #endregion
             #region プロパティ
             /// <summary>
             /// 工事番号
             /// </summary>
             public int ConstructionCode
+            {
                 get { return m_ConstructionCode; }
                 set { m_ConstructionCode = value; }
+            }
             /// <summary>
             /// 議事録作成日
             /// </summary>
             public DateTime ProceedingsDataDate
+            {
                 get { return m_ProceedingsDataDate; }
                 set { m_ProceedingsDataDate = value; }
+            }
             /// <summary>
             /// 会議時間開始
             /// </summary>
             public int StartMeetingTime
+            {
                 get { return m_StartMeetingTime; }
                 set { m_StartMeetingTime = value; }
+            }
             /// <summary>
             /// データ行番号
             /// </summary>
             public int SeqNo
+            {
                 get { return m_SeqNo; }
                 set { m_SeqNo = value; }
+            }
             /// <summary>
             /// 出席者所属
             /// </summary>
             public string Department
+            {
                 get { return m_Department; }
                 set { m_Department = value; }
+            }
             /// <summary>
             /// 出席者氏名
             /// </summary>
             public string AttendName
+            {
                 get { return m_AttendName; }
                 set { m_AttendName = value; }
+            }
             /// <summary>
             /// 登録年月日
             /// </summary>
             public DateTime EntryDate
+            {
                 get { return m_EntryDate; }
                 set { m_EntryDate = value; }
+            }
             /// <summary>
             /// 更新年月日
             /// </summary>
             public DateTime UpdateDate
+            {
                 get { return m_UpdateDate; }
                 set { m_UpdateDate = value; }
+            }
             #endregion
+        }
+    }

                     DateTime dtToday = GetPrevDateFieldValue(sender);
                     // ??????o????J?E???g
                     // int sepStrCnt = txtbox.Text.Length - txtbox.Text.Replace("/", "").Length;
                     if (CommonMotions.chkNumeric(txtbox.Text))
                     {   // ??????????
                         if (txtbox.Text.ToString().Length <= 4)
+                        {
                             //txtbox.Text = m_dispControl[(int)Dispcount.ConstructionYear].Text
                             txtbox.Text = dtToday.Year.ToString()
                                             + "/" + CommonMotions.cnvInt(txtbox.Text.Substring(0, 2)).ToString("00")
                                             + "/" + CommonMotions.cnvInt(txtbox.Text.Substring(2)).ToString("00");
-...
                     {   // 99/99?????
                         if (txtbox.Text.ToString().Length <= 5)
+                        {
                             //txtbox.Text = m_dispControl[(int)Dispcount.ConstructionYear].Text
                             txtbox.Text = dtToday.Year.ToString()
                                             + "/" + CommonMotions.cnvInt(txtbox.Text.Substring(0, txtbox.Text.IndexOf("/"))).ToString("00")
                                             + "/" + CommonMotions.cnvInt(txtbox.Text.Substring(txtbox.Text.IndexOf("/") + 1)).ToString("00");
-...
                     // ???N?x?`?F?b?N
                     txtbox.Text = DTNextYearChange(txtbox).ToShortDateString();
                     //txtbox.Text = DTNextYearChange(ClsCommon.cnvDate(txtbox.Text)).ToShortDateString();
                     if (!CommonMotions.chkDate(txtbox.Text.ToString())) return;
                     txtbox.Text = DateTime.Parse(txtbox.Text.ToString()).ToShortDateString();
                     ValidatedDate(txtbox);
                     m_bChengeAns = true;
+                }
                 catch (Exception ex)

                     if (m_DspCtrl[(int)DspCnt.SalesPersonCode].Text.Length != 0) iLength++;
                     if (!CommonMotions.DispFieldIndispensable(m_DspCtrl[(int)DspCnt.SalesPersonCode]))
                         iNGno = (int)DspCnt.SalesPersonCode;
                     if (m_DspCtrl[(int)DspCnt.SalesPersonCode].Text.Trim().Equals(CommonDefine.s_UndecidedString))
+                    {
                         iNGno = (int)DspCnt.SalesPersonCode;
                         // ?w?i?F??X
                         CommonMotions.chgBackColor(m_DspCtrl[(int)DspCnt.SalesPersonCode], false);
+                    }
                     // ???????
                     if (m_DspCtrl[(int)DspCnt.OrderersDivision].Text.Length != 0) iLength++;
-...
+                }
+            }
             #endregion
             #region ?_??H???????????z???????????
             /// <summary>
             /// ?_??H???????????z???????????
             /// </summary>
             /// <param name="txtbox"></param>
             private void ValidatedDate(TextBox txtbox)
+            {
                 try
+                {
                     bool bTarget = false;
                     if (txtbox.Name.Equals(m_DspCtrl[(int)DspCnt.ConstructionPeriodStart].Name)) bTarget = true;    // 48: ?_??H???J?n
                     if (txtbox.Name.Equals(m_DspCtrl[(int)DspCnt.ConstructionPeriodEnd].Name)) bTarget = true;      // 49: ?_??H??????
                     if (txtbox.Name.Equals(m_DspCtrl[(int)DspCnt.ConstructionPeriodStart2].Name)) bTarget = true;	// 62: ?_??H???J?n?i???????j
                     if (txtbox.Name.Equals(m_DspCtrl[(int)DspCnt.ConstructionPeriodEnd2].Name)) bTarget = true;		// 63: ?_??H???????i???????j
                     // ????O??????????
                     if (!bTarget) return;
                     // ?w????????
                     int Period = CommonMotions.cnvInt(m_DspCtrl[(int)DspCnt.ConstructionPeriod].Text);              //  2: ?H????
                     DateTime dtStart = DateTime.Now;
                     DateTime dtEnd = DateTime.Now;
                     int iYear = 0;
                     int month = 0;
                     int day = 0;
                     bool bPeriod = true;
                     if (CommonMotions.SystemMasterData.ConstructionNoBase == (int)CommonDefine.SystemConstructionNoBase.BusinessPeriod)
                     {   // ?c???
                         iYear = CommonMotions.PeriodCountToYear(Period);
                         bPeriod = true;
+                    }
                     CommonMotions.GetBeginningMonthDay(bPeriod, ref month, ref day);
                     dtStart = new DateTime(iYear, month, day);
                     dtEnd = dtStart.AddYears(1).AddDays(-1);     // ?I????{1?N?|1??
                     // ?{?H?????
                     DateTime dtCStart = CommonMotions.cnvDate(m_DspCtrl[(int)DspCnt.ConstructionPeriodStart].Text);     // 48: ?_??H???J?n
                     DateTime dtCStart2 = CommonMotions.cnvDate(m_DspCtrl[(int)DspCnt.ConstructionPeriodStart2].Text);   // 62: ?_??H???J?n?i???????j
                     if (dtCStart2 == DateTime.MinValue) dtCStart2 = dtCStart;
                     if (dtCStart2 < dtCStart) dtCStart = dtCStart2;
                     DateTime dtCEnd = CommonMotions.cnvDate(m_DspCtrl[(int)DspCnt.ConstructionPeriodEnd].Text);         // 49: ?_??H??????
                     DateTime dtCEnd2 = CommonMotions.cnvDate(m_DspCtrl[(int)DspCnt.ConstructionPeriodEnd2].Text);		// 63: ?_??H???????i???????j
                     if (dtCEnd2 == DateTime.MinValue) dtCEnd2 = dtCEnd;
                     if (dtCEnd < dtCEnd2) dtCEnd = dtCEnd2;
                     // ???????????O
                     if (dtCStart < dtStart)
+                    {
                         if(MessageBox.Show("?_??H?????H????\n????v???????????O???w????????\n?v??????X????????H",
                                         "?_??H?????H???`?F?b?N",
                                         MessageBoxButtons.YesNo, MessageBoxIcon.Information)==DialogResult.Yes)
+                        {
                             int NewPeriod = Period;
                             for (int i = 1; i < 10; i++)
+                            {
                                 dtStart = new DateTime((iYear - i), month, day);
                                 dtEnd = dtStart.AddYears(1).AddDays(-1);
                                 if (dtStart <= dtCStart && dtCStart <= dtEnd)
+                                {
                                     NewPeriod -= i;
                                     break;
+                                }
+                            }
                             m_DspCtrl[(int)DspCnt.ConstructionPeriod].Text = NewPeriod.ToString();
                             return;
+                        }
+                    }
                     if (dtEnd < dtCEnd)
+                    {
                         if (MessageBox.Show("?_??H??????????\n????v????????????~???w????????\n?v??????X????????H",
                                         "?_??H?????????`?F?b?N",
                                         MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
+                        {
                             int NewPeriod = Period;
                             for (int i = 1; i < 10; i++)
+                            {
                                 dtStart = new DateTime((iYear + i), month, day);
                                 dtEnd = dtStart.AddYears(1).AddDays(-1);
                                 if (dtStart <= dtCEnd && dtCEnd <= dtEnd)
+                                {
                                     NewPeriod += i;
                                     break;
+                                }
+                            }
                             m_DspCtrl[(int)DspCnt.ConstructionPeriod].Text = NewPeriod.ToString();
                             return;
+                        }
+                    }
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);
+                }
+            }
             #endregion
+        }
+    }

                                                                 "?w ?? ?? ?U ??",
                                                                 "?S??????^???z"};
             #endregion
             #region ???v???Z?X????
             /// <summary>
             /// ???v???Z?X????
             /// </summary>
             private static int s_CurrentProcessNo = (int)ClsExcute.ProcessExecuteNo.ConstructionLedgerList;
             #endregion
             #endregion
             #region ???
             /// <summary>
             /// ?t?B?[???h?l????t???O
-...
             private bool m_NextProcFlg = false;
             #endregion
             #region ????m?F???
             /// <summary>
             /// ????m?F???
             /// </summary>
             private FrmPriceOfBudget m_PriceOfBudget = null;
             #endregion
             #endregion
             #region ?v???p?e?B
             #region ?N???t???O
-...
+            {
                 try
+                {
                     // ?t?H?[????Close????????????N???[?Y????
                     TerminatingProcess();
                     if (m_CloseingProcessOff) return;
                     // ????m?F?????\???????????N???[?Y????
                     if (m_PriceOfBudget != null)
+                    {
                         m_PriceOfBudget.Dispose();
                         m_PriceOfBudget = null;
+                    }
                     // ?O?v???Z?X????
                     ClsExcute.BackProcess();
+                }
-...
             /// <param name="e"></param>
             private void btnLedgerStatus_Click(object sender, EventArgs e)
+            {
                 // ?t?H?[?????\?????????????O??\???????????
                 if (m_PriceOfBudget != null)
+                {
                     m_PriceOfBudget.Activate();
                     return;
+                }
                 // ?O??\??
                 // ???\??
                 DispPriceOfBudget();
+            }
             #endregion
             #region ????m?F???N???[?Y
             /// <summary>
             /// ????m?F????N???[?Y????????
             /// </summary>
             /// <param name="sender"></param>
             /// <param name="e"></param>
             private void FrmPriceOfBudget_FormClosed(object sender, FormClosedEventArgs e)
+            {
                 try
+                {
                     this.Activate();
                     // ?n???h???N???A
                     m_PriceOfBudget.Dispose();
                     m_PriceOfBudget = null;
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);
+                }
+            }
             #endregion
             #region ?t?H?[?????[?h
             /// <summary>
             /// ?????t?H?[?????[?h
             /// </summary>
             /// <param name="sender"></param>
             /// <param name="e"></param>
             private void FrmConstructionBaseInfoList_Load(object sender, EventArgs e)
             private void FrmLedgerStatus_Load(object sender, EventArgs e)
+            {
                 // ?R???{?{?b?N?X?Z?b?g

                 this.ShowIcon = false;
                 this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
                 this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.FrmConstructionLedgerList_FormClosing);
                 this.Load += new System.EventHandler(this.FrmConstructionBaseInfoList_Load);
                 this.Load += new System.EventHandler(this.FrmLedgerStatus_Load);
                 this.SizeChanged += new System.EventHandler(this.FrmConstructionLedgerList_SizeChanged);
                 this.KeyDown += new System.Windows.Forms.KeyEventHandler(this.FrmConstructionLedgerList_KeyDown);
                 this.groupBox1.ResumeLayout(false);

                 else
+                {
                     int Master = CommonDefine.SecurityRankList[(int)CommonDefine.SecurityRankPos.SpecialAuthority].Key;
                     if (CommonMotions.LoginUserSecurity.SecRank == Master) btnLedgerStatus.Visible = true;
                     else btnLedgerStatus.Visible = false;
                     // ??????{?^???\??
                     int editflg = 0;
                     btnLedgerStatus.Visible = ClsSecurityPermission.GetExecutePermission((int)ClsExcute.ProcessExecuteNo.PriceOfBudget, ref editflg);
+                }
+            }
             #endregion
-...
+            }
             #endregion
             #region ?I????????
             /// <summary>
             /// ?I?????T?u?t?H?[???N???[?Y
             /// </summary>
             private void TerminatingProcess()
+            {
                 try
+                {
                     // ?t?H?[????Close????????????N???[?Y????
                     for (int i = 0; i < ClsExcute.SubFormHandleList.Length; i++)
+                    {
                         PreserveSubFormHandle Handle = ClsExcute.SubFormHandleList[i];
                         // ???????N???????????O??????????
                         if (Handle.ProcessNo != s_CurrentProcessNo) continue;
                         // ??????????????
                         if (i == s_CurrentProcessNo)
+                        {
                             ClsExcute.SubFormHandleList[i].SubFormHandle = null;
                             ClsExcute.SubFormHandleList[i].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;
                             continue;
+                        }
                         // ?N?????????????????????
                         if (Handle.SubFormHandle == null) continue;
                         // ???N???[?Y
                         Handle.SubFormHandle.Close();
                         if (Handle.SubFormHandle != null) Handle.SubFormHandle.Dispose();
                         ClsExcute.SubFormHandleList[i].SubFormHandle = null;
+                    }
+                }
                 catch (System.Exception ex)
+                {
                     logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);
+                }
+            }
             #endregion
             #region ????SQL??Z?L?????e?B??????????????
             /// <summary>
             /// ????SQL??Z?L?????e?B??????????????
-...
+            {
                 try
+                {
                     // ????m?F???\??
                     m_PriceOfBudget = new FrmPriceOfBudget();
                     int ProcessNo = (int)ClsExcute.ProcessExecuteNo.PriceOfBudget;
                     // ?t?H?[??????????O???
                     FrmPriceOfBudget frm = (FrmPriceOfBudget)ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle;
                     // ?\???S?????????????????????
                     if (frm != null)
+                    {
                         frm.Activate();
                         return;
+                    }
                     // ????m?F???
                     frm = new FrmPriceOfBudget();
                     ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = s_CurrentProcessNo;
                     ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = (Form)frm;
                     // ??u???
                     m_PriceOfBudget.LocationPoint = new Point(this.Right, this.Top);
                     frm.LocationPoint = new Point(this.Right, this.Top);
                     // ?^?X?N?o?[??\???????
                     //m_PriceOfBudget.ShowInTaskbar = false;
                     // ?N???[?X?h?n???h????????????`????
                     m_PriceOfBudget.FormClosed += new FormClosedEventHandler(FrmPriceOfBudget_FormClosed);
                     m_PriceOfBudget.Show();
                     frm.FormClosed += new FormClosedEventHandler(FrmPriceOfBudget_FormClosed);
                     frm.Show();
+                }
                 catch (System.Exception ex)
+                {
-...
+            }
             #endregion
             #region ????m?F???N???[?Y
             /// <summary>
             /// ????m?F????N???[?Y????????
             /// </summary>
             /// <param name="sender"></param>
             /// <param name="e"></param>
             private void FrmPriceOfBudget_FormClosed(object sender, FormClosedEventArgs e)
+            {
                 try
+                {
                     int ProcessNo = (int)ClsExcute.ProcessExecuteNo.PriceOfBudget;
                     FrmPriceOfBudget frm = (FrmPriceOfBudget)ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle;
                     // ?n???h???N???A
                     if (ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle != null)
+                    {
                         ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle.Dispose();
                         ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = null;
                         ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;
+                    }
                     this.Activate();
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);
+                }
+            }
             #endregion
             #region ??????????O?C???S??????Z?b?g????
             /// <summary>
             /// ??????????O?C???S??????Z?b?g????

             /// 新規工事番号取得
             /// </summary>
             private bool m_NewConstruction = false;
             /// <summary>
             /// 工事基本情報
             /// </summary>
             private ConstructionBaseInfo m_BaseRec = new ConstructionBaseInfo();
             #endregion
             #region プロパティ
-...
                     // 工事基本情報取得
                     string strSQL = cbDB.CreatePrimarykeyString(m_ConstructionCode);
                     ConstructionBaseInfo cbRec = new ConstructionBaseInfo();
                     if (!cbDB.SelectAction(strSQL, ref cbRec)) return false;
                     if (!cbDB.SelectAction(strSQL, ref m_BaseRec))
+                    {
                         MessageBox.Show("工事基本情報が存在しません。", "データ存在エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     // 積算見積データ取得（見積データが無くてもコピーを行う 2016/07/19）
                     //strSQL = edDB.CreatePrimarykeyString(m_ConstructionCode);
-...
                     toolTip1.SetToolTip(m_dispControl[(int)Dispcount.ConstructionName], cbdRec.DetailString);
                     // 担当者表示
                     m_dispControl[(int)Dispcount.SalesPerson].Text = GetPersonName(cbRec.SalesPersonCode);
                     m_dispControl[(int)Dispcount.SalesPerson].Text = GetPersonName(m_BaseRec.SalesPersonCode);
                     toolTip1.SetToolTip(m_dispControl[(int)Dispcount.SalesPerson], m_dispControl[(int)Dispcount.SalesPerson].Text);
                     cmbSalesPerson.SelectedValue = cbRec.SalesPersonCode;
                     cmbSalesPerson.SelectedValue = m_BaseRec.SalesPersonCode;
                     m_dispControl[(int)Dispcount.ConstructionPerson].Text = GetPersonName(cbRec.ConstructionPersonCode);
                     m_dispControl[(int)Dispcount.ConstructionPerson].Text = GetPersonName(m_BaseRec.ConstructionPersonCode);
                     toolTip1.SetToolTip(m_dispControl[(int)Dispcount.ConstructionPerson], m_dispControl[(int)Dispcount.ConstructionPerson].Text);
                     cmbConstructionPerson.SelectedValue = cbRec.ConstructionPersonCode;
                     cmbConstructionPerson.SelectedValue = m_BaseRec.ConstructionPersonCode;
                     // 工事番号表示
                     SetConstructionCode();
-...
                         return;
+                    }
                     // 現在データを取得する
                     string strExistsData = cbDB.CreatePrimarykeyString(m_ConstructionCode);
                     ConstructionBaseInfo BaseRec = new ConstructionBaseInfo();
                     if (!cbDB.SelectAction(strExistsData, ref BaseRec)) return;
                     // ----- 見積データのみコピー・工事情報のみコピー
                     int PeriodValue = 0;
                     if (CommonMotions.SystemMasterData.ConstructionNoBase == (int)CommonDefine.SystemConstructionNoBase.BusinessPeriod)
                         PeriodValue = BaseRec.ConstructionPeriod;
                         PeriodValue = m_BaseRec.ConstructionPeriod;
                     else
                         PeriodValue = BaseRec.ConstructionYear;
                         PeriodValue = m_BaseRec.ConstructionYear;
                     // 新規工事番号の表示
                     int ConstructionCode = cbDB.CreateNewCounstructionCode(PeriodValue);
-...
                 IOEstimateDataBody DB4 = new IOEstimateDataBody();                          // 積算見積ボディ
                 IOEstimateDataDetail DB5 = new IOEstimateDataDetail();                      // 積算見積明細
                 IOConstructionProgressDate DB6 = new IOConstructionProgressDate();          // 案件進捗日付データ
                 IOConstructionLink DB7 = new IOConstructionLink();                          // 工事リンク情報
                 try
+                {
                     int iToCode = 0;
-...
                     DB4.connect(); DB4.beginTran();
                     DB5.connect(); DB5.beginTran();
                     DB6.connect(); DB6.beginTran();
                     DB7.connect(); DB7.beginTran();
                     // デフォルトは新規工事にしておく
                     m_NewConstruction = true;
-...
                             DB5.rollback();
                             return false;
+                        }
                         // 工事基本情報コピー
                         if (!RecordCopyTypeA(m_ConstructionCode, iToCode, DB1, DB2))
+                        {
                             DB1.rollback();
-...
                             return false;
+                        }
                         // 工事リンク情報作成処理
                         if(!CreateConstructionLink(iToCode,  DB7))
+                        {
                             DB1.rollback();
                             DB2.rollback();
                             DB3.rollback();
                             DB4.rollback();
                             DB5.rollback();
                             DB7.rollback();
                             return false;
+                        }
                         // 継続案件の場合は新規工事フラグを落とす
                         m_NewConstruction = false;
+                    }
-...
                             DB5.rollback();
                             return false;
+                        }
+                    }
                     // ----- 工事基本情報コピー
                     else if (radioButton3.Checked)
+                    {
                         // 工事基本情報コピー
                         if (!RecordCopyTypeA(m_ConstructionCode, iToCode, DB1, DB2))
+                        {
                             DB1.rollback();
-...
                             DB5.rollback();
                             return false;
+                        }
                         // 工事基本情報コピー
                         if (!RecordCopyTypeA(m_ConstructionCode, iToCode, DB1, DB2))
+                        {
                             DB1.rollback();
-...
                         DB4.rollback();
                         DB5.rollback();
                         DB6.rollback();
                         DB7.rollback();
                         return false;
+                    }
-...
                     DB4.commit();
                     DB5.commit();
                     DB6.commit();
                     DB7.commit();
                     return true;
+                }
-...
                     DB4.close(); DB4 = null;
                     DB5.close(); DB5 = null;
                     DB6.close(); DB6 = null;
                     DB7.close(); DB7 = null;
+                }
+            }
             #endregion
-...
                     // 工事基本情報の設定
                     string strSQL = cbDB.CreatePrimarykeyString(ToCode);
                     ConstructionBaseInfo cbRec = new ConstructionBaseInfo();
                     if (!cbDB.SelectAction(strSQL, ref cbRec, false)) return false;
                     if (!cbDB.SelectAction(strSQL, ref cbRec, false))
+                    {
                         MessageBox.Show("工事基本情報が存在しません。", "データ存在エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     // 営業期・工事年度を更新する
                     int iPeriod = 0;
-...
+                    }
                     // 更新処理
                     if (!cbDB.UpdateAction(strSQL, cbRec, false)) return false;
                     if (!cbDB.UpdateAction(strSQL, cbRec, false))
+                    {
                         MessageBox.Show("工事基本情報、更新に失敗しました。", "コピー処理エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     return true;
+                }
-...
                     // 工事基本情報明細の設定
                     string strSQL = cbidDB.CreatePrimarykeyString(ToCode, (int)ConstructionBaseInfoDetail.DetailDataNo.ConstructionName);
                     ConstructionBaseInfoDetail cbidRec = new ConstructionBaseInfoDetail();
                     if (!cbidDB.SelectAction(strSQL, ref cbidRec, false)) return false;
                     if (!cbidDB.SelectAction(strSQL, ref cbidRec, false))
+                    {
                         MessageBox.Show("工事基本情報明細が存在しません。", "データ存在エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     // 工事名を更新する
                     if (cbidRec.DetailString.Length < s_ConstructionNameLength - 2)
-...
+                    }
                     // 更新処理
                     if (!cbidDB.UpdateAction(strSQL, cbidRec, false)) return false;
                     if (!cbidDB.UpdateAction(strSQL, cbidRec, false))
+                    {
                         MessageBox.Show("工事基本情報明細、更新に失敗しました。", "コピー処理エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     return true;
+                }
-...
                     DB1.DeleteAction(strSQL, false);
                     DB2.DeleteAction(strSQL, false);
                     if (!DB1.RecordCopyAction(FromCode, ToCode, false)) return false;
                     if (!DB2.RecordCopyAction(FromCode, ToCode, false)) return false;
                     if (!DB1.RecordCopyAction(FromCode, ToCode, false))
+                    {
                         MessageBox.Show("工事基本情報、作成に失敗しました。", "コピー処理エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     if (!DB2.RecordCopyAction(FromCode, ToCode, false))
+                    {
                         MessageBox.Show("工事基本情報明細、作成に失敗しました。", "コピー処理エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     return true;
+                }
-...
                     DB2.DeleteAction(strSQL, false);
                     DB3.DeleteAction(strSQL, false);
                     if (!DB1.RecordCopyAction(FromCode, ToCode, false)) return false;
                     if (!DB2.RecordCopyAction(FromCode, ToCode, false)) return false;
                     if (!DB3.RecordCopyAction(FromCode, ToCode, false)) return false;
                     if (!DB1.RecordCopyAction(FromCode, ToCode, false))
+                    {
                         MessageBox.Show("積算見積書データ、作成に失敗しました。", "コピー処理エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     if (!DB2.RecordCopyAction(FromCode, ToCode, false))
+                    {
                         MessageBox.Show("積算見積書ページデータ、作成に失敗しました。", "コピー処理エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     if (!DB3.RecordCopyAction(FromCode, ToCode, false))
+                    {
                         MessageBox.Show("積算見積書明細データ、作成に失敗しました。", "コピー処理エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     return true;
+                }
                 catch (Exception ex)
-...
+                }
+            }
             #endregion
             #region 工事リンク情報作成処理
             /// <summary>
             /// 工事リンク情報作成処理
             /// </summary>
             /// <returns></returns>
             private bool CreateConstructionLink(int ToCode, IOConstructionLink DB7)
+            {
                 try
+                {
                     string strSQL = DB7.CreatePrimarykeyString(m_ConstructionCode, ToCode);
                     DB7.DeleteAction(strSQL, false);
                     // 増減工事の子データ以外はリンク情報を作成しない
                     if (m_BaseRec.TyingFlg != (int)CommonDefine.BaseInfoTyingFlg.Tying) return true;
                     ConstructionLink LinkRec = new ConstructionLink();
                     LinkRec.ConstructionCode = m_ConstructionCode;
                     LinkRec.FluctuationCode = ToCode;
                     LinkRec.LinkType = 0;
                     if (!DB7.InsertAction(LinkRec, false))
+                    {
                         MessageBox.Show("工事リンク情報、作成に失敗しました。", "コピー処理エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);
                         return false;
+                    }
                     return true;
+                }
                 catch (System.Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
                     return false;
+                }
+            }
             #endregion
+        }
+    }

     using ProcessManagement.DB.Core;
     using ProcessManagement.Forms.CustomControls;
     using ProcessManagement.Forms.ControlsAction;
     using ProcessManagement.Forms.SubForms;
     //*---------------------------- ??????o?????? ----------------------------*
     //  2016/09/23  Ver1.0.0.0      Create Source
     //
-...
             /// </summary>
             private bool m_CloseingProcessOff = false;
             #endregion
             #region ?O???b?h?J?????T?C?Y
             /// <summary>
             /// ?O???b?h?J?????T?C?Y
-...
             private int m_GridWidthSize = 0;
             #endregion

プロジェクト

全般

プロフィール

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

リビジョン 89