SQL效果图
SQL脚本
use HXSHR;declare @FPositionID varchar(max); set @FPositionID='jnntHe9QSRGzjWSlNPvmvnSuYS4='
select 'N' 上级,FLevel,FID,FChildID,FParentID
from T_ORG_PositionHierarchy
where FChildID=@FPositionID
union
select 'N+1' 上级,FLevel,FID,FChildID,FParentID
from T_ORG_PositionHierarchy
where FChildID=(select FParentID from T_ORG_PositionHierarchy where FChildID=@FPositionID)
union
select 'N+2' 上级,FLevel,FID,FChildID,FParentID
from T_ORG_PositionHierarchy
where FChildID=(select FParentID from T_ORG_PositionHierarchy where FChildID=(
select FParentID from T_ORG_PositionHierarchy where FChildID=@FPositionID))
union
select 'N+3' 上级,FLevel,FID,FChildID,FParentID
from T_ORG_PositionHierarchy
where FChildID=(select FParentID from T_ORG_PositionHierarchy where FChildID=(
select FParentID from T_ORG_PositionHierarchy where FChildID=(
select FParentID from T_ORG_PositionHierarchy where FChildID=@FPositionID)))
说明:
1、当前c#下已创建了文本控件,用于录入@FPositionID的值,然后用于联合查询
2、目前c#下只能写第一组查询语句,不知道如何拼接其他组语句。
请诸位高手赐教c#相应脚本!