inv140_02.pas.svn-base

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

unit Inv140_02;

interface

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

type
  TInv140_02Form = class(TBas200_16Form)
    lblCode: TLabel;
    edtCode: TEdit;
    lblType: TLabel;
    lblName: TLabel;
    edtName: TEdit;
    cbType: TComboBox;
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    procedure OpenData(ACode:String);
    procedure SetInterface; override;
    procedure GetDataInfo; override;
    procedure SetEmptyInit; override;
    procedure InsertInit; override;
    procedure TableBeforePost; override;
    { Public declarations }
  end;

var
  Inv140_02Form: TInv140_02Form;

implementation

uses SYSDATA, CommFun;

{$R *.dfm}

procedure TInv140_02Form.OpenData(ACode:String);
begin
  if ACode='' then AMode:='ADD' else AMode:='UPD';
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('select * from INV140 order by I140_002');
  ADOQuery1.Open;
  if ACode<>'' then
  begin
    ADOQuery1.Locate('I140_002',ACode,[]);
    ADOQuery1AfterScroll(ADOQuery1);
  end else
  begin
    InsertInit;
  end;
end;

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

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

procedure TInv140_02Form.GetDataInfo;
begin
  inherited;
  edtCode.Text:=ADOQuery1.FieldByName('I140_002').AsString;
  cbType.ItemIndex:=ADOQuery1.FieldByName('I140_004').AsInteger;
  edtName.Text:=ADOQuery1.FieldByName('I140_003').AsString;
  AOldCode:=edtCode.Text;
end;

procedure TInv140_02Form.SetEmptyInit;
begin
  inherited;
  edtCode.Text:='';
  cbType.ItemIndex:=-1;
  edtName.Text:='';
end;

procedure TInv140_02Form.SetInterface;
begin
  inherited;
  Caption:=GetDBString('INV14002001');  //计量单位维护
  lblCode.Caption:=GetDBString('INV14002002');  //单位编号
  lblType.Caption:=GetDBString('INV14002003');  //单位类型
  lblName.Caption:=GetDBString('INV14002004');  //单位名称
  cbType.Clear;
  cbType.Items.Add(GetDBString('INV14002005'));  //数量单位
  cbType.Items.Add(GetDBString('INV14002006'));  //重量单位
  cbType.Items.Add(GetDBString('INV14002007'));  //长度单位
  cbType.Items.Add(GetDBString('INV14002008'));  //面积单位
  cbType.Items.Add(GetDBString('INV14002009'));  //容积单位
  cbType.Items.Add(GetDBString('INV14002010'));  //时间单位
  cbType.ItemIndex:=0;
end;

procedure TInv140_02Form.TableBeforePost;
begin
  inherited;
  if trim(edtCode.Text)='' then
  begin
    ShowMsg('UMS10000461');  //单位编号不能为空
    edtCode.SetFocus;
    Abort;
  end;
  if trim(edtName.Text)='' then
  begin
    ShowMsg('UMS10000462');  //单位名称不能为空
    edtName.SetFocus;
    Abort;
  end;
  if AOldCode<>trim(edtCode.Text) then
  begin
    if IsExists('select 1 from INV140 where I140_002='+''''+trim(edtCode.Text)+'''') then
    begin
      ShowMsg('UMS10000463');  //单位编号已存在，请重新输入
      edtCode.SetFocus;
      Abort;
    end;
  end;

  if AMode='ADD' then ADOQuery1.Append else ADOQuery1.Edit;
  ADOQuery1.FieldByName('I140_002').AsString:=edtCode.Text;
  ADOQuery1.FieldByName('I140_004').AsInteger:=cbType.ItemIndex;
  ADOQuery1.FieldByName('I140_003').AsString:=edtName.Text;
end;

procedure TInv140_02Form.InsertInit;
begin
  inherited;
  edtCode.Text:='';
  cbType.ItemIndex:=0;
  edtName.Text:='';
end;

initialization
  RegisterClass(TInv140_02Form);

finalization
  UnRegisterClass(TInv140_02Form);

end.