public SiteGroupCms.Entity.Role GetEntity(int _roleid)
{
SiteGroupCms.Entity.Role role = new SiteGroupCms.Entity.Role();
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.SqlCmd = "SELECT * FROM [yy_roleinfo] WHERE [id]=" + _roleid;
DataTable dt = _doh.GetDataTable();
SiteGroupCms.Dal.RightDal rightdal = new RightDal();
SiteGroupCms.Entity.Right right = new SiteGroupCms.Entity.Right();
if (dt.Rows.Count > 0)
{
role.Title = dt.Rows[0]["role"].ToString();
role.Id = _roleid;
role.Rights = dt.Rows[0]["rights"].ToString();
role.Sort = Str2Int(dt.Rows[0]["sort"].ToString());
role.Description = dt.Rows[0]["description"].ToString();
string[] strs = role.Rights.Split(',');
for (int i = 0; i < strs.Length - 1; i++)
{
role.Righttitle += rightdal.GetEntity(Str2Int(strs[i])).Title + ";";
}
}
}
return(role);
}
public string Getrighttitle(int _roleid)
{
string str = "";
string returns = "";
RightDal rightdal = new RightDal();
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.SqlCmd = "SELECT * FROM [yy_roleinfo] WHERE [id]=" + _roleid;
DataTable dt = _doh.GetDataTable();
if (dt.Rows.Count > 0)
{
str = dt.Rows[0]["rights"].ToString();
string[] strs = str.Split(',');
for (int i = 0; i < strs.Length - 1; i++)
{
returns += rightdal.GetEntity(Str2Int(strs[i])).Title + " ,";
}
}
}
return(returns);
}