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