Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.77 KB | None | 0 0
  1. QueryContainer andQuery = null;
  2.  
  3. //List<QueryContainer> QueryContainers = new List<QueryContainer>();
  4.  
  5. IDXNetAnnouncement record = params;
  6.  
  7. #region keyword
  8. if (!string.IsNullOrEmpty(queries.queryfields))
  9. {
  10. var val = queries.queryfields;
  11.  
  12. TermQuery tq = new TermQuery
  13. {
  14. Field = queries.queryfields,
  15. Value = val
  16. };
  17.  
  18. if (andQuery == null)
  19. andQuery = tq;
  20. else
  21. andQuery &= tq;
  22.  
  23. //QueryContainers.Add(tq);
  24. }
  25. #endregion keyword
  26.  
  27. #region kodeemiten
  28. if (!string.IsNullOrEmpty(queries.kodeemiten))
  29. {
  30. var val = queries.kodeemiten;
  31.  
  32. TermQuery tq = new TermQuery
  33. {
  34. Name = "kode_emiten",
  35. Field = record.kode_emiten,
  36. Value = val
  37. };
  38.  
  39. if (andQuery == null)
  40. andQuery = tq;
  41. else
  42. andQuery &= tq;
  43.  
  44. //QueryContainers.Add(tq);
  45. }
  46. #endregion
  47.  
  48. #region date
  49. if (!string.IsNullOrEmpty(queries.datefrom) && !string.IsNullOrEmpty(queries.dateto))
  50. {
  51. DateRangeQuery dq = new DateRangeQuery();
  52. dq.Name = "tglpengumuman";
  53. dq.LessThanOrEqualTo = DateMath.Anchored(queries.dateto);
  54. dq.GreaterThanOrEqualTo = DateMath.Anchored(queries.datefrom);
  55. dq.Format = "dd/mm/yyyy";
  56.  
  57. if (andQuery == null)
  58. andQuery = dq;
  59. else
  60. andQuery &= dq;
  61.  
  62. //QueryContainers.Add(dq);
  63. }
  64. #endregion keyword
  65.  
  66. var reqs = (ISearchResponse<IDXNetAnnouncement>)null;
  67.  
  68. if (andQuery != null)
  69. {
  70. reqs = conn.client.Search<IDXNetAnnouncement>(s => s
  71. .AllIndices()
  72. .AllTypes()
  73. .From(queries.indexfrom)
  74. .Size(queries.pagesize)
  75. .Query(q => q.Bool(qb => qb.Must(m => m.MatchAll() && andQuery))));
  76. //var json = conn.client.Serializer.SerializeToString(reqs.ApiCall.ResponseBodyInBytes);
  77. }
  78. else
  79. {
  80. reqs = conn.client.Search<IDXNetAnnouncement>(s => s
  81. .AllIndices()
  82. .AllTypes()
  83. .From(queries.indexfrom)
  84. .Size(queries.pagesize)
  85. .Query(m => m.MatchAll()));
  86. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement