直接sql报表 报错“已添加了具有相同键的项”
金蝶云社区-云社区用户6ZA50447
云社区用户6ZA50447
0人赞赏了该文章 1257次浏览 未经作者许可,禁止转载编辑于2017年02月28日 15:42:31

sql大概如下,前台能够正常查询,但是我在bos中打开数据源会报错 “已添加了具有相同键的项。”经测试报错原因是用了两遍_CurrentUserId_. 这个问题怎么解决?请老师帮帮忙
SELECT
t0.F_PAEZ_BILLNO as 返点余额编码,
t1.FCUSTID as 客户,
t0.F_PAEZ_UploadDate as 上传日期,
t0.F_PAEZ_EndDate as 截止日期,
t4.FDATAVALUE as 返点类型,
t0.F_PAEZ_UPAMOUNT as 上传金额,
t0.F_PAEZ_OrderAmount as 累计订单金额
from PAEZ_T_KeHuFanDianYuE t0
inner join
T_BD_CUSTOMER_L t1 on (t0.F_PAEZ_CUSTOMERID = t1.FCUSTID)
left join
T_BD_CUSTOMER t2 on(t0.F_PAEZ_CUSTOMERID = t2.FCUSTID)
left join
bmw_t_Cust_Entry100002 t3 on(t2.F_BMW_LCKHFZ=t3.FID)
left join
T_BAS_ASSISTANTDATAENTRY_L t4 on (t0.F_PAEZ_ReturnType= t4.FENTRYID)
left join
T_HR_EMPINFO t5 on (t5.F_PAEZ_FQ =t2.F_BMW_JGKHFZ )
left join
T_SEC_USER t6 on (t6.FLINKOBJECT = t5.FPERSONID)
where t0.F_PAEZ_DocumentStatus='C'
and t6.FUSERID =_CurrentUserId_
and t4.FDATAVALUE = '技工'
union
SELECT
t0.F_PAEZ_BILLNO as 返点余额编码,
t1.FCUSTID as 客户,
t0.F_PAEZ_UploadDate as 上传日期,
t0.F_PAEZ_EndDate as 截止日期,
t4.FDATAVALUE as 返点类型,
t0.F_PAEZ_UPAMOUNT as 上传金额,
t0.F_PAEZ_OrderAmount as 累计订单金额
from PAEZ_T_KeHuFanDianYuE t0
inner join
T_BD_CUSTOMER_L t1 on (t0.F_PAEZ_CUSTOMERID = t1.FCUSTID)
left join
T_BD_CUSTOMER t2 on(t0.F_PAEZ_CUSTOMERID = t2.FCUSTID)
left join
bmw_t_Cust_Entry100002 t3 on(t2.F_BMW_LCKHFZ=t3.FID)
left join
T_BAS_ASSISTANTDATAENTRY_L t4 on (t0.F_PAEZ_ReturnType= t4.FENTRYID)
left join
T_HR_EMPINFO t5 on (t5.F_PAEZ_FQ =t2.F_BMW_LCKHFZ)
left join
T_SEC_USER t6 on (t6.FLINKOBJECT = t5.FPERSONID)
where t0.F_PAEZ_DocumentStatus='C'
and t6.FUSERID =
_CurrentUserId_
and t4.FDATAVALUE ='临床'

错误详细信息
发生时间: 2017年2月28日 15:39:48
错误来源: mscorlib
错误信息: 已添加了具有相同键的项。
===================================================
调用堆栈:
在 System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
在 System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
在 Kingdee.BOS.DomainModelDesigner.SQLReport.SQLRptDataSourceCtl..ctor(SQLDataSource dataSource)
在 Kingdee.BOS.DomainModelDesigner.SQLReport.frmSQLRptWizard.InitSteps(String key)
在 Kingdee.BOS.DomainModelDesigner.SQLReport.frmSQLRptWizard.ChangeStep(String key)
在 Kingdee.BOS.DomainModelDesigner.SQLReport.frmSQLRptWizard.btnNext_Click(Object sender, EventArgs e)
在 System.Windows.Forms.Control.OnClick(EventArgs e)
在 DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
在 System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
在 System.Windows.Forms.Control.WndProc(Message& m)
在 DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
在 DevExpress.XtraEditors.BaseControl.WndProc(Message& msg)
在 System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
错误数据: System.Collections.ListDictionaryInternal