protected void Page_Load(object sender, EventArgs e) { try { string rid = Context.Request.Params["rid"]; rid = 782512 + ""; Range = new JObject(); points = new JArray(); if (string.IsNullOrEmpty(rid)) { return; } else { #region 查询数据 //查询线路信息 string hql = "SELECT NEW uf_CarGPS_WFRange(a.id,a.wfRequestId,a.sqr,a.ccqsrq,a.ccqssj,a.ccjzrq,a.ccjzsj,a.ccdd,a.Range,a.RangeCount,a.sqgs,a.sqbm)FROM uf_CarGPS_WFRange a WHERE wfRequestId=?"; SimpleQuery <uf_CarGPS_WFRange> GQuery = new SimpleQuery <uf_CarGPS_WFRange>(hql, Int32.Parse(rid)); uf_CarGPS_WFRange[] GBeans = GQuery.Execute(); if (GBeans.Length < 1) { return; } uf_CarGPS_WFRange GBean = GBeans[0]; //查询人员信息 hql = "SELECT NEW HrmResource(a.id,a.loginid,a.lastname)FROM HrmResource a WHERE a.id=?"; SimpleQuery <HrmResource> SQuery = new SimpleQuery <HrmResource>(hql, GBean.sqr); HrmResource[] UBeans = SQuery.Execute(); if (UBeans.Length == 0) { return; } //查询出线路信息 hql = "SELECT NEW uf_CarGPS_WFRoute(a.id,a.PointsCount,a.CreateTime,a.RouteRange,a.WFRangeID,a.Points)FROM uf_CarGPS_WFRoute a WHERE a.WFRangeID = ?"; SimpleQuery <uf_CarGPS_WFRoute> RQuery = new SimpleQuery <uf_CarGPS_WFRoute>(hql, GBean.id); uf_CarGPS_WFRoute[] RBeans = RQuery.Execute(); #endregion #region 封装数据 Range.Add("id", GBean.id); Range.Add("rid", GBean.wfRequestId); Range.Add("uName", UBeans[0].lastname); Range.Add("sqr", GBean.sqr); Range.Add("ccqsrq", GBean.ccqsrq); Range.Add("ccqssj", GBean.ccqssj); Range.Add("ccdd", GBean.ccdd); Range.Add("Range", GBean.Range); Range.Add("RangeCount", GBean.RangeCount); Range.Add("sqgs", GBean.sqgs); Range.Add("sqbm", GBean.sqbm); if (RBeans.Length > 0) { foreach (uf_CarGPS_WFRoute bean in RBeans) { JObject jo = new JObject(); jo.Add("id", bean.id); jo.Add("PointsCount", bean.PointsCount); jo.Add("CreateTime", bean.CreateTime); jo.Add("RouteRange", bean.RouteRange); jo.Add("WFRangeID", bean.WFRangeID); jo.Add("Points", bean.Points); points.Add(jo); } } #endregion #region 返回数据 //已经放在参数内 不需要返回 #endregion } } catch (Exception _e) { Log.Error("MapSearch:", _e); throw; } //根据流程id查询 uf_CarGPS_WFRange 和 uf_CarGPS_WFRange的明细 uf_CarGPS_WFRoute、 }
protected void Page_Load(object sender, EventArgs e) { try { string rid = Context.Request.Params["rid"]; string method = Context.Request.Params["method"]; //rid = 782512 + ""; Range = new JObject(); points = new JArray(); if (string.IsNullOrEmpty(rid)) { Range = new JObject(); points = new JArray(); return; } else { #region 查询数据 //查询线路信息 string hql; if (string.IsNullOrEmpty(method)) //method=NULL 查微信 { hql = "SELECT NEW uf_CarGPS_WFRange(a.id,a.wfRequestId,a.sqr,a.ccqsrq,a.ccqssj,a.ccjzrq,a.ccjzsj,a.ccdd,a.Range,a.RangeCount,a.sqgs,a.sqbm,a.LastUpdateTime,a.WxOpenid)FROM uf_CarGPS_WFRange a WHERE wfRequestId=?"; } else//method!=NULL GPS { hql = "SELECT NEW uf_CarGPS_WFRange(a.id,a.wfRequestId,a.sqr,a.ccqsrq,a.ccqssj,a.ccjzrq,a.ccjzsj,a.ccdd,a.Range,a.RangeCount,a.sqgs,a.sqbm,a.LastUpdateTime,a.WxOpenid)FROM uf_CarGPS_WFRange a WHERE wfRequestId=? and WxOpenid is null"; } SimpleQuery <uf_CarGPS_WFRange> GQuery = new SimpleQuery <uf_CarGPS_WFRange>(hql, Int32.Parse(rid)); uf_CarGPS_WFRange[] GBeans = GQuery.Execute(); if (GBeans.Length < 1) { Range = new JObject(); points = new JArray(); return; } uf_CarGPS_WFRange GBean = GBeans[0]; //查询人员信息 hql = "SELECT NEW HrmResource(a.id,a.loginid,a.lastname)FROM HrmResource a WHERE a.id=?"; SimpleQuery <HrmResource> SQuery = new SimpleQuery <HrmResource>(hql, GBean.sqr); HrmResource[] UBeans = SQuery.Execute(); if (UBeans.Length == 0) { Range = new JObject(); points = new JArray(); return; } //查询出线路信息 hql = "SELECT NEW uf_CarGPS_WFRoute(a.id,a.PointsCount,a.CreateTime,a.RouteRange,a.WFRangeID,a.Points,a.LastUpdateTime)FROM uf_CarGPS_WFRoute a WHERE a.WFRangeID = ?"; SimpleQuery <uf_CarGPS_WFRoute> RQuery = new SimpleQuery <uf_CarGPS_WFRoute>(hql, GBean.id); uf_CarGPS_WFRoute[] RBeans = RQuery.Execute(); #endregion #region 封装数据 Range.Add("id", GBean.id); Range.Add("rid", GBean.wfRequestId); Range.Add("uName", UBeans[0].lastname); Range.Add("sqr", GBean.sqr); Range.Add("ccqsrq", GBean.ccqsrq); Range.Add("ccqssj", GBean.ccqssj); Range.Add("ccdd", GBean.ccdd); Range.Add("Range", GBean.Range); Range.Add("RangeCount", GBean.RangeCount); Range.Add("sqgs", GBean.sqgs); Range.Add("sqbm", GBean.sqbm); Range.Add("LastUpdateTime", GBean.LastUpdateTime); Range.Add("WxOpenid", GBean.WxOpenid); if (RBeans.Length > 0) { foreach (uf_CarGPS_WFRoute bean in RBeans) { JObject jo = new JObject(); jo.Add("id", bean.id); jo.Add("PointsCount", bean.PointsCount); jo.Add("CreateTime", bean.CreateTime); jo.Add("RouteRange", bean.RouteRange); jo.Add("WFRangeID", bean.WFRangeID); jo.Add("Points", bean.Points); if (bean.LastUpdateTime != null && bean.LastUpdateTime.Length > 12) { DateTime dt = DateTime.ParseExact(bean.LastUpdateTime, "yyyy/MM/dd", System.Globalization.CultureInfo.CurrentCulture); jo.Add("LastUpdateTime", dt.ToString("yyyy/MM/dd HH:mm:ss")); } else if (bean.LastUpdateTime != null) { jo.Add("LastUpdateTime", bean.LastUpdateTime); } else { jo.Add("LastUpdateTime", ""); } points.Add(jo); } } #endregion #region 返回数据 //已经放在参数内 不需要返回 #endregion } } catch (Exception _e) { Log.Error("MapSearch2:", _e); throw; } //根据流程id查询 uf_CarGPS_WFRange 和 uf_CarGPS_WFRange的明细 uf_CarGPS_WFRoute、 }