/// <summary> /// 用户学习完某门课程下的某个视频 /// </summary> /// <param name="uid"></param> /// <param name="couid"></param> /// <param name="movid"></param> /// <returns></returns> public bool UserLearnEnd(int uid, int movid) { int courseid = base.EF.Move.Where(m => m.Mov_ID == movid).FirstOrDefault().Cou_ID; UserLearnCoursesRecord course = base.EF.UserLearnCoursesRecord.Where(u => u.User_ID == uid && u.Cou_ID == courseid).FirstOrDefault(); UserLearnSectionRecord rec = base.EF.UserLearnSectionRecord.Where(u => u.User_ID == uid && u.Mov_ID == movid).FirstOrDefault(); rec.Is_Finish = true; course.ULC_Time = DateTime.Now; //var list = base.EF.UserLearnCoursesRecord.Where(u => u.User_ID == uid && u.Cou_ID == rec.Cou_ID); //foreach (var item in list) //{ // item.ULC_Time = DateTime.Now; //} //if (rec == null) //{ // int courseid = base.EF.Move.Where(m => m.Mov_ID == movid).Select(m => m.Cou_ID).FirstOrDefault(); // base.EF.UserLearnCoursesRecord.Add(new UserLearnCoursesRecord() {Cou_ID = courseid, User_ID = uid, Move_ID = movid, Is_Finish = true, ULC_Time = DateTime.Now }); //} //else //{ // rec.ULC_Time = DateTime.Now; //} return(base.EF.SaveChanges() > 0 ? true : false); }
/// <summary> /// 用户开始学习的课程 /// </summary> /// <param name="uid"></param> /// <param name="movid"></param> /// <returns></returns> public bool UserStartLearn(int uid, int movid) { //获取节对应的课程ID int courseid = base.EF.Move.Where(m => m.Mov_ID == movid).Select(m => m.Cou_ID).FirstOrDefault(); UserLearnCoursesRecord rec = base.EF.UserLearnCoursesRecord.Where(u => u.User_ID == uid && u.Cou_ID == courseid).FirstOrDefault(); //用户学习课程记录 if (rec == null)//如果该用户第一次学习该课程,就在数据表中添加数据 { base.EF.UserLearnCoursesRecord.Add(new UserLearnCoursesRecord() { Cou_ID = courseid, ULC_Time = DateTime.Now, User_ID = uid }); } else//如果用户已经学习了该课程,并且不过是否已经学完,都要更改时间 { rec.ULC_Time = DateTime.Now; } //用户学习章节记录 UserLearnSectionRecord section = base.EF.UserLearnSectionRecord.Where(u => u.Mov_ID == movid && u.User_ID == uid).FirstOrDefault(); if (section == null)//第一次学习该章节 { base.EF.UserLearnSectionRecord.Add(new UserLearnSectionRecord() { User_ID = uid, Mov_ID = movid, Is_Finish = false, Cou_ID = courseid }); } return(base.EF.SaveChanges() > 0 ? true : false); }