public IList <RoleSpecialPermissionsInfo> GetSpecialPermissionsBySpecialId(int specialId)
{
IList <RoleSpecialPermissionsInfo> list = new List <RoleSpecialPermissionsInfo>();
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@SpecialID", DbType.Int32, specialId);
string strCommand = "SELECT * FROM PE_Role_Special_Permissions WHERE SpecialID = @SpecialID";
using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
{
while (reader.Read())
{
RoleSpecialPermissionsInfo item = new RoleSpecialPermissionsInfo();
item.GroupId = reader.GetInt32("RoleID");
item.OperateCode = (OperateCode)reader.GetInt32("OperateCode");
item.SpecialId = reader.GetInt32("SpecialID");
list.Add(item);
}
}
return(list);
}
public IList <RoleSpecialPermissionsInfo> GetSpecialPermissionsList(int id, int specialId, OperateCode operateCode, int idType)
{
IList <RoleSpecialPermissionsInfo> list = new List <RoleSpecialPermissionsInfo>();
Parameters cmdParams = new Parameters();
string strCommand = "SELECT * FROM PE_GroupSpecialPermissions WHERE 1 = 1";
if ((id > 0) || (id == -2))
{
strCommand = strCommand + " AND GroupID = @GroupID ";
cmdParams.AddInParameter("@GroupID", DbType.Int32, id);
}
if ((specialId > 0) || (specialId == -1))
{
strCommand = strCommand + " AND SpecialID = @SpecialID ";
cmdParams.AddInParameter("@SpecialID", DbType.Int32, specialId);
}
if (operateCode != OperateCode.None)
{
strCommand = strCommand + " AND OperateCode = @OperateCode ";
cmdParams.AddInParameter("@OperateCode", DbType.Int32, operateCode);
}
if (idType >= 0)
{
strCommand = strCommand + " AND IdType = @IdType ";
cmdParams.AddInParameter("@IdType", DbType.Int32, idType);
}
using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
{
while (reader.Read())
{
RoleSpecialPermissionsInfo item = new RoleSpecialPermissionsInfo();
item.GroupId = reader.GetInt32("GroupID");
item.OperateCode = (OperateCode)reader.GetInt32("OperateCode");
item.SpecialId = reader.GetInt32("SpecialID");
list.Add(item);
}
}
return(list);
}
