procedure TForm1.Button1Click(Sender: TObject); begin //DBGrid1.Enabled:=true; StrSql:='select 合同编号,客户名称,合同金额,销售员,签订日期 from 合同档案.db where 销售员=:name and 签订日期>:date1 and 签订日期<:date2'; query1.Close; query1.sql.Clear; query1.Params[0].AsString:=trim(edit1.Text);//query1.ParamByName('name').Asstring is useful query1.Params[1].AsDate:=DateTimePicker1.Date; query1.Params[2].AsDate:=DateTimePicker2.Date; query1.Sql.Add(StrSql); query1.Open; end;
procedure TForm1.Button1Click(Sender: TObject); begin //DBGrid1.Enabled:=true; StrSql:='select 合同编号,客户名称,合同金额,销售员,签订日期 from 合同档案.db where 销售员=:name and 签订日期>:date1 and 签订日期<:date2'; query1.Close; query1.sql.Clear; query1.Sql.Add(StrSql); query1.Params[0].AsString:=trim(edit1.Text);//query1.ParamByName('name').Asstring is useful query1.Params[1].AsDate:=DateTimePicker1.Date; query1.Params[2].AsDate:=DateTimePicker2.Date; query1.Open; end;
procedure TForm1.Button1Click(Sender: TObject); begin //DBGrid1.Enabled:=true; StrSql:='select 合同编号,客户名称,合同金额,销售员,签订日期 from 合同档案.db where 销售员=:name and 签订日期>:date1 and 签订日期<:date2'; query1.Close; query1.sql.Clear; query1.Sql.Add(StrSql); query1.Params[0].AsString:=trim(edit1.Text); query1.Params[1].AsDate:=DateTimePicker1.Date; query1.Params[2].AsDate:=DateTimePicker2.Date; query1.Open; end;
where 销售员=:name and 签订日期>:date1 and 签订日期<:date2:name,:date1, :date2的赋值在外面用窗体进行
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, Grids, DBGrids, DB, DBTables, StdCtrls, Buttons, BaseGrid,
AdvGrid, DBAdvGrd,math, ComCtrls, VrLabel, VrControls, VrDeskTop,
AdvCombo, Lucombo, dblucomb, TodoList, DBTodoList, AdvEdit, DBAdvEd;type
TForm1 = class(TForm)
DataSource1: TDataSource;
Query1: TQuery;
VrDeskTop1: TVrDeskTop;
VrLabel1: TVrLabel;
DateTimePicker1: TDateTimePicker;
DateTimePicker2: TDateTimePicker;
DBGrid1: TDBGrid;
VrLabel2: TVrLabel;
VrLabel3: TVrLabel;
VrLabel4: TVrLabel;
Edit1: TEdit;
Button1: TButton;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
begin //DBGrid1.Enabled:=true;
query1.Close;
query1.sql.Clear;
query1.Params[0].AsString:=trim(edit1.Text);
query1.Params[1].AsDate:=DateTimePicker1.Date;
query1.Params[2].AsDate:=DateTimePicker2.Date;
query1.Open;
end;end.
begin //DBGrid1.Enabled:=true;
StrSql:='select 合同编号,客户名称,合同金额,销售员,签订日期 from 合同档案.db
where 销售员=:name and 签订日期>:date1 and 签订日期<:date2'; query1.Close;
query1.sql.Clear;
query1.Params[0].AsString:=trim(edit1.Text);//query1.ParamByName('name').Asstring is useful
query1.Params[1].AsDate:=DateTimePicker1.Date;
query1.Params[2].AsDate:=DateTimePicker2.Date;
query1.Sql.Add(StrSql);
query1.Open;
end;
begin //DBGrid1.Enabled:=true;
StrSql:='select 合同编号,客户名称,合同金额,销售员,签订日期 from 合同档案.db
where 销售员=:name and 签订日期>:date1 and 签订日期<:date2'; query1.Close;
query1.sql.Clear;
query1.Sql.Add(StrSql);
query1.Params[0].AsString:=trim(edit1.Text);//query1.ParamByName('name').Asstring is useful
query1.Params[1].AsDate:=DateTimePicker1.Date;
query1.Params[2].AsDate:=DateTimePicker2.Date;
query1.Open;
end;
procedure TForm1.Button1Click(Sender: TObject);
begin //DBGrid1.Enabled:=true;
StrSql:='select 合同编号,客户名称,合同金额,销售员,签订日期 from 合同档案.db
where 销售员=:name and 签订日期>:date1 and 签订日期<:date2'; query1.Close;
query1.sql.Clear;
query1.Sql.Add(StrSql);
query1.Params[0].AsString:=trim(edit1.Text);
query1.Params[1].AsDate:=DateTimePicker1.Date;
query1.Params[2].AsDate:=DateTimePicker2.Date;
query1.Open;
end;