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