/// <summary> /// 分页查询,返回json数据 /// </summary> /// <param name="strColumn">查询的字段列</param> /// <param name="pageSize">每页记录数</param> /// <param name="currentPage">当前页数</param> /// <param name="strWhere">查询条件</param> /// <param name="orderBy">排序条件</param> /// <returns></returns public string GetAllByPage(string strColumn, int pageSize, int currentPage, string strWhere, string orderBy) { int pageCount = 0; int recordCount = 0; if (strWhere == "") { strWhere = " 1=1 "; } if (strColumn == "") { strColumn = " * "; } if (orderBy == "") { orderBy = " ld desc "; } TSqlClient tSqlClient = new TSqlClient(); tSqlClient.SetSqlConn(sqlConn); List <TModule> contList = tSqlClient.GetAllByPage(strColumn, pageSize, currentPage, strWhere, orderBy, out pageCount, out recordCount); StringBuilder rStr = new StringBuilder(); rStr.Append("{\"total\":" + recordCount.ToString() + ","); if (contList != null) { rStr.Append("\"rows\":" + CFun.JsonToString <TModule>(contList)); } else { rStr.Append("\"rows\":[]"); } rStr.Append("}"); return(rStr.ToString()); }