[K/3Cloud]DBServiceHelper.ExecuteDataSet(this.Context, sql)) 返回数据问题

例如下面代码:

int sQty = 0;
string sql = string.Format(@" Select FMATERIALID ,FBASEUNITID ,FAUXPROPID ,FLOT,FSTOCKID ,FBASEQTY FStockQty,FSECQTY FStockUnitQty," +
" FBASEQTY FLockQty,FSECQTY FLockUnitQty,FBASEQTY FUseQty,FSECQTY FUseUnitQty from T_STK_INVENTORY " +
" Where FBASEQTY>{0}", sQty);
using (DataSet ds = DBServiceHelper.ExecuteDataSet(this.Context, sql))

执行后无论WHERE 条件是什么总返回15行数据。

解决办法是:不要用这个接口,这个是废弃的接口,用ExecuteDynamicObject。

原文地址:https://www.cnblogs.com/fyq891014/p/3308525.html