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