/// <summary>
/// 角色权限列表查询
/// </summary>
/// <returns></returns>
public List <S_RoleInfoViewModel> GetRoleInfoList(string roleName)
{
var resultList = new List <S_RoleInfoViewModel>();
var modelList = GetModelList(" RoleName like '%" + roleName + "%'");
if (modelList != null)
{
var treeBiz = new S_TreeInfoBiz();
foreach (var item in modelList)
{
var model = new S_RoleInfoViewModel
{
RoleId = item.RoleID.ToString(),
RoleName = item.RoleName,
CreateTime = (DateTime)item.CreateTime
};
model.TreeList = GetRoleTreeList(item.RoleID);
resultList.Add(model);
}
}
return(resultList);
}
/// <summary>
/// 根据用户id获取用户所属角色
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public List <S_RoleInfoViewModel> GetRolesByUserId(string userID)
{
var result = new List <S_RoleInfoViewModel>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select UserClass,u.RoleID,r.RoleName,u.UserID from S_UserInfo u left join S_RoleInfo r on u.RoleID=r.RoleID where UserID = '" + userID + "'");
var ds = db.Query(strSql.ToString());
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
var row = ds.Tables[0].Rows[i];
if (row != null)
{
if (row["UserClass"] != null || !string.IsNullOrEmpty(row["UserClass"].ToString()))
{
var uc = row["UserClass"].ToString().TrimEnd(',').Split(',');
if (uc.Length > 0)
{
foreach (var item in uc)
{
var model2 = new S_RoleInfoViewModel();
switch (item.Trim())
{
case "1":
model2.RoleName = "超级管理员";
break;
case "2":
model2.RoleName = "判图员";
break;
case "3":
model2.RoleName = "开包员";
break;
default:
break;
}
if (!string.IsNullOrEmpty(model2.RoleName))
{
result.Add(model2);
}
}
}
}
if (row["RoleName"] != null && !string.IsNullOrEmpty(row["RoleName"].ToString()))
{
var model = new S_RoleInfoViewModel();
model.RoleName = row["RoleName"].ToString();
if (row["RoleID"] != null && !string.IsNullOrEmpty(row["RoleID"].ToString()))
{
model.RoleId = row["RoleID"].ToString();
}
result.Add(model);
}
}
}
}
return(result);
}
