bas_currency.pas

一个MRPII系统源代码版本

unit Bas_Currency;

Interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  Base_Outer, Menus, ExtPrintReport, Db, ActnList, AdODB, Grids, DBGridEh,
  StdCtrls, ExtCtrls, ComCtrls, ToolWin, jpeg;

Type
  TFrm_Bas_Currency = Class(TFrm_Base_Outer)
    AdoQry_MainCURRENCYCode: TStringField;
    AdoQry_MainCURRENCYName: TStringField;
    AdoQry_MainCURRENCYFLAG: TStringField;
    AdoQry_MainISMaster: TIntegerField;
    procedure Act_DeleteExecute(Sender: TObject);
    procedure Act_ModifyExecute(Sender: TObject);
  private
    { Private declarations }
  public
    procedure InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);Override;
    function  SetDeleteSql:String;Override  ;
    { Public declarations }
  end;

var
  Frm_Bas_Currency: TFrm_Bas_Currency;

implementation

uses Bas_Currency_D,Sys_Global;

{$R *.DFM}

procedure TFrm_Bas_Currency.InitForm(AdOConnection:TAdOConnection;ReadOnly:Boolean);
begin
  Application.ProcessMessages;
  ExtendCaption:=False;
  
  inherited;
  Application.ProcessMessages;
  SelectFromSQL:='Select * From Currency';
  OrderByFields:='CurrencyCode';
  Lbl_Order.Caption:='货币代码';
  GetData;
  Frm_Sys_Detail:=TFrm_Bas_Currency_D.Create(Application)
end;

function TFrm_Bas_Currency.SetDeleteSql:String;
begin
  Result:='Delete From Currency Where CurrencyCode='''+
          AdoQry_Main.fieldbyname('CurrencyCode').AsString+'''';
end;

procedure TFrm_Bas_Currency.Act_DeleteExecute(Sender: TObject);
begin
  if AdoQry_Main.fieldbyname('CurrencyCode').asstring='00' then
  begin
    DispInfo(' 人民币是系统保留的记录，不允许删除！ ',3);
    abort;
  end;
  inherited;
end;

procedure TFrm_Bas_Currency.Act_ModifyExecute(Sender: TObject);
begin
  if AdoQry_Main.fieldbyname('CurrencyCode').asstring='00' then
  begin
    DispInfo(' 人民币是系统保留的记录，不允许修改！ ',3);
    abort;
  end;
  inherited;
end;

end.