public ActionResult InstockReturn(int id, FormCollection collection)
{
FoodMaterialInstockReturn ret = new FoodMaterialInstockReturn();
if (id == 0)
{
int instockid = 0;
int.TryParse(Request["instockid"], out instockid);
ret.InstockId = instockid;
db.FoodMaterialInstockReturns.Add(ret);
}
else
{
ret = (from o in db.FoodMaterialInstockReturns where o.Id == id select o).FirstOrDefault();
}
TryUpdateModel(ret, "", null, new string[] { "InstockId" }, collection);
if (ret.Num <= 0)
{
ModelState.AddModelError("Num", "数量必须大于0");
}
if (ModelState.IsValid)
{
ret.PersonId = UserInfo.CurUser.Id;
db.SaveChanges();
db.Database.ExecuteSqlCommand(string.Format("update foodmaterialinstocks set num={0} where id={1}", ret.BeforeNum - ret.Num, ret.InstockId));
return Redirect("~/content/close.htm");
}
return View(ret);
}
public ActionResult InstockReturn(int id)
{
FoodMaterialInstockReturn ret = new FoodMaterialInstockReturn();
if (id != 0)
{
ret = (from o in db.FoodMaterialInstockReturns where o.Id == id select o).FirstOrDefault();
}
else
{
int instockid = 0;
int.TryParse(Request["instockid"], out instockid);
FoodMaterialInstock instock = (from o in db.FoodMaterialInstocks where o.Id == instockid select o).FirstOrDefault();
if (instock == null)
{
return View("ShowError", "", "找不到入库单");
}
ret.BeforeNum = instock.Num;
ret.ReturnDate = DateTime.Today;
}
return View(ret);
}
