public int CreateTable(MG_FieldSet fieldSet, MG_GeometryType gt)
{
if (this.IsTableExist(fieldSet.GetName()))
return 0;
this.sql_CreateTable(fieldSet, gt, out m_strSQL, out m_sqlParams);
return this.RunSQL(m_strConn, m_strSQL, m_sqlParams);
}
private string sql_CreateTable(MG_FieldSet fieldSet, MG_GeometryType gt)
{// oid, field1, field2, field3, field4,...fieldN, geom
//CREATE TABLE point2 ( oid SERIAL PRIMARY KEY, name1 VARCHAR, name2 VARCHAR); SELECT AddGeometryColumn('public','point2','geom',0,'POINT',2);
// table name, column name must be lowercase, e.g. pointTABLE --->pointtable
string front = "CREATE TABLE {0} ( oid SERIAL PRIMARY KEY";
string table = fieldSet.GetName().ToLower();
front = String.Format(front, table);
string m = ", {0} {1}";
string mid = "";
for (int i = 0; i < fieldSet.Count(); i++)
{
MG_Field field = fieldSet.GetAt(i);
mid += String.Format(m, field.Name.ToLower(), field.Type.ToString());
}
string end = "); SELECT AddGeometryColumn('public','{0}','geom',0,'{1}',2);";
end = String.Format(end, table, gt.ToString());
string strSQL = front + mid + end;
return(strSQL);
}
public int CreateTable(MG_FieldSet fieldSet, MG_GeometryType gt)
{
if (this.IsTableExist(fieldSet.GetName()))
{
return(0);
}
this.sql_CreateTable(fieldSet, gt, out m_strSQL, out m_sqlParams);
return(this.RunSQL(m_strConn, m_strSQL, m_sqlParams));
}
public int CreateTable(MG_FieldSet fieldSet, MG_GeometryType gt)
{
if (this.IsTableExist(fieldSet.GetName()))
{
return(0);
}
string strSQL = this.sql_CreateTable(fieldSet, gt);
return(this.Run(strSQL));
}
private string LayerPath; // null or not
#endregion Fields
#region Constructors
public MG_Layer()
{
layerCount++;
this.LayerName = "Layer_" + layerCount.ToString();
this.LayerPath = null;
this.IsVisible = true;
this.FeatureSet = new MG_FeatureSet();
this.FieldSet = new MG_FieldSet(this.LayerName);
this.Extent = new MG_MapExtent();
this.Type = MG_GeometryType.NONE;
}
public MG_GeometryType Type; // default NONE
public MG_Layer()
{
layerCount++;
this.LayerName = "Layer_" + layerCount.ToString();
this.LayerPath = null;
this.IsVisible = true;
this.FeatureSet = new MG_FeatureSet();
this.FieldSet = new MG_FieldSet(this.LayerName);
this.Extent = new MG_MapExtent();
this.Type = MG_GeometryType.NONE;
}
// feature
public void AddFeature(MG_Feature feature)
{
if (this.Type == MG_GeometryType.NONE)
{
this.Type = feature.GetGeometry().Type;
this.FeatureSet.Add(feature);
}
else if (this.Type == feature.GetGeometry().Type)
{
this.FeatureSet.Add(feature);
}
}
// feature
public void AddFeature(MG_Feature feature)
{
if (this.Type == MG_GeometryType.NONE)
{
this.Type = feature.GetGeometry().Type;
this.FeatureSet.Add(feature);
}
else if (this.Type == feature.GetGeometry().Type)
{
this.FeatureSet.Add(feature);
}
}
public void InitializeLayerType(MG_GeometryType type)
{
this.layerType = type;
switch (type)
{
case MG_GeometryType.POINT:
this.radioButton1_Point.Checked = true;
break;
case MG_GeometryType.LINESTRING:
this.radioButton2_LineString.Checked = true;
break;
case MG_GeometryType.POLYGON:
this.radioButton3_Polygon.Checked = true;
break;
}
}
public void InitializeLayerType(MG_GeometryType type)
{
this.layerType = type;
switch (type)
{
case MG_GeometryType.POINT:
this.radioButton1_Point.Checked = true;
break;
case MG_GeometryType.LINESTRING:
this.radioButton2_LineString.Checked = true;
break;
case MG_GeometryType.POLYGON:
this.radioButton3_Polygon.Checked = true;
break;
}
}
private void button_OK_Click(object sender, EventArgs e)
{
string name = this.textBox1_layerName.Text.Trim().ToString();
if (!name.Equals(""))
{
this.layerName = name;
}
if (this.radioButton1_Point.Checked)
{
this.layerType = MG_GeometryType.POINT;
}
else if (this.radioButton2_LineString.Checked)
{
this.layerType = MG_GeometryType.LINESTRING;
}
else if (this.radioButton3_Polygon.Checked)
{
this.layerType = MG_GeometryType.POLYGON;
}
this.Close();
}
private void button_OK_Click(object sender, EventArgs e)
{
string name = this.textBox1_layerName.Text.Trim().ToString();
if (!name.Equals(""))
{
this.layerName = name;
}
if (this.radioButton1_Point.Checked)
{
this.layerType = MG_GeometryType.POINT;
}
else if (this.radioButton2_LineString.Checked)
{
this.layerType = MG_GeometryType.LINESTRING;
}
else if (this.radioButton3_Polygon.Checked)
{
this.layerType = MG_GeometryType.POLYGON;
}
this.Close();
}
public static wkbGeometryType TowkbGeometryType(MG_GeometryType type)
{
wkbGeometryType geomType;
switch (type)
{
case MG_GeometryType.POINT:
geomType = wkbGeometryType.wkbPoint;
break;
case MG_GeometryType.MULTIPOINT:
geomType = wkbGeometryType.wkbMultiPoint;
break;
case MG_GeometryType.LINESTRING:
geomType = wkbGeometryType.wkbLineString;
break;
case MG_GeometryType.MULTILINESTRING:
geomType = wkbGeometryType.wkbMultiLineString;
break;
case MG_GeometryType.POLYGON:
geomType = wkbGeometryType.wkbPolygon;
break;
case MG_GeometryType.MULTIPOLYGON:
geomType = wkbGeometryType.wkbMultiPolygon;
break;
default:
geomType = wkbGeometryType.wkbUnknown;
break;
}
return(geomType);
}
public void SetLayerType(MG_GeometryType type)
{
this.Type = type;
}
public void SetLayerType(MG_GeometryType type)
{
this.Type = type;
}
private void sql_CreateTable(MG_FieldSet fieldSet, MG_GeometryType gt, out string strSQL, out NpgsqlParameter[] sqlParams)
{
// oid, field1, field2, field3, field4,...fieldN, geom
//CREATE TABLE point2 ( oid SERIAL PRIMARY KEY, name1 VARCHAR, name2 VARCHAR); SELECT AddGeometryColumn('public','point2','geom',0,'POINT',2);
// table name, column name must be lowercase, e.g. pointTABLE --->pointtable
string front = "CREATE TABLE {0} ( oid SERIAL PRIMARY KEY";
string table = fieldSet.GetName().ToLower();
front = String.Format(front, table);
string m = ", {0} {1}";
string mid = "";
for (int i = 0; i < fieldSet.Count(); i++)
{
MG_Field field = fieldSet.GetAt(i);
mid += String.Format(m, field.Name, field.Type.ToString());
}
string end = "); SELECT AddGeometryColumn('public','{0}','geom',0,'{1}',2);";
end = String.Format(end, table, gt.ToString());
strSQL = front + mid + end;
sqlParams = null;
}
