public override string GetUpdateSQL()
{
return(String.Format(@"update table_customerinvoicejournalitem set
cij_id = {0},
cus_id = {1},
ccy_id = {2},
ciji_amount = {3},
vbe_id = {4},
vb_id = {5},
ciji_entrytype = '{6}',
ciji_invoicedate = '{7}',
ciji_invoiceno = '{8}',
ciji_duedate = '{9}',
emp_id = {10},
ciji_discount = {11},
ciji_amountbeforediscount = {12},
top_id = {13},
ciji_description = '{14}',
ciji_notes = '{15}',
ciji_againstpaymentstatus = '{16}',
ciji_outstandingamount = {17},
ciji_receiptamount = {18}
where ciji_id = {16}",
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.CustomerInvoice.ToString(),
INVOICE_DATE.ToString(Utils.DATE_FORMAT),
INVOICE_NO,
DUE_DATE.ToString(Utils.DATE_FORMAT),
EMPLOYEE.ID,
DISCOUNT,
AMOUNT_BEFORE_DISCOUNT,
TOP.ID,
DESCRIPTION,
NOTES,
AGAINST_RECEIPT_STATUS.ToString(),
OUTSTANDING_AMOUNT,
RECEIPT_AMOUNT,
ID));
}