procedure Tlogin.FormCreate(Sender: TObject);
begin
with ADOQuery1 do
begin
Close;
SQL.Text:='SELECT 用户名称,用户密码 FROM device_holder';
Open;
if RecNo<>-1 then
begin
First;
if ComboBox1.Items.IndexOf(FieldByName('用户名称').AsString)=-1 then
ComboBox1.Items.Add(FieldByName('用户名称').AsString);
while RecNo<RecordCount do
begin
Next;
if ComboBox1.Items.IndexOf(FieldbyName('用户名称').AsString)=-1 then
ComboBox1.Items.Add(FieldByName('用户名称').AsString)
end;
end;
end;
ActiveControl:=ComboBox1;
end;
procedure Tlogin.Button1Click(Sender: TObject);
begin
if ComboBox1.Text='' then
begin
Application.MessageBox('用户ID不能为空','用户ID错误',MB_IconError);
ActiveControl:=ComboBox1;
end
else
begin
with ADOQuery1 do
begin
Close;
SQL.Text:=Format('SELECT * FROM device_holder WHERE 用户名称=''%s''',[ComboBox1.Text]);
Open;
if (FieldByName('用户密码').AsString<>Edit1.Text) then
begin
Application.MessageBox('用户ID与密码不匹配','登录失败',MB_IconError);
Edit1.Clear;
ActiveControl:=Edit1;
end
else
begin
FormMain.Show;
UserName:=FieldByName('用户名称').AsString;
ExitApplication:=False;
//self.Close;
end;
end;
end;
end;
end.