|
楼主 |
发表于 2017-4-14 14:52:22
来自手机
|
显示全部楼层
注意还有sData1的过滤,需要从页面中传当前记录的rowid,因此action中要有一个参数String sData1 action对应的java代码如下: 1 2 3 4 5 6 7 8 9 10 public static Table taskData(String sData1){ String ksql="Select task,task.sEURL,task.sActivityName from SA_Task task where task.sData1 = '"+sData1+"' and (task.sKindID='tkTask' or task.sKindID='tkExecutor' or task.sKindID IS NULL) " + "and (task.sStatusID='tesReady' or task.sStatusID='tesExecuting') " + "and (task.sTypeID IS NULL or task.sTypeID <> 'WORKREMIND')" + "and task.sExecutorPersonID=:currentPersonID()"; Table table = KSQL.select(ksql, null, "/system/data", null); return table; } |
|