public static StockTaking GetHeaderOnly(MySql.Data.MySqlClient.MySqlCommand cmd, int poID) { cmd.CommandText = StockTaking.GetByIDSQL(poID); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); StockTaking st = StockTaking.TransformReader(r); r.Close(); return(st); }
protected override Event doGet(int ID) { m_command.CommandText = StockTaking.GetByIDSQL(ID); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); StockTaking st = StockTaking.TransformReader(r); r.Close(); m_command.CommandText = StockTakingItems.GetByEventIDSQL(ID); r = m_command.ExecuteReader(); IList stis = StockTakingItems.TransformReaderList(r); r.Close(); foreach (StockTakingItems sti in stis) { sti.EVENT = st; sti.PART = PartRepository.GetByID(m_command, sti.PART.ID); sti.STOCK_CARD_ENTRY = StockCardEntryRepository.FindStockCardEntryByEventItem(m_command, sti.ID, sti.STOCK_CARD_ENTRY_TYPE); st.EVENT_ITEMS.Add(sti); } return(st); }