fee_list_new_r.pas

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

unit Fee_List_New_R;

interface

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

type
  TR_Fee_List_New = class(TQuickRep)
    SummaryBand1: TQRBand;
    DetailBand1: TQRBand;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText15: TQRDBText;
    QRDBText23: TQRDBText;
    QRDBText24: TQRDBText;
    QRDBText26: TQRDBText;
    QRShape9: TQRShape;
    QRShape35: TQRShape;
    QRShape39: TQRShape;
    QRShape42: TQRShape;
    QRShape44: TQRShape;
    QRShape46: TQRShape;
    QRShape52: TQRShape;
    QRShape54: TQRShape;
    QRShape55: TQRShape;
    QRShape58: TQRShape;
    PageHeaderBand1: TQRBand;
    QRLabel34: TQRLabel;
    QRL_Title: TQRLabel;
    PageFooterBand1: TQRBand;
    QRLabel37: TQRLabel;
    QRLabel38: TQRLabel;
    QRL_Auditing: TQRLabel;
    QRLabel1: TQRLabel;
    QRSysData1: TQRSysData;
    QRLabel25: TQRLabel;
    QRLabel26: TQRLabel;
    QRLabel36: TQRLabel;
    QRSysData2: TQRSysData;
    QRL_Use: TQRLabel;
    QRL_Month: TQRLabel;
    QRShape32: TQRShape;
    QRLabel49: TQRLabel;
    QRSysData4: TQRSysData;
    QRLabel50: TQRLabel;
    QRDBCount: TQRDBText;
    QRExpr5: TQRExpr;
    QRExpr9: TQRExpr;
    QRExpr13: TQRExpr;
    QRExpr17: TQRExpr;
    QRExpr21: TQRExpr;
    QRExpr22: TQRExpr;
    QRShape34: TQRShape;
    QRShape48: TQRShape;
    QRShape49: TQRShape;
    QRShape59: TQRShape;
    QRShape62: TQRShape;
    QRShape63: TQRShape;
    QRShape64: TQRShape;
    QRShape65: TQRShape;
    QRShape69: TQRShape;
    QRShape73: TQRShape;
    QRShape77: TQRShape;
    QRShape78: TQRShape;
    QRLabel35: TQRLabel;
    QRExpr26: TQRExpr;
    QRDBText5: TQRDBText;
    QRShape26: TQRShape;
    QRExpr24: TQRExpr;
    QRShape28: TQRShape;
    QRShape4: TQRShape;
    QRShape6: TQRShape;
    QRDBText3: TQRDBText;
    QRShape8: TQRShape;
    QRShape12: TQRShape;
    QRShape14: TQRShape;
    QRSysData3: TQRSysData;
    QRLabel40: TQRLabel;
    QRL_Cooks: TQRLabel;
    QRExpr6: TQRExpr;
    QRShape15: TQRShape;
    QRShape19: TQRShape;
    QRLabel23: TQRLabel;
    QRLabel27: TQRLabel;
    QRL_Price: TQRLabel;
    QRShape25: TQRShape;
    QRShape30: TQRShape;
    QRShape29: TQRShape;
    QRShape57: TQRShape;
    QRShape56: TQRShape;
    QRShape18: TQRShape;
    QRShape1: TQRShape;
    QRLabel2: TQRLabel;
    QRLabel3: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel5: TQRLabel;
    QRShape10: TQRShape;
    QRLabel9: TQRLabel;
    QRLabel10: TQRLabel;
    QRLabel14: TQRLabel;
    QRLabel15: TQRLabel;
    QRShape20: TQRShape;
    QRLabel19: TQRLabel;
    QRLabel20: TQRLabel;
    QRLabel31: TQRLabel;
    QRLabel32: TQRLabel;
    QRLabel24: TQRLabel;
    QRShape2: TQRShape;
    QRShape3: TQRShape;
    QRLabel6: TQRLabel;
    QRShape5: TQRShape;
    QRShape7: TQRShape;
    QRLabel7: TQRLabel;
    QRLabel8: TQRLabel;
    QRLabel12: TQRLabel;
    QRLabel21: TQRLabel;
    QRShape13: TQRShape;
    QRShape16: TQRShape;
    QRLabel22: TQRLabel;
    QRLabel29: TQRLabel;
    QRLabel16: TQRLabel;
    QRShape31: TQRShape;
    QRLabel17: TQRLabel;
    QRLabel18: TQRLabel;
    QRShape11: TQRShape;
    QRLabel13: TQRLabel;
    QRSysData5: TQRSysData;
    QRDBText4: TQRDBText;
    QRLabel28: TQRLabel;
    QRLabel33: TQRLabel;
    QRDBText6: TQRDBText;
    QRExpr1: TQRExpr;
    QRDBText8: TQRDBText;
    QRLabel11: TQRLabel;
    QRLabel30: TQRLabel;
    QRExpr2: TQRExpr;
    QRDBText9: TQRDBText;
    QRExpr3: TQRExpr;
    QRLabel39: TQRLabel;
    procedure PageFooterBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure PageHeaderBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure QRDBCountPrint(sender: TObject; var Value: String);
    procedure QRDBMoneyPrint(sender: TObject; var Value: String);
    procedure R_Fee_Single_ListAfterPrint(Sender: TObject);
    procedure DetailBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure SummaryBand1BeforePrint(Sender: TQRCustomBand;
      var PrintBand: Boolean);
    procedure QuickRepBeforePrint(Sender: TCustomQuickRep;
      var PrintReport: Boolean);
    procedure QuickRepAfterPrint(Sender: TObject);
  private
    Cooks: Integer;
  public

  end;

var
  R_Fee_List_New: TR_Fee_List_New;

implementation

uses Table_DM, CommSmdljf, Comm;

{$R *.DFM}
































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


procedure TR_Fee_List_New.PageHeaderBand1BeforePrint(
  Sender: TQRCustomBand; var PrintBand: Boolean);
var
    Str:String;
begin
    QRL_Month.Caption := CurrentYear+' 年 ' + CurrentMonth + ' 月份';
    QRL_Title.Caption := CorpName + StationName
    					+ Dm_Table.Tb_Transfer['F_Transfer_Name']
                        + '电量、电费明细表';
    Str := '现行电价: ';
    With DM_Table Do
    Begin
        Tb_Elect.Open();
        Tb_Elect.First();
        While Not Tb_Elect.Eof Do
        Begin
            Str := Str + Tb_Elect['f_Elect_Name'] + ' ' + FloatToStr(Tb_Elect['f_Price']) + ' 元/kw.h   ';
            Tb_Elect.Next();
        End
    End;
    QRL_Price.Caption := Str;
end;












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















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

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

procedure TR_Fee_List_New.DetailBand1BeforePrint(Sender: TQRCustomBand;
  var PrintBand: Boolean);
begin
    If DM_Table.V_Fee['f_Count3'] <> 0 Then
        Cooks := Cooks + 1;//电炊户
end;

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

procedure TR_Fee_List_New.QuickRepBeforePrint(Sender: TCustomQuickRep;
  var PrintReport: Boolean);
begin
    Cooks := 0;//电炊户
end;

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

end.