发生时间: 2014-09-18 11:05:07
错误编号: BOS_ExecuteReader
错误信息: 在应使用条件的上下文(在 'AND' 附近)中指定了非布尔类型的表达式。
Sql语句: SELECT * FROM (SELECT t0.FUSEORGID fuseorgid_id, t0.FNUMBER fnumber, t0_L.FNAME fname, t0_L.FSPECIFICATION fspecification, t0.FDOCUMENTSTATUS fdocumentstatus, t0.FFORBIDSTATUS fforbidstatus, t0.FUSEORGID fuseorgid, t0.FMATERIALGROUP fmaterialgroup, t0.FMATERIALID fmaterialid, t0.FMASTERID fmasterid, ROW_NUMBER() OVER( ORDER BY t02_L.FNAME ASC, t0.FNUMBER ASC) fidentityid FROM T_BD_MATERIAL t0 LEFT OUTER JOIN T_BD_MATERIAL_L t0_L ON (t0.FMATERIALID = t0_L.FMATERIALID AND t0_L.FLocaleId = 2052) LEFT OUTER JOIN T_ORG_Organizations_L t02_L ON (t0.FUSEORGID = t02_L.FOrgID AND t02_L.FLocaleId = 2052) WHERE (((((
SELECT * FROM t_BD_MaterialStock WHERE (FDEFAULTVENDORID > 'dslfjdsjf'
这个是我自己写的
)
) AND (t0.FDOCUMENTSTATUS = 'C' AND t0.FFORBIDSTATUS = 'A')) AND t0.FFORBIDSTATUS = 'A') AND t0.FUSEORGID = 100001) AND t0.FUSEORGID = 100001)) tlist WHERE ((fidentityid >= 1) AND (fidentityid <= 200))
===================================================
调用堆栈:
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteReader(DbCommand command, IEnumerable`1 paramList, CommandBehavior cmdBehavior)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteReader(Context ctx, String strSQL, IEnumerable`1 paramList, CommandType cmdtype, CommandBehavior cmdBehavior)
在 Kingdee.BOS.App.Data.DBUtils.ExecuteObject[T](Context ctx, String strSQL, IDataEntityType dt, IDictionary`2 propertyTypeMaps, CommandType cmdType, SqlParam[] paramList)
在 Kingdee.BOS.App.Core.ListDataService.GetData(Context ctx, String sql, DynamicObjectType dt)
Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.IListDataServices.GetData(Context ctx, String sql, DynamicObjectType dt)
在 Kingdee.BOS.ServiceHelper.ListDataServiceHelper.GetData(Context ctx, String sql, DynamicObjectType dt)
在 Kingdee.BOS.Model.List.DataAccessPolicy.DirectSQLDataAccessTreeList.GetTreeListData(Int32 start, Int32 rows, FormGroup group, String groupAliasName, Boolean displayChildData)
在 Kingdee.BOS.Model.List.TreeListModel.GetDataByDirectSQL(Int32 start, Int32 rows)
在 Kingdee.BOS.Model.List.ListModel.GetData(Int32 start, Int32 rows, Boolean needRefreshTree)
在 Kingdee.BOS.Web.List.ListView.GetDataByPermission(Int32 startRow, Int32 limit, FormOperationEnum operatioEnum, String groupRows, String permissionItemId)
在 Kingdee.BOS.Web.List.ListView.GetData(Int32 startRow, Int32 limit, String groupRows)
求救,什么原因
推荐阅读