unit2.pas

网上书店管理系统

unit Unit2;

interface

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

type
  TForm2 = class(TForm)
    Bevel1: TBevel;
    MainMenu1: TMainMenu;
    N1: TMenuItem;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    TabSheet3: TTabSheet;
    TabSheet4: TTabSheet;
    TabSheet5: TTabSheet;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    DBGrid3: TDBGrid;
    DBGrid4: TDBGrid;
    DBGrid5: TDBGrid;
    N2: TMenuItem;
    N3: TMenuItem;
    Label1: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Label2: TLabel;
    Label3: TLabel;
    ComboBox1: TComboBox;
    Label4: TLabel;
    Label5: TLabel;
    N4: TMenuItem;
    Button1: TButton;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Button6: TButton;
    Button5: TButton;
    Button7: TButton;
    Button8: TButton;
    Button9: TButton;
    Button10: TButton;
    Button11: TButton;
    Button12: TButton;
    Button13: TButton;
    Button14: TButton;
    Button15: TButton;
    Button16: TButton;
    Button17: TButton;
    Button18: TButton;
    Button19: TButton;
    Button20: TButton;
    Button21: TButton;
    Button22: TButton;
    Button23: TButton;
    Button24: TButton;
    Edit4: TEdit;
    Button25: TButton;
    Button26: TButton;
    Button27: TButton;
    Button28: TButton;
    Button29: TButton;
    Button30: TButton;
    Button31: TButton;
    Button32: TButton;
    ComboBox2: TComboBox;
    Button33: TButton;
    Button34: TButton;
    Button35: TButton;
    Button36: TButton;
    Button37: TButton;
    Button38: TButton;
    Button39: TButton;
    Button40: TButton;
    Table1: TTable;
    DataSource1: TDataSource;
    Table2: TTable;
    Table3: TTable;
    Table4: TTable;
    Table5: TTable;
    DataSource2: TDataSource;
    DataSource3: TDataSource;
    DataSource4: TDataSource;
    DataSource5: TDataSource;
    Memo1: TMemo;
    N5: TMenuItem;
    N6: TMenuItem;
    procedure N1Click(Sender: TObject);
    procedure N2Click(Sender: TObject);
    procedure N3Click(Sender: TObject);
    procedure N4Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button15Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button14Click(Sender: TObject);
    procedure Button16Click(Sender: TObject);
    procedure Button13Click(Sender: TObject);
    procedure Button11Click(Sender: TObject);
    procedure Button10Click(Sender: TObject);
    procedure Button9Click(Sender: TObject);
    procedure Button12Click(Sender: TObject);
    procedure Button18Click(Sender: TObject);
    procedure Button23Click(Sender: TObject);
    procedure Button19Click(Sender: TObject);
    procedure Button17Click(Sender: TObject);
    procedure Button22Click(Sender: TObject);
    procedure Button21Click(Sender: TObject);
    procedure Button20Click(Sender: TObject);
    procedure Button32Click(Sender: TObject);
    procedure Button31Click(Sender: TObject);
    procedure Button27Click(Sender: TObject);
    procedure Button28Click(Sender: TObject);
    procedure Button26Click(Sender: TObject);
    procedure Button30Click(Sender: TObject);
    procedure Button29Click(Sender: TObject);
    procedure Button39Click(Sender: TObject);
    procedure Button37Click(Sender: TObject);
    procedure Button38Click(Sender: TObject);
    procedure Button36Click(Sender: TObject);
    procedure Button34Click(Sender: TObject);
    procedure Button35Click(Sender: TObject);
    procedure Button40Click(Sender: TObject);
    procedure TabSheet1Show(Sender: TObject);
    procedure TabSheet2Show(Sender: TObject);
    procedure TabSheet3Show(Sender: TObject);
    procedure TabSheet4Show(Sender: TObject);
    procedure TabSheet5Show(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure Button24Click(Sender: TObject);
    procedure Button25Click(Sender: TObject);
    procedure Button33Click(Sender: TObject);
    procedure N5Click(Sender: TObject);
    procedure N6Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form2: TForm2;

implementation

uses Unit1, Unit3, Unit4, Unit5, Unit6;

{$R *.dfm}

procedure TForm2.N1Click(Sender: TObject);
begin 
form1.Show ;
end;

procedure TForm2.N2Click(Sender: TObject);
begin
form2.Show ;
end;

procedure TForm2.N3Click(Sender: TObject);
begin
form3.show ;
end;

procedure TForm2.N4Click(Sender: TObject);
begin
form4.show;
end;

procedure TForm2.Button1Click(Sender: TObject);
begin
table1.Edit ;
end;

procedure TForm2.Button15Click(Sender: TObject);
begin
table1.Refresh ;
end;

procedure TForm2.Button7Click(Sender: TObject);
begin
 table1.Delete ;
end;

procedure TForm2.Button3Click(Sender: TObject);
begin
table1.First ;
end;

procedure TForm2.Button5Click(Sender: TObject);
begin
table1.Next ;
end;

procedure TForm2.Button6Click(Sender: TObject);
begin
table1.Prior ;
end;

procedure TForm2.Button2Click(Sender: TObject);
begin
table1.Last ;
end;

procedure TForm2.Button14Click(Sender: TObject);
begin
table2.Edit ;
end;

procedure TForm2.Button16Click(Sender: TObject);
begin
table2.Refresh ;
end;

procedure TForm2.Button13Click(Sender: TObject);
begin
table2.Delete ;
end;

procedure TForm2.Button11Click(Sender: TObject);
begin
table2.First ;
end;

procedure TForm2.Button10Click(Sender: TObject);
begin
table2.Next ;
end;

procedure TForm2.Button9Click(Sender: TObject);
begin
table2.Prior ;
end;

procedure TForm2.Button12Click(Sender: TObject);
begin
table2.Last ;
end;

procedure TForm2.Button18Click(Sender: TObject);
begin
table3.Edit ;
end;

procedure TForm2.Button23Click(Sender: TObject);
begin
table3.Refresh ;
end;

procedure TForm2.Button19Click(Sender: TObject);
begin
table3.Delete ;
end;

procedure TForm2.Button17Click(Sender: TObject);
begin
table3.First ;
end;

procedure TForm2.Button22Click(Sender: TObject);
begin
table3.Next ;
end;

procedure TForm2.Button21Click(Sender: TObject);
begin
table3.Prior ;
end;

procedure TForm2.Button20Click(Sender: TObject);
begin
table3.Last ;
end;

procedure TForm2.Button32Click(Sender: TObject);
begin
table4.Edit ;
end;

procedure TForm2.Button31Click(Sender: TObject);
begin
table4.Refresh ;
end;

procedure TForm2.Button27Click(Sender: TObject);
begin
table4.Delete ;
end;

procedure TForm2.Button28Click(Sender: TObject);
begin
table4.First ;
end;

procedure TForm2.Button26Click(Sender: TObject);
begin
table4.Next ;
end;

procedure TForm2.Button30Click(Sender: TObject);
begin
table4.Prior ;
end;

procedure TForm2.Button29Click(Sender: TObject);
begin
table4.Last ;
end;

procedure TForm2.Button39Click(Sender: TObject);
begin
table5.Edit ;
end;

procedure TForm2.Button37Click(Sender: TObject);
begin 
table5.Refresh ;
end;

procedure TForm2.Button38Click(Sender: TObject);
begin
table5.Delete ;
end;

procedure TForm2.Button36Click(Sender: TObject);
begin
table5.First ;
end;

procedure TForm2.Button34Click(Sender: TObject);
begin
table5.Next ;
end;

procedure TForm2.Button35Click(Sender: TObject);
begin
table5.Prior ;
end;

procedure TForm2.Button40Click(Sender: TObject);
begin
table5.Last ;
end;

procedure TForm2.TabSheet1Show(Sender: TObject);
begin
table1.Open ;
table2.Close ;
table3.Close ;
table4.Close ;
table5.Close ;
end;

procedure TForm2.TabSheet2Show(Sender: TObject);
begin
table2.Open ;
table1.Close ;
table3.Close ;
table4.Close ;
table5.Close ;
end;

procedure TForm2.TabSheet3Show(Sender: TObject);
begin
table3.Open ;
table2.Close ;
table1.Close ;
table4.Close ;
table5.Close ;
end;

procedure TForm2.TabSheet4Show(Sender: TObject);
begin
table4.Open ;
table2.Close ;
table3.Close ;
table1.Close ;
table5.Close ;
end;

procedure TForm2.TabSheet5Show(Sender: TObject);
begin
table5.Open ;
table2.Close ;
table3.Close ;
table4.Close ;
table1.Close ;
end;

procedure TForm2.Button4Click(Sender: TObject);
 begin
  table1.refresh;
  with table1 do
  try
    disablecontrols;
    filtered:=false;
    memo1.Text:='bookName='+''''+edit1.Text+'''';
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table1.recordcount=0 then
      begin
        messagebeep(1);
        showmessage('没有符合条件的纪录,请确认条件或放弃查询!');
           if messageDlg('是否继续查询？,只有结束查询才能作其它操作!',mtinformation,[mbYes,mbNo],0)=mrno then
           begin
           filtered:=false;
           table1.close;
           table1.open;
           end;
       end;
   end;
 end;


procedure TForm2.Button8Click(Sender: TObject);
 begin
  table2.refresh;
  with table2 do
  try
    disablecontrols;
    filtered:=false;
    memo1.Text:='writer='+''''+edit2.Text+'''';
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table2.recordcount=0 then
      begin
        messagebeep(1);
        showmessage('没有符合条件的纪录,请确认条件或放弃查询!');
           if messageDlg('是否继续查询？,只有结束查询才能作其它操作!',mtinformation,[mbYes,mbNo],0)=mrno then
           begin
           filtered:=false;
           table2.close;
           table2.open;
           end;
       end;
   end;
 end;

procedure TForm2.Button24Click(Sender: TObject);
 begin
  table3.refresh;
  with table3 do
  try
    disablecontrols;
    filtered:=false;
    if ComboBox1.Text='计算机'then
       memo1.Text:='kind='+''''+'computer'+''''
       else if ComboBox1.Text='英语' then
          memo1.Text:='kind='+''''+'english'+''''
          else  memo1.Text:='kind='+''''+'other'+'''' ;
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table3.recordcount=0 then
      begin
        messagebeep(1);
        showmessage('没有符合条件的纪录,请确认条件或放弃查询!');
           if messageDlg('是否继续查询？,只有结束查询才能作其它操作!',mtinformation,[mbYes,mbNo],0)=mrno then
           begin
           filtered:=false;
           table3.close;
           table3.open;
           end;
       end;
   end;
 end;

procedure TForm2.Button25Click(Sender: TObject);
 begin
  table4.refresh;
  with table4 do
  try
    disablecontrols;
    filtered:=false;
    memo1.Text:='publisher='+''''+edit4.Text+'''';
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table4.recordcount=0 then
      begin
        messagebeep(1);
        showmessage('没有符合条件的纪录,请确认条件或放弃查询!');
           if messageDlg('是否继续查询？,只有结束查询才能作其它操作!',mtinformation,[mbYes,mbNo],0)=mrno then
           begin
           filtered:=false;
           table4.close;
           table4.open;
           end;
       end;
   end;
 end;

procedure TForm2.Button33Click(Sender: TObject);
 begin
  table5.refresh;
  with table5 do
  try
    disablecontrols;
    filtered:=false;
    memo1.Text:='rest='+''''+ComboBox2.Text+'''';
    filter:=memo1.text;
    filtered:=true;
  finally
     enablecontrols;
     if table5.recordcount=0 then
      begin
        messagebeep(1);
        showmessage('没有符合条件的纪录,请确认条件或放弃查询!');
           if messageDlg('是否继续查询？,只有结束查询才能作其它操作!',mtinformation,[mbYes,mbNo],0)=mrno then
           begin
           filtered:=false;
           table5.close;
           table5.open;
           end;
       end;
   end;
 end;

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

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

end.