public IRowBufferCollection GetRows(Dictionary <string, IRowBuffer> rows)
{
if (rows == null || rows.Count == 0)
{
return(null);
}
IRowBufferCollection rowCollection = new RowBufferCollection();
foreach (string key in rows.Keys)
{
rowCollection.Add(rows[key]);
}
return(rowCollection);
}
private void AddGeometry()
{
try
{
this.beforeRowBufferMap.Clear();
SelectCollection.Instance().Clear();
DF3DFeatureClass featureClassInfo = CommonUtils.Instance().CurEditLayer;
if (featureClassInfo == null)
{
return;
}
IFeatureClass fc = featureClassInfo.GetFeatureClass();
if (fc == null)
{
return;
}
IFieldInfoCollection fields = fc.GetFields();
int indexGeo = fields.IndexOf(this._strGeometryFieldName);
if (indexGeo == -1)
{
return;
}
IGeometry geo = this._drawTool.GetGeo();
IGeometry geoOut = null;
switch (geo.GeometryType)
{
case gviGeometryType.gviGeometryModelPoint:
geoOut = geo;
break;
case gviGeometryType.gviGeometryPoint:
IPoint pt = geo as IPoint;
IPoint pt1 = pt.Clone2(gviVertexAttribute.gviVertexAttributeZM) as IPoint;
pt1.SetCoords(pt.X, pt.Y, pt.Z, 0, 0);
geoOut = pt1;
break;
case gviGeometryType.gviGeometryPolyline:
IPolyline line = geo as IPolyline;
IPolyline line1 = this._geoFact.CreateGeometry(gviGeometryType.gviGeometryPolyline, gviVertexAttribute.gviVertexAttributeZM) as IPolyline;
for (int i = 0; i < line.PointCount; i++)
{
IPoint ptGet = line.GetPoint(i);
IPoint pttemp = ptGet.Clone2(gviVertexAttribute.gviVertexAttributeZM) as IPoint;
pttemp.SetCoords(ptGet.X, ptGet.Y, ptGet.Z, 0, 0);
line1.AppendPoint(pttemp);
}
geoOut = line1;
break;
case gviGeometryType.gviGeometryPolygon:
IPolygon polygon = geo as IPolygon;
IPolygon polygon1 = this._geoFact.CreateGeometry(gviGeometryType.gviGeometryPolygon, gviVertexAttribute.gviVertexAttributeZM) as IPolygon;
for (int i = 0; i < polygon.ExteriorRing.PointCount; i++)
{
IPoint ptGet = polygon.ExteriorRing.GetPoint(i);
IPoint pttemp = ptGet.Clone2(gviVertexAttribute.gviVertexAttributeZM) as IPoint;
pttemp.SetCoords(ptGet.X, ptGet.Y, ptGet.Z, 0, 0);
polygon1.ExteriorRing.AppendPoint(pttemp);
}
geoOut = polygon1;
break;
}
if (geoOut == null)
{
return;
}
if (geo.GeometryType == gviGeometryType.gviGeometryModelPoint)
{
//导入模型到数据库中
string mn = BitConverter.ToString(ObjectIdGenerator.Generate()).Replace("-", string.Empty).ToLowerInvariant();
IModelPoint mp = geoOut as IModelPoint;
bool bRes = this.ImportOsg(mn, mp.ModelName);
if (!bRes)
{
return;
}
mp.ModelName = mn;
geoOut = mp;
}
IRowBufferCollection rowCol = new RowBufferCollection();
IRowBufferFactory fac = new RowBufferFactory();
IRowBuffer row = fac.CreateRowBuffer(fields);
row.SetValue(indexGeo, geoOut);
rowCol.Add(row);
beforeRowBufferMap[featureClassInfo] = rowCol;
}
catch (Exception ex)
{
}
}
private void CmdEditFacilityStyle_FacStyleClassChangedEvent(DF3DPipeCreateTool.Class.FacStyleClass style)
{
try
{
this.beforeRowBufferMap.Clear();
if (style == null)
{
return;
}
DF3DFeatureClass dffc = CommonUtils.Instance().CurEditLayer;
if (dffc == null)
{
return;
}
IFeatureClass fc = dffc.GetFeatureClass();
if (fc == null)
{
return;
}
FacClassReg reg = FacilityInfoService.GetFacClassRegByFeatureClassID(fc.GuidString);
if (reg == null)
{
return;
}
TopoClass tc = FacilityInfoService.GetTopoClassByFacClassCode(reg.FacClassCode);
if (tc == null)
{
return;
}
FacilityClass facc = reg.FacilityType;
if (facc == null)
{
return;
}
IResourceManager manager = fc.FeatureDataSet as IResourceManager;
if (manager == null)
{
return;
}
IFieldInfoCollection fields = fc.GetFields();
//int indexGroupid = -1;
//int indexClassify = -1;
//SubClass sc = null;
//MajorClass mc = LogicDataStructureManage3D.Instance.GetMajorClassByDFFeatureClassID(fc.GuidString);
//if (mc != null)
//{
// indexClassify = fields.IndexOf(mc.ClassifyField);
// indexGroupid = fields.IndexOf("GroupId");
//}
int index = fields.IndexOf("StyleId");
if (index == -1)
{
return;
}
int mnindex = fields.IndexOf("ModelName");
int mpindex = fields.IndexOf("Geometry");
if (mpindex == -1)
{
return;
}
HashMap hm = SelectCollection.Instance().GetSelectGeometrys();
if (hm != null && hm.Count == 1)
{
IRowBufferCollection res = new RowBufferCollection();
IRowBufferCollection rowBufferCollection = hm[dffc] as IRowBufferCollection;
if (rowBufferCollection != null)
{
for (int i = 0; i < rowBufferCollection.Count; i++)
{
IRowBuffer rowBuffer = rowBufferCollection.Get(i);
Fac fac = null;
IModelPoint mp = null;
IModel finemodel = null;
IModel simplemodel = null;
string name = "";
switch (facc.Name)
{
case "PipeNode":
fac = new PipeNodeFac(reg, style, rowBuffer, tc);
break;
case "PipeLine":
fac = new PipeLineFac(reg, style, rowBuffer, tc, false, false);
break;
case "PipeBuild":
case "PipeBuild1":
fac = new PipeBuildFac(reg, style, rowBuffer);
break;
}
if (UCAuto3DCreate.RebuildModel(fac, style, out mp, out finemodel, out simplemodel, out name))
{
if (finemodel == null || mp == null)
{
continue;
}
mp.ModelEnvelope = finemodel.Envelope;
rowBuffer.SetValue(mpindex, mp);
rowBuffer.SetValue(index, style.ObjectId);
//if (mc != null)
//{
// if (indexClassify != -1 && indexGroupid != -1)
// {
// }
//}
bool bRes = false;
if (!string.IsNullOrEmpty(mp.ModelName))
{
if (!manager.ModelExist(mp.ModelName))
{
if (manager.AddModel(mp.ModelName, finemodel, simplemodel))
{
bRes = true;
}
}
else
{
if (manager.UpdateModel(mp.ModelName, finemodel) && manager.UpdateSimplifiedModel(mp.ModelName, simplemodel))
{
bRes = true;
}
}
}
if (bRes)
{
res.Add(rowBuffer);
}
}
}
}
beforeRowBufferMap[dffc] = res;
//SelectCollection.Instance().Clear();
UpdateDatabase();
DF3DApplication app = DF3DApplication.Application;
if (app == null || app.Current3DMapControl == null)
{
return;
}
app.Current3DMapControl.FeatureManager.RefreshFeatureClass(fc);
}
}
catch (Exception ex)
{
}
}
private void AddRecord()
{
try
{
this.beforeRowBufferMap.Clear();
SelectCollection.Instance().Clear();
DF3DFeatureClass featureClassInfo = CommonUtils.Instance().CurEditLayer;
if (featureClassInfo == null)
{
return;
}
IFeatureClass fc = featureClassInfo.GetFeatureClass();
if (fc == null)
{
return;
}
IFeatureLayer fl = featureClassInfo.GetFeatureLayer();
if (fl == null)
{
return;
}
IFieldInfoCollection fields = fc.GetFields();
int indexGeo = fields.IndexOf(fl.GeometryFieldName);
if (indexGeo == -1)
{
return;
}
IFieldInfo fiGeo = fields.Get(indexGeo);
if (fiGeo == null || fiGeo.GeometryDef == null)
{
return;
}
IGeometry geo = this._drawTool.GetGeo();
if (geo.GeometryType != gviGeometryType.gviGeometryPolygon)
{
return;
}
IPolygon polygon = geo as IPolygon;
IPolygon geoOut = this._geoFact.CreateGeometry(gviGeometryType.gviGeometryPolygon, fiGeo.GeometryDef.VertexAttribute) as IPolygon;
for (int i = 0; i < polygon.ExteriorRing.PointCount; i++)
{
IPoint ptGet = polygon.ExteriorRing.GetPoint(i);
IPoint pttemp = ptGet.Clone2(fiGeo.GeometryDef.VertexAttribute) as IPoint;
if (fiGeo.GeometryDef.HasZ)
{
pttemp.SetCoords(ptGet.X, ptGet.Y, ptGet.Z, 0, 0);
}
else
{
pttemp.SetCoords(ptGet.X, ptGet.Y, 0, 0, 0);
}
geoOut.ExteriorRing.AppendPoint(pttemp);
}
IRowBufferCollection rowCol = new RowBufferCollection();
IRowBufferFactory fac = new RowBufferFactory();
IRowBuffer row = fac.CreateRowBuffer(fields);
row.SetValue(indexGeo, geoOut);
foreach (DataRow dr in this._dt.Rows)
{
IFieldInfo fi = dr["F"] as IFieldInfo;
if (fi == null)
{
continue;
}
string fn = fi.Name;
int index = fields.IndexOf(fn);
if (index != -1)
{
if (dr["FV"] == null)
{
row.SetNull(index);
}
else
{
string strobj = dr["FV"].ToString();
bool bRes = false;
switch (fi.FieldType)
{
case gviFieldType.gviFieldBlob:
case gviFieldType.gviFieldGeometry:
case gviFieldType.gviFieldUnknown:
break;
case gviFieldType.gviFieldFloat:
float f;
bRes = float.TryParse(strobj, out f);
if (bRes)
{
row.SetValue(index, f);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldDouble:
double d;
bRes = double.TryParse(strobj, out d);
if (bRes)
{
row.SetValue(index, d);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldFID:
case gviFieldType.gviFieldUUID:
case gviFieldType.gviFieldInt16:
Int16 i16;
bRes = Int16.TryParse(strobj, out i16);
if (bRes)
{
row.SetValue(index, i16);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldInt32:
Int32 i32;
bRes = Int32.TryParse(strobj, out i32);
if (bRes)
{
row.SetValue(index, i32);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldInt64:
Int64 i64;
bRes = Int64.TryParse(strobj, out i64);
if (bRes)
{
row.SetValue(index, i64);
}
else
{
row.SetNull(index);
}
break;;
case gviFieldType.gviFieldString:
row.SetValue(index, strobj);
break;
case gviFieldType.gviFieldDate:
DateTime dt;
bRes = DateTime.TryParse(strobj, out dt);
if (bRes)
{
row.SetValue(index, dt);
}
else
{
row.SetNull(index);
}
break;
default:
break;
}
}
}
}
rowCol.Add(row);
beforeRowBufferMap[featureClassInfo] = rowCol;
UpdateDatabase();
}
catch (Exception ex)
{
}
}
private void AddRecord()
{
try
{
this.beforeRowBufferMap.Clear();
SelectCollection.Instance().Clear();
if (reg == null || tc == null)
{
return;
}
FacStyleClass style = this.cmbStyle.EditValue as FacStyleClass;
if (style == null)
{
return;
}
SubClass sc = this.cmbClassify.EditValue as SubClass;
DF3DFeatureClass featureClassInfo = CommonUtils.Instance().CurEditLayer;
if (featureClassInfo == null)
{
return;
}
IFeatureClass fc = featureClassInfo.GetFeatureClass();
if (fc == null)
{
return;
}
IResourceManager manager = fc.FeatureDataSet as IResourceManager;
if (manager == null)
{
return;
}
IFeatureLayer fl = featureClassInfo.GetFeatureLayer();
if (fl == null)
{
return;
}
IFieldInfoCollection fields = fc.GetFields();
int indexOid = fields.IndexOf(fc.FidFieldName);
if (indexOid == -1)
{
return;
}
int mpindex = fields.IndexOf(fl.GeometryFieldName);
if (mpindex == -1)
{
return;
}
int indexShape = fields.IndexOf("Shape");
if (indexShape == -1)
{
return;
}
int indexFootPrint = fields.IndexOf("FootPrint");
if (indexFootPrint == -1)
{
return;
}
int indexStyleId = fields.IndexOf("StyleId");
if (indexStyleId == -1)
{
return;
}
int indexFacilityId = fields.IndexOf("FacilityId");
if (indexFacilityId == -1)
{
return;
}
IFieldInfo fiShape = fields.Get(indexShape);
if (fiShape == null || fiShape.GeometryDef == null)
{
return;
}
IGeometry geo = this._drawTool.GetGeo();
if (geo.GeometryType != gviGeometryType.gviGeometryPoint)
{
return;
}
IPoint pt = geo as IPoint;
IPoint geoOut = pt.Clone2(fiShape.GeometryDef.VertexAttribute) as IPoint;
if (fiShape.GeometryDef.HasZ)
{
geoOut.SetCoords(pt.X, pt.Y, pt.Z, 0, 0);
}
else
{
geoOut.SetCoords(pt.X, pt.Y, 0, 0, 0);
}
IQueryFilter filter = new QueryFilter();
filter.WhereClause = "1=1";
filter.ResultBeginIndex = 0;
filter.ResultLimit = 1;
filter.PostfixClause = "ORDER BY " + fc.FidFieldName + " desc";
IFdeCursor cursor = null;
cursor = fc.Search(filter, false);
IRowBuffer rowtemp = cursor.NextRow();
int oid = 0;
if (rowtemp != null)
{
oid = int.Parse(rowtemp.GetValue(indexOid).ToString());
}
if (cursor != null)
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(cursor);
cursor = null;
}
IRowBufferFactory fac = new RowBufferFactory();
IRowBuffer row = fac.CreateRowBuffer(fields);
row.SetValue(indexOid, oid + 1);
row.SetValue(indexShape, geoOut);
row.SetValue(indexFootPrint, geoOut.Clone2(gviVertexAttribute.gviVertexAttributeNone));
row.SetValue(indexStyleId, style.ObjectId);
row.SetValue(indexFacilityId, BitConverter.ToString(ObjectIdGenerator.Generate()).Replace("-", string.Empty).ToLowerInvariant());
if (sc != null)
{
int indexClassify = fields.IndexOf(this._classifyName);
int indexGroupId = fields.IndexOf("GroupId");
if (indexClassify != -1 && indexGroupId != -1)
{
row.SetValue(indexClassify, sc.Name);
row.SetValue(indexGroupId, sc.GroupId);
}
}
foreach (DataRow dr in this._dt.Rows)
{
IFieldInfo fi = dr["F"] as IFieldInfo;
if (fi == null)
{
continue;
}
string fn = fi.Name;
int index = fields.IndexOf(fn);
if (index != -1)
{
if (dr["FV"] == null)
{
row.SetNull(index);
}
else
{
string strobj = dr["FV"].ToString();
bool bRes = false;
switch (fi.FieldType)
{
case gviFieldType.gviFieldBlob:
case gviFieldType.gviFieldGeometry:
case gviFieldType.gviFieldUnknown:
break;
case gviFieldType.gviFieldFloat:
float f;
bRes = float.TryParse(strobj, out f);
if (bRes)
{
row.SetValue(index, f);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldDouble:
double d;
bRes = double.TryParse(strobj, out d);
if (bRes)
{
row.SetValue(index, d);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldFID:
case gviFieldType.gviFieldUUID:
case gviFieldType.gviFieldInt16:
Int16 i16;
bRes = Int16.TryParse(strobj, out i16);
if (bRes)
{
row.SetValue(index, i16);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldInt32:
Int32 i32;
bRes = Int32.TryParse(strobj, out i32);
if (bRes)
{
row.SetValue(index, i32);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldInt64:
Int64 i64;
bRes = Int64.TryParse(strobj, out i64);
if (bRes)
{
row.SetValue(index, i64);
}
else
{
row.SetNull(index);
}
break;;
case gviFieldType.gviFieldString:
row.SetValue(index, strobj);
break;
case gviFieldType.gviFieldDate:
DateTime dt;
bRes = DateTime.TryParse(strobj, out dt);
if (bRes)
{
row.SetValue(index, dt);
}
else
{
row.SetNull(index);
}
break;
default:
break;
}
}
}
}
Fac plf = new PipeNodeFac(reg, style, row, tc);
IModelPoint mp = null;
IModel finemodel = null;
IModel simplemodel = null;
string name = "";
if (UCAuto3DCreate.RebuildModel(plf, style, out mp, out finemodel, out simplemodel, out name))
{
if (finemodel == null || mp == null)
{
return;
}
mp.ModelEnvelope = finemodel.Envelope;
row.SetValue(mpindex, mp);
//if (mc != null)
//{
// if (indexClassify != -1 && indexGroupid != -1)
// {
// }
//}
bool bRes = false;
if (!string.IsNullOrEmpty(mp.ModelName))
{
if (!manager.ModelExist(mp.ModelName))
{
if (manager.AddModel(mp.ModelName, finemodel, simplemodel))
{
bRes = true;
}
}
else
{
if (manager.UpdateModel(mp.ModelName, finemodel) && manager.UpdateSimplifiedModel(mp.ModelName, simplemodel))
{
bRes = true;
}
}
}
if (!bRes)
{
return;
}
IRowBufferCollection rowCol = new RowBufferCollection();
rowCol.Add(row);
beforeRowBufferMap[featureClassInfo] = rowCol;
UpdateDatabase();
app.Current3DMapControl.FeatureManager.RefreshFeatureClass(fc);
}
}
catch (Exception ex)
{
}
}
public void ImportModelMdb(IFeatureClass fc, string mdbFile, int groupId)
{
try
{
//2、获取基本信息
FileInfo fInfo = new FileInfo(mdbFile);
string strFilePath = fInfo.DirectoryName;
Gvitech.CityMaker.Resource.IResourceFactory rf = new Gvitech.CityMaker.Resource.ResourceFactory();
IResourceManager rm = fc.FeatureDataSet as IResourceManager;
Dictionary <string, IEnvelope> cacheModeInfos = new Dictionary <string, IEnvelope>();
List <string> cacheImageNames = new List <string>();
IGeometryFactory geoFactory = new GeometryFactory();
IResourceFactory symbolFac = new ResourceFactory();
IRowBufferCollection fcRows = new RowBufferCollection();
IRowBuffer fcRow = null;
//4、解析mdb
string strConn = _ConnStr + mdbFile + "\'";
int index = 0;
int totalCount = 0;
using (OleDbConnection oleConn = new OleDbConnection(strConn))
{
oleConn.Open();
string strSql = "select count(*) from Attribute_Table_CityManager";
OleDbCommand countCmd = new OleDbCommand(strSql, oleConn);
OleDbDataReader countReader = countCmd.ExecuteReader();
countReader.Read();
totalCount = countReader.GetInt32(0);
countReader.Close();
OleDbCommand command = new OleDbCommand(_QueryModelStr, oleConn);
OleDbDataReader reader = command.ExecuteReader();
IModelPoint modePoint = null;
while (reader.Read())
{
int percent = ++index * 100 / totalCount;
string toolTip = string.Format("已完成{0}条/总共{1}条 {2}%", index, totalCount, percent);
CommonEntity.FormEntity.Text = toolTip;
double dScaleX = 0.0;
double dScaleY = 0.0;
double dScaleZ = 0.0;
double.TryParse(reader.GetString(9), out dScaleX);
double.TryParse(reader.GetString(10), out dScaleY);
double.TryParse(reader.GetString(11), out dScaleZ);
//if (dScaleX < 0 || dScaleY < 0 || dScaleZ < 0)
// continue;
//fc
fcRow = fc.CreateRowBuffer();
int nPose = fcRow.FieldIndex("name");
if (nPose == -1)
{
continue;
}
string modelName = reader.GetString(0);
fcRow.SetValue(nPose, modelName);
nPose = fcRow.FieldIndex("groupId");
if (nPose == -1)
{
continue;
}
fcRow.SetValue(nPose, groupId);
modePoint = (IModelPoint)geoFactory.CreateGeometry(
gviGeometryType.gviGeometryModelPoint,
gviVertexAttribute.gviVertexAttributeZ);
modePoint.ModelName = modelName;
double dModePointX = double.Parse(reader.GetString(2)) + 0; // CoorX = 0
double dModePointY = double.Parse(reader.GetString(3)) + 0; // CoorY = 0
double dModePointZ = double.Parse(reader.GetString(4)) + 0; // CoorZ = 0
double dRotationAngle = double.Parse(reader.GetString(5));
double dAxisX = double.Parse(reader.GetString(6));
double dAxisY = double.Parse(reader.GetString(7));
double dAxisZ = double.Parse(reader.GetString(8));
double dUTransAngel = double.Parse(reader.GetString(12));
double dUTransX = double.Parse(reader.GetString(13));
double dUTransY = double.Parse(reader.GetString(14));
double dUTransZ = double.Parse(reader.GetString(15));
modePoint.X = dModePointX;
modePoint.Y = dModePointY;
modePoint.Z = dModePointZ;
IMatrix matrix = new Matrix();
IVector3 pointVec = new Vector3();
pointVec.X = dModePointX;
pointVec.Y = dModePointY;
pointVec.Z = dModePointZ;
IVector3 Scale = new Vector3();
Scale.X = dScaleX;
Scale.Y = dScaleY;
Scale.Z = dScaleZ;
IVector3 Rotation = new Vector3();
Rotation.X = dAxisX;
Rotation.Y = dAxisY;
Rotation.Z = dAxisZ;
IVector3 Shear = new Vector3();
Shear.X = dUTransX;
Shear.Y = dUTransY;
Shear.Z = dUTransZ;
matrix.Compose2(pointVec, Scale, dRotationAngle, Rotation, dUTransAngel, Shear);
modePoint.FromMatrix(matrix);
//mc
IPropertySet Images = null;
//如果内存中不包含
if (!cacheModeInfos.Keys.Contains(modelName))
{
//数据库中包含
if (rm.ModelExist(modelName))
{
//重名即跳过
IEnvelope ev = rm.GetModel(modelName).Envelope;
modePoint.ModelEnvelope = ev;
}
else
{
IModel simpleModel = null;
string osgFilePath = strFilePath + "\\" + modelName + ".osg";
IModel fineModel = null;
IMatrix m = null;
symbolFac.CreateModelAndImageFromFileEx(osgFilePath,
out Images, out simpleModel, out fineModel, out m);
if (fineModel == null || fineModel.GroupCount == 0)
{
continue;
}
cacheModeInfos[modelName] = modePoint.ModelEnvelope = Clone(fineModel.Envelope);
rm.AddModel(modelName, fineModel, simpleModel);
}
}
else
{
modePoint.ModelEnvelope = cacheModeInfos[modelName];
}
nPose = fcRow.FieldIndex("Geometry");
fcRow.SetValue(nPose, modePoint);
fcRows.Add(fcRow);
//tc
if (Images != null)
{
int nCount = Images.Count;
if (nCount > 0)
{
Hashtable htImages = Images.AsHashtable();
foreach (DictionaryEntry item in htImages)
{
string imgName = item.Key.ToString();
IImage img = item.Value as IImage;
if (img == null)
{
continue;
}
if (string.IsNullOrEmpty(imgName))
{
continue;
}
//如果内存中不包含
if (!cacheImageNames.Contains(imgName))
{
//数据库中包含
if (rm.ImageExist(imgName))
{
//重名即跳过
}
}
//如果内存中不包含，数据库中也不包含
if (!rm.ImageExist(imgName) &&
!cacheImageNames.Contains(imgName))
{
cacheImageNames.Add(imgName);
rm.AddImage(imgName, img);
}
}
}
}
//end
if (fcRows.Count >= 10)
{
InsertFeatures(fc as IObjectClass, fcRows);
fcRows.Clear();
}
}
reader.Close();
oleConn.Close();
}
if (fcRows.Count > 0)
{
InsertFeatures(fc as IObjectClass, fcRows);
fcRows.Clear();
}
}
catch (System.Exception ex)
{
if (ex.GetType().Name.Equals("UnauthorizedAccessException"))
{
MessageBox.Show("需要标准runtime授权");
}
else
{
MessageBox.Show(ex.Message);
}
}
}
private void toolStripButtonEditFeature_Click(object sender, EventArgs e)
{
this.dataGridView1.EndEdit(); //强制提交
if (dsFactory == null)
{
dsFactory = new DataSourceFactory();
}
IDataSource ds = null;
IFeatureDataSet dataset = null;
IFeatureClass fc = null;
IFdeCursor cursor = null;
IFieldInfo field = null;
try
{
if (dataGridView1.SelectedRows.Count == 1)
{
ds = dsFactory.OpenDataSource(Info.ci);
dataset = ds.OpenFeatureDataset(Info.datasetName);
fc = dataset.OpenFeatureClass(Info.featureclassName);
// 比较是否修改了记录
int oid = int.Parse(dataGridView1.SelectedRows[0].Cells["oid"].Value.ToString());
IRowBuffer fdeRow = fc.GetRow(oid);
bool isChanged = false;
for (int i = 0; i < AttriTable.Columns.Count; ++i)
{
string strColName = AttriTable.Columns[i].ColumnName;
int nPos = fdeRow.FieldIndex(strColName);
if (nPos != -1)
{
field = fdeRow.Fields.Get(nPos);
}
if (nPos != -1 && strColName != "oid" && strColName != "GroupName" && field.FieldType != gviFieldType.gviFieldGeometry)
{
if (fdeRow.GetValue(nPos) == null || (!dataGridView1.Rows[dataGridView1.SelectedRows[0].Index].Cells[i].EditedFormattedValue.Equals(fdeRow.GetValue(nPos).ToString())))
{
isChanged = true;
break;
}
}
}
if (!isChanged)
{
MessageBox.Show("该条记录无改动");
return;
}
for (int j = 0; j < AttriTable.Columns.Count; ++j)
{
string strColName = AttriTable.Columns[j].ColumnName;
int nPos = fdeRow.FieldIndex(strColName);
if (nPos != -1)
{
field = fdeRow.Fields.Get(nPos);
}
if (nPos != -1 && strColName != "oid" && strColName != "GroupName" && field.FieldType != gviFieldType.gviFieldGeometry)
{
fdeRow.SetValue(nPos, dataGridView1.Rows[dataGridView1.SelectedRows[0].Index].Cells[j].EditedFormattedValue); //插入字段值
}
}
// 修改数据库中记录
IRowBufferCollection col = new RowBufferCollection();
col.Add(fdeRow);
fc.UpdateRows(col, false);
MessageBox.Show("修改成功");
}
}
catch (COMException ex)
{
System.Diagnostics.Trace.WriteLine(ex.Message);
}
finally
{
if (ds != null)
{
//Marshal.ReleaseComObject(ds);
ds = null;
}
if (dataset != null)
{
//Marshal.ReleaseComObject(dataset);
dataset = null;
}
if (fc != null)
{
//Marshal.ReleaseComObject(fc);
fc = null;
}
if (cursor != null)
{
//Marshal.ReleaseComObject(cursor);
cursor = null;
}
}
}
static void Main(string[] args)
{
//创建要素类要先定义属性字段
IFieldInfoCollection fields = new FieldInfoCollection();
{
//名称列
IFieldInfo field = new FieldInfo();
field.Name = "Name";
field.FieldType = gviFieldType.gviFieldString;
field.Length = 255;
fields.Add(field);
//空间列
field = new FieldInfo();
field.Name = "Geometry";
field.FieldType = gviFieldType.gviFieldGeometry; //列类型为空间类型
field.GeometryDef = new GeometryDef(); //需要实例化一个几何定义对象,里面有大量与空间有关的内容，比如：
field.GeometryDef.HasZ = true; //是否在Z值，默认为false,只能存XY
field.GeometryDef.GeometryColumnType = gviGeometryColumnType.gviGeometryColumnPoint; //空间列的几何类型
field.RegisteredRenderIndex = true; //注册渲染索引，允许在renderControl中显示
fields.Add(field);
//多空间列
field = new FieldInfo();
field.Name = "Model";
field.FieldType = gviFieldType.gviFieldGeometry; //列类型为空间类型
field.GeometryDef = new GeometryDef(); //需要实例化一个几何定义对象,里面有大量与空间有关的内容，比如：
field.GeometryDef.HasZ = true; //是否在Z值，默认为false,只能存XY
field.GeometryDef.GeometryColumnType = gviGeometryColumnType.gviGeometryColumnModelPoint; //空间列的几何类型
field.RegisteredRenderIndex = true; //注册渲染索引，允许在renderControl中显示
fields.Add(field);
//... 其它列
}
//创建要素类
IFeatureClass FC = FDS.CreateFeatureClass("FC", fields);
int nameID = FC.GetFields().IndexOf("Name"); //获取对应列的索引，
int geomID = FC.GetFields().IndexOf("Geometry");
int fidIndex = FC.GetFields().IndexOf(FC.FidFieldName);
//增加单条数据，并同步到FeatureLayer
IFdeCursor fcu = FC.Insert(); //通过FC创建一个插入游标，用来操作rowBuffer
IRowBuffer rb = FC.CreateRowBuffer(); //通过FC创建一条空要素实例，用来设置数据，设置完成后将其塞入FC
IPoint p = new GeometryFactory().CreatePoint(gviVertexAttribute.gviVertexAttributeZ); // 将要塞入空间列的几何对象，类型要对应 FC的field.GeometryDef.GeometryColumnType ，否则塞不进
rb.SetValue(nameID, "testPointA"); //塞名称
rb.SetValue(geomID, p); //塞几何
fcu.InsertRow(rb); //塞进FC
int fid = fcu.LastInsertId; //成功后反回这条buffer的主键ID
rb.SetValue(fidIndex, fid); //Cursor（FC）增加数据后会产生一个对应的FID，要把这个FID赋值给row才能在FLayer中显示
ax.FeatureManager.CreateFeature(FC, rb); //同步到renderControl
//增加很大量数据时，参考以下方法
IFdeCursor cu = FC.Insert();
IRowBufferCollection rows = new RowBufferCollection();
for (int i = 0; i < 100000; i++)
{
IRowBuffer row = FC.CreateRowBuffer();
// do something ...
row.SetValue(geomID, p);
cu.InsertRow(row);
row.SetValue(fidIndex, cu.LastInsertId);
rows.Add(row);
}
ax.FeatureManager.CreateFeatures(FC, rows);
//或直接整体更新
ax.FeatureManager.RefreshFeatureClass(FC);
//查
string tagStr = "tagName";
IQueryFilter qf = new QueryFilter(); //过滤器
qf.WhereClause = $"Name = '{tagStr}'";
IFdeCursor res = FC.Search(qf, true); //条件查
IRowBuffer aBuffer = res.NextRow(); //遍历查询结果
//改
IFdeCursor upCu = FC.Update(qf);
IRowBuffer upBuffer = upCu.NextRow();
upCu.UpdateRow(upBuffer);
//删
FC.Delete(qf);
FC.DeleteRow(0);
FC.Truncate(); //保留表结构，清空表
}
public void ImportModelXml(IFeatureClass fc, string mdbFile, int groupId, int _nCount)
{
try
{
//2、获取基本信息
FileInfo fInfo = new FileInfo(mdbFile);
string strFilePath = fInfo.DirectoryName;
IResourceManager rm = fc.FeatureDataSet as IResourceManager;
Dictionary <string, IEnvelope> cacheModeInfos = new Dictionary <string, IEnvelope>();
List <string> cacheImageNames = new List <string>();
IGeometryFactory geoFactory = new GeometryFactory();
IResourceFactory symbolFac = new ResourceFactory();
IRowBufferCollection fcRows = new RowBufferCollection();
IRowBuffer fcRow = null;
//4、解析xml
string strConn = "" + mdbFile + "\'";
int index = 0;
int totalCount = _nCount;
IModelPoint modePoint = null;
for (int i = 0; i < _nCount; ++i)
{
int percent = ++index * 100 / totalCount;
string toolTip = string.Format("已完成{0}条/总共{1}条 {2}%", index, totalCount, percent);
CommonEntity.FormEntity.Text = toolTip;
//fc
fcRow = fc.CreateRowBuffer();
int nPose = fcRow.FieldIndex("name");
if (nPose == -1)
{
continue;
}
string modelName = _dataTable.Rows[i]["ModelName"].ToString();
fcRow.SetValue(nPose, modelName);
nPose = fcRow.FieldIndex("groupId");
if (nPose == -1)
{
continue;
}
fcRow.SetValue(nPose, groupId);
modePoint = (IModelPoint)geoFactory.CreateGeometry(
gviGeometryType.gviGeometryModelPoint,
gviVertexAttribute.gviVertexAttributeZ);
modePoint.ModelName = modelName;
double dModePointX = double.Parse(_dataTable.Rows[i]["LocationX"].ToString()) + 0; // CoorX = 0
double dModePointY = double.Parse(_dataTable.Rows[i]["LocationY"].ToString()) + 0; // CoorY = 0
double dModePointZ = double.Parse(_dataTable.Rows[i]["LocationZ"].ToString()) + 0; // CoorZ = 0
string strMatrix = _dataTable.Rows[i]["Matrix3"].ToString();
float[] Matrix = null;
if (!string.IsNullOrEmpty(strMatrix))
{
string[] strArray = strMatrix.Split(',');
if (strArray.Length == 9)
{
Matrix = new float[9];
Matrix[0] = float.Parse(strArray[0]);
Matrix[1] = float.Parse(strArray[1]);
Matrix[2] = float.Parse(strArray[2]);
Matrix[3] = float.Parse(strArray[3]);
Matrix[4] = float.Parse(strArray[4]);
Matrix[5] = float.Parse(strArray[5]);
Matrix[6] = float.Parse(strArray[6]);
Matrix[7] = float.Parse(strArray[7]);
Matrix[8] = float.Parse(strArray[8]);
}
}
modePoint.X = dModePointX;
modePoint.Y = dModePointY;
modePoint.Z = dModePointZ;
modePoint.Matrix33 = Matrix;
//mc
IPropertySet Images = null;
//如果内存中不包含
if (!cacheModeInfos.Keys.Contains(modelName))
{
//数据库中包含
if (rm.ModelExist(modelName))
{
//重名即跳过
IEnvelope ev = rm.GetModel(modelName).Envelope;
modePoint.ModelEnvelope = ev;
}
else
{
IModel simpleModel = null;
string osgFilePath = strFilePath + "\\" + modelName + ".osg";
IModel fineModel = null;
IMatrix matrix = null;
symbolFac.CreateModelAndImageFromFileEx(osgFilePath,
out Images, out simpleModel, out fineModel, out matrix);
if (fineModel == null || fineModel.GroupCount == 0)
{
continue;
}
cacheModeInfos[modelName] = modePoint.ModelEnvelope = Clone(fineModel.Envelope);
rm.AddModel(modelName, fineModel, simpleModel);
//Marshal.ReleaseComObject(simpleModel);
//Marshal.ReleaseComObject(fineModel);
}
}
else
{
modePoint.ModelEnvelope = cacheModeInfos[modelName];
}
nPose = fcRow.FieldIndex("Geometry");
fcRow.SetValue(nPose, modePoint);
fcRows.Add(fcRow);
//tc
int nCount = Images.Count;
if (Images != null && nCount > 0)
{
Hashtable htImages = Images.AsHashtable();
foreach (DictionaryEntry item in htImages)
{
string imgName = item.Key.ToString();
IImage img = item.Value as IImage;
if (img == null)
{
continue;
}
if (string.IsNullOrEmpty(imgName))
{
continue;
}
//如果内存中不包含
if (!cacheImageNames.Contains(imgName))
{
//数据库中包含
if (rm.ImageExist(imgName))
{
//重名即跳过
}
}
//如果内存中不包含，数据库中也不包含
if (!rm.ImageExist(imgName) &&
!cacheImageNames.Contains(imgName))
{
cacheImageNames.Add(imgName);
rm.AddImage(imgName, img);
}
}
}
//end
if (fcRows.Count >= 10)
{
InsertFeatures(fc as IObjectClass, fcRows);
fcRows.Clear();
}
}
if (fcRows.Count > 0)
{
InsertFeatures(fc as IObjectClass, fcRows);
fcRows.Clear();
}
}
catch (System.Exception ex)
{
if (ex.GetType().Name.Equals("UnauthorizedAccessException"))
{
MessageBox.Show("需要标准runtime授权");
}
else
{
MessageBox.Show(ex.Message);
}
}
}
private void AddRecord(IGeometry geo)
{
try
{
if (geo.GeometryType != gviGeometryType.gviGeometryModelPoint)
{
return;
}
this.beforeRowBufferMap.Clear();
SelectCollection.Instance().Clear();
DF3DFeatureClass featureClassInfo = CommonUtils.Instance().CurEditLayer;
if (featureClassInfo == null)
{
return;
}
IFeatureClass fc = featureClassInfo.GetFeatureClass();
if (fc == null)
{
return;
}
IFeatureDataSet fds = fc.FeatureDataSet;
if (fds == null)
{
return;
}
IFeatureLayer fl = featureClassInfo.GetFeatureLayer();
if (fl == null)
{
return;
}
IFieldInfoCollection fields = fc.GetFields();
int indexGeo = fields.IndexOf(fl.GeometryFieldName);
if (indexGeo == -1)
{
return;
}
IFieldInfo fiGeo = fields.Get(indexGeo);
if (fiGeo == null || fiGeo.GeometryDef == null)
{
return;
}
IModelPoint pt = geo as IModelPoint;
string mname = Path.GetFileNameWithoutExtension(pt.ModelName);
IEnvelope envelope = ImportOsg(fc, pt.ModelName);
if (envelope == null)
{
return;
}
IModelPoint geoOut = pt.Clone2(fiGeo.GeometryDef.VertexAttribute) as IModelPoint;
if (fiGeo.GeometryDef.HasZ)
{
geoOut.SetCoords(pt.X, pt.Y, pt.Z, 0, 0);
}
else
{
geoOut.SetCoords(pt.X, pt.Y, 0, 0, 0);
}
geoOut.ModelName = mname;
geoOut.ModelEnvelope = new EnvelopeClass
{
MinX = envelope.MinX,
MaxX = envelope.MaxX,
MinY = envelope.MinY,
MaxY = envelope.MaxY,
MinZ = envelope.MinZ,
MaxZ = envelope.MaxZ
};
IRowBufferCollection rowCol = new RowBufferCollection();
IRowBufferFactory fac = new RowBufferFactory();
IRowBuffer row = fac.CreateRowBuffer(fields);
row.SetValue(indexGeo, geoOut);
foreach (DataRow dr in this._dt.Rows)
{
IFieldInfo fi = dr["F"] as IFieldInfo;
if (fi == null)
{
continue;
}
string fn = fi.Name;
int index = fields.IndexOf(fn);
if (index != -1)
{
if (dr["FV"] == null)
{
row.SetNull(index);
}
else
{
string strobj = dr["FV"].ToString();
bool bRes = false;
switch (fi.FieldType)
{
case gviFieldType.gviFieldBlob:
case gviFieldType.gviFieldGeometry:
case gviFieldType.gviFieldUnknown:
break;
case gviFieldType.gviFieldFloat:
float f;
bRes = float.TryParse(strobj, out f);
if (bRes)
{
row.SetValue(index, f);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldDouble:
double d;
bRes = double.TryParse(strobj, out d);
if (bRes)
{
row.SetValue(index, d);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldFID:
case gviFieldType.gviFieldUUID:
case gviFieldType.gviFieldInt16:
Int16 i16;
bRes = Int16.TryParse(strobj, out i16);
if (bRes)
{
row.SetValue(index, i16);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldInt32:
Int32 i32;
bRes = Int32.TryParse(strobj, out i32);
if (bRes)
{
row.SetValue(index, i32);
}
else
{
row.SetNull(index);
}
break;
case gviFieldType.gviFieldInt64:
Int64 i64;
bRes = Int64.TryParse(strobj, out i64);
if (bRes)
{
row.SetValue(index, i64);
}
else
{
row.SetNull(index);
}
break;;
case gviFieldType.gviFieldString:
row.SetValue(index, strobj);
break;
case gviFieldType.gviFieldDate:
DateTime dt;
bRes = DateTime.TryParse(strobj, out dt);
if (bRes)
{
row.SetValue(index, dt);
}
else
{
row.SetNull(index);
}
break;
default:
break;
}
}
}
}
rowCol.Add(row);
beforeRowBufferMap[featureClassInfo] = rowCol;
UpdateDatabase();
Clear();
(this._drawTool as Draw3DModel).Set3DModelFilePath(this.beFilePath.Text);
}
catch (Exception ex)
{
}
}
public void ImportModelOsg(IFeatureClass fc, string osgFile, int groupId)
{
try
{
FileInfo fInfo = new FileInfo(osgFile);
string strFilePath = fInfo.DirectoryName;
IResourceManager rm = fc.FeatureDataSet as IResourceManager;
IGeometryFactory geoFactory = new GeometryFactory();
IResourceFactory symbolFac = new ResourceFactory();
IRowBuffer fcRow = null;
//fc
string modelName = fInfo.Name.Split('.')[0];
fcRow = fc.CreateRowBuffer();
int nPose = fcRow.FieldIndex("name");
if (nPose != -1)
{
fcRow.SetValue(nPose, modelName);
}
nPose = fcRow.FieldIndex("groupId");
if (nPose != -1)
{
fcRow.SetValue(nPose, groupId);
}
//mc
IPropertySet Images = null;
IModel simpleModel = null;
string osgFilePath = strFilePath + "\\" + modelName + ".osg";
IModel fineModel = null;
IMatrix matrix = null;
symbolFac.CreateModelAndImageFromFileEx(osgFilePath,
out Images, out simpleModel, out fineModel, out matrix);
if (fineModel == null || fineModel.GroupCount == 0)
{
return;
}
rm.AddModel(modelName, fineModel, simpleModel);
//Marshal.ReleaseComObject(simpleModel);
//Marshal.ReleaseComObject(fineModel);
//tc
int nCount = Images.Count;
if (Images != null && nCount > 0)
{
Hashtable htImages = Images.AsHashtable();
foreach (DictionaryEntry item in htImages)
{
String imgName = item.Key.ToString();
IImage img = item.Value as IImage;
rm.AddImage(imgName, img);
}
}
//modelpoint
IModelPoint modePoint = null;
modePoint = (IModelPoint)geoFactory.CreateGeometry(
gviGeometryType.gviGeometryModelPoint,
gviVertexAttribute.gviVertexAttributeZ);
modePoint.FromMatrix(matrix);
modePoint.ModelName = modelName;
double dModePointX = 0.0;
double dModePointY = 0.0;
double dModePointZ = 0.0;
modePoint.X += dModePointX;
modePoint.Y += dModePointY;
modePoint.Z += dModePointZ;
nPose = fcRow.FieldIndex("Geometry");
fcRow.SetValue(nPose, modePoint);
if (fc.HasTemporal())
{
ITemporalManager mgr = fc.TemporalManager;
mgr.Insert(DateTime.Now, fcRow);
//Marshal.ReleaseComObject(mgr);
}
else
{
IRowBufferCollection fcRows = new RowBufferCollection();
fcRows.Add(fcRow);
InsertFeatures(fc as IObjectClass, fcRows);
fcRows.Clear();
}
}
catch (System.Exception ex)
{
if (ex.GetType().Name.Equals("UnauthorizedAccessException"))
{
MessageBox.Show("需要标准runtime授权");
}
else
{
MessageBox.Show(ex.Message);
}
}
}
