public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.MtWorkOrderSequenceL d, string userID = "") { var param = new Dapper.DynamicParameters(); param.Add("@WorkDate", d.WorkDate); param.Add("@WorkStationGrpCd", d.WorkStationGrpCd); param.Add("@EmployeeId", d.EmployeeId); param.Add("@WorkOrderId", d.WorkOrderId); param.Add("@EndTime", d.EndTime); param.Add("@QtyAmt", d.QtyAmt); param.Add("@DrawingCd", d.DrawingCd); param.Add("@CusCod", d.CusCod); param.Add("@Move_Flag", d.Move_Flag); param.Add("@ReworkFlag", d.ReworkFlag); param.Add("@WorkStationGrp_STD", d.WorkStationGrp_STD); param.Add("@SeqNo_STD", d.SeqNo_STD); param.Add("@WorkStationGrpCd_Next", d.WorkStationGrpCd_Next); param.Add("@SeqNo_NEXT", d.SeqNo_NEXT); param.Add("@CauseStatus", d.CauseStatus); param.Add("@RemarkCause", d.RemarkCause); param.Add("@AppvCauseId", d.AppvCauseId); param.Add("@AppvCauseDt", d.AppvCauseDt); param.Add("@User_Id", d.User_Id); param.Add("@User_date", d.User_date); param.Add("@ExtFlag", d.ExtFlag); param.Add("@EndSequence", d.EndSequence); string cmd = "INSERT INTO mcis.dbo.MtWorkOrderSequenceL " + $" (WorkDate, WorkStationGrpCd, EmployeeId, WorkOrderId, EndTime, QtyAmt, DrawingCd, CusCod, Move_Flag, ReworkFlag, WorkStationGrp_STD, SeqNo_STD, WorkStationGrpCd_Next, SeqNo_NEXT, CauseStatus, RemarkCause, AppvCauseId, AppvCauseDt, User_Id, User_date, ExtFlag, EndSequence) " + $"VALUES(@WorkDate, @WorkStationGrpCd, @EmployeeId, @WorkOrderId, @EndTime, @QtyAmt, @DrawingCd, @CusCod, @Move_Flag, @ReworkFlag, @WorkStationGrp_STD, @SeqNo_STD, @WorkStationGrpCd_Next, @SeqNo_NEXT, @CauseStatus, @RemarkCause, @AppvCauseId, @AppvCauseDt, @User_Id, @User_date, @ExtFlag, @EndSequence); " + $"SELECT SCOPE_IDENTITY();"; return(ExecuteScalar <int>(cmd, param)); }
public int Delete(ASSETKKF_MODEL.Data.Mssql.Mcis.MtWorkOrderSequenceL d, string userID = "", SqlTransaction transac = null) { var param = new Dapper.DynamicParameters(); param.Add("@WorkDate", d.WorkDate); param.Add("@WorkStationGrpCd", d.WorkStationGrpCd.GetValue()); param.Add("@EmployeeId", d.EmployeeId.GetValue()); param.Add("@WorkOrderId", d.WorkOrderId.GetValue()); param.Add("@EndTime", d.EndTime); param.Add("@QtyAmt", d.QtyAmt); param.Add("@DrawingCd", d.DrawingCd.GetValue()); param.Add("@CusCod", d.CusCod.GetValue()); param.Add("@Move_Flag", d.Move_Flag.GetValue()); param.Add("@ReworkFlag", d.ReworkFlag.GetValue()); param.Add("@WorkStationGrp_STD", d.WorkStationGrp_STD.GetValue()); param.Add("@SeqNo_STD", d.SeqNo_STD.GetValue()); param.Add("@WorkStationGrpCd_Next", d.WorkStationGrpCd_Next.GetValue()); param.Add("@SeqNo_NEXT", d.SeqNo_NEXT.GetValue()); 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("@User_Id", d.User_Id.GetValue()); param.Add("@User_date", d.User_date); param.Add("@ExtFlag", d.ExtFlag.GetValue()); param.Add("@EndSequence", d.EndSequence.GetValue()); string cmd = ""; /* * cmd = DELETE FROM mcis.dbo.MtWorkOrderSequenceL "+ * "WHERE WorkDate = @.WorkDate "+ * " AND WorkStationGrpCd = @.WorkStationGrpCd "+ * " AND EmployeeId = @.EmployeeId "+ * " AND WorkOrderId = @.WorkOrderId "+ * " AND EndTime = @.EndTime "+ * " AND QtyAmt = @.QtyAmt "+ * " AND DrawingCd = @.DrawingCd "+ * " AND CusCod = @.CusCod "+ * " AND Move_Flag = @.Move_Flag "+ * " AND ReworkFlag = @.ReworkFlag "+ * " AND WorkStationGrp_STD = @.WorkStationGrp_STD "+ * " AND SeqNo_STD = @.SeqNo_STD "+ * " AND WorkStationGrpCd_Next = @.WorkStationGrpCd_Next "+ * " AND SeqNo_NEXT = @.SeqNo_NEXT "+ * " AND CauseStatus = @.CauseStatus "+ * " AND RemarkCause = @.RemarkCause "+ * " AND AppvCauseId = @.AppvCauseId "+ * " AND AppvCauseDt = @.AppvCauseDt "+ * " AND User_Id = @.User_Id "+ * " AND User_date = @.User_date "+ * " AND ExtFlag = @.ExtFlag "+ * " AND EndSequence = @.EndSequence "+ * " "; */ var res = ExecuteNonQuery(transac, cmd, param); return(res); }