protected override Event doGet(int ID) { m_command.CommandText = CustomerInvoice.GetByIDSQL(ID); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); CustomerInvoice st = CustomerInvoice.TransformReader(r); r.Close(); m_command.CommandText = CustomerInvoiceItem.GetByEventIDSQL(ID); r = m_command.ExecuteReader(); IList stis = CustomerInvoiceItem.TransformReaderList(r); r.Close(); foreach (CustomerInvoiceItem 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); if (sti.DO_ITEM.ID > 0) { sti.DO_ITEM = DeliveryOrderRepository.FindDeliveryOrderItem(m_command, sti.DO_ITEM.ID); } st.EVENT_ITEMS.Add(sti); } return(st); }
public OpeningStock GetOpeningStockByNotes(string note) { m_command.CommandText = OpeningStock.GetByNotesSQL(note); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); OpeningStock st = OpeningStock.TransformReader(r); r.Close(); m_command.CommandText = OpeningStockItem.GetByEventIDSQL(st.ID); r = m_command.ExecuteReader(); IList stis = OpeningStockItem.TransformReaderList(r); r.Close(); foreach (OpeningStockItem 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); }
protected override Event doGet(int ID) { m_command.CommandText = PurchaseOrder.GetByIDSQL(ID); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); PurchaseOrder st = PurchaseOrder.TransformReader(r); r.Close(); m_command.CommandText = PurchaseOrderItem.GetByEventIDSQL(ID); r = m_command.ExecuteReader(); IList stis = PurchaseOrderItem.TransformReaderList(r); r.Close(); foreach (PurchaseOrderItem 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); }