public MResultModel GetUserInfoByWhere(string UserName, string Mobile, string WeChatWorkUserID, string Email, string TrueName, string NickName, bool?IfEnable, int PageIndex, int PageSize) { MPagingModel pageM = new MPagingModel(PageIndex, PageSize); List <V_User> listM = _bll.GetUserInfoByWhere(UserName, Mobile, WeChatWorkUserID, Email, TrueName, NickName, IfEnable, pageM); return(MResultPagingModel <List <V_User> > .GetSuccessResultM(listM, pageM, "查询成功")); }
public MResultModel GetUserGroupInfoByWhere(string Name, string Code, bool?IfEnable, int PageIndex, int PageSize) { MPagingModel pageM = new MPagingModel(PageIndex, PageSize); List <V_UserGroup> listM = _bll.GetUserGroupInfoByWhere(Name, Code, IfEnable, pageM); return(MResultPagingModel <List <V_UserGroup> > .GetSuccessResultM(listM, pageM, "查询成功")); }
public MResultModel GetUserInfoByWhere(string UserName, string TrueName, int PageIndex, int PageSize) { MPagingModel pageM = new MPagingModel(PageIndex, PageSize); List <V_User> listM = _bll.GetUserInfoByWhere(UserName, TrueName, pageM); return(MResultPagingModel <List <V_User> > .GetSuccessResultM(listM, pageM, "查询成功")); }
public MResultModel GetAllUserInfo(int PageIndex, int PageSize) { MResultModel resM; MPagingModel pageM = new MPagingModel(PageIndex, PageSize); List <V_User> listM = _userBLL.GetAllUserViewInfo(pageM); resM = MResultPagingModel <List <V_User> > .GetSuccessResultM(listM, pageM, "查询成功"); return(resM); }
public MResultModel GetPaperInfoByWhere(string Title, bool?IsEnable, int PageIndex, int PageSize) { MResultModel resM; MPagingModel pageM = new MPagingModel(PageIndex, PageSize); List <V_Paper> listM = _paperBLL.GetPaperInfoByWhere(Title, IsEnable, pageM); resM = MResultPagingModel <List <V_Paper> > .GetSuccessResultM(listM, pageM, "查询成功"); return(resM); }
/// <summary> /// 获得所有用户的视图信息 /// </summary> /// <param name="pageM">分页模型</param> /// <returns>查询结果</returns> public List <V_User> GetAllUserViewInfo(MPagingModel pageM) { List <V_User> listM = new List <V_User>(); pageM.DataCount = _DB.V_User.Count(); if (pageM.DataCount > 0) { listM.AddRange(_DB.V_User.OrderBy(m => m.UserName).Skip((pageM.PagingIndex - 1) * pageM.PagingSize).Take(pageM.PagingSize).ToList()); } return(listM); }
/// <summary> /// 根据条件查询日志分页信息 /// </summary> /// <param name="qModel">查询条件</param> /// <param name="pageM">分页对象</param> /// <returns>日志信息</returns> public MPagingData <List <LogModel> > GetInfoByWhere(LogQueryModel qModel, MPagingModel pageM) { DataSet ds = SQLServerManager.Pagination(qModel.GetQuerySQL(false), qModel.GetGroupStr(), pageM.PagingIndex, pageM.PagingSize); MPagingData <List <LogModel> > resM = new MPagingData <List <LogModel> >(); resM.Data = ConvertManager.DataTableToList <LogModel>(ds.Tables[0]); pageM.PagingIndex = Convert.ToInt32(ds.Tables[1].Rows[0][0]); pageM.DataCount = Convert.ToInt32(ds.Tables[1].Rows[0][1]); pageM.PagingCount = Convert.ToInt32(ds.Tables[1].Rows[0][2]); resM.PageInfo = pageM; return(resM); }
/// <summary> /// 获得所有的用户信息 /// </summary> /// <param name="pageM">分页信息</param> /// <returns>所有用户的信息</returns> public List <V_User> GetAllUserViewInfo(MPagingModel pageM) { if (pageM != null) { List <V_User> resM; resM = _dal.GetAllUserViewInfo(pageM); return(resM); } else { throw new ArgumentNullException($"参数{nameof(pageM)}不可以为空。"); } }
public void GetInfoByWhereTest1() { LogQueryModel qModel = new LogQueryModel { ID = Guid.Parse("37689F18-E5F2-42AE-9610-273DA251A80B"), GroupM = new GroupModel(GroupType.Asc, "CreateTime") }; MPagingModel pageM = new MPagingModel() { PagingIndex = 1, PagingSize = 20 }; MPagingData <List <LogModel> > listM = logDal.GetInfoByWhere(qModel, pageM); }
/// <summary> /// 根据条件获得试题信息 /// </summary> /// <param name="title">试题标题</param> /// <param name="IsEnable">启用状态</param> /// <param name="pageM">分页对象</param> /// <returns>试题信息</returns> public List <V_Paper> GetPaperViewInfoByWhere(string title, bool?IsEnable, MPagingModel pageM) { Expression <Func <V_Paper, bool> > searchPredicate = LinqManager.True <V_Paper>(); if (!string.IsNullOrEmpty(title)) { searchPredicate = LinqManager.And(searchPredicate, m => m.Title.Contains(title)); } if (IsEnable != null) { searchPredicate = LinqManager.And(searchPredicate, m => m.IsEnable == IsEnable.Value); } pageM.DataCount = _DB.V_Paper.Where(searchPredicate.Compile()).Count(); List <V_Paper> resM = new List <V_Paper>(); if (pageM.DataCount > 0) { resM = _DB.V_Paper.Where(searchPredicate.Compile()).OrderByDescending(m => m.CreateTime).Skip((pageM.PagingIndex - 1) * pageM.PagingSize).Take(pageM.PagingSize).ToList(); } return(resM); }
/// <summary> /// 根据条件获得用户信息 /// </summary> /// <param name="userName">用户名</param> /// <param name="trueName">真实姓名</param> /// <param name="pageM">分页对象</param> /// <returns>用户信息</returns> public List <V_User> GetUserViewInfoByWhere(string userName, string trueName, MPagingModel pageM) { Expression <Func <V_User, bool> > expression = m => true; if (!string.IsNullOrEmpty(userName)) { expression = LinqManager.And(expression, m => m.UserName == userName); } if (!string.IsNullOrEmpty(trueName)) { expression = LinqManager.And(expression, m => m.TrueName.Contains(trueName)); } pageM.DataCount = _DB.V_User.Count(expression.Compile()); List <V_User> listM = null; if (pageM.DataCount > 0) { listM = _DB.V_User.Where(expression.Compile()).Skip((pageM.PagingIndex - 1) * pageM.PagingSize).Take(pageM.PagingSize).OrderBy(m => m.CreateTime).ToList(); } return(listM); }
/// <summary> /// 根据条件获得用户信息 /// </summary> /// <param name="userName">用户名</param> /// <param name="mobile">手机</param> /// <param name="weChatWorkUserID">微信企业号账户</param> /// <param name="email">邮箱</param> /// <param name="trueName">真实姓名</param> /// <param name="nickName">昵称</param> /// <param name="ifEnable">启用标识</param> /// <param name="pageM">分页对象</param> /// <returns>用户信息</returns> public List <V_User> GetUserInfoByWhere(string userName, string mobile, string weChatWorkUserID, string email, string trueName, string nickName, bool?ifEnable, MPagingModel pageM) { return(_dal.GetUserInfoByWhere(userName, mobile, weChatWorkUserID, email, trueName, nickName, ifEnable, pageM)); }
/// <summary> /// 根据条件获得用户组信息 /// </summary> /// <param name="name">名称</param> /// <param name="code">代码</param> /// <param name="ifEnable">启用标识</param> /// <param name="pageM">分页对象</param> /// <returns>用户组信息</returns> public List <V_UserGroup> GetUserGroupInfoByWhere(string name, string code, bool?ifEnable, MPagingModel pageM) { Expression <Func <V_UserGroup, bool> > expression = m => true; if (!string.IsNullOrEmpty(name)) { expression = LinqManager.And(expression, m => m.Name.Contains(name)); } if (!string.IsNullOrEmpty(code)) { expression = LinqManager.And(expression, m => m.Code == code); } if (ifEnable != null) { expression = LinqManager.And(expression, m => m.IfEnable == ifEnable.Value); } pageM.DataCount = _DB.V_UserGroup.Count(expression.Compile()); List <V_UserGroup> listM = null; if (pageM.DataCount > 0) { listM = _DB.V_UserGroup.Where(expression.Compile()).Skip((pageM.PagingIndex - 1) * pageM.PagingSize).Take(pageM.PagingSize).OrderBy(m => m.CreateTime).ToList(); } return(listM); }
/// <summary> /// 根据条件获得用户信息 /// </summary> /// <param name="userName">用户名</param> /// <param name="mobile">手机</param> /// <param name="weChatWorkUserID">微信企业号账户</param> /// <param name="email">邮箱</param> /// <param name="trueName">真实姓名</param> /// <param name="nickName">昵称</param> /// <param name="ifEnable">启用标识</param> /// <param name="pageM">分页对象</param> /// <returns>用户信息</returns> public List <V_User> GetUserInfoByWhere(string userName, string mobile, string weChatWorkUserID, string email, string trueName, string nickName, bool?ifEnable, MPagingModel pageM) { Expression <Func <V_User, bool> > expression = m => true; if (!string.IsNullOrEmpty(userName)) { expression = LinqManager.And(expression, m => m.UserName == userName); } if (!string.IsNullOrEmpty(mobile)) { expression = LinqManager.And(expression, m => m.Mobile == mobile); } if (!string.IsNullOrEmpty(weChatWorkUserID)) { expression = LinqManager.And(expression, m => m.WeChatWorkUserID == weChatWorkUserID); } if (!string.IsNullOrEmpty(email)) { expression = LinqManager.And(expression, m => m.Email == email); } if (!string.IsNullOrEmpty(trueName)) { expression = LinqManager.And(expression, m => m.TrueName.Contains(trueName)); } if (!string.IsNullOrEmpty(nickName)) { expression = LinqManager.And(expression, m => m.NickName.Contains(nickName)); } if (ifEnable != null) { expression = LinqManager.And(expression, m => m.IfEnable == ifEnable.Value); } pageM.DataCount = _DB.V_User.Count(expression.Compile()); List <V_User> listM = null; if (pageM.DataCount > 0) { listM = _DB.V_User.Where(expression.Compile()).Skip((pageM.PagingIndex - 1) * pageM.PagingSize).Take(pageM.PagingSize).OrderBy(m => m.CreateTime).ToList(); } return(listM); }
/// <summary> /// 根据条件获得试题信息 /// </summary> /// <param name="title">试题标题</param> /// <param name="IsEnable">启用状态</param> /// <param name="pageM">分页对象</param> /// <returns>试题信息</returns> public List <V_Paper> GetPaperInfoByWhere(string title, bool?IsEnable, MPagingModel pageM) { List <V_Paper> listM = _dal.GetPaperViewInfoByWhere(title, IsEnable, pageM); return(listM); }
/// <summary> /// 根据条件获得用户组信息 /// </summary> /// <param name="name">名称</param> /// <param name="code">代码</param> /// <param name="ifEnable">启用标识</param> /// <param name="pageM">分页对象</param> /// <returns>用户组信息</returns> public List <V_UserGroup> GetUserGroupInfoByWhere(string name, string code, bool?ifEnable, MPagingModel pageM) { List <V_UserGroup> listM = _dal.GetUserGroupInfoByWhere(name, code, ifEnable, pageM); return(listM); }
/// <summary> /// 根据条件获得用户信息 /// </summary> /// <param name="userName">用户名</param> /// <param name="trueName">真实姓名</param> /// <param name="pageM">分页对象</param> /// <returns>用户信息</returns> public List <V_User> GetUserInfoByWhere(string userName, string trueName, MPagingModel pageM) { return(_dal.GetUserViewInfoByWhere(userName, trueName, pageM)); }