You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
105 lines
2.9 KiB
Plaintext
105 lines
2.9 KiB
Plaintext
unit u_clear;
|
|
|
|
interface
|
|
|
|
uses
|
|
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
|
|
Dialogs, StdCtrls, bsSkinCtrls, DB, ADODB;
|
|
|
|
type
|
|
TForm1 = class(TForm)
|
|
Button1: TButton;
|
|
bsSkinGauge1: TbsSkinGauge;
|
|
ADOConnection1: TADOConnection;
|
|
ADOQuery1: TADOQuery;
|
|
ADOStoredProc1: TADOStoredProc;
|
|
procedure ADOConnection1BeforeConnect(Sender: TObject);
|
|
procedure Button1Click(Sender: TObject);
|
|
private
|
|
{ Private declarations }
|
|
public
|
|
{ Public declarations }
|
|
end;
|
|
|
|
var
|
|
Form1: TForm1;
|
|
|
|
implementation
|
|
|
|
{$R *.dfm}
|
|
|
|
procedure TForm1.ADOConnection1BeforeConnect(Sender: TObject);
|
|
begin
|
|
ADOConnection1.ConnectionString:='FILE NAME='+ExtractFilePath(ParamStr(0))+'sql.udl';
|
|
end;
|
|
|
|
procedure TForm1.Button1Click(Sender: TObject);
|
|
begin
|
|
ADOQuery1.Close;
|
|
ADOQuery1.sql.clear;
|
|
ADOQuery1.sql.add('select 񅧏 from t_op_seae where 񅧏 not in (select 񅧏 from t_op_gain)');
|
|
ADOQuery1.open;
|
|
bsSkinGauge1.Value:=ADOQuery1.RecordCount+1;
|
|
bsSkinGauge1.Value:=0;
|
|
ADOQuery1.First;
|
|
bsSkinGauge1.Value:=bsSkinGauge1.Value+1;
|
|
while not ADOQuery1.eof do
|
|
begin
|
|
ADOStoredProc1.Parameters.ParamByName('con_no').value:=ADOQuery1.fieldbyname('񅧏').asstring;
|
|
ADOStoredProc1.ExecProc;
|
|
bsSkinGauge1.Value:=bsSkinGauge1.Value+1;
|
|
ADOQuery1.next;
|
|
end;
|
|
|
|
ADOQuery1.Close;
|
|
ADOQuery1.sql.clear;
|
|
ADOQuery1.sql.add('select 񅧏 from t_op_seai where 񅧏 not in (select 񅧏 from t_op_gain)');
|
|
ADOQuery1.open;
|
|
bsSkinGauge1.Value:=ADOQuery1.RecordCount+1;
|
|
bsSkinGauge1.Value:=0;
|
|
ADOQuery1.First;
|
|
bsSkinGauge1.Value:=bsSkinGauge1.Value+1;
|
|
while not ADOQuery1.eof do
|
|
begin
|
|
ADOStoredProc1.Parameters.ParamByName('con_no').value:=ADOQuery1.fieldbyname('񅧏').asstring;
|
|
ADOStoredProc1.ExecProc;
|
|
bsSkinGauge1.Value:=bsSkinGauge1.Value+1;
|
|
ADOQuery1.next;
|
|
end;
|
|
|
|
ADOQuery1.Close;
|
|
ADOQuery1.sql.clear;
|
|
ADOQuery1.sql.add('select 񅧏 from t_op_aire where 񅧏 not in (select 񅧏 from t_op_gain)');
|
|
ADOQuery1.open;
|
|
bsSkinGauge1.Value:=ADOQuery1.RecordCount+1;
|
|
bsSkinGauge1.Value:=0;
|
|
ADOQuery1.First;
|
|
bsSkinGauge1.Value:=bsSkinGauge1.Value+1;
|
|
while not ADOQuery1.eof do
|
|
begin
|
|
ADOStoredProc1.Parameters.ParamByName('con_no').value:=ADOQuery1.fieldbyname('񅧏').asstring;
|
|
ADOStoredProc1.ExecProc;
|
|
bsSkinGauge1.Value:=bsSkinGauge1.Value+1;
|
|
ADOQuery1.next;
|
|
end;
|
|
|
|
ADOQuery1.Close;
|
|
ADOQuery1.sql.clear;
|
|
ADOQuery1.sql.add('select 񅧏 from t_op_airi where 񅧏 not in (select 񅧏 from t_op_gain)');
|
|
ADOQuery1.open;
|
|
bsSkinGauge1.Value:=ADOQuery1.RecordCount+1;
|
|
bsSkinGauge1.Value:=0;
|
|
ADOQuery1.First;
|
|
bsSkinGauge1.Value:=bsSkinGauge1.Value+1;
|
|
while not ADOQuery1.eof do
|
|
begin
|
|
ADOStoredProc1.Parameters.ParamByName('con_no').value:=ADOQuery1.fieldbyname('񅧏').asstring;
|
|
ADOStoredProc1.ExecProc;
|
|
bsSkinGauge1.Value:=bsSkinGauge1.Value+1;
|
|
ADOQuery1.next;
|
|
end;
|
|
showmessage('ok');
|
|
end;
|
|
|
|
end.
|