/// <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"));
Hoto.BLL.search bll = new Hoto.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"] = HotoUtils.DropHTML(dr1["content"].ToString(), 255); //简介
dr["link_url"] = link_url; //链接地址
dr["add_time"] = dr1["add_time"]; //发布时间
dt.Rows.Add(dr);
}
}
}
return(dt);
}
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"));
Hoto.BLL.search bll = new Hoto.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"] = HotoUtils.DropHTML(dr1["content"].ToString(), 255); //简介
dr["link_url"] = link_url; //链接地址
dr["add_time"] = dr1["add_time"]; //发布时间
dt.Rows.Add(dr);
}
}
}
return dt;
}
