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));
}
