public void SetViewBag(string selectdID = null) { //Tạo IEnumerable<SelectListItem> để đẩy dữ liệu vào dropdownlist var dao = new HouseDao(); ViewBag.MaKhu = new SelectList(dao.ListAll(), "MaKhu", "TenKhu", selectdID); }
public List<FullHouse> Query(QueryHouseServiceForm form) { //form.OwnerID = ""; List<FullHouse> list = new List<FullHouse>(); ISqlMapper mapper = MapperHelper.GetMapper(); HouseDao dao = new HouseDao(mapper); House_CustomerDao hcdao = new House_CustomerDao(mapper); CustomerDao customerdao = new CustomerDao(mapper); BuildingDao buildingdao = new BuildingDao(mapper); var house = dao.QueryFullHouse(form); var houseids = (from h in house select h.ID).ToList(); var hos = hcdao.Query(new House_CustomerQueryForm { HouseOrRoomIDs = houseids }); var customerids = (from ho in hos select ho.CustomerID).Distinct().ToList(); var customers = customerdao.Query(new CustomerQueryForm { IDs = customerids, Enabled = 1, IsDeleted = 0 }); var buildingids = (from h in house select h.BuildingID).Distinct().ToList(); var buidlings = buildingdao.Query(new BuildingQueryForm { IDs = buildingids }); foreach (var h in house) { FullHouse fh = new FullHouse { House = h, Customer = (from ho in hos join c in customers on ho.CustomerID equals c.ID where ho.HouseOrRoomID.Equals(h.ID) select c).FirstOrDefault(), Building = buidlings.Find(t => t.ID.Equals(h.BuildingID)), }; list.Add(fh); } return list; }
/// <summary> /// 获取房间预订信息 /// </summary> /// <param name="baseApi"></param> /// <returns></returns> public object Do_RefundBooking(BaseApi baseApi) { BookingIdParam param = JsonConvert.DeserializeObject <BookingIdParam>(baseApi.param.ToString()); if (param == null) { throw new ApiException(CodeMessage.InvalidParam, "InvalidParam"); } if (param.bookingId == null || param.bookingId == "") { throw new ApiException(CodeMessage.InterfaceValueError, "InterfaceValueError"); } string openId = Utils.GetOpenID(baseApi.token); HouseDao houseDao = new HouseDao(); if (houseDao.refundBooking(param.bookingId)) { UserDao userDao = new UserDao(); Booking booking = userDao.getBooking(param.bookingId); if (userDao.updateUserPrice(booking.userPhone, Convert.ToString(0 - Convert.ToDouble(booking.price)))) { return(userDao.getBookingList(booking.userPhone)); } else { throw new ApiException(CodeMessage.AddPaymentError, "AddPaymentError"); } } else { throw new ApiException(CodeMessage.BookingRefundError, "BookingRefundError"); } }
/// <summary> /// 获取房间预订信息 /// </summary> /// <param name="baseApi"></param> /// <returns></returns> public object Do_GetHouseDataTimeInfoListByBeginTime(BaseApi baseApi) { HouseBookingParam param = JsonConvert.DeserializeObject <HouseBookingParam>(baseApi.param.ToString()); if (param == null) { throw new ApiException(CodeMessage.InvalidParam, "InvalidParam"); } if (param.houseId == null || param.houseId == "") { throw new ApiException(CodeMessage.InterfaceValueError, "InterfaceValueError"); } if (param.checkDate == null || param.checkDate == "") { throw new ApiException(CodeMessage.InterfaceValueError, "InterfaceValueError"); } if (param.beginTime == null || param.beginTime == "") { throw new ApiException(CodeMessage.InterfaceValueError, "InterfaceValueError"); } string openId = Utils.GetOpenID(baseApi.token); HouseDao houseDao = new HouseDao(); return(houseDao.getHouseDataTimeInfoListByBeginTime(param)); }
public int QueryCount(QueryHouseServiceForm form) { form.OwnerID = ""; List<FullHouse> list = new List<FullHouse>(); ISqlMapper mapper = MapperHelper.GetMapper(); HouseDao dao = new HouseDao(mapper); return dao.QueryFullHouseCount(form); }
public List<FullHouse> QueryFullHouse(QueryHouseServiceForm form) { List<FullHouse> list = new List<FullHouse>(); ISqlMapper mapper = MapperHelper.GetMapper(); HouseDao dao = new HouseDao(mapper); House_CustomerDao hcdao = new House_CustomerDao(mapper); CustomerDao customerdao = new CustomerDao(mapper); BuildingDao buildingdao = new BuildingDao(mapper); RentFeeDao rfdao = new RentFeeDao(mapper); House_OtherFeeDao hofdao = new House_OtherFeeDao(mapper); OtherFeeDao ofdao = new OtherFeeDao(mapper); var house = dao.QueryFullHouse(form); var houseids = (from h in house select h.ID).ToList(); var hcs = hcdao.Query(new House_CustomerQueryForm { HouseOrRoomIDs = houseids }); var customerids = (from ho in hcs select ho.CustomerID).Distinct().ToList(); var customers = customerdao.Query(new CustomerQueryForm { IDs = customerids, Enabled = 1, IsDeleted = 0, }); var buildingids = (from h in house select h.BuildingID).Distinct().ToList(); var buidlings = buildingdao.Query(new BuildingQueryForm { IDs = buildingids }); var rentfees = rfdao.Query(new RentFeeQueryForm { HouseOrRoomIDs = houseids, Enabled = 1, IsDeleted = 0 }); var rentfeeids = (from rf in rentfees select rf.ID).ToList(); var hos = hofdao.Query(new House_OtherFeeQueryForm { HouseOrRoomIDs = houseids }); var otherfeeids = (from ho in hos select ho.OtherFeeID).Distinct().ToList(); var ofs = ofdao.Query(new OtherFeeQueryForm { IDs = otherfeeids }); foreach (var h in house) { FullHouse fh = new FullHouse { House = h, Customer = (from ho in hcs join c in customers on ho.CustomerID equals c.ID where ho.HouseOrRoomID.Equals(h.ID) && c.Type == (int)CustomerType.业主 select c).FirstOrDefault(), Building = buidlings.Find(t => t.ID.Equals(h.BuildingID)), RentFee = rentfees.Find(t => t.HouseOrRoomID.Equals(h.ID)), OtherFees = (from ho in hos join of in ofs on ho.OtherFeeID equals of.ID where ho.HouseOrRoomID.Equals(h.ID) select of).ToList(), Renter = (from ho in hcs join c in customers on ho.CustomerID equals c.ID where ho.HouseOrRoomID.Equals(h.ID) && c.Type == (int)CustomerType.租客 select c).FirstOrDefault(), }; list.Add(fh); } return list; }
/// <summary> /// 获取房间信息 /// </summary> /// <param name="baseApi"></param> /// <returns></returns> public object Do_GetHouseList(BaseApi baseApi) { HouseDao houseDao = new HouseDao(); return(houseDao.getHouseList()); }
/// <summary> /// 预订房间 /// </summary> /// <param name="baseApi"></param> /// <returns></returns> public object Do_BookingHouse(BaseApi baseApi) { BookingHouseParam param = JsonConvert.DeserializeObject <BookingHouseParam>(baseApi.param.ToString()); if (param == null) { throw new ApiException(CodeMessage.InvalidParam, "InvalidParam"); } if (param.houseId == null || param.houseId == "") { throw new ApiException(CodeMessage.InterfaceValueError, "InterfaceValueError"); } if (param.checkDate == null || param.checkDate == "") { throw new ApiException(CodeMessage.InterfaceValueError, "InterfaceValueError"); } if (param.beginTime == null || param.beginTime == "") { throw new ApiException(CodeMessage.InterfaceValueError, "InterfaceValueError"); } if (param.userPhone == null || param.userPhone == "") { throw new ApiException(CodeMessage.InterfaceValueError, "InterfaceValueError"); } if (param.endTime == null || param.endTime == "") { throw new ApiException(CodeMessage.InterfaceValueError, "InterfaceValueError"); } if (param.bookingPrice == null || param.bookingPrice == "") { throw new ApiException(CodeMessage.InterfaceValueError, "InterfaceValueError"); } UserDao userDao = new UserDao(); User user = userDao.getUserByPhone(param.userPhone); if (user == null) { throw new ApiException(CodeMessage.BookingUserError, "BookingUserError"); } if (user.price < Convert.ToDouble(param.bookingPrice)) { throw new ApiException(CodeMessage.UserPriceError, "UserPriceError"); } string openId = Utils.GetOpenID(baseApi.token); HouseDao houseDao = new HouseDao(); if (houseDao.bookingHouse(param, openId)) { if (userDao.updateUserPrice(param.userPhone, param.bookingPrice)) { return(user); } else { throw new ApiException(CodeMessage.CutPaymentError, "CutPaymentError"); } } else { throw new ApiException(CodeMessage.BookingInsertError, "BookingInsertError"); } }
public List<House> Query(HouseQueryForm form) { ISqlMapper mapper = MapperHelper.GetMapper(); HouseDao dao = new HouseDao(mapper); return dao.Query(form); }
public List<FullHouse> QueryFullHouse(QueryHouseServiceForm form) { List<FullHouse> list = new List<FullHouse>(); ISqlMapper mapper = MapperHelper.GetMapper(); UserBLL userbll = new UserBLL(); HouseDao dao = new HouseDao(mapper); House_CustomerDao hcdao = new House_CustomerDao(mapper); CustomerDao customerdao = new CustomerDao(mapper); BuildingDao buildingdao = new BuildingDao(mapper); FollowupDao followupdao = new FollowupDao(mapper); form.IsDeleted = 0; var house = dao.QueryFullHouse(form); var houseids = (from h in house select h.ID).ToList(); var hos = hcdao.Query(new House_CustomerQueryForm { HouseOrRoomIDs = houseids }); var customerids = (from ho in hos select ho.CustomerID).Distinct().ToList(); var customers = customerdao.Query(new CustomerQueryForm { IDs = customerids, Enabled = 1, IsDeleted = 0 }); var buildingids = (from h in house select h.BuildingID).Distinct().ToList(); var buidlings = buildingdao.Query(new BuildingQueryForm { IDs = buildingids }); //var ownerids = (from h in house where !string.IsNullOrEmpty(h.OwnerID.Trim()) select h.OwnerID).Distinct().ToList(); var users = userbll.Query(new FullUserQueryForm { Enabled = 1, IsDeleted = 0 }); var followups = followupdao.Query(new FollowupQueryForm { HouseIDs = houseids }); var fullfollowup = (from f in followups join u in users on f.Creator equals u.ID select new FullFollowup { ID = f.ID, Creator = f.Creator, CreateTime = f.CreateTime, HouseID = f.HouseID, Name = f.Name, CreatorName = u.CnName, Remark = f.Remark }).ToList(); //var rentfee = rentfeebll.Query(new RentFeeQueryForm { HouseOrRoomIDs = houseids, Type = (int)HouseOrRoomType.House, Enabled = 1, IsDeleted = 0 }); //var house_otherfee = hobll.Query(new House_OtherFeeQueryForm { HouseOrRoomIDs = houseids, Type = (int)HouseOrRoomType.House }); //var otherfee = ofbll.Query(new OtherFeeQueryForm { Enabled = 1, IsDeleted = 0 }); foreach (var h in house) { FullHouse fh = new FullHouse { House = h, //RentFee = rentfee.Find(t => t.HouseOrRoomID.Equals(h.ID)), //OtherFees = (from ho in house_otherfeeu //join of in otherfee on ho.OtherFeeID equals of.ID //where ho.HouseOrRoomID.Equals(h.ID) //select of).ToList(), Customer = (from ho in hos join c in customers on ho.CustomerID equals c.ID where ho.HouseOrRoomID.Equals(h.ID) select c).FirstOrDefault(), Building = buidlings.Find(t => t.ID.Equals(h.BuildingID)), Owner = users.Find(t => t.ID.Equals(h.OwnerID)), Followups = fullfollowup.FindAll(t => t.HouseID.Equals(h.ID)), }; //rentfee.Remove(fh.RentFee); //house_otherfee.RemoveAll(t => t.HouseOrRoomID.Equals(fh.House.ID)); list.Add(fh); } return list; }
public bool Delete(HouseQueryForm form) { ISqlMapper mapper = MapperHelper.GetMapper(); HouseDao dao = new HouseDao(mapper); return dao.Delete(form); }
public string Add(House House) { ISqlMapper mapper = MapperHelper.GetMapper(); HouseDao dao = new HouseDao(mapper); return dao.Add(House); }
public bool Update(House House) { if (string.IsNullOrEmpty(House.ID)) throw new Exception("没有房间ID"); ISqlMapper mapper = MapperHelper.GetMapper(); HouseDao dao = new HouseDao(mapper); return dao.Update(new HouseUpdateForm { Entity = House, HouseQueryForm = new HouseQueryForm { ID = House.ID } }); }
public int QueryFullHouseCount(QueryHouseServiceForm form) { ISqlMapper mapper = MapperHelper.GetMapper(); HouseDao dao = new HouseDao(mapper); form.IsDeleted = 0; return dao.QueryFullHouseCount(form); }
public HouseLogic(HouseDao dao) { _dao = dao; }