/// <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)));
}
