baseptype.pas

产品信息系统!关于产品基础信息的系统!功能强大!

unit BasePType;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, BaseInfoBase, DB, ADODB, ActnList, ComCtrls, ToolWin, ExtCtrls,
  Grids, DBGrids, StdCtrls, DBCtrls, Mask, wwDialog, wwidlg;

type
  TfrmBasePType = class(TfrmBaseInfoBase)
    DBGrid1: TDBGrid;
    Splitter1: TSplitter;
    Panel1: TPanel;
    QBaseInfofCode: TWideStringField;
    QBaseInfofTypeName: TWideStringField;
    QBaseInfofNotes: TWideStringField;
    Panel2: TPanel;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBMemo1: TDBMemo;
    procedure QBaseInfoBeforePost(DataSet: TDataSet);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure QBaseInfofCodeValidate(Sender: TField);
    procedure dsBaseInfoStateChange(Sender: TObject);
    procedure QBaseInfoAfterInsert(DataSet: TDataSet);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmBasePType      : TfrmBasePType;

implementation

{$R *.dfm}

procedure TfrmBasePType.QBaseInfoBeforePost(DataSet: TDataSet);
begin
  inherited;
  if (QBaseInfo.FieldbyName('fCode').asString = '') then
  begin
    showmessage('供应商类别编号不能为空，请重新输入！');
    abort;
  end;
  if (QBaseInfo.FieldbyName('fName').asString = '') then
  begin
    showmessage('供应商类别名称不能为空，请重新输入！');
    abort;
  end;
end;

procedure TfrmBasePType.FormClose(Sender: TObject;
  var Action: TCloseAction);
begin
  inherited;
  frmBasePType := nil;
end;

procedure TfrmBasePType.QBaseInfofCodeValidate(Sender: TField);
begin
  inherited;
  if not IsUnique('Code', Sender.asString) then
  begin
    showmessage('供应商类别编码重复，请重新输入');
    abort;
  end;
end;

procedure TfrmBasePType.dsBaseInfoStateChange(Sender: TObject);
var
  i                 : Integer;
begin
  inherited;
  with Panel2 do
    for i := 0 to ControlCount - 1 do
      if Controls[i] is TDBEdit then
        (Controls[i] as TDBEdit).ReadOnly := not acSave.Enabled
      else if Controls[i] is TDBMemo then
        (Controls[i] as TDBMemo).ReadOnly := not acSave.Enabled;
end;

procedure TfrmBasePType.QBaseInfoAfterInsert(DataSet: TDataSet);
begin
  inherited;
  DBEdit1.SetFocus;
end;

end.