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";          }      }