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);
            }
        });    
    },