public List <Commodity> GetCommodities(CommodityMember commodityMember) { WarehouseERPDAL dB = new WarehouseERPDAL(); List <Commodity> commodities; commodities = dB.commoditys.Where(c => (commodityMember.Co_bar_code == null || c.Co_bar_code == commodityMember.Co_bar_code) && (commodityMember.Co_Id == null || c.Co_Id.ToString() == commodityMember.Co_Id) && (commodityMember.Co_name == null || c.Co_name == commodityMember.Co_name) && (commodityMember.Co_note == null || c.Co_note == commodityMember.Co_note) && (commodityMember.Co_price == null || c.Co_price.ToString() == commodityMember.Co_price) && (commodityMember.Co_specification == null || c.Co_specification == commodityMember.Co_specification) && (commodityMember.Co_type == null || c.Co_type == commodityMember.Co_type) && (commodityMember.Co_unit == null || c.Co_unit == commodityMember.Co_unit) && (commodityMember.Co_weight == null || c.Co_weight.ToString() == commodityMember.Co_weight)).ToList(); return(commodities == null ? new List <Commodity>() : commodities); }
/// <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); }