public async Task <FileStreamResult> Export(ReconciliationQueryRequest request) { var manager = new ReconciliationManager(User); var reconciliations = await manager.GetReconciliationsAsync(request.GetReconciliationListQueryFilter()); var titles = new string[] { "序号", "客户", "日期", "付/欠款", "金额(元)", "备注" }; var result = Dickson.Web.Helper.ExcelHelp.Export(titles, "对账记录", ws => { var row = 2; int index = 1; foreach (var reconciliation in reconciliations) { ws.Cells[row, 1].Value = index; ws.Cells[row, 2].Value = reconciliation.CustomerName; ws.Cells[row, 3].Value = reconciliation.Created.ToString(SaleManagentConstants.UI.DateStringFormat); ws.Cells[row, 4].Value = reconciliation.Type.GetDisplayName(); ws.Cells[row, 5].Value = reconciliation.Amount; ws.Cells[row, 6].Value = reconciliation.Remark; row++; index++; } ; }); return(result); }
public async Task <ActionResult> List(ReconciliationQueryRequest request) { if (!Request.IsAjaxRequest()) { return(View(request)); } var manager = new ReconciliationManager(User); var paging = await manager.GetReconciliationsAsync(request.Start, request.Take, request.GetReconciliationListQueryFilter()); var reconciliations = paging.List.Select(u => { return(new ReconciliationItemViewModel(u)); }); return(Json(true, string.Empty, new { paging.Total, List = reconciliations, })); }