|
版本: |
X5.2.7 |
小版本号: |
|
|
|
数据库: |
MS SQLServer |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 其它 |
浏览器: |
Chrome |
|
|
界面上的gridSelect绑定了bizData,因为这个数据集的queryAction是共用的,所以排序规则不好写在ontology里,可是我在界面上设置了数据集的order-by属性,也没生效。。。
ps:queryBaseCodeDiffClient这是自定义的Action,不知道和这个有关系吗??
- public static Table queryBaseCodeDiffClient(String concept,String idColumn,String select,String from,String condition,List range,
- String filter,Boolean distinct,Integer offset,Integer limit,String columns,String orderBy,
- String aggregate,String aggregateColumns,Map variables,String dataModel,String fnModel,
- String vScope,String vClient,String vUseState){
- try {
- String where = "";
- if(filter != null && !"".equals(filter)){
- where = " and (" + filter+")";
- }
- String sql = "";
- sql = "select fid,FBIZORIGN,version,fScope,fCode,fName,fDescription,fSequence,fUseStatus,fUseStatusName,fParentCode,fLevel,"
- +"fURL,fCreateOgnID,fCreateOgnName,fCreateDeptID,fCreateDeptName,fCreatePsnID,fCreatePsnName,fCreatePsnFID,fCreateTime,"
- +"fUpdatePsnID,fUpdatePsnName,fUpdateTime,fContent,fMsgCaption2,fMsgCaption3,fMsgCaption4,fMsgCaption5,fMsgCaption6,"
- +"fMsgCaption7,fMsgCaption8,fMsgCaption9,fMsgCaption10,fisReadOnly,fExtendStr1,fExtendStr2,fExtendStr3,fExtendStr4,fExtendStr5,"
- +"fExtendStr6,fExtendStr7,fExtendStr8,fExtendStr9,fExtendDate1,fExtendDate2,fExtendDate3,fExtendDate4,fExtendDate5,fExtendNum1,"
- +"fExtendNum2,fExtendNum3,fExtendNum4,fExtendNum5,fJudgeInt1,fJudgeInt2,fJudgeInt3,fJudgeInt4,Flogo,CLIENTACCOUNT,"
- +"CLIENTACCOUNTName from OA_Pub_BaseCode where fScope=? and CLIENTACCOUNT=? and fUseStatus=? "+where;
- List<Object> list = new ArrayList<Object>();
- list.add(vScope);
- list.add(vClient);
- list.add(vUseState);
- Map<String, String> sqlMap = new HashMap<String, String>();
- sqlMap.put(DatabaseProduct.MSSQL.name(), sql);
- Table table = SQL.select(sqlMap, list, "/OA/common/data");
- table.getProperties().put(Table.PROP_NAME_ROWID, "fid");
- table.getProperties().put(Table.PROP_DB_COUNT, 100);
-
- return table;
-
- } catch (Exception e) {
- System.out.println("ds.createVersion Exception:" + e.getMessage());
- return null;
- }
- }
复制代码
|
|