|

楼主 |
发表于 2008-7-3 17:25:38
|
显示全部楼层
我把代码 贴出来把,这段代码是写在业务信息里的
Procedure TYWXX_NBLL.UpdateTzxxb(DataSet:TDataSet);
var
length:Integer;
wzbm:string;
wzbms:string;
wzbms2:string;
gsbm:string;
flag3:Boolean;
begin
gsbm:=DataSetNBLLDJB.FieldByName('gsbm').AsString;
DataSetTZ.Open;
try
DataSetNBLLDXB.DisableControls;
DataSetNBLLDXB.First;
while not DataSetNBLLDXB.Eof do
begin
wzbm:=DataSetNBLLDXB.FieldByName('wzbm').AsString;
DataSetNBLLDXB.Next;
wzbms:=''+wzbm+''+','+wzbms;
end;
wzbms:='('+wzbms+')';
length:=wzbms.Length;
wzbms2:=wzbms.Substring(0,length-2)+wzbms.Substring(length-1,1);
DataSetWZKC.SQL.Text:='select * from zbmroler.wzkcxxb where wzbm in '+wzbms2+' and gsbm='''+gsbm+'''';
DataSetWZKC.Open;
while not DataSetNBLLDXB.Eof do
begin
wzbm:=DataSetNBLLDXB.FieldByName('wzbm').AsString;
DataSetTZ.Append;
DataSetTZ.FieldByName('pzbm').AsString:=DataSetNBLLDJB.FieldByName('nblldbm').AsString;
DataSetTZ.FieldByName('wzbm').AsString:=DataSetNBLLDXB.FieldByName('wzbm').AsString;
DataSetTZ.FieldByName('sfbz').AsString:='1';
DataSetTZ.FieldByName('srsl').AsString:='0';
DataSetTZ.FieldByName('fcsl').AsString:=DataSetNBLLDXB.FieldByName('slsl').AsString;
DataSetTZ.FieldByName('gsbm').AsString:=gsbm;
DataSetTZ.FieldByName('pzgldmbbm').AsString:='005';
DataSetTZ.FieldByName('pzmcbm').AsString:='001';
DataSetTZ.FieldByName('cbdj').AsFloat:=DataSetNBLLDXB.FieldByName('sjdj').AsFloat;
DataSetTZ.FieldByName('pjbm').AsString:=DataSetNBLLDJB.FieldByName('pjbm').AsString;
DataSetTZ.FieldByName('je').AsFloat:=DataSetNBLLDXB.FieldByName('je').AsFloat;
flag3:=DataSetWZKC.Locate('wzbm',[wzbm],[]);
if flag3 then
begin
DataSetTZ.FieldByName('jcsl').AsFloat:=DataSetWZKC.FieldByName('kcsl').AsFloat-DataSetNBLLDXB.FieldByName('slsl').AsFloat;
DataSetTZ.FieldByName('jcje').AsFloat:=DataSetWZKC.FieldByName('zje').AsFloat-DataSetNBLLDXB.FieldByName('je').AsFloat;
DataSetTZ.FieldByName('sjkcsl').AsFloat:=DataSetWZKC.FieldByName('sjkcsl').AsFloat-DataSetNBLLDXB.FieldByName('sjkcsl').AsFloat;
end;
DataSetTZ.Post;
DataSetNBLLDXB.Next;
end;
finally
DataSetNBLLDXB.EnableControls;
end;
end; |
|