formquery1.pas.~25~

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

unit formquery1;

interface

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

type
  Tform_query1 = class(TForm)
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    BitBtn1: TBitBtn;
    GroupBox1: TGroupBox;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Edit5: TEdit;
    BitBtn2: TBitBtn;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Edit7: TEdit;
    Label7: TLabel;
    dtp_date1: TDateTimePicker;
    Label6: TLabel;
    dtp_date2: TDateTimePicker;
    Label8: TLabel;
    CheckBox1: TCheckBox;
    Table1: TSQLTable;
    Query1: TSQLQuery;
    SimpleDataSet1: TSimpleDataSet;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormShow(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
 //   procedure editkeypress(Sender: tobject; var key: char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  form_query1: Tform_query1;

implementation

uses report, utData;

{$R *.dfm}

procedure Tform_query1.BitBtn1Click(Sender: TObject);
var aSQL:string;
begin

if edit1.text<>''  then aSQL:='and 序号='''+edit1.Text+'''';
if edit2.text<>'' then aSQL:=aSQL+ 'and 姓名='''+edit2.text+''' ';
if edit3.text<>'' then aSQL:=aSQL+ 'and 户口本='''+edit3.text+''' ';
if edit4.text<>'' then aSQL:=aSQL+ 'and 身份证='''+edit4.text+''' ';
if edit5.text<>'' then aSQL:=aSQL+ 'and  驾驶证='''+edit5.text+''' ';
if edit7.text<>'' then aSQL:=aSQL+ 'and 联系电话='''+edit7.text+'''';
if checkbox1.Checked then  aSQL:=aSQL+ 'and (租车时间> :d1 ) and (租车时间< :d2 )' ;
if asql<>''then
      begin
       //query1.close;
       //query1.SQL.Clear;
       //query1.Active :=False;
       SimpleDataSet1.Active :=False;
//       query1.sql.text:='select * from 会员档案登记表 where 序号<>'''' '+asql;
       SimpleDataSet1.DataSet.CommandText :=  'select * from 会员档案登记表 where 序号<>'''' '+asql;
       if checkbox1.Checked  then
          begin
          // query1.Params[0].AsDate:=dtp_date1.Date;
          //query1.Params[1].AsDate :=dtp_date2.Date;
          //SimpleDataSet1.Params.ParamByName('d1').AsDate :=dtp_date1.Date;
         // SimpleDataSet1.Params.ParamByName('d2').AsDate :=dtp_date1.Date;
            SimpleDataSet1.DataSet.Params[0].Value := dtp_date1.Date;
            SimpleDataSet1.DataSet.Params[1].Value := dtp_date2.Date;
          end;
       //DataSource1.DataSet:=query1;
      // query1.Open;
     // query1.Active :=True;
     SimpleDataSet1.Active := True;
     end;

end;

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

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

end;

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

procedure Tform_query1.BitBtn3Click(Sender: TObject);
begin
reportform.q_form2query.preview;

end;

end.