/// <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;
        }
示例#2
0
        /// <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;

        }
示例#3
0
        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;
           
        }
示例#4
0
        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;

        }
示例#5
0
        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;
        }
示例#6
0
        /// <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;          
        }
示例#7
0
        /// <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;
           
        }
示例#8
0
 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();
     }
 }
示例#9
0
 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();
     }
 }