示例#1
0
 public static string getQuerySaveRoom(Room room)
 {
     return string.Format("INSERT INTO {0} VALUES('{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", ID_TABLE_ROOM,
         room.Id,
         room.Cell.Id,
         room.Surface,
         room.Volumen,
         room.MaxOcup,
         room.Description,
         room.LocalInsertTime.ToString(DATETIMEFORMATINSERT_ROOM),
         room.InsertUser,
         room.UpdateLocalDateTime.ToString(DATETIMEFORMATINSERT_ROOM),
         room.UpdateUser);
 }
示例#2
0
 public static string getQueryUpdateRoom(Room room)
 {
     return string.Format("UPDATE {0} SET {1}='{2}', {3}='{4}',{5}='{6}' ,{7}='{8}' ,{9}='{10}',{11}='{12}',{13}='{14}' WHERE {15}='{16}'",
          ID_TABLE_ROOM,
          ID_CELL_ROOM,room.Cell.Id,
          ID_SURFACE_ROOM,room.Surface,
          ID_VOLUMEN_ROOM,room.Volumen,
          ID_MAX_OCUP_ROOM,room.MaxOcup,
          ID_DESCRIPTION_ROOM, room.Description,
          ID_UPDATETIME_ROOM, room.UpdateLocalDateTime.ToString(DATETIMEFORMAT_ROOM),
          ID_UPDATEUSER_ROOM, room.UpdateUser,
          ID_ID_ROOM, room.Id
         );
 }
示例#3
0
        public static IList<Room> ParseDataSetToRoom(DataTable dataTable)
        {
            IList<Room> roomList = new List<Room>();
            foreach (DataRow row in dataTable.Rows)
            {
                Room room = new Room()
                {
                    Id = row[POSITION_ID_ROOM].ToString(),
                    Cell=new Cell(row[POSITION_CELL_ROOM].ToString()),
                    Surface=Double.Parse(row[POSITION_SURFACE_ROOM].ToString()),
                    Volumen = Double.Parse(row[POSITION_VOLUMEN_ROOM].ToString()),
                    MaxOcup = int.Parse(row[POSITION_MAX_OCUP_ROOM].ToString()),
                    Description = row[POSITION_DESCRIPTION_ROOM].ToString(),
                    LocalInsertTime = getDateTime(row[POSITION_INSERTTIME_ROOM].ToString(), DATETIMEFORMATINSERT_ROOM),
                    InsertUser = row[POSITION_INSERTUSER_ROOM].ToString(),
                    UpdateLocalDateTime = getDateTime(row[POSITION_UPDATETIME_ROOM].ToString(),DATETIMEFORMATINSERT_ROOM),
                    UpdateUser = row[POSITION_UPDATEUSER_ROOM].ToString()
                };
                roomList.Add(room);
            }

            return roomList;
        }
示例#4
0
 public void Update(Room room)
 {
     _repositoryHelper.UpdateRoom(room);
 }
示例#5
0
 public void Save(Room room)
 {
     _repositoryHelper.SaveRoom(room);
 }
示例#6
0
 public bool Exists(Room room)
 {
     return Get(room.Id) != null;
 }
示例#7
0
 internal void UpdateRoom(Room room)
 {
     string query = RoomQuery.getQueryUpdateRoom(room);
     RoomQuery.ParseDataSetToRoom(_provider.queryExecute(query,UPDATE_TYPE));
 }
示例#8
0
 internal void SaveRoom(Room room)
 {
     string query = RoomQuery.getQuerySaveRoom(room);
     RoomQuery.ParseDataSetToRoom(_provider.queryExecute(query,INSERT_TYPE));
 }