/// <summary>
/// 导出到响应流
/// </summary>
/// <param name="sql"></param>
/// <param name="orderStr"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="cmdParams"></param>
/// <returns></returns>
public static bool ExportToExcel(System.Web.HttpResponse response, string fileName, string sheetName, string sql, string orderStr, int pageIndex, int pageSize, List <string[]> renameList, params SqlParameter[] cmdParams)
{
DataTable dt;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectingString))
{
dt = SqlHelper.GetPagedDataTable(conn, sql, orderStr, pageIndex, pageSize, cmdParams);
}
return(NPOIHelper.CreateXls(response, fileName, sheetName, dt, renameList));
}
/// <summary>
/// 获取EasyUI所需的Json
/// </summary>
/// <returns></returns>
public static string GetEasyUIJson(string sql, string orderStr, int pageIndex, int pageSize, params SqlParameter[] cmdParams)
{
string jsonResult;
int rowsTotal;
DataTable dt;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectingString))
{
rowsTotal = SqlHelper.GetRowsCount(conn, sql, cmdParams);
dt = SqlHelper.GetPagedDataTable(conn, sql, orderStr, pageIndex, pageSize, cmdParams);
}
jsonResult = JSONHelper.DataTableToJson(dt);
jsonResult = "{\"total\":" + "\"" + rowsTotal.ToString() + "\",\"rows\":" + jsonResult + "}";
return(jsonResult);
}