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