打开 协同系统\任务\任务中心资源\任务桌面过滤
在 function TCIRCSCOMMONFILTER.RebuildRightsFilterText: string;
定义
SSOrgURLLike1 = 'T1.FSORGURL LIKE ''%s%%'' and (T1.FSPERSON is null or T1.FSPERSON='''' or T1.FSPERSON = ''%s'')';
SROrgURLLike1 = 'TTASKMESSAGE.FRORGURL LIKE ''%s%%'' and (TTASKMESSAGE.FRPERSON is null or TTASKMESSAGE.FRPERSON='''' or TTASKMESSAGE.FRPERSON=''%s'')';
代码
begin
lSQL := SysUtils.Format(SSOrgURLLike, [DoGetQueryURLStr(lBizURL.URL)]);
if not FPersonChecked and not lDeptEmpty then
begin
lOperatorID := TContextUtils.GetOperator(Context).ID;
lSQL := AddAndCondition(lSQL, SysUtils.Format('NOT (%s)', [SysUtils.Format(SSOrgURLIn,
[DoGetQueryURLStr(PersonMemberURLs), lOperatorID])]));
end;}
lSend.Add(lSQL);
lSQL := SysUtils.Format(SROrgURLLike, [DoGetQueryURLStr(lBizURL.URL)]);
if not FPersonChecked and not lDeptEmpty then
begin
lOperatorID := TContextUtils.GetOperator(Context).ID;
lSQL := AddAndCondition(lSQL, SysUtils.Format('NOT (%s)', [SysUtils.Format(SROrgURLIn,
[DoGetQueryURLStr(PersonMemberURLs), lOperatorID])]));
end;
lProces.Add(lSQL);
end
修改成
begin
TContextUtils.GetContextOperator(Context, lDept, lPos, lPer);
lSQL := SysUtils.Format(SSOrgURLLike1, [DoGetQueryURLStr(lBizURL.URL), lPer]);
{if not FPersonChecked and not lDeptEmpty then
begin
lOperatorID := TContextUtils.GetOperator(Context).ID;
lSQL := AddAndCondition(lSQL, SysUtils.Format('NOT (%s)', [SysUtils.Format(SSOrgURLIn1,
[DoGetQueryURLStr(PersonMemberURLs), lOperatorID])])); //alang
end;}
lSend.Add(lSQL);
lSQL := SysUtils.Format(SROrgURLLike1, [DoGetQueryURLStr(lBizURL.URL), lPer]);
{if not FPersonChecked and not lDeptEmpty then
begin
lOperatorID := TContextUtils.GetOperator(Context).ID;
lSQL := AddAndCondition(lSQL, SysUtils.Format('NOT (%s)', [SysUtils.Format(SROrgURLIn1,
[DoGetQueryURLStr(PersonMemberURLs), lOperatorID])])); //alang
end;}
lProces.Add(lSQL);
end |