/// <summary>
/// 取出有读权限的栏目
/// </summary>
/// <param name="roleId">角色id</param>
/// <param name="langFlag">版本标识</param>
/// <returns></returns>
private string getCateTree(int roleId, string langFlag)
{
string treeStr = "";
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
if (roleId == 0)
{
string Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_ModelKeyId,Cate_IsMenu from Dcms_Cate where Cate_Lang='" + langFlag + "' order by Cate_Order asc";
DataTable cateDt = session.GetTable(Sql);
if (cateDt.Rows.Count > 0)
{
ScrollTree Tree = new ScrollTree();
treeStr = Tree.CreateTree(cateDt);
}
}
else
{
string Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_ModelKeyId,Cate_IsMenu from Dcms_Cate where Cate_Id in (select Permissions_CateId from Dcms_Permissions where Cate_Lang='" + langFlag + "' and Permissions_Select=1 and Permissions_RoleId=" + roleId + ") order by Cate_Order asc";
DataTable cateDt = session.GetTable(Sql);
if (cateDt.Rows.Count > 0)
{
ScrollTree Tree = new ScrollTree();
treeStr = Tree.CreateTree(cateDt);
}
}
}
return(treeStr);
}
/// <summary>
/// 取出有读权限的栏目
/// </summary>
/// <param name="roleId">角色id</param>
/// <param name="langFlag">版本标识</param>
/// <returns></returns>
private string getCateTree(int roleId, string langFlag)
{
string treeStr = "";
using (ISession session = dbContext.Current().GetContext("SqlDb").GetSession())
{
if (roleId == 0)
{
string Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_ModelKeyId,Cate_IsMenu from Dcms_Cate where Cate_Lang='" + langFlag + "' order by Cate_Order asc";
DataTable cateDt = session.GetTable(Sql);
if (cateDt.Rows.Count > 0)
{
ScrollTree Tree = new ScrollTree();
treeStr = Tree.CreateTree(cateDt);
}
}
else
{
string Sql = "select Cate_Id,Cate_Title,Cate_Module,Cate_ManageUrl,Cate_ParentID,Cate_ModelKeyId,Cate_IsMenu from Dcms_Cate where Cate_Id in (select Permissions_CateId from Dcms_Permissions where Cate_Lang='" + langFlag + "' and Permissions_Select=1 and Permissions_RoleId=" + roleId + ") order by Cate_Order asc";
DataTable cateDt = session.GetTable(Sql);
if (cateDt.Rows.Count > 0)
{
ScrollTree Tree = new ScrollTree();
treeStr = Tree.CreateTree(cateDt);
}
}
}
return treeStr;
}
