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);
}
