//本周热门,如本周无数据,则取总数据 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)); }