public override string GetInsertSQL() { return(String.Format(@"insert into table_goodreceivenoteitem ( grn_id, part_id, warehouse_id, grni_amount, sce_id, grn_scentrytype, sc_id, unit_id, grni_notes, poi_id, grni_againstprstatus, grni_outstandingamtpr, grni_returnedamount ) VALUES ({0},{1},{2},{3},{4},'{5}',{6},{7},'{8}',{9},'{10}',{11},{12})", EVENT.ID, PART.ID, WAREHOUSE.ID, QYTAMOUNT, STOCK_CARD_ENTRY == null ? 0 : STOCK_CARD_ENTRY.ID, StockCardEntryType.GoodReceiveNote.ToString(), STOCK_CARD == null ? 0 : STOCK_CARD.ID, UNIT.ID, NOTES, PO_ITEM == null?0:PO_ITEM.ID, AGAINST_PR_STATUS.ToString(), GetAmountInSmallestUnit(), //OUTSTANDING_AMOUNT_TO_PR, 0 //RETURNED_AMOUNT )); }
public override string GetInsertSQL() { return(String.Format(@"insert into table_purchaseorderitem ( po_id, part_id, warehouse_id, poi_amount, sce_id, poi_scentrytype, sc_id, unit_id, poi_price, poi_discpercent, poi_discamount, poi_totaldisc, poi_subtotal, poi_notes, poi_disca, poi_discb, poi_discc, poi_discabc, poi_againstgrnstatus, poi_outstandingamounttogrn, poi_receivedamount, poi_priceinsmallestunit ) VALUES ({0},{1},{2},{3},{4},'{5}',{6},{7},{8},{9},{10},{11},{12},'{13}',{14}, {15},{16},'{17}','{18}',{19},{20},{21})", EVENT.ID, PART.ID, WAREHOUSE.ID, QYTAMOUNT, STOCK_CARD_ENTRY == null ? 0 : STOCK_CARD_ENTRY.ID, StockCardEntryType.PurchaseOrder.ToString(), STOCK_CARD == null ? 0 : STOCK_CARD.ID, UNIT.ID, PRICE, DISC_PERCENT, DISC_AMOUNT, TOTAL_DISCOUNT, SUBTOTAL, NOTES, DISC_A, DISC_B, DISC_C, DISC_ABC, AGAINST_GRN_STATUS.ToString(), GetAmountInSmallestUnit(), //OUTSTANDING_AMOUNT_TO_GRN, 0, //RECEIVED_AMOUNT, UNIT.ID == PART.UNIT.ID?PRICE :PRICE / GetAmountInSmallestUnit() //-----kalau Unit lain baru dibagi )); }
public override string GetInsertSQL() { return(String.Format(@"insert into table_salesorderitem ( so_id, part_id, warehouse_id, soi_amount, sce_id, soi_scentrytype, sc_id, unit_id, soi_price, soi_discpercent, soi_discamount, soi_totaldisc, soi_subtotal, soi_notes, soi_disca, soi_discb, soi_discc, soi_discabc, soi_againstdostatus, soi_outstandingamounttodo, soi_deliveredamount, soi_priceinsmallestunit ) VALUES ({0},{1},{2},{3},{4},'{5}',{6},{7},{8},{9},{10},{11},{12},'{13}',{14}, {15},{16},'{17}','{18}',{19},{20},{21})", EVENT.ID, PART.ID, WAREHOUSE.ID, QYTAMOUNT, STOCK_CARD_ENTRY == null ? 0 : STOCK_CARD_ENTRY.ID, StockCardEntryType.SalesOrder.ToString(), STOCK_CARD == null ? 0 : STOCK_CARD.ID, UNIT.ID, PRICE, DISC_PERCENT, DISC_AMOUNT, TOTAL_DISCOUNT, SUBTOTAL, NOTES, DISC_A, DISC_B, DISC_C, DISC_ABC, AGAINST_DO_STATUS.ToString(), GetAmountInSmallestUnit(), // QYTAMOUNT,//OUTSTANDING_AMOUNT_TO_DO, 0, //DELIVERED_AMOUNT, UNIT.ID == PART.UNIT.ID?PRICE :PRICE / GetAmountInSmallestUnit() )); }
public override string GetInsertSQL() { return(String.Format(@"insert into table_customerinvoicejournal ( cij_code, cij_date, cus_id, ccy_id, entry_type, cij_notes, cij_posted, cij_eventstatus, cij_subtotalamount, cij_discpercent, cij_amountafterdiscpercent, cij_discamount, cij_amountafterdiscamount, cij_otherexpense, cij_netamount, emp_id, ci_id, cij_againstreceiptstatus, pos_id, modified_by, modified_date, modified_computer ) VALUES ('{0}','{1}',{2},{3},'{4}','{5}',{6},'{7}', {8},{9},{10},{11},{12},{13},{14},{15},{16},'{17}',{18},'{19}','{20}','{21}')", CODE, TRANSACTION_DATE.ToString(Utils.DATE_FORMAT), VENDOR.ID, CURRENCY.ID, VendorBalanceEntryType.CustomerInvoice.ToString(), NOTES, POSTED, EVENT_STATUS.ToString(), SUBTOTAL_AMOUNT, DISC_PERCENT, AMOUNT_AFTER_DISC_PERCENT, DISC_AMOUNT, AMOUNT_AFTER_DISC_AMOUNT, OTHER_EXPENSE, NET_AMOUNT, EMPLOYEE.ID, CUSTOMER_INVOICE == null ? 0 : CUSTOMER_INVOICE.ID, AGAINST_RECEIPT_STATUS.ToString(), POS_INVOICE == null ? 0 : POS_INVOICE.ID, MODIFIED_BY, DateTime.Now.ToString(Utils.DATE_FORMAT), MODIFIED_COMPUTER_NAME )); }
public override string GetInsertSQL() { return(String.Format(@"insert into table_supplieroutstandinginvoice ( sosti_code, sosti_date, sup_id, ccy_id, entry_type, sosti_notes, sosti_posted, sosti_eventstatus, sosti_subtotalamount, sosti_discpercent, sosti_amountafterdiscpercent, sosti_discamount, sosti_amountafterdiscamount, sosti_otherexpense, sosti_netamount, emp_id, sosti_againstpaymentstatus, modified_by, modified_date, modified_computer ) VALUES ('{0}','{1}',{2},{3},'{4}','{5}',{6},'{7}',{8},{9},{10},{11},{12},{13},{14},{15},'{16}','{17}','{18}','{19}')", CODE, TRANSACTION_DATE.ToString(Utils.DATE_FORMAT), VENDOR.ID, CURRENCY.ID, VendorBalanceEntryType.SupplierOutStandingInvoice.ToString(), NOTES, POSTED, EVENT_STATUS.ToString(), SUBTOTAL_AMOUNT, DISC_PERCENT, AMOUNT_AFTER_DISC_PERCENT, DISC_AMOUNT, AMOUNT_AFTER_DISC_AMOUNT, OTHER_EXPENSE, NET_AMOUNT, EMPLOYEE.ID, AGAINST_PAYMENT_STATUS.ToString(), MODIFIED_BY, DateTime.Now.ToString(Utils.DATE_FORMAT), MODIFIED_COMPUTER_NAME )); }
public override string GetInsertSQL() { return(String.Format(@"insert into table_supplieroutstandinginvoiceitem ( sosti_id, sup_id, ccy_id, sostii_amount, vbe_id, vb_id, sostii_entrytype, sostii_invoicedate, sostii_invoiceno, sostii_duedate, emp_id, sostii_discount, sostii_amountbeforediscount, top_id, sostii_description, sostii_notes, sostii_againstpaymentstatus, sostii_outstandingamount, sostii_paidamount ) VALUES ({0},{1},{2},{3},{4},{5},'{6}','{7}','{8}','{9}',{10},{11},{12},{13},'{14}','{15}' ,'{16}',{17},{18})", 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.SupplierOutStandingInvoice.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_PAYMENT_STATUS.ToString(), AMOUNT, 0 )); }
public override string GetInsertSQL() { return(String.Format(@"insert into table_goodreceivenote ( grn_date, grn_noticedate, grn_scentrytype, emp_id, grn_notes, grn_posted, grn_eventstatus, grn_againstprstatus, grn_code, sup_id, grn_docno, grn_docdate, modified_by, modified_date, modified_computer ) VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}','{7}','{8}',{9},'{10}','{11}','{12}','{13}','{14}')", TRANSACTION_DATE.ToString(Utils.DATE_FORMAT), NOTICE_DATE.ToString(Utils.DATE_FORMAT), StockCardEntryType.GoodReceiveNote.ToString(), EMPLOYEE.ID, NOTES, POSTED, EVENT_STATUS.ToString(), AGAINST_PR_STATUS.ToString(), CODE, SUPPLIER == null ? 0 : SUPPLIER.ID, DOCUMENT_NO, DOCUMENT_DATE.ToString(Utils.DATE_FORMAT), MODIFIED_BY, DateTime.Now.ToString(Utils.DATE_FORMAT), MODIFIED_COMPUTER_NAME )); }
public override string GetInsertSQL() { return(String.Format(@"insert into table_deliveryorder ( do_date, do_noticedate, do_scentrytype, emp_id, do_notes, do_posted, do_eventstatus, do_againstprstatus, do_code, cus_id, do_docno, do_docdate, modified_by, modified_date, modified_computer ) VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}','{7}','{8}',{9},'{10}','{11}','{12}','{13}','{14}')", TRANSACTION_DATE.ToString(Utils.DATE_FORMAT), NOTICE_DATE.ToString(Utils.DATE_FORMAT), StockCardEntryType.DeliveryOrder.ToString(), EMPLOYEE.ID, NOTES, POSTED, EVENT_STATUS.ToString(), AGAINST_SR_STATUS.ToString(), CODE, CUSTOMER == null ? 0 : CUSTOMER.ID, DOCUMENT_NO, DOCUMENT_DATE.ToString(Utils.DATE_FORMAT), MODIFIED_BY, DateTime.Now.ToString(Utils.DATE_FORMAT), MODIFIED_COMPUTER_NAME )); }
public override string GetInsertSQL() { return(String.Format(@"insert into table_purchaseorder ( po_date, po_noticedate, po_scentrytype, emp_id, po_notes, po_posted, po_eventstatus, div_id, top_id, po_duedate, ccy_id, po_subtotal, po_discpercent, po_discafteramount, po_discamount, tax_id, po_taxafteramount, po_otherexpense, po_nettotal, po_againsgrnstatus, po_code, sup_id, po_docno, po_docdate, modified_by, modified_date, modified_computer ) VALUES ('{0}','{1}','{2}',{3},'{4}',{5},'{6}',{7},{8},'{9}',{10}, {11},{12},{13},{14},{15},{16},{17},{18},'{19}','{20}',{21},'{22}','{23}','{24}','{25}','{26}')", TRANSACTION_DATE.ToString(Utils.DATE_FORMAT), NOTICE_DATE.ToString(Utils.DATE_FORMAT), StockCardEntryType.PurchaseOrder.ToString(), EMPLOYEE.ID, NOTES, POSTED, EVENT_STATUS.ToString(), DIVISION == null ? 0 : DIVISION.ID, TOP == null ? 0 : TOP.ID, DUE_DATE.ToString(Utils.DATE_FORMAT), CURRENCY == null ? 0 : CURRENCY.ID, SUB_TOTAL, DISC_PERCENT, DISC_AFTER_AMOUNT, DISC_AMOUNT, TAX == null ? 0 : TAX.ID, TAX_AFTER_AMOUNT, OTHER_EXPENSE, NET_TOTAL, AGAINST_GRN_STATUS.ToString(), CODE, SUPPLIER == null ? 0 : SUPPLIER.ID, DOCUMENT_NO, DOCUMENT_DATE.ToString(Utils.DATE_FORMAT), MODIFIED_BY, DateTime.Now.ToString(Utils.DATE_FORMAT), MODIFIED_COMPUTER_NAME )); }