public static PartGroup GetPartGroupByID(MySql.Data.MySqlClient.MySqlCommand cmd, int unitID) { cmd.CommandText = PartGroup.GetByIDSQLstatic(unitID); MySql.Data.MySqlClient.MySqlDataReader aReader = cmd.ExecuteReader(); PartGroup a = PartGroup.GetPartGroup(aReader); aReader.Close(); return(a); }
private PartGroup GetPartGroup(MySql.Data.MySqlClient.MySqlCommand aCommand, string code, string name) { //MySql.Data.MySqlClient.MySqlCommand aCommand = new MySql.Data.MySqlClient.MySqlCommand(); aCommand.Connection = m_connection; aCommand.CommandText = PartGroup.GetByCodeSQLStatic(code.Trim()); MySql.Data.MySqlClient.MySqlDataReader r = aCommand.ExecuteReader(); PartGroup u = PartGroup.GetPartGroup(r); r.Close(); if (u == null) { u = new PartGroup(); u.CODE = code; u.NAME = name; aCommand.CommandText = u.GetInsertSQL(); aCommand.ExecuteNonQuery(); aCommand.CommandText = u.GetMaximumIDSQL(); u.ID = Convert.ToInt32(aCommand.ExecuteScalar()); } return(u); }