/// <summary>
/// Returns the template table for imports ways in Sql Server
/// </summary>
/// <returns>Template table for saving way</returns>
public static DataTable GetTableWays()
{
ConstructDataTable ways = new ConstructDataTable("dbo.Ways");
ways.AddColumn("id", TypeDataTable.Int64);
ways.AddColumn("typeGeo", TypeDataTable.Byte);
ways.AddColumn("times", TypeDataTable.DateTime);
return ways.GetDataTable();
}
/// <summary>
/// Returns the template table for imports ways and nodes in Sql Server
/// </summary>
/// <returns>Template table for saving way and refs (nodes in way)</returns>
public static DataTable GetTableWaysRefs()
{
ConstructDataTable waysRefs = new ConstructDataTable("dbo.WaysRefs");
waysRefs.AddColumn("idWay", TypeDataTable.Int64);
waysRefs.AddColumn("idNode", TypeDataTable.Int64);
waysRefs.AddColumn("orders", TypeDataTable.Int16);
return waysRefs.GetDataTable();
}
/// <summary>
/// Returns the template table for imports geos as a varbinary(max) in Sql Server
/// </summary>
/// <returns>Template table for saving geos as a varbinary(max)</returns>
public static DataTable GetTableGeo()
{
ConstructDataTable constructDataTable = new ConstructDataTable("dbo.Geo");
constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
constructDataTable.AddColumn("bin", TypeDataTable.ByteArray);
constructDataTable.AddColumn("typeGeo", TypeDataTable.Int16);
return constructDataTable.GetDataTable();
}
/// <summary>
/// Returns the template table for imports nodes in Sql Server
/// </summary>
/// <returns>Template table for saving node</returns>
public static DataTable GetTableNodes()
{
ConstructDataTable nodes = new ConstructDataTable("dbo.Nodes");
nodes.AddColumn("id", TypeDataTable.Int64);
nodes.AddColumn("lat", TypeDataTable.Double);
nodes.AddColumn("lon", TypeDataTable.Double);
nodes.AddColumn("times", TypeDataTable.DateTime);
return nodes.GetDataTable();
}
/// <summary>
/// Returns the template table for imports ways in Sql Server
/// </summary>
/// <returns>Template table for saving way</returns>
public static DataTable GetTableWays()
{
ConstructDataTable ways = new ConstructDataTable("dbo.Ways");
ways.AddColumn("id", TypeDataTable.Int64);
ways.AddColumn("typeGeo", TypeDataTable.Byte);
ways.AddColumn("times", TypeDataTable.DateTime);
return(ways.GetDataTable());
}
/// <summary>
/// Returns the template table for imports ways and nodes in Sql Server
/// </summary>
/// <returns>Template table for saving way and refs (nodes in way)</returns>
public static DataTable GetTableWaysRefs()
{
ConstructDataTable waysRefs = new ConstructDataTable("dbo.WaysRefs");
waysRefs.AddColumn("idWay", TypeDataTable.Int64);
waysRefs.AddColumn("idNode", TypeDataTable.Int64);
waysRefs.AddColumn("orders", TypeDataTable.Int16);
return(waysRefs.GetDataTable());
}
/// <summary>
/// Returns the template table for imports geos as a varbinary(max) in Sql Server
/// </summary>
/// <returns>Template table for saving geos as a varbinary(max)</returns>
public static DataTable GetTableGeo()
{
ConstructDataTable constructDataTable = new ConstructDataTable("dbo.Geo");
constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
constructDataTable.AddColumn("bin", TypeDataTable.ByteArray);
constructDataTable.AddColumn("typeGeo", TypeDataTable.Int16);
return(constructDataTable.GetDataTable());
}
/// <summary>
/// Returns the template table for imports nodes in Sql Server
/// </summary>
/// <returns>Template table for saving node</returns>
public static DataTable GetTableNodes()
{
ConstructDataTable nodes = new ConstructDataTable("dbo.Nodes");
nodes.AddColumn("id", TypeDataTable.Int64);
nodes.AddColumn("lat", TypeDataTable.Double);
nodes.AddColumn("lon", TypeDataTable.Double);
nodes.AddColumn("times", TypeDataTable.DateTime);
return(nodes.GetDataTable());
}
public static DataTable GetTableTagsValuesTrans()
{
ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValuesTrans");
constructDataTable.AddColumn("tagHash", TypeDataTable.Int32);
constructDataTable.AddColumn("valueHash", TypeDataTable.Int32);
constructDataTable.AddColumn("tagTrans", TypeDataTable.String);
constructDataTable.AddColumn("valTrans", TypeDataTable.String);
constructDataTable.AddColumn("LCID", TypeDataTable.Int16);
constructDataTable.AddColumn("typeTrans", TypeDataTable.Byte);
return constructDataTable.GetDataTable();
}
/// <summary>
/// Creates a table for storing tags and their values
/// </summary>
/// <returns>Table for storing tags and their values</returns>
public static DataTable GetTableTagsValue()
{
ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValues");
constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
constructDataTable.AddColumn("tag", TypeDataTable.Int32);
constructDataTable.AddColumn("vType", TypeDataTable.Int16);
constructDataTable.AddColumn("vHash", TypeDataTable.Int32);
constructDataTable.AddColumn("vString", TypeDataTable.String);
constructDataTable.AddColumn("vInt", TypeDataTable.Int32);
return constructDataTable.GetDataTable();
}
/// <summary>
/// Creates a table for storing tags and their values
/// </summary>
/// <returns>Table for storing tags and their values</returns>
public static DataTable GetTableTagsValue()
{
ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValues");
constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
constructDataTable.AddColumn("tag", TypeDataTable.Int32);
constructDataTable.AddColumn("vType", TypeDataTable.Int16);
constructDataTable.AddColumn("vHash", TypeDataTable.Int32);
constructDataTable.AddColumn("vString", TypeDataTable.String);
constructDataTable.AddColumn("vInt", TypeDataTable.Int32);
return(constructDataTable.GetDataTable());
}
public static DataTable GetTableTagsValuesTrans()
{
ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValuesTrans");
constructDataTable.AddColumn("tagHash", TypeDataTable.Int32);
constructDataTable.AddColumn("valueHash", TypeDataTable.Int32);
constructDataTable.AddColumn("tagTrans", TypeDataTable.String);
constructDataTable.AddColumn("valTrans", TypeDataTable.String);
constructDataTable.AddColumn("LCID", TypeDataTable.Int16);
constructDataTable.AddColumn("typeTrans", TypeDataTable.Byte);
return(constructDataTable.GetDataTable());
}
/// <summary>
/// Returns the template table for imports ways in Sql Server
/// </summary>
/// <returns>Template table for saving way</returns>
private DataTable GetTableWays()
{
ConstructDataTable ways = new ConstructDataTable("dbo.Ways");
ways.AddColumn("id", TypeDataTable.Int64);
ways.AddColumn("typeGeo", TypeDataTable.Byte);
ways.AddColumn("orders", TypeDataTable.Int16);
ways.AddColumn("idNode", TypeDataTable.Int64);
ways.AddColumn("times", TypeDataTable.DateTime);
return ways.GetDataTable();
}
/// <summary>
/// Creates a table for storing tags and their values
/// </summary>
/// <returns>Table for storing tags and their values</returns>
private DataTable GetTableTagsValue()
{
ConstructDataTable constructDataTable = new ConstructDataTable(_importConfigurator.DataBaseConfig.TableNameValues);
constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
constructDataTable.AddColumn("tag", TypeDataTable.Int32);
constructDataTable.AddColumn("vType", TypeDataTable.Int16);
constructDataTable.AddColumn("vHash", TypeDataTable.Int32);
constructDataTable.AddColumn("vString", TypeDataTable.String);
constructDataTable.AddColumn("vInt", TypeDataTable.Int32);
return constructDataTable.GetDataTable();
}
/// <summary>
/// Returns the template table for imports node as a varbinary(max) in Sql Server
/// </summary>
/// <returns>Template table for saving node as a varbinary(max)</returns>
private DataTable GetTableGeo()
{
ConstructDataTable constructDataTable = new ConstructDataTable(_importConfigurator.DataBaseConfig.TableNameGeo);
constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
constructDataTable.AddColumn("bin", TypeDataTable.ByteArray);
constructDataTable.AddColumn("typeGeo", TypeDataTable.Int16);
return constructDataTable.GetDataTable();
}