unit3.pas

网上书店管理系统

unit Unit3;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Menus, ExtCtrls, Grids, DBGrids, DB, DBTables, Mask,
  DBCtrls;

type
  TForm3 = class(TForm)
    MainMenu1: TMainMenu;
    N1: TMenuItem;
    N2: TMenuItem;
    N4: TMenuItem;
    Bevel1: TBevel;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    N3: TMenuItem;
    Button5: TButton;
    Table1: TTable;
    DataSource1: TDataSource;
    N5: TMenuItem;
    N6: TMenuItem;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    Label7: TLabel;
    DBGrid1: TDBGrid;
    DataSource2: TDataSource;
    Table2: TTable;
    Memo1: TMemo;
    procedure N2Click(Sender: TObject);
    procedure N1Click(Sender: TObject);
    procedure N4Click(Sender: TObject);
    procedure N3Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure N5Click(Sender: TObject);
    procedure N6Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
 
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form3: TForm3;

implementation

uses Unit2, Unit1, Unit4, Unit5, Unit6;

{$R *.dfm}



procedure TForm3.N2Click(Sender: TObject);
begin
form2.show;
end;

procedure TForm3.N1Click(Sender: TObject);
begin
table1.Close ;
form1.Show ;
table1.Open ;
end;

procedure TForm3.N4Click(Sender: TObject);
begin
table1.Close ;
form3.Show ;
table1.Open ;
end;

procedure TForm3.N3Click(Sender: TObject);
begin
table1.close;
form4.show;
table1.open ;
end;

procedure TForm3.Button2Click(Sender: TObject);
begin
table1.First ;
table2.refresh;
  with table2 do
  try
    disablecontrols;
    filtered:=false;
    memo1.Text:='orderTag='+''''+DBedit1.Text+'''';
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table2.recordcount=0 then
      begin
        messagebeep(1);
        showmessage('        此订单没有的纪录 !      ');
      end;
   end;
 end;
 

procedure TForm3.Button3Click(Sender: TObject);
begin
table1.Next ;
table2.refresh;
  with table2 do
  try
    disablecontrols;
    filtered:=false;
    memo1.Text:='orderTag='+''''+DBedit1.Text+'''';
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table2.recordcount=0 then
      begin
        messagebeep(1);
       showmessage('        此订单没有的纪录 !      ');
      end;
   end;
 end; 

procedure TForm3.Button1Click(Sender: TObject);
begin
table1.Prior ;
table2.refresh;
  with table2 do
  try
    disablecontrols;
    filtered:=false;
    memo1.Text:='orderTag='+''''+DBedit1.Text+'''';
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table2.recordcount=0 then
      begin
        messagebeep(1);
 showmessage('        此订单没有的纪录 !      ');
     end;
   end;
 end;

procedure TForm3.Button4Click(Sender: TObject);
begin
table1.Last ;
table2.refresh;
  with table2 do
  try
    disablecontrols;
    filtered:=false;
    memo1.Text:='orderTag='+''''+DBedit1.Text+'''';
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table2.recordcount=0 then
      begin
        messagebeep(1);
        showmessage('        此订单没有的纪录 !      ');
     end;
   end;
 end;

procedure TForm3.Button5Click(Sender: TObject);
begin
if table1.recordcount =0  then
 showmessage('        没有订单  !      ')
  else table1.Delete ;
while table2.recordcount > 0 do
table2.delete ;
table2.refresh;
  with table2 do
  try
    disablecontrols;
    filtered:=false;
    memo1.Text:='orderTag='+''''+DBedit1.Text+'''';
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table2.recordcount=0 then
      begin
        messagebeep(1);
        showmessage('        此订单没有的纪录 !      ');
      end;
   end;
end;

procedure TForm3.N5Click(Sender: TObject);
begin
form5.show;
end;

procedure TForm3.N6Click(Sender: TObject);
begin
form6.show;
end;

procedure TForm3.FormCreate(Sender: TObject);
begin
table1.Open ;
table2.Open ;
table2.refresh;
  with table2 do
  try
    disablecontrols;
    filtered:=false;
    memo1.Text:='orderTag='+''''+DBedit1.Text+'''';
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table2.recordcount=0 then
      begin
        messagebeep(1);
        showmessage('        此订单没有的纪录       !');
      end;
   end;
 end;

end.