/// <summary> /// 查找所有角色 /// </summary> /// <returns></returns> public static List <Role> FindAll() { OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr); string sql = "SELECT * FROM PLM.ROLE_TAB ORDER BY ROLENAME"; DbCommand cmd = db.GetSqlStringCommand(sql); return(EntityBase <Role> .DReaderToEntityList(db.ExecuteReader(cmd))); }
/// <summary> /// 返回所有系统列表 /// </summary> /// <returns></returns> public static List <ProjectSystem> FindAll() { OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr); string sql = "SELECT * FROM PLM.PROJECT_SYSTEM_TAB"; DbCommand cmd = db.GetSqlStringCommand(sql); return(EntityBase <ProjectSystem> .DReaderToEntityList(db.ExecuteReader(cmd))); }
/// <summary> /// 返回所有名称列表 /// </summary> /// <returns></returns> public static List <ProjectBlock> FindAll() { OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr); string sql = "SELECT * FROM Project_Block_tab"; DbCommand cmd = db.GetSqlStringCommand(sql); return(EntityBase <ProjectBlock> .DReaderToEntityList(db.ExecuteReader(cmd))); }
/// <summary> /// 查找所有权限信息 /// </summary> /// <returns></returns> public static List <Privilege> FindAll() { Database db = DatabaseFactory.CreateDatabase(); string sql = "SELECT * FROM PLM.PRIVILEGE_TAB ORDER BY PRIVILEGE_ID"; DbCommand cmd = db.GetSqlStringCommand(sql); return(EntityBase <Privilege> .DReaderToEntityList(db.ExecuteReader(cmd))); }
/// <summary> /// 根据角色名获得其可以继承的角色集合(已排序其本身及继承自它的角色) /// </summary> /// <param name="roleName"></param> /// <returns></returns> public static List <Role> FindAvailableInheritRole(string roleName) { OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr); string sql = "SELECT * FROM PLM.ROLE_TAB WHERE ROLENAME<>:rolename AND ROLENAME NOT IN (SELECT DISTINCT ROLENAME FROM PLM.ROLEINHERIT_TAB WHERE INHERITNAME=:rolename)"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "rolename", DbType.String, roleName); return(EntityBase <Role> .DReaderToEntityList(db.ExecuteReader(cmd))); }
/// <summary> /// 根据用户名查找此用户所属的角色 /// </summary> /// <returns></returns> public static List <Role> FindAll(string userName) { OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr); string sql = "SELECT r.* FROM PLM.ROLE_TAB r, PLM.USERINROLE_TAB u WHERE r.ROLENAME=u.ROLENAME AND u.USERNAME=:username"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "username", DbType.String, userName); return(EntityBase <Role> .DReaderToEntityList(db.ExecuteReader(cmd))); }
/// <summary> /// 根据角色名获得人员名 /// </summary> /// <param name="userName"></param> /// <returns></returns> public static List <Role> FindName(string roleName) { OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr); string sql = "SELECT * FROM PLM.userinrole_tab WHERE ROLENAME=:rolename"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "rolename", DbType.String, roleName); return(EntityBase <Role> .DReaderToEntityList(db.ExecuteReader(cmd))); }
/// <summary> /// 根据项目ID返回其Block列表 /// </summary> /// <returns></returns> public static List <ProjectBlock> FindAll(string projectid) { OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr); string sql = "SELECT * FROM PLM.Project_Block_tab WHERE PROJECT_ID=:projectid ORDER BY DESCRIPTION"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "projectid", DbType.String, projectid); return(EntityBase <ProjectBlock> .DReaderToEntityList(db.ExecuteReader(cmd))); }
/// <summary> /// 查找所有权限信息 /// </summary> /// <returns></returns> public static List <Privilege> FindAll(string cata) { Database db = DatabaseFactory.CreateDatabase(); string sql = "SELECT * FROM PLM.PRIVILEGE_TAB WHERE PRIVILEGE_CATA=:cata ORDER BY PRIVILEGE_ID"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "cata", DbType.String, cata); return(EntityBase <Privilege> .DReaderToEntityList(db.ExecuteReader(cmd))); }
/// <summary> /// 根据项目返回其系统 /// </summary> /// <returns></returns> public static List <ProjectSystem> FindAll(int projectid, string newFlag) { OracleDatabase db = new OracleDatabase(DataAccess.OIDSConnStr); string sql = "SELECT * FROM PLM.PROJECT_SYSTEM_TAB WHERE PROJECT_ID=:projectid AND NEWFLAG=:newflag"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "projectid", DbType.Int32, projectid); db.AddInParameter(cmd, "newflag", DbType.String, newFlag); return(EntityBase <ProjectSystem> .DReaderToEntityList(db.ExecuteReader(cmd))); }