unit2.pas.~4~

delphi2007开发的汽车配件进销存系统.实用级的源码.

unit Unit2;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, StdCtrls, GridsEh, DBGridEh, cxControls, cxContainer,
  cxEdit, cxGroupBox;

type
  TForm1 = class(TForm)
    cxGroupBox1: TcxGroupBox;
    DBGridEh1: TDBGridEh;
    edt1: TEdit;
    cxGroupBox2: TcxGroupBox;
    DBGridEh2: TDBGridEh;
    con1: TADOConnection;
    qry1: TADOQuery;
    qry2: TADOQuery;
    ds1: TDataSource;
    ds2: TDataSource;
    cxGroupBox3: TcxGroupBox;
    DBGridEh3: TDBGridEh;
    qry3: TADOQuery;
    ds3: TDataSource;
    procedure DBGridEh1CellClick(Column: TColumnEh);
    procedure edt1KeyUp(Sender: TObject; var Key: Word; Shift: TShiftState);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.DBGridEh1CellClick(Column: TColumnEh);
begin
  with qry2 do begin
    Close;
    with SQL do begin
      Clear;
      Add('select * from xsdmx where xsdh =:p_xsdh');
    end;
    Parameters.ParamByName('p_xsdh').Value := qry1.FieldByName('xsdh').Value;
    Open;
  end;
end;

procedure TForm1.edt1KeyUp(Sender: TObject; var Key: Word; Shift: TShiftState);
begin
 with qry1 do begin
    active:=false;
    with sql do begin
      Clear;
      Add('select distinct a.xsdh,a.dwbm,a.xsrq,b.dwmc,b.ch from xsd a,dwgl b where a.dwbm=b.dwbm ');
      add(' and (a.xsdh like :p_xsdh or b.ch like :p_ch or b.dwmc like :p_dwmc)');
      Add(' order by a.xsdh desc');
    end;
    Parameters.ParamByName('p_xsdh').value:='%'+ edt1.Text+'%';
    Parameters.ParamByName('p_ch').value:='%'+ edt1.Text+'%';
    Parameters.ParamByName('p_dwmc').value:='%'+ edt1.Text+'%';
    Active:=true;
  end;
end;

end.