|
|
|
|
unit u_op_close_select;
|
|
|
|
|
|
|
|
|
|
interface
|
|
|
|
|
|
|
|
|
|
uses
|
|
|
|
|
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
|
|
|
|
|
Dialogs, BusinessSkinForm,ADODB, bsSkinCtrls, DB;
|
|
|
|
|
|
|
|
|
|
type
|
|
|
|
|
Tfrm_op_close_select = class(TForm)
|
|
|
|
|
bsBusinessSkinForm1: TbsBusinessSkinForm;
|
|
|
|
|
bsSkinCheckRadioBox1: TbsSkinCheckRadioBox;
|
|
|
|
|
bsSkinCheckRadioBox2: TbsSkinCheckRadioBox;
|
|
|
|
|
bsSkinCheckRadioBox3: TbsSkinCheckRadioBox;
|
|
|
|
|
bsSkinButton1: TbsSkinButton;
|
|
|
|
|
bsSkinButton5: TbsSkinButton;
|
|
|
|
|
yewu: TDataSource;
|
|
|
|
|
accept: TDataSource;
|
|
|
|
|
pay: TDataSource;
|
|
|
|
|
procedure bsSkinButton5Click(Sender: TObject);
|
|
|
|
|
procedure bsSkinButton1Click(Sender: TObject);
|
|
|
|
|
procedure select_feng_all();
|
|
|
|
|
procedure select_feng_op();
|
|
|
|
|
procedure select_feng_fee();
|
|
|
|
|
private
|
|
|
|
|
{ Private declarations }
|
|
|
|
|
public
|
|
|
|
|
{ Public declarations }
|
|
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
var
|
|
|
|
|
frm_op_close_select: Tfrm_op_close_select;
|
|
|
|
|
close_select_num:integer;
|
|
|
|
|
|
|
|
|
|
implementation
|
|
|
|
|
|
|
|
|
|
uses u_main, u_op_seae_close, u_op_seai_close, u_op_aire_close,
|
|
|
|
|
u_op_airi_close, my_sys_chat, u_sys_progress,my_sys_function;
|
|
|
|
|
|
|
|
|
|
{$R *.dfm}
|
|
|
|
|
|
|
|
|
|
procedure Tfrm_op_close_select.select_feng_all();
|
|
|
|
|
var
|
|
|
|
|
i:integer;
|
|
|
|
|
can_do:boolean;
|
|
|
|
|
p_accmonth:TADOQuery;
|
|
|
|
|
dsstr,PostUrl,str:string;
|
|
|
|
|
begin
|
|
|
|
|
case close_select_num of
|
|
|
|
|
1:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
2:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
3:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
4:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
p_accmonth:=createAdoQuery;
|
|
|
|
|
case close_select_num of
|
|
|
|
|
1:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_seae_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_seae_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=now;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
// p_accmonth.Close;
|
|
|
|
|
// p_accmonth.SQL.Text:='exec p_exec_accmonth '''+yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>').AsString+'''';
|
|
|
|
|
// p_accmonth.ExecSQL;
|
|
|
|
|
if (dsstr='') then
|
|
|
|
|
dsstr:=dsstr+'{'
|
|
|
|
|
else dsstr:=dsstr+',{';
|
|
|
|
|
dsstr:=dsstr+'"bookingId":'+ yewu.DataSet.FieldByName('DJYID').asstring;
|
|
|
|
|
dsstr:=dsstr+',"lockStatus":true';
|
|
|
|
|
dsstr:=dsstr+'}';
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>') then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>') then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=now;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
p_accmonth.Close;
|
|
|
|
|
p_accmonth.SQL.Text:='exec p_exec_accmonth '''+yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>').AsString+'''';
|
|
|
|
|
p_accmonth.ExecSQL;
|
|
|
|
|
if (dsstr='') then
|
|
|
|
|
dsstr:=dsstr+'{'
|
|
|
|
|
else dsstr:=dsstr+',{';
|
|
|
|
|
dsstr:=dsstr+'"bookingId":'+ yewu.DataSet.FieldByName('DJYID').asstring;
|
|
|
|
|
dsstr:=dsstr+',"lockStatus":true';
|
|
|
|
|
dsstr:=dsstr+'}';
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if (dsstr<>'') then begin
|
|
|
|
|
str:=str+'[';
|
|
|
|
|
str:=str+dsstr;
|
|
|
|
|
str:=str+']';
|
|
|
|
|
PostUrl:='http://47.104.85.216:12345/DataSync/SaveBookingOrderLock';
|
|
|
|
|
TDsDjyThread.create(PostUrl,str,'','1bccf850845542f89057007e51f78f13','2af5ed1f0cc124bcfc4ba05e4a24eac77f2f582c25737477633a1c0303ac3b8ed647e810880dac58');
|
|
|
|
|
InsertSysLog('<27>ϴ<EFBFBD><CFB4><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ʒ<EFBFBD><C6B7><EFBFBD>',yewu.DataSet.FieldByName('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').asstring);
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
2:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seai_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_seai_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_seai_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
3:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_aire_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_aire_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_aire_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
4:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_airi_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_airi_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_airi_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
FreeAndNil(p_accmonth);
|
|
|
|
|
if frm_sys_progress.showing then begin
|
|
|
|
|
frm_sys_progress.close;
|
|
|
|
|
frm_sys_progress:=nil;
|
|
|
|
|
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
procedure Tfrm_op_close_select.select_feng_op();
|
|
|
|
|
var
|
|
|
|
|
i:integer;
|
|
|
|
|
begin
|
|
|
|
|
|
|
|
|
|
case close_select_num of
|
|
|
|
|
1:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
2:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
3:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
4:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
case close_select_num of
|
|
|
|
|
1:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_seae_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_seae_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
2:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seai_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_seai_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_seai_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
3:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_aire_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_aire_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_aire_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
4:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_airi_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_airi_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_airi_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('ҵ<><D2B5>״̬').asstring<>'ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['ҵ<><D2B5>״̬']:='ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>';
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD><EFBFBD>ҵ<EFBFBD><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'41',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if frm_sys_progress.showing then begin
|
|
|
|
|
frm_sys_progress.close;
|
|
|
|
|
frm_sys_progress:=nil;
|
|
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
procedure Tfrm_op_close_select.select_feng_fee();
|
|
|
|
|
var
|
|
|
|
|
i:integer;
|
|
|
|
|
can_do:boolean;
|
|
|
|
|
p_accmonth:TADOQuery;
|
|
|
|
|
dsstr,PostUrl,str:string;
|
|
|
|
|
begin
|
|
|
|
|
case close_select_num of
|
|
|
|
|
1:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
2:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
3:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
4:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then begin
|
|
|
|
|
if not ASSIGNED(frm_sys_progress) then
|
|
|
|
|
frm_sys_progress:=tfrm_sys_progress.Create(self);
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.ProgressText:='<27><><EFBFBD>ڷ<EFBFBD><DAB7><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ⱥ<C8BA><F2A1A3A1><EFBFBD>';
|
|
|
|
|
frm_sys_progress.Show;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MaxValue:=frm_op_seae_close.dxdbgrid1.SelectedCount;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.MinValue:=0;
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=0;
|
|
|
|
|
frm_sys_progress.Update;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
p_accmonth:=createAdoQuery;
|
|
|
|
|
|
|
|
|
|
case close_select_num of
|
|
|
|
|
1:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seae_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_seae_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_seae_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
p_accmonth.Close;
|
|
|
|
|
p_accmonth.SQL.Text:='exec p_exec_accmonth '''+yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>').AsString+'''';
|
|
|
|
|
p_accmonth.ExecSQL;
|
|
|
|
|
if (dsstr='') then
|
|
|
|
|
dsstr:=dsstr+'{'
|
|
|
|
|
else dsstr:=dsstr+',{';
|
|
|
|
|
dsstr:=dsstr+'"bookingId":'+ yewu.DataSet.FieldByName('DJYID').asstring;
|
|
|
|
|
dsstr:=dsstr+',"lockStatus":true';
|
|
|
|
|
dsstr:=dsstr+'}';
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
p_accmonth.Close;
|
|
|
|
|
p_accmonth.SQL.Text:='exec p_exec_accmonth '''+yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>').AsString+'''';
|
|
|
|
|
p_accmonth.ExecSQL;
|
|
|
|
|
if (dsstr='') then
|
|
|
|
|
dsstr:=dsstr+'{'
|
|
|
|
|
else dsstr:=dsstr+',{';
|
|
|
|
|
dsstr:=dsstr+'"bookingId":'+ yewu.DataSet.FieldByName('DJYID').asstring;
|
|
|
|
|
dsstr:=dsstr+',"lockStatus":true';
|
|
|
|
|
dsstr:=dsstr+'}';
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if (dsstr<>'') then begin
|
|
|
|
|
str:=str+'[';
|
|
|
|
|
str:=str+dsstr;
|
|
|
|
|
str:=str+']';
|
|
|
|
|
PostUrl:='http://47.104.85.216:12345/DataSync/SaveBookingOrderLock';
|
|
|
|
|
TDsDjyThread.create(PostUrl,str,'','1bccf850845542f89057007e51f78f13','2af5ed1f0cc124bcfc4ba05e4a24eac77f2f582c25737477633a1c0303ac3b8ed647e810880dac58');
|
|
|
|
|
InsertSysLog('<27>ϴ<EFBFBD><CFB4><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ʒ<EFBFBD><C6B7><EFBFBD>',yewu.DataSet.FieldByName('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').asstring);
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
2:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_seai_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_seai_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_seai_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>ᵥ<EFBFBD><E1B5A5>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>ᵥ<EFBFBD><E1B5A5>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
3:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_aire_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_aire_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_aire_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˳<EFBFBD><CBB3>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
4:
|
|
|
|
|
begin
|
|
|
|
|
if frm_op_airi_close.dxdbgrid1.SelectedCount>=1 then
|
|
|
|
|
begin
|
|
|
|
|
for i:=0 to frm_op_airi_close.dxdbgrid1.SelectedCount-1 do
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.GotoBookmark(pointer(frm_op_airi_close.dxdbgrid1.selectedrows[i]));
|
|
|
|
|
frm_sys_progress.bsSkinGauge1.Value:=frm_sys_progress.bsSkinGauge1.Value+1;
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end
|
|
|
|
|
else
|
|
|
|
|
begin
|
|
|
|
|
if yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>' then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=true;
|
|
|
|
|
accept.DataSet.first;
|
|
|
|
|
while not accept.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(accept.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
accept.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
pay.DataSet.first;
|
|
|
|
|
while not pay.DataSet.eof do
|
|
|
|
|
begin
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
if (pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD>ͨ<EFBFBD><CDA8>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD>ֽ<EFBFBD><D6BD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹɾ<D6B9><C9BE>') and
|
|
|
|
|
(pay.DataSet.FieldByName('<27><><EFBFBD><EFBFBD>״̬').asstring<>'<27><>ֹ<EFBFBD><EFBFBD>')then
|
|
|
|
|
begin
|
|
|
|
|
can_do:=false;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
pay.DataSet.next;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
if can_do then
|
|
|
|
|
begin
|
|
|
|
|
yewu.DataSet.edit;
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD><EFBFBD>״̬']:='<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD>';
|
|
|
|
|
yewu.DataSet['<27><><EFBFBD>÷<EFBFBD><C3B7><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>']:=date;
|
|
|
|
|
yewu.DataSet.post;
|
|
|
|
|
{
|
|
|
|
|
Send_op_do('<27><><EFBFBD>˽<EFBFBD><CBBD>ڷ<EFBFBD><DAB7>÷<EFBFBD><C3B7><EFBFBD>,ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>:'+yewu.DataSet.fieldbyname('ҵ<><D2B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString
|
|
|
|
|
+',<2C><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>:'+yewu.DataSet.fieldbyname('<27><><EFBFBD>˵<EFBFBD><CBB5><EFBFBD>').AsString,'42',
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27>ͷ<EFBFBD>Ա').AsString,
|
|
|
|
|
yewu.DataSet.fieldbyname('<27><><EFBFBD><EFBFBD><EFBFBD><EFBFBD>').AsString);
|
|
|
|
|
}
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
FreeAndNil(p_accmonth);
|
|
|
|
|
if frm_sys_progress.showing then begin
|
|
|
|
|
frm_sys_progress.close;
|
|
|
|
|
frm_sys_progress:=nil;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
procedure Tfrm_op_close_select.bsSkinButton5Click(Sender: TObject);
|
|
|
|
|
begin
|
|
|
|
|
close;
|
|
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
procedure Tfrm_op_close_select.bsSkinButton1Click(Sender: TObject);
|
|
|
|
|
begin
|
|
|
|
|
if bsSkinCheckRadioBox3.Checked then
|
|
|
|
|
begin
|
|
|
|
|
frm_op_close_select.select_feng_all();
|
|
|
|
|
close;
|
|
|
|
|
exit;
|
|
|
|
|
end;
|
|
|
|
|
if bsSkinCheckRadioBox1.Checked then
|
|
|
|
|
begin
|
|
|
|
|
frm_op_close_select.select_feng_op();
|
|
|
|
|
close;
|
|
|
|
|
exit;
|
|
|
|
|
end;
|
|
|
|
|
if bsSkinCheckRadioBox2.Checked then
|
|
|
|
|
begin
|
|
|
|
|
frm_op_close_select.select_feng_fee();
|
|
|
|
|
close;
|
|
|
|
|
exit;
|
|
|
|
|
end;
|
|
|
|
|
end;
|
|
|
|
|
|
|
|
|
|
end.
|