private PagedDataTableResult SelectPage(string qrySql, string statSql, int pageSize, int pageIndex, params object[] parameters) { var index = pageIndex; var ds = SelectPaged(qrySql, statSql, pageSize, index, parameters); if (ds == null || ds.Tables.Count == 0) { return(null); } //Tables[0] 无数据时判断 var rowCount = 0; if (ds.Tables[0].Rows.Count > 0) { rowCount = ds.Tables[0].Rows[0][0].ConvertTo(0); } var pageCount = Math.Ceiling(1M * rowCount / pageSize).ConvertTo(0); var pagedResult = new PagedDataTableResult(pageSize, pageIndex) { PageIndex = index, PageCount = pageCount, RowCount = rowCount, Rows = ds.Tables[1] }; if (statSql.HasValue()) { pagedResult.Stat = ds.Tables[2].Rows[0]; } return(pagedResult); }
public void SelectPage <T>(string sql, Global.Db.PagedResult <T> pagedResult) { var pagedDataTableResult = new PagedDataTableResult(pagedResult.PageSize, pagedResult.PageIndex); SelectPage(sql, pagedDataTableResult); if (pagedDataTableResult.Rows == null) { return; } pagedDataTableResult.ListResult(pagedResult); }
public void SelectPage(string sql, PagedDataTableResult pagedResult) { var pageIndex = pagedResult.PageIndex; int pageCount; int rowCount; var dt = SelectPage(sql, pagedResult.PageSize, ref pageIndex, out pageCount, out rowCount); if (dt == null) { return; } pagedResult.PageIndex = pageIndex; pagedResult.PageCount = pageCount; pagedResult.RowCount = rowCount; pagedResult.Rows = dt; }