ElasticSearch.net结构化查询
来源:互联网 发布:图像空间的消隐算法 编辑:程序博客网 时间:2024/06/06 14:23
ES_PUB_Stock这个类型定义先看之前写的文章,
以下直接列出查询方法。
public PUB_StockSearchResult Search(PUB_StockSearch param)
{PUB_StockSearchResult result = new PUB_StockSearchResult();
result.ResultList = new List<ES_PUB_StockResult>();
QueryContainer query = null;
if (!string.IsNullOrEmpty(param.Model))
{
QueryContainer query_model = new WildcardQuery() { Field = ES_PUB_StockField.Model, Value = param.Model.Trim().ToUpper() + "*" };
query = query && query_model;
}
if (!string.IsNullOrEmpty(param.CategoryNo))
{
QueryContainer query_categoryNo = new WildcardQuery() { Field = ES_PUB_StockField.CategoryNo, Value = param.CategoryNo.Trim() + "*" };
query = query && query_categoryNo;
}
if (param.UpbyMemberID > 0)
{
QueryContainer query_UpbyMemeberID = new WildcardQuery() { Field = ES_PUB_StockField.UpbyMemberID, Value = param.UpbyMemberID };
query = query && query_UpbyMemeberID;
}
if (param.PageIndex < 1)
{
param.PageIndex = 1;
}
int start = (param.PageIndex - 1) * param.PageSize.GetValueOrDefault();
if (query == null || start + param.PageSize > 10000)
{
return result;
}
List<ISort> sortlist = new List<ISort>()
{
new SortField{Field=ES_PUB_StockField.ModelLength,Order=SortOrder.Ascending},
new SortField{Field=ES_PUB_StockField.UpdateTime,Order=SortOrder.Descending}
};
var searchRequest = new SearchRequest<ES_PUB_Stock>();
searchRequest.Query = query;
searchRequest.Sort = sortlist;
searchRequest.From = start;
searchRequest.Size = param.PageSize;
var response = client.Search<ES_PUB_Stock>(searchRequest);
result.Total = response.Total;
foreach (var item in response.Hits.Select(p => p.Source))
{
MEM_ApplyInfo applyparam = new MEM_ApplyInfo();
applyparam.MEMID = item.upByMemberID;
ES_PUB_StockResult resultItem = FacetsHelper.FillPicSearchTempEntity(applyparam);
if (resultItem == null)
{
continue;
}
resultItem = GetOneStockResult(resultItem, item);
result.ResultList.Add(resultItem);
}
return result;
}
0 0
- ElasticSearch.net结构化查询
- ElasticSearch结构化查询
- Elasticsearch 结构化查询
- 【ElasticSearch】4.ElasticSearch结构化查询
- ElasticSearch(七)-结构化查询
- Elasticsearch(五)-结构化查询
- ElasticSearch.net分组查询
- ElasticSearch.net In查询
- elasticsearch结构化搜索
- ElasticSearch.net第四步-查询详解
- Elasticsearch进行and,or多条件组合DSL结构化查询
- Elasticsearch 的一些示例, 增删改查,映射,结构化查询,聚合
- ElasticSearch 常用的结构化查询字符串(持续更新中...)
- Elasticsearch之结构化索引。
- elasticsearch-查询
- Elasticsearch查询
- Elasticsearch查询
- ElasticSearch查询
- 手把手教你搭建谷歌TensorFlow深度学习开发环境和更高级的keras开发安装!
- Jedis调用之Centos7安装部署redis3.2.8(一)
- 在Struts2中,自定义radio与select的值
- React Native简介与MAC平台下环境搭建
- MYSQL语句按中文拼音排序
- ElasticSearch.net结构化查询
- leetcode day1
- Django自定义列表 models字段显示
- js函数前面的加号,叹号
- JS截取字符串常用方法
- 69.二叉树的层次遍历
- [kuangbin带你飞]专题十一 网络流 D POJ – 2195
- javascript怎么把对象里的数据整合进另外一个数组里
- 圆的面积