public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.MtMoveOrderSequence d, string userID = "")
{
var param = new Dapper.DynamicParameters();
param.Add("@Sequence", d.Sequence);
param.Add("@MoveDate", d.MoveDate);
param.Add("@MoveTime", d.MoveTime);
param.Add("@EmployeeId", d.EmployeeId);
param.Add("@WorkOrderId", d.WorkOrderId);
param.Add("@DrawingCd", d.DrawingCd);
param.Add("@WorkStationGrpCd_FR", d.WorkStationGrpCd_FR);
param.Add("@WorkStationGrpCd_STD", d.WorkStationGrpCd_STD);
param.Add("@WorkStationGrpCd_TO", d.WorkStationGrpCd_TO);
param.Add("@SeqNo_NEXT", d.SeqNo_NEXT);
param.Add("@EndTime", d.EndTime);
param.Add("@CauseStatus", d.CauseStatus);
param.Add("@RemarkCause", d.RemarkCause);
param.Add("@AppvCauseId", d.AppvCauseId);
param.Add("@AppvCauseDt", d.AppvCauseDt);
param.Add("@Process_Flag", d.Process_Flag);
param.Add("@User_Id", d.User_Id);
param.Add("@User_date", d.User_date);
string cmd = "INSERT INTO mcis.dbo.MtMoveOrderSequence " +
$" (Sequence, MoveDate, MoveTime, EmployeeId, WorkOrderId, DrawingCd, WorkStationGrpCd_FR, WorkStationGrpCd_STD, WorkStationGrpCd_TO, SeqNo_NEXT, EndTime, CauseStatus, RemarkCause, AppvCauseId, AppvCauseDt, Process_Flag, User_Id, User_date) " +
$"VALUES(@Sequence, @MoveDate, @MoveTime, @EmployeeId, @WorkOrderId, @DrawingCd, @WorkStationGrpCd_FR, @WorkStationGrpCd_STD, @WorkStationGrpCd_TO, @SeqNo_NEXT, @EndTime, @CauseStatus, @RemarkCause, @AppvCauseId, @AppvCauseDt, @Process_Flag, @User_Id, @User_date); " +
$"SELECT SCOPE_IDENTITY();";
return(ExecuteScalar <int>(cmd, param));
}
public int Delete(ASSETKKF_MODEL.Data.Mssql.Mcis.MtMoveOrderSequence d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@Sequence", d.Sequence);
param.Add("@MoveDate", d.MoveDate);
param.Add("@MoveTime", d.MoveTime);
param.Add("@EmployeeId", d.EmployeeId.GetValue());
param.Add("@WorkOrderId", d.WorkOrderId.GetValue());
param.Add("@DrawingCd", d.DrawingCd.GetValue());
param.Add("@WorkStationGrpCd_FR", d.WorkStationGrpCd_FR.GetValue());
param.Add("@WorkStationGrpCd_STD", d.WorkStationGrpCd_STD.GetValue());
param.Add("@WorkStationGrpCd_TO", d.WorkStationGrpCd_TO.GetValue());
param.Add("@SeqNo_NEXT", d.SeqNo_NEXT.GetValue());
param.Add("@EndTime", d.EndTime);
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("@Process_Flag", d.Process_Flag.GetValue());
param.Add("@User_Id", d.User_Id.GetValue());
param.Add("@User_date", d.User_date);
string cmd = "";
/*
* cmd = DELETE FROM mcis.dbo.MtMoveOrderSequence "+
* "WHERE Sequence = @.Sequence "+
* " AND MoveDate = @.MoveDate "+
* " AND MoveTime = @.MoveTime "+
* " AND EmployeeId = @.EmployeeId "+
* " AND WorkOrderId = @.WorkOrderId "+
* " AND DrawingCd = @.DrawingCd "+
* " AND WorkStationGrpCd_FR = @.WorkStationGrpCd_FR "+
* " AND WorkStationGrpCd_STD = @.WorkStationGrpCd_STD "+
* " AND WorkStationGrpCd_TO = @.WorkStationGrpCd_TO "+
* " AND SeqNo_NEXT = @.SeqNo_NEXT "+
* " AND EndTime = @.EndTime "+
* " AND CauseStatus = @.CauseStatus "+
* " AND RemarkCause = @.RemarkCause "+
* " AND AppvCauseId = @.AppvCauseId "+
* " AND AppvCauseDt = @.AppvCauseDt "+
* " AND Process_Flag = @.Process_Flag "+
* " AND User_Id = @.User_Id "+
* " AND User_date = @.User_date "+
* " ";
*/
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
