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

     -- ???????f?[?^
     DROP TABLE IF EXISTS billingdata_OLD;
     CREATE TABLE billingdata_OLD As Select * from billingdata;
     drop table if exists billingdata cascade;
     create table billingdata (
       COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'
       , TARGETDATE decimal(6,0) default '0' not null comment '???N??'
       , PAYMENTKIND decimal(1,0) default '0' not null comment '?x????'
       , SEQNO decimal(3,0) default '0' not null comment '?A??'
       , BILLPRICE decimal(10,0) comment '???????z'
       , ENTRYDATE datetime comment '?o?^?N????'
       , UPDATEDATE datetime comment '?X?V?N????'
       , constraint billingdata_PKC primary key (COMPANYCODE,TARGETDATE,PAYMENTKIND,SEQNO)
     ) comment '???????f?[?^' ;
     Insert INTO billingdata
     SELECT
       COMPANYCODE
       , TARGETDATE
       , 0
       , SEQNO
       , BILLPRICE
       , ENTRYDATE
       , UPDATEDATE
     FROM billingdata_OLD
+    ;
     commit;
     -- ??????????f?[?^
     DROP TABLE IF EXISTS billingdatadetail_OLD;
     CREATE TABLE billingdatadetail_OLD As Select * from billingdatadetail;
     drop table if exists billingdatadetail cascade;
     create table billingdatadetail (
       COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'
       , TARGETDATE decimal(6,0) default '0' not null comment '???N??'
       , PAYMENTKIND decimal(1,0) default '0' not null comment '?x????'
       , SEQNO decimal(3,0) default '0' not null comment '?A??'
       , LINECOUNT decimal(3,0) default '0' not null comment '?s???'
       , CONSTRUCTIONCODE decimal(10,0) comment '?H?????'
       , CONSTRUCTIONROWCNT decimal(3,0) default '0' not null comment '?s???'
       , CONSTRUCTIONCOLCNT decimal(3,0) default '0' not null comment '????'
       , FIELDNAME varchar(120) comment '????'
       , BILLPRICE decimal(10,0) comment '???????z'
       , HIGHWPRICE decimal(10,0) comment '??????'
       , HARDWPRICE decimal(10,0) comment '??????'
       , INDSWASTETAX decimal(10,0) comment '?Y?p??'
       , NOTE varchar(120) comment '???l'
       , ENTRYDATE datetime comment '?o?^?N????'
       , UPDATEDATE datetime comment '?X?V?N????'
       , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,PAYMENTKIND,SEQNO,LINECOUNT)
     ) comment '??????????f?[?^' ;
     Insert INTO billingdatadetail
     SELECT
       COMPANYCODE
       , TARGETDATE
       , 0
       , SEQNO
       , LINECOUNT
       , CONSTRUCTIONCODE
       , CONSTRUCTIONROWCNT
       , CONSTRUCTIONCOLCNT
       , FIELDNAME
       , BILLPRICE
       , HIGHWPRICE
       , HARDWPRICE
       , INDSWASTETAX
       , NOTE
       , ENTRYDATE
       , UPDATEDATE
     FROM billingdatadetail_OLD
+    ;
     commit;

     -- ?H??????????f?[?^
     drop table if exists PeriodAvoidance cascade;
     create table PeriodAvoidance (
       ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
       , ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O'
       , FieldNo decimal(2,0) not null comment '?`?F?b?N???t?B?[???h???'
       , EntryDate datetime not null comment '?o?^???t'
       , UpdateDate datetime not null comment '?X?V???t'
       , constraint PeriodAvoidance_PKC primary key (ConstructionCode,ConstructionStatusFlg,FieldNo)
     ) comment '?H??????????f?[?^' ;
     create index PeriodAvoidance_Index1
       on PeriodAvoidance(ConstructionCode);
     create index PeriodAvoidance_Index2
       on PeriodAvoidance(ConstructionStatusFlg);
     create index PeriodAvoidance_Index3
       on PeriodAvoidance(FieldNo);

     -- ??????????f?[?^
     DROP TABLE IF EXISTS purchaseorderdetail_OLD;
     CREATE TABLE purchaseorderdetail_OLD As Select * from purchaseorderdetail;
     drop table if exists purchaseorderdetail cascade;
     create table purchaseorderdetail (
       ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
       , SeqNo decimal(3,0) unsigned not null comment '???????}??'
       , GroupCount decimal(1,0) not null comment '?O???[?v???'
       , LineCount decimal(3,0) unsigned not null comment '?s???'
       , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
       , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
       , FirstString varchar(120) comment '?H??E?i??'
       , SecondString varchar(120) comment '???e????'
       , UnitCount decimal(8,2) not null comment '????'
       , UnitName varchar(30) comment '?P??'
       , UnitPrice decimal(10,0) not null comment '?P??'
       , OrdersLinePrice decimal(12,0) comment '???z'
       , SourceCode decimal(10,0) unsigned not null comment '?\?Z?????H?????'
       , SourceLineCnt decimal(3,0) unsigned not null comment '?????????????s???'
       , DataTypeFlag decimal(1,0) unsigned not null comment '?f?[?^?^?C?v?t???O'
       , EntryDate datetime not null comment '?o?^???t'
       , UpdateDate datetime not null comment '?X?V???t'
       , constraint purchaseorderdetail_PKC primary key (ConstructionCode,SeqNo,GroupCount,LineCount)
     ) comment '??????????f?[?^' ;
     create index POrderDetail_Index1
       on purchaseorderdetail(SourceCode);
     Insert INTO purchaseorderdetail
     SELECT
       ConstructionCode
       , SeqNo
       , GroupCount
       , LineCount
       , ComponentCode
       , ItemCode
       , FirstString
       , SecondString
       , UnitCount
       , UnitName
       , UnitPrice
       , OrdersLinePrice
       , SourceCode
       , SourceLineCnt
       , 0
       , EntryDate
       , UpdateDate
     FROM purchaseorderdetail_OLD
+    ;
     update purchaseorderdetail set DataTypeFlag = 1 where FirstString like '%?@??%';
     commit;

     -- ?H??????????f?[?^
     DROP TABLE IF EXISTS constructionledgerdetail_OLD;
     CREATE TABLE constructionledgerdetail_OLD As Select * from constructionledgerdetail;
     drop table if exists constructionledgerdetail cascade;
     create table constructionledgerdetail (
       ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
       , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'
       , LineCount decimal(4,0) unsigned not null comment '?s???'
       , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
       , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
       , FirstString varchar(120) comment '???????'
       , SecondString varchar(120) comment '?H?????e'
       , CompanyType decimal(1,0) not null comment '??????R?[?h?^?C?v'
       , CompanyCode decimal(8,0) not null comment '??????R?[?h'
       , CompanyName varchar(120) comment '?????????'
       , EstimatePrice decimal(12,0) not null comment '?\?Z?i????j???z'
       , ExecutionAmount decimal(12,0) not null comment '???s???z'
       , AmountConfigRate decimal(5,2) not null comment '???z?\????'
       , PaymentBurden decimal(12,0) not null comment '?x????U?z'
       , FixDataFlg decimal(1,0) not null comment '???f?[?^?t???O'
       , IndependentFlg decimal(1,0) not null comment '????f?[?^?t???O'
       , FluctuationFlg decimal(1,0) not null comment '?????f?[?^?t???O'
       , SalaryFlg decimal(1,0) not null comment '???^?U????'
       , SalaryDays decimal(4,0) not null comment '???^?U??????'
       , OperatingFlg decimal(1,0) not null comment '?S?????t???O'
       , SourceCode decimal(10,0) unsigned not null comment '???H?????'
       , JoinTitleFlg decimal(1,0) not null comment '?H??????^?C?g??'
       , SalaryOnRegist decimal(12,0) not null comment '?o?^?????z???^'
       , PurchaseOrderFlg decimal(2,0) not null comment '?????????s?t???O'
       , DetailCount decimal(4,0) unsigned not null comment '??????'
       , EntryDate datetime not null comment '?o?^???t'
       , UpdateDate datetime not null comment '?X?V???t'
       , constraint constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
     ) comment '?H??????????f?[?^' ;
     create index LedgerDetail_Index01
       on constructionledgerdetail(ConstructionCode);
     create index LedgerDetail_Index02
       on constructionledgerdetail(GroupCount);
     create index LedgerDetail_Index03
       on constructionledgerdetail(LineCount);
     create index LedgerDetail_Index04
       on constructionledgerdetail(SourceCode);
     create index LedgerDetail_Index05
       on constructionledgerdetail(DetailCount);
     Insert INTO constructionledgerdetail
     SELECT
       ConstructionCode
       , GroupCount
       , LineCount
       , ComponentCode
       , ItemCode
       , FirstString
       , SecondString
       , CompanyType
       , CompanyCode
       , CompanyName
       , EstimatePrice
       , ExecutionAmount
       , AmountConfigRate
       , PaymentBurden
       , FixDataFlg
       , IndependentFlg
       , FluctuationFlg
       , SalaryFlg
       , SalaryDays
       , OperatingFlg
       , SourceCode
       , JoinTitleFlg
       , SalaryOnRegist
       , PurchaseOrderFlg
       , 0
       , EntryDate
       , UpdateDate
     FROM constructionledgerdetail_OLD
+    ;
     ALTER TABLE purchaseorderdetail
     CHANGE SourceCode SourceCode decimal(10,0) unsigned not null
     COMMENT '???H?????';
     ALTER TABLE purchaseorderdetail
     CHANGE SourceLineCnt SourceDetailCnt decimal(4,0) unsigned not null
     COMMENT '????????';
     ALTER TABLE constructionledgerexcute
     CHANGE LineCount LineCount decimal(4,0) unsigned not null
     comment '?s???';
     Truncate table paymentapprovalinfo;
     Truncate table paymentdatadetail;
     Truncate table billingdata;
     Truncate table billingdatadetail;
     Truncate table billingpaymentsummary;
     commit;

     -- Project Name : noname
     -- Date/Time    : 2017/10/05 15:29:38
     -- Date/Time    : 2017/12/12 10:48:17
     -- Author       : Horiuchi
     -- RDBMS Type   : MySQL
     -- Application  : A5:SQL Mk-2
-...
     create table constructionledgerdetail (
       ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
       , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'
       , LineCount decimal(3,0) unsigned not null comment '?s???'
       , LineCount decimal(4,0) unsigned not null comment '?s???'
       , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
       , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
       , FirstString varchar(120) comment '???????'
-...
       , JoinTitleFlg decimal(1,0) not null comment '?H??????^?C?g??'
       , SalaryOnRegist decimal(12,0) not null comment '?o?^?????z???^'
       , PurchaseOrderFlg decimal(2,0) not null comment '?????????s?t???O'
       , DetailCount decimal(4,0) unsigned not null comment '??????'
       , EntryDate datetime not null comment '?o?^???t'
       , UpdateDate datetime not null comment '?X?V???t'
       , constraint constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
-...
       on constructionledgerdetail(GroupCount);
     create index LedgerDetail_Index03
       on constructionledgerdetail(LineCount);
     create index LedgerDetail_Index04
       on constructionledgerdetail(SourceCode);
     create index LedgerDetail_Index05
       on constructionledgerdetail(DetailCount);
     -- ?H?????????s?f?[?^
     drop table if exists constructionledgerexcute cascade;
     create table constructionledgerexcute (
       ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
       , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'
       , LineCount decimal(3,0) unsigned not null comment '?s???'
       , LineCount decimal(4,0) unsigned not null comment '?s???'
       , ColumnCount decimal(3,0) not null comment '????'
       , PaymentAmount decimal(12,0) not null comment '?x?????z'
       , TargetMonth date not null comment '???N??'
-...
       , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
     ) comment '?x??????f?[?^' ;
     -- ?H??????????f?[?^
     drop table if exists periodavoidance cascade;
     create table periodavoidance (
       ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
       , ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O'
       , FieldNo decimal(2,0) not null comment '?`?F?b?N???t?B?[???h???'
       , EntryDate datetime not null comment '?o?^???t'
       , UpdateDate datetime not null comment '?X?V???t'
       , constraint periodavoidance_PKC primary key (ConstructionCode,ConstructionStatusFlg,FieldNo)
     ) comment '?H??????????f?[?^' ;
     create index PeriodAvoidance_Index1
       on periodavoidance(ConstructionCode);
     create index PeriodAvoidance_Index2
       on periodavoidance(ConstructionStatusFlg);
     create index PeriodAvoidance_Index3
       on periodavoidance(FieldNo);
     -- ?S??????F?f?[?^
     drop table if exists personapproval cascade;
-...
       , constraint proceedingsdataattend_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)
     ) comment '?????????????c???^?f?[?^?i?o???j' ;
     -- ?????????????c???^?f?[?^?i?o???j
     drop table if exists proceedingsdataattendee cascade;
     create table proceedingsdataattendee (
       PersonCode decimal(8,0) not null comment '????R?[?h'
       , ProceedingsDataDate date not null comment '?c???^????'
       , ConstructionCode int(11) not null comment '?H?????'
       , SeqNo smallint(6) not null comment '?f?[?^?s???'
       , Department varchar(100) comment '?o??????'
       , AttendeeName varchar(100) comment '?o??????'
       , EntryDate datetime not null comment '?o?^?N????'
       , UpdateDate datetime not null comment '?X?V?N????'
       , constraint proceedingsdataattendee_PKC primary key (PersonCode,ProceedingsDataDate,ConstructionCode,SeqNo)
     ) comment '?????????????c???^?f?[?^?i?o???j' ;
     -- ?????????????c???^?f?[?^?i????j
     drop table if exists proceedingsdatadetail cascade;
-...
       , UnitName varchar(30) comment '?P??'
       , UnitPrice decimal(10,0) not null comment '?P??'
       , OrdersLinePrice decimal(12,0) comment '???z'
       , SourceCode decimal(10,0) unsigned not null comment '?\?Z?????H?????'
       , SourceLineCnt decimal(3,0) unsigned not null comment '?????????????s???'
       , SourceCode decimal(10,0) unsigned not null comment '???H?????'
       , SourceDetailCnt decimal(4,0) unsigned not null comment '????????'
       , DataTypeFlag decimal(1,0) unsigned not null comment '?f?[?^?^?C?v?t???O'
       , EntryDate datetime not null comment '?o?^???t'
       , UpdateDate datetime not null comment '?X?V???t'
       , constraint purchaseorderdetail_PKC primary key (ConstructionCode,SeqNo,GroupCount,LineCount)

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

                     for (int i = (int)CostDataOfPerson.DataNoDef.Transport; i <= (int)CostDataOfPerson.DataNoDef.DisposalCost; i++)
+                    {
                         string strSQL = "SELECT CONSTRUCTIONCODE, DATATYPE, DATE_FORMAT(ACTIONDATE,'%Y/%m'), SUM(ENTRYPRICE) FROM COSTDATAOFPERSON";
                         strSQL += String.Format(" WHERE DATE_FORMAT(ACTIONDATE,'%Y/%m') = '{0}'", TargetMonth);
                         strSQL += String.Format(" AND DATATYPE = {0}", i);
                         strSQL += " AND CONSTRUCTIONCODE IN (SELECT A1.CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO A1";
                         strSQL += string.Format(" WHERE (A1.SALESPERSONCODE = {0} OR A1.CONSTRUCTIONPERSONCODE = {0} OR A1.CONSTRSUBPERSONCODE = {0} OR A1.CONSTRUCTIONINSTRUCTOR = {0}))", PersonCode);
                         strSQL += " GROUP BY CONSTRUCTIONCODE, DATATYPE, DATE_FORMAT(ACTIONDATE,'%Y/%m')";
                         strSQL += " ORDER BY CONSTRUCTIONCODE, DATATYPE";
                         StringBuilder strSQL = new StringBuilder();
                         strSQL.Append("SELECT CONSTRUCTIONCODE, DATATYPE, DATE_FORMAT(ACTIONDATE,'%Y/%m'), SUM(ENTRYPRICE) FROM COSTDATAOFPERSON");
                         strSQL.AppendFormat(" WHERE DATE_FORMAT(ACTIONDATE,'%Y/%m') = '{0}'", TargetMonth);
                         strSQL.AppendFormat(" AND DATATYPE = {0}", i);
                         strSQL.Append(" AND CONSTRUCTIONCODE IN (SELECT A1.CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO A1");
                         strSQL.AppendFormat(" WHERE (A1.SALESPERSONCODE = {0} OR A1.CONSTRUCTIONPERSONCODE = {0} OR A1.CONSTRSUBPERSONCODE = {0} OR A1.CONSTRUCTIONINSTRUCTOR = {0}))", PersonCode);
                         strSQL.Append(" GROUP BY CONSTRUCTIONCODE, DATATYPE, DATE_FORMAT(ACTIONDATE,'%Y/%m')");
                         strSQL.Append(" ORDER BY CONSTRUCTIONCODE, DATATYPE");
                         ArrayList arList = new ArrayList();
                         if (!CostDB.ExecuteReader(strSQL, ref arList, false)) continue;
                         if (!CostDB.ExecuteReader(strSQL.ToString(), ref arList, false)) continue;
                         if (arList.Count == 0) continue;
                         foreach (object[] wrkrec in arList)
-...
             /// </summary>
             /// <param name="EntryList"></param>
             /// <returns></returns>
             public static bool EntryExecuteData(List<ConstructionLedgerExcute> EntryList)
             public static bool EntryExecuteData(IOConstructionLedgerDetail DetailDB
                                                 , IOConstructionLedgerExcute ExecDB
                                                 , ArrayList EntryList)
+            {
                 IOConstructionLedgerExcute ExecDB = new IOConstructionLedgerExcute();
                 try
+                {
                     ExecDB.connect(); ExecDB.beginTran();
                     StringBuilder strSQL = new StringBuilder();
                     bool bExists = true;
                     bool bRet = true;
                     List<int> ConstrCodeList = new List<int>();
                     List<ConstructionLedgerExcute> ExecList = new List<ConstructionLedgerExcute>();
                     int nLineCount = 0;
                     ArrayList ExecList = new ArrayList();
                     foreach (ConstructionLedgerExcute CurRec in EntryList)
                     foreach (object[] CurData in EntryList)
+                    {
                         strSQL.Clear();
                         ConstructionLedgerDetail DetailRec = (ConstructionLedgerDetail)CurData[0];
                         ConstructionLedgerExcute ExcuteRec = (ConstructionLedgerExcute)CurData[1];
                         // 工事番号が0の場合は処理しない
                         if (CurRec.ConstructionCode == 0) continue;
                         if (ExcuteRec.ConstructionCode == 0) continue;
                         // グループ番号が0の場合は処理しない
                         if (CurRec.GroupCount == 0) continue;
                         // 行・列番号が0の場合は処理しない
                         if (CurRec.LineCount == 0 && CurRec.ColumnCount == 0) continue;
                         if (ExcuteRec.GroupCount == 0) continue;
                         // キー作成
                         strSQL.AppendFormat(ExecDB.CreatePrimarykeyString(CurRec.ConstructionCode,
                                                                             CurRec.GroupCount,
                                                                             CurRec.LineCount,
                                                                             CurRec.ColumnCount));
                         // SQL作成
                         strSQL.Clear();
                         strSQL.Append("Select");
                         strSQL.Append(" A.ConstructionCode");
                         strSQL.Append(", A.GroupCount");
                         strSQL.Append(", A.LineCount");
                         strSQL.Append(", B.ColumnCount");
                         strSQL.Append(", B.TargetMonth");
                         strSQL.Append(" From");
                         strSQL.Append(" constructionledgerdetail AS A");
                         strSQL.Append(" Left Join constructionledgerexcute AS B");
                         strSQL.Append("    On B.ConstructionCode = A.ConstructionCode");
                         strSQL.Append("    And B.GroupCount = A.GroupCount");
                         strSQL.Append("    And B.LineCount = A.LineCount");
                         strSQL.AppendFormat("    And B.ColumnCount = {0}", ExcuteRec.ColumnCount);
                         strSQL.AppendFormat(" Where A.ConstructionCode = {0}", ExcuteRec.ConstructionCode);
                         strSQL.AppendFormat(" And A.GroupCount = {0}", ExcuteRec.GroupCount);
                         strSQL.AppendFormat(" And A.DetailCount = {0}", DetailRec.DetailCount);
                         ExecList.Clear();
                         if (!ExecDB.SelectAction(strSQL.ToString(), ref ExecList, false)) continue;
                         if (!ExecDB.ExecuteReader(strSQL.ToString(), ref ExecList, false)) continue;
                         if (ExcuteRec.ConstructionCode == 2017028801) { Debug.WriteLine(""); }
                         bExists = false;
                         object[] objRec = (object[])ExecList[0];
                         // 明細データが存在する場合
                         if (ExecList.Count > 0)
                             bExists = true;
                         else
                             bExists = false;
+                        {
                             // 行番号をセットする
                             ExcuteRec.LineCount = CommonMotions.cnvInt(objRec[2]);
                             // 実行データも存在する場合
                             if (CommonMotions.cnvInt(objRec[3]) != 0)
+                            {
                                 bExists = true;
+                            }
+                        }
                         if (bExists)
                         {   // データ存在時は支払金額更新
                             if(!ExecDB.UpdateFeild(CurRec.ConstructionCode,
                                                 CurRec.GroupCount,
                                                 CurRec.LineCount,
                                                 CurRec.ColumnCount,
                             if (!ExecDB.UpdateFeild(ExcuteRec.ConstructionCode,
                                                 ExcuteRec.GroupCount,
                                                 ExcuteRec.LineCount,
                                                 ExcuteRec.ColumnCount,
                                                 (int)IOConstructionLedgerExcute.TableColumn.PaymentAmount,
                                                 CurRec.PaymentAmount,
                                                 ExcuteRec.PaymentAmount,
                                                 false))
+                            {
                                 bRet = false;
-...
+                        }
                         else
+                        {
                             // 行番号が設定されていない場合は新規に取得する
                             if (CurRec.LineCount == 0)
                             // キー項目取得条件作成
                             strSQL.Clear();
                             strSQL.Append(DetailDB.CreatePrimarykeyString(ExcuteRec.ConstructionCode, ExcuteRec.GroupCount));
                             strSQL.AppendFormat(" And DetailCount = {0}", DetailRec.DetailCount);
                             // データがない場合は新規行番号を取得する
                             ExcuteRec.LineCount = DetailDB.SelectMaxLineCount(strSQL.ToString(), false);
                             DetailRec.LineCount = ExcuteRec.LineCount;
                             // 明細データも実行データも存在しない
                             if (ExecList.Count < 1)
+                            {
                                 nLineCount = 0;
                                 if (GetNewLineNo(ExecDB, CurRec, ref nLineCount))
                                 // データがない場合は新規明細番号を取得する
                                 DetailRec.DetailCount = DetailDB.SelectMaxDetailCount(strSQL.ToString(), false);
                                 // 明細データ新規作成
                                 if (!DetailDB.InsertAction(DetailRec, false))
+                                {
                                     bRet = false;
                                     break;
+                                }
                                 CurRec.LineCount = nLineCount;
+                            }
                             // 新規作成
                             if (!ExecDB.InsertAction(CurRec, false))
                             // 実行データ新規作成
                             if (!ExecDB.InsertAction(ExcuteRec, false))
+                            {
                                 bRet = false;
                                 break;
-...
                         foreach (int CurCode in ConstrCodeList)
+                        {
                             // 既に追加済みかを探す
                             if (CurCode == CurRec.ConstructionCode)
                             if (CurCode == ExcuteRec.ConstructionCode)
+                            {
                                 bAddFlg = false;
                                 break;
-...
+                        }
                         if (bAddFlg)
                         {   // 更新対象リストへ追加
                             ConstrCodeList.Add(CurRec.ConstructionCode);
                             ConstrCodeList.Add(ExcuteRec.ConstructionCode);
+                        }
+                    }
                     // ループ後エラーがあれば処理終了
                     if (!bRet)
                     // ループ後エラーが無ければ再計算処理
                     if (bRet)
+                    {
                         ExecDB.rollback();
                         return bRet;
                         // 台帳再計算
                         if (!LedgerRecalculate(ExecDB, ConstrCodeList))
+                        {
                             bRet = false;
+                        }
+                    }
                     // 台帳再計算
                     if (!LedgerRecalculate(ExecDB, ConstrCodeList))
+                    {
                         bRet = false;
                         ExecDB.rollback();
+                    }
                     return bRet;
+                }
                 catch (System.Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
                     ExecDB.rollback();
                     return false;
+                }
                 finally
+                {
                     ExecDB.commit();
                     ExecDB.close(); ExecDB = null;
+                }
+            }
             #endregion
             #region 工事台帳より新規の行番号を取得する
             /// <summary>
             /// 工事台帳より新規の行番号を取得する
             /// </summary>
             private static bool GetNewLineNo(IOConstructionLedgerExcute ExecDB, ConstructionLedgerExcute CurRec, ref int nLineCount)
+            {
                 try
+                {
                     StringBuilder strSQL = new StringBuilder();
                     ArrayList CountData = new ArrayList();
                     // 行番号が0の場合は施工費の最大行番号で新規データ作成
                     strSQL.Clear();
                     strSQL.Append("SELECT MAX(LINECOUNT) FROM CONSTRUCTIONLEDGERDETAIL");
                     strSQL.AppendFormat(" WHERE CONSTRUCTIONCODE = {0}", CurRec.ConstructionCode);
                     strSQL.AppendFormat(" AND GROUPCOUNT = {0}", (int)FrmConstructionLedger.DataGroup.ConstructionCosts);
                     strSQL.AppendFormat(" AND FLUCTUATIONFLG = {0}", (int)ConstructionLedgerDetail.FlucFlgDef.Normal);
                     CountData.Clear();
                     if (!ExecDB.ExecuteReader(strSQL.ToString(), ref CountData, false)) return false;
                     object[] objRec = (object[])CountData[0];
                     nLineCount = CommonMotions.cnvInt(objRec[0]) + 1;
                     // ----- 取得行以下を1行下げる
                     // 工事詳細台帳明細データ
                     strSQL.Clear();
                     strSQL.Append("UPDATE CONSTRUCTIONLEDGERDETAIL SET LineCount = (LineCount + 1)");
                     strSQL.AppendFormat(" WHERE CONSTRUCTIONCODE = {0}", CurRec.ConstructionCode);
                     strSQL.AppendFormat(" AND LineCount >= {0}", nLineCount);
                     if (!ExecDB.ExecuteNonQuery(strSQL.ToString(), false)) return false;
                     // 工事詳細台帳実行データ
                     strSQL.Clear();
                     strSQL.Append("UPDATE CONSTRUCTIONLEDGEREXCUTE SET LineCount = (LineCount + 1)");
                     strSQL.AppendFormat(" WHERE CONSTRUCTIONCODE = {0}", CurRec.ConstructionCode);
                     strSQL.AppendFormat(" AND LineCount >= {0}", nLineCount);
                     if (!ExecDB.ExecuteNonQuery(strSQL.ToString(), false)) return false;
                     return true;
+                }
                 catch (System.Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
                     return false;
+                }
+            }
             #endregion
             // ↑↑ ** ----- インターフェース ----- **
+        }
+    }

                 MaterialKind = 127,                 // 127:資材種類マスタ
                 MaterialItem = 128,                 // 128:資材品目マスタ
                 SalesConfirm = 129,                 // 129:売上確認
                 BankBusinessDay = 130,              // 130:銀行営業日マスタ
+            }
             #endregion
-...
                                                                                     { (int)MaintenanceExecuteNo.MaterialKind,               "資材種類登録"},               // 127
                                                                                     { (int)MaintenanceExecuteNo.MaterialItem,               "資材品目登録"},               // 128
                                                                                     { (int)MaintenanceExecuteNo.SalesConfirm,               "売上順一覧"},                 // 129
                                                                                     { (int)MaintenanceExecuteNo.BankBusinessDay,            "銀行営業日登録"},             // 130
                                                                                     };
             #endregion
-...
                             case (int)MaintenanceExecuteNo.SalesConfirm:                        // 129:売上確認
                                 MaintenanceExecuteNo_SalesConfirm(m_ProcControlPara[NowPoint]);
                                 break;
                             case (int)MaintenanceExecuteNo.BankBusinessDay:                     // 130:銀行営業日
                                 MaintenanceExecuteNo_BBD(m_ProcControlPara[NowPoint]);
                                 break;
                             #endregion
-...
+            }
             #endregion
             #region 銀行営業日マスタ
             /// <summary>
             /// 銀行営業日マスタ
             /// </summary>
             public static void MaintenanceExecuteNo_BBD(ProcessParameter CurrentPara)
+            {
                 // 銀行営業日マスタ
                 FrmBBD frm = new FrmBBD();
                 try
+                {
                     // 起動・編集フラグ
                     int ProcessNo = (int)MaintenanceExecuteNo.BankBusinessDay;
                     int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference;
                     if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg))
+                    {
                         BackProcess();
                         return;
+                    }
                     if (EditFlg == (int)CommonDefine.ProcessDataEdit.Reference) frm.EditLock = true;
                     frm.ShowDialog();
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
                     BackProcess();
+                }
                 finally
+                {
                     frm.Dispose(); frm = null;
+                }
+            }
             #endregion
             #endregion
             #region サブフォーム
             #region 掲示板メッセージ入力
             /// <summary>

                     foreach (BankBusinessDayMaster work in data)
+                    {
                         strcmd.Clear();
                         strcmd.Append("INSERT INTO BankBusinessDayMaster");
                         strcmd.Append(" VALUES (");
-...
                 StringBuilder strcmd = new StringBuilder();
                 try
+                {
                     strcmd.Append("Update BankBusinessDayMaster Set DeleteFlg = 1");
                     strcmd.Append(", UpdateDate = NOW()");
                     strcmd.Append("Delete From BankBusinessDayMaster");
                     strcmd.Append(AddSQLString);
                     if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingData.cs
113	113
114	114	foreach (BillingData work in data)
115	115	{
	116	strcmd.Clear();
116	117	strcmd.Append("INSERT INTO BillingData");
117	118
118	119	strcmd.Append(" VALUES (");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingDataDetail.cs
137	137
138	138	foreach (BillingDataDetail work in data)
139	139	{
	140	strcmd.Clear();
140	141	strcmd.Append("INSERT INTO BillingDataDetail");
141	142
142	143	strcmd.Append("(");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOBillingPaymentSummary.cs
135	135
136	136	foreach (BillingPaymentSummary work in data)
137	137	{
	138	strcmd.Clear();
138	139	strcmd.Append("INSERT INTO BillingPaymentSummary");
139	140
140	141	strcmd.Append(" VALUES (");

                 JoinTitleFlg,           // 工事名称タイトル
                 SalaryOnRegist,         // 登録時月額給与
                 PurchaseOrderFlg,       // 注文書発行フラグ
                 DetailCount,            // 明細番号
                 EntryDate,
                 UpdateDate,
-...
                 strcmd.Append(", JoinTitleFlg");             // 工事名称タイトル
                 strcmd.Append(", SalaryOnRegist");           // 登録時月額給与
                 strcmd.Append(", PurchaseOrderFlg");         // 注文書発行フラグ
                 strcmd.Append(", DetailCount");              // 明細番号
                 strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
                 strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
-...
                     strcmd.AppendFormat(", {0}", work.JoinTitleFlg);            // 工事名称タイトル
                     strcmd.AppendFormat(", {0}", work.SalaryOnRegist);          // 登録時月額給与
                     strcmd.AppendFormat(", {0}", work.PurchaseOrderFlg);        // 注文書発行フラグ
                     strcmd.AppendFormat(", {0}", work.DetailCount);             // 明細番号
                     strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
                     strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
-...
                         strcmd.AppendFormat(", {0}", work.JoinTitleFlg);            // 工事名称タイトル
                         strcmd.AppendFormat(", {0}", work.SalaryOnRegist);          // 登録時月額給与
                         strcmd.AppendFormat(", {0}", work.PurchaseOrderFlg);        // 注文書発行フラグ
                         strcmd.AppendFormat(", {0}", work.DetailCount);             // 明細番号
                         strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
                         strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
-...
                     strcmd.AppendFormat(", JoinTitleFlg = {0}", data.JoinTitleFlg);                 // 工事名称タイトルフラグ
                     strcmd.AppendFormat(", SalaryOnRegist = {0}", data.SalaryOnRegist);             // 登録時月額給与
                     strcmd.AppendFormat(", PurchaseOrderFlg = {0}", data.PurchaseOrderFlg);         // 注文書発行フラグ
                     strcmd.AppendFormat(", DetailCount = {0}", data.DetailCount);                   // 明細番号
                     strcmd.Append(", UpdateDate = NOW()");
                     strcmd.Append(AddSQLString);
-...
                     wrk.JoinTitleFlg = int.Parse(objwrk[(int)TableColumn.JoinTitleFlg].ToString());                  // 工事名称タイトルフラグ
                     wrk.SalaryOnRegist = CommonMotions.cnvDouble(objwrk[(int)TableColumn.SalaryOnRegist]);           // 登録時月額給与
                     wrk.PurchaseOrderFlg = int.Parse(objwrk[(int)TableColumn.PurchaseOrderFlg].ToString());          // 注文書発行フラグ
                     wrk.DetailCount = int.Parse(objwrk[(int)TableColumn.DetailCount].ToString());                    // 明細番号
                     wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
                     wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
-...
                         case (int)TableColumn.PurchaseOrderFlg:      // 注文書発行フラグ
                             strcmd.AppendFormat(" PurchaseOrderFlg = {0}", ((int)value).ToString());
                             break;
                         case (int)TableColumn.DetailCount:          // 明細番号
                             strcmd.AppendFormat(" DetailCount = {0}", ((int)value).ToString());
                             break;
                         default:
                             break;
-...
             /// <param name="OutsourcingFlg"></param>
             /// <param name="LineCount"></param>
             /// <returns></returns>
             public string CreatePrimarykeyString(int ConstructionCode, int GroupCount = 0, int LineCount = 0)
             public string CreatePrimarykeyString(int ConstructionCode, int GroupCount = 0, int LineCount = 0, string strArias = "")
+            {
                 StringBuilder strWork = new StringBuilder();
                 try
+                {
                     strWork.AppendFormat(" Where ConstructionCode = {0}", ConstructionCode);
                     strWork.AppendFormat(" Where {0}ConstructionCode = {1}", strArias, ConstructionCode);
                     if (GroupCount != 0)
                         strWork.AppendFormat(" And GroupCount = {0}", GroupCount);
                         strWork.AppendFormat(" And {0}GroupCount = {1}", strArias, GroupCount);
                     if (LineCount != 0)
                         strWork.AppendFormat(" And LineCount = {0}", LineCount);
                         strWork.AppendFormat(" And {0}LineCount = {1}", strArias, LineCount);
                     return strWork.ToString();
+                }
-...
                 return iRet;
+            }
             #endregion
             #region 明細番号の最大値を取得
             /// <summary>
             /// 明細の最大値を取得する
             /// </summary>
             /// <param name="AddSQLString"></param>
             /// <param name="bConnect"></param>
             /// <returns></returns>
             public int SelectMaxDetailCount(string AddSQLString, bool bConnect = true)
+            {
                 // インターフェース
                 StringBuilder strcmd = new StringBuilder();
                 ArrayList arData = new ArrayList();
                 int iRet = 0;
                 try
+                {
                     // SQL作成
                     strcmd.Append("SELECT IFNULL(MAX(DetailCount), 0) FROM ConstructionLedgerDetail");
                     strcmd.Append(AddSQLString);
                     // SQL実行
                     if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return iRet;
                     // データセット
                     foreach (object[] objwrk in arData)
+                    {
                         if (objwrk[0].ToString().Equals("null"))
                             iRet = 0;
                         else
                             iRet = int.Parse(objwrk[0].ToString());
+                    }
+                }
                 catch (Exception ex)
+                {
                     logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
+                }
                 return iRet;
+            }
             #endregion
+        }
+    }

             /// 1項目の更新を行う
             /// </summary>
             /// <returns></returns>
             public bool UpdateFeild(int ConstructionCode, int FeildNo, object value, bool bConnect = true)
             public bool UpdateFeild(string strWhere, int FeildNo, object value, bool bConnect = true)
+            {
                 StringBuilder strcmd = new StringBuilder();
                 try
-...
+                    }
                     strcmd.Append(", UpdateDate = NOW()");
                     strcmd.Append(CreatePrimarykeyString(ConstructionCode));
                     strcmd.Append(strWhere);
                     if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionMaterialInfo.cs
122	122
123	123	foreach (ConstructionMaterialInfo work in data)
124	124	{
	125	strcmd.Clear();
125	126	strcmd.Append("INSERT INTO ConstructionMaterialInfo");
126	127
127	128	strcmd.Append(" VALUES (");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODeadLineMaster.cs
119	119
120	120	foreach (DeadLineMaster work in data)
121	121	{
	122	strcmd.Clear();
122	123	strcmd.Append("INSERT INTO DeadLineMaster");
123	124
124	125	strcmd.Append(" VALUES (");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMCategoryName.cs
120	120
121	121	foreach (CategoryNameMaster work in data)
122	122	{
	123	strcmd.Clear();
123	124	strcmd.Append("INSERT INTO CategoryNameMaster");
124	125
125	126	strcmd.Append(" VALUES (");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMExpenses.cs
179	179
180	180	foreach (ExpensesMaster work in data)
181	181	{
	182	strcmd.Clear();
182	183	strcmd.Append("INSERT INTO ExpensesMaster");
183	184
184	185	strcmd.Append(" VALUES (");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialInfo.cs
112	112
113	113	foreach (MaterialInfo work in data)
114	114	{
	115	strcmd.Clear();
115	116	strcmd.Append("INSERT INTO MaterialInfo");
116	117
117	118	strcmd.Append(" VALUES (");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialItem.cs
120	120
121	121	foreach (MaterialItemMaster work in data)
122	122	{
	123	strcmd.Clear();
123	124	strcmd.Append("INSERT INTO MaterialItemMaster");
124	125
125	126	strcmd.Append(" VALUES (");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialRecordInfo.cs
123	123
124	124	foreach (MaterialRecordInfo work in data)
125	125	{
	126	strcmd.Clear();
126	127	strcmd.Append("INSERT INTO MaterialRecordInfo");
127	128
128	129	strcmd.Append(" VALUES (");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMaterialTypes.cs
111	111
112	112	foreach (MaterialKindMaster work in data)
113	113	{
	114	strcmd.Clear();
114	115	strcmd.Append("INSERT INTO MaterialKindMaster");
115	116
116	117	strcmd.Append(" VALUES (");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPaymentApprovalInfo.cs
201	201
202	202	foreach (PaymentApprovalInfo work in data)
203	203	{
	204	strcmd.Clear();
204	205	strcmd.Append("INSERT INTO PaymentApprovalInfo");
205	206
206	207	strcmd.Append(" VALUES (");

branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOPaymentDataDetail.cs
143	143
144	144	foreach (PaymentDataDetail work in data)
145	145	{
	146	strcmd.Clear();
146	147	strcmd.Append("INSERT INTO PaymentDataDetail");
147	148
148	149	strcmd.Append(" VALUES (");

                 UnitName,		        // 単位
                 UnitPrice,		        // 単価
                 OrdersLinePrice,		// 金額
                 SourceCode,             // 予算作成時工事番号
                 SourceLineCnt,	        // 注文書作成時台帳行番号
                 SourceCode,             // 台帳工事番号
                 SourceDetailCnt,	    // 台帳明細番号
                 DataTypeFlag,           // 明細行データタイプフラグ
                 EntryDate,
-...
                 strcmd.Append(", UnitName");		        // 単位
                 strcmd.Append(", UnitPrice");		        // 単価
                 strcmd.Append(", OrdersLinePrice");		    // 金額
                 strcmd.Append(", SourceCode");              // 予算作成時工事番号
                 strcmd.Append(", SourceLineCnt");	        // 注文書作成時台帳行番号
                 strcmd.Append(", SourceCode");              // 台帳工事番号
                 strcmd.Append(", SourceDetailCnt");	        // 台帳明細番号
                 strcmd.Append(", DataTypeFlag");            // 明細行データタイプフラグ
                 strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
-...
                     strcmd.AppendFormat(",'{0}'", work.UnitName);		        // 単位
                     strcmd.AppendFormat(", {0}", work.UnitPrice);		        // 単価
                     strcmd.AppendFormat(", {0}", work.OrdersLinePrice);         // 金額
                     strcmd.AppendFormat(", {0}", work.SourceCode);              // 予算作成時工事番号
                     strcmd.AppendFormat(", {0}", work.SourceLineCnt);	        // 注文書作成時台帳行番号
                     strcmd.AppendFormat(", {0}", work.SourceCode);              // 台帳工事番号
                     strcmd.AppendFormat(", {0}", work.SourceDetailCnt);	        // 台帳明細番号
                     strcmd.AppendFormat(", {0}", work.DataTypeFlag);            // 明細行データタイプフラグ
-...
                         strcmd.AppendFormat(",'{0}'", work.UnitName);		        // 単位
                         strcmd.AppendFormat(", {0}", work.UnitPrice);		        // 単価
                         strcmd.AppendFormat(", {0}", work.OrdersLinePrice);         // 金額
                         strcmd.AppendFormat(", {0}", work.SourceCode);              // 予算作成時工事番号
                         strcmd.AppendFormat(", {0}", work.SourceLineCnt);	        // 注文書作成時台帳行番号
                         strcmd.AppendFormat(", {0}", work.SourceCode);              // 台帳工事番号
                         strcmd.AppendFormat(", {0}", work.SourceDetailCnt);	        // 台帳明細番号
                         strcmd.AppendFormat(", {0}", work.DataTypeFlag);            // 明細行データタイプフラグ
                         strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
-...
                     strcmd.AppendFormat(", UnitName = '{0}'", data.UnitName);		                // 単位
                     strcmd.AppendFormat(", UnitPrice = {0}", data.UnitPrice);		                // 単価
                     strcmd.AppendFormat(", OrdersLinePrice = {0}", data.OrdersLinePrice);		    // 金額
                     strcmd.AppendFormat(", SourceCode = {0}", data.SourceCode);                     // 予算作成時工事番号
                     strcmd.AppendFormat(", SourceLineCnt = {0}", data.SourceLineCnt);	            // 注文書作成時台帳行番号
                     strcmd.AppendFormat(", SourceCode = {0}", data.SourceCode);                     // 台帳工事番号
                     strcmd.AppendFormat(", SourceDetailCnt = {0}", data.SourceDetailCnt);	        // 台帳明細番号
                     strcmd.AppendFormat(", DataTypeFlag = {0}", data.DataTypeFlag);                 // 明細行データタイプフラグ
                     strcmd.Append(", UpdateDate = NOW()");
-...
             /// 1項目の更新を行う
             /// </summary>
             /// <returns></returns>
             public bool UpdateFeild(int ConstructionCode, int FeildNo, object value, bool bConnect = true)
             public bool UpdateFeild(string strWhere, int FeildNo, object value, bool bConnect = true)
+            {
                 StringBuilder strcmd = new StringBuilder();
                 try
-...
                         case (int)TableColumn.OrdersLinePrice:	// 金額
                             strcmd.AppendFormat(" OrdersLinePrice = {0}", ((double)value).ToString());
                             break;
                         case (int)TableColumn.SourceCode:       // 予算作成時工事番号
                         case (int)TableColumn.SourceCode:       // 台帳工事番号
                             strcmd.AppendFormat(" SourceCode = {0}", ((int)value).ToString());
                             break;
                         case (int)TableColumn.SourceLineCnt:	// 注文書作成時台帳行番号
                             strcmd.AppendFormat(" SourceLineCnt = {0}", ((int)value).ToString());
                         case (int)TableColumn.SourceDetailCnt:	// 台帳明細番号
                             strcmd.AppendFormat(" SourceDetailCnt = {0}", ((int)value).ToString());
                             break;
                         case (int)TableColumn.DataTypeFlag:     // 明細行データタイプフラグ
                             strcmd.AppendFormat(" DataTypeFlag = {0}", ((int)value).ToString());
-...
+                    }
                     strcmd.Append(", UpdateDate = NOW()");
                     strcmd.Append(CreatePrimarykeyString(ConstructionCode));
                     strcmd.Append(strWhere);
                     if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
-...
                     wrk.UnitName = objwrk[(int)TableColumn.UnitName].ToString();		                            // 単位
                     wrk.UnitPrice = CommonMotions.cnvDouble(objwrk[(int)TableColumn.UnitPrice]);		            // 単価
                     wrk.OrdersLinePrice = CommonMotions.cnvDouble(objwrk[(int)TableColumn.OrdersLinePrice]);		// 金額
                     wrk.SourceCode = int.Parse(objwrk[(int)TableColumn.SourceCode].ToString());                     // 予算作成時工事番号
                     wrk.SourceLineCnt = int.Parse(objwrk[(int)TableColumn.SourceLineCnt].ToString());	            // 注文書作成時台帳行番号
                     wrk.SourceCode = int.Parse(objwrk[(int)TableColumn.SourceCode].ToString());                     // 台帳工事番号
                     wrk.SourceDetailCnt = int.Parse(objwrk[(int)TableColumn.SourceDetailCnt].ToString());	        // 台帳明細番号
                     wrk.DataTypeFlag = int.Parse(objwrk[(int)TableColumn.DataTypeFlag].ToString());                 // 明細行データタイプフラグ
-...
             /// <param name="OutsourcingFlg"></param>
             /// <param name="LineCount"></param>
             /// <returns></returns>
             public string CreatePrimarykeyString(int ConstructionCode, int SeqNo = 0, int GroupCount = 0, int LineCount = 0, string strArias = "")
             public string CreatePrimarykeyString(int ConstructionCode, int SeqNo = 0, int GroupCount = -1, int LineCount = 0, string strArias = "")
+            {
                 StringBuilder strWork = new StringBuilder();
                 try
-...
                     strWork.AppendFormat(" Where {0}ConstructionCode = {1}", strArias, ConstructionCode);
                     if (SeqNo != 0)
                         strWork.AppendFormat(" And {0}SEQNO = {1}", strArias, SeqNo);
                     if (GroupCount != 0)
                     if (GroupCount != -1)
                         strWork.AppendFormat(" And {0}GROUPCOUNT = {1}", strArias, GroupCount);
                     if (LineCount != 0)
                         strWork.AppendFormat(" And {0}LineCount = {1}", strArias, LineCount);

         public class BankBusinessDayMaster
+        {
             #region メンバ変数
             private int m_YearMonth = 0;       // 年月
             private int m_BankBusinessDay = 0;         // 銀行営業日
             private string m_Note = "";         // 備考
             private int m_DeleteFlg = 0;        // 削除フラグ
             private DateTime m_EntryDate = DateTime.Now;    // 登録日付
             private DateTime m_UpdateDate = DateTime.Now;   // 更新日付
             private int         m_YearMonth = 0;                // 年月
             private int         m_BankBusinessDay = 0;          // 銀行営業日
             private string      m_Note = "";                    // 備考
             private int         m_DeleteFlg = 0;                // 削除フラグ
             private DateTime    m_EntryDate = DateTime.Now;     // 登録日付
             private DateTime    m_UpdateDate = DateTime.Now;    // 更新日付
             #endregion
             #region コンストラクタ

             private int     m_JoinTitleFlg = 0;                 // 工事名称タイトル
             private double  m_SalaryOnRegist = 0;               // 登録時月額給与
             private int     m_PurchaseOrderFlg = 0;             // 注文書発行フラグ
             private int     m_DetailCount = 0;                  // 明細番号
             private DateTime m_EntryDate = DateTime.Now;        // 登録日付
             private DateTime m_UpdateDate = DateTime.Now;       // 更新日付
-...
                 get { return m_PurchaseOrderFlg; }
                 set { m_PurchaseOrderFlg = value; }
+            }
             /// <summary>
             /// 明細番号
             /// </summary>
             public int DetailCount
+            {
                 get { return m_DetailCount; }
                 set { m_DetailCount = value; }
+            }
             /// <summary>
             /// 登録日付

             private string  m_UnitName = string.Empty;	        // 単位
             private double  m_UnitPrice = 0;	                // 単価
             private double  m_OrdersLinePrice = 0;	            // 金額
             private double  m_SourceCode = 0;                   // 予算作成時工事番号
             private int     m_SourceLineCnt = 0;                // 注文書作成時台帳行番号
             private long    m_SourceCode = 0;                   // 台帳工事番号
             private int     m_SourceDetailCnt = 0;              // 台帳明細番号
             private int     m_DataTypeFlag = 0;                 // 明細行データタイプフラグ
-...
                 set { m_OrdersLinePrice = value; }
+            }
             /// <summary>
             /// 予算作成時工事番号
             /// 台帳工事番号
             /// </summary>
             public double SourceCode
             public long SourceCode
+            {
                 get { return m_SourceCode; }
                 set { m_SourceCode = value; }
+            }
             /// <summary>
             /// 注文書作成時台帳行番号
             /// 台帳明細番号
             /// </summary>
             public int SourceLineCnt
             public int SourceDetailCnt
+            {
                 get { return m_SourceLineCnt; }
                 set { m_SourceLineCnt = value; }
                 get { return m_SourceDetailCnt; }
                 set { m_SourceDetailCnt = value; }
+            }
             /// <summary>

                     strSQL.Append(" Left Join processapprovaldetail AS A3");
                     strSQL.Append("    On A3.ConstructionCode = A2.ConstructionCode");
                     strSQL.AppendFormat("    And A3.ApprovalCode = {0}", (int)ClsExcute.ApprovalListNo.PurchaseOrderEntryApproval);
                     strSQL.Append("    And A3.LinkCode = A2.SeqNo");
                     strSQL.Append("          And A3.LinkCode = A2.SeqNo");
                     strSQL.Append(" Left Join processapproval AS A4");
                     strSQL.Append("    On A4.ConstructionCode = A3.ConstructionCode");
                     strSQL.Append("    And A4.ApprovalCode = A3.ApprovalCode");
-...
                     strSQL.AppendFormat(" WHERE A1.CONSTRUCTIONCODE = {0}", ParentCode);
                     strSQL.AppendFormat("  And A1.SOURCECODE = {0}", SourceCode);
                     strSQL.AppendFormat("  AND A1.GROUPCOUNT = {0}", (int)FrmConstructionLedger.DataGroup.ConstructionCosts);
                     strSQL.Append("  AND A1.COMPANYCODE > 0");
                     strSQL.AppendFormat("  And A1.PurchaseOrderFlg <> {0}",(int)ConstructionLedgerDetail.PurOrderFlgDef.NotMakingData);
                     strSQL.Append("        AND A1.COMPANYCODE > 0");
                     strSQL.AppendFormat("  And (A1.PurchaseOrderFlg > {0}", (int)ConstructionLedgerDetail.PurOrderFlgDef.ChangeOld);
                     strSQL.AppendFormat("  And A1.PurchaseOrderFlg <> {0})", (int)ConstructionLedgerDetail.PurOrderFlgDef.NotMakingData);
                     strSQL.AppendFormat("  And ((ConstrType.PublicFlg != {0}", (int)ConstructionTypeMaster.ConstructionTypeDef.Community);
                     strSQL.AppendFormat("    And A1.EXECUTIONAMOUNT >= {0})", CommonDefine.s_PrintOutPrice);
-...
                     ArrayList arList = new ArrayList();
                     if (!OrderDB.ExecuteReader(strSQL.ToString(), ref arList)) return false;
                     if (arList.Count == 0) return false;
                     if (arList.Count == 0) return true;
                     bool bRet = true;
                     foreach (object[] objRec in arList)
+                    {

                         return false;
+                    }
                     LinkDB.commit();
                     BaseDB.commit();
                     DetailDB.commit();
                     PDateDB.commit();
                     // ???N???v???Z?X?Z?b?g
                     int NowPoint = ClsExcute.NextProcess((int)ClsExcute.ProcessExecuteNo.EstimateInput);
                     // ?I???H??????Z?b?g
-...
+                }
                 finally
+                {
                     LinkDB.commit();
                     BaseDB.commit();
                     DetailDB.commit();
                     PDateDB.commit();
                     LinkDB.close(); LinkDB = null;
                     BaseDB.close(); BaseDB = null;
                     DetailDB.close(); DetailDB = null;
-...
+            }
             #endregion
             #region ???z?????f?[?^?????????
             #region ?????H???f?[?^?????????
             /// <summary>
             /// ???z?????f?[?^?????????
             /// ?????H???f?[?^?????????
             /// </summary>
             /// <param name="Code"></param>
             /// <param name="DB1"></param>
-...
+            {
                 try
+                {
                     // ???z????????????????
                     // ?????H??????????????
                     StringBuilder strSQL = new StringBuilder();
                     strSQL.AppendFormat("SELECT COUNT(*) FROM CONSTRUCTIONBASEINFO A WHERE A.CONSTRUCTIONSTATUSFLG != {0}",
                                                             CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?? ?? ??")).Key);
-...
+            }
             #endregion
             #region ???z???????F?H????{???????
             #region ?????H?????F?H????{???????
             /// <summary>
             /// ???z???????F?H????{???????
             /// ?????H?????F?H????{???????
             /// </summary>
             /// <param name="cbRec"></param>
             private bool InitSetBaseInfo(int ToCode, IOConstructionBaseInfo cbDB)
+            {
                 try
+                {
                     // ?H????{??????
                     // ?R?s?[???H????{??????
                     StringBuilder strSQL = new StringBuilder();
                     strSQL.Append(cbDB.CreatePrimarykeyString(ToCode));
                     ConstructionBaseInfo cbRec = new ConstructionBaseInfo();
                     if (!cbDB.SelectAction(strSQL.ToString(), ref cbRec, false)) return false;
                     // ?R?s?[?????e?H???????
                     if (ToCode != m_ConstructionCode)
+                    {
                         StringBuilder strGetOrgSQL = new StringBuilder();
                         strGetOrgSQL.Append(cbDB.CreatePrimarykeyString(m_ConstructionCode));
                         ConstructionBaseInfo OrgRec = new ConstructionBaseInfo();
                         if (!cbDB.SelectAction(strGetOrgSQL.ToString(), ref OrgRec, false)) return false;
                         // ?????_??H?????????Z?b?g????
                         cbRec.ConstructionPeriodEnd2 = OrgRec.ConstructionPeriodEnd2;
+                    }
                     cbRec.TyingFlg = (int)ConstructionBaseInfo.TyingFlgDef.Tying;                          // ?R?t???t???O
                     cbRec.ConstructionStatusFlg = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("??????")).Key;  // ?H???i?????
-...
                     cbRec.OrdersDecisionPriceInTax = 0;                                                 // ??????????z
                     cbRec.TransferConstructionDate = DateTime.MinValue;                                 // ?H??????
                     //cbRec.ConstructionPeriodStart = DateTime.MinValue;                                  // ?_??H???J?n
                     //cbRec.ConstructionPeriodEnd = DateTime.MinValue;                                    // ?_??H??????
                     //cbRec.ConstructionPeriodStart2 = DateTime.MinValue;                                 // ?_??H???J?n?i???????j
                     //cbRec.ConstructionPeriodEnd2 = DateTime.MinValue;                                   // ?_??H???????i???????j
                     if (cbRec.ConstructionPeriodEnd2 != DateTime.MinValue)                               // ?????_??H?????????????_??H?????????X
                         cbRec.ConstructionPeriodEnd = cbRec.ConstructionPeriodEnd2;                     // ?_??H??????
                     cbRec.ConstructionPeriodStart2 = DateTime.MinValue;                                 // ?_??H???J?n?i???????j
                     cbRec.ConstructionPeriodEnd2 = DateTime.MinValue;                                   // ?_??H???????i???????j
                     //cbRec.StartDate = DateTime.MinValue;	                                            // ?H???J?n??
                     //cbRec.EndDate = DateTime.MinValue;                                                  // ?H???I????
                     cbRec.PurchaseOrderMailingDate = DateTime.MinValue;                                 // ???????X????

                     CreateProcessContextMenu(m_SubForm);
                     // *-----* ????????{?^????? *-----*
                     // ?\????u????
                     if (m_SubForm)
+                    {
                         this.StartPosition = FormStartPosition.CenterParent;
                         this.Top += CommonDefine.s_DefalutShiftValue;
                         this.Left += CommonDefine.s_DefalutShiftValue;
+                    }
                     // ?????t?H?[?J?X
                     this.ActiveControl = m_DspCtrl[(int)DspCnt.ConstructionPeriod];

                         SeeModeLock();
+                    }
                     // ?\????u????
                     if (m_SubForm)
+                    {
                         this.StartPosition = FormStartPosition.CenterParent;
                         this.Top += CommonDefine.s_DefalutShiftValue;
                         this.Left += CommonDefine.s_DefalutShiftValue;
+                    }
                     // ??X?t???OOFF
                     m_bChengeAns = false;
                     m_bInitFlg = false;

                     // 給与コンテンツセット
                     Content = string.Format(CommonDefine.s_SalaryCostMonthlyFormat, CalcBetweenTimes.ToString("#,0"), CommonDefine.InstructorMonthryCost.ToString("#,0"));
                     // 差分日付
                     int dDiffDays = 0;
                     // ----- 増減工事のこの場合は期間が同じかのチェックを行う
                     if (m_ConstructionBaseInfo.TyingFlg == (int)ConstructionBaseInfo.TyingFlgDef.Tying)
+                    {
                         // ----- 増減工事の場合は期間が同じかのチェックを行う
                         // 親の期間を取得する
                         DateTime StDate = m_ParentBaseInfo.ConstructionPeriodStart2;
                         DateTime EdDate = m_ParentBaseInfo.ConstructionPeriodEnd2;
-...
                         int MyMonths = DateTimeUtil.GetElapsedMonths(m_ConstructionBaseInfo.ConstructionPeriodStart
                                                                     , m_ConstructionBaseInfo.ConstructionPeriodEnd);
                         // 期間が同じ場合は処理しない
                         if (StDate == m_ConstructionBaseInfo.ConstructionPeriodStart && EdDate == m_ConstructionBaseInfo.ConstructionPeriodEnd)
                         if (StDate.Date == m_ConstructionBaseInfo.ConstructionPeriodStart.Date
                             && EdDate.Date == m_ConstructionBaseInfo.ConstructionPeriodEnd.Date)
+                        {
                             CostsValue = 0;
                             Content = string.Empty;
-...
+                        }
                         else
+                        {
                             // 差分日付を取得する
                             dDiffDays = CalcDifferenceDate(m_ConstructionBaseInfo.ConstructionPeriodStart,

プロジェクト

全般

プロフィール

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

リビジョン 302