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

        public static int s_SystemVersion = 57;

                for (int i = 3; i < CurrentPara.IntExecParameter.Count; i++)

                    frm.PurchaseOrderSeqNo.Add(CurrentPara.IntExecParameter[i]);

            strcmd.Append("SELECT");

            strcmd.Append("  ConstructionCode");

            strcmd.Append(", TyingFlg");

            strcmd.Append(", JoinFlg");

            strcmd.Append(", ConstructionYear");

            strcmd.Append(", ConstructionPeriod");

            strcmd.Append(", DATE_FORMAT(RequestedDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(EstimatesSubmitDeadline, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(EstimatesSubmittedDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(ProvisionalOrderDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(OrderDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(OrderStartingDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(OrderCompletionDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(PreparationStartDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(ConstructionStartingDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(ConstructionCompletionDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(NonOrderDate, '%Y/%m/%d')");

            strcmd.Append(", OrdersDecisionPrice");

            strcmd.Append(", OrdersDecisionPriceInTax");

            strcmd.Append(", SalesPersonCode");

            strcmd.Append(", ConstructionPersonCode");

            strcmd.Append(", ConstrSubPersonCode");

            strcmd.Append(", ConstructionInstructor");

            strcmd.Append(", TransferConstruction");

            strcmd.Append(", DATE_FORMAT(TransferConstructionDate, '%Y/%m/%d')");

            strcmd.Append(", OrderersDivision");

            strcmd.Append(", OrderersCode");

            strcmd.Append(", DATE_FORMAT(EstimatesExpirationDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(ConstructionPeriodStart, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(ConstructionPeriodEnd, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(ConstructionPeriodStart2, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(ConstructionPeriodEnd2, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(StartDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(EndDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(PurchaseOrderMailingDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(PurchaseOrderReturnDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(PurchaseOrderReturnCheckDate, '%Y/%m/%d')");

            strcmd.Append(", ConsumptionTaxFlg");

            strcmd.Append(", PrimeContractorFlg");

            strcmd.Append(", SalesCostFlg");

            strcmd.Append(", ConstructionStatusFlg");

            strcmd.Append(", ConstructionType");

            strcmd.Append(", EstimateType");

            strcmd.Append(", DATE_FORMAT(BillingStartDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(BillingDate, '%Y/%m/%d')");

            strcmd.Append(", BillingSplitFlg");

            strcmd.Append(", DATE_FORMAT(BillingSendDate, '%Y/%m/%d')");

            strcmd.Append(", DATE_FORMAT(LedgerComplateDate, '%Y/%m/%d')");

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

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

            strcmd.Append(" FROM ConstructionBaseInfo");

            return strcmd.ToString();

        public string CreatePrimarykeyString(int ConstructionCode, int ApprovalCode = 0, int OrderNo = 0, int SeqNo = 0, string APara = "")

                if (ApprovalCode != 0)

                if (OrderNo != 0)

                if (SeqNo != 0)

        public enum DataColumn

            PettionDate,

            strcmd.Append("  ConstructionCode");

            strcmd.Append(", PettionDate");

            strcmd.Append(", PersonCode");

            strcmd.Append(", StringValue");

            strcmd.Append(", OrderNo");

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

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

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

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

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

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

                strcmd.AppendFormat(", PettionDate = STR_TO_DATE('{0}','%Y/%m/%d')", data.PettionDate.ToShortDateString());

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

                wrk.PettionDate = DateTime.Parse(objwrk[(int)DataColumn.PettionDate].ToString());

                wrk.PersonCode = int.Parse(objwrk[(int)DataColumn.PersonCode].ToString());

                wrk.StringValue = objwrk[(int)DataColumn.StringValue].ToString();

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

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

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

        public string CreatePrimarykeyString(int ConstructionCode, DateTime PettionDate, int PersonCode = 0)

                strWork.AppendFormat(" Adn PettionDate = STR_TO_DATE('{0}','%Y/%m/%d')", PettionDate.ToShortDateString());

                if (PersonCode != 0)

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

        public enum DataColumn

            PettionDate,

            PersonCode,

            strcmd.Append(", PettionDate");

            strcmd.Append(", PersonCode");

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

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

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

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

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

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

                strcmd.AppendFormat(", PettionDate = STR_TO_DATE('{0}','%Y/%m/%d')", data.PettionDate.ToShortDateString());

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

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

                wrk.PettionDate = DateTime.Parse(objwrk[(int)DataColumn.PettionDate].ToString());

                wrk.PersonCode = int.Parse(objwrk[(int)DataColumn.PersonCode].ToString());

                wrk.CompanyCode = int.Parse(objwrk[(int)DataColumn.CompanyCode].ToString());

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

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

        public string CreatePrimarykeyString(int ConstructionCode, DateTime PettionDate, int PersonCode = 0, int CompanyCode = 0)

                strWork.AppendFormat(" Adn PettionDate = STR_TO_DATE('{0}','%Y/%m/%d')", PettionDate.ToShortDateString());

                if (PersonCode != 0)

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

                if (CompanyCode != 0)

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

        private int m_ConstructionCode = 0;

        /// 申請日時

        private DateTime m_PettionDate = DateTime.MinValue;

        private int m_PersonCode = 0;

        private string m_StringValue = string.Empty;

        /// 申請受付番号

        private int m_OrderNo = 0;

        private DateTime m_EntryDate = DateTime.Now;

        private DateTime m_UpdateDate = DateTime.Now;

        /// 申請日時

        public DateTime PettionDate

            get { return m_PettionDate; }

            set { m_PettionDate = value; }

        /// 申請受付番号

        private int m_ConstructionCode = 0;

        /// 申請日時

        private DateTime m_PettionDate = DateTime.MinValue;

        /// 申請者番号

        private int m_PersonCode = 0;

        private int m_CompanyCode = 0;

        private DateTime m_EntryDate = DateTime.Now;

        private DateTime m_UpdateDate = DateTime.Now;

        /// 申請日時

        public DateTime PettionDate

            get { return m_PettionDate; }

            set { m_PettionDate = value; }

        /// 申請者番号

        public int PersonCode

            get { return m_PersonCode; }

            set { m_PersonCode = value; }

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Text;

using System.Windows.Forms;

using System.Collections;

using System.Linq;

using System.Diagnostics;

using System.Data.Common;

using log4net;

using log4net.Appender;

using log4net.Repository.Hierarchy;

using ProcessManagement.Common;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

using ProcessManagement.DB.Core;

using ProcessManagement.Forms.Master;

using ProcessManagement.Forms.SubForms;

using ProcessManagement.Forms.ControlsAction;

using ProcessManagement.Forms.CustomControls;

namespace ProcessManagement.Forms.DataEntry

{

    partial class FrmApprovalPerson

    {

        #region 最終承認が成された後の処理

        /// <summary>

        /// 最終承認が成された後の処理

        /// </summary>

        private void FinalUpdateSourceData()

        {

            try

            {

                switch (m_ApprovalCode)

                {

                    case (int)ClsExcute.ApprovalListNo.DRWorkApproval:

                        // 8:出勤管理承認

                        break;

                    case (int)ClsExcute.ApprovalListNo.CostomerRegistApproval:

                        // 9:発注者登録承認

                        CreateCostomerData();

                        break;

                    case (int)ClsExcute.ApprovalListNo.SubConstregistApproval:

                        // 10:協力会社登録承認

                        CreateSubConstrData();

                        break;

                }

            }

            catch (Exception ex)

            {

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

            }

        }

        #endregion

        #region 発注者マスタの登録

        /// <summary>

        /// 発注者マスタの登録

        /// </summary>

        private void CreateCostomerData()

        {

            IOMOrderers OrderDB = new IOMOrderers(); 

            IOCostomerRegist RegistDB = new IOCostomerRegist();

            try

            {

                // 発注者登録申請データ取得

                string strSQL = RegistDB.CreatePrimarykeyString(m_PersonCode, m_SearchDate, m_SearchSeqNo);

                CostomerRegist RegistRec = new CostomerRegist();

                if (!RegistDB.SelectAction(strSQL, ref RegistRec))

                {

                    MessageBox.Show("発注者登録申請データが存在しません。", "登録確認エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return;

                }

                OrderDB.connect(); OrderDB.beginTran();

                RegistDB.connect(); RegistDB.beginTran();

                // 新規・修正処理

                switch (RegistRec.DataMode)

                {

                    case (int)FrmCostomerRegist.DataMode.NewData:

                        // ソースのコードがあれば再度の作成はしない

                        if (RegistRec.SourceCode != 0) return;

                        // 新規データ作成

                        CreateCostomer(OrderDB, RegistDB, ref RegistRec, strSQL);

                        break;

                    case (int)FrmCostomerRegist.DataMode.EditData:

                        // 既存データ更新

                        UpdateCostomer(OrderDB, RegistRec);

                        break;

                }

                OrderDB.commit();

                RegistDB.commit();

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                RegistDB.close(); RegistDB = null;

                OrderDB.close(); OrderDB = null;

            }

        }

        #endregion

        #region 発注者マスタ新規データ作成

        /// <summary>

        /// 発注者マスタ新規データ作成

        /// </summary>

        private bool CreateCostomer(IOMOrderers OrderDB, IOCostomerRegist RegistDB, ref CostomerRegist RegistRec, string SourceSQL)

        {

            try

            {

                // 新規発注者コード取得

                string strSQL = OrderDB.CreatePrimarykeyString(RegistRec.OrderCotegory);

                int OrderersCode = OrderDB.SelectMaxOrderersCodeCount(strSQL, false) + 1;

                // 表示順取得

                int DispOrder = OrderDB.GetMaxDisplayOrder(strSQL, false) + 1;

                strSQL = "INSERT INTO ORDERERSMASTER";

                strSQL += " SELECT";

                strSQL += " OrderCotegory,";

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

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

                strSQL += " OrderFlg,";

                strSQL += " CorporateStatusName,";

                strSQL += " CorporateStatusPoint,";

                strSQL += " OrderersName1,";

                strSQL += " OrderersName2,";

                strSQL += " DepartmentName,";

                strSQL += " ChargePersonName,";

                strSQL += " ZipCode,";

                strSQL += " Address1,";

                strSQL += " Address2,";

                strSQL += " Address3,";

                strSQL += " PhoneNumber,";

                strSQL += " FaxNumber,";

                strSQL += " MailAddress,";

                strSQL += " Note,";

                strSQL += " 0,";

                strSQL += " NOW(),";

                strSQL += " NOW()";

                strSQL += " FROM COSTOMERREGIST";

                strSQL += SourceSQL;

                if (!OrderDB.ExecuteNonQuery(strSQL, false))

                {

                    OrderDB.rollback();

                    MessageBox.Show("発注者マスタ、登録に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                // 新規番号のセット

                RegistRec.SourceCode = OrderersCode;

                // 成功時は発注者登録データにコードセット

                strSQL = "UPDATE COSTOMERREGIST SET";

                strSQL += string.Format(" SOURCECOTEGORY = {0}", RegistRec.OrderCotegory);

                strSQL += string.Format(", SOURCECODE = {0}", RegistRec.SourceCode);

                strSQL += RegistDB.CreatePrimarykeyString(m_PersonCode, m_SearchDate, m_SearchSeqNo);

                if (!RegistDB.ExecuteNonQuery(strSQL, false))

                {

                    OrderDB.rollback();

                    RegistDB.rollback();

                    MessageBox.Show("発注者登録申請データ更新に失敗しました。", "更新エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 発注者マスタ既存データ更新

        /// <summary>

        /// 発注者マスタ既存データ更新

        /// </summary>

        private bool UpdateCostomer(IOMOrderers OrderDB, CostomerRegist RegistRec)

        {

            try

            {

                string strSQL = "UPDATE OrderersMaster";

                strSQL += " SET";

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

                strSQL += string.Format(", CorporateStatusName = '{0}'", RegistRec.CorporateStatusName);

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

                strSQL += string.Format(", OrderersName1 = '{0}'", RegistRec.OrderersName1);

                strSQL += string.Format(", OrderersName2 = '{0}'", RegistRec.OrderersName2);

                strSQL += string.Format(", DepartmentName = '{0}'", RegistRec.DepartmentName);

                strSQL += string.Format(", ChargePersonName = '{0}'", RegistRec.ChargePersonName);

                strSQL += string.Format(", ZipCode = '{0}'", RegistRec.ZipCode);

                strSQL += string.Format(", Address1 = '{0}'", RegistRec.Address1);

                strSQL += string.Format(", Address2 = '{0}'", RegistRec.Address2);

                strSQL += string.Format(", Address3 = '{0}'", RegistRec.Address3);

                strSQL += string.Format(", PhoneNumber = '{0}'", RegistRec.PhoneNumber);

                strSQL += string.Format(", FaxNumber = '{0}'", RegistRec.FaxNumber);

                strSQL += string.Format(", Note = '{0}'", RegistRec.Note);

                strSQL += string.Format(", MailAddress = '{0}'", RegistRec.MailAddress);

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

                strSQL += OrderDB.CreatePrimarykeyString(RegistRec.SourceCotegory, RegistRec.SourceCode);

                if (!OrderDB.ExecuteNonQuery(strSQL, false))

                {

                    OrderDB.rollback();

                    MessageBox.Show("発注者マスタ、更新に失敗しました。", "更新エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 協力会社マスタの登録

        /// <summary>

        /// 協力会社マスタの登録

        /// </summary>

        private void CreateSubConstrData()

        {

            IOMSubContractor SubConstrDB = new IOMSubContractor();

            IOSubConstrRegist RegistDB = new IOSubConstrRegist();

            try

            {

                // 協力会社登録申請データ取得

                string strSQL = RegistDB.CreatePrimarykeyString(m_PersonCode, m_SearchDate, m_SearchSeqNo);

                SubConstrRegist RegistRec = new SubConstrRegist();

                if (!RegistDB.SelectAction(strSQL, ref RegistRec))

                {

                    MessageBox.Show("協力会社登録申請データが存在しません。", "登録確認エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return;

                }

                SubConstrDB.connect(); SubConstrDB.beginTran();

                RegistDB.connect(); RegistDB.beginTran();

                // 新規・修正処理

                switch (RegistRec.DataMode)

                {

                    case (int)FrmCostomerRegist.DataMode.NewData:

                        // ソースのコードがあれば再度の作成はしない

                        if (RegistRec.SourceCode != 0) break;

                        // ----- 新規データ作成

                        // 協力会社登録

                        if (!CreateSubConstr(SubConstrDB, RegistDB, ref RegistRec, strSQL)) break;

                        // 協力業者施工工種登録

                        if (!CreateSubConstrJobItem(SubConstrDB, RegistRec, strSQL))

                        {

                            RegistDB.rollback();

                            break;

                        }

                        // 協力業者職種リンク登録

                        if (!CreateSubConstrJobLink(SubConstrDB, RegistRec, strSQL))

                        {

                            RegistDB.rollback();

                            break;

                        }

                        break;

                    case (int)FrmCostomerRegist.DataMode.EditData:

                        // 既存データ更新

                        if (!UpdateSubConstr(SubConstrDB, RegistRec)) break;

                        // 協力業者施工工種登録

                        if (!UpdateSubConstrJobItem(SubConstrDB, RegistRec, strSQL)) break;

                        // 協力業者職種リンク登録

                        if (!UpdateSubConstrJobLink(SubConstrDB, RegistRec, strSQL)) break;

                        break;

                }

                SubConstrDB.commit();

                RegistDB.commit();

            }

            catch (Exception ex)

            {

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

            }

            finally

            {

                RegistDB.close(); RegistDB = null;

                SubConstrDB.close(); SubConstrDB = null;

            }

        }

        #endregion

        #region 協力会社マスタ新規データ作成

        /// <summary>

        /// 協力会社マスタ新規データ作成

        /// </summary>

        private bool CreateSubConstr(IOMSubContractor SubDB, IOSubConstrRegist RegistDB, ref SubConstrRegist RegistRec, string SourceSQL)

        {

            try

            {

                // 新規協力会社コード取得

                int CompanyCode = SubDB.SelectMaxCompanyCodeCount("", false) + 1;

                int DisplayOrder = SubDB.SelectMaxDisplayOrderCount("", false) + 1;

                string strSQL = "INSERT INTO SUBCONTRACTORMASTER";

                strSQL += " SELECT";

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

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

                strSQL += " CorporateStatusName,";

                strSQL += " CorporateStatusPoint,";

                strSQL += " CompanyName,";

                strSQL += " CEOPositionName,";

                strSQL += " CEOName,";

                strSQL += " ContactPersonName,";

                strSQL += " ZipCode,";

                strSQL += " Address1,";

                strSQL += " Address2,";

                strSQL += " Address3,";

                strSQL += " CellPhoneNumber,";

                strSQL += " MailAddress,";

                strSQL += " PhoneNumber,";

                strSQL += " FaxNumber,";

                strSQL += " JapaneseSyllabary,";

                strSQL += " StartDate,";

                strSQL += " Note,";

                strSQL += " labourKind,";

                strSQL += " 0,";

                strSQL += " NOW(),";

                strSQL += " NOW()";

                strSQL += " FROM SUBCONSTRREGIST";

                strSQL += SourceSQL;

                if (!SubDB.ExecuteNonQuery(strSQL, false))

                {

                    SubDB.rollback();

                    MessageBox.Show("協力会社マスタ、登録に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                // 新規番号のセット

                RegistRec.SourceCode = CompanyCode;

                // 成功時は発注者登録データにコードセット

                strSQL = string.Format("UPDATE SUBCONSTRREGIST SET SOURCECODE = {0}", RegistRec.SourceCode);

                strSQL += SourceSQL;

                if (!RegistDB.ExecuteNonQuery(strSQL, false))

                {

                    SubDB.rollback();

                    RegistDB.rollback();

                    MessageBox.Show("発注者登録申請データ更新に失敗しました。", "更新エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 協力業者施工工種登録申請データ新規作成

        /// <summary>

        /// 協力業者施工工種登録申請データ新規作成

        /// </summary>

        private bool CreateSubConstrJobItem(IOMSubContractor SubDB, SubConstrRegist RegistRec, string SourceSQL)

        {

            try

            {

                // データ無は処理しない

                string strSQL = "SELECT count(*) FROM SUBCONSTRJOBITEMREGIST";

                strSQL += SourceSQL;

                ArrayList arCnt = new ArrayList();

                if (!SubDB.ExecuteReader(strSQL, ref arCnt, false)) return false;

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

                object[] Datacnt = (object[])arCnt[0];

                if (CommonMotions.cnvInt(Datacnt[0]) == 0) return true;

                strSQL = "INSERT INTO SUBCONTRACTORJOBITEM";

                strSQL += " SELECT";

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

                strSQL += " ItemCode,";

                strSQL += " DisplayOrder,";

                strSQL += " NOW(),";

                strSQL += " NOW()";

                strSQL += " FROM SubConstrJobItemRegist";

                strSQL += SourceSQL;

                if (!SubDB.ExecuteNonQuery(strSQL, false))

                {

                    SubDB.rollback();

                    MessageBox.Show("協力業者施工工種登録申請データ、登録に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 協力業者職種リンク登録申請データ新規作成

        /// <summary>

        /// 協力業者職種リンク登録申請データ新規作成

        /// </summary>

        private bool CreateSubConstrJobLink(IOMSubContractor SubDB, SubConstrRegist RegistRec, string SourceSQL)

        {

            try

            {

                // データ無は処理しない

                string strSQL = "SELECT count(*) FROM SubConstrJobLinkRegist";

                strSQL += SourceSQL;

                ArrayList arCnt = new ArrayList();

                if (!SubDB.ExecuteReader(strSQL, ref arCnt, false)) return false;

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

                object[] Datacnt = (object[])arCnt[0];

                if (CommonMotions.cnvInt(Datacnt[0]) == 0) return true;

                strSQL = "INSERT INTO SubContractorJobLink";

                strSQL += " SELECT";

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

                strSQL += " JobCategoryCode,";

                strSQL += " DisplayOrder,";

                strSQL += " NOW(),";

                strSQL += " NOW()";

                strSQL += " FROM SubConstrJobLinkRegist";

                strSQL += SourceSQL;

                if (!SubDB.ExecuteNonQuery(strSQL, false))

                {

                    SubDB.rollback();

                    MessageBox.Show("協力業者職種リンク登録申請データ、登録に失敗しました。", "登録エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 協力会社マスタ既存データ更新

        /// <summary>

        /// 協力会社マスタ既存データ更新

        /// </summary>

        private bool UpdateSubConstr(IOMSubContractor SubDB, SubConstrRegist RegistRec)

        {

            try

            {

                string strSQL = "UPDATE SubContractorMaster";

                strSQL += " SET";

                strSQL += string.Format(" CompanyCode = {0}", RegistRec.SourceCode);

                strSQL += string.Format(", CorporateStatusName = '{0}'", RegistRec.CorporateStatusName);

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

                strSQL += string.Format(", CompanyName = '{0}'", RegistRec.CompanyName);

                strSQL += string.Format(", CEOPositionName = '{0}'", RegistRec.CEOPositionName);

                strSQL += string.Format(", CEOName = '{0}'", RegistRec.CEOName);

                strSQL += string.Format(", ContactPersonName = '{0}'", RegistRec.ContactPersonName);

                strSQL += string.Format(", ZipCode = '{0}'", RegistRec.ZipCode);

                strSQL += string.Format(", Address1 = '{0}'", RegistRec.Address1);

                strSQL += string.Format(", Address2 = '{0}'", RegistRec.Address2);

                strSQL += string.Format(", Address3 = '{0}'", RegistRec.Address3);

                strSQL += string.Format(", CellPhoneNumber = '{0}'", RegistRec.CellPhoneNumber);

                strSQL += string.Format(", MailAddress = '{0}'", RegistRec.MailAddress);

                strSQL += string.Format(", PhoneNumber = '{0}'", RegistRec.PhoneNumber);

                strSQL += string.Format(", FaxNumber = '{0}'", RegistRec.FaxNumber);

                strSQL += string.Format(", JapaneseSyllabary = '{0}'", RegistRec.JapaneseSyllabary);

                strSQL += string.Format(", StartDate = STR_TO_DATE('{0}','%Y/%m/%d')", RegistRec.StartDate.ToShortDateString());

                strSQL += string.Format(", Note = '{0}'", RegistRec.Note);

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

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

                strSQL += SubDB.CreatePrimarykeyString(RegistRec.SourceCode);

                if (!SubDB.ExecuteNonQuery(strSQL, false))

                {

                    SubDB.rollback();

                    MessageBox.Show("協力会社マスタ、更新に失敗しました。", "更新エラー", MessageBoxButtons.OK, MessageBoxIcon.Error);

                    return false;

                }

                return true;

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 協力業者施工工種登録申請データ更新

        /// <summary>

        /// 協力業者施工工種登録申請データ更新

        /// </summary>

        private bool UpdateSubConstrJobItem(IOMSubContractor SubDB, SubConstrRegist RegistRec, string SourceSQL)

        {

            try

            {

                // まず削除して

                string strSQL = "DELETE FROM SubContractorJobItem";

                strSQL += string.Format(" WHERE CompanyCode = {0}", RegistRec.SourceCode);

                SubDB.ExecuteNonQuery(strSQL, false);

                // 新規作成

                return CreateSubConstrJobItem(SubDB, RegistRec, SourceSQL);

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

        #region 協力業者職種リンク登録申請データ更新

        /// <summary>

        /// 協力業者職種リンク登録申請データ更新

        /// </summary>

        private bool UpdateSubConstrJobLink(IOMSubContractor SubDB, SubConstrRegist RegistRec, string SourceSQL)

        {

            try

            {

                // まず削除して

                string strSQL = "DELETE FROM SubContractorJobLink";

                strSQL += string.Format(" WHERE CompanyCode = {0}", RegistRec.SourceCode);

                SubDB.ExecuteNonQuery(strSQL, false);

                // 新規作成

                return CreateSubConstrJobLink(SubDB, RegistRec, SourceSQL);

            }

            catch (Exception ex)

            {

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

                return false;

            }

        }

        #endregion

    }

}