unit2.pas.~2~

来自「delphi2007开发的汽车配件进销存系统.实用级的源码.」· ~2~ 代码 · 共 54 行

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);
  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;

end.