/// <summary> /// delete data by key value /// 删除指定条件数据 /// </summary> /// <param name="KeyColumnName"></param> /// <param name="KeyValue"></param> /// <returns></returns> public MongoDeleteData Where(string KeyColumnName, CommandComparison comparison, object KeyValue) { filterDefinition = MongoDBOP.GetFilterOP(KeyColumnName, KeyValue, comparison); return(this); }
/// <summary> /// get data by filter /// 得到指定条件的表中所有数据 /// </summary> /// <param name="ColumnName">筛选字段名 Filed</param> /// <param name="Value">筛选值 Filter value</param> /// <param name="Comparison">筛选条件 Filter where</param> /// <returns></returns> public MongoGetData Where(String ColumnName, Object Value, CommandComparison Comparison) { filterDefinition = MongoDBOP.GetFilterOP(ColumnName, Value, Comparison); return(this); }
/// <summary> /// 多种查询条件组合 /// </summary> /// <param name="ColumnName"></param> /// <param name="Value"></param> /// <returns></returns> public static FilterDefinition <BsonDocument> GetWhere(String[] ColumnName, Object[] Value) { FilterDefinition <BsonDocument> definition = new BsonDocument(); for (int i = 0; i < ColumnName.Length; i++) { FilterDefinition <BsonDocument> def = MongoDBOP.GetFilterOP(ColumnName[i], Value[i], CommandComparison.Equals); definition = definition & def; } return(definition); }
/// <summary> /// 多种查询条件组合 /// </summary> /// <param name="ColumnName"></param> /// <param name="Value"></param> /// <param name="comparison"></param> /// <param name="relation"></param> /// <returns></returns> public static FilterDefinition <BsonDocument> GetWhere(String[] ColumnName, Object[] Value, CommandComparison[] comparison, WhereRelation[] relation) { FilterDefinition <BsonDocument> definition = new BsonDocument(); for (int i = 0; i < ColumnName.Length; i++) { FilterDefinition <BsonDocument> def = MongoDBOP.GetFilterOP(ColumnName[i], Value[i], comparison[i]); if (relation[i] != WhereRelation.Or) { definition = definition & def; } else { definition = definition | def; } } return(definition); }
/// <summary> /// update new data /// 更新数据 /// </summary> /// <param name="KeyColumnName"></param> /// <param name="KeyValue"></param> /// <returns></returns> public MongoUpdateData Where(String KeyColumnName, Object KeyValue) { filterDefinition = MongoDBOP.GetFilterOP(KeyColumnName, KeyValue, CommandComparison.Equals); return(this); }