procedure TSGRYHZ.ActionSAVExecute(Sender: TObject);
var
lLookUpDateBegin: String;
begin
lLookUpDateBegin := GetDateEditBegin;
if (PageControl.ActivePageIndex=0) and (DocView.DocClassID='SGRYHZ.SheetDoc') then
begin
TSqlDataSet(DataSetBrokerCKS.DataSet).UserFilter:='CONSTRUCTIONPERSONNEL.Data = '''+ lLookUpDateBegin+'''';
with DataSetBrokerCKS.DataSet do
begin
while IsEmpty=false do
begin
First;
Delete;
Next;
end;
ApplyUpdates;
end;
with Tsqldataset(DataSetBrokerHZS.DataSet) do
begin
First;
while not Eof do
begin
DataSetBrokerCKS.DataSet.Append;
DataSetBrokerCKS.DataSet.FieldByName('JZSGRY').AsInteger :=
DataSetBrokerHZS.DataSet.FieldByName('b').AsInteger;
DataSetBrokerCKS.DataSet.FieldByName('AZSGRY').AsInteger :=
DataSetBrokerHZS.DataSet.FieldByName('c').AsInteger;
DataSetBrokerCKS.DataSet.FieldByName('SGUnit').AsString :=
DataSetBrokerHZS.DataSet.FieldByName('SGUnit').AsString;
DataSetBrokerCKS.DataSet.FieldByName('Data').AsDateTime :=
DataSetBrokerHZS.DataSet.FieldByName('aaa').AsDateTime;
DataSetBrokerCKS.DataSet.Post;
DataSetBrokerHZS.DataSet.Next;
end;
DataSetBrokerCKS.DataSet.ApplyUpdates;
end;
end
else
begin
DataSetBrokerCKS.DataSet.ApplyUpdates;
DataSetBrokerCKZ.DataSet.ApplyUpdates;
DataSetBrokerCKX.DataSet.ApplyUpdates;
end;
end;