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(); //保留表结构，清空表
}
/// <summary>
/// 创建普通表
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public bool CreateLogicTreeTable(IDataSource ds)
{
IFieldInfoCollection fields = new FieldInfoCollection();
IFieldInfo field = new FieldInfo();
try
{
if (ds != null)
{
field.Name = "id";
field.FieldType = gviFieldType.gviFieldFID;
field.Nullable = false;
fields.Add(field);
field = new FieldInfo();
field.Name = "groupid";
field.FieldType = gviFieldType.gviFieldString;
field.Length = 255;
field.Nullable = false;
fields.Add(field);
field = new FieldInfo();
field.Name = "name";
field.FieldType = gviFieldType.gviFieldString;
field.Length = 255;
field.Nullable = false;
fields.Add(field);
field = new FieldInfo();
field.Name = "founder";
field.FieldType = gviFieldType.gviFieldString;
field.Length = 255;
fields.Add(field);
field = new FieldInfo();
field.Name = "content";
field.FieldType = gviFieldType.gviFieldBlob;
field.Nullable = false;
fields.Add(field);
ds.CreateTable("cm_logictree", "id", fields);
fields.Clear();
field = new FieldInfo();
field.Name = "id";
field.FieldType = gviFieldType.gviFieldFID;
field.Nullable = false;
fields.Add(field);
field = new FieldInfo();
field.Name = "groupuid";
field.FieldType = gviFieldType.gviFieldString;
field.Length = 255;
field.Nullable = false;
fields.Add(field);
field = new FieldInfo();
field.Name = "DataSet";
field.FieldType = gviFieldType.gviFieldString;
field.Length = 255;
field.Nullable = false;
fields.Add(field);
ds.CreateTable("cm_group", "id", fields);
return(true);
}
else
{
return(false);
}
}
catch (COMException comEx)
{
System.Diagnostics.Trace.WriteLine(comEx.Message);
return(false);
}
catch (System.Exception ex)
{
System.Diagnostics.Trace.WriteLine(ex.Message);
return(false);
}
finally
{
//Marshal.ReleaseComObject(field);
field = null;
//Marshal.ReleaseComObject(fields);
fields = null;
}
}
///<summary>
/// Constructs a panel info with a list of fields and a list of children panel info.
///</summary>
public PanelInfo()
{
FieldInfos = new FieldInfoCollection();
PanelInfos = new List <IPanelInfo>();
}
