public static SalesReturn GetHeaderOnly(MySql.Data.MySqlClient.MySqlCommand cmd, int prnID)
{
cmd.CommandText = SalesReturn.GetByIDSQL(prnID);
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
SalesReturn st = SalesReturn.TransformReader(r);
r.Close();
return(st);
}
public static SalesReturnItem FindDOItem(MySql.Data.MySqlClient.MySqlCommand cmd, int grnIID)
{
cmd.CommandText = SalesReturnItem.FindByDOItemIDSQL(grnIID);
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
SalesReturnItem res = SalesReturnItem.TransformReader(r);
r.Close();
if (res == null)
{
return(null);
}
cmd.CommandText = SalesReturn.GetByIDSQL(res.EVENT.ID);
r = cmd.ExecuteReader();
res.EVENT = SalesReturn.TransformReader(r);
r.Close();
return(res);
}
protected override Event doGet(int ID)
{
m_command.CommandText = SalesReturn.GetByIDSQL(ID);
MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
SalesReturn st = SalesReturn.TransformReader(r);
r.Close();
m_command.CommandText = SalesReturnItem.GetByEventIDSQL(ID);
r = m_command.ExecuteReader();
IList stis = SalesReturnItem.TransformReaderList(r);
r.Close();
foreach (SalesReturnItem 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);
sti.DO_ITEM = DeliveryOrderRepository.FindDeliveryOrderItem(m_command, sti.DO_ITEM.ID);
sti.DO_ITEM.PART = PartRepository.GetByID(m_command, sti.DO_ITEM.PART.ID);
st.EVENT_ITEMS.Add(sti);
}
return(st);
}