import com.openbravo.pos.payment.PaymentInfoTicket; //导入依赖的package包/类
public final TicketInfo loadTicket(final int tickettype, final int ticketid) throws BasicException {
    TicketInfo ticket = (TicketInfo) new PreparedSentence(s
            , "SELECT T.ID, T.TICKETTYPE, T.TICKETID, R.DATENEW, R.MONEY, R.ATTRIBUTES, P.ID, P.NAME, T.CUSTOMER FROM RECEIPTS R JOIN TICKETS T ON R.ID = T.ID LEFT OUTER JOIN PEOPLE P ON T.PERSON = P.ID WHERE T.TICKETTYPE = ? AND T.TICKETID = ?"
            , SerializerWriteParams.INSTANCE
            , new SerializerReadClass(TicketInfo.class))
            .find(new DataParams() { public void writeValues() throws BasicException {
                setInt(1, tickettype);
                setInt(2, ticketid);
            }});
    if (ticket != null) {

        String customerid = ticket.getCustomerId();
        ticket.setCustomer(customerid == null
                ? null
                : loadCustomerExt(customerid));

        ticket.setLines(new PreparedSentence(s
            , "SELECT L.TICKET, L.LINE, L.PRODUCT, L.ATTRIBUTESETINSTANCE_ID, L.UNITS, L.PRICE, T.ID, T.NAME, T.CATEGORY, T.VALIDFROM, T.CUSTCATEGORY, T.PARENTID, T.RATE, T.RATECASCADE, T.RATEORDER, L.ATTRIBUTES " +
              "FROM TICKETLINES L, TAXES T WHERE L.TAXID = T.ID AND L.TICKET = ? ORDER BY L.LINE"
            , SerializerWriteString.INSTANCE
            , new SerializerReadClass(TicketLineInfo.class)).list(ticket.getId()));
        ticket.setPayments(new PreparedSentence(s
            , "SELECT PAYMENT, TOTAL, TRANSID FROM PAYMENTS WHERE RECEIPT = ?"
            , SerializerWriteString.INSTANCE
            , new SerializerReadClass(PaymentInfoTicket.class)).list(ticket.getId()));
    }
    return ticket;
}
 

import com.openbravo.pos.payment.PaymentInfoTicket; //导入依赖的package包/类
public List getTicketPayments(final String ticket) throws BasicException {
    return new PreparedSentence(s
            , "SELECT TOTAL, PAYMENT FROM PAYMENTS WHERE RECEIPT = ?"
            , SerializerWriteString.INSTANCE
            , new SerializerRead() {
                public Object readValues(DataRead dr) throws BasicException {
                    return new PaymentInfoTicket(
                            dr.getDouble(1),
                            dr.getString(2));
                }                
            }).list(ticket);
}
 

import com.openbravo.pos.payment.PaymentInfoTicket; //导入依赖的package包/类
/**
     *
     * @param tickettype
     * @param ticketid
     * @return
     * @throws BasicException
     */
    public final TicketInfo loadTicket(final int tickettype, final int ticketid) throws BasicException {
        TicketInfo ticket = (TicketInfo) new PreparedSentence(s
                , "SELECT "
                + "T.ID, "
                + "T.TICKETTYPE, "
                + "T.TICKETID, "
                + "R.DATENEW, "
                + "R.MONEY, "
                + "R.ATTRIBUTES, "
                + "P.ID, "
                + "P.NAME, "
                + "T.CUSTOMER "
                + "FROM RECEIPTS R "
                + "JOIN TICKETS T ON R.ID = T.ID "
                + "LEFT OUTER JOIN PEOPLE P ON T.PERSON = P.ID "
                + "WHERE T.TICKETTYPE = ? AND T.TICKETID = ? "
                + "ORDER BY R.DATENEW DESC"
                , SerializerWriteParams.INSTANCE
                , new SerializerReadClass(TicketInfo.class))
                .find(new DataParams() {@Override
 public void writeValues() throws BasicException {
                    setInt(1, tickettype);
                    setInt(2, ticketid);
                }});
        if (ticket != null) {

            String customerid = ticket.getCustomerId();
            ticket.setCustomer(customerid == null
                    ? null
                    : loadCustomerExt(customerid));

            ticket.setLines(new PreparedSentence(s
                , "SELECT L.TICKET, L.LINE, L.PRODUCT, L.ATTRIBUTESETINSTANCE_ID, L.UNITS, L.PRICE, T.ID, T.NAME, T.CATEGORY, T.CUSTCATEGORY, T.PARENTID, T.RATE, T.RATECASCADE, T.RATEORDER, L.ATTRIBUTES " +
                  "FROM TICKETLINES L, TAXES T WHERE L.TAXID = T.ID AND L.TICKET = ? ORDER BY L.LINE"
                , SerializerWriteString.INSTANCE
                , new SerializerReadClass(TicketLineInfo.class)).list(ticket.getId()));
            ticket.setPayments(new PreparedSentence(s
// JG 10 Oct 13 Bug Fix + Add Cardname 20 Oct  
//                    , "SELECT PAYMENT, TOTAL, TRANSID TENDERED FROM PAYMENTS WHERE RECEIPT = ?" 
                    , "SELECT PAYMENT, TOTAL, TRANSID, TENDERED, CARDNAME FROM PAYMENTS WHERE RECEIPT = ?"
                , SerializerWriteString.INSTANCE
                , new SerializerReadClass(PaymentInfoTicket.class)).list(ticket.getId()));
        }
        return ticket;
    }
 

import com.openbravo.pos.payment.PaymentInfoTicket; //导入依赖的package包/类
private void btnPayActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnPayActionPerformed

        paymentdialog.setPrintSelected(true);

        if (paymentdialog.showDialog(customerext.getCurdebt(), null)) {

            // Save the ticket
            TicketInfo ticket = new TicketInfo();
            ticket.setTicketType(TicketInfo.RECEIPT_PAYMENT);

            List<PaymentInfo> payments = paymentdialog.getSelectedPayments();

            double total = 0.0;
            for (PaymentInfo p : payments) {
                total += p.getTotal();
            }

            payments.add(new PaymentInfoTicket(-total, "debtpaid"));

            ticket.setPayments(payments);

            ticket.setUser(app.getAppUserView().getUser().getUserInfo());
            ticket.setActiveCash(app.getActiveCashIndex());
            ticket.setDate(new Date());
            ticket.setCustomer(customerext);

            try {
                dlsales.saveTicket(ticket, app.getInventoryLocation());
            } catch (BasicException eData) {
                MessageInf msg = new MessageInf(MessageInf.SGN_NOTICE, AppLocal.getIntString("message.nosaveticket"), eData);
                msg.show(this);
            }

            editCustomer(readCustomer(customerext.getId(), null));

            printTicket(paymentdialog.isPrintSelected()
                    ? PRINT_CUSTOMER_PAID
                    : PRINT_CUSTOMER_PAID_2,
                    ticket, customerext);
        }

        editorcard.reset();
        editorcard.activate();

}