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);
}
