public int Update(ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@WorkStationGrpCd", d.WorkStationGrpCd.GetValue());
param.Add("@WorkStationGrpNm", d.WorkStationGrpNm.GetValue());
param.Add("@DLCost", d.DLCost);
param.Add("@FOHCost", d.FOHCost);
param.Add("@MDCost", d.MDCost);
param.Add("@WorkStationCD", d.WorkStationCD.GetValue());
param.Add("@LastUpdUsr", d.LastUpdUsr.GetValue());
param.Add("@LastUpdDt", d.LastUpdDt);
param.Add("@UnionDLCost", d.UnionDLCost);
param.Add("@WorkStationNM", d.WorkStationNM.GetValue());
param.Add("@MulEmp_flag", d.MulEmp_flag.GetValue());
param.Add("@ExtGrp_Flag", d.ExtGrp_Flag.GetValue());
string cmd = "";
/*
* cmd = UPDATE mcis.dbo.msWorkStationGrp "+
* "SET WorkStationGrpCd = @.WorkStationGrpCd "+
* " , WorkStationGrpNm = @.WorkStationGrpNm "+
* " , DLCost = @.DLCost "+
* " , FOHCost = @.FOHCost "+
* " , MDCost = @.MDCost "+
* " , WorkStationCD = @.WorkStationCD "+
* " , LastUpdUsr = @.LastUpdUsr "+
* " , LastUpdDt = @.LastUpdDt "+
* " , UnionDLCost = @.UnionDLCost "+
* " , WorkStationNM = @.WorkStationNM "+
* " , MulEmp_flag = @.MulEmp_flag "+
* " , ExtGrp_Flag = @.ExtGrp_Flag "+
* "WHERE WorkStationGrpCd = @.WorkStationGrpCd "+
* " AND WorkStationGrpNm = @.WorkStationGrpNm "+
* " AND DLCost = @.DLCost "+
* " AND FOHCost = @.FOHCost "+
* " AND MDCost = @.MDCost "+
* " AND WorkStationCD = @.WorkStationCD "+
* " AND LastUpdUsr = @.LastUpdUsr "+
* " AND LastUpdDt = @.LastUpdDt "+
* " AND UnionDLCost = @.UnionDLCost "+
* " AND WorkStationNM = @.WorkStationNM "+
* " AND MulEmp_flag = @.MulEmp_flag "+
* " AND ExtGrp_Flag = @.ExtGrp_Flag "+
* " ";
*/
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp d, string userID = "")
{
var param = new Dapper.DynamicParameters();
param.Add("@WorkStationGrpCd", d.WorkStationGrpCd);
param.Add("@WorkStationGrpNm", d.WorkStationGrpNm);
param.Add("@DLCost", d.DLCost);
param.Add("@FOHCost", d.FOHCost);
param.Add("@MDCost", d.MDCost);
param.Add("@WorkStationCD", d.WorkStationCD);
param.Add("@LastUpdUsr", d.LastUpdUsr);
param.Add("@LastUpdDt", d.LastUpdDt);
param.Add("@UnionDLCost", d.UnionDLCost);
param.Add("@WorkStationNM", d.WorkStationNM);
param.Add("@MulEmp_flag", d.MulEmp_flag);
param.Add("@ExtGrp_Flag", d.ExtGrp_Flag);
string cmd = "INSERT INTO mcis.dbo.msWorkStationGrp " +
$" (WorkStationGrpCd, WorkStationGrpNm, DLCost, FOHCost, MDCost, WorkStationCD, LastUpdUsr, LastUpdDt, UnionDLCost, WorkStationNM, MulEmp_flag, ExtGrp_Flag) " +
$"VALUES(@WorkStationGrpCd, @WorkStationGrpNm, @DLCost, @FOHCost, @MDCost, @WorkStationCD, @LastUpdUsr, @LastUpdDt, @UnionDLCost, @WorkStationNM, @MulEmp_flag, @ExtGrp_Flag); " +
$"SELECT SCOPE_IDENTITY();";
return(ExecuteScalar <int>(cmd, param));
}