public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.MtWorkOrderSequence_Emp d, string userID = "")
{
var param = new Dapper.DynamicParameters();
param.Add("@WorkDate", d.WorkDate);
param.Add("@ItemNo", d.ItemNo);
param.Add("@EmployeeId", d.EmployeeId);
param.Add("@WorkStationGrpCd", d.WorkStationGrpCd);
param.Add("@WorkOrderId", d.WorkOrderId);
param.Add("@StartTime", d.StartTime);
param.Add("@QtyAmt", d.QtyAmt);
param.Add("@EndTime", d.EndTime);
param.Add("@StdTime", d.StdTime);
param.Add("@ActTime", d.ActTime);
param.Add("@DiffTime", d.DiffTime);
param.Add("@Use_FreeTimeOT", d.Use_FreeTimeOT);
param.Add("@User_Id", d.User_Id);
param.Add("@User_date", d.User_date);
param.Add("@DrawingCd", d.DrawingCd);
param.Add("@CusCod", d.CusCod);
param.Add("@Post_flag", d.Post_flag);
param.Add("@Pause_Flag", d.Pause_Flag);
param.Add("@ReworkFlag", d.ReworkFlag);
string cmd = "INSERT INTO mcis.dbo.MtWorkOrderSequence_Emp " +
$" (WorkDate, ItemNo, EmployeeId, WorkStationGrpCd, WorkOrderId, StartTime, QtyAmt, EndTime, StdTime, ActTime, DiffTime, Use_FreeTimeOT, User_Id, User_date, DrawingCd, CusCod, Post_flag, Pause_Flag, ReworkFlag) " +
$" VALUES(@WorkDate, @ItemNo, @EmployeeId, @WorkStationGrpCd, @WorkOrderId, @StartTime, @QtyAmt, @EndTime, @StdTime, @ActTime, @DiffTime, @Use_FreeTimeOT, @User_Id, @User_date, @DrawingCd, @CusCod, @Post_flag, @Pause_Flag, @ReworkFlag); " +
$" SELECT SCOPE_IDENTITY();";
return(ExecuteScalar <int>(cmd, param));
}
public int Delete(ASSETKKF_MODEL.Data.Mssql.Mcis.MtWorkOrderSequence_Emp d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@WorkDate", d.WorkDate);
param.Add("@ItemNo", d.ItemNo);
param.Add("@EmployeeId", d.EmployeeId.GetValue());
param.Add("@WorkStationGrpCd", d.WorkStationGrpCd.GetValue());
param.Add("@WorkOrderId", d.WorkOrderId.GetValue());
param.Add("@StartTime", d.StartTime);
param.Add("@QtyAmt", d.QtyAmt);
param.Add("@EndTime", d.EndTime);
param.Add("@StdTime", d.StdTime);
param.Add("@ActTime", d.ActTime);
param.Add("@DiffTime", d.DiffTime);
param.Add("@Use_FreeTimeOT", d.Use_FreeTimeOT.GetValue());
param.Add("@User_Id", d.User_Id.GetValue());
param.Add("@User_date", d.User_date);
param.Add("@DrawingCd", d.DrawingCd.GetValue());
param.Add("@CusCod", d.CusCod.GetValue());
param.Add("@Post_flag", d.Post_flag.GetValue());
param.Add("@Pause_Flag", d.Pause_Flag.GetValue());
param.Add("@ReworkFlag", d.ReworkFlag.GetValue());
string cmd = "";
/*
* cmd = DELETE FROM mcis.dbo.MtWorkOrderSequence_Emp "+
* "WHERE WorkDate = @.WorkDate "+
* " AND ItemNo = @.ItemNo "+
* " AND EmployeeId = @.EmployeeId "+
* " AND WorkStationGrpCd = @.WorkStationGrpCd "+
* " AND WorkOrderId = @.WorkOrderId "+
* " AND StartTime = @.StartTime "+
* " AND QtyAmt = @.QtyAmt "+
* " AND EndTime = @.EndTime "+
* " AND StdTime = @.StdTime "+
* " AND ActTime = @.ActTime "+
* " AND DiffTime = @.DiffTime "+
* " AND Use_FreeTimeOT = @.Use_FreeTimeOT "+
* " AND User_Id = @.User_Id "+
* " AND User_date = @.User_date "+
* " AND DrawingCd = @.DrawingCd "+
* " AND CusCod = @.CusCod "+
* " AND Post_flag = @.Post_flag "+
* " AND Pause_Flag = @.Pause_Flag "+
* " AND ReworkFlag = @.ReworkFlag "+
* " ";
*/
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
