ufrmhyrene.pas

一个会议签到系统

unit uFrmHYRenE;

interface

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

type
  TFrmHYRenE = class(TForm)
    BitBtn1: TBitBtn;
    BitBtn2: TBitBtn;
    Panel1: TPanel;
    Label1: TLabel;
    DBEdit1: TDBEdit;
    DataSource1: TDataSource;
    Label2: TLabel;
    DBEdit2: TDBEdit;
    Label4: TLabel;
    DBEdit4: TDBEdit;
    Label5: TLabel;
    DBEdit5: TDBEdit;
    Label6: TLabel;
    DBEdit6: TDBEdit;
    Label7: TLabel;
    DBEdit7: TDBEdit;
    Label8: TLabel;
    DBEdit8: TDBEdit;
    Label11: TLabel;
    DBEdit11: TDBEdit;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    DBEdit14: TDBEdit;
    DBComboBox1: TDBComboBox;
    DBComboBox2: TDBComboBox;
    DBEdit3: TDBEdit;
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure FormShortCut(var Msg: TWMKey; var Handled: Boolean);
  private
    { Private declarations }
  public
    Procedure PSave();
    { Public declarations }
  end;

var
  FrmHYRenE: TFrmHYRenE;

implementation

uses uFunSys, uDMOA;

{$R *.dfm}

procedure TFrmHYRenE.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action:=caFree;
  FrmHYRenE:=nil;
end;

procedure TFrmHYRenE.BitBtn2Click(Sender: TObject);
begin
  DataSource1.DataSet.Cancel;   
  Close;
end;

procedure TFrmHYRenE.BitBtn1Click(Sender: TObject);
begin
  DataSource1.DataSet.Post;
  PSave();
  CLose; 
end;

procedure TFrmHYRenE.PSave;
var
  Str,S:String;
  ID,sHYBM,sFZ,sCHLB,sZC,sBZ:String;
begin
  Str:='Delete From TAD03_HYCJR Where ID ='+''''+DBEdit1.text+''''
      +' And sHYBM ='+''''+Trim(DBEdit3.text)+'''';
  ID:=DBEdit1.Text;
  sHYBM:=Trim(DBEdit3.Text);
  sFZ:=DBComboBox1.Text;
  sCHLB:=DBComboBox2.Text;
  sZC:=DBEdit14.Text;
  sBZ:=DBEdit11.Text;
          
  S:=FCreateInSertOneSQL(['ID','sHYBM','sFZ','sCHLB','sZC','sBZ'],
                         [ID,sHYBM,sFZ,sCHLB,sZC,sBZ],
                         [0,1,2,3,4,5],'TAD03_HYCJR');
  Str:=Str+ ' '+S;
  FCarryOutSQL(nil,Str,False);

end;

procedure TFrmHYRenE.FormShortCut(var Msg: TWMKey; var Handled: Boolean);
begin
  if Msg.CharCode = 13 then BitBtn1.SetFocus;  
end;

end.