string sqlAll = string.Format(@"select * from dbo.SysFun where NodeId in (select SysFunId from dbo.Role_SysFun where RoleId in (
select RoleId from dbo.User_Role where UserId={0})) and ParentNodeId=0",userId);
string sql = "From SysFun as syf where syf.NodeId in(from Role_SysFun as roles where roles.RoleId in(from User_Role as ur where ur.UserId=" + userId + ")) and syf.ParentNodeId=0";我转的不能用 帮忙啊
select RoleId from dbo.User_Role where UserId={0})) and ParentNodeId=0",userId);
string sql = "From SysFun as syf where syf.NodeId in(from Role_SysFun as roles where roles.RoleId in(from User_Role as ur where ur.UserId=" + userId + ")) and syf.ParentNodeId=0";我转的不能用 帮忙啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货