protected override string OnExecute() { SpRequestMsg pSpRequestMsg = new SpRequestMsg(); string JsonData = string.Empty; string tableName = "p_terminal"; //设备表 string fields = "cid,jxh,sbbm,jkfl,sbmc,jd,wd,jdmc,lxdh,ssdw,dwdz,dwlxr"; //返回字段 HttpContext context = this.SpContext as HttpContext; string cid = context.Request["cid"] ?? ""; if (string.IsNullOrEmpty(cid)) { pSpRequestMsg.success = false; pSpRequestMsg.message = "设备唯一标识不能为空!"; pSpRequestMsg.data = ""; return(pSpRequestMsg.ToNormalJson()); } string strWhere = string.Format("cid={0}", cid); ValueHelper.TerminalCid = cid; SpPagingResponse pSpPagingResponse = new SpPagingResponse(); IUtilService service = SpServiceFactory.CreateUtilService(); DataTable dtDetail = null; try { dtDetail = service.QueryData(fields, tableName, strWhere, cid); pSpRequestMsg.success = true; pSpRequestMsg.message = "设备详情获取成功"; pSpRequestMsg.data = JsonData; JsonData = ValueHelper.DataTable2Json(dtDetail); } catch (Exception ex) { pSpRequestMsg.success = false; pSpRequestMsg.message = "设备详情获取异常,详情" + ex.Message; // pSpRequestMsg.data = ""; Log.Error("设备详情获取异常:" + ex.Message.ToString()); return(pSpRequestMsg.ToNormalJson()); } // return JsonData;//返回json字符串数据 //return pSpRequestMsg.ToNormalJson(); return(dtDetail.ToJsonStore(true, dtDetail.Rows.Count)); }