bjgunit.pas

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

unit bjgunit;

interface

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

type
  Tbjg = class(TForm)
    Bevel1: TBevel;
    Label1: TLabel;
    ComboBox1: TComboBox;
    ComboBox3: TComboBox;
    Label3: TLabel;
    Button1: TButton;
    qry: TQuery;
    DataSource1: TDataSource;
    procedure FormCreate(Sender: TObject);
    procedure ComboBox1Change(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  bjg: Tbjg;

implementation

uses bjgqkunit;



{$R *.dfm}

procedure Tbjg.FormCreate(Sender: TObject);
begin
combobox1.Items.clear;
with datamodule1.qry_bjg do
begin
 close;
 sql.clear;
 sql.add('select * from zyb0') ;
 open;
 first;

if recordcount>0 then
// combobox1.text:=Fields[1].asstring;
repeat
 combobox1.items.add(fields[1].asstring);
 until findnext=false;
end;
end;

procedure Tbjg.ComboBox1Change(Sender: TObject);
begin
combobox3.Items.clear;
with datamodule1.qry_bjg do
begin
close;
sql.Clear;
sql.add('select distinct kcbh from cjb0 where bjh0 in (select  bjh0 from bjb0 where zymc=:id)');   //select distinct kcmc from cjb0 where bjh0=:name??????

parambyname('id').asstring:=combobox1.text;
execsql;

active:=true;
if recordcount>0 then
// combobox2.text:=Fields[0].asstring;
repeat
 combobox3.items.add(fields[0].asstring);
 until findnext=false;
end;
end;

procedure Tbjg.Button1Click(Sender: TObject);
var i:integer;
begin

with datamodule1.qry_bjg do
begin
close;
sql.Clear ;
sql.add('delete bjgtemp');
execsql;

sql.Clear ;
sql.Add('insert into bjgtemp(bjh0) select distinct bjb0.bjh0 from cjb0,bjb0 where (cjb0.bjh0=bjb0.bjh0) and (cjb0.kcbh=:name) and (bjb0.zymc=:dd)');
parambyname('name').asstring:=combobox3.text;
parambyname('dd').asstring:=combobox1.text;
execsql;

sql.Clear ;
sql.add('select * from bjgtemp');
execsql;
open;
first;
while not datamodule1.qry_bjg.eof do
begin
i:=0;
with qry do
begin
close;
sql.Clear ;
sql.add('select * from cjb0 where kcbh=:name and bjh0=:id and cj00<60');
parambyname('name').asstring:=combobox3.text;
parambyname('id').AsString:=datamodule1.qry_bjg.Fields[0].asstring;

open;

first;
while not qry.eof do
begin
i:=i+1;
qry.next;
end;
sql.clear;
sql.add('update bjgtemp set rs00=:rs where bjh0=:id');
parambyname('rs').AsInteger:=i;
parambyname('id').asstring:=datamodule1.qry_bjg.Fields[0].asstring;
execsql;
end;

datamodule1.qry_bjg.next;
end;

end;
bjgqk:=tbjgqk.create(self);
bjgqk.showmodal;
end;

end.