Package com.openbravo.data.loader

Examples of com.openbravo.data.loader.StaticSentence

258
259
260
261
262
263
264
265
266
267
268
                                setDouble(13, 0.0);                              
                            }});
                }
                       
                // Insert in catalog
                new StaticSentence(s,
                        "INSERT INTO PRODUCTS_CAT(PRODUCT, CATORDER) VALUES (?, NULL)",
                        SerializerWriteString.INSTANCE
                        ).exec(prod.getID());  
               
                return null;       
View Full Code Here
296
297
298
299
300
301
302
                    }               
                }).list(ticket);
    }   

    public void execTicketUpdate() throws BasicException {
        new StaticSentence(s, "UPDATE TICKETS SET STATUS = 1 WHERE STATUS = 0").exec();
    }
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
    private Object insertid;

    /** Creates new form AttributeSetEditor */
    public AttributeUseEditor(AppView app, DirtyManager dirty) {

        attributesent = new StaticSentence(app.getSession()
            , "SELECT ID, NAME FROM ATTRIBUTE ORDER BY NAME"
            , null
            , new SerializerRead() { public Object readValues(DataRead dr) throws BasicException {
                return new AttributeInfo(dr.getString(1), dr.getString(2));
            }}
View Full Code Here
48
49
50
51
52
53
54
55
56
57
58
        initComponents();
    }

    public void init(AppView app) {

        attsent = new StaticSentence(app.getSession()
            , "SELECT ID, NAME FROM ATTRIBUTE ORDER BY NAME"
            , null
            , new SerializerRead() { public Object readValues(DataRead dr) throws BasicException {
                return new AttributeInfo(dr.getString(1), dr.getString(2));
            }});
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
        m_PlaceCurrent = null;
        m_PlaceClipboard = null;
        customer = null;
           
        try {
            SentenceList sent = new StaticSentence(
                    app.getSession(),
                    "SELECT ID, NAME, IMAGE FROM FLOORS ORDER BY NAME",
                    null,
                    new SerializerReadClass(Floor.class));
            m_afloors = sent.list();
              
               
           
        } catch (BasicException eD) {
            m_afloors = new ArrayList<Floor>();
        }
        try {
            SentenceList sent = new StaticSentence(
                    app.getSession(),
                    "SELECT ID, NAME, X, Y, FLOOR FROM PLACES ORDER BY FLOOR",
                    null,
                    new SerializerReadClass(Place.class));
            m_aplaces = sent.list();
        } catch (BasicException eD) {
            m_aplaces = new ArrayList<Place>();
        }
       
        initComponents();
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
    public AttributeSetFilter() {
        initComponents();
    }
    public void init(AppView app) {

        attusesent = new StaticSentence(app.getSession()
            , "SELECT ID, NAME FROM ATTRIBUTESET ORDER BY NAME"
            , null
            , new SerializerRead() { public Object readValues(DataRead dr) throws BasicException {
                return new AttributeSetInfo(dr.getString(1), dr.getString(2));
            }});
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
       
    }
   
    // CustomerList list
    public SentenceList getCustomerList() {
        return new StaticSentence(s
            , new QBFBuilder("SELECT ID, TAXID, SEARCHKEY, NAME FROM CUSTOMERS WHERE VISIBLE = " + s.DB.TRUE() + " AND ?(QBF_FILTER) ORDER BY NAME", new String[] {"TAXID", "SEARCHKEY", "NAME"})
            , new SerializerWriteBasic(new Datas[] {Datas.OBJECT, Datas.STRING, Datas.OBJECT, Datas.STRING, Datas.OBJECT, Datas.STRING})
            , new SerializerRead() {
                    public Object readValues(DataRead dr) throws BasicException {
                        CustomerInfo c = new CustomerInfo(dr.getString(1));
View Full Code Here
119
120
121
122
123
124
125
126
127
128
    public void addParameter(String name) {
        paramnames.add(name);       
    }
   
    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()])));
    }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    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];
        }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
        }
    }
   
    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();
    }
View Full Code Here
TOP

Related Classes of com.openbravo.data.loader.StaticSentence

  • com.openbravo.pos.admin.DataLogicAdmin
  • com.openbravo.pos.customers.DataLogicCustomers
  • com.openbravo.pos.inventory.AttributeFilter
  • com.openbravo.pos.inventory.AttributeSetFilter
  • com.openbravo.pos.inventory.AttributeUseEditor
  • com.openbravo.pos.panels.JPanelCloseMoney
  • com.openbravo.pos.reports.PanelReportBean
  • com.openbravo.pos.sales.DataLogicReceipts
  • com.openbravo.pos.sales.restaurant.JTicketsBagRestaurantMap
  • com.openbravo.pos.sql.JPanelSQL
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.