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);
        }
Esempio n. 2
0
        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);
        }