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