本文整理汇总了Java中com.openbravo.data.loader.StaticSentence类的典型用法代码示例。如果您正苦于以下问题:Java StaticSentence类的具体用法?Java StaticSentence怎么用?Java StaticSentence使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
StaticSentence类属于com.openbravo.data.loader包,在下文中一共展示了StaticSentence类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: AttributeUseEditor
import com.openbravo.data.loader.StaticSentence; //导入依赖的package包/类
/** 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));
}}
);
attributemodel = new ComboBoxValModel();
initComponents();
jLineno.getDocument().addDocumentListener(dirty);
jAttribute.addActionListener(dirty);
}
示例2: AttributeUseEditor
import com.openbravo.data.loader.StaticSentence; //导入依赖的package包/类
/** Creates new form AttributeSetEditor
* @param app
* @param dirty */
public AttributeUseEditor(AppView app, DirtyManager dirty) {
attributesent = new StaticSentence(app.getSession()
, "SELECT ID, NAME FROM ATTRIBUTE ORDER BY NAME"
, null
, new SerializerRead() {@Override
public Object readValues(DataRead dr) throws BasicException {
return new AttributeInfo(dr.getString(1), dr.getString(2));
}}
);
attributemodel = new ComboBoxValModel();
initComponents();
jLineno.getDocument().addDocumentListener(dirty);
jAttribute.addActionListener(dirty);
}
示例3: getSharedTicket
import com.openbravo.data.loader.StaticSentence; //导入依赖的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];
}
}
示例4: getSharedTicketList
import com.openbravo.data.loader.StaticSentence; //导入依赖的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();
}
示例5: getCustomerList
import com.openbravo.data.loader.StaticSentence; //导入依赖的package包/类
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));
c.setTaxid(dr.getString(2));
c.setSearchkey(dr.getString(3));
c.setName(dr.getString(4));
return c;
}
});
}
示例6: init
import com.openbravo.data.loader.StaticSentence; //导入依赖的package包/类
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));
}});
attmodel = new ComboBoxValModel();
}
示例7: init
import com.openbravo.data.loader.StaticSentence; //导入依赖的package包/类
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));
}});
attusemodel = new ComboBoxValModel();
}
示例8: insertProductCategories
import com.openbravo.data.loader.StaticSentence; //导入依赖的package包/类
private void insertProductCategories() {
try {
for( int i = 100; i < 50000; i++) {
String sentence =
"INSERT INTO m_product_category(" +
" m_product_category_id," +
" ad_client_id," +
" ad_org_id," +
" isactive, " +
" created, createdby, " +
" updated, updatedby, " +
" value, " +
" name, " +
" description, " +
" isdefault, plannedmargin, a_asset_group_id) VALUES " +
"(" +
Integer.toString(i + 1000000) + " ," +
" 1000000, " +
" 0, " +
"'Y', " +
" '2007-01-01', 100, " +
" '2007-01-01', 100, " +
" 'Fictious Category no " + Integer.toString(i) +"' ," +
" 'Fictious Category Name no " + Integer.toString(i) +"' ," +
" null," +
" '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();
}
}
示例9: getSharedTicket
import com.openbravo.data.loader.StaticSentence; //导入依赖的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];
}
}
示例10: getSharedTicketList
import com.openbravo.data.loader.StaticSentence; //导入依赖的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();
}
示例11: deleteSharedTicket
import com.openbravo.data.loader.StaticSentence; //导入依赖的package包/类
/**
*
* @param id
* @throws BasicException
*/
public final void deleteSharedTicket(final String id) throws BasicException {
new StaticSentence(s
, "DELETE FROM SHAREDTICKETS WHERE ID = ?"
, SerializerWriteString.INSTANCE).exec(id);
}
示例12: getPickupId
import com.openbravo.data.loader.StaticSentence; //导入依赖的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];
}
}
示例13: getCustomerList
import com.openbravo.data.loader.StaticSentence; //导入依赖的package包/类
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));
c.setTaxid(dr.getString(2));
c.setSearchkey(dr.getString(3));
c.setName(dr.getString(4));
return c;
}
});
}
示例14: getCustomerList
import com.openbravo.data.loader.StaticSentence; //导入依赖的package包/类
public SentenceList getCustomerList() {
// TODO To action on webservice
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));
c.setTaxid(dr.getString(2));
c.setSearchkey(dr.getString(3));
c.setName(dr.getString(4));
return c;
}
});
}
示例15: deleteSharedTicket
import com.openbravo.data.loader.StaticSentence; //导入依赖的package包/类
public final void deleteSharedTicket(final String id) throws BasicException {
new StaticSentence(s
, "DELETE FROM SHAREDTICKETS WHERE ID = ?"
, SerializerWriteString.INSTANCE).exec(id);
}