unit9.pas

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

unit Unit9;

interface

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

type
  TF_base = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    PageControl1: TPageControl;
    TabSheet1: TTabSheet;
    TabSheet2: TTabSheet;
    Panel3: TPanel;
    Splitter1: TSplitter;
    Panel4: TPanel;
    Panel5: TPanel;
    Splitter2: TSplitter;
    Panel6: TPanel;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    Edit1: TEdit;
    Edit2: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    SpeedButton4: TSpeedButton;
    SpeedButton5: TSpeedButton;
    SpeedButton6: TSpeedButton;
    Edit3: TEdit;
    Edit4: TEdit;
    Label3: TLabel;
    Label4: TLabel;
    SpeedButton7: TSpeedButton;
    SpeedButton8: TSpeedButton;
    procedure SpeedButton3Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton5Click(Sender: TObject);
    procedure SpeedButton6Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton4Click(Sender: TObject);
    procedure SpeedButton7Click(Sender: TObject);
    procedure SpeedButton8Click(Sender: TObject);
    procedure FormCloseQuery(Sender: TObject; var CanClose: Boolean);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_base: TF_base;
  change:boolean;
implementation
  uses unit11;
{$R *.dfm}

procedure TF_base.SpeedButton3Click(Sender: TObject);
begin
  Speedbutton3.Enabled:=false;
  Speedbutton4.Enabled:=false;
  Speedbutton5.Enabled:=false;
  if  PageControl1.ActivePage=Tabsheet1 then
  begin
    Speedbutton1.Enabled:=true;
    Speedbutton2.Enabled:=true;
    Edit1.Enabled:=true;
    Edit2.Enabled:=true;
  end
  else
  begin
    Speedbutton7.Enabled:=true;
    Speedbutton8.Enabled:=true;
    Edit3.Enabled:=true;
    Edit4.Enabled:=true;
  end;
  Edit1.Clear;
  Edit2.Clear;
end;

procedure TF_base.SpeedButton1Click(Sender: TObject);
begin
  if change<>True then
  begin
    mydm.find.Close;
    mydm.find.SQL.Clear;
    mydm.find.SQL.Add('select*from class where  class_ID='''+Trim(Edit1.text)+'''');
    mydm.find.Open;
    if mydm.find.RecordCount>0 then//查找是否有重复记录有则退出
    begin
      Application.MessageBox('编号重复。','提示！',mb_ok);
      Exit;
    end;
  end;
  if ((Edit1.Text<>'') and (Edit2.Text<>'')) then
  begin
    if change=True then mydm.classrc.DataSet.Delete;
    with Mydm.clasQuery do //插入新记录
    begin
      Close;
      with SQL do
      begin
        Clear;
        Add('insert into class values(:p0,:p1)');
        Parameters[0].Value:=Edit1.Text;
        Parameters[1].Value:=Edit2.Text;
      end;
      Execsql;
    end;
  //刷新表
    with mydm.clasQuery do
    begin
      Close;
      with sql do
      begin
        Clear;
        Add('select*from class');
      end;
      Open;
      Change:=False;
      Speedbutton2.Click;
    end;
  end
  else
  begin
    Application.MessageBox('输入必要信息','提示',64);
    Exit;
  end;
  Edit1.Enabled:=False;
  Edit2.Enabled:=False;
  Speedbutton3.Enabled:=True;
  Speedbutton4.Enabled:=True;
  Speedbutton5.Enabled:=True;
  Speedbutton1.Enabled:=False;
  Speedbutton2.Enabled:=False;
end;

procedure TF_base.SpeedButton5Click(Sender: TObject);
begin
  if Application.MessageBox('是否删除？','提示',mb_yesno)=6 then
  begin
    try
      if Pagecontrol1.ActivePage=Tabsheet1 then
        Mydm.classrc.DataSet.Delete;
      if Pagecontrol1.ActivePage=Tabsheet2 then
        Mydm.fansrc.DataSet.Delete;
    except//如果删除不成功将弹出以下对会框
      Application.MessageBox('删除不成功!','提示',mb_ok);
    end;
  end;
end;

procedure TF_base.SpeedButton6Click(Sender: TObject);
begin
  Speedbutton2.Click;
  Close;
end;

procedure TF_base.SpeedButton2Click(Sender: TObject);
begin
  Edit1.Clear;
  Edit2.Clear;
  Edit1.Enabled:=false;
  Edit2.Enabled:=false;
  speedbutton2.Enabled:=false;
  speedbutton1.Enabled:=false;
  Speedbutton3.Enabled:=true;
  Speedbutton4.Enabled:=true;
  Speedbutton5.Enabled:=true;
  change:=False;
end;

procedure TF_base.SpeedButton4Click(Sender: TObject);
begin
  Edit1.Clear;
  Edit2.Clear;
  Edit1.Enabled:=True;
  Edit2.Enabled:=True;
  Edit3.Enabled:=True;
  Edit4.Enabled:=True;
  Speedbutton3.Enabled:=False;
  Speedbutton4.Enabled:=False;
  Speedbutton5.Enabled:=False;
  if  pagecontrol1.ActivePage=Tabsheet1 then//判断Tabsheet1是否为当前页
  begin
    Speedbutton1.Enabled:=True;
    Speedbutton2.Enabled:=True;
  end
  else
  begin
    Speedbutton7.Enabled:=True;
    Speedbutton8.Enabled:=True;
  end;
  if Pagecontrol1.ActivePage=Tabsheet1 then
  begin
    Edit1.Text:=mydm.classrc.DataSet.Fields[0].AsString;//记录在TEdit组件中显示
    Edit2.Text:=mydm.classrc.DataSet.Fields[1].AsString;
  end;
  if Pagecontrol1.ActivePage=Tabsheet2 then
  begin
    Edit3.Text:=mydm.fansrc.DataSet.Fields[0].AsString;
    Edit4.Text:=mydm.fansrc.DataSet.Fields[1].AsString;
  end;
  Change:=True;//定义判断是否为修改状态的全局变量
end;

procedure TF_base.SpeedButton7Click(Sender: TObject);
begin
  Edit3.Clear;
  Edit4.Clear;
  Edit3.Enabled:=false;
  Edit4.Enabled:=false;
  Speedbutton3.Enabled:=true;
  Speedbutton4.Enabled:=true;
  Speedbutton5.Enabled:=true;
  speedbutton7.Enabled:=false;
  speedbutton8.Enabled:=false;
  change:=False;
end;

procedure TF_base.SpeedButton8Click(Sender: TObject);
begin
  if change<>True then
  begin
    mydm.find.Close;
    mydm.find.SQL.Clear;
    mydm.find.SQL.Add('select*from fan where  fan_num='''+Trim(edit3.text)+'''');
    mydm.find.Open;
    if mydm.find.RecordCount<>0 then
    begin
      application.MessageBox('编号重复。','提示！',mb_ok);
      exit;
    end;
  end;
  if ((Edit3.Text<>'') and (Edit4.Text<>'')) then
  begin
    if change=true then Mydm.fanQuery.Delete;
    with mydm.fanQuery do
    begin
      Close;
      with SQL do
      begin
        Clear;
        Add('insert into fan values(:p0,:p1)');
        Parameters[0].Value:=edit3.Text;
        Parameters[1].Value:=edit4.Text;
      end;
      Execsql;
    end;
    //刷新dbgrid
    with mydm.fanQuery do
    begin
      Close;
      with SQL do
      begin
        Clear;
        Add('select*from fan');
      end;
      Open;
      change:=false;
      Speedbutton7.Click;
    end;
  end
  else
  begin
    Application.MessageBox('输入必要信息','提示',64);
    exit;
  end;
  Edit3.enabled:=false;
  Edit4.enabled:=false;
  Speedbutton3.Enabled:=true;
  Speedbutton4.Enabled:=true;
  Speedbutton5.Enabled:=true;
  Speedbutton1.Enabled:=false;
end;

procedure TF_base.FormCloseQuery(Sender: TObject; var CanClose: Boolean);
begin
  if (speedbutton1.Enabled=True) or (speedbutton8.Enabled=True) then
  begin
    canclose:=False;
    Application.MessageBox('请点击取消或提交。','提示！',mb_ok)
  end;
end;

end.