public ActionResult FinanceReportExport(QueryBase model)
{
ResultInfo info = new ResultInfo();
string fileName = "财务报表";
if (model.StartTime != DateTime.MinValue)
{
fileName += "_" + model.StartTime.ToString("yyyy-MM-dd");
}
if (model.EndTime != DateTime.MinValue)
{
fileName += "_" + model.EndTime.ToString("yyyy-MM-dd");
}
var list = FinanceReportBLL.GetExportList(model);
Company.Util.ExportHelper.Export <ExportFinanceModel>(list, this.Response, fileName);
return(View());
}
/// <summary>
/// 导入
/// </summary>
/// <returns></returns>
public JsonResult ImportFinanceReport()
{
ResultInfo info = new ResultInfo();
HttpPostedFileBase file = Request.Files["upfile"];
AdminInfo admin = CookieOperate.UserAdminCookie;
if (file.FileName.Contains(".xls") || file.FileName.Contains(".xlsx"))
{
try
{
DataTable dt = ExportHelper.ExcelToDataTable(file.InputStream, file.FileName, "", true);
if (FinanceReportBLL.ImportExcel(dt, admin))
{
info.Message = "导入成功";
info.IsSuccess = true;
}
}
catch (Exception ex)
{
info.Message = ex.Message;
}
}
return(Json(info, "text/html"));
}
