ulogin.pas

本文阐述了目前CRM（Customer Relationship Management 客户关系管理）的管理方法

unit Ulogin;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtCtrls, StdCtrls, Buttons, DB, ADODB;

type
  TForm2 = class(TForm)
    ComboBox1: TComboBox;
    Edit1: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Image1: TImage;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    ADOQuery1: TADOQuery;
    procedure FormShow(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form2: TForm2;
  publicuser:string;
  usertype:integer;
implementation

uses main;

{$R *.dfm}

procedure TForm2.FormShow(Sender: TObject);
begin
  ADOTable1.Active := true;
  while not ADOTable1.Eof  do
  begin
    ComboBox1.Items.Add(ADOTable1.fieldbyname('user').AsString);
    ADOTable1.Next;
  end;
end;

procedure TForm2.BitBtn2Click(Sender: TObject);
begin
  application.Terminate;
end;

procedure TForm2.BitBtn1Click(Sender: TObject);
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('select * from yonghu where user='+
   QuotedStr(ComboBox1.Text)+'and pwd = '+  QuotedStr(edit1.Text));
  ADOQuery1.Open;
  if ADOQuery1.RecordCount > 0 then
  begin
  self.Hide;
  publicuser := ComboBox1.Text;
  usertype:=ADOQuery1.fieldbyname('type').AsInteger;
  form1.Show;
  end else
  begin
  edit1.Text := '';
  application.MessageBox('密码错误','chable',MB_OK);
  end;
end;

end.