/// <summary>
/// 初始化数据库连接
/// </summary>
private void InitialDB(out Exception err)
{
err = null;
//cyf 20110625 modify
List <IDataset> lstDataset = new List <IDataset>();
XmlDocument xml = new XmlDocument();
if (!File.Exists(ModData.v_projectDetalXML))
{
err = new Exception(ModData.v_projectDetalXML + "不存在");
return;
}
xml.Load(ModData.v_projectDetalXML);
XmlElement elementTemp = xml.SelectSingleNode("//现势库/连接信息[@类型!='']") as XmlElement;//取得矢量数据
//end
IWorkspace TempWorkSpace = ModDBOperator.GetDBInfoByXMLNode(elementTemp, "") as IWorkspace;
if (TempWorkSpace == null)
{
err = new Exception("连接数据库失败!");
return;
}
XmlElement elementTemp2 = xml.SelectSingleNode("//现势库/数据集[@名称!='']") as XmlElement;
string datasetname = elementTemp2.GetAttribute("名称");
SysCommon.Gis.SysGisDataSet sysGisDataset = new SysCommon.Gis.SysGisDataSet(TempWorkSpace);
//cyf 20110625 modify:
IFeatureDataset dataset = sysGisDataset.GetFeatureDataset(datasetname, out err);
//end
if (err != null)
{
err = new Exception("获取数据失败!");
return;
}
lstDataset = sysGisDataset.GetFeatureClass(dataset);
if (lstDataset == null || lstDataset.Count == 0)
{
err = new Exception("库体要素类为空！");
}
m_LstDataset = lstDataset;
}
public override void OnClick()
{
//当前所有范围面，用来设置数据显示范围
IFeatureLayer pRangeFeatLay = null;
IFeatureLayer pFeatureLayer = null;
IFeatureClass pFeatureClass = null;
Exception exError = null;
//如果工作库数据group图层已经存在 就不让再加了
for (int i = 0; i < _AppHk.MapControl.LayerCount; i++)
{
ILayer mLayer = _AppHk.MapControl.get_Layer(i);
if (mLayer is IGroupLayer)
{
if (mLayer.Name == "现势库数据")
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "现势库数据图层已经存在。");
return;
}
}
}
Plugin.Application.IAppFormRef pArrForm = _AppHk as Plugin.Application.IAppFormRef;
pArrForm.MainForm.Cursor = System.Windows.Forms.Cursors.WaitCursor;
//获取更新库体数据集
if (_AppHk.DBXmlDocument == null)
{
pArrForm.MainForm.Cursor = System.Windows.Forms.Cursors.Default;
return;
}
XmlNode DBNode = _AppHk.DBXmlDocument.SelectSingleNode(".//项目工程");
if (DBNode == null)
{
return;
}
XmlElement DBElement = DBNode as XmlElement;
XmlElement objNode = DBNode.SelectSingleNode(".//目标数据连接") as XmlElement;
SysCommon.Gis.SysGisDataSet pObjSysGisDataSet = new SysCommon.Gis.SysGisDataSet();
pObjSysGisDataSet.SetWorkspace(objNode.GetAttribute("服务器"), objNode.GetAttribute("服务名"), objNode.GetAttribute("数据库"), objNode.GetAttribute("用户"), objNode.GetAttribute("密码"), objNode.GetAttribute("版本"), out exError);
if (exError != null)
{
pArrForm.MainForm.Cursor = System.Windows.Forms.Cursors.Default;
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "现势库数据连接失败,请确认");
return;
}
//获取数据显示范围
IGeometry pGeometry = null;
pRangeFeatLay = ModDBOperator.GetMapFrameLayer("zone", _AppHk.MapControl, "示意图") as IFeatureLayer;
if (pRangeFeatLay == null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "无法获取数据显示范围！");
return;
}
//判断当前是否有示提交的范围面
IFeatureCursor pFeatureCursor = pRangeFeatLay.Search(null, false);
if (pFeatureCursor != null)
{
IFeature pFeature = pFeatureCursor.NextFeature();
while (pFeature != null)
{
if (pGeometry == null)
{
pGeometry = pFeature.Shape;
}
else
{
pGeometry = (pGeometry as ITopologicalOperator).Union(pFeature.Shape);
}
pFeature = pFeatureCursor.NextFeature();
}
}
if (pGeometry == null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "无法获取数据显示范围！");
return;
}
//获取所有更新数据的FeatureClass
IFeatureDataset pFeaDataset = pObjSysGisDataSet.GetFeatureDataset("c_njtdt", out exError);// 这个地方要素集的名称是写死的 暂时没有办法获得工作库的信息 需要修改 陈新伟 20091211
if (pFeaDataset == null)
{
pArrForm.MainForm.Cursor = System.Windows.Forms.Cursors.Default;
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "无法获得指定的现势库数据【C_NJTDT】。");//yjl20120503
return;
}
//符号化类
//SymbolLyr symLyr = new SymbolLyr(); //@@@
List <IDataset> listFC = pObjSysGisDataSet.GetFeatureClass(pFeaDataset);
IGroupLayer pLayer = new GroupLayerClass();
pLayer.Name = "现势库数据";
foreach (IDataset pDataset in listFC)
{
pFeatureClass = pDataset as IFeatureClass;
if (pFeatureClass == null)
{
continue;
}
pFeatureLayer = new FeatureLayerClass();
if (pFeatureClass.FeatureType == esriFeatureType.esriFTAnnotation)
{
pFeatureLayer = new FDOGraphicsLayerClass();
}
pFeatureLayer.FeatureClass = pFeatureClass;
pFeatureLayer.Name = pDataset.Name;
pFeatureLayer.ScaleSymbols = false;
//pFeatureLayer = ModDBOperator.GetSelectionLayer(pTempFeatureLayer, pGeometry);
//if (pFeatureLayer == null) return;
//符号化图层
//symLyr.SymbolFeatrueLayer(pFeatureLayer); //@@@
//收缩图例
if (pFeatureClass.FeatureType == esriFeatureType.esriFTSimple)
{
ModDBOperator.ExpandLegend(pFeatureLayer as ILayer, false);
}
pLayer.Add(pFeatureLayer as ILayer);
}
_AppHk.MapControl.Map.AddLayer(pLayer);
pObjSysGisDataSet.CloseWorkspace(true);
//对图层进行排序
SysCommon.Gis.ModGisPub.LayersCompose(pLayer);
//将图幅结合表置于底层
//ModDBOperator.MoveMapFrameLayer(_AppHk.MapControl);
_AppHk.TOCControl.Update();
_AppHk.MapControl.Map.ClipGeometry = pGeometry;
_AppHk.MapControl.ActiveView.Refresh();
pArrForm.MainForm.Cursor = System.Windows.Forms.Cursors.Default;
}
//cyf 2011065 modify
public override void OnClick()
{
Exception err = null;
/////获取工程项目名称
DevComponents.AdvTree.Node ProjectNode = new DevComponents.AdvTree.Node();
ProjectNode = m_Hook.ProjectTree.SelectedNode;
while (ProjectNode.Parent != null)
{
ProjectNode = ProjectNode.Parent;
}
//cyf 20110625 add:
DevComponents.AdvTree.Node DBNode = new DevComponents.AdvTree.Node(); //数据库树节点
//获取数据库节点
DBNode = m_Hook.ProjectTree.SelectedNode;
while (DBNode.Parent != null && DBNode.DataKeyString != "DB")
{
DBNode = DBNode.Parent;
}
if (DBNode.DataKeyString != "DB")
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据库节点失败!");
return;
}
DevComponents.AdvTree.Node DtSetNode = new DevComponents.AdvTree.Node(); //数据集树节点
#region 获取数据集节点
if (DBNode.Text == "现势库" || DBNode.Text == "历史库" || DBNode.Text == "临时库") //.DataKeyString == "现势库"
{
//获取数据集节点
DtSetNode = m_Hook.ProjectTree.SelectedNode;
while (DtSetNode.Parent != null && DtSetNode.DataKeyString != "FD")
{
DtSetNode = DtSetNode.Parent;
}
if (DtSetNode.DataKeyString != "FD")
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据集节点失败!");
return;
}
}
else if (DBNode.Text == "栅格数据库")
{
//cyf 20110626 add:获取栅格数据库图层节点
DtSetNode = m_Hook.ProjectTree.SelectedNode;
if (m_Hook.ProjectTree.SelectedNode.DataKeyString == "RC")
{
while (DtSetNode.Parent != null && DtSetNode.DataKeyString != "RC")
{
DtSetNode = DtSetNode.Parent;
}
if (DtSetNode.DataKeyString != "RC")
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据集节点失败!");
return;
}
}
else if (m_Hook.ProjectTree.SelectedNode.DataKeyString == "RD")
{
while (DtSetNode.Parent != null && DtSetNode.DataKeyString != "RD")
{
DtSetNode = DtSetNode.Parent;
}
if (DtSetNode.DataKeyString != "RD")
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据集节点失败!");
return;
}
}
//end
}
#endregion
XmlElement elementTemp = (DBNode.Tag as XmlElement).SelectSingleNode(".//连接信息") as XmlElement;
IWorkspace TempWorkSpace = ModDBOperator.GetDBInfoByXMLNode(elementTemp, "") as IWorkspace;
if (TempWorkSpace == null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "连接数据库失败!");
return;
}
//cyf 20110625 modify
ILayer player = null;
//ILayer player = ModDBOperator.GetGroupLayer(m_Hook.MapControl, m_Hook.ProjectTree.SelectedNode.DataKeyString + "_" + ProjectNode.Text);
if (m_Hook.ProjectTree.SelectedNode.DataKeyString == "FD")
{
player = ModDBOperator.GetGroupLayer(m_Hook.MapControl, m_Hook.ProjectTree.SelectedNode.Text + "_" + ProjectNode.Text);
}
else if (m_Hook.ProjectTree.SelectedNode.DataKeyString == "FC")
{
player = ModDBOperator.GetGroupLayer(m_Hook.MapControl, DtSetNode.Text + "_" + ProjectNode.Text);
}
//cyf 20110626 add:添加获取栅格数据图层
else if (m_Hook.ProjectTree.SelectedNode.DataKeyString == "RC" || m_Hook.ProjectTree.SelectedNode.DataKeyString == "RD")
{
//获取栅格数据图层
player = ModDBOperator.GetGroupLayer(m_Hook.MapControl, DtSetNode.Text + "_" + ProjectNode.Text);
}
//end
if (player != null)
{
m_Hook.MapControl.Map.DeleteLayer(player);
m_Hook.TOCControl.Update();
}
//end
IGroupLayer pGroupLayer = new GroupLayerClass();
//cyf 20110625
if (DBNode.Text == "现势库" || DBNode.Text == "历史库" || DBNode.Text == "临时库") //.DataKeyString == "现势库"
{
/////////若为历史库管理状态退出该状态，加载现势库
m_Hook.MapControl.Map.ClearLayers();
Plugin.Interface.ICommandRef HisBaseCommand = null;
bool GetSeccess = Plugin.ModuleCommon.DicCommands.TryGetValue("GeoDBATool.ControlsDBHistoryManage", out HisBaseCommand);
if (GetSeccess)
{
HisCommand = HisBaseCommand as ControlsDBHistoryManage;
if (HisCommand.Checked)
{
HisCommand.IsHistory = false;//判断是不是历史库点的加载，若是现势库就卸载掉历史库，若是历史库就不操作
HisCommand.OnClick();
}
}
#region 加载数据
SysCommon.Gis.SysGisDataSet sysGisDataset = new SysCommon.Gis.SysGisDataSet(TempWorkSpace);
//cyf 20110625 modify
IFeatureDataset featureDataset = null; //数据集
if (m_Hook.ProjectTree.SelectedNode.DataKeyString == "FD")
{
featureDataset = sysGisDataset.GetFeatureDataset(m_Hook.ProjectTree.SelectedNode.Text, out err);
if (err != null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据集失败，请检查该数据集是否存在!");
return;
}
pGroupLayer.Name = m_Hook.ProjectTree.SelectedNode.Text + "_" + ProjectNode.Text;
}
else if (m_Hook.ProjectTree.SelectedNode.DataKeyString == "FC")
{
featureDataset = sysGisDataset.GetFeatureDataset(DtSetNode.Text, out err);
if (err != null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据集失败!");
return;
}
pGroupLayer.Name = DtSetNode.Text + "_" + ProjectNode.Text;
}
//end
List <IDataset> lstDataset = sysGisDataset.GetFeatureClass(featureDataset);
//遍历要素类，加载图层
string dbType = "";
string userName = "";//用户名
userName = elementTemp.GetAttribute("用户");
dbType = elementTemp.GetAttribute("类型");
foreach (IDataset dataset in lstDataset)
{
IFeatureClass pFeatureClass = dataset as IFeatureClass;
if (pFeatureClass == null)
{
continue;
}
IFeatureLayer pFeatureLayer = new FeatureLayerClass();
if (pFeatureClass.FeatureType == esriFeatureType.esriFTAnnotation)
{
pFeatureLayer = new FDOGraphicsLayerClass();
}
pFeatureLayer.FeatureClass = pFeatureClass;
if (dbType.Trim().ToUpper() == "SDE")
{
//cyf 20110706 modify:修改为不去掉用户名 changed by xisheng 0906 去掉用户名
if (dataset.Name.ToUpper().Contains(userName.Trim().ToUpper()))
{
//SDE用户图层名去掉用户名
pFeatureLayer.Name = dataset.Name.Substring(userName.Trim().Length + 1);
}
else
{
pFeatureLayer.Name = dataset.Name;
}
//end
}
else
{
pFeatureLayer.Name = dataset.Name;
}
//cyf 20110625 modify
if (m_Hook.ProjectTree.SelectedNode.DataKeyString == "FC")
{
//加载指定的图层
if (m_Hook.ProjectTree.SelectedNode.Text != pFeatureLayer.Name)
{
continue;
}
}
else if (m_Hook.ProjectTree.SelectedNode.DataKeyString == "FD")
{
//加载具备权限的图层
XmlElement feaclsElem = null;
try { feaclsElem = (m_Hook.ProjectTree.SelectedNode.Tag as XmlElement).SelectSingleNode(".//图层名") as XmlElement; } catch { }
if (feaclsElem != null)
{
if (!feaclsElem.GetAttribute("名称").Contains(pFeatureLayer.Name))
{
//若不具备数据权限，则不进行加载
continue;
}
}
}
//end
pGroupLayer.Add(pFeatureLayer as ILayer);
}
m_Hook.MapControl.Map.AddLayer(pGroupLayer);
#endregion
}
//else if (DBNode.Text == "历史库")
//{
// //历史库加载
// //ModDBOperator.WriteLog("GetCommand");
// Plugin.Interface.ICommandRef HisBaseCommand = null;
// bool GetSeccess = Plugin.ModuleCommon.DicCommands.TryGetValue("GeoDBATool.ControlsDBHistoryManage", out HisBaseCommand);
// if (GetSeccess)
// {
// HisCommand = HisBaseCommand as ControlsDBHistoryManage;
// //判断是不是历史库点的加载，若是现势库就卸载掉历史库，若是历史库就不操作
// HisCommand.IsHistory = true;
// HisCommand.OnClick();
// if (HisCommand.MyControlHistoryBar != null)
// {
// string HisDBType = elementTemp.GetAttribute("类型");
// string[] strTemp = new string[] { elementTemp.GetAttribute("服务器"), elementTemp.GetAttribute("服务名"), elementTemp.GetAttribute("数据库"), elementTemp.GetAttribute("用户"), elementTemp.GetAttribute("密码"), elementTemp.GetAttribute("版本") };
// HisCommand.MyControlHistoryBar.AddHistoryData(strTemp, HisDBType);
// }
// }
//}
//加载sde数据后，注册版本
//if (dbType.Trim().ToUpper() == "SDE")
//{
// IDataset pFeaDt = featureDataset as IDataset;
// if (pFeaDt != null)
// {
// IVersionedObject pVerObj = pFeaDt as IVersionedObject;
// if (!pVerObj.IsRegisteredAsVersioned)
// {
// //注册版本
// pVerObj.RegisterAsVersioned(true);
// }
// else
// {
// pVerObj.RegisterAsVersioned(false);
// }
// }
//}
else if (DBNode.Text == "栅格数据库")
{
//栅格数据加载，分为两种情况：栅格数据集、栅格编目
//cyf 20110625 modify
pGroupLayer.Name = m_Hook.ProjectTree.SelectedNode.Text + "_" + ProjectNode.Text;
//end
string rasterDBType = (m_Hook.ProjectTree.SelectedNode.Tag as XmlElement).GetAttribute("存储类型");
elementTemp = (DBNode.Tag as XmlElement).SelectSingleNode(".//连接信息") as XmlElement; //cyf 20110626
TempWorkSpace = ModDBOperator.GetDBInfoByXMLNode(elementTemp, "") as IWorkspace;
if (TempWorkSpace == null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "连接数据库失败!");
return;
}
IRasterWorkspaceEx pRasterWS = TempWorkSpace as IRasterWorkspaceEx;
if (pRasterWS == null)
{
return;
}
//string feaclsName = (elementTemp.FirstChild as XmlElement).GetAttribute("名称");
string feaclsName = m_Hook.ProjectTree.SelectedNode.Text;
try
{
if (rasterDBType.Trim() == "栅格编目")
{
//栅格编目数据加载
IRasterCatalog pRasterCatalog = pRasterWS.OpenRasterCatalog(feaclsName);
IGdbRasterCatalogLayer pGDBRCLayer = new GdbRasterCatalogLayerClass();
if (!pGDBRCLayer.Setup(pRasterCatalog as ITable))
{
return;
}
IFeatureLayer mFeaLayer = pGDBRCLayer as IFeatureLayer;
pGroupLayer.Add(mFeaLayer as ILayer);
//IFeatureClass pFeaCls = pRasterCatalog as IFeatureClass;
//if (pFeaCls == null) return;
//IFeatureCursor pFeaCursor=pFeaCls.Search(null,false);
//if(pFeaCursor==null) return;
//IFeature pFea=pFeaCursor.NextFeature();
//while (pFea != null)
//{
// IRasterCatalogItem pRCItem = pFea as IRasterCatalogItem;
// IRasterDataset pRasterDt = pRCItem.RasterDataset;
// IRasterLayer mRasterLayer = new RasterLayerClass();
// mRasterLayer.CreateFromDataset(pRasterDt);
// if (mRasterLayer == null) return;
// pGroupLayer.Add(mRasterLayer as ILayer);
// pFea = pFeaCursor.NextFeature();
// //IFeatureLayer pFeaLayer = new FeatureLayerClass();
// //pFeaLayer.FeatureClass = pFeaCls as IFeatureClass;
// //pFeaLayer.Name = feaclsName;
// //pGroupLayer.Add(pFeaLayer as ILayer);
//}
}
else if (rasterDBType.Trim() == "栅格数据集")
{
//栅格数据集加载
IRasterDataset pRasterDataset = pRasterWS.OpenRasterDataset(feaclsName);
//IRasterPyramid pRasterPyramid = pRasterDataset as IRasterPyramid;
//if(!pRasterPyramid.Present)
//{
// if (SysCommon.Error.ErrorHandle.ShowFrmInformation("是", "否", "未构建金字塔，是否构建金字塔？"))
// {
// pRasterPyramid.Create();
// }
//}
IRasterLayer pRasterLayer = new RasterLayerClass();
pRasterLayer.CreateFromDataset(pRasterDataset);
if (pRasterLayer == null)
{
return;
}
pGroupLayer.Add(pRasterLayer as ILayer);
}
m_Hook.MapControl.Map.AddLayer(pGroupLayer);
} catch (Exception e)
{
//*******************************************************************
//guozheng added
if (ModData.SysLog != null)
{
ModData.SysLog.Write(e, null, DateTime.Now);
}
else
{
ModData.SysLog = new SysCommon.Log.clsWriteSystemFunctionLog();
ModData.SysLog.Write(e, null, DateTime.Now);
}
//********************************************************************
return;
}
}
//对图层进行排序
SysCommon.Gis.ModGisPub.LayersCompose(m_Hook.MapControl);
//符号化 去掉加载的符号化 20111025 席胜
//GeoUtilities.ControlsRenderLayerByMxd RenderLayerByMxd = new GeoUtilities.ControlsRenderLayerByMxd();
//RenderLayerByMxd.OnCreate(m_Hook);
//RenderLayerByMxd.OnClick();
}
private void btnOk_Click(object sender, EventArgs e)
{
if (listViewEx.CheckedItems.Count == 0)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "未选择对象,无法生成历史!");
return;
}
Exception err = null;
//获取现势库连接信息
SysCommon.Gis.SysGisDataSet sourceSysGisDataSet = new SysCommon.Gis.SysGisDataSet();
switch (comBoxType.Text)
{
case "SDE":
sourceSysGisDataSet.SetWorkspace(txtServer.Text, txtInstance.Text, txtDB.Text, txtUser.Text, txtPassword.Text, txtVersion.Text, out err);
break;
case "GDB":
sourceSysGisDataSet.SetWorkspace(txtDB.Text, SysCommon.enumWSType.GDB, out err);
break;
case "PDB":
sourceSysGisDataSet.SetWorkspace(txtDB.Text, SysCommon.enumWSType.PDB, out err);
break;
default:
break;
}
if (err != null || sourceSysGisDataSet.WorkSpace == null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "未设置用户数据库连接或连接失败,请检查!");
return;
}
//获取历史库连接信息
IPropertySet pPropSet = new PropertySetClass();
IWorkspace pTagetWorkspace = null;
try
{
switch (comboBoxTypeHistory.Text)
{
case "PDB":
AccessWorkspaceFactory pAccessFact = new AccessWorkspaceFactoryClass();
if (!File.Exists(txtDBHistory.Text))
{
FileInfo filePDB = new FileInfo(txtDBHistory.Text);
pAccessFact.Create(filePDB.DirectoryName, filePDB.Name, null, 0);
}
pPropSet.SetProperty("DATABASE", txtDBHistory.Text);
pTagetWorkspace = pAccessFact.Open(pPropSet, 0);
break;
case "GDB":
FileGDBWorkspaceFactoryClass pFileGDBFact = new FileGDBWorkspaceFactoryClass();
DirectoryInfo dirGDB = new DirectoryInfo(txtDBHistory.Text);
pFileGDBFact.Create(dirGDB.Parent.FullName, dirGDB.Name.Substring(0, dirGDB.Name.Length - 4), null, 0);
pPropSet.SetProperty("DATABASE", txtDBHistory.Text);
pTagetWorkspace = pFileGDBFact.Open(pPropSet, 0);
break;
case "SDE":
IWorkspaceFactory pSdeFact = new SdeWorkspaceFactoryClass();
pPropSet.SetProperty("SERVER", txtServerHistory.Text);
pPropSet.SetProperty("INSTANCE", txtInstanceHistory.Text);
pPropSet.SetProperty("DATABASE", txtDBHistory.Text);
pPropSet.SetProperty("USER", txtUserHistory.Text);
pPropSet.SetProperty("PASSWORD", txtPasswordHistory.Text);
pPropSet.SetProperty("VERSION", txtVersionHistory.Text);
pTagetWorkspace = pSdeFact.Open(pPropSet, 0);
break;
default:
break;
}
}
catch (Exception er)
{
//*******************************************************************
//guozheng added
if (ModData.SysLog != null)
{
ModData.SysLog.Write(er, null, DateTime.Now);
}
else
{
ModData.SysLog = new SysCommon.Log.clsWriteSystemFunctionLog();
ModData.SysLog.Write(er, null, DateTime.Now);
}
//********************************************************************
}
if (pTagetWorkspace == null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "未设置历史库连接或连接失败,请检查!");
return;
}
this.Cursor = System.Windows.Forms.Cursors.AppStarting;
List <string> lstData = new List <string>();
try
{
//根据用户数据库结构创建历史库
foreach (ListViewItem aItem in listViewEx.CheckedItems)
{
if (aItem.Tag.ToString() == "FD")
{
IFeatureDataset tagetFeatureDataset = null;
IFeatureDataset pFeatureDataset = sourceSysGisDataSet.GetFeatureDataset(aItem.Text, out err);
if (!(pTagetWorkspace as IWorkspace2).get_NameExists(esriDatasetType.esriDTFeatureDataset, aItem.Text + "_GOH"))
{
tagetFeatureDataset = (pTagetWorkspace as IFeatureWorkspace).CreateFeatureDataset(aItem.Text + "_GOH", (pFeatureDataset as IGeoDataset).SpatialReference);
}
else
{
tagetFeatureDataset = (pTagetWorkspace as IFeatureWorkspace).OpenFeatureDataset(aItem.Text + "_GOH");
}
IEnumDataset pEnumDs = pFeatureDataset.Subsets;
pEnumDs.Reset();
IDataset pDs = pEnumDs.Next();
while (pDs != null)
{
IFeatureClass pFeatureClass = pDs as IFeatureClass;
if (pFeatureClass != null)
{
if (!(pTagetWorkspace as IWorkspace2).get_NameExists(esriDatasetType.esriDTFeatureClass, pDs.Name + "_GOH"))
{
CreateFeatCls(tagetFeatureDataset, pFeatureClass, pDs.Name + "_GOH", out err);
}
lstData.Add(pDs.Name);
}
pDs = pEnumDs.Next();
}
}
else if (aItem.Tag.ToString() == "FC")
{
IFeatureClass pFeatureClass = sourceSysGisDataSet.GetFeatureClass(aItem.Text, out err);
if (!(pTagetWorkspace as IWorkspace2).get_NameExists(esriDatasetType.esriDTFeatureClass, aItem.Text + "_GOH"))
{
CreateFeatCls(pTagetWorkspace as IFeatureWorkspace, pFeatureClass, aItem.Text + "_GOH", out err);
}
lstData.Add(aItem.Text);
}
}
}
catch (Exception er)
{
//*******************************************************************
//guozheng added
if (ModData.SysLog != null)
{
ModData.SysLog.Write(er, null, DateTime.Now);
}
else
{
ModData.SysLog = new SysCommon.Log.clsWriteSystemFunctionLog();
ModData.SysLog.Write(er, null, DateTime.Now);
}
//********************************************************************
this.Cursor = System.Windows.Forms.Cursors.Default;
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "创建历史库结构失败!");
return;
}
//遍历现势库数据FC进行数据移植
Dictionary <string, string> dicFieldsPair = new Dictionary <string, string>();
dicFieldsPair.Add("OBJECTID", "SourceOID");
Dictionary <string, object> dicValue = new Dictionary <string, object>();
dicValue.Add("FromDate", DateTime.Now.ToString("u"));
dicValue.Add("ToDate", DateTime.MaxValue.ToString("u"));//.ToString("YYYY-MM-DD HH:MI:SS"));
dicValue.Add("State", 0);
(pTagetWorkspace as IWorkspaceEdit).StartEditing(false);
bool res = true;
progressBarXLay.Maximum = lstData.Count;
progressBarXLay.Minimum = 0;
progressBarXLay.Value = 0;
foreach (string aFeatClsName in lstData)
{
labelXMemo.Text = "正在进行图层" + aFeatClsName + "...";
Application.DoEvents();
int cnt = 0;
int allcnt = 0;
IFeatureCursor featureCursor = null;
IFeatureClass tagetFeatCls = null;
try
{
featureCursor = sourceSysGisDataSet.GetFeatureCursor(aFeatClsName, "", null, "", out err, out cnt, out allcnt);
tagetFeatCls = (pTagetWorkspace as IFeatureWorkspace).OpenFeatureClass(aFeatClsName + "_GOH");
}
catch (Exception ex)
{
//*******************************************************************
//guozheng added
if (ModData.SysLog != null)
{
ModData.SysLog.Write(ex, null, DateTime.Now);
}
else
{
ModData.SysLog = new SysCommon.Log.clsWriteSystemFunctionLog();
ModData.SysLog.Write(ex, null, DateTime.Now);
}
//********************************************************************
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", ex.Message);
return;
}
progressBarXFeat.Maximum = cnt;
progressBarXFeat.Minimum = 0;
progressBarXFeat.Value = 0;
ModDBOperator.NewFeatures(tagetFeatCls, featureCursor, dicFieldsPair, dicValue, true, false, progressBarXFeat, out err);
Marshal.ReleaseComObject(featureCursor);
progressBarXLay.Value++;
labelXMemo.Text = "";
Application.DoEvents();
if (err != null)
{
res = false;
break;
}
}
(pTagetWorkspace as IWorkspaceEdit).StopEditing(res);
this.Cursor = System.Windows.Forms.Cursors.Default;
if (res)
{
if (m_DbProjectElement != null)
{
try
{
XmlElement aElement = m_DbProjectElement.SelectSingleNode(".//内容//历史库//连接信息") as XmlElement;
SaveObjDB(aElement, listViewEx.Items[0].Text + "_GOH");
}
catch (Exception er)
{
//*******************************************************************
//guozheng added
if (ModData.SysLog != null)
{
ModData.SysLog.Write(er, null, DateTime.Now);
}
else
{
ModData.SysLog = new SysCommon.Log.clsWriteSystemFunctionLog();
ModData.SysLog.Write(er, null, DateTime.Now);
}
//********************************************************************
return;
}
}
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "生成历史库成功!");
this.Close();
}
else
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "生成历史库失败!");
}
}
public override void OnClick()
{
Exception eError = null;
DevComponents.AdvTree.Node SelNode = m_Hook.ProjectTree.SelectedNode;
long dataID = long.Parse(SelNode.Tag.ToString()); //数据ID
//获得项目节点
DevComponents.AdvTree.Node proNode = SelNode;
while (proNode.DataKey.ToString() != EnumTreeNodeType.PROJECT.ToString())
{
proNode = proNode.Parent;
}
long projectID = long.Parse(proNode.Tag.ToString()); //项目ID
//获得根节点,数据库节点
DevComponents.AdvTree.Node mDBNode = SelNode;
while (mDBNode.Parent != null)
{
mDBNode = mDBNode.Parent;
}
//若不是数据库节点，就返回
if (mDBNode == null)
{
return;
}
if (mDBNode.DataKey == null)
{
return;
}
if (mDBNode.DataKey.ToString() == "")
{
return;
}
if (mDBNode.DataKey.ToString() != EnumTreeNodeType.DATABASE.ToString())
{
return;
}
if (mDBNode.Name == "文件连接")
{
//进行定位操作
//连接数据库
XmlElement dbElem = mDBNode.Tag as XmlElement;
if (dbElem == null)
{
return;
}
string ipStr = dbElem.GetAttribute("MetaDBConn");
// string ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ipStr + ";Persist Security Info=True";//元数据连接字符串
string ConnStr = ipStr;
//设置元数据库连接
SysCommon.DataBase.SysTable pSysDB = new SysCommon.DataBase.SysTable();
pSysDB.SetDbConnection(ConnStr, SysCommon.enumDBConType.ORACLE, SysCommon.enumDBType.ORACLE, out eError);
if (eError != null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("错误", "连接元数据库失败！连接地址为：" + ipStr);
return;
}
string str = "select * from ProjectMDTable where ID=" + projectID;
DataTable dt = pSysDB.GetSQLTable(str, out eError);
if (eError != null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("错误", "查找项目元信息表出错！");
pSysDB.CloseDbConnection();
return;
}
if (dt.Rows.Count == 0)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("错误", "找不到ID为：" + projectID + "的项目元信息！");
pSysDB.CloseDbConnection();
return;
}
string RangeDBPath = dt.Rows[0]["图幅结合表"].ToString().Trim(); //图幅结合表
//查找数据对应的图幅的比例尺和图幅号
string str1 = "";
string mapNO = ""; //图幅号
long mapSale = 0; //图幅比例尺
string feaClsName = ""; //范围图层名
if (m_DataTypeID == 0)
{
//标准图幅
str1 = "select 图幅号,图幅比例尺 from StandardMapMDTable where ID=" + dataID;
feaClsName = "MapFrame_";
}
else if (m_DataTypeID == 1)
{
//非标准图幅
str1 = "select 块图号,块图比例尺 from NonstandardMapMDTable where ID=" + dataID;
feaClsName = "Range_";
}
DataTable tempDT = pSysDB.GetSQLTable(str1, out eError);
if (eError != null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("错误", "查询数据表格出错！");
pSysDB.CloseDbConnection();
return;
}
if (tempDT.Rows.Count == 0)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("错误", "找不到数据ID为：" + dataID + "的数据元信息！");
pSysDB.CloseDbConnection();
return;
}
mapNO = tempDT.Rows[0][0].ToString().Trim();
if (tempDT.Rows[0][1].ToString().Trim() != "")
{
mapSale = long.Parse(tempDT.Rows[0][1].ToString().Trim());
}
if (mapSale == 0)
{
return; //若没有填写比例尺信息则返回
}
feaClsName += mapSale.ToString();
pSysDB.CloseDbConnection();
SysCommon.Gis.SysGisDataSet pSysDT = new SysCommon.Gis.SysGisDataSet();
pSysDT.SetWorkspace(RangeDBPath, SysCommon.enumWSType.PDB, out eError);
if (eError != null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("错误", "连接范围库出错，连接地址为：\n" + RangeDBPath);
return;
}
IFeatureClass rangeFeaCls = pSysDT.GetFeatureClass(feaClsName, out eError);
if (eError != null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("错误", "查找范围图层出错，图层名为：\n" + feaClsName);
return;
}
try
{
string whereStr = "MAP_NEWNO='" + mapNO + "'";
IQueryFilter pFilter = new QueryFilterClass();
pFilter.WhereClause = whereStr;
IFeatureCursor pCursor = rangeFeaCls.Search(pFilter, false);
if (pCursor == null)
{
return;
}
IFeature pFea = pCursor.NextFeature();
if (pFea != null)
{
//进行定位
ZoomToFeature(m_Hook.MapControl, pFea);
}
else
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("错误", "范围要素不存在！");
return;
}
//释放CURSOR
System.Runtime.InteropServices.Marshal.ReleaseComObject(pCursor);
}
catch (Exception ex)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("错误", ex.Message);
return;
}
}
}
/////////该类实现将各种ArcGis图层加载至数据库集成管理界面的图层控件当中来////////
/// <summary>
/// 加载矢量库体
/// </summary>
/// <param name="DbEleInfo">矢量库体对应的库体信息XmlElement</param>
/// <param name="in_MXDFile">符号化mxd文件路径</param>
/// <param name="ex">输出错误信息</param>
public static void AddFeaLayer(Plugin.Application.IAppDBIntegraRef m_Hook, XmlElement DbEleInfo, string in_MXDFile, out Exception ex)
{
ex = null;
try
{
XmlElement elementTemp = DbEleInfo.SelectSingleNode(".//现势库/连接信息") as XmlElement;
IWorkspace TempWorkSpace = ModDBOperate.GetDBInfoByXMLNode(elementTemp, "") as IWorkspace;
if (TempWorkSpace == null)
{
//SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "连接数据库失败!");
ex = new Exception("连接数据库失败!");
return;
}
ILayer player = ModDBOperate.GetGroupLayer(m_Hook.MapControl, m_Hook.ProjectTree.SelectedNode.DataKeyString + "_" + m_Hook.ProjectTree.SelectedNode.Text);
if (player != null)
{
m_Hook.MapControl.Map.DeleteLayer(player);
m_Hook.TOCControl.Update();
}
IGroupLayer pGroupLayer = new GroupLayerClass();
SysCommon.Gis.SysGisDataSet sysGisDataset = new SysCommon.Gis.SysGisDataSet(TempWorkSpace);
IFeatureDataset featureDataset = sysGisDataset.GetFeatureDataset((elementTemp.FirstChild as XmlElement).GetAttribute("名称"), out ex);
if (ex != null)
{
//SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据失败!");
ex = new Exception("获取数据发生异常:" + ex.Message);
return;
}
pGroupLayer.Name = m_Hook.ProjectTree.SelectedNode.DataKeyString + "_" + m_Hook.ProjectTree.SelectedNode.Text;
List <IDataset> lstDataset = sysGisDataset.GetFeatureClass(featureDataset);
//遍历要素类，加载图层
string dbType = "";
string userName = "";//用户名
userName = elementTemp.GetAttribute("用户");
dbType = elementTemp.GetAttribute("类型");
foreach (IDataset dataset in lstDataset)
{
IFeatureClass pFeatureClass = dataset as IFeatureClass;
if (pFeatureClass == null)
{
continue;
}
IFeatureLayer pFeatureLayer = new FeatureLayerClass();
if (pFeatureClass.FeatureType == esriFeatureType.esriFTAnnotation)
{
pFeatureLayer = new FDOGraphicsLayerClass();
}
pFeatureLayer.FeatureClass = pFeatureClass;
if (dbType.Trim().ToUpper() == "SDE")
{
if (dataset.Name.ToUpper().Contains(userName.Trim().ToUpper()))
{
//SDE用户图层名去掉用户名
pFeatureLayer.Name = dataset.Name.Substring(userName.Trim().Length + 1);
}
else
{
pFeatureLayer.Name = dataset.Name;
}
}
else
{
pFeatureLayer.Name = dataset.Name;
}
pFeatureLayer.Visible = false;
pGroupLayer.Add(pFeatureLayer as ILayer);
}
m_Hook.MapControl.Map.AddLayer(pGroupLayer);
SysCommon.Gis.ModGisPub.LayersCompose(m_Hook.MapControl);
}
catch (Exception eError)
{
ex = eError;
return;
}
}
//added by chulili 20110719 根据数据集加载历史数据
public void AddHistoryDataByFD(string[] strTemp, string strType)
{
Mapcontrol.ClearLayers();
Toccontrol.Update();
Application.DoEvents();
//加载历史数据
Exception err = null;
SysCommon.Gis.SysGisDataSet sourceSysGisDataSet = new SysCommon.Gis.SysGisDataSet();
switch (strType)
{
case "SDE":
sourceSysGisDataSet.SetWorkspace(strTemp[0], strTemp[1], strTemp[2], strTemp[3], strTemp[4], strTemp[5], out err);
break;
case "PDB":
sourceSysGisDataSet.SetWorkspace(strTemp[2], SysCommon.enumWSType.PDB, out err);
break;
case "GDB":
sourceSysGisDataSet.SetWorkspace(strTemp[2], SysCommon.enumWSType.GDB, out err);
break;
}
if (err != null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("连接数据库失败", "原因:" + err.Message);
return;
}
//cyf 20110706 add
DevComponents.AdvTree.Node ProjectNode = new DevComponents.AdvTree.Node();
ProjectNode = m_ProTree.SelectedNode;
while (ProjectNode.Parent != null)
{
ProjectNode = ProjectNode.Parent;
}
//cyf 20110625 add:
DevComponents.AdvTree.Node DBNode = new DevComponents.AdvTree.Node(); //数据库树节点
//获取数据库节点
DBNode = m_ProTree.SelectedNode;
while (DBNode.Parent != null && DBNode.DataKeyString != "DB")
{
DBNode = DBNode.Parent;
}
if (DBNode.DataKeyString != "DB")
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据库节点失败!");
return;
}
DevComponents.AdvTree.Node DtSetNode = new DevComponents.AdvTree.Node(); //数据集树节点
if (DBNode.Text == "现势库" || DBNode.Text == "历史库") //.DataKeyString == "现势库"
{
//获取数据集节点
DtSetNode = m_ProTree.SelectedNode;
while (DtSetNode.Parent != null && DtSetNode.DataKeyString != "FD")
{
DtSetNode = DtSetNode.Parent;
}
if (DtSetNode.DataKeyString != "FD")
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据集节点失败!");
return;
}
}
//end
//added by chulili 20110719
XmlElement elementTemp = (DBNode.Tag as XmlElement).SelectSingleNode(".//连接信息") as XmlElement;
IWorkspace TempWorkSpace = ModDBOperator.GetDBInfoByXMLNode(elementTemp, "") as IWorkspace;
SysCommon.Gis.SysGisDataSet sysGisDataset = new SysCommon.Gis.SysGisDataSet(TempWorkSpace);
IFeatureDataset featureDataset = null; //数据集
IGroupLayer pGroupLayer = new GroupLayerClass();
if (m_ProTree.SelectedNode.DataKeyString == "FD")
{
featureDataset = sysGisDataset.GetFeatureDataset(m_ProTree.SelectedNode.Text, out err);
if (err != null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据集失败，请检查该数据集是否存在!");
return;
}
pGroupLayer.Name = m_ProTree.SelectedNode.Text + "_" + ProjectNode.Text;
}
else if (m_ProTree.SelectedNode.DataKeyString == "FC")
{
featureDataset = sysGisDataset.GetFeatureDataset(DtSetNode.Text, out err);
if (err != null)
{
SysCommon.Error.ErrorHandle.ShowFrmErrorHandle("提示", "获取数据集失败!");
return;
}
pGroupLayer.Name = DtSetNode.Text + "_" + ProjectNode.Text;
}
List <IDataset> lstDataset = sysGisDataset.GetFeatureClass(featureDataset);
//end added by chulili
//List<string> lstNames = sourceSysGisDataSet.GetFeatureClassNames();
XmlElement feaclsElem = null;
try { feaclsElem = (m_ProTree.SelectedNode.Tag as XmlElement).SelectSingleNode(".//图层名") as XmlElement; }
catch { }
foreach (IDataset dataset in lstDataset)
{
IFeatureClass pFeatureClass = dataset as IFeatureClass;
if (pFeatureClass == null)
{
continue;
}
IFeatureLayer pFeatureLayer = new FeatureLayerClass();
if (pFeatureClass.FeatureType == esriFeatureType.esriFTAnnotation)
{
pFeatureLayer = new FDOGraphicsLayerClass();
}
pFeatureLayer.FeatureClass = pFeatureClass;
pFeatureLayer.Name = dataset.Name;
if (m_ProTree.SelectedNode.DataKeyString == "FC")
{
//加载指定的图层
if (m_ProTree.SelectedNode.Text != pFeatureLayer.Name)
{
continue;
}
}
else if (m_ProTree.SelectedNode.DataKeyString == "FD")
{
if (feaclsElem != null)
{
if (!feaclsElem.GetAttribute("名称").Contains(pFeatureLayer.Name))
{
//若不具备数据权限，则不进行加载
continue;
}
}
}
pGroupLayer.Add(pFeatureLayer as ILayer);
}
Mapcontrol.Map.AddLayer(pGroupLayer);
SysCommon.Gis.ModGisPub.LayersCompose(Mapcontrol);
InitialSliderItem(Mapcontrol);
}