/// <summary>
/// 更新VPN状态
/// </summary>
/// <param name="vpnServer">vpnServer</param>
/// <returns>返回更新结果</returns>
public bool ExitUpdateVpnIsValid(MVPNServer vpnServer)
{
IVPNServer ivpnServer = Better517Na.VPNDataService.Factory.DALFactory.GetVpnServerDal(Better517Na.VPNDataService.Factory.DBOperType.write);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("KeyID", vpnServer.KeyID);
mmb.AddUpdateFields("IsUsing", 0);
mmb.AddUpdateFields("IsUsingDesc", "未使用");
mmb.AddUpdateFields("UsingServer", string.Empty);
return ivpnServer.Update<MVPNServer>(vpnServer, mmb) > 0;
}
/// <summary>
/// 释放VPN账号
/// </summary>
/// <param name="vpnAccount">vpn账号对象信息</param>
/// <returns>返回释放结果</returns>
public bool ReleaseVpnAccountState(MVPNAccount vpnAccount)
{
IVPNAccount ivpnAccount = Better517Na.VPNDataService.Factory.DALFactory.GetVpnAccountDal(Better517Na.VPNDataService.Factory.DBOperType.write);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("KeyID", vpnAccount.KeyID);
mmb.AddUpdateFields("IsUsing", 0);
mmb.AddUpdateFields("IsUsingDesc", "未使用");
mmb.AddUpdateFields("UsingServer", string.Empty);
return(ivpnAccount.Update <MVPNAccount>(vpnAccount, mmb) > 0);
}
/// <summary>
/// 更新VPN账号状态
/// </summary>
/// <param name="vpnAccount">vpn账号对象信息</param>
/// <returns>返回更新结果</returns>
public bool UpdateVpnAccountState(MVPNAccount vpnAccount)
{
IVPNAccount ivpnAccount = Better517Na.VPNDataService.Factory.DALFactory.GetVpnAccountDal(Better517Na.VPNDataService.Factory.DBOperType.write);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("KeyID", vpnAccount.KeyID);
mmb.AddUpdateFields("IsUsing", 1);
mmb.AddUpdateFields("IsUsingDesc", "使用中");
mmb.AddUpdateFields("UsingServer", new GetIP().GetLocalIp("本地连接"));
return(ivpnAccount.Update <MVPNAccount>(vpnAccount, mmb) > 0);
}
/// <summary>
/// 更新VPN状态
/// </summary>
/// <param name="vpnServer">vpnServer</param>
/// <returns>返回更新结果</returns>
public bool ExitUpdateVpnIsValid(MVPNServer vpnServer)
{
IVPNServer ivpnServer = Better517Na.VPNDataService.Factory.DALFactory.GetVpnServerDal(Better517Na.VPNDataService.Factory.DBOperType.write);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("KeyID", vpnServer.KeyID);
mmb.AddUpdateFields("IsUsing", 0);
mmb.AddUpdateFields("IsUsingDesc", "未使用");
mmb.AddUpdateFields("UsingServer", string.Empty);
return(ivpnServer.Update <MVPNServer>(vpnServer, mmb) > 0);
}
/// <summary>
/// 重新获取一个VPN账号
/// </summary>
/// <param name="provider">提供商</param>
/// <returns>返回账号</returns>
public MVPNAccount GetNewVpnAccount(string provider)
{
MVPNAccount vpnAccount = null;
IVPNAccount ivpnAccount = Better517Na.VPNDataService.Factory.DALFactory.GetVpnAccountDal(Better517Na.VPNDataService.Factory.DBOperType.read);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("IsValid", 1);
mmb.AddConditionFields("IsDelete", 0);
mmb.AddConditionFields("IsUsing", 0);
mmb.AddConditionFields("Provider", provider, DatabaseOperators.DoesNotEqual);
mmb.AddUpdateFields("KeyID", null);
mmb.AddUpdateFields("Account", null);
mmb.AddUpdateFields("Password", null);
mmb.AddUpdateFields("Provider", null);
vpnAccount = ivpnAccount.GetModel<MVPNAccount>(mmb);
return vpnAccount;
}
/// <summary>
/// 获取一个VPN账号
/// </summary>
/// <returns>返回账号</returns>
public MVPNAccount GetVpnAccount()
{
MVPNAccount vpnAccount = null;
IVPNAccount ivpnAccount = Better517Na.VPNDataService.Factory.DALFactory.GetVpnAccountDal(Better517Na.VPNDataService.Factory.DBOperType.read);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("IsValid", 1);
mmb.AddConditionFields("IsDelete", 0);
mmb.AddConditionFields("IsUsing", 0);
mmb.AddUpdateFields("KeyID", null);
mmb.AddUpdateFields("Account", null);
mmb.AddUpdateFields("Password", null);
mmb.AddUpdateFields("Provider", null);
vpnAccount = ivpnAccount.GetModel <MVPNAccount>(mmb);
return(vpnAccount);
}
/// <summary>
/// 获取本机正在使用的VPN服务器（杀进程造成的数据）
/// </summary>
/// <param name="provider">VPN服务器提供商</param>
/// <returns>返回VPN服务器信息</returns>
public List<MVPNServer> GetLocalUsedVpnServer(string provider)
{
List<MVPNServer> vpnServerList = null;
IVPNServer vpnServer = Better517Na.VPNDataService.Factory.DALFactory.GetVpnServerDal(Better517Na.VPNDataService.Factory.DBOperType.read);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("Provider", provider);
mmb.AddConditionFields("IsValid", 1);
mmb.AddConditionFields("IsDelete", 0);
mmb.AddConditionFields("IsUsing", 1);
mmb.AddConditionFields("UsingServer", new GetIP().GetLocalIp("本地连接"));
mmb.AddUpdateFields("Address", null);
mmb.AddUpdateFields("KeyID", null);
mmb.AddUpdateFields("Area", null);
mmb.AddUpdateFields("Line", null);
mmb.AddUpdateFields("Provider", null);
mmb.AddUpdateFields("UsingServer", null);
vpnServerList = vpnServer.GetModel<MVPNServer>(mmb, 20);
return vpnServerList;
}
/// <summary>
/// 获取本机正在使用的VPN服务器（杀进程造成的数据）
/// </summary>
/// <param name="provider">VPN服务器提供商</param>
/// <returns>返回VPN服务器信息</returns>
public List <MVPNServer> GetLocalUsedVpnServer(string provider)
{
List <MVPNServer> vpnServerList = null;
IVPNServer vpnServer = Better517Na.VPNDataService.Factory.DALFactory.GetVpnServerDal(Better517Na.VPNDataService.Factory.DBOperType.read);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("Provider", provider);
mmb.AddConditionFields("IsValid", 1);
mmb.AddConditionFields("IsDelete", 0);
mmb.AddConditionFields("IsUsing", 1);
mmb.AddConditionFields("UsingServer", new GetIP().GetLocalIp("本地连接"));
mmb.AddUpdateFields("Address", null);
mmb.AddUpdateFields("KeyID", null);
mmb.AddUpdateFields("Area", null);
mmb.AddUpdateFields("Line", null);
mmb.AddUpdateFields("Provider", null);
mmb.AddUpdateFields("UsingServer", null);
vpnServerList = vpnServer.GetModel <MVPNServer>(mmb, 20);
return(vpnServerList);
}
/// <summary>
/// 获取有效VPN
/// </summary>
/// <param name="vpnProvider">vpn提供商</param>
/// <param name="keyid">起始keyid</param>
/// <param name="vpnNumber">vpn数目</param>
/// <returns>返回VPN数目</returns>
public List <MVPNServer> GetValidVpn(string vpnProvider, string keyid, int vpnNumber)
{
List <MVPNServer> vpnServerList = null;
IVPNServer vpnServer = Better517Na.VPNDataService.Factory.DALFactory.GetVpnServerDal(Better517Na.VPNDataService.Factory.DBOperType.read);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("Provider", vpnProvider);
mmb.AddConditionFields("IsValid", 1);
mmb.AddConditionFields("IsDelete", 0);
mmb.AddConditionFields("IsUsing", 0);
mmb.AddConditionFields("KeyID", keyid, DatabaseOperators.GreaterThan);
mmb.AddUpdateFields("Address", null);
mmb.AddUpdateFields("KeyID", null);
mmb.AddUpdateFields("Area", null);
mmb.AddUpdateFields("Line", null);
mmb.AddUpdateFields("Provider", null);
mmb.AddUpdateFields("UsingServer", null);
vpnServerList = vpnServer.GetModel <MVPNServer>(mmb, vpnNumber);
return(vpnServerList);
}
/// <summary>
/// 更新VPN使用状态
/// </summary>
/// <param name="vpnServer">vpnServer</param>
/// <returns>返回更新结果</returns>
public bool UpdateVpnUseStatu(MVPNServer vpnServer)
{
IVPNServer ivpnServer = Better517Na.VPNDataService.Factory.DALFactory.GetVpnServerDal(Better517Na.VPNDataService.Factory.DBOperType.write);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("KeyID", vpnServer.KeyID);
mmb.AddUpdateFields("IsUsing", 1);
mmb.AddUpdateFields("IsUsingDesc", "使用中");
mmb.AddUpdateFields("UsingServer", new GetIP().GetLocalIp("本地连接"));
return ivpnServer.Update<MVPNServer>(vpnServer, mmb) > 0;
}
/// <summary>
/// 释放VPN账号
/// </summary>
/// <param name="vpnAccount">vpn账号对象信息</param>
/// <returns>返回释放结果</returns>
public bool ReleaseVpnAccountState(MVPNAccount vpnAccount)
{
IVPNAccount ivpnAccount = Better517Na.VPNDataService.Factory.DALFactory.GetVpnAccountDal(Better517Na.VPNDataService.Factory.DBOperType.write);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("KeyID", vpnAccount.KeyID);
mmb.AddUpdateFields("IsUsing", 0);
mmb.AddUpdateFields("IsUsingDesc", "未使用");
mmb.AddUpdateFields("UsingServer", string.Empty);
return ivpnAccount.Update<MVPNAccount>(vpnAccount, mmb) > 0;
}
/// <summary>
/// 根据本机获取一个VPN账号
/// </summary>
/// <returns>返回账号</returns>
public MVPNAccount GetVpnAccountByIP()
{
MVPNAccount vpnAccount = null;
IVPNAccount ivpnAccount = Better517Na.VPNDataService.Factory.DALFactory.GetVpnAccountDal(Better517Na.VPNDataService.Factory.DBOperType.read);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("IsValid", 1);
mmb.AddConditionFields("IsDelete", 0);
mmb.AddConditionFields("UsingServer", new GetIP().GetLocalIp("本地连接"));
mmb.AddUpdateFields("KeyID", null);
mmb.AddUpdateFields("Account", null);
mmb.AddUpdateFields("Password", null);
mmb.AddUpdateFields("Provider", null);
vpnAccount = ivpnAccount.GetModel<MVPNAccount>(mmb);
return vpnAccount;
}
/// <summary>
/// 获取有效VPN
/// </summary>
/// <param name="vpnProvider">vpn提供商</param>
/// <param name="keyid">起始keyid</param>
/// <param name="vpnNumber">vpn数目</param>
/// <returns>返回VPN数目</returns>
public List<MVPNServer> GetValidVpn(string vpnProvider, string keyid, int vpnNumber)
{
List<MVPNServer> vpnServerList = null;
IVPNServer vpnServer = Better517Na.VPNDataService.Factory.DALFactory.GetVpnServerDal(Better517Na.VPNDataService.Factory.DBOperType.read);
MModelBase mmb = new MModelBase();
mmb.AddConditionFields("Provider", vpnProvider);
mmb.AddConditionFields("IsValid", 1);
mmb.AddConditionFields("IsDelete", 0);
mmb.AddConditionFields("IsUsing", 0);
mmb.AddConditionFields("KeyID", keyid, DatabaseOperators.GreaterThan);
mmb.AddUpdateFields("Address", null);
mmb.AddUpdateFields("KeyID", null);
mmb.AddUpdateFields("Area", null);
mmb.AddUpdateFields("Line", null);
mmb.AddUpdateFields("Provider", null);
mmb.AddUpdateFields("UsingServer", null);
vpnServerList = vpnServer.GetModel<MVPNServer>(mmb, vpnNumber);
return vpnServerList;
}
