/// <summary> /// 由于按订单出库,因此单独有表记录订单出库数量 /// </summary> /// <param name="obr"></param> public void InsertOutBoundRecord(OutBoundRecord obr) { using (var dbContext = new StoreDbContext()) { dbContext.Insert <OutBoundRecord>(obr); } }
public ActionResult Create(FormCollection collection) { if (collection.AllKeys.Contains("DictionaryProperty.dpid")) { StoreTableRequest request = new StoreTableRequest(); request.PageSize = 1000; request.Gid = new Guid(collection["DictionaryProperty.dpid"]); int OutProductNumber; if (!int.TryParse(collection["OutBoundCount"], out OutProductNumber)) { var model = new StoreTable(); return(View("OutBoundEdit", model)); } //OutProductNumber = int.Parse(collection["OutBoundCount"]); //出库订单件数 var result = this.StoreService.GetStoreList(request); Guid tempid = new Guid(); foreach (StoreTable st in result) { if (st.DictionaryProperty.leaf_id == request.Gid) { st.number = st.number - (st.DictionaryProperty.js.Value * Convert.ToDecimal(OutProductNumber)); InBoundRecord ibr = new InBoundRecord(); //插入数据到入库记录表 ibr.inbound_id = st.store_item_id; ibr.rkid = Guid.NewGuid(); ibr.number = st.number; ibr.boundtype = "出库材料"; ibr.khmc = this.StoreService.GetParentNameByLeafID(st.DictionaryProperty.leaf_id.Value); this.StoreService.InsertInboundRecord(ibr); tempid = st.DictionaryProperty.leaf_id.Value; //出库 this.StoreService.OutBoundItem(st); } } //插入到出库记录表 OutBoundRecord obr = new OutBoundRecord(); obr.ckid = Guid.NewGuid(); obr.node_id = tempid; obr.number = OutProductNumber; this.StoreService.InsertOutBoundRecord(obr); } return(this.RefreshParent()); }
public ActionResult Create(FormCollection collection) { if (collection.AllKeys.Contains("DictionaryProperty.dpid")) { StoreTableRequest request = new StoreTableRequest(); request.PageSize = 10000; request.Gid = new Guid(collection["DictionaryProperty.dpid"]); int OutProductNumber; if (!int.TryParse(collection["OutBoundCount"], out OutProductNumber)) { var model = new StoreTable(); return(View("OutBoundEdit", model)); } var lydw = collection["employment"]; /// var result = this.StoreService.GetStoreList(request); Guid tempid = new Guid();//订单ID,出库记录表用 //获取订单下所有材料 StoreTreeNameRequests stnRequest = new StoreTreeNameRequests(); stnRequest.PageSize = 1000; stnRequest.treeID = request.Gid; var dpLists = this.StoreService.GetNodeProperty(stnRequest); foreach (DictionaryProperty dp in dpLists) { var storeItem = this.StoreService.ExistDPInStore(dp); tempid = dp.leaf_id.Value; //判断store里是否有dp if (storeItem == null) { StoreTable st = new StoreTable(); st.number = 0; st.number = st.number - (dp.js.Value * Convert.ToDecimal(OutProductNumber)); st.store_item_id = dp.dpid; InBoundRecord ibr = new InBoundRecord(); //插入数据到入库记录表 ibr.inbound_id = st.store_item_id; ibr.rkid = Guid.NewGuid(); ibr.number = dp.js.Value * Convert.ToDecimal(OutProductNumber); ibr.boundtype = "出库材料"; ibr.employment = lydw; ibr.khmc = this.StoreService.GetParentNameByLeafID(dp.leaf_id.Value); this.StoreService.InsertInboundRecord(ibr); //出库 this.StoreService.InsertStoreItem(st); } else//有StoreItem { storeItem.number = storeItem.number - (dp.js.Value * Convert.ToDecimal(OutProductNumber)); InBoundRecord ibr = new InBoundRecord(); //插入数据到入库记录表 ibr.inbound_id = storeItem.store_item_id; ibr.rkid = Guid.NewGuid(); ibr.number = dp.js.Value * Convert.ToDecimal(OutProductNumber); ibr.boundtype = "出库材料"; ibr.employment = lydw; ibr.khmc = this.StoreService.GetParentNameByLeafID(storeItem.DictionaryProperty.leaf_id.Value); this.StoreService.InsertInboundRecord(ibr); //出库 this.StoreService.OutBoundItem(storeItem); } // } //插入到出库记录表 OutBoundRecord obr = new OutBoundRecord(); obr.ckid = Guid.NewGuid(); obr.node_id = tempid; obr.employment = lydw; obr.number = OutProductNumber; this.StoreService.InsertOutBoundRecord(obr); } return(this.RefreshParent()); }