| | |
|---|
| | | SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); |
|---|
| | | string sql = string.Format(@"select '权限管理-用户' id,'' HNumber,'权限管理--用户' title,'' ParentID |
|---|
| | | union all |
|---|
| | | select gnbm id,gnsy HNumber,gnmc as title, case when sjgnbm='' then '权限管理--用户' else sjgnbm end ParentID from Xt_Xtgnb where sjgnbm='' |
|---|
| | | select gnbm id,gnsy HNumber,gnmc as title, case when sjgnbm='' then '权限管理--用户' else sjgnbm end ParentID from Xt_Xtgnb where sjgnbm='' and useflag=1 |
|---|
| | | union all |
|---|
| | | Select gnbm id,gnsy HNumber,gnmc as title,sjgnbm as ParentID |
|---|
| | | from Xt_Xtgnb where mjbz=0 and useflag=1 and rightflag=1 and sjgnbm in( |
|---|
