public int Uptsstate(int id) { IOT.Core.Model.Commodity commodity = DapperHelper.GetList <Model.Commodity>($"select * from Commodity where CommodityId={id}").FirstOrDefault(); if (commodity.IsSell == 0) { commodity.IsSell = 1; } else { commodity.IsSell = 0; } string sql = $"update Commodity set IsSell={commodity.IsSell} where CommodityId={commodity.CommodityId}"; return(DapperHelper.Execute(sql)); }
public int Uptstate(int id) { var list = DapperHelper.GetList <Model.Commodity>($"select * from Commodity ").ToList(); IOT.Core.Model.Commodity commodity = list.FirstOrDefault(m => m.CommodityId == id); if (commodity.DeleteState == 0) { commodity.DeleteState = 1; } else { commodity.DeleteState = 0; } string sql = $"update Commodity set DeleteState={commodity.DeleteState} where CommodityId={commodity.CommodityId}"; return(DapperHelper.Execute(sql)); }
public int CommodityUpt(IOT.Core.Model.Commodity a) { return(_Commodity.UptCommodity(a)); }