dzdwunit.pas

集成酒店桑拿食管管理的完整程序

unit dzdwUnit;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Db, DBTables, Grids, DBGrids, ExtCtrls;

type
  TgzdwForm = class(TForm)
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    Query1: TQuery;
    DataSource1: TDataSource;
    Label1: TLabel;
    zh: TEdit;
    Button1: TButton;
    Button2: TButton;
    procedure FormShow(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure DBGrid1DblClick(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure zhChange(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  gzdwForm: TgzdwForm;
  zhhao,danwei:string;
implementation

{$R *.DFM}
 uses dataproc;
procedure TgzdwForm.FormShow(Sender: TObject);
begin
    zh.Text:='';
    query1.Active:=false;
    query1.SQL.Clear;
    query1.SQL.Add('select * from zhdb ');
    query1.Prepare;
    query1.Open;
    ChineseGrid(dbgrid1);
end;

procedure TgzdwForm.Button1Click(Sender: TObject);
begin
    query1.Active:=false;
    query1.SQL.Clear;
    query1.SQL.Add('select * from zhdb where jc>='''+trim(zh.Text)+''' and jc<='''+trim(zh.Text)+chr(255)+'''');
    query1.Prepare;
    query1.Open;
    ChineseGrid(dbgrid1);
end;

procedure TgzdwForm.DBGrid1DblClick(Sender: TObject);
begin
   zhhao:=query1.Fields[0].AsString;
   danwei:=query1.Fields[1].AsString;
   query1.Close;
   gzdwForm.Close;
end;

procedure TgzdwForm.Button2Click(Sender: TObject);
begin
  close;
end;

procedure TgzdwForm.zhChange(Sender: TObject);
begin
    query1.Active:=false;
    query1.SQL.Clear;
    query1.SQL.Add('select * from zhdb where jc>='''+trim(zh.Text)+''' and jc<='''+trim(zh.Text)+chr(255)+'''');
    query1.Prepare;
    query1.Open;
    ChineseGrid(dbgrid1);

end;

end.