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