public IList <RoleFieldPermissionsInfo> GetFieldPermissionsById(int roleId, int modelId, string fieldName, OperateCode operateCode)
{
IList <RoleFieldPermissionsInfo> list = new List <RoleFieldPermissionsInfo>();
Parameters cmdParams = new Parameters();
string strCommand = "SELECT * FROM PE_Role_Field_Permissions WHERE 1 = 1";
if (roleId >= 0)
{
strCommand = strCommand + " AND RoleId = @RoleId ";
cmdParams.AddInParameter("@RoleId", DbType.Int32, roleId);
}
if (modelId > 0)
{
strCommand = strCommand + " AND ModelId = @ModelId ";
cmdParams.AddInParameter("@ModelId", DbType.Int32, modelId);
}
if (!string.IsNullOrEmpty(fieldName))
{
strCommand = strCommand + " AND FieldName = @FieldName ";
cmdParams.AddInParameter("@FieldName", DbType.String, fieldName);
}
if (operateCode != OperateCode.None)
{
strCommand = strCommand + " AND OperateCode = @OperateCode ";
cmdParams.AddInParameter("@OperateCode", DbType.Int32, operateCode);
}
using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
{
while (reader.Read())
{
RoleFieldPermissionsInfo item = new RoleFieldPermissionsInfo();
item.RoleId = reader.GetInt32("RoleID");
item.OperateCode = (OperateCode)reader.GetInt32("OperateCode");
item.ModelId = reader.GetInt32("ModelID");
item.FieldName = reader.GetString("FieldName");
list.Add(item);
}
}
return(list);
}
public IList <RoleFieldPermissionsInfo> GetFieldPermissionsById(int id, int modelId, string fieldName, int idType)
{
IList <RoleFieldPermissionsInfo> list = new List <RoleFieldPermissionsInfo>();
Parameters cmdParams = new Parameters();
string strCommand = "SELECT * FROM PE_GroupFieldPermissions WHERE 1 = 1 ";
if ((id > 0) || (id == -2))
{
strCommand = strCommand + " AND GroupID = @GroupID ";
cmdParams.AddInParameter("@GroupID", DbType.Int32, id);
}
if (modelId > 0)
{
strCommand = strCommand + " AND ModelId = @ModelId";
cmdParams.AddInParameter("@ModelId", DbType.Int32, modelId);
}
if (!string.IsNullOrEmpty(fieldName))
{
strCommand = strCommand + " AND FieldName = @FieldName";
cmdParams.AddInParameter("@FieldName", DbType.String, fieldName);
}
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())
{
RoleFieldPermissionsInfo item = new RoleFieldPermissionsInfo();
item.RoleId = reader.GetInt32("GroupID");
item.OperateCode = (OperateCode)reader.GetInt32("OperateCode");
item.ModelId = reader.GetInt32("ModelID");
item.FieldName = reader.GetString("FieldName");
list.Add(item);
}
}
return(list);
}
