kucunzonglan.pas

DELPHI语言制作的音象管理系统 很经典的例子噢 欢迎下载参考

unit kucunzonglan;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, Grids, DBGrids, StdCtrls, ComCtrls, DBActns, ActnList,
  Buttons, ExtCtrls;

type
  TForm7 = class(TForm)
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    SpeedButton6: TSpeedButton;
    SpeedButton7: TSpeedButton;
    SpeedButton8: TSpeedButton;
    ActionList1: TActionList;
    DataSetFirst1: TDataSetFirst;
    DataSetPrior1: TDataSetPrior;
    DataSetNext1: TDataSetNext;
    DataSetLast1: TDataSetLast;
    DataSetInsert1: TDataSetInsert;
    DataSetDelete1: TDataSetDelete;
    DataSetPost1: TDataSetPost;
    DataSetRefresh1: TDataSetRefresh;
    DataSetCancel1: TDataSetCancel;
    SpeedButton9: TSpeedButton;
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    GroupBox3: TGroupBox;
    RadioButton1: TRadioButton;
    RadioButton2: TRadioButton;
    RadioButton3: TRadioButton;
    RadioButton4: TRadioButton;
    RadioButton5: TRadioButton;
    RadioButton6: TRadioButton;
    Edit1: TEdit;
    Label1: TLabel;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Label2: TLabel;
    Label3: TLabel;
    GroupBox4: TGroupBox;
    SpeedButton10: TSpeedButton;
    SpeedButton11: TSpeedButton;
    SpeedButton13: TSpeedButton;
    Label4: TLabel;
    DBGrid2: TDBGrid;
    SpeedButton12: TSpeedButton;
    SpeedButton14: TSpeedButton;
    DataSource2: TDataSource;
    SpeedButton15: TSpeedButton;
    SpeedButton16: TSpeedButton;
    Image1: TImage;
    Image2: TImage;
    SpeedButton17: TSpeedButton;
    SpeedButton18: TSpeedButton;

    procedure FormActivate(Sender: TObject);
    procedure SpeedButton6Click(Sender: TObject);
    procedure SpeedButton8Click(Sender: TObject);
    procedure SpeedButton13Click(Sender: TObject);
    procedure SpeedButton10Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure SpeedButton15Click(Sender: TObject);
    procedure SpeedButton16Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure SpeedButton17Click(Sender: TObject);
    procedure SpeedButton18Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    

    
    
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form7: TForm7;

implementation

uses datamoban, main;

{$R *.dfm}

procedure TForm7.FormActivate(Sender: TObject);
begin
datamodule1.ADOTable1.Active:=false;
datamodule1.ADOTable1.Active:=true;
datamodule1.ADOQuery1.Active:=false;
datamodule1.ADOQuery1.Active:=true;
end;

procedure TForm7.SpeedButton6Click(Sender: TObject);
begin
if messagedlg('确实要删除此条记录吗？',mtInformation,[mbOK, mbCancel],0)=mrok then
datamodule1.ADOTable1.Delete;
end;

procedure TForm7.SpeedButton8Click(Sender: TObject);
begin
form7.Close;
end;

procedure TForm7.SpeedButton13Click(Sender: TObject);
begin
form7.Close;
end;

procedure TForm7.SpeedButton10Click(Sender: TObject);
begin
if messagedlg('确定删除本条记录吗？',mtInformation,[mbOK, mbCancel],0)=mrok then

datamodule1.ADOquery1.Delete;


end;

procedure TForm7.Button1Click(Sender: TObject);
begin
datasource2.DataSet:=datamodule1.ADOQuery1;
if RadioButton1.Checked then

    if not datamodule1.adotable1.Locate('编号',edit1.Text,[]) then
        begin
             showmessage('没有这条记录，请重新输入');
             edit1.Text:='';
         end
     else
         begin

         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 编号='''+edit1.Text+'''');
         datamodule1.ADOQuery1.Open;
         end;
if RadioButton5.Checked then
         begin
         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 地域='''+combobox1.Text+'''');
         datamodule1.ADOQuery1.Open;
         end;
if RadioButton2.Checked then
        if not datamodule1.adotable1.Locate('片名',edit1.Text,[]) then
        begin
             showmessage('没有这条记录，请重新输入');
             edit1.Text:='';
         end
     else
         begin
         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 片名='''+edit1.Text+'''');
         datamodule1.ADOQuery1.Open;
end;
if RadioButton3.Checked then
  if not datamodule1.adotable1.Locate('主演',edit1.Text,[]) then
        begin
             showmessage('没有这条记录，请重新输入');
             edit1.Text:='';
         end
     else
         begin
         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 主演='''+edit1.Text+'''');
         datamodule1.ADOQuery1.Open;
end;
if RadioButton4.Checked then

    if not datamodule1.adotable1.Locate('导演',edit1.Text,[]) then
        begin
             showmessage('没有这条记录，请重新输入');
             edit1.Text:='';
         end
     else
         begin

         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 导演='''+edit1.Text+'''');
         datamodule1.ADOQuery1.Open;
         end;
if RadioButton6.Checked then
         begin
         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 影片类型='''+combobox2.Text+'''');
         datamodule1.ADOQuery1.Open;
end;



end;

procedure TForm7.SpeedButton15Click(Sender: TObject);
begin
datamodule1.ADOTable1.Active:=false;
datamodule1.ADOTable1.Active:=true;

end;

procedure TForm7.SpeedButton16Click(Sender: TObject);
begin
datamodule1.ADOQuery1.Active:=false;
datamodule1.ADOQuery1.Active:=true;
end;

procedure TForm7.Button2Click(Sender: TObject);
begin
datasource2.dataset:=datamodule1.ADOTable1;
datamodule1.ADOTable1.Active:=false;
datamodule1.ADOTable1.Active:=true;
end;

procedure TForm7.SpeedButton17Click(Sender: TObject);
begin
datasource2.DataSet:=datamodule1.ADOQuery1;
if RadioButton1.Checked then
   begin
    if not datamodule1.adotable1.Locate('编号',edit1.Text,[]) then
        begin
             showmessage('没有这条记录，请重新输入');
             edit1.Text:='';
         end
     else
         begin

         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 编号='''+edit1.Text+'''');
         datamodule1.ADOQuery1.Open;
         end;
     end;
if RadioButton5.Checked then
         begin
         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 地域='''+combobox1.Text+'''');
         datamodule1.ADOQuery1.Open;
         end;
if RadioButton2.Checked then
  begin
        if not datamodule1.adotable1.Locate('片名',edit1.Text,[]) then
        begin
             showmessage('没有这条记录，请重新输入');
             edit1.Text:='';
         end
     else
         begin
         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 片名='''+edit1.Text+'''');
         datamodule1.ADOQuery1.Open;
end;
end;
if RadioButton3.Checked then
    begin
    if not datamodule1.adotable1.Locate('主演',edit1.Text,[]) then
        begin
             showmessage('没有这条记录，请重新输入');
             edit1.Text:='';
         end
     else
         begin

         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 主演='''+edit1.Text+'''');
         datamodule1.ADOQuery1.Open;
         end;
     end;
if RadioButton4.Checked then
     begin
    if not datamodule1.adotable1.Locate('导演',edit1.Text,[]) then
        begin
             showmessage('没有这条记录，请重新输入');
             edit1.Text:='';
         end
     else
         begin

         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 导演='''+edit1.Text+'''');
         datamodule1.ADOQuery1.Open;
         end;
     end;
if RadioButton6.Checked then
         begin
         datamodule1.ADOQuery1.Close;
         datamodule1.ADOQuery1.SQL.Clear;
         datamodule1.ADOQuery1.SQL.Add('select * from 库存总揽 where 影片类型='''+combobox2.Text+'''');
         datamodule1.ADOQuery1.Open;
         end;
end;

procedure TForm7.SpeedButton18Click(Sender: TObject);
begin
datasource2.dataset:=datamodule1.ADOTable1;
datamodule1.ADOTable1.Active:=false;
datamodule1.ADOTable1.Active:=true;
end;

procedure TForm7.FormClose(Sender: TObject; var Action: TCloseAction);
begin
form1.windowstate:=wsmaximized;
end;

end.