public ArrayList find(string db, string collection, int skip, int limit, int batch_size, Hashtable json_query, Hashtable json_fields)
{
var _db = _mongoserver.GetDatabase(db);
var _collection = _db.GetCollection <MongoDB.Bson.BsonDocument>(collection) as MongoDB.Driver.MongoCollection <MongoDB.Bson.BsonDocument>;
MongoDB.Driver.QueryDocument _query = new MongoDB.Driver.QueryDocument(json_query);
MongoDB.Driver.MongoCursor <MongoDB.Bson.BsonDocument> c = null;
if (json_fields != null)
{
MongoDB.Driver.FieldsDocument _fields = new MongoDB.Driver.FieldsDocument(json_fields);
c = _collection.FindAs <MongoDB.Bson.BsonDocument>(_query).SetSkip(skip).SetLimit(limit).SetBatchSize(batch_size).SetFields(_fields);
}
else
{
c = _collection.FindAs <MongoDB.Bson.BsonDocument>(_query).SetSkip(skip).SetLimit(limit).SetBatchSize(batch_size);
}
ArrayList _list = new ArrayList();
foreach (var data in c)
{
var _data = data.ToHashtable();
_data.Remove("_id");
_list.Add(_data);
}
return(_list);
}
public bool remove(Hashtable json_query)
{
MongoDB.Driver.QueryDocument _query = new MongoDB.Driver.QueryDocument(json_query);
_collection.Remove(_query);
return(true);
}
/// <summary>
/// 根据ObjectID 查询
/// </summary>
public BsonDocument LogSelectOne(string objId)
{
BsonDocument docFind = new BsonDocument();
MongoDB.Driver.MongoServer server = MongoDB.Driver.MongoServer.Create(ConfigurationManager.AppSettings["mongoDBConfig"]);
server.Connect();
//获取指定数据库
MongoDB.Driver.MongoDatabase db = server.GetDatabase(ConfigurationManager.AppSettings["mongoDBName"].ToString());
//获取表
MongoDB.Driver.MongoCollection <BsonDocument> col = db.GetCollection <BsonDocument>(ConfigurationManager.AppSettings["mongoDBCollection"].ToString());
try
{
var query = new MongoDB.Driver.QueryDocument("_id", new ObjectId(objId));
docFind = col.FindOne(query);
}
catch (Exception ex)
{
log.Error(ex.ToString());
}
finally
{
server.Disconnect();
}
return(docFind);
}
/// <summary>
/// 根据ObjectID 查询
/// </summary>
public BsonDocument LogSelectOne(string objId)
{
BsonDocument docFind = new BsonDocument();
MongoDB.Driver.MongoServer server = MongoDB.Driver.MongoServer.Create(ConfigurationManager.AppSettings["mongoDBConfig"]);
server.Connect();
//获取指定数据库
MongoDB.Driver.MongoDatabase db = server.GetDatabase(ConfigurationManager.AppSettings["mongoDBName"].ToString());
string appid = string.Empty;
if (!string.IsNullOrEmpty(txtAppid.Text.Trim()))
{
appid = txtAppid.Text.Trim().Split(' ')[0];
}
//获取表
MongoDB.Driver.MongoCollection <BsonDocument> col = db.GetCollection <BsonDocument>(appid + "logs");
try
{
var query = new MongoDB.Driver.QueryDocument("_id", new ObjectId(objId));
docFind = col.FindOne(query);
}
catch (Exception ex)
{
log.Error(ex.ToString());
}
finally
{
server.Disconnect();
}
return(docFind);
}
public bool update(Hashtable json_query, Hashtable json_update)
{
MongoDB.Driver.QueryDocument _query = new MongoDB.Driver.QueryDocument(json_query);
MongoDB.Driver.UpdateDocument _update = new MongoDB.Driver.UpdateDocument(json_update);
var ret = _collection.Update(_query, _update);
return(true);
}
public bool remove(string db, string collection, Hashtable json_query)
{
var _db = _mongoserver.GetDatabase(db);
var _collection = _db.GetCollection <MongoDB.Bson.BsonDocument>(collection) as MongoDB.Driver.MongoCollection <MongoDB.Bson.BsonDocument>;
MongoDB.Driver.QueryDocument _query = new MongoDB.Driver.QueryDocument(json_query);
_collection.Remove(_query);
return(true);
}
public bool update(string db, string collection, Hashtable json_query, Hashtable json_update)
{
var _db = _mongoserver.GetDatabase(db);
var _collection = _db.GetCollection <MongoDB.Bson.BsonDocument>(collection) as MongoDB.Driver.MongoCollection <MongoDB.Bson.BsonDocument>;
MongoDB.Driver.QueryDocument _query = new MongoDB.Driver.QueryDocument(json_query);
MongoDB.Driver.UpdateDocument _update = new MongoDB.Driver.UpdateDocument(json_update);
var ret = _collection.Update(_query, _update);
return(true);
}
public bool remove(string db, string collection, Hashtable json_query)
{
var _db = _mongoserver.GetDatabase(db);
var _collection = _db.GetCollection <MongoDB.Bson.BsonDocument>(collection) as MongoDB.Driver.MongoCollection <MongoDB.Bson.BsonDocument>;
MongoDB.Driver.QueryDocument _query = new MongoDB.Driver.QueryDocument(json_query);
var ret = _collection.Remove(_query);
if (ret != null && ret.HasLastErrorMessage)
{
log.log.operation(new System.Diagnostics.StackFrame(), service.timerservice.Tick, ret.LastErrorMessage);
}
return(true);
}
public ArrayList find(int skip, int limit, int batch_size, Hashtable json_query, Hashtable json_fields)
{
MongoDB.Driver.QueryDocument _query = new MongoDB.Driver.QueryDocument(json_query);
MongoDB.Driver.FieldsDocument _fields = new MongoDB.Driver.FieldsDocument(json_fields);
var c = _collection.FindAs <MongoDB.Bson.BsonDocument>(_query).SetSkip(skip).SetLimit(limit).SetBatchSize(batch_size).SetFields(_fields);
ArrayList _list = new ArrayList();
foreach (var data in c)
{
_list.Add(data.ToHashtable());
}
return(_list);
}
