/// <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> /// update many new data /// 更新多个数据 /// </summary> /// <param name="KeyColumnName"></param> /// <param name="comparison"></param> /// <param name="KeyValue"></param> /// <param name="relation"></param> /// <returns></returns> public MongoUpdateData Where(String[] KeyColumnName, CommandComparison[] comparison, Object[] KeyValue, WhereRelation[] relation) { filterDefinition = MongoDBOP.GetWhere(KeyColumnName, KeyValue, comparison, relation); 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> /// update many new data /// 更新多个数据 /// </summary> /// <param name="KeyColumnName"></param> /// <param name="KeyValue"></param> /// <returns></returns> public MongoUpdateData Where(String[] KeyColumnName, Object[] KeyValue) { filterDefinition = MongoDBOP.GetWhere(KeyColumnName, KeyValue); return(this); }
/// <summary> /// delete data by many key value /// 删除多个指定条件数据 /// </summary> /// <param name="KeyColumnName"></param> /// <param name="KeyValue"></param> /// <returns></returns> public MongoDeleteData Where(string[] KeyColumnName, object[] KeyValue) { if (KeyColumnName.Length != KeyValue.Length) { throw new Exception("Column number not Equals Value number"); } filterDefinition = MongoDBOP.GetWhere(KeyColumnName, KeyValue); return(this); }
/// <summary> /// get data by filter /// 得到指定条件的表中所有数据 /// </summary> /// <param name="ColumnName">筛选字段名 Filed</param> /// <param name="Value">筛选值 Filter value</param> /// <returns></returns> public MongoGetData Where(String[] ColumnName, Object[] Value) { if (ColumnName.Length != Value.Length) { throw new Exception("Column number not Equals Value number"); } filterDefinition = MongoDBOP.GetWhere(ColumnName, Value); return(this); }
/// <summary> /// delete data by many key value /// 删除多个指定条件数据 /// </summary> /// <param name="KeyColumnName"></param> /// <param name="KeyValue"></param> /// <returns></returns> public MongoDeleteData Where(string[] KeyColumnName, CommandComparison[] comparison, object[] KeyValue, WhereRelation[] relation) { if (KeyColumnName.Length != KeyValue.Length) { throw new Exception("Column number not Equals Value number"); } filterDefinition = MongoDBOP.GetWhere(KeyColumnName, KeyValue, comparison, relation); 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> /// get data by filter /// 得到指定条件的表中所有数据 /// </summary> /// <param name="ColumnName">筛选字段名 Filed</param> /// <param name="Comparison">筛选条件 Filter where</param> /// <param name="Value">筛选值 Filter value</param> /// <param name="relation">筛选关系 relation</param> /// <returns></returns> public MongoGetData Where(String[] ColumnName, CommandComparison[] Comparison, Object[] Value, WhereRelation[] relation) { if (ColumnName.Length != Value.Length && ColumnName.Length != Comparison.Length && ColumnName.Length != relation.Length) { throw new Exception("Column number not Equals Value number"); } filterDefinition = MongoDBOP.GetWhere(ColumnName, Value, Comparison, relation); return(this); }
/// <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); }
/// <summary> /// insert new data /// 插入新数据 /// </summary> public String ExecuteCommand(String KeyColumnName, String GUIDValue) { //数据库连接 if (_connectionConfig.IsAutoCloseConnection == false) { if (_database.CheckStatus() == false) { throw new Exception("databse connect not open"); } } if (_connectionConfig.IsAutoCloseConnection == true) { _database.Open(); } String s = _database.InsertData(_databasename, _TableName, MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(MongoDBOP.HashtableToJson(htData)) , KeyColumnName, GUIDValue); if (_connectionConfig.IsAutoCloseConnection == true) { _database.Close(); } return(s); }
/// <summary> /// insert new data /// 插入新数据 /// </summary> public void ExecuteCommand() { //数据库连接 if (_connectionConfig.IsAutoCloseConnection == false) { if (_database.CheckStatus() == false) { throw new Exception("databse connect not open"); } } if (_connectionConfig.IsAutoCloseConnection == true) { _database.Open(); } _database.InsertData(_databasename, _TableName, MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(MongoDBOP.HashtableToJson(htData))); if (_connectionConfig.IsAutoCloseConnection == true) { _database.Close(); } return; }
/// <summary> /// insert many new data /// 插入多个新数据 /// </summary> /// <param name="ht"></param> public void ExecuteCommand(List <Hashtable> ht) { if (ht.Count == 0) { throw new Exception("Column number not Equals Value number"); } BsonDocument[] document = new BsonDocument[ht.Count]; for (int i = 0; i < ht.Count; i++) { document[i] = MongoDB.Bson.Serialization.BsonSerializer.Deserialize <BsonDocument>(MongoDBOP.HashtableToJson(ht[i])); } //数据库连接 if (_connectionConfig.IsAutoCloseConnection == false) { if (_database.CheckStatus() == false) { throw new Exception("databse connect not open"); } } if (_connectionConfig.IsAutoCloseConnection == true) { _database.Open(); } _database.InsertData(_databasename, _TableName, document); if (_connectionConfig.IsAutoCloseConnection == true) { _database.Close(); } return; }