public ReceiptItem FindReceiptItemByCIJ(int CIId) { string sql = ReceiptItem.GetCustomerInvoiceBySOIID(CIId, VendorBalanceEntryType.CustomerInvoice); m_command.CommandText = sql; MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader(); ReceiptItem rest = ReceiptItem.TransformReader(r); r.Close(); return(rest); }
internal static IList FindPaidCustomerInvoice(MySql.Data.MySqlClient.MySqlCommand cmd, int siID) { cmd.CommandText = ReceiptItem.GetCustomerInvoiceBySOIID(siID, VendorBalanceEntryType.CustomerInvoice); MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader(); IList result = ReceiptItem.TransformReaderList(r); r.Close(); foreach (ReceiptItem i in result) { cmd.CommandText = Receipt.GetByIDSQL(i.EVENT_JOURNAL.ID); r = cmd.ExecuteReader(); i.EVENT_JOURNAL = Receipt.TransformReader(r); r.Close(); } return(result); }