unit6.pas

来自「药房管理程序实现药房的基本管理功能」· PAS 代码 · 共 85 行

unit Unit6;

interface

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

type
  Tqygl_form = class(TForm)
    Panel1: TPanel;
    cmdok: TButton;
    cmdclose: TButton;
    DBGrid1: TDBGrid;
    Query1: TQuery;
    Label1: TLabel;
    Label2: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    ADOTable2: TADOTable;
    ADOConnection2: TADOConnection;
    DataSource2: TDataSource;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    DBGrid2: TDBGrid;
    ADOQuery2: TADOQuery;
    DataSource3: TDataSource;
    procedure cmdcloseClick(Sender: TObject);
    procedure Edit1Change(Sender: TObject);
    procedure cmdokClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  qygl_form: Tqygl_form;

implementation

{$R *.dfm}

procedure Tqygl_form.cmdcloseClick(Sender: TObject);
begin
close;

end;

procedure Tqygl_form.Edit1Change(Sender: TObject);
Var SqlStr:string;
begin
  With ADOQuery1  do
     begin
       close;
       ADOQuery1.Sql.Clear;
       SqlStr:='Select * from 购物车记录 Where 客户名='+''''+Edit1.Text+'''';
       ADOQuery1.Sql.Add(SqlStr);
       Open;


       Edit2.Text:=Fieldbyname('编号').asstring;

     end;
  end;


procedure Tqygl_form.cmdokClick(Sender: TObject);
var
    bh,sqlstr:string;
begin

    bh:=Edit2.Text;

    sqlstr:='select 图书编号,数量  from 图书销售 where (编号='''+bh+''')';
    ADOQuery2.SQL.Clear;
    ADOQuery2.SQL.Add(sqlstr);
    ADOQuery2.Open;

end;

end.