/// <summary>
/// 获取DataSet类型的资讯查询结果列表
/// </summary>
/// <param name="SelectCol"></param>
/// <param name="Criteria"></param>
/// <param name="CurrentPage"></param>
/// <param name="PageSize"></param>
/// <param name="PageCount"></param>
/// <returns></returns>
public DataTable dsGetSearchResultNews(
string SelectCol,
string Criteria,
string SortBy,
ref long CurrentPage,
long PageSize,
ref long PageCount
)
{
Common.CommonFunction mCF = new Tz888.SQLServerDAL.Common.CommonFunction();
return(mCF.GetDataTable(
"NewsTabList",
SelectCol,
Criteria,
SortBy,
ref CurrentPage,
PageSize,
ref PageCount));
}
/// <summary>
/// 查询推荐的次数
/// </summary>
/// <param name="SelectCol">选择列</param>
/// <param name="Criteria">查询推荐的信息ID号</param>
/// <param name="OrderBy">排序</param>
/// <param name="CurrentPage">显示的当前页号</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageCount">通过该查询条件，返回的查询记录的页数</param>
/// <returns>查询列表</returns>
public int GetListCount(
string SelectCol,
string Criteria,
string OrderBy,
ref long CurrentPage,
long PageSize,
ref long PageCount)
{
int count = 0;
Common.CommonFunction comm = new Tz888.SQLServerDAL.Common.CommonFunction();
DataTable dt = comm.GetDataTable("CommendTabList", SelectCol, Criteria, OrderBy, ref CurrentPage, PageSize, ref PageCount);
if (dt != null && dt.Rows != null)
{
count = dt.Rows.Count;
}
return(count);
}