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

                DateTime dtDefaultStart = CommonMotions.GetOpeningEndDate(nTargetYear, true);

                DateTime dtDefaultEnd = CommonMotions.GetOpeningEndDate(nTargetYear, false);

                strSQL.Append(" personinchargemaster As A");

                strSQL.Append(" Left Join chgchargedep As B");

                strSQL.Append("       On B.PersonCode = A.PersonCode");

                strSQL.Append(", A.PersonName");

                strSQL.Append(", B.DepartmentCode");

                strSQL.Append(", B.DepartmentName");

                strSQL.AppendFormat(" AND (DATE('{0}') <= DATE(A.ENDDATE)", dtDefaultStart.ToShortDateString());

                strSQL.AppendFormat(" OR DATE('{0}') = DATE(A.ENDDATE)))", DateTime.MinValue.ToShortDateString());

        /// <summary>

        /// 営業日だけのｎ日前の日付を取る

        /// </summary>

        {

            IOMHolidayCalender CalDB = new IOMHolidayCalender();

            try

            {

                {

                    return dtTarget;

                }

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("     (SELECT A1.years, A2.month, A3.days");

                strSQL.Append("           , CAST(CONCAT(A1.years, '/', A2.month, '/', A3.days) as DATE) as d");

                strSQL.Append("      FROM yearmaster as A1");

                ArrayList arList = new ArrayList();

                CalDB.ExecuteReader(strSQL.ToString(), ref arList);

                DateTime dtRet = DateTime.MinValue;

                int nPrevCount = 0;

                foreach(object[] objCalender in arList)

                    DateTime dtholiday = CommonMotions.cnvDate(objCalender[1]);

                    if (DateTime.MinValue.Date != dtholiday.Date) continue;

                    nPrevCount++;

                    if (nCount <= nPrevCount)

                    {

            finally

            {

                CalDB.close(); CalDB = null;

            }

        }

        #endregion

            ConstrExpenses = 126,               // 126:施工経費区分登録

            MaterialKind = 127,                 // 127:資材種類マスタ

            MaterialItem = 128,                 // 128:資材品目マスタ

            BankBusinessDay = 130,              // 130:銀行営業日マスタ

            BudgetCodeSum = 131,                // 131:予算書集計コードマスタ

            AddressConvert = 132,               // 132:郵便番号変換処理

            QualificationD = 134,               // 134:資格マスタ分類

            QualificationQ = 135,               // 135:資格マスタ区分

            WorkingTime = 136,                  // 136:就業時間マスタ

        }

        #endregion

                                                                                { (int)MaintenanceExecuteNo.QualificationD,             "資格マスタ区分登録" },        // 134

                                                                                { (int)MaintenanceExecuteNo.QualificationQ,             "資格マスタ登録" },            // 135

                                                                                { (int)MaintenanceExecuteNo.WorkingTime,                "就業時間マスタ" },            // 136

                                                                                };

        #endregion

                        case (int)ClsExcute.MaintenanceExecuteNo.WorkingTime:               // 136:就業時間マスタ

                            MaintenanceExecuteNo_WorkingTime(m_ProcControlPara[NowPoint]);

                            break;

                        #endregion

                frm.ConstructionCode = CurrentPara.IntExecParameter[0];

                frm.OrderNo = CurrentPara.IntExecParameter[1];

                int nApprovalNo = CurrentPara.IntExecParameter[2];

                frm.CreateData = CurrentPara.BoolExecParameter[0];

                // フォーム表示

            }

        }

        #endregion

        #endregion

        #region サブフォーム

        #region 掲示板メッセージ入力

        /// <summary>

                // 対象データの取得

                StringBuilder strSQL = new StringBuilder();

                strSQL.Append("SELECT");

                strSQL.Append(" FROM");

                strSQL.Append(" MESSAGEBOARDDATA A");

                strSQL.Append(" LEFT JOIN PERSONINCHARGEMASTER B");

                // 工事日報入力起動

                frm.ConstructionCode = ClsProcessExist.GetParentConstrCode(ConstrCode);

                frm.EditLock = EditLock;

                frm.SubForm = true;

                frm.ShowInTaskbar = true;

using System.Data;

using System.Linq;

using System.Text;

using System.Collections;

using MySql.Data.MySqlClient; 

                        //objwrk[i++] = www.ToString().Equals("null") ? "" : www;

                        objwrk[i++] = www is null ? "" : www;

                    }

                    arData.Add(objwrk);

                }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                strcmd.AppendFormat(", {0}", work.AttendanceMonth);                             // 出勤管理年月

                strcmd.AppendFormat(", {0}", work.OrderNo);                                     // 届番号

                strcmd.AppendFormat(", {0}", work.ConstructionCode);                            // 工事コード

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

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

                    strcmd.AppendFormat(", {0}", work.AttendanceMonth);                             // 出勤管理年月

                    strcmd.AppendFormat(", {0}", work.OrderNo);                                     // 届番号

                    strcmd.AppendFormat(", {0}", work.ConstructionCode);                            // 工事コード

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

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

                strcmd.AppendFormat(", AttendanceMonth = {0}", data.AttendanceMonth);                       // 出勤管理年月

                strcmd.AppendFormat(", OrderNo = {0}", data.OrderNo);                                       // 届番号

                strcmd.AppendFormat(", ConstructionCode = {0}", data.ConstructionCode);                     // 工事コード

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

                strcmd.Append(AddSQLString);

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

                        break;

                    case (int)TableColumn.ConstructionName:     // 工事名称

                        break;

                }

        #endregion

        #region SQL作成

        /// <summary>

        /// SQL作成

        /// </summary>

        private string CreateSelectSQL()

        {

            StringBuilder strcmd = new StringBuilder();

            {

            }

        }

        #endregion

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

                strcmd.AppendFormat(", {0}", work.SeqNo);                                           // 明細行番号

                strcmd.AppendFormat(", {0}", work.ConstructionCode);                                // 工事番号

                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.StartTime);    // 開始時間

                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.CompTime);     // 終了時間

                strcmd.AppendFormat(", {0}", work.DayTimes);                                        // 稼働時間

                strcmd.AppendFormat(", {0}", work.Overtime);                                        // 時間外就業

                strcmd.AppendFormat(", {0}", work.OvertimeWA);                                      // 残業認可時間

                strcmd.AppendFormat(", {0}", work.WorkKindFlg);                                     // 作業区分フラグ

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

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

                    strcmd.AppendFormat(", {0}", work.SeqNo);                                           // 明細行番号

                    strcmd.AppendFormat(", {0}", work.ConstructionCode);                                // 工事番号

                    strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.StartTime);    // 開始時間

                    strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.CompTime);     // 終了時間

                    strcmd.AppendFormat(", {0}", work.DayTimes);                                        // 稼働時間

                    strcmd.AppendFormat(", {0}", work.Overtime);                                        // 時間外就業

                    strcmd.AppendFormat(", {0}", work.OvertimeWA);                                      // 残業認可時間

                    strcmd.AppendFormat(", {0}", work.WorkKindFlg);                                     // 作業区分フラグ

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

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

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

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

                strcmd.AppendFormat(",StartTime = STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')"

                                        , data.StartTime);                                  // 開始時間

                strcmd.AppendFormat(",DayTimes = {0}", data.DayTimes);                      // 稼働時間

                strcmd.AppendFormat(",Overtime = {0}", data.Overtime);                      // 時間外就業

                strcmd.AppendFormat(",OvertimeWA = {0}", data.OvertimeWA);                  // 残業認可時間

                strcmd.AppendFormat(",WorkKindFlg = {0}", data.WorkKindFlg);                // 作業区分フラグ

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

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

                        break;

                    case (int)TableColumn.ActionResult:

                        break;

                    case (int)TableColumn.StartTime:

                        strcmd.AppendFormat(" StartTime = STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", ((DateTime)value).ToString());

                        strcmd.AppendFormat(" OvertimeWA = {0}", (decimal)value);

                        break;

                    case (int)TableColumn.WorkingComment:

                        break;

                    case (int)TableColumn.WorkKindFlg:

                        strcmd.AppendFormat(" WorkKindFlg = {0}", (int)value);

                strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.ToDate);   // 申請終了日時

                strcmd.AppendFormat(", {0}", work.NoticePeriod);                                // 勤怠期間日

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

                strcmd.AppendFormat(", {0}", work.ApprovalDate);                                // 承認日

                strcmd.AppendFormat(", {0}", work.ApprovalNo);                                  // 承認受付番号

                strcmd.AppendFormat(", {0}", work.DeleteFlg);                                   // 削除フラグ

                    strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.ToDate);   // 申請終了日時

                    strcmd.AppendFormat(", {0}", work.NoticePeriod);                                // 勤怠期間日

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

                    strcmd.AppendFormat(", {0}", work.ApprovalDate);                                // 承認日

                    strcmd.AppendFormat(", {0}", work.ApprovalNo);                                  // 承認受付番号

                    strcmd.AppendFormat(", {0}", work.DeleteFlg);                                   // 削除フラグ

                strcmd.AppendFormat(", HolidayReason = {0}", data.HolidayReason);                           // 休み区分

                strcmd.AppendFormat(", FromDate = STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.FromDate);  // 申請開始日時

                strcmd.AppendFormat(", ToDate = STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", data.ToDate);      // 申請終了日時

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

                strcmd.AppendFormat(", ApprovalDate = {0}", data.ApprovalDate);                             // 承認日

                strcmd.AppendFormat(", ApprovalNo = {0}", data.ApprovalNo);                                 // 承認受付番号

                strcmd.AppendFormat(", DeleteFlg = {0}", data.DeleteFlg);                                   // 削除フラグ

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

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

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

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

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

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

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

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

            SeqNoB,

            LineCount,

            LabourKind,

            YearNumber,

            CostType,

            TargetType,

            TargetCode,

            SeqNoC,

            EntryDate,

            UpdateDate,

        }

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                strcmd.Append(AddSQLString);

                    case (int)NameColumn.LabourKind:

                        strcmd.AppendFormat(" LabourKind = {0}", (int)value);

                        break;

                    case (int)NameColumn.YearNumber:

                        strcmd.AppendFormat(" YearNumber = {0}", (int)value);

                        break;

                    case (int)NameColumn.SeqNoC:

                        strcmd.AppendFormat(" SeqNoC = {0}", (int)value);

                        break;

                }

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

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

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

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

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

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

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

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

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

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

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

        /// <summary>

        /// 行ロック

        /// </summary>

        /// <returns></returns>

        public bool RowLock(int CompanyCode, int TargetDate, int SeqNo, int LineCount, int LabourKind, bool bConnect = true)

        {

        /// <summary>

        /// 行ロック

        /// </summary>

        /// <returns></returns>

        public bool RowLock(int CompanyCode, int TargetDate, int SeqNo, bool bConnect = true)

        {

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

        /// <summary>

        /// 行ロック

        /// </summary>

        /// <returns></returns>

        public bool RowLock(int CompanyCode, int TargetDate, int SeqNo, int LineCount, int LabourKind, bool bConnect = true)

        {

        /// <summary>

        /// 行ロック

        /// </summary>

        /// <returns></returns>

        public bool RowLock(int CompanyCode, int TargetDate, int ChargePaymentKind, bool bConnect = true)

        {

        #endregion

        /// <summary>

        /// </summary>

        {

            StringBuilder strcmd = new StringBuilder();

            try

            {

                bool bColFirst = true;

                string strWork = string.Empty;

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

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

                    if (strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))

                    {

                    }

                    else if (strWork.Equals("RequestedDate")

                            || strWork.Equals("EstimatesSubmitDeadline")

                            || strWork.Equals("InspectExecuteDate")

                            || strWork.Equals("RevCompleteDate"))

                    {

                    }

                    else

                    {

                    }

                    bColFirst = false;

                }

                return strcmd.ToString();

            }

            catch (Exception ex)

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

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

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

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

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

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

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

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

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

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

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

                strcmd.Append(AddSQLString);

                        strcmd.AppendFormat(" DetailNo = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.DETAILSTRING:

                        break;

                }

        #endregion

        #region 検索の文字列を返す

        /// <summary>

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

        /// </summary>

                strcmd.AppendFormat("  {0}", work.ConstructionCode);                // 工事番号

                strcmd.AppendFormat(", {0}", work.CreatorCode);                     // 作成者コード

                strcmd.AppendFormat(", {0}", work.CreatorCosts);                    // 作成者給与

                strcmd.AppendFormat(", {0}", work.AssistantCode);                   // 副担当者コード

                strcmd.AppendFormat(", {0}", work.AssistantCosts);                  // 副担当者給与

                strcmd.AppendFormat(", {0}", work.InstructorCode);                  // 工事指導員コード

                strcmd.AppendFormat(", {0}", work.InstructorCosts);                 // 工事指導員給与

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

                    strcmd.AppendFormat("  {0}", work.ConstructionCode);                // 工事番号

                    strcmd.AppendFormat(", {0}", work.CreatorCode);                     // 作成者コード

                    strcmd.AppendFormat(", {0}", work.CreatorCosts);                    // 作成者給与

                    strcmd.AppendFormat(", {0}", work.AssistantCode);                   // 副担当者コード

                    strcmd.AppendFormat(", {0}", work.AssistantCosts);                  // 副担当者給与

                    strcmd.AppendFormat(", {0}", work.InstructorCode);                  // 工事指導員コード

                    strcmd.AppendFormat(", {0}", work.InstructorCosts);                 // 工事指導員給与

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

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

                strcmd.AppendFormat(", CreatorCode = {0}", data.CreatorCode);                       // 作成者コード

                strcmd.AppendFormat(", CreatorCosts = {0}", data.CreatorCosts);                     // 作成者給与

                strcmd.AppendFormat(", AssistantCode = {0}", data.AssistantCode);                   // 副担当者コード

                strcmd.AppendFormat(", AssistantCosts = {0}", data.AssistantCosts);                 // 副担当者給与

                strcmd.AppendFormat(", InstructorCode = {0}", data.InstructorCode);                 // 工事指導員コード

                strcmd.AppendFormat(", InstructorCosts = {0}", data.InstructorCosts);               // 工事指導員給与

                strcmd.AppendFormat(", CreateDate = STR_TO_DATE('{0}','%Y/%m/%d')",

                                                        data.CreateDate.ToShortDateString());       // 作成日

                        strcmd.AppendFormat(" CreatorCode = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.CreatorName:    	    // 作成者名

                        break;

                    case (int)TableColumn.CreatorCosts:	        // 作成者給与

                        strcmd.AppendFormat(" CreatorCosts = {0}", ((double)value).ToString());

                        strcmd.AppendFormat(" AssistantCode = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.AssistantName:        // 副担当者名

                        break;

                    case (int)TableColumn.AssistantCosts:       // 副担当者給与

                        strcmd.AppendFormat(" AssistantCosts = {0}", ((double)value).ToString());

                        strcmd.AppendFormat(" InstructorCode = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.InstructorName:	    // 工事指導員名

                        break;

                    case (int)TableColumn.InstructorCosts:	    // 工事指導員給与

                        strcmd.AppendFormat(" InstructorCosts = {0}", ((double)value).ToString());

                strcmd.AppendFormat(", {0}", work.LineCount);               // 行番号

                strcmd.AppendFormat(", {0}", work.ComponentCode);           // 構成キー

                strcmd.AppendFormat(", {0}", work.ItemCode);		        // 工種キー

                strcmd.AppendFormat(", {0}", work.CompanyType);             // 協力会社コードタイプ

                strcmd.AppendFormat(", {0}", work.CompanyCode);             // 協力会社コード

                strcmd.AppendFormat(", {0}", work.EstimatePrice);           // 見積時金額

                strcmd.AppendFormat(", {0}", work.NegotiationPrice);        // 交渉時金額

                strcmd.AppendFormat(", {0}", work.OrderDesiredAmount);      // 発注希望金額

                    strcmd.AppendFormat(", {0}", work.LineCount);               // 行番号

                    strcmd.AppendFormat(", {0}", work.ComponentCode);           // 構成キー

                    strcmd.AppendFormat(", {0}", work.ItemCode);		        // 工種キー

                    strcmd.AppendFormat(", {0}", work.CompanyType);             // 協力会社コードタイプ

                    strcmd.AppendFormat(", {0}", work.CompanyCode);             // 協力会社コード

                    strcmd.AppendFormat(", {0}", work.EstimatePrice);           // 見積時金額

                    strcmd.AppendFormat(", {0}", work.NegotiationPrice);        // 交渉時金額

                    strcmd.AppendFormat(", {0}", work.OrderDesiredAmount);      // 発注希望金額

                strcmd.AppendFormat(", LineCount = {0}", data.LineCount);                       // 行番号

                strcmd.AppendFormat(", ComponentCode = {0}", data.ComponentCode);               // 構成キー

                strcmd.AppendFormat(", ItemCode = {0}", data.ItemCode);		                    // 工種キー

                strcmd.AppendFormat(", CompanyType = {0}", data.CompanyType);                   // 協力会社コードタイプ

                strcmd.AppendFormat(", CompanyCode = {0}", data.CompanyCode);                   // 協力会社コード

                strcmd.AppendFormat(", EstimatePrice = {0}", data.EstimatePrice);               // 見積時金額

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

                strcmd.AppendFormat(", OrderDesiredAmount = {0}", data.OrderDesiredAmount);     // 発注希望金額

                        strcmd.AppendFormat(" ItemCode = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.FirstString:            // 項目名称

                        break;

                    case (int)TableColumn.SecondString:           // 工事内容

                        break;

                    case (int)TableColumn.CompanyType:            // 協力会社コードタイプ

                        strcmd.AppendFormat(" CompanyType = {0}", ((int)value).ToString());

                        strcmd.AppendFormat(" CompanyCode = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.CompanyName:            // 協力会社名称

                        break;

                    case (int)TableColumn.EstimatePrice:          // 見積時金額

                        strcmd.AppendFormat(" EstimatePrice = {0}", ((double)value).ToString());

                strcmd.AppendFormat(", {0}", work.ConstructionPeriod);              // 事業期

                strcmd.AppendFormat(", {0}", work.CreatorCode);                     // 作成者コード

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

                strcmd.AppendFormat(", {0}", work.ConstructionTimes);               // 工期（単位・月）

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

                                        work.ConstructionStart.ToShortDateString());    // 契約工期開始

                    strcmd.AppendFormat(", {0}", work.ConstructionPeriod);              // 事業期

                    strcmd.AppendFormat(", {0}", work.CreatorCode);                     // 作成者コード

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

                    strcmd.AppendFormat(", {0}", work.ConstructionTimes);               // 工期（単位・月）

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

                                            work.ConstructionStart.ToShortDateString());    // 契約工期開始

                strcmd.AppendFormat(", ConstructionPeriod = {0}", data.ConstructionPeriod);     // 事業期

                strcmd.AppendFormat(", CreatorCode = {0}", data.CreatorCode);                   // 作成者コード

                strcmd.AppendFormat(", CreateDate = STR_TO_DATE('{0}','%Y/%m/%d')",

                strcmd.AppendFormat(", ConstructionTimes = {0}", data.ConstructionTimes);       // 工期（単位・月）

                strcmd.AppendFormat(", ConstructionStart = STR_TO_DATE('{0}','%Y/%m/%d')",

                                                        data.ConstructionStart.ToShortDateString());// 契約工期開始

                        strcmd.AppendFormat(" CreatorCode = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.CreatorName:    	        // 作成者名

                        break;

                    case (int)TableColumn.CreateDate:	            // 作成日

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

        #endregion

        #region SELECT　SQL作成

        /// <summary>

        /// SQL作成

        private string CreateSelectSQL()

        {

            StringBuilder strcmd = new StringBuilder();

            {

            }

        }

        #endregion

                strcmd.AppendFormat(", {0}", work.LineCount);               // 行番号

                strcmd.AppendFormat(", {0}", work.ComponentCode);           // 構成キー

                strcmd.AppendFormat(", {0}", work.ItemCode);		        // 工種キー

                strcmd.AppendFormat(", {0}", work.CompanyType);             // 協力会社コードタイプ

                strcmd.AppendFormat(", {0}", work.CompanyCode);             // 協力会社コード

                strcmd.AppendFormat(", {0}", work.EstimatePrice);           // 予算（見積）金額

                strcmd.AppendFormat(", {0}", work.ExecutionAmount);         // 実行金額

                strcmd.AppendFormat(", {0}", work.AmountConfigRate);        // 金額構成率

                    strcmd.AppendFormat(", {0}", work.LineCount);               // 行番号

                    strcmd.AppendFormat(", {0}", work.ComponentCode);           // 構成キー

                    strcmd.AppendFormat(", {0}", work.ItemCode);		        // 工種キー

                    strcmd.AppendFormat(", {0}", work.CompanyType);             // 協力会社コードタイプ

                    strcmd.AppendFormat(", {0}", work.CompanyCode);             // 協力会社コード

                    strcmd.AppendFormat(", {0}", work.EstimatePrice);           // 予算（見積）金額

                    strcmd.AppendFormat(", {0}", work.ExecutionAmount);         // 実行金額

                    strcmd.AppendFormat(", {0}", work.AmountConfigRate);        // 金額構成率

                strcmd.AppendFormat(", LineCount = {0}", data.LineCount);                       // 行番号

                strcmd.AppendFormat(", ComponentCode = {0}", data.ComponentCode);               // 構成キー

                strcmd.AppendFormat(", ItemCode = {0}", data.ItemCode);		                    // 工種キー

                strcmd.AppendFormat(", CompanyType = {0}", data.CompanyType);                   // 協力会社コードタイプ

                strcmd.AppendFormat(", CompanyCode = {0}", data.CompanyCode);                   // 協力会社コード

                strcmd.AppendFormat(", EstimatePrice = {0}", data.EstimatePrice);               // 予算（見積）金額

                strcmd.AppendFormat(", ExecutionAmount = {0}", data.ExecutionAmount);           // 実行金額

                strcmd.AppendFormat(", AmountConfigRate = {0}", data.AmountConfigRate);         // 金額構成率

                        strcmd.AppendFormat(" ItemCode = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.FirstString:           // 項目名称

                        break;

                    case (int)TableColumn.SecondString:          // 工事内容

                        break;

                    case (int)TableColumn.CompanyType:           // 協力会社コードタイプ

                        strcmd.AppendFormat(" CompanyType = {0}", ((int)value).ToString());

                        strcmd.AppendFormat(" CompanyCode = {0}", ((int)value).ToString());

                        break;

                    case (int)TableColumn.CompanyName:           // 協力会社名称

                        break;

                    case (int)TableColumn.EstimatePrice:         // 予算（見積）金額

                        strcmd.AppendFormat(" EstimatePrice = {0}", ((int)value).ToString());

        #endregion

        #region SELECT　SQL作成

        /// <summary>

        /// SQL作成

        /// </summary>

        private string CreateSelectSQL()

        {

            StringBuilder strcmd = new StringBuilder();

        }

        #endregion

            FromCodeType,       // 相手先コードタイプ

            FromCode,           // 相手先コード

            SendDate,           // 対象日付

            EntryPrice,         // 金額（税抜）

            EntryTax,           // 金額（税込）

            Content,            // 支払内容

        #endregion

        #region SQL作成

        /// <summary>

        /// SQL作成

        /// </summary>

        private string CreateSelectSQL()

        {

            StringBuilder strcmd = new StringBuilder();

            {

            }

        }

        #endregion