/// <summary>
/// Adds an $elemMatch test to the query.
/// </summary>
/// <param name="query">The query to match elements with.</param>
/// <returns>The builder (so method calls can be chained).</returns>
public QueryConditionList ElemMatch(
QueryComplete query
)
{
conditions.Add("$elemMatch", query.ToBsonDocument());
return(this);
}
/// <summary>
/// Adds an $elemMatch test to the query.
/// </summary>
/// <param name="name">The name of the element to test.</param>
/// <param name="query">The query to match elements with.</param>
/// <returns>The builder (so method calls can be chained).</returns>
public static QueryConditionList ElemMatch(
string name,
QueryComplete query
)
{
return(new QueryConditionList(name).ElemMatch(query));
}
public static QueryConditionList ElemMatch(
string name,
QueryComplete query
)
{
return new QueryConditionList(name, "$elemMatch", query.ToBsonDocument());
}
/// <summary>
/// GEP상품 리스트 페이징
/// </summary>
/// <param name="page">페이지</param>
/// <param name="query">조건</param>
/// <returns>GepItemsData Class List</returns>
public MongoPagingResult<GepItemsData> List(int page, QueryComplete query)
{
SortByBuilder sort = SortBy.Descending("_id");
List<GepItemsData> List = new List<GepItemsData>();
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "gep_items");
return MongoHelper.FindByPaging<GepItemsData>(query, 10, (10 * (page - 1)), sort);
}
private QueryComplete getQuery(string[] keywords)
{
QueryComplete[] qries = new QueryComplete[keywords.Length];
int index = 0;
foreach (string keyword in keywords)
{
qries[index] = Query.EQ("Keywords", new Regex(keyword, RegexOptions.IgnoreCase));
index++;
}
return Query.Or(qries);
}
public void SetQuery(QueryComplete queryComplete)
{
if (this.QueryComplete != null)
{
this.QueryComplete = QueryBuilder.Query.And(this.QueryComplete, queryComplete);
}
else
{
this.QueryComplete = queryComplete;
}
}
public static void ParseList(IEnumerable<string> filterQuery, QueryComplete andQuery, out QueryComplete totalQuery)
{
if (filterQuery == null || filterQuery.Count() <= 0)
{
totalQuery = andQuery;
return;
}
var andQueryList = new List<IMongoQuery>();
foreach (var filter in filterQuery)
{
var v = filter.Split('~');
andQueryList.Add(Query.Or(Parse(v[0], v[1])));
}
andQueryList.Add(andQuery);
totalQuery = Query.And(andQueryList.ToArray());
}
private void PushQuery(QueryComplete query)
{
_queries.Push(new ExpressionTreeElement(query));
}
/// <summary>
/// 根据条件获取内容集合的公共方法
/// </summary>
/// <param name="qc">查询条件</param>
/// <param name="pagesize">每页条数</param>
/// <param name="pageno">页数</param>
/// <returns></returns>
public static IList<PublicContent> getContentList(QueryComplete qc, SortByDocument order, int pagesize, int pageno)
{
try
{
MongoCursor<BsonDocument> mc = MongoDBHelper.GetCursor<BsonDocument>(PublicContent.GetCollectionName(), qc, order, pageno, pagesize);
new SortByDocument("UpdateTime", -1);
return ContentResolve(mc);
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}
/// <summary>
/// GEP 상품 한건 보기
/// </summary>
/// <param name="query">조건</param>
/// <returns>GepItemsData Class</returns>
public GepItemsData View(QueryComplete query)
{
List<GepItemsData> List = new List<GepItemsData>();
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "gep_items");
return MongoHelper.FindOne<GepItemsData>(query);
}
/// <summary>
/// Export 사이트 뷰
/// </summary>
/// <param name="query">조건</param>
/// <returns></returns>
public ExportSite ExportSiteView(QueryComplete query)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "export_site");
return MongoHelper.FindOne<ExportSite>(query);
}
/// <summary>
/// Export 사이트 리스트
/// </summary>
/// <param name="query">조건</param>
/// <returns></returns>
public IQueryable<ExportSite> ExportSiteList(QueryComplete query)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "export_site");
return MongoHelper.Find<ExportSite>(query);
}
public QueryNotConditionList ElemMatch(
QueryComplete query
)
{
conditions.Add("$elemMatch", query.ToBsonDocument());
return this;
}
public void ExportSiteRemove(QueryComplete query)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "export_site");
MongoHelper.Remove(query);
}
public QueryNotConditionList ElemMatch(
QueryComplete query
)
{
return new QueryNotConditionList(name, "$elemMatch", query.ToBsonDocument());
}
/// <summary>
/// 根据条件获取内容数量的公共方法
/// </summary>
/// <param name="qc"></param>
/// <returns></returns>
public static long getContentListCount(QueryComplete qc)
{
try
{
return MongoDBHelper.GetCount(PublicContent.GetCollectionName(), qc);
}
catch (System.Exception err)
{
throw new CBB.ExceptionHelper.OperationException(
CBB.ExceptionHelper.ErrType.SystemErr,
CBB.ExceptionHelper.ErrNo.DBOperationError,
err);
}
}
/// <summary>
/// 필수선택 임시저장하여 만들어졌던 S1 상품 삭제
/// </summary>
public void DeleteSelection(QueryComplete query)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper(dataBase, collection);
MongoHelper.Remove(query);
}
/// <summary>
/// Generates a $match pipeline command based upon the given query
/// </summary>
/// <param name="query">The query used to filter the pipeline document</param>
public static BsonDocument Match(QueryComplete query) {
return new BsonDocument("$match", query.ToBsonDocument());
}
public ExpressionTreeElement(QueryComplete query)
{
_query = query;
}
/// <summary>
/// Adds an $elemMatch test to the query.
/// </summary>
/// <param name="name">The name of the element to test.</param>
/// <param name="query">The query to match elements with.</param>
/// <returns>The builder (so method calls can be chained).</returns>
public static QueryConditionList ElemMatch(
string name,
QueryComplete query
) {
return new QueryConditionList(name).ElemMatch(query);
}
/// <summary>
/// eBay 상품 리스트 조회 (페이징)
/// </summary>
/// <param name="page"></param>
/// <param name="query"></param>
/// <returns></returns>
public MongoPagingResult<eBayItemsData> List(int page, QueryComplete query)
{
SortByBuilder sort = SortBy.Descending("_id");
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper(dataBase, collection);
return MongoHelper.FindByPaging<eBayItemsData>(query, 10, (10 * (page - 1)), sort);
}
/// <summary>
/// eBay 상품 리스트 조회
/// </summary>
public IQueryable<eBayItemsData> List(QueryComplete query)
{
return new GEPMongoDacHelper(dataBase, collection).Find<eBayItemsData>(query);
}
/// <summary>
/// Adds an $elemMatch test to the query.
/// </summary>
/// <param name="query">The query to match elements with.</param>
/// <returns>The builder (so method calls can be chained).</returns>
public QueryNotConditionList ElemMatch(
QueryComplete query
)
{
return(new QueryNotConditionList(name, "$elemMatch", query.ToBsonDocument()));
}