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)); }