mc_ssdj.~pas

1、系统环境要求：所有程序均在Windows98/XP操作系统下测试运行。 2、建议用户在系统上安装DELPHI7.0企业版。 3、如果数据库为SQL Server数据库

unit MC_SSDJ;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Mask, DBCtrls, Db, DBTables, Buttons, ExtCtrls;

type
  TSSDJ = class(TForm)
    Table1: TTable;
    Table1BDEDesigner: TStringField;
    Table1BDEDesigner2: TStringField;
    Table1BDEDesigner3: TStringField;
    Table1BDEDesigner4: TIntegerField;
    Table1BDEDesigner5: TStringField;
    Table1BDEDesigner6: TStringField;
    Table1BDEDesigner7: TDateTimeField;
    Table1BDEDesigner8: TStringField;
    DataSource1: TDataSource;
    GroupBox1: TGroupBox;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label3: TLabel;
    DBEdit3: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    Label5: TLabel;
    DBEdit5: TDBEdit;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    Label7: TLabel;
    DBEdit7: TDBEdit;
    Label8: TLabel;
    DBEdit8: TDBEdit;
    DBNavigator1: TDBNavigator;
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn3: TBitBtn;
    BitBtn4: TBitBtn;
    procedure DBEdit1Enter(Sender: TObject);
    procedure DBEdit1Exit(Sender: TObject);
    procedure DBEdit1KeyPress(Sender: TObject; var Key: Char);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  SSDJ: TSSDJ;

implementation

uses MC_SSXXLL, MC_MainForm;

{$R *.DFM}

procedure TSSDJ.DBEdit1Enter(Sender: TObject);
begin
     TDBEdit(Sender).Color:=ClAqua;
end;

procedure TSSDJ.DBEdit1Exit(Sender: TObject);
begin
     TDBEdit(Sender).Color:=ClWindow;
end;

procedure TSSDJ.DBEdit1KeyPress(Sender: TObject; var Key: Char);
begin
     if key=#13 then perForm(WM_NEXTDLGCTL,0,0);
end;

procedure TSSDJ.FormClose(Sender: TObject; var Action: TCloseAction);
begin
     SSDJ.Release;
     SSDJ:=Nil;
end;

procedure TSSDJ.BitBtn3Click(Sender: TObject);
begin
     if Table1.RecordCount<>0 then
     if MessageDlg('是否删除当前记录?',mtCustom,[mbYes,mbNo],0)=mrYes then
        Table1.Delete; 
end;

procedure TSSDJ.BitBtn1Click(Sender: TObject);
begin
     if BitBtn1.Caption='添加[&I]' then
        begin
             Table1.Insert;
             BitBtn1.Caption:='保存[&S]';
             BitBtn2.Caption:='取消[&U]';
             BitBtn3.Enabled:=False;
             BitBtn4.Enabled:=False;
             DBNavigator1.Enabled:=False;
             GroupBox1.Enabled:=True;
             DBEdit1.Setfocus;
        end
     else
        begin
             if Length(Table1.FieldByname('设备编号').AsString)=0 then
                begin
                     ShowMessage('请输入设备编号');
                     DBEdit1.SetFocus;
                end
             else
                begin
                     BitBtn1.Caption:='添加[&I]';
                     BitBtn2.Caption:='修改[&E]';
                     BitBtn3.Enabled:=True;
                     BitBtn4.Enabled:=True;
                     DBNavigator1.Enabled:=True;
                     GroupBox1.Enabled:=False;
                     try
                        Table1.Post
                     Except
                         ShowMessage('重复设备编号，保存失败.');
                     end;
                end;
        end;
end;

procedure TSSDJ.BitBtn2Click(Sender: TObject);
begin
     if BitBtn2.Caption='修改[&E]' then
        begin
             Table1.Edit;
             BitBtn1.Caption:='保存[&S]';
             BitBtn2.Caption:='取消[&U]';
             BitBtn3.Enabled:=False;
             BitBtn4.Enabled:=False;
             DBNavigator1.Enabled:=False;
             GroupBox1.Enabled:=True;
             DBEdit1.Setfocus;
        end
     else
        begin
                     BitBtn1.Caption:='添加[&I]';
                     BitBtn2.Caption:='修改[&E]';
                     BitBtn3.Enabled:=True;
                     BitBtn4.Enabled:=True;
                     DBNavigator1.Enabled:=True;
                     GroupBox1.Enabled:=False;
                     Table1.Cancel;
        end;
end;

procedure TSSDJ.BitBtn4Click(Sender: TObject);
begin
     if Not Assigned(SSXXLL) then
        begin
             SSXXLL:=TSSXXLL.Create(Self);
             SSXXLL.ShowModal;
        end;
end;

procedure TSSDJ.FormShow(Sender: TObject);
begin
     if MainForm.Query1.Locate('使用选项','小区设施登记',[loCaseInsensitive]) then
        begin
             if MainForm.Query1.FieldbyName('读写').AsString='读' then
                begin
                     Bitbtn1.Enabled:=False;
                     Bitbtn2.Enabled:=False;
                     bitBtn3.Enabled:=False;
                end;
        end;
end;

end.