/// <summary>
/// 根据课件id查找对应数据
/// </summary>
/// <param name="Model"></param>
/// <param name="System_Station_ID"></param>
/// <returns></returns>
public W_CourseWareModel GetCourseWareByIDforStu(W_CourseWareModel Model, string StuId, int System_Station_ID)
{
string sql = string.Empty;
W_CourseWareModel CourseWareModel = new W_CourseWareModel();
W_Configuration ConModel = Orm.Single <W_Configuration>(x => x.System_Station_ID == System_Station_ID);
if (string.IsNullOrEmpty(StuId) && ConModel.OverFlowAuth == 1 && ConModel.UserSeeAuth == 1)
{
throw new ApiException("您当前未注册，请注册登录后再试！");
}
CourseWareModel = SqlMapper.QueryForObject <W_CourseWareModel>("GetCourseWareModel2", new { ID = Model.ChapterID, Course_ID = Model.Course_ID, System_Station_ID = System_Station_ID, StuId = StuId });
if (CourseWareModel != null && CourseWareModel.Discipline_ID > 0)
{
//获取一级 二级 三级学科ID
DisciplineIDModel DisciplineModel = new DisciplineMapper().GetDisciplineIDS(CourseWareModel.Discipline_ID);
if (DisciplineModel != null)
{
CourseWareModel.Discipline_OneLevelID = DisciplineModel.Discipline_OneLevelID; //一级学科ID
CourseWareModel.Discipline_TwoLevelID = DisciplineModel.Discipline_TwoLevelID; //二级学科ID
CourseWareModel.Discipline_ThreeLevelID = DisciplineModel.Discipline_ThreeLevelID; //三级学科ID
}
//秒转时间格式
if (CourseWareModel.Duration > 0)
{
CourseWareModel.DurationS = GetTurnSecondTime(CourseWareModel.Duration);
}
else
{
CourseWareModel.DurationS = "00:00:00";
}
//字节转换KB MB GB
if (CourseWareModel.CourseSize > 0)
{
CourseWareModel.CourseSizeS = HumanReadableFilesize(CourseWareModel.CourseSize);
}
}
if (CourseWareModel == null)
{
throw new ApiException("操作失败，未找到对应的数据！");
}
return(CourseWareModel);
}
/// <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 List <T_TeacherInfo_Detail_DisciplineModel> GetTeacherDetailDiscipline(int TeacherDetail_ID, int System_Station_ID)
{
List <T_TeacherInfo_Detail_DisciplineModel> list = SqlMapper.QueryForList <T_TeacherInfo_Detail_DisciplineModel>("GetTeacherDetailDiscipline", new { TeacherDetail_ID = TeacherDetail_ID, System_Station_ID = System_Station_ID }).ToList();
if (list != null && list.Count > 0)
{
list.ForEach(T =>
{
//获取一级 二级 三级学科ID
DisciplineIDModel DisciplineModel = new DisciplineMapper().GetDisciplineIDS(T.Discipline_ID);
if (DisciplineModel != null)
{
T.Discipline_OneLevelID = DisciplineModel.Discipline_OneLevelID; //一级学科ID
T.Discipline_TwoLevelID = DisciplineModel.Discipline_TwoLevelID; //二级学科ID
T.Discipline_ThreeLevelID = DisciplineModel.Discipline_ThreeLevelID; //三级学科ID
}
});
}
return(list);
}
/// <summary>
/// 根据课件id查找对应数据
/// </summary>
/// <param name="Model"></param>
/// <param name="System_Station_ID"></param>
/// <returns></returns>
public W_CourseWareModel GetCourseWareByIDforPC(W_CourseWareModel Model, int System_Station_ID)
{
string sql = string.Empty;
W_CourseWareModel CourseWareModel = new W_CourseWareModel();
CourseWareModel = SqlMapper.QueryForObject <W_CourseWareModel>("GetCourseWareModel1", new { ID = Model.ID, System_Station_ID = System_Station_ID });
if (CourseWareModel != null && CourseWareModel.Discipline_ID > 0)
{
//获取一级 二级 三级学科ID
DisciplineIDModel DisciplineModel = new DisciplineMapper().GetDisciplineIDS(CourseWareModel.Discipline_ID);
if (DisciplineModel != null)
{
CourseWareModel.Discipline_OneLevelID = DisciplineModel.Discipline_OneLevelID; //一级学科ID
CourseWareModel.Discipline_TwoLevelID = DisciplineModel.Discipline_TwoLevelID; //二级学科ID
CourseWareModel.Discipline_ThreeLevelID = DisciplineModel.Discipline_ThreeLevelID; //三级学科ID
}
//秒转时间格式
if (CourseWareModel.Duration > 0)
{
CourseWareModel.DurationS = GetTurnSecondTime(CourseWareModel.Duration);
}
else
{
CourseWareModel.DurationS = "00:00:00";
}
//字节转换KB MB GB
if (CourseWareModel.CourseSize > 0)
{
CourseWareModel.CourseSizeS = HumanReadableFilesize(CourseWareModel.CourseSize);
}
}
if (CourseWareModel == null)
{
throw new ApiException("操作失败，未找到对应的数据！");
}
return(CourseWareModel);
}