String sql = "select t.ID,t.ORDER_NO,t.TASK_ID,t.TASK_NAME, "
+ "t.TASK_START_TIME,t.TASK_END_TIME,t.USED_TIME, "
+ "t.PROCESS_INSTANCE_ID,t.CREATE_USER,t.CREATE_USER_NAME, "
+ "t.CREATE_DEPT_ID,t.CREATE_DEPT_NAME,t.CREATE_TIME,t.END_TIME,t.ORDER_TOTAL_DURATION, "
+ "t.EVENT_TITLE, "
+ "(case when t.END_TIME is null then '未归档' else '已归档' end) as ORDER_STATUS, "
+ "t.EVENT_TYPE, "
+ "(select a.TYPE_NAME from MON_ALARM_TYPE a where a.ID=t.EVENT_TYPE)as EVENT_TYPE_NAME, "
+ "t.ORDER_LEVEL,( "
+ "select TYPENAME from ISDP_T_S_TYPE c ,ISDP_T_S_TYPEGROUP d "
+ "where d.TYPEGROUPCODE='ORDER_EVENT_LEVEL' "
+ "and c.TYPEGROUPID = d.ID "
+ "and c.TYPECODE = t.ORDER_LEVEL "
+ ") as ORDER_LEVEL_NAME,t.IF_CHANGE_CONFIG, "
+ "( case when t.IF_CHANGE_CONFIG = '1' then '是' else '否' end) as IF_CHANGE_CONFIG_NAME,t.TASK_FORM_KEY "
+ buildCondSql(map);
+ "t.TASK_START_TIME,t.TASK_END_TIME,t.USED_TIME, "
+ "t.PROCESS_INSTANCE_ID,t.CREATE_USER,t.CREATE_USER_NAME, "
+ "t.CREATE_DEPT_ID,t.CREATE_DEPT_NAME,t.CREATE_TIME,t.END_TIME,t.ORDER_TOTAL_DURATION, "
+ "t.EVENT_TITLE, "
+ "(case when t.END_TIME is null then '未归档' else '已归档' end) as ORDER_STATUS, "
+ "t.EVENT_TYPE, "
+ "(select a.TYPE_NAME from MON_ALARM_TYPE a where a.ID=t.EVENT_TYPE)as EVENT_TYPE_NAME, "
+ "t.ORDER_LEVEL,( "
+ "select TYPENAME from ISDP_T_S_TYPE c ,ISDP_T_S_TYPEGROUP d "
+ "where d.TYPEGROUPCODE='ORDER_EVENT_LEVEL' "
+ "and c.TYPEGROUPID = d.ID "
+ "and c.TYPECODE = t.ORDER_LEVEL "
+ ") as ORDER_LEVEL_NAME,t.IF_CHANGE_CONFIG, "
+ "( case when t.IF_CHANGE_CONFIG = '1' then '是' else '否' end) as IF_CHANGE_CONFIG_NAME,t.TASK_FORM_KEY "
+ buildCondSql(map);
return sql;
case when ** then *** end 用法 何时用
通过上面后台的查询, 将数据在页面上显示出来
<td class="searchTable_right" align="left"><select
id="IF_CHANGE_CONFIG" name="IF_CHANGE_CONFIG" style="width: 90px">
<option value="" selected>-请选择-</option>
<option value="1">是</option>
<option value="0">否</option>
</select></td>