/// <summary>
/// 修改货架信息
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int AlterStoragerack(Storagerack sRack)
{
string str = $"update Storagerack set StorageRackName='{sRack.StorageRackName}',ReservoirAreaId='{sRack.ReservoirAreaId}',Remark='{sRack.Remark}' where StorageRackId={sRack.StorageRackId}";
return(DBHelper.ExecuteNonQuery(str));
}
public IActionResult PutStoragerack([FromBody] Storagerack storagerack)
{
return(new JsonResult(storagerackDAL.AlterStoragerack(storagerack)));
}
/// <summary>
/// 添加新货架
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int AddStoragerack(Storagerack sRack)
{
string str = $"insert into Storagerack values('{sRack.StorageRackName}','{sRack.ReservoirAreaId}',0,'{sRack.Remark}','{sRack.CreateBy}',GETDATE(),'{sRack.ModifiedBy}',GETDATE())";
return(DBHelper.ExecuteNonQuery(str));
}
