unit Hrm120_01;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Bas200_06, dxExEdtr, dxTL, dxDBCtrl, dxDBGrid, DB, ADODB,
  ActnList, Menus, dxCntner, ComCtrls,
  ToolWin, ExtCtrls;

type
  THrm120_01Form = class(TBas200_06Form)
    ADOQuery1H120_001: TAutoIncField;
    ADOQuery1H120_002: TStringField;
    ADOQuery1H120_003: TStringField;
    ADOQuery1H120_004: TStringField;
    dxDBGrid1H120_002: TdxDBGridMaskColumn;
    dxDBGrid1H120_003: TdxDBGridMaskColumn;
    dxDBGrid1H120_004: TdxDBGridMaskColumn;
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure ActDeleteExecute(Sender: TObject);
  private
    { Private declarations }
  public
    procedure SetInterface; override;
    procedure ReportGetValue(const ParName: String; var ParValue: Variant); override;
    { Public declarations }
  end;

var
  Hrm120_01Form: THrm120_01Form;

implementation

uses SYSDATA, CommFun;

{$R *.dfm}

procedure THrm120_01Form.SetInterface;
begin
  inherited;
  Caption:=GetDBString('HRM12001001');  //崗位資料維護
  ADOQuery1H120_002.DisplayLabel:=GetDBString('HRM12001002');  //崗位編號
  ADOQuery1H120_003.DisplayLabel:=GetDBString('HRM12001003');  //崗位說明
  ADOQuery1H120_004.DisplayLabel:=GetDBString('HRM12001004');  //備注
end;

procedure THrm120_01Form.FormCreate(Sender: TObject);
begin
  inherited;
//
end;

procedure THrm120_01Form.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  inherited;
//
end;

procedure THrm120_01Form.ActDeleteExecute(Sender: TObject);
begin
  if ADOQuery1.IsEmpty then
  begin
    ShowMsg('UMS10000002');  //表記錄為空，操作無效
    Abort;
  end;

  SYSDM.qryQuery.Close;
  SYSDM.qryQuery.SQL.Clear;
  SYSDM.qryQuery.SQL.Add('select 1 from HRM150 where H150_008='+ADOQuery1.FieldByName('H120_001').AsString);
  SYSDM.qryQuery.Open;
  if not SYSDM.qryQuery.IsEmpty then
  begin
    ShowMsg('UMS10000172');  //該崗位編號被員工資料表引用，不能刪除
    Abort;
  end;
  inherited;
end;

procedure THrm120_01Form.ReportGetValue(const ParName: String;
  var ParValue: Variant);
begin
  inherited;
  if ParName='H120_002' then ParValue:=GetDBString('HRM12001002')  //崗位編號
  else if ParName='H120_003' then ParValue:=GetDBString('HRM12001003')  //崗位說明
  else if ParName='H120_004' then ParValue:=GetDBString('HRM12001004')  //備注
end;

initialization
  RegisterClass(THrm120_01Form);

finalization
  UnRegisterClass(THrm120_01Form);

end.