// SELECT course.id,course.grade,course.name,course.url,course.content FROM genreRecommend INNER JOIN course
//on genreRecommend.id = course.id and genreRecommend.type=0
//order by genreRecommend.time desc
/// <summary>
/// 获取某一种类型
/// </summary>
/// <param name="type">类型</param>
/// <returns></returns>
public Views.content_T <Views.course_T> GetModel_T(string type)
{
try
{
char t = Convert.ToChar(type);
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT TOP 4 course.id,course.grade,course.name,course.url,course.content ");
strSql.Append(" FROM genreRecommend INNER JOIN course ");
strSql.Append(" on genreRecommend.id = course.id and genreRecommend.type=@type ");
strSql.Append(" order by genreRecommend.time desc ");
SqlParameter[] parameters =
{
new SqlParameter("@type", SqlDbType.Char, 1)
};
parameters[0].Value = t;
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
List <Views.course_T> list = new List <Views.course_T>();
course c = new course();
foreach (DataRow item in ds.Tables[0].Rows)
{
list.Add(c.DataRowToModel_T(item));
}
Views.content_T <Views.course_T> gr = new Views.content_T <Views.course_T>();
gr.name = ConfigurationManager.AppSettings["type" + type].ToString();
gr.content = list;
return(gr);
}
catch (Exception) {
return(null);
}
}
public Views.content_T <Model.search> GetListTop()
{
Views.content_T <Model.search> content = new Views.content_T <Model.search>();
string name = ConfigurationManager.AppSettings["searchTop"];
content.name = name;
content.content = DataTableToList(new DAL.search().GetListTop());
return(content);
}
public Views.content_T <Views.courseTop> GetListTop()
{
Views.content_T <Views.courseTop> content = new Views.content_T <Views.courseTop>();
List <Views.courseTop> list = new List <Views.courseTop>();
DAL.course c = new DAL.course();
foreach (DataRow item in c.GetListTop().Rows)
{
list.Add(c.DataRowToModelTop(item));
}
string name = ConfigurationManager.AppSettings["courseTop"];
content.name = name;
content.content = list;
return(content);
}
