public List<HtTagInfo> HtPageQuery(HtTagSelect select) { string h_tableName = "HoverTreeSCJ_Tag"; 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); }
void MyQuery(HtTagSelect select) { List<HtTagInfo> h_list = HtTag.HtPageQuery(select); if (listView_tags.Items.Count > 0) listView_tags.Items.Clear(); ListViewItem h_item; foreach (HtTagInfo info in h_list) { string[] h_subItems = { info.HtTagName, info.HtId.ToString(), info.HtAddTime.ToString() }; h_item = new ListViewItem(h_subItems); listView_tags.Items.Add(h_item); } //dataGridView_htList.DataSource = h_list; }
private void button_freshen_Click(object sender, System.EventArgs e) { HtTagSelect h_select = new HtTagSelect(); MyQuery(h_select); }
private void Form_TagList_Load(object sender, System.EventArgs e) { HtTagSelect h_select = new HtTagSelect(); MyQuery(h_select); }
public static List<HtTagInfo> HtPageQuery(HtTagSelect select) { return dal.HtPageQuery(select); }