/// <summary>
/// 分页计数
/// </summary>
/// <param name="keyWord">关键字</param>
/// <param name="startDate">开始时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="status">状态</param>
/// <param name="sort">分页</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public int PageCount(string keyWord, DateTime startDate, DateTime endDate, ModeBase.Status status, ModeBase.Sort sort, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
// 定义
var queryable = SQLQueryable(context, entityAttrs);
// keyWord查询
queryable = KeyWordQueryable(queryable, keyWord, entityAttrs);
// keyWordExt查询
queryable = KeyWordExtQueryable(queryable, keyWord, entityAttrs);
// 日期查询
queryable = DateQueryable(queryable, startDate, endDate, entityAttrs);
// status查询
queryable = StatusQueryable(queryable, status, entityAttrs);
// 排序
queryable = SortQueryable(queryable, sort, entityAttrs);
// 返回
return(queryable.Count());
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 汇总信息
/// </summary>
/// <param name="keyWord">关键字</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">单页数据量</param>
/// <param name="startDate">开始时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="status">状态</param>
/// <param name="sort">分页</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public SummaryEntity PageSummary(string keyWord, int pageIndex, int pageSize, DateTime startDate, DateTime endDate, ModeBase.Status status, ModeBase.Sort sort, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
// 定义
var queryable = SQLQueryable(context, entityAttrs);
// keyWord查询
queryable = KeyWordQueryable(queryable, keyWord, entityAttrs);
// keyWordExt查询
queryable = KeyWordExtQueryable(queryable, keyWord, entityAttrs);
// 日期查询
queryable = DateQueryable(queryable, startDate, endDate, entityAttrs);
// status查询
queryable = StatusQueryable(queryable, status, entityAttrs);
// 排序
queryable = SortQueryable(queryable, sort, entityAttrs);
// 分页
queryable = PageQueryable(queryable, pageIndex, pageSize, entityAttrs);
// 返回
return(new SummaryEntity());
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据状态键名查询
/// </summary>
/// <param name="key">状态键名</param>
/// <returns></returns>
public Status ByKey(string key)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToSingle(
SQLQueryable(context)
.Where(row => row.Status.Key == key)
.SingleOrDefault()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据 id 查询
/// </summary>
/// <param name="id">Id</param>
/// <returns></returns>
public Status ById(int id)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToSingle(
SQLQueryable(context)
.Where(row => row.Status.Id == id)
.SingleOrDefault()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据用户Id查询
/// </summary>
/// <param name="userId">用户Id</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public List <REUserRegistry> ByUserId(int userId, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToList(
SQLQueryable(context, entityAttrs)
.Where(row => row.REUserRegistry.UserId == userId)
.ToList()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 查询唯一值
/// </summary>
/// <param name="userId">用户Id</param>
/// <param name="registryId">功能Id</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public UserPower Only(int userId, int registryId, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToSingle(
SQLQueryable(context, entityAttrs)
.Where(row => row.UserPower.UserId == userId && row.UserPower.RegistryId == registryId)
.SingleOrDefault()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据功能Id查询
/// </summary>
/// <param name="registryId">功能Id</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public List <UserPower> ByRegistryId(int registryId, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToList(
SQLQueryable(context, entityAttrs)
.Where(row => row.UserPower.RegistryId == registryId)
.ToList()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据 id 查询
/// </summary>
/// <param name="id">唯一标识</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public Site ById(int id, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToSingle(
SQLQueryable(context, entityAttrs)
.Where(row => row.Site.Id == id)
.SingleOrDefault()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据mobile查询
/// </summary>
/// <param name="mobile">手机号</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public User ByMobile(string mobile, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToSingle(
SQLQueryable(context, entityAttrs)
.Where(row => row.User.Mobile == mobile)
.SingleOrDefault()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据功能键名查询
/// </summary>
/// <param name="key">功能键名</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public Dictionary ByKey(string key, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToSingle(
SQLQueryable(context, entityAttrs)
.Where(row => row.Dictionary.Key == key)
.SingleOrDefault()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据微信OpenId查询
/// </summary>
/// <param name="weChatOpenId">Id</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public User ByWeChatOpenId(string weChatOpenId, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToSingle(
SQLQueryable(context, entityAttrs)
.Where(row => row.User.WeChatOpenId == weChatOpenId)
.SingleOrDefault()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据场馆Id查询
/// </summary>
/// <param name="venueId">场馆Id</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public List <Task> ByVenueId(int venueId, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToList(
SQLQueryable(context, entityAttrs)
.Where(row => row.Task.VenueId == venueId)
.OrderBy(row => row.Task.Id)
.ToList()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 模糊查询
/// </summary>
/// <param name="keyWord">关键字</param>
/// <returns></returns>
public List <Status> ByKeyWord(string keyWord)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToList(
SQLQueryable(context)
.Where(row => row.Status.Name.Contains(keyWord))
.OrderBy(row => row.Status.Id)
.ToList()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 模糊查询
/// </summary>
/// <param name="keyWord">关键字</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public List <Site> ByKeyWord(string keyWord, params string [] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToList(
SQLQueryable(context, entityAttrs)
.Where(row => row.Site.Name.Contains(keyWord))
.OrderBy(row => row.Site.Id)
.ToList()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据功能路径查询
/// </summary>
/// <param name="path">功能路径</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public List <Dictionary> ByPath(string path, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToList(
SQLQueryable(context, entityAttrs)
.Where(row => row.Dictionary.Path.StartsWith(path))
.OrderBy(row => row.Dictionary.Id)
.ToList()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据父Id查询
/// </summary>
/// <param name="pid">父Id</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public List <Dictionary> ByPid(int pid, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToList(
SQLQueryable(context, entityAttrs)
.Where(row => row.Dictionary.Pid == pid)
.OrderBy(row => row.Dictionary.Id)
.ToList()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据角色Id查询
/// </summary>
/// <param name="roleId">角色Id</param>
/// <param name="entityAttrs">可变参数</param>
/// <returns></returns>
public List <RERoleUser> ByRoleId(int roleId, params string[] entityAttrs)
{
using (VMISContext context = new VMISContext())
{
try
{
entityAttrs[entityAttrs.Length] = "User";
return(SQLEntityToList(
SQLQueryable(context, entityAttrs)
.Where(row => row.RERoleUser.RoleId == roleId)
.ToList()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据状态路径查询
/// </summary>
/// <param name="path">状态路径</param>
/// <returns></returns>
public List <Status> ByPath(string path)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToList(
SQLQueryable(context)
.Where(row => row.Status.Path.StartsWith(path))
.OrderBy(row => row.Status.Id)
.ToList()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 根据父Id查询
/// </summary>
/// <param name="pid">父Id</param>
/// <returns></returns>
public List <Status> ByPid(int pid)
{
using (VMISContext context = new VMISContext())
{
try
{
return(SQLEntityToList(
SQLQueryable(context)
.Where(row => row.Status.Pid == pid)
.OrderBy(row => row.Status.Id)
.ToList()
));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
///
/// </summary>
/// <param name="key"></param>
/// <param name="password"></param>
/// <returns></returns>
public User Verify(string key, string password)
{
using (VMISContext context = new VMISContext())
{
try
{
// 加密
password = EncryptHelper.GetBase64String(password);
return(SQLEntityToSingle(
SQLQueryable(context, "status")
.SingleOrDefault(row => (
(row.User.Name == key && row.User.Password == password) ||
(row.User.Mobile == key && row.User.Password == password) ||
(row.User.Email == key && row.User.Password == password) && row.Status.Value == 1
)
)
));
}
catch (Exception ex)
{
throw ex;
}
}
}
