/// <summary> /// 得到角色模块上的所有权限 /// </summary> /// <param name="RoleKey"></param> /// <returns></returns> public string GetRoleModulePermission(int RoleId, out List <PermissionsModel> olist) { olist = null; string ret = Config.Fail; try { olist = pd.GetRoleModulePermission(RoleId); return(Config.Success); } catch (Exception ex) { WriteLog.WriteExceptionLog("ZB.BLL.Authorization.AdminBLL.GetRoleModulePermission()", ex); return(Config.ExceptionMsg); } }
/// <summary> /// 得到用户列表 /// </summary> /// <param name="PageIndex"></param> /// <param name="PageNum"></param> /// <param name="where"></param> /// <param name="Count"></param> /// <returns></returns> public List <AdminModel> GetAdminList(int PageIndex, int PageNum, string where, out int Count) { List <AdminModel> olist = new List <AdminModel>(); Count = 0; SqlConnection sqlConnection = new SqlConnection(Config.ConnectionString); SqlCommand sqlcommand = new SqlCommand("sp_AdminList", sqlConnection); sqlcommand.CommandType = CommandType.StoredProcedure; SqlParameter _PageIndex = new SqlParameter("@PageIndex", PageIndex); _PageIndex.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_PageIndex); SqlParameter _PageNum = new SqlParameter("@PageNum", PageNum); _PageNum.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_PageNum); SqlParameter _where = new SqlParameter("@where", where); _where.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_where); SqlParameter _Count = new SqlParameter("@Count", SqlDbType.Int); _Count.Direction = ParameterDirection.Output; sqlcommand.Parameters.Add(_Count); try { sqlConnection.Open(); using (IDataReader idr = sqlcommand.ExecuteReader()) { DealerDAL dd = new DealerDAL(); StoreDAL sd = new StoreDAL(); PermissionsDAL pDal = new PermissionsDAL(); while (idr.Read()) { AdminModel oCModel = new AdminModel(); if (idr["AdminId"] != DBNull.Value) { oCModel.AdminId = (int)idr["AdminId"]; } if (idr["AdminName"] != DBNull.Value) { oCModel.AdminName = (string)idr["AdminName"]; } if (idr["AdminPassword"] != DBNull.Value) { oCModel.AdminPassword = (string)idr["AdminPassword"]; } if (idr["Type"] != DBNull.Value) { oCModel.Type = (AdminType)idr["Type"]; } if (idr["RoleId"] != DBNull.Value) { oCModel.RoleId = (int)idr["RoleId"]; } if (idr["Status"] != DBNull.Value) { oCModel.Status = (bool)idr["Status"]; } if (idr["CreateTime"] != DBNull.Value) { oCModel.CreateTime = (DateTime)idr["CreateTime"]; } if (idr["CreatorId"] != DBNull.Value) { oCModel.CreatorId = (int)idr["CreatorId"]; } int Totoal = 0; List <DealerModel> dModel = dd.GetDealerModelList(1, 1, "DealerInfo.AdminId=" + oCModel.AdminId, out Totoal); if (dModel != null & dModel.Count > 0) { oCModel.Dealer = dModel[0]; } List <StoreModel> oSMoel = sd.GetStoreModelList(1, 1, "StoreInfo.AdminId=" + oCModel.AdminId, out Totoal); if (oSMoel != null & oSMoel.Count > 0) { oCModel.Store = oSMoel[0]; } RoleModel role = new RoleModel(); if (idr["RoleId"] != DBNull.Value) { role.RoleId = (int)idr["RoleId"]; } if (idr["RoleId"] != DBNull.Value) { role.RoleName = (string)idr["RoleName"]; } if (idr["RoleId"] != DBNull.Value) { role.Permissions = pDal.GetRoleModulePermission(role.RoleId); } oCModel.Role = role; olist.Add(oCModel); } } Count = int.Parse(_Count.Value.ToString()); } catch (Exception ex) { throw ex; } finally { sqlConnection.Close(); } return(olist); }
/// <summary> ///得到角色列表 /// </summary> /// <returns></returns> public List <RoleModel> GetRoleList(int?RoleId) { List <RoleModel> oLRModel = new List <RoleModel>(); SqlConnection sqlConnection = new SqlConnection(Config.ConnectionString); SqlCommand sqlcommand = new SqlCommand("sp_RoleInfo", sqlConnection); sqlcommand.CommandType = CommandType.StoredProcedure; SqlParameter _op = new SqlParameter("@op", "Get"); _op.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_op); SqlParameter _RoleId = new SqlParameter("@RoleId", RoleId == null?(Object)DBNull.Value:RoleId.Value); _RoleId.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_RoleId); SqlParameter _RoleName = new SqlParameter("@RoleName", (Object)DBNull.Value); _RoleName.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_RoleName); SqlParameter _CreatorId = new SqlParameter("@CreatorId", (Object)DBNull.Value); _CreatorId.Direction = ParameterDirection.Input; sqlcommand.Parameters.Add(_CreatorId); SqlParameter result = new SqlParameter("@result", SqlDbType.VarChar, 10); result.Direction = ParameterDirection.Output; sqlcommand.Parameters.Add(result); try { sqlConnection.Open(); using (IDataReader idr = sqlcommand.ExecuteReader()) { PermissionsDAL pDal = new PermissionsDAL(); while (idr.Read()) { RoleModel oRoleModel = new RoleModel(); oRoleModel.RoleId = (int)idr["RoleId"]; oRoleModel.RoleName = (string)idr["RoleName"]; oRoleModel.CreatorId = (int)idr["CreatorId"]; if (idr["AdminName"] != DBNull.Value) { oRoleModel.Creator = (string)idr["AdminName"]; } ; oRoleModel.CreateTime = (DateTime)idr["CreateTime"]; oRoleModel.Permissions = pDal.GetRoleModulePermission(oRoleModel.RoleId); oLRModel.Add(oRoleModel); } } } catch (Exception ex) { throw ex; } finally { sqlConnection.Close(); } return(oLRModel); }