import com.openbravo.data.loader.SerializerReadClass; //导入依赖的package包/类
public final List<SharedTicketInfo> getSharedTicketList() throws BasicException {
    
    return (List<SharedTicketInfo>) new StaticSentence(s
            , "SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID"
            , null
            , new SerializerReadClass(SharedTicketInfo.class)).list();
}
 

import com.openbravo.data.loader.SerializerReadClass; //导入依赖的package包/类
public List getTicketLines(final String ticket) throws BasicException {
    return new PreparedSentence(s
            , "SELECT L.TICKET, L.LINE, L.PRODUCT, 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 = ?"
            , SerializerWriteString.INSTANCE
            , new SerializerReadClass(TicketLineInfo.class)).list(ticket);
}
 

import com.openbravo.data.loader.SerializerReadClass; //导入依赖的package包/类
/**
     *
     * @return
     * @throws BasicException
     */
    public final List<SharedTicketInfo> getSharedTicketList() throws BasicException {
        
        return (List<SharedTicketInfo>) new StaticSentence(s
// JG 20 Aug 13 Bug Fix: invalid SQL string
//                , "SELECT ID, NAME, CONTENT PICKUPID FROM SHAREDTICKETS ORDER BY ID"                
                , "SELECT ID, NAME, CONTENT, PICKUPID FROM SHAREDTICKETS ORDER BY ID"
                , null
                , new SerializerReadClass(SharedTicketInfo.class)).list();
    }
 

import com.openbravo.data.loader.SerializerReadClass; //导入依赖的package包/类
public List getTickets() throws BasicException {
    // TODO: Remove query on CUSTOMERS table. Ask the web service when using it.
    return new PreparedSentence(s
            , "SELECT T.ID, T.TICKETTYPE, T.TICKETID, R.DATENEW, R.MONEY, P.ID, P.NAME, C.ID, C.TAXID, C.SEARCHKEY, C.NAME FROM RECEIPTS R JOIN TICKETS T ON R.ID = T.ID LEFT OUTER JOIN PEOPLE P ON T.PERSON = P.ID LEFT OUTER JOIN CUSTOMERS C ON T.CUSTOMER = C.ID WHERE (T.TICKETTYPE = 0 OR T.TICKETTYPE = 1) AND T.STATUS = 0"
            , null
            , new SerializerReadClass(TicketInfo.class)).list();
}
 

import com.openbravo.data.loader.SerializerReadClass; //导入依赖的package包/类
public final SentenceList getRolesList() {
    return new StaticSentence(s
        , "SELECT ID, NAME FROM ROLES ORDER BY NAME"
        , null
        , new SerializerReadClass(RoleInfo.class));
}
 

import com.openbravo.data.loader.SerializerReadClass; //导入依赖的package包/类
public List getTickets() throws BasicException {
    return new PreparedSentence(s
            , "SELECT T.ID, T.TICKETTYPE, T.TICKETID, R.DATENEW, R.MONEY, P.ID, P.NAME, C.ID, C.TAXID, C.SEARCHKEY, C.NAME FROM RECEIPTS R JOIN TICKETS T ON R.ID = T.ID LEFT OUTER JOIN PEOPLE P ON T.PERSON = P.ID LEFT OUTER JOIN CUSTOMERS C ON T.CUSTOMER = C.ID WHERE (T.TICKETTYPE = 0 OR T.TICKETTYPE = 1) AND T.STATUS = 0"
            , null
            , new SerializerReadClass(TicketInfo.class)).list();
}
 

import com.openbravo.data.loader.SerializerReadClass; //导入依赖的package包/类
public final SentenceList getLayersList() {
    return new StaticSentence(s,
            "SELECT ID, NAME, VISIBLE, ICON, COLOUR FROM GEOLAYERS ORDER BY NAME",
            null,
            new SerializerReadClass(Geolayer.class));
}
 

import com.openbravo.data.loader.SerializerReadClass; //导入依赖的package包/类
public final List<Geomarker> getMarkers(String layerId) throws BasicException {
    return new PreparedSentence(s, "SELECT ID, NAME, LATITUDE, LONGITUDE, VISIBLE, GEOLAYER FROM GEOMARKERS WHERE GEOLAYER = ? ORDER BY NAME", SerializerWriteString.INSTANCE, new SerializerReadClass(Geomarker.class)).list(layerId);
}