C# (CSharp) BaseMap.Web PostGIS.SQLExcute 예제들

예제 #1

        public static void updatePassableToT()
        {
            var    pg     = new PostGIS();
            string strSQL = "update ch10.realtimeroad set passable=1";

            pg.SQLExcute(strSQL);
        }

예제 #2

        public static void updateLength()
        {
            var    pg     = new PostGIS();
            string strSQL = "update ch10.realtimeroad set length1=random()*40";

            pg.SQLExcute(strSQL);
        }

예제 #3

        public static void updatePassable(int source, int target, int passable)
        {
            PostGIS pg     = new PostGIS();
            string  strSQL = string.Format(@" update ch10.realtimeroad set passable={2}  
           WHERE realtimeroad.source={0} and realtimeroad.target={1}", source, target, passable);

            pg.SQLExcute(strSQL);
        }

예제 #4

파일: postgisHelper.cs 프로젝트: HogwartsRico/AGS-PgRouting

        public static void updatePassableToT()
        {
            var pg = new PostGIS();
            string strSQL = "update ch10.realtimeroad set passable=1";

            pg.SQLExcute(strSQL);
        }

예제 #5

파일: postgisHelper.cs 프로젝트: HogwartsRico/AGS-PgRouting

 public static void updatePassable(int source ,int target,int passable)
 {
     PostGIS pg = new PostGIS();
     string strSQL = string.Format(@" update ch10.realtimeroad set passable={2}
        WHERE realtimeroad.source={0} and realtimeroad.target={1}", source, target, passable);
     pg.SQLExcute(strSQL);
 }

예제 #6

파일: postgisHelper.cs 프로젝트: HogwartsRico/AGS-PgRouting

 public static void updateLength()
 {
     var pg = new PostGIS();
     string strSQL = "update ch10.realtimeroad set length1=random()*40";
     pg.SQLExcute(strSQL);
 }