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

            /// 宿泊費

            /// </summary>

            Lodging,

        }

        /// <summary>

        /// データ種別

        /// </summary>

        #endregion

        #region 汎用データ：コードデータ種別

        /// <summary>

        /// 本体バージョン

        /// </summary>

        /// <summary>

        /// コピー・環境バージョン

                // 結合工事表示

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

                strParent += " FROM CONSTRUCTIONLINK A";

                strParent += " , CONSTRUCTIONBASEINFO B";

                strParent += string.Format(" WHERE A.FLUCTUATIONCODE = {0}", SearchCode);

                GetLedgerColumnCount();

                // 対象をまず削除する(対象月で削除する)

                strDelSQL += " WHERE CONSTRUCTIONCODE IN";

                strDelSQL += " (SELECT A1.CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO A1";

                strDelSQL += string.Format(" WHERE (A1.SALESPERSONCODE = {0} OR A1.CONSTRUCTIONPERSONCODE = {0} OR A1.CONSTRSUBPERSONCODE = {0} OR A1.CONSTRUCTIONINSTRUCTOR = {0}))", PersonCode);

                                                                , GetConstructionLedgerGroupNo((int)CommonDefine.CostDataNo.Purchase)

                                                                , GetConstructionLedgerGroupNo((int)CommonDefine.CostDataNo.Lease)

                                                                , GetConstructionLedgerGroupNo((int)CommonDefine.CostDataNo.StoragePlace)

                strDelSQL += string.Format(" AND DATE(TARGETMONTH) = STR_TO_DATE('{0}','%Y/%m/%d')", (TargetMonth + "/01"));

                LedgerExcuteDB.ExecuteNonQuery(strDelSQL, false);

                {

                    string strSQL = "SELECT CONSTRUCTIONCODE, DATATYPE, DATE_FORMAT(ACTIONDATE,'%Y/%m'), SUM(ENTRYPRICE) FROM COSTDATAOFPERSON";

                    strSQL += String.Format(" WHERE DATE_FORMAT(ACTIONDATE,'%Y/%m') = '{0}'", TargetMonth);

                        }

                    }

                }

                // 工事詳細台帳の更新

                {

                }

                return true;

            }

            catch (System.Exception ex)

        }

        #endregion

        /// <summary>

        /// </summary>

        /// <param name="ConstrCode"></param>

        {

            try

            {

            }

            catch (System.Exception ex)

            {

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

            }

            {

            }

        }

        #endregion

                    // 宿泊費

                    GroupNo = (int)FrmConstructionLedger.DataGroup.RoomChargeCosts;

                    break;

            }

            return GroupNo;

        }

        /// </summary>

        private static void GetLedgerColumnCount()

        {

            try

            {

            }

            catch (System.Exception ex)

            {

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

            }

        }

        #endregion

        /// <returns></returns>

        public static bool UpdateRecalLedgerDataFromTAndPCost(int PersonCode, string TargetMonth)

        {

            IOCostDataOfPerson CostDB = new IOCostDataOfPerson();

            try

            {

                string strSQL = "SELECT PERSONCODE, DATE_FORMAT(ACTIONDATE,'%Y/%m'), CONSTRUCTIONCODE FROM COSTDATAOFPERSON";

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

                if (arList.Count == 0) return true;

                foreach (object[] wrkobj in arList)

                {

                    int ConstructionCode = CommonMotions.cnvInt(wrkobj[2]);

                }

            }

            catch (System.Exception ex)

            {

            finally

            {

                CostDB.close(); CostDB = null;

            }

        }

        #endregion

            IOConstructionLedgerDetail LedgerDeDB = new IOConstructionLedgerDetail();

            IOConstructionLedgerExcute LedgerExDB = new IOConstructionLedgerExcute();

            IOMPersonInCharge PersonDB = new IOMPersonInCharge();

            try

            {

                // 工事詳細台帳明細データ取得

                bool bret = true;

                // データ初期セット時に振分無・日数入力は次のループをしない

                //if (bSetFlag && LoopBreak) bret = false;

                LedgerDeDB.close(); LedgerDeDB = null;

                LedgerExDB.close(); LedgerExDB = null;

                PersonDB.close(); PersonDB = null;

            }

        }

        #endregion

        /// <returns></returns>

        public static int CalcTargetMonthToColumn(DateTime StartDate, DateTime TargetMonth)

        {

            try

            {

                // 処理対象年月日を対象月月初日に変換する

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

                return Columncnt;

            }

        }

        #endregion

using ProcessManagement.Common;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

namespace ProcessManagement.Common

{

                else

                {

                    // 掲示板閲覧テーブルのチェック

                    strSQL += " LEFT JOIN PERSONINCHARGEMASTER C ON C.PERSONCODE = A.TOCODE";

                    strSQL += " LEFT JOIN SECURITYMASTER D ON D.SECCODE = C.SECCODE";

                    strSQL += " , MESSAGEBOARDDATA B";

using ProcessManagement.Common;

using ProcessManagement.DB.IOAccess;

using ProcessManagement.DataModel;

namespace ProcessManagement.Common

{

                        if (wrkRec.TyingFlg == (int)CommonDefine.BaseInfoTyingFlg.Tying) continue;

                        // 結合工事の親は処理しない

                        if (wrkRec.JoinFlg == (int)CommonDefine.BaseInfoJoinFlg.JoinParent) continue;

                        // チェック

                        if (!ConstructionStatusCheck(wrkRec, CriteriaDate, ref term))

                        {

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

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

                strcmd += AddSQLString;

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

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

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

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

                strcmd += AddSQLString;

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

                        break;

                }

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

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

                                                    data.OrderDate.ToShortDateString());        // 申請日

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

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(PersonCode, AttendanceMonth);

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

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

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

                    strcmd += ")";

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

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

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

                strcmd += AddSQLString;

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

            try

            {

                strcmd = "Update BankBusinessDayMaster Set DeleteFlg = 1";

                strcmd += AddSQLString;

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

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

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

                    strcmd += ")";

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

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

                strcmd += AddSQLString;

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

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

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

                    strcmd += ")";

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

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

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

                strcmd += AddSQLString;

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

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

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

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

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

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

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

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

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

                    strcmd += ")";

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

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

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

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode, DetailNo);

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

                strcmd += string.Format(", I_SalaryFlg = {0}", data.I_SalaryFlg);                       // 指導員給与振分区分

                strcmd += string.Format(", I_SalaryDays = {0}", data.I_SalaryDays);                     // 指導員振分日数

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

                strcmd += string.Format(", NegotiateFlg = {0}", data.NegotiateFlg);                 // 協力業者交渉フラグ

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

                strcmd += string.Format(", ComplateFlg = {0}", data.ComplateFlg);                   // 入力完了フラグ

                strcmd += string.Format(", IntegrationFlg = {0}", data.IntegrationFlg);             // 受注金額積算フラグ

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

                strcmd += string.Format(", SalaryOnRegist = {0}", data.SalaryOnRegist);             // 登録時月額給与

                strcmd += string.Format(", PurchaseOrderFlg = {0}", data.PurchaseOrderFlg);         // 注文書発行フラグ

                strcmd += AddSQLString;

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

                strcmd += " SET";

                UpdateFeildSQL(FeildNo, value, ref strcmd);

                strcmd += CreatePrimarykeyString(ConstructionCode, GroupCount, LineCount);

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

                UpdateFeildSQL(FeildNo, value, ref strcmd);

                strcmd += strWhere;

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

                strcmd += string.Format(", PaymentAmount = {0}", data.PaymentAmount);               // 支払金額

                strcmd += string.Format(", TargetMonth = STR_TO_DATE('{0}','%Y/%m/%d')", data.TargetMonth.ToShortDateString());   // 対象年月

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode, GroupCount, LineCount, ColumnCount);

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

                strcmd += string.Format(", DetailNo = {0}", data.FluctuationCode);

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

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

                        break;

                }

                strcmd += string.Format(" WHERE FluctuationCode = {0}", FluctuationCode);

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

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

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

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

                strcmd += string.Format(",ComplateFlg = {0}", data.ComplateFlg);                // 引込済みフラグ

                strcmd += string.Format(",ApprovalFlg = {0}", data.ApprovalFlg);                // 承認フラグ

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

                        break;

                }

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

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

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

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

                strcmd += ")";

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += string.Format(",Weather = '{0}'", data.Weather);                      // 天気

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(PersonCode, DailyDataDate, ConstructionCode);

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

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

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

                strcmd += string.Format(",NextdayHeadCount =  {0} ", data.NextdayHeadCount);    // 翌日人員数

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(PersonCode, DailyDataDate, ConstructionCode, SeqNo);

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

                                        , data.PatrolTime.ToShortDateString());                 // 巡回時間

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

                strcmd += AddSQLString;

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

                strcmd += string.Format(",Delivery = '{0}'", data.Delivery);                    // 納入業者

                strcmd += string.Format(",QualityControl = '{0}'", data.QualityControl);        // 品質管理事項

                strcmd += AddSQLString;

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

                strcmd += string.Format(",Attendee = '{0}'", data.Attendee);                    // 出席者

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

                strcmd += AddSQLString;

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

                                        , data.StartWorkingTime.ToString());                    // 作業時間開始

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

                                        , data.EndWorkingTime.ToString());                      // 作業時間終了

                strcmd += AddSQLString;

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

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

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

                    strcmd += ")";

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

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

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

                strcmd += AddSQLString;

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

            try

            {

                strcmd = "Update DeadLineMaster Set DeleteFlg = 1";

                strcmd += AddSQLString;

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

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

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

                    strcmd += string.Format(", DATE_FORMAT('{0}','%Y%m%d')", data.ApprovalDate.ToString());

                    strcmd += ")";

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

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

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

                strcmd += string.Format(",ApprovalDate = DATE_FORMAT('{0}','%Y%m%d')", data.ApprovalDate.ToString());

                strcmd += AddSQLString;

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

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

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

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

                    strcmd += ")";

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

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

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

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

                strcmd += AddSQLString;

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

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

                strcmd += string.Format(", {0}", data.ApprovalEndFlg ? 1 : 0);

                strcmd += ")";

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

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

                strcmd += string.Format(",ApprovalEndFlg = {0}", data.ApprovalEndFlg ? 1 : 0);

                strcmd += string.Format(" where OrderersDivision = {0} and OrderersCode = {1} and TargetDate = {2} and SeqNo = {3} and LineCount = {4} ",

                    data.OrderersDivision, data.OrderersCode, data.TargetDate, data.SeqNo, data.LineCount);

                strcmd += AddSQLString;

                strcmd += string.Format(",ConstructionTime = {0}", data.ConstructionTime);                      // 工期

                strcmd += string.Format(",IntegratedCode = {0}", data.IntegratedCode);                          // 積算者

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

                strcmd += string.Format(",RetValue1 = {0}", data.RetValue1);                                    // 予定価格

                strcmd += string.Format(",RetValue2 = {0}", data.RetValue2);                                    // 直接工事費

                strcmd += string.Format(",RetValue3 = {0}", data.RetValue3);                                    // 積み上げ共通仮設費

                strcmd += string.Format(",RetValue4 = {0}", data.RetValue4);                                    // 積み上げ現場管理費

                strcmd += string.Format(",RetPercent = {0}", data.RetPercent);                                  // 一般管理費率

                strcmd += AddSQLString;

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

                strcmd += string.Format(", NegotiationPrice = {0}", data.NegotiationPrice);         // 交渉時金額

                strcmd += string.Format(", Notes = '{0}'", data.Notes);                             // 注意事項

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

                strcmd += string.Format(", Note = '{0}'", data.Note.Replace(",", "，"));			    // 備考

                strcmd += string.Format(", MyExpensesFlg = {0}", data.MyExpensesFlg);       // 自社経費フラグ

                strcmd += string.Format(", InputFlg = {0}", data.InputFlg);                 // 入力フラグ

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

                strcmd += string.Format(",PageTitle ='{0}'", data.PageTitle);                // ページ表示名

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

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

                strcmd += string.Format(",MyExpensesFlg = {0}", data.MyExpensesFlg);        // 自社経費フラグ

                strcmd += string.Format(",InputFlg = {0}", data.InputFlg);                  // 入力フラグ

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ConstructionCode);

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

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

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

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

                strcmd += ")";

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

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

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

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

                strcmd += AddSQLString;

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

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

                strcmd += AddSQLString;

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

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

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

                    strcmd += ")";

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

                        break;

                }

                strcmd += CreatePrimarykeyString(ComponentCode);

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += ")";

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

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

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

                strcmd += AddSQLString;

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

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

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

                    strcmd += ")";

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

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

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