private void HtUcPages1_PageChanged(HtSelectBase select) { UrlSelect h_urlSelect = new UrlSelect(); h_urlSelect.HtPageSize = select.HtPageSize; h_urlSelect.HtPageIndex = select.HtPageIndex; h_urlSelect.HtTotalPageCount = select.HtTotalPageCount; h_urlSelect.HtTotalRecordCount = select.HtTotalRecordCount; h_urlSelect.SortType = select.SortType; MyQuery(h_urlSelect); }
void InitQuery() { UrlSelect h_select = new UrlSelect(); h_select.SortType = HtSortType.Desc; h_select.HtPageSize =5;//作为示例,暂定每页5个记录。在后续的版本中将会改进。 h_select.HtPageIndex = 1; MyQuery(h_select); htUcPages1.SetSelectBase(h_select); }
public static List<UrlInfo> HtPageQuery(UrlSelect select) { return dal.HtPageQuery(select); }
void MyQuery(UrlSelect select) { List<UrlInfo> h_list = HtUrl.HtPageQuery(select); dataGridView_htList.DataSource = h_list; }
public List<UrlInfo> HtPageQuery(UrlSelect select) { string h_tableName = "HoverTreeSCJ_Urls"; int h_totalCount, h_totalPageCount; DataTable h_dt = KeleyiSQLHelper.HoverTreeSql.HtPageQuery(h_tableName, "*", "htid", " htid>0 ", " htId desc ", (int)select.SortType, select.HtPageSize, select.HtPageIndex, 0, out h_totalCount, out h_totalPageCount); select.HtTotalRecordCount = h_totalCount; select.HtTotalPageCount = h_totalPageCount; return ConvertToList(h_dt); }