public override string GetInsertSQL()
{
return(String.Format(@"insert into table_receiptitem
(
rec_id,
cus_id,
ccy_id,
reci_amount,
vbe_id,
vb_id,
reci_entrytype,
reci_invoicedate,
reci_invoiceno,
reci_duedate,
emp_id,
reci_discount,
reci_amountbeforediscount,
top_id,
reci_description,
reci_notes,
inv_id,
inv_type,
bank_id,
reci_receipttype,
arcr_id
)
VALUES ({0},{1},{2},{3},{4},{5},'{6}','{7}','{8}','{9}',{10},{11},{12},{13},
'{14}','{15}',{16},'{17}',{18},'{19}',{20})",
EVENT_JOURNAL.ID,
VENDOR.ID,
CURRENCY.ID,
AMOUNT,
VENDOR_BALANCE_ENTRY == null?0:VENDOR_BALANCE_ENTRY.ID,
VENDOR_BALANCE == null?0:VENDOR_BALANCE.ID,
VendorBalanceEntryType.Receipt.ToString(),
INVOICE_DATE.ToString(Utils.DATE_FORMAT),
INVOICE_NO,
DUE_DATE.ToString(Utils.DATE_FORMAT),
EMPLOYEE.ID,
DISCOUNT,
AMOUNT_BEFORE_DISCOUNT,
TOP == null?0:TOP.ID,
DESCRIPTION,
NOTES,
CUSTOMER_INVOICE_JOURNAL_ITEM.GetID(),
VENDOR_BALANCE_CUSTOMER_INVOICE_TYPE.ToString(),
BANK == null?0:BANK.ID,
PAYMENT_TYPE.ToString(),
AR_CREDIT_NOTE == null?0:AR_CREDIT_NOTE.ID
));
}
public string GetInsertSQL()
{
return(String.Format(@"insert into table_vendorbalanceentry
(
vb_id,
vbe_vendorbalanceentrytype,
vbe_date,
ccy_id,
vbe_amount,
eventjournalitem_id
)
VALUES ({0},'{1}','{2}',{3},{4},{5})",
VENDOR_BALANCE.ID,
VENDOR_BALANCE_ENTRY_TYPE.ToString(),
TRANSACTION_DATE.ToString(Utils.DATE_FORMAT),
CURRENCY.ID,
AMOUNT,
EVENT_JOURNAL_ITEM.ID
));
}
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 string FindByEventJournalItem(int id, VendorBalanceEntryType type)
{
return(String.Format("Select * from table_vendorbalanceentry where eventjournalitem_id ={0} and vbe_vendorbalanceentrytype = '{1}'", id, type.ToString()));
}