/// <summary>
/// 修改库区信息
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int AlterReservoirarea(Reservoirarea rArea)
{
string str = $"update Reservoirarea set ReservoirAreaName='{rArea.ReservoirAreaName}',WarehouseId='{rArea.WarehouseId}',Remark='{rArea.Remark}' where ReservoirAreaId={rArea.ReservoirAreaId}";
return(DBHelper.ExecuteNonQuery(str));
}
public IActionResult PutReservoirarea([FromBody] Reservoirarea reservoirarea)
{
return(new JsonResult(reservoirareaDAL.AlterReservoirarea(reservoirarea)));
}
/// <summary>
/// 添加新库区
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
public int AddReservoirarea(Reservoirarea rArea)
{
string str = $"insert into Reservoirarea values('{rArea.ReservoirAreaName}',{rArea.WarehouseId},0,'{rArea.Remark}','{rArea.CreateBy}',GETDATE(),'{rArea.ModifiedBy}',GETDATE())";
return(DBHelper.ExecuteNonQuery(str));
}