private void RefreshAlarmHandleInfo(int pageindex, int pagesize)
{
DateTime stime = Convert.ToDateTime(dateEdit3.Text).Date;
DateTime etime = Convert.ToDateTime(dateEdit4.Text).Date;
if (stime > etime)
{
XtraMessageBox.Show("开始时间不应大于结束时间");
return;
}
TimeSpan span = etime.Subtract(stime);
if (span.TotalDays > 2)
{
XtraMessageBox.Show("查询时间不能大于3天");
return;
}
SetExecuteBeginTime();
AlarmHandelGetByStimeAndETime request = new AlarmHandelGetByStimeAndETime()
{
Stime = stime,
Etime = etime,
PagerInfo = new PagerInfo
{
PageIndex = pageindex,
PageSize = pagesize
}
};
var alarmHandleresponse = alarmHandleService.GetAlarmHandleByStimeAndEtime(request);
if (alarmHandleresponse != null && alarmHandleresponse.IsSuccess)
{
AlarmHandleInfos = alarmHandleresponse.Data;
this.logicAlarmGrid.DataSource = AlarmHandleInfos;
SetPageInfo(alarmHandleresponse.PagerInfo);
}
}
public BasicResponse <List <JC_AlarmHandleInfo> > GetAlarmHandleByStimeAndEtime(AlarmHandelGetByStimeAndETime alarmHandelRequest)
{
return(alarmHandleService.GetAlarmHandleByStimeAndEtime(alarmHandelRequest));
}
public BasicResponse <List <JC_AlarmHandleInfo> > GetAlarmHandleByStimeAndEtime(AlarmHandelGetByStimeAndETime alarmHandelRequest)
{
var responsestr = HttpClientHelper.Post(Webapi + "/v1/KJ73NApp/GetAlarmHandleByStimeAndEtime?token=" + Token, JSONHelper.ToJSONString(alarmHandelRequest));
return(JSONHelper.ParseJSONString <BasicResponse <List <JC_AlarmHandleInfo> > >(responsestr));
}
/// <summary>
/// 根据开始时间和结束时间获取报警列表
/// </summary>
/// <param name="alarmHandelRequest"></param>
/// <returns></returns>
public BasicResponse <List <JC_AlarmHandleInfo> > GetAlarmHandleByStimeAndEtime(AlarmHandelGetByStimeAndETime alarmHandelRequest)
{
try
{
var stime = alarmHandelRequest.Stime.Date;
var etime = alarmHandelRequest.Etime.AddDays(1).AddSeconds(-1);
int pageindex = alarmHandelRequest.PagerInfo.PageIndex;
int pagesize = alarmHandelRequest.PagerInfo.PageSize;
DateTime noneEndTime = new DateTime(1900, 1, 1, 0, 0, 0);
BasicResponse <List <JC_AlarmHandleInfo> > alarmresponse = new BasicResponse <List <JC_AlarmHandleInfo> >();
//获取逻辑报警数据：当结束时间等于1990-01-01 00:00:00时取开始时间<etime;反之取开始时间<etime且结束时间>stime
var query = _Repository.Datas.Where(alarm =>
(alarm.StartTime <etime && alarm.EndTime> stime) ||
(alarm.StartTime < etime && alarm.EndTime.Equals(noneEndTime)))
.OrderBy(alarm => alarm.StartTime);
int rowcount = query.Count();
var responseList = query.Skip((pageindex - 1) * pagesize).Take(pagesize).ToList();
List <JC_AlarmHandleInfo> alarmHandleModelList = ObjectConverter.CopyList <JC_AlarmHandleModel, JC_AlarmHandleInfo>(responseList).ToList();
//var modellistresponse = _largeDataAnalysisConfigCacheService.GetAllLargeDataAnalysisConfigCache(new LargeDataAnalysisConfigCacheGetAllRequest());
//逻辑报警分析模型从数据库获取。
var modellist = _LargedataAnalysisConfigRepository.Datas.ToList();
if (modellist != null && modellist.Any())
{
alarmHandleModelList.ForEach(alarmhandle =>
{
if (alarmhandle.EndTime == null || alarmhandle.EndTime.ToString("yyyy-MM-dd HH:mm:ss") == "1900-01-01 00:00:00")
{
alarmhandle.EtimeDisplay = "-";
}
else
{
alarmhandle.EtimeDisplay = alarmhandle.EndTime.ToString("yyyy-MM-dd HH:mm:ss");
}
var analysismodel = modellist.FirstOrDefault(modle => modle.Id == alarmhandle.AnalysisModelId);
if (analysismodel != null)
{
alarmhandle.AnalysisModelName = analysismodel.Name;
}
});
}
alarmresponse.Data = alarmHandleModelList;
alarmresponse.PagerInfo.PageIndex = pageindex;
alarmresponse.PagerInfo.PageSize = pagesize;
alarmresponse.PagerInfo.RowCount = rowcount;
return(alarmresponse);
}
catch (Exception ex)
{
LogHelper.Error("根据时间获取逻辑报警失败：" + "\r\n" + ex.Message);
return(new BasicResponse <List <JC_AlarmHandleInfo> >());
}
}
