/// <summary>
/// 查找指定会话的GGA信息
/// </summary>
/// <param name="session">会话实体</param>
/// <returns>查找到的GGA信息列表,定位之间倒叙排列</returns>
public List <GGAHistory> FindGGAHistoriesBySessionHistory(SessionHistory session)
{
List <GGAHistory> result = new List <GGAHistory>();
using (var ctx = new NtripProxyDB())
{
result = ctx.GGAHistories.Where <GGAHistory>(g => g.SessionID == session.ID).OrderByDescending(g => g.FixedTime).ToList();
}
return(result);
}
/// <summary>
/// 查找所有概略位置信息
/// </summary>
/// <returns>所有概略位置列表</returns>
public List <GGAHistory> FindAllGGAHistories()
{
List <GGAHistory> result = new List <GGAHistory>();
using (var ctx = new NtripProxyDB())
{
result = ctx.GGAHistories.ToList();
}
return(result);
}
/// <summary>
/// 查找指定账号名的GGA信息
/// </summary>
/// <param name="account">账号名信息</param>
/// <returns>查找到的GGA信息列表,定位之间倒叙排列</returns>
public List <GGAHistory> FindGGAHistoriesByAccount(string account)
{
List <GGAHistory> result = new List <GGAHistory>();
using (var ctx = new NtripProxyDB())
{
result = ctx.GGAHistories.Include("SessionHistory").Where <GGAHistory>(g => g.Account == account).OrderByDescending(g => g.FixedTime).ToList();
}
return(result);
}
/// <summary>
/// 查找所有在线会话,包含GGA数据信息
/// </summary>
/// <returns>所有在线会话信息列表</returns>
public List <SessionHistory> FindAllOnlineSessions()
{
List <SessionHistory> result = new List <SessionHistory>();
using (var ctx = new NtripProxyDB())
{
result = ctx.SessionHistories.Include("GGAHistories").Where(s => s.ConnectionEnd == null).ToList();
}
return(result);
}
/// <summary>
/// 查找指定账号名的所有会话信息
/// </summary>
/// <param name="account">账号名信息</param>
/// <returns>查找到的会话信息列表,会话倒叙排列</returns>
public List <SessionHistory> FindSessionHistoriesByAccount(string account)
{
List <SessionHistory> result = new List <SessionHistory>();
using (var ctx = new NtripProxyDB())
{
result = ctx.SessionHistories.Where <SessionHistory>(s => s.AccountName == account && s.ConnectionEnd != null).OrderByDescending(s => s.ConnectionStart).ToList();
}
return(result);
}
/// <summary>
/// 查找所有菜单基本信息
/// </summary>
/// <returns>所有菜单列表</returns>
public List <MENU> FindAllMenus()
{
List <MENU> result = new List <MENU>();
using (var ctx = new NtripProxyDB())
{
result = ctx.MENUs.Where <MENU>(m => m.isDelete == false).OrderByDescending(m => m.createTime).ToList <MENU>();
}
return(result);
}
/// <summary>
/// 通过权限ID查找菜单全部信息
/// </summary>
/// <param name="id">菜单ID号</param>
/// <returns>查找到的菜单信息</returns>
public MENU FindMenuByID(Guid id)
{
MENU menu = new MENU();
using (var ctx = new NtripProxyDB())
{
menu = ctx.MENUs.Include("PERMISSIONs").FirstOrDefault(m => m.ID == id && m.isDelete == false);
}
return(menu);
}
/// <summary>
/// 通过ID号查找公司全部信息
/// </summary>
/// <param name="id">公司ID号</param>
/// <returns>公司信息</returns>
public COMPANY FindCompanyByID(Guid id)
{
COMPANY company = new COMPANY();
using (var ctx = new NtripProxyDB())
{
company = ctx.COMPANies.Include("ACCOUNTs").Include("COMPANY1").Include("COMPANY2").Include("USERs").FirstOrDefault(c => c.ID == id && c.isDelete == false);
}
return(company);
}
/// <summary>
/// 查找除了指定id号以外的公司
/// </summary>
/// <param name="id">需要去除的公司的ID号</param>
/// <returns>查询到的公司列表</returns>
public List <COMPANY> FindOtherComapnies(Guid id)
{
List <COMPANY> result = new List <COMPANY>();
using (var ctx = new NtripProxyDB())
{
result = ctx.COMPANies.Where <COMPANY>(c => c.isDelete == false && c.ID != id).ToList <COMPANY>();
}
return(result);
}
/// <summary>
/// 查找所有公司基本信息
/// </summary>
/// <returns>所有公司列表</returns>
public List <COMPANY> FindAllCompanies()
{
List <COMPANY> result = new List <COMPANY>();
using (var ctx = new NtripProxyDB())
{
result = ctx.COMPANies.Where <COMPANY>(c => c.isDelete == false).OrderByDescending(c => c.createTime).ToList <COMPANY>();
}
return(result);
}
/// <summary>
/// 查找所有过期系统账号基本信息
/// </summary>
/// <returns>所有过期系统账号列表</returns>
public List <ACCOUNTSYS> FindAllAccountSYSExpired()
{
List <ACCOUNTSYS> result = new List <ACCOUNTSYS>();
using (var ctx = new NtripProxyDB())
{
result = ctx.ACCOUNTSYS.Where <ACCOUNTSYS>(a => a.isDelete == false && a.AccountSYS_Expire < DateTime.Now).ToList <ACCOUNTSYS>();
}
return(result);
}
/// <summary>
/// 通过系统账户名查找系统账号全部信息
/// </summary>
/// <param name="id">系统账号名</param>
/// <returns>系统账号信息</returns>
public ACCOUNTSYS FindAccountSYSByName(string name)
{
ACCOUNTSYS accountSYS = new ACCOUNTSYS();
using (var ctx = new NtripProxyDB())
{
accountSYS = ctx.ACCOUNTSYS.FirstOrDefault(a => a.AccountSYS_Name == name && a.isDelete == false);
}
return(accountSYS);
}
/// <summary>
/// 通过用户ID查找用户全部信息
/// </summary>
/// <param name="id">用户ID号</param>
/// <returns>查找到的用户信息</returns>
public USER FindUserByID(Guid id)
{
USER user = new USER();
using (var ctx = new NtripProxyDB())
{
user = ctx.USERs.Include("COMPANY").Include("ACCOUNTs").Include("ROLEs").FirstOrDefault(u => u.ID == id && u.isDelete == false);
}
return(user);
}
/// <summary>
/// 查找所有锁定系统账号基本信息
/// </summary>
/// <returns>所有锁定系统账号列表</returns>
public List <ACCOUNTSYS> FindAllAccountSYSLocked()
{
List <ACCOUNTSYS> result = new List <ACCOUNTSYS>();
using (var ctx = new NtripProxyDB())
{
result = ctx.ACCOUNTSYS.Where <ACCOUNTSYS>(a => a.isDelete == false && a.AccountSYS_IsLocked == true).ToList <ACCOUNTSYS>();
}
return(result);
}
/// <summary>
/// 通过权限ID查找权限全部信息
/// </summary>
/// <param name="id">权限ID号</param>
/// <returns>查找到的权限信息</returns>
public PERMISSION FindPermissionByID(Guid id)
{
PERMISSION permission = new PERMISSION();
using (var ctx = new NtripProxyDB())
{
permission = ctx.PERMISSIONs.Include("MENUs").Include("ROLEs").FirstOrDefault(p => p.ID == id && p.isDelete == false);
}
return(permission);
}
/// <summary>
/// 通过ID号查找账号全部信息
/// </summary>
/// <param name="id">账号ID号</param>
/// <returns>账号信息</returns>
public ACCOUNT FindAccountByID(Guid id)
{
ACCOUNT account = new ACCOUNT();
using (var ctx = new NtripProxyDB())
{
account = ctx.ACCOUNTs.Include("COMPANY").Include("USER").FirstOrDefault(a => a.ID == id && a.isDelete == false);
}
return(account);
}
/// <summary>
/// 查找所有权限基本信息
/// </summary>
/// <returns>所有权限列表</returns>
public List <PERMISSION> FindAllPermissions()
{
List <PERMISSION> result = new List <PERMISSION>();
using (var ctx = new NtripProxyDB())
{
result = ctx.PERMISSIONs.Where <PERMISSION>(p => p.isDelete == false).OrderByDescending(p => p.createTime).ToList <PERMISSION>();
}
return(result);
}
/// <summary>
/// 查找所有用户基本信息
/// </summary>
/// <returns>所有用户列表</returns>
public List <USER> FindAllUsers()
{
List <USER> result = new List <USER>();
using (var ctx = new NtripProxyDB())
{
result = ctx.USERs.Where <USER>(u => u.isDelete == false).OrderByDescending(u => u.createTime).ToList <USER>();
}
return(result);
}
/// <summary>
/// 通过角色ID查找角色全部信息
/// </summary>
/// <param name="id">角色ID号</param>
/// <returns>查找到的角色信息</returns>
public ROLE FindRoleByID(Guid id)
{
ROLE role = new ROLE();
using (var ctx = new NtripProxyDB())
{
role = ctx.ROLEs.Include("PERMISSIONs").Include("USERs").FirstOrDefault(r => r.ID == id && r.isDelete == false);
}
return(role);
}
/// <summary>
/// 通过公司ID号查找公司账号信息
/// </summary>
/// <param name="id">公司ID号</param>
/// <returns>账号信息</returns>
public List <ACCOUNT> FindAccountByCompanyID(Guid id)
{
List <ACCOUNT> result = new List <ACCOUNT>();
using (var ctx = new NtripProxyDB())
{
result = ctx.ACCOUNTs.Include("COMPANY").Where <ACCOUNT>(a => a.isDelete == false && a.COMPANY.ID == id).ToList <ACCOUNT>();
}
return(result);
}
/// <summary>
/// 查找所有角色基本信息
/// </summary>
/// <returns>所有角色列表</returns>
public List <ROLE> FindAllRoles()
{
List <ROLE> result = new List <ROLE>();
using (var ctx = new NtripProxyDB())
{
result = ctx.ROLEs.Where <ROLE>(r => r.isDelete == false).OrderByDescending(r => r.createTime).ToList <ROLE>();
}
return(result);
}
/// <summary>
/// 通过账户名查找账号全部信息
/// </summary>
/// <param name="name">账号名</param>
/// <returns>账号信息</returns>
public ACCOUNT FindAccountByName(string name)
{
ACCOUNT account = new ACCOUNT();
using (var ctx = new NtripProxyDB())
{
account = ctx.ACCOUNTs.FirstOrDefault(a => a.Account_Name == name && a.isDelete == false);
}
return(account);
}
/// <summary>
/// 通过ID号查找系统账号全部信息
/// </summary>
/// <param name="id">系统账号ID号</param>
/// <returns>系统账号信息</returns>
public ACCOUNTSYS FindAccountSYSByID(Guid id)
{
ACCOUNTSYS accountSYS = new ACCOUNTSYS();
using (var ctx = new NtripProxyDB())
{
accountSYS = ctx.ACCOUNTSYS.FirstOrDefault(a => a.ID == id && a.isDelete == false);
}
return(accountSYS);
}
/// <summary>
/// 查找所有在线账号
/// </summary>
/// <returns>在线账号列表</returns>
public List <ACCOUNT> FindAccountOnline()
{
List <ACCOUNT> result = new List <ACCOUNT>();
using (var ctx = new NtripProxyDB())
{
result = ctx.ACCOUNTs.Where <ACCOUNT>(a => a.isDelete == false && a.Account_IsOnline == true).ToList <ACCOUNT>();
}
return(result);
}
/// <summary>
/// 查找所有账号基本信息
/// </summary>
/// <returns>所有账号列表</returns>
public List <ACCOUNT> FindAllAccounts()
{
List <ACCOUNT> result = new List <ACCOUNT>();
using (var ctx = new NtripProxyDB())
{
result = ctx.ACCOUNTs.Where <ACCOUNT>(a => a.isDelete == false).OrderByDescending(a => a.createTime).ToList <ACCOUNT>();
}
return(result);
}
/// <summary>
/// 查找所有日志信息
/// </summary>
/// <returns>所有日志信息列表</returns>
public List <LOG> FindAllLogs()
{
List <LOG> result = new List <LOG>();
using (var ctx = new NtripProxyDB())
{
result = ctx.LOGs.OrderByDescending(l => l.Log_Time).ToList <LOG>();
}
return(result);
}
/// <summary>
/// 查找即将过期系统账号基本信息
/// </summary>
/// <returns>所有即将过期系统账号列表</returns>
public List <ACCOUNTSYS> FindAllAccountSYSExpiring()
{
List <ACCOUNTSYS> result = new List <ACCOUNTSYS>();
using (var ctx = new NtripProxyDB())
{
DateTime checkTime = DateTime.Now.AddMonths(1);
result = ctx.ACCOUNTSYS.Where <ACCOUNTSYS>(a => a.isDelete == false && a.AccountSYS_Expire <checkTime && a.AccountSYS_Expire> DateTime.Now).ToList <ACCOUNTSYS>();
}
return(result);
}
/// <summary>
/// 添加角色信息
/// </summary>
/// <param name="role">需要添加的角色信息</param>
/// <returns>角色是否添加成功</returns>
public bool AddRole(ROLE role)
{
bool result = false;
using (var ctx = new NtripProxyDB())
{
ctx.ROLEs.Add(role);
result = ctx.SaveChanges() == 1;
}
return(result);
}
/// <summary>
/// 添加单个账号
/// </summary>
/// <param name="account">账号信息</param>
/// <returns>是否添加成功</returns>
public bool AddAccount(ACCOUNT account)
{
bool result = false;
using (var ctx = new NtripProxyDB())
{
ctx.ACCOUNTs.Add(account);
result = ctx.SaveChanges() == 1;
}
return(result);
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="log">日志信息</param>
/// <returns>是否添加成功</returns>
public bool AddLog(LOG log)
{
bool result = false;
using (var ctx = new NtripProxyDB())
{
ctx.LOGs.Add(log);
result = ctx.SaveChanges() == 1;
}
return(result);
}
