private void btnExport_Click(object sender, RoutedEventArgs e)
{
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
string str = "Excel (*.xlsx)|*.xlsx";
saveFileDialog1.Filter = str;
SaveFileDialog saveFileDialog2 = saveFileDialog1;
if (saveFileDialog2.ShowDialog() != DialogResult.OK)
{
return;
}
AlarmRecordListResponse recordListResponse = LocalApi.GetAlarmRecordList(new AlarmRecordListRequest()
{
Keyword = this.Keyword, AlarmDateStart = this.AlarmDateStart, AlarmDateEnd = this.AlarmDateEnd, PageNumber = 1, PageSize = int.MaxValue
});
if (recordListResponse.IsError)
{
return;
}
PagedData <AlarmRecordItem> rows = recordListResponse.AlarmRecords;
ExcelExport excelExport = new ExcelExport();
DataTable table = ToDataTable(rows.ToList());
excelExport.sheetName = "历史报警记录";
excelExport.ExcuteExport(saveFileDialog2.FileName, table);
}
public AlarmRecordListResponse GetAlarmRecordList(AlarmRecordListRequest request)
{
AlarmRecordListResponse recordListResponse = new AlarmRecordListResponse();
IPagedList <AlarmRecordItem> pagedAlarmRecords = ServiceHelper.LoadService <IAlarmService>().GetPagedAlarmRecords(request.Keyword, request.AlarmDateStart, request.AlarmDateEnd, request.PageNumber, request.PageSize);
recordListResponse.AlarmRecords = pagedAlarmRecords.ToPagedData <AlarmRecordItem>();
return(recordListResponse);
}
public void RefreshData(int?pageNumber = 1)
{
AlarmRecordListResponse recordListResponse = LocalApi.GetAlarmRecordList(new AlarmRecordListRequest()
{
Keyword = this.Keyword,
AlarmDateStart = this.AlarmDateStart,
AlarmDateEnd = this.AlarmDateEnd,
PageNumber = pageNumber.Value,
CraftsDid = CraftDID,
PageSize = 15
});
this.pager.Setup(recordListResponse.AlarmRecords);
this.dataGrid.ItemsSource = recordListResponse.AlarmRecords;
}
