public DataTable GetPageData(string keywords, string tid, int pageIndex, int pageSize, out int recordsCount) { string where = "1=1"; if (!string.IsNullOrEmpty(tid)) { where += " AND TypeId=" + int.Parse(tid); } if (!string.IsNullOrEmpty(keywords)) { where += " AND Subject LIKE '%" + keywords.Replace("'", "''") + "%'"; } PagerProc pp = new PagerProc() { fields = "Id,Subject,Contents,AppTime,(SELECT Name FROM [UserInfo] WHERE UserId=FromId) AS FromName", order = "Id DESC", pageIndex = pageIndex, pageSize = pageSize, tables = "Posts", uniqueField = "Id", uniqueFieldType = "int", where = where, group = string.Empty }; var dt = pp.ToDataSet().Tables[0]; recordsCount = pp.recordsCount; return(dt); }
public DataTable GetPageData(int uid, int pageIndex, int pageSize, out int recordsCount) { string where = "1=1"; where += " AND Id in (Select PostsId from Collection where UserID=" + uid + ")"; PagerProc pp = new PagerProc() { fields = "Id,Subject,Contents,AppTime,(SELECT Name FROM [UserInfo] WHERE UserId=FromId) AS FromName", order = "Id DESC", pageIndex = pageIndex, pageSize = pageSize, tables = "Posts", uniqueField = "Id", uniqueFieldType = "int", where = where, group = string.Empty }; var dt = pp.ToDataSet().Tables[0]; recordsCount = pp.recordsCount; return(dt); }