procedure TWJSCCT.FlowBroker1AfterFlowFinish(Sender: TObject; Command: TFlowFinishCommand);
var
qry1:TQuery;
id:integer;
dyr:string;
begin
WJdsb.DataSet.Open;
id:=WJdsb.DataSet.FieldByName('inst_id').AsInteger;
qry1:=TQuery.Create(nil);
qry1.ConnectionString:=BizObjConsts.cSysDatabaseConnectionString;
qry1.CommandText:='select ttaskmessage.* from ttaskmessage join ttask on ttaskmessage.ftaskguid =ttask.fguid join TFLOWID on ttask.fflowguid=tflowid.fflowguid join DD_WJSC on to_char(DD_WJSC.INST_ID)=tflowid.fid where inst_id=id and ttask.fkind=''ftkNotify'' and FPROCURL=''BIZ:\DMISXT\WJGL.PROC'' ';
qry1.Params.ParamByName('oid').AsInteger:=id;
qry1.Open;
qry1.First;
While not qry1.Eof do
begin
dyr:=dyr+qry1.FieldByName('frpersonname').AsString+'、';
qry1.next;
end;
with WJdsb.DataSet do
begin
edit;
FieldByName('dy').AsString :=dyr;
applyupdates;
end;
qry1.Free;
end;