/// <summary>
/// 添加代理信息
/// </summary>
/// <param name="proxyInfo">代理信息</param>
/// <returns>状态</returns>
public int AddProxyInfo(ProxyInfo proxyInfo)
{
String sql = String.Format("INSERT INTO PROXYINFOS(TYPE, IP, PORT, NAME, PASSWORD, DOMAIN, USE) values ({0},'{1}',{2},'{3}','{4}','{5}',{6})",
proxyInfo.m_type, CStrA.GetDBString(proxyInfo.m_ip), proxyInfo.m_port, CStrA.GetDBString(proxyInfo.m_name),
CStrA.GetDBString(proxyInfo.m_pwd), CStrA.GetDBString(proxyInfo.m_domain), proxyInfo.m_use ? 1 : 0);
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
/// <summary>
/// 添加服务器
/// </summary>
/// <param name="serverInfo">服务器信息</param>
/// <returns>状态</returns>
public int AddServer(ServerInfo serverInfo)
{
String sql = String.Format("INSERT INTO SERVERS(ID, IP, PORT, TYPE) values ('{0}','{1}', {2}, '{3}')",
CStrA.GetDBString(serverInfo.m_id), CStrA.GetDBString(serverInfo.m_ip), serverInfo.m_port, CStrA.GetDBString(serverInfo.m_type));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
/// <summary>
/// 删除服务
/// </summary>
/// <param name="id">编号</param>
/// <returns>状态</returns>
public int DeleteServer(String id)
{
String sql = String.Format("DELETE FROM SERVERS WHERE ID = '{0}'", CStrA.GetDBString(id));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
conn.Open();
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
/// <summary>
/// 更新服务器信息
/// </summary>
/// <param name="serverInfo">服务器信息</param>
/// <returns>状态</returns>
public void UpdateServer(ServerInfo serverInfo)
{
String sql = String.Format("UPDATE SERVERS SET IP = '{0}', PORT = {1}, TYPE = '{2}' WHERE ID = '{3}'",
CStrA.GetDBString(serverInfo.m_ip), serverInfo.m_port, CStrA.GetDBString(serverInfo.m_type), CStrA.GetDBString(serverInfo.m_id));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
/// <summary>
/// 更新连接信息
/// </summary>
/// <param name="connectInfo">连接信息</param>
/// <returns>状态</returns>
public int UpdateConnect(ConnectInfo connectInfo)
{
String sql = String.Format("UPDATE CONNECTS SET IP = '{0}', PORT = {1}, TYPE = '{2}' WHERE ID = '{3}'",
CStrA.GetDBString(connectInfo.m_ip), connectInfo.m_port, CStrA.GetDBString(connectInfo.m_type), CStrA.GetDBString(connectInfo.m_id));
SQLiteConnection conn = new SQLiteConnection(m_connectStr);
SQLiteCommand cmd = conn.CreateCommand();
cmd.CommandText = sql;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
return(1);
}
