gl_enter_credence_p.pas

一个MRPII系统源代码版本

unit Gl_Enter_Credence_P;

Interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Base, ExtCtrls, QuickRpt, QrCtrls, Db, AdODB,Qrprntr;

Type
  TFrm_Gl_Enter_Credence_P = Class(TFrm_Base)
    QR_Credence: TQuickRep;
    ColumnHeaderBand1: TQRBand;
    DetailBand: TQRBand;
    PageFooterBand1: TQRBand;
    SummAryBand1: TQRBand;
    QrLbl_Company: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    Qlbl_Page: TQRLabel;
    QLbl_Date: TQRLabel;
    QLbl_CredenceNo: TQRLabel;
    QLbl_BorrowCount: TQRLabel;
    QRLabel8: TQRLabel;
    QLbl_MBEmp: TQRLabel;
    QRLabel9: TQRLabel;
    QLbl_CredItemp: TQRLabel;
    QRLabel10: TQRLabel;
    QLbl_PayEmp: TQRLabel;
    QRLabel11: TQRLabel;
    QLbl_tallyEmp: TQRLabel;
    QRShApe2: TQRShApe;
    QRShApe1: TQRShApe;
    QRLabel1: TQRLabel;
    QRShApe3: TQRShApe;
    QRLabel12: TQRLabel;
    QRLabel13: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRShApe4: TQRShApe;
    QRShApe5: TQRShApe;
    QRShApe6: TQRShApe;
    QRShApe8: TQRShApe;
    QRShApe10: TQRShApe;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    AdoQry_Tmp: TAdoQuery;
    QRShApe12: TQRShApe;
    QRShApe13: TQRShApe;
    QRShApe9: TQRShApe;
    QRShApe14: TQRShApe;
    QLbl_PageBorrowCount: TQRLabel;
    QS_Line3: TQRShApe;
    QLbl_PageLenderCount: TQRLabel;
    QLbl_LenderCount: TQRLabel;
    QRShApe16: TQRShApe;
    QRLabel18: TQRLabel;
    QS_Line2: TQRShApe;
    QRLbl_ThisPage: TQRLabel;
    QS_Line1: TQRShApe;
    QRLabel2: TQRLabel;
    QRLabel5: TQRLabel;
    QLbl_Bill: TQRLabel;
    procedure Qlbl_PagePrint(sender: TObject; var Value: String);
    procedure QR_CredenceStArtPage(Sender: TCustomQuickRep);
    procedure QLbl_PageBorrowCountPrint(sender: TObject;
      var Value: String);
    procedure QRDBText3Print(sender: TObject; var Value: String);
    procedure QLbl_PageLenderCountPrint(sender: TObject;
      var Value: String);
    procedure DetailBandAfterPrint(Sender: TQRCustomBand;
      BandPrinted: Boolean);
    procedure PageFooterBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
  private
     PageborrowCount,PageLenderCount:Double;
  public
    PageCount:Integer;
  end;

var
  Frm_Gl_Enter_Credence_P: TFrm_Gl_Enter_Credence_P;

implementation


{$R *.DFM}

procedure TFrm_Gl_Enter_Credence_P.Qlbl_PagePrint(sender: TObject;
  var Value: String);
begin
  inherited;
  Value:='ҳ:'+IntToStr(QR_Credence.QRPrinter.PageNumber)+'/'+IntToStr(PageCount);
end;

procedure TFrm_Gl_Enter_Credence_P.QR_CredenceStArtPage(
  Sender: TCustomQuickRep);
begin
  inherited;
  PageborrowCount:=0;
  PageLenderCount:=0;
end;

procedure TFrm_Gl_Enter_Credence_P.QLbl_PageBorrowCountPrint(
  sender: TObject; var Value: String);
begin
  inherited;
  Value:=FormatFloat('#,##0.##',PageborrowCount);
end;

procedure TFrm_Gl_Enter_Credence_P.QRDBText3Print(sender: TObject;
  var Value: String);
begin
  inherited;
//  Value:=FormatFloat('#,##0.##',StrToFloat(Value));
end;

procedure TFrm_Gl_Enter_Credence_P.QLbl_PageLenderCountPrint(
  sender: TObject; var Value: String);
begin
  inherited;
  Value:=FormatFloat('#,##0.##',PageLenderCount);
end;

procedure TFrm_Gl_Enter_Credence_P.DetailBandAfterPrint(
  Sender: TQRCustomBand; BandPrinted: Boolean);
begin
  inherited;
  PageborrowCount:=PageborrowCount+AdoQry_Tmp.fieldbyname('DebitAmount').AsFloat;
  PageLenderCount:=PageLenderCount+AdoQry_Tmp.fieldbyname('CreditAmount').AsFloat;
end;

procedure TFrm_Gl_Enter_Credence_P.PageFooterBand1BeforePrint(
  Sender: TQRCustomBand; var PrintBand: Boolean);
begin
  inherited;
  if QR_Credence.QRPrinter.PageNumber=PageCount Then
  begin
    QS_Line1.Enabled:=False;
    QS_Line2.Enabled:=False;
    QS_Line3.Enabled:=False;
    QRLbl_ThisPage.Enabled:=False;
    QLbl_PageBorrowCount.Enabled:=False;
    QLbl_PageLenderCount.Enabled:=False;
    QRShApe14.Enabled:=False;
{    QRLabel8.Top:=QRLabel8.Top-29;
    QLbl_MBEmp.Top:=QLbl_MBEmp.Top-29;
    QRLabel9.Top:=QRLabel9.Top-29;
    QLbl_CredItemp.Top:=QLbl_CredItemp.Top-29;
    QRLabel10.Top:=QRLabel10.Top-29;
    QLbl_PayEmp.Top:=QLbl_PayEmp.Top-29;
    QRLabel11.Top:=QRLabel11.Top-29;
    QLbl_tallyEmp.Top:=QLbl_tallyEmp.Top-29;
    }
  end
  Else
  begin
    QS_Line1.Enabled:=True;
    QS_Line2.Enabled:=True;
    QS_Line3.Enabled:=True;
    QRLbl_ThisPage.Enabled:=True;
    QLbl_PageBorrowCount.Enabled:=True;
    QLbl_PageLenderCount.Enabled:=True;
  end;
end;


{  Frm_Sys_Preview:=TFrm_Sys_Preview.Create(Self);
  Frm_Sys_Preview.QRPreview.QRPrinter:=Sender As TQRPrinter;
  Frm_Sys_Preview.ShowModal;
  Frm_Sys_Preview.Release;}

end.