public ActionResult Export(string id)
{
try
{
string sWhere = "";
//条件
WhereFilter QF = null;
if (!string.IsNullOrEmpty(Request.Params["where"]))
{
QF = new JavaScriptSerializer().Deserialize <WhereFilter>(Request.Params["where"]);
//sWhere = QF.GetWhere();
}
//DataTable dt = SQLDBHelper.MUser.QueryDT(sWhere, 1, int.MaxValue);
M_Data_Paging <M_User> lstMUserPage = SQLDBHelperClient.CreateUser().Query(QF, 1, int.MaxValue);
Stream stream = NPOIExcel.RenderDataTableToExcelHSS(lstMUserPage.lstTObj);
ViewBag.Succ = "1";
ViewBag.Msg = "数据下载成功!";
return(File(stream, "application/vnd.ms-excel", DateTime.Now.Ticks + ".xls"));
}
catch (Exception ex)
{
return(View("Query"));
}
}
