/// <summary>
/// 获取历史记录中 All 所有城市的酒店列表数
/// </summary>
/// <param name="hotelsConsultRoomManagerEntity"></param>
/// <returns></returns>
public static HotelsConsultRoomManagerEntity GetAllCityByTimeManagerHistory(HotelsConsultRoomManagerEntity hotelsConsultRoomManagerEntity)
{
HotelsConsultRoomManagerDBEntity dbParm = (hotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity.Count > 0) ? hotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity[0] : new HotelsConsultRoomManagerDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("GetAllCityByTimeManagerHistory");
cmd.SetParameterValue("@CHECKTIME", dbParm.SDate);
hotelsConsultRoomManagerEntity.QueryResult = cmd.ExecuteDataSet();
return hotelsConsultRoomManagerEntity;
}
/// <summary>
/// 获取当天已询酒店列表--All 酒店Count
/// </summary>
/// <param name="hotelsConsultRoomManagerEntity"></param>
/// <returns></returns>
public static HotelsConsultRoomManagerEntity GetConsultHotelsByManager(HotelsConsultRoomManagerEntity hotelsConsultRoomManagerEntity)
{
HotelsConsultRoomManagerDBEntity dbParm = (hotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity.Count > 0) ? hotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity[0] : new HotelsConsultRoomManagerDBEntity();
DataCommand cmd = DataCommandManager.GetDataCommand("GetConsultHotelsByManager");
cmd.SetParameterValue("@StartDate", dbParm.SDate);
cmd.SetParameterValue("@EndDate", dbParm.EDate);
hotelsConsultRoomManagerEntity.QueryResult = cmd.ExecuteDataSet();
return hotelsConsultRoomManagerEntity;
}
public static HotelsConsultRoomManagerEntity GetConsultHotelsBySales(HotelsConsultRoomManagerEntity hotelsConsultRoomManagerEntity)
{
hotelsConsultRoomManagerEntity.LogMessages.MsgType = MessageType.INFO;
hotelsConsultRoomManagerEntity.LogMessages.Content = _nameSpaceClass + "GetAllCityByTimeManagerHistory";
LoggerHelper.LogWriter(hotelsConsultRoomManagerEntity.LogMessages);
try
{
return HotelsConsultRoomManagerDA.GetConsultHotelsBySales(hotelsConsultRoomManagerEntity);
}
catch (Exception ex)
{
hotelsConsultRoomManagerEntity.LogMessages.MsgType = MessageType.ERROR;
hotelsConsultRoomManagerEntity.LogMessages.Content = _nameSpaceClass + "GetAllCityByTimeManagerHistory Error: " + ex.Message;
LoggerHelper.LogWriter(hotelsConsultRoomManagerEntity.LogMessages);
throw ex;
}
}
public static HotelsConsultRoomManagerEntity GetCheck18EXDConsultHotelCountLogsByManager(HotelsConsultRoomManagerEntity hotelsConsultRoomManagerEntity)
{
hotelsConsultRoomManagerEntity.LogMessages.MsgType = MessageType.INFO;
hotelsConsultRoomManagerEntity.LogMessages.Content = _nameSpaceClass + "GetCheck18EXDConsultHotelCountLogsByManager";
LoggerHelper.LogWriter(hotelsConsultRoomManagerEntity.LogMessages);
try
{
return HotelsConsultRoomManagerDA.GetCheck18EXDConsultHotelCountLogsByManager(hotelsConsultRoomManagerEntity);
}
catch (Exception ex)
{
hotelsConsultRoomManagerEntity.LogMessages.MsgType = MessageType.ERROR;
hotelsConsultRoomManagerEntity.LogMessages.Content = _nameSpaceClass + "GetCheck18EXDConsultHotelCountLogsByManager Error: " + ex.Message;
LoggerHelper.LogWriter(hotelsConsultRoomManagerEntity.LogMessages);
throw ex;
}
}
/// <summary>
/// All下面 所有的酒店列表
/// </summary>
/// <param name="appContentEntity"></param>
/// <returns></returns>
public static HotelsConsultRoomManagerEntity GetConsultManagerAllCitysByManager(HotelsConsultRoomManagerEntity hotelsConsultRoomManagerEntity)
{
hotelsConsultRoomManagerEntity.QueryResult = DbManager.Query("HotelsConsultRoomManager", "get_oracle_consultallcitys_bymanager", true);
return hotelsConsultRoomManagerEntity;
}
/// <summary>
/// 获取每个房控人员 所对应的（酒店 城市 商圈）酒店数
/// </summary>
/// <returns></returns>
public static HotelsConsultRoomManagerEntity GetOracleHotelsByConsultPeopleByManager(HotelsConsultRoomManagerEntity hotelsConsultRoomManagerEntity)
{
OracleParameter[] parm ={
new OracleParameter("CHECKUSERNAME",OracleType.VarChar)
};
HotelsConsultRoomManagerDBEntity dbParm = (hotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity.Count > 0) ? hotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity[0] : new HotelsConsultRoomManagerDBEntity();
if (String.IsNullOrEmpty(dbParm.CheckUserName))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.CheckUserName;
}
hotelsConsultRoomManagerEntity.QueryResult = DbManager.Query("HotelsConsultRoomManager", "get_oracle_hotels_byconsultprople", true, parm);
return hotelsConsultRoomManagerEntity;
}
/// <summary>
/// 根据 商圈 城市 来获取酒店该名下的酒店列表
/// </summary>
/// <param name="keys"></param>
/// <returns></returns>
public static HotelsConsultRoomManagerEntity GetHotelsByKeysByManager(HotelsConsultRoomManagerEntity hotelsConsultRoomManagerEntity)
{
OracleParameter[] parm ={
new OracleParameter("KEYID",OracleType.VarChar)
};
HotelsConsultRoomManagerDBEntity dbParm = (hotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity.Count > 0) ? hotelsConsultRoomManagerEntity.HotelsConsultRoomManagerDBEntity[0] : new HotelsConsultRoomManagerDBEntity();
if (String.IsNullOrEmpty(dbParm.KeyID))
{
parm[0].Value = DBNull.Value;
}
else
{
parm[0].Value = dbParm.KeyID;
}
hotelsConsultRoomManagerEntity.QueryResult = DbManager.Query("HotelsConsultRoomManager", "get_oracle_hotelsdetail_bykeys", true, parm);
return hotelsConsultRoomManagerEntity;
}
/// <summary>
/// 获取所有的销售人员（过滤计划需要）
/// </summary>
/// <param name="ValueString"></param>
/// <returns></returns>
public static DataSet GetSalesManagerList(HotelsConsultRoomManagerEntity hotelsConsultRoomManagerEntity)
{
hotelsConsultRoomManagerEntity.LogMessages.MsgType = MessageType.INFO;
hotelsConsultRoomManagerEntity.LogMessages.Content = _nameSpaceClass + "GetSalesManagerList";
LoggerHelper.LogWriter(hotelsConsultRoomManagerEntity.LogMessages);
try
{
return HotelsConsultRoomManagerDA.GetSalesManagerList();
}
catch (Exception ex)
{
hotelsConsultRoomManagerEntity.LogMessages.MsgType = MessageType.ERROR;
hotelsConsultRoomManagerEntity.LogMessages.Content = _nameSpaceClass + "GetSalesManagerList Error: " + ex.Message;
LoggerHelper.LogWriter(hotelsConsultRoomManagerEntity.LogMessages);
throw ex;
}
}