xs_ch.pas

药店GSP源码

unit xs_ch;

interface

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

type
  TForm13 = class(TForm)
    GroupBox1: TGroupBox;
    DT1: TDateTimePicker;
    Label1: TLabel;
    Label2: TLabel;
    DT2: TDateTimePicker;
    DBGrid1: TDBGrid;
    DS1: TDataSource;
    Database1: TDatabase;
    Query1: TQuery;
    Query1ID: TIntegerField;
    Query1DATE: TDateTimeField;
    Query1NAME: TStringField;
    Query1SHU: TIntegerField;
    Query1BASICUNIT: TStringField;
    Query1SALEPRICE: TFloatField;
    Query1INPRICE: TFloatField;
    Query1KEHU: TStringField;
    Query1SUM_XS: TFloatField;
    Query1GUIGE: TStringField;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    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
  Form13: TForm13;

implementation

{$R *.dfm}

procedure TForm13.BitBtn1Click(Sender: TObject);
var
d1:string;
d2:string;
begin
d1:=datetostr(dt1.Date);
d2:=datetostr(dt2.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 TForm13.BitBtn2Click(Sender: TObject);
begin
query1.Close;
form13.Close;
end;

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

end.