unit34.pas

人寿保险的管理信息系统

unit Unit34;

interface

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

type
  TF_billcha = class(TForm)
    Panel1: TPanel;
    SpeedButton1: TSpeedButton;
    SpeedButton2: TSpeedButton;
    SpeedButton3: TSpeedButton;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    Label1: TLabel;
    Edit1: TEdit;
    Label2: TLabel;
    Edit2: TEdit;
    Button1: TButton;
    Button2: TButton;
    Panel3: TPanel;
    Label3: TLabel;
    Label4: TLabel;
    RvProject6: TRvProject;
    RvDataSetConnection6: TRvDataSetConnection;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure SpeedButton3Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure Edit1Change(Sender: TObject);
    procedure SpeedButton1Click(Sender: TObject);
    procedure SpeedButton2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  F_billcha: TF_billcha;

implementation
  Uses Unit11;
{$R *.dfm}

procedure TF_billcha.Button1Click(Sender: TObject);
begin
  //查出满足要求的缴费记录
  with Mydm.billQuery do
  begin
    Close;
    with SQL do
    begin
      Clear;
      Add('select*from bill');
      Add('where policy_id=:p');
    end;
    Parameters[0].Value:=trim(edit1.Text);
    Prepared;
    Open;
    Button1.Enabled:=false;
  end;
  //统计缴费总额
  with Mydm.billsumQuery do
  begin
    Close;
    with SQL do
    begin
      Clear;
      Add('select sum(Bill_Money) from bill');
      Add('where policy_id=:p');
    end;
    Parameters[0].Value:=trim(edit1.Text);
    Prepared;
    Open;
  end;
  //显示交费总额
 Label4.Visible:=True;
 Label4.Caption:=Mydm.billsumQuery.Fields[0].AsString;
 edit1.Clear;
end;

procedure TF_billcha.Button2Click(Sender: TObject);
begin
  with Mydm.billQuery do
  begin
    Close;
    with SQL do
    begin
      Clear;
      Add('select*from bill');
      Add('where bill_id=:p');
    end;
    Parameters[0].Value:=trim(edit2.Text);
    Prepared;
    Open;
    edit2.Clear;
   end;
   label4.Caption:='';
end;

procedure TF_billcha.SpeedButton3Click(Sender: TObject);
begin
  close;
end;

procedure TF_billcha.FormShow(Sender: TObject);
begin
  with mydm.billQuery do
  begin
    close;
    with sql do
    begin
      clear;
      add('select*from bill');
    end;
    open;
  end;
  label4.Caption:='';
  edit1.Clear;
  edit2.Clear;
end;

procedure TF_billcha.Edit1Change(Sender: TObject);
begin
   Button1.Enabled:=true;
end;

procedure TF_billcha.SpeedButton1Click(Sender: TObject);
begin
    Rvproject6.Execute;
end;

procedure TF_billcha.SpeedButton2Click(Sender: TObject);
begin
  if Application.MessageBox('是否删除？','提示',mb_yesno)=6 then
  begin
    try
      mydm.billsrc.DataSet.Delete;
    except//如果删除不成功将弹出以下对会框
      Application.MessageBox('删除不成功!','提示',mb_ok);
    end;
  end;
end;

end.