/// <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);
}
