public ActionResult GetDataManage(DataManageSearch dataManage) { var result = _unitOfWork.GetRepository <DataManage>().GetEntities(); if (!string.IsNullOrEmpty(dataManage.ProductNum)) { result = result.Where(i => i.ProductNum.Contains(dataManage.ProductNum)); } if (dataManage.OrderId.HasValue) { result = result.Where(i => i.OrderId == dataManage.OrderId); } var w1 = result.OrderByDescending(x => x.Id).Skip((dataManage.page - 1) * dataManage.limit).Take(dataManage.limit); return(Json(new { code = 0, msg = "ok", count = result.Count(), data = w1.ToList() })); }
public IActionResult DataManageExport(DataManageSearch dataManage) { var properties = new PropertyByName <DataManage>[] { new PropertyByName <DataManage>("Id", d => d.Id), new PropertyByName <DataManage>("ProductNum", d => d.ProductNum), new PropertyByName <DataManage>("DataType", d => d.DataType), new PropertyByName <DataManage>("DataAddress", d => d.DataAddress), new PropertyByName <DataManage>("Count", d => d.Count), new PropertyByName <DataManage>("Remark", d => d.Remark), new PropertyByName <DataManage>("OrderId", d => d.OrderId) }; var result = _unitOfWork.GetRepository <DataManage>().GetEntities(); if (!string.IsNullOrEmpty(dataManage.ProductNum)) { result = result.Where(i => i.ProductNum.Contains(dataManage.ProductNum)); } var bytes = _exportImportService.ExportToXlsx(properties, result); return(File(bytes, MimeTypes.TextXlsx, "DataManage.xlsx")); }