formyewuyuanxinxi.~pas

这是一个关于药品进销存的管理软件

unit FormYewuyuanxinxi;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, Grids, DBGrids, ADODB;

type
  Tyewuyuanxinxi = class(TForm)
    ADOTable1: TADOTable;
    DBGrid1: TDBGrid;
    DataSource1: TDataSource;
    procedure DBGrid1DblClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  yewuyuanxinxi: Tyewuyuanxinxi;

implementation

uses FormJinhuodanbiaotouxinxi, FormJinhuodanchakan, FormXiaoshoudanchakan;

{$R *.dfm}

procedure Tyewuyuanxinxi.DBGrid1DblClick(Sender: TObject);
begin
if  jinhuodanchakan.Visible=true then
begin
  jinhuodanbiaotouxinxi.Caption:='进货单表头信息查看';
  jinhuodanbiaotouxinxi.show;
  jinhuodanbiaotouxinxi.ADOQuery1.Close ;
  jinhuodanbiaotouxinxi.ADOQuery1.SQL.Clear;
  jinhuodanbiaotouxinxi.ADOQuery1.SQL.Text:='select * from 入库信息查询 where 业务员姓名='''+dbgrid1.Fields[1].Text+'''';
  jinhuodanbiaotouxinxi.ADOQuery1.Open;
  end;
if  xiaoshoudanchakan.Visible=true then
  begin
  jinhuodanbiaotouxinxi.Caption:='销售单表头信息查看';
  jinhuodanbiaotouxinxi.show;
  jinhuodanbiaotouxinxi.ADOQuery1.Close ;
  jinhuodanbiaotouxinxi.ADOQuery1.SQL.Clear;
  jinhuodanbiaotouxinxi.ADOQuery1.SQL.Text:='select * from 销售信息查询 where 业务员姓名='''+dbgrid1.Fields[1].Text+'''';
  jinhuodanbiaotouxinxi.ADOQuery1.Open;
  end;
end;

end.