formlirunjiesuan.pas

这是一个关于药品进销存的管理软件

unit FormLirunjiesuan;

interface

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

type
  Tlirunjiesuan = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Label3: TLabel;
    GroupBox1: TGroupBox;
    Label4: TLabel;
    Label5: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Label6: TLabel;
    Edit3: TEdit;
    Button1: TButton;
    Button2: TButton;
    ADOQuery1: TADOQuery;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  lirunjiesuan: Tlirunjiesuan;

implementation

{$R *.dfm}

procedure Tlirunjiesuan.Button1Click(Sender: TObject);
var
temp1,temp2,temp3:double;
begin
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Text:='select sum(销售金额) as 销售金额 from 销售信息 where 销售日期 between d1 and d2';
adoquery1.Parameters.ParamByName('d1').Value:=datetimepicker1.DateTime;
adoquery1.Parameters.ParamByName('d2').Value:=datetimepicker2.DateTime;
adoquery1.Open;
temp1:=adoquery1.fieldbyname('销售金额').AsFloat;
adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Text:='select sum(入库金额) as 入库金额 from 入库信息  where 进货日期 between d1 and d2';
adoquery1.Parameters.ParamByName('d1').Value:=datetimepicker1.DateTime;
adoquery1.Parameters.ParamByName('d2').Value:=datetimepicker2.DateTime;
adoquery1.Open;
temp2:=adoquery1.fieldbyname('入库金额').AsFloat;
temp3:=temp1-temp2;
edit1.Text:=floattostr(temp1);
edit2.Text:=floattostr(temp2);
edit3.Text:=floattostr(temp3);
end;

end.