hhgis驱动

 

 

function loadPathInfo

在car.js中

function loadPathInfo(carid, fnClass) {

    var qureydrive;
    if (jsonp)
        qureydrive = remote_http + "drive/qrGisSet.ashx";
    else {
        qureydrive = "../drive/qrGisSet.ashx";
    }
    var my_page = "loadpath"
    var url = qureydrive + "?page=" + my_page;
    url += "&station=" +  encodeURIComponent(carid);
    ajaxLoadGenData(url, my_page, _loadPathInfo, fnClass);
}

 

 

 

qrGisSet.ashx

 

    public void ProcessRequest(HttpContext context)
    {
          string carid = HttpContext.Current.Request.Params["station"];
          string page = HttpContext.Current.Request.Params["page"];
          string callback = HttpContext.Current.Request.Params["callback"];
      
          // string connectionSrting = System.Configuration.ConfigurationManager.ConnectionStrings["MyConnectionString"].ToString();
          string connectionSrting = DBLogin.getConnectionStrings(95);
          string rt="";
           try {
               if (page == "loadpath")//调度日志
               {
                   rt = _loadPathinfo(connectionSrting, carid);
                   if(rt==null){
                       rt = "{success:false,message:'服务器loadpath错!'}";
                   }
               }
               else {
                  rt = "{success:false,message:'服务器loadpath错!'}"; 
              }
        }
        catch (Exception e)      {
            rt = "{success:false,message:'上传失败,可能因为上传文件过大导致!'}";

        }//catch

 增加  string tableid = HttpContext.Current.Request.Params["tableid"];

选择不同的表

updateGisSet.ashx

同上

 

TrackStation 表

 

CREATE TABLE [dbo].[TrackStation](
    [StationId] [nchar](20) NOT NULL,
    [Name] [nvarchar](50) NOT NULL,
    [StartTime] [datetime] NULL,
    [EndTime] [datetime] NULL,
    [Description] [nvarchar](4000) NULL,
    [curstatus] [int] NULL,
    [curposx] [real] NULL,
    [curposy] [real] NULL,
    [curpath] [varchar](max) NULL,
    [curtime] [datetime] NULL,
    [batchid] [int] NULL,
 CONSTRAINT [PK_TrackStation_1] PRIMARY KEY CLUSTERED 
(
    [StationId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

 

 

主页面

 在主页中重设

      function getDriver(level) {
          var qureydrive;
          if (jsonp)
              qureydrive = remote_http + "drive/qrGisSet.ashx";
          else {
              qureydrive = "../drive/qrGisSet.ashx";
          }
          return qureydrive;

      }
      function getUpdateDriver(level) {
          if (jsonp)
              return remote_http + "drive/updateGisSet.ashx";
          else {
              return "../drive/updateGisSet.ashx";
          }
      }