addcustomer.pas

来自「完整的delphi书籍源代码,大家有空的时候自己慢慢看看」· PAS 代码 · 共 97 行

unit AddCustomer;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls;

type
  TAddCustomerFrm = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Memo1: TMemo;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  AddCustomerFrm: TAddCustomerFrm;

implementation

uses Login;

{$R *.dfm}

procedure TAddCustomerFrm.Button1Click(Sender: TObject);
var con:string;
begin
    if (edit1.text='') then
     messagebox(AddCustomerFrm.handle,'请填写单位名称！','警告',mb_ok+mb_iconwarning)
    else
     begin
      con:= 'insert into Customer(CustomerName,Address,LinkMan,Tel,Fax,Zipcode,CustomerRemark) values('+''''+edit1.Text+''''+','+''''+edit2.Text+''''+','+''''+edit3.Text+''''+','+''''+edit4.Text+''''+','+''''+edit5.Text+''''+','+''''+edit6.Text+''''+','+''''+memo1.Text+''''+')' ;
      with LoginFrm.ADOQuery1 do
      begin
       close;
       sql.clear;
       sql.add(con);
       execsql;
      end;
      messagebox(AddCustomerFrm.handle,'收货单位信息已经成功添加','恭喜',mb_ok);
     end;
end;

procedure TAddCustomerFrm.Button2Click(Sender: TObject);
begin
    edit1.text:='';
    edit2.text:='';
    edit3.text:='';
    edit4.text:='';
    edit5.text:='';
    edit6.text:='';
    Memo1.Text:='';
    edit1.Setfocus;
end;

procedure TAddCustomerFrm.Button3Click(Sender: TObject);
begin
      AddCustomerFrm.Hide;
end;

procedure TAddCustomerFrm.FormShow(Sender: TObject);
begin
    edit1.text:='';
    edit2.text:='';
    edit3.text:='';
    edit4.text:='';
    edit5.text:='';
    edit6.text:='';
    Memo1.Text:='';
    edit1.Setfocus;
end;

end.