gyglrq_gy.pas

商品批发管理系统ADO版

unit gyglRQ_gy;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ComCtrls, XPMenu;

type
  TgyglRQgy = class(TForm)
    DateTimeT: TDateTimePicker;
    Button1: TButton;
    Button2: TButton;
    Label1: TLabel;
    Label2: TLabel;
    DateTimeF: TDateTimePicker;
    XPMenu1: TXPMenu;
    procedure Button2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  gyglRQgy: TgyglRQgy;

implementation

uses newDM, main;

{$R *.dfm}

procedure TgyglRQgy.Button2Click(Sender: TObject);
begin
close;
end;

procedure TgyglRQgy.Button1Click(Sender: TObject);
var
 eee:string;
begin
 with DM do
   Begin
    eee:='select * from gyb where gyrq between :form and :to';
    if ADOQgygl.Active then
        ADOQgygl.Active:=false;
    ADOQgygl.SQL.Clear;
    ADOQgygl.SQL.add(eee);
    ADOQgygl.Parameters[0].Value:=DatetimeF.Date;
    ADOQgygl.Parameters[1].Value:=DatetimeT.Date;
    ADOQgygl.Active:=true;
    try
      ADOTgygl.Locate('gybh',ADOQgygl.Lookup('gybh',Form1.DBEgyglCXDW.Text,'gybh'),[]);
    except
    end;
   end;
end;

procedure TgyglRQgy.FormClose(Sender: TObject; var Action: TCloseAction);
begin
form1.RGgygl.ItemIndex:=0;
end;

end.