private void sbtnOut_Click(object sender, EventArgs e) { try { string savePath = FileDialogHelper.SaveExcel(); if (!string.IsNullOrEmpty(savePath)) { string outError = ""; AsposeExcelTools.DataTableToExcel(dtPage, savePath, out outError); if (!string.IsNullOrEmpty(outError)) { MessageBox.Show(outError); } else { Process.Start(savePath); } } } catch (Exception ee) { MessageUtil.ShowTips(ee.ToString()); } }
private void btnOK_Click(object sender, EventArgs e) { try { IDictionary <int, IGeometry> boundGeometrys = this.ucExtentSetting1.BoundGeometrys; if (boundGeometrys == null || boundGeometrys.Count <= 0) { MessageBox.Show(@"请选择输出数据的范围!", @"提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (_layerFieldsList == null || !_layerFieldsList.Any(c => c.Checked)) { MessageBox.Show(@"请选择要输出的图层!", @"提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (string.IsNullOrWhiteSpace(this.ucSelectFile1.FileName)) { MessageBox.Show(@"请选择要输出数据的存放位置!", @"提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } string error = ""; foreach (UcLayerFields layerFields in _layerFieldsList) { try { if (!layerFields.Checked) { continue; } DataTable dataTable = FeatureClassUtil.FeatureClassToDataTable(layerFields.FeatureLayer.FeatureClass, boundGeometrys, null, layerFields.SelectedFieldDictionary); AsposeExcelTools.DataTableToExcel(dataTable, ucSelectFile1.FileName, out error); } catch (Exception) { throw; } } if (!string.IsNullOrEmpty(error)) { MessageBox.Show(error); } else { Process.Start(ucSelectFile1.FileName); } } catch (Exception exception) { MessageBox.Show(exception.Message); } }
private void sbtnExport_Click(object sender, EventArgs e) { try { string savePath = FileDialogHelper.SaveExcel(); if (!string.IsNullOrEmpty(savePath)) { string outError = ""; dtOut.Rows.Clear(); DataRow outRow = dtOut.NewRow();//存放位置,工具状态 outRow["ID"] = "序号"; outRow["ToolType"] = "工具种类"; outRow["ToolName"] = "工具名称"; outRow["ToolID"] = "工具ID"; outRow["StoragePlace"] = "存放位置"; outRow["IsInStore"] = "工具状态"; dtOut.Rows.Add(outRow); int nRow = 0; foreach (DataRow drow in dataTable.Rows) { nRow++; DataRow outRows = dtOut.NewRow(); outRows["ID"] = nRow.ToString(); outRows["ToolType"] = drow["ToolType"].ToString(); outRows["ToolName"] = drow["ToolName"].ToString(); outRows["ToolID"] = drow["ToolID"].ToString(); outRows["StoragePlace"] = drow["StoragePlace"].ToString(); outRows["IsInStore"] = drow["IsInStore"].ToString(); dtOut.Rows.Add(outRows); } AsposeExcelTools.DataTableToExcel(dtOut, savePath, out outError); if (!string.IsNullOrEmpty(outError)) { MessageBox.Show(outError); } else { Process.Start(savePath); } } } catch (Exception ee) { MessageUtil.ShowTips(ee.ToString()); } }