下拉框考虑历史数据脚本示例

1. /**
   
2. *        考虑历史数据：获取通用主数据类型返回Options
   
3. *        table:当前表名  docId：当前docID  valueName:当前字段名  type：通用主数据的类型
   
4. */
   
5. function getDatatype(table, docId, valueName, isNull) {
   
6.     var opts = $TOOLS.createOptions();
   
7.     var sql1 = "select * from " + table + " where id='" + docId + "' ";
   
8.     var data = findBySQL(sql1);
   
9.     var value1 = "";
   
10.     if (data != null) {
    
11.         value1 = data.getItemValueAsString(valueName);
    
12.     }
    
13.     var sql = "select * from obpm_crm_new.tlk_客户状态 where item_status='有效' order by item_类别名称";
    
14.     if (value1 != null && !"".equals(value1)) {
    
15.         sql = "select * from obpm_crm_new.tlk_客户状态 where (item_status='有效') or (item_status='无效' and item_类别名称='" + value1 + "') order by item_类别名称";
    
16.     }
    
17.     if (isNull) {
    
18.         opts.add("", "");
    
19.     }
    
20.     var query = queryBySQL(sql);
    
21.     if (query != null && query.size() > 0) {
    
22.         for (var it = query.iterator(); it.hasNext(); ) {
    
23.             var doc = it.next();
    
24.             var value = doc.getItemValueAsString("类别名称");
    
25.             var name = doc.getItemValueAsString("类别名称");
    
26.             opts.add(name, value);
    
27.         }
    
28.     }
    
29.     return opts;
    
30. };

复制代码