/// <summary> /// 首页回顾(展示有报道的活动) /// </summary> /// <returns></returns> public List <ViewClassGroup> GetClassesHaveReport() { List <ViewClassGroup> list = new List <ViewClassGroup>(); string sql = "select c.* from Class c join(" + " SELECT top 8 ClassId,max(CreateTime)as CreateTime FROM ClassReport where IsDeleted=0 group by ClassId" + " order by CreateTime desc) r on c.Id=r.ClassId"; SqlDataReader reader = SQLHelper.ExecuteDataReader(sql, CommandType.Text, null); while (reader.Read()) { ViewClassGroup user = new ViewClassGroup() { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Banner = reader["Banner"].ToString(), Start = reader["Start"].ToString(), TopicIds = reader["TopicIds"].ToString(), AreaID = Convert.ToInt32(reader["AreaID"]), //Nums = Convert.ToInt32(reader["Nums"]), //InterNums = Convert.ToInt32(reader["InterNums"]), //OrderNums = Convert.ToInt32(reader["OrderNums"]), //DicId = Convert.ToInt32(reader["DicId"]), //AreaName = reader["AreaName"].ToString() }; list.Add(user); } return(list); }
/// <summary> /// 回顾首页 /// </summary> /// <param name="Orderby">四个排序</param> /// <param name="where"></param> /// <returns></returns> public List <ViewClassGroup> GetClassHuiGuList(string Orderby, string where, int ClassStatus) { List <ViewClassGroup> list = new List <ViewClassGroup>(); string OrderByValue = "EndTime"; if (!string.IsNullOrEmpty(Orderby)) { OrderByValue = Orderby; } string orderby = " order by " + OrderByValue + " desc "; string sql = GetSql(ClassStatus) + where + orderby; SqlDataReader reader = SQLHelper.ExecuteDataReader(sql, CommandType.Text, null); while (reader.Read()) { ViewClassGroup user = new ViewClassGroup() { Id = Convert.ToInt32(reader["Id"]), Name = reader["Name"].ToString(), Banner = reader["Banner"].ToString(), Start = reader["Start"].ToString(), TopicIds = reader["TopicIds"].ToString(), AreaID = Convert.ToInt32(reader["AreaID"]), Nums = Convert.ToInt32(reader["Nums"]), InterNums = Convert.ToInt32(reader["InterNums"]), OrderNums = Convert.ToInt32(reader["OrderNums"]), DicId = Convert.ToInt32(reader["DicId"]), AreaName = reader["AreaName"].ToString() }; list.Add(user); } return(list); }