procedure TTSSH.FlowBroker1BeforeFlowOut(Sender: TObject; Command: TFlowOutCommand);
var
i:integer;
begin
i:=0;
Dialogs.ShowMessage('0');//测试下是否执行这里,但是在运行根本没执行这里.
DataSetBroker1.DataSet.First ;
while not DataSetBroker1.DataSet.Eof do
begin
try
Query1 :=TQuery.Create(Self);
Query1.ConnectionString := 'DATABASEURL=Biz:\OABGZDHXT\BGZDHSJK.DATABASE';
Query1.Close;
Query1.CommandText := 'Update TSZB set JYSL=JYSL+'+DataSetBroker1.DataSet.FieldByName('JYSL').AsString+' where TSBH='''+ DataSetBroker1.DataSet.FieldByName('TSBH').AsString +'''';
Query1.Execute;
i:=1;
except
on e:Exception do
Dialogs.ShowMessage(e.Message);
end;
DataSetBroker1.DataSet.Next;
end;
if i=1 then
Dialogs.ShowMessage('库存量已经更改');