public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.mmStdSequence d, string userID = "") { var param = new Dapper.DynamicParameters(); param.Add("@DrawingCd", d.DrawingCd); param.Add("@SeqNo", d.SeqNo); param.Add("@WorkStationGrp", d.WorkStationGrp); param.Add("@TaskCode", d.TaskCode); param.Add("@WorkCenterCode", d.WorkCenterCode); param.Add("@MachCode", d.MachCode); param.Add("@SetupTime", d.SetupTime); param.Add("@NoOfMins", d.NoOfMins); param.Add("@ProductionRate", d.ProductionRate); param.Add("@UnitCode", d.UnitCode); param.Add("@TimeCode", d.TimeCode); param.Add("@CycleTime", d.CycleTime); param.Add("@LastUpdDt", d.LastUpdDt); param.Add("@LastUpdUser", d.LastUpdUser); param.Add("@SECM_NO", d.SECM_NO); param.Add("@Tm", d.Tm); param.Add("@USER_ID", d.USER_ID); param.Add("@USER_DATE", d.USER_DATE); param.Add("@RoutingDateSt", d.RoutingDateSt); param.Add("@RoutingDateEnd", d.RoutingDateEnd); param.Add("@NewFlag", d.NewFlag); string cmd = "INSERT INTO mcis.dbo.mmStdSequence " + $" (DrawingCd, SeqNo, WorkStationGrp, TaskCode, WorkCenterCode, MachCode, SetupTime, NoOfMins, ProductionRate, UnitCode, TimeCode, CycleTime, LastUpdDt, LastUpdUser, SECM_NO, Tm, USER_ID, USER_DATE, RoutingDateSt, RoutingDateEnd, NewFlag) " + $"VALUES(@DrawingCd, @SeqNo, @WorkStationGrp, @TaskCode, @WorkCenterCode, @MachCode, @SetupTime, @NoOfMins, @ProductionRate, @UnitCode, @TimeCode, @CycleTime, @LastUpdDt, @LastUpdUser, @SECM_NO, @Tm, @USER_ID, @USER_DATE, @RoutingDateSt, @RoutingDateEnd, @NewFlag); " + $"SELECT SCOPE_IDENTITY();"; return(ExecuteScalar <int>(cmd, param)); }
public int Delete(ASSETKKF_MODEL.Data.Mssql.Mcis.mmStdSequence d, string userID = "", SqlTransaction transac = null) { var param = new Dapper.DynamicParameters(); param.Add("@DrawingCd", d.DrawingCd.GetValue()); param.Add("@SeqNo", d.SeqNo.GetValue()); param.Add("@WorkStationGrp", d.WorkStationGrp.GetValue()); param.Add("@TaskCode", d.TaskCode.GetValue()); param.Add("@WorkCenterCode", d.WorkCenterCode.GetValue()); param.Add("@MachCode", d.MachCode.GetValue()); param.Add("@SetupTime", d.SetupTime); param.Add("@NoOfMins", d.NoOfMins); param.Add("@ProductionRate", d.ProductionRate); param.Add("@UnitCode", d.UnitCode.GetValue()); param.Add("@TimeCode", d.TimeCode.GetValue()); param.Add("@CycleTime", d.CycleTime); param.Add("@LastUpdDt", d.LastUpdDt); param.Add("@LastUpdUser", d.LastUpdUser.GetValue()); param.Add("@SECM_NO", d.SECM_NO.GetValue()); param.Add("@Tm", d.Tm.GetValue()); param.Add("@USER_ID", d.USER_ID.GetValue()); param.Add("@USER_DATE", d.USER_DATE); param.Add("@RoutingDateSt", d.RoutingDateSt); param.Add("@RoutingDateEnd", d.RoutingDateEnd); param.Add("@NewFlag", d.NewFlag.GetValue()); string cmd = ""; /* * cmd = DELETE FROM mcis.dbo.mmStdSequence "+ * "WHERE DrawingCd = @.DrawingCd "+ * " AND SeqNo = @.SeqNo "+ * " AND WorkStationGrp = @.WorkStationGrp "+ * " AND TaskCode = @.TaskCode "+ * " AND WorkCenterCode = @.WorkCenterCode "+ * " AND MachCode = @.MachCode "+ * " AND SetupTime = @.SetupTime "+ * " AND NoOfMins = @.NoOfMins "+ * " AND ProductionRate = @.ProductionRate "+ * " AND UnitCode = @.UnitCode "+ * " AND TimeCode = @.TimeCode "+ * " AND CycleTime = @.CycleTime "+ * " AND LastUpdDt = @.LastUpdDt "+ * " AND LastUpdUser = @.LastUpdUser "+ * " AND SECM_NO = @.SECM_NO "+ * " AND Tm = @.Tm "+ * " AND USER_ID = @.USER_ID "+ * " AND USER_DATE = @.USER_DATE "+ * " AND RoutingDateSt = @.RoutingDateSt "+ * " AND RoutingDateEnd = @.RoutingDateEnd "+ * " AND NewFlag = @.NewFlag "+ * " "; */ var res = ExecuteNonQuery(transac, cmd, param); return(res); }