with DBGrid1.SelectedRows do
begin
qryDetail.DisableControls;
try
with qrytemp do
begin
close;
sql.Clear;
sql.Add('update A set A.数量=A.数量+B.数量,A.金额=A.金额+B.金额,A.单价=((A.金额+B.金额)/(A.数量+B.数量)) from kc2 A');
sql.Add('inner join rukudetail B on B.品名=A.品名');
sql.Add('inner join rukumaster C on C.入库单单号=B.入库单单号');
sql.Add('where C.state=0');
execsql;
end;
finally
qryDetail.EnableControls;
end;
end;