rec.pas

1.使用某一高级语言和数据库（SOL2000

unit Rec;

interface

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

type
  TRecordFrm = class(TForm)
    ADOQuery1: TADOQuery;
    Panel1: TPanel;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    ADOQuery1RecordID: TWideStringField;
    ADOQuery1RecordDoc: TWideStringField;
    ADOQuery1RecordDate: TDateTimeField;
    ADOQuery1RecordMomo: TWideStringField;
    Panel3: TPanel;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    DateTimePicker1: TDateTimePicker;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    SpeedButton6: TSpeedButton;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure SpeedButton6Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  RecordFrm: TRecordFrm;

implementation

uses Data, Client;

{$R *.dfm}

procedure TRecordFrm.FormClose(Sender: TObject; var Action: TCloseAction);
begin
RecordFrm:=nil;
end;

procedure TRecordFrm.SpeedButton6Click(Sender: TObject);
begin
    close;
end;

procedure TRecordFrm.FormShow(Sender: TObject);
begin
    with ADOQuery1 do
    begin
    close;
    sql.Text:='select * from Record where recordid='''+trim(ClientFrm.DBEdit2.Text)+''' ';
    //ShowMessage(sql.Text);
    open;
    end;
    DBEdit1.Enabled:=false;
    DBEdit2.Enabled:=false;
    DBEdit3.Enabled:=false;
    DBEdit4.Enabled:=false;
    //DateTimePicker1.DateTime:=StrToDate(trim(DBEdit3.Text));
end;

procedure TRecordFrm.SpeedButton1Click(Sender: TObject);
begin
ADOQuery1.Append;
DBEdit1.Enabled:=true;
    DBEdit2.Enabled:=true;
    DBEdit3.Enabled:=true;
    DBEdit4.Enabled:=true;
    DBEdit1.SetFocus;
    SpeedButton5.Enabled:=true;
end;

procedure TRecordFrm.SpeedButton2Click(Sender: TObject);
begin
ADOQuery1.Delete;
end;

procedure TRecordFrm.SpeedButton3Click(Sender: TObject);
begin
ADOQuery1.Edit;
DBEdit1.Enabled:=true;
    DBEdit2.Enabled:=true;
    DBEdit3.Enabled:=true;
    DBEdit4.Enabled:=true;
    SpeedButton5.Enabled:=true;
end;

procedure TRecordFrm.SpeedButton4Click(Sender: TObject);
begin
ADOQuery1.Cancel;
end;

procedure TRecordFrm.SpeedButton5Click(Sender: TObject);
begin
ADOQuery1.Edit;
DBEdit3.Text:=DateToStr(DateTimePicker1.Date);
ADOQuery1.Post;
SpeedButton5.Enabled:=false;
end;

end.