public FileResult ExportInventoryListToExcel(InventoryListModel model) { var queryInfo = new InventoryListQueryInfo(); queryInfo.SupplierID = base.CurrentUser.SupplierID; queryInfo.ProductName = model.ProductName.SafeTrim(); queryInfo.Spu = model.Spu.SafeTrim(); queryInfo.Sku = model.Sku.SafeTrim(); queryInfo.BarCode = model.BarCode.SafeTrim(); queryInfo.SkuStatus = model.SkuStatus; queryInfo.IsLowStockAlarm = model.IsLowStockAlarm; var fileName = "Inventory" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx"; try { var dateTable = bll.GetSkuInventoryListData(queryInfo, LanguageEnum.TraditionalChinese); var dtExporter = new DataTableExporter(EnumExcelType.XLSX); dtExporter.AddTable <InventoryListExportModel>(dateTable, "SKU庫存"); return(XlsxFile(dtExporter.Export(), fileName)); } catch (Exception ex) { LogHelper.Error(ex); } return(XlsxFile(new byte[0], fileName)); }
public IActionResult AddInventory([FromBody] InventoryListModel model) { var inv = _db.Set <Inventory>().FirstOrDefault(x => x.SeriNo == model.seriNo); if (inv != null) { if (inv.SeriNo == model.seriNo) { return(BadRequest("Bu Seri Numaraya Ait Ürün Bulunmaktadır. Lütfen Seri Numarayı Kontrol Edip Tekrar Deneyiniz.")); } } var inventory = new Inventory { Id = new Guid(), Marka = model.marka, Feature = model.feature, Name = model.name, Model = model.model, SeriNo = model.seriNo, Status = false, }; _db.Entry(inventory).State = Microsoft.EntityFrameworkCore.EntityState.Added; _db.SaveChanges(); return(Ok("Envanter Sisteme Eklendi")); }
public ActionResult InventoryList(InventoryListModel model) { var queryInfo = new InventoryListQueryInfo(); queryInfo.SupplierID = base.CurrentUser.SupplierID; queryInfo.ProductName = model.ProductName.SafeTrim(); queryInfo.Spu = model.Spu.SafeTrim(); queryInfo.Sku = model.Sku.SafeTrim(); queryInfo.BarCode = model.BarCode.SafeTrim(); queryInfo.SkuStatus = model.SkuStatus; queryInfo.IsLowStockAlarm = model.IsLowStockAlarm; var page = new PageDTO() { PageIndex = model.PageIndex, PageSize = 50 }; try { PageOf <SkuTempModel> dateList = bll.GetSkuInventoryList(queryInfo, LanguageEnum.TraditionalChinese, page); ViewBag.DataList = dateList; } catch (Exception ex) { LogHelper.Error(ex); } return(View(model)); }
private async Task <InventoryListModel> GetInventoryListModel(int pageIndex, string sortExpression, string filterKeywords) { int pageCount = 10; int total; var field = (InventoryListDTO.Filds)Enum.Parse(typeof(InventoryListDTO.Filds), sortExpression); var list = _inventoryAppService.GetInventoryList(pageIndex, pageCount, out total, field, true, filterKeywords); var model = new InventoryListModel(); model.NumberOfResults = total; model.InventoryList = list; model.ItemsPerPage = pageCount; model.CurrentPage = pageIndex; return(model); }