public ActionResult searchWarehouse(string wareName) { WarehouseViewModel warehouseViewModel = new WarehouseViewModel(); //判断是否是管理人员,是则有权限进行修改 if (Convert.ToInt32(Session["level"]) == Convert.ToInt32(level.Admin)) { warehouseViewModel.display = ""; } else { warehouseViewModel.display = "display:none"; } warehouseViewModel.UserName = Session["User"].ToString(); WarehouseBusinessLayer warehouseBusinessLayer = new WarehouseBusinessLayer();//第几页 int pageNumber = 1; //每页显示多少条 int pageSize = int.Parse(ConfigurationManager.AppSettings["pageSize"]); warehouseViewModel.warehouses = warehouseBusinessLayer.GetWarehouse(wareName).ToPagedList(pageNumber, pageSize); return(View("Warehouse", warehouseViewModel)); }
//[AdminFilter] public ActionResult Warehouse(int?page) { WarehouseViewModel warehouseViewModel = new WarehouseViewModel(); //判断是否是管理人员,是则有权限进行修改 if (Convert.ToInt32(Session["level"]) == Convert.ToInt32(level.Admin)) { warehouseViewModel.display = ""; } else { warehouseViewModel.display = "display:none"; } warehouseViewModel.UserName = Session["User"].ToString(); //第几页 int pageNumber = page ?? 1; if (NoChangePage) { pageNumber = HomeController.page; NoChangePage = false; } HomeController.page = pageNumber; //每页显示多少条 int pageSize = int.Parse(ConfigurationManager.AppSettings["pageSize"]); WarehouseBusinessLayer warehouseBusinessLayer = new WarehouseBusinessLayer(); warehouseViewModel.warehouses = warehouseBusinessLayer.GetWarehouse().ToPagedList(pageNumber, pageSize); return(View("Warehouse", warehouseViewModel)); }
/// <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); }
//[HttpGet] public ActionResult RedirectStorage(int?page) { MyStorageBusinessLayer storageBusinessLayer = new MyStorageBusinessLayer(); //判断是否为管理员,是管理员则为空,不是则为none,对应修改按钮是否显示 bool Display = (level.Admin == (level)Session["level"]); //获取显示的数据 StorageViewModel storageViewMode1; int pageSize = int.Parse(ConfigurationManager.AppSettings["pageSize"]); int pageNumber = page ?? 1; while (IsSearchExist) { //获取user id string U_id = null; if (!S_userMember.Equals(new UserMember())) { if (S_userMember.U_Id != "" || S_userMember.U_name != "") { UserBusinessLayer userBusinessLayer = new UserBusinessLayer(); List <User> users = userBusinessLayer.GetUsers(S_userMember); if (users == null) { break; } U_id = users.FirstOrDefault().U_Id.ToString(); } } //获取全部exist的数据 storageViewMode1 = storageBusinessLayer.GetStorageViewModel(Display, Session["User"].ToString(), pageNumber); //获取comm id集合 List <Commodity> commodities = new List <Commodity>(); if (!S_commodityMember.Equals(new CommodityMember())) { CommodityBusinessLayer commodityBusinessLayer = new CommodityBusinessLayer(); commodities = commodityBusinessLayer.GetCommodities(S_commodityMember); } //获取ware id集合 List <Warehouse> warehouses = new List <Warehouse>(); if (!S_warehouseMember.Equals(new WarehouseMember())) { WarehouseBusinessLayer warehouseBusinessLayer = new WarehouseBusinessLayer(); warehouses = warehouseBusinessLayer.GetWarehouse(S_warehouseMember); } bool[] k = new bool[4]; ExistTableViewModel existTableViewModel; for (int i = storageViewMode1.existTableListViewModel.existTableViewModels.Count() - 1; i >= 0; i--) { k[0] = k[1] = k[2] = k[3] = true; existTableViewModel = storageViewMode1.existTableListViewModel.existTableViewModels[i]; //是否符合物品条件 if (U_id == null || existTableViewModel.exist.U_id.ToString() == U_id) { k[0] = false; } //是否符合物品条件 if (commodities != null && commodities.Count() > 0) { foreach (Commodity commodity in commodities) { if (commodity.Co_Id == existTableViewModel.exist.Co_id) { k[1] = false; break; } } } else { k[1] = false; } //是否符合仓库条件 if (warehouses != null && warehouses.Count() > 0) { foreach (Warehouse warehouse in warehouses) { if (warehouse.Wa_Id == existTableViewModel.exist.W_id) { k[2] = false; break; } } } else { k[2] = false; } //是否符合时间区间 DateTime dateTime = new DateTime(); if ((S_existMember.Star_date.Equals(dateTime.ToString()) || DateTime.Compare(Convert.ToDateTime(S_existMember.Star_date), existTableViewModel.exist.IntoDate) != 1) && (S_existMember.End_date.Equals(dateTime.ToString()) || DateTime.Compare(Convert.ToDateTime(S_existMember.End_date), existTableViewModel.exist.IntoDate) != -1)) { k[3] = false; } //整合条件 if (k[0] || k[1] || k[2] || k[3]) { storageViewMode1.existTableListViewModel.existTableViewModels.Remove(existTableViewModel); } } // storageViewMode1 = storageBusinessLayer.GetStorageViewModel(Display, Session["User"].ToString()); storageViewMode1.existTableListViewModel.iPagedLists = storageViewMode1.existTableListViewModel.existTableViewModels.ToPagedList(pageNumber, pageSize); return(View("Storage", storageViewMode1)); } storageViewMode1 = storageBusinessLayer.GetStorageViewModel(Display, Session["User"].ToString()); storageViewMode1.existTableListViewModel.iPagedLists = storageViewMode1.existTableListViewModel.existTableViewModels.ToPagedList(pageNumber, pageSize); return(View("Storage", storageViewMode1)); }
/// <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); }