gld110_02.pas

这是一个功能齐全的,代码完整的ERP企业信息管理系统,现在上传和大家分享

unit Gld110_02;

interface

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

type
  TGld110_02Form = class(TBas200_16Form)
    lblName: TLabel;
    edtName: TEdit;
    lblRemark: TLabel;
    edtRemark: TEdit;
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    procedure OpenData(ACode:Integer);
    procedure SetInterface; override;
    procedure GetDataInfo; override;
    procedure SetEmptyInit; override;
    procedure InsertInit; override;
    procedure TableBeforePost; override;
    { Public declarations }
  end;

var
  Gld110_02Form: TGld110_02Form;

implementation

uses SYSDATA, CommFun;

{$R *.dfm}

procedure TGld110_02Form.OpenData(ACode:Integer);
begin
  if ACode=0 then AMode:='ADD' else AMode:='UPD';
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('select * from GLD110');
  ADOQuery1.Open;
  if ACode<>0 then
  begin
    ADOQuery1.Locate('G110_001',ACode,[]);
    ADOQuery1AfterScroll(ADOQuery1);
  end else
  begin
    SetEmptyInit;
  end;
end;

procedure TGld110_02Form.SetInterface;
begin
  inherited;
  Caption:=GetDBString('GLD11002001');  //付款方式维护
  lblName.Caption:=GetDBString('GLD11002002');  //付款方式
  lblRemark.Caption:=GetDBString('GLD11002003');  //备注说明
end;

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

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

procedure TGld110_02Form.GetDataInfo;
begin
  inherited;
  edtName.Text:=ADOQuery1.FieldByName('G110_002').AsString;
  edtRemark.Text:=ADOQuery1.FieldByName('G110_003').AsString;
  AOldCode:=edtName.Text;
end;

procedure TGld110_02Form.InsertInit;
begin
  inherited;
  SetEmptyInit;
end;

procedure TGld110_02Form.SetEmptyInit;
begin
  inherited;
  edtName.Text:='';
  edtRemark.Text:='';
end;

procedure TGld110_02Form.TableBeforePost;
begin
  inherited;
  if trim(edtName.Text)='' then
  begin
    ShowMsg('UMS10000636');  //付款方式不能为空
    edtName.SetFocus;
    Abort;
  end;
  if AOldCode<>trim(edtName.Text) then
  begin
    if IsExists('select 1 from GLD110 where G110_002='+''''+trim(edtName.Text)+'''') then
    begin
      ShowMsg('UMS10000637');  //付款方式已存在，请重新输入
      edtName.SetFocus;
      Abort;
    end;
  end;

  if AMode='ADD' then ADOQuery1.Append else ADOQuery1.Edit;
  ADOQuery1.FieldByName('G110_002').AsString:=edtName.Text;
  ADOQuery1.FieldByName('G110_003').AsString:=edtRemark.Text;
end;

end.