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