/// <summary> /// /// </summary> /// <param name="RoleID"> </param> /// <returns></returns> public static Entity.Role GetRole(int RoleID) { Entity.Role entity = null; DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { dbFactory.MakeInParam("@RoleID", DBTypeConverter.ConvertCsTypeToOriginDBType(RoleID.GetType().ToString()), RoleID, 32) }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.StoredProcedure, "proc_Role_Get", prams); while (dataReader.Read()) { entity = new Entity.Role(); //entity.RoleID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); entity.RoleName = dataReader["RoleName"].ToString(); //entity.RoleDescription = dataReader["RoleDescription"].ToString(); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }
/// <summary> /// /// </summary> /// <returns></returns> public static List <Entity.Role> GetAllRole() { List <Entity.Role> list = new List <Entity.Role>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDbDataParameter[] prams = { }; IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select * from Role", prams); while (dataReader.Read()) { Entity.Role entity = new Entity.Role(); entity.ID = DataHelper.ParseToInt(dataReader["ID"].ToString()); entity.RoleName = dataReader["RoleName"].ToString(); entity.Description = dataReader["Description"].ToString(); //entity.IsAudit = DataHelper.ParseToBoolean(dataReader["IsAudit"].ToString()); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="ID"> </param> /// <returns></returns> public static List <Entity.Role> GetUserRole(string GUID) { List <Entity.Role> list = new List <Entity.Role>(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "Select * from vUserRole where GUID='" + GUID + "'", null); while (dataReader.Read()) { Entity.Role entity = new Entity.Role(); entity.ID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); entity.RoleName = dataReader["RoleName"].ToString(); entity.Description = dataReader["Description"].ToString(); list.Add(entity); } } catch (Exception ex) { } finally { db.Conn.Close(); } return(list); }
/// <summary> /// /// </summary> /// <param name="UserID"> </param> /// <returns></returns> public static Entity.UserRole GetUserRoleByGUID(string GUID) { Entity.UserRole entity = new Entity.UserRole(); DBOperatorBase db = new DataBase(); IDBTypeElementFactory dbFactory = db.GetDBTypeElementFactory(); try { List <Entity.Role> Roles = new List <Entity.Role>(); IDataReader dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select * from vUserRole where GUID='" + GUID + "'", null); if (dataReader.Read()) { //Entity.UserRole entity = new Entity.UserRole(); //entity.UserID = DataHelper.ParseToInt(dataReader["UserID"].ToString()); //entity.RoleID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); //list.Add(entity); entity.user.ID = DataHelper.ParseToInt(dataReader["UserID"].ToString()); entity.user.UserName = dataReader["UserName"].ToString(); entity.user.PassWord = dataReader["PassWord"].ToString(); entity.user.GUID = dataReader["GUID"].ToString(); entity.user.RealName = dataReader["RealName"].ToString(); entity.user.IsStop = DataHelper.ParseToBoolean(dataReader["IsStop"].ToString()); //entity.role.ID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); //entity.role.RoleName = dataReader["RoleName"].ToString(); //entity.role.Description = dataReader["Description"].ToString(); //entity.role.IsAudit = DataHelper.ParseToBoolean(dataReader["IsAudit"].ToString()); } dataReader = db.ExecuteReader(Config.con, CommandType.Text, "select * from vUserRole where GUID='" + GUID + "'", null); while (dataReader.Read()) { Entity.Role role = new Entity.Role(); role.ID = DataHelper.ParseToInt(dataReader["RoleID"].ToString()); role.RoleName = dataReader["RoleName"].ToString(); role.Description = dataReader["Description"].ToString(); Roles.Add(role); //entity.role.IsAudit = DataHelper.ParseToBoolean(dataReader["IsAudit"].ToString()); } entity.role = Roles; } catch (Exception ex) { } finally { db.Conn.Close(); } return(entity); }