public ActionResult Calculate(string area, string company, string message)
{
area = HttpUtility.UrlDecode(area);
company = HttpUtility.UrlDecode(company);
message = HttpUtility.UrlDecode(message);
DAL.z_parameter dal_z_parameter = new DAL.z_parameter();
List<Models.z_parameter> area_list = dal_z_parameter.GetModelList("地区");
List<Models.z_parameter> company_list = dal_z_parameter.GetModelList("分公司");
ViewBag.area_list = area_list;
ViewBag.company_list = company_list;
if (area == null || area == "")
{
area = area_list[0].ID.ToString();
}
if (company == null || company == "")
{
company = company_list[0].ID.ToString();
}
ViewBag.area = area;
ViewBag.company = company;
Models.z_user session_model_z_user = (Models.z_user)ViewBag.model_z_user;
DAL.m_worker dal_m_worker = new DAL.m_worker();
DataTable dtReturnFee = dal_m_worker.GetReturnFee(area, new Guid(company));
ViewBag.ReportChart = dtReturnFee;
ViewBag.message = message;
return View();
}
public ActionResult ExportCalculate(string area, string company)
{
area = HttpUtility.UrlDecode(area);
company = HttpUtility.UrlDecode(company);
try
{
Models.z_user session_model_z_user = (Models.z_user)ViewBag.model_z_user;
DAL.m_worker dal_m_worker = new DAL.m_worker();
DataTable dtReturnFee = dal_m_worker.GetReturnFee(area, new Guid(company));
MemoryStream ms = DAL.NpoiExcel.RenderWorkerTableToExcelFee(dtReturnFee) as MemoryStream;
Response.Clear();
Response.Buffer = true;
Response.AddHeader("Content-Disposition", string.Format("attachment; filename=返费导出" + DateTime.Now.ToString("yyyy_MM_dd HH_mm") + ".xls"));
Response.BinaryWrite(ms.ToArray());
Response.End();
ms.Close();
ms.Dispose();
return RedirectToAction("Calculate", new { message = HttpUtility.UrlEncode("导出成功"), area = HttpUtility.UrlEncode(area) });
}
catch
{
return RedirectToAction("Calculate", new { message = HttpUtility.UrlEncode("导出失败"), area = HttpUtility.UrlEncode(area) });
}
}