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);
}