/// <summary>
/// 添加空间坐标
/// </summary>
/// <param name="Geometry"></param>
/// <returns></returns>
public bool InsertGeometry(GeometryModel Geometry)
{
StringBuilder strInsertSql = new StringBuilder();
strInsertSql.Append(" INSERT INTO GEOMETRY( ");
strInsertSql.Append(" BOID,NAME,GATHERID,GEOMETRY,SOURCEDB)");
strInsertSql.Append(" VALUES (@BOID,@NAME,GATHERID,GEOGRAPHY::STGeomFromText(@GEOMETRY, 4326),@SOURCEDB)");
SqlParameter[] parameters =
{
new SqlParameter("BOID", SqlDbType.VarChar, 36),
new SqlParameter("NAME", SqlDbType.VarChar, 50),
new SqlParameter("GATHERID", SqlDbType.VarChar, 36),
new SqlParameter("GEOMETRY", SqlDbType.Binary),
new SqlParameter("SOURCEDB", SqlDbType.VarChar, 50)
};
parameters[0].Value = Geometry.BOID;
parameters[1].Value = Geometry.NAME;
parameters[2].Value = Geometry.GATHERID;
parameters[3].Value = Geometry.SOURCEDB;
return(SqlServerDBHelper.ExecuteCommand(strInsertSql.ToString(), parameters) > 0 ? true : false);
}
/// <summary>
/// 修改空间坐标
/// </summary>
/// <param name="Geometry"></param>
/// <returns></returns>
public bool UpdateGeometry(GeometryModel Geometry)
{
StringBuilder strUpdateSql = new StringBuilder();
strUpdateSql.Append(" UPDATE GEOMETRY SET GATHERID=:GATHERID");
strUpdateSql.Append(" SOURCEDB=@SOURCEDB,GEOMETRY=GEOGRAPHY::STGeomFromText(@GEOMETRY, 4326),NAME=@NAME");
strUpdateSql.Append(" WHERE BOID=@BOID ");
SqlParameter[] parameters =
{
new SqlParameter("GATHERID", SqlDbType.VarChar, 50),
new SqlParameter("SOURCEDB", SqlDbType.Binary),
new SqlParameter("GEOMETRY", SqlDbType.VarChar, 36),
new SqlParameter("NAME", SqlDbType.VarChar, 50),
new SqlParameter("BOID", SqlDbType.VarChar, 36)
};
parameters[0].Value = Geometry.GATHERID;
parameters[1].Value = Geometry.SOURCEDB;
parameters[2].Value = Geometry.GEOMETRY;
parameters[3].Value = Geometry.NAME;
parameters[3].Value = Geometry.BOID;
return(SqlServerDBHelper.ExecuteCommand(strUpdateSql.ToString(), parameters) > 0 ? true : false);
}
public int UpdateInfo(string sql)
{
return(SqlServerDBHelper.ExecuteCommand(sql));
}