Use The login user ,bring the person which in the same department ~!
来源:互联网 发布:2106淘宝查虚假交易 编辑:程序博客网 时间:2024/04/28 10:33
Select * from((
select VGUID,ODESC as DESC0,ODESCCHS as DESC1,PGUID,OID as ZORDER from CSORGA_1 where VGUID in (
select cmpnam from csempl_1 where dcno='{SYS:DCNO}' union all
select DCDEPT from csempl_1 where dcno='{SYS:DCNO}' ) )union (
select VGUID,DCNO+'-'+DCNAME as DESC0,DCNO+'-'+DCNAMECHS as DESC1,DCDEPT as PGUID,DCNO as ZORDER FROM CSEMPL_1 where DCDEPT in (
select DCDEPT from csempl_1 where dcno='{SYS:DCNO}')))A ORDER BY ZORDER
when we use the landa system ,some of the fields is used by the Tree control ,when the use the tree control to select the relation person ,the want filter the person which in the same department ,so ,when depend on the user number,bring the CMPNAM and the DCDEPT from the CSORGA_1 and DCDEPT from the CSEMPL_1 .is will show the result which you need ~!
- Use The login user ,bring the person which in the same department ~!
- in LandaV8: Specify the Person in which department ~!
- The charactor bring the weapon
- 126.Identify the two situations in which you use the alert log file in your database to check the de
- The Error "Login failed for user"
- UVA 484 - The Department of Redundancy Department
- UVa 484 - The Department of Redundancy Department
- uva 222 The Department of Redundancy Department
- Cannot open database "WWALMDB" requested by the login.The login failed Login failed for user sa
- the use of github in the Ubuntu
- the tables of the user in SAP
- Check the active user in the Application
- The Day the QA Department Died
- Use Dojo in the ZF
- SoC Bring-Up in DS-5 using the PCE
- Could I use NEON and VFP at the same time in my application?
- Question 16: Which of the following methods can a developer use to override the default terminate() function in C++?
- In which of the following does a C++ developer use the placement new syntax to make new allocate an
- jsf nich:tree treeAction
- Netlink Socket
- 我是一个相当浮躁的人
- java常用方法
- 清空jsp页面中input中的值
- Use The login user ,bring the person which in the same department ~!
- access数据库用sql语句添加字段,修改字段,删除字段
- 解决kingEditer提交不能传值的问题
- Delphi中怎样监视POP3信箱
- 利用GetIfTable ,GetIfEntry 实时判断网线插拔状态
- 利用GetIfTable ,GetIfEntry 实时判断网线插拔状态
- 小技巧:WINCE下快速编译单个驱动
- 在Android中创建一种新的输入法(Creating an Input Method))
- MFC中自定义类访问主对话框控件