版本6.1补丁1月23号
SELECT tmp.FFLEX9, tmp.FFLEX9_number, tmp.FFLEX9_name, tmp.FFLEX9_fullparentid, tmp.FFLEX9_isgroup FROM (SELECT DISTINCT f.fid fdetailid, t_FFLEX9.FFLEX9, t_FFLEX9.FFLEX9_number, t_FFLEX9.FFLEX9_name, t_FFLEX9.FFLEX9_fullparentid, t_FFLEX9.FFLEX9_isgroup FROM (SELECT detailv.fid, detailv.FFLEX9, ((ISNULL(FFLEX9_dvlt.FFULLPARENTID, '.') + '.') + CONVERT(VARCHAR(8000), detailv.FFLEX9)) fflex9_fullparentid FROM t_bd_flexitemdetailv detailv LEFT OUTER JOIN T_BD_EXPENSE FFLEX9_dvt ON detailv.FFLEX9 = FFLEX9_dvt.FMasterId LEFT OUTER JOIN T_BD_EXPENSE_GROUPLEVEL FFLEX9_dvlt ON FFLEX9_dvt.FGROUP = FFLEX9_dvlt.fid) f INNER JOIN (SELECT f.FEXPID fflex9, f.FNUMBER fflex9_number, f_l.FNAME fflex9_name, f.FFULLPARENTID fflex9_fullparentid, 0 fflex9_isgroup, f.FLEVEL fflex9_level FROM (SELECT CONVERT(VARCHAR(8000), FMasterId) fexpid, CONVERT(VARCHAR(8000), ff.FNUMBER) fnumber, CONVERT(VARCHAR(8000), FDocumentStatus) fdocumentstatus, CONVERT(VARCHAR(8000), FForbidStatus) fforbidstatus, CONVERT(VARCHAR(8000), ((ISNULL(gpl.FFULLPARENTID, '.') + '.') + CONVERT(VARCHAR(8000), min(ff.FMasterId)))) ffullparentid, (ISNULL(gpl.flevel, 0) + 1) flevel FROM T_BD_EXPENSE ff LEFT OUTER JOIN T_BD_EXPENSE_GROUPLEVEL gpl ON gpl.fid = ff.FGROUP WHERE ((0 = 0 AND ((FDocumentStatus != 'A') AND (FDocumentStatus != 'Z'))) AND FFORBIDSTATUS = 'A') UNION SELECT DISTINCT CONVERT(VARCHAR(8000), 0) fexpid, CONVERT(VARCHAR(8000), 'ZZZZZZ') fnumber, CONVERT(VARCHAR(8000), 'C') fdocumentstatus, CONVERT(VARCHAR(8000), 'A') fforbidstatus, CONVERT(VARCHAR(8000), '..') ffullparentid, 1 flevel FROM T_BD_FLEXITEMPROPERTY) f LEFT OUTER JOIN (SELECT CONVERT(VARCHAR(8000), FEXPID) fexpid, CONVERT(VARCHAR(8000), FNAME) fname, FLOCALEID flocaleid FROM T_BD_EXPENSE_L UNION SELECT DISTINCT CONVERT(VARCHAR(8000), 0) fexpid, CONVERT(VARCHAR(8000), '【未录入】') fname, CONVERT(FLOAT, 2052) flocaleid FROM T_BD_FLEXITEMPROPERTY_L) f_l ON f.FEXPID = f_l.FEXPID WHERE f_l.flocaleid = 2052 UNION SELECT CONVERT(VARCHAR(8000), g.FID) fflex9, CONVERT(VARCHAR(8000), g.FNUMBER) fflex9_number, CONVERT(VARCHAR(8000), gl.FNAME) fflex9_name, g_l.FFULLPARENTID fflex9_fullparentid, 1 fflex9_isgroup, g_l.FLEVEL fflex9_level FROM T_BD_EXPENSE_GROUP g LEFT OUTER JOIN T_BD_EXPENSE_GROUPLEVEL g_l ON g.fid = g_l.fid LEFT OUTER JOIN T_BD_EXPENSE_GROUP_L gl ON (g.fid = gl.fid AND gl.flocaleid = 2052)) t_fflex9 ON (f.FFLEX9_fullparentid = t_FFLEX9.FFLEX9_fullparentid OR (f.FFLEX9_fullparentid LIKE t_FFLEX9.FFLEX9_fullparentid + '.%')) WHERE (t_FFLEX9.FFLEX9_level <= 2)) tmp WHERE tmp.FFLEX9_number = 'CBFY-004'
Server stack trace:
at Kingdee.BOS.App.Data.AbstractDatabase.DoLoadDataSet(IDbCommand command, DataSet dataSet, String[] tableNames)
at Kingdee.BOS.App.Data.AbstractDatabase.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.AbstractDatabase.LoadDataSet(DbCommand command, DataSet dataSet, String tableName, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.AbstractDatabase.ExecuteDataSet(DbCommand command, IEnumerable`1 listParam)
at Kingdee.BOS.App.Data.DBUtils.ExecuteDataSet(Context ctx, String strSQL, List`1 paramList)
at Kingdee.BOS.App.Data.DBUtils.ExecuteDataSet(Context ctx, String strSQL)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.AccountingItemsBalancePaging(Dictionary`2 dic)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.PagingFromOtherReport(Dictionary`2 dic)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.Paging(IRptParams filter)
at Kingdee.K3.FIN.GL.App.Report.SubledgerForAcctItemsService.GetList(IRptParams filter)
at Kingdee.BOS.Core.Report.PlugIn.AbstractSysReportServicePlugIn.GetListAndReportData(IRptParams filter)
at Kingdee.BOS.App.Core.PlugInProxy.SysReportServicePlugInProxy.GetListAndReportData(MoveReportServiceParameter parameter)
at Kingdee.BOS.App.Core.SysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Kingdee.BOS.Contracts.ISysReportService.GetListAndReportData(MoveReportServiceParameter parameter)
at Kingdee.BOS.ServiceHelper.SysReportServiceHelper.GetListAndReportData(MoveReportServiceParameter parameter)
at Kingdee.BOS.Model.Report.MoveReportModel.GetData(Int32 start, Int32 rows)
at Kingdee.BOS.Web.Report.SysReportView.GetListData()
at Kingdee.BOS.Web.Report.SysReportView.<>c__DisplayClass4d.
推荐阅读