public static GoodReceiveNote GetHeaderOnly(MySql.Data.MySqlClient.MySqlCommand cmd, int grnID) { cmd.CommandText = GoodReceiveNote.GetByIDSQL(grnID); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); GoodReceiveNote st = GoodReceiveNote.TransformReader(r); r.Close(); return(st); }
public IList FindPObyPartAndGRNNo(string find, IList exceptGRNI, int supplierID, DateTime trDate) { StringBuilder poisSB = new StringBuilder(); foreach (int i in exceptGRNI) { poisSB.Append(i.ToString()); poisSB.Append(','); } string pois = poisSB.ToString(); pois = exceptGRNI.Count > 0 ? pois.Substring(0, pois.Length - 1) : ""; m_command.CommandText = GoodReceiveNoteItem.GetSearchByPartAndGRNNo(find, supplierID, pois, trDate); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); IList result = GoodReceiveNoteItem.TransformReaderList(r); r.Close(); foreach (GoodReceiveNoteItem t in result) { m_command.CommandText = GoodReceiveNote.GetByIDSQL(t.EVENT.ID); r = m_command.ExecuteReader(); t.EVENT = GoodReceiveNote.TransformReader(r); r.Close(); m_command.CommandText = Part.GetByIDSQLStatic(t.PART.ID); r = m_command.ExecuteReader(); t.PART = Part.GetPart(r); r.Close(); m_command.CommandText = Unit.GetByIDSQLstatic(t.UNIT.ID); r = m_command.ExecuteReader(); t.UNIT = Unit.GetUnit(r); r.Close(); m_command.CommandText = Warehouse.GetByIDSQLStatic(t.WAREHOUSE.ID); r = m_command.ExecuteReader(); t.WAREHOUSE = Warehouse.GetWarehouse(r); r.Close(); m_command.CommandText = Unit.GetByIDSQLstatic(t.PART.UNIT.ID); r = m_command.ExecuteReader(); t.PART.UNIT = Unit.GetUnit(r); r.Close(); } return(result); }
public static GoodReceiveNoteItem FindPOItem(MySql.Data.MySqlClient.MySqlCommand cmd, int PoIID) { cmd.CommandText = GoodReceiveNoteItem.FindByPOItemIDSQL(PoIID); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); GoodReceiveNoteItem res = GoodReceiveNoteItem.TransformReader(r); r.Close(); if (res == null) { return(res); } cmd.CommandText = GoodReceiveNote.GetByIDSQL(res.EVENT.ID); r = cmd.ExecuteReader(); res.EVENT = GoodReceiveNote.TransformReader(r); r.Close(); return(res); }
protected override Event doGet(int ID) { m_command.CommandText = GoodReceiveNote.GetByIDSQL(ID); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); GoodReceiveNote st = GoodReceiveNote.TransformReader(r); r.Close(); m_command.CommandText = GoodReceiveNoteItem.GetByEventIDSQL(ID); r = m_command.ExecuteReader(); IList stis = GoodReceiveNoteItem.TransformReaderList(r); r.Close(); foreach (GoodReceiveNoteItem 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.PO_ITEM = PurchaseOrderRepository.FindPurchaseOrderItem(m_command, sti.PO_ITEM.ID); sti.PO_ITEM.PART = PartRepository.GetByID(m_command, sti.PO_ITEM.PART.ID); st.EVENT_ITEMS.Add(sti); } return(st); }
public IList FindGRNItemlistBySupplierDate(string find, int supID, DateTime trdate, IList grnIDS) { m_command.CommandText = SupplierInvoiceItem.GetGRNUseBySupplierInvoice(); MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); if (r.HasRows) { while (r.Read()) { int id = Convert.ToInt32(r[0]); if (!grnIDS.Contains(id)) { grnIDS.Add(id); } } } r.Close(); StringBuilder poisSB = new StringBuilder(); foreach (int i in grnIDS) { poisSB.Append(i.ToString()); poisSB.Append(','); } string pois = poisSB.ToString(); pois = grnIDS.Count > 0 ? pois.Substring(0, pois.Length - 1) : ""; if (find == "") { m_command.CommandText = GoodReceiveNoteItem.GetGRNItemBySuppDate(supID, trdate, pois); } else { m_command.CommandText = GoodReceiveNoteItem.GetSearchByPartAndGRNNo(find, supID, pois, trdate); } r = m_command.ExecuteReader(); IList result = GoodReceiveNoteItem.TransformReaderList(r); r.Close(); foreach (GoodReceiveNoteItem t in result) { m_command.CommandText = GoodReceiveNote.GetByIDSQL(t.EVENT.ID); r = m_command.ExecuteReader(); t.EVENT = GoodReceiveNote.TransformReader(r); r.Close(); m_command.CommandText = Part.GetByIDSQLStatic(t.PART.ID); r = m_command.ExecuteReader(); t.PART = Part.GetPart(r); r.Close(); m_command.CommandText = Unit.GetByIDSQLstatic(t.UNIT.ID); r = m_command.ExecuteReader(); t.UNIT = Unit.GetUnit(r); r.Close(); m_command.CommandText = Warehouse.GetByIDSQLStatic(t.WAREHOUSE.ID); r = m_command.ExecuteReader(); t.WAREHOUSE = Warehouse.GetWarehouse(r); r.Close(); m_command.CommandText = Unit.GetByIDSQLstatic(t.PART.UNIT.ID); r = m_command.ExecuteReader(); t.PART.UNIT = Unit.GetUnit(r); r.Close(); } return(result); }