kill.pas

结于初学者来说这对数据库是一个很好的例子

unit kill;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Mask, Buttons, Grids, DBGrids, DB, DBTables, ExtCtrls,
  DBCtrls;

type
  TForm17 = class(TForm)
    Label1: TLabel;
    GroupBox1: TGroupBox;
    GroupBox2: TGroupBox;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label2: TLabel;
    Button1: TButton;
    In_khbh: TEdit;
    In_khmc: TEdit;
    In_je: TMaskEdit;
    In_lxff: TEdit;
    In_bz: TEdit;
    SpeedButton1: TSpeedButton;
    T_kill: TTable;
    DS_kill: TDataSource;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label12: TLabel;
    Q_search: TQuery;
    Q_repeat: TQuery;
    procedure SpeedButton1Click(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure In_khbhKeyPress(Sender: TObject; var Key: Char);
    procedure In_khmcKeyPress(Sender: TObject; var Key: Char);
    procedure In_jeKeyPress(Sender: TObject; var Key: Char);
    procedure In_lxffKeyPress(Sender: TObject; var Key: Char);
    procedure In_bzKeyPress(Sender: TObject; var Key: Char);
    procedure In_khbhExit(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form17: TForm17;

implementation

{$R *.dfm}

procedure TForm17.SpeedButton1Click(Sender: TObject);
begin
  close;
end;

procedure TForm17.Button1Click(Sender: TObject);
 var dzbh:string;
begin
 if (length(In_je.text)=0) or (length(In_khbh.text)=0) or (length(In_khmc.Text)=0) or (length(In_lxff.Text)=0) or (length(In_bz.Text)=0) then
  begin
   MessageDlg('输入不能为空，请重新输入！',mtError,[mbok],0);
   end
  else
   begin
    dzbh:=In_khbh.Text;
//判断是否是续存金额
    Q_search.SQL.Clear;
    Q_search.SQL.Add('select * from VipInfo where UserNo='''+dzbh+'''');
    Q_search.Open;
    if Q_search.Eof then
    begin
      T_kill.Open;
      T_kill.AppendRecord([In_khbh.text,In_khmc.text,In_lxff.text,StrToFloat(In_je.Text),In_bz.text]);
      T_kill.Close;
      T_kill.Open;
      T_kill.Active:=True;
    end
    else
    begin
     Q_search.Edit;
     Q_search['TotalMoney']:=Q_search['TotalMoney']+StrToFloat(In_je.Text);
     Q_search.Post;
     Q_search.Close;
     T_kill.Active:=False; 
     T_kill.Open;
     T_kill.Active:=True;
    end;
    end;
end;

procedure TForm17.In_khbhKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm17.In_khmcKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm17.In_jeKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm17.In_lxffKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm17.In_bzKeyPress(Sender: TObject; var Key: Char);
begin
 if key=#13 then
 begin
    key:=#0;
    perform(WM_NEXTDLGCTL,0,0);
 end;
end;

procedure TForm17.In_khbhExit(Sender: TObject);
begin
  Q_repeat.Close;
  Q_repeat.SQL.Clear;
  Q_repeat.SQL.Add('select * from VIPInfo where UserNo='''+In_khbh.Text+'''');
  Q_repeat.Open;
  if not Q_repeat.Eof then
    begin
      In_khbh.Clear;
      In_khbh.SetFocus;
      MessageDlg('您输入的编号有重复，请重新输入！',mtError,[mbok],0);
    end;
end;

end.