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

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

            /// 作成中

            NoMakeData = 9,

        public static int s_SystemVersion = 2;

        public static int s_UpDateCopyVersion = 2;

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Collections;

using System.Diagnostics;

using log4net;

using log4net.Appender;

using log4net.Repository.Hierarchy;

using ProcessManagement.Common;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

using ProcessManagement.Forms.Master;

using ProcessManagement.Forms.DataEntry;

using ProcessManagement.Forms.ControlsAction;

using ProcessManagement.Forms.SubForms;

//*----------------------- 工事詳細台帳データ引込クラス -----------------------*

//  2016/05/31  Ver1.0.0.0      Create Source           

//

//

//

//*----------------------------------------------------------------------------*

namespace ProcessManagement.Common

{

    //*--------------------- 経費データを工事詳細台帳データ引込む -----------------*

    //  2015/08/12  Ver1.0.0.0      Create Source           

    //

    //

    //

    //*----------------------------------------------------------------------------*

    /// <summary>

    /// 経費データを工事詳細台帳データ引込む

    /// </summary>

    public static class ClsCreateLedgerData

    {

        #region ログ定義

        /// <summary>

        /// log4netログを使用する

        /// </summary>

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

        #endregion

        #region 定数

        #endregion

        #region 変数

        /// <summary>

        /// 工事施工台帳支払い実績先頭カラム数

        /// </summary>

        private static int m_LedgerColumnCount = 0;

        #endregion

        #region 対象月の工事詳細台帳実行データを作成する

        /// <summary>

        /// 対象月の工事詳細台帳実行データを作成する

        /// </summary>

        /// <param name="PersonCode">担当者コード</param>

        /// <param name="TargetMonth">対象年月</param>

        /// <returns></returns>

        public static bool MakeLedgerData(int PersonCode, string TargetMonth)

        {

            IOCostDataOfPerson CostDB = new IOCostDataOfPerson();

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

            IOConstructionLedgerDetail LedgerDetailDB = new IOConstructionLedgerDetail();

            IOConstructionLedgerExcute LedgerExcuteDB = new IOConstructionLedgerExcute();

            try

            {

                // 一括処理で登録を行う

                CostDB.connect();

                LedgerDB.connect();

                LedgerDetailDB.connect();

                LedgerExcuteDB.connect(); LedgerExcuteDB.beginTran();

                // 詳細台帳よりグリッドのカラムを取得する

                GetLedgerColumnCount();

                // 対象をまず削除する

                string strDelSQL = "DELETE CONSTRUCTIONLEDGEREXCUTE";

                strDelSQL += " WHERE CONSTRUCTIONCODE IN";

                strDelSQL += " (SELECT CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO";

                strDelSQL += string.Format(" WHERE (SALESPERSONCODE = {0} OR CONSTRUCTIONPERSONCODE = {0} OR CONSTRSUBPERSONCODE = {0} OR CONSTRUCTIONINSTRUCTOR = {0}))", PersonCode);

                strDelSQL += string.Format(" AND GROUPCOUNT IN ({0}, {1}, {2}, {3}, {4})"

                                                                , GetConstructionLedgerGroupNo((int)CommonDefine.CostDataNo.Transport)

                                                                , GetConstructionLedgerGroupNo((int)CommonDefine.CostDataNo.Purchase)

                                                                , GetConstructionLedgerGroupNo((int)CommonDefine.CostDataNo.Lease)

                                                                , GetConstructionLedgerGroupNo((int)CommonDefine.CostDataNo.StoragePlace)

                                                                , GetConstructionLedgerGroupNo((int)CommonDefine.CostDataNo.Lodging));

                strDelSQL += string.Format(" AND TARGETMONTH = TO_DATE('{0}','YYYY/MM/DD')", (TargetMonth + "/01"));

                LedgerExcuteDB.ExecuteNonQuery(strDelSQL, false);

                for (int i = (int)CommonDefine.CostDataNo.Transport; i <= (int)CommonDefine.CostDataNo.Lodging; i++)

                {

                    string strSQL = "SELECT CONSTRUCTIONCODE, DATATYPE, TO_CHAR(ACTIONDATE,'YYYY/MM'), SUM(ENTRYPRICE) FROM COSTDATAOFPERSON";

                    strSQL += String.Format(" WHERE TO_CHAR(ACTIONDATE,'YYYY/MM') = '{0}'", TargetMonth);

                    strSQL += String.Format(" AND DATATYPE = {0}", i);

                    strSQL += " AND CONSTRUCTIONCODE IN (SELECT CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO";

                    strSQL += string.Format(" WHERE (SALESPERSONCODE = {0} OR CONSTRUCTIONPERSONCODE = {0} OR CONSTRSUBPERSONCODE = {0} OR CONSTRUCTIONINSTRUCTOR = {0}))", PersonCode);

                    strSQL += " GROUP BY CONSTRUCTIONCODE, DATATYPE, TO_CHAR(ACTIONDATE,'YYYY/MM')";

                    strSQL += " ORDER BY CONSTRUCTIONCODE, DATATYPE";

                    ArrayList arList = new ArrayList();

                    if (!CostDB.ExecuteReader(strSQL, ref arList, false)) continue;

                    if (arList.Count == 0) continue;

                    foreach (object[] wrkrec in arList)

                    {

                        // 支払金額

                        int PaymentPrice = CommonMotions.cnvInt(wrkrec[3]);

                        // 支払金額無は処理しない

                        if (PaymentPrice == 0) continue;

                        // 工事番号

                        int ConstructionCode = CommonMotions.cnvInt(wrkrec[0]);

                        // グループ番号

                        int DataType = i;

                        int GroupNo = GetConstructionLedgerGroupNo(DataType);

                        // 工事詳細台帳よりデータの行・列を取得する

                        int LineCnt = 0;

                        int ColCnt = 0;

                        // 台帳が無ければ処理しない

                        if (!SearchTatgetConstructionLedger(LedgerDB, LedgerDetailDB, ConstructionCode, GroupNo, TargetMonth, ref  LineCnt, ref ColCnt)) continue;

                        ConstructionLedgerExcute excRec = new ConstructionLedgerExcute();

                        // データ編集

                        excRec.ConstructionCode = ConstructionCode;

                        excRec.GroupCount = GroupNo;

                        excRec.LineCount = LineCnt;

                        excRec.ColumnCount = ColCnt;

                        excRec.PaymentAmount = PaymentPrice;

                        excRec.TargetMonth = CommonMotions.cnvDate(TargetMonth + "/01");

                        if (!LedgerExcuteDB.InsertAction(excRec, false))

                        {

                            LedgerExcuteDB.rollback();

                            return false;

                        }

                    }

                }

                // DBコミット

                LedgerExcuteDB.commit();

                return true;

            }

            catch (System.Exception ex)

            {

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

                LedgerExcuteDB.rollback();

                return false;

            }

            finally

            {

                CostDB.close(); CostDB = null;

                LedgerDB.close(); LedgerDB = null;

                LedgerDetailDB.close(); LedgerDetailDB = null;

                LedgerExcuteDB.close(); LedgerExcuteDB = null;

            }

        }

        #endregion

        #region 工事詳細台帳より対象データを探して実行データの行番号・列番号を返す

        /// <summary>

        /// 工事詳細台帳より対象データを探して実行データの行番号・列番号を返す

        /// </summary>

        /// <returns></returns>

        private static bool SearchTatgetConstructionLedger(IOConstructionLedger LedgerDB, IOConstructionLedgerDetail LedgerDetailDB

                                                            ,int ConstructionCode, int GroupNo, string TargetMonth, ref int LineCnt, ref int ColCnt)

        {

            try

            {

                // 台帳データよりカラム数を取得する

                string strLedger = LedgerDB.CreatePrimarykeyString(ConstructionCode);

                ConstructionLedger LedgerRec = new ConstructionLedger();

                if (!LedgerDB.SelectAction(strLedger, ref LedgerRec, false)) return false;

                // 現在の処理年月をDateTime型に変換する

                DateTime NowDates = CommonMotions.cnvDate(TargetMonth + "/01");

                // 経過月数を取得する

                int DiffMonth = NowDates.Month - LedgerRec.ConstructionStart.Month;

                // 列番号取得

                ColCnt = m_LedgerColumnCount + DiffMonth;

                // 工事詳細台帳明細データ読込み

                string strSQL = LedgerDetailDB.CreatePrimarykeyString(ConstructionCode, GroupNo);

                List<ConstructionLedgerDetail> DetailList = new List<ConstructionLedgerDetail>();

                if (!LedgerDetailDB.SelectAction(strSQL, ref DetailList, false)) return false;

                // 行番号取得

                LineCnt = DetailList[0].LineCount;

                return true;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 工事台帳のグループ番号を取得する

        /// <summary>

        /// 工事台帳のグループ番号を取得する

        /// </summary>

        /// <param name="TargetData"></param>

        /// <returns></returns>

        public static int GetConstructionLedgerGroupNo(int TargetData)

        {

            int GroupNo = 0;

            // 工事台帳のグループ番号を取得する

            switch (TargetData)

            {

                case (int)CommonDefine.CostDataNo.Transport:

                    // 交通費（通行料・電車代）

                    GroupNo = (int)GroupName_ConstructionLedger.TransportationCosts;

                    break;

                case (int)CommonDefine.CostDataNo.Purchase:

                    // 購入品

                    GroupNo = (int)GroupName_ConstructionLedger.PurchaseCosts;

                    break;

                case (int)CommonDefine.CostDataNo.Lease:

                    // 車両リース代

                    GroupNo = (int)GroupName_ConstructionLedger.VehicleLeaseFee;

                    break;

                case (int)CommonDefine.CostDataNo.StoragePlace:

                    // 駐車場・資材置き場

                    GroupNo = (int)GroupName_ConstructionLedger.ParkingCosts;

                    break;

                case (int)CommonDefine.CostDataNo.Lodging:

                    // 宿泊費

                    GroupNo = (int)GroupName_ConstructionLedger.RoomChargeCosts;

                    break;

            }

            return GroupNo;

        }

        #endregion

        #region 工事詳細台帳より支払金額グリッドの先頭カラム数を取得する

        /// <summary>

        /// 工事詳細台帳より支払金額グリッドの先頭カラム数を取得する

        /// </summary>

        private static void GetLedgerColumnCount()

        {

            FrmConstructionLedger frm = new FrmConstructionLedger();

            try

            {

                m_LedgerColumnCount = frm.GetGridColumsCount - 1;

            }

            catch (System.Exception ex)

            {

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

            }

            finally

            {

                frm.Dispose(); frm = null;

            }

        }

        #endregion

        #region 個人毎経費データから工事詳細台帳の工事毎のデータ再計算更新処理

        /// <summary>

        /// 個人毎経費データから工事詳細台帳の工事毎のデータ再計算更新処理

        /// </summary>

        /// <param name="PersonCode"></param>

        /// <param name="TargetMonth"></param>

        /// <returns></returns>

        public static bool UpdateRecalLedgerDataFromTAndPCost(int PersonCode, string TargetMonth)

        {

            IOCostDataOfPerson CostDB = new IOCostDataOfPerson();

            FrmConstructionLedger frm = new FrmConstructionLedger();

            try

            {

                string strSQL = "SELECT PERSONCODE, TO_CHAR(ACTIONDATE,'YYYY/MM'), CONSTRUCTIONCODE FROM COSTDATAOFPERSON";

                strSQL += String.Format(" WHERE PERSONCODE = {0} AND TO_CHAR(ACTIONDATE,'YYYY/MM') = '{1}'", PersonCode, TargetMonth);

                strSQL += " GROUP BY PERSONCODE, TO_CHAR(ACTIONDATE,'YYYY/MM'), CONSTRUCTIONCODE";

                strSQL += " ORDER BY CONSTRUCTIONCODE";

                ArrayList arList = new ArrayList();

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

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

                bool bInit = true;

                foreach (object[] wrkobj in arList)

                {

                    int ConstructionCode = CommonMotions.cnvInt(wrkobj[2]);

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

                    if (ConstructionCode == 0) continue;

                    // 工事コードのセット

                    frm.ConstructionCode = ConstructionCode;

                    if (bInit)

                    {

                        // 見えない画面を出す

                        frm.Show();

                        // フォーム非表示

                        frm.Visible = false;

                        bInit = false;

                    }

                    // 再計算処理

                    bool bret = frm.RecalculateLedger;

                }

                // 画面を閉じる

                frm.Close();

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

            finally

            {

                CostDB.close(); CostDB = null;

                frm.Dispose(); frm = null;

            }

            return true;

        }

        #endregion

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

        /// <summary>

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

        /// </summary>

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

        /// <returns></returns>

        public static bool MakingLedgerData(int ConstructionCode)

        {

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

            FrmConstructionLedger frm = new FrmConstructionLedger();

            try

            {

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

                if (ConstructionCode == 0) return false;

                // 工事詳細台帳データが既にあれば作成しない

                string strExists = LedgerDB.CreatePrimarykeyString(ConstructionCode);

                List<ConstructionLedger> LedgerList = new List<ConstructionLedger>();

                LedgerDB.SelectAction(strExists, ref LedgerList);

                if (LedgerList.Count > 0) return true;

                // 工事コードのセット

                frm.ConstructionCode = ConstructionCode;

                // 見えない画面を出す

                frm.WindowState = FormWindowState.Minimized;

                frm.Show();

                // フォーム非表示

                frm.Visible = false;

                // データ作成処理

                if (!frm.SaveLedgerData)

                {

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

                    return false;

                }

                // 画面を閉じる

                frm.Close();

                return true;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

            finally

            {

                frm.Dispose(); frm = null;

                LedgerDB.close(); LedgerDB = null;

            }

        }

        #endregion

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

        /// <summary>

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

        /// </summary>

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

        /// <returns></returns>

        public static bool AddingLedgerData(int ConstructionCode)

        {

            IOConstructionLink LinkDB = new IOConstructionLink();

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

            FrmConstructionLedger frm = new FrmConstructionLedger();

            try

            {

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

                if (ConstructionCode == 0) return false;

                // 親の工事を探す

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

                ConstructionLink LinkRec = new ConstructionLink();

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

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

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

                ConstructionLedger LedgerList = new ConstructionLedger();

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

                // 工事コードのセット

                frm.ConstructionCode = LinkRec.ConstructionCode;

                // 見えない画面を出す

                frm.WindowState = FormWindowState.Minimized;

                frm.Show();

                // フォーム非表示

                frm.Visible = false;

                // データを追加する

                frm.AddingConstrCode = ConstructionCode;

                if (!frm.AddDataLedger)

                {

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

                    return false;

                }

                // データ作成処理

                if (!frm.SaveLedgerData)

                {

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

                    return false;

                }

                // 画面を閉じる

                frm.Close();

                return true;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

            finally

            {

                frm.Dispose(); frm = null;

                LedgerDB.close(); LedgerDB = null;

                LinkDB.close(); LinkDB = null;

            }

        }

        #endregion

    }

}

        public int SelectMaxConstructionCodeCount(string AddSQLString, bool bConnect = true)

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace ProcessManagement.DataModel

{

    /// <summary>

    /// 部署経費率マスタ

    /// </summary>

    public class DepartmentExpensesMaster

    {

        #region メンバ変数

        private int         m_DepartmentCode = 0;	            // 工事種別コード

        private int         m_NameCode = 0;	                    // 経費区分コード

        private int         m_DisplayOrder = 0;	                // 表示順

        private double      m_ExpensesRatio = 0;	            // 経費率

        private int         m_DeleteFlg = 0;	                // 削除フラグ

        private DateTime    m_EntryDate = DateTime.Now;         // 登録日付

        private DateTime    m_UpdateDate = DateTime.Now;        // 更新日付

        #endregion

        #region コンストラクタ

        #endregion

        #region プロパティ

        /// <summary>

        /// 区分コード

        /// </summary>

        public int DepartmentCode

        {

            get { return m_DepartmentCode; }

            set { m_DepartmentCode = value; }

        }

        /// <summary>

        /// 名称コード

        /// </summary>

        public int NameCode

        {

            get { return m_NameCode; }

            set { m_NameCode = value; }

        }

        /// <summary>

        /// 表示順

        /// </summary>

        public int DisplayOrder

        {

            get { return m_DisplayOrder; }

            set { m_DisplayOrder = value; }

        }

        /// <summary>

        /// 経費率

        /// </summary>

        public double ExpensesRatio

        {

            get { return m_ExpensesRatio; }

            set { m_ExpensesRatio = value; }

        }

        /// <summary>

        /// 削除フラグ

        /// </summary>

        public int DeleteFlg

        {

            get { return m_DeleteFlg; }

            set { m_DeleteFlg = value; }

        }

        /// <summary>

        /// 登録日付

        /// </summary>

        public DateTime EntryDate

        {

            set { m_EntryDate = value; }

            get { return m_EntryDate; }

        }

        /// <summary>

        /// 更新日付

        /// </summary>

        public DateTime UpdateDate

        {

            set { m_UpdateDate = value; }

            get { return m_UpdateDate; }

        }

        #endregion

    }

}

                    // 1:??Z????????F

                    // 2:??Z?\?Z?????F

                    // 3:?H???\?Z?????F

                    // 4:?????????F

                    // 5:?????????F

                    // 6:?H??????F

        #region ?I???{?^??

        /// <summary>

        /// ?H???I???{?^??????

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void btnDataSelect_Click(object sender, EventArgs e)

        {

            // ?f?[?^??????????????

            if (dgvMaster.RowCount == 0) return;

            if (CommonMotions.chkCellBlank(dgvMaster.CurrentRow.Cells[(int)DispColumn.ConstructionName].Value)) return;

            // ?e?????N??

            SubProcessExecute(CommonMotions.cnvIntFromStringCode(dgvMaster.CurrentRow.Cells[(int)DispColumn.ConstructionCode].Value.ToString(), "-"));

        }

        #endregion

            SubProcessExecute(CommonMotions.cnvIntFromStringCode(dgvMaster.CurrentRow.Cells[(int)DispColumn.ConstructionCode].Value.ToString(), "-"));

            this.btnDataSelect = new System.Windows.Forms.Button();

            // btnDataSelect

            // 

            this.btnDataSelect.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));

            this.btnDataSelect.BackColor = System.Drawing.Color.Green;

            this.btnDataSelect.ForeColor = System.Drawing.Color.White;

            this.btnDataSelect.Location = new System.Drawing.Point(10, 619);

            this.btnDataSelect.Name = "btnDataSelect";

            this.btnDataSelect.Size = new System.Drawing.Size(120, 30);

            this.btnDataSelect.TabIndex = 6;

            this.btnDataSelect.Text = "工事を選択";

            this.btnDataSelect.UseVisualStyleBackColor = false;

            this.btnDataSelect.Visible = false;

            this.btnDataSelect.Click += new System.EventHandler(this.btnDataSelect_Click);

            // 

            this.Column2});

            this.Controls.Add(this.btnDataSelect);

        private System.Windows.Forms.Button btnDataSelect;

        private System.Windows.Forms.RadioButton radioButton2;

        private System.Windows.Forms.RadioButton radioButton1;

        private void SubProcessExecute(int para_ConstructionCode = 0)

            wrkFormat += ", TO_CHAR(A2.PRINTOUTDATE, 'YYYY/MM/DD')";

        private void GetPrintCount(int TargetCode, ref int AllCount, ref int PrintCount)

            IOPurchaseOrder OrderDB = new IOPurchaseOrder();

                strSQL += string.Format(" (SELECT COUNT(*) FROM PURCHASEORDER A1 WHERE CONSTRUCTIONCODE = {0}) A,", TargetCode);

                strSQL += string.Format(" (SELECT COUNT(*) FROM PURCHASEORDER B1 WHERE CONSTRUCTIONCODE = {0} AND PRINTOUTDATE != TO_DATE('0001/01/01')) B", TargetCode);

                AllCount = CommonMotions.cnvInt(objRec[0]);

            finally

            {

                OrderDB.close(); OrderDB = null;

            }

                            //DateTime wrkDate = CommonMotions.cnvDate(objwrk[(int)GetData.PRINTOUTDATE]);

                            int PrintCount=0;

                            GetPrintCount(ConstrCode, ref AllCount, ref PrintCount);

                    //strStatus = string.Empty;

                    //strSalesDepName[1] = string.Empty;

                    //strSalesName[1] = string.Empty;

                    //strConstDepName[1] = string.Empty;

                    //strConstName[1] = string.Empty;

                                        , CommonMotions.cnvString(objwrk[(int)GetData.CONSTRUCTIONNAME])

                btnDataSelect.Left = btnDataEntry.Left;

        private void CalcExpenese()

        {

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

            IOConstructionLedgerDetail LedgerDDB = new IOConstructionLedgerDetail();

            IOConstructionLedgerExcute LedgerEDB = new IOConstructionLedgerExcute();

            FrmConstructionLedger frm = new FrmConstructionLedger();

            try

            {

                LedgerDB.connect(); LedgerDB.beginTran();

                LedgerDDB.connect();LedgerDDB.beginTran();

                LedgerEDB.connect(); LedgerEDB.beginTran();

                // 経費率のセット

                string strSQL1 = "SELECT A.CONSTRUCTIONCODE, E.DETAILSTRING, F.DEPARTMENTSTRING, A.LINECOUNT, A.FIRSTSTRING";

                strSQL1 += ", A.EXECUTIONAMOUNT, A.AMOUNTCONFIGRATE, B.CONSTRUCTIONPERIOD, C.DEPARTMENTCODE, D.NAMECODE";

                strSQL1 += ", D.EXPENSESRATIO, ROUND(B.ORDERSDECISIONPRICE * (A.AMOUNTCONFIGRATE / 100.0)), G.NAMESTRING";

                strSQL1 += " FROM CONSTRUCTIONLEDGERDETAIL A, CONSTRUCTIONBASEINFO B, PERSONINCHARGEMASTER C, DEPARTMENTEXPENSESMASTER D, CONSTRUCTIONBASEINFODETAIL E, DEPARTMENTMASTER F, DIVISIONMASTER G";

                strSQL1 += " WHERE A.CONSTRUCTIONCODE <> 2015043401";

                strSQL1 += " AND A.GROUPCOUNT = 1";

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

                strSQL1 += " AND B.CONSTRUCTIONPERIOD = 16";

                strSQL1 += " AND B.CONSTRUCTIONPERSONCODE = C.PERSONCODE";

                strSQL1 += " AND (C.DEPARTMENTCODE = D.DEPARTMENTCODE AND B.CONSTRUCTIONPERIOD = D.EXPENSESPERIOD AND D.DISPLAYORDER = (A.LINECOUNT - 1))";

                strSQL1 += " AND E.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE AND E.DETAILNO = 2";

                strSQL1 += " AND F.DEPARTMENTCODE = C.DEPARTMENTCODE";

                strSQL1 += " AND G.DIVISIONCODE = 3";

                strSQL1 += " AND G.NAMECODE = D.NAMECODE";

                strSQL1 += " ORDER BY A.CONSTRUCTIONCODE, A.LINECOUNT";

                ArrayList arList = new ArrayList();

                if (!LedgerDB.ExecuteReader(strSQL1, ref arList, false)) return;

                foreach (object[] CurRec in arList)

                {

                    int CurConstrCode = CommonMotions.cnvInt(CurRec[(int)Read1Enum.CONSTRUCTIONCODE]);

                    int CurLineCnt = CommonMotions.cnvInt(CurRec[(int)Read1Enum.LINECOUNT]);

                    int CurCompnentCode = CommonMotions.cnvInt(CurRec[(int)Read1Enum.NAMECODE]);

                    double CurParcent = CommonMotions.cnvDouble(CurRec[(int)Read1Enum.EXPENSESRATIO]);

                    int CurValue = CommonMotions.cnvInt(CurRec[(int)Read1Enum.EXPENESE]);

                    string strValue = CommonMotions.cnvString(CurRec[(int)Read1Enum.EXPENESENAME]) + string.Format("({0}%)", CurParcent.ToString("0.00"));

                    // 項目名

                    if (!LedgerDDB.UpdateFeild(CurConstrCode, (int)IOConstructionLedgerDetail.DataColumn.FirstString, strValue, 1, CurLineCnt, false))

                    {

                        LedgerDDB.rollback();

                        return;

                    }

                    // 実行金額

                    if (!LedgerDDB.UpdateFeild(CurConstrCode, (int)IOConstructionLedgerDetail.DataColumn.ExecutionAmount, CurValue, 1, CurLineCnt, false))

                    {

                        LedgerDDB.rollback();

                        return;

                    }

                    // 経費率セット

                    if (!LedgerDDB.UpdateFeild(CurConstrCode, (int)IOConstructionLedgerDetail.DataColumn.AmountConfigRate, CurParcent, 1, CurLineCnt, false))

                    {

                        LedgerDDB.rollback();

                        return;

                    }

                    // 経費コード

                    if (!LedgerDDB.UpdateFeild(CurConstrCode, (int)IOConstructionLedgerDetail.DataColumn.ComponentCode, CurCompnentCode, 1, CurLineCnt, false))

                    {

                        LedgerDDB.rollback();

                        return;

                    }

                }

                string strSQL2 = "SELECT A.CONSTRUCTIONCODE, A.TYINGFLG, B.CONSTRUCTIONCODE, B.LINECOUNT, B.DataCnt,";

                strSQL2 += " C.CONSTRUCTIONCODE, C.GROUPCOUNT, C.LINECOUNT, C.COLUMNCOUNT,";

                strSQL2 += " ROUND(A.ORDERSDECISIONPRICE * (D.AMOUNTCONFIGRATE / 100.0))";

                strSQL2 += " FROM CONSTRUCTIONBASEINFO A,";

                strSQL2 += " (SELECT CONSTRUCTIONCODE, LINECOUNT, COUNT(*) DataCnt FROM CONSTRUCTIONLEDGEREXCUTE WHERE GROUPCOUNT = 1 GROUP BY CONSTRUCTIONCODE, LINECOUNT) B,";

                strSQL2 += " CONSTRUCTIONLEDGEREXCUTE C,";

                strSQL2 += " CONSTRUCTIONLEDGERDETAIL D";

                strSQL2 += " WHERE A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE";

                strSQL2 += " AND A.CONSTRUCTIONCODE <> 2015043401";

                strSQL2 += " AND B.DataCnt = 1";

                strSQL2 += " AND C.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE";

                strSQL2 += " AND C.GROUPCOUNT = 1";

                strSQL2 += " AND C.LINECOUNT = B.LINECOUNT";

                strSQL2 += " AND D.CONSTRUCTIONCODE = C.CONSTRUCTIONCODE";

                strSQL2 += " AND D.GROUPCOUNT = C.GROUPCOUNT";

                strSQL2 += " AND D.LINECOUNT = C.LINECOUNT";

                strSQL2 += " ORDER BY C.CONSTRUCTIONCODE, C.GROUPCOUNT, C.LINECOUNT, C.COLUMNCOUNT";

                ArrayList arList2 = new ArrayList();

                if (!LedgerEDB.ExecuteReader(strSQL2, ref arList2, false))

                {

                    LedgerDDB.rollback();

                    return;

                }

                foreach (object[] CurRec in arList2)

                {

                    int CONSTRUCTIONCODE = CommonMotions.cnvInt(CurRec[0]);

                    int TYINGFLG = CommonMotions.cnvInt(CurRec[1]);

                    int CONSTRUCTIONCODE2 = CommonMotions.cnvInt(CurRec[2]);

                    int LINECOUNT = CommonMotions.cnvInt(CurRec[3]);

                    int DataCnt = CommonMotions.cnvInt(CurRec[4]);

                    int CONSTRUCTIONCODE3 = CommonMotions.cnvInt(CurRec[5]);

                    int GROUPCOUNT = CommonMotions.cnvInt(CurRec[6]);

                    int LINECOUNT2 = CommonMotions.cnvInt(CurRec[7]);

                    int COLUMNCOUNT = CommonMotions.cnvInt(CurRec[8]);

                    int iValue =CommonMotions.cnvInt(CurRec[9]);

                    if (!LedgerEDB.UpdateFeild(CONSTRUCTIONCODE3, GROUPCOUNT, LINECOUNT2, COLUMNCOUNT, (int)IOConstructionLedgerExcute.TableColumn.PaymentAmount, iValue, false))

                    {

                        LedgerDDB.rollback();

                        return;

                    }

                }

                LedgerDB.commit();

                LedgerDDB.commit();

                LedgerEDB.commit();

                string strSQL3 = "SELECT A.CONSTRUCTIONCODE FROM CONSTRUCTIONLEDGER A, CONSTRUCTIONBASEINFO B";

                strSQL3 += " WHERE A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE";

                strSQL3 += " AND B.CONSTRUCTIONPERIOD = 16";

                strSQL3 += " ORDER BY A.CONSTRUCTIONCODE";

                ArrayList arList3 = new ArrayList();

                if (!LedgerDB.ExecuteReader(strSQL3, ref arList3)) return;

                foreach (object[] CurRec in arList3)

                {

                    // 工事コードのセット

                    frm.ConstructionCode = CommonMotions.cnvInt(CurRec[0]);

                    // 見えない画面を出す

                    frm.Hide();

                    // フォーム非表示

                    //frm.Visible = false;

                    // 再計算処理

                    if (!frm.RecalculateLedger) break;

                }

                // 画面を閉じる

                frm.Close();

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                LedgerDB.close(); LedgerDB = null;

                LedgerDDB.close(); LedgerDDB = null;

                LedgerEDB.close(); LedgerEDB = null;

                frm.Dispose(); frm = null;

            }

        }

                    // 日報結合

                    if (!JoiningDairyData(LinkDB, DailyData1, DailyData2, DailyData3, DailyData4, DailyData5, DailyData6))

                    {

                        MessageBox.Show("工事日報結合処理に失敗しました。", "日報結語エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                        // エラー時工事情報を削除する

                        JoinRollBackDataProc(BaseDB, DetailDB, LinkDB, LedgerDB, LedgerDDB, ExcuteDB, DateCodeList, m_ConstructionCode);

                        ClsChangeLedgerData.PseudoRollBackForBudgetData(m_ConstructionCode, DateCodeList);

                        return false;

                    }

                    // 日報結合

                    if (!JoiningDairyData(LinkDB, DailyData1, DailyData2, DailyData3, DailyData4, DailyData5, DailyData6))

                    {

                        MessageBox.Show("工事日報結合処理に失敗しました。", "日報結語エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                        ClsChangeLedgerData.PseudoRollBackForBudgetData(m_ConstructionCode, DateCodeList);

                        // エラー時工事情報を削除する

                        JoinRollBackDataProc(BaseDB, DetailDB, LinkDB, LedgerDB, LedgerDDB, ExcuteDB, DateCodeList, m_ConstructionCode);

                        return false;

                    }

                string strRemove = string.Empty;