copyrate_f.pas

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

unit CopyRate_F;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Transfer_Frm, StdCtrls, ExtCtrls, Grids, DBGrids, Line_Frm, Mask, DBCtrls;

type
  TF_CopyRate = class(TForm)
    Panel1: TPanel;
    Bt_Close: TButton;
    Bt_Print: TButton;
    Bt_Calculate: TButton;
    TFrm_Line1: TFrm_Line;
    DBGrid1: TDBGrid;
    DBE_TransferNo: TDBEdit;
    procedure Bt_CloseClick(Sender: TObject);
    procedure Bt_CalculateClick(Sender: TObject);
    procedure Bt_PrintClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_CopyRate: TF_CopyRate;

implementation

uses Table_DM, Proc_Dm, CopyRate_R, CommSmdljf;

{$R *.DFM}

procedure TF_CopyRate.Bt_CloseClick(Sender: TObject);
begin
	Close();
end;

procedure TF_CopyRate.Bt_CalculateClick(Sender: TObject);
begin
    DM_Table.Tb_Transfer.DisableControls();

    Try
	    DM_Table.Tb_Transfer.First();
    	While Not DM_Table.Tb_Transfer.Eof Do
    	Begin
       		DM_Proc.sp_CopyRate.Params.ParamValues['v_TransferNo'] := DM_Table.Tb_Transfer['f_Transfer_No'];
        	DM_Proc.sp_CopyRate.Prepare();
        	DM_Proc.sp_CopyRate.ExecProc();
        	DM_Proc.sp_CopyRate.Unprepare();
        	DM_Table.Tb_Transfer.Next();
    	End;
    Finally
	    DM_Table.Tb_Transfer.Refresh();
    End;

	DM_Table.Tb_Transfer.EnableControls();
end;

procedure TF_CopyRate.Bt_PrintClick(Sender: TObject);
begin
	P_Print_Report(R_CopyRate);
end;

end.