/// <summary> /// 查询当前角色对应权限 /// </summary> /// <param name="rid"></param> /// <param name="pid"></param> /// <returns></returns> public DataTable selectQX(string rid, string pid) { string sql = string.Format("select[id],[text],[state], rp.PopID,case when rp.PopID is not null then 1 else 0 end as checked from [dbo].[Pop] p left join (select PopID from GuanliPop where GuanliID = {0}) rp on p.id = rp.PopID where p.PID = {1}", rid, pid); return(SqlDBHelper.table(sql)); }