相信很多小伙伴在做酒店管理项目客房预订模块时会用到实时统计客房可预订的功能,这样不但可以清晰的看到酒店的客房可预订数量而且还便于做报表做统计、数据一目了然。那么我们如何实现分类统计未来一周的客房预订情况的功能呢?下面我们来实现一下。
Controller层:
public ActionResult selectTongJiRoomInfor(DateTime TStartDate, DateTime TEndDate)
{
int QuanBuFangShu = 0;//总房
List<string> roominfor = new List<string>();
TimeSpan date = TEndDate.Subtract(TStartDate);
int intdaterow = date.Days;//两个日期相隔的天数
List<RoomLevetVoL> RoomLevet = (from tbRoom in MyModel.S_RoomLevel
select new RoomLevetVoL
{
RoomLevelID = tbRoom.RoomLevelID,
RoomLevelMC = tbRoom.RoomLevelMC
}).ToList();
for (int r = 0; r < RoomLevet.Count; r++)
{
string zanfanggaulv = "";//概率,加入字符串
int RoomLevetid = RoomLevet[r].RoomLevelID;//循环所有的房间等级ID
string RoomMC = RoomLevet[r].RoomLevelMC;
//全部房数
List<RoomInforVoL> linqRoomcount = (from tbroomInfor in MyModel.R_RoomInfor
join tbRoomlevel in MyModel.S_RoomLevel on tbroomInfor.RoomLevelID equals tbRoomlevel.RoomLevelID
where tbroomInfor.RoomLevelID == RoomLevetid
select new RoomInforVoL
{
RoomID = tbroomInfor.RoomID,
}).ToList();
QuanBuFangShu = linqRoomcount.Count();
for (int i = 0; i <=