public ActionResult InOutTable() { //if (Session["Table_Id"] == null) if (Table_Id == "" || Table_Id == null) { //没有创建表单号 return(new EmptyResult()); } //获取信息 InOutTableViewModel inOutTableViewModel = new InOutTableViewModel(); inOutTableViewModel.type = I_type; inOutTableViewModel.commodityViewModels = new List <CommodityViewModel>(); inOutTableViewModel.IO_id = Table_Id; //通过表号查询storate表的数据(物品编号,数量,时间), //通过编号查询commodity表 //将数据(commodity表、时间、数量)存入CommodityViewModel CommodityBusinessLayer commodityBusinessLayer = new CommodityBusinessLayer(); Commodity commodity; StorageBusinessLayer storageBusinessLayer = new StorageBusinessLayer(); //List<Storage> storages = storageBusinessLayer.GetStorage("IO_Id", Session["Table_Id"].ToString()); List <Storage> storages = storageBusinessLayer.GetStorage("IO_Id", Table_Id); foreach (Storage storage in storages) { commodity = commodityBusinessLayer.GetCommodity(storage.Co_id, "", ""); inOutTableViewModel.commodityViewModels.Add(new CommodityViewModel() { commodity = commodity, Count = storage.Count, Out_into_date = storage.IntoDate }); } return(PartialView("InOutTable", inOutTableViewModel)); }
public ActionResult InOutWarehouse(string BtnSubmit, Commodity commodity, string sid, int Count) { InOutWarehouseViewModel inOutWarehouseViewModel = new InOutWarehouseViewModel(); inOutWarehouseViewModel.UserName = Session["User"].ToString(); if (BtnSubmit == "手动入库" || BtnSubmit == "手动出库") { if (!SelectIntoOut) { //显示物品的数据 CommodityBusinessLayer commodityBusinessLayer = new CommodityBusinessLayer(); inOutWarehouseViewModel.commodity = commodityBusinessLayer.GetCommodity(sid, commodity); if (!inOutWarehouseViewModel.commodity.Equals(commodity)) { SelectIntoOut = true; } } else { //存储数据到Storage表(出入库单号、物品号、物品数量) StorageBusinessLayer storageBusinessLayer = new StorageBusinessLayer(); Storage storage = new Storage(); storage.Co_id = commodity.Co_Id; //storage.IO_Id = Session["Table_Id"].ToString(); storage.IO_Id = Table_Id; storage.Count = Count; storage.IntoDate = DateTime.Now; storageBusinessLayer.InsertStorage(storage); SelectIntoOut = false; inOutWarehouseViewModel.commodity = new Commodity(); } } else { StorageBusinessLayer storageBusinessLayer = new StorageBusinessLayer(); if (BtnSubmit == "完成入库") { //将入库的数据存储到Exist表中 ExistBusinessLayer existBusinessLayer = new ExistBusinessLayer(); InOutWarehouseBusinessLayer inOutWarehouseBusinessLayer = new InOutWarehouseBusinessLayer(); Exist exist; List <Storage> storages = storageBusinessLayer.GetStorage("IO_Id", Table_Id); foreach (Storage storage in storages) { exist = inOutWarehouseBusinessLayer.GetExist(storage); existBusinessLayer.InsertExist(exist); } } else if (BtnSubmit == "完成出库") { //将入库的数据在exit表中删除 //将入库的数据存储到Exist表中 ExistBusinessLayer existBusinessLayer = new ExistBusinessLayer(); InOutWarehouseBusinessLayer inOutWarehouseBusinessLayer = new InOutWarehouseBusinessLayer(); //Exist exist; List <Storage> storages = storageBusinessLayer.GetStorage("IO_Id", Table_Id); foreach (Storage storage in storages) { existBusinessLayer.Delete(storage); } } else if (BtnSubmit == "取消入库" || BtnSubmit == "取消出库") { //将入库的数据删除 storageBusinessLayer.Delete(Table_Id); OutIntoWareBusinessLayer outIntoWareBusinessLayer = new OutIntoWareBusinessLayer(); outIntoWareBusinessLayer.Delete(Table_Id); } IsIntoOutWaretor = false; //设置为不是出入库状态IsIntoOutWaretor = false; SelectIntoOut = false; //设置状态为取消SelectIntoOut = false; Table_Id = ""; //表数据清除 } I_commodity = inOutWarehouseViewModel.commodity; return(RedirectToAction("RedirectInOutWarehouse")); //return View("inOutWarehouse", inOutWarehouseViewModel); }