public ActionResult EditCourseSystem(int flag, int Id)
{
Co_CourseSystem courseSys = new Co_CourseSystem();
if (Id != 0)
{
courseSys = _courseSysBL.GetCourseSystem(Id);
}
if (flag == 1)//编辑 选中的接点
{
if (courseSys != null)
{
var list = _sysPayGradeBL.GetSys_SortLinkGradeList(" SortId=" + Id);
if (courseSys.ParentID == 0)
{
ViewBag.PartentName = TopCourseSystemName;
}
else
{
var temp = _courseSysBL.GetCourseSystem(courseSys.ParentID);
if (temp == null)
{
ViewBag.PartentName = TopCourseSystemName;
}
else
{
ViewBag.PartentName = temp.CourseSystemName;
}
}
}
return(View(courseSys));
}
else//新增
{
var tempAdd = new Co_CourseSystem();
tempAdd.ParentID = Id;
var tempParent = _courseSysBL.GetCourseSystem(courseSys.Id);
if (tempParent == null)
{
ViewBag.PartentName = TopCourseSystemName;
}
else
{
ViewBag.PartentName = tempParent.CourseSystemName;
}
return(View(tempAdd));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateCourseSystem(Co_CourseSystem model)
{
using (IDbConnection connection = OpenConnection())
{
const string updateSql =
@"update Co_CourseSystem set CourseSystemName=@CourseSystemName,ParentID=@ParentID,Memo=@Memo,IsDelete=@IsDelete where Id=@Id ";
var param = new
{
model.Id,
model.CourseSystemName,
ParentID = model.ParentID,
model.Memo,
model.IsDelete
};
return(connection.Execute(updateSql, param) > 0);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void AddCourseSystem(Co_CourseSystem model)
{
using (IDbConnection connection = OpenConnection())
{
const string strSql =
@"insert into Co_CourseSystem(CourseSystemName,ParentID,Memo,IsDelete) values(@CourseSystemName,@ParentID,@Memo,@IsDelete)
SELECT @@Identity AS ID
";
var param = new
{
model.CourseSystemName,
ParentID = model.ParentID,
model.Memo,
model.IsDelete
};
decimal id =
connection.Query <decimal>(strSql, param)
.FirstOrDefault();
model.Id = decimal.ToInt32(id);
}
}
/// <summary>
/// 保存分类
/// </summary>
/// <returns></returns>
public JsonResult SubmitCourseSystem(Co_CourseSystem courseSystem, string sys_PayGrade, string hidOldPayGradeIds = "")
{
if (courseSystem.Id == 0)
{
//添加
_courseSysBL.AddCourseSystem(courseSystem);
//if (!string.IsNullOrEmpty(sys_PayGrade))
//{
// string[] payGradeArray = sys_PayGrade.Split(',');
// foreach (var item in payGradeArray)
// {
// if (!string.IsNullOrEmpty(item))
// {
// _sysPayGradeBL.AddSys_SortLinkGrade(new Sys_SortLinkGrade() { GradeID = int.Parse(item), SortID = courseSystem.Id });
// }
// }
//}
if (courseSystem.Id > 0)
{
return(Json(new
{
result = 1,
content = "保存成功！"
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new
{
result = 0,
content = "保存失败"
}, JsonRequestBehavior.AllowGet));
}
}
else
{
//修改
Co_CourseSystem courseSys = _courseSysBL.GetCourseSystem(courseSystem.Id);
courseSys.CourseSystemName = courseSystem.CourseSystemName;
courseSys.Memo = courseSystem.Memo;
bool newid = _courseSysBL.UpdateCourseSystem(courseSys);
if (newid)
{
//if (!string.IsNullOrEmpty(hidOldPayGradeIds))
//{
// string[] CurrentpayGrade = sys_PayGrade.Split(',');// A B C
// string[] OldpayGrade = hidOldPayGradeIds.Split(',');// B C
// foreach (var item in OldpayGrade)
// {
// if (!CurrentpayGrade.Contains(item))// 移除
// {
// if (!string.IsNullOrEmpty(item))
// {
// _sysPayGradeBL.DeleteSys_SortLinkGrade(courseSystem.Id, int.Parse(item));
// }
// }
// }
// foreach (var item in CurrentpayGrade)
// {
// if (!OldpayGrade.Contains(item))// 新增
// {
// if (!string.IsNullOrEmpty(item))
// {
// _sysPayGradeBL.AddSys_SortLinkGrade(new Sys_SortLinkGrade() { GradeID = int.Parse(item), SortID = courseSystem.Id });
// }
// }
// }
//}
return(Json(new
{
result = 1,
content = "保存成功"
}, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new
{
result = 0,
content = "保存失败"
}, JsonRequestBehavior.AllowGet));
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool UpdateCourseSystem(Co_CourseSystem model)
{
return(_courseSysDB.UpdateCourseSystem(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public void AddCourseSystem(Co_CourseSystem model)
{
_courseSysDB.AddCourseSystem(model);
}
