public VendorBalanceEntry(VendorBalance vendorBalance, EventJournalItem item)
{
VENDOR_BALANCE = vendorBalance;
VENDOR_BALANCE_ENTRY_TYPE = item.VENDOR_BALANCE_ENTRY_TYPE;
TRANSACTION_DATE = item.EVENT_JOURNAL.TRANSACTION_DATE;
CURRENCY = item.CURRENCY;
item.VENDOR_BALANCE_ENTRY = this;
EVENT_JOURNAL_ITEM = item;
AMOUNT = item.AMOUNT;
}
public static string GetCustomerInvoiceBySOIID(int soiid, VendorBalanceEntryType invtype)
{
return(String.Format("select * from table_receiptitem where inv_id = {0} and inv_type = '{1}'", soiid, invtype.ToString()));
}
public static VendorBalanceEntry FindVendorBalanceEntryByEventItem(MySql.Data.MySqlClient.MySqlCommand cmd, int itemID, VendorBalanceEntryType scetype)
{
cmd.CommandText = VendorBalanceEntry.FindByEventJournalItem(itemID, scetype);
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
VendorBalanceEntry res = VendorBalanceEntry.TransformReader(r);
r.Close();
return(res);
}
public static string FindByEventJournalItem(int id, VendorBalanceEntryType type)
{
return(String.Format("Select * from table_vendorbalanceentry where eventjournalitem_id ={0} and vbe_vendorbalanceentrytype = '{1}'", id, type.ToString()));
}
