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

        #region 旧機密管理

        #endregion

        public static Color[] ApprovalBackStatusColor = new Color[] { Color.Blue, Color.Yellow, Color.MediumSpringGreen, Color.Red, Color.LightSkyBlue, Color.LightBlue };

        public static Color[] ApprovalForeStatusColor = new Color[] { Color.White, Color.Black, Color.Black, Color.Black, Color.Black, Color.Black };

        public static int s_SystemVersion = 15;

            CostomerRegistList = 33,            // 33:発注者登録申請一覧

            CostomerRegist = 34,                // 34:発注者登録申請

                                                                                { (int)ProcessExecuteNo.CostomerRegistList,     "発注者登録申請一覧"},

                        case (int)ProcessExecuteNo.CostomerRegistList:                  // 33:発注者登録申請一覧

                            ProcessExecuteNo_CostomerRegistList(m_ProcControlPara[NowPoint]);

                            break;

                        case (int)ProcessExecuteNo.CostomerRegist:                      // 34:発注者登録申請

                if (CurrentPara.DateExecParameter.Count > 0)

                    frm.OrdertDate = CurrentPara.DateExecParameter[0];

        #region 発注者登録申請一覧

        /// 発注者登録申請一覧

        public static void ProcessExecuteNo_CostomerRegistList(ProcessParameter CurrentPara)

            }

            catch (Exception ex)

            {

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

                BackProcess();

            }

            finally

            {

                frm.Dispose(); frm = null;

            }

        }

        #endregion

        #region 発注者登録申請一覧

        /// <summary>

        /// 発注者登録申請一覧

        /// </summary>

        /// <param name="CurrentPara"></param>

        public static void ProcessExecuteNo_CostomerRegist(ProcessParameter CurrentPara)

        {

            //　発注者登録申請

            FrmCostomerRegist frm = new FrmCostomerRegist();

            try

            {

                // 自分のハンドルをリストへセットする

                int ProcessNo = (int)ClsExcute.ProcessExecuteNo.DRWork;

                ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = ProcessNo;

                ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = (Form)frm;

                // 起動・編集フラグ

                int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference;

                if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg))

                {

                    BackProcess();

                    return;

                }

                if (EditFlg == (int)CommonDefine.ProcessDataEdit.Reference) frm.EditLock = true;

                // パラメータセット

                frm.PersonCode = CurrentPara.IntExecParameter[0];

                frm.CreateDate = CurrentPara.DateExecParameter[0];

                frm.SeqNo = CurrentPara.IntExecParameter[1];

                // フォーム表示

                frm.ShowDialog();

                frm.OrderDate = CurrentPara.DateExecParameter[0];

                if (CurrentPara.DateExecParameter.Count > 1) frm.DataSearchDate = CurrentPara.DateExecParameter[1];

                if (CurrentPara.IntExecParameter.Count > 3) frm.DataSearchSeqNo = CurrentPara.IntExecParameter[3];

            ///  申請日

            /// </summary>

            OrderDate,

            /// <summary>

            strcmd += " ,OrderDate";                                        // 申請日

                strcmd += "(";

                bool bFirst = true;

                foreach (var gender in Enum.GetValues(typeof(DataColumn)))

                {

                    if (!bFirst) strcmd += " ,";

                    strcmd += gender.ToString();

                    bFirst = false;

                }

                strcmd += ") VALUES (";

                strcmd += string.Format(", TO_DATE('{0}','YYYY/MM/DD')"

                                            , work.OrderDate.ToShortDateString());      // 申請日

                strcmd += string.Format(" ,AttendanceMonth = TO_DATE('{0}','YYYY/MM/DD')", data.AttendanceMonth.ToShortDateString());   // 出勤管理年月

                strcmd += string.Format(" ,OrderDate = TO_DATE('{0}','YYYY/MM/DD')", data.OrderDate.ToShortDateString());   // 申請日

                    case (int)DataColumn.OrderDate:

                        strcmd += string.Format(" OrderDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());

                        break;

                wrk.OrderDate = DateTime.Parse(objwrk[(int)DataColumn.OrderDate].ToString());               // 申請日

                strcmd += "(";

        public string CreatePrimarykeyString(int ConstructionCode, int GroupCount = 0, int LineCount = 0, string Alias = "")

                string strAlias = string.Empty;

                if (Alias.Length != 0) strAlias = string.Format("{0}.", Alias);

                strWork = string.Format(" Where {0}ConstructionCode = {1}", strAlias, ConstructionCode);

                    strWork += string.Format(" And {0}GroupCount = {1}", strAlias, GroupCount);

                    strWork += string.Format(" And {0}LineCount = {1}", strAlias, LineCount);

            PersonCode = 0,

            CreateDate,

            OrderDate,

            strcmd += "  PersonCode";

            strcmd += " ,TO_CHAR(CreateDate, 'YYYY/MM/DD')";

            strcmd += " ,TO_CHAR(OrderDate, 'YYYY/MM/DD')";

                strcmd += string.Format("  {0}", work.PersonCode);

                strcmd += string.Format(", TO_DATE('{0}','YYYY/MM/DD')", work.CreateDate.ToShortDateString());

                strcmd += string.Format(", TO_DATE('{0}','YYYY/MM/DD')", work.OrderDate.ToShortDateString());

                strcmd += string.Format(" PersonCode = {0}", data.PersonCode);

                strcmd += string.Format(", CreateDate = TO_DATE('{0}','YYYY/MM/DD')", data.CreateDate.ToShortDateString());

                strcmd += string.Format(", OrderDate = TO_DATE('{0}','YYYY/MM/DD')", data.OrderDate.ToShortDateString());

        public bool UpdateFeild(int PersonCode, DateTime CreateDate, int SeqNo, int FeildNo, object value, bool bConnect = true)

                    case (int)DataColumn.PersonCode:

                        strcmd += string.Format(" PersonCode = {0}", ((int)value).ToString());

                    case (int)DataColumn.CreateDate:

                        strcmd += string.Format(" CreateDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());

                        break;

                    case (int)DataColumn.OrderDate:

                        strcmd += string.Format(" OrderDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());

                        break;

                strcmd += CreatePrimarykeyString(PersonCode, CreateDate, SeqNo);

                wrk.PersonCode = int.Parse(objwrk[(int)DataColumn.PersonCode].ToString());

                wrk.CreateDate = DateTime.Parse(objwrk[(int)DataColumn.CreateDate].ToString());

                wrk.OrderDate = DateTime.Parse(objwrk[(int)DataColumn.OrderDate].ToString());

        public string CreatePrimarykeyString(int PersonCode, DateTime CaretaDate, int SeqNo = 0)

                strWork = string.Format(" WHERE PersonCode = {0}", PersonCode);

                if (CaretaDate != DateTime.MinValue)

                    strWork += string.Format(" AND CreateDate = TO_DATE('{0}','YYYY/MM/DD')", CaretaDate.ToShortDateString());

            SecRank,

            ExpensesLink,

        #region 名称マスタ検索ＳＱＬ作成

        /// 名称マスタ検索ＳＱＬ作成

            strcmd += ",SecRank";

            strcmd += ",ExpensesLink";

        #endregion

        #region 名称マスタ検索（複数件）

        /// <summary>

        /// 名称マスタ検索（複数件）

        /// </summary>

        /// <param name="AddSQLString"></param>

        /// <param name="data"></param>

        /// <param name="bConnect"></param>

        /// <returns></returns>

        #endregion

        #region 名称マスタ検索（１件）

        /// <summary>

        /// 名称マスタ検索（１件）

        /// </summary>

        /// <param name="AddSQLString"></param>

        /// <param name="data"></param>

        /// <param name="bConnect"></param>

        /// <returns></returns>

        #region 名称マスタ追加（１件）

                strcmd += "(";

                bool bFirst = true;

                foreach (var gender in Enum.GetValues(typeof(NameColumn)))

                {

                    if (!bFirst) strcmd += " ,";

                    strcmd += gender.ToString();

                    bFirst = false;

                }

                strcmd += ") VALUES (";

                strcmd += string.Format("  {0}", work.TypeCode);

                strcmd += string.Format(", {0}", work.DisplayOrder);

                strcmd += string.Format(",'{0}'", work.NameString);

                strcmd += string.Format(", {0}", work.PublicFlg);

                strcmd += string.Format(", {0}", work.SecRank);

                strcmd += string.Format(", {0}", work.ExpensesLink);

                strcmd += string.Format(", {0}", work.DeleteFlg);

        #endregion

        #region 名称マスタ追加（複数件）

        /// <summary>

        /// 名称マスタ追加（複数件）

        /// </summary>

        /// <param name="data"></param>

        /// <param name="bConnect"></param>

        /// <returns></returns>

        #region 名称マスタ更新

                strcmd += string.Format(" TypeCode = {0}", data.TypeCode);

                strcmd += string.Format(",DisplayOrder = {0}", data.DisplayOrder);

                strcmd += string.Format(",NameString = '{0}'", data.NameString);

                strcmd += string.Format(",PublicFlg = {0}", data.PublicFlg);

                strcmd += string.Format(",SecRank = {0}", data.SecRank);

                strcmd += string.Format(",ExpensesLink = {0}", data.ExpensesLink);

                strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg);

                wrk.SecRank = int.Parse(objwrk[(int)NameColumn.SecRank].ToString());

                wrk.ExpensesLink = int.Parse(objwrk[(int)NameColumn.ExpensesLink].ToString());

        #region 種別コードの最大値を取得する

        #endregion

        #region 表示順の最大値を取得する

        #endregion

        #region 主キー検索の文字列を返す

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Collections;

using log4net;

using Oracle.ManagedDataAccess.Client;

using ProcessManagement.DB.Oracle;

using ProcessManagement.DB.Core;

using ProcessManagement.DataModel;

using ProcessManagement.Common;

namespace ProcessManagement.DB.IOAccess

{

    /// <summary>

    /// 工事種別経費率マスタアクセスクラス

    /// </summary>

    public class IOMTypeExpenses : OracleProcess

    {

        #region 定義部

        /// <summary>

        /// log4netログを使用する

        /// </summary>

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

        #endregion

        #region 定数

        /// <summary>

        /// 経費率マスタフィールド並び

        /// </summary>

        public enum NameColumn

        {

            TypeCode = 0,

            ExpensesPeriod,

            NameCode,

            ExpensesRate,

            DeleteFlg,

            EntryDate,

            UpdateDate,

        }

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

        /// <param name="ConnectionString"></param>

        public IOMTypeExpenses()

            : base(DBCommon.Instance.DBConnectString)

        {

        }

        #endregion

        #region 経費率マスタ検索SQL作成

        /// <summary>

        /// 経費率マスタ検索SQL作成

        /// </summary>

        /// <param name="AddSQLString">検索条件SQL文字列</param>

        /// <param name="data">経費率マスタデータ</param>

        /// <returns>true：成功 false：失敗</returns>

        private string CreateSelectSQL()

        {

            string strcmd = "SELECT";

            strcmd += " TypeCode";

            strcmd += " ,ExpensesPeriod";

            strcmd += " ,NameCode";

            strcmd += " ,ExpensesRate";

            strcmd += " ,DeleteFlg";

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

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

            strcmd += " FROM TypeExpensesMaster";

            return strcmd;

        }

        #endregion

        #region データ検索（複数件）

        /// <summary>

        /// データ検索（複数件）

        /// </summary>

        /// <param name="AddSQLString"></param>

        /// <param name="data"></param>

        /// <param name="bConnect"></param>

        /// <returns></returns>

        public bool SelectAction(string AddSQLString, ref List<TypeExpensesMaster> data, bool bConnect = true)

        {

            //Oracle インターフェース

            string strcmd = "";

            ArrayList arData = new ArrayList();

            try

            {

                // SQL作成（oracleのDateTime型が変換できないのでCharに変換しておく）

                strcmd = CreateSelectSQL() + AddSQLString;

                // SQL実行

                if (!ExecuteReader(strcmd, ref arData, bConnect)) return false;

                // データセット

                foreach (object[] objwrk in arData)

                {

                    TypeExpensesMaster work = new TypeExpensesMaster();

                    Reader2Struct(objwrk, ref work);

                    data.Add(work);

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region データ検索（１件）

        /// <summary>

        /// データ検索（１件）

        /// </summary>

        /// <param name="AddSQLString"></param>

        /// <param name="data"></param>

        /// <param name="bConnect"></param>

        /// <returns></returns>

        public bool SelectAction(string AddSQLString, ref TypeExpensesMaster data, bool bConnect = true)

        {

            //Oracle インターフェース

            string strcmd = "";

            ArrayList arData = new ArrayList();

            try

            {

                // SQL作成（oracleのDateTime型が変換できないのでCharに変換しておく）

                strcmd = CreateSelectSQL() + AddSQLString;

                // SQL実行

                if (!ExecuteReader(strcmd, ref arData, bConnect)) return false;

                if (arData.Count == 0) return false;

                // データセット

                foreach (object[] objwrk in arData)

                {

                    Reader2Struct(objwrk, ref data);

                    break;

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 経費率マスタ追加（１件）

        /// <summary>

        /// 経費率マスタ追加（１件）

        /// </summary>

        /// <param name="data">経費率マスタデータ</param>

        /// <returns>true：成功 false：失敗</returns>

        public bool InsertAction(TypeExpensesMaster work, bool bConnect = true)

        {

            string strcmd = "";

            try

            {

                strcmd = "INSERT INTO TypeExpensesMaster";

                strcmd += "(";

                bool bFirst = true;

                foreach (var gender in Enum.GetValues(typeof(NameColumn)))

                {

                    if (!bFirst) strcmd += " ,";

                    strcmd += gender.ToString();

                    bFirst = false;

                }

                strcmd += ") VALUES (";

                strcmd += string.Format("  {0}", work.TypeCode.ToString());

                strcmd += string.Format(", {0}", work.ExpensesPeriod.ToString());

                strcmd += string.Format(", {0}", work.NameCode.ToString());

                strcmd += string.Format(", {0}", work.ExpensesRate.ToString());

                strcmd += string.Format(", {0}", work.DeleteFlg.ToString());

                strcmd += ", TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

                strcmd += ", TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

                strcmd = strcmd + ")";

                if (!ExecuteNonQuery(strcmd, bConnect)) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 経費率マスタ追加（複数件）

        /// <summary>

        /// 経費率マスタ追加

        /// </summary>

        /// <param name="data">経費率マスタデータ</param>

        /// <returns>true：成功 false：失敗</returns>

        public bool InsertAction(List<TypeExpensesMaster> data, bool bConnect = true)

        {

            string strcmd = "";

            try

            {

                foreach (TypeExpensesMaster work in data)

                {

                    if (!InsertAction(work, bConnect)) return false;

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 経費率マスタ更新

        /// <summary>

        /// 経費率マスタ更新

        /// </summary>

        /// <param name="AddSQLString">更新条件SQL文字列</param>

        /// <param name="data">経費率マスタデータ</param>

        /// <returns>true：成功 false：失敗</returns>

        public bool UpdateAction(string AddSQLString, TypeExpensesMaster data, bool bConnect = true)

        {

            string strcmd = "";

            try

            {

                strcmd = "UPDATE TypeExpensesMaster";

                strcmd += " SET";

                strcmd += string.Format(" TypeCode = {0}", data.TypeCode.ToString());

                strcmd += string.Format(",ExpensesPeriod = {0}", data.ExpensesPeriod.ToString());

                strcmd += string.Format(",NameCode = {0}", data.NameCode.ToString());

                strcmd += string.Format(",ExpensesRate = {0}", data.ExpensesRate.ToString());

                strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString());

                strcmd += ", UpdateDate = TO_DATE(TO_CHAR(sysdate,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS')";

                strcmd += AddSQLString;

                if (!ExecuteNonQuery(strcmd, bConnect)) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 経費率マスタ削除

        /// <summary>

        /// 経費率マスタ削除

        /// </summary>

        /// <param name="AddSQLString">削除条件SQL文字列</param>

        /// <param name="data">経費率マスタデータ</param>

        /// <returns>true：成功 false：失敗</returns>

        public bool DeleteAction(string AddSQLString, bool bConnect = true)

        {

            //Oracle インターフェース

            string strcmd = "";

            try

            {

                strcmd = string.Format("{0}{1}", "DELETE FROM TypeExpensesMaster", AddSQLString);

                if (!ExecuteNonQuery(strcmd, bConnect)) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 論理削除

        /// <summary>

        /// 論理削除

        /// </summary>

        /// <param name="NameCode">名称コード</param>

        /// <returns>成功時：true　失敗時：false</returns>

        public bool LogicalDeleteAction(int NameCode, bool bConnect = true)

        {

            // Where文字列作成

            string strWhere = CreatePrimarykeyString(NameCode);

            try

            {

                List<TypeExpensesMaster> workList = new List<TypeExpensesMaster>();

                // データ読込

                if (SelectAction(strWhere, ref workList, bConnect))

                {

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

                    // 削除フラグ

                    workList[0].DeleteFlg = 1;

                    // データ更新

                    if (!UpdateAction(strWhere, workList[0], bConnect))

                    {

                        rollback();

                        return false;

                    }

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region OracleDataReaderより構造体へセットする

        /// <summary>

        /// OracleDataReaderより構造体へセットする

        /// </summary>

        /// <param name="reader">OracleDataReader</param>

        /// <param name="wrk">構造体</param>

        public void Reader2Struct(object[] objwrk, ref TypeExpensesMaster wrk)

        {

            try

            {

                // データ取得

                wrk.TypeCode = int.Parse(objwrk[(int)NameColumn.TypeCode].ToString());

                wrk.ExpensesPeriod = int.Parse(objwrk[(int)NameColumn.ExpensesPeriod].ToString());

                wrk.NameCode = int.Parse(objwrk[(int)NameColumn.NameCode].ToString());

                wrk.ExpensesRate = double.Parse(objwrk[(int)NameColumn.ExpensesRate].ToString());

                wrk.DeleteFlg = int.Parse(objwrk[(int)NameColumn.DeleteFlg].ToString());

                wrk.EntryDate = DateTime.Parse(objwrk[(int)NameColumn.EntryDate].ToString());

                wrk.UpdateDate = DateTime.Parse(objwrk[(int)NameColumn.UpdateDate].ToString());

            }

            catch (OracleException oraex)

            {

                logger.ErrorFormat("オラクルエラー：{0}：{1}", CommonMotions.GetMethodName(), oraex.Message);

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 区分別の最大値を取得する

        /// <summary>

        /// 区分別の最大値を取得する

        /// </summary>

        /// <param name="AddSQLString"></param>

        /// <param name="bConnect"></param>

        /// <returns></returns>

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

        {

            //Oracle インターフェース

            string strcmd = "";

            ArrayList arData = new ArrayList();

            int iRet = 0;

            try

            {

                // SQL作成

                strcmd = "SELECT NVL(MAX(NameCode), 0) FROM TypeExpensesMaster" + AddSQLString;

                // SQL実行

                if (!ExecuteReader(strcmd, ref arData, bConnect)) return iRet;

                // データセット

                foreach (object[] objwrk in arData)

                {

                    if (objwrk[0].ToString().Equals(""))

                        iRet = 0;

                    else

                        iRet = int.Parse(objwrk[0].ToString());

                }

            }

            catch (Exception ex)

            {

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

            }

            return iRet;

        }

        #endregion

        #region 主キー検索の文字列を返す

        /// <summary>

        /// 主キー検索の文字列を返す

        /// </summary>

        /// <param name="NameCode">名称コード</param>

        /// <returns>Where文字列</returns>

        public string CreatePrimarykeyString(int TypeCode, int Period = 0, int NameCode = 0, string Alias = "")

        {

            string strWork = string.Empty;

            try

            {

                string strAlias = string.Empty;

                if (Alias.Length != 0) strAlias = string.Format("{0}.", Alias);

                strWork = string.Format(" Where {0}TypeCode = {1}", strAlias, TypeCode);

                if (Period != 0)

                    strWork += string.Format(" And {0}ExpensesPeriod = {1}", strAlias, Period);

                if (NameCode != 0)

                    strWork += string.Format(" And {0}NameCode = {1}", strAlias, NameCode);

            }

            catch (Exception ex)

            {

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

            }

            return strWork;

        }

        #endregion

    }

}

        ///  申請日

        /// </summary>

        private DateTime    m_OrderDate = DateTime.MinValue;

        /// <summary>

        ///  申請日

        /// </summary>

        public DateTime OrderDate

        {

            get { return m_OrderDate; }

            set { m_OrderDate = value; }

        }

        /// <summary>

        private int         m_SecRank = 0;                      // 保護区分ランク

        private int         m_ExpensesLink = 0;                 // 経費使用区分

        /// 保護区分ランク

        /// </summary>

        public int SecRank

        {

            get { return m_SecRank; }

            set { m_SecRank = value; }

        }

        /// <summary>

        /// 経費使用区分

        /// </summary>

        public int ExpensesLink

        {

            get { return m_ExpensesLink; }

            set { m_ExpensesLink = value; }

        }

        /// <summary>

        private int         m_PersonCode = 0;                       // 申請者番号

        private DateTime    m_CreateDate = DateTime.Now;            // 作成日

        private int         m_CorporateStatusPoint = 0;	            // 法人格名称位置

        private DateTime    m_OrderDate = DateTime.MinValue;        // 申請日

        /// 申請者番号

        public int PersonCode

            get { return m_PersonCode; }

            set { m_PersonCode = value; }

        /// 作成日

        /// </summary>

        public DateTime CreateDate

        {

            get { return m_CreateDate; }

            set { m_CreateDate = value; }

        }

        /// <summary>

        /// 申請日

        /// </summary>

        public DateTime OrderDate

        {

            get { return m_OrderDate; }

            set { m_OrderDate = value; }

        }

        /// <summary>

        /// <summary>

        /// 日付値パラメータ

        /// </summary>

        private List<DateTime> m_DateParameter = new List<DateTime>();

        /// 日付値パラメータ

        /// </summary>

        public List<DateTime> DateExecParameter

        {

            get { return m_DateParameter; }

            set { m_DateParameter = value; }

        }

        /// <summary>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace ProcessManagement.DataModel

{

    /// <summary>

    /// 工事種別経費率マスタ

    /// </summary>

    public class TypeExpensesMaster

    {

        #region メンバ変数

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

        private int         m_ExpensesPeriod = 0;               // 事業期

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

        private double      m_ExpensesRate = 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 TypeCode

        {

            get { return m_TypeCode; }

            set { m_TypeCode = 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 double ExpensesRate

        {

            get { return m_ExpensesRate; }

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

    }

}

        #region ?\???E??\???E????{?^????u

        /// <summary>

        /// ?\???E??\???E????{?^????u

        /// </summary>

        Point[] s_ButtonPosition = new Point[] { new Point(6, 58), new Point(258, 58), new Point(510, 58) };

        #endregion

        /// ???????t?L?[

        private DateTime m_SearchDate = DateTime.MinValue;

        /// ?????}??L?[

        /// </summary>

        private int m_SearchSeqNo = 0;

        /// <summary>

        /// ???????t?L?[

        public DateTime DataSearchDate

            get { return m_SearchDate; }

            set { m_SearchDate = value; }

        /// <summary>