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