private string GetLayerFields(string layerId) { StringBuilder str = new StringBuilder(); try { var query = from a in _ILayerContentRepository.GetAll() join b in _ILayerFieldRepository.GetAll() on a.Id equals b.LayerID where a.Id == layerId select new { b.AttributeName }; if (query != null) { foreach (var item in query) { str.Append("\""); str.Append(item.AttributeName); str.Append("\""); str.Append(","); } if (str.Length > 0) { str.Length = str.Length - 1; } } return(str.ToString()); } catch (Exception ex) { return(string.Empty); } }
/// <summary> /// 通过图层ID获取字段字典集合 /// </summary> /// <param name="layerID"></param> /// <returns></returns> public ListResultOutput <LayerFieldDictDto> GetFieldDictByLayerID(string layerID) { try { List <LayerFieldDictDto> layerFieldDicts = new List <LayerFieldDictDto>(); var query = _ILayerFieldRepository.GetAll().Where(q => q.LayerID == layerID && q.AttributeDataType == "T").ToList(); foreach (var item in query) { string fieldId = item.Id; var result = _ILayerFieldDictRepository.GetAll().Where(t => t.AttributeID == fieldId).ToList(); foreach (var detail in result) { LayerFieldDictDto dto = new LayerFieldDictDto(); dto.AttributeID = detail.AttributeID; dto.FieldDictDesc = detail.FieldDictDesc; dto.FieldDictName = detail.FieldDictName; dto.Id = detail.Id; layerFieldDicts.Add(dto); } } var list = new ListResultOutput <LayerFieldDictDto>(layerFieldDicts); return(list); } catch (Exception ex) { throw new Exception(ex.Message); } }