/// <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);
}
/// <summary>
/// 根据组织的ID，得到其正常的用户Table
/// </summary>
/// <param name="orgid"></param>
/// <returns></returns>
public DataTable GetOrgUserID(String orgid)
{
DataTable dt1 = null;
if (String.IsNullOrEmpty(orgid) == false)
{
List <SearchField> condition = new List <SearchField>();
condition.Add(new SearchField("JOrgUsers.orgid", orgid));
condition.Add(new SearchField("Juser.status", "1"));
RelaTable r1 = new RelaTable("JOrgUsers");
r1.InnerJoin("JUser", "JOrgUsers.userid=Juser.userid");
JTable tab1 = new JTable(r1.TableName);
dt1 = tab1.SearchData(condition, -1, "JOrgUsers.*,Juser.UserName").Tables[0];
}
return(dt1);
}
