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

-- Project Name : noname

-- Author       : Horiuchi

-- RDBMS Type   : MySQL

-- Application  : A5:SQL Mk-2

  , constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo)

) comment '?o?????f?[?^' ;

-- ?o?????f?[?^

drop table if exists attendancedata cascade;

create table constructionmaterialinfo (

  CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '?H?????'

  , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'

  , RENTCOUNT smallint(5) unsigned comment '??o??'

  , REPAYCOUNT smallint(5) unsigned comment '??p??'

  , COMPLETEFLG tinyint(3) unsigned comment '?????t???O'

  , ENTRYDATE datetime comment '?o?^???t'

  , UPDATEDATE datetime comment '?X?V???t'

) comment '?H????????' ;

-- ????i?????t?f?[?^

  , constraint proceedingsdataattend_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)

) comment '?????????????c???^?f?[?^?i?o???j' ;

-- ?????????????c???^?f?[?^?i????j

drop table if exists proceedingsdatadetail cascade;

  , CompletionPaymentDays decimal(3,0) unsigned not null comment '???n??????x??????'

  , CompletionPaymentPrice decimal(12,0) not null comment '???n??????x?????z'

  , LeadEngineerCode decimal(8,0) comment '??C?Z?p??R?[?h'

  , SafetyOfficerCode decimal(8,0) comment '???S?????R?[?h'

  , SafetyOfficerName varchar(60) comment '???S??????'

  , WorkersCount decimal(3,0) unsigned comment '??????'

                WriteData.MessageTitle = CheckRec.SendTitle;                                                // 伝言タイトル

                // リンク情報

                WriteData.LinkMessage = string.Format("工事番号：{0} 工事名称：{1}"

                                                                            , CommonMotions.cnvStringCodeFromInt(wrkRec.ConstructionCode, "-", 8)

                                                                            , DetailString);

                WriteDetail.Add(DetailTbl);

                // メッセージフラグを自動に設定する

                // 掲示板へメッセージを載せる

                if (!ClsMessageBoradAccess.CreateMessage(mbdDB, mbtDB, WriteData, WriteDetail)) return false;

                WriteData.MessageTitle = CheckRec.SendTitle;                                                // 伝言タイトル

                // リンク情報

                WriteData.LinkMessage = string.Format("工事番号：{0} 工事名称：{1}"

                                                                            , CommonMotions.cnvStringCodeFromInt(wrkRec.ConstructionCode, "-", 8)

                                                                            , DetailString);

                WriteDetail.Add(DetailTbl);

                // メッセージフラグを自動に設定する

                // 掲示板へメッセージを載せる

                if (!ClsMessageBoradAccess.CreateMessage(mbdDB, mbtDB, WriteData, WriteDetail)) return false;

        /// </summary>

        public static int s_GeneralAffairsDevision = 4;

        #endregion

        #endregion

        #region 行動予定 会社行事名称・コード

        /// <summary>

        /// 行動予定 会社行事名称・コード

        /// <summary>

        /// 本体バージョン

        /// </summary>

        /// <summary>

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

                WriteData.MessageTitle = CheckRec.SendTitle;                                                // 伝言タイトル

                // リンク情報

                WriteData.LinkMessage = string.Format("工事番号：{0} 工事名称：{1}"

                                                                            , CommonMotions.cnvStringCodeFromInt(wrkRec.ConstructionCode, "-", 8)

                                                                            , DetailString);

                WriteDetail.Add(DetailTbl);

                // メッセージフラグを自動に設定する

                // 掲示板へメッセージを載せる

                if (!ClsMessageBoradAccess.CreateMessage(mbdDB, mbtDB, WriteData, WriteDetail)) return false;

                WriteData.MessageTitle = CheckRec.SendTitle;                                                // 伝言タイトル

                // リンク情報

                WriteData.LinkMessage = string.Format("工事番号：{0} 工事名称：{1}"

                                                                            , CommonMotions.cnvStringCodeFromInt(wrkRec.ConstructionCode, "-", 8)

                                                                            , DetailString);

                WriteDetail.Add(DetailTbl);

                // メッセージフラグを自動に設定する

                // 掲示板へメッセージを載せる

                if (!ClsMessageBoradAccess.CreateMessage(mbdDB, mbtDB, WriteData, WriteDetail)) return false;

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

            /// </summary>

            WorkingComment,

            /// <summary>

            /// </summary>

            /// <summary>

            /// 登録年月日

            /// </summary>

            strcmd.Append(" ,DATE_FORMAT(CompTime, '%Y/%m/%d %H:%i:%s')");      // 終了時間

            strcmd.Append(" ,DayTimes");                                        // 日稼働合計時間

            strcmd.Append(" ,WorkingComment");                                  // コメント

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

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

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

                strcmd.AppendFormat(",'{0}'", work.WorkingComment);                     // コメント

                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(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.CompTime);     // 終了時間

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

                    strcmd.AppendFormat(",'{0}'", work.WorkingComment);                                 // コメント

                    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(",DayTimes = {0}", data.DayTimes);                      // 日稼働合計時間

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

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

                strcmd.Append(AddSQLString);

                    case (int)TableColumn.WorkingComment:

                        strcmd.AppendFormat(" WorkingComment = '{0}'", CommonMotions.cnvString(value));

                        break;

                        break;

                }

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

                wrk.CompTime = DateTime.Parse(objwrk[(int)TableColumn.CompTime].ToString());

                wrk.DayTimes = CommonMotions.cnvDouble(objwrk[(int)TableColumn.DayTimes]);

                wrk.WorkingComment = objwrk[(int)TableColumn.WorkingComment].ToString();                     // 当日作業内容

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

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

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region 読込みオブジェクトセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        {

            ConstructionCode = 0,

            MaterialItemCode,

            RentCount,

            RepayCount,

            CompleteFlg,

            EntryDate,

            UpdateDate,

            : base(DBCommon.Instance.DBConnectString)

        {

        }

        #endregion

        /// <summary>

        /// 検索

        /// </summary>

            {

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

                strcmd.Append("SELECT");

                strcmd.Append(" FROM ConstructionMaterialInfo");

                strcmd.Append(AddSQLString);

            }

        }

        /// <summary>

        /// 追加

        /// </summary>

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

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

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

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

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

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

                return false;

            }

        }

        /// <summary>

        /// 更新

        /// </summary>

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

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

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

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

                return false;

            }

        }

        /// <summary>

        /// 削除

        /// </summary>

                return false;

            }

        }

        /// <summary>

        /// </summary>

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

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

        {

                // データ取得

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

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

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

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

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

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

            }

        }

        #endregion

        /// <summary>

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

        /// </summary>

        /// <param name="BusinessTypeCode"></param>

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

        {

            StringBuilder strWork = new StringBuilder();

            try

            {

                return strWork.ToString();

            }

                return string.Empty;

            }

        }

        /// <summary>

        /// 指定資材の件数を取得する

        /// </summary>

        /// <param name="MaterialKindCode">資材種類コード</param>

            return iRet;

        }

        /// <summary>

        /// 行ロック

        /// </summary>

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット処理

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット

        /// <summary>

        /// </summary>

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

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

        {

        #region データセット

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        }

        #endregion

        /// <summary>

        /// </summary>

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

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

        {

        #region 構造体へセットする

        /// <summary>

        /// </summary>

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

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

        {

        #region 構造体へセットする

        /// <summary>

        /// </summary>

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

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

        {