資源簡介
使用步驟:
1. 使用Microsoft Visual Studio 2008打開解決方案，并重新編譯；
2. 重新編譯后在解決方案文件同級的目錄下會產生兩個文件夾，分別是BinD和WorkEnvironment；
3. 拷貝BinD目錄下的CustomContextMenuStrip.dll到
SuperMap Deskpro .NET的安裝目錄下..Bin/Plugins/CustomContextMenuStrip文件夾中，如果CustomContextMenuStrip不存在，請先新建一個。
4. 拷貝WorkEnvironment目錄下的
CustomContextMenuStrip.config到SuperMap Deskpro .NET的安裝目錄下..WorkEnvironment/Default文件夾中。
5.打開矢量數據集后點擊右鍵，彈出右鍵菜單，如示意圖1所示，將選中的數據集屬性導出到Excel文件中。
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Windows.Forms;
using?SuperMap.Desktop;
using?Application?=?SuperMap.Desktop.Application;
using?SuperMap.Data;
namespace?CustomContextMenuStrip
{
????class?MyCtrlAction?:?CtrlAction
????{
????????override?public?void?Run（）
????????{
????????????try
????????????{
????????????????//定位到某個表中
????????????????Microsoft.Office.Interop.Excel.Application?myexcel?=?new?Microsoft.Office.Interop.Excel.Application（）;
????????????????Microsoft.Office.Interop.Excel.Workbooks?workbooks?=?myexcel.Workbooks;
????????????????Microsoft.Office.Interop.Excel.Workbook?workbook?=
????????????????????workbooks.Add（Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet）;
????????????????;
????????????????Microsoft.Office.Interop.Excel.Worksheet?sheet?=
????????????????????（Microsoft.Office.Interop.Excel.Worksheet）?workbook.Worksheets[1];
????????????????Microsoft.Office.Interop.Excel.Range?range?=?sheet.Columns.get_Range（“H:H“?Type.Missing）;
????????????????range.Validation.Delete（）;
????????????????range.Validation.Add（Microsoft.Office.Interop.Excel.XlDVType.xlValidateList
?????????????????????????????????????Microsoft.Office.Interop.Excel.XlDVAlertstyle.xlValidAlertStop?Type.Missing
?????????????????????????????????????“123“?Type.Missing）;
????????????????//獲取數據集屬性
????????????????Dataset[]?activeDatasets?=?Application.ActiveDatasets;
????????????????if?（activeDatasets.Length?!=?0）
????????????????{
????????????????????Dataset?dataset?=?activeDatasets[0];
????????????????????if?（dataset.Type?==?DatasetType.Point?||?dataset.Type?==?DatasetType.Region?||
????????????????????????dataset.Type?==?DatasetType.Line）
????????????????????{
????????????????????????//確定選中的數據集
????????????????????????DatasetVector?Dtv_Aim?=?dataset?as?DatasetVector;
????????????????????????FieldInfos?fieldInfos?=?Dtv_Aim.FieldInfos;
????????????????????????//賦字段名
????????????????????????for?（int?i?=?1;?i?????????????????????????{
????????????????????????????sheet.Cells[1?i]?=?fieldInfos[i?-?1].Name.ToString（）;
????????????????????????}
????????????????????????Recordset?recordset?=?Dtv_Aim.GetRecordset（false?CursorType.Dynamic）;
????????????????????????if?（recordset.RecordCount?!=?0）
????????????????????????{
????????????????????????????//彈出保存Excel對話框
????????????????????????????SaveFileDialog?saveFileDialog?=?new?SaveFileDialog（）;
????????????????????????????saveFileDialog.Filter?=?“*.xlsx|*.xlsx“;
????????????????????????????if?（saveFileDialog.ShowDialog（）?==?DialogResult.OK）
????????????????????????????{
????????????????????????????????recordset.MoveFirst（）;
????????????????????????????????int?j?=?2;
????????????????????????????????while?（!recordset.IsEOF）
????????????????????????????????{
????????????????????????????????????object[]?value?=?recordset.GetValues（）;
????????????????????????????????????for?（i ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\
?????文件????????1074??2012-05-10?22:12??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\CustomContextMenuStrip.config
?????文件????????6656??2012-05-10?22:12??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\CustomContextMenuStrip.dll
?????文件???????15872??2012-05-10?22:12??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\CustomContextMenuStrip.pdb
?????文件?????1100392??2007-10-10?09:48??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\Microsoft.Office.Interop.Excel.dll
?????文件?????1309492??2005-04-19?14:48??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\Microsoft.Office.Interop.Excel.xm
?????文件???????20080??2007-10-10?09:48??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\Microsoft.Office.Interop.SmartTag.dll
?????文件???????64088??2007-10-10?09:48??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\Microsoft.Vbe.Interop.dll
?????文件??????223800??2007-10-10?09:48??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\office.dll
?????文件??????387947??2005-04-19?14:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\office.xm
?????文件?????6155776??2012-03-31?09:36??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\SuperMap.Data.dll
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\zh-CN\
?????文件??????114688??2012-03-31?09:36??CustomContextMenuStrip（修改）\CustomContextMenuStrip\BinD\zh-CN\SuperMap.Data.resources.dll
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\$SuperMapDesktopHome$\
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\$SuperMapDesktopHome$\Bin\
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\$SuperMapDesktopHome$\Bin\Plugins\
?????目錄???????????0??2012-05-11?08:25??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\$SuperMapDesktopHome$\Bin\Plugins\CustomContextMenuStrip\
?????文件????????4494??2012-04-08?15:59??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\CtrlAction.cs
?????文件????????1021??2012-05-11?09:05??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\CustomContextMenuStrip.config
?????文件????????4945??2012-05-10?22:12??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\CustomContextMenuStrip.csproj
?????文件????????1048??2012-04-08?16:26??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\CustomContextMenuStrip.csproj.user
?????文件?????????524??2012-04-08?15:23??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\DesktopPlugin.cs
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\obj\
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\obj\X86\
?????目錄???????????0??2012-05-11?08:42??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\obj\X86\Debug\
?????文件????????1748??2012-05-10?22:12??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\obj\X86\Debug\CustomContextMenuStrip.csproj.FileListAbsolute.txt
?????文件????????6656??2012-05-10?22:12??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\obj\X86\Debug\CustomContextMenuStrip.dll
?????文件???????15872??2012-05-10?22:12??CustomContextMenuStrip（修改）\CustomContextMenuStrip\CustomContextMenuStrip\obj\X86\Debug\CustomContextMenuStrip.pdb
............此處省略10個文件信息
- 上一篇：收集的幾個Flash小游戲源代碼
- 下一篇：noip2009測試數據
評論
共有 條評論
川公網安備 51152502000135號