/// <summary> /// 图层查询 获取联表结果 /// </summary> /// <param name="sw"></param> /// <returns></returns> public static IEnumerable <SDE_QueyLayerModel> GetQueryLayerUnionResult(QueryLayerDataSW sw) { var result = new List <SDE_QueyLayerModel>(); DataTable dt = BaseDT.SDE.TD_CUNZHUDI.getUnionDT(sw); for (int i = 0; i < dt.Rows.Count; i++) { SDE_QueyLayerModel m = new SDE_QueyLayerModel(); m.ID = dt.Rows[i]["ID"].ToString(); m.Name = dt.Rows[i]["NAME"].ToString(); m.Display_X = dt.Rows[i]["DISPLAY_X"].ToString(); m.Display_Y = dt.Rows[i]["DISPLAY_Y"].ToString(); m.Flag = dt.Rows[i]["FLAG"].ToString(); m.LayerName = Enum.GetName(typeof(LayerType), int.Parse(m.Flag)); m.LNGLATSTRS = dt.Rows[i]["LNGLATSTRS"] == null ? null : dt.Rows[i]["LNGLATSTRS"].ToString(); m.DBTYPE = dt.Rows[i]["DBTYPE"] == null ? null : dt.Rows[i]["DBTYPE"].ToString(); m.TYPE = dt.Rows[i]["TYPE"].ToString(); m.CATEGORY = dt.Rows[i]["category"].ToString(); m.ImageUrl = dt.Rows[i]["ImageUrl"].ToString(); result.Add(m); } dt.Clear(); dt.Dispose(); return(result); }
/// <summary> /// 获取图层 /// </summary> /// <returns></returns> public JsonResult GetAroundLayersInfo() { var result = new List <SDE_QueyLayerResultModel>(); string flagstr = Request.Params["flagstr"]; //图层类型 string disval = Request.Params["disval"]; //周边距离 string jd = Request.Params["jd"]; //经度 string wd = Request.Params["wd"]; //纬度 var sw = new QueryLayerDataSW(); sw.FlagStr = flagstr; sw.AroundValue = disval; sw.JD = jd; sw.WD = wd; //获取符合条件的结果 var list = TD_CUNZHUDICls.GetQueryLayerUnionResult(sw); var layers = flagstr.Split(','); if (layers.Length > 0) { foreach (var item in layers) { var model = new SDE_QueyLayerResultModel(); model.LayerId = item.Trim(); model.LayerName = Enum.GetName(typeof(ManagerSystemClassLibrary.EnumCls.LayerType), int.Parse(model.LayerId)); if (list.Any()) { var recordlist = list.Where(p => p.Flag == item);//每个图层里的信息 if (recordlist.Any()) { foreach (var record in recordlist) { var data = new SDE_QueyLayerModel(); data.ID = record.ID; data.Flag = record.Flag; data.Display_X = record.Display_X; data.Display_Y = record.Display_Y; data.LayerName = model.LayerName; data.Name = record.Name; data.LNGLATSTRS = record.LNGLATSTRS; data.DBTYPE = record.DBTYPE; data.TYPE = record.TYPE; data.CATEGORY = record.CATEGORY; data.ImageUrl = record.ImageUrl; model.DataList.Add(data); } } } result.Add(model); } } return(Json(result)); }