public static void Show(string lg1)
{
Console.ForegroundColor = ConsoleColor.Yellow;
Console.Write(prefix + ": ");
Console.ForegroundColor = ConsoleColor.Green;
Console.Write(lg1 + "\n");
Console.ForegroundColor = ConsoleColor.Gray;
}
| LogConsole::Show ( string lg1, object arg0 ) : void | |
| LogConsole::Show ( string lg1, object arg0, object arg1 ) : void | |
| LogConsole::Show ( string lg1, object arg0, object arg1, object arg2 ) : void | |
| LogConsole::Show ( string lg1, object arg0, object arg1, object arg2, object arg3 ) : void | |
| LogConsole::Show ( string lg1, object arg0, object arg1, object arg2, object arg3, object arg4 ) : void |
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);
}