import com.openbravo.data.loader.SerializerReadBasic; //导入依赖的package包/类
public final TicketInfo getSharedTicket(String Id) throws BasicException {
    
    if (Id == null) {
        return null; 
    } else {
        Object[]record = (Object[]) new StaticSentence(s
                , "SELECT CONTENT FROM SHAREDTICKETS WHERE ID = ?"
                , SerializerWriteString.INSTANCE
                , new SerializerReadBasic(new Datas[] {Datas.SERIALIZABLE})).find(Id);
        return record == null ? null : (TicketInfo) record[0];
    }
}
 

import com.openbravo.data.loader.SerializerReadBasic; //导入依赖的package包/类
public final SentenceList getReservationsList() {
    return new PreparedSentence(s
        , "SELECT R.ID, R.CREATED, R.DATENEW, C.CUSTOMER, CUSTOMERS.TAXID, CUSTOMERS.SEARCHKEY, COALESCE(CUSTOMERS.NAME, R.TITLE),  R.CHAIRS, R.ISDONE, R.DESCRIPTION " +
          "FROM RESERVATIONS R LEFT OUTER JOIN RESERVATION_CUSTOMERS C ON R.ID = C.ID LEFT OUTER JOIN CUSTOMERS ON C.CUSTOMER = CUSTOMERS.ID " +
          "WHERE R.DATENEW >= ? AND R.DATENEW < ?"
        , new SerializerWriteBasic(new Datas[] {Datas.TIMESTAMP, Datas.TIMESTAMP})
        , new SerializerReadBasic(customerdatas));             
}
 

import com.openbravo.data.loader.SerializerReadBasic; //导入依赖的package包/类
/**
 *
 * @param Id
 * @return
 * @throws BasicException
 */
public final TicketInfo getSharedTicket(String Id) throws BasicException {
    
    if (Id == null) {
        return null; 
    } else {
        Object[]record = (Object[]) new StaticSentence(s
                , "SELECT CONTENT FROM SHAREDTICKETS WHERE ID = ?"
                , SerializerWriteString.INSTANCE
                , new SerializerReadBasic(new Datas[] {Datas.SERIALIZABLE})).find(Id);
        return record == null ? null : (TicketInfo) record[0];
    }
}
 

import com.openbravo.data.loader.SerializerReadBasic; //导入依赖的package包/类
/**
 *
 * @param Id
 * @return
 * @throws BasicException
 */
public final Integer getPickupId(String Id) throws BasicException {
    
    if (Id == null) {
        return null; 
    } else {
        Object[]record = (Object[]) new StaticSentence(s
                , "SELECT PICKUPID FROM SHAREDTICKETS WHERE ID = ?"
                , SerializerWriteString.INSTANCE
                , new SerializerReadBasic(new Datas[] {Datas.INT})).find(Id);
        return record == null ? 0 : (Integer)record[0];
    }
}
 

import com.openbravo.data.loader.SerializerReadBasic; //导入依赖的package包/类
public final SentenceList getReservationsList() {
    return new PreparedSentence(s
        , "SELECT R.ID, R.CREATED, R.DATENEW, C.CUSTOMER, CUSTOMERS.TAXID, CUSTOMERS.SEARCHKEY, COALESCE(CUSTOMERS.NAME, R.TITLE),  R.CHAIRS, R.ISDONE, R.DESCRIPTION " +
          "FROM RESERVATIONS R LEFT OUTER JOIN RESERVATION_CUSTOMERS C ON R.ID = C.ID LEFT OUTER JOIN CUSTOMERS ON C.CUSTOMER = CUSTOMERS.ID " +
          "WHERE R.DATENEW >= ? AND R.DATENEW < ?"
        , new SerializerWriteBasic(new Datas[] {Datas.TIMESTAMP, Datas.TIMESTAMP})
        , new SerializerReadBasic(customerdatas));
}
 

import com.openbravo.data.loader.SerializerReadBasic; //导入依赖的package包/类
public final SentenceList getReservationsList() {
    // TODO: Remove query on CUSTOMERS table. Ask the web service when using it.
    return new PreparedSentence(s
        , "SELECT R.ID, R.CREATED, R.DATENEW, C.CUSTOMER, CUSTOMERS.TAXID, CUSTOMERS.SEARCHKEY, COALESCE(CUSTOMERS.NAME, R.TITLE),  R.CHAIRS, R.ISDONE, R.DESCRIPTION " +
          "FROM RESERVATIONS R LEFT OUTER JOIN RESERVATION_CUSTOMERS C ON R.ID = C.ID LEFT OUTER JOIN CUSTOMERS ON C.CUSTOMER = CUSTOMERS.ID " +
          "WHERE R.DATENEW >= ? AND R.DATENEW < ?"
        , new SerializerWriteBasic(new Datas[] {Datas.TIMESTAMP, Datas.TIMESTAMP})
        , new SerializerReadBasic(customerdatas));             
}
 

import com.openbravo.data.loader.SerializerReadBasic; //导入依赖的package包/类
protected BaseSentence getSentence() {
    return new StaticSentence(m_App.getSession()
        , new QBFBuilder(sentence, paramnames.toArray(new String[paramnames.size()]))
        , qbffilter.getSerializerWrite()
        , new SerializerReadBasic(fielddatas.toArray(new Datas[fielddatas.size()])));
}
 

import com.openbravo.data.loader.SerializerReadBasic; //导入依赖的package包/类
/** Creates new form JPanelSQL */
public JPanelSQL(AppView oApp) {
    m_App = oApp;        
    
    m_aHistory = new ArrayList();
    m_aHistory.add("");
    m_iHistoryIndex = 0;
   
    initComponents();
    
    m_iResultIndex = 0;
    addResultTab();
    
    
    DefaultMutableTreeNode rootnode =  new DefaultMutableTreeNode(AppLocal.APP_NAME);
    
    
    SQLDatabase db = new SQLDatabase(AppLocal.APP_NAME + " - Database.");
    
    try {
        BaseSentence sent = new MetaSentence(m_App.getSession(), "getTables"
                , new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING})
                , new SerializerReadBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING}));
        DataResultSet rs = sent.openExec( new Object[] {null, null});          
        while (rs.next()) {
            Object[] aTable = (Object[]) rs.getCurrent();
            db.addTable((String) aTable[2]);
        }            
        rs.close();
        sent.closeExec();
        
        sent = new MetaSentence(m_App.getSession(), "getColumns"
                , new SerializerWriteBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING})
                , new SerializerReadBasic(new Datas[] {Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING, Datas.STRING}));
        rs = sent.openExec(new Object[] {null, null, null}); 
        while (rs.next()) {
            Object[] aColumn = (Object[]) rs.getCurrent();
            SQLTable t = db.getTable((String) aColumn[2]);
            if (t != null) {
                t.addColumn((String) aColumn[3]);
            }
        }            
        rs.close();
        sent.closeExec();
        
    } catch (BasicException e) {
        // e.printStackTrace();
    }        
   

    DefaultTreeModel tm = new DefaultTreeModel(db);
    
    m_jTreeDB.setModel(tm);
    
    statusButtons();
}