public SQLResult Select(string sql, params object[] args) { SQLResult retData = new SQLResult(); StringBuilder sqlString = new StringBuilder(); sqlString.AppendFormat(CultureInfo.GetCultureInfo("en-US").NumberFormat, sql); MySqlCommand sqlCommand = new MySqlCommand(sqlString.ToString(), Connection); try { List <MySqlParameter> mParams = new List <MySqlParameter>(args.Length); foreach (var a in args) { mParams.Add(new MySqlParameter("", a)); } sqlCommand.Parameters.AddRange(mParams.ToArray()); SqlData = sqlCommand.ExecuteReader(CommandBehavior.Default); retData.Load(SqlData); retData.Count = retData.Rows.Count; SqlData.Close(); } catch (MySqlException ex) { LogConsole.Show("{0}", ex.Message); } return(retData); }
public bool Execute(string sql, params object[] args) { StringBuilder sqlString = new StringBuilder(); sqlString.AppendFormat(CultureInfo.GetCultureInfo("en-US").NumberFormat, sql); MySqlCommand sqlCommand = new MySqlCommand(sqlString.ToString(), Connection); try { List <MySqlParameter> mParams = new List <MySqlParameter>(args.Length); foreach (var a in args) { mParams.Add(new MySqlParameter("", a)); } sqlCommand.Parameters.AddRange(mParams.ToArray()); sqlCommand.ExecuteNonQuery(); return(true); } catch (MySqlException ex) { LogConsole.Show("{0}", ex.Message); return(false); } }
public void CommandSQL(string _comm) { using (MySqlCommand sqlCommand = new MySqlCommand(_comm, Connection)) { sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.ExecuteNonQuery(); LogConsole.Show(_comm + " Complete!"); } }
public void Init(string host, string user, string password, string database, int port) { Connection = new MySqlConnection("Server=" + host + ";User Id=" + user + ";Port=" + port + ";" + "Password="******";Database=" + database + ";Allow Zero Datetime=True"); try { Connection.Open(); LogConsole.Show("Successfully connected to {0}:{1}:{2} ", host, port, database); } catch (MySqlException ex) { LogConsole.Show("{0}", ex.Message); LogConsole.Show("Try reconnect in 5 seconds..."); Thread.Sleep(5000); Init(host, user, password, database, port); } }
static void Main(string[] args) { #region Load Settings _dir = Environment.CurrentDirectory; LogConsole._Load(); try { if (File.Exists(_dir + _file_config)) { ini = new Systems.Ini(_dir + _file_config); s_timer = ini.GetValue("Timer", "minutes", 10); max_count = ini.GetValue("Timer", "max", 100); delay = ini.GetValue("Timer", "delay", 10000); infi = ini.GetValue("Timer", "infi", false); _db_user = ini.GetValue("MYSQL", "user", "root"); _db_pass = ini.GetValue("MYSQL", "pass", "123456"); _db_ipsv = ini.GetValue("MYSQL", "ipsv", "127.0.0.1"); _db_name = ini.GetValue("MYSQL", "data", "rakion"); _db_port = ini.GetValue("MYSQL", "port", 3306); debug = ini.GetValue("CONSOLE", "debug", false); ini = null; LogConsole.Show("Has loaded your settings successfully"); } else { LogConsole.Show("Settings.ini could not be found, using default setting"); } } catch (Exception) { return; } #endregion _SQL.Init(_db_ipsv, _db_user, _db_pass, _db_name, _db_port); TimerX _t = new TimerX(s_timer, max_count, infi, delay); }