|

楼主 |
发表于 2007-6-4 16:37:55
|
显示全部楼层
如图, 我把自定义数据集删除后又重新赋值
图,的数据不对, 表的数据是对的.请帮我看看是怎么回事,图和表连的是一个数据集(自定义数据集)
//chart buyer
dataSetBuyer := DataSetBrokerJBXXBuyer.DataSet as TSQLDataSet;
if not dataSetBuyer.Active then
dataSetBuyer.Open;
if not DataSetBrokerMyBuyer.DataSet.Active then
DataSetBrokerMyBuyer.DataSet.Open;
//delete DataSetBrokerMyBuyer data
if not DataSetBrokerMyBuyer.DataSet.IsEmpty then
begin
DataSetBrokerMyBuyer.DataSet.First;
while not DataSetBrokerMyBuyer.DataSet.Eof do
begin
DataSetBrokerMyBuyer.DataSet.Delete;
end;
end;
DataSetBrokerMyBuyer.DataSet.Close;
DataSetBrokerMyBuyer.DataSet.Open;
dataSetBuyer.First;
for i:=0 to dataSetBuyer.RecordCount-1 do
begin
buyer := dataSetBuyer.FieldByName('BUYER').AsString;
quantity := dataSetBuyer.FieldByName('QUANTITY').AsInteger;
if buyer = tempName then
begin
sumQuantity := sumQuantity + quantity;
tempName := buyer;
if i = dataSetBuyer.RecordCount-1 then
begin
DataSetBrokerMyBuyer.DataSet.Append;
DataSetBrokerMyBuyer.DataSet.FieldByName('GDF').AsString := tempName;
DataSetBrokerMyBuyer.DataSet.FieldByName('ZDL').AsInteger := sumQuantity;
DataSetBrokerMyBuyer.DataSet.ApplyUpdates;
end;
end
else
begin
if i > 0 then
begin
DataSetBrokerMyBuyer.DataSet.Append;
DataSetBrokerMyBuyer.DataSet.FieldByName('GDF').AsString := tempName;
DataSetBrokerMyBuyer.DataSet.FieldByName('ZDL').AsInteger := sumQuantity;
DataSetBrokerMyBuyer.DataSet.ApplyUpdates;
end;
if i = dataSetBuyer.RecordCount-1 then
begin
DataSetBrokerMyBuyer.DataSet.Append;
DataSetBrokerMyBuyer.DataSet.FieldByName('GDF').AsString := buyer;
DataSetBrokerMyBuyer.DataSet.FieldByName('ZDL').AsInteger := quantity;
DataSetBrokerMyBuyer.DataSet.ApplyUpdates;
end;
tempName := buyer;
sumQuantity := quantity;
end;
dataSetBuyer.Next;
end;
|
|