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