linecopyrate_f.pas

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

unit LineCopyRate_F;

interface

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

type
  TF_LineCopyRate = class(TForm)
    Panel1: TPanel;
    Bt_Close: TButton;
    Bt_Print: TButton;
    Bt_Calculate: TButton;
    DBGrid1: TDBGrid;
    DBE_LineNo: 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_LineCopyRate: TF_LineCopyRate;

implementation

uses Table_DM, Proc_Dm, CopyRate_R, CommSmdljf, LineCopyRate_R;

{$R *.DFM}

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

procedure TF_LineCopyRate.Bt_CalculateClick(Sender: TObject);
begin
    DM_Table.Tb_Line.DisableControls();

    Try
	    DM_Table.Tb_Line.First();
    	While Not DM_Table.Tb_Line.Eof Do
    	Begin
       		DM_Proc.sp_LineCopyRate.Params.ParamValues['v_LineNo'] := DM_Table.Tb_Line['f_Line_No'];
        	DM_Proc.sp_LineCopyRate.Prepare();
        	DM_Proc.sp_LineCopyRate.ExecProc();
        	DM_Proc.sp_LineCopyRate.Unprepare();
        	DM_Table.Tb_Line.Next();
    	End;
    Finally
	    DM_Table.Tb_Line.Refresh();
    End;

	DM_Table.Tb_Line.EnableControls();
end;

procedure TF_LineCopyRate.Bt_PrintClick(Sender: TObject);
begin
	P_Print_Report(R_LineCopyRate);
end;

end.