public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.MtMoveOrderSequence d, string userID = "") { var param = new Dapper.DynamicParameters(); param.Add("@Sequence", d.Sequence); param.Add("@MoveDate", d.MoveDate); param.Add("@MoveTime", d.MoveTime); param.Add("@EmployeeId", d.EmployeeId); param.Add("@WorkOrderId", d.WorkOrderId); param.Add("@DrawingCd", d.DrawingCd); param.Add("@WorkStationGrpCd_FR", d.WorkStationGrpCd_FR); param.Add("@WorkStationGrpCd_STD", d.WorkStationGrpCd_STD); param.Add("@WorkStationGrpCd_TO", d.WorkStationGrpCd_TO); param.Add("@SeqNo_NEXT", d.SeqNo_NEXT); param.Add("@EndTime", d.EndTime); param.Add("@CauseStatus", d.CauseStatus); param.Add("@RemarkCause", d.RemarkCause); param.Add("@AppvCauseId", d.AppvCauseId); param.Add("@AppvCauseDt", d.AppvCauseDt); param.Add("@Process_Flag", d.Process_Flag); param.Add("@User_Id", d.User_Id); param.Add("@User_date", d.User_date); string cmd = "INSERT INTO mcis.dbo.MtMoveOrderSequence " + $" (Sequence, MoveDate, MoveTime, EmployeeId, WorkOrderId, DrawingCd, WorkStationGrpCd_FR, WorkStationGrpCd_STD, WorkStationGrpCd_TO, SeqNo_NEXT, EndTime, CauseStatus, RemarkCause, AppvCauseId, AppvCauseDt, Process_Flag, User_Id, User_date) " + $"VALUES(@Sequence, @MoveDate, @MoveTime, @EmployeeId, @WorkOrderId, @DrawingCd, @WorkStationGrpCd_FR, @WorkStationGrpCd_STD, @WorkStationGrpCd_TO, @SeqNo_NEXT, @EndTime, @CauseStatus, @RemarkCause, @AppvCauseId, @AppvCauseDt, @Process_Flag, @User_Id, @User_date); " + $"SELECT SCOPE_IDENTITY();"; return(ExecuteScalar <int>(cmd, param)); }
public int Delete(ASSETKKF_MODEL.Data.Mssql.Mcis.MtMoveOrderSequence d, string userID = "", SqlTransaction transac = null) { var param = new Dapper.DynamicParameters(); param.Add("@Sequence", d.Sequence); param.Add("@MoveDate", d.MoveDate); param.Add("@MoveTime", d.MoveTime); param.Add("@EmployeeId", d.EmployeeId.GetValue()); param.Add("@WorkOrderId", d.WorkOrderId.GetValue()); param.Add("@DrawingCd", d.DrawingCd.GetValue()); param.Add("@WorkStationGrpCd_FR", d.WorkStationGrpCd_FR.GetValue()); param.Add("@WorkStationGrpCd_STD", d.WorkStationGrpCd_STD.GetValue()); param.Add("@WorkStationGrpCd_TO", d.WorkStationGrpCd_TO.GetValue()); param.Add("@SeqNo_NEXT", d.SeqNo_NEXT.GetValue()); param.Add("@EndTime", d.EndTime); param.Add("@CauseStatus", d.CauseStatus.GetValue()); param.Add("@RemarkCause", d.RemarkCause.GetValue()); param.Add("@AppvCauseId", d.AppvCauseId.GetValue()); param.Add("@AppvCauseDt", d.AppvCauseDt); param.Add("@Process_Flag", d.Process_Flag.GetValue()); param.Add("@User_Id", d.User_Id.GetValue()); param.Add("@User_date", d.User_date); string cmd = ""; /* * cmd = DELETE FROM mcis.dbo.MtMoveOrderSequence "+ * "WHERE Sequence = @.Sequence "+ * " AND MoveDate = @.MoveDate "+ * " AND MoveTime = @.MoveTime "+ * " AND EmployeeId = @.EmployeeId "+ * " AND WorkOrderId = @.WorkOrderId "+ * " AND DrawingCd = @.DrawingCd "+ * " AND WorkStationGrpCd_FR = @.WorkStationGrpCd_FR "+ * " AND WorkStationGrpCd_STD = @.WorkStationGrpCd_STD "+ * " AND WorkStationGrpCd_TO = @.WorkStationGrpCd_TO "+ * " AND SeqNo_NEXT = @.SeqNo_NEXT "+ * " AND EndTime = @.EndTime "+ * " AND CauseStatus = @.CauseStatus "+ * " AND RemarkCause = @.RemarkCause "+ * " AND AppvCauseId = @.AppvCauseId "+ * " AND AppvCauseDt = @.AppvCauseDt "+ * " AND Process_Flag = @.Process_Flag "+ * " AND User_Id = @.User_Id "+ * " AND User_date = @.User_date "+ * " "; */ var res = ExecuteNonQuery(transac, cmd, param); return(res); }