/// <summary>
/// 课程分类
/// </summary>
/// <returns></returns>
public ActionResult GetCateTreeSelectJson()
{
var data = _coreCategoryService.GetCourseCategoryList();
var treeList = new List <TreeSelectModel>();
foreach (var item in data)
{
TreeSelectModel treeModel = new TreeSelectModel();
treeModel.id = item.CategoryId + "";
treeModel.text = item.CourseCategoryName;
treeModel.parentId = item.ParentId + "";
treeList.Add(treeModel);
}
return(Content(treeList.TreeSelectJson()));
}
public ActionResult saveOrUpdate(string strlist)
{
try
{
//因为页面操作是修改删除添加全由一个保存按钮来实现的
//所以这里的保存要原来的数据全部删掉然后再重新添加最简单
//但是如果部门表有关联表且关联的是id可能会有问题,可以改为关联名称，且名称不重复就能避免
JavaScriptSerializer jss = new JavaScriptSerializer();
var treelist = jss.Deserialize <List <TreeView> >(strlist);
var dtolist = treelist.TreeViewToCDto();
foreach (var item in dtolist)
{
if (item.IsNew)
{
if (item.ParentId > 0)
{
var date = _corecategoryService.GetCourseCategoryList().FirstOrDefault(t => t.CategoryId == item.ParentId);
if (date != null)
{
item.Path = date.Path + item.CategoryId + "/";
}
}
else
{
item.Path = item.CategoryId + "/";
}
item.IsNew = false;
_corecategoryService.CreateCourseCategory(item);
}
else
{
string sqlstr = "update px_course_category set name=@name ,update_time=@update_time, updater=@updater where category_id=@category_id";
var i = _sqlExecuter.Execute(sqlstr,
new MySqlParameter("@name", item.CourseCategoryName),
new MySqlParameter("@update_time", DateTime.Now),
new MySqlParameter("@updater", 1),
new MySqlParameter("@category_id", item.CategoryId));
}
}
return(Content("添加成功！"));
}
catch (Exception e)
{
return(Content("添加失败！"));
}
}