public int Update(ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp_Spare d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@WorkStationGrpCd", d.WorkStationGrpCd.GetValue());
param.Add("@WorkStationGrpCd_Spare", d.WorkStationGrpCd_Spare.GetValue());
param.Add("@User_Id", d.User_Id.GetValue());
param.Add("@User_date", d.User_date);
string cmd = "";
/*
* cmd = UPDATE mcis.dbo.msWorkStationGrp_Spare "+
* "SET WorkStationGrpCd = @.WorkStationGrpCd "+
* " , WorkStationGrpCd_Spare = @.WorkStationGrpCd_Spare "+
* " , User_Id = @.User_Id "+
* " , User_date = @.User_date "+
* "WHERE WorkStationGrpCd = @.WorkStationGrpCd "+
* " AND WorkStationGrpCd_Spare = @.WorkStationGrpCd_Spare "+
* " AND User_Id = @.User_Id "+
* " AND User_date = @.User_date "+
* " ";
*/
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStationGrp_Spare d, string userID = "")
{
var param = new Dapper.DynamicParameters();
param.Add("@WorkStationGrpCd", d.WorkStationGrpCd);
param.Add("@WorkStationGrpCd_Spare", d.WorkStationGrpCd_Spare);
param.Add("@User_Id", d.User_Id);
param.Add("@User_date", d.User_date);
string cmd = "INSERT INTO mcis.dbo.msWorkStationGrp_Spare " +
$" (WorkStationGrpCd, WorkStationGrpCd_Spare, User_Id, User_date) " +
$"VALUES(@WorkStationGrpCd, @WorkStationGrpCd_Spare, @User_Id, @User_date); " +
$"SELECT SCOPE_IDENTITY();";
return(ExecuteScalar <int>(cmd, param));
}
