/// <summary> /// 添加物料入仓 /// </summary> private void AddEnterWareHouse(HttpContext context) { Model.domain_EnterWareHouseLog log = new Model.domain_EnterWareHouseLog() { OrderID = context.Request["OrderID"]??"", MaterialName = context.Request["MaterialName"]??"", ModelNumber = context.Request["ModelNumber"] ?? "", CategoryName = context.Request["CategoryName"] ?? "", UnitName = context.Request["UnitName"]??"", Amout = decimal.Parse(context.Request["Amout"]??""), WareHouseID = NCore.DataConvert.ToInt(context.Request["WareHouseID"],0), WareHouseName = context.Request["WareHouseName"]??"", Suppliers = context.Request["Suppliers"]??"", Remark = context.Request["Remark"]??"", DealWithBy = context.Request["DealWithBy"] ?? "", Department = context.Request["Department"] ?? "", DoBy = context.Request["DoBy"] ?? "", DoTime = DateTime.Now }; db.domain_EnterWareHouseLog.Add(log); int num = db.SaveChanges(); }
/// <summary> /// 添加物料入仓 /// </summary> private void AddEnterWareHouse(HttpContext context) { int WareHouseID = NCore.DataConvert.ToInt(context.Request["WareHouseID"],0); string WareHouseName = context.Request["WareHouseName"] ?? ""; string MaterialName = context.Request["MaterialName"]??""; string ModelNumber = context.Request["ModelNumber"] ?? ""; decimal Amout = decimal.Parse(context.Request["Amout"] ?? ""); Model.domain_EnterWareHouseLog log = new Model.domain_EnterWareHouseLog() { OrderID = context.Request["OrderID"]??"", MaterialName = MaterialName, ModelNumber = ModelNumber, CategoryName = context.Request["CategoryName"] ?? "", UnitName = context.Request["UnitName"]??"", Amout = Amout, WareHouseID = WareHouseID, WareHouseName = WareHouseName, Suppliers = context.Request["Suppliers"]??"", Remark = context.Request["Remark"]??"", DealWithBy = context.Request["DealWithBy"] ?? "", Department = context.Request["Department"] ?? "", DoBy = context.Request["DoBy"] ?? "", DoTime = DateTime.Now }; db.domain_EnterWareHouseLog.Add(log); int num = db.SaveChanges(); if (num > 0) //日志录入成功 { List<domain_Material_WareHouse> list = db.domain_Material_WareHouse .Where(w => w.WareHouseID == WareHouseID && w.MaterialName == MaterialName && w.MaterialModelNumber == ModelNumber) .ToList(); if (list.Count > 0) { //物料库存表中存在 domain_Material_WareHouse mw = list[0]; //增加库存量 mw.KuCun += Amout; //先将实体附加到实体上下文中 db.domain_Material_WareHouse.Attach(mw); //手动修改实体的状态 db.Entry(mw).State = EntityState.Modified; int r1= db.SaveChanges(); if(r1>0) { context.Response.Write("{\"d\":1}"); } else { context.Response.Write("{\"d\":0,\"msg\":\"保存失败!\"}"); } } else { //物料库存表中不存在 domain_Material_WareHouse mw = new domain_Material_WareHouse() { KuCun = Amout, MaterialModelNumber = ModelNumber, MaterialName = MaterialName, WareHouseID = WareHouseID, WareHouseName = WareHouseName }; db.domain_Material_WareHouse.Add(mw); int r1 = db.SaveChanges(); if (r1 > 0) { context.Response.Write("{\"d\":1}"); } else { context.Response.Write("{\"d\":0,\"msg\":\"保存失败!\"}"); } } } else { context.Response.Write("{\"d\":0,\"msg\":\"保存失败!\"}"); } }