Example #1
0
        /// <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);
        }