transfer_wasting_r.pas

县级供电企业电费核算源码, 在客户处正常运行8年以上, Delphi 5开发,数据库为Interbase/Firebird, 深入使用Procedure和Trigger等, 对入门者具有很好的参考价值

unit Transfer_Wasting_R;

interface

uses Windows, SysUtils, Messages, Classes, Graphics, Controls,
  StdCtrls, ExtCtrls, Forms, Quickrpt, QRCtrls;

type
  TR_Transfer_Wasting = class(TQuickRep)
    ColumnHeaderBand1: TQRBand;
    DetailBand1: TQRBand;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText23: TQRDBText;
    QRDBMoney: TQRDBText;
    QRDBText26: TQRDBText;
    QRLabel31: TQRLabel;
    QRLabel32: TQRLabel;
    QRLabel33: TQRLabel;
    QRShape44: TQRShape;
    QRShape46: TQRShape;
    QRShape52: TQRShape;
    QRShape54: TQRShape;
    QRShape55: TQRShape;
    QRShape56: TQRShape;
    QRShape57: TQRShape;
    QRShape58: TQRShape;
    PageHeaderBand1: TQRBand;
    QRLabel34: TQRLabel;
    QRL_Title: TQRLabel;
    QRShape27: TQRShape;
    QRShape29: TQRShape;
    QRShape30: TQRShape;
    QRShape31: TQRShape;
    PageFooterBand1: TQRBand;
    QRLabel37: TQRLabel;
    QRLabel38: TQRLabel;
    QRLabel1: TQRLabel;
    QRSysData1: TQRSysData;
    QRLabel26: TQRLabel;
    QRLabel36: TQRLabel;
    QRSysData2: TQRSysData;
    QRL_Use: TQRLabel;
    QRShape32: TQRShape;
    QRShape34: TQRShape;
    QRLabel35: TQRLabel;
    QRL_Auditing: TQRLabel;
    QRLabel4: TQRLabel;
    QRShape1: TQRShape;
    QRLabel5: TQRLabel;
    QRShape2: TQRShape;
    QRLabel6: TQRLabel;
    QRShape3: TQRShape;
    QRLabel7: TQRLabel;
    QRShape4: TQRShape;
    QRLabel8: TQRLabel;
    QRShape5: TQRShape;
    QRShape6: TQRShape;
    QRShape7: TQRShape;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRShape11: TQRShape;
    QRDBText6: TQRDBText;
    QRLabel9: TQRLabel;
    QRShape13: TQRShape;
    QRShape14: TQRShape;
    QRExpr3: TQRExpr;
    QRShape16: TQRShape;
    QRLabel11: TQRLabel;
    QRShape17: TQRShape;
    QRDBText7: TQRDBText;
    QRBand1: TQRBand;
    QRShape18: TQRShape;
    QRShape19: TQRShape;
    QRShape20: TQRShape;
    QRLabel12: TQRLabel;
    QRSysData3: TQRSysData;
    QRLabel13: TQRLabel;
    QRExpr5: TQRExpr;
    QRShape21: TQRShape;
    QRShape22: TQRShape;
    QRExpr7: TQRExpr;
    QRExpr8: TQRExpr;
    QRShape23: TQRShape;
    QRShape24: TQRShape;
    QRShape25: TQRShape;
    QRShape26: TQRShape;
    QRExpr9: TQRExpr;
    QRExpr10: TQRExpr;
    QRExpr11: TQRExpr;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRShape28: TQRShape;
    QRLabel16: TQRLabel;
    QRExpr12: TQRExpr;
    QRShape35: TQRShape;
    QRLabel10: TQRLabel;
    QRShape8: TQRShape;
    QRDBText8: TQRDBText;
    QRShape9: TQRShape;
    QRShape10: TQRShape;
    QRExpr1: TQRExpr;
    procedure PageFooterBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure PageHeaderBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure QRDBCountPrin(sender: TObject; var Value: String);
    procedure QRExpr1Print(sender: TObject; var Value: String);
    procedure QRExpr2Print(sender: TObject; var Value: String);
    procedure QRL_WastRatePrint(sender: TObject; var Value: String);
    procedure QRDBMoneyPrint(sender: TObject; var Value: String);
    procedure QRLabel10Print(sender: TObject; var Value: String);
    procedure QRExpr21Print(sender: TObject; var Value: String);
    procedure QRExpr22Print(sender: TObject; var Value: String);
    procedure R_Transfer_WastingAfterPrint(Sender: TObject);
  private
  	V_BuyCount, V_WastCount, V_CountryAmount, V_Count: Extended;
  public

  end;

var
  R_Transfer_Wasting: TR_Transfer_Wasting;

implementation

uses Table_DM, CommSmdljf, Comm, Variants;

{$R *.DFM}
































procedure TR_Transfer_Wasting.PageFooterBand1BeforePrint(
  Sender: TQRCustomBand; var PrintBand: Boolean);
begin
	QRL_Use.Caption := Default_Use;
    QRL_Auditing.Caption := Default_Auditing;
end;


procedure TR_Transfer_Wasting.PageHeaderBand1BeforePrint(
  Sender: TQRCustomBand; var PrintBand: Boolean);
begin
    QRL_Title.Caption := CorpName + StationName
    					+ CurrentYear+'年' + CurrentMonth + '月份'
                        + '线损统计对帐表';
end;












procedure TR_Transfer_Wasting.QRDBCountPrin(sender: TObject;
  var Value: String);
begin
	Value := F_StrToStrF(Value,0,2);
end;











procedure TR_Transfer_Wasting.QRExpr1Print(sender: TObject;
  var Value: String);
begin
	V_BuyCount := StrToFloat(Value);
    If V_BuyCount = 0 Then
    Begin
    	Value := '';
        V_BuyCount := NULL;
    End;
end;

procedure TR_Transfer_Wasting.QRExpr2Print(sender: TObject;
  var Value: String);
begin
	V_WastCount := StrToFloat(Value);
end;

procedure TR_Transfer_Wasting.QRL_WastRatePrint(sender: TObject;
  var Value: String);
begin
	If v_BuyCount <> 0 Then
		Value := F_FloatToStrF(V_WastCount / V_BuyCount * 100,3,1)
    Else
    	Value := '';
end;


procedure TR_Transfer_Wasting.QRDBMoneyPrint(sender: TObject;
  var Value: String);
begin
	Value := F_StrToStrF(Value,10,2);
end;




procedure TR_Transfer_Wasting.QRLabel10Print(sender: TObject;
  var Value: String);
begin
	If V_Count <> 0 Then
		Value := F_FloatToStrF(V_CountryAmount / V_Count,4,3)
    Else
    	Value := '';
end;

procedure TR_Transfer_Wasting.QRExpr21Print(sender: TObject;
  var Value: String);
begin
    V_Count := StrToFloat(Value);
end;

procedure TR_Transfer_Wasting.QRExpr22Print(sender: TObject;
  var Value: String);
begin
    V_CountryAmount := StrToFloat(Value);
end;

procedure TR_Transfer_Wasting.R_Transfer_WastingAfterPrint(
  Sender: TObject);
begin
    P_Log('打印: 农电五表');
end;

end.