rstempunit.pas

高校学生学籍管理系统源码

unit rstempunit;

interface

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

type
  Trstemp = class(TForm)
    ToolBar1: TToolBar;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Panel1: TPanel;
    DBGrid1: TDBGrid;
    Edit1: TEdit;
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  rstemp: Trstemp;

implementation

uses zyrsunit;

{$R *.dfm}

procedure Trstemp.Button2Click(Sender: TObject);
begin
if application.MessageBox('确实要删除这条记录吗?','提示',mb_okcancel+mb_iconinformation)=id_ok then
with datamodule1.qry_rstemp do
 if isempty=false then
  delete;
//application.MessageBox('','提示',mb_ok+mb_iconinformation);
with DataModule1.qry_zyrs do
begin
close;
sql.Clear ;
sql.add('select * from zyb0 where zyh0=:id');
parambyname('id').AsString:=edit1.text;
execsql;
open;
edit;
zyrs.dbgrid1.SelectedField.asinteger:=zyrs.dbgrid1.SelectedField.asinteger-1 ;
post;


end;

end;

procedure Trstemp.Button3Click(Sender: TObject);
begin
datamodule1.qry_rstemp.edit;
datamodule1.qry_rstemp.Post;
datamodule1.qry_rstemp.close;
datamodule1.qry_rstemp.Open;
end;

procedure Trstemp.Button4Click(Sender: TObject);
begin
close;
end;

procedure Trstemp.FormClose(Sender: TObject; var Action: TCloseAction);
begin
//datamodule1.qry_rstemp.RequestLive:=false;
zyrs.Close;

end;

procedure Trstemp.FormCreate(Sender: TObject);
begin
//datamodule1.qry_rstemp.RequestLive:=true;
end;

end.