public ActionResult Edit(MaterialIn materialin)
{
if (ModelState.IsValid)
{
db.Entry(materialin).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(materialin);
}
public ActionResult Create(MaterialIn materialin)
{
if (ModelState.IsValid)
{
db.MaterialIns.Add(materialin);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(materialin);
}
public ActionResult MaterialInView(int id,string act)
{
if (!UserInfo.CurUser.HasRight("物资设备-物资入库查询")) return Redirect("~/content/AccessDeny.htm");
var r = (from o in db.MaterialIns where o.Id == id select o).FirstOrDefault();
if (r == null)
{
r = new MaterialIn();
}
ViewBag.Items = (from o in db.MaterialInItems where o.MaterialId == id select o).ToList();
using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
conn.Open();
var items =
conn.Query(
string.Format("select m.DepartmentId, m.Name,m.CatalogId,i.UnitPrice,i.Num from materialinitems i join materials m on i.materialid=m.id where i.inid={0}", r.Id));
ViewBag.Items2 = items;
}
//ViewBag.Items1 = (from o in db.MaterialInItems select new { UnitPrice = o.UnitPrice, Num = o.Num }).ToList();
if (act == "print")
return View("MaterialInPrint", r);
return View(r);
}
public ActionResult MaterialInEdit(int id, string itemsString, FormCollection collection)
{
if (!UserInfo.CurUser.HasRight("物资设备-物资入库输入")) return Redirect("~/content/AccessDeny.htm");
MaterialIn r = (from o in db.MaterialIns where o.Id == id select o).FirstOrDefault();
if (r == null)
{
r = new MaterialIn {MallId = mallid}; db.MaterialIns.Add(r);
}
MaterialIn v=new MaterialIn();
TryUpdateModel(r, collection);
r.PersonId = UserInfo.CurUser.Id;
List<MaterialInItem> items = Newtonsoft.Json.JsonConvert.DeserializeObject<List<MaterialInItem>>(itemsString);
foreach (var materialInItem in items)
{
if (materialInItem.MaterialId == 0) ModelState.AddModelError("", "请选择物料");
}
if(items.Count==0)
{
ModelState.AddModelError("", "入库单的物料明细不能为空");
}
if (ModelState.IsValid == false)
{
ViewBag.ItemsString = Newtonsoft.Json.JsonConvert.SerializeObject(items);
return View(r);
}
else
{
db.SaveChanges();
(from o in db.MaterialInItems where o.InId == r.Id select o).ToList().ForEach(o => db.MaterialInItems.Remove(o));
foreach (var item in items)
{
item.InId = r.Id;
db.MaterialInItems.Add(item);
}
db.SaveChanges();
return Redirect("../MaterialInView/" + r.Id);
}
}
public ActionResult MaterialInEdit(int id)
{
if (!UserInfo.CurUser.HasRight("物资设备-物资入库输入")) return Redirect("~/content/AccessDeny.htm");
var r = (from o in db.MaterialIns where o.Id == id select o).FirstOrDefault();
if (r == null)
{
r = new MaterialIn();
}
List<MaterialInItem> items = (from o in db.MaterialInItems where o.InId == id select o).ToList();
ViewBag.ItemsString = Newtonsoft.Json.JsonConvert.SerializeObject(items);
return View(r);
}