/// <summary> /// 添加修改 网课 /// </summary> /// <param name="Model"></param> /// <param name="System_Station_ID"></param> /// <returns></returns> public dynamic SaveCourse(W_Course model, int System_Station_ID, int AccountID) { if (GetExsitWebCourse(model, System_Station_ID) > 0) { throw new ApiException("该网课已存在!"); } if (model.ID > 0) { W_CourseModel Model = GetCourseByID(model.ID, System_Station_ID, ""); if (Model == null) { throw new ApiException("操作失败,未找到对应的数据!"); } model.AddPerson = Model.AddPerson; model.AddTime = Model.AddTime; model.System_Station_ID = Model.System_Station_ID; model.Valid = Model.Valid; if (Orm.Update(model) <= 0) { throw new ApiException("修改失败"); } return(model); } else { model.System_Station_ID = System_Station_ID; model.Valid = 1; model.AddTime = DateTime.Now; model.AddPerson = AccountID; return(Orm.Single <W_Course>(x => x.ID == (int)Orm.Insert(model, true) && x.System_Station_ID == System_Station_ID)); } }
public dynamic SaveCourse1(W_Course model) { W_CourseModel Coursemodel = mapper.GetCourseByID(model.ID, this.System_Station_ID, ""); if (Coursemodel != null) { model.TeacherDetail_ID = Coursemodel.TeacherDetail_ID; model.CoverPath = Coursemodel.CoverPath; model.Description = Coursemodel.Description; model.Particulars = Coursemodel.Particulars; } return(Success(mapper.SaveCourse(model, this.System_Station_ID, this.AccountID))); }
/// <summary> /// 根据网课id 查找对应数据 /// </summary> /// <param name="Model"></param> /// <param name="System_Station_ID"></param> /// <returns></returns> public dynamic GetCourseByID(int ID, int System_Station_ID, string StuId) { W_CourseModel model = SqlMapper.QueryForObject <W_CourseModel>("GetCourseByID", new { ID = ID, System_Station_ID = System_Station_ID, StuId = StuId }); if (model != null && model.Discipline_ID > 0) { //获取一级 二级 三级学科ID DisciplineIDModel DisciplineModel = new DisciplineMapper().GetDisciplineIDS(model.Discipline_ID); if (DisciplineModel != null) { model.Discipline_OneLevelID = DisciplineModel.Discipline_OneLevelID; //一级学科ID model.Discipline_TwoLevelID = DisciplineModel.Discipline_TwoLevelID; //二级学科ID model.Discipline_ThreeLevelID = DisciplineModel.Discipline_ThreeLevelID; //三级学科ID } } return(model); }
public dynamic SaveCourse2(W_Course model) { W_CourseModel Coursemodel = mapper.GetCourseByID(model.ID, this.System_Station_ID, ""); if (Coursemodel != null) { model.Name = Coursemodel.Name; model.Price = Coursemodel.Price; model.PreferentialPrice = Coursemodel.PreferentialPrice; model.BuyBase = Coursemodel.BuyBase; model.TotalHours = Coursemodel.TotalHours; model.TeachingMethod = Coursemodel.TeachingMethod; model.IsPutaway = Coursemodel.IsPutaway; model.IsRecommend = Coursemodel.IsRecommend; model.Discipline_ID = Coursemodel.Discipline_ID; } return(Success(mapper.SaveCourse(model, this.System_Station_ID, this.AccountID))); }
/// <summary> /// 获取一级学科下面所有二级学科列表以及课程列表 /// </summary> /// <param name="DisciplineID"></param> /// <returns></returns> public List <DisciplineModel> GetAllDisciplineInfo(int System_Station_ID) { DisciplineModel Model = new DisciplineModel(); Model.Valid = 1;//启用 Model.System_Station_ID = System_Station_ID; Model.IsRecommend = -1; PageModel page = new PageModel(); List <DisciplineModel> List = GetAllDisciplines(Model); W_CourseModel Course = new W_CourseModel(); Course.Valid = 1;//启用 Course.System_Station_ID = System_Station_ID; List <W_CourseModel> CourseList = GetCourseList(Course); List <DisciplineModel> NodeList = new List <DisciplineModel>(); if (List != null && List.Count > 0) { NodeList = List.FindAll(X => X.CID == 0); if (NodeList != null && NodeList.Count > 0) { //添加子集 NodeList.ForEach(x => { x.CourseList = new List <W_CourseModel>(); x.ChildNodeList = List.FindAll(F => F.CID == x.ID); if (x.ChildNodeList != null && x.ChildNodeList.Count > 0) { x.ChildNodeList.ForEach(y => { y.ChildNodeList = List.FindAll(K => K.CID == y.ID); string DisciplineIds = string.Join(",", y.ChildNodeList.Select(m => m.ID)) + "," + y.ID; y.CourseList = CourseList.Where(C => ("," + DisciplineIds + ",").IndexOf("," + C.Discipline_ID + ",") >= 0).ToList(); x.CourseList.AddRange(y.CourseList); }); } x.CourseList.AddRange(CourseList.Where(C => C.Discipline_ID == x.ID).ToList()); }); } } return(NodeList); }
public List <W_CourseModel> GetCourseList(W_CourseModel Model) { return(SqlMapper.QueryForList <W_CourseModel>("GetCourseLists", new { System_Station_ID = Model.System_Station_ID, Valid = Model.Valid }).ToList()); }
public dynamic GetCourseList([FromUri] W_CourseModel model) { return(Success(mapper.GetCourseList(model, this.System_Station_ID), model.PageIndex == 1 ? mapper.GetCourseListTotalCount(model, this.System_Station_ID) : 0)); }
/// <summary> /// 获取课程列表总条数 /// </summary> /// <param name="Model"></param> /// <param name="System_Station_ID"></param> /// <returns></returns> public int GetCourseListTotalCount(W_CourseModel Model, int System_Station_ID) { return(SqlMapper.QueryForObject <int>("GetCourseListTotalCount", new { System_Station_ID = System_Station_ID, TeachingMethod = Model.TeachingMethod, Discipline_ID = Model.Discipline_ID, Valid = Model.Valid, IsPutaway = Model.IsPutaway, IsRecommend = Model.IsRecommend, Name = Model.Name, StuID = Model.StuID, pageStatus = 0 })); }
/// <summary> /// 获取课程列表 /// </summary> /// <param name="Model"></param> /// <param name="System_Station_ID"></param> /// <returns></returns> public IList GetCourseList(W_CourseModel Model, int System_Station_ID) { return(QueryForList("GetCourseList", new { System_Station_ID = System_Station_ID, TeachingMethod = Model.TeachingMethod, Discipline_ID = Model.Discipline_ID, Valid = Model.Valid, IsPutaway = Model.IsPutaway, IsRecommend = Model.IsRecommend, Name = Model.Name, StuID = Model.StuID, pageIndex = (Model.PageIndex - 1) * Model.PageSize, pageSize = Model.PageSize, pageStatus = Model.PageStatus })); }