/// <summary>
/// 按条件查询调度历史记录
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public static List <ESB_SCHD_HISTORY_VIEW> GetScheduleHistroyByCondition(ScheduleHistoryCondition condition)
{
var pSelect = from p in schedulerDC.ESB_SCHD_HISTORY_VIEW
where
(
p.BEGIN_TIME >= condition.DateScopeBegin &&
p.BEGIN_TIME <= condition.DateScopeEnd &&
p.CALL_STATUS == condition.Status
)
select p;
if (!String.IsNullOrEmpty(condition.Type))
{
pSelect = from p in pSelect
where p.TRIG_GROUP == condition.Type
select p;
}
if (condition.Host != Guid.Empty)
{
pSelect = from p in pSelect
where p.SCHD_HOST == condition.Host
select p;
}
if (!String.IsNullOrEmpty(condition.SchedID))
{
pSelect = from p in pSelect
where p.SCHD_ID == condition.SchedID
select p;
}
return(pSelect.OrderByDescending(p => p.BEGIN_TIME).ToList <ESB_SCHD_HISTORY_VIEW>());
}
public List<ESB_SCHD_HISTORY_VIEW> SearchScheduleHistory(ScheduleHistoryCondition condition)
{
SchedulerLogic schedulerLogic = new SchedulerLogic();
return schedulerLogic.SearchScheduleHistory(condition);
}
/// <summary>
/// 按条件查询调度历史记录
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public List<ESB_SCHD_HISTORY_VIEW> SearchScheduleHistory(ScheduleHistoryCondition condition)
{
try
{
return SchedulerDataAccess.GetScheduleHistroyByCondition(condition);
}
catch (Exception ex)
{
throw new Exception("按条件查询调度历史记录 失败！" + ex.Message);
}
}
/// <summary>
/// 按条件查询调度历史记录
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public static List<ESB_SCHD_HISTORY_VIEW> GetScheduleHistroyByCondition(ScheduleHistoryCondition condition)
{
var pSelect = from p in schedulerDC.ESB_SCHD_HISTORY_VIEW
where
(
p.BEGIN_TIME >= condition.DateScopeBegin
&& p.BEGIN_TIME <= condition.DateScopeEnd
&& p.CALL_STATUS == condition.Status
)
select p;
if (!String.IsNullOrEmpty(condition.Type))
{
pSelect = from p in pSelect
where p.TRIG_GROUP == condition.Type
select p;
}
if (condition.Host != Guid.Empty)
{
pSelect = from p in pSelect
where p.SCHD_HOST == condition.Host
select p;
}
if (!String.IsNullOrEmpty(condition.SchedID))
{
pSelect = from p in pSelect
where p.SCHD_ID == condition.SchedID
select p;
}
return pSelect.OrderByDescending(p=>p.BEGIN_TIME).ToList<ESB_SCHD_HISTORY_VIEW>();
}
