cw_snzd.pas

结于初学者来说这对数据库是一个很好的例子

unit cw_snzd;

interface

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

type
  TForm26 = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    Label2: TLabel;
    AccountNo: TEdit;
    Button1: TButton;
    GroupBox3: TGroupBox;
    DB_zd: TDBGrid;
    Button4: TButton;
    Button2: TButton;
    Q_zdcx: TQuery;
    DS_zdcx: TDataSource;
    Q_zdxxcx: TQuery;
    Button3: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure DB_zdDblClick(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure AccountNoKeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form26: TForm26;

implementation

uses cw_snzdxx, cw_spcx;

{$R *.dfm}

procedure TForm26.Button1Click(Sender: TObject);
begin
 if (length(AccountNo.Text)=0) then
  begin
   MessageDlg('输入不能为空，请重新输入！',mtError,[mbok],0);
   accountno.Clear;
   end
  else
   begin
  q_zdcx.Active:=False;
  Q_zdcx.SQL.Clear;
  Q_zdcx.SQL.Add('select * from H_Sn_Account where cstr(AccountNo)='''+AccountNo.Text+'''');
  Q_zdcx.Active:=True;
  accountno.Clear;
  end;

end;

procedure TForm26.Button4Click(Sender: TObject);
begin
  q_zdcx.Active:=False;
  Q_zdcx.SQL.Clear;
  Q_zdcx.SQL.Add('select * from H_Sn_Account order by AccountNo');
  Q_zdcx.Active:=True;

end;

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

procedure TForm26.DB_zdDblClick(Sender: TObject);
 var acc:string;
begin
  Q_zdcx.Open;
     with db_zd.DataSource.DataSet do
     begin
     GotoBookmark(pointer(db_zd.SelectedRows[0]));
     acc:=fields[0].AsString;
     end;
  form27.Q_acc.Active:=False;
  form27.Q_acc.SQL.Clear;
  form27.Q_acc.SQL.Add('select * from h_sn_account where accountno=cdbl('''+acc+''')');
  form27.Q_acc.Active:=True;
  form27.Q_xx.Active:=False;
  form27.Q_xx.SQL.Clear;
  form27.Q_xx.SQL.Add('select * from h_sn_dinlist where accountno=cdbl('''+acc+''')');
  form27.Q_xx.Active:=True;
  form27.ShowModal;
end;

procedure TForm26.Button3Click(Sender: TObject);
begin
 form51.showmodal;
end;

procedure TForm26.AccountNoKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;

end;

end.