mobile_dm.pas

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

unit Mobile_DM;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Db, DBTables;

type
  TDM_Mobile = class(TDataModule)
    Ds_OrigHouse: TDataSource;
    Tb_OrigHouse: TTable;
    Tb_OrigHouseF_HOUSE_NO: TStringField;
    Tb_OrigHouseF_HOUSE_NAME: TStringField;
    Ds_OrigAmmeter: TDataSource;
    Tb_OrigAmmeter: TTable;
    Tb_OrigHouseF_BOX_NO: TStringField;
    Tb_OrigAmmeterF_HOUSE_NO: TStringField;
    Tb_OrigAmmeterF_AMMETER_ORDER: TIntegerField;
    Tb_OrigAmmeterF_AMMETER_NO: TStringField;
    Tb_OrigAmmeterF_LNO: TStringField;
    Tb_OrigAmmeterF_LCONSTANT: TSmallintField;
    Tb_OrigAmmeterF_PLRATE: TSmallintField;
    Tb_OrigAmmeterF_THIS_COUNT: TFloatField;
    Tb_OrigHouseF_TRANSFER_NO: TStringField;
    Ds_Transfer: TDataSource;
    Tb_Transfer: TTable;
    Tb_TransferF_TRANSFER_NO: TStringField;
    Tb_TransferF_TRANSFER_NAME: TStringField;
    Tb_TransferF_RECENTTIME: TDateTimeField;
    Tb_TransferF_METERCOUNT: TIntegerField;
    Tb_OrigAmmeterF_TRANSFER_NO: TStringField;
    Q_Query: TQuery;
    Tb_TransferF_CENTERNO: TIntegerField;
    Q_Ammeter: TQuery;
    Q_AmmeterF_HOUSE_NAME: TStringField;
    Q_AmmeterF_LNO: TStringField;
    Q_AmmeterF_AMMETER_NO: TStringField;
    Q_AmmeterF_LCONSTANT: TSmallintField;
    Q_AmmeterF_PLRATE: TSmallintField;
    Q_AmmeterF_THIS_COUNT: TFloatField;
    Q_CheckMulti: TQuery;
    Q_CheckMultiF_LNO: TStringField;
    Q_CheckMultiCOUNT: TIntegerField;
    Ds_CheckMulti: TDataSource;
    DS_CWCMeter: TDataSource;
    Tb_CWCMeter: TTable;
    Tb_CWCMeterF_CENTERNO: TIntegerField;
    Tb_CWCMeterF_LNO: TStringField;
    Tb_CWCMeterF_FACTCOUNT: TFloatField;
    Tb_CWCMeterF_COUNT: TIntegerField;
    Tb_CWCMeterF_COPYTIME: TStringField;
    Tb_CWCMeterF_OK: TSmallintField;
    Tb_OrigHouseF_VOLTAGE_NO: TStringField;
    Tb_OrigHouseF_ELECT_NO: TStringField;
    Q_AmmeterF_HOUSE_NO: TStringField;
    Tb_CWCMeterF_BATCH: TIntegerField;
    Q_RepeatLNo: TQuery;
    Q_RepeatLNoF_CENTERNO: TIntegerField;
    Q_RepeatLNoF_LNO: TStringField;
    Q_RepeatLNoCOUNT: TIntegerField;
    Ds_RepeatLNo: TDataSource;
    Q_RepeatLNoDetail: TQuery;
    Q_RepeatLNoDetailF_HOUSE_NO: TStringField;
    Q_RepeatLNoDetailF_AMMETER_NO: TStringField;
    Ds_RepeatLNoDetail: TDataSource;
    procedure IB_DatabaseAfterConnect(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  DM_Mobile: TDM_Mobile;

implementation

uses Comm;

{$R *.DFM}












procedure TDM_Mobile.IB_DatabaseAfterConnect(Sender: TObject);
begin
	Tb_Transfer.Open();
	Tb_OrigHouse.Open();
    Tb_OrigAmmeter.Open();
end;

end.