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