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

        public static double s_SalaryCorrection = 1.1;

        #region 工事詳細台帳：台帳入力完了フラグ

        /// 工事詳細台帳：台帳入力完了フラグ

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

        /// <summary>

        /// 工事詳細台帳：増減工事フラグ

        /// </summary>

        public enum FluctuatesFlg

        {

            /// <summary>

            /// 0:通常データ

            /// </summary>

            Normal =0,

            /// <summary>

            /// 1:増減データ

            /// </summary>

            Fluctuates,

        }

        #endregion

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/10/06  Ver1.0.0.0      Create Source           

//

//

//

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

namespace ProcessManagement.Common

{

    /// <summary>

    /// 工事基本情報データ変更クラス

    /// </summary>

    public static class ClsChangeBaseInfoData

    {

        #region ログ定義

        /// <summary>

        /// log4netログを使用する

        /// </summary>

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

        #endregion

        #region 定数

        #endregion

        #region 変数

        #endregion

        #region 工事詳細台帳入力完了日セット処理

        /// <summary>

        /// 工事詳細台帳入力完了日セット処理

        /// </summary>

        /// <param name="SetDate"></param>

        /// <returns></returns>

        public static bool SetLedgerComplateDate(int ConstrCode, DateTime SetDate)

        {

            IOConstructionBaseInfo BaseDB = new IOConstructionBaseInfo();

            try

            {

                // 工事詳細台帳入力完了日をセットする

                if (!BaseDB.UpdateFeild(ConstrCode, (int)IOConstructionBaseInfo.TableColumn.LEDGERCOMPLATEDATE, SetDate)) return false;

                return true;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

            finally

            {

                BaseDB.close(); BaseDB = null;

            }

        }

        #endregion

    }

}

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

{

    /// <summary>

    /// 工事詳細台帳データ変更クラス

    /// </summary>

    public static class ClsChangeLedgerData

    {

        #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");

                // 経過月数を取得する

                //TimeSpan ts = NowDates - LedgerRec.ConstructionStart;

                //int DiffMonth = ts.GetTimeSpanMonths();

                int DiffMonth = (LedgerRec.ConstructionStart.Month + (LedgerRec.ConstructionStart.Year - NowDates.Year) * 12) - NowDates.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)FrmConstructionLedger.DataGroup.TransportationCosts;

                    break;

                case (int)CommonDefine.CostDataNo.Purchase:

                    // 購入品

                    GroupNo = (int)FrmConstructionLedger.DataGroup.PurchaseCosts;

                    break;

                case (int)CommonDefine.CostDataNo.Lease:

                    // 車両リース代

                    GroupNo = (int)FrmConstructionLedger.DataGroup.VehicleLeaseFee;

                    break;

                case (int)CommonDefine.CostDataNo.StoragePlace:

                    // 駐車場・資材置き場

                    GroupNo = (int)FrmConstructionLedger.DataGroup.ParkingCosts;

                    break;

                case (int)CommonDefine.CostDataNo.Lodging:

                    // 宿泊費

                    GroupNo = (int)FrmConstructionLedger.DataGroup.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.Hide();

                        // フォーム非表示

                        //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;

                bool bSuccess = true;

                // データ作成処理

                if (!frm.SaveLedgerData) bSuccess = false;

                // 画面を閉じる

                frm.Close();

                return bSuccess;

            }

            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.Hide();

                // データを追加する

                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

        #region 工事詳細台帳データに対象行の支払い給与を計算する

        /// <summary>

        /// 工事詳細台帳データに対象行の支払い給与を計算する

        /// </summary>

        /// <param name="ConstrCode">工事番号</param>

        /// <param name="TargetDate">対象日</param>

        /// <param name="bSetFlag">月一括セットフラグ</param>

        /// <returns></returns>

        public static bool CalculatePayment(int ConstrCode, DateTime TargetDate, bool bSetFlag = false)

        {

            IOConstructionLedger LedgerDB = new IOConstructionLedger();

            IOConstructionLedgerDetail LedgerDeDB = new IOConstructionLedgerDetail();

            IOConstructionLedgerExcute LedgerExDB = new IOConstructionLedgerExcute();

            IOMPersonInCharge PersonDB = new IOMPersonInCharge();

            FrmConstructionLedger frm = new FrmConstructionLedger();

            try

            {

                // 工事詳細台帳データ取得

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

                string LedgerSQL = LedgerDB.CreatePrimarykeyString(ConstrCode);

                if (!LedgerDB.SelectAction(LedgerSQL, ref LedgerList) || LedgerList.Count == 0) return false;

                // 工事詳細台帳明細データ取得

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

                string DetailSQL = LedgerDeDB.CreatePrimarykeyString(ConstrCode);

                DetailSQL += string.Format(" AND OperatingFlg = {0}", (int)CommonDefine.SalaryOperateKind.Oparateing);  // 対応中フラグ

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

                                                                (int)FrmConstructionLedger.DataGroup.Instructor,   // 指導員給料

                                                                (int)FrmConstructionLedger.DataGroup.Assistant,    // 副担当者給料

                                                                (int)FrmConstructionLedger.DataGroup.Payroll);     // 担当者給料行

                if (!LedgerDeDB.SelectAction(DetailSQL, ref DetailList) || DetailList.Count == 0) return false;

                // 対象月より書込みカラム位置を取得する

                int ColPoint = CalcTargetMonthToColumn(LedgerList[0].ConstructionStart, TargetDate);

                // 対象月の開始日・終了日を取得する

                DateTime dtStart = DateTimeUtil.BeginOfMonth(TargetDate);

                DateTime dtLast = DateTimeUtil.EndOfMonth(TargetDate);

                // 開始月は開始月を入れる

                if (LedgerList[0].ConstructionStart.Year == dtStart.Year

                    && LedgerList[0].ConstructionStart.Month == dtStart.Month) dtStart = LedgerList[0].ConstructionStart;

                // 当月は今日より大きい場合は今日を入れる

                if (DateTime.Now.Year == dtLast.Year

                    && DateTime.Now.Month == dtLast.Month

                    && DateTime.Now.Day < dtLast.Day) dtLast = DateTime.Now;

                // 終了月は終了日を入れる

                if (LedgerList[0].ConstructionEnd.Year == dtLast.Year

                    && LedgerList[0].ConstructionEnd.Month == dtLast.Month

                    && LedgerList[0].ConstructionEnd.Day < dtLast.Day) dtLast = LedgerList[0].ConstructionEnd;

                //// 稼働日数を取得する

                //int WorkingDay = ClsCalendar.CalcOperatingDaysCount(dtStart, dtLast);

                // 経過日数を取得する

                int WorkingDay = ClsCalendar.CalcPassedDaysCount(dtStart, dtLast);

                LedgerExDB.connect(); LedgerExDB.beginTran();

                PersonDB.connect(); PersonDB.beginTran();

                bool LoopBreak = false;

                foreach (ConstructionLedgerDetail CurRec in DetailList)

                {

                    // コードが担当者ではない場合は処理しない

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

                    // コードがない場合は処理しない

                    if (CurRec.CompanyCode == 0) continue;

                    // 施工管理中担当者ではない場合は処理しない

                    if (CurRec.OperatingFlg == (int)CommonDefine.SalaryOperateKind.Complate) continue;

                    // 1日分の給与を取得する

                    //double dSaraly = Get1DaysSalaryForOperating(PersonDB, CurRec.CompanyCode);

                    double dSaraly = Get1DaysSalaryForFixed(PersonDB, CurRec.CompanyCode, CurRec.GroupCount);

                        switch (CurRec.SalaryFlg)

                        {

                            case (int)CommonDefine.SalaryDevision.All:          // 全日振分

                                // 指定日までの稼働日数を掛けた値をセットする

                                dSaraly *= WorkingDay;

                                break;

                            case (int)CommonDefine.SalaryDevision.Noting:       // 振分無

                                // 給与振分無

                                dSaraly = 0;

                                LoopBreak = true;

                                break;

                            case (int)CommonDefine.SalaryDevision.DaysInput:    // 日数入力

                                // 日当加算判定を行う

                                if (CheckPaymentValue(CurRec))

                                {

                                    // 日数分掛ける

                                    dSaraly *= CurRec.SalaryDays;

                                }

                                else

                                {

                                    dSaraly = 0;

                                }

                                LoopBreak = true;

                                break;

                            default:

                                break;

                        }

                    DateTime ParaDate = new DateTime(TargetDate.Year, TargetDate.Month, 1);

                    // 支払いデータ書込み

                    if (!AddOrSetSalary(LedgerExDB

                                    , ConstrCode, CurRec.GroupCount, CurRec.LineCount, ColPoint, (int)dSaraly, ParaDate))

                    {

                        LedgerExDB.rollback();

                        return false;

                    }

                }

                // DB Commit

                LedgerExDB.commit();

                bool bret = true;

                // 工事コードのセット

                frm.ConstructionCode = ConstrCode;

                // 見えない画面を出す

                frm.Hide();

                // フォーム非表示

                //frm.Visible = false;

                // 再計算処理

                bret = frm.RecalculateLedger;

                // 画面を閉じる

                frm.Close();

                // データ初期セット時に振分無・日数入力は次のループをしない

                if (bSetFlag && LoopBreak) bret = false;

                return bret;

            }

            catch (Exception ex)

            {

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

                return false;

            }

            finally

            {

                LedgerDB.close(); LedgerDB = null;

                LedgerDeDB.close(); LedgerDeDB = null;

                LedgerExDB.close(); LedgerExDB = null;

                PersonDB.close(); PersonDB = null;

                frm.Dispose(); frm = null;

            }

        }

        #endregion

        #region 日次処理での日当の加算を判定する

        /// <summary>

        /// 日次処理での日当の加算を判定する

        /// </summary>

        /// <param name="CurRec"></param>

        /// <returns></returns>

        private static bool CheckPaymentValue(ConstructionLedgerDetail CurRec)

        {

            IOConstructionLedgerExcute ExcuteDB = new IOConstructionLedgerExcute();

            try

            {

                // 支払いデータより合計金額を取得する

                ArrayList arList = new ArrayList();

                string ExcuteSQL = "SELECT SUM(PAYMENTAMOUNT) FROM CONSTRUCTIONLEDGEREXCUTE";

                ExcuteSQL += string.Format(" WHERE CONSTRUCTIONCODE = {0}", CurRec.ConstructionCode);

                ExcuteSQL += string.Format(" AND GROUPCOUNT = {0}", CurRec.GroupCount);

                ExcuteSQL += string.Format(" AND LINECOUNT = {0}", CurRec.LineCount);

                if (!ExcuteDB.ExecuteReader(ExcuteSQL, ref arList) || arList.Count == 0) return false;

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

                int TotalVal = CommonMotions.cnvInt(wrkobj[0]);

                bool bRet = false;

                if (TotalVal < CurRec.ExecutionAmount) bRet = true;

                return bRet;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 平均稼働数より1日分の給与を取得する

        /// <summary>

        /// 平均稼働数より1日分の給与を取得する

        /// </summary>

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

        /// <returns></returns>

        private static double Get1DaysSalaryForOperating(IOMPersonInCharge PersonDB, int PersonCode, int GroupCount)

        {

            try

            {

                int monthSalary = 0;

                if (GroupCount == (int)FrmConstructionLedger.DataGroup.Payroll)

                {   // 担当者給与の場合

                    // 担当者マスタより給与月額を取得する

                    string strPerson = PersonDB.CreatePrimarykeyString(PersonCode);

                    PersonInChargeMaster personRec = new PersonInChargeMaster();

                    PersonDB.SelectAction(strPerson, ref personRec, false);

                    // 出勤補正値係数を掛ける

                    monthSalary = CommonMotions.cnvRound(personRec.MonthlySalary * (double)CommonDefine.s_SalaryCorrection);

                }

                else if (GroupCount == (int)FrmConstructionLedger.DataGroup.Instructor)

                {

                    // 指導員月額を取得する

                    monthSalary = CommonDefine.InstructorMonthryCost;

                }

                else if (GroupCount == (int)FrmConstructionLedger.DataGroup.Assistant)

                {

                    // 副担当者月額を取得する

                    monthSalary = CommonDefine.AssistantMonthryCost;

                }

                // 計算値を月稼働日数で割る

                double daylySalary = monthSalary / CommonDefine.s_WorkingDaysOfMonth;

                return daylySalary;

            }

            catch (Exception ex)

            {

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

                return 0;

            }

        }

        #endregion

        #region 月工数より1日分の給与を取得する

        /// <summary>

        /// 月工数より1日分の給与を取得する

        /// </summary>

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

        /// <returns></returns>

        private static double Get1DaysSalaryForFixed(IOMPersonInCharge PersonDB, int PersonCode, int GroupCount)

        {

            try

            {

                int monthSalary = 0;

                if (GroupCount == (int)FrmConstructionLedger.DataGroup.Payroll)

                {   // 担当者給与の場合

                    // 担当者マスタより給与月額を取得する

                    string strPerson = PersonDB.CreatePrimarykeyString(PersonCode);

                    PersonInChargeMaster personRec = new PersonInChargeMaster();

                    PersonDB.SelectAction(strPerson, ref personRec, false);

                    // 出勤補正値係数を掛ける

                    monthSalary = CommonMotions.cnvRound(personRec.MonthlySalary * (double)CommonDefine.s_SalaryCorrection);

                }

                else if (GroupCount == (int)FrmConstructionLedger.DataGroup.Instructor)

                {

                    // 指導員月額を取得する

                    monthSalary = CommonDefine.InstructorMonthryCost;

                }

                else if (GroupCount == (int)FrmConstructionLedger.DataGroup.Assistant)

                {

                    // 副担当者月額を取得する

                    monthSalary = CommonDefine.AssistantMonthryCost;

                }

                // 計算値を月工数日数で割る

                double daylySalary = CommonMotions.cnvRound(monthSalary / CommonDefine.s_ManHourUnitMonth);

                return daylySalary;

            }

            catch (Exception ex)

            {

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

                return 0;

            }

        }

        #endregion

        #region 詳細台帳に指定金額を設定するか足しこむ

        /// <summary>

        /// 詳細台帳に指定金額を設定するか足しこむ

        /// </summary>

        /// <param name="LedgerExDB">詳細台帳支払いデータ</param>

        /// <param name="ConstrCode">工事番号</param>

        /// <param name="GroupCount">グループ番号</param>

        /// <param name="LineCount">行番号</param>

        /// <param name="ColumnCount">列番号</param>

        /// <param name="DaySalary">給与金額</param>

        /// <param name="ColumnDate">対象月</param>

        /// <param name="bSetFlag">セットフラグ</param>

        /// <returns></returns>

        private static bool AddOrSetSalary(IOConstructionLedgerExcute LedgerExDB

                                    , int ConstrCode, int GroupCount, int LineCount, int ColumnCount

                                    , int DaySalary, DateTime ColumnDate)

        {

            try

            {

                // キー作成

                string strSQL = LedgerExDB.CreatePrimarykeyString(ConstrCode, GroupCount, LineCount, ColumnCount);

                strSQL += string.Format(" AND TargetMonth = TO_DATE('{0}','YYYY/MM/DD')", ColumnDate.ToShortDateString());

                // データ読込み

                List<ConstructionLedgerExcute> LedgerExDBList = new List<ConstructionLedgerExcute>();

                ConstructionLedgerExcute LedgerExDBRec = new ConstructionLedgerExcute();

                bool ReadData = LedgerExDB.SelectAction(strSQL, ref LedgerExDBList, false);

                if (!ReadData || LedgerExDBList.Count == 0)

                {

                    LedgerExDBRec.ConstructionCode = ConstrCode;	// 工事コード

                    LedgerExDBRec.GroupCount = GroupCount;          // グループ番号

                    LedgerExDBRec.LineCount = LineCount;            // 行番号

                    LedgerExDBRec.ColumnCount = ColumnCount;        // 列番号

                    LedgerExDBRec.PaymentAmount = DaySalary;        // 支払金額

                    LedgerExDBRec.TargetMonth = ColumnDate;         // 対象年月

                    // データ作成

                    bool bSaccess = LedgerExDB.InsertAction(LedgerExDBRec, false);

                    if (bSaccess) return true;

                    else return false;

                }

                // データ更新

                if (!LedgerExDB.UpdateFeild(ConstrCode, GroupCount, LineCount, ColumnCount

                                            , (int)IOConstructionLedgerExcute.TableColumn.PaymentAmount, DaySalary, false)) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 対象年月から工事詳細台帳のグリッドカラム位置を算出する

        /// <summary>

        /// 対象年月から工事詳細台帳のグリッドカラム位置を算出する

        /// </summary>

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

        /// <returns></returns>

        private static int CalcTargetMonthToColumn(DateTime StartDate, DateTime TargetMonth)

        {

            FrmConstructionLedger frm = new FrmConstructionLedger();

            int Columncnt = frm.GetGridColumsCount - 1;

            try

            {

                // 処理対象年月日を対象月月初日に変換する

                DateTime NowDates = DateTimeUtil.BeginOfMonth(TargetMonth);

                // 開始年月日を開始年月月初日に変換する

                DateTime StartMonth = DateTimeUtil.BeginOfMonth(StartDate);

                // 経過月数を取得する

                //TimeSpan ts = NowDates - StartDate;

                //int DiffMonth = ts.GetTimeSpanMonths();

                int DiffMonth = (TargetMonth.Month + (TargetMonth.Year - StartDate.Year) * 12) - StartDate.Month;

                // 列番号取得

                Columncnt += DiffMonth;

                return Columncnt;

            }

            catch (Exception ex)

            {

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

                return Columncnt;

            }

            finally

            {

                frm.Dispose(); frm = null;

            }

        }

        #endregion

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace ProcessManagement.DataModel

{

    /// <summary>

    /// 部署経費率マスタ

    /// </summary>

    public class DepartmentExpenses

    {

        #region メンバ変数

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

        private int         m_ExpensesPeriod = 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 ExpensesPeriod

        {

            get { return m_ExpensesPeriod; }

            set { m_ExpensesPeriod = 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

    }

}

                                                            " FROM CONSTRUCTIONBASEINFO A" };

        private static string[] s_SQLPart2 = new string[] { " LEFT JOIN (SELECT CA.CONSTRUCTIONCODE, CA.SALESPERSONCODE PERSONCODE, CB.PERSONNAME PERSONNAME,",

                                                            " FROM CONSTRUCTIONBASEINFO CA",

                                                            " LEFT JOIN PERSONINCHARGEMASTER CB ON CA.SALESPERSONCODE = CB.PERSONCODE",

                                                            " LEFT JOIN DEPARTMENTMASTER CC ON CB.DEPARTMENTCODE = CC.DEPARTMENTCODE",

                                                            " WHERE CA.CONSTRUCTIONPERIOD = {0}) C ON A.CONSTRUCTIONCODE = C.CONSTRUCTIONCODE" };

        private static string[] s_SQLPart3 = new string[] { " LEFT JOIN (SELECT DA.CONSTRUCTIONCODE, DA.CONSTRUCTIONPERSONCODE PERSONCODE, DB.PERSONNAME PERSONNAME,",

                                                            " FROM CONSTRUCTIONBASEINFO DA",

                                                            " LEFT JOIN PERSONINCHARGEMASTER DB ON DA.CONSTRUCTIONPERSONCODE = DB.PERSONCODE",

                                                            " LEFT JOIN DEPARTMENTMASTER DC ON DB.DEPARTMENTCODE = DC.DEPARTMENTCODE",

                                                            " WHERE DA.CONSTRUCTIONPERIOD = {0}) D ON A.CONSTRUCTIONCODE = D.CONSTRUCTIONCODE",

                                                            ", CONSTRUCTIONBASEINFODETAIL B" };

        private static string[] s_SQLPart5 = new string[] { " ORDER BY A.CONSTRUCTIONSTATUSFLG ASC, C.DEPDISPORDER ASC, C.MANDISPORDER ASC,",

            for (int i = 0; i < s_SQLPart5.Length; i++) strSQL += s_SQLPart5[i];

            for (int i = 0; i < s_SQLPart5.Length; i++) strSQL += s_SQLPart5[i];

            //for (int i = 0; i < s_SQLPart5.Length; i++) wrkFormat += s_SQLPart5[i];

        #region ?????H?????????z???v????????

        /// <summary>

        /// ?????H?????????z???v????????

        /// </summary>

        /// <param name="cbiDB"></param>

        /// <param name="work"></param>

        private int FluctuationDataOrdersPrice(IOConstructionBaseInfo cbiDB)

        {

            try

            {

                int iCode1 = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?? ?? ??")).Key;

                string strSQL = "SELECT SUM(ORDERSDECISIONPRICE) FROM CONSTRUCTIONBASEINFO";

                strSQL += string.Format(" WHERE (TRUNC(CONSTRUCTIONCODE / 100) = {0})", (int)(m_ConstructionCode / 100));

                strSQL += string.Format(" AND CONSTRUCTIONSTATUSFLG != {0})", iCode1);

                strSQL += " GROUP BY TRUNC(CONSTRUCTIONCODE / 100)";

                ArrayList Arlist = new ArrayList();

                if (!cbiDB.ExecuteReader(strSQL, ref Arlist, false)) return 0;

                if (Arlist.Count == 0) return 0;

                object[] objCur = (object[])Arlist[0];

                return CommonMotions.cnvInt(objCur[0]);

            }

            catch (System.Exception ex)

            {

                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);

                return 0;

            }

        }

        #endregion

        #region ???^???z?v?Z????

        /// <summary>

        /// ???^???z?v?Z????

        /// </summary>

        /// <param name="MonthryCost"></param>

        /// <param name="OrdersDecisionPrice"></param>

        /// <param name="ConstructionStart"></param>

        /// <param name="ConstructionEnd"></param>

        /// <param name="ExecutionAmount"></param>

        /// <param name="AmountConfigRate"></param>

        private void CalcPayValueData(double MonthryCost, double OrdersDecisionPrice, DateTime ConstructionStart, DateTime ConstructionEnd,

                                        ref double ExecutionAmount, ref double AmountConfigRate)

        {

            try

            {

                if (OrdersDecisionPrice == 0) return;

                // ?????v?Z

                double DairySalary = (MonthryCost * CommonDefine.s_SalaryCorrection) / CommonDefine.s_ManHourUnitMonth;

                // ??????v?Z

                int workingCount = ClsCalendar.CalcPassedDaysCount(ConstructionStart, ConstructionEnd);

                int iInput = CommonMotions.cnvRound(DairySalary * workingCount);                        // ???^?x?????z

                ExecutionAmount = iInput;                                                     // ???s???z

                AmountConfigRate = (iInput / OrdersDecisionPrice) * 100.0;          // ???z?\????

            }

            catch (Exception ex)

            {

                logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);

            }

        }

        #endregion

                    MessageBox.Show("????i?????t?f?[?^?o?^????s????????B", "?f?[?^???G???[", MessageBoxButtons.OK, MessageBoxIcon.Error);

        private bool BudgetDataChange(IOProcessApproval ApprovalDB,

                                        IOConstructionBudget BudgetDB,

                                        IOConstructionBudgetDetail BudgetDDB,

                                        IOMPersonInCharge PersonDB,

                                        int TotalOrdersPrice)

                if (!BudgetDetailDataSalarySet(frm, BudgetDDB, BudgetRec, TotalOrdersPrice

                                                    , (int)FrmConstructionBudget.DataGroup.PayrollExpenses, ConstrPersonCode, ConstrPersonName

                                                    , personRec.MonthlySalary, ExpensesList)) return false;

                if (!BudgetDetailDataSalarySet(frm, BudgetDDB, BudgetRec, TotalOrdersPrice

                                                    , (int)FrmConstructionBudget.DataGroup.AssistantCosts, AssistantCode, AssistantName

                                                    , CommonDefine.AssistantMonthryCost, ExpensesList)) return false;

                if (!BudgetDetailDataSalarySet(frm, BudgetDDB, BudgetRec, TotalOrdersPrice

                                                    , (int)FrmConstructionBudget.DataGroup.InstructorCosts, InstructorCode, InstructorName

                                                    , CommonDefine.InstructorMonthryCost, ExpensesList)) return false;

            /// <summary>

            /// ?o????R?[?h

            /// </summary>

            NameCode,

                string strSQL = "SELECT A.NAMESTRING, NVL(B.EXPENSESRATIO, 0), B.NAMECODE";

                MonthlySalary = CommonMotions.cnvRound(MonthlySalary * (double)CommonDefine.s_SalaryCorrection);

                    // ?o????R?[?h

                    work.ComponentCode = CommonMotions.cnvInt(wrkExpense[(int)ExpensesArray.NameCode]);

        #region ?H???\?Z???F?S????E???S????E?w?????Z?b?g

        /// ?H???\?Z???F?S????E???S????E?w?????Z?b?g

        /// <param name="frm"></param>

        /// <param name="BudgetDDB"></param>

        /// <param name="BudgetRec"></param>

        /// <param name="TotalOrdersPrice"></param>

        /// <param name="GroupNo"></param>

        /// <param name="ConstructorCode"></param>

        /// <param name="ConstructorName"></param>

        /// <param name="MonthryCost"></param>

        /// <param name="ExpensesList"></param>

        private bool BudgetDetailDataSalarySet(FrmConstructionBudget frm, IOConstructionBudgetDetail BudgetDDB, ConstructionBudget BudgetRec, int TotalOrdersPrice

                                                    , int GroupNo, int ConstructorCode, string ConstructorName

                                                    , double MonthryCost, ArrayList ExpensesList)

                string strSQL = BudgetDDB.CreatePrimarykeyString(m_ConstructionCode, GroupNo);

                // ???^???z?Z?b?g

                double ExecutionAmount = 0;

                double AmountConfigRate = 0;

                CalcPayValueData(MonthryCost, TotalOrdersPrice,

                                BudgetRec.ConstructionStart, BudgetRec.ConstructionEnd,

                                ref ExecutionAmount, ref AmountConfigRate);

                    DetailRec.OrderDesiredAmount = ExecutionAmount;

                    DetailRec.ExecutionAmount = ExecutionAmount;

                    DetailRec.AmountConfigRate = AmountConfigRate;

                    DetailRec.GroupCount = GroupNo;

                    frm.GetTitileParametar = GroupNo;