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);
}
public void GetListJSON(int _thispage, int _pagesize, string _wherestr, ref string _jsonstr, string ordercol, string ordertype)
{
SiteGroupCms.Dal.RightDal rightdal = new RightDal();
SiteGroupCms.Entity.Right right = new SiteGroupCms.Entity.Right();
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.ConditionExpress = _wherestr;
string sqlStr = "";
int _countnum = _doh.Count("yy_roleinfo");
sqlStr = SiteGroupCms.Utils.SqlHelp.GetSql("*", "yy_roleinfo", ordercol, _pagesize, _thispage, ordertype, _wherestr);
_doh.Reset();
_doh.SqlCmd = sqlStr;
DataTable dt = _doh.GetDataTable();
DataTable dt2 = new DataTable();
DataColumn col = new DataColumn("id", System.Type.GetType("System.String"));
DataColumn col2 = new DataColumn("title", System.Type.GetType("System.String"));
DataColumn col3 = new DataColumn("rights", System.Type.GetType("System.String"));
DataColumn col4 = new DataColumn("description", System.Type.GetType("System.String"));
dt2.Columns.Add(col);
dt2.Columns.Add(col2);
dt2.Columns.Add(col3);
dt2.Columns.Add(col4);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt2.NewRow();
dr["id"] = dt.Rows[i]["id"];
dr["title"] = dt.Rows[i]["role"];
dr["rights"] = Getrighttitle(Str2Int(dt.Rows[i]["id"].ToString()));
dr["description"] = dt.Rows[i]["description"].ToString();
dt2.Rows.Add(dr);
}
_jsonstr = SiteGroupCms.Utils.dtHelp.DT2JSON(dt2, _countnum);
dt.Clear();
dt.Dispose();
}
}
