/// <summary> /// 插入价格 /// </summary> /// <param name="p"></param> /// <returns></returns> public bool InsertPriceBatch(hotel_room_RP_price_info p) { bool result = false; try { using (DBC.HotelDBContent db = new DBC.HotelDBContent()) { Hotel_room_RP_info rp = new Hotel_room_RP_info(); rp.h_room_rp_name_cn = "标准价"; rp.hotel_id = p.hotel_id; Hotel_room_RP_price_batch pBacth = new Hotel_room_RP_price_batch(); pBacth.Addbed = -1; pBacth.HpStatus = 0; pBacth.Room_rp_id = help.HotelInfoHelp.getRatePlanId(rp); DateTime start = p.room_rp_start_time; DateTime end = p.room_rp_end_time; pBacth.Room_rp_start_time = start; pBacth.Room_rp_end_time = end; pBacth.Room_id = p.room_id; pBacth.Hotel_id = p.hotel_id; pBacth.Price = p.room_rp_price; pBacth.Idate = DateTime.Now; pBacth.Hpdate = DateTime.Now; pBacth.AuditDate = DateTime.Now; db.publicPrices.Add(pBacth); result=db.SaveChanges()>0?true:false; //DBhelp.CallProc(p.room_id, "proc_hotel_room_RP_price_batch_roomid"); } } catch (Exception e) { result = false; } return result; }
/// <summary> /// 修改用户 /// </summary> /// <param name="room_id"></param> /// <param name="hotel_room_info"></param> /// <returns></returns> public int updateUser(Merchant_info mer) { int result = 0; try { using (DBC.HotelDBContent db = new DBC.HotelDBContent()) { var merchant = (from m in db.Merchant_infos where m.id == mer.id select m).Single(); if (merchant != null) { //Merchant_info m = new Merchant_info(); // string f = mer.password != "******" ? new help.HotelInfoHelp().Md5(mer.password) : merchant.password; merchant.utime = DateTime.Now; merchant.password = mer.password != "******" ? new help.HotelInfoHelp().Md5(mer.password) : merchant.password; merchant.utime = DateTime.Now; merchant.name = mer.name; merchant.tel = mer.tel; merchant.Sex = mer.Sex; merchant.startTime = mer.startTime; merchant.endTime = mer.endTime; merchant.limit = mer.limit; merchant.limitName = mer.limitName; merchant.limitHotelId = mer.limitHotelId; merchant.limitHotelName = mer.limitHotelName; result = db.SaveChanges() > 0 ? 1 : 0; ; } } } catch (Exception) { result = 0; throw; } return result; }
public List<Order_info> getOrderInfos(orderStatus state) { int orderState = (int)state;; List<Order_info> list=new List<Order_info>(); try { using (DBC.HotelDBContent db = new DBC.HotelDBContent()) { string uId = new HotelInfoHelp().getUId(); int[] rf = (from h in db.hotel where h.u_id == uId select h.hotel_id).ToArray(); list = (from o in db.orders where rf.Contains(o.hotel_id) && o.o_state_id == orderState select o).ToList(); } // uId = "test1"; // var f = from h in db.drrs where rf.Contains(h.hotel_id) select h; } catch (Exception e) { throw e; } return list; }
public List<Order_info> getOrderInfos(string start,string end, Order_info order) { int orderState = 0; DateTime s, e; DateTime.TryParse(start, out s); DateTime.TryParse(end, out e); List<Order_info> list = new List<Order_info>(); // int.TryParse(state.ToString(), out orderState); try { using (DBC.HotelDBContent db = new DBC.HotelDBContent()) { string uId = new HotelInfoHelp().getUId(); int[] rf = (from h in db.hotel where h.u_id == uId select h.hotel_id).ToArray(); list = (from o in db.orders where rf.Contains(o.hotel_id) && o.o_ctime >= s && o.o_ctime<=e select o).ToList(); } // uId = "test1"; // var f = from h in db.drrs where rf.Contains(h.hotel_id) select h; } catch (Exception ex) { throw ex; } return list; }
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; }
/// <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; }
/// <summary> /// 修改房型 /// </summary> /// <param name="room_id"></param> /// <param name="hotel_room_info"></param> /// <returns></returns> public bool updateRoom(hotel_room_info hotel_room_info) { bool result = false; try { using (DBC.HotelDBContent db = new DBC.HotelDBContent()) { var room = (from r in db.rooms where r.room_id == hotel_room_info.room_id select r).Single(); if (room != null) { room.h_r_name_cn = hotel_room_info.h_r_name_cn; room.h_r_bed_type = hotel_room_info.h_r_bed_type; room.h_r_description_cn = hotel_room_info.h_r_description_cn; room.h_r_floor = hotel_room_info.h_r_floor; room.Comments = hotel_room_info.Comments; room.house_service = hotel_room_info.house_service; room.sitting_room_number = hotel_room_info.sitting_room_number; room.study = hotel_room_info.study; room.h_r_bathroom_number = hotel_room_info.h_r_bathroom_number; room.KitchenNumber = hotel_room_info.KitchenNumber; room.Balcony = hotel_room_info.Balcony; room.h_r_bedroom_number = hotel_room_info.h_r_bedroom_number; room.h_r_utime = DateTime.Now; room.h_r_people_number = hotel_room_info.h_r_people_number; room.h_r_house_number = hotel_room_info.h_r_house_number; room.h_r_acreage = hotel_room_info.h_r_acreage; room.defaultPrice = hotel_room_info.DefaultPrice; result = db.SaveChanges() > 0 ? true : false; ; } } } catch (Exception) { result = false; throw; } return result; }
public List<hotel_room_info> getRoomsByHoltelId(int hotelId) { using (DBC.HotelDBContent db = new DBC.HotelDBContent()) { return (from r in db.rooms where r.hotel_id == hotelId select r).ToList(); } }
public List<DrrRules> getDrrsByHoltelId(int hotelId) { using (DBC.HotelDBContent db = new DBC.HotelDBContent()) { return (from r in db.drrs where r.hotel_id == hotelId select r).ToList(); } }