/// <summary> /// 得到权限数的数据 /// </summary> /// <returns></returns> public DataTable GetAuthorityTree() { RelaTable tab1 = new RelaTable("JAuthority"); tab1.InnerJoin("Jmodel", "JAuthority.modelid=jmodel.modelid"); tab1.InnerJoin("JAuthorityDetail", "JAuthorityDetail.AuthorityID=JAuthority.AuthorityID"); JQuery querey1 = new JQuery(tab1); querey1.OrderBy = "Jmodel.num,JAuthority.num,JAuthorityDetail.num"; String fields = "Jmodel.modelid,jmodel.modelname,JAuthority.authorityid,JAuthority.authorityName,JAuthorityDetail.remark,JAuthorityDetail.AuthorityUnitID"; DataTable dt1 = querey1.SearchData(fields, -1).Tables[0]; return(dt1); }