/// <summary> /// 设置配置值 /// </summary> /// <param name="conf"></param> /// <param name="tenantId"></param> /// <param name="value"></param> public static void SetConfig(Configs conf, int tenantId, object value) { string val; if (value == null) { val = ""; } else { val = value.ToString(); } var sqlwhere = "Sys_Config.ConfigName=@name AND Sys_Config.TenantId=@tenantId"; var config = DataAccess.GetList <Models.SysConfig>(sqlwhere, new { name = conf.ToString(), tenantId }).FirstOrDefault(); if (config == null) { config = new Models.SysConfig() { ConfigCode = conf.ToString(), ConfigName = conf.ToString(), ConfigValue = val, TenantId = tenantId }; DataAccess.AddEntity(config); } else { config.ConfigValue = val; DataAccess.UpdateEntity(config); } }
/// <summary> /// 所有的考试 /// </summary> /// <param name="classId"></param> /// <returns></returns> public List <Tr_TrainClassToExam> GetClassExamShow(int classId) { var examList = _dataAccess.GetList <Tr_TrainClassToExam>(" Tr_TrainClassToExam.IsDelete=0 and ClassId=" + classId); if (examList.Any()) { var dbExamList = _examinationDb.GetAllExamination(examList.Select(p => p.ExamID)); var dbPaperList = _exampaperDb.GetExampaperRedundancyList(); foreach (var exam in examList) { if (exam.ExamID > 0) { tbExamination model = dbExamList.FirstOrDefault(p => p._id == exam.ExamID); tbExampaperRedundancy paper = dbPaperList.FirstOrDefault(p => p.ExampaperId == model.PaperID); exam.PaperID = paper != null ? paper._id : 0; exam.Papername = paper != null ? paper.ExampaperTitle : "--"; exam.TestTimes = model.TestTimes; exam.RadomOrderFlag = model.RadomOrderFlag; exam.PassScore = model.PassScore; } } } return(examList); }
public void LoadSendUsers(SurveyInfo surveyInfo) { var sqlwhere = "Cde_UserSurvey.SurveyId=" + surveyInfo.SurveyId; var sendusers = _dataAccess.GetList <UserSurvey>(sqlwhere); surveyInfo.EvalUsers.AddRange(sendusers); }
public Cde_SurveyExampaper GetFullExampaper(int id) { var exampaper = GetExampaper(id); if (exampaper == null) { return(null); } var questions = _dataAccess.GetListBySql <Cde_IndexQuestion>(@"SELECT sq.ShowOrder, iq.* ,s1.SortName,s2.SortName AS SecondSortName FROM Cde_SurveyQuestion sq JOIN Cde_IndexQuestion iq ON iq.QuestionId = sq.QuestionID LEFT JOIN Cde_IndexSort s1 ON s1.SortId = iq.SortId LEFT JOIN Cde_IndexSort s2 ON s2.SortId=iq.SecondSortId WHERE sq.ExampaperID = " + id + " ORDER BY sq.ShowOrder"); var answers = _dataAccess.GetList <Cde_IndexQuestionAnswer>(" Cde_IndexQuestionAnswer.QuestionId IN (" + questions.Select(p => p.QuestionId).GetString() + ") "); exampaper.Questions.AddRange(questions); foreach (var question in questions) { question.Answers.AddRange(answers.Where(p => p.QuestionId == question.QuestionId)); } return(exampaper); }
public void LoadOpenUsers(KL_Resource resource) { var sqlwhere = "KL_KnowledgeOpenUser.ResourceId=" + resource.ResourceId; resource.OpenUsers.Clear(); resource.OpenUsers.AddRange(_dataAccess.GetList <KL_KnowledgeOpenUser>(sqlwhere)); }
public UserSurvey GetUserSurvey(int userId, int surveyId) { var sqlwhere = "SurveyId=" + surveyId + " AND UserId=" + userId; var model = _dataAccess.GetList <UserSurvey>(sqlwhere).FirstOrDefault(); return(model); }
/// <summary> /// 获取部门列表 /// </summary> /// <param name="ids"></param> /// <returns></returns> public List <SysDepartment> GetDeptList(string ids) { var deptList = _dataAccess.GetList <SysDepartment>(string.Format(" DeptId in ({0})", ids.TrimEnd(',').TrimStart(','))); return(deptList); }
/// <summary> /// 获取子分类 /// </summary> /// <param name="tenantId"></param> /// <param name="categoryId"></param> /// <returns></returns> public IEnumerable <EBookCategory> GetAllChilds(int tenantId, int categoryId) { var allsorts = _dataAccess.GetList <EBookCategory>("Res_EBookCategory.IsDelete = 0 and Res_EBookCategory.TenantId = " + tenantId); var list = new List <EBookCategory>(); GetSortChilds(categoryId, allsorts, list); return(list); }
/// <summary> /// 获得培训班报名管理列表页 /// </summary> /// <param name="totalCount"></param> /// <param name="classType"></param> /// <param name="deptId"></param> /// <param name="trainname"></param> /// <param name="traincode"></param> /// <param name="username"></param> /// <param name="signupstatus"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public List <TrainClassSignUpShow> GetClassSignUpList(out int totalCount, int classType, int deptId, string trainname, string traincode , string username, int signupstatus, int pageIndex, int pageSize) { var sqlwhere = " and tt.IsDelete=0 and tt.IsSignUp=1 "; if (classType > -1) { sqlwhere += " and tt.ClassType =" + classType.ToString(CultureInfo.CurrentCulture); } if (!string.IsNullOrEmpty(trainname)) { sqlwhere += string.Format(" AND tt.TrainName like '%{0}%'", trainname.ReplaceSql()); } if (!string.IsNullOrEmpty(traincode)) { sqlwhere += string.Format(" AND tt.Code like '%{0}%'", traincode.ReplaceSql()); } if (!string.IsNullOrEmpty(username)) { sqlwhere += string.Format(" AND tt.Realname like '%{0}%'", username.ReplaceSql()); } if (signupstatus != -1) { sqlwhere += " and tt.SignUpCondition=" + signupstatus.ToString(CultureInfo.CurrentCulture); } if (deptId > 0) { var deptIds = new List <int> { deptId }; var deptList = _dataAccess.GetList <SysDepartment>("Sys_Department.Status = 0 "); GetChildDeptIds(deptId, deptList, deptIds); sqlwhere += " AND syu.DeptId in (" + deptIds.GetString() + ") "; } string sql = string.Format(@"SELECT * FROM ( SELECT row_number()OVER(ORDER BY tt.ClassId desc) RowIndex,count(1)OVER(PARTITION BY null) totalCount ,tp.TrainName,ClassId, ClassType, Code,tt.Number,OldClassId,sd.DeptName,syu.Realname,tt.SignUpCondition,tt.SignUpEndTime, (select count(*) from Tr_TrainClassToUser tc where tc.ClassId=tt.ClassId and tc.IsDelete=0) SignUpUser, (select count(*) from Tr_TrainClassToUser tc where tc.ClassId=tt.ClassId and tc.IsDelete=0 and tc.ApproveStatus=1 ) SignUpApprovalUser FROM Tr_TrainClass tt LEFT JOIN Tr_PlanClass tp ON tp.PlanClassID=tt.PlanClassId LEFT JOIN Sys_Department sd ON sd.DeptId=tt.DeptID LEFT JOIN Sys_Users syu ON syu.UserId=tt.CreateUserID WHERE tt.ApproveStatus=2 AND tt.IsDelete=0 {0} )result WHERE RowIndex BETWEEN @startLength*(@startIndex-1)+1 AND @startLength*@startIndex", sqlwhere); var param = new { startIndex = pageIndex, startLength = pageSize }; var list = _dataAccess.FetchListBySql <TrainClassSignUpShow>(sql, param); totalCount = list.Any() ? list.FirstOrDefault().totalCount : 0; return(list.ToList()); }
public IEnumerable <KL_CategorySubscription> GetSubscriptions(int userId) { var list = _dataAccess.GetList <KL_CategorySubscription>("KL_CategorySubscription.UserId=" + userId); foreach (var subscription in list) { subscription.FirstCategoryName = AllSorts.First(p => p.SortId == subscription.FirstCategory).SortName; subscription.SecondCategoryName = AllSorts.First(p => p.SortId == subscription.CategoryId).SortName; } return(list); }
/// <summary> /// /// </summary> /// <returns></returns> public List <SysPermission> GetAllPermissions() { var list = _dataAccess.GetList <SysPermission>("Sys_Permission.Status=0 ORDER BY Sort"); foreach (var function in list) { //function.Father = list.FirstOrDefault(p => p.PermissionId == function.ParentId); function.Childrens.AddRange(list.Where(p => p.ParentId == function.PermissionId)); } return(list); }
public Cde_Report GetReport(int userSurveyId) { var report = _dataAccess.GetList <Cde_Report>("Cde_Report.UserSurveyId=" + userSurveyId).FirstOrDefault(); if (report != null) { var indexs = _dataAccess.GetList <Cde_ReportIndex>("Cde_ReportIndex.ReportId=" + report.ReportId); report.IndexList.AddRange(indexs); } return(report); }
/// <summary> /// 获取系统中所有的权限 /// </summary> /// <returns></returns> public List <SysPermission> GetAllPermissions(int type) { var where = string.Format(@"Sys_Permission.Status=0 and UserType={0} ORDER BY Sort", type); var list = _dataAccess.GetList <SysPermission>(where); foreach (var function in list) { //function.Father = list.FirstOrDefault(p => p.PermissionId == function.ParentId); function.Childrens.AddRange(list.Where(p => p.ParentId == function.PermissionId)); } return(list); }
/// <summary> ///施教机构 系统中所有的权限 /// </summary> public List <SysPermission> Permissions(int tenantId) { var cacheKey = "permissions_" + tenantId; CacheHelper.CacheService.Remove(cacheKey); var list = CacheHelper.CacheService.GetList <SysPermission>(cacheKey); if (list == null || !list.Any()) { list = _dataAccess.GetList <SysPermission>("PermissionId IN (SELECT PermissionId FROM Sys_TenantPermission WHERE TenantId=" + tenantId + ") AND Status=0 "); CacheHelper.CacheService.SetList(cacheKey, list, CachingExpirationType.Invariable); } return(list.ToList()); }
/// <summary> /// 出发特定的积分事件 /// </summary> /// <param name="ruleCode">规则代码</param> /// <param name="userId">用户id</param> /// <param name="tenantId">租户Id</param> /// <returns></returns> public int FireIntegrationEvent(IntegrationEvents ruleCode, int userId, int tenantId) { var code = ruleCode.ToString(); if (!IntegrationRules.Instance.IsExistsCode(code)) { //规则代码不匹配 throw new Exception("规则代码不匹配"); } //找到规则 var rule = _dataAccess.GetList <IntegralRule>(string.Format("IsEnabled=1 AND RuleCode='{0}' AND TenantId={1}", ruleCode, tenantId)).FirstOrDefault(); if (rule == null) { //该租户木有配置规则 return(0); } //判断规则周期 var startTime = DateTime.Now; switch (rule.TimeRange) { case -1: startTime = new DateTime(1901, 1, 1); rule.MaxTimes = 1; break; case 0: AddIntegration(rule.RuleId, rule.Integral, userId, tenantId); return(rule.Integral); case 2: startTime = startTime.Accuracy("h"); break; case 3: startTime = startTime.Accuracy("d"); break; } //查找本周期内,积分奖惩次数 var count = _dataAccess.GetCount <UserIntegral>(string.Format("Int_UserIntegral.RuleId={0} AND Int_UserIntegral.TimeToGet>'{1}' AND Int_UserIntegral.UserId={2}", rule.RuleId, startTime.ToString("yyyy-MM-dd HH:mm:00"), userId)); if (count >= rule.MaxTimes) { return(0); } AddIntegration(rule.RuleId, rule.Integral, userId, tenantId, rule.RuleDesc); return(rule.Integral); }
/// <summary> /// 初始化一个租户角色和其权限 /// </summary> /// <param name="TenantId"></param> /// <returns>返回角色ID</returns> public int IntiRole(int tenantId) { var result = 0; var roleId = 0; var single = _dataAccess.GetList <SysRole>(" IsDefault=1 and TenantId=" + tenantId).FirstOrDefault(); var role = new SysRole { RoleName = "默认角色", Description = "默认角色", TenantId = tenantId, CreateTime = DateTime.Now, IsDefault = 1, Status = 0, IsDelete = 0 }; if (single != null) { roleId = single.RoleId; role.RoleId = roleId; _dataAccess.UpdateEntity(role); } else { roleId = _dataAccess.AddEntity(role); } if (roleId > 0) { IntiRoleRight(roleId, tenantId); } return(roleId); }
/// <summary> /// /// </summary> /// <param name="courseId"></param> /// <returns></returns> public List <ResCourseToExam> LoadCourseExaminations(int courseId) { var sqlwhere = "Res_CourseToExam.CourseId=" + courseId; var list = _dataAccess.GetList <ResCourseToExam>(sqlwhere); if (list.Count > 0) { var manager = new RetechWing.BusinessCommon.Examination.ExaminationCommonMethod();// ExampaperDb(); var exampaperRedundancys = manager.GetAllExampaperRedundancy(list.Select(p => p.ExampaperId)); var sortlist = manager.GetAllListByTenantId <RetechWing.Models.Exam.DBModels.tbExampaperSort>(false, exampaperRedundancys.First().TenantId); foreach (var exam in list) { var tmp = exampaperRedundancys.FirstOrDefault(p => p._id == exam.ExampaperId); if (tmp == null) { list.Remove(exam); continue; } exam.Exampaper = tmp; exam.ExampaperId = tmp.ExampaperId; exam.ExampaperRedundancyId = tmp._id; exam.SortName = sortlist.Any(p => p._id == tmp.ExamSortID) ? sortlist.Find(p => p._id == tmp.ExamSortID).Title : ""; } } return(list); }
/// <summary> /// 绑定用户到微信帐户,如果该openID已经绑定则取消原有,绑定新的 /// </summary> /// <param name="userId"></param> /// <param name="openId"></param> public void BindingUserAccount(int userId, string openId) { var model = _dataAccess.GetList <Wx_BindingAccount>(string.Format("openid = '{0}'", openId)).FirstOrDefault(); if (model == null) { _dataAccess.AddEntity(new Wx_BindingAccount { OpenID = openId, UserId = userId }); } else if (model.UserId != userId) { model.UserId = userId; _dataAccess.UpdateEntity(model); } }
/// <summary> /// 根据部门id获得审批流程 /// </summary> /// <param name="deptId">部门id</param> /// <param name="wayType"> /// 路径类型 /// 0:培训 /// 1:晋升学习 /// </param> /// <param name="approveStepList">返回流程的步骤</param> /// <param name="approveDeptList">返回流程的适用部门</param> /// <param name="canUpdate">是否能修改流程,代表是自己新建的还是强制被覆盖的</param> /// <returns>返回0代表可以新建流程,否则返回流程wayid</returns> public ApproveWay GetApproveWay(int deptId, int wayType, out List <ApproveStep> approveStepList, out List <ApproveDept> approveDeptList, out bool canUpdate) { //找到部门所用流程 var approvedepts = _dataAccess.GetList <ApproveDept>("Ap_ApproveDept.DeptId=" + deptId + " and Ap_ApproveWay.WayType=" + wayType + " and Ap_ApproveDept.IsDelete=0 and Ap_ApproveWay.IsDelete=0"); //没有限定流程,可以新建 if (approvedepts.Count == 0) { approveDeptList = new List <ApproveDept> { new ApproveDept { DeptId = deptId } }; approveStepList = new List <ApproveStep>(); canUpdate = true; return(new ApproveWay()); } //限定流程 if (approvedepts.Count == 1) { var approvedept = approvedepts.FirstOrDefault(); //如果是自己创建的,可以修改 if (approvedept.DeptId == approvedept.ApproveWay_DeptId) { canUpdate = true; approveDeptList = _dataAccess.GetList <ApproveDept>("Ap_ApproveDept.WayId=" + approvedept.WayId + " and Ap_ApproveDept.IsDelete=0"); } //不是自己创建的,只能查看 else { canUpdate = false; approveDeptList = new List <ApproveDept>(); } //步骤获取 approveStepList = _dataAccess.GetList <ApproveStep>("Ap_ApproveStep.WayId=" + approvedept.WayId + " Order by Ap_ApproveStep.OrderNum"); return(_dataAccess.Get <ApproveWay>(approvedept.WayId)); } throw new Exception(RetechWing.LanguageResources.Other.MultipleApprovalProcess); }
/// <summary> /// 学习指派 /// </summary> /// <param name="designateUser">指派者ID</param> /// <param name="userId">被指派者id</param> /// <returns></returns> public void GetDesignateDetail(int designateUser, int userId) { var userCourseListSql = string.Format(@"SELECT distinct u.UserId,u.Username,u.Realname,u.Sex,u.UserCode,dp.LevelPath,p.PostName,d.CourseId FROM Len_DesignateCourse d LEFT JOIN Sys_Users u ON u.UserId=d.UserId LEFT JOIN Sys_Department dp ON u.DeptId=dp.DeptId LEFT JOIN Sys_Posts p ON u.PostId=p.PostId WHERE DesignateUser={0} AND d.InfoType IN(0) and u.UserId={1}", designateUser, userId); var userCourseList = _dataAccess.FetchListBySql <DesignateUserList>(userCourseListSql); var courseIds = userCourseList.Select(p => p.CourseId).Distinct().GetString(); string[] courseId = courseIds.Split(','); //更新学习记录 if (userCourseList.Any()) { // var sql = string.Format(@"DELETE FROM dbo.Len_LearningRecord WHERE UserId = {0} AND CourseId IN ({1}) //AND LearnPath=0 AND SourceId=0 ", userId, courseIds); // var DeletelearnRecords = _dataAccess.ExecuteSql(sql); List <LenLearningRecord> learnRecords = new List <LenLearningRecord>(); foreach (var item in courseId) { var learnRecord = _dataAccess.GetList <LenLearningRecord>(string.Format(@"WHERE UserId = ({0}) AND CourseId = ({1}) AND LearnPath=0 AND SourceId=0 ", userId, Convert.ToInt32(item))); if (learnRecord.Count > 0) { _dataAccess.UpdateFieldCalc("dbo.Len_LearningRecord", "LearnProcess", "2", "where RecordId=" + learnRecord[0].RecordId); } else { LenLearningRecord lr = new LenLearningRecord(); lr.CourseId = Convert.ToInt32(item); lr.UserId = userId; lr.LearnProcess = 2; lr.LearnPath = 0; lr.SourceId = 0; lr.StartTime = DateTime.Now; lr.EndTime = DateTime.Now; lr.LastLearnTime = DateTime.Now; _dataAccess.AddEntity(lr); } } } }
/// <summary> /// 添加标签,返回ID /// 如果已经存在,则返回ID /// </summary> /// <param name="tag"></param> /// <returns></returns> public int Insert(KL_Tags tag) { var list = _dataAccess.GetList <KL_Tags>(string.Format(" KL_Tags.TenantId = {0} and KL_Tags.TagName = '{1}'", tag.TenantId, tag.TagName.ReplaceSql())); if (list.Count > 0) { return(list[0].TagId); } _dataAccess.AddEntity(tag); return(tag.TagId); }
/// <summary> /// 获得数据列表 /// </summary> public List <PromotionApply> GetList(string strWhere) { var list = _dataAccess.GetList <PromotionApply>(strWhere); if (list.Count == 0) { return(list); } var ways = _dataAccess.GetList <PromotionWay>("Ab_PromotionWay.IsDelete=0 AND PromotionId IN (" + list.Select(p => p.PromotionId).GetString() + ")"); var stages = _dataAccess.GetList <PromotionStage>("Ab_PromotionStage.IsDelete=0 AND PromotionId IN (" + list.Select(p => p.PromotionId).GetString() + ")"); list = list.FindAll(p => ways.Any(w => w.PromotionId == p.PromotionId)); foreach (var way in ways) { way.Stages.AddRange(stages.Where(p => p.PromotionId == way.PromotionId).OrderBy(p => p.OrderNum)); list.First(p => p.PromotionId == way.PromotionId).PromotionWay = way; } return(list); }
/// <summary> /// 租户下所有的用户 /// </summary> /// <returns></returns> public IEnumerable <SysUser> SystemUser() { var cacheKey = "users"; var list = CacheHelper.CacheService.GetList <SysUser>(cacheKey); if (list == null || !list.Any()) { list = _dataAccess.GetList <SysUser>(); CacheHelper.CacheService.SetList(cacheKey, list, CachingExpirationType.Stable); } return(list); }
/// <summary> /// 创建小组,创建用户,并把两者进行关联 /// 审批 or 发布 成功时,执行 /// </summary> /// <param name="trainId"></param> public void TrainUserJoinGroup(int trainId) { if (string.IsNullOrWhiteSpace(mysqlconnectionString)) { return; } var train = _dataAccess.Get <TrTrainingInfo>(trainId); if (train.Status != 4) { return; } var detailList = _dataAccess.GetList <TrTrainDetail>("Tr_TrainDetail.IsDeleted = 0 and Tr_TrainDetail.TrainId = " + trainId); var userids = _dataAccess.FetchListBySql <int>(string.Format(@" select userId from Tr_TrainUser where trainId = {0} union select userId from Tr_TrainRegister where ApplyStatus = 2 and Tr_TrainRegister.TrainId = {0}", trainId)); var ofuser = GetofUsers(); var ofuserids = new List <int>(); int o; foreach (var item in ofuser) { if (int.TryParse(item.username, out o)) { ofuserids.Add(o); } } //var ofuserids = GetofUsers().Select(p => Convert.ToInt32(p.username)); var tmpuserid = userids.Where(p => !ofuserids.Contains(p)).ToList(); if (tmpuserid.Any()) { AddUsers(tmpuserid); } JoinUserGroup(detailList.Where(p => p.TrainFrom > 0).Select(p => p.DetailId), userids); }
/// <summary> /// 批量添加授权信息 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool AddAllTenantToWare(List <Sys_TenantToWare> list, string wareids) { var result = 0; var allList = _dataAccess.GetList <Sys_TenantToWare>(" WareID in (" + wareids.TrimEnd(',').TrimStart(',') + ")"); foreach (var item in list) { var single = allList.FirstOrDefault(p => p.WareID == item.WareID); if (single == null) { _dataAccess.AddEntity(item); } else { var openList = (single.OpenObject.TrimEnd(',') + "," + item.OpenObject.TrimStart(',')).Split(',').ToList().Distinct(); single.OpenObject = string.Join(",", openList); _dataAccess.UpdateEntity(single); } result++; } return(result == list.Count); }
public IEnumerable <IntQuestion> GetAllThematicQuestons(int tenantId, int info) { var sqlwhere = "Int_Question.IsDelete=0 AND Int_Question.IsThematic=1 AND Int_Question.TenantId=" + tenantId; switch (info) { case 1: //未处理的提问 sqlwhere += " AND Int_Question.AnswerId=0 AND (Int_Question.Expired IS NULL OR Int_Question.Expired>'" + DateTime.Now.ToString("yyyy-MM-dd") + "')"; break; case 2: //已处理的提问 sqlwhere += " AND Int_Question.AnswerId<>0 AND (Int_Question.Expired IS NULL OR Int_Question.Expired>'" + DateTime.Now.ToString("yyyy-MM-dd") + "')"; break; case 3: //已过期的提问 sqlwhere += " AND Int_Question.AnswerId=0 AND Int_Question.Expired <'" + DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + "'"; break; } return(_dataAccess.GetList <IntQuestion>(sqlwhere)); }
private static readonly int REMOVEDIFF = 60; //多少秒执行一次删除不活动用户 /// <summary> /// Checks the online. /// </summary> /// <param name="userId">User identifier.</param> /// <param name="tenantId">Tenant identifier.</param> public static void CheckOnline(int userId, int tenantId) { lock (lockHelper) { string sessionId = System.Web.HttpContext.Current.Session.SessionID; //数据表中是否有用户的记录 OnlineUser onlineUser = _dataAccess.GetList <OnlineUser>("sys_onlineuser.UserId=" + userId).FirstOrDefault();// onlineUsers.Find(p => p.UserId == userId); if (onlineUser != null && onlineUser.SessionId != sessionId) { //SESSION变了??? //onlineUsers.Remove(onlineUser); _dataAccess.DeleteEntities <OnlineUser>("sys_onlineuser.UserId=" + userId); onlineUser = null; } if (onlineUser != null) { //有;更新我的状态 onlineUser.LastActiveTime = DateTime.Now; onlineUser.UserWhere = AtWhere(); onlineUser.UserId = userId; _dataAccess.UpdateEntity(onlineUser, "SessionId"); } else { //无;加入关于我的在线信息 onlineUser = new OnlineUser(); onlineUser.SessionId = sessionId; onlineUser.TenantId = tenantId; onlineUser.UserId = userId; onlineUser.LastActiveTime = DateTime.Now; onlineUser.LoginTime = DateTime.Now; onlineUser.VisitorIp = System.Web.HttpContext.Current.Request.UserHostAddress; onlineUser.UserWhere = AtWhere(); _dataAccess.AddEntity(onlineUser); } //如果离上次删除的时间间隔超过设定值 TimeSpan tsRemove = DateTime.Now - LastRemove; if (tsRemove.Seconds > REMOVEDIFF) { _dataAccess.ExecuteSql(string.Format(@"DELETE FROM sys_onlineuser where TIMESTAMPDIFF(SECOND,LastActiveTime,now())>{0};", OFFLINEDIFF * 60)); //重置上次删除时间 LastRemove = DateTime.Now; } } }
public int SaveLearningRecord(int stageid, int abilityid, int applyId) { var record = _dataAccess.GetList <AbLearningRecord>("StageId=" + stageid + " AND AbilityId=" + abilityid + " AND ApplyId=" + applyId).FirstOrDefault(); if (record == null) { var promotion = _dataAccess.Get <PromotionStage>(stageid); return(_dataAccess.AddEntity(new AbLearningRecord() { StageId = stageid, AbilityId = abilityid, ApplyId = applyId, PromotionId = promotion.PromotionId })); } else { return(record.RecordId); } }
/// <summary> /// /// </summary> /// <param name="keyWord"></param> /// <param name="tenantId"></param> /// <returns></returns> public static int AddWord(string keyWord, int tenantId) { if (string.IsNullOrWhiteSpace(keyWord)) { return(0); } var exists = _dataAccess.GetList <Sys_SearchKeyWord>("KeyWord=@keyword AND TenantId=@tid", new { keyword = keyWord, tid = tenantId }).FirstOrDefault(); if (exists == null) { exists = new Sys_SearchKeyWord { KeyWord = keyWord, SearchCount = 1, TenantId = tenantId, Lookup = keyWord.GetPy(0) + " " + keyWord.GetPy(2) }; return(_dataAccess.AddEntity(exists)); } exists.SearchCount += 1; return(_dataAccess.UpdateEntity(exists)); }
/// <summary> /// /// </summary> /// <param name="deptId"></param> /// <returns></returns> public IEnumerable <SysPost> GetPostByDeptId(int deptId) { var sqlwhere = "Sys_Posts.Status=0 AND Sys_Posts.DeptId=" + deptId; return(_dataAccess.GetList <SysPost>(sqlwhere)); }