cai_jia_print.~pas

采购管理系统：delphi+sql实现了企业采购自动化作业流程

unit cai_jia_print;

interface

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

type
  Tcai_jia_prin = class(TForm)
    Label1: TLabel;
    Label2: TLabel;
    Button1: TButton;
    Button3: TButton;
    Label3: TLabel;
    t1: TMaskEdit;
    t2: TMaskEdit;
    Button2: TButton;
    procedure Button3Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure t1KeyPress(Sender: TObject; var Key: Char);
    procedure t2KeyPress(Sender: TObject; var Key: Char);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  cai_jia_prin: Tcai_jia_prin;

implementation
uses cai_jia_biao,excel;
{$R *.dfm}

procedure Tcai_jia_prin.Button3Click(Sender: TObject);
begin
close;
end;

procedure Tcai_jia_prin.FormClose(Sender: TObject; var Action: TCloseAction);
begin
action:=cafree;
end;

procedure Tcai_jia_prin.Button1Click(Sender: TObject);
var cai_jia_bia:Tcai_jia_bia;
begin
cai_jia_bia:=Tcai_jia_bia.Create(self);
cai_jia_bia.StoredProc1.Active:=false;
cai_jia_bia.StoredProc1.ParamByName('@str1').AsDateTime:=strtodate(t1.Text);
cai_jia_bia.StoredProc1.ParamByName('@str2').AsDateTime:=strtodate(t2.Text);
cai_jia_bia.StoredProc1.Prepare;
cai_jia_bia.StoredProc1.Active:=true;
cai_jia_bia.QRLabel3.Caption:=label3.Caption;
cai_jia_bia.QRLabel18.Caption:=t1.Text;
cai_jia_bia.QRLabel19.Caption:=t2.Text;

cai_jia_bia.QuickRep1.Preview;
cai_jia_bia.Release;
end;

procedure Tcai_jia_prin.FormCreate(Sender: TObject);
begin
label3.Visible:=false;
t1.Text:=datetostr(date);
t2.Text:=datetostr(date);
end;

procedure Tcai_jia_prin.t1KeyPress(Sender: TObject; var Key: Char);
begin
if key=chr(13) then
t2.SetFocus;
end;

procedure Tcai_jia_prin.t2KeyPress(Sender: TObject; var Key: Char);
begin
if key=chr(13) then
button1.SetFocus;
end;

procedure Tcai_jia_prin.Button2Click(Sender: TObject);
var exce:Texce;
begin
exce:=Texce.Create(self);
exce.Query1.Active:=false;
exce.Query1.SQL.Clear;
exce.Query1.SQL.Add('select  A.chang_shang_no,A.chang_shang_name,  A.ding_gou_date ,A.fo_bi_kind ,B.ding_shu_liang,  B.wu_no, B.wu_name,B.wu_gui,  B.dan_wei ,B.ding_dan_jia ,B.ren_ming_bi  from ding_gou_zhu A inner join  ding_gou_chong  B  on A.ding_gou_no=B.ding_gou_no ');

exce.Query1.SQL.Add('where (A.ding_gou_date >=@str1)and (A.ding_gou_date<=@str2) and (A.yes_or_no=:mm) and (B.ding_dan_jia >=:nn) order by A.ding_gou_date');
exce.Query1.ParamByName('mm').AsString:='琌';
exce.Query1.ParamByName('nn').AsFloat:=0;
exce.Query1.Prepare;
exce.Query1.Active:=true;
exce.sjbname:='蹦潦刹