public static List <RemoteCommand> load(string query) { List <RemoteCommand> list = new List <RemoteCommand>(); MySqlDataReader rd = null; try { MySqlConnection conn = Main.getConnection(); if (conn == null) { return(list); } if (query == null || query.Length == 0) { query = "select * from remote_command"; } Log.Info("Query: " + query); MySqlCommand cmd = new MySqlCommand(query, conn); rd = cmd.ExecuteReader(); while (rd.Read()) { RemoteCommand obj = new RemoteCommand(); obj.cmd_id = Convert.ToInt32(rd["cmd_id"].ToString()); // Primary obj.eqp_id = Convert.ToInt32(rd["eqp_id"].ToString()); obj.cmd_text = rd["cmd_text"].ToString(); obj.cmd_time = Convert.ToInt32(rd["cmd_time"].ToString()); list.Add(obj); } rd.Close(); } catch (MySqlException e) { Log.Error("Error: " + e.Message); } finally { if (rd != null) { rd.Close(); } } return(list); }
public static RemoteCommand load(int cmd_id) { MySqlDataReader rd = null; try { MySqlConnection conn = Main.getConnection(); if (conn == null) { return(null); } string query = "select * from remote_command where cmd_id='" + cmd_id + "'"; Log.Info("Query: " + query); MySqlCommand cmd = new MySqlCommand(query, conn); rd = cmd.ExecuteReader(); RemoteCommand obj = new RemoteCommand(); while (rd.Read()) { obj.cmd_id = Convert.ToInt32(rd["cmd_id"].ToString()); // Primary obj.eqp_id = Convert.ToInt32(rd["eqp_id"].ToString()); obj.cmd_text = rd["cmd_text"].ToString(); obj.cmd_time = Convert.ToInt32(rd["cmd_time"].ToString()); break; } rd.Close(); return(obj); } catch (MySqlException e) { Log.Error("Query: " + e.Message); } finally { if (rd != null) { rd.Close(); } } return(null); }