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;
}
