Unieap3.5-前台js用SQL语句执行数据请求

执行UPDATE

var sql=" update T_SS_SETTLEMENT_RECORD  "+
" set CINVOICE_INFO_FLAG='Y',"+
" SINVOICE_INFO_PERSON='"+userAccount+"',"+
" TINVOICE_INFO_DATE=sysdate "+
" where SSETTLEMENT_ID='"+rowId+"' ";
var errorMsg=param.updateSql(sql);
if(errorMsg==null){
MessageBox.alert({
title:'提示框',
message:'信息提示:通知开发票操作成功!',
type:'info'
});

执行QUERY

query : function(whereStore,flag){
var store = new unieap.ds.DataStore("engineerRecordStore");
store.setRowSetName("mcss.CS.sf.sf05.engineer_reward_record");
var sql=" SORG_ID='"+getDimensionId()+"' ";
if(flag==null){
sql+=" AND SSTATUS='001' ";
}
store.setCondition(sql);
setConditionWhere(store,whereStore);
SubUnitSql.getSubUnitSqlClause(store,"SUNIT_ID");
store.setOrder("T_CS_ENGINEER_REWARD_RECORD.SENGINEER_REWARD_FORM_NUM desc");
store.setPageSize(9);
unieap.Action.doQuery(store,{
load:function(ds){
unieap.byId("engineerDetailGrid").getBinding().setDataStore(null);
unieap.byId("engineerRecordGrid").getBinding().setDataStore(ds);
}
});
},
上一篇:nfc近场通信


下一篇:Java模式之模板方法模式