fee_list_r.pas

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

unit Fee_List_R;

interface

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

type
  TR_Fee_List = class(TQuickRep)
    DetailBand1: TQRBand;
    QRDBText1: TQRDBText;
    ColumnHeaderBand1: TQRBand;
    QRLabel1: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel6: TQRLabel;
    QRLabel7: TQRLabel;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRShape1: TQRShape;
    QRShape7: TQRShape;
    QRShape8: TQRShape;
    QRShape10: TQRShape;
    QRShape11: TQRShape;
    QRLabel16: TQRLabel;
    QRShape13: TQRShape;
    QRShape14: TQRShape;
    QRShape15: TQRShape;
    QRShape17: TQRShape;
    QRShape18: TQRShape;
    QRShape22: TQRShape;
    PageHeaderBand1: TQRBand;
    QRL_Month: TQRLabel;
    QRL_Title: TQRLabel;
    SummaryBand1: TQRBand;
    QRShape24: TQRShape;
    QRShape29: TQRShape;
    QRLabel25: TQRLabel;
    QRExpr1: TQRExpr;
    QRExpr2: TQRExpr;
    PageFooterBand1: TQRBand;
    QRLabel17: TQRLabel;
    QRLabel26: TQRLabel;
    QRShape9: TQRShape;
    QRLabel14: TQRLabel;
    QRShape16: TQRShape;
    QRLabel27: TQRLabel;
    QRLabel28: TQRLabel;
    QRDBText7: TQRDBText;
    QRShape30: TQRShape;
    QRShape31: TQRShape;
    QRDBText10: TQRDBText;
    QRL_Price1: TQRLabel;
    QRL_Price2: TQRLabel;
    QRShape33: TQRShape;
    QRLabel31: TQRLabel;
    QRShape34: TQRShape;
    QRDBText8: TQRDBText;
    QRShape32: TQRShape;
    QRLabel34: TQRLabel;
    QRShape35: TQRShape;
    QRLabel35: TQRLabel;
    QRShape36: TQRShape;
    QRShape37: TQRShape;
    QRShape38: TQRShape;
    QRLabel2: TQRLabel;
    QRShape39: TQRShape;
    QRLabel15: TQRLabel;
    QRShape40: TQRShape;
    QRShape41: TQRShape;
    QRShape42: TQRShape;
    QRShape43: TQRShape;
    QRLabel23: TQRLabel;
    QRSD_Page: TQRSysData;
    QRLabel24: TQRLabel;
    QRLabel22: TQRLabel;
    QRSysData3: TQRSysData;
    QRLabel21: TQRLabel;
    QRLabel18: TQRLabel;
    QRLabel19: TQRLabel;
    QRL_Auditing: TQRLabel;
    QRLabel20: TQRLabel;
    QRShape44: TQRShape;
    QRL_Address: TQRLabel;
    QRLabel5: TQRLabel;
    QRL_Use: TQRLabel;
    QRL_Order: TQRLabel;
    QRLabel33: TQRLabel;
    QRLabel36: TQRLabel;
    QRLabel37: TQRLabel;
    QRLabel32: TQRLabel;
    QRLabel38: TQRLabel;
    QRLabel39: TQRLabel;
    QRLabel30: TQRLabel;
    QRLabel40: TQRLabel;
    QRLabel41: TQRLabel;
    QRLabel42: TQRLabel;
    QRSysData1: TQRSysData;
    QRLabel29: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel9: TQRLabel;
    QRShape4: TQRShape;
    QRLabel10: TQRLabel;
    QRLabel43: TQRLabel;
    QRShape5: TQRShape;
    QRDBText9: TQRDBText;
    QRShape2: TQRShape;
    QRL_Price3: TQRLabel;
    QRShape3: TQRShape;
    QRLabel11: TQRLabel;
    QRLabel12: TQRLabel;
    QRDB_LateFee: TQRDBText;
    QRShape12: TQRShape;
    QRLabel13: TQRLabel;
    QRLabel44: TQRLabel;
    QRShape6: TQRShape;
    QRDBText11: TQRDBText;
    QRShape19: TQRShape;
    QRLabel45: TQRLabel;
    QRLabel46: TQRLabel;
    QRL_Cooks: TQRLabel;
    procedure PageHeaderBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure DetailBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure PageFooterBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure DetailBand1AfterPrint(Sender: TQRCustomBand;
      BandPrinted: Boolean);
    procedure QRDBCount(sender: TObject; var Value: String);
    procedure QRDBMoney(sender: TObject; var Value: String);
    procedure R_Fee_ListAfterPrint(Sender: TObject);
    procedure QuickRepBeforePrint(Sender: TCustomQuickRep;
      var PrintReport: Boolean);
    procedure SummaryBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
  private
  	Cooks: Integer;
  public

  end;

var
  R_Fee_List: TR_Fee_List;

implementation

uses Table_DM, CommSmdljf, Comm;

{$R *.DFM}



































procedure TR_Fee_List.PageHeaderBand1BeforePrint(Sender: TQRCustomBand;
  var PrintBand: Boolean);
begin
	QRL_Title.Caption := CorpName+StationName+' 电量、电费明细对帐表(公布)';
    QRL_Month.Caption := CurrentYear+' 年 '+CurrentMonth+' 月份';
    QRL_Address.Caption := F_GetAddress(Dm_Table.V_House['F_House_No']);
end;










procedure TR_Fee_List.DetailBand1BeforePrint(Sender: TQRCustomBand;
  var PrintBand: Boolean);
begin
    QRL_Price1.Caption := F_FLoatToStrF(Dm_Table.V_House['F_Price1'],4,3);
    QRL_Price2.Caption := F_FLoatToStrF(Dm_Table.V_House['F_Price2'],4,3);
    If DM_Table.V_House['f_Count3'] <> 0 Then
    Begin
        QRL_Price3.Caption := F_FLoatToStrF(Dm_Table.V_House['F_Price3'],4,3);
        Cooks := Cooks + 1;//电炊户
    End
    Else
        QRL_Price3.Caption := '';
end;



















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

procedure TR_Fee_List.DetailBand1AfterPrint(Sender: TQRCustomBand;
  BandPrinted: Boolean);
begin
	QRL_Order.Caption := IntToStr(StrToInt(QRL_Order.Caption) + 1);
end;

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

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


procedure TR_Fee_List.R_Fee_ListAfterPrint(Sender: TObject);
begin
	P_CalcTransferCooks(DM_Table.Tb_Transfer['F_Transfer_No']);
    P_Log('打印: 农电三-2表');
end;





procedure TR_Fee_List.QuickRepBeforePrint(Sender: TCustomQuickRep;
  var PrintReport: Boolean);
begin
	QRL_Order.Caption := '1';
    Cooks := 0;//电炊户
end;

procedure TR_Fee_List.SummaryBand1BeforePrint(Sender: TQRCustomBand;
  var PrintBand: Boolean);
begin
	QRL_Cooks.Caption := IntToStr(Cooks);
end;

End.