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

        #region 30:入金入力データ存在確認

        /// <summary>

        /// 30:入金入力データ存在確認

        /// </summary>

        /// <returns></returns>

        private static bool ExistPaymentConf()

        {

            IORequestHead ReqHed = new IORequestHead();

            try

            {

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("Select Count(*) From RequestHead As ReqHead");

                strSQL.Append(" Inner Join InvoiceData As InvData");

                strSQL.Append("       On InvData.InvoiceNo = ReqHead.InvoiceNo");

                strSQL.AppendFormat(" Where ReqHead.REQCONSTRUCTIONCODE = {0}", m_SearchCode);

                ArrayList ReqList = new ArrayList();

                if (!ReqHed.ExecuteReader(strSQL.ToString(), ref ReqList)) return false;

                if (ReqList.Count < 1) return false;

                object[] ObjRec = (object[])ReqList[0];

                if (CommonMotions.cnvInt(ObjRec[0]) < 1) return false;

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

            finally

            {

                ReqHed.close(); ReqHed = null;

            }

        }

        #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 IORemoveRequest : MySqlProcess

    {

        #region 定義部

        /// <summary>

        /// log4netログを使用する

        /// </summary>

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

        #endregion

        #region 定数

        /// <summary>

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

        /// </summary>

        public enum NameColumn

        {

            RemoveNo = 0,

            RemoveDate,

            RemovePersonCode,

            RemoveComment,

            RequestNo,

            ReqConstructionCode,

            OrderNo,

            RequestMonth,

            OrderersDivision,

            OrderersCode,

            OrderersName,

            ReqConstructionName,

            RequestTotalAmount,

            RequestAmount,

            TaxAmount,

            UnpaidAmount,

            Note,

            AssignedFlg,

            InvoiceNo,

            ENTRYDATE,

            UPDATEDATE,

        }

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

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

        public IORemoveRequest()

            : base(DBCommon.Instance.DBConnectString)

        {

        }

        #endregion

        #region SELECT　SQL作成

        /// <summary>

        /// SQL作成

        /// </summary>

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

                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>

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

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            ArrayList arData = new ArrayList();

            try

            {

                strcmd.Append(CreateSelectSQL());

                strcmd.Append(AddSQLString);

                // SQL実行

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

                // データセット

                foreach (object[] objwrk in arData)

                {

                    RemoveRequest work = new RemoveRequest();

                    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>

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                bool bColFirst = true;

                strcmd.Append("INSERT INTO RemoveRequest");

                strcmd.Append(" (");

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

                {

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

                    strcmd.Append(gender.ToString());

                    bColFirst = false;

                }

                strcmd.Append(") VALUES (");

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                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>

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.Append("UPDATE RemoveRequest");

                strcmd.Append(" SET");

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                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>

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

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.AppendFormat("{0}{1}", "DELETE FROM RemoveRequest", 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>

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

        {

            try

            {

                // データ取得

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                wrk.InvoiceNo = int.Parse(objwrk[(int)NameColumn.InvoiceNo].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="RequestNo">請求No</param>

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

        public string CreatePrimarykeyString(int RemoveNo, int RemoveDate = 0)

        {

            StringBuilder strWork = new StringBuilder();

            try

            {

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

                if (RemoveDate != 0)

                    strWork.AppendFormat(" And RemoveDate = {0}", RemoveDate);

            }

            catch (Exception ex)

            {

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

            }

            return strWork.ToString();

        }

        #endregion

        #region 請求取消Noの採番

        /// <summary>

        /// 請求取消Noの採番

        /// </summary>

        /// <returns></returns>

        public int NumberingRemoveNo(int RemoveDate, bool bConnect = true)

        {

            int ret = -1;

            StringBuilder sql = new StringBuilder();

            ArrayList arData = new ArrayList();

            try

            {

                sql.AppendFormat("SELECT IFNULL(MAX(RemoveNo),0) FROM RemoveRequest WHERE RemoveDate = {0}", RemoveDate) ;

                // SQL実行

                if (!ExecuteReader(sql.ToString(), ref arData, bConnect)) return -1;

                // データセット

                foreach (object[] objwrk in arData)

                {

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

                    break;

                }

                if (ret > 0)

                {

                    ret++;

                }

                else

                {

                    ret = (RemoveDate * 100) + 1;

                }

            }

            catch (Exception ex)

            {

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

            }

            return ret;

        }

        #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 IORemoveRequestDetail : MySqlProcess

    {

        #region 定義部

        /// <summary>

        /// log4netログを使用する

        /// </summary>

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

        #endregion

        #region 定数

        /// <summary>

        /// 請求取消データ明細フィールド並び

        /// </summary>

        public enum NameColumn

        {

            RemoveNo = 0,

            SeqNo,

            RequestNo,

            MainConstructionCode,

            ConstructionCode,

            ConstructionKind,

            RequestAmount,

            TaxAmount,

            ENTRYDATE,

            UPDATEDATE,

        }

        #endregion

        #region コンストラクタ

        /// <summary>

        /// コンストラクタ

        /// </summary>

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

        public IORemoveRequestDetail()

            : base(DBCommon.Instance.DBConnectString)

        {

        }

        #endregion

        #region SELECT　SQL作成

        /// <summary>

        /// SQL作成

        /// </summary>

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

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

        {

            // インターフェース

            StringBuilder strcmd = new StringBuilder();

            ArrayList arData = new ArrayList();

            try

            {

                strcmd.Append(CreateSelectSQL());

                strcmd.Append(AddSQLString);

                // SQL実行

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

                // データセット

                foreach (object[] objwrk in arData)

                {

                    RemoveRequestDetail work = new RemoveRequestDetail();

                    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>

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

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                bool bColFirst = true;

                strcmd.Append("INSERT INTO RemoveRequestDetail");

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

                {

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

                    else strcmd.Append(", (");

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

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

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

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

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

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

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

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

                    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>

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

        /// <returns></returns>

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                bool bColFirst = true;

                strcmd.Append("INSERT INTO RemoveRequestDetail");

                strcmd.Append(" (");

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

                {

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

                    strcmd.Append(gender.ToString());

                    bColFirst = false;

                }

                strcmd.Append(") VALUES (");

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

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

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

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

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

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

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

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

                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="AddSQLString">更新条件SQL文字列</param>

        /// <param name="data">請求取消データ明細</param>

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

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

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                strcmd.Append("UPDATE RemoveRequestDetail");

                strcmd.Append(" SET");

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

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

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

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

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

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

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

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

                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 RemoveRequestDetail", 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 RemoveRequestDetail wrk)

        {

            try

            {

                // データ取得

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

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

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

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

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

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

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

                wrk.TaxAmount = long.Parse(objwrk[(int)NameColumn.TaxAmount].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>

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

        {

            StringBuilder strWork = new StringBuilder();

            try

            {

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

                if(SeqNo != 0)

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

            }

            catch (Exception ex)

            {

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

            }

            return strWork.ToString();

        }

        #endregion

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace ProcessManagement.DataModel

{

    /// <summary>

    /// 請求取消データ

    /// </summary>

    public class RemoveRequest

    {

        #region メンバ変数

        private int         m_RemoveNo = 0;                     // 取消No

        private int         m_RemoveDate = 0;                   // 請求取消日

        private int         m_RemovePersonCode = 0;             // 請求取消担当者コード

        private string      m_RemoveComment = string.Empty;     // 明細内容

        private int         m_RequestNo = 0;                    // 請求No

        private int         m_ReqConstructionCode = 0;          // 請求工事番号

        private int         m_OrderNo = 0;                      // 受付番号

        private int         m_RequestMonth = 0;                 // 請求月

        private int         m_OrderersDivision = 0;             // 発注者区分

        private int         m_OrderersCode = 0;                 // 発注者コード

        private string      m_OrderersName = "";                // 発注者名

        private string      m_ReqConstructionName = "";         // 請求工事件名

        private long        m_RequestTotalAmount = 0;           // 請求金額合計

        private long        m_RequestAmount = 0;                // 請求金額

        private long        m_TaxAmount = 0;                    // 消費税

        private long        m_UnpaidAmount = 0;                 // 未入金

        private string      m_Note ="";                         // 備考

        private int         m_AssignedFlg = 0;                  // 割当済フラグ

        private int         m_InvoiceNo = 0;                    // 請求書No

        private DateTime    m_EntryDate = DateTime.Now;         // 登録日付

        private DateTime    m_UpdateDate = DateTime.Now;        // 更新日付

        #endregion

        #region コンストラクタ

        #endregion

        #region プロパティ

        /// <summary>

        /// 取消No

        /// </summary>

        public int RemoveNo

        {

            get { return m_RemoveNo; }

            set { m_RemoveNo = value; }

        }

        /// <summary>

        /// 請求取消日

        /// </summary>

        public int RemoveDate

        {

            get { return m_RemoveDate; }

            set { m_RemoveDate = value; }

        }

        /// <summary>

        /// 請求取消担当者コード

        /// </summary>

        public int RemovePersonCode

        {

            get { return m_RemovePersonCode; }

            set { m_RemovePersonCode = value; }

        }

        /// <summary>

        /// 明細内容

        /// </summary>

        public string RemoveComment

        {

            get { return m_RemoveComment; }

            set { m_RemoveComment = value; }

        }

        /// <summary>

        /// 請求No

        /// </summary>

        public int RequestNo

        {

            get { return m_RequestNo; }

            set { m_RequestNo = value; }

        }

        /// <summary>

        /// 請求工事番号

        /// </summary>

        public int ReqConstructionCode

        {

            get { return m_ReqConstructionCode; }

            set { m_ReqConstructionCode = value; }

        }

        /// <summary>

        /// 受付番号

        /// </summary>

        public int OrderNo

        {

            get { return m_OrderNo; }

            set { m_OrderNo = value; }

        }

        /// <summary>

        /// 請求月

        /// </summary>

        public int RequestMonth

        {

            get { return m_RequestMonth; }

            set { m_RequestMonth = value; }

        }

        /// <summary>

        /// 発注者区分

        /// </summary>

        public int OrderersDivision

        {

            get { return m_OrderersDivision; }

            set { m_OrderersDivision = value; }

        }

        /// <summary>

        /// 発注者コード

        /// </summary>

        public int OrderersCode

        {

            get { return m_OrderersCode; }

            set { m_OrderersCode = value; }

        }

        /// <summary>

        /// 発注者名

        /// </summary>

        public string OrderersName

        {

            get { return m_OrderersName; }

            set { m_OrderersName = value; }

        }

        /// <summary>

        /// 請求工事件名

        /// </summary>

        public string ReqConstructionName

        {

            get { return m_ReqConstructionName; }

            set { m_ReqConstructionName = value; }

        }

        /// <summary>

        /// 請求金額合計

        /// </summary>

        public long RequestTotalAmount

        {

            get { return m_RequestTotalAmount; }

            set { m_RequestTotalAmount = value; }

        }

        /// <summary>

        /// 請求金額

        /// </summary>

        public long RequestAmount

        {

            get { return m_RequestAmount; }

            set { m_RequestAmount = value; }

        }

        /// <summary>

        /// 消費税

        /// </summary>

        public long TaxAmount

        {

            get { return m_TaxAmount; }

            set { m_TaxAmount = value; }

        }

        /// <summary>

        /// 未入金

        /// </summary>

        public long UnpaidAmount

        {

            get { return m_UnpaidAmount; }

            set { m_UnpaidAmount = value; }

        }

        /// <summary>

        /// 備考

        /// </summary>

        public string Note

        {

            get { return m_Note; }

            set { m_Note = value; }

        }

        /// <summary>

        /// 割当済フラグ

        /// </summary>

        public int AssignedFlg

        {

            get { return m_AssignedFlg; }

            set { m_AssignedFlg = value; }

        }

        /// <summary>

        /// 請求書No

        /// </summary>

        public int InvoiceNo

        {

            get { return m_InvoiceNo; }

            set { m_InvoiceNo = 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 RemoveRequestDetail

    {

        #region 定数

        /// <summary>

        /// 工事区分定義

        /// </summary>

        public enum ConstructionKindDef

        {

            /// <summary>

            /// 0:本工事

            /// </summary>

            Original = 0,

            /// <summary>

            /// 1:追加工事（増減工事）

            /// </summary>

            Additional,

        }

        #endregion

        #region メンバ変数

        private int         m_RemoveNo = 0;                     // 取消No

        private int         m_SeqNo = 0;                        // 受付No

        private int         m_RequestNo = 0;                    // 請求No

        private int         m_MainConstructionCode = 0;         // 本工事番号

        private int         m_ConstructionCode = 0;             // 工事番号

        private int         m_ConstructionKind = 0;             // 工事区分

        private long        m_RequestAmount = 0;                // 請求金額

        private long        m_TaxAmount = 0;                    // 消費税

        private DateTime    m_EntryDate = DateTime.Now;         // 登録日付

        private DateTime    m_UpdateDate = DateTime.Now;        // 更新日付

        #endregion

        #region コンストラクタ

        #endregion

        #region プロパティ

        /// <summary>

        /// 取消No

        /// </summary>

        public int RemoveNo

        {

            get { return m_RemoveNo; }

            set { m_RemoveNo = value; }

        }

        /// <summary>

        /// 受付No

        /// </summary>

        public int SeqNo

        {

            get { return m_SeqNo; }

            set { m_SeqNo = value; }

        }

        /// <summary>

        /// 請求No

        /// </summary>

        public int RequestNo

        {

            get { return m_RequestNo; }

            set { m_RequestNo = value; }

        }

        /// <summary>

        /// 本工事番号

        /// </summary>

        public int MainConstructionCode

        {

            get { return m_MainConstructionCode; }

            set { m_MainConstructionCode = value; }

        }

        /// <summary>

        /// 工事番号

        /// </summary>

        public int ConstructionCode

        {

            get { return m_ConstructionCode; }

            set { m_ConstructionCode = value; }

        }

        /// <summary>

        /// 工事区分

        /// </summary>

        public int ConstructionKind

        {

            get { return m_ConstructionKind; }

            set { m_ConstructionKind = value; }

        }

        /// <summary>

        /// 請求金額

        /// </summary>

        public long RequestAmount

        {

            get { return m_RequestAmount; }

            set { m_RequestAmount = value; }

        }

        /// <summary>

        /// 消費税

        /// </summary>

        public long TaxAmount

        {

            get { return m_TaxAmount; }

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

    }

}

                                                    IOConstructionProgressDate cpdDB,

                                                    bool MsgOn)

                {   // ?????????X?V

                    if (!ConstructionProgressDateEntry(cpdDB

                                                        , BeforeStatus

                                                        , work.ConstructionStatusFlg)) return false;

                    // ?????????X?e?[?^?X??X?????????i????????????????????j

                    if (MsgOn)

                    {

                        if (!SyncFluctuationData(cbiDB, iStatus)) return false;

                    }

                {   // ?V?K?o?^????o?^

                        if (!ConstructionProgressDateEntry(cpdDB

                                                            , BeforeStatus

                                                            , work.ConstructionStatusFlg)) return false;

        #region ?????????X?e?[?^?X??X????????

        /// <summary>

        /// ?????????X?e?[?^?X??X????????

        /// </summary>

        /// <returns></returns>

        private bool SyncFluctuationData(IOConstructionBaseInfo cbiDB, int nStatus)

        {

            FrmConstrProgDiag frm = new FrmConstrProgDiag();

            try

            {

                int[] nStatArrary = new int[] {CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?{?H????")).Key,

                                                CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?{?H????")).Key,

                                                CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?{?H?J?n")).Key,

                                                CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?{?H????")).Key,

                                                CommonDefine.ProjectsStatus.First(x => x.Value.Equals("????????")).Key,

                                                CommonDefine.ProjectsStatus.First(x => x.Value.Equals("?????m?F")).Key};

                bool bAns = false;

                for (int i = 0; i < nStatArrary.Length; i++)

                {

                    if (nStatArrary[i] != nStatus) continue;

                    bAns = true;

                    break;

                }

                if (!bAns) return true;

                // ?????f?[?^?I??

                frm.ConstructionCode = m_ConstructionCode;

                DialogResult drRwt = frm.ShowDialog();

                if (drRwt == DialogResult.Cancel) return true;

                bool bRet = true;

                for(int i = 0; i < frm.TergetList.Count; i++)

                {

                    int nCode = frm.TergetList[i];

                    if (!cbiDB.UpdateFeild(nCode

                                            , (int)IOConstructionBaseInfo.TableColumn.ConstructionStatusFlg

                                            , nStatus

                                            , false))

                    {

                        bRet = false;

                        break;

                    }

                }

                return bRet;

            }

            catch (System.Exception ex)

            {

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

                return false;

            }

            finally

            {

                frm.Dispose(); frm = null;

            }

        }

        #endregion

                if (!ConstructionBaseInfoDataEntry(cbiDB, cpdDB, MsgOn))

namespace ProcessManagement.Forms.DataEntry

{

    partial class FrmCancelDisplay

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows Form Designer generated code

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();

            System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle();

            this.btnEnd = new System.Windows.Forms.Button();

            this.dgvMain = new ProcessManagement.Forms.CustomControls.DataGridViewEX();

            this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            this.Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn();

            ((System.ComponentModel.ISupportInitialize)(this.dgvMain)).BeginInit();

            this.SuspendLayout();

            // 

            // btnEnd

            // 

            this.btnEnd.BackColor = System.Drawing.Color.Blue;

            this.btnEnd.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));

            this.btnEnd.ForeColor = System.Drawing.Color.White;

            this.btnEnd.Location = new System.Drawing.Point(872, 176);

            this.btnEnd.Name = "btnEnd";

            this.btnEnd.Size = new System.Drawing.Size(120, 30);

            this.btnEnd.TabIndex = 3;

            this.btnEnd.Text = "終　了";

            this.btnEnd.UseVisualStyleBackColor = false;

            this.btnEnd.Click += new System.EventHandler(this.btnEnd_Click);

            // 

            // dgvMain

            // 

            this.dgvMain.AllowUserToAddRows = false;

            this.dgvMain.AllowUserToDeleteRows = false;

            this.dgvMain.AllowUserToResizeColumns = false;

            this.dgvMain.AllowUserToResizeRows = false;

            this.dgvMain.BackgroundColor = System.Drawing.Color.White;

            this.dgvMain.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;

            dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            dataGridViewCellStyle1.BackColor = System.Drawing.SystemColors.Control;

            dataGridViewCellStyle1.Font = new System.Drawing.Font("ＭＳ 明朝", 12F, System.Drawing.FontStyle.Bold);

            dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText;

            dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight;

            dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText;

            dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.True;

            this.dgvMain.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;

            this.dgvMain.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing;

            this.dgvMain.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {

            this.Column1,

            this.Column2,

            this.Column3,

            this.Column4,

            this.Column5});

            this.dgvMain.EnableHeadersVisualStyles = false;

            this.dgvMain.Location = new System.Drawing.Point(2, 2);

            this.dgvMain.Name = "dgvMain";

            this.dgvMain.RowHeadersVisible = false;

            this.dgvMain.RowHeadersWidth = 20;

            this.dgvMain.RowHeadersWidthSizeMode = System.Windows.Forms.DataGridViewRowHeadersWidthSizeMode.DisableResizing;

            this.dgvMain.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.CellSelect;

            this.dgvMain.Size = new System.Drawing.Size(990, 172);

            this.dgvMain.TabIndex = 0;

            // 

            // Column1

            // 

            dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            dataGridViewCellStyle2.BackColor = System.Drawing.Color.White;

            dataGridViewCellStyle2.Font = new System.Drawing.Font("Century", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));

            dataGridViewCellStyle2.ForeColor = System.Drawing.Color.Black;

            dataGridViewCellStyle2.Format = "N0";

            this.Column1.DefaultCellStyle = dataGridViewCellStyle2;

            this.Column1.HeaderText = "№";

            this.Column1.Name = "Column1";

            this.Column1.ReadOnly = true;

            this.Column1.Resizable = System.Windows.Forms.DataGridViewTriState.False;

            this.Column1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;

            this.Column1.Width = 50;

            // 

            // Column2

            // 

            dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;

            dataGridViewCellStyle3.BackColor = System.Drawing.Color.White;

            dataGridViewCellStyle3.Font = new System.Drawing.Font("Century", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));