public async Task <FileStreamResult> OrderMainStoneStatisticsExport(ShipmentReportQuery reportQuery)
{
var manager = new OrderMainStoneInfoManager(User);
var mainStones = await manager.GetOrderMainStoneStatisticsAsync(reportQuery);
var titles = new string[] { "序号", "客户", "单号", "主石名称", "主石大小", "风险等级", "收石日期" };
var result = Dickson.Web.Helper.ExcelHelp.Export(titles, "主石收石记录", ws =>
{
var row = 2;
int index = 1;
foreach (var mainStone in mainStones)
{
ws.Cells[row, 1].Value = index;
ws.Cells[row, 2].Value = mainStone.CustomerName;
ws.Cells[row, 3].Value = mainStone.OrderId;
ws.Cells[row, 4].Value = mainStone.MainStoneName;
ws.Cells[row, 5].Value = mainStone.MainStoneWeight;
ws.Cells[row, 6].Value = mainStone.Risk;
ws.Cells[row, 7].Value = mainStone.Created;
row++;
index++;
}
});
return(result);
}
public async Task <ActionResult> OrderMainStoneStatistics(ReportQueryBaseDto reportQuery)
{
if (!Request.IsAjaxRequest())
{
return(View(reportQuery));
}
var manager = new OrderMainStoneInfoManager(User);
var list = await manager.GetOrderMainStoneStatisticsAsync(reportQuery);
return(Json(true, string.Empty, list));
}
