/// <summary> /// 分页获取数据 /// </summary> /// <returns></returns> public string List(string AreaName) { string where = ""; if (!string.IsNullOrEmpty(AreaName) && CommonHelper.filterSql(AreaName)) { where += "AreaName like '%" + AreaName + "%'"; } int total = BLL.GetRecordCount(where); int pageSize = Convert.ToInt32(Request["rows"]); int pageNum = Convert.ToInt32(Request["page"]); int startIndex = (pageNum - 1) * pageSize + 1; int endIndex = pageNum * pageSize; if (total >= startIndex) { DataSet ds = BLL.GetListByPage(where, " OrderBy asc", startIndex, endIndex); String strJson = JsonHelper.GetJsonFromDataSet(ds, total); return(strJson); } else { String strJson = JsonHelper.GetJsonFromDataTable(null, total); return(strJson); } }