/// <summary> /// 作者:Primo /// 日期:2015.05.22 /// 描述:获取学员的单个一课一练 /// </summary> /// <param name="branchId"></param> /// <param name="productId"></param> /// <param name="productLevelId"></param> /// <param name="searchKeyword"></param> /// <param name="searchKey"></param> /// <returns></returns> public static List<GetEWBFinishExercise_Result> GetEWBFinishExercise(int? branchId, int? productId, int? productLevelId, string searchKeyword, int? searchKey) { var db = new EwordbookEntities(); var account = ""; var userName = ""; if (searchKey.HasValue) { //登录帐号 if (ConvertEnum.SearchStudentKeyForAccount == searchKey.Value) { account = searchKeyword; } //用户名称 if (ConvertEnum.SearchStudentKeyForUserName == searchKey.Value) { userName = searchKeyword; } } var model = db.GetEWBFinishExercise(branchId, productId, productLevelId, account, userName).ToList(); return model; }
/// <summary> /// 作者:Primo /// 日期:2015.08.21 /// 描述:获取学生一课一练的单课情况1 /// </summary> /// <param name="branchId"></param> /// <param name="account"></param> /// <param name="courseId"></param> /// <returns></returns> public static List<StudentEwordBookScoreLessonDetail_Result> GetStudentEwordBookScoreLessonDetail(int branchId, string account, int courseId) { var db = new EwordbookEntities(); var modelList = db.StudentEwordBookScoreLessonDetail(branchId, account, courseId).ToList(); return modelList; }
/// <summary> /// 作者:Primo /// 日期:2015.08.19 /// 描述:获取学生一课一练的情况 /// </summary> /// <param name="account"></param> /// <param name="branchId"></param> /// <param name="productId"></param> /// <param name="productLeveId"></param> /// <returns></returns> public static List<StudentEwordBookScoreDetail_Result> GetStudentEwordBookScoreDetail(string account, int? branchId, int? productId, int? productLeveId) { var db = new EwordbookEntities(); var modelLessonId = db.StudentEwordBookScoreDetail(branchId, productId, productLeveId, account).ToList(); return modelLessonId; }
/// <summary> /// 作者:Primo /// 日期:2015.05.23 /// 描述:获取一课一练该级别下需要联系的课节ID /// </summary> /// <param name="productId"></param> /// <param name="productLeveId"></param> /// <returns></returns> public static List<int?> GetEWBExerciseLessonIdList(int? productId, int? productLeveId) { var db = new EwordbookEntities(); var modelLessonId = db.GetEWBExerciseLessonId(productId, productLeveId).ToList(); return modelLessonId; }
/// <summary> /// 作者:Primo /// 日期:2015.05.20 /// 描述:获取学员的单个一课一练的情况 /// </summary> /// <param name="branchId"></param> /// <param name="beginDate"></param> /// <param name="endDate"></param> /// <returns></returns> public static List<StudentEwordbookScore_Result> StudentEwordbookScore(string userName, int CourseId) { var db = new EwordbookEntities(); var model = db.StudentEwordbookScore(userName, CourseId).ToList(); return model; }
/// <summary> /// 作者: /// 时间: /// 描述: /// /// /// 作者:Primo /// 时间:2015.05.08 /// 描述:修改判断学员是否有权限做题 /// </summary> /// <param name="userName"></param> /// <param name="courseId"></param> /// <returns></returns> public static bool IsExistsCourse(string userName, int courseId) { var db = new EmeEntities(dbRead); var edb = new EwordbookEntities(); //如果这个用户名是非学生,则无论如何都是返回true var modelUser = UserBLL.GetUserByUserName(userName); if (modelUser != null) { if (modelUser.UserType != ConvertEnum.UserTypeForStudent) { return true; } } var courseIdList = edb.GetEwordbook(courseId).ToList(); var beginTime = DateTime.Now; if (courseIdList.Count() > 0) { courseId = courseIdList[0].Value; var list = from br in db.BookRecord join plctc in db.ProductLevelCourseTypeCourse on br.ArrangeCourse.ProductLevelCourseTypeCourseId equals plctc.Id where br.IsUnBook == false && br.Student.User.UserName == userName && plctc.CourseId == courseId && br.ArrangeCourse.BeginTime <= beginTime select new { br.Id }; return list.Any(); } else { return false; } }
/// <summary> /// 作者:Primo /// 时间:2015.07.21 /// 描述:一课一练四周内上课 存储过程在一课一练数据库中 /// </summary> /// <param name="searchDate"></param> /// <returns></returns> public static List<EWorkBookStudentStudyActivityStat_Result> GetEWorkBookStudentStudyActivityStat(DateTime searchDate) { using (var db = new EwordbookEntities()) { return db.EWorkBookStudentStudyActivityStat(searchDate).ToList(); } }