/// <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)); }