formquery6.pas

1.大家请将SQLServer2000中的sa用户的密码设定为sa2.将DataBase目录下的数据库附加到SQLSERVER中 应用于出租车车辆管理中的

unit formquery6;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, DBTables, StdCtrls, Buttons, Grids, DBGrids, FMTBcd, SqlExpr,
  DBClient, Provider;

type
  Tformquery_6 = class(TForm)
    GroupBox1: TGroupBox;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    ComboBox3: TComboBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    DBGrid1: TDBGrid;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    DataSource1: TDataSource;
    Query1: TSQLQuery;
    DataSetProvider1: TDataSetProvider;
    ClientDataSet1: TClientDataSet;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  formquery_6: Tformquery_6;

implementation

uses utData;

{$R *.dfm}

procedure Tformquery_6.BitBtn1Click(Sender: TObject);
begin
ClientDataSet1.Active := False;
query1.close;
query1.SQL.Clear;
query1.SQL.add('select * from 车辆租用登记表');
query1.SQL.add(' where 车号='''+edit1.text+''' or 车型='''+edit2.text+''' or 车主='''+edit3.text+''' or 结算金额='''+edit4.text+''' or 租用方式='''+combobox1.text+''' or 是否配司机='''+combobox2.text+''' or 客户是否结账='''+combobox3.text+'''');
query1.Open;
ClientDataSet1.Active := True;
end;

procedure Tformquery_6.BitBtn2Click(Sender: TObject);
begin
Close; 
end;

procedure Tformquery_6.FormShow(Sender: TObject);
begin
query1.Open;
end;

procedure Tformquery_6.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
query1.close;
action:=cafree;

end;

end.