/// <summary>
/// 根据ID获取课程分类实体
/// </summary>
/// <param name="categoryid">课程分类ID</param>
/// <returns></returns>
public static Entity.CourseCategoryEntity GetCourseCategoryByID(string categoryid)
{
Entity.CourseCategoryEntity model = new CourseCategoryEntity();
DataTable dt = new DAL.CourseDAL().GetCourseCategoryByID(categoryid);
if (dt.Rows.Count > 0)
{
model.FillData(dt.Rows[0]);
}
return model;
}
/// <summary>
/// 根据PID获取课程分类列表
/// </summary>
/// <param name="pid">上级分类ID</param>
/// <returns></returns>
public static List<Entity.CourseCategoryEntity> GetCourseCategorysByPID(string pid)
{
List<Entity.CourseCategoryEntity> list = new List<Entity.CourseCategoryEntity>();
DataTable dt = new DAL.CourseDAL().GetCourseCategorysByPID(pid);
foreach (DataRow dr in dt.Rows)
{
CourseCategoryEntity category = new CourseCategoryEntity();
category.FillData(dr);
list.Add(category);
}
return list;
}
/// <summary>
/// 获取课程分类列表(分页)
/// </summary>
/// <param name="pid">上级分类ID</param>
/// <param name="keywords">关键词</param>
/// <param name="pageSize">页size</param>
/// <param name="index">页码</param>
/// <param name="total">返回总记录数</param>
/// <param name="pages">返回总页数</param>
/// <returns></returns>
public static List<Entity.CourseCategoryEntity> GetCourseCategorys(string pid, string keywords, int pageSize, int index, out int total, out int pages)
{
List<Entity.CourseCategoryEntity> list = new List<Entity.CourseCategoryEntity>();
string table = "CourseCategory c left join CourseCategory p on c.PID=p.CategoryID";
string columns = " c.*,p.CategoryName PName";
StringBuilder build = new StringBuilder();
build.Append(" c.Status <> 9 ");
if (pid != "-1")
{
build.Append(" and c.PID='" + pid + "'");
}
if (keywords != "")
{
build.Append(" and (c.CategoryName like '%" + keywords + "%' or p.CategoryName like '%" + keywords + "%')");
}
DataTable dt = CommonBusiness.GetPagerData(table, columns, build.ToString(), "c.ID", pageSize, index, out total, out pages);
foreach (DataRow dr in dt.Rows)
{
CourseCategoryEntity category = new CourseCategoryEntity();
category.FillData(dr);
list.Add(category);
}
return list;
}
