unit7.pas

商品销售管理系统

unit Unit7;

interface

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

type
  TForm7 = class(TForm)
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    Edit6: TEdit;
    Edit7: TEdit;
    Edit8: TEdit;
    Edit9: TEdit;
    Edit10: TEdit;
    ComboBox1: TComboBox;
    Memo1: TMemo;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Table1: TTable;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form7: TForm7;
   flag:boolean;
   logname:string;
implementation

uses Unit3;

{$R *.dfm}

procedure TForm7.Button1Click(Sender: TObject);
begin
  table1.Open;
  if edit1.Text='' then
  showmessage('供应者编号不能为空,请输入')
  else
  begin
    begin
  flag:=false;
  logname:=edit1.Text;

  table1.Open;
  table1.First;
  while not Table1.Eof do
  begin
    if logname = table1.Fields[0].AsString then
    flag:=true;
   table1.Next;
  end;
  end;
  begin
  if flag then
 begin
showmessage('已经有此编号存在，请重新输入');

end
else
     begin
  table1.Open;
  table1.AppendRecord([edit1.text,edit2.text,combobox1.Text,edit3.text,
  edit4.Text,edit5.Text,edit6.text,edit7.text,edit8.text,edit9.text,edit10.text,memo1.Text]);
  showmessage('提交完毕!');
  end;
  table1.Close;

  end;
  end;
  end;





procedure TForm7.Button2Click(Sender: TObject);
begin
edit1.Text:='';
edit2.Text:='';
edit3.Text:='';
edit4.Text:='';
edit5.Text:='';
edit6.Text:='';
edit7.Text:='';
edit8.Text:='';
edit9.Text:='';
edit10.Text:='';
combobox1.Text:='';
memo1.Text:='';
end;

procedure TForm7.Button3Click(Sender: TObject);
begin
form7.Close;
form3.show;
end;

end.