/// <summary>
/// 获取系统所有角色数据
/// </summary>
/// <returns>角色数据集</returns>
public EntityBase GetRoles(string loginId, ref List<RoleEntity> list)
{
TradeUser reftradeuser = new TradeUser();
if (ComFunction.ExistUserLoginID(loginId, ref reftradeuser) == false)
{
return entityBase;
}
try
{
string sqlCommand = @"select * from Base_Role where roleid not in(select roleid from base_userrole
where userid in(select userid from base_user where account in('root','admin')))";
if ("ROOT" == reftradeuser.Account.ToUpper())
{
sqlCommand = @"select * from Base_Role where roleid not in(select roleid from base_userrole
where userid in(select userid from base_user where account='admin'))";
}
else if ("ADMIN" == reftradeuser.Account.ToUpper())
{
sqlCommand = @"select * from Base_Role";
}
DataTable dt = ComFunction.GetRoles(sqlCommand);
RoleEntity roleEntity = null;
foreach (DataRow dr in dt.Rows)
{
roleEntity = new RoleEntity();
roleEntity.RoleID = dr["RoleID"].ToString();
roleEntity.RoleName = dr["RoleName"].ToString();
roleEntity.Remark = dr["Remark"].ToString();
list.Add(roleEntity);
}
entityBase.Desc = "获取系统所有角色成功！";
entityBase.Result = true;
}
catch (Exception ex)
{
SetException("获取角色记录数出错,原因:", ex);
}
return entityBase;
}
/// <summary>
/// 向数据库插入角色
/// </summary>
/// <param name="loginId"></param>
/// <param name="roleEntity"></param>
/// <returns></returns>
public EntityBase AddRole(string loginId, RoleEntity roleEntity)
{
if (ComFunction.ExistUserLoginID(loginId) == false)
{
return entityBase;
}
try
{
if (ComFunction.AddRole(roleEntity) > 0)
{
entityBase.Result = true;
entityBase.Desc = "角色新增成功";
}
else
{
entityBase.Result = false;
entityBase.Desc = "角色新增失败";
}
}
catch (Exception ex)
{
SetException("角色新增失败,原因:", ex);
}
return entityBase;
}
/// <summary>
/// 新增角色
/// </summary>
/// <param name="roleEntity"></param>
/// <returns></returns>
public static int AddRole(RoleEntity roleEntity)
{
string sqlCommand = string.Format(@"INSERT INTO Base_Role (RoleID,RoleName,Remark) VALUES ('{0}' ,'{1}' ,'{2}')", roleEntity.RoleID, roleEntity.RoleName, roleEntity.Remark);
return DbHelper.ExecuteNonQuery(sqlCommand);
}
/// <summary>
/// 读取角色
/// </summary>
/// <param name="loginId"></param>
/// <param name="roleID"></param>
/// <returns></returns>
public RoleEntity ReadRole(string loginId, string roleID)
{
RoleEntity roleEntity = new RoleEntity();
if (ComFunction.ExistUserLoginID(loginId) == false)
{
return roleEntity;
}
try
{
DataTable dt = ComFunction.ReadRole(roleID);
foreach (DataRow dr in dt.Rows)
{
roleEntity = new RoleEntity();
roleEntity.RoleID = dr["RoleID"].ToString();
roleEntity.RoleName = dr["RoleName"].ToString();
roleEntity.Remark = dr["Remark"].ToString();
}
roleEntity.Desc = "获取系统角色成功！";
roleEntity.Result = true;
}
catch (Exception ex)
{
SetException("获取角色记录数出错,原因:", ex);
}
return roleEntity;
}
/// <summary>
/// 修改角色
/// </summary>
/// <param name="roleEntity"></param>
/// <returns></returns>
public static int UpdateRole(RoleEntity roleEntity)
{
string sqlCommand = string.Format(@"UPDATE Base_Role SET RoleName = '{0}',Remark = '{1}' WHERE RoleID = '{2}'", roleEntity.RoleName, roleEntity.Remark, roleEntity.RoleID);
return DbHelper.ExecuteNonQuery(sqlCommand);
}
