private void cbxNewDB_SelectedIndexChanged(object sender, EventArgs e) { this.cbxNewKQ.Items.Clear(); int fclsID; mcEnumIDs fclsEnum; mcFClsInfo fclsInfo;//要素类的信息 m_gdbObj = m_svcObj.get_gdb(this.cbxNewDB.SelectedItem.ToString()); if (m_gdbObj != null) { fclsEnum = m_gdbObj.get_xclses(meXClsType.meXSFCls, 0); //光标复位 fclsID = fclsEnum.Reset(); //将fclsID中的ID对应的要素名逐一加到myXFClsList的listbox中。 while (fclsID > 0) { fclsInfo = (mcFClsInfo)m_gdbObj.get_xclsInfo(meXClsType.meXSFCls, fclsID); if (fclsInfo != null) { this.cbxNewKQ.Items.Add(fclsInfo.name); fclsInfo = null; } fclsID = fclsEnum.Next(); } } }
private void svcList_SelectedIndexChanged(object sender, EventArgs e) { //初始化数据库选项 meConnectType connType; int rtn = 0; mcEnumIDs gdbIDs = null; int gdbID = 0; ListViewItem item = null; if (svcList.SelectedItem != null) { m_svcObj = new mcGDBServer(); //1.判断数据源连接类型,若为非本地连接,需要输入用户名和密码 connType = m_svcMng.Get(svcList.SelectedIndex).SvcType; if (connType == meConnectType.meConLocal || connType == meConnectType.meCon6xLocal) { rtn = m_svcObj.Connect(m_svcMng.Get(svcList.SelectedIndex).SvcName, "", ""); } //else //{ // logFrm logInfo = new logFrm(); // if (logInfo.ShowDialog() != DialogResult.OK) // return; // rtn = m_svcObj.Connect(m_svcMng.Get(svcList.SelectedIndex).SvcName, logInfo.m_user, logInfo.m_pswd); //} if (rtn < 1) { return; } //2.获取当前数据源连接包含的所有数据库 gdbIDs = m_svcObj.gdbs; if (gdbIDs == null) { return; } //gdbList.Items.Clear(); //2.1.取第一条记录 gdbID = gdbIDs.Reset(); while (gdbID > 0) { m_gdbObj = m_svcObj.get_gdb0(gdbID); this.cbxNewDB.Items.Add(m_gdbObj.name); this.cbsSourceDB.Items.Add(m_gdbObj.name); //2.2取下一条记录 gdbID = gdbIDs.Next(); } } }
private void btnGeoUpdate_Click(object sender, EventArgs e) { GeoUpdateParameterSetDlg aupDlg = new GeoUpdateParameterSetDlg(this); if (aupDlg.ShowDialog() == DialogResult.OK) { mcGDBServer GDBSvr = null; mcGDataBase GDB = null; mcGDataBase GDB_source = null; mcQueryDef QueryDef = null; mcQueryDef QueryDef_source = null; mcGeoPolygon GeoPolygon = null; mcGeoPolygon GeoPolygon_source = null; IGeometry pgeo = null; IGeometry pgeo_source = null; IVectorCls VecCls = null; IVectorCls VecCls_source = null; mcObjectID ID = null; mcObjectID ID_Source = null; IVectorCls VecCls_Add = null; GDBSvr = new mcGDBServer(); QueryDef = new mcQueryDef(); QueryDef_source = new mcQueryDef(); GeoPolygon = new mcGeoPolygon(); GeoPolygon_source = new mcGeoPolygon(); //变量初始化 ID = new mcObjectID(); ID_Source = new mcObjectID(); //连接数据源,打开数据库 try { GDBSvr.Connect("MapGislocal", "", ""); GDB = GDBSvr.get_gdb(DB); GDB_source = GDBSvr.get_gdb(DB_source); VecCls = GDB.get_XClass(meXClsType.meXSFCls) as IVectorCls; VecCls_source = GDB_source.get_XClass(meXClsType.meXSFCls) as IVectorCls; VecCls.Open(KQ, 0); VecCls_source.Open(KQ_source, 0); ID.Int = 1; VecCls.GetGeometry(ID, out pgeo); GeoPolygon = (mcGeoPolygon)pgeo; //空间查询模式。主要有四种 :相交、外包矩形相交、相等、相离,具体意思及区别见技术文档 QueryDef.set_Spatial(GeoPolygon, meSpaQueryMode.meModeIntersect); ID_Source.Int = 1; VecCls_source.GetGeometry(ID_Source, out pgeo_source); GeoPolygon_source = (mcGeoPolygon)pgeo_source; //空间查询模式。主要有四种 :相交、外包矩形相交、相等、相离,具体意思及区别见技术文档 QueryDef_source.set_Spatial(GeoPolygon_source, meSpaQueryMode.meModeIntersect); string[] keys = new string[dict.Count]; dict.Keys.CopyTo(keys, 0); foreach (string key in keys) { if ("".Equals(key)) { mcQueryDef QDef = null; mcRecordSet RecordSet = null; QueryDef = new mcQueryDef(); IVectorCls VecCls_data = null; //打开待分析数据 VecCls_data = GDB.get_XClass(meXClsType.meXSFCls) as IVectorCls; VecCls_data.Open(dict[key], 0); VecCls_Add = GDB_source.get_XClass(meXClsType.meXSFCls) as IVectorCls; VecCls_Add.Create(dict[key], meGeomConstrainType.mefReg, 0, 0, null); //设置属性查询条件 QueryDef.Filter = ""; VecCls_data.Select(QDef, out RecordSet); int rtn = VecCls_Add.CopySet(RecordSet); VecCls_Add.Close(); VecCls_data.Close(); break; } SpatialDataAutoUpdate(GDBSvr, GDB, GDB_source, QueryDef, QueryDef_source, dict[key], key, Field, Field_source); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { VecCls.Close(); VecCls_source.Close(); GDBSvr.DisConnect(); GDB.Close(); GDB_source.Close(); } } }
private static void SpatialDataAutoUpdate(mcGDBServer GDBSvr, mcGDataBase GDB, mcGDataBase GDB_source, mcQueryDef QueryDef, mcQueryDef QueryDef_source, string data, string data_source, string field, string field_source) { //变量定义 mcRecordSet RecordSet = null; mcRecordSet RecordSet_source = null; IVectorCls VecCls_data = null; IVectorCls VecCls_source_data = null; try { //打开待分析数据 VecCls_data = GDB.get_XClass(meXClsType.meXSFCls) as IVectorCls; VecCls_data.Open(data, 0); VecCls_source_data = GDB_source.get_XClass(meXClsType.meXSFCls) as IVectorCls; VecCls_source_data.Open(data_source, 0); VecCls_data.Select(QueryDef, out RecordSet); VecCls_source_data.Select(QueryDef_source, out RecordSet_source); int SfcID = 0; SfcID = RecordSet.MoveFirst(); while (!RecordSet.IsEOF()) { mcRecord record = null; mcFields Fields = null; IGeometry geo = null; IGeomInfo geoInfo = null; object val = null; mcObjectID mID = new mcObjectID(); RecordSet.Get(out geo, out record, out geoInfo); record.GetFields(out Fields); record.GetFldVal(field, out val); int SfcID_source = 0; bool flag = true; SfcID_source = RecordSet_source.MoveFirst(); while (!RecordSet_source.IsEOF()) { mcObjectID id_source = new mcObjectID(); mcRecord record_source = null; mcFields Fields_source = null; IGeometry geo_source = null; IGeomInfo geoInfo_source = null; object val_source = null; RecordSet_source.Get(out geo_source, out record_source, out geoInfo_source); RecordSet_source.GetID(out id_source); record_source.GetFields(out Fields_source); record_source.GetFldVal(field_source, out val_source); //找到新旧数据中对应的矿体 if (val.ToString().Equals(val_source.ToString())) { flag = false; VecCls_source_data.Del(id_source); VecCls_source_data.Append(geo, record, geoInfo); //更新原始数据结果集 要不会报空指针错误 VecCls_source_data.Select(QueryDef, out RecordSet_source); break; } SfcID_source = RecordSet_source.MoveNext(); } //判断是否是新增矿体 新增矿体直接添加 if (flag) { VecCls_source_data.Append(geo, record, geoInfo); //更新原始数据结果集 要不会报空指针错误 VecCls_source_data.Select(QueryDef, out RecordSet_source); } SfcID = RecordSet.MoveNext(); } } catch (Exception ex) { throw new Exception("更新出错啦!"); } finally { //关闭类、数据库、断开数据源 VecCls_data.Close(); VecCls_source_data.Close(); } }