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