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

        public static int s_SystemVersion = 228;

                StringBuilder strRemove = new StringBuilder();

                StringBuilder strRemove2 = new StringBuilder();

                StringBuilder strSQL = new StringBuilder();

                    strRemove.Clear();

                    strRemove.Append(DB01.CreatePrimarykeyString(RemoveList[i]));

                    if (!DB01.DeleteAction(strRemove.ToString(), false)) { ProcSuccess = false; break; }

                    if (!DB02.DeleteAction(strRemove.ToString(), false)) { ProcSuccess = false; break; }

                    DB04.DeleteAction(strRemove.ToString(), false);

                    DB05.DeleteAction(strRemove.ToString(), false);

                    DB06.DeleteAction(strRemove.ToString(), false);

                    DB07.DeleteAction(strRemove.ToString(), false);

                    DB08.DeleteAction(strRemove.ToString(), false);

                    DB09.DeleteAction(strRemove.ToString(), false);

                    DB10.DeleteAction(strRemove.ToString(), false);

                    DB11.DeleteAction(strRemove.ToString(), false);

                    DB12.DeleteAction(strRemove.ToString(), false);

                    DB13.DeleteAction(strRemove.ToString(), false);

                    DB14.DeleteAction(strRemove.ToString(), false);

                    DB15.DeleteAction(strRemove.ToString(), false);

                    DB16.DeleteAction(strRemove.ToString(), false);

                    DB17.DeleteAction(strRemove.ToString(), false);

                    DB18.DeleteAction(strRemove.ToString(), false);

                    DB19.DeleteAction(strRemove.ToString(), false);

                    DB20.DeleteAction(strRemove.ToString(), false);

                    DB21.DeleteAction(strRemove.ToString(), false);

                    DB22.DeleteAction(strRemove.ToString(), false);

                    DB23.DeleteAction(strRemove.ToString(), false);

                    DB24.DeleteAction(strRemove.ToString(), false);

                    DB25.DeleteAction(strRemove.ToString(), false);

                    DB26.DeleteAction(strRemove.ToString(), false);

                    DB27.DeleteAction(strRemove.ToString(), false);

                    DB28.DeleteAction(strRemove.ToString(), false);

                    DB29.DeleteAction(strRemove.ToString(), false);

                        DB03.DeleteAction(strRemove.ToString(), false);

                        strRemove2.Clear();

                        strRemove2.AppendFormat(" Where FluctuationCode = {0}", RemoveList[i]);

                        strRemove2.AppendFormat(" AND LINKTYPE = {0}", (int)ConstructionLink.DataTypeDef.FluctuationType);

                        DB03.DeleteAction(strRemove2.ToString(), false);

                        strSQL.Clear();

                            strSQL.AppendFormat("UPDATE CONSTRUCTIONBASEINFO A SET A.JOINFLG = {0}", (int)ConstructionBaseInfo.JoinFlgDef.Standard);

                            strSQL.Append(" WHERE A.CONSTRUCTIONCODE IN (SELECT AA.FLUCTUATIONCODE FROM CONSTRUCTIONLINK AA");

                            strSQL.AppendFormat(" WHERE AA.CONSTRUCTIONCODE = {0}",UpdateLinkList[i]);

                            strSQL.AppendFormat(" AND AA.LINKTYPE = {0})", (int)ConstructionLink.DataTypeDef.FluctuationType);

                            DB01.ExecuteNonQuery(strSQL.ToString(), false);

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("SELECT FLUCTUATIONCODE FROM CONSTRUCTIONLINK");

                strSQL.Append(LinkDB.CreatePrimarykeyString(RemoveCode));

                    strSQL.AppendFormat(" AND LINKTYPE = {0}", (int)ConstructionLink.DataTypeDef.JoinType);

                    strSQL.AppendFormat(" AND LINKTYPE = {0}", (int)ConstructionLink.DataTypeDef.FluctuationType);

                if (!LinkDB.ExecuteReader(strSQL.ToString(), ref arList)) return;

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("SELECT B.CONSTRUCTIONCODE, COUNT(*) FROM CONSTRUCTIONLINK A, CONSTRUCTIONLINK B");

                strSQL.AppendFormat(" WHERE A.FLUCTUATIONCODE = {0}", RemoveCode);

                strSQL.AppendFormat(" AND A.LINKTYPE = {0}", (int)ConstructionLink.DataTypeDef.FluctuationType);

                strSQL.Append(" AND B.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE");

                strSQL.Append(" GROUP BY B.CONSTRUCTIONCODE");

                if (!LinkDB.ExecuteReader(strSQL.ToString(), ref arList)) return 0;

                StringBuilder strParent = new StringBuilder();

                strParent.Append("SELECT DISTINCT(A.CONSTRUCTIONCODE), B.REQUESTEDDATE, 0, 0, 0, 0, F.DETAILSTRING, B.JOINFLG");

                strParent.Append(" FROM CONSTRUCTIONLINK A");

                strParent.Append(" LEFT OUTER JOIN CONSTRUCTIONBASEINFODETAIL F ON F.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE");

                strParent.AppendFormat(" AND F.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);

                strParent.Append(", CONSTRUCTIONBASEINFO B");

                strParent.AppendFormat(" WHERE A.FLUCTUATIONCODE = {0}", SearchCode);

                        strParent.AppendFormat(" AND A.LINKTYPE = {0}", (int)ConstructionLink.DataTypeDef.JoinType);

                        strParent.AppendFormat(" AND A.LINKTYPE = {0}", (int)ConstructionLink.DataTypeDef.FluctuationType);

                strParent.Append(" AND B.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE");

                strParent.AppendFormat(" AND B.CONSTRUCTIONSTATUSFLG != {0}", iStatus);

                if (!BaseDB.ExecuteReader(strParent.ToString(), ref DataList))

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append(BaseDB.CreatePrimarykeyString(TargetCode));

                if (!BaseDB.SelectAction(strSQL.ToString(), ref BaseRec, false)) return false;

                strSQL.Clear();

                strSQL.Append("SELECT A.CONSTRUCTIONCODE, A.FLUCTUATIONCODE, D.JOINFLG, B.FLUCTUATIONCODE, C.JOINFLG FROM CONSTRUCTIONLINK A");

                strSQL.Append(" LEFT JOIN CONSTRUCTIONLINK B ON B.CONSTRUCTIONCODE = A.FLUCTUATIONCODE");

                strSQL.Append(" LEFT JOIN CONSTRUCTIONBASEINFO C ON C.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE");

                strSQL.Append(", CONSTRUCTIONBASEINFO D");

                strSQL.AppendFormat(" WHERE A.CONSTRUCTIONCODE = {0}", ParentCode);

                strSQL.Append(" AND D.CONSTRUCTIONCODE = A.FLUCTUATIONCODE");

                strSQL.Append(" ORDER BY D.JOINFLG ASC, C.JOINFLG ASC");

                if (!BaseDB.ExecuteReader(strSQL.ToString(), ref arList, false)) return false;

                strSQL.Clear();

                strSQL.Append("SELECT MIN(CONSTRUCTIONSTATUSFLG), MAX(CONSTRUCTIONSTATUSFLG)");

                strSQL.Append(" FROM CONSTRUCTIONBASEINFO");

                strSQL.Append(" WHERE CONSTRUCTIONCODE IN (");

                    if (i != 0) strSQL.Append(", ");

                    strSQL.Append(CodeList[i].ToString());

                strSQL.Append(")");

                if (!BaseDB.ExecuteReader(strSQL.ToString(), ref arList, false)) return false;

        public static bool CheckProcessApproval(int ConstructionCode, int ApprovalCode, int OrderNo)

                // 承認データを取得する

                string strData = ApprDB.CreatePrimarykeyString(ConstructionCode, ApprovalCode, OrderNo, s_PrimartyRecord);

        #region 承認時確認（工事承認）

        /// 工事案件に対して承認ＯＫかを確認する

        public static bool CheckProcessApprovalFinal(int ConstructionCode, int ApprovalCode, int OrderNo)

                StringBuilder strData = new StringBuilder();

                strData.Append(ApprDB.CreatePrimarykeyString(ConstructionCode, ApprovalCode, OrderNo));

                strData.Append(" Order By SeqNo ASC");

                if (!ApprDB.SelectAction(strData.ToString(), ref DataList)) return false;

                // 承認されている場合はそのまま終了

                //if (RequestData.ApprovalStatus == (int)CommonDefine.ApprovalStatus.Approval) return true;

                    PetitionButtonDisplay(AppPnls, btnPetition, btnApproval, lblAppCnt, bNone);

        private static void PetitionButtonDisplay(List<Panel> AppPnls, Button btnPetition, Button btnApproval, Label lblAppCnt, bool bNone)

                int nWidth = AppPnls[(int)AppPnlDef.Normal].Width - 12;

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

            OrderRequestApproval,

                if (CurrentPara.IntExecParameter.Count > 1) frm.ApprovalCode = CurrentPara.IntExecParameter[1];

                if (CurrentPara.IntExecParameter.Count > 2) frm.OrderNo = CurrentPara.IntExecParameter[2];

                frm.EditFlg = true;

            //　請求状況一覧

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Collections;

using log4net;

using MySql.Data.MySqlClient;

using ProcessManagement.DB.MySql;

using ProcessManagement.DB.Core;

using ProcessManagement.DataModel;

using ProcessManagement.Common;

namespace ProcessManagement.DB.IOAccess

{

    /// <summary>

    /// 請求書削除データアクセスクラス

    /// </summary>

    public class IORemInvoiceData : MySqlProcess

    {

        #region 定義部

        /// <summary>

        /// log4netログを使用する

        /// </summary>

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

        #endregion

        #region 定数

        /// <summary>

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

        /// </summary>

        public enum NameColumn

        {

            InvoiceNo = 0,

            RemPerson,

            RemDate,

            RemComment,

            EntryDate,

            UpdateDate,

        }

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

        /// <param name="connectionString"></param>

        public IORemInvoiceData()

                : base(DBCommon.Instance.DBConnectString)

        {

        }

        #endregion

        #region SELECT　SQL作成

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

                {

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

                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 RemInvoiceData data, bool bConnect = true)

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            ArrayList arData = new ArrayList();

            try

            {

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

                strcmd.Append(CreateSelectSQL());

                strcmd.Append(AddSQLString);

                // SQL実行

                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) 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 請求書削除データ検索(複数件取得)

        /// <summary>

        /// 請求書削除データ検索(複数件取得)

        /// </summary>

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

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

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

        /// <returns></returns>

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

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            ArrayList arData = new ArrayList();

            try

            {

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

                strcmd.Append(CreateSelectSQL());

                strcmd.Append(AddSQLString);

                // SQL実行

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

                // データセット

                foreach (object[] objwrk in arData)

                {

                    RemInvoiceData work = new RemInvoiceData();

                    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 請求書削除データ１件追加

        /// <summary>

        /// 請求書削除データ１件追加

        /// </summary>

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

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

        /// <returns></returns>

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.Append("INSERT INTO RemInvoiceData");

                strcmd.Append("(");

                bool bFirst = true;

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

                {

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

                    strcmd.Append(gender.ToString());

                    bFirst = false;

                }

                strcmd.Append(") VALUES (");

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

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

                strcmd.AppendFormat(", DATE('{0}')", data.RemDate.ToShortDateString());

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

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

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

                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="data">請求データ</param>

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

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                bool bColFirst = true;

                strcmd.Append("INSERT INTO RemInvoiceData");

                strcmd.Append(" (");

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

                {

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

                    strcmd.Append(gender.ToString());

                    bColFirst = false;

                }

                strcmd.Append(") VALUES (");

                bool bDataFirst = true;

                foreach (RemInvoiceData work in data)

                {

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

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

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

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

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

                    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, RemInvoiceData data, bool bConnect = true)

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.Append("UPDATE RemInvoiceData");

                strcmd.Append(" SET");

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

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

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

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

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

        /// <returns></returns>

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

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.AppendFormat("{0}{1}", "DELETE FROM RemInvoiceData", 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 MySQLDataReaderより構造体へセットする

        /// <summary>

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

        /// </summary>

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

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

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

        {

            try

            {

                // データ取得

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

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

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

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

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

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

            }

            catch (MySqlException myex)

            {

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

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 構造体クリア

        /// <summary>

        /// 構造体クリア

        /// </summary>

        /// <param name="wrk"></param>

        public void ClearStruct(ref RemInvoiceData wrk)

        {

            try

            {

                // データ取得

                wrk.InvoiceNo = 0;

                wrk.RemPerson = 0;

                wrk.RemDate = DateTime.Today;

                wrk.RemComment = string.Empty;

                wrk.EntryDate = DateTime.Now;

                wrk.UpdateDate = DateTime.Now;

            }

            catch (MySqlException myex)

            {

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

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

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

        /// <summary>

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

        /// </summary>

        /// <param name="InvoiceNo">請求書No</param>

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

        public string CreatePrimarykeyString(int InvoiceNo)

        {

            StringBuilder strWork = new StringBuilder();

            try

            {

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

                return strWork.ToString();

            }

            catch (Exception ex)

            {

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

                return string.Empty;

            }

        }

        #endregion

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Collections;

using log4net;

using MySql.Data.MySqlClient;

using ProcessManagement.DB.MySql;

using ProcessManagement.DB.Core;

using ProcessManagement.DataModel;

using ProcessManagement.Common;

namespace ProcessManagement.DB.IOAccess

{

    /// <summary>

    /// 請求書削除明細データアクセスクラス

    /// </summary>

    public class IORemInvoiceDataDetail : MySqlProcess

    {

        #region 定義部

        /// <summary>

        /// log4netログを使用する

        /// </summary>

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

        #endregion

        #region 定数

        /// <summary>

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

        /// </summary>

        public enum NameColumn

        {

            InvoiceNo = 0,

            SeqNo,

            RequestNo,

            EntryDate,

            UpdateDate,

        }

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

        /// <param name="connectionString"></param>

        public IORemInvoiceDataDetail()

                : base(DBCommon.Instance.DBConnectString)

        {

        }

        #endregion

        #region SELECT　SQL作成

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

                {

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

                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 RemInvoiceDataDetail data, bool bConnect = true)

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            ArrayList arData = new ArrayList();

            try

            {

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

                strcmd.Append(CreateSelectSQL());

                strcmd.Append(AddSQLString);

                // SQL実行

                if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) 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 請求書削除明細データ検索(複数件取得)

        /// <summary>

        /// 請求書削除明細データ検索(複数件取得)

        /// </summary>

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

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

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

        /// <returns></returns>

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

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            ArrayList arData = new ArrayList();

            try

            {

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

                strcmd.Append(CreateSelectSQL());

                strcmd.Append(AddSQLString);

                // SQL実行

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

                // データセット

                foreach (object[] objwrk in arData)

                {

                    RemInvoiceDataDetail work = new RemInvoiceDataDetail();

                    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 請求書削除明細データ１件追加

        /// <summary>

        /// 請求書削除明細データ１件追加

        /// </summary>

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

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

        /// <returns></returns>

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.Append("INSERT INTO RemInvoiceDataDetail");

                strcmd.Append("(");

                bool bFirst = true;

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

                {

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

                    strcmd.Append(gender.ToString());

                    bFirst = false;

                }

                strcmd.Append(") VALUES (");

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

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

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

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

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

                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="data">請求データ</param>

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

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                bool bColFirst = true;

                strcmd.Append("INSERT INTO RemInvoiceDataDetail");

                strcmd.Append(" (");

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

                {

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

                    strcmd.Append(gender.ToString());

                    bColFirst = false;

                }

                strcmd.Append(") VALUES (");

                bool bDataFirst = true;

                foreach (RemInvoiceDataDetail work in data)

                {

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

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

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

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

                    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, RemInvoiceDataDetail data, bool bConnect = true)

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.Append("UPDATE RemInvoiceDataDetail");

                strcmd.Append(" SET");

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

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

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

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

        /// <returns></returns>

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

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.AppendFormat("{0}{1}", "DELETE FROM RemInvoiceDataDetail", 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 MySQLDataReaderより構造体へセットする

        /// <summary>

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

        /// </summary>

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

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

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

        {

            try

            {

                // データ取得

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

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

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

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

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

            }

            catch (MySqlException myex)

            {

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

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 構造体クリア

        /// <summary>

        /// 構造体クリア

        /// </summary>

        /// <param name="wrk"></param>

        public void ClearStruct(ref RemInvoiceDataDetail wrk)

        {

            try

            {

                // データ取得

                wrk.InvoiceNo = 0;

                wrk.SeqNo = 0;

                wrk.RequestNo = 0;

                wrk.EntryDate = DateTime.Now;

                wrk.UpdateDate = DateTime.Now;

            }

            catch (MySqlException myex)

            {

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

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

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

        /// <summary>

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

        /// </summary>

        /// <param name="InvoiceNo">請求書No</param>

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

        public string CreatePrimarykeyString(int InvoiceNo, int SeqNo = 0)

        {

            StringBuilder strWork = new StringBuilder();

            try

            {

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

                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 定数

        public enum CompleteFlgDef

        {

            /// <summary>

            /// 削除済み

            /// </summary>

            Deleted = -1,

            /// <summary>

            /// 未印刷

            /// </summary>

            NoPrint = 0,

            /// <summary>

            /// 印刷済み

            /// </summary>

            Printed,

        }

        #endregion

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ProcessManagement.DataModel

{

    /// <summary>

    /// 請求書削除データ

    /// </summary>

    public class RemInvoiceData

    {

        #region メンバ変数

        /// <summary>

        ///  請求書No

        /// </summary>

        private int         m_InvoiceNo = 0;

        /// <summary>

        /// 削除担当者コード

        /// </summary>

        private int         m_RemPerson = 0;

        /// <summary>

        /// 削除日付

        /// </summary>

        private DateTime    m_RemDate = DateTime.Today;

        /// <summary>

        /// 削除理由

        /// </summary>

        private string      m_RemComment = string.Empty;

        /// <summary>

        /// 登録日付

        /// </summary>

        private DateTime    m_EntryDate = DateTime.Now;

        /// <summary>

        /// 更新日付

        /// </summary>

        private DateTime    m_UpdateDate = DateTime.Now;

        #endregion

        #region コンストラクタ

        #endregion

        #region プロパティ

        /// <summary>

        ///  請求書No

        /// </summary>

        public int InvoiceNo

        {

            get { return m_InvoiceNo; }

            set { m_InvoiceNo = value; }

        }

        /// <summary>

        /// 削除担当者コード

        /// </summary>

        public int RemPerson

        {

            get { return m_RemPerson; }

            set { m_RemPerson = value; }

        }

        /// <summary>

        /// 削除日付

        /// </summary>

        public DateTime RemDate

        {

            get { return m_RemDate; }

            set { m_RemDate = value; }

        }

        /// <summary>

        /// 削除理由

        /// </summary>

        public string RemComment

        {

            get { return m_RemComment; }

            set { m_RemComment = value; }

        }

        /// <summary>

        /// 登録日付

        /// </summary>

        public DateTime EntryDate

        {

            get { return m_EntryDate; }

            set { m_EntryDate = value; }

        }

        /// <summary>

        /// 更新日付

        /// </summary>

        public DateTime UpdateDate

        {

            get { return m_UpdateDate; }

            set { m_UpdateDate = value; }

        }

        #endregion

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ProcessManagement.DataModel

{

    /// <summary>

    /// 請求書削除明細データ

    /// </summary>

    public class RemInvoiceDataDetail

    {

        #region メンバ変数

        /// <summary>

        ///  請求書No

        /// </summary>

        private int         m_InvoiceNo = 0;

        /// <summary>

        /// 連番

        /// </summary>

        private int         m_SeqNo = 0;

        /// <summary>

        /// 請求No

        /// </summary>

        private int         m_RequestNo = 0;

        /// <summary>

        /// 登録日付

        /// </summary>

        private DateTime    m_EntryDate = DateTime.Now;

        /// <summary>

        /// 更新日付

        /// </summary>

        private DateTime    m_UpdateDate = DateTime.Now;

        #endregion

        #region コンストラクタ

        #endregion

        #region プロパティ

        /// <summary>

        ///  請求書No

        /// </summary>

        public int InvoiceNo

        {

            get { return m_InvoiceNo; }

            set { m_InvoiceNo = value; }

        }

        /// <summary>

        /// 連番

        /// </summary>

        public int SeqNo

        {

            get { return m_SeqNo; }

            set { m_SeqNo = value; }

        }