public bool insertStatuBatch(RoomStatus_batch roomStatus) { bool result = false; try { using(DBC.HotelDBContent db=new DBC.HotelDBContent()) { //roomStatus.r_s_time = p.room_rp_start_time; //roomStatus.EndDate = p.room_rp_end_time; //roomStatus.room_id = p.room_id; //roomStatus.hotel_id = p.hotel_id; roomStatus.OverBooking = true; //roomStatus.r_s_status = true; roomStatus.HpStatus = 0; roomStatus.AuditDate = DateTime.Now; roomStatus.r_s_utime = DateTime.Now; roomStatus.r_s_ctime = DateTime.Now; db.publicStatuses.Add(roomStatus); result = db.SaveChanges() > 0 ? true : false; if (result) DBhelp.CallProc(roomStatus.room_id, "[proc_hotel_room_ebeds_batch_roomid]"); } } catch (Exception e) { help.DBhelp.log("插入Roombatch" + e.ToString()); result = false; } return result; }
//修改房态 public int uStatus(string id, string roomId, string startDate, string EndDate, string CanSell, string status) { int result = 0; int Id, room_id, count = 0; int Rstatus; int RCanSell; int.TryParse(status, out Rstatus); int.TryParse(CanSell, out RCanSell); int.TryParse(id, out Id); int.TryParse(roomId, out room_id); DateTime.TryParse(startDate, out start); DateTime.TryParse(EndDate, out end); using (db = new HotelDBContent()) { count = (from r in db.rooms where r.hotel_id == Id && r.room_id == room_id select r).Count(); } if (count > 0) result = new RoomStatus_batch().insertStatuBatch(new RoomStatus_batch() { hotel_id = Id, room_id = room_id, r_s_time = start, EndDate = end, eBeds = RCanSell,r_s_status = Rstatus==1?true:false}) == true && DBhelp.CallProc(room_id, "proc_hotel_room_ebeds_batch_roomid") == true ? 1 : 0; // result = new RoomStatus_batch().insertStatuBatch(new RoomStatus_batch() { hotel_id = Id, room_id = room_id, r_s_time = start, EndDate = end, eBeds = RCanSell }) == true?1 : 0; return result; }
/// <summary> /// 房态首次数据插入 /// </summary> /// <param name="p"></param> /// <returns></returns> public bool insertStatuBatch(hotel_room_RP_price_info p) { bool result = false; try { using(DBC.HotelDBContent db=new DBC.HotelDBContent()) { RoomStatus_batch roomStatus = new RoomStatus_batch(); roomStatus.r_s_time = p.room_rp_start_time; roomStatus.EndDate = p.room_rp_end_time; roomStatus.room_id = p.room_id; roomStatus.hotel_id = p.hotel_id; roomStatus.OverBooking = true; roomStatus.HpStatus = 0; roomStatus.r_s_status = true; roomStatus.r_s_utime = DateTime.Now; roomStatus.r_s_ctime = DateTime.Now; string number = (from r in db.rooms where r.room_id == p.room_id select r.h_r_house_number).SingleOrDefault(); int roomNubmer; int.TryParse(number, out roomNubmer); roomStatus.r_s_number = roomNubmer; roomStatus.eBeds = roomNubmer; db.publicStatuses.Add(roomStatus); result = db.SaveChanges() > 0 ? true : false; // DBhelp.CallProc(roomStatus.room_id, "[proc_hotel_room_ebeds_batch_roomid]"); //} } } catch (Exception e) { help.DBhelp.log("插入Roombatch" + e.ToString()); result = false; } return result; }