在业务模型\协同系统\任务\任务中心信息 按下面的代码修改下面的函数
procedure TTASKCENTERINFO.DataSetBatchTaskBeforeOpen(DataSet: TDataSet);
const
cFlowTaskSQL = 'TTASK.FGROUPGUID = ''-1'' AND TTASK.FPROCURL = ''%s'' AND TTASK.FPROCUNITID = ''%s'' AND TTASK.FSTATE IN (%s) AND TTASK.FFLOWGUID = ''%s'' ' ;
cTaskSQL = 'TTASK.FGROUPGUID = ''-1'' AND TTASK.FTYPE = ''%s'' AND TTASK.FSTATE IN (%s)';
var
lProcessingTask: string;
begin
lProcessingTask := TFilterBuilder.DoGetTaskStatesQueryStr(TTask.CanProcessTaskStates);
if Task.IsFlowTask then
DataSetBatchTask.UserFilter := SysUtils.Format(cFlowTaskSQL, [Task.ProcURL, Task.ProcUnitID, lProcessingTask,TASK.FlowGUID ])
else
DataSetBatchTask.UserFilter := SysUtils.Format(cTaskSQL, [Task.TaskType, lProcessingTask]);
DataSetBatchTask.SQLFilter := DataSetTaskIndex.SQLFilter;
DataSetBatchTask.SQLFiltered := True;
end; |