2,498
社区成员
发帖
与我相关
我的任务
分享
procedure TIWForm1.IWButton5Click(Sender: TObject);
var str:string;
begin
//查找添加的记录是否有重复,判断的字段有证件号(CardID)或者电话号码(PhoneNo)
str:='select * from Customerinfo where CardID = '+
chr(39)+IWEdit5.Text+chr(39)+
' or PhoneNo = '+
chr(39)+IWEdit6.Text +chr(39);
UserSession.ADOQuery3.Close;
UserSession.ADOQuery3.SQL.Clear;
UserSession.ADOQuery3.SQL.Append(str);
UserSession.ADOQuery3.Open;
if UserSession.ADOQuery3.FieldValues['zt']='有' then//查找到有记录,提示重复
begin
webapplication.ShowMessage('保存不成功,记录有重复,请查看下方明细。');
end
else //没有则新增
begin
UserSession.ADOQuery2.Append;
UserSession.ADOQuery2.FieldByName('CustomerName').Value:=IWEdit4.Text;
UserSession.ADOQuery2.FieldByName('CardID').Value:=IWEdit5.Text;
UserSession.ADOQuery2.FieldByName('quyu').Value:=IWLabel7.Caption;
UserSession.ADOQuery2.FieldByName('PhoneNo').Value:=IWEdit6.Text;
UserSession.ADOQuery2.FieldByName('zt').Value:='有';
UserSession.ADOQuery2.Post;
IWEdit4.Text:='';
IWEdit5.Text:='';
IWEdit6.Text:='';
webapplication.ShowMessage('保存成功');
end;