unit Ser110_01;

interface

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

type
  TSer110_01Form = class(TBas200_10Form)
    ADOQuery1S110_001: TAutoIncField;
    ADOQuery1S110_002: TWideStringField;
    ADOQuery1S110_003: TWideStringField;
    ADOQuery1S110_004: TWideStringField;
    ADOQuery1S110_005: TIntegerField;
    dxDBGrid1S110_002: TdxDBGridColumn;
    dxDBGrid1S110_003: TdxDBGridColumn;
    dxDBGrid1S110_004: TdxDBGridColumn;
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    procedure SetInterface; override;
    procedure InsertEvent; override;
    procedure UpdateEvent; override;
    procedure DeleteEvent; override;
    procedure BrowseEvent; override;
    procedure ReportGetValue(const ParName: String; var ParValue: Variant); override;
    { Public declarations }
  end;

var
  Ser110_01Form: TSer110_01Form;

implementation

uses SYSDATA, CommFun, Ser110_02;

{$R *.dfm}

procedure TSer110_01Form.SetInterface;
begin
  inherited;
  Caption:=GetDBString('SER11001001');  //來電狀態(tài)維護(hù)
  ADOQuery1S110_001.DisplayLabel:=GetDBString('SER11001002');  //電腦編號
  ADOQuery1S110_002.DisplayLabel:=GetDBString('SER11001003');  //狀態(tài)編號
  ADOQuery1S110_003.DisplayLabel:=GetDBString('SER11001004');  //狀態(tài)名稱
  ADOQuery1S110_004.DisplayLabel:=GetDBString('SER11001005');  //備注說明
  ADOQuery1S110_005.DisplayLabel:=GetDBString('SER11001006');  //狀態(tài)顏色
end;

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

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

procedure TSer110_01Form.ReportGetValue(const ParName: String; var ParValue: Variant);
begin
  inherited;
  if ParName='S110_002' then ParValue:=ADOQuery1S110_002.DisplayLabel  //狀態(tài)編號
  else if ParName='S110_003' then ParValue:=ADOQuery1S110_003.DisplayLabel  //狀態(tài)名稱
  else if ParName='S110_004' then ParValue:=ADOQuery1S110_004.DisplayLabel  //備注說明
  else if ParName='S110_005' then ParValue:=ADOQuery1S110_005.DisplayLabel  //
end;

procedure TSer110_01Form.BrowseEvent;
begin
  inherited;

end;

procedure TSer110_01Form.DeleteEvent;
begin
  inherited;
//刪除
  SYSDM.qryQuery.Close;
  SYSDM.qryQuery.SQL.Clear;
  SYSDM.qryQuery.SQL.Add('select 1 from SER500 where S500_003='+ADOQuery1.FieldByName('S110_001').AsString);
  SYSDM.qryQuery.Open;
  if not SYSDM.qryQuery.IsEmpty then
  begin
    ShowMsg('UMS10000355');  //該狀態(tài)編號被來電記錄表引用，不能刪除
    Abort;
  end;
  DeleteTableRecord(ADOQuery1,'SER110','S110_001='+ADOQuery1S110_001.AsString);
end;

procedure TSer110_01Form.InsertEvent;
begin
  inherited;
//新增
  Ser110_02Form:=TSer110_02Form.Create(Application);
  Ser110_02Form.OpenData('');
  Ser110_02Form.showModal;
end;

procedure TSer110_01Form.UpdateEvent;
begin
  inherited;
//修改
  Ser110_02Form:=TSer110_02Form.Create(Application);
  Ser110_02Form.OpenData(ADOQuery1S110_002.Value);
  Ser110_02Form.showModal;
end;

initialization
  RegisterClass(TSer110_01Form);

finalization
  UnRegisterClass(TSer110_01Form);

end.