技术答疑.常用SQL.信息中心
信息中心常用SQL示例:
DECLARE @FUSERID INT SELECT @FUSERID=FUSERID FROM dbo.T_SEC_USER WHERE FNAME='demo' -- 我的待办 SELECT t0.FSENDERID AS FSENDERID_Id , t0.FTITLE AS FTITLE , t0.FCREATETIME AS FCREATETIME , t0_L.fpreresultname AS FPRERESULTNAME , t0.fpredisposition AS FPREDISPOSITION , t0.fbillnumber AS FBILLNUMBER , t0.FPROCDEFID AS FProcDefId_Id , t0.FCONTENT AS FCONTENT , t0.FNUMBER AS FNUMBER , t0.fdiscusscount AS FDISCUSSCOUNT , t0.freadstatus AS FREADSTATUS , t0.FASSIGNID AS FASSIGNID , ROW_NUMBER() OVER ( ORDER BY t0.FASSIGNID DESC ) fidentityid FROM V_WF_ASSIGN t0 LEFT JOIN V_WF_ASSIGN_L t0_L ON ( t0.FASSIGNID = t0_L.FASSIGNID AND t0_L.FLOCALEID = 2052 ) WHERE ( (t0.FRECEIVERID = @FUSERID AND t0.fstatus = '0') ); -- 我的已办 SELECT t0.FSENDERID AS FSENDERID_Id , t0.FTITLE AS FTITLE , t0.FCREATETIME AS FCREATETIME , t0_L.fpreresultname AS FPRERESULTNAME , t0.FDISPOSITION AS FPREDISPOSITION , t0.FPROCDEFID AS FProcDefId_Id , t0.FBILLNO AS FBILLNO , t0.FNUMBER AS FNUMBER , t0.FCOMPLETEDTIME AS FCOMPLETEDTIME , t0.fdiscusscount AS FDISCUSSCOUNT , t0.FREADSTATUS AS FREADSTATUS , t0.FASSIGNID AS FASSIGNID , ROW_NUMBER() OVER ( ORDER BY t0.FCOMPLETEDTIME DESC ) fidentityid FROM V_WF_ASSIGNEND t0 LEFT JOIN V_WF_ASSIGNEnd_L t0_L ON ( t0.FASSIGNID = t0_L.FAssignId AND t0_L.FLocaleId = 2052 ) WHERE ( (t0.FRECEIVERID = @FUSERID AND ( t0.FSTATUS > '0' )) ); -- 我的转发 SELECT t0.FSenderId AS FSENDERID_Id , t0.FCreateTime AS FCREATETIME , t0.FFORWARDRECEIVERID AS FFORWARDRECEIVERID_Id , t0.FTitle AS FTITLE , t0.FCompletedTime AS FCOMPLETEDTIME , t0.FProcDefId AS FProcDefId_Id , t0.FDisposition AS FDISPOSITION , t0.FNumber AS FNUMBER , t0.fforwardstatus AS FFORWARDSTATUS , t0.FReadStatus AS FREADSTATUS , t0.FAssignId AS FASSIGNID , ROW_NUMBER() OVER ( ORDER BY t0.FCreateTime DESC ) fidentityid FROM V_WF_FORWARD t0 WHERE ( (FReceiverId = @FUSERID AND ( t0.FFORWARDRECEIVERID > 0 )) ); -- 我的加签 SELECT t0.FSenderId AS FSENDERID_Id , t0.FCreateTime AS FCREATETIME , t0.FTitle AS FTITLE , t0.FCompletedTime AS FCOMPLETEDTIME , t0.FProcDefId AS FProcDefId_Id , t0.FNumber AS FNUMBER , t0.FReadStatus AS FREADSTATUS , t0.FAssignId AS FASSIGNID , ROW_NUMBER() OVER ( ORDER BY t0.FCreateTime DESC ) fidentityid FROM V_WF_ADDSIGN t0 WHERE ( t0.FReceiverId = 100008 ); -- 我的委托 SELECT t0.FCREATETIME AS FCREATETIME , t0.fentrustreceiverid AS FReceiverId_Id , t0.FTITLE AS FTITLE , t0.FCONTENT AS FCONTENT , t0_L.fpreresultname AS FPRERESULTNAME , t0.FDISPOSITION AS FPREDISPOSITION , t0.FNUMBER AS FNUMBER , t0.fstatus AS FSTATUS , t0.FREADSTATUS AS FREADSTATUS , t0.fpkid AS FPKID , ROW_NUMBER() OVER ( ORDER BY t0.FCREATETIME DESC ) fidentityid FROM V_WF_Consign t0 LEFT JOIN V_WF_Consign_L t0_L ON ( t0.fpkid = t0_L.fpkid AND t0_L.FLocaleId = 2052 ) WHERE ( (( fentrustconsignor = @FUSERID AND fentrustconsignstatus = 1--0非委托1委托2已撤销 ) AND ( t0.fstatus <> '3' ))--0未处理1已处理3已转发 );
---------------------------------------------------------------------------------------------------------
【金蝶云星空BOS二次开发案例演示】https://vip.kingdee.com/article/94751030918525696
技术答疑.常用SQL.信息中心
信息中心常用SQL示例:DECLARE @FUSERID INTSELECT @FUSERID=FUSERID FROM dbo.T_SEC_USER WHERE FNAME='demo'-- 我的待办SELECT ...
点击下载文档
本文2024-09-23 03:57:15发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-162165.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章