sql.clear;
sql.Add('select * from customernow where 房间=''男间'' and 手牌号='+lblfrom.Caption);
prepared;
open;
//first;
while not Eof do
begin
edit;
fieldbyname('手牌号').AsInteger:=strtoint(lblto.caption);
refresh;
post;
//refresh;
next;
end;
//更换salecount里的手牌号
close;
sql.Clear;
sql.Add('select * from salecount where 房间=''男间'' and 结帐否=false 手牌号='+lblfrom.Caption);
prepared;
open;
//first;
while not eof do
begin
edit;
fieldbyname('手牌号').AsInteger:=strtoint(lblto.caption);
refresh;
post;
// //refresh;
next;
end;
//更换servicercount里的手牌号
close;
sql.Clear;
sql.Add('select * from servicercount where 房间=''男间'' and 结帐否=false 手牌号='+lblfrom.Caption);
prepared;
open;
// //first;
while not eof do
begin
edit;
fieldbyname('手牌号').AsInteger:=strtoint(lblto.caption);
refresh;
post;