/// <summary>
/// 分页查询所有的活动信息
/// </summary>
/// <param name="iUnitContentId"></param>
/// <returns></returns>
private List<Course_UnitContent> GetCourseUnitContentActivities(int iTrainingId = 0)
{
var List_Course_UnitContent = new List<Course_UnitContent>();
var unitContentbll = new Course_UnitContentBLL();
var stbSqlWhere = new StringBuilder();
var strOrderBy = "Course_UnitDetail.Id,Course_UnitContent.Sort";
if (iTrainingId > 0)
stbSqlWhere.AppendFormat("Course_UnitDetail.TrainingId = {0}", iTrainingId);
List_Course_UnitContent = unitContentbll.GetListOther(stbSqlWhere.ToString(), strOrderBy);
//按照页面排列 章-节-活动
return List_Course_UnitContent;
}
/// <summary>
/// 获取页面活动的公共方法
/// </summary>
/// <param name="bolNeedUpdateProgress">是否需要更新总进度</param>
/// <returns></returns>
private Course_UnitContent GetCourseUnitContentActivity(int TrainingId, int UnitContent, int ClassId, bool bolNeedUpdateProgress = true)
{
//获取所有的阅读信息
var courseBll = new Course_UnitContentBLL();
var DetailBll = new Traning_DetailBLL();
var List_Course_UnitContent = new List<Course_UnitContent>();
var Model_Course_UnitContent = new Course_UnitContent();
var stbSqlWhere = new StringBuilder();
var strOrderBy = "Sort";
int iAccountId = 0, iUnitId = 0;
iAccountId = Code.SiteCache.Instance.LoginInfo.UserId;
stbSqlWhere.Append(" 1 = 1");
if (TrainingId > 0)
stbSqlWhere.AppendFormat(" AND Course_UnitDetail.TrainingId = {0}", TrainingId);
if (UnitContent > 0)
stbSqlWhere.AppendFormat(" AND Course_UnitContent.Id = {0}", UnitContent);
List_Course_UnitContent = courseBll.GetListOther(stbSqlWhere.ToString(), strOrderBy);
if (List_Course_UnitContent != null && List_Course_UnitContent.Count == 1)
Model_Course_UnitContent = List_Course_UnitContent[0];
//根据 TrainingId 获取 Title
var Model_Traning_Detail = DetailBll.GetModel(TrainingId, string.Empty);
ViewBag.TraningDetailTitle = Model_Traning_Detail.Title;
ViewBag.UnitId = iUnitId = Model_Course_UnitContent.UnitId.Value;
ViewBag.AccountId = iAccountId;
ViewBag.ClassId = ClassId;
ViewBag.TrainingId = TrainingId;
ViewBag.UnitContent = UnitContent = Model_Course_UnitContent.Id;
ViewBag.Model_Course_UnitContent = Model_Course_UnitContent;
if (bolNeedUpdateProgress && List_Course_UnitContent != null && List_Course_UnitContent.Count > 0)
{
//更新总体进度
this.UpdateOverallProgress(iUnitId, ClassId, TrainingId, iAccountId, UnitContent);
}
return Model_Course_UnitContent;
}
/// <summary>
/// 获取页面活动的公共方法
/// </summary>
/// <returns></returns>
private Course_UnitContent GetCourseUnitContentActivity()
{
//获取所有的阅读信息
var courseBll = new Course_UnitContentBLL();
var DetailBll = new Traning_DetailBLL();
var List_Course_UnitContent = new List<Course_UnitContent>();
var Model_Course_UnitContent = new Course_UnitContent();
var stbSqlWhere = new StringBuilder();
var strOrderBy = "Sort";
int iClassId = 0, iTrainingId = 0, iAccountId = 0, iUnitContent = 0, iUnitId = 0;
int.TryParse(Convert.ToString(Request["TrainingId"]) == "" ? "0" : QueryString.Decrypt(Request["TrainingId"]), out iTrainingId);
int.TryParse(Convert.ToString(Request["UnitContent"]) == "" ? "0" : QueryString.Decrypt(Request["UnitContent"]), out iUnitContent);
stbSqlWhere.Append(" 1 = 1 ");
if (iTrainingId > 0)
stbSqlWhere.AppendFormat("AND Course_UnitDetail.TrainingId = {0}", iTrainingId);
if (iTrainingId > 0)
stbSqlWhere.AppendFormat("AND Course_UnitContent.Id = {0}", iUnitContent);
List_Course_UnitContent = courseBll.GetListOther(stbSqlWhere.ToString(), strOrderBy);
if (List_Course_UnitContent != null && List_Course_UnitContent.Count == 1)
Model_Course_UnitContent = List_Course_UnitContent[0];
//获取当前登录用户的班级和ID
iAccountId = Code.SiteCache.Instance.LoginInfo.UserId;
//根据 TrainingId 获取 Title
var Model_Traning_Detail = DetailBll.GetModel(iTrainingId, string.Empty);
ViewBag.TraningDetailTitle = Model_Traning_Detail.Title;
ViewBag.AccountId = iAccountId;
ViewBag.TrainingId = iTrainingId;
ViewBag.UnitContent = iUnitContent = Model_Course_UnitContent.Id;
ViewBag.Model_Course_UnitContent = Model_Course_UnitContent;
return Model_Course_UnitContent;
}