Exemple #1
0
        /// <summary>
        /// 隐藏问题的答案
        /// </summary>
        /// <param name="answerId"></param>
        /// <returns></returns>
        public int HideAnswer(int answerId)
        {
            var answer = GetUserAnswerById(answerId);

            var question = GetQuestionById(answer.QuestionId);

            if (answer.IsHide == 0)
            {
                _dataAccess.ExecuteSql(
                    @"UPDATE Int_Question SET AnswerCount=AnswerCount-1 WHERE QuestionId=(SELECT QuestionId FROM Int_UserAnswer WHERE AnswerId=" +
                    answerId + ")");


                var result = _dataAccess.UpdateField("Int_UserAnswer", "IsHide", "1", "AnswerId=" + answerId);
                SetNewAnswer(question.QuestionId);
                return(result);
            }
            else
            {
                _dataAccess.ExecuteSql(
                    @"UPDATE Int_Question SET AnswerCount=AnswerCount+1 WHERE QuestionId=(SELECT QuestionId FROM Int_UserAnswer WHERE AnswerId=" +
                    answerId + ")");

                SetNewAnswer(question.QuestionId);
                return(_dataAccess.UpdateField("Int_UserAnswer", "IsHide", "0", "AnswerId=" + answerId));
            }
        }
Exemple #2
0
        /// <summary>
        /// 删除单个课程
        /// </summary>
        /// <param name="courseId"></param>
        /// <returns></returns>
        public int DeleteCourse(int courseId)
        {
            BusinessCache.SystemCache.Instance.ClearCourses();
            var result = _dataAccess.UpdateField("Res_Course", "Status", "1", "CourseId=" + courseId);

            DeleteCourseIndex(courseId);
            return(result);
        }
Exemple #3
0
 public bool DeleteAbilitys(IEnumerable <int> abilityId)
 {
     if (abilityId.Count() == 0)
     {
         return(false);
     }
     return(_dataAccess.UpdateField("Ab_AbilityInfo", "IsDelete", "1", string.Format("where AbilityId in ({0}) ", abilityId.GetString())) > 0);
 }
Exemple #4
0
        /// <summary>
        /// 删除版块
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public int DeleteSection(int id)
        {
            var sqlwhere = " SectionId=" + id;

            //主版块下的所有子版块,一起删除
            _dataAccess.UpdateField("bbs_SubSection", "IsDelete", "1", sqlwhere);
            return(_dataAccess.UpdateField("bbs_MainSection", "IsDelete", "1", sqlwhere));
        }
 /// <summary>
 /// 删除站内信
 /// </summary>
 /// <param name="RecordId"></param>
 /// <param name="type">0:删除发件箱;1:删除收件箱</param>
 public void DeleteMessage(int[] RecordId, int type)
 {
     if (type == 0)
     {
         _dataAccess.UpdateField("Sys_UserMessage", "SendStatus", "1", "where RecordId in (" + RecordId.GetString() + ")");
     }
     else
     {
         _dataAccess.UpdateField("Sys_UserMessage", "RecStatus", "2", "where RecordId in (" + RecordId.GetString() + ")");
     }
 }
Exemple #6
0
        /// <summary>
        /// 批量冻结/解冻角色
        /// </summary>
        /// <param name="RoleId"></param>
        /// <returns></returns>
        public bool FreezeRole(int[] RoleId)
        {
            if (RoleId.Length == 0)
            {
                return(false);
            }
            var users = _dataAccess.GetListBySql <SysRole>("select Status,RoleId from Sys_Roles where RoleId in (" + RoleId.GetString() + ") and IsDelete = 0");
            var tmp1  = users.Where(p => p.Status == 0).Select(p => p.RoleId);
            var tmp2  = users.Where(p => p.Status == 1).Select(p => p.RoleId);

            _dataAccess.UpdateField("Sys_Roles", "Status", "1", "RoleId in (" + tmp1.GetString() + ")");
            _dataAccess.UpdateField("Sys_Roles", "Status", "0", "RoleId in (" + tmp2.GetString() + ")");
            return(true);
        }
 /// <summary>
 /// 删除学习班
 /// </summary>
 /// <param name="classIds"></param>
 public void DeleteLearningClass(int[] classIds)
 {
     if (classIds.Length > 0)
     {
         string ids = classIds.GetString();
         //var deleteWhere = "Len_Students.ClassId in (" + ids + ")";
         //_dataAccess.DeleteEntities<LenStudents>(deleteWhere);
         _dataAccess.UpdateField("Len_LearningClass", "IsDeleted", "1", " where Len_LearningClass.ClassId in (" + ids + ")");
     }
 }
Exemple #8
0
        /// <summary>
        /// 批量冻结/解冻用户
        /// </summary>
        /// <param name="userId"></param>
        /// <param name="flag">0-冻结 1-解冻</param>
        /// <returns></returns>
        public bool FreezeUser(int[] userId, int flag = 0)
        {
            if (userId.Length == 0)
            {
                return(false);
            }
            var users = _dataAccess.GetListBySql <SysUser>("select Status,UserId from Sys_Users where UserId in (" + userId.GetString() + ") and IsDelete = 0");
            var tmp1  = users.Where(p => p.Status == 0).Select(p => p.UserId);
            var tmp2  = users.Where(p => p.Status == 1).Select(p => p.UserId);

            if (flag == 1)
            {
                _dataAccess.UpdateField("Sys_Users", "Status", "0", "UserId in (" + tmp2.GetString() + ")");
            }
            else
            {
                _dataAccess.UpdateField("Sys_Users", "Status", "1", "UserId in (" + tmp1.GetString() + ")");
            }
            return(true);
        }
Exemple #9
0
        /// <summary>
        /// 批量冻结/解冻服务中心
        /// </summary>
        /// <param name="deptId"></param>
        /// <param name="flag">0-冻结 1-解冻</param>
        /// <returns></returns>
        public bool FreezeDept(int[] deptId, int flag = 0)
        {
            if (deptId.Length == 0)
            {
                return(false);
            }
            var users = _dataAccess.GetListBySql <SysDepartment>("select Status,DepartmentId from Sys_Department where DepartmentId in (" + deptId.GetString() + ") and IsDelete = 0");
            var tmp1  = users.Where(p => p.Status == 0).Select(p => p.DepartmentId);
            var tmp2  = users.Where(p => p.Status == 1).Select(p => p.DepartmentId);

            if (flag == 1)
            {
                _dataAccess.UpdateField("Sys_Department", "Status", "0", "DepartmentId in (" + tmp2.GetString() + ")");
            }
            else
            {
                _dataAccess.UpdateField("Sys_Department", "Status", "1", "DepartmentId in (" + tmp1.GetString() + ")");
            }
            return(true);
        }
Exemple #10
0
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool DeleteGroup(int GroupId)
        {
            var doflag = _dataAccess.UpdateField("Int_Group", "IsDelete", "1", " GroupId = " + GroupId) > 0;

            if (doflag)
            {
                _dataAccess.UpdateField("Int_GroupTopic", "IsDelete", "1", " GroupId = " + GroupId);
            }
            return(doflag);
        }
Exemple #11
0
        /// <summary>
        /// 刷新在线时间
        /// </summary>
        public static void SetAlive()
        {
            var session = new SessionManager.SessionExt(HttpContext.Current);

            if (!session.Exists("login-logId"))
            {
                return;
            }
            lock (lkhelp)
            {
                var exec  = false;//是否需要执行数据库更新操作
                var logId = (int)session["login-logId"];
                if (lastUpDateTimes.ContainsKey(logId))
                {
                    var lastTime = lastUpDateTimes[logId];
                    if ((DateTime.Now - lastTime).TotalMinutes >= 1)
                    {
                        exec = true;
                        lastUpDateTimes[logId] = DateTime.Now;
                    }
                }
                else
                {
                    lastUpDateTimes.Add(logId, DateTime.Now);
                    exec = true;
                }
                if (exec)
                {
                    SysLoginLog log = _dataAccess.Get <SysLoginLog>(logId);
                    if (log == null)
                    {
                        return;
                    }
                    log.LogoutTime = DateTime.Now;
                    _dataAccess.UpdateField("Sys_LoginLog", "LogoutTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
                                            "Sys_LoginLog.LogId=" + logId);
                }
            }
        }
Exemple #12
0
        public int ChangeResourcesSort(int sortId, int newSort)
        {
            _dataAccess.UpdateField("KL_Resource", "LastUpdateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
                                    "SortId=" + sortId);

            var result = _dataAccess.UpdateField("KL_Resource", "SortId", newSort.ToString(), "SortId=" + sortId);

            var sort = _dataAccess.Get <KL_KnowledgeSort>(newSort);
            var ks   = _dataAccess.FetchListBySql <KL_Resource>("SortId=" + sortId);

            foreach (var resource in ks)
            {
                FullTextSearchProvider.UpdateIndex <KL_Resource>("knowledge", resource.ResourceId,
                                                                 new { sortId = newSort, sortName = sort.SortName, levelPath = sort.LevelPath }, true);
            }

            return(result);
        }
Exemple #13
0
        /// <summary>
        /// 批量修改租户状态
        /// </summary>
        /// <param name="tids">租户id 数组</param>
        /// <param name="status">新状态</param>
        /// <returns></returns>
        public int ChangeStatus(int[] tids, int status)
        {
            var sqlwhere = "Sys_Tenant.TenantId IN (" + tids.GetString() + ")";

            return(_dataAccess.UpdateField("Sys_Tenant", "Status", status.ToString(), sqlwhere));
        }
Exemple #14
0
        /// <summary>
        /// 计算每个人的各项指标得分
        /// <para>返回</para>
        /// <para>0:成功</para>
        /// <para>1:计算中</para>
        /// <para>2:已计算</para>
        /// <para>3:计算失败</para>
        /// </summary>
        /// <param name="examId"></param>
        /// <returns></returns>
        public int DoExamUserQuestionIndexScore(int examId)
        {
            var exam = _examinationDb.GetSingleById <TalExamination>(examId);
            int flag = 1;

            try
            {
                if (exam.ScoreCalculationStatus > 0)
                {
                    return(exam.ScoreCalculationStatus);
                }
                exam.ScoreCalculationStatus = 1;
                _examinationDb.Modify <TalExamination>(exam);

                var examUserList              = _examinationDb.GetAllList <TalExamSendStudent>(Query.And(Query.EQ("Status", 0), Query.EQ("SourceType", 0), Query.EQ("RelationID", examId)));
                var doExamUserIds             = examUserList.Where(p => p.DoExamStatus >= 2).Select(p => p._id);
                var examUserQuestionScoreList = _examinationDb.GetAllList <TalExamSendStudentQuestionIndexScore>(Query.EQ("ExamId", examId));
                var exampaper       = _examinationDb.GetSingleById <TalExampaperRedundancy>(exam.PaperID);
                var examUserListTmp = examUserList.Where(p => !examUserQuestionScoreList.Any(eu => eu.ExamSendId == p._id));


                var firstIndex  = exampaper.QuestionIndexList.Where(p => p.FatherID == 0).Select(p => p._id);
                var secondIndex = exampaper.QuestionIndexList.Where(p => p.FatherID > 0).Select(p => p._id);

                //统计出每个人每个二级指标的实际得分
                foreach (var item in examUserListTmp)
                {
                    foreach (var qIndex in secondIndex)
                    {
                        examUserQuestionScoreList.Add(new TalExamSendStudentQuestionIndexScore
                        {
                            UserId  = item.UserID,
                            IndexId = qIndex,
                            Score   = 0
                        });
                    }
                }
                //根据9分法规则,统计出每个人每个二级指标的得分
                foreach (var item in secondIndex)
                {
                    var userScore = examUserQuestionScoreList.Where(p => p.IndexId == item && doExamUserIds.Contains(p.ExamSendId));
                    var tmpScore  = userScore.Select(p => p.Score).Distinct().OrderByDescending(p => p).ToList();
                    if (tmpScore.Contains(0))
                    {
                        tmpScore.Remove(0);
                    }
                    if (tmpScore.Count > 0)
                    {
                        var fen = new List <double> {
                            0.04, 0.11, 0.23, 0.4, 0.6, 0.77, 0.89, 0.96, 1
                        };
                        for (int i = 9; i >= 2; i--)
                        {
                            int index = (int)(tmpScore.Count * fen[9 - i]);
                            index = index >= tmpScore.Count ? tmpScore.Count - 1 : index;
                            var line = tmpScore[index];
                            foreach (var u in userScore)
                            {
                                if (u.NineScore == 0 && u.Score >= line)
                                {
                                    u.NineScore = i;
                                }
                                if (u.NineScore == 0 && i == 2 && u.Score > 0)
                                {
                                    u.NineScore = 1;
                                }
                            }
                        }
                    }
                }
                //通过权重,给每个人算一级指标的分值
                foreach (var item in examUserList)
                {
                    var userScore = examUserQuestionScoreList.Where(p => p.UserId == item.UserID).ToList();
                    foreach (var qIndex in firstIndex)
                    {
                        var   tmp = exampaper.QuestionIndexList.Where(p => p.FatherID == qIndex);
                        float all = 0;
                        foreach (var u in userScore.Where(p => tmp.Any(t => t._id == p.IndexId)))
                        {
                            all += u.NineScore * tmp.First(p => p._id == u.IndexId).weight / 100;
                        }
                        userScore.Add(new TalExamSendStudentQuestionIndexScore
                        {
                            IndexId   = qIndex,
                            NineScore = all,
                            UserId    = item.UserID
                        });
                    }
                    item.UserQuestionIndexWeightScore.Clear();
                    float s = 0;
                    foreach (var u in userScore)
                    {
                        var t = exampaper.QuestionIndexList.Find(p => p._id == u.IndexId);
                        item.UserQuestionIndexWeightScore.Add(new TalUserQuestionIndexWeightScore
                        {
                            _id      = u.IndexId,
                            FatherID = t.FatherID,
                            score    = u.NineScore,
                            weight   = t.weight
                        });
                        if (t.FatherID == 0)
                        {
                            s += u.NineScore * t.weight / 100;
                        }
                    }
                    if (exam.ExamLength * 60 - item.RemainingTime < 600)
                    {
                        item.CancellationCause = 1; item.CancellationTime = DateTime.Now; item.CancellationStatus = 1;
                    }
                    if (exampaper.QuestionList.Count > 10 ? item.StudentAnswerList.Count(p => p.DoneFlag == 1) < 10 : false)
                    {
                        item.CancellationCause = 2; item.CancellationTime = DateTime.Now; item.CancellationStatus = 1;
                    }
                    if (item.CancellationStatus == 1)
                    {
                        _dataAccess.UpdateField("Sys_Users", "Freezed", "1", "UserId = " + item.UserID);
                    }

                    item.Score = s;
                    //1星:总分∈[1,2.994),不推荐;
                    //2星:总分∈[2.994,4.994),慎重使用;
                    //3星:总分∈[4.994,6.494),推荐使用;
                    //4星:总分∈[6.494,7.994),积极推荐;
                    //5星:总分∈[7.994,9],强烈推荐
                    item.UserLevel = 0;
                    if (item.Score >= 1 && item.Score < 2.994)
                    {
                        item.UserLevel = 1;
                    }
                    else if (item.Score >= 2.994 && item.Score < 4.994)
                    {
                        item.UserLevel = 2;
                    }
                    else if (item.Score >= 4.994 && item.Score < 6.494)
                    {
                        item.UserLevel = 3;
                    }
                    else if (item.Score >= 6.494 && item.Score < 7.994)
                    {
                        item.UserLevel = 4;
                    }
                    else if (item.Score >= 7.994)
                    {
                        item.UserLevel = 5;
                    }
                    _examinationDb.Modify <TalExamSendStudent>(item);
                }
                exam.ScoreCalculationStatus = 2;
                _examinationDb.Modify <TalExamination>(exam);
                flag = 0;
            }
            catch
            {
                flag = 3;
            }
            finally
            {
                if (flag == 3)
                {
                    exam.ScoreCalculationStatus = 0;
                    _examinationDb.Modify <TalExamination>(exam);
                }
            }
            return(flag);
        }
Exemple #15
0
 public bool ChangeSurveyStatus(int sendUserId, int status)
 {
     return
         (_dataAccess.UpdateField("Cde_SurveySendUsers", "Status", status.ToString(CultureInfo.InvariantCulture),
                                  "SendUserId=" + sendUserId.ToString(CultureInfo.InvariantCulture)) > 0);
 }
Exemple #16
0
 public bool DeleteSurveyInfo(SurveyInfo surveyInfo)
 {
     return(_dataAccess.UpdateField("Cde_SurveyInfo", "IsDelete", "1",
                                    "Cde_SurveyInfo.SurveyId=" + surveyInfo.SurveyId) > 0);
 }
Exemple #17
0
 public void DeleteNotes(int[] noteID)
 {
     _dataAccess.UpdateField("Sys_Notes", "IsDelete", "1", "where noteId in (" + noteID.GetString() + ")");
 }
Exemple #18
0
 /// <summary>
 ///     批量删除书籍,返回受影响的行数
 /// </summary>
 /// <param name="ids">书籍ids</param>
 /// <returns></returns>
 public bool DeleteEBook(int[] ids)
 {
     return(_dataAccess.UpdateField("Res_EBook", "IsDelete", "1", string.Format("where BookId in ({0})", ids.GetString())) > 0);
 }
Exemple #19
0
 public int DeleteUserLevel(int id)
 {
     return(_dataAccess.UpdateField("Int_UserLevel", "IsDelete", "1", "LevelId=" + id));
 }
Exemple #20
0
        public bool DeleteExampaper(int id)
        {
            int result = _dataAccess.UpdateField("Cde_SurveyExampaper", "IsDelete", "1", "ExampaperID=" + id);

            return(result > 0);
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="id"></param>
        /// <param name="isEnabled"></param>
        /// <returns></returns>
        public int EnableRule(int id, bool isEnabled = true)
        {
            var sqlwhere = "Int_IntegralRule.RuleId=" + id;

            return(_dataAccess.UpdateField("Int_IntegralRule", "IsEnabled", isEnabled ? "1" : "0", sqlwhere));
        }
Exemple #22
0
 /// <summary>
 /// 删除资源
 /// </summary>
 /// <param name="ids"></param>
 /// <returns></returns>
 public int DeleteResource(string ids)
 {
     return(_dataAccess.UpdateField("Res_Resource", "Status", "-1", string.Format(" Id in ({0})", ids)));
 }
Exemple #23
0
 /// <summary>
 /// 删除一条数据
 /// </summary>
 public bool Delete(int applyId)
 {
     return(_dataAccess.UpdateField("Ab_PromotionApply", "IsDelete", "1", "ApplyId=" + applyId) > 0);
 }
Exemple #24
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="ids"></param>
 /// <returns></returns>
 public int BatchDelete(int[] ids)
 {
     return(_dataAccess.UpdateField("Sys_Admin", "IsDelete", "1", "AdminId IN (" + ids.GetString() + ")"));
 }
Exemple #25
0
 public bool DeleteReport(int reportId)
 {
     return(_dataAccess.UpdateField("Cde_Report", "IsDelete", "1", "ReportId=" + reportId) > 0);
 }
Exemple #26
0
 public bool DeletePromotionWay(int promotionId)
 {
     return(_dataAccess.UpdateField("Ab_PromotionWay", "IsDelete", "1", "where PromotionId = " + promotionId) > 0);
 }
Exemple #27
0
 public int Delete(int planId)
 {
     return(_dataAccess.UpdateField("Len_LearnPlan", "Status", "1", " Len_LearnPlan.PlanId=" + planId));
 }
 /// <summary>
 ///
 /// </summary>
 /// <param name="ids"></param>
 /// <returns></returns>
 public int DeleteTemplate(int[] ids)
 {
     return(_dataAccess.UpdateField("Sys_ReasonTemplate", "Status", "1", string.Format(" TempId in ({0})", ids.GetString())));
 }
Exemple #29
0
 /// <summary>
 ///
 /// </summary>
 /// <param name="deptId"></param>
 /// <param name="postId"></param>
 /// <returns></returns>
 public bool UpdatePostDeptId(int deptId, int[] postId)
 {
     return(_dataAccess.UpdateField("Sys_Posts", "DeptId", deptId.ToString(), "where PostId in (" + postId.GetString() + ")") > 0);
 }
Exemple #30
0
 /// <summary>
 ///     根据ID删除单个实体(假删)
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public bool DeleteByID(int id)
 {
     return(_dataAccess.UpdateField("KL_KnowledgeSort", "IsDelete", "1", "SortId=" + id) > 0);
 }