| | |
|---|
| | | 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( |
|---|
| | |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | if (sWhere == null || sWhere.Equals("")) |
|---|
| | | { |
|---|
| | | ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrjGroup"); |
|---|
| | | ds = oCN.RunProcReturn("Select HItemID,HNumber ,HName from Gy_ClassTimePrj where HStopflag=0 Order by HItemID ", "Gy_ClassTimePrj"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | string sql1 = "Select HItemID,HNumber ,HName from Gy_ClassTimePrjGroup where HStopflag=0 "; |
|---|
| | | string sql1 = "Select HItemID,HNumber ,HName from Gy_ClassTimePrj where HStopflag=0 "; |
|---|
| | | string sql = sql1 + sWhere; |
|---|
| | | ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrjGroup"); |
|---|
| | | ds = oCN.RunProcReturn(sql, "Gy_ClassTimePrj"); |
|---|
| | | } |
|---|
| | | |
|---|
| | | //ds = webserver.GetUnitList(sWhere, ref DBUtility.ClsPub.sErrInfo); |
|---|
