public Room QueryByName(string name)
{
Room result = null;
RoomHibernate hibernate = new RoomHibernate();
result = hibernate.QueryByName(name);
return result;
}
public Room QueryByGuid(string guid)
{
Room result = null;
RoomHibernate hibernate = new RoomHibernate();
result = hibernate.QueryByGuid(guid);
return result;
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="page">页码</param>
/// <param name="rows">每页行数</param>
/// <param name="total">总数</param>
/// <returns>机房集合</returns>
public List<Room> Query(int page, int rows, ref int total)
{
List<Room> results = new List<Room>();
RoomHibernate hibernate = new RoomHibernate();
results = hibernate.Query(page, rows, ref total);
return results;
}
/// <summary>
/// 增加
/// </summary>
/// <param name="value">值</param>
/// <returns>结果</returns>
public bool Insert(Room value)
{
bool result = false;
RoomHibernate hibernate = new RoomHibernate();
result = hibernate.Insert(value);
return result;
}
public bool Delete(Room value)
{
bool result = false;
RoomHibernate hibernate = new RoomHibernate();
result = hibernate.Delete(value);
return result;
}
public List<Room> RefreshRooms(User value)
{
List<Room> results = null;
RoomHibernate roomHibernate = new RoomHibernate();
int total = 0;
List<Room> rooms = roomHibernate.Query(1, int.MaxValue, ref total);
if (value.Prerogative)
{
results = rooms;
}
else
{
UserRoomHiberante userRoomHiberante = new UserRoomHiberante();
List<UserRoom> userRooms = userRoomHiberante.QueryByUser(1, int.MaxValue, ref total, value.Guid);
if ((userRooms != null) && (userRooms.Count > 0))
{
if ((rooms != null) && (rooms.Count > 0))
{
results = new List<Room>();
for (int i = 0; i < userRooms.Count; i++)
{
for (int j = 0; j < rooms.Count; j++)
{
if (string.Equals(userRooms[i].RoomId, rooms[j].Guid, StringComparison.CurrentCulture))
{
results.Add(rooms[j]);
break;
}
}
}
}
}
}
return results;
}
