/// <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);
}
