/// <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);
}
