コード例 #1
0
        /// <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);
        }
コード例 #2
0
        /// <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);
        }