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

        public static void ChangeGridRow(DataGridViewEX dgv

                if (nDepCode > 0) strSQL.AppendFormat(" AND (B.DEPARTMENTCODE = {0})", nDepCode);

        public static int s_SystemVersion = 208;

            DepartmentCost = 46,                // 46:部署出納帳

                                                                                { (int)ProcessExecuteNo.DepartmentCost,         "部署出納帳" },

                        case (int)ProcessExecuteNo.DepartmentCost:                      // 46:部署出納帳

                            ProcessExecuteNo_DepartmentCost(m_ProcControlPara[NowPoint]);

                            break;

                    // 直接表示フラグのセット

                    if (CurrentPara.BoolExecParameter.Count > 1)

                    {

                        /// 新規申請フラグ

                        frm.NewApprovalFlg = CurrentPara.BoolExecParameter[1];

                    }

        #region 部署出納帳

        /// <summary>

        /// 部署出納帳

        /// </summary>

        /// <returns></returns>

        public static void ProcessExecuteNo_DepartmentCost(ProcessParameter CurrentPara)

        {

            //　部署出納帳一覧

            FrmDepCost frm = new FrmDepCost();

            try

            {

                // フォーム表示

                frm.ShowDialog();

            }

            catch (Exception ex)

            {

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

                BackProcess();

            }

            finally

            {

                frm.Dispose(); frm = null;

            }

        }

        #endregion

                        if (ExecCode != CurRec.ExecCode) continue;

                        bRet = true;

                        Editflg = CurRec.EditFlg;

                        break;

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Collections;

using log4net;

using MySql.Data.MySqlClient;           // Data Provider for MySql

using ProcessManagement.DB.MySql;

using ProcessManagement.DB.Core;

using ProcessManagement.DataModel;

using ProcessManagement.Common;

namespace ProcessManagement.DB.IOAccess

{

    /// <summary>

    /// 部署毎経費データＤＢアクセス

    /// </summary>

    public class IOCostDataOfDepartment : MySqlProcess

    {

        #region 定義部

        /// <summary>

        /// log4netログを使用する

        /// </summary>

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

        #endregion

        #region 定数

        /// <summary>

        /// 部署毎経費データフィールド並び

        /// </summary>

        public enum TableColumn

        {

            DepartmentCode = 0, // 部署コード

            ConstrYear,         // 工事期数・年数

            SeqNo,              // データ番号

            CostDate,           // 対象日付

            DepartmentName,     // 部署名

            SuppliersCode,      // 出納先コード

            SuppliersName,      // 出納先名称

            PaymentContent,     // 出納内容

            SendReceiveFlg,     // 出納フラグ

            EntryPrice,	        // 金額（税抜）

            EntryTax,           // 金額（税込）

            Coment,             // 備考

            EntryDate,

            UpdateDate,

        }

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

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

        public IOCostDataOfDepartment()

            : base(DBCommon.Instance.DBConnectString)

        {

        }

        #endregion

        #region SQL作成

        /// <summary>

        /// SQL作成

        /// </summary>

        private string CreateSelectSQL()

        {

            // SQL作成

            StringBuilder strcmd = new StringBuilder();

            strcmd.Append("SELECT");

            bool bColFirst = true;

            string strWork = string.Empty;

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

            {

                strWork = gender.ToString();

                if (!bColFirst) strcmd.Append(",");

                if (strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))

                {

                    strcmd.AppendFormat(" DATE_FORMAT({0}, '%Y/%m/%d %H:%i:%s')", strWork);

                }

                else if (strWork.Equals("CostDate"))

                {

                    strcmd.AppendFormat(" DATE_FORMAT({0}, '%Y/%m/%d')", strWork);

                }

                else

                {

                    strcmd.AppendFormat(" {0}", strWork);

                }

                bColFirst = false;

            }

            strcmd.Append(" FROM CostDataOfDepartment");

            return strcmd.ToString();

        }

        #endregion

        #region 複数読込み処理

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

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            ArrayList arData = new ArrayList();

            try

            {

                // SQL作成

                strcmd.Append(CreateSelectSQL());

                strcmd.Append(AddSQLString);

                // SQL実行

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

                // データセット

                foreach (object[] objwrk in arData)

                {

                    CostDataOfDepartment work = new CostDataOfDepartment();

                    Reader2Struct(objwrk, ref work);

                    data.Add(work);

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 1件読込み処理

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

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            ArrayList arData = new ArrayList();

            try

            {

                strcmd.Append(CreateSelectSQL());

                strcmd.Append(AddSQLString);

                // SQL実行

                if (!ExecuteReader(strcmd.ToString(), 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.ToString());

                return false;

            }

        }

        #endregion

        #region 1件追加処理

        /// <summary>

        /// 部署毎経費データ追加

        /// </summary>

        /// <param name="data">部署毎経費データデータ</param>

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

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                bool bColFirst = true;

                strcmd.Append("INSERT INTO CostDataOfDepartment");

                strcmd.Append(" (");

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

                {

                    if (!bColFirst) strcmd.Append(", ");

                    strcmd.Append(gender.ToString());

                    bColFirst = false;

                }

                strcmd.Append(") VALUES (");

                strcmd.AppendFormat("  {0}", work.DepartmentCode);                  // 部署コード

                strcmd.AppendFormat(", {0}", work.ConstrYear);                      // 工事期数・年数

                strcmd.AppendFormat(", {0}", work.SeqNo);                           // データ番号

                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d')"

                                            , work.CostDate.ToShortDateString());   // 対象日付

                strcmd.AppendFormat(",'{0}'", work.DepartmentName);                 // 部署名称

                strcmd.AppendFormat(", {0}", work.SuppliersCode);                   // 出納先コード

                strcmd.AppendFormat(",'{0}'", work.SuppliersName);                  // 出納先名称

                strcmd.AppendFormat(",'{0}'", work.PaymentContent);                 // 出納内容

                strcmd.AppendFormat(", {0}", work.SendReceiveFlg);                  // 出納フラグ

                strcmd.AppendFormat(", {0}", work.EntryPrice);	                    // 金額（税抜）

                strcmd.AppendFormat(", {0}", work.EntryTax);	                    // 金額（税込）

                strcmd.AppendFormat(",'{0}'", work.Coment);	                        // 備考

                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);

                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);

                strcmd.Append(")");

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

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 複数追加処理

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                bool bColFirst = true;

                strcmd.Append("INSERT INTO CostDataOfDepartment");

                strcmd.Append(" (");

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

                {

                    if (!bColFirst) strcmd.Append(", ");

                    strcmd.Append(gender.ToString());

                    bColFirst = false;

                }

                strcmd.Append(") VALUES");

                bool bDataFirst = true;

                foreach (CostDataOfDepartment work in data)

                {

                    if (bDataFirst) strcmd.Append(" (");

                    else strcmd.Append(", (");

                    strcmd.AppendFormat("  {0}", work.DepartmentCode);                  // 部署コード

                    strcmd.AppendFormat(", {0}", work.ConstrYear);                      // 工事期数・年数

                    strcmd.AppendFormat(", {0}", work.SeqNo);                           // データ番号

                    strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d')"

                                                , work.CostDate.ToShortDateString());   // 対象日付

                    strcmd.AppendFormat(",'{0}'", work.DepartmentName);                 // 部署名称

                    strcmd.AppendFormat(", {0}", work.SuppliersCode);                   // 出納先コード

                    strcmd.AppendFormat(",'{0}'", work.SuppliersName);                  // 出納先名称

                    strcmd.AppendFormat(",'{0}'", work.PaymentContent);                 // 出納内容

                    strcmd.AppendFormat(", {0}", work.SendReceiveFlg);                  // 出納フラグ

                    strcmd.AppendFormat(", {0}", work.EntryPrice);	                    // 金額（税抜）

                    strcmd.AppendFormat(", {0}", work.EntryTax);	                    // 金額（税込）

                    strcmd.AppendFormat(",'{0}'", work.Coment);                         // 備考

                    strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);

                    strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);

                    strcmd.Append(")");

                    bDataFirst = false;

                }

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

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 更新処理

        /// <summary>

        /// 部署毎経費データ更新

        /// </summary>

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

        /// <param name="data">部署毎経費データデータ</param>

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

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.Append("UPDATE CostDataOfDepartment");

                strcmd.Append(" SET");

                strcmd.AppendFormat(" DepartmentCode = {0}", data.DepartmentCode);          // 部署コード

                strcmd.AppendFormat(",ConstrYear = {0}", data.ConstrYear);                  // 工事期数・年数

                strcmd.AppendFormat(",SeqNo = {0}", data.SeqNo);                            // データ番号

                strcmd.AppendFormat(",CostDate = STR_TO_DATE('{0}','%Y/%m/%d')"

                                        , data.CostDate.ToShortDateString());               // 対象日付

                strcmd.AppendFormat(",DepartmentName = '{0}'", data.DepartmentName);        // 部署名称

                strcmd.AppendFormat(",SuppliersCode = {0}", data.SuppliersCode);            // 出納先コード

                strcmd.AppendFormat(",SuppliersName = '{0}'", data.SuppliersName);          // 出納先名称

                strcmd.AppendFormat(",PaymentContent = '{0}'", data.PaymentContent);        // 出納内容

                strcmd.AppendFormat(",SendReceiveFlg = {0}", data.SendReceiveFlg);          // 出納フラグ

                strcmd.AppendFormat(",EntryPrice = {0}", data.EntryPrice);                  // 金額（税抜）

                strcmd.AppendFormat(",EntryTax = {0}", data.EntryTax);                      // 金額（税込）

                strcmd.AppendFormat(",Coment = '{0}'", data.Coment);                        // 備考

                strcmd.Append(", UpdateDate = NOW()");

                strcmd.Append(AddSQLString);

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

                return true;

            }

            catch (Exception ex)

            {

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

                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)

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.AppendFormat("{0}{1}", "DELETE FROM CostDataOfDepartment", AddSQLString);

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

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region データセット処理

        /// <summary>

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

        /// </summary>

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

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

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

        {

            try

            {

                // データ取得

                wrk.DepartmentCode = int.Parse(objwrk[(int)TableColumn.DepartmentCode].ToString());         // 部署コード

                wrk.ConstrYear = int.Parse(objwrk[(int)TableColumn.ConstrYear].ToString());                 // 工事期数・年数

                wrk.SeqNo = int.Parse(objwrk[(int)TableColumn.SeqNo].ToString());                           // データ番号

                wrk.CostDate = DateTime.Parse(objwrk[(int)TableColumn.CostDate].ToString());                // 対象日付

                wrk.DepartmentName = objwrk[(int)TableColumn.DepartmentName].ToString();                    // 部署名称

                wrk.SuppliersCode = int.Parse(objwrk[(int)TableColumn.SuppliersCode].ToString());           // 出納先コード

                wrk.SuppliersName = objwrk[(int)TableColumn.SuppliersName].ToString();                      // 出納先名称

                wrk.PaymentContent = objwrk[(int)TableColumn.PaymentContent].ToString();                    // 出納内容

                wrk.SendReceiveFlg = int.Parse(objwrk[(int)TableColumn.SendReceiveFlg].ToString());         // 出納フラグ

                wrk.EntryPrice = CommonMotions.cnvDouble(objwrk[(int)TableColumn.EntryPrice]);              // 金額（税抜）

                wrk.EntryTax = CommonMotions.cnvDouble(objwrk[(int)TableColumn.EntryTax]);                  // 金額（税込）

                wrk.Coment = objwrk[(int)TableColumn.Coment].ToString();                                    // 備考

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

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

            }

            catch (MySqlException myex)

            {

                logger.ErrorFormat("ＭｙＳＱＬエラー：{0}：{1}", CommonMotions.GetMethodName(2), myex.Message);

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 検索文字列作成処理

        /// <summary>

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

        /// </summary>

        /// <param name="DepartmentCode"></param>

        /// <param name="CostDate"></param>

        /// <param name="DataType"></param>

        /// <param name="DataAddCount"></param>

        /// <returns></returns>

        public string CreatePrimarykeyString(int DepartmentCode, int ConstrYear = 0, int SeqNo = 0)

        {

            StringBuilder strWork = new StringBuilder();

            try

            {

                strWork.AppendFormat(" WHERE DepartmentCode = {0}", DepartmentCode);

                if (ConstrYear != 0)

                    strWork.AppendFormat(" AND ConstrYear = {0}", ConstrYear);

                if (SeqNo != 0)

                    strWork.AppendFormat(" AND SeqNo = {0}", SeqNo);

                return strWork.ToString();

            }

            catch (Exception ex)

            {

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

                return string.Empty;

            }

        }

        #endregion

        #region 追加番号の最大値を取得

        /// <summary>

        /// 追加番号の最大値を取得する

        /// </summary>

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

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

        /// <returns></returns>

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

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            ArrayList arData = new ArrayList();

            int iRet = 0;

            try

            {

                // SQL作成

                strcmd.AppendFormat("SELECT IFNULL(MAX(SeqNo), 0) FROM CostDataOfDepartment{0}", AddSQLString);

                // SQL実行

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

                // データセット

                foreach (object[] objwrk in arData)

                {

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

                        iRet = 0;

                    else

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

                }

            }

            catch (Exception ex)

            {

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

            }

            return iRet;

        }

        #endregion

    }

}

            StatutoryWelfareRate,   // 法定福利費比率

            strcmd.Append(", StatutoryWelfareRate");    // 法定福利費比率

                strcmd.AppendFormat(", {0}", work.StatutoryWelfareRate);    // 法定福利費比率

                    strcmd.AppendFormat(", {0}", work.StatutoryWelfareRate);    // 法定福利費比率

                strcmd.AppendFormat(", StatutoryWelfareRate = {0}", data.StatutoryWelfareRate); // 法定福利費比率

                    case (int)TableColumn.StatutoryWelfareRate: // 法定福利費比率

                        strcmd.AppendFormat(" StatutoryWelfareRate = {0}", ((double)value).ToString());

                        break;

                wrk.StatutoryWelfareRate = double.Parse(objwrk[(int)TableColumn.StatutoryWelfareRate].ToString());  // 法定福利費比率

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

namespace ProcessManagement.DataModel

{

    /// <summary>

    /// 部署毎経費データ

    /// </summary>

    public class CostDataOfDepartment

    {

        #region 定数

        #region 出納フラグ定義

        /// <summary>

        /// 出納フラグ定義

        /// </summary>

        public enum SendReceiveFlgDef

        {

            /// <summary>

            /// 支払データ

            /// </summary>

            Payment = -1,

            /// <summary>

            /// データ無し

            /// </summary>

            NonData = 0,

            /// <summary>

            /// 収入データ

            /// </summary>

            Revenue = 1,

        }

        #endregion

        #endregion

        #region メンバ変数

        /// <summary>

        /// 部署コード

        /// </summary>

        private int         m_DepartmentCode = 0;

        /// <summary>

        /// 工事期数・年数

        /// </summary>

        private int         m_ConstrYear = 0;

        /// <summary>

        /// データ番号

        /// </summary>

        private int         m_SeqNo = 0;

        /// <summary>

        /// 対象日付

        /// </summary>

        private DateTime    m_CostDate = DateTime.Now;

        /// <summary>

        /// 出納先コード

        /// </summary>

        private int         m_SuppliersCode = 0;

        /// <summary>

        /// 部署名

        /// </summary>

        private string      m_DepartmentName = string.Empty;

        /// <summary>

        /// 支払先名称

        /// </summary>

        private string      m_SuppliersName = string.Empty;

        /// <summary>

        /// 支払内容

        /// </summary>

        private string      m_PaymentContent = string.Empty;

        /// <summary>

        /// 出納フラグ

        /// </summary>

        private int         m_SendReceiveFlg = 0;

        /// <summary>

        /// 金額（税抜）

        /// </summary>

        private double      m_EntryPrice = 0;

        /// <summary>

        /// 金額（税込）

        /// </summary>

        private double      m_EntryTax = 0;

        /// <summary>

        /// 備考

        /// </summary>

        private string      m_Coment = string.Empty;

        /// <summary>

        /// 登録日付

        /// </summary>

        private DateTime    m_EntryDate = DateTime.Now;

        /// <summary>

        /// 更新日付

        /// </summary>

        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 ConstrYear

        {

            get { return m_ConstrYear; }

            set { m_ConstrYear = value; }

        }

        /// <summary>

        /// データ番号

        /// </summary>

        public int SeqNo

        {

            get { return m_SeqNo; }

            set { m_SeqNo = value; }

        }

        /// <summary>

        /// 対象日付

        /// </summary>

        public DateTime CostDate

        {

            get { return m_CostDate; }

            set { m_CostDate = value; }

        }

        /// <summary>

        /// 出納先コード

        /// </summary>

        public int SuppliersCode

        {

            get { return m_SuppliersCode; }

            set { m_SuppliersCode = value; }

        }

        /// <summary>

        /// 部署名

        /// </summary>

        public string DepartmentName

        {

            get { return m_DepartmentName; }

            set { m_DepartmentName = value; }

        }

        /// <summary>

        /// 支払先名称

        /// </summary>

        public string SuppliersName

        {

            get { return m_SuppliersName; }

            set { m_SuppliersName = value; }

        }

        /// <summary>

        /// 支払内容

        /// </summary>

        public string PaymentContent

        {

            get { return m_PaymentContent; }

            set { m_PaymentContent = value; }

        }

        /// <summary>

        /// 出納フラグ

        /// </summary>

        public int SendReceiveFlg

        {

            get { return m_SendReceiveFlg; }

            set { m_SendReceiveFlg = value; }

        }

        /// <summary>

        /// 金額（税抜）

        /// </summary>

        public double EntryPrice

        {

            get { return m_EntryPrice; }

            set { m_EntryPrice = value; }

        }

        /// <summary>

        /// 金額（税込）

        /// </summary>

        public double EntryTax

        {

            get { return m_EntryTax; }

            set { m_EntryTax = value; }

        }

        /// <summary>

        /// 備考

        /// </summary>

        public string Coment

        {

            get { return m_Coment; }

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

    }

}

    /// DataGridViewEX.Cell.styleメンバー退避クラス

        private double  m_StatutoryWelfareRate = 0.0;       // 法定福利費比率

        /// 法定福利費比率

        /// </summary>

        public double StatutoryWelfareRate

        {

            get { return m_StatutoryWelfareRate; }

            set { m_StatutoryWelfareRate = value; }

        }

        /// <summary>

//*---------------------------- 拡張ComboBoxEXコード --------------------------*

using log4net;

using log4net.Appender;

using log4net.Repository.Hierarchy;

using ProcessManagement.Common;

using System.Collections;

//*---------------------------- ?g??DataGridViewEX?R?[?h ------------------------*

        #region ?g?p??`

        //log4net???O???g?p????

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

        #endregion

            //this.RowTemplate.Height = 21;

            try

                // ?R?????g??t?H?[?J?X????????????????

                Form frmParent = FindForm();

                //if (frmParent.ActiveControl.GetType().Equals(typeof(MoveTextBox))

                //    || frmParent.ActiveControl.GetType().Equals(typeof(ShapeContainer))

                //    || frmParent.ActiveControl.GetType().Equals(typeof(LineShape))) return false;

                // Enter?L?[????????????ADownKey???????????????

                // ??I?s??Tab?L?[???????????????

                if ((keyData & Keys.KeyCode) == Keys.Enter)

                {

                    if (CurrentCell.RowIndex == (base.RowCount - 1))

                        return this.ProcessTabKey(keyData);

                    else

                        return this.ProcessDownKey(keyData);

                }

                return base.ProcessDialogKey(keyData);

            catch (Exception ex)

            {

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

                return false;

            }

            try

            {

                // ?R?????g??t?H?[?J?X????????????????

                Form frmParent = FindForm();

                //if (frmParent.ActiveControl.GetType().Equals(typeof(MoveTextBox))

                //    || frmParent.ActiveControl.GetType().Equals(typeof(ShapeContainer))

                //    || frmParent.ActiveControl.GetType().Equals(typeof(LineShape))) return false;

                //Enter?L?[????????????ATab?L?[???????????????

                if (e.KeyCode == Keys.Enter)

                {

                    //return this.ProcessTabKey(e.KeyCode);

                    return this.ProcessDownKey(e.KeyCode);

                }

                return base.ProcessDataGridViewKey(e);

            }

            catch (Exception ex)

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

                return false;

            try

            {

                DataGridViewEX dgv = (DataGridViewEX)(sender);

                int CurrentCellX = dgv.CurrentCellAddress.X;

                int CurrentCellY = dgv.CurrentCellAddress.Y;

                if (e.KeyCode == Keys.Delete || e.KeyCode == Keys.Back)

                {

                    foreach (DataGridViewCell c in dgv.SelectedCells)

                    {

                        if (((DataGridViewEX)sender).CurrentCell.ReadOnly == false)

                        {

                            // ?Z??????e??????

                            dgv[c.ColumnIndex, c.RowIndex].Value = "";

                        }

                    }

                }

                else if ((e.Modifiers & Keys.Control) == Keys.Control && e.KeyCode == Keys.V)

                {

                    // ?N???b?v?{?[?h????e????

                    String clipText = Clipboard.GetText();

                    // ???s????

                    clipText = clipText.Replace("\r\n", "\n");

                    clipText = clipText.Replace("\r", "\n");

                    // ???s?????

                    String[] lines = clipText.Split('\n');

                    int srcLineCnt;

                    Boolean nflag = true;

                    for (srcLineCnt = 0; srcLineCnt <= lines.GetLength(0) - 1; srcLineCnt++)

                    {

                        // ????NULL?s???R?s?[?????????

                        if (srcLineCnt >= lines.GetLength(0) - 1 && "".Equals(lines[srcLineCnt]) && nflag == false) break;

                        if ("".Equals(lines[srcLineCnt]) == false) nflag = false;

                        // ?^?u?????

                        String[] vals = lines[srcLineCnt].Split('\t');

                        // ?e?Z????l????

                        int srcCellCnt = 0;

                        int DestCellCnt = 0;

                        for (srcCellCnt = 0; srcCellCnt <= vals.GetLength(0) - 1; srcCellCnt++)

                        {

                            // ?Z???????????????\??t?????

                            if (!(CurrentCellX + DestCellCnt >= 0 && CurrentCellX + DestCellCnt < dgv.ColumnCount && CurrentCellY + srcLineCnt >= 0 && CurrentCellY + srcLineCnt < dgv.RowCount))

                            {

                                continue;

                            }

                            // ??\???Z?????\??t?????

                            if (dgv[CurrentCellX + DestCellCnt, CurrentCellY + srcLineCnt].Visible == false)

                            {

                                //srcCellCnt = srcCellCnt - 1;

                                continue;

                            }

                            // ?\??t??????(?????\?????`?F?b?N???????)------------

                            // ?s??????[?h&(??I?s?????s???)

                            if (CurrentCellY + srcLineCnt == dgv.RowCount - 1 && dgv.AllowUserToAddRows == true)

                            {

                                dgv.RowCount = dgv.RowCount + 1;

                            }

                            // Lock???|?????????Cell??R?s?[??????

                            if (dgv[CurrentCellX + DestCellCnt, CurrentCellY + srcLineCnt].ReadOnly == false)

                                // ?\??t??

                                dgv[CurrentCellX + DestCellCnt, CurrentCellY + srcLineCnt].Value = vals[srcCellCnt];

                            // ------------------------------------------------------

                            //// ?\??t??????(?????\?????`?F?b?N?L????)------------

                            //String pststr = "";

                            //for (int i = 0; i <= vals[srcCellCnt].Length - 1; i++)

                            //{

                            //    _editingColumn = x + DestCellCnt;

                            //    byte[] cc = Encoding.GetEncoding("SHIFT-JIS").GetBytes(vals[srcCellCnt].Substring(i, 1));

                            //    KeyPressEventArgs tmpe = new KeyPressEventArgs((char)cc[0]);

                            //    tmpe.Handled = false;

                            //    DataGridViewPlus_CellKeyPress(sender, tmpe);

                            //    if (tmpe.Handled == false)

                            //    {

                            //        pststr = pststr + vals[srcCellCnt].Substring(i, 1);

                            //    }

                            //}

                            //// ?s??????[?h????I?s?????s???

                            //if (CurrentCellY + srcLineCnt == dgv.RowCount - 1 && dgv.AllowUserToAddRows == true)

                            //{

                            //    dgv.RowCount = dgv.RowCount + 1;

                            //}

                            //// ?\??t??

                            //dgv[CurrentCellX + destCellCnt, CurrentCellY + srcLineCnt].Value = pststr;

                            // ------------------------------------------------------

                            // ????Z????

                            DestCellCnt = DestCellCnt + 1;

                        }

                    }

                }

            }

            catch (Exception ex)

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

            }

        }

        #endregion

        #region // <---------> ??????\?b?h

        #region 1?s?f?[?^?A?b?v

        /// <summary>

        /// ?A?b?v?L?[????

        /// </summary>

        /// <param name="StartPoint">?s??????J?n?J??????u</param>

        /// <param name="EndPoint">?s??????I???J??????u</param>

        public void GridRowUpAction(int StartPoint, int EndPoint)

        {

            try

            {

                // ?J?????g?s????

                int nCurRow = base.CurrentCell.RowIndex;

                int nCurCol = base.CurrentCell.ColumnIndex;

                // ?J?????g?s???

                DataGridViewRow currentrow = base.CurrentRow;

                // ?P?s?O????

                DataGridViewRow frontrow = base.Rows[nCurRow - 1];

                // ??????

                // ?J?????g?s?????

                DataGridViewRow SaveRow = (DataGridViewRow)currentrow.Clone();

                for (int i = StartPoint; i <= EndPoint; i++)

                    SaveRow.Cells[i].Value = currentrow.Cells[i].Value;

                    SaveRow.Cells[i].Style = currentrow.Cells[i].Style;

                    SaveRow.Cells[i].ReadOnly = currentrow.Cells[i].ReadOnly;

                }

                // ?O?s???J?????g?s

                for (int i = StartPoint; i <= EndPoint; i++)

                {

                    currentrow.Cells[i].Value = frontrow.Cells[i].Value;

                    currentrow.Cells[i].Style = frontrow.Cells[i].Style;

                    currentrow.Cells[i].ReadOnly = frontrow.Cells[i].ReadOnly;

                }

                // ?J?????g?s???O?s

                for (int i = StartPoint; i <= EndPoint; i++)

                {

                    frontrow.Cells[i].Value = SaveRow.Cells[i].Value;

                    frontrow.Cells[i].Style = SaveRow.Cells[i].Style;

                    frontrow.Cells[i].ReadOnly = SaveRow.Cells[i].ReadOnly;

                }

                //dgv.FirstDisplayedScrollingRowIndex = curRow;

                base.CurrentCell = base[nCurCol, nCurRow - 1];

            }

            catch (System.Exception ex)

            {

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

            }

        }

        #endregion

        #region 1?s?f?[?^?_?E??

        /// <summary>

        /// ?_?E???L?[????????

        /// </summary>

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

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

        public void GridRowDownAction(int StartPoint, int EndPoint)

        {

            try

            {

                // ??I?s??????????

                if ((base.CurrentRow.Index + 1) == base.Rows.Count) return;

                // ?J?????g?s????

                int curRow = base.CurrentCell.RowIndex;

                int curCol = base.CurrentCell.ColumnIndex;

                // ?J?????g?s???

                DataGridViewRow currentrow = base.CurrentRow;