public int AddConfigLineInformation(ConfigLineInformation Record) { connect(); string sql = String.Format("INSERT INTO `config_line_information` (`LineName`,`StationID_Start`,`StationID_End`,`VoltageLevel`,`RatedCurrent`) VALUE ('{0}','{1}','{2}','{3}','{4}');", Record.LineName, Record.StationID_Start, Record.StationID_End, Record.VoltageLevel, Record.RatedCurrent); MySqlCommand cmd = new MySqlCommand(sql, conn); int result = cmd.ExecuteNonQuery(); return result; }
public int AddConfigLineInformation(ConfigLineInformation Record) { connect(); string sql = String.Format("INSERT INTO `config_line_information` (`LineName`,`StationID_Start`,`StationID_End`,`VoltageLevel`,`RatedCurrent`) VALUE ('{0}','{1}','{2}','{3}','{4}');", Record.LineName, Record.StationID_Start, Record.StationID_End, Record.VoltageLevel, Record.RatedCurrent); MySqlCommand cmd = new MySqlCommand(sql, conn); int result = cmd.ExecuteNonQuery(); return(result); }
public ConfigLineInformation FindConfigLineInformation(int ID) { connect(); string sql = String.Format("SELECT * FROM `config_line_information` WHERE `ID`={0};", ID); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); ConfigLineInformation Record = new ConfigLineInformation() { ID = (int)rdr["ID"], LineName = (string)rdr["LineName"], StationID_Start = (int)rdr["StationID_Start"], StationID_End = (int)rdr["StationID_End"], VoltageLevel = double.Parse((string)rdr["VoltageLevel"]), RatedCurrent = double.Parse((string)rdr["RatedCurrent"]) }; rdr.Close(); return(Record); }
public int AddConfigLineInformation(ConfigLineInformation Record) { DatabaseConnector dc = new DatabaseConnector(); return(dc.AddConfigLineInformation(Record)); }
public ConfigLineInformation FindConfigLineInformation(int ID) { connect(); string sql = String.Format("SELECT * FROM `config_line_information` WHERE `ID`={0};", ID); MySqlCommand cmd = new MySqlCommand(sql, conn); MySqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); ConfigLineInformation Record = new ConfigLineInformation() { ID = (int)rdr["ID"], LineName=(string)rdr["LineName"], StationID_Start = (int)rdr["StationID_Start"], StationID_End = (int)rdr["StationID_End"], VoltageLevel = double.Parse((string)rdr["VoltageLevel"]), RatedCurrent = double.Parse((string)rdr["RatedCurrent"]) }; rdr.Close(); return Record; }
public int AddConfigLineInformation(ConfigLineInformation Record) { DatabaseConnector dc = new DatabaseConnector(); return dc.AddConfigLineInformation(Record); }