【delphi开源代码栏目提醒】:网学会员delphi开源代码为您提供bjgunit.pas参考,解决您在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.
上一篇:
bjgqkunit.pas
下一篇:
临床前药物安全性评价中毒性病理学新技术的应用