/// <summary>
/// 检查一个用户名是否存在
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public bool IsExistUser(string username)
{
DataTable dt = _odbc.GetDataTable("select user from mysql.user");
ArrayList _array = new ArrayList();
foreach (DataRow row in dt.Rows)
{
_array.Add(row[0]);
}
string[] nameArr = (string[])_array.ToArray(typeof(string));
dt.Clear();
dt.Dispose();
return(SmString.FindFormStringArray(nameArr, username));
}
/// <summary>
/// 检查数据库是否存在
/// </summary>
/// <param name="database">要检查的数据库</param>
/// <returns></returns>
public bool IsExistDatabase(string database)
{
DataTable dt = _odbc.GetDataTable("SHOW DATABASES");
ArrayList _array = new ArrayList();
foreach (DataRow row in dt.Rows)
{
_array.Add(row[0]);
}
string[] nameArr = (string[])_array.ToArray(typeof(string));
dt.Clear();
dt.Dispose();
return(SmString.FindFormStringArray(nameArr, database));
}
/// <summary>
/// 检查数据库是否存在
/// </summary>
/// <param name="database">要检查的数据库</param>
/// <returns></returns>
public bool IsExistDatabase(string database)
{
DataTable dt = _mssql.GetDataTable("Select Name From Master..SysDatabases");
ArrayList _array = new ArrayList();
foreach (DataRow row in dt.Rows)
{
_array.Add(row[0]);
}
string[] nameArr = (string[])_array.ToArray(typeof(string));
dt.Clear();
dt.Dispose();
return(SmString.FindFormStringArray(nameArr, database));
}
/// <summary>
/// 检查一个用户名是否存在
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public bool IsExistUser(string username)
{
DataTable dt = _mssql.GetDataTable("select Name from Master..syslogins where isntname=0");
ArrayList _array = new ArrayList();
foreach (DataRow row in dt.Rows)
{
_array.Add(row[0]);
}
string[] nameArr = (string[])_array.ToArray(typeof(string));
dt.Clear();
dt.Dispose();
return(SmString.FindFormStringArray(nameArr, username));
}
/// <summary>
///
/// </summary>
/// <param name="port"></param>
/// <param name="protocol"></param>
/// <param name="enable"></param>
/// <param name="name"></param>
public static void AddSharedAccessFirewallPort(int port, InternetProtocol protocol, bool enable, string name)
{
string protocolStr = "";
string enableStr = "";
if (protocol == InternetProtocol.Tcp)
{
protocolStr = "TCP";
}
else if (protocol == InternetProtocol.Udp)
{
protocolStr = "UDP";
}
if (enable)
{
enableStr = "Enabled";
}
else
{
enableStr = "Disabled";
}
string portStr = port.ToString();
RegistryKey k1 = Registry.LocalMachine.OpenSubKey(@"SYSTEM\CurrentControlSet\Services\SharedAccess\Parameters\FirewallPolicy\StandardProfile", true);
if (!SmString.FindFormStringArray(k1.GetSubKeyNames(), "GloballyOpenPorts"))
{
k1.CreateSubKey("GloballyOpenPorts");
}
k1.Close();
RegistryKey k2 = Registry.LocalMachine.OpenSubKey(@"SYSTEM\CurrentControlSet\Services\SharedAccess\Parameters\FirewallPolicy\StandardProfile\GloballyOpenPorts", true);
if (!SmString.FindFormStringArray(k2.GetSubKeyNames(), "List"))
{
k2.CreateSubKey("List");
}
k2.Close();
RegistryKey k3 = Registry.LocalMachine.OpenSubKey(@"SYSTEM\CurrentControlSet\Services\SharedAccess\Parameters\FirewallPolicy\StandardProfile\GloballyOpenPorts\List", true);
k3.SetValue(portStr + ":" + protocolStr, portStr + ":" + protocolStr + ":*:" + enableStr + ":" + name, RegistryValueKind.String);
k3.Close();
}
