unit7.pas

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

unit Unit7;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, ExtCtrls, StdCtrls, ComCtrls, DBCtrls, Buttons,
  RpCon, RpConDS, RpDefine, RpRave;

type
  TF_policy = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Panel3: TPanel;
    Panel4: TPanel;
    Panel5: TPanel;
    DBGrid1: TDBGrid;
    Edit1: TEdit;
    Edit2: TEdit;
    Edit3: TEdit;
    Edit4: TEdit;
    ComboBox1: TComboBox;
    ComboBox2: TComboBox;
    Edit5: TEdit;
    DateTimePicker1: TDateTimePicker;
    Edit6: TEdit;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Button1: TButton;
    Button2: TButton;
    Button4: TButton;
    Edit7: TEdit;
    Label10: TLabel;
    Button6: TButton;
    Splitter1: TSplitter;
    Button8: TButton;
    Panel6: TPanel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    RvProject1: TRvProject;
    RvDataSetConnection1: TRvDataSetConnection;
    procedure Button1Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button6Click(Sender: TObject);
    procedure Button7Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button8Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure Edit7Change(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Edit5KeyPress(Sender: TObject; var Key: Char);
    procedure ComboBox1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure ComboBox2KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Edit5KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure DateTimePicker1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Edit6KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Edit1KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Edit2KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Edit3KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
    procedure Edit4KeyDown(Sender: TObject; var Key: Word;
      Shift: TShiftState);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_policy: TF_policy;
  change:boolean;
  mybookmark:string;
implementation
  uses unit11,unit12,unit9, Unit4, Unit8, fselect;
{$R *.dfm}

procedure TF_policy.Button1Click(Sender: TObject);
begin
  Button1.Enabled:=false;
  Button2.Enabled:=false;
  Button4.Enabled:=true;
  button8.Enabled:=true;
  Edit5.Clear;
  Edit6.Clear;
  Edit5.Enabled:=true;
  Edit6.Enabled:=true;
  Combobox1.Enabled:=true;
  Combobox2.Enabled:=true;
  Datetimepicker1.Enabled:=true;
  end;

procedure TF_policy.Button4Click(Sender: TObject);
begin

  if ((Edit1.Text<>'') and (Edit2.Text<>'') and (Edit3.Text<>'') and (Edit4.Text<>'')) then
  begin
    if change=true then
    begin
      mydm.policysrc.DataSet.Bookmark:=mybookmark;
      mydm.policysrc.DataSet.Delete;
    end;
    with Mydm.policyquery do
    begin
      Close;
      with SQL do
      begin
        Clear;
        Add('insert into policy values(:p0,:p1,:p2,:p3,:p4,:p5,:p6:,:p7,:p8) ');
      end;
      Parameters[0].Value:=edit1.Text;
      Parameters[1].Value:=edit2.Text;
      Parameters[2].Value:=edit3.Text;
      Parameters[3].value:=edit4.Text;
      Parameters[4].Value:=combobox1.Text;
      Parameters[5].Value:=combobox2.Text;
      parameters[6].Value:=edit5.Text;
      Parameters[7].Value:=datetimepicker1.Date;
      Parameters[8].Value:=edit6.Text;
      Execsql;
    end;
   //刷新表
    with Mydm.policyquery do
    begin
      Close;
      with SQL do
      begin
        Clear;
        Add('select*from policy');
      end;
      Open;
    end;
    F_customer.guo:=(strtoint(trim(Mydm.guosrc.DataSet.FieldByName('saveguo').AsString)));
    Inc(F_customer.guo);
    Mydm.guo.Edit;
    if change<>true then
      Mydm.guosrc.DataSet.FieldByName('saveguo').AsString:=Trim(inttostr(F_customer.guo));
    MYdm.guo.Post;
    change:=false;
    button8.Click;
  end
  else
  begin
    Application.MessageBox('输入必要信息。','提示',64);
    exit;
  end;
  edit2.Clear;
  edit3.Clear;
  edit4.Clear;
  Button1.Enabled:=True;
  Button2.Enabled:=True;
  Button4.Enabled:=False;
  button8.Enabled:=False;
  speedbutton2.Enabled:=True;
end;

procedure TF_policy.Button6Click(Sender: TObject);
begin
  F_select.ListBox1.Clear;
  Button8.Click;
  Close;
end;

procedure TF_policy.Button7Click(Sender: TObject);
var
  i:integer;
begin
  Combobox1.clear;
  for i:=0 to mydm.classrc.DataSet.RecordCount-1 do
  begin
    Combobox1.Items.Add(mydm.clasQuery.Fields[0].asstring);
    Mydm.classrc.DataSet.Next;
  end;
  Mydm.classrc.DataSet.First;
end;

procedure TF_policy.Button2Click(Sender: TObject);
begin
  if mydm.policyquery.RecordCount=0 then
    Exit;
  change:=true;
  Button1.Click;
  Button1.Enabled:=false;
  Button2.Enabled:=false;
  button4.Enabled:=true;
  button8.Enabled:=true;
  Edit5.Enabled:=true;
  Edit6.Enabled:=true;
  Combobox1.Enabled:=true;
  Combobox2.Enabled:=true;
  Datetimepicker1.Enabled:=true;
  Edit1.Text:=mydm.policysrc.DataSet.Fields[0].AsString;
  Edit2.Text:=mydm.policysrc.DataSet.Fields[1].AsString;
  Edit3.Text:=mydm.policysrc.DataSet.Fields[2].AsString;
  Edit4.Text:=mydm.policysrc.DataSet.Fields[3].AsString;
  Combobox1.Text:=mydm.policysrc.DataSet.Fields[4].AsString;
  Combobox2.Text:=mydm.policysrc.DataSet.Fields[5].AsString;
  Edit5.Text:=mydm.policysrc.DataSet.Fields[6].AsString;
  Datetimepicker1.Date:=mydm.policysrc.DataSet.Fields[7].AsDateTime;
  Edit6.Text:=mydm.policysrc.DataSet.Fields[8].AsString;
  mybookmark:=mydm.policysrc.DataSet.Bookmark;
end;

procedure TF_policy.Button8Click(Sender: TObject);
begin
  Button1.Enabled:=true;
  Button2.Enabled:=true;
  button4.Enabled:=false;
  button8.Enabled:=false;
  edit1.Clear;
  Edit2.Clear;
  Edit3.Clear;
  Edit4.Clear;
  Edit5.Clear;
  Edit6.Clear;
  Combobox1.ItemIndex:=-1;
  Edit1.Enabled:=false;
  Edit2.Enabled:=false;
  Edit3.Enabled:=false;
  Edit4.Enabled:=false;
  Edit5.Enabled:=false;
  Edit6.Enabled:=false;
  Combobox1.Enabled:=false;
  Combobox2.Enabled:=false;
  Datetimepicker1.Enabled:=false;
  change:=False;
end;

procedure TF_policy.SpeedButton2Click(Sender: TObject);
begin
  if (button4.Enabled=true) and ((Trim(MYdm.guosrc.DataSet.Fields[0].asstring)<>'0') and (Trim(MYdm.guosrc.DataSet.Fields[0].asstring)<>'5')) then
    application.MessageBox('请提交或取消！','提示',mb_ok)
  else
  begin
    F_select.listbox1.clear;
    Hide;
    F_customer.Button4.Click;
    F_customer.show;
  end;
end;

procedure TF_policy.SpeedButton1Click(Sender: TObject);
begin
  Hide;
  F_bill.show;
end;

procedure TF_policy.SpeedButton3Click(Sender: TObject);
begin
  with mydm.query do
  begin
    Close;
    with SQL do
    begin
      Clear;
      Add('select a.*,b.*,c.*,d.* from policy as a,customer as b,insurant as c,beneficiary as d');
      Add('where policy_id=:p and' );
      Add('b.cust_id=a.cust_id and');
      Add('c.inst_id=a.inst_id and');
      Add('d.bene_id=a.bene_id');
      Prepared;
    end;
    Parameters[0].Value:=trim(edit7.Text);
    Active:=true; open;
  end;
  Rvproject1.Execute;
end;

procedure TF_policy.Edit7Change(Sender: TObject);
begin
  Speedbutton3.Enabled:=true;
end;

procedure TF_policy.FormShow(Sender: TObject);
var
  i:integer;
begin
  speedbutton1.Enabled:=False;
  speedbutton2.Enabled:=False;
  if Trim(Edit1.Text)<>'' then
  begin
    Edit2.Text:=Trim(Edit1.Text);
    Edit3.Text:=Trim(Edit1.Text);
    Edit4.Text:=Trim(Edit1.Text);
  end;
  with mydm.policyquery do
   begin
     Close;
     with SQL do
     begin
       Clear;
       Add('select*from policy');
     end;
      Open;
   end;
   if combobox1.Enabled=true then
    combobox1.SetFocus;
   Combobox1.ItemIndex:=-1;
  Combobox2.ItemIndex:=-1;
  Combobox1.clear;
  for i:=0 to mydm.classrc.DataSet.RecordCount-1 do
  begin
    Combobox1.Items.Add(mydm.clasQuery.Fields[1].asstring);
    Mydm.classrc.DataSet.Next;
  end;
  Mydm.classrc.DataSet.First;
  Combobox2.Clear;
  for i:=0 to mydm.fansrc.DataSet.RecordCount-1 do
  begin
    Combobox2.Items.Add(mydm.fanQuery.Fields[1].asstring);
    Mydm.fansrc.DataSet.Next;
  end;
  Mydm.fansrc.DataSet.First;
end;

procedure TF_policy.Edit5KeyPress(Sender: TObject; var Key: Char);
begin
  if not (key in ['0'..'9',Chr(vk_Back),'.']) then
    key:=#0;
end;

procedure TF_policy.ComboBox1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.ComboBox2KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit5KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.DateTimePicker1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit6KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit1KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit2KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit3KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

procedure TF_policy.Edit4KeyDown(Sender: TObject; var Key: Word;
  Shift: TShiftState);
begin
  if Key=13 then
    selectnext(sender as twincontrol,true,true);
end;

end.