protected int totalcount; //OUT数据总数 #endregion Fields #region Methods /// <summary> /// 查询数据 /// </summary> protected DataTable get_search_list(int _pagesize, out int _totalcount) { //组合查询条件 string strWhere = "(title like '%" + keyword + "%' or content like '%" + keyword + "%')"; //创建一个DataTable DataTable dt = new DataTable(); dt.Columns.Add("title", Type.GetType("System.String")); dt.Columns.Add("remark", Type.GetType("System.String")); dt.Columns.Add("link_url", Type.GetType("System.String")); dt.Columns.Add("add_time", Type.GetType("System.String")); BLL.search bll = new BLL.search(); DataSet ds = bll.GetList(_pagesize, page, strWhere, "add_time desc", out _totalcount); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr1 = ds.Tables[0].Rows[i]; string link_url = get_url_rewrite(dr1["channel_id"].ToString(), Convert.ToInt32(dr1["id"])); if (!string.IsNullOrEmpty(link_url)) { DataRow dr = dt.NewRow(); dr["title"] = dr1["title"]; //标题 dr["remark"] = Utils.DropHTML(dr1["content"].ToString(), 255); //简介 dr["link_url"] = link_url; //链接地址 dr["add_time"] = dr1["add_time"]; //发布时间 dt.Rows.Add(dr); } } } return dt; }
/// <summary> /// 查询数据 /// </summary> protected DataTable get_search_list(int _pagesize, out int _totalcount) { //组合查询条件 string strWhere = "(title like '%" + keyword + "%' or content like '%" + keyword + "%')"; //创建一个DataTable DataTable dt = new DataTable(); dt.Columns.Add("title", Type.GetType("System.String")); dt.Columns.Add("remark", Type.GetType("System.String")); dt.Columns.Add("link_url", Type.GetType("System.String")); dt.Columns.Add("add_time", Type.GetType("System.String")); BLL.search bll = new BLL.search(); DataSet ds = bll.GetList(_pagesize, page, strWhere, "add_time desc", out _totalcount); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr1 = ds.Tables[0].Rows[i]; string link_url = get_url_rewrite(dr1["channel_id"].ToString(), Convert.ToInt32(dr1["id"])); if (!string.IsNullOrEmpty(link_url)) { DataRow dr = dt.NewRow(); dr["title"] = dr1["title"]; //标题 dr["remark"] = Utils.DropHTML(dr1["content"].ToString(), 255); //简介 dr["link_url"] = link_url; //链接地址 dr["add_time"] = dr1["add_time"]; //发布时间 dt.Rows.Add(dr); } } } return(dt); }