public HouseBookingDateTimeInfo getHouseDataTimeInfoList(HouseBookingParam param)
{
HouseBookingDateTimeInfo houseBookingDateTimeInfo = new HouseBookingDateTimeInfo();
houseBookingDateTimeInfo.beginTimes = new List <string>();
houseBookingDateTimeInfo.endTimes = new List <string>();
House house = getHouseByHouseId(param.houseId);
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.SELECT_HOUSELIST_TIME_BY_HOUSEID_AND_DATA, param.houseId, param.checkDate);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
DateTime begin = Convert.ToDateTime(param.checkDate + " 09:00:00");
DateTime end = Convert.ToDateTime(param.checkDate + " 19:00:00");
List <string> beginTimes = new List <string>();
List <string> endTimes = new List <string>();
List <string> bookingPrices = new List <string>();
DateTime dateTime = begin;
int i = 0;
int count = 0;
bool ifEndClose = false;
while (dateTime < end)
{
if (i == dt.Rows.Count || dateTime.AddMinutes(30) <= Convert.ToDateTime(dt.Rows[i]["BOOKING_TIME_FROM"]))
{
beginTimes.Add(dateTime.ToString("HH:mm"));
dateTime = dateTime.AddMinutes(15);
count++;
if (!ifEndClose)
{
endTimes.Add(dateTime.ToString("HH:mm"));
bookingPrices.Add(Convert.ToString(Convert.ToDouble(house.hourPrice) / 4 * count));
}
}
else
{
dateTime = Convert.ToDateTime(dt.Rows[i]["BOOKING_TIME_END"]).AddMinutes(15);
i++;
if (endTimes.Count > 0)
{
ifEndClose = true;
}
}
}
houseBookingDateTimeInfo.beginTimes = beginTimes;
houseBookingDateTimeInfo.endTimes = endTimes;
houseBookingDateTimeInfo.bookingPrices = bookingPrices;
return(houseBookingDateTimeInfo);
}
public HouseBookingDateInfo getHouseBookingDateInfo(HouseBookingParam param)
{
HouseBookingDateInfo houseBookingDateInfo = new HouseBookingDateInfo();
houseBookingDateInfo.todoDayList = new List <TodoDay>();
houseBookingDateInfo.disableDayList = new List <DisableDay>();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.SELECT_HOUSELIST_DATA_BY_HOUSEID, param.houseId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["BOOKINGTYPE"].ToString() == "1")
{
DisableDay disableDay = new DisableDay
{
year = dt.Rows[i]["BOOKINGYEAR"].ToString(),
month = dt.Rows[i]["BOOKINGMONTH"].ToString(),
day = dt.Rows[i]["BOOKINGDAY"].ToString(),
};
houseBookingDateInfo.disableDayList.Add(disableDay);
}
else
{
string todoText = "";
if (param.userPhone != "")
{
if (param.userPhone == dt.Rows[i]["BOOKINGYEAR"].ToString())
{
todoText = "预订";
}
}
TodoDay todoDay = new TodoDay
{
year = dt.Rows[i]["BOOKINGYEAR"].ToString(),
month = dt.Rows[i]["BOOKINGMONTH"].ToString(),
day = dt.Rows[i]["BOOKINGDAY"].ToString(),
todoText = todoText,
};
houseBookingDateInfo.todoDayList.Add(todoDay);
}
}
}
houseBookingDateInfo.house = getHouseByHouseId(param.houseId);
return(houseBookingDateInfo);
}
