private EasyuiTreeNode GetChilds(ResCourseCategory category, IEnumerable <ResCourseCategory> all, int selectedId)
{
IEnumerable <ResCourseCategory> list = all.Where(p => p.ParentId == category.CategoryId);
var cate = new EasyuiTreeNode {
id = category.CategoryId.ToString(), text = category.CategoryName
};
if (category.CategoryId == selectedId)
{
cate.selected = true;
}
foreach (ResCourseCategory courseCategory in list)
{
cate.children.Add(GetChilds(courseCategory, all, selectedId));
}
return(cate);
}
public JsonResult SaveCategory(int parentId, int id, string cname, string desc)
{
ResCourseCategory category;
if (id == 0)
{
category = new ResCourseCategory
{
ParentId = parentId,
TenantId = CurrentTenant.TenantId,
CreateTime = DateTime.Now,
CreateUser = CurrentUser.UserId,
Status = 0
};
}
else
{
category = _courseManager.GetCategoryById(id);
if (category.TenantId != CurrentTenant.TenantId)
{
return(Json(new { result = 0, errorMgs = RetechWing.LanguageResources.CourseLanguage.DontFindCourseSystem }, JsonRequestBehavior.DenyGet));
}
}
category.CategoryName = cname;
category.Description = desc;
if (parentId == 0)
{
category.LevelDesc = cname;
}
else
{
ResCourseCategory parent = _courseManager.GetCategoryById(parentId);
category.LevelDesc = parent.LevelDesc + "\\" + cname;
}
if (id == 0)
{
_courseManager.AddCategory(category);
}
else
{
_courseManager.UpdateCategory(category);
}
return(Json(new { result = 1 }, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// Edits the category.
/// </summary>
/// <returns>The category.</returns>
/// <param name="cateId">Cate identifier.</param>
/// <param name="parentId">Parent identifier.</param>
public ActionResult EditCategory(int cateId, int parentId = 0)
{
ResCourseCategory model;
ViewBag.parentId = parentId;
if (cateId == 0)
{
//新增
model = new ResCourseCategory();
}
else
{
model = _courseManager.GetCategoryById(cateId);
}
ResCourseCategory parent = _courseManager.GetCategoryById(parentId);
ViewBag.parentName = parent == null ? CurrentTenant.TenantName : parent.CategoryName;
return(View(model));
}
/// <summary>
/// 更新课程体系
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public bool UpdateCategory(ResCourseCategory category)
{
var oldcategory = GetCategoryById(category.CategoryId);
bool result = _dataAccess.UpdateEntity(category) > 0;
if (result)
{
//修改描述
string sql = string.Format("UPDATE Res_CourseCategory SET LevelDesc=REPLACE(LevelDesc,'{0}','{1}') WHERE CategoryId<>{2}", oldcategory.LevelDesc, category.LevelDesc, category.CategoryId);
var flag = _dataAccess.ExecuteSql(sql);
if (flag > 0)
{
var source = BusinessCache.SystemCache.Instance.Courses;
foreach (var item in source.Where(p => p.Status == 0 && (p.LevelDesc.ToUpper().StartsWith(oldcategory.LevelDesc.ToUpper()) || p.CategoryId == category.CategoryId)))
{
item.LevelDesc = item.LevelDesc.Replace(oldcategory.LevelDesc, category.LevelDesc);
}
}
}
return(result);
}
/// <summary>
/// 新增课程体系
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public int AddCategory(ResCourseCategory category)
{
_dataAccess.AddEntity(category);
return(category.CategoryId);
}
/// <summary>
/// 更新一个分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateSort(ResCourseCategory model)
{
return(_dataAccess.UpdateEntity(model));
}
/// <summary>
/// 添加一个分类
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddSort(ResCourseCategory model)
{
return(_dataAccess.AddEntity(model));
}
