u_stagequery.~pas

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

unit U_stagequery;

interface

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

type
  TF_stagequery = class(TForm)
    DataSource1: TDataSource;
    ADOQuery1: TADOQuery;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Ediagnose: TEdit;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Button1: TBitBtn;
    BitBtn2: TBitBtn;
    btnClose: TBitBtn;
    GroupBox2: TGroupBox;
    DBGrid1: TDBGrid;
    Panel1: TPanel;
    count: TEdit;
    Label4: TLabel;
    btnUpd: TBitBtn;
    btnDele: TBitBtn;
    procedure Button1Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure DBGrid1TitleClick(Column: TColumn);
    procedure btnCloseClick(Sender: TObject);
    procedure btnDeleClick(Sender: TObject);
    procedure btnUpdClick(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_stagequery: TF_stagequery;

implementation

uses U_filmrecord;

{$R *.dfm}

procedure TF_stagequery.Button1Click(Sender: TObject);
begin
adoquery1.close;
//adoquery1.sql.Text:='select * from filmrecord where date between #'+begindate.Text+'# and #'+enddate.Text+'#';
//adoquery1.SQL.Text:='select * from filmrecord where diagnose like '+'''%'+ediagnose.Text+'%'''+' and (date between #'+begindate.Text+'# and #'+enddate.Text+'#)';
adoquery1.SQL.Text:='select * from filmrecord where filmstage like '+'''%'+ediagnose.text+'%'''+' and date between #'+formatdatetime('yyyy-mm-dd',datetimepicker1.Date)+'# and #'+formatdatetime('yyyy-mm-dd',datetimepicker2.Date)+'# order by Filmnumber';
adoquery1.Open;
adoquery1.Sort:= 'filmnumber';
count.text:=inttostr(adoquery1.RecordCount);
end;

procedure TF_stagequery.FormShow(Sender: TObject);
begin
datetimepicker1.date:=now-365;
datetimepicker2.Date:=now;
Button1Click(nil);
end;

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

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

procedure TF_stagequery.btnCloseClick(Sender: TObject);
begin
close;
end;

procedure TF_stagequery.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_stagequery.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_stagequery.DBGrid1DblClick(Sender: TObject);
begin
btnUpd.Click;
end;

end.