/// <summary> /// 检索异常日志 /// </summary> /// <returns></returns> public static BaseResponseList <SysExcptionLog> searchLog(VMMsgSearchExceptionLogRequest condtion) { BaseResponseList <SysExcptionLog> result = new BaseResponseList <SysExcptionLog>(); using (var db = new SysModelContainer()) { var r = (from c in db.Db_SysMsgSet.OfType <Db_SysExceptionLog>().AsEnumerable() where (condtion.type == null? true :c.errorCode == condtion.type.GetHashCode()) && (condtion.beginDate == null? true :c.createdOn >= condtion.beginDate) && (condtion.endDate == null? true :c.createdOn <= condtion.endDate) orderby c.Id descending select c.Id ); result.total = r.Count(); if (result.total > 0) { if (condtion.page == 0) { result.rows = r.Select(p => new SysExcptionLog(p)).ToList(); } else { result.rows = r.Skip(condtion.getSkip()).Take(condtion.pageSize).Select(p => new SysExcptionLog(p)).ToList(); } } } return(result); }
/// <summary> /// 检索日志 /// </summary> /// <param name="condtion"></param> /// <returns></returns> public static BaseResponseList <SysUserLog> searchLog(ViewModelMsgSearchUserLogReqeust condtion) { BaseResponseList <SysUserLog> result = new BaseResponseList <SysUserLog>(); using (var db = new SysModelContainer()) { var r = (from c in db.Db_SysMsgSet.OfType <Db_SysUserLog>().AsEnumerable() where ((string.IsNullOrEmpty(condtion.loginName) && string.IsNullOrEmpty(condtion.fkid))? true :( (string.IsNullOrEmpty(condtion.loginName)?false:c.Db_SysUser_loginName == condtion.loginName) || (string.IsNullOrEmpty(condtion.fkid) ? false : c.fkId == condtion.fkid) )) && (condtion.logType == null ? true : c.logType == condtion.logType.GetHashCode()) orderby c.createdOn descending select c.Id); result.total = r.Count(); if (result.total > 0) { if (condtion.page == 0) { result.rows = r.Select(p => new SysUserLog(p)).ToList(); } else { result.rows = r.Skip(condtion.getSkip()).Take(condtion.pageSize).Select(p => new SysUserLog(p)).ToList(); } } } return(result); }
/// <summary> /// 检索用户 /// </summary> /// <param name="condtion"></param> /// <returns></returns> internal static BaseResponseList <SysManagerUser> searchUserList(ViewModelSearchUserBaseRequest condtion) { BaseResponseList <SysManagerUser> res = new BaseResponseList <SysManagerUser>(); using (var db = new SysModelContainer()) { var r = (from x in db.Db_SysUserSet.OfType <Db_ManagerUser>().AsEnumerable() where !x.isDeleted && (condtion.roles.Count == 0 ? true : condtion.roles.Contains(x.role)) && (condtion.loginName.Count == 0 ? true : condtion.loginName.Contains(x.loginName)) && (string.IsNullOrEmpty(condtion.q) ? true : (x.loginName.Contains(condtion.q) || x.fullName.Contains(condtion.q) || (string.IsNullOrEmpty(x.mobilePhone) ? false : x.mobilePhone.Contains(condtion.q)))) select new { x.loginName, x.createdOn }); res.total = r.Count(); if (res.total > 0) { r = r.OrderByDescending(p => p.createdOn); if (condtion.page == 0) { res.rows = r.Select(p => new SysManagerUser(p.loginName)).ToList(); } else { res.rows = r.Skip(condtion.getSkip()).Take(condtion.pageSize).Select(p => new SysManagerUser(p.loginName)).ToList(); } } } return(res); }
/// <summary> /// 检索系统消息 /// </summary> /// <param name="condtion"></param> /// <returns></returns> public static BaseResponseList <SysMsg> searchLog(VMMsgSearchMsgRequest condtion) { BaseResponseList <SysMsg> result = new BaseResponseList <SysMsg>(); using (var db = new SysModelContainer()) { var r = (from c in db.Db_SysMsgSet.AsEnumerable() where (condtion.msgType.Count == 0 ? true : condtion.msgType.Contains(c.msgType)) orderby c.Id descending select c.Id); result.total = r.Count(); if (result.total > 0) { if (condtion.page == 0) { result.rows = r.Select(p => new SysMsg(p)).ToList(); } else { result.rows = r.Skip(condtion.getSkip()).Take(condtion.pageSize).Select(p => new SysMsg(p)).ToList(); } } } return(result); }