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