unit10.pas

数据库人寿保险通用系统 本系统主要负责保险资料的管理

unit Unit10;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Grids, DBGrids, ExtCtrls, Buttons, ComCtrls, ImgList;

type
  TF_user = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Splitter1: TSplitter;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    Button1: TButton;
    Button2: TButton;
    RadioGroup1: TRadioGroup;
    ImageList1: TImageList;
    Label5: TLabel;
    Edit5: TEdit;
    Panel3: TPanel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure RadioGroup1Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
    procedure Edit2KeyPress(Sender: TObject; var Key: Char);
    procedure Edit3KeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_user: TF_user;
  change:boolean;
implementation
  uses unit11;
{$R *.dfm}

procedure TF_user.SpeedButton1Click(Sender: TObject);
begin
  Speedbutton1.Enabled:=False;
  Speedbutton4.Enabled:=False;
  Speedbutton3.Enabled:=False;
  Button1.Enabled:=True;
  Button2.Enabled:=True;
  Edit1.Enabled:=True;
  Edit2.Enabled:=True;
  Edit3.Enabled:=True;
  Edit4.Enabled:=True;
  Edit5.Enabled:=True;
  if Edit1.Enabled=True then
    Edit1.SetFocus;
end;

procedure TF_user.SpeedButton2Click(Sender: TObject);
begin
  Button2.Click;
  Close;
end;

procedure TF_user.SpeedButton4Click(Sender: TObject);
begin
  Edit1.Enabled:=True;//设置文本框可编辑
  Edit2.Enabled:=True;
  Edit3.Enabled:=True;
  Edit4.Enabled:=True;
  Edit5.Enabled:=True;
  Change:=True;//修改状态
  Speedbutton1.Enabled:=False;
  Speedbutton4.Enabled:=False;
  Speedbutton3.Enabled:=False;
  Button1.Enabled:=True;
  Button2.Enabled:=True;
  Edit1.Text:=mydm.usersrc.DataSet.Fields[0].AsString;//文本框中显示数据
  Edit2.Text:=mydm.usersrc.DataSet.Fields[1].AsString;
  Edit3.Text:=mydm.usersrc.DataSet.Fields[2].AsString;
  Edit4.Text:=mydm.usersrc.DataSet.Fields[3].AsString;
end;

procedure TF_user.SpeedButton3Click(Sender: TObject);
begin
  Try
    if Application.MessageBox('是否删除?','提示',mb_yesno)=6 then
      Mydm.usersrc.DataSet.Delete;
  Except
    Application.MessageBox('操作不成功可能无记录！','提示',mb_ok);
  end;
end;
procedure TF_user.RadioGroup1Click(Sender: TObject);
begin
  if Radiogroup1.ItemIndex=0 then
    Edit4.Text:='管理员';
  if Radiogroup1.ItemIndex=1 then
    Edit4.Text:='浏览者';
end;

procedure TF_user.Button1Click(Sender: TObject);
begin
  if Trim(Edit5.Text)<>Trim(Edit3.Text) then
  begin
    Application.MessageBox('密码不相同！','提示',mb_ok);
    Exit;
  end;
  if ((Edit1.Text<>'') and (Edit2.Text<>'') and (Edit3.text<>'') and (Edit4.text<>''))then
  begin
    if change=true then mydm.usersrc.DataSet.Delete;
    Try
      with mydm.userQuery do
      begin
        Close;
        with SQL do
        begin
          Clear;
          Add('insert into users values(:p0,:p1,:p2,:p3)');
        end;
        Parameters[0].Value:=Edit1.Text;
        Parameters[1].Value:=Edit2.Text;
        Parameters[2].Value:=Edit3.Text;
        Parameters[3].Value:=Edit4.Text;
        Execsql;
      end;
    Except
      Application.MessageBox('操作不成功编号不可重复！','提示',mb_ok);
    end;
    with mydm.userQuery do
    begin
      Close;
      with SQL do
      begin
        Clear;
        Add('select*from users');
      end;
      Open;
    end;
    Button2.Click;//取消按钮清空文本框中数据
    change:=False;//修改完
  end
  else
  begin
    Application.MessageBox('输入必要信息。','提示',64);
    exit;
  end;
  Radiogroup1.ItemIndex:=-1;
  Speedbutton1.Enabled:=True;
  Speedbutton3.Enabled:=True;
  Speedbutton4.Enabled:=True;
  Button1.Enabled:=False;
  Button2.Enabled:=False;
end;

procedure TF_user.Button2Click(Sender: TObject);
begin
  Change:=False;
  Edit1.Clear;
  Edit2.Clear;
  Edit3.Clear;
  Edit4.Clear;
  Edit5.Clear;
  Edit1.Enabled:=false;
  Edit2.Enabled:=false;
  Edit3.Enabled:=false;
  Edit4.Enabled:=false;
  Edit5.Enabled:=False;
  Speedbutton1.Enabled:=true;
  Speedbutton3.Enabled:=true;
  Speedbutton4.Enabled:=true;
  Button1.Enabled:=false;
  button2.Enabled:=false;
  Radiogroup1.ItemIndex:=-1;
end;

procedure TF_user.FormShow(Sender: TObject);
begin
  with mydm.userQuery do
  begin
    Close;
    SQL.Clear;
    SQL.Add('select*from users ');
    Open;
  End;
end;

procedure TF_user.Edit1KeyPress(Sender: TObject; var Key: Char);
begin
  if key=#13 then
    selectnext(sender as Twincontrol,true,true);
end;

procedure TF_user.Edit2KeyPress(Sender: TObject; var Key: Char);
begin
  if key=#13 then
    selectnext(sender as Twincontrol,true,true);
end;

procedure TF_user.Edit3KeyPress(Sender: TObject; var Key: Char);
begin
  if key=#13 then
    selectnext(sender as Twincontrol,true,true);
end;

end.