Examples of StaticSentence

com.openbravo.data.loader.StaticSentence
@author adrianromero

Examples of com.openbravo.data.loader.StaticSentence

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

Examples of com.openbravo.data.loader.StaticSentence

    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

Examples of com.openbravo.data.loader.StaticSentence

            , new SerializerWriteBasicExt(datas, new int[] {0, 1, 2})).exec(values);
    }
    
    public final void deleteSharedTicket(final String id) throws BasicException {


        new StaticSentence(s
            , "DELETE FROM SHAREDTICKETS WHERE ID = ?"
            , SerializerWriteString.INSTANCE).exec(id);      
    }

View Full Code Here

Examples of com.openbravo.data.loader.StaticSentence

                        " 'N'," +
                        " 0," +
                        " null)";
                System.out.println(i);
                System.out.println(sentence);
                BaseSentence sent = new StaticSentence(m_App.getSession(), sentence);
                sent.exec();
            }
        } catch (BasicException e) {
            e.printStackTrace();
        }        
    }

View Full Code Here

Examples of com.openbravo.data.loader.StaticSentence

    public void init(Session s) {
        this.s = s;
    }
     
    public void syncCustomersBefore() throws BasicException {
        new StaticSentence(s, "UPDATE CUSTOMERS SET VISIBLE = " + s.DB.FALSE()).exec();
    }

View Full Code Here

Examples of com.openbravo.data.loader.StaticSentence

        t.execute();
    }
        
    
    public void syncProductsBefore() throws BasicException {
        new StaticSentence(s, "DELETE FROM PRODUCTS_CAT").exec();
    }

View Full Code Here

Examples of com.openbravo.data.loader.StaticSentence

                                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

Examples of com.openbravo.data.loader.StaticSentence

                    }                
                }).list(ticket);
    }    


    public void execTicketUpdate() throws BasicException {
        new StaticSentence(s, "UPDATE TICKETS SET STATUS = 1 WHERE STATUS = 0").exec();
    }

View Full Code Here

Examples of com.openbravo.data.loader.StaticSentence

        this.s = s;
    }
     
    public void syncCustomersBefore() throws BasicException {
 // sync problems
        new StaticSentence(s, "UPDATE CUSTOMERS SET VISIBLE = " + s.DB.TRUE()).exec();
        new StaticSentence(s, "DELETE FROM CUSTOMERS WHERE ID NOT LIKE '0' AND ID NOT IN (SELECT CUSTOMER FROM TICKETS GROUP BY CUSTOMER)").exec();
 //ZAV
       // if (TicketInfo.getPayID()==2)
       //     new StaticSentence(s, "UPDATE CUSTOMERS SET CURDEBT=0.0 WHERE ID NOT LIKE '0' AND CURDEBT > 0.0").exec();


    }

View Full Code Here

Examples of com.openbravo.data.loader.StaticSentence

        t.execute();
    }
        
    
    public void syncProductsBefore() throws BasicException {
        new StaticSentence(s, "DELETE FROM PRODUCTS_CAT").exec();
    }

View Full Code Here

0 1 2 3 4

TOP

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.