unit Ser110_02;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Bas100_01, DB, ADODB, StdCtrls, Buttons, ExtCtrls, Menus;

type
  TSer110_02Form = class(TBas100_01Form)
    PopupMenu1: TPopupMenu;
    MenuItem1: TMenuItem;
    MenuItem2: TMenuItem;
    MenuItem3: TMenuItem;
    Bevel1: TBevel;
    lblCode: TLabel;
    lblName: TLabel;
    lblRemark: TLabel;
    lblColor: TLabel;
    edtCode: TEdit;
    edtName: TEdit;
    edtRemark: TEdit;
    cbColor: TColorBox;
    bbtnOk: TBitBtn;
    bbtnExit: TBitBtn;
    qrySer110: TADOQuery;
    qrySer110S110_001: TAutoIncField;
    qrySer110S110_002: TWideStringField;
    qrySer110S110_003: TWideStringField;
    qrySer110S110_004: TWideStringField;
    qrySer110S110_005: TIntegerField;
    procedure bbtnExitClick(Sender: TObject);
    procedure bbtnOkClick(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
    procedure qrySer110AfterScroll(DataSet: TDataSet);
  private
   AMode,AOldCode:string;
   procedure SetInterface;
    { Private declarations }
  public
    procedure OpenData(ACode:string);
    { Public declarations }
  end;

var
  Ser110_02Form: TSer110_02Form;

implementation

uses SYSDATA, CommFun;

{$R *.dfm}

procedure TSer110_02Form.OpenData(ACode:string);
begin
  if not qryser110.Active then qryser110.Open;
  if ACode='' then AMode:='ADD' else AMode:='UPD';
  if ACode<>'' then
  begin
    qryser110.Locate('S110_002',ACode,[]);
    qryser110AfterScroll(qryser110);
  end else
  begin
    edtCode.Text:='';
    edtName.Text:='';
    edtRemark.Text:='';
    cbColor.Selected:=clBlack;
  end;
end;

procedure TSer110_02Form.bbtnExitClick(Sender: TObject);
begin
  inherited;
  Close;
end;

procedure TSer110_02Form.bbtnOkClick(Sender: TObject);
begin
  inherited;
  if trim(edtCode.Text)='' then
  begin
    ShowMsg('UMS10000332');  //狀態編號不能為空
    edtCode.SetFocus;
    Abort;
  end;
  if trim(edtName.Text)='' then
  begin
    ShowMsg('UMS10000333');  //狀態名稱不能為空
    edtName.SetFocus;
    Abort;
  end;
  if AOldCode<>edtCode.Text then
  begin
    if IsExists('select 1 from ser110 where S110_002='+''''+edtCode.Text+'''') then
    begin
      ShowMsg('UMS10000334');  //狀態編號已存在，請重新輸入
      edtCode.SetFocus;
      Abort;
    end;
  end;
//確定
  try
    if AMode='ADD' then qrySer110.Append else qrySer110.Edit;
    qryser110.FieldByName('S110_002').AsString:=edtCode.Text;
    qryser110.FieldByName('S110_003').AsString:=edtName.Text;
    qryser110.FieldByName('S110_004').AsString:=edtRemark.Text;
    qryser110.FieldByName('S110_005').AsInteger:=cbColor.Selected;
    qryser110.Post;

    if AMode='ADD' then
    begin
      if ShowDialog('UMS10000309')=IDYES then  //記錄保存成功，是否繼續增加新記錄？
      begin
        edtCode.Text:='';
        edtName.Text:='';
        edtRemark.Text:='';
        cbColor.Selected:=clBlack;
        edtCode.SetFocus;
      end;
    end else
      ModalResult:=1;
  except
    ShowMsg(SYSDM.ADOC.Errors[0].Description,1);
    Abort;
  end;
end;

procedure TSer110_02Form.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  inherited;
  qrySer110.close;
end;

procedure Tser110_02Form.SetInterface;
begin
  Caption:=GetDBString('TAS12002001');  //任務狀態維護
  lblCode.Caption:=GetDBString('TAS12002002');  //狀態編號
  lblName.Caption:=GetDBString('TAS12002003');  //狀態名稱
  lblColor.Caption:=GetDBString('TAS12002004');  //狀態顏色
  lblRemark.Caption:=GetDBString('TAS12002005');  //備注說明
  bbtnOk.Caption:=GetDBString('TAS12002006');  //確定(&O)
  bbtnExit.Caption:=GetDBString('TAS12002007');  //退出(&X)
end;

procedure TSer110_02Form.FormCreate(Sender: TObject);
begin
  inherited;
  qrySer110.open;
  SetInterface;
end;

procedure TSer110_02Form.qrySer110AfterScroll(DataSet: TDataSet);
begin
  inherited;
  if AMode='ADD' then Exit;
  edtCode.Text:=qryser110.FieldByName('S110_002').AsString;
  edtName.Text:=qryser110.FieldByName('S110_003').AsString;
  edtRemark.Text:=qryser110.FieldByName('S110_004').AsString;
  cbColor.Selected:=qryser110.FieldByName('S110_005').AsInteger;
  AOldCode:=edtCode.Text;
end;

end.