public JsonResult GetCategoryList(CategoryLevelEnum level, int parentID) { object data = null; try { List <CategoryModel> list = CategoryBLL.GetChildrenCategories(LanguageEnum.TraditionalChinese, level, parentID); data = list.Select(p => new { Id = p.CategoryId, Name = p.CategoryName }); } catch (Exception ex) { LogHelper.Error(ex); } return(Json(data)); }
public IList <CategoryModel> GetChildrenCategories(LanguageEnum languageVersion, CategoryLevelEnum categoryLevel, int parentID) { var sql = @"SELECT c.CategoryId, c.RootId, c.ParentId, c.SortValue, c.Status, c.CategoryLevel, cl.CategoryName, cl.AppImgUrl, cl.SiteImgUrl FROM Category c(NOLOCK) INNER JOIN Category_LanguageVersion cl(NOLOCK) ON cl.CategoryKey = c.CategoryKey WHERE cl.LanguageVersion=@LanguageVersion AND c.Status = 1 and CategoryLevel=@CategoryLevel AND c.ParentId=@ParentId" ; var db = DbSFO2OMain; var parameters = db.CreateParameterCollection(); parameters.Append("LanguageVersion", (int)languageVersion); parameters.Append("CategoryLevel", (int)categoryLevel); parameters.Append("parentID", parentID); return(db.ExecuteSqlList <CategoryModel>(sql, parameters)); }
public static List <CategoryModel> GetChildrenCategories(LanguageEnum languageVersion, CategoryLevelEnum categoryLevel, int parentID) { return(categoryDAL.GetChildrenCategories(languageVersion, categoryLevel, parentID).ToList()); }