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