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();
}
