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