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); }