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