/// <summary> /// 获取所有的销售人员 /// </summary> private DataTable GetSalesManagerLisByManager() { DataTable dtNewResult = new DataTable(); _HotelsConsultRoomManagerEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _HotelsConsultRoomManagerEntity.LogMessages.Userid = UserSession.Current.UserAccount; _HotelsConsultRoomManagerEntity.LogMessages.Username = UserSession.Current.UserDspName; _HotelsConsultRoomManagerEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _HotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity = new List<HotelsConsultRoomManagerDBEntity>(); HotelsConsultRoomManagerDBEntity hotelsConsultRoomManagerDBEntity = new HotelsConsultRoomManagerDBEntity(); _HotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity.Add(hotelsConsultRoomManagerDBEntity); DataTable dtSales = HotelsConsultRoomManagerBP.GetSalesManagerList(_HotelsConsultRoomManagerEntity).Tables[0]; return dtSales; }
/// <summary> /// 获取当天所有询房人员 已询酒店的总数(返回每个人对应的酒店数) /// </summary> /// <returns></returns> public DataTable GetEXDConsultHotelCountLogsByManager(string SDate, string EDate) { DataTable dtNewResult = new DataTable(); _HotelsConsultRoomManagerEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _HotelsConsultRoomManagerEntity.LogMessages.Userid = UserSession.Current.UserAccount; _HotelsConsultRoomManagerEntity.LogMessages.Username = UserSession.Current.UserDspName; _HotelsConsultRoomManagerEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _HotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity = new List<HotelsConsultRoomManagerDBEntity>(); HotelsConsultRoomManagerDBEntity hotelsConsultRoomManagerDBEntity = new HotelsConsultRoomManagerDBEntity(); hotelsConsultRoomManagerDBEntity.SDate = SDate; hotelsConsultRoomManagerDBEntity.EDate = EDate; _HotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity.Add(hotelsConsultRoomManagerDBEntity); DataTable dtResult = HotelsConsultRoomManagerBP.GetEXDConsultHotelCountLogsByManager(_HotelsConsultRoomManagerEntity).QueryResult.Tables[0]; return dtResult; }
/// <summary> /// 获取每个人 对应的(酒店 城市 商圈)酒店数 /// </summary> /// <param name="salesID"></param> /// <returns></returns> public DataTable GetHotelsChargeByManager(string CheckUserName) { DataTable dtNewResult = new DataTable(); _HotelsConsultRoomManagerEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _HotelsConsultRoomManagerEntity.LogMessages.Userid = UserSession.Current.UserAccount; _HotelsConsultRoomManagerEntity.LogMessages.Username = UserSession.Current.UserDspName; _HotelsConsultRoomManagerEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _HotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity = new List<HotelsConsultRoomManagerDBEntity>(); HotelsConsultRoomManagerDBEntity hotelsConsultRoomManagerDBEntity = new HotelsConsultRoomManagerDBEntity(); hotelsConsultRoomManagerDBEntity.CheckUserName = CheckUserName; _HotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity.Add(hotelsConsultRoomManagerDBEntity); DataTable dtResult = HotelsConsultRoomManagerBP.GetOracleHotelsByConsultPeopleByManager(_HotelsConsultRoomManagerEntity).QueryResult.Tables[0]; return dtResult; }
/// <summary> /// 获取历史记录中 每个询房人员对应的酒店详细列表(已询酒店列表) /// </summary> /// <param name="SDate"></param> /// <returns></returns> public DataTable GetConsultRoomByTimeAndUserManagerHistory(string SDate, string CheckUserName) { DataTable dtNewResult = new DataTable(); _HotelsConsultRoomManagerEntity.LogMessages = new HotelVp.Common.Logger.LogMessage(); _HotelsConsultRoomManagerEntity.LogMessages.Userid = UserSession.Current.UserAccount; _HotelsConsultRoomManagerEntity.LogMessages.Username = UserSession.Current.UserDspName; _HotelsConsultRoomManagerEntity.LogMessages.IpAddress = UserSession.Current.UserIP; _HotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity = new List<HotelsConsultRoomManagerDBEntity>(); HotelsConsultRoomManagerDBEntity hotelsConsultRoomManagerDBEntity = new HotelsConsultRoomManagerDBEntity(); hotelsConsultRoomManagerDBEntity.SDate = SDate; hotelsConsultRoomManagerDBEntity.CheckUserName = CheckUserName; _HotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity.Add(hotelsConsultRoomManagerDBEntity); DataTable dtResult = HotelsConsultRoomManagerBP.GetConsultRoomByTimeAndUserManagerHistory(_HotelsConsultRoomManagerEntity).QueryResult.Tables[0]; return dtResult; }