private void RefreshAlarmRecordInfo(int pageindex, int pagesize)
{
DateTime stime = Convert.ToDateTime(dateEdit1.Text);
DateTime etime = Convert.ToDateTime(dateEdit2.Text);
if (stime > etime)
{
XtraMessageBox.Show("开始时间不应大于结束时间");
return;
}
TimeSpan span = etime.Subtract(stime);
if (span.TotalDays > 2)
{
XtraMessageBox.Show("查询时间不能大于3天");
return;
}
SetExecuteBeginTime();
AlarmRecordGetByStimeRequest request = new AlarmRecordGetByStimeRequest()
{
Stime = stime.ToString(),
ETime = etime.ToString(),
PagerInfo = new PagerInfo
{
PageSize = pagesize,
PageIndex = pageindex
}
};
var alarmresponse = alarmRecordService.GetAlarmRecordListByStime(request);
if (alarmresponse != null && alarmresponse.IsSuccess && alarmresponse.Data != null)
{
PointAlarmInfos = alarmresponse.Data;
this.pointAlarmGrid.DataSource = PointAlarmInfos;
//设置分页信息
SetPageInfo(alarmresponse.PagerInfo);
}
}
public BasicResponse <List <AlarmProcessInfo> > GetAlarmRecordListByStime(AlarmRecordGetByStimeRequest alarmRecordRequest)
{
var responsestr = HttpClientHelper.Post(Webapi + "/v1/KJ73NApp/GetAlarmRecordListByStime?token=" + Token, JSONHelper.ToJSONString(alarmRecordRequest));
return(JSONHelper.ParseJSONString <BasicResponse <List <AlarmProcessInfo> > >(responsestr));
}
/// <summary>
/// 查询分站中断记录
/// </summary>
/// <param name="AlarmRecordRequest"></param>
/// <returns></returns>
public BasicResponse <List <AlarmProcessInfo> > GetStaionInterruptRecordListByStime(AlarmRecordGetByStimeRequest AlarmRecordRequest)
{
BasicResponse <List <AlarmProcessInfo> > resultResponse = new BasicResponse <List <AlarmProcessInfo> >();
int pageindex = AlarmRecordRequest.PagerInfo.PageIndex;
int pagesize = AlarmRecordRequest.PagerInfo.PageSize;
try
{
DateTime stime = new DateTime();
DateTime.TryParse(AlarmRecordRequest.Stime, out stime);
DateTime etime = new DateTime();
DateTime.TryParse(AlarmRecordRequest.ETime, out etime);
List <AlarmProcessInfo> alarmRecordList = new List <AlarmProcessInfo>();
DataTable alarmTable = new DataTable();
alarmTable = _Repository.QueryTable("global_GetStationInterruptAlarmRecordByStime", new object[] { "KJ_DataAlarm" + stime.ToString("yyyyMM"), etime, stime });
alarmRecordList = _Repository.ToEntityFromTable <AlarmProcessInfo>(alarmTable).ToList();
resultResponse.Data = alarmRecordList;
return(resultResponse);
}
catch (Exception ex)
{
LogHelper.Error("获取分站中断记录失败：" + "\r\n" + ex.Message);
resultResponse.Data = new List <AlarmProcessInfo>();
return(resultResponse);
}
}
public BasicResponse <List <AlarmProcessInfo> > GetAlarmRecordListByStime(AlarmRecordGetByStimeRequest AlarmRecordRequest)
{
BasicResponse <List <AlarmProcessInfo> > resultResponse = new BasicResponse <List <AlarmProcessInfo> >();
int pageindex = AlarmRecordRequest.PagerInfo.PageIndex;
int pagesize = AlarmRecordRequest.PagerInfo.PageSize;
try
{
DateTime stime = new DateTime();
DateTime.TryParse(AlarmRecordRequest.Stime, out stime);
DateTime etime = new DateTime();
DateTime.TryParse(AlarmRecordRequest.ETime, out etime);
List <AlarmProcessInfo> alarmRecordList = new List <AlarmProcessInfo>();
DataTable alarmTable = new DataTable();
//如果跨月,则需要查询当前报警月表与上一月报警月表;反之则查询当前月表
if (stime.Month != etime.Month)
{
//DateTime temptime = new DateTime();
////跨一天
//if (stime.Month == etime.AddDays(-1).Month)
//{
// temptime = etime.AddDays(-1);
//}
////跨2天
//else if (stime.Month == etime.AddDays(-2).Month)
//{
// temptime = etime.AddDays(-2);
//}
//if (temptime.Year != 1)
//{
try
{
//查询上一月数据
alarmTable = _Repository.QueryTable("global_GetAlarmRecordByStime", new object[] { "KJ_DataAlarm" + stime.ToString("yyyyMM"), etime, stime, stime, etime });
//alarmRecordList = _Repository.ToEntityFromTable<AlarmProcessInfo>(alarmTable).ToList();
}
catch (Exception ex)
{
LogHelper.Error("根据日期获取报警数据失败:" + "\r\n" + ex.Message);
}
try
{
//查询本月数据
DataTable tempTable = _Repository.QueryTable("global_GetAlarmRecordByStime", new object[] { "KJ_DataAlarm" + etime.ToString("yyyyMM"), etime, stime, stime, etime });
//List<AlarmProcessInfo> tempalarmRecordList = _Repository.ToEntityFromTable<AlarmProcessInfo>(tempTable).ToList();
//alarmRecordList.AddRange(tempalarmRecordList);
foreach (DataRow row in tempTable.Rows)
{
alarmTable.ImportRow(row);
}
//alarmTable.Merge(tempTable,)
}
catch (Exception ex)
{
LogHelper.Error("根据日期获取报警数据失败:" + "\r\n" + ex.Message);
}
//}
}
else
{
alarmTable = _Repository.QueryTable("global_GetAlarmRecordByStime", new object[] { "KJ_DataAlarm" + stime.ToString("yyyyMM"), etime, stime, stime, etime });
//alarmRecordList = _Repository.ToEntityFromTable<AlarmProcessInfo>(alarmTable).ToList();
}
DataTable alarmdt = GetPagedTable(alarmTable, AlarmRecordRequest.PagerInfo.PageIndex, AlarmRecordRequest.PagerInfo.PageSize);
alarmRecordList = _Repository.ToEntityFromTable <AlarmProcessInfo>(alarmdt).ToList();
alarmRecordList.ForEach(o =>
{
if (o.Etime == null || o.Etime.ToString("yyyy-MM-dd HH:mm:ss") == "1900-01-01 00:00:00")
{
o.EtimeDisplay = "-";
}
else
{
o.EtimeDisplay = o.Etime.ToString("yyyy-MM-dd HH:mm:ss");
}
});
resultResponse.Data = alarmRecordList.OrderBy(o => o.Stime).ToList();
resultResponse.PagerInfo.RowCount = alarmTable.Rows.Count;
resultResponse.PagerInfo.PageSize = pagesize;
resultResponse.PagerInfo.PageIndex = pageindex;
return(resultResponse);
}
catch (Exception ex)
{
LogHelper.Error("获取设备报警记录失败：" + "\r\n" + ex.Message);
resultResponse.Data = new List <AlarmProcessInfo>();
return(resultResponse);
}
}
