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

                string strSQL = "SELECT SUM(SAL.SALARY) FROM";

                strSQL += " (SELECT AX.hiduke,";

                strSQL += string.Format(" ROUND((AX.salary * {0}) / DATE_FORMAT(LAST_DAY(AX.hiduke), '%d')) AS SALARY,", CommonDefine.s_SalaryCorrection);

                strSQL += " MAX(AX.StartD) FROM";

                strSQL += " (SELECT A.d hiduke, B.MonthlySalary salary, B.STARTDATE StartD FROM";

                strSQL += " (SELECT A1.years, A2.month, A3.days, DATE(CONCAT(A1.years, '/', A2.month, '/', A3.days)) AS d";

                strSQL += " FROM yearmaster AS A1, monthmaster AS A2, daymaster AS A3";

                strSQL += " WHERE";

                    strSQL += string.Format(" (A1.years = {0} AND A2.month IN(", dtStart.Year.ToString("0000"));

                        if (i != dtStart.Month) strSQL += ", ";

                        strSQL += string.Format("{0} ", i);

                    strSQL += "))";

                    strSQL += string.Format(" ((A1.years = {0} AND A2.month IN(", dtStart.Year.ToString("0000"));

                        if (i != dtStart.Month) strSQL += ", ";

                        strSQL += string.Format("{0} ", i);

                    strSQL += "))";

                    strSQL += string.Format(" OR (A1.years = {0} AND A2.month IN(", dtLast.Year.ToString("0000"));

                        if (i != 1) strSQL += ", ";

                        strSQL += string.Format("{0} ", i);

                    strSQL += ")))";

                strSQL += " AND DATE(CONCAT(A1.years, '/', A2.month, '/', A3.days)) IS NOT NULL";

                strSQL += string.Format(" AND (DATE('{0}') <= DATE(CONCAT(A1.years, '/', A2.month, '/', A3.days))", dtStart.ToShortDateString());

                strSQL += string.Format(" AND DATE(CONCAT(A1.years, '/', A2.month, '/', A3.days)) <= DATE('{0}'))", dtLast.ToShortDateString());

                strSQL += " ORDER BY d) A";

                strSQL += ", PERSONSALARYMASTER AS B";

                strSQL += " WHERE B.STARTDATE <= A.d";

                strSQL += string.Format(" AND B.PERSONCODE = {0}", PersonCode);

                strSQL += " ORDER BY A.d, B.STARTDATE DESC) AS AX";

                strSQL += " GROUP BY AX.hiduke";

                strSQL += " ORDER BY AX.hiduke";

                strSQL += " ) SAL";

                SalDB.ExecuteReader(strSQL, ref ArData);

        public static int s_SystemVersion = 41;

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

    {

        #region 定義部

        /// <summary>

        /// log4netログを使用する

        /// </summary>

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

        #endregion

        #region 定数

        /// <summary>

        /// データフィールド並び

        /// </summary>

        public enum TableColumn

        {

            /// <summary>

            /// 作成者コード

            /// </summary>

            PersonCode,

            /// <summary>

            /// 日報作成日

            /// </summary>

            DailyDataDate,

            /// <summary>

            /// 行番号

            /// </summary>

            LineCount,

            /// <summary>

            /// 工事番号

            /// </summary>

            ConstructionCode,

            /// <summary>

            /// 作業内容

            /// </summary>

            WorkContentsText,

            /// <summary>

            /// 登録年月日

            /// </summary>

            EntryDate,

            /// <summary>

            /// 更新年月日

            /// </summary>

            UpdateDate,

        }

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

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

        public IODailyData()

            : base(DBCommon.Instance.DBConnectString)

        {

        }

        #endregion

        #region SQL作成

        /// <summary>

        /// SQL作成

        /// </summary>

        private string CreateSelectSQL()

        {

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

            string strcmd = "SELECT";

            strcmd += "  PersonCode";                                       // 担当者コード

            strcmd += " ,DATE_FORMAT(DailyDataDate, '%Y/%m/%d')";           // 日報作成日

            strcmd += " ,LineCount";                                        // 行番号

            strcmd += " ,ConstructionCode";                                 // 工事番号

            strcmd += " ,WorkContentsText";                                 // 作業内容

            strcmd += ", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')";

            strcmd += ", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')";

            strcmd += " FROM DailyData";

            return strcmd;

        }

        #endregion

        #region 複数読込み処理

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

        {

            // インターフェース

            string strcmd = "";

            ArrayList arData = new ArrayList();

            try

            {

                // SQL作成

                strcmd = CreateSelectSQL() + AddSQLString;

                // SQL実行

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

                // データセット

                foreach (object[] objwrk in arData)

                {

                    DailyData work = new DailyData();

                    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 1件読込み処理

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

        {

            // インターフェース

            string strcmd = "";

            ArrayList arData = new ArrayList();

            try

            {

                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 1件追加処理

        /// <summary>

        /// 担当者毎経費データ追加

        /// </summary>

        /// <param name="data">担当者毎経費データデータ</param>

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

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

        {

            string strcmd = "";

            try

            {

                strcmd = "INSERT INTO DailyData";

                strcmd += " VALUES (";

                strcmd += string.Format("  {0}", work.PersonCode);                      // 担当者コード

                strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"

                                            , work.DailyDataDate.ToShortDateString());  // 日報作成日

                strcmd += string.Format(", {0}", work.LineCoount);                      // 行番号

                strcmd += string.Format(", {0}", work.ConstructionCode);                // 工事番号

                strcmd += string.Format(",'{0}'", work.WorkContentsText);               // 作業内容

                strcmd += ", NOW()";

                strcmd += ", NOW()";

                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 複数追加処理

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

        {

            string strcmd = "";

            try

            {

                foreach (DailyData 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, DailyData data, bool bConnect = true)

        {

            string strcmd = "";

            try

            {

                strcmd = "UPDATE DailyData";

                strcmd += " SET";

                strcmd += string.Format(" PersonCode = {0}", data.PersonCode);                  // 担当者コード

                strcmd += string.Format(",DailyDataDate = STR_TO_DATE('{0}','%Y/%m/%d')"

                                        , data.DailyDataDate.ToShortDateString());              // 日報作成日

                strcmd += string.Format(",LineCoount = {0}", data.LineCoount);                  // 行番号

                strcmd += string.Format(",ConstructionCode = {0}", data.ConstructionCode);      // 工事番号

                strcmd += string.Format(",WorkContentsText = '{0}'", data.WorkContentsText);    // 作業内容

                strcmd += ", UpdateDate = NOW()";

                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)

        {

            // インターフェース

            string strcmd = "";

            try

            {

                strcmd = string.Format("{0}{1}", "DELETE FROM DailyData", 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>

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

        /// </summary>

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

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

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

        {

            try

            {

                // データ取得

                wrk.PersonCode = int.Parse(objwrk[(int)TableColumn.PersonCode].ToString());                  // 担当者コード

                wrk.DailyDataDate = DateTime.Parse(objwrk[(int)TableColumn.DailyDataDate].ToString());       // 日報作成日

                wrk.LineCoount = int.Parse(objwrk[(int)TableColumn.LineCount].ToString());                   // 行番号

                wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.ConstructionCode].ToString());      // 工事番号

                wrk.WorkContentsText = objwrk[(int)TableColumn.WorkContentsText].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="PersonCode"></param>

        /// <param name="ActionDate"></param>

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

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

        /// <returns></returns>

        public string CreatePrimarykeyString(int PersonCode, DateTime DailyDataDate, int LineCount)

        {

            string strWork = "";

            try

            {

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

                if (DailyDataDate != DateTime.MinValue)

                    strWork += string.Format(" AND DailyDataDate = STR_TO_DATE('{0}','%Y/%m/%d')", DailyDataDate.ToShortDateString());

                if (LineCount != 0)

                    strWork += string.Format(" AND LineCount = {0}", LineCount);

            }

            catch (Exception ex)

            {

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

            }

            return strWork;

        }

        #endregion

    }

}

            string strcmd = "";

                strcmd = "SELECT";

                strcmd += " DATE_FORMAT(TargetDate, '%Y/%m/%d')";

                strcmd += " ,PersonCode";

                strcmd += " ,ActionSchedule";

                strcmd += " ,TargetYear";

                strcmd += " ,TargetMonth";

                strcmd += " ,TargetDay";

                strcmd += " ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')";

                strcmd += " ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')";

                strcmd += " FROM ActionScheduleData";

                strcmd += AddSQLString;

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

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

            string strcmd = "";

                strcmd = "INSERT INTO ActionScheduleData";

                strcmd += " (";

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

                    strcmd += gender.ToString();

                strcmd += ") VALUES";

                    if (bDataFirst) strcmd += " (";

                    else strcmd += ", (";

                    strcmd += string.Format(" STR_TO_DATE('{0}','%Y/%m/%d')", work.TargetDate.ToShortDateString());

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

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

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

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

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

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

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

                    strcmd += ")";

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

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

            string strcmd = "";

                strcmd = "INSERT INTO ActionScheduleData";

                strcmd += " (";

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

                    strcmd += gender.ToString();

                strcmd += ") VALUES (";

                strcmd += string.Format(" STR_TO_DATE('{0}','%Y/%m/%d')", data.TargetDate.ToShortDateString());

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

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

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

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

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

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

                strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.UpdateDate);

                strcmd += ")";

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

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

            string strcmd = "";

                strcmd = "UPDATE ActionScheduleData";

                strcmd += " SET";

                strcmd += string.Format(" TargetDate = STR_TO_DATE('{0}','%Y/%m/%d')", data.TargetDate.ToShortDateString());

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

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

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

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

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

                strcmd += ", UpdateDate = NOW()";

                strcmd += AddSQLString;

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

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

            string strWork = string.Empty;

                strWork = string.Format(" Where DATE(TargetDate) = STR_TO_DATE('{0}','%Y/%m/%d')", TargetDate.ToShortDateString());

                    strWork += string.Format(" And PersonCode = {0}", PersonCode.ToString());

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

            return strWork;

            string strWork = string.Empty;

                strWork = string.Format(" Where TargetYear = {0}", TargetYear.ToString());

                    strWork += string.Format(" And TargetMonth = {0}", TargetMonth.ToString());

                    strWork += string.Format(" And TargetDay = {0}", TargetDay.ToString());

                    strWork += string.Format(" And PersonCode = {0}", PersonCode.ToString());

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

            return strWork;

            string strcmd = "SELECT";

            strcmd += "  PersonCode";                                       // 担当者コード

            strcmd += " ,DATE_FORMAT(AttendanceDate, '%Y/%m/%d')";          // 日報作成日

            strcmd += " ,SeqNo";                                            // 明細行番号

            strcmd += " ,ActionResult";                                     // 行動実績

            strcmd += " ,OvertimeHours";                                    // 残業時間

            strcmd += " ,WorkingComment";                                   // コメント

            strcmd += ", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')";      // 登録年月日

            strcmd += ", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')";     // 更新年月日

            strcmd += " FROM AttendanceDailyData";

            return strcmd;

            string strcmd = "";

                strcmd = CreateSelectSQL() + AddSQLString;

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

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

            string strcmd = "";

                strcmd = CreateSelectSQL() + AddSQLString;

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

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

            string strcmd = "";

                strcmd = "INSERT INTO AttendanceDailyData";

                strcmd += " (";

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

                    strcmd += gender.ToString();

                strcmd += ") VALUES (";

                strcmd += string.Format("  {0}", work.PersonCode);                      // 担当者コード

                strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"

                strcmd += string.Format(", {0}", work.SeqNo);                           // 明細行番号

                strcmd += string.Format(",'{0}'", work.ActionResult);                   // 行動実績

                strcmd += string.Format(", {0}", work.OvertimeHours);                   // 残業時間

                strcmd += string.Format(",'{0}'", work.WorkingComment);                 // コメント

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

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

                strcmd += ")";

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

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

            string strcmd = "";

                strcmd = "INSERT INTO AttendanceDailyData";

                strcmd += " (";

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

                    strcmd += gender.ToString();

                strcmd += ") VALUES";

                    if (bDataFirst) strcmd += " (";

                    else strcmd += ", (";

                    strcmd += string.Format("  {0}", work.PersonCode);                      // 担当者コード

                    strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"

                    strcmd += string.Format(", {0}", work.SeqNo);                           // 明細行番号

                    strcmd += string.Format(",'{0}'", work.ActionResult);                   // 行動実績

                    strcmd += string.Format(", {0}", work.OvertimeHours);                   // 残業時間

                    strcmd += string.Format(",'{0}'", work.WorkingComment);                 // コメント

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

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

                    strcmd += ")";

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

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

            string strcmd = "";

                strcmd = "UPDATE AttendanceDailyData";

                strcmd += " SET";

                strcmd += string.Format(" PersonCode = {0}", data.PersonCode);                  // 担当者コード

                strcmd += string.Format(",AttendanceDate = STR_TO_DATE('{0}','%Y/%m/%d')"

                strcmd += string.Format(",SeqNo =  {0} ", data.SeqNo);                          // 明細行番号

                strcmd += string.Format(",ActionResult = '{0}'", data.ActionResult);            // 行動実績

                strcmd += string.Format(",OvertimeHours = {0}", data.OvertimeHours);            // 残業時間

                strcmd += string.Format(",WorkingComment = '{0}'", data.WorkingComment);        // コメント

                strcmd += ", UpdateDate = NOW()";

                strcmd += AddSQLString;

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

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

            string strcmd = "";

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

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

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

            string strcmd = "";

                strcmd = "UPDATE AttendanceDailyData";

                strcmd += " SET";

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

                        strcmd += string.Format(" AttendanceDate = STR_TO_DATE('{0}','%Y/%m/%d')", ((DateTime)value).ToShortDateString());

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

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

                        strcmd += string.Format(" OvertimeHours = {0}", (double)value);

                        strcmd += string.Format(" WorkingComment = '{0}'", CommonMotions.cnvString(value));

                strcmd += ", UpdateDate = NOW()";

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

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

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

            string strWork = "";

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

                    strWork += string.Format(" AND AttendanceDate = STR_TO_DATE('{0}','%Y/%m/%d')", AttendanceDate.ToShortDateString());

                    strWork += string.Format(" AND SeqNo = {0}", SeqNo);

            return strWork;

            string strcmd = "SELECT";

            strcmd += "  PersonCode";                                       // 担当者コード

            strcmd += " ,DATE_FORMAT(AttendanceMonth, '%Y/%m/%d')";         // 出勤管理年月

            strcmd += " ,LastDays";                                         // 当月最終日

            strcmd += " ,AttendDayCount";                                   // 出勤日数

            strcmd += " ,TotalOverTimes";                                   // 残業時間数

            strcmd += " ,DATE_FORMAT(OrderDate, '%Y/%m/%d')";               // 申請日

            strcmd += " ,OrderNo";                                          // 申請受付番号

            strcmd += ", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')";      // 更新年月日

            strcmd += ", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')";     // 登録年月日

            strcmd += " FROM AttendanceData";

            return strcmd;

            string strcmd = "";

                strcmd = CreateSelectSQL() + AddSQLString;

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

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

            string strcmd = "";

                strcmd = CreateSelectSQL() + AddSQLString;

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

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

            string strcmd = "";

                strcmd = "INSERT INTO AttendanceData";

                strcmd += "(";

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

                    strcmd += gender.ToString();

                strcmd += ") VALUES (";

                strcmd += string.Format("  {0}", work.PersonCode);                      // 担当者コード

                strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"

                strcmd += string.Format(", {0}", work.LastDays);                        // 当月最終日

                strcmd += string.Format(", {0}", work.AttendDayCount);                  // 出勤日数

                strcmd += string.Format(", {0}", work.TotalOverTimes);                  // 残業時間数

                strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"

                strcmd += string.Format(", {0}", work.OrderNo);                         // 申請受付番号

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

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

                strcmd += ")";

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

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

            string strcmd = "";

                strcmd = "INSERT INTO AttendanceData";

                strcmd += " (";

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

                    strcmd += gender.ToString();

                strcmd += ") VALUES";

                    if (bDataFirst) strcmd += " (";

                    else strcmd += ", (";

                    strcmd += string.Format("  {0}", work.PersonCode);                      // 担当者コード

                    strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"

                    strcmd += string.Format(", {0}", work.LastDays);                        // 当月最終日

                    strcmd += string.Format(", {0}", work.AttendDayCount);                  // 出勤日数

                    strcmd += string.Format(", {0}", work.TotalOverTimes);                  // 残業時間数

                    strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d')"

                    strcmd += string.Format(", {0}", work.OrderNo);                         // 申請受付番号

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

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

                    strcmd += ")";

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

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

            string strcmd = "";

                strcmd = "UPDATE AttendanceData";

                strcmd += " SET";

                strcmd += string.Format(" PersonCode = {0}", data.PersonCode);                  // 担当者コード

                strcmd += string.Format(" ,AttendanceMonth = STR_TO_DATE('{0}','%Y/%m/%d')",

                strcmd += string.Format(" ,LastDays =  {0} ", data.LastDays);                   // 当月最終日

                strcmd += string.Format(" ,AttendDayCount =  {0} ", data.AttendDayCount);       // 出勤日数

                strcmd += string.Format(" ,TotalOverTimes =  {0} ", data.TotalOverTimes);       // 残業時間数

                strcmd += string.Format(" ,OrderDate = STR_TO_DATE('{0}','%Y/%m/%d')",

                strcmd += string.Format(" ,OrderNo =  {0} ", data.OrderNo);                     // 申請受付番号

                strcmd += ", UpdateDate = NOW()";

                strcmd += AddSQLString;

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

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

            string strcmd = "";

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

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

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

            string strcmd = "";

                strcmd = "UPDATE AttendanceData";

                strcmd += " SET";

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

                        strcmd += string.Format(" AttendanceMonth = STR_TO_DATE('{0}','%Y/%m/%d')", ((DateTime)value).ToShortDateString());

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

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

                        strcmd += string.Format(" TotalOverTimes = {0}", (double)value);

                        strcmd += string.Format(" OrderDate = STR_TO_DATE('{0}','%Y/%m/%d')", ((DateTime)value).ToShortDateString());

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

                strcmd += ", UpdateDate = NOW()";

                strcmd += CreatePrimarykeyString(PersonCode, AttendanceMonth);

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

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