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