passqpfrm.pas

基于Interbase的图书管理系统

unit passqpfrm;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ChildFrm, QRCtrls, QuickRpt, ExtCtrls, Buttons, StdCtrls,QRPrntr,
  Menus;

type
  TpassQPForm = class(TChildForm)
    Panel1: TPanel;
    Splitter1: TSplitter;
    pnlpreview: TPanel;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    Image1: TImage;
    Label1: TLabel;
    QRclosetime: TQuickRep;
    DetailBand1: TQRBand;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRLabel6: TQRLabel;
    QRDBText5: TQRDBText;
    QRLabel7: TQRLabel;
    QRDBText6: TQRDBText;
    QRLabel8: TQRLabel;
    QRDBText7: TQRDBText;
    QRLabel9: TQRLabel;
    QRDBText8: TQRDBText;
    QRLabel10: TQRLabel;
    QRDBText9: TQRDBText;
    QRLabel11: TQRLabel;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText12: TQRDBText;
    QRLabel14: TQRLabel;
    QRDBText13: TQRDBText;
    QRShape1: TQRShape;
    QRLabel1: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRLabel12: TQRLabel;
    QRLabel13: TQRLabel;
    QRLabel2: TQRLabel;
    QRShape2: TQRShape;
    QRLabel15: TQRLabel;
    QRDBText14: TQRDBText;
    QRLabel16: TQRLabel;
    QRShape3: TQRShape;
    QRShape4: TQRShape;
    QRbooklose: TQuickRep;
    PageFooterBand1: TQRBand;
    PageHeaderBand1: TQRBand;
    DetailBand2: TQRBand;
    ColumnHeaderBand1: TQRBand;
    QRLabel17: TQRLabel;
    QRShape5: TQRShape;
    QRShape6: TQRShape;
    QRShape7: TQRShape;
    QRShape8: TQRShape;
    QRShape9: TQRShape;
    QRShape10: TQRShape;
    QRShape11: TQRShape;
    QRShape12: TQRShape;
    QRLabel18: TQRLabel;
    QRLabel19: TQRLabel;
    QRLabel20: TQRLabel;
    QRLabel21: TQRLabel;
    QRLabel22: TQRLabel;
    QRLabel23: TQRLabel;
    QRLabel24: TQRLabel;
    QRDBText15: TQRDBText;
    QRDBText16: TQRDBText;
    QRDBText17: TQRDBText;
    QRDBText18: TQRDBText;
    QRDBText19: TQRDBText;
    QRDBText20: TQRDBText;
    QRDBText21: TQRDBText;
    QRSysData1: TQRSysData;
    QRSysData2: TQRSysData;
    QRbookrepair: TQuickRep;
    QRBand1: TQRBand;
    QRShape13: TQRShape;
    QRShape14: TQRShape;
    QRShape15: TQRShape;
    QRShape16: TQRShape;
    QRLabel25: TQRLabel;
    QRLabel26: TQRLabel;
    QRLabel27: TQRLabel;
    QRLabel28: TQRLabel;
    QRLabel29: TQRLabel;
    QRLabel30: TQRLabel;
    QRLabel31: TQRLabel;
    QRBand2: TQRBand;
    QRShape17: TQRShape;
    QRShape18: TQRShape;
    QRShape19: TQRShape;
    QRShape20: TQRShape;
    QRDBText22: TQRDBText;
    QRDBText23: TQRDBText;
    QRDBText24: TQRDBText;
    QRDBText25: TQRDBText;
    QRDBText26: TQRDBText;
    QRDBText27: TQRDBText;
    QRDBText28: TQRDBText;
    QRBand3: TQRBand;
    QRLabel32: TQRLabel;
    QRSysData3: TQRSysData;
    QRShape21: TQRShape;
    QRShape22: TQRShape;
    QRLabel33: TQRLabel;
    QRDBText29: TQRDBText;
    QRBand4: TQRBand;
    QRSysData4: TQRSysData;
    procedure FormDestroy(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
    procedure QRDBText5Print(sender: TObject; var Value: String);
    procedure QRDBText6Print(sender: TObject; var Value: String);
    procedure QRDBText12Print(sender: TObject; var Value: String);
    procedure QRclosetimePreview(Sender: TObject);
    procedure QRDBText2Print(sender: TObject; var Value: String);
    procedure QRDBText3Print(sender: TObject; var Value: String);
    procedure QRDBText4Print(sender: TObject; var Value: String);
    procedure DetailBand2BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure QRSysData1Print(sender: TObject; var Value: String);
    procedure QRSysData2Print(sender: TObject; var Value: String);
    procedure QRBand2BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure QRSysData3Print(sender: TObject; var Value: String);
    procedure QRDBText29Print(sender: TObject; var Value: String);
 private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  passQPForm: TpassQPForm;

implementation
uses dmfrm, qrpassfrm;
{$R *.dfm}

procedure TpassQPForm.FormDestroy(Sender: TObject);
begin
  inherited;
 passQPForm:=nil;
end;

procedure TpassQPForm.FormShow(Sender: TObject);
begin
  inherited;
dmbook.closebook;
dmbook.closereader;
dmbook.closeClosetime;
dmbook.closeBooklose; 
dmbook.openbook;
//dmbook.openbooktypedb;
dmbook.openClosetime;
dmbook.openreader;
dmbook.openBooklose;
end;

procedure TpassQPForm.BitBtn1Click(Sender: TObject);
begin
  inherited;
qrpassform.QRPreview.QRPrinter:=nil;
qrpassform.ToolBar1.Enabled:=false;
qrpassform.firstNavbutton;
if qrpassform.ToolBar1.Enabled=false then qrpassform.ToolBar1.Enabled:=true;
   QRclosetime.Preview;
end;

procedure TpassQPForm.BitBtn2Click(Sender: TObject);
begin
  inherited;
qrpassform.QRPreview.QRPrinter:=nil;
qrpassform.ToolBar1.Enabled:=false;
qrpassform.firstNavbutton;
if qrpassform.ToolBar1.Enabled=false then qrpassform.ToolBar1.Enabled:=true;
   QRbooklose.Preview;
end;

procedure TpassQPForm.FormCreate(Sender: TObject);
begin
  inherited;
  if not assigned(qrpassform) then
  qrpassform:=Tqrpassform.Create(self,pnlpreview);
  qrpassform.Show;
  QRbooklose.Visible:=false;
  QRclosetime.Visible:=false;
  QRbookrepair.Visible:=false;
end;

procedure TpassQPForm.BitBtn3Click(Sender: TObject);
begin
  inherited;
qrpassform.QRPreview.QRPrinter:=nil;
qrpassform.ToolBar1.Enabled:=false;
qrpassform.firstNavbutton;
if qrpassform.ToolBar1.Enabled=false then qrpassform.ToolBar1.Enabled:=true;
 QRbookrepair.Preview;
end;

procedure TpassQPForm.FormCloseQuery(Sender: TObject;
  var CanClose: Boolean);
begin
  inherited;
qrpassform.free;
qrpassform:=nil;
CanClose:=true;
end;

procedure TpassQPForm.QRDBText5Print(sender: TObject; var Value: String);
begin
  inherited;
if Value=Emptystr then Value:='无'
else Value:=FormatDateTime('yyyy.mm.dd',StrToDateTime(Value));
end;

procedure TpassQPForm.QRDBText6Print(sender: TObject; var Value: String);
begin
  inherited;
if Value=Emptystr then Value:='无'
else Value:=Value+'天';
end;

procedure TpassQPForm.QRDBText12Print(sender: TObject; var Value: String);
begin
  inherited;
dmbook.Qrybook.First;
if dmbook.Qrybook.Locate('book_id',Value,[]) then
    begin
      Value:=dmbook.Qrybook['book_name'];
      Value:='《'+Value+'》';
    end
      else Value:=Emptystr;
end;

procedure TpassQPForm.QRclosetimePreview(Sender: TObject);
begin
  inherited;
qrpassform.QRPreview.QRPrinter:=TQRPrinter(sender);
end;

procedure TpassQPForm.QRDBText2Print(sender: TObject; var Value: String);
begin
  inherited;
dmbook.Qryreader.First;
if dmbook.Qryreader.Locate('reader_id',Value,[]) then
      Value:=dmbook.Qryreader['reader_no']
      else Value:=Emptystr;
end;

procedure TpassQPForm.QRDBText3Print(sender: TObject; var Value: String);
begin
  inherited;
dmbook.Qryreader.First;
if dmbook.Qryreader.Locate('reader_id',Value,[]) then
      Value:=dmbook.Qryreader['reader_name']
      else Value:=Emptystr;
end;

procedure TpassQPForm.QRDBText4Print(sender: TObject; var Value: String);
begin
  inherited;
dmbook.Qryreader.First;
if dmbook.Qryreader.Locate('reader_id',Value,[]) then
      Value:=dmbook.Qryreader['reader_dept']
      else Value:=Emptystr;
end;

procedure TpassQPForm.DetailBand2BeforePrint(Sender: TQRCustomBand;
  var PrintBand: Boolean);
begin
  inherited;
if dmbook.Qrybooklose['book_lose']=1 then PrintBand:=true
else PrintBand:=false;
end;

procedure TpassQPForm.QRSysData1Print(sender: TObject; var Value: String);
begin
  inherited;
Value:='第 '+Value+' 页';
end;

procedure TpassQPForm.QRSysData2Print(sender: TObject; var Value: String);
begin
  inherited;
Value:='赐昱图书室 '+Value;
end;

procedure TpassQPForm.QRBand2BeforePrint(Sender: TQRCustomBand;
  var PrintBand: Boolean);
begin
  inherited;
if dmbook.Qrybooklose['book_lose']=0 then PrintBand:=true
else PrintBand:=false;
end;

procedure TpassQPForm.QRSysData3Print(sender: TObject; var Value: String);
begin
  inherited;
Value:='第 '+Value+' 页';
end;

procedure TpassQPForm.QRDBText29Print(sender: TObject; var Value: String);
begin
  inherited;
delete(Value,length(Value)-1,2);
Value:=Value+'。';
end;

end.