u_namequery.~pas

对于医院的影像室的资料进行管理,主要方便查阅,特别是对于病人的照片的病前后比较对于病情的发展很有价值

unit U_namequery;

interface

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

type
  TF_namequery = class(TForm)
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    GroupBox2: TGroupBox;
    button1: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    Label1: TLabel;
    Edit1: TEdit;
    GroupBox1: TGroupBox;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    Label4: TLabel;
    count: TEdit;
    btnUpd: TBitBtn;
    btnDele: TBitBtn;
    procedure Button1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure DBGrid1TitleClick(Column: TColumn);
    procedure BitBtn4Click(Sender: TObject);
    procedure btnUpdClick(Sender: TObject);
    procedure btnDeleClick(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
    procedure FormKeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_namequery: TF_namequery;

implementation
uses U_datamodule,U_filmrecord;
{$R *.dfm}

procedure TF_namequery.Button1Click(Sender: TObject);
begin
adoquery1.Close;
adoquery1.SQL.Text:='select * from filmrecord where name like '+'''%'+edit1.Text+'%'''+' order by filmnumber';
adoquery1.Open;
adoquery1.Sort:= 'filmnumber';
count.text:=inttostr(adoquery1.RecordCount);
end;

procedure TF_namequery.FormShow(Sender: TObject);
begin
adoquery1.close;
adoquery1.SQL.Text:='select * from filmrecord';
adoquery1.Open;
count.text:=inttostr(adoquery1.RecordCount);
end;

procedure TF_namequery.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
adoquery1.Close;
end;

procedure TF_namequery.DBGrid1TitleClick(Column: TColumn);
begin
SortDataset(column);

end;

procedure TF_namequery.BitBtn4Click(Sender: TObject);
begin
close;
end;

procedure TF_namequery.btnUpdClick(Sender: TObject);
begin
if not adoquery1.active then exit;
if   adoquery1.FieldByName('filmnumber').asstring='' then exit;
updFilmRecData(adoquery1.fieldbyname('filmnumber').asstring);

end;

procedure TF_namequery.btnDeleClick(Sender: TObject);
begin
if not  adoquery1.active then exit;
if   adoquery1.FieldByName('filmnumber').asstring='' then exit;
if messagebox(handle,'你希望删除当前的数据吗?请小心删除,删除后将不能恢复该信息.','[危险操作]确认信息',mb_iconwarning+mb_YESNO+mb_defbutton2)<>idYes then
exit;
adoquery1.Delete;
count.text:=inttostr(adoquery1.RecordCount);
end;

procedure TF_namequery.DBGrid1DblClick(Sender: TObject);
begin
btnUpd.Click;
end;

procedure TF_namequery.FormKeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
if key=vk_escape then
close;
end;

end.