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

                                        IOMessageBrowsingHistory mbhDB,

                                        IORecordKey RecDB,

                if (!ClsMessageBoradAccess.CreateMessage(mbdDB, mbtDB, mbhDB, RecDB, WriteData, WriteDetail)) return false;

            IOMessageBrowsingHistory mbhDB = new IOMessageBrowsingHistory();

            IORecordKey RecDB = new IORecordKey();

                mbhDB.connect(); mbhDB.beginTran();

                RecDB.connect(); RecDB.beginTran();

                        if (!MakeSecretaryMassageData(mbdDB, mbtDB, mbhDB, RecDB, cbiDDB, wrkRec, term, StartDate))

                        mbhDB.commit();

                        RecDB.commit();

                        mbhDB.rollback();

                        RecDB.rollback();

                mbhDB.close(); mbhDB = null;

                RecDB.close(); RecDB = null;

            IOMessageBrowsingHistory mbhDB = new IOMessageBrowsingHistory();

            IORecordKey RecDB = new IORecordKey();

                mbhDB.connect(); mbhDB.beginTran();

                RecDB.connect(); RecDB.beginTran();

                            if (!MakeMassageData(mbdDB, mbtDB, mbhDB, RecDB, cbiDDB, wrkBaseRec, CurTerm, CriteriaDate))

                    mbhDB.rollback();

                    RecDB.rollback();

                mbhDB.commit();

                RecDB.commit();

                mbhDB.close(); mbhDB = null;

                RecDB.close(); RecDB = null;

                                        IOMessageBrowsingHistory mbhDB,

                                        IORecordKey RecDB,

                if (!ClsMessageBoradAccess.CreateMessage(mbdDB, mbtDB, mbhDB, RecDB, WriteData, WriteDetail)) return false;

    <Compile Include="..\..\ProcessManagement\ProcessManagement\DataModel\RecordKey.cs">

      <Link>DataModel\RecordKey.cs</Link>

    </Compile>

    <Compile Include="..\..\ProcessManagement\ProcessManagement\DB\IOAccess\IORecordKey.cs">

      <Link>DB\IOAccess\IORecordKey.cs</Link>

    </Compile>

        public static int s_SystemVersion = 217;

            IOMessageBoardData DataDB = new IOMessageBoardData();

            IOMessageBoardTerget TergetDB = new IOMessageBoardTerget();

            IOMessageBrowsingHistory HistoryDB = new IOMessageBrowsingHistory();

            IORecordKey RecordDB = new IORecordKey();

                DataDB.connect(); DataDB.beginTran();

                TergetDB.connect(); TergetDB.beginTran();

                HistoryDB.connect(); HistoryDB.beginTran();

                RecordDB.connect(); RecordDB.beginTran();

                WriteData.RecordNumber = IOMessageBoardData.GetNewRecordNumber(DataDB, TergetDB, HistoryDB, RecordDB

                                                                        , (int)RecordKey.KeyNoDef.MessageKey, false);

                if (!DataDB.OneRecInsertAction(WriteData, false))

                    DataDB.rollback();

                    TergetDB.rollback();

                    HistoryDB.rollback();

                    RecordDB.rollback();

                if (!TergetDB.InsertAction(WriteDetail, false))

                    DataDB.rollback();

                    TergetDB.rollback();

                    HistoryDB.rollback();

                    RecordDB.rollback();

                DataDB.commit();

                TergetDB.commit();

                HistoryDB.commit();

                RecordDB.commit();

                DataDB.close(); DataDB = null;

                TergetDB.close(); TergetDB = null;

                HistoryDB.close(); HistoryDB = null;

                RecordDB.close(); RecordDB = null;

        public static bool CreateMessage(IOMessageBoardData mbdDB,

                                        IOMessageBoardTerget mbtDB,

                                        IOMessageBrowsingHistory HistroyDB,

                                        IORecordKey RecordDB,

                                        MessageBoardData WriteData,

                                        List<MessageBoardTerget> WriteDetail)

                WriteData.RecordNumber = IOMessageBoardData.GetNewRecordNumber(mbdDB, mbtDB, HistroyDB, RecordDB,

                                                                                (int)RecordKey.KeyNoDef.MessageKey, false);

                                        IOMessageBrowsingHistory mbhDB ,

                                        IORecordKey RecDB,

                if (!ClsMessageBoradAccess.CreateMessage(mbdDB, mbtDB, mbhDB, RecDB, WriteData, WriteDetail)) return false;

            IOMessageBrowsingHistory mbhDB = new IOMessageBrowsingHistory();

            IORecordKey RecDB = new IORecordKey();

                mbhDB.connect(); mbhDB.beginTran();

                RecDB.connect(); RecDB.beginTran();

                        if (!MakeSecretaryMassageData(mbdDB, mbtDB, mbhDB, RecDB, cbiDDB, wrkRec, term, StartDate))

                        mbhDB.commit();

                        RecDB.commit();

                        mbhDB.rollback();

                        RecDB.rollback();

                mbhDB.close(); mbhDB = null;

                RecDB.close(); RecDB = null;

            IOMessageBrowsingHistory mbhDB = new IOMessageBrowsingHistory();

            IORecordKey RecDB = new IORecordKey();

                mbhDB.connect(); mbhDB.beginTran();

                RecDB.connect(); RecDB.beginTran();

                            if (!MakeMassageData(mbdDB, mbtDB, mbhDB, RecDB, cbiDDB, wrkBaseRec, CurTerm, CriteriaDate))

                    mbhDB.rollback();

                    RecDB.rollback();

                mbhDB.commit();

                RecDB.commit();

                mbhDB.close(); mbhDB = null;

                RecDB.close(); RecDB = null;

                                        IOMessageBrowsingHistory mbhDB,

                                        IORecordKey RecDB,

                if (!ClsMessageBoradAccess.CreateMessage(mbdDB, mbtDB, mbhDB, RecDB, WriteData, WriteDetail)) return false;

        public static int GetNewRecordNumber(IOMessageBoardData DataDB,

                                            IOMessageBoardTerget TergetDB,

                                            IOMessageBrowsingHistory HistroyDB,

                                            IORecordKey RecordDB,

                                            int nKeyNo, bool bConnect = true)

                // 最大レコード番号取得

                strcmd.Append("Select (IFNULL(RecordNumber, 0) + 1) As RecNo");

                strcmd.Append(" From Recordkey");

                strcmd.AppendFormat(" Where KeyNo = {0}", nKeyNo);

                ArrayList arData = new ArrayList();

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

                // レコード番号取得

                object[] objwrk = (object[])arData[0];

                int nRecNo = CommonMotions.cnvInt(objwrk[0]);

                // MAXを越えれば1にする

                if (nRecNo > RecordKey.MaxRecCountDef[nKeyNo]) nRecNo = 1;

                // 番号更新

                strcmd.Clear();

                strcmd.Append("UPDATE Recordkey");

                strcmd.AppendFormat(" Set RecordNumber = {0}", nRecNo);

                strcmd.AppendFormat(" Where KeyNo = {0}", nKeyNo);

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

                // データ存在確認

                strcmd.Clear();

                strcmd.Append("Select * From MessageBoardData");

                strcmd.AppendFormat(" Where RecordNumber = {0}", nRecNo);

                arData.Clear();

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

                // 無ければそのまま

                if (arData.Count < 1) return nRecNo;

                // あれば削除する

                DelAllMessageData(DataDB, TergetDB, HistroyDB, nRecNo, bConnect);

                return nRecNo;

                return 0;

        public int GetMaxBranchNumber(int RecordNumber, bool bConnect = true)

        #region メッセージデータ一括削除

        /// <summary>

        /// メッセージデータ一括削除

        /// </summary>

        /// <returns></returns>

        public static void DelAllMessageData(IOMessageBoardData DataDB,

                                            IOMessageBoardTerget TergetDB,

                                            IOMessageBrowsingHistory HistoryDB

                                            , int KeyNumber, bool bConnect)

        {

            try

            {

                StringBuilder strcmd = new StringBuilder();

                strcmd.AppendFormat(" Where RecordNumber = {0}", KeyNumber);

                DataDB.DeleteAction(strcmd.ToString(), bConnect);

                TergetDB.DeleteAction(strcmd.ToString(), bConnect);

                HistoryDB.DeleteAction(strcmd.ToString(), bConnect);

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

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

    /// 掲示板履歴データアクセスクラス

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

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

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 IORecordKey : MySqlProcess

    {

        #region 定義部

        /// <summary>

        /// log4netログを使用する

        /// </summary>

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

        #endregion

        #region 定数

        /// <summary>

        /// レコード番号管理データフィールド並び

        /// </summary>

        public enum TableColumn

        {

            KeyNo = 0,

            RecordNumber,

            EntryDate,

            UpdateDate,

        }

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

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

        public IORecordKey()

            : 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()

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                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

                    {

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

                    }

                    bColFirst = false;

                }

                strcmd.Append(" FROM RecordKey");

                return strcmd.ToString();

            }

            catch (Exception ex)

            {

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

                return string.Empty;

            }

        }

        #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<RecordKey> 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)

                {

                    RecordKey work = new RecordKey();

                    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件検索

        /// <summary>

        /// レコード番号管理データ1件検索

        /// </summary>

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

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

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

        /// <returns></returns>

        public bool SelectAction(string AddSQLString, ref RecordKey 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;

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

                // データセット

                foreach (object[] objwrk in arData)

                {

                    RecordKey work = new RecordKey();

                    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 レコード番号管理データ複数件追加

        /// <summary>

        /// レコード番号管理データ複数件追加

        /// </summary>

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

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

        /// <returns></returns>

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                bool bColFirst = true;

                strcmd.Append("INSERT INTO RecordKey");

                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 (RecordKey work in data)

                {

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

                    else strcmd.Append(", (");

                    strcmd.AppendFormat("{0}", work.KeyNo);

                    strcmd.AppendFormat(",{0}", work.RecordNumber);

                    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="data"></param>

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

        /// <returns></returns>

        public bool InsertAction(RecordKey data, bool bConnect = true)

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                bool bColFirst = true;

                strcmd.Append("INSERT INTO RecordKey");

                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}", data.KeyNo);

                strcmd.AppendFormat(",{0}", data.RecordNumber);

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

                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.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 レコード番号管理データ更新

        /// <summary>

        /// レコード番号管理データ更新

        /// </summary>

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

        /// <param name="data">レコード番号管理データデータ</param>

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

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.Append("UPDATE RecordKey");

                strcmd.Append(" SET");

                strcmd.AppendFormat("KeyNo = {0}", data.KeyNo);

                strcmd.AppendFormat(", RecordNumber = {0}", data.RecordNumber);

                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 RecordKey", 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 1項目更新処理

        /// <summary>

        /// 1項目の更新を行う

        /// </summary>

        /// <param name="PrimaryCode"></param>

        /// <param name="FeildNo"></param>

        /// <param name="value"></param>

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

        /// <returns></returns>

        public bool UpdateFeild(int PrimaryCode, int FeildNo, object value, bool bConnect = true)

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.Append("UPDATE RecordKey");

                strcmd.Append(" SET");

                switch (FeildNo)

                {

                    case (int)TableColumn.KeyNo:

                        strcmd.AppendFormat(" KeyNo = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.RecordNumber:

                        strcmd.AppendFormat(" RecordNumber = {0}", ((int)value).ToString());

                        break;

                }

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

                strcmd.Append(CreatePrimarykeyString(PrimaryCode));

                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 MySQLDataReaderより構造体へセットする

        /// <summary>

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

        /// </summary>

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

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

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

        {

            try

            {

                // データ取得

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

                wrk.RecordNumber = int.Parse(objwrk[(int)TableColumn.RecordNumber].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(), myex.Message);

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

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

        /// <summary>

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

        /// </summary>

        /// <param name="UnitKey"></param>

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

        public string CreatePrimarykeyString(int KeyNo)

        {

            StringBuilder strWork = new StringBuilder();

            try

            {

                strWork.AppendFormat(" Where KeyNo = {0}", KeyNo);

            }

            catch (Exception ex)

            {

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

            }

            return strWork.ToString();

        }

        #endregion

        #region レコード番号の最大値を取得する

        /// <summary>

        /// レコード番号の最大値を取得する

        /// </summary>

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

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

        /// <returns></returns>

        public long SelectMaxMessageBoardDataKeyCount(int KeyNo, bool bConnect = true)

        {

            int iRet = 0;

            IORecordKey keyDB = new IORecordKey();

            try

            {

                // インターフェース

                StringBuilder strcmd = new StringBuilder();

                ArrayList arData = new ArrayList();

                // SQL作成

                strcmd.Append("SELECT IFNULL(RecordNumber, 0) FROM RecordKey");

                strcmd.AppendFormat("Where KeyNo = {0}", KeyNo);

                // SQL実行

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

                // データセット

                object[] objwrk = (object[])arData[0];

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

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                keyDB.close(); keyDB = null;

            }

            return iRet;

        }

        #endregion

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ProcessManagement.DataModel

{

    public class RecordKey

    {

        #region 定数

        #region 工事基本情報：結合工事フラグ

        /// <summary>

        /// 工事基本情報：結合工事フラグ

        /// </summary>

        public enum KeyNoDef

        {

            /// <summary>

            /// 1:結合無通常データ

            /// </summary>

            MessageKey = 1,

        }

        #endregion

        #region 最大値定義

        /// <summary>

        /// 最大値定義

        /// </summary>

        public static long[] MaxRecCountDef = new long[] { 0, 999999 };

        #endregion

        #endregion

        #region メンバ変数

        /// <summary>

        /// キーコード

        /// </summary>

        private int m_KeyNo = 0;

        /// <summary>

        /// レコード番号

        /// </summary>

        private int m_RecordNumber = 0;

        /// <summary>

        /// 登録日付

        /// </summary>

        private DateTime m_EntryDate = DateTime.Now;

        /// <summary>

        /// 更新日付

        /// </summary>

        private DateTime m_UpdateDate = DateTime.Now;

        #endregion

        #region コンストラクタ

        #endregion

        #region プロパティ

        /// <summary>

        /// キーコード

        /// </summary>

        public int KeyNo

        {

            get { return m_KeyNo; }

            set { m_KeyNo = value; }

        }

        /// <summary>

        /// レコード番号

        /// </summary>

        public int RecordNumber

        {

            get { return m_RecordNumber; }

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

    }

}

                // ?????\??

                InitDataLoad();

                SetCmbDepartmentEvent(true);

                if (worklist[0].SalesDepCode > 0) comboBoxEX1.SelectedValue = worklist[0].SalesDepCode;

                if (worklist[0].SalesPersonCode > 0) cmbSalesPerson.SelectedValue = worklist[0].SalesPersonCode;

                if (worklist[0].SalesSubDepCode > 0) comboBoxEX5.SelectedValue = worklist[0].SalesSubDepCode;

                if (worklist[0].SalesSubPersonCode > 0) cmbSalesSubPerson.SelectedValue = worklist[0].SalesSubPersonCode;

                if (worklist[0].ConstrDepCode > 0) comboBoxEX2.SelectedValue = worklist[0].ConstrDepCode;

                if (worklist[0].ConstructionPersonCode > 0) cmbConstrPerson.SelectedValue = worklist[0].ConstructionPersonCode;

                if (worklist[0].ConstrSubDepCode > 0) comboBoxEX3.SelectedValue = worklist[0].ConstrSubDepCode;

                if (worklist[0].ConstrSubPersonCode > 0) cmbConstrSubPerson.SelectedValue = worklist[0].ConstrSubPersonCode;

                if (worklist[0].ConstrInstrDepCode > 0) comboBoxEX4.SelectedValue = worklist[0].ConstrInstrDepCode;

                if (worklist[0].ConstructionInstructor > 0) cmbConstrInst.SelectedValue = worklist[0].ConstructionInstructor;

                SetCmbDepartmentEvent(false);

            IOMessageBrowsingHistory mbhDB = new IOMessageBrowsingHistory();            // ?f???????f?[?^

            IORecordKey RecDB = new IORecordKey();                                      // ???R?[?h??????

                            mbdDB, mbtDB, mbhDB, RecDB);

                                        mbdDB, mbtDB, mbhDB, RecDB);

                                        mbdDB, mbtDB, mbhDB, RecDB);

                                        mbdDB, mbtDB, mbhDB, RecDB);

                                        mbdDB, mbtDB, mbhDB, RecDB);

                                            mbdDB, mbtDB, mbhDB, RecDB);

                                        mbdDB, mbtDB, mbhDB, RecDB);

                                        mbdDB, mbtDB, mbhDB, RecDB);

                    if (!MessageBoardEntry(mbdDB, mbtDB, mbhDB, RecDB))

                                            mbdDB, mbtDB, mbhDB, RecDB);

                    if (!MessageBoardEntry2(mbdDB, mbtDB, mbhDB, RecDB))

                                            mbdDB, mbtDB, mbhDB, RecDB);

                                    mbdDB, mbtDB, mbhDB, RecDB);

                mbhDB.close(); mbhDB = null;

                RecDB.close(); RecDB = null;

                                IOMessageBoardTerget mbtDB,             // ?f??????e?[?u??

                                IOMessageBrowsingHistory mbhDB,         // ?f???????f?[?^

                                IORecordKey RecDB                       // ???R?[?h???????f?[?^

                                )

                mbhDB.connect(); mbhDB.beginTran();

                RecDB.connect(); RecDB.beginTran();

                                        IOMessageBoardTerget mbtDB,             // ?f??????e?[?u??