public int Save(ASSETKKF_MODEL.Data.Mssql.Mcis.lnItemGroup d, string userID = "", SqlTransaction transac = null)
{
var req = new ASSETKKF_MODEL.Request.Mcis.lnItemGroupReq();
req.Seq_Itemgroup = d.seq_itemgroup;
if (GetDataSeq(req).Count > 0)
{
return(Update(d, userID, transac));
}
return(Insert(d, userID, transac));
}
public int Insert(ASSETKKF_MODEL.Data.Mssql.Mcis.lnItemGroup d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@Seq_Itemgroup", d.seq_itemgroup);
param.Add("@Item_Group", d.itemgroup);
param.Add("@Description", d.description);
string cmd = "INSERT INTO mcis.dbo.lnItemGroup " +
$" (Seq_Itemgroup, Item_Group, Description) " +
$"VALUES(@Seq_Itemgroup, @Item_Group, @Description); " +
$"SELECT SCOPE_IDENTITY();";
return(ExecuteScalar <int>(cmd, param));
}
public int Update(ASSETKKF_MODEL.Data.Mssql.Mcis.lnItemGroup d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@Seq_Itemgroup", d.seq_itemgroup);
param.Add("@Item_Group", d.itemgroup.GetValue());
param.Add("@Description", d.description.GetValue());
string cmd = "UPDATE mcis.dbo.lnItemGroup " +
"SET Item_Group = @Item_Group " +
" , Description = @Description " +
"WHERE Seq_Itemgroup = @Seq_Itemgroup " +
" ";
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
public int Delete(ASSETKKF_MODEL.Data.Mssql.Mcis.lnItemGroup d, string userID = "", SqlTransaction transac = null)
{
var param = new Dapper.DynamicParameters();
param.Add("@Seq_Itemgroup", d.seq_itemgroup);
param.Add("@Item_Group", d.itemgroup.GetValue());
param.Add("@Description", d.description.GetValue());
string cmd = "";
/*
* cmd = DELETE FROM mcis.dbo.lnItemGroup "+
* "WHERE Seq_Itemgroup = @.Seq_Itemgroup "+
* " AND Item_Group = @.Item_Group "+
* " AND Description = @.Description "+
* " ";
*/
var res = ExecuteNonQuery(transac, cmd, param);
return(res);
}
