uwxjlcx.pas

来自「很好的汽车管理系统 很实用的 谢谢合作」· PAS 代码 · 共 158 行

unit UWXJLCX;

interface

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

type
  TWXJLCX = class(TForm)
    ToolBar1: TToolBar;
    Panel2: TPanel;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    Label3: TLabel;
    ComboBox1: TComboBox;
    CheckBox1: TCheckBox;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Panel4: TPanel;
    Panel5: TPanel;
    Panel3: TPanel;
    DBGrid1: TDBGrid;
    SpeedButton1: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    DBNavigator1: TDBNavigator;
    procedure SpeedButton3Click(Sender: TObject);
    procedure ComboBox1DropDown(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure CheckBox1Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure ComboBox1Change(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  WXJLCX: TWXJLCX;

implementation

uses UDM, UMain, ADODB;

{$R *.dfm}

procedure TWXJLCX.SpeedButton3Click(Sender: TObject);
begin
  Close;
end;

procedure TWXJLCX.ComboBox1DropDown(Sender: TObject);
var
  i:integer;
begin
  ComboBox1.Clear;
  with DM.QWXXX do
  begin
    SQL.clear;
    SQl.Text := 'select cph from wxxx';
    Close;
    Active := False;
    prepared := False;
    prepared := True;
    Active := True;
    if (recordcount > 0) then
      first;
    for i := 0 to recordcount - 1 do
    begin //取得该列所有的数据到combobox2控件中
      combobox1.Items.add(FieldByName('cph').asstring);
      next;
    end;
  end;
end;


procedure TWXJLCX.SpeedButton4Click(Sender: TObject);
begin
  if ComboBox1.Text<>'' then
  begin
    with DM.QWXXX do
    begin
      Close;
      SQL.Clear;
      SQL.text:='Select * from wxxx where cph like'+#39+'%'+trim(ComboBox1.Text)+'%'+#39;
      open;
      DBGrid1.DataSource:=DM.DSWXXX;
    end;
  CheckBox1.Enabled:=True;
  end;
  if CheckBox1.Checked then
  begin
    with DM.QWXXX do
    begin
      Close;
      SQL.Clear;
      SQL.text:='SELECT * FROM WXXX WHERE wxrq between  :a AND :b ';
      Parameters.ParamByName('a').Value:=datetimepicker1.DateTime;
      parameters.ParamByName('b').Value:= datetimepicker2.DateTime;
      Open;
      DBGrid1.DataSource:=DM.DSWXXX;
    end;
    ComboBox1.Enabled:=True;
  end;
end;

procedure TWXJLCX.CheckBox1Click(Sender: TObject);
begin
  if CheckBox1.Checked=true then
  begin
    ComboBox1.Clear;
    ComboBox1.Enabled:=False;
    DateTimePicker1.Enabled:=True;
    DateTimePicker2.Enabled:=True;
  end
  else
  begin
    ComboBox1.Enabled:=True;
    DateTimePicker1.Enabled:=False;
    DateTimePicker2.Enabled:=False;
  end;
end;

procedure TWXJLCX.SpeedButton1Click(Sender: TObject);
begin
  ComboBox1.Clear;
  CheckBox1.Checked:=False;
  with DM.QWXXX DO
  BEGIN
    CLOSE;
    SQL.Clear;
    SQL.text:='Select * from wxxx';
    Open;
    DBGrid1.DataSource:=DM.DSWXXX;
  END;
end;

procedure TWXJLCX.ComboBox1Change(Sender: TObject);
begin
  CheckBox1.Checked:=False;
  CheckBox1.Enabled:=False;
end;

procedure TWXJLCX.FormShow(Sender: TObject);
begin
  DateTimePicker1.Date:=now;
  DateTimePicker2.Date:=now;
end;

end.