Ejemplo n.º 1
0
        internal static IList FindPaidCustomerInvoice(MySql.Data.MySqlClient.MySqlCommand cmd, int siID)
        {
            cmd.CommandText = PaymentItem.GetSupplierInvoiceBySOIID(siID, VendorBalanceEntryType.CustomerInvoice);
            MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
            IList result = PaymentItem.TransformReaderList(r);

            r.Close();
            foreach (PaymentItem i in result)
            {
                cmd.CommandText = Payment.GetByIDSQL(i.EVENT_JOURNAL.ID);
                r = cmd.ExecuteReader();
                i.EVENT_JOURNAL = Payment.TransformReader(r);
                r.Close();
            }
            return(result);
        }