public int Delete(ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStation d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@WorkStationCd", d.WorkStationCd.GetValue());
param.Add("@WorkStationNm", d.WorkStationNm.GetValue());
param.Add("@WSProfit", d.WSProfit.GetValue());
param.Add("@WSProfit_NM", d.WSProfit_NM.GetValue());
param.Add("@SelProfit", d.SelProfit.GetValue());
param.Add("@CANCELFLAG", d.CANCELFLAG.GetValue());
string cmd = "";
/*
* cmd = DELETE FROM .dbo.msWorkStation "+
* "WHERE WorkStationCd = @.WorkStationCd "+
* " AND WorkStationNm = @.WorkStationNm "+
* " AND WSProfit = @.WSProfit "+
* " AND WSProfit_NM = @.WSProfit_NM "+
* " AND SelProfit = @.SelProfit "+
* " AND CANCELFLAG = @.CANCELFLAG "+
* " ";
*/
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.msWorkStation d, string userID = "")
{
var param = new Dapper.DynamicParameters();
param.Add("@WorkStationCd", d.WorkStationCd);
param.Add("@WorkStationNm", d.WorkStationNm);
param.Add("@WSProfit", d.WSProfit);
param.Add("@WSProfit_NM", d.WSProfit_NM);
param.Add("@SelProfit", d.SelProfit);
param.Add("@CANCELFLAG", d.CANCELFLAG);
string cmd = "INSERT INTO .dbo.msWorkStation " +
$" (WorkStationCd, WorkStationNm, WSProfit, WSProfit_NM, SelProfit, CANCELFLAG) " +
$"VALUES(@WorkStationCd, @WorkStationNm, @WSProfit, @WSProfit_NM, @SelProfit, @CANCELFLAG); " +
$"SELECT SCOPE_IDENTITY();";
return(ExecuteScalar <int>(cmd, param));
}
