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