public void ChangeDataContext(TextileInventoryHeader textileInventoryHeader, IEnumerable <TextileColorInventory> textileColorInventoryList) { InventoryListViewModel inventoryListViewModel = this.DataContext as InventoryListViewModel; inventoryListViewModel.TextileColorList = textileColorInventoryList; inventoryListViewModel.TextileInventoryHeader = textileInventoryHeader; inventoryListViewModel.Change(); }
public InventoryViewModel() { PageCaption = new PageCaptionViewModel("Инвентарь"); InventoryItems = new InventoryListViewModel(); ReportCommand = new RelayCommand(ShowPrintPreviewReport); ReceiptCommand = new RelayCommand(x => GoToPage(ApplicationPage.InventoryReceipt)); }
// GET: ProductInventories public IActionResult Index(string itemNumber, int catId = 0, int locationId = 0, int styleId = 0) { var inventories = _context.ProductInventory.Include(p => p.Location).Include(p => p.Product).Include(p => p.Style).AsQueryable(); var products = _context.Product.Include(p => p.Category).AsQueryable(); //Prepare data for drop downs StoreSelectListsInViewData(); if (styleId > 0) { inventories = inventories.Where(pv => pv.StyleId == styleId); } if (locationId > 0) { inventories = inventories.Where(pv => pv.LocationId == locationId); } if (catId > 0) { var productsInCat = products.Where(p => p.CategoryId == catId) .Select(p => p.ProductId); if (productsInCat.Count() > 0) { inventories = inventories.Where(pv => productsInCat.Contains(pv.ProductId)); } else { //never true, we do this because we cannot set this collection to null directly inventories = inventories.Where(pv => pv.ProductId < 0); } } if (!string.IsNullOrEmpty(itemNumber)) { var product = products.Where(p => p.ItemNumber.Equals(itemNumber)) .FirstOrDefault(); if (product != null) { inventories = inventories.Where(pv => pv.ProductId == product.ProductId); } else { //never true in database inventories = inventories.Where(pv => pv.ProductId < 0); } } //sort items by category, itemNumber, style and location inventories = inventories.OrderBy(pi => pi.Product.CategoryId).ThenBy(pi => pi.ProductId) .ThenBy(pi => pi.StyleId).ThenBy(pi => pi.LocationId); var model = new InventoryListViewModel() { Inventories = inventories, Products = products }; return(View(model)); }
public DataTable GetProductInventoryListData(InventoryListViewModel queryModel, LanguageEnum languageEnum) { var page = new PagingModel() { PageIndex = 1, PageSize = int.MaxValue }; var ds = productDAL.GetProductInventoryList(queryModel, languageEnum, page); return(ds.Tables[0]); }
public ActionResult Index() { var inventories = _inventoryService.GetAll(); InventoryListViewModel model = new InventoryListViewModel { Inventories = inventories }; return(View(model)); }
public InventoryListDialog(string fileName, TextileInventoryHeader textileInventoryHeader, IEnumerable <TextileColorInventory> textileColorInventoryList) { InitializeComponent(); InventoryListViewModel = new InventoryListViewModel() { FileName = fileName, TextileColorList = textileColorInventoryList, TextileInventoryHeader = textileInventoryHeader }; this.DataContext = InventoryListViewModel; }
public PageOf <SkuInfo> GetProductInventoryList(InventoryListViewModel queryModel, LanguageEnum languageEnum, Models.PagingModel page) { var ds = productDAL.GetProductInventoryList(queryModel, languageEnum, page); return(new PageOf <SkuInfo>() { PageIndex = page.PageIndex, PageSize = page.PageSize, Total = Convert.ToInt32(ds.Tables[1].Rows[0][0]), RowCount = Convert.ToInt32(ds.Tables[1].Rows[0][1]), Items = DataMapHelper.DataSetToList <SkuInfo>(ds) }); }
private string CreateInventoryListHtml(InventoryListViewModel rlvm) { var text = File.ReadAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"PDFs/Views/InventoryList.cshtml")); var renderedText = Razor.Parse(text, rlvm); var html = new StringBuilder(); html.Append("<html><head><style type=\"text/css\">"); html.Append(File.ReadAllText(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"PDFs/Styles/InventoryList.css"))); html.Append("</style></head><body>"); html.Append(renderedText); html.Append("</body></html>"); return(html.ToString()); }
public ActionResult Index() { try { var _invent = _InventoryManager.GetAll(); var Ilvm = new InventoryListViewModel { Inventories = _invent }; return(View(Ilvm)); } catch (Exception ex) { //Log exception return(View(ex.ToString())); } }
public FileResult ExportInventoryListToExcel(InventoryListViewModel Model) { var fileName = "Inventory" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx"; try { var dateTable = productBll.GetProductInventoryListData(Model, LanguageEnum.TraditionalChinese); var dtExporter = new DataTableExporter(EnumExcelType.XLSX); dtExporter.AddTable <InventoryListExportModel>(dateTable, "SKU庫存"); return(XlsxFile(dtExporter.Export(), fileName)); } catch (Exception ext) { LogHelper.Error(ext); } return(XlsxFile(new byte[0], fileName)); }
public ActionResult InventoryList(InventoryListViewModel Model) { try { var pageSetting = new PagingModel() { PageIndex = Model.PageIndex, PageSize = 50 }; ViewBag.DataList = productBll.GetProductInventoryList(Model, LanguageEnum.TraditionalChinese, pageSetting); ViewBag.SupplierNames = supplierBLL.GetSupplierNames(); } catch (Exception ext) { LogHelper.Error(ext); } return(View(Model)); }
public void CreateInventoryList(IEnumerable <InventoryViewModel> inventories) { var rlvm = new InventoryListViewModel { Inventories = inventories }; var html = CreateInventoryListHtml(rlvm); ObjectConfig oc = new ObjectConfig(); oc.SetPrintBackground(true); oc.SetAllowLocalContent(true); oc.SetScreenMediaType(true); oc.SetLoadImages(true); oc.Footer.SetFontSize(8); oc.Footer.SetRightText("Erstellt: " + DateTime.Now); var pdfBuf = new SynchronizedPechkin(new GlobalConfig()).Convert(oc, html); var _SD = new SaveFileDialog { Filter = "PDF File (*.pdf)|*.pdf", FileName = TranslationProvider.Translate("InventoryList"), Title = TranslationProvider.Translate("SaveAs") }; if (_SD.ShowDialog() == DialogResult.OK) { try { File.WriteAllBytes(_SD.FileName, pdfBuf); Process.Start(_SD.FileName); } catch (IOException e) { MessageBox.Show(TranslationProvider.Translate("CantWriteFile")); } } }
public ActionResult InventoryList(InventoryListViewModel model) { if (ModelState.IsValid) { var db = new DbEntities <InventoryList>().SimpleClient; //信息记录不重复 if (db.IsAny(il => il.InboundTaskDetailID == model.InboundTaskDetailID && il.OutboundTaskDetailID == model.OutboundTaskDetailID && il.TrayID == model.TrayID && il.InventoryLocationID == model.InventoryLocationID && il.InventoryType == model.InventoryType)) { TempData["Msg"] = "该条记录已存在"; } else { //登录人信息 if (new IdentityAuth().GetCurUserID(HttpContext, out int curUserID)) { InventoryList entity = model.InitAddInventoryList(curUserID); if (db.Insert(entity)) { TempData["Msg"] = $"添加成功"; return(RedirectToAction("InventoryList", "Warehouse")); } TempData["Msg"] = "添加失败"; } else { TempData["Msg"] = "登录身份过期,请重新登录"; } } } //下拉框设置 SetSelectListItems.InboundTaskDetail(this); SetSelectListItems.OutboundTaskDetail(this); SetSelectListItems.Tray(this); SetSelectListItems.InventoryLocation(this); return(View()); }
public InventoryListPage() { InitializeComponent(); BindingContext = _viewModel = new InventoryListViewModel(); }