unit cjxgtempunit;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls;

type
  Tcjxgtemp = class(TForm)
    Panel1: TPanel;
    Edit1: TEdit;
    Label1: TLabel;
    Edit2: TEdit;
    Label2: TLabel;
    Button1: TButton;
    ComboBox1: TComboBox;
    Label3: TLabel;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  cjxgtemp: Tcjxgtemp;

implementation

uses datadomule, cjxgunit;

{$R *.dfm}

procedure Tcjxgtemp.Button1Click(Sender: TObject);
begin
if combobox1.text='普通考試' then
begin
with datamodule1.qry_cjxg do
begin
close;
sql.clear;
sql.add('select * from cjb0 where xsxh_id=:id and kcbh=:bh');
parambyname('id').asstring:=edit1.text;
parambyname('bh').asstring:=edit2.text;


 open;
if recordcount=0 then
begin
application.MessageBox('沒(méi)有該學(xué)生的信息，請(qǐng)檢查輸入是否正確！','提示',mb_ok+mb_iconinformation);
exit;
end;
end;
end;



if combobox1.text='補(bǔ)考' then
begin
with datamodule1.qry_cjxg do
begin
close;
sql.clear;
sql.add('select * from bkcj where xsxh_id=:id and kcbh=:bh');
parambyname('id').asstring:=edit1.text;
parambyname('bh').asstring:=edit2.text;
open;
if recordcount=0 then
begin
application.MessageBox('沒(méi)有該學(xué)生的信息，請(qǐng)檢查輸入是否正確！','提示',mb_ok+mb_iconinformation);
exit;
end;
end;
end;


if combobox1.text='重修考試' then
begin
with datamodule1.qry_cjxg do
begin
close;
sql.clear;
sql.add('select * from cxcj where xsxh_id=:id and kcbh=:bh');
parambyname('id').asstring:=edit1.text;
parambyname('bh').asstring:=edit2.text;
open;
if recordcount=0 then
begin
application.MessageBox('沒(méi)有該學(xué)生的信息，請(qǐng)檢查輸入是否正確！','提示',mb_ok+mb_iconinformation);
exit;
end;
end;
end;


cjxg:=tcjxg.create(self);
cjxg.showmodal;
end;

end.