/// <summary>
/// InesrtVisitFormSendSql
/// 公出申請
/// 申請 > 送簽
/// </summary>s
/// <param name="sb">傳入之前組好Command</param>
/// <param name="isReset">StringBuilder Reset or not</param>
public static void InesrtVisitFormSendSql(OnBizPublicOutBean model, ref CommandHelper sb, bool isReset = false)
{
if (isReset)
{
sb.Reset();
}
sb.Append(" INSERT INTO VisitForm ( ");
sb.Append(" CompID, EmpID, EmpNameN, WriteDate, WriteTime, WriterID, WriterName, FormSeq, FlowCaseID, TransactionSeq, OBFormStatus, ValidDate, "); //13
sb.Append(" ValidID, ValidName, RejectReasonID, RejectReasonCN, DeptID, DeptName, OrganID, OrganName, WorkTypeID, WorkType, FlowOrganID, FlowOrganName, TitleID, "); //13
sb.Append(" TitleName, PositionID, Position, Tel_1, Tel_2, VisitBeginDate, BeginTime, VisitEndDate, EndTime, DeputyID, DeputyName, LocationType, InterLocationID, "); //13
sb.Append(" InterLocationName, ExterLocationName, VisiterName, VisiterTel, VisitReasonID, VisitReasonCN, VisitReasonDesc, "); //7
sb.Append(" LastChgComp, LastChgID, LastChgDate "); //3
sb.Append(" ) VALUES ( ");
sb.AppendParameter("CompID", model.CompID).Append(",").AppendParameter("EmpID", model.EmpID).Append(",");
sb.AppendParameter("EmpNameN", model.EmpNameN).Append(",").AppendParameter("WriteDate", model.WriteDate).Append(",");
sb.AppendParameter("WriteTime", model.WriteTime).Append(",").AppendParameter("WriterID", model.WriterID).Append(",");
sb.AppendParameter("WriterName", model.WriterName).Append(",").AppendParameter("FormSeq", model.FormSeq).Append(",");
sb.AppendParameter("FlowCaseID", model.FlowCaseID).Append(",").AppendParameter("TransactionSeq", model.TransactionSeq).Append(",");
sb.AppendParameter("OBFormStatus", model.OBFormStatus).Append(",");
sb.AppendParameter("ValidDate", model.ValidDate).Append(",").AppendParameter("ValidID", model.ValidID).Append(",");
sb.AppendParameter("ValidName", model.ValidName).Append(",").AppendParameter("RejectReasonID", model.RejectReasonID).Append(",");
sb.AppendParameter("RejectReasonCN", model.RejectReasonCN).Append(",").AppendParameter("DeptID", model.DeptID).Append(",");
sb.AppendParameter("DeptName", model.DeptName).Append(",").AppendParameter("OrganID", model.OrganID).Append(",");
sb.AppendParameter("OrganName", model.OrganName).Append(",").AppendParameter("WorkTypeID", model.WorkTypeID).Append(",");
sb.AppendParameter("WorkType", model.WorkType).Append(",").AppendParameter("FlowOrganID", model.FlowOrganID).Append(",");
sb.AppendParameter("FlowOrganName", model.FlowOrganName).Append(",").AppendParameter("TitleID", model.TitleID).Append(",").AppendParameter("TitleName", model.TitleName).Append(",");
sb.AppendParameter("PositionID", model.PositionID).Append(",").AppendParameter("Position", model.Position).Append(",");
sb.AppendParameter("Tel_1", model.Tel_1).Append(",").AppendParameter("Tel_2", model.Tel_2).Append(",");
sb.AppendParameter("VisitBeginDate", model.VisitBeginDate).Append(",").AppendParameter("BeginTime", model.BeginTime).Append(",");
sb.AppendParameter("VisitEndDate", model.VisitEndDate).Append(",").AppendParameter("EndTime", model.EndTime).Append(",");
sb.AppendParameter("DeputyID", model.DeputyID).Append(",").AppendParameter("DeputyName", model.DeputyName).Append(",");
sb.AppendParameter("LocationType", model.LocationType).Append(",").AppendParameter("InterLocationID", model.InterLocationID).Append(",");
sb.AppendParameter("InterLocationName", model.InterLocationName).Append(",").AppendParameter("ExterLocationName", model.ExterLocationName).Append(",");
sb.AppendParameter("VisiterName", model.VisiterName).Append(",").AppendParameter("VisiterTel", model.VisiterTel).Append(",");
sb.AppendParameter("VisitReasonID", model.VisitReasonID).Append(",").AppendParameter("VisitReasonCN", model.VisitReasonCN).Append(",");
sb.AppendParameter("VisitReasonDesc", model.VisitReasonDesc).Append(",").AppendParameter("LastChgComp", model.LastChgComp).Append(",");
sb.AppendParameter("LastChgID", model.LastChgID).Append(",").Append("getDate()");
sb.Append(" ); ");
}
/// <summary>
/// InsertOnBizReqAppd_ITRDFlowFullLogSql
/// 公出查詢
/// 核准_註銷
/// 新增一筆資料到OnBizReqAppd_ITRDFlowFullLog
/// </summary>
/// <param name="sb">傳入之前組好Command</param>
/// <param name="isReset">StringBuilder Reset or not</param>
public static void InsertOnBizReqAppd_ITRDFlowFullLogSql(OnBizPublicOutBean model, string flowLogNo, ref CommandHelper sb, bool isReset = false)
{
if (isReset)
{
sb.Reset();
}
sb.Append(" INSERT INTO OnBizReqAppd_ITRDFlowFullLog ( ");
sb.Append(" FlowCaseID , FlowLogBatNo , FlowLogID , FlowStepID , FlowStepName , FlowStepBtnID , FlowStepBtnCaption , FlowStepOpinion , FlowLogIsClose , ");
sb.Append(" IsProxy , AttachID , FromDept , FromDeptName , FromUser , FromUserName , AssignTo , AssignToName , ");
sb.Append(" ToDept , ToDeptName , ToUser , ToUserName , LogCrDateTime , LogUpdDateTime )");
sb.Append(" VALUES ( ");
sb.AppendParameter("@FlowCaseID", model.FlowCaseID).Append(",");
sb.AppendParameter("@FlowLogBatNo", flowLogNo).Append(",");
sb.AppendParameter("@FlowLogID", model.FlowCaseID + "." + flowLogNo.PadLeft(5, '0')).Append(",");
sb.AppendParameter("@FlowStepID", "Z03").Append(",");
sb.AppendParameter("@FlowStepName", "取消").Append(",");
sb.AppendParameter("@FlowStepBtnID", "").Append(",");
sb.AppendParameter("@FlowStepBtnCaption", "").Append(",");
sb.AppendParameter("@FlowStepOpinion", "").Append(",");
sb.AppendParameter("@FlowLogIsClose", "Y").Append(",");
sb.AppendParameter("@IsProxy", "").Append(",");
sb.AppendParameter("@AttachID", "").Append(",");
sb.AppendParameter("@FromDept", model.DeptID).Append(",");
sb.AppendParameter("@FromDeptName", model.DeptName).Append(",");
sb.AppendParameter("@FromUser", model.WriterID).Append(",");
sb.AppendParameter("@FromUserName", model.WriterName).Append(",");
sb.AppendParameter("@AssignTo", model.WriterID).Append(",");
sb.AppendParameter("@AssignToName", model.WriterName).Append(",");
sb.AppendParameter("@ToDept", model.DeptID).Append(",");
sb.AppendParameter("@ToDeptName", model.DeptName).Append(",");
sb.AppendParameter("@ToUser", model.WriterID).Append(",");
sb.AppendParameter("@ToUserName", model.WriterName).Append(",");
sb.Append("getDate() ,");
sb.Append("getDate()").Append(")");
sb.Append(" ; ");
}
