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; } ZhuiSuResponse zhuisuResponse = LocalApi.ExecuteHistory(new ZhuiSuRequest() { ProcessDID = this.ProcessDID, //PageNumber = this.pager.PageNumber, TimeStart = this.TimeStart, TimeEnd = this.TimeEnd, PageNumber = 1, PageSize = int.MaxValue }); if (zhuisuResponse.IsError) { return; } PagedData <ZhuiSuItem> rows = zhuisuResponse.ZhuiSus; ExcelExport excelExport = new ExcelExport(); DataTable table = ToDataTable(rows.ToList()); excelExport.sheetName = "易损件数据"; excelExport.ExcuteExport(saveFileDialog2.FileName, table); }
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; } AlarmInfoListResponse infoListResponse = LocalApi.GetAlarmInfoList(new AlarmInfoListRequest() { Keyword = this.Keyword, AlarmDateStart = this.AlarmDateStart, AlarmDateEnd = this.AlarmDateEnd, PageNumber = 1, PageSize = int.MaxValue }); if (infoListResponse.IsError) { return; } PagedData <AlarmInfoModel> rows = infoListResponse.AlarmInfoModel; ExcelExport excelExport = new ExcelExport(); DataTable table = ToDataTable(rows.ToList()); excelExport.sheetName = "新报警记录"; excelExport.ExcuteExport(saveFileDialog2.FileName, table); }