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

using System;

using System.Collections.Generic;

using System.Collections;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using log4net;

using ProcessManagement.OracleDB.Oracle;

using ProcessManagement.OracleDB.Core;

using ProcessManagement.OracleDB.IOAccess;

using ProcessManagement.DB.MySql;

using ProcessManagement.DB.Core;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

using ProcessManagement.Common;

namespace DataConert

{

    partial class FrmDataConvert

    {

        #region スレッド使用定義

        //コントロールの値を変更するためのデリゲート

        private delegate void SetProgressValueDelegate(string strMsg);

        //バックグラウンド処理が終わった時にコントロールの値を変更するためのデリゲート

        private delegate void ThreadCompletedDelegate();

        //処理がキャンセルされた時にコントロールの値を変更するためのデリゲート

        private delegate void ThreadCanceledDelegate();

        //別処理をするためのスレッド

        private System.Threading.Thread workerThread;

        //デリゲートの作成

        SetProgressValueDelegate m_progressDlg = null;

        ThreadCompletedDelegate m_completeDlg = null;

        ThreadCanceledDelegate m_canceledDlg = null;

        #endregion

        private DateTime m_dtStart = DateTime.Now;

        #region 変換メイン

        /// <summary>

        /// 変換メイン

        /// </summary>

        private void MainProc()

        {

            try

            {

                btnStart.Visible = false;

                btnEnd.Visible = false;

                //印刷を別スレッドで実行する

                workerThread = new System.Threading.Thread(new System.Threading.ThreadStart(ConvertProcess));

                workerThread.IsBackground = true;

                workerThread.Start();

                listBox1.Items.Clear();

                m_dtStart = DateTime.Now;

                string strStartMsg = string.Format(" ---------- 処理開始 ---------- {0}", m_dtStart.ToLongTimeString());

                listBox1.Items.Add(strStartMsg);

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 変換処理

        /// <summary>

        /// 変換処理

        /// </summary>

        private void ConvertProcess()

        {

            try

            {

                //デリゲートの作成

                m_progressDlg = new SetProgressValueDelegate(SetProgressValue);

                m_completeDlg = new ThreadCompletedDelegate(ThreadCompleted);

                m_canceledDlg = new ThreadCanceledDelegate(ThreadCanceled);

                string strMsg = string.Empty;

                bool bRet= true;

                int ino = 0;

                #region ----- 変換処理

                // 1:担当者行動予定データ(Actionscheduledata)

                bRet = CnvActionscheduledata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 2:承認経路マスタ(Approvalmaster)

                bRet = CnvApprovalmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 3:出勤日報データ(Attendancedailydata)

                bRet = CnvAttendancedailydata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 4:出勤管理データ(Attendancedata)

                bRet = CnvAttendancedata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 5:工事詳細台帳データ【退避用】(bk_constructionledger)

                bRet = CnvBk_constructionledger(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 6:工事詳細台帳明細データ【退避用】(Bk_constructionledgerdetail)

                bRet = CnvBk_constructionledgerdetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 7:工事詳細台帳実行データ【退避用】(Bk_constructionledgerexcute)

                bRet = CnvBk_constructionledgerexcute(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 8:積算見積データ【退避用】(Bk_estimatedata)

                bRet = CnvBk_estimatedata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 9:積算見積ページデータ【退避用】(Bk_estimatedatabody)

                bRet = CnvBk_estimatedatabody(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 10:積算見積データ明細【退避用】(Bk_estimatedatadetail)

                bRet = CnvBk_estimatedatadetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 11:法人格マスタ(Businesstypemaster)

                bRet = CnvBusinesstypemaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 12:共通費大項目マスタ(Commoncostlarge)

                bRet = CnvCommoncostlarge(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 13:共通費工種関連マスタ(Commoncostlinkms)

                bRet = CnvCommoncostlinkms(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 14:共通費中項目マスタ(Commoncostmiddle)

                bRet = CnvCommoncostmiddle(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 15:共通費中項目キーマスタ(Commoncostmiddlesearchword)

                bRet = CnvCommoncostmiddlesearchword(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 16:構成工種関連マスタ(Componentlinkmaster)

                bRet = CnvComponentlinkmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 17:構成マスタ(Componentmaster)

                bRet = CnvComponentmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 18:工事基本情報(Constructionbaseinfo)

                bRet = CnvConstructionbaseinfo(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 19:工事基本情報明細(Constructionbaseinfodetail)

                bRet = CnvConstructionbaseinfodetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 20:工事施工予算データ(Constructionbudget)

                bRet = CnvConstructionbudget(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 21:工事施工予算データ明細(Constructionbudgetdetail)

                bRet = CnvConstructionbudgetdetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 22:工種マスタ(Constructionitemmaster)

                bRet = CnvConstructionitemmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 23:工事詳細台帳データ(Constructionledger)

                bRet = CnvConstructionledger(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 24:工事詳細台帳明細データ(Constructionledgerdetail)

                bRet = CnvConstructionledgerdetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 25:工事詳細台帳実行データ(Constructionledgerexcute)

                bRet = CnvConstructionledgerexcute(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 26:工事リンク情報(Constructionlink)

                bRet = CnvConstructionlink(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 27:案件進捗日付データ(Constructionprogressdate)

                bRet = CnvConstructionprogressdate(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 28:作業マスタ(Constructionspecmaster)

                bRet = CnvConstructionspecmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 29:作業単価マスタ(Constructionspecunitprice)

                bRet = CnvConstructionspecunitprice(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 30:工事種別マスタ(Constructiontypemaster)

                bRet = CnvConstructiontypemaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 31:担当者毎経費データ(Costdataofperson)

                bRet = CnvCostdataofperson(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 32:発注者登録申請データ(Costomerregist)

                bRet = CnvCostomerregist(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 33:日報データ(Dailydataconstruction)

                bRet = CnvDailydataconstruction(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 34:日報データ (明細)(Dailydatadetail)

                bRet = CnvDailydatadetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 35:日報データ (現場巡回)(Dailydatafield)

                bRet = CnvDailydatafield(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 36:日報データ (資材)(Dailydatamaterials)

                bRet = CnvDailydatamaterials(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 37:日報データ (協力業者指示)(Dailydatasubcontractors)

                bRet = CnvDailydatasubcontractors(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 38:日報データ (車両)(Dailydatavehicles)

                bRet = CnvDailydatavehicles(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 39:部署経費率マスタ(Departmentexpensesmaster)

                bRet = CnvDepartmentexpensesmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 40:部署マスタ(Departmentmaster)

                bRet = CnvDepartmentmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 41:区分マスタ(Divisionmaster)

                bRet = CnvDivisionmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 42:積算予算書データ(Estimatebudget)

                bRet = CnvEstimatebudget(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 43:積算予算内訳データ明細(Estimatebudgetdetail)

                bRet = CnvEstimatebudgetdetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 44:積算見積データ(Estimatedata)

                bRet = CnvEstimatedata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 45:積算見積ページデータ(Estimatedatabody)

                bRet = CnvEstimatedatabody(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 46:積算見積データ明細(Estimatedatadetail)

                bRet = CnvEstimatedatadetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 47:会社休日マスタ(Holidaycalendermaster)

                bRet = CnvHolidaycalendermaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 48:入力時検索履歴(Inputsearchlogdata)

                bRet = CnvInputsearchlogdata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 49:掲示板メッセージ(Messageboarddata)

                bRet = CnvMessageboarddata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 50:掲示板対象者テーブル(Messageboardterget)

                bRet = CnvMessageboardterget(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 51:掲示板メッセージ閲覧履歴(Messagebrowsinghistory)

                bRet = CnvMessagebrowsinghistory(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 52:発注者マスタ(Orderersmaster)

                bRet = CnvOrderersmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 53:受注金額データ(Orderspricedata)

                bRet = CnvOrderspricedata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 54:担当者承認データ(Personapproval)

                bRet = CnvPersonapproval(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 55:担当者承認コメントデータ(Personapprovalcomment)

                bRet = CnvPersonapprovalcomment(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 56:担当者対象部署マスタ(Persondepartmentmaster)

                bRet = CnvPersondepartmentmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 57:担当者マスタ(Personinchargemaster)

                bRet = CnvPersoninchargemaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 58:担当者給与マスタ(Personsalarymaster)

                bRet = CnvPersonsalarymaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 59:発注者打ち合わせ議事録データ(Proceedingsdata)

                bRet = CnvProceedingsdata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 60:発注者打ち合わせ議事録データ（出席(Proceedingsdataattend)者）

                bRet = CnvProceedingsdataattend(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 61:発注者打ち合わせ議事録データ（明細(Proceedingsdatadetail)）

                bRet = CnvProceedingsdatadetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 62:承認データ(Processapproval)

                bRet = CnvProcessapproval(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 63:承認コメントデータ(Processapprovalcomment)

                bRet = CnvProcessapprovalcomment(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 64:承認明細データ(Processapprovaldetail)

                bRet = CnvProcessapprovaldetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 65:起動対象マスタ(Processexcutemaster)

                bRet = CnvProcessexcutemaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 66:注文書データ(Purchaseorder)

                bRet = CnvPurchaseorder(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 67:注文書明細データ(Purchaseorderdetail)

                bRet = CnvPurchaseorderdetail(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 68:売上グラフデータ(Salesgraphdata)

                bRet = CnvSalesgraphdata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 69:保護区分マスタ(Securitymaster)

                bRet = CnvSecuritymaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 70:協力業者施工工種登録申請データ(Subconstrjobitemregist)

                bRet = CnvSubconstrjobitemregist(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 71:協力業者職種リンク登録申請データ(Subconstrjoblinkregist)

                bRet = CnvSubconstrjoblinkregist(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 72:協力業者登録申請データ(Subconstrregist)

                bRet = CnvSubconstrregist(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 73:協力会社工種マスタ(Subcontractoritemmaster)

                bRet = CnvSubcontractoritemmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 74:協力会社職種マスタ(Subcontractorjobcategory)

                bRet = CnvSubcontractorjobcategory(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 75:協力会社施工工種データ(Subcontractorjobitem)

                bRet = CnvSubcontractorjobitem(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 76:協力会社職種リンクマスタ(Subcontractorjoblink)

                bRet = CnvSubcontractorjoblink(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 77:協力会社マスタ(Subcontractormaster)

                bRet = CnvSubcontractormaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 78:仕入先マスタ(Suppliersmaster)

                bRet = CnvSuppliersmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 79:システム起動確認データ(Systemexecute)

                bRet = CnvSystemexecute(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 80:管理マスタ(Systemmaster)

                bRet = CnvSystemmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 81:期限マスタ(Termmaster)

                bRet = CnvTermmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 82:出勤交通費データ(Tranceportdailydata)

                bRet = CnvTranceportdailydata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 83:工事種別経費率マスタ(Typeexpensesmaster)

                bRet = CnvTypeexpensesmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 84:単位マスタ(Unitmaster)

                bRet = CnvUnitmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 85:車両マスタ(Vehiclemaster)

                bRet = CnvVehiclemaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 86:車両記録データ(Vehiclerecorddata)

                bRet = CnvVehiclerecorddata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 87:車両予約データ(Vehiclescheduledata)

                bRet = CnvVehiclescheduledata(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 88:年マスタ(YearMaster)

                bRet = CnvYearMaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 89:月マスタ(Monthmaster)

                bRet = CnvMonthmaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                // 90:日マスタ(Daymaster)

                bRet = CnvDaymaster(ino++, ref strMsg);

                this.Invoke(m_progressDlg, new object[] { strMsg });

                if (!bRet) return;

                #endregion

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                // 完了したときにコントロールの値を変更する

                this.Invoke(m_completeDlg);

                //デリゲートの廃棄

                m_progressDlg = null;

                m_completeDlg = null;

                m_canceledDlg = null;

                // ガーベージコレクト

                GC.Collect();

            }

        }

        #endregion

        #region プログレスの代わりにメッセージを出す

        /// <summary>

        /// プログレスの代わりにメッセージを出す

        /// </summary>

        /// <param name="strMsg"></param>

        private void SetProgressValue(string strMsg)

        {

            listBox1.Items.Add(strMsg);

            listBox1.SelectedIndex = (listBox1.Items.Count - 1);

        }

        #endregion

        #region 処理が完了した時にコントロールの値を変更する

        /// <summary>

        /// 処理が完了した時にコントロールの値を変更する

        /// </summary>

        private void ThreadCompleted()

        {

            try

            {

                DateTime dtFinish = DateTime.Now;

                string strFinishMsg = string.Format(" ---------- 処理終了 ---------- {0}:経過時間{1}", dtFinish.ToLongTimeString(), dtFinish.Subtract(m_dtStart).ToString());

                listBox1.Items.Add(strFinishMsg);

                listBox1.SelectedIndex = (listBox1.Items.Count - 1);

                btnStart.Visible = true;

                btnEnd.Visible = true;

            }

            catch (System.Exception ex)

            {

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

            }

        }

        #endregion

        #region 処理がキャンセルされた時にコントロールの値を変更する

        /// <summary>

        /// 処理がキャンセルされた時にコントロールの値を変更する

        /// </summary>

        private void ThreadCanceled()

        {

            try

            {

            }

            catch (System.Exception ex)

            {

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

            }

        }

        #endregion

        #region プライマリキー取得

        /// <summary>

        /// プライマリキー取得

        /// </summary>

        /// <param name="tblname"></param>

        /// <param name="keyname"></param>

        private void GetPrimaryKey(string tblname, ref List<string> keyname)

        {

            OracleProcess OraProc = new OracleProcess(DBCommonForOracle.Instance.DBConnectString);

            try

            {

                string strSQL = "SELECT COLUMN_NAME FROM USER_CONS_COLUMNS";

                strSQL += string.Format(" WHERE TABLE_NAME = '{0}'", tblname);

                strSQL += " AND CONSTRAINT_NAME IN (SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS";

                strSQL += string.Format(" WHERE TABLE_NAME = '{0}'", tblname);

                strSQL += " AND CONSTRAINT_TYPE = 'P')";

                ArrayList arList = new ArrayList();

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

                foreach (object[] objRec in arList)

                {

                    keyname.Add(CommonMotions.cnvString(objRec[0]));

                }

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                OraProc.close(); OraProc = null;

            }

        }

        #endregion

        #region テーブル取得順序作成

        /// <summary>

        /// テーブル取得順序作成

        /// </summary>

        /// <param name="tblname"></param>

        /// <returns></returns>

        private string CreateOrder(string tblname)

        {

            string strRet = string.Empty;

            try

            {

                List<string> keyname = new List<string>();

                // プライマリキー取得

                GetPrimaryKey(tblname, ref keyname);

                strRet = " ORDER BY";

                bool bFirst = true;

                foreach (string curname in keyname)

                {

                    if (bFirst) strRet += string.Format(" {0} ASC", curname);

                    else strRet += string.Format(", {0} ASC", curname);

                    bFirst = false;

                }

                if (strRet.Equals(" ORDER BY")) strRet = string.Empty;

            }

            catch (Exception ex)

            {

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

            }

            return strRet;

        }

        #endregion

        #region 表示メッセージ長さ調整

        /// <summary>

        /// 表示メッセージ長さ調整

        /// </summary>

        /// <param name="strMsg"></param>

        private void EditDspLength(ref string strMsg)

        {

            try

            {

                string work = strMsg;

                strMsg = string.Format("{0, -90}", work);

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        // ----- テーブル毎変換処理

        #region 担当者行動予定データ(Actionscheduledata)

        /// <summary>

        /// 担当者行動予定データ(Actionscheduledata)

        /// </summary>

        /// <returns></returns>

        private bool CnvActionscheduledata(int ino, ref string strMsg)

        {

            ProcessManagement.OracleDB.IOAccess.IOActionScheduleData InDB = new ProcessManagement.OracleDB.IOAccess.IOActionScheduleData();

            ProcessManagement.DB.IOAccess.IOActionScheduleData OutDB = new ProcessManagement.DB.IOAccess.IOActionScheduleData();

            strMsg = string.Format("№{0}：テーブル:{1}({2})", (ino + 1).ToString("00"), s_OracleTables[ino].Value, s_OracleTables[ino].Key);

            try

            {

                EditDspLength(ref strMsg);

                string strSQL = CreateOrder(s_OracleTables[ino].Key);

                List<ActionScheduleData> getList = new List<ActionScheduleData>();

                if (!InDB.SelectAction(strSQL, ref getList)) return false;

                OutDB.connect(); OutDB.beginTran();

                strSQL = string.Format("TRUNCATE TABLE {0}", s_OracleTables[ino].Key);

                OutDB.ExecuteNonQuery(strSQL, false);

                List<ActionScheduleData> BuffList = new List<ActionScheduleData>();

                int DataCnt = 0;

                while (DataCnt < getList.Count)

                {

                    BuffList.Clear();

                    for (int ii = 0; ii < s_LoopCount; ii++, DataCnt++)

                    {

                        if (DataCnt >= getList.Count) break;

                        BuffList.Add(getList[DataCnt]);

                    }

                    if (!OutDB.InsertAction(BuffList, false))

                    {

                        OutDB.rollback();

                        strMsg += "　ＤＢ処理異常";

                        return false;

                    }

                }

                strMsg += string.Format("　処理件数={0}", DataCnt.ToString("#,0"));

                return true;

            }

            catch (Exception ex)

            {

                OutDB.rollback();

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

                strMsg += string.Format("　システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

                return false;

            }

            finally

            {

                InDB.close(); InDB = null;

                OutDB.commit();

                OutDB.close(); OutDB = null;

            }

        }

        #endregion

        #region 承認経路マスタ(Approvalmaster)

        /// <summary>

        /// 承認経路マスタ(Approvalmaster)

        /// </summary>

        private bool CnvApprovalmaster(int ino, ref string strMsg)

        {

            ProcessManagement.OracleDB.IOAccess.IOMApproval InDB = new ProcessManagement.OracleDB.IOAccess.IOMApproval();

            ProcessManagement.DB.IOAccess.IOMApproval OutDB = new ProcessManagement.DB.IOAccess.IOMApproval();

            strMsg = string.Format("№{0}：テーブル:{1}({2})", (ino + 1).ToString("00"), s_OracleTables[ino].Value, s_OracleTables[ino].Key);

            try

            {

                EditDspLength(ref strMsg);

                string strSQL = CreateOrder(s_OracleTables[ino].Key);

                List<ApprovalMaster> getList = new List<ApprovalMaster>();

                if (!InDB.SelectAction(strSQL, ref getList)) return false;

                OutDB.connect(); OutDB.beginTran();

                strSQL = string.Format("TRUNCATE TABLE {0}", s_OracleTables[ino].Key);

                OutDB.ExecuteNonQuery(strSQL, false);

                List<ApprovalMaster> BuffList = new List<ApprovalMaster>();

                int DataCnt = 0;

                while (DataCnt < getList.Count)

                {

                    BuffList.Clear();

                    for (int ii = 0; ii < s_LoopCount; ii++, DataCnt++)

                    {

                        if (DataCnt >= getList.Count) break;

                        BuffList.Add(getList[DataCnt]);

                    }

                    if (!OutDB.InsertAction(BuffList, false))

                    {

                        OutDB.rollback();

                        strMsg += "　ＤＢ処理異常";

                        return false;

                    }

                }

                strMsg += string.Format("　処理件数={0}", DataCnt.ToString("#,0"));

                return true;

            }

            catch (Exception ex)

            {

                OutDB.rollback();

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

                strMsg += string.Format("　システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

                return false;

            }

            finally

            {

                InDB.close(); InDB = null;

                OutDB.commit();

                OutDB.close(); OutDB = null;

            }

        }

        #endregion

        #region 出勤日報データ(Attendancedailydata)

        /// <summary>

        /// 出勤日報データ(Attendancedailydata)

        /// </summary>

        /// <returns></returns>

        private bool CnvAttendancedailydata(int ino, ref string strMsg)

        {

            ProcessManagement.OracleDB.IOAccess.IOAttendanceDailyData InDB = new ProcessManagement.OracleDB.IOAccess.IOAttendanceDailyData();

            ProcessManagement.DB.IOAccess.IOAttendanceDailyData OutDB = new ProcessManagement.DB.IOAccess.IOAttendanceDailyData();

            strMsg = string.Format("№{0}：テーブル:{1}({2})", (ino + 1).ToString("00"), s_OracleTables[ino].Value, s_OracleTables[ino].Key);

            try

            {

                EditDspLength(ref strMsg);

                string strSQL = CreateOrder(s_OracleTables[ino].Key);

                List<AttendanceDailyData> getList = new List<AttendanceDailyData>();

                if (!InDB.SelectAction(strSQL, ref getList)) return false;

                OutDB.connect(); OutDB.beginTran();

                strSQL = string.Format("TRUNCATE TABLE {0}", s_OracleTables[ino].Key);

                OutDB.ExecuteNonQuery(strSQL, false);

                List<AttendanceDailyData> BuffList = new List<AttendanceDailyData>();

                int DataCnt = 0;

                while (DataCnt < getList.Count)

                {

                    BuffList.Clear();

                    for (int ii = 0; ii < s_LoopCount; ii++, DataCnt++)

                    {

                        if (DataCnt >= getList.Count) break;

                        BuffList.Add(getList[DataCnt]);

                    }

                    if (!OutDB.InsertAction(BuffList, false))

                    {

                        OutDB.rollback();

                        strMsg += "　ＤＢ処理異常";

                        return false;

                    }

                }

                strMsg += string.Format("　処理件数={0}", DataCnt.ToString("#,0"));

                return true;

            }

            catch (Exception ex)

            {

                OutDB.rollback();

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

                strMsg += string.Format("　システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

                return false;

            }

            finally

            {

                InDB.close(); InDB = null;

                OutDB.commit();

                OutDB.close(); OutDB = null;

            }

        }

        #endregion

        #region 出勤管理データ(Attendancedata)

        /// <summary>

        /// 出勤管理データ(Attendancedata)

        /// </summary>

        /// <param name="strMsg"></param>

        /// <returns></returns>

        private bool CnvAttendancedata(int ino, ref string strMsg)

        {

            ProcessManagement.OracleDB.IOAccess.IOAttendanceData InDB = new ProcessManagement.OracleDB.IOAccess.IOAttendanceData();

            ProcessManagement.DB.IOAccess.IOAttendanceData OutDB = new ProcessManagement.DB.IOAccess.IOAttendanceData();

            strMsg = string.Format("№{0}：テーブル:{1}({2})", (ino + 1).ToString("00"), s_OracleTables[ino].Value, s_OracleTables[ino].Key);

            try

            {

                EditDspLength(ref strMsg);

                string strSQL = CreateOrder(s_OracleTables[ino].Key);

                List<AttendanceData> getList = new List<AttendanceData>();

                if (!InDB.SelectAction(strSQL, ref getList)) return false;

                OutDB.connect(); OutDB.beginTran();

                strSQL = string.Format("TRUNCATE TABLE {0}", s_OracleTables[ino].Key);

                OutDB.ExecuteNonQuery(strSQL, false);

                List<AttendanceData> BuffList = new List<AttendanceData>();

                int DataCnt = 0;

                while (DataCnt < getList.Count)

                {

                    BuffList.Clear();

                    for (int ii = 0; ii < s_LoopCount; ii++, DataCnt++)

                    {

                        if (DataCnt >= getList.Count) break;

                        BuffList.Add(getList[DataCnt]);

                    }

                    if (!OutDB.InsertAction(BuffList, false))

                    {

                        OutDB.rollback();

                        strMsg += "　ＤＢ処理異常";

                        return false;

                    }

                }

                strMsg += string.Format("　処理件数={0}", DataCnt.ToString("#,0"));

                return true;

            }

            catch (Exception ex)

            {

                OutDB.rollback();

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

                strMsg += string.Format("　システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

                return false;

            }

            finally

            {

                InDB.close(); InDB = null;

                OutDB.commit();

                OutDB.close(); OutDB = null;

            }

        }

        #endregion

        #region 工事詳細台帳データ【退避用】(bk_constructionledger)

        /// <summary>

        /// 工事詳細台帳データ【退避用】(bk_constructionledger)

        /// </summary>

        /// <param name="strMsg"></param>

        private bool CnvBk_constructionledger(int ino, ref string strMsg)

        {

            ProcessManagement.OracleDB.IOAccess.IOConstructionLedger InDB = new ProcessManagement.OracleDB.IOAccess.IOConstructionLedger();

            ProcessManagement.DB.IOAccess.IOConstructionLedger OutDB = new ProcessManagement.DB.IOAccess.IOConstructionLedger();

            strMsg = string.Format("№{0}：テーブル:{1}({2})", (ino + 1).ToString("00"), s_OracleTables[ino].Value, s_OracleTables[ino].Key);

            try

            {

                EditDspLength(ref strMsg);

                string strSQL = "SELECT";

                strSQL += " ConstructionCode";      // 工事番号

                strSQL += " ,ConstructionPeriod";   // 事業期

                strSQL += " ,CreatorCode";          // 作成者コード

                strSQL += " ,CreatorName";    	    // 作成者名

                strSQL += " ,CreateDate";	        // 作成日

                strSQL += " ,ConstructionTimes";    // 工期（単位・月）

                strSQL += " ,TO_CHAR(ConstructionStart, 'YYYY/MM/DD')"; // 契約工期開始

                strSQL += " ,TO_CHAR(ConstructionEnd, 'YYYY/MM/DD')";   // 契約工期完了

                strSQL += " ,OrdersDecisionPrice";  // 税抜受注決定金額

                strSQL += " ,CompanyExpenses";      // 会社経費合計

                strSQL += " ,DepartmentExpenses";   // 部署経費合計

                strSQL += " ,SalesExpenses";        // 営業経費合計

                strSQL += " ,TotalPayment";         // 総支払額

                strSQL += " ,GrossProfit";          // 粗利

                strSQL += " ,Allowance";            // 給与

                strSQL += " ,NetProfit";            // 純利益

                strSQL += " ,ComplateFlg";          // 入力完了フラグ

                strSQL += " ,IntegrationFlg";       // 受注金額積算フラグ

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

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

                strSQL += string.Format(" FROM {0}", s_OracleTables[ino].Key);

                strSQL += string.Format(CreateOrder(s_OracleTables[ino].Key));

                strSQL += CreateOrder(s_OracleTables[ino].Key);

                ArrayList getList = new ArrayList();

                if (!InDB.ExecuteReader(strSQL, ref getList)) return false;

                OutDB.connect(); OutDB.beginTran();

                strSQL = string.Format("TRUNCATE TABLE {0}", s_OracleTables[ino].Key);

                OutDB.ExecuteNonQuery(strSQL, false);

                int DataCnt = 0;

                bool bColFirst = true;

                bool bDataFirst = true;

                ConstructionLedger work = new ConstructionLedger();

                while (DataCnt < getList.Count)

                {

                    bColFirst = true;

                    strSQL = string.Format("INSERT INTO {0}", s_OracleTables[ino].Key);

                    strSQL += " (";

                    foreach (var gender in Enum.GetValues(typeof(ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn)))

                    {

                        if (!bColFirst) strSQL += ", ";

                        strSQL += gender.ToString();

                        bColFirst = false;

                    }

                    strSQL += ") VALUES";

                    bDataFirst = true;

                    for (int i = 0; i < s_LoopCount; i++, DataCnt++)

                    {

                        if (DataCnt >= getList.Count) break;

                        object[] CurRec = (object[])getList[DataCnt];

                        if (bDataFirst) strSQL += " (";

                        else strSQL += ", (";

                        work.ConstructionCode = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.ConstructionCode);

                        strSQL += string.Format("  {0}", work.ConstructionCode);                // 工事番号

                        work.ConstructionPeriod = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.ConstructionPeriod);

                        strSQL += string.Format(", {0}", work.ConstructionPeriod);              // 事業期

                        work.CreatorCode = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.CreatorCode);

                        strSQL += string.Format(", {0}", work.CreatorCode);                     // 作成者コード

                        work.CreatorName = CommonMotions.ObjectToString(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.CreatorName);

                        strSQL += string.Format(",'{0}'", work.CreatorName);                    // 作成者名

                        work.CreateDate = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.CreateDate);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.CreateDate.ToShortDateString());           // 作成日

                        work.ConstructionTimes = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.ConstructionTimes);

                        strSQL += string.Format(", {0}", work.ConstructionTimes);               // 工期（単位・月）

                        work.ConstructionStart = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.ConstructionStart);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ConstructionStart.ToShortDateString());    // 契約工期開始

                        work.ConstructionEnd = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.ConstructionEnd);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.ConstructionEnd.ToShortDateString());      // 契約工期完了

                        work.OrdersDecisionPrice = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.OrdersDecisionPrice);

                        strSQL += string.Format(",{0}", work.OrdersDecisionPrice);              // 税抜受注決定金額

                        work.CompanyExpenses = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.CompanyExpenses);

                        strSQL += string.Format(",{0}", work.CompanyExpenses);                  // 会社経費合計

                        work.DepartmentExpenses = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.DepartmentExpenses);

                        strSQL += string.Format(",{0}", work.DepartmentExpenses);               // 部署経費合計

                        work.SalesExpenses = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.SalesExpenses);

                        strSQL += string.Format(",{0}", work.SalesExpenses);                    // 営業経費合計

                        work.TotalPayment = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.TotalPayment);

                        strSQL += string.Format(",{0}", work.TotalPayment);                     // 総支払額

                        work.GrossProfit = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.GrossProfit);

                        strSQL += string.Format(",{0}", work.GrossProfit);                      // 粗利

                        work.Allowance = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.Allowance);

                        strSQL += string.Format(",{0}", work.Allowance);                        // 給与

                        work.NetProfit = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.NetProfit);

                        strSQL += string.Format(",{0}", work.NetProfit);                        // 純利益

                        work.ComplateFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.ComplateFlg);

                        strSQL += string.Format(",{0}", work.ComplateFlg);                      // 入力完了フラグ

                        work.IntegrationFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.IntegrationFlg);

                        strSQL += string.Format(",{0}", work.IntegrationFlg);                   // 受注金額積算フラグ

                        work.EntryDate = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.EntryDate);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);

                        work.UpdateDate = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.DB.IOAccess.IOConstructionLedger.TableColumn.UpdateDate);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);

                        strSQL += ")";

                        bDataFirst = false;

                    }

                    if (!OutDB.ExecuteNonQuery(strSQL, false))

                    {

                        OutDB.rollback();

                        strMsg += " ＤＢ処理異常";

                        return false;

                    }

                }

                strMsg += string.Format("　処理件数={0}", DataCnt.ToString("#,0"));

                return true;

            }

            catch (Exception ex)

            {

                OutDB.rollback();

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

                strMsg += string.Format("　システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

                return false;

            }

            finally

            {

                InDB.close(); InDB = null;

                OutDB.commit();

                OutDB.close(); OutDB = null;

            }

        }

        #endregion

        #region 工事詳細台帳明細データ【退避用】(Bk_constructionledgerdetail)

        /// <summary>

        /// 工事詳細台帳明細データ【退避用】(Bk_constructionledgerdetail)

        /// </summary>

        /// <param name="strMsg"></param>

        /// <returns></returns>

        private bool CnvBk_constructionledgerdetail(int ino, ref string strMsg)

        {

            ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail InDB = new ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail();

            ProcessManagement.DB.IOAccess.IOConstructionLedgerDetail OutDB = new ProcessManagement.DB.IOAccess.IOConstructionLedgerDetail();

            strMsg = string.Format("№{0}：テーブル:{1}({2})", (ino + 1).ToString("00"), s_OracleTables[ino].Value, s_OracleTables[ino].Key);

            try

            {

                EditDspLength(ref strMsg);

                string strSQL = "SELECT";

                strSQL += "  ConstructionCode";	        // 工事コード

                strSQL += ", GroupCount";               // グループ番号

                strSQL += ", LineCount";                // 行番号

                strSQL += ", ComponentCode";            // 構成キー

                strSQL += ", ItemCode";		            // 工種キー

                strSQL += ", FirstString";              // 項目名称

                strSQL += ", SecondString";             // 工事内容

                strSQL += ", CompanyType";              // 協力会社コードタイプ

                strSQL += ", CompanyCode";              // 協力会社コード

                strSQL += ", CompanyName";              // 協力会社名称

                strSQL += ", EstimatePrice";            // 予算（見積）金額

                strSQL += ", ExecutionAmount";          // 実行金額

                strSQL += ", AmountConfigRate";         // 金額構成率

                strSQL += ", PaymentBurden";            // 支払補填額

                strSQL += ", FixDataFlg";               // 固定データフラグ

                strSQL += ", IndependentFlg";           // 独立データフラグ

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

                strSQL += ", SalaryFlg";                // 給与振分区分

                strSQL += ", SalaryDays";               // 給与振分日数

                strSQL += ", OperatingFlg";             // 担当中フラグ

                strSQL += ", SourceCode";               // 元工事番号

                strSQL += ", JoinTitleFlg";             // 工事名称タイトル

                strSQL += ", SalaryOnRegist";           // 登録時月額給与

                strSQL += ", PurchaseOrderFlg";         // 注文書発行フラグ

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

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

                strSQL += string.Format(" FROM {0}", s_OracleTables[ino].Key);

                strSQL += string.Format(CreateOrder(s_OracleTables[ino].Key));

                strSQL += CreateOrder(s_OracleTables[ino].Key);

                ArrayList getList = new ArrayList();

                if (!InDB.ExecuteReader(strSQL, ref getList)) return false;

                OutDB.connect(); OutDB.beginTran();

                strSQL = string.Format("TRUNCATE TABLE {0}", s_OracleTables[ino].Key);

                OutDB.ExecuteNonQuery(strSQL, false);

                int DataCnt = 0;

                bool bColFirst = true;

                bool bDataFirst = true;

                ConstructionLedgerDetail work = new ConstructionLedgerDetail();

                while (DataCnt < getList.Count)

                {

                    bColFirst = true;

                    strSQL = string.Format("INSERT INTO {0}", s_OracleTables[ino].Key);

                    strSQL += " (";

                    foreach (var gender in Enum.GetValues(typeof(ProcessManagement.DB.IOAccess.IOConstructionLedgerDetail.TableColumn)))

                    {

                        if (!bColFirst) strSQL += ", ";

                        strSQL += gender.ToString();

                        bColFirst = false;

                    }

                    strSQL += ") VALUES";

                    bDataFirst = true;

                    for (int i = 0; i < s_LoopCount; i++, DataCnt++)

                    {

                        if (DataCnt >= getList.Count) break;

                        object[] CurRec = (object[])getList[DataCnt];

                        if (bDataFirst) strSQL += " (";

                        else strSQL += ", (";

                        work.ConstructionCode = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.ConstructionCode);

                        strSQL += string.Format("  {0}", work.ConstructionCode);        // 工事番号

                        work.GroupCount = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.GroupCount);

                        strSQL += string.Format(", {0}", work.GroupCount);              // グループ番号

                        work.LineCount = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.LineCount);

                        strSQL += string.Format(", {0}", work.LineCount);               // 行番号

                        work.ComponentCode = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.ComponentCode);

                        strSQL += string.Format(", {0}", work.ComponentCode);           // 構成キー

                        work.ItemCode = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.ItemCode);

                        strSQL += string.Format(", {0}", work.ItemCode);		        // 工種キー

                        work.FirstString = CommonMotions.ObjectToString(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.FirstString);

                        strSQL += string.Format(",'{0}'", work.FirstString);            // 項目名称

                        work.SecondString = CommonMotions.ObjectToString(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.SecondString);

                        strSQL += string.Format(",'{0}'", work.SecondString);           // 工事内容

                        work.CompanyType = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.CompanyType);

                        strSQL += string.Format(", {0}", work.CompanyType);             // 協力会社コードタイプ

                        work.CompanyCode = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.CompanyCode);

                        strSQL += string.Format(", {0}", work.CompanyCode);             // 協力会社コード

                        work.CompanyName = CommonMotions.ObjectToString(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.CompanyName);

                        strSQL += string.Format(",'{0}'", work.CompanyName);            // 協力会社名称

                        work.EstimatePrice = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.EstimatePrice);

                        strSQL += string.Format(", {0}", work.EstimatePrice);           // 予算（見積）金額

                        work.ExecutionAmount = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.ExecutionAmount);

                        strSQL += string.Format(", {0}", work.ExecutionAmount);         // 実行金額

                        work.AmountConfigRate = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.AmountConfigRate);

                        strSQL += string.Format(", {0}", work.AmountConfigRate);        // 金額構成率

                        work.PaymentBurden = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.PaymentBurden);

                        strSQL += string.Format(", {0}", work.PaymentBurden);           // 支払補填額

                        work.FixDataFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.FixDataFlg);

                        strSQL += string.Format(", {0}", work.FixDataFlg);              // 固定データフラグ

                        work.IndependentFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.IndependentFlg);

                        strSQL += string.Format(", {0}", work.IndependentFlg);          // 独立データフラグ

                        work.FluctuationFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.FluctuationFlg);

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

                        work.SalaryFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.SalaryFlg);

                        strSQL += string.Format(", {0}", work.SalaryFlg);               // 給与振分区分

                        work.SalaryDays = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.SalaryDays);

                        strSQL += string.Format(", {0}", work.SalaryDays);              // 給与振分日数

                        work.OperatingFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.OperatingFlg);

                        strSQL += string.Format(", {0}", work.OperatingFlg);            // 担当中フラグ

                        work.SourceCode = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.SourceCode);

                        strSQL += string.Format(", {0}", work.SourceCode);              // 元工事番号

                        work.JoinTitleFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.JoinTitleFlg);

                        strSQL += string.Format(", {0}", work.JoinTitleFlg);            // 工事名称タイトル

                        work.SalaryOnRegist = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.SalaryOnRegist);

                        strSQL += string.Format(", {0}", work.SalaryOnRegist);          // 登録時月額給与

                        work.PurchaseOrderFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.PurchaseOrderFlg);

                        strSQL += string.Format(", {0}", work.PurchaseOrderFlg);        // 注文書発行フラグ

                        work.EntryDate = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.EntryDate);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);

                        work.UpdateDate = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerDetail.TableColumn.UpdateDate);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);

                        strSQL += ")";

                        bDataFirst = false;

                    }

                    if (!OutDB.ExecuteNonQuery(strSQL, false))

                    {

                        OutDB.rollback();

                        strMsg += " ＤＢ処理異常";

                        return false;

                    }

                }

                strMsg += string.Format("　処理件数={0}", DataCnt.ToString("#,0"));

                return true;

            }

            catch (Exception ex)

            {

                OutDB.rollback();

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

                strMsg += string.Format("　システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

                return false;

            }

            finally

            {

                InDB.close(); InDB = null;

                OutDB.commit();

                OutDB.close(); OutDB = null;

            }

        }

        #endregion

        #region 工事詳細台帳実行データ【退避用】(Bk_constructionledgerexcute)

        /// <summary>

        /// 工事詳細台帳実行データ【退避用】(Bk_constructionledgerexcute)

        /// </summary>

        /// <param name="strMsg"></param>

        /// <returns></returns>

        private bool CnvBk_constructionledgerexcute(int ino, ref string strMsg)

        {

            ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerExcute InDB = new ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerExcute();

            ProcessManagement.DB.IOAccess.IOConstructionLedgerExcute OutDB = new ProcessManagement.DB.IOAccess.IOConstructionLedgerExcute();

            strMsg = string.Format("№{0}：テーブル:{1}({2})", (ino + 1).ToString("00"), s_OracleTables[ino].Value, s_OracleTables[ino].Key);

            try

            {

                EditDspLength(ref strMsg);

                string strSQL = "SELECT";

                strSQL += "  ConstructionCode";	        // 工事コード

                strSQL += ", GroupCount";               // グループ番号

                strSQL += ", LineCount";                // 行番号

                strSQL += ", ColumnCount";              // 列番号

                strSQL += ", PaymentAmount";            // 支払金額

                strSQL += ", TO_CHAR(TargetMonth, 'YYYY/MM/DD HH24:MI:ss')";    // 対象年月

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

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

                strSQL += string.Format(" FROM {0}", s_OracleTables[ino].Key);

                strSQL += string.Format(CreateOrder(s_OracleTables[ino].Key));

                strSQL += CreateOrder(s_OracleTables[ino].Key);

                ArrayList getList = new ArrayList();

                if (!InDB.ExecuteReader(strSQL, ref getList)) return false;

                OutDB.connect(); OutDB.beginTran();

                strSQL = string.Format("TRUNCATE TABLE {0}", s_OracleTables[ino].Key);

                OutDB.ExecuteNonQuery(strSQL, false);

                int DataCnt = 0;

                bool bColFirst = true;

                bool bDataFirst = true;

                ConstructionLedgerExcute work = new ConstructionLedgerExcute();

                while (DataCnt < getList.Count)

                {

                    bColFirst = true;

                    strSQL = string.Format("INSERT INTO {0}", s_OracleTables[ino].Key);

                    strSQL += " (";

                    foreach (var gender in Enum.GetValues(typeof(ProcessManagement.DB.IOAccess.IOConstructionLedgerExcute.TableColumn)))

                    {

                        if (!bColFirst) strSQL += ", ";

                        strSQL += gender.ToString();

                        bColFirst = false;

                    }

                    strSQL += ") VALUES";

                    bDataFirst = true;

                    for (int i = 0; i < s_LoopCount; i++, DataCnt++)

                    {

                        if (DataCnt >= getList.Count) break;

                        object[] CurRec = (object[])getList[DataCnt];

                        if (bDataFirst) strSQL += " (";

                        else strSQL += ", (";

                        work.ConstructionCode = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerExcute.TableColumn.ConstructionCode);

                        strSQL += string.Format("  {0}", work.ConstructionCode);        // 工事番号

                        work.GroupCount = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerExcute.TableColumn.GroupCount);

                        strSQL += string.Format(", {0}", work.GroupCount);              // グループ番号

                        work.LineCount = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerExcute.TableColumn.LineCount);

                        strSQL += string.Format(", {0}", work.LineCount);               // 行番号

                        work.ColumnCount = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerExcute.TableColumn.ColumnCount);

                        strSQL += string.Format(", {0}", work.ColumnCount);             // 列番号

                        work.PaymentAmount = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerExcute.TableColumn.PaymentAmount);

                        strSQL += string.Format(", {0}", work.PaymentAmount);           // 支払金額

                        work.TargetMonth = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerExcute.TableColumn.TargetMonth);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')", work.TargetMonth.ToShortDateString());  // 対象年月

                        work.EntryDate = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerExcute.TableColumn.EntryDate);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);

                        work.UpdateDate = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOConstructionLedgerExcute.TableColumn.UpdateDate);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);

                        strSQL += ")";

                        bDataFirst = false;

                    }

                    if (!OutDB.ExecuteNonQuery(strSQL, false))

                    {

                        OutDB.rollback();

                        strMsg += " ＤＢ処理異常";

                        return false;

                    }

                }

                strMsg += string.Format("　処理件数={0}", DataCnt.ToString("#,0"));

                return true;

            }

            catch (Exception ex)

            {

                OutDB.rollback();

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

                strMsg += string.Format("　システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

                return false;

            }

            finally

            {

                InDB.close(); InDB = null;

                OutDB.commit();

                OutDB.close(); OutDB = null;

            }

        }

        #endregion

        #region 積算見積データ【退避用】(Bk_estimatedata)

        /// <summary>

        /// 積算見積データ【退避用】(Bk_estimatedata)

        /// </summary>

        /// <param name="strMsg"></param>

        /// <returns></returns>

        private bool CnvBk_estimatedata(int ino, ref string strMsg)

        {

            ProcessManagement.OracleDB.IOAccess.IOEstimateData InDB = new ProcessManagement.OracleDB.IOAccess.IOEstimateData();

            ProcessManagement.DB.IOAccess.IOEstimateData OutDB = new ProcessManagement.DB.IOAccess.IOEstimateData();

            strMsg = string.Format("№{0}：テーブル:{1}({2})", (ino + 1).ToString("00"), s_OracleTables[ino].Value, s_OracleTables[ino].Key);

            try

            {

                EditDspLength(ref strMsg);

                string strSQL = "SELECT";

                strSQL += "  ConstructionCode";     // 工事番号

                strSQL += ", LineCount";            // 行番号

                strSQL += ", ComponentCode";        // 構成キー

                strSQL += ", FixedItemCode";		// 固定項目キー

                strSQL += ", ItemName";      		// 作業名称

                strSQL += ", SpecName";      		// 品質・形状・寸法

                strSQL += ", PriceValue";           // 金額

                strSQL += ", Note";			        // 備考

                strSQL += ", MyExpensesFlg";

                strSQL += ", InputFlg";

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

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

                strSQL += ", TO_CHAR(SaveDate, 'YYYY/MM/DD HH24:MI:ss')";   // 退避日付

                strSQL += string.Format(" FROM {0}", s_OracleTables[ino].Key);

                strSQL += string.Format(CreateOrder(s_OracleTables[ino].Key));

                strSQL += CreateOrder(s_OracleTables[ino].Key);

                ArrayList getList = new ArrayList();

                if (!InDB.ExecuteReader(strSQL, ref getList)) return false;

                OutDB.connect(); OutDB.beginTran();

                strSQL = string.Format("TRUNCATE TABLE {0}", s_OracleTables[ino].Key);

                OutDB.ExecuteNonQuery(strSQL, false);

                int DataCnt = 0;

                bool bColFirst = true;

                bool bDataFirst = true;

                EstimateData work = new EstimateData();

                DateTime SaveDate = DateTime.Now;

                int TblColCnt = Enum.GetNames(typeof(ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn)).Length;

                while (DataCnt < getList.Count)

                {

                    bColFirst = true;

                    strSQL = string.Format("INSERT INTO {0}", s_OracleTables[ino].Key);

                    strSQL += " (";

                    strSQL += "SaveDate,";

                    foreach (var gender in Enum.GetValues(typeof(ProcessManagement.DB.IOAccess.IOEstimateData.TableColumn)))

                    {

                        if (!bColFirst) strSQL += ", ";

                        strSQL += gender.ToString();

                        bColFirst = false;

                    }

                    strSQL += ") VALUES";

                    bDataFirst = true;

                    for (int i = 0; i < s_LoopCount; i++, DataCnt++)

                    {

                        if (DataCnt >= getList.Count) break;

                        object[] CurRec = (object[])getList[DataCnt];

                        if (bDataFirst) strSQL += " (";

                        else strSQL += ", (";

                        SaveDate = CommonMotions.ObjectToDateTime(CurRec, TblColCnt);

                        strSQL += string.Format("  STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", SaveDate);  // 退避日付

                        work.ConstructionCode = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.ConstructionCode);

                        strSQL += string.Format(", {0}", work.ConstructionCode);        // 工事番号

                        work.LineCount = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.LineCount);

                        strSQL += string.Format(", {0}", work.LineCount);               // 行番号

                        work.ComponentCode = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.ComponentCode);

                        strSQL += string.Format(", {0}", work.ComponentCode);           // 構成キー

                        work.FixedItemCode = CommonMotions.ObjectToString(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.FixedItemCode);

                        strSQL += string.Format(",'{0}'", work.FixedItemCode);		    // 固定項目キー

                        work.ItemName = CommonMotions.ObjectToString(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.ItemName);

                        strSQL += string.Format(",'{0}'", work.ItemName.Replace(",", "，"));     // 作業名称

                        work.SpecName = CommonMotions.ObjectToString(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.WorkName);

                        strSQL += string.Format(",'{0}'", work.SpecName.Replace(",", "，"));     // 品質・形状・寸法

                        work.PriceValue = CommonMotions.ObjectToDouble(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.PriceValue);

                        strSQL += string.Format(", {0}", work.PriceValue);                      // 金額

                        work.Note = CommonMotions.ObjectToString(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.Note);

                        strSQL += string.Format(",'{0}'", work.Note.Replace(",", "，"));		// 備考

                        work.MyExpensesFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.MyExpensesFlg);

                        strSQL += string.Format(", {0}", work.MyExpensesFlg);           // 自社経費フラグ

                        work.InputFlg = CommonMotions.ObjectToInt(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.InputFlg);

                        strSQL += string.Format(", {0}", work.InputFlg);                // 入力フラグ

                        work.EntryDate = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.EntryDate);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);

                        work.UpdateDate = CommonMotions.ObjectToDateTime(CurRec, (int)ProcessManagement.OracleDB.IOAccess.IOEstimateData.TableColumn.UpdateDate);

                        strSQL += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);

                        strSQL += ")";

                        bDataFirst = false;

                    }

                    if (!OutDB.ExecuteNonQuery(strSQL, false))

                    {

                        OutDB.rollback();

                        strMsg += " ＤＢ処理異常";

                        return false;

                    }

                }

                strMsg += string.Format("　処理件数={0}", DataCnt.ToString("#,0"));

                return true;

            }

            catch (Exception ex)

            {

                OutDB.rollback();

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

                strMsg += string.Format("　システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);

                return false;

            }

            finally

            {

                InDB.close(); InDB = null;

                OutDB.commit();

                OutDB.close(); OutDB = null;

            }

        }

        #endregion

        #region 積算見積ページデータ【退避用】(Bk_estimatedatabody)

        /// <summary>

        /// 積算見積ページデータ【退避用】(Bk_estimatedatabody)

        /// </summary>

        /// <param name="strMsg"></param>

        /// <returns></returns>

        private bool CnvBk_estimatedatabody(int ino, ref string strMsg)