jh_ch.pas

药店GSP源码

unit jh_ch;

interface

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

type
  TForm18 = class(TForm)
    GroupBox1: TGroupBox;
    DBGrid1: TDBGrid;
    CheckBox1: TCheckBox;
    dtp1: TDateTimePicker;
    Label1: TLabel;
    CheckBox2: TCheckBox;
    dtp2: TDateTimePicker;
    Label2: TLabel;
    Label3: TLabel;
    Edit1: TEdit;
    Button1: TButton;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    DataSource1: TDataSource;
    Database1: TDatabase;
    Query1: TQuery;
    Query1JIN_DATE: TDateTimeField;
    Query1NAME: TStringField;
    Query1BASICUNIT: TStringField;
    Query1GUIGE: TStringField;
    Query1JX: TStringField;
    Query1SHU: TIntegerField;
    Query1SALEPRICE: TFloatField;
    Query1INPRICE: TFloatField;
    Query1SUM_IN: TFloatField;
    Query1PLACE: TStringField;
    Query1LOTNO: TStringField;
    Query1PZNO: TStringField;
    Query1GYS: TStringField;
    Query1YX_DATE: TDateTimeField;
    frReport1: TfrReport;
    frDBDataSet1: TfrDBDataSet;
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form18: TForm18;

implementation
   uses ypqd;
{$R *.dfm}

procedure TForm18.BitBtn3Click(Sender: TObject);
begin
database1.Close;
 form18.Close;
end;

procedure TForm18.BitBtn1Click(Sender: TObject);
var
 dt1:string;
 dt2:string;
begin
 dt1:=datetostr(dtp1.Date);
 dt2:=datetostr(dtp2.Date);
 query1.Close;
 if (checkbox1.Checked=true) and (checkbox2.Checked=false) then
  begin
   query1.SQL.Clear;
   query1.RequestLive:=false;
   query1.SQL.Add('select * from jhdj');
   query1.SQL.Add('where jin_date>=#'+dt1+'#');
   query1.SQL.Add('and jin_date<=#'+dt2+'#');
   query1.Open;
  end;
 if (checkbox2.Checked=true) and (checkbox1.Checked=false) then
  begin
   query1.SQL.Clear;
   query1.RequestLive:=true;
   query1.SQL.Add('select * from jhdj');
   query1.SQL.Add('where name="'+edit1.Text+'"');
   query1.Open;
  end;
 if (checkbox1.Checked=true) and (checkbox2.Checked=True) then
  begin
   query1.SQL.Clear;
   query1.RequestLive:=true;
   query1.SQL.Add('select * from jhdj');
   query1.SQL.Add('where jin_date>=#'+dt1+'#');
   query1.SQL.Add('and jin_date<=#'+dt2+'#');
   query1.SQL.Add('and name="'+edit1.Text+'"');
   query1.Open;

  end;
end;

procedure TForm18.BitBtn2Click(Sender: TObject);
begin
frreport1.LoadFromFile('D:\药品进销存\report\jh_ch.frf');
frreport1.ShowReport;
end;

procedure TForm18.Button1Click(Sender: TObject);
begin
 form4.Query1.Close;
 Form4.Query1.SQL.Clear;
 Form4.Query1.SQL.Add('select * from base');
 Form4.Query1.SQL.Add('where pingyingcode like "'+edit1.Text+'%"');
 Form4.Query1.Open;
 form4.Show;
end;

end.