/// <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="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="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);
}
