//本周热门,如本周无数据,则取总数据
public DataTable SelTop(int num)
{
string stime = "", etime = "";
DateHelper.GetWeekSE(DateTime.Now, ref stime, ref etime);
Sql_Where whereMod = new Sql_Where()
{
join = "AND", field = "CDate", type = "date", stime = stime, etime = etime
};
string where = "Pid = 0 And Status != " + ((int)ConStatus.Recycle);
PageSetting setting = new PageSetting()
{
psize = num,
cpage = 1,
pk = PK,
t1 = TbName,
fields = "*",
where = where + DBCenter.DB.GetDateSql(whereMod),
order = "HitCount DESC"
};
DataTable dt = DBCenter.SelPage(setting);
if (dt.Rows.Count < 1)
{
setting.where = where; dt = DBCenter.SelPage(setting);
}
dt.Columns.Add(new DataColumn("IndexNum", typeof(int)));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["IndexNum"] = (i + 1);
}
return(dt);
}
/// <summary>
/// 生成 between语句
/// </summary>
public static string GetDateSql(string field, string stime, string etime)
{
Sql_Where whereMod = new Sql_Where()
{
join = "", field = field, type = "date", stime = stime, etime = etime
};
return(DB.GetDateSql(whereMod));
}
