public ActionResult ExportBill()
{
QueryParam queryParam = new QueryParam();
var extendParams = Request.Params["extendParams"];
if (extendParams != null)
{
JavaScriptSerializer js = new JavaScriptSerializer();
List <FilterModel> filters = js.Deserialize <List <FilterModel> >(extendParams);
Dictionary <string, FilterModel> filterSet = filters.ToDictionary(key => key.key, model => model);
queryParam.filters = filterSet;
}
OperateResult or = SalaryRecordManager.ExportBill(queryParam);
if (or.status == OperateStatus.Success &&
or.data != null)
{
string exportFileName = string.Concat("工资条", DateTime.Now.ToString("yyyyMMddHHmmss"), ".xlsx");
var excelHelper = new ExportExcelHelper()
{
SheetName = "工资条",
FileName = exportFileName,
ExportData = (DataTable)or.data
};
excelHelper.GenerateExcelEx(this.HttpContext);
return(new EmptyResult());
}
return(Json(or, JsonRequestBehavior.AllowGet));
}