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