/// <summary> /// 获取数据集 /// </summary> /// <param name="where"></param> /// <param name="orderBy"></param> /// <returns></returns> public List<Course_UnitHomeWork> GetList(string where, string orderBy) { StringBuilder sql = new StringBuilder(); sql.Append("select * from [dbo].[Course_UnitHomeWork]"); if (!string.IsNullOrEmpty(where)) sql.Append(" where " + where); if (!string.IsNullOrEmpty(orderBy)) sql.Append(" order by " + orderBy); List<Course_UnitHomeWork> list = new List<Course_UnitHomeWork>(); using (IDataReader reader = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql.ToString())) { while (reader.Read()) { Course_UnitHomeWork model = new Course_UnitHomeWork(); ConvertToModel(reader, model); list.Add(model); } } return list; }
/// <summary> /// 新增一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Add(Course_UnitHomeWork model) { StringBuilder sql = new StringBuilder(); sql.Append("insert into [dbo].[Course_UnitHomeWork] ([UnitContent],[ClassId],[Content],[AccountId],[AttList],[Display],[Delflag],[CreateDate],[Score],[ScoreCreater])"); sql.Append(" values (@UnitContent,@ClassId,@Content,@AccountId,@AttList,@Display,@Delflag,@CreateDate,@Score,@ScoreCreater)"); sql.Append(" set @Id=@@IDENTITY"); SqlParameter[] cmdParams = new SqlParameter[]{ new SqlParameter("@Id", SqlDbType.Int, 4) { Value = model.Id, Direction = ParameterDirection.Output }, new SqlParameter("@UnitContent", SqlDbType.Int, 4) { Value = model.UnitContent }, new SqlParameter("@ClassId", SqlDbType.Int, 4) { Value = model.ClassId }, new SqlParameter("@Content", SqlDbType.VarChar, 2000) { Value = model.Content }, new SqlParameter("@AccountId", SqlDbType.Int, 4) { Value = model.AccountId }, new SqlParameter("@AttList", SqlDbType.VarChar, 2000) { Value = model.AttList }, new SqlParameter("@Display", SqlDbType.Bit, 1) { Value = model.Display }, new SqlParameter("@Delflag", SqlDbType.Bit, 1) { Value = model.Delflag }, new SqlParameter("@CreateDate", SqlDbType.DateTime, 8) { Value = model.CreateDate }, new SqlParameter("@Score", SqlDbType.Float, 8) { Value = model.Score }, new SqlParameter("@ScoreCreater", SqlDbType.Int, 4) { Value = model.ScoreCreater } }; int result = Convert.ToInt32(MSEntLibSqlHelper.ExecuteNonQueryBySql(sql.ToString(), cmdParams)); model.Id = Convert.ToInt32(cmdParams[0].Value); return result; }
public ActionResult LearnOnLineTaskShowView(int TrainingId, int UnitContent, int ClassId, int UId) { //获取活动及标题 var Model_Course_UnitContent = this.GetCourseUnitContentActivity(TrainingId, UnitContent, ClassId, false); var homeWorkBll = new Course_UnitHomeWorkBLL(); var Model_Course_UnitHomeWork = new Course_UnitHomeWork(); var stbSqlWhere = new StringBuilder(); var MemberBll = new Member_AccountBLL(); var strNickName = string.Empty; //获取作业信 stbSqlWhere.AppendFormat(@" UId = {0}", UId); Model_Course_UnitHomeWork = homeWorkBll.GetModel(UId, string.Empty); if (Model_Course_UnitHomeWork != null) { strNickName = MemberBll.GetModel(Model_Course_UnitHomeWork.AccountId, string.Empty).Nickname; } ViewBag.ClassId = ClassId; ViewBag.NickName = strNickName; ViewBag.UnitContent = UnitContent = Model_Course_UnitHomeWork.Id; ViewBag.Model_Course_UnitHomeWork = Model_Course_UnitHomeWork; return View(); }
/// <summary> /// [在线学习-作业] 新增 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult LearnOnLineTaskEdit(int UnitId, int ClassId, int TrainingId, int UnitContent, string Content, string AttList) { var stbSqlWhere = new StringBuilder(); var HomeWorkBll = new Course_UnitHomeWorkBLL(); var model = new Course_UnitHomeWork(); int AccountId = Code.SiteCache.Instance.LoginInfo.UserId; double? dblScore = null; //若课程已结束禁止操作 if (this.GetCourseIsOver(ClassId, TrainingId, AccountId)) return Json(new { Result = false, Msg = "提交失败.当前课程已结束,不能执行该操作!" }, JsonRequestBehavior.AllowGet); //查看当前活动是否已打分,若已打分则禁止操作 if (this.GetActivityScore_Task(ClassId, AccountId, UnitContent, out dblScore)) return Json(new { Result = false, Msg = "提交失败.当前活动已打分,不能执行该操作!" }, JsonRequestBehavior.AllowGet); model.UnitContent = UnitContent; model.ClassId = ClassId; model.Content = Content; model.AccountId = AccountId; model.AttList = AttList; model.Content = Content; stbSqlWhere.AppendFormat(@" UnitContent = {0} AND ClassId = {1} AND AccountId = {2} AND Display = 1 AND Delflag = 0", model.UnitContent, model.ClassId, model.AccountId); var List_Course_UnitHomeWork = HomeWorkBll.GetList(stbSqlWhere.ToString(), string.Empty); if (List_Course_UnitHomeWork.Count > 0) { var ModelTmp = List_Course_UnitHomeWork[0]; model.Id = ModelTmp.Id; model.Display = ModelTmp.Display; model.Delflag = ModelTmp.Delflag; model.CreateDate = DateTime.Now; model.Score = ModelTmp.Score; model.ScoreCreater = ModelTmp.ScoreCreater; if (HomeWorkBll.Update(model)) { //更新总体进度 this.UpdateOverallProgress(UnitId, ClassId, TrainingId, AccountId, UnitContent); return Json(new { Result = true, Msg = "作业更新成功!" }, JsonRequestBehavior.AllowGet); } else { return Json(new { Result = false, Msg = "作业更新失败!" }, JsonRequestBehavior.AllowGet); } } else { model.Delflag = false; model.Display = true; model.CreateDate = DateTime.Now; model.Score = null; if (HomeWorkBll.Add(model)) { //更新总进度 this.UpdateOverallProgress(UnitId, ClassId, TrainingId, AccountId, UnitContent); return Json(new { Result = true, Msg = "作业新增成功!" }, JsonRequestBehavior.AllowGet); } else { return Json(new { Result = false, Msg = "作业新增失败!" }, JsonRequestBehavior.AllowGet); } } }
/// <summary> /// 查看当前活动是否已打分,若已打分则禁止操作 /// </summary> /// <param name="iClassId"></param> /// <param name="iAccountId"></param> /// <param name="iUnitContent"></param> /// <param name="outScore"></param> /// <returns></returns> private bool GetActivityScore_Task(int iClassId, int iAccountId, int iUnitContent, out double? outScore) { double? dblScore = null; var bolResult = false; var Course_UnitHomeWorkbll = new Course_UnitHomeWorkBLL(); var Model_Course_UnitHomeWork = new Course_UnitHomeWork(); var strWhere_Activity = string.Format(@" Delflag = 0 AND ClassId = {0} AND AccountId = {1} AND UnitContent = {2}", iClassId, iAccountId, iUnitContent); var List_Course_UnitHomeWor = Course_UnitHomeWorkbll.GetList(strWhere_Activity, string.Empty); if (List_Course_UnitHomeWor != null && List_Course_UnitHomeWor.Count > 0) { Model_Course_UnitHomeWork = List_Course_UnitHomeWor[0]; if (Model_Course_UnitHomeWork.Score != null) { bolResult = true; dblScore = Model_Course_UnitHomeWork.Score; } } outScore = dblScore;//返回作业得分 return bolResult; }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Update(Course_UnitHomeWork model) { return dal.Update(model) > 0; }
/// <summary> /// 新增一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool Add(Course_UnitHomeWork model) { return dal.Add(model) > 0; }
public ActionResult LearnOnLineTaskView(int TrainingId, int UnitContent, int ClassId) { #region 作业标题 var Model_Course_UnitContent = this.GetCourseUnitContentActivity(TrainingId, UnitContent, ClassId, false); #endregion #region 获取作业信息 var stbSqlWhere = new StringBuilder(); var Model_Course_UnitHomeWork = new Course_UnitHomeWork(); int iClassId = 0, iTrainingId = 0, iAccountId = 0, iUnitContent = 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); int.TryParse(Convert.ToString(Request["ClassId"]) == "" ? "0" : QueryString.Decrypt(Request["ClassId"]), out iClassId);//获取 ClassId iAccountId = Code.SiteCache.Instance.LoginInfo.UserId; var HomeWorkBll = new Course_UnitHomeWorkBLL(); stbSqlWhere.AppendFormat(@" UnitContent = {0} AND ClassId = {1} AND AccountId = {2} AND Display = 1 AND Delflag = 0", iUnitContent, iClassId, iAccountId); var List_Course_UnitHomeWork = HomeWorkBll.GetList(stbSqlWhere.ToString(), string.Empty); if (List_Course_UnitHomeWork.Count > 0) { Model_Course_UnitHomeWork = List_Course_UnitHomeWork[0]; } ViewBag.Model_Course_UnitHomeWork = Model_Course_UnitHomeWork; #endregion return View(); }
/// <summary> /// 获取分页数据集 /// </summary> /// <param name="pageSize"></param> /// <param name="pageIndex"></param> /// <param name="where"></param> /// <param name="orderBy"></param> /// <param name="recordCount"></param> /// <returns></returns> public List<Course_UnitHomeWork> GetList(int pageSize, int pageIndex, string where, string orderBy, out int recordCount) { if (string.IsNullOrEmpty(orderBy)) throw new ArgumentNullException(); StringBuilder sb = new StringBuilder(); sb.Append("select count(1) from [dbo].[Course_UnitHomeWork]"); if (!string.IsNullOrEmpty(where)) sb.Append(" where " + where); recordCount = Convert.ToInt32(MSEntLibSqlHelper.ExecuteScalarBySql(sb.ToString())); int start = (pageIndex - 1) * pageSize + 1; int end = pageIndex * pageSize; StringBuilder sql = new StringBuilder(); sql.Append("select * from (select *,ROW_NUMBER() over (order by " + orderBy + ") as [RowNum] from [dbo].[Course_UnitHomeWork]"); if (!string.IsNullOrEmpty(where)) sql.Append(" where " + where); sql.Append(") as T where [RowNum] between " + start + " and " + end); List<Course_UnitHomeWork> list = new List<Course_UnitHomeWork>(); using (IDataReader reader = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql.ToString())) { while (reader.Read()) { Course_UnitHomeWork model = new Course_UnitHomeWork(); ConvertToModel(reader, model); list.Add(model); } } return list; }
private void ConvertToModel(IDataReader reader, Course_UnitHomeWork model) { if (reader["Id"] != DBNull.Value) model.Id = Convert.ToInt32(reader["Id"]); if (reader["UnitContent"] != DBNull.Value) model.UnitContent = Convert.ToInt32(reader["UnitContent"]); if (reader["ClassId"] != DBNull.Value) model.ClassId = Convert.ToInt32(reader["ClassId"]); if (reader["Content"] != DBNull.Value) model.Content = reader["Content"].ToString(); if (reader["AccountId"] != DBNull.Value) model.AccountId = Convert.ToInt32(reader["AccountId"]); if (reader["AttList"] != DBNull.Value) model.AttList = reader["AttList"].ToString(); if (reader["Display"] != DBNull.Value) model.Display = Convert.ToBoolean(reader["Display"]); if (reader["Delflag"] != DBNull.Value) model.Delflag = Convert.ToBoolean(reader["Delflag"]); if (reader["CreateDate"] != DBNull.Value) model.CreateDate = Convert.ToDateTime(reader["CreateDate"]); if (reader["Score"] != DBNull.Value) model.Score = Convert.ToDouble(reader["Score"]); if (reader["ScoreCreater"] != DBNull.Value) model.ScoreCreater = Convert.ToInt32(reader["ScoreCreater"]); }
/// <summary> /// 更新一条记录 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update(Course_UnitHomeWork model) { StringBuilder sql = new StringBuilder(); sql.Append("update [dbo].[Course_UnitHomeWork] set "); sql.Append("[UnitContent]=@UnitContent,[ClassId]=@ClassId,[Content]=@Content,[AccountId]=@AccountId,[AttList]=@AttList,[Display]=@Display,[Delflag]=@Delflag,[CreateDate]=@CreateDate,[Score]=@Score,[ScoreCreater]=@ScoreCreater"); sql.Append(" where [Id]=@Id"); SqlParameter[] cmdParams = new SqlParameter[] { new SqlParameter("@Id", SqlDbType.Int, 4) { Value = model.Id }, new SqlParameter("@UnitContent", SqlDbType.Int, 4) { Value = model.UnitContent }, new SqlParameter("@ClassId", SqlDbType.Int, 4) { Value = model.ClassId }, new SqlParameter("@Content", SqlDbType.VarChar, 2000) { Value = model.Content }, new SqlParameter("@AccountId", SqlDbType.Int, 4) { Value = model.AccountId }, new SqlParameter("@AttList", SqlDbType.VarChar, 2000) { Value = model.AttList }, new SqlParameter("@Display", SqlDbType.Bit, 1) { Value = model.Display }, new SqlParameter("@Delflag", SqlDbType.Bit, 1) { Value = model.Delflag }, new SqlParameter("@CreateDate", SqlDbType.DateTime, 8) { Value = model.CreateDate }, new SqlParameter("@Score", SqlDbType.Float, 8) { Value = model.Score }, new SqlParameter("@ScoreCreater", SqlDbType.Int, 4) { Value = model.ScoreCreater } }; return MSEntLibSqlHelper.ExecuteNonQueryBySql(sql.ToString(), cmdParams); }
/// <summary> /// 取得一条记录 /// </summary> /// <param name="id"></param> /// <param name="where"></param> /// <returns></returns> public Course_UnitHomeWork GetModel(int id, string where) { string sql = "select * from [dbo].[Course_UnitHomeWork] where [Id]=@Id"; if (!string.IsNullOrEmpty(where)) sql += " and " + where; SqlParameter[] cmdParams = new SqlParameter[]{ new SqlParameter("@Id", SqlDbType.Int, 4) { Value = id } }; using (IDataReader reader = MSEntLibSqlHelper.ExecuteDataReaderBySql(sql, cmdParams)) { if (reader.Read()) { Course_UnitHomeWork model = new Course_UnitHomeWork(); ConvertToModel(reader, model); return model; } else { return null; } } }