xsj_ch.pas

药店GSP源码

unit xsj_ch;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, FR_DSet, FR_DBSet, FR_Class, DB, DBTables, Grids, DBGrids,
  StdCtrls, ComCtrls, Buttons;

type
  TForm17 = class(TForm)
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    dtp1: TDateTimePicker;
    dtp2: TDateTimePicker;
    Label1: TLabel;
    Label2: TLabel;
    DBGrid1: TDBGrid;
    Database1: TDatabase;
    Query1: TQuery;
    DataSource1: TDataSource;
    Query1NAME: TStringField;
    Query1SHU: TIntegerField;
    Query1BASICUNIT: TStringField;
    Query1SALEPRICE: TFloatField;
    Query1INPRICE: TFloatField;
    Query1SUM_XS: TFloatField;
    Query1GUIGE: TStringField;
    BitBtn3: TBitBtn;
    frReport1: TfrReport;
    frDBDataSet1: TfrDBDataSet;
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form17: TForm17;

implementation

{$R *.dfm}

procedure TForm17.BitBtn1Click(Sender: TObject);
var
d1:string;
d2:string;
begin
 d1:=datetostr(dtp1.Date);
 d2:=datetostr(dtp2.Date);
 query1.Close;
 query1.SQL.Clear;
 query1.SQL.Add('select * from sale1');
 query1.SQL.Add('where date>=#'+d1+'#');
 query1.SQL.Add('and date<=#'+d2+'#');
 query1.Open;

end;

procedure TForm17.BitBtn2Click(Sender: TObject);
begin
database1.Close;
form17.Close;
end;

procedure TForm17.BitBtn3Click(Sender: TObject);
begin
frreport1.LoadFromFile('D:\药品进销存\report\xsj_ch.frf');
frreport1.ShowReport;
end;

end.