protected MG_FeatureSet GetFeatureSet(MG_FieldSet fieldSet, string table)
{
NpgsqlDataReader reader = this.SelectAll(table);
if (reader == null || !reader.HasRows)
{
return(null);
}
MG_FeatureSet featureSet = new MG_FeatureSet();
int fc = reader.FieldCount; // 4
while (reader.Read())
{// oid f1,f2,f3... geom
MG_Feature f = new MG_Feature(fieldSet);
MG_ValueSet valueSet = new MG_ValueSet();
string oid = reader["oid"].ToString();
string geom = reader["geomtext"].ToString();
for (int i = 1; i < fc - 1; i++)
{
string str = reader[i].ToString();
MG_Value value = new MG_Value(i - 1, str);
valueSet.Add(value);
}
f.ValueSet = valueSet;
f.Geometry = MG_ShapeFileOper.AsGeometry(geom);
featureSet.Add(f);
}
reader.Close();
reader.Dispose();
return(featureSet);
}
public static MG_Feature AsFeature(Feature f)
{
FeatureDefn def = f.GetDefnRef();
MG_FieldSet fieldSet = AsFieldSet(def);
MG_Feature mgFeature = new MG_Feature(fieldSet);//collect data
// geometry
Geometry g = f.GetGeometryRef();
MG_Geometry geometry = AsGeometry(g);
string wkt = geometry.AsWKT(); // Test
mgFeature.SetGeometry(geometry); //collect data
// symbol
string styleString = f.GetStyleString();
//f.SetStyleString(styleString);
// attribute value
MG_ValueSet valueSet = new MG_ValueSet();
int fid = f.GetFID();
int nFieldCount = f.GetFieldCount();
for (int iField = 0; iField < nFieldCount; iField++)
{
FieldDefn fdef = def.GetFieldDefn(iField);
FieldType fieldType = fdef.GetFieldType();//OFTInteger OFTString OFTString
MG_Value mgValue = new MG_Value();
mgValue.Index = iField;// collect data
//collect data
if (fieldType == FieldType.OFTString)
{
mgValue.Value = f.GetFieldAsString(iField);
}
else if (fieldType == FieldType.OFTInteger)
{
mgValue.Value = f.GetFieldAsInteger(iField);
}
else if (fieldType == FieldType.OFTReal)
{
mgValue.Value = f.GetFieldAsDouble(iField);
}
else if (fieldType == FieldType.OFTDateTime)
{
int year, month, day, hour, minute, second, flag;
f.GetFieldAsDateTime(iField, out year, out month, out day, out hour, out minute, out second, out flag);
mgValue.Value = new DateTime(year, month, day, hour, minute, second, flag);
}
valueSet.Add(mgValue);
}
mgFeature.ValueSet = valueSet;//collect data
return(mgFeature);
}
