//通过相应的storage表获得exist表 public Exist GetExist(Storage storage) { Exist exist = new Exist(); exist.IO_Id = storage.IO_Id; exist.Count = storage.Count; exist.IntoDate = DateTime.Now; exist.Co_id = storage.Co_id; OutIntoWareBusinessLayer outIntoWareBusinessLayer = new OutIntoWareBusinessLayer(); Out_Into_ware out_Into_Ware = outIntoWareBusinessLayer.GetOut_Into_ware(storage.IO_Id); exist.W_id = out_Into_Ware.Ware_id; exist.U_id = out_Into_Ware.User_id; return(exist); }
//[MultiButton("入库")] public ActionResult MakeTableSubmit(string Sumbit) { if (Sumbit == null && IsIntoOutWaretor) { return(new EmptyResult()); } Session["Table_Id"] = null; //string Sumbit = "入库"; Out_Into_ware out_Into_Ware = new Out_Into_ware(); out_Into_Ware.Make_date = DateTime.Now;//时间 UserBusinessLayer userBusinessLayer = new UserBusinessLayer(); WarehouseBusinessLayer warehouseBusinessLayer = new WarehouseBusinessLayer(); OutIntoWareBusinessLayer outIntoWareBusinessLayer1 = new OutIntoWareBusinessLayer(); User user = userBusinessLayer.GetUser(Session["User"].ToString()); out_Into_Ware.User_id = user.U_Id; //负责人编号 out_Into_Ware.Ware_id = warehouseBusinessLayer.GetId(user.U_point); //仓库编号 //创建表单号 Table_Id = "12343"; if (Sumbit == "商品入库") { I_type = "入库"; IsIntoOutWaretor = true; out_Into_Ware.type = IO_Type.INTO; //out_Into_Ware.Table_Id = "INTO" + Table_Id; out_Into_Ware.Table_Id = outIntoWareBusinessLayer1.GetMaxTable(IO_Type.INTO); } else if (Sumbit == "商品出库") { I_type = "出库"; IsIntoOutWaretor = true; out_Into_Ware.type = IO_Type.OUT; //out_Into_Ware.Table_Id = "OUT" + Table_Id; out_Into_Ware.Table_Id = outIntoWareBusinessLayer1.GetMaxTable(IO_Type.OUT); } //Session["Table_Id"] = out_Into_Ware.Table_Id; Table_Id = out_Into_Ware.Table_Id; //存入数据库 OutIntoWareBusinessLayer outIntoWareBusinessLayer = new OutIntoWareBusinessLayer(); outIntoWareBusinessLayer.InsertOut_Into_ware(out_Into_Ware); return(RedirectToAction("RedirectInOutWarehouse")); }
/// <summary> /// 返回在存的全部数据 /// </summary> /// <param name="U_name"></param> /// <returns></returns> public StorageViewModel GetStorageViewModel(bool Display, string U_name, int pageNumber = 1) { StorageViewModel storageViewModel = new StorageViewModel(); storageViewModel.UserName = U_name; storageViewModel.existTableListViewModel = new ExistTableListViewModel(); storageViewModel.existTableListViewModel.Display = Display ? "" : "none"; //storageViewModel.existTableListViewModel.existTableViewModels = new List<ExistTableViewModel>(); List <ExistTableViewModel> existTableViewModels = new List <ExistTableViewModel>(); ExistBusinessLayer existBusinessLayer = new ExistBusinessLayer(); CommodityBusinessLayer commodityBusinessLayer = new CommodityBusinessLayer(); OutIntoWareBusinessLayer outIntoWareBusinessLayer = new OutIntoWareBusinessLayer(); UserBusinessLayer userBusinessLayer = new UserBusinessLayer(); WarehouseBusinessLayer warehouseBusinessLayer = new WarehouseBusinessLayer(); //得到全部在存表中的数据 List <Exist> exists = existBusinessLayer.GetExist(); //Out_Into_ware out_Into_Ware; ExistTableViewModel existTableViewModel; foreach (Exist item in exists) { existTableViewModel = new ExistTableViewModel(); existTableViewModel.exist = item; //out_Into_Ware = outIntoWareBusinessLayer.GetOut_Into_ware(item.IO_Id); //得到姓名 existTableViewModel.U_name = userBusinessLayer.GetUsers("员工编号", item.U_id.ToString()).FirstOrDefault().U_name; //得到仓库名 existTableViewModel.W_name = warehouseBusinessLayer.GetWarehouse("仓库编号", item.W_id.ToString()).FirstOrDefault().Wa_name; existTableViewModel.commodity = commodityBusinessLayer.GetCommodity("商品编号", item.Co_id.ToString()).FirstOrDefault(); //storageViewModel.existTableListViewModel.existTableViewModels.Add(existTableViewModel); existTableViewModels.Add(existTableViewModel); } //每页显示多少条 //int pageSize = int.Parse(ConfigurationManager.AppSettings["pageSize"]); storageViewModel.existTableListViewModel.existTableViewModels = existTableViewModels; return(storageViewModel); }
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); }
/// <summary> /// 得到符合条件的在存数据 /// </summary> /// <param name="U_name">登陆人</param> /// <param name="Select">属性</param> /// <param name="name">属性值</param> /// <returns></returns> public StorageViewModel GetStorageViewModel(bool Display, string U_name, string Select, string name, int pageNumber = 1) { StorageViewModel storageViewModel = new StorageViewModel(); storageViewModel.UserName = U_name; storageViewModel.existTableListViewModel = new ExistTableListViewModel(); storageViewModel.existTableListViewModel.Display = Display ? "" : "none"; //storageViewModel.existTableListViewModel.existTableViewModels = new List<ExistTableViewModel>(); List <ExistTableViewModel> existTableViewModels = new List <ExistTableViewModel>(); ExistBusinessLayer existBusinessLayer = new ExistBusinessLayer(); CommodityBusinessLayer commodityBusinessLayer = new CommodityBusinessLayer(); OutIntoWareBusinessLayer outIntoWareBusinessLayer = new OutIntoWareBusinessLayer(); UserBusinessLayer userBusinessLayer = new UserBusinessLayer(); WarehouseBusinessLayer warehouseBusinessLayer = new WarehouseBusinessLayer(); //得到全部在存表中的数据 List <Exist> exists; if (Select == "入库单号" || Select == "商品编号") { exists = existBusinessLayer.GetExist(Select, name); } else { exists = existBusinessLayer.GetExist(); } //Out_Into_ware out_Into_Ware; ExistTableViewModel existTableViewModel; foreach (Exist item in exists) { existTableViewModel = new ExistTableViewModel(); existTableViewModel.exist = item; //out_Into_Ware = outIntoWareBusinessLayer.GetOut_Into_ware(item.IO_Id); //得到姓名 existTableViewModel.U_name = userBusinessLayer.GetUsers("员工编号", item.U_id.ToString()).FirstOrDefault().U_name; if (Select == "入库员工" && existTableViewModel.U_name != name) { continue; } //得到仓库名 existTableViewModel.W_name = warehouseBusinessLayer.GetWarehouse("仓库编号", item.W_id.ToString()).FirstOrDefault().Wa_name; if (Select == "存储仓库" && existTableViewModel.W_name != name) { continue; } //existTableViewModel.commodity = commodityBusinessLayer.GetCommodity("商品编号", item.Co_id.ToString()).FirstOrDefault(); CommodityMember commodityMember = new CommodityMember(); switch (Select) { case "商品编号": commodityMember.Co_Id = name; break; case "商品名称": commodityMember.Co_name = name; break; case "条码编号": commodityMember.Co_bar_code = name; break; case "商品分类": commodityMember.Co_type = name; break; } existTableViewModel.commodity = commodityBusinessLayer.GetCommodities(commodityMember).FirstOrDefault(); //storageViewModel.existTableListViewModel.existTableViewModels.Add(existTableViewModel); existTableViewModels.Add(existTableViewModel); } //每页显示多少条 //int pageSize = int.Parse(ConfigurationManager.AppSettings["pageSize"]); storageViewModel.existTableListViewModel.existTableViewModels = existTableViewModels; return(storageViewModel); }