Mongo C# 操作（元素 数组 ）

最新推荐文章于 2023-07-23 19:01:28 发布
最新推荐文章于 2023-07-23 19:01:28 发布
阅读量3.4k 收藏
点赞数
分类专栏： C#mongo mongo MongoServer
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/nicepainkiller/article/details/50894469
版权
C#mongo 同时被 3 个专栏收录
2 篇文章 0 订阅
订阅专栏
mongo
2 篇文章 0 订阅
订阅专栏
MongoServer
1 篇文章 0 订阅
订阅专栏

先看下我的Bson结构：

{
  "_id" : ObjectId("56e2642e6f29584fa01d02be"),
  "deviceId" : "25a3928850c31fffbb470fb18d082c42191d9eb3",
  "avatarName" : "CCC",
  "avatarIndex" : 2,
  "avatarLevel" : 1,
  "avatarCreateTime" : "2016/3/11 14:22:38",
  "economy" : {
    "glod" : -2236
  },
  "friend" : [["Q1Q"], ["23EE#"]],
  "message" : {
    "QQQ" : [{
        "content" : "你大爷的?",
        "sendTime" : ISODate("2016-03-15T02:23:27.743Z")
      }, {
        "content" : "你大爷的?",
        "sendTime" : ISODate("2016-03-15T02:23:32.706Z")
      }]
  }
}

具体操作如下，

    

        #region //设备登录信息
        /// <summary>
        /// 设备登录服务器  插入时间
        /// </summary>
        /// <param name="deviceId">设备ID</param>
        /// <param name="devicename">设备类型</param>
        /// <returns></returns>
        public bool DeviceLogin(string deviceId, string devicename)
        {

            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            try
            {

                IMongoQuery device = Query.EQ("deviceID", deviceId); 
                BsonDocument bson = mongoCollection.FindOne(device);
                if (bson == null)
                {
                    BsonArray loginDetail = new BsonArray { DateTime.Now.ToString() };
                    BsonDocument doc = new BsonDocument();
                    doc.Add("deviceID", deviceId);
                    doc.Add("deviceType", devicename);
                    doc.Add("registerTime", DateTime.Now.ToString());
                    doc.Add("LoginCount", 1);
                    doc.Add("loginDetail", loginDetail);

                    Console.WriteLine("{0}: 创建设备账号! 设备ID :{1},  机型 :{2} ", collectionName, deviceId, devicename);
                    return mongoCollection.Insert(doc).Ok;
                }
                else
                {
                    IMongoQuery query = Query.EQ("deviceID", deviceId);
                    UpdateDocument update = new UpdateDocument { { "$inc",  new QueryDocument{ {"LoginCount", 1 } } },
                                                                 { "$addToSet", new QueryDocument{  { "loginDetail", DateTime.Now.ToString() } } }
                                                                 };
                    Console.WriteLine("{0}: 登录设备账号! 设备ID :{1},  机型 :{2} ", collectionName, deviceId, devicename);
                    return mongoCollection.Update(query, update).Ok;

                }
            }
            catch (Exception e)
            {
                stateMessage = e.ToString();
                Console.WriteLine("数据库操作错误！ 集合名称{0}", collectionName);
                Console.WriteLine( stateMessage );
                return false;
            }

        }

        /// <summary>
        /// 设置玩家等级
        /// </summary>
        /// <param name="avatarName"></param>
        /// <param name="level"></param>
        /// <returns></returns>
        public bool UpdateAvatarLevel(string avatarName, int level)
        {
            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            try
            {
                IMongoQuery query = Query.EQ("avatarName", avatarName);
                UpdateDocument update = new UpdateDocument { { "$inc", new QueryDocument { { "avatarLevel", level } } } };
                if (mongoCollection.Update(query, update).Ok)
                {
                    Console.WriteLine("{0}角色：{1},设置角色等级成功 ", collectionName, avatarName);
                    return true;
                }
                else
                {
                    Console.WriteLine("{0}角色：{1},设置角色等级失败 ", collectionName, avatarName);
                    return false;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine("{0}角色：{1},设置角色等级异常, ErrorMessage:{3} ", collectionName, avatarName, e.ToString());
                stateMessage = e.ToString();
            }
            return false;

        }
        #endregion

        #region//玩家具体信息
        /// <summary>
        /// 创建玩家角色
        /// </summary>
        /// <param name="deviceId">设备ID</param>
        /// <param name="avatarName">角色昵称</param>
        /// <param name="avatarIndex">角色ID</param>
        /// <param name="avatrLevel">角色等级</param>
        /// <returns></returns>
        public bool CreateAvatr(string deviceId, string avatarName, byte avatarIndex, short avatrLevel)
        {

            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            try
            {
                IMongoQuery device = Query.EQ("avatarName", avatarName);
                BsonDocument bson = mongoCollection.FindOne(device);
                if (bson == null)
                {
                    BsonDocument doc = new BsonDocument();
                    doc.Add("deviceId", deviceId);
                    doc.Add("avatarName", avatarName);
                    doc.Add("avatarIndex", avatarIndex);
                    doc.Add("avatarLevel", avatrLevel);
                    doc.Add("avatarCreateTime", DateTime.Now.ToString());
                    Console.WriteLine("{0}:设备：{1},创建角色：昵称:{2},索引:{3},等级:{4} ", collectionName, deviceId, avatarName, avatarIndex, avatrLevel);
                    return mongoCollection.Insert(doc).Ok;
                }
                else
                {
                    Console.WriteLine("{0}:设备：{1},创建角色失败：昵称:{2},索引:{3},等级:{4}, ErrorMessage:{5} ", collectionName, deviceId, avatarName, avatarIndex, avatrLevel, "昵称已经存在");
                    stateMessage = "昵称已经存在";
                    return false;
                }

            }
            catch (Exception e)
            {
                Console.WriteLine("{0}:设备：{1},创建角色异常：昵称:{2},索引:{3},等级:{4}, ErrorMessage:{5} ", collectionName, deviceId, avatarName, avatarIndex, avatrLevel, e.ToString());
                stateMessage = e.ToString();
                return false;
            }

        }

        // <summary>
        // 返回角色列表
        // </summary>
        // <param name="deviceId"></param>
        // <returns></returns>
        public List<Avatars> GetAvatarList(string deviceId)
        {
 
            List<Avatars> avatarlist = new List<Avatars>();
            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);

            try
            {
                IMongoQuery query = Query.EQ("deviceId", deviceId);
                FieldsDocument fddoc = new FieldsDocument();
                fddoc.Add("avatarName", 1);
                fddoc.Add("avatarIndex", 1);
                fddoc.Add("avatarLevel", 1);
                MongoCursor<BsonDocument> doc = mongoCollection.Find(query).SetFields(fddoc);

                foreach (BsonDocument bs in doc)
                {
                    Avatars avatar = new Avatars();
                    if (bs.Contains("avatarName"))
                        avatar.avatarName = (string)bs["avatarName"];
                    if (bs.Contains("avatarIndex"))
                        avatar.avatarIndex = (Byte)bs["avatarIndex"];
                    if (bs.Contains("avatarLevel"))
                        avatar.avatarLevel = (short)bs["avatarLevel"];
                    avatarlist.Add(avatar);
                }
                Console.WriteLine("{0}设备：{1},返回角色列表, 角色个数{2} ", collectionName, deviceId, avatarlist.Count);

            }
            catch (Exception e)
            {
                Console.WriteLine("{0}设备：{1},返回角色列表异常, ErrorMessage:{3} ", collectionName, deviceId, e.ToString());
                stateMessage = e.ToString();
            }

            return avatarlist;
        }

        #endregion

        #region //角色任务

        /// <summary>
        /// 获取玩家的任务
        /// </summary>
        /// <param name="avatarName"></param>
        /// <returns></returns>
        public List<TaskDetail> GetAvatarTask(string avatarName)
        {

            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            List<TaskDetail> taskDetail = new List<TaskDetail>();
            try
            {
                //IMongoQuery query = Query.EQ("avatarName", avatarName);
                IMongoQuery query = Query.And(Query.EQ("avatarName", avatarName), Query.Exists("task"));
                BsonArray bson = mongoCollection.FindOne(query)["task"].AsBsonArray;
                if ( bson != null)
                {
                    foreach (BsonDocument bdoc in bson)
                    {
                        TaskDetail task = new TaskDetail();
                        if (bdoc.Contains("taskType"))
                            task.taskType = ((Byte)bdoc["taskType"]);
                        if (bdoc.Contains("taskID"))
                            task.taskID = (Byte)bdoc["taskID"];
                        if (bdoc.Contains("taskState"))
                            task.taskState = ((Byte)bdoc["taskState"]);
                        if (bdoc.Contains("lastTime"))
                            task.lastTime = bdoc["lastTime"].AsDateTime;
                        taskDetail.Add(task);
                    }

                }

                Console.WriteLine("{0}角色：{1},返回角色任务列表，个数为{2} ", collectionName, avatarName, taskDetail.Count);

            }
            catch (Exception e)
            {
                //Console.WriteLine("{0}角色：{1},返回角色任务列表异常, ErrorMessage:{3} ", collectionName, avatarName, e.ToString());
                stateMessage = e.ToString();
                Console.WriteLine( stateMessage );
            }
            return taskDetail;

        }
        /// <summary>
        /// 删除一个角色
        /// </summary>
        /// <param name="avatartName"></param>
        /// <returns></returns>
        public bool RemoveAvatar(string avatartName)
        {
            List<Avatars> avatarlist = new List<Avatars>();
            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);

            try
            {
                IMongoQuery query = Query.EQ("avatarName", avatartName);
                if (mongoCollection.Remove(query).Ok)
                {
                    Console.WriteLine("{0}设备：{1},删除角色列表成功 ", collectionName, avatartName);
                    return true;
                }
                else
                {
                    Console.WriteLine("{0}设备：{1},删除角色列表失败 ", collectionName, avatartName);
                    return false;
                }
            }
            catch (Exception e)
            {
                 Console.WriteLine("{0}设备：{1},删除角色列表异常, ErrorMessage:{3} ", collectionName, avatartName, e.ToString());
                stateMessage = e.ToString();
                return false;
            }

        }

        public bool SetAvatarTask(string avatarName, TaskDetail task)
        {

            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);

            try
            {
                BsonDocument doc = new BsonDocument();
                doc.Add("taskID",    task.taskID);
                doc.Add("taskType",  task.taskType);
                doc.Add("taskState", task.taskState);
                doc.Add("lastTime",  task.lastTime);
 
                IMongoQuery query = Query.EQ("avatarName", avatarName);
                UpdateDocument update = new UpdateDocument { { "$addToSet", new QueryDocument { { "task", doc } } } };

                Console.WriteLine("{0}: 设置任务成功! 角色名称 avatarName：{1} 任务类型 task.taskType：{2} ", collectionName, avatarName, task.taskType);
                return mongoCollection.Update(query, update).Ok;

            }
            catch (Exception e)
            {
                stateMessage = e.ToString();
                Console.WriteLine("数据库操作错误！ 集合名称{0}", collectionName);
                return false;
            }

        }

        public bool UpdateAvatarTask(string avatarName, TaskDetail task)
        {

            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            //mongoServer.RequestStart( mongoDatabase );
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);

            try
            {
                BsonDocument doc = new BsonDocument();
                doc.Add("taskID", task.taskID);
                doc.Add("taskType", task.taskType);
                doc.Add("taskState", task.taskState);
                doc.Add("lastTime", task.lastTime);

                //IMongoQuery query =  Query.EQ( "avatarName", avatarName );
                IMongoQuery query = Query.And( Query.EQ("avatarName", avatarName), Query.EQ("task.taskID", task.taskID ));
                QueryDocument queryDoc = new QueryDocument { { "avatarName", avatarName }, { "task.taskID", task.taskID } };

                //UpdateDocument update = new UpdateDocument { { "$set",  new QueryDocument { {  "task.$.taskState", task.taskState  } } },
                                                              
                //                                            };
                //UpdateDocument update = new UpdateDocument { { "$set",  new QueryDocument { {  "task.$.taskType", task.taskType  } } },
                //                                                        new QueryDocument { {  "task.$.taskState", task.taskState  } } ,
                //                                                        new QueryDocument { {  "task.$.lastTime",  task.lastTime  } } ,
                // 

                UpdateDocument updates = new UpdateDocument();
                updates.Add("task.$.taskType",  task.taskType);
                updates.Add("task.$.taskState", task.taskState);
                updates.Add("task.$.lastTime",  task.lastTime);

                UpdateDocument update = new UpdateDocument { { "$set", updates }};
               
               // mongoServer.RequestDone();
                if (mongoCollection.Update(query, update).Ok)
                {
                    Console.WriteLine("{0}: 设置任务成功!  任务类型 task.taskType：{1} ", collectionName, task.taskType);
                    return true ;
                }
                else
                {
                    Console.WriteLine("{0}: 设置任务失败!  任务类型 task.taskType：{1} ", collectionName, task.taskType);
                    return true;
                }
               

            }
            catch (Exception e)
            {
                stateMessage = e.ToString();
                Console.WriteLine("数据库操作错误！ 集合名称{0}", collectionName);
                Console.WriteLine(stateMessage);
               // mongoServer.RequestDone();
                return false;
            }

           

        }

        #endregion

        #region//经济系统
        /// <summary>
        /// 获取经济系统数据
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        public Economy GetEconomy(string avatarName)
        {

            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            Economy economy = new Economy();

            try
            {
                IMongoQuery query = Query.And(Query.EQ("avatarName", avatarName), Query.Exists("economy"));
                BsonDocument doc = mongoCollection.FindOne(query)["economy"].AsBsonDocument;

                if (doc != null)
                {
                    if (doc.Contains("glod"))
                        economy.glod = (int)doc["glod"].AsInt32;
                    if (doc.Contains("glodTotal"))
                        economy.glodTotal = (int)doc["glodTotal"].AsInt32;
                    if (doc.Contains("silver"))
                        economy.silver = (int)doc["silver"].AsInt32;
                    if (doc.Contains("silverTotal"))
                        economy.silverTotal = (int)doc["silverTotal"].AsInt32;
                    return economy; 
                }

               Console.WriteLine("{0}角色：{1},返回经济系统 ", collectionName, avatarName);

            }
            catch (Exception e)
            {
                //
                stateMessage = e.ToString();
                Console.WriteLine("{0}角色：{1},返回经济系统异常, ErrorMessage:{3} ", collectionName, avatarName, stateMessage);
            }
            return null;
        }


        /// <summary>
        /// 设置经济系统数据
        /// </summary>
        /// <param name="name"></param>
        /// <param name="economy"></param>
        /// <returns></returns>
        public bool SetEconomy(string avatarName, Economy economy)
        {
            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);

            try
            {
                BsonDocument doc = new BsonDocument();
                doc.Add("glod", economy.glod);
                doc.Add("glodTotal", economy.glodTotal);
                doc.Add("silver", economy.silver);
                doc.Add("silverTotal", economy.silverTotal);

                IMongoQuery query = Query.EQ("avatarName", avatarName);
                UpdateDocument update = new UpdateDocument { { "$set", new QueryDocument { { "economy", doc } } } };
         
                if ( mongoCollection.Update(query, update).Ok  )
                {
                  Console.WriteLine("{0}角色：{1},设置经济系统成功 ", collectionName, avatarName);
                  return true;
                }else
                {
                  Console.WriteLine("{0}角色：{1},设置经济系统失败 ", collectionName, avatarName);
                  return false;
                }
                 

            }
            catch (Exception e)
            {
                Console.WriteLine("{0}角色：{1},返回经济系统异常, ErrorMessage:{3} ", collectionName, avatarName, e.ToString());
                stateMessage = e.ToString();
                return false;
            }

           
        }

        /// <summary>
        /// 消耗充值金币
        /// </summary>
        /// <param name="avatarName"></param>
        /// <param name="count"></param>
        /// <returns></returns>
        public bool ExpendEconomy( string avatarName, int count )
        {

            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            try
            {

                IMongoQuery query = Query.EQ("avatarName", avatarName);
                BsonDocument doc = new BsonDocument();
                doc.Add();
                UpdateDocument update = new UpdateDocument { { "$inc", new QueryDocument { { "economy.glod", count } } } };
                if (mongoCollection.Update(query, update).Ok)
                {
                    Console.WriteLine("{0}角色：{1},设置经济系统成功 ", collectionName, avatarName);
                    return true;
                }
                else 
                {
                    Console.WriteLine("{0}角色：{1},设置经济系统失败 ", collectionName, avatarName);
                    return false;
                }
            }
            catch (Exception e)
            {
                Console.WriteLine("{0}角色：{1},返回经济系统异常, ErrorMessage:{3} ", collectionName, avatarName, e.ToString());
                stateMessage = e.ToString();
            }
            return false;
        }

        #endregion

        #region//好友系统

        /// <summary>
        /// 获取好友列表
        /// </summary>
        /// <param name="avatarName">获取好友列表</param>
        /// <returns>玩家数组</returns>
        public string[] GetFriendList(string avatarName)
        {
            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            List<string> friend = new List<string>();
            try
            {
                IMongoQuery query = Query.And(Query.EQ("avatarName", avatarName), Query.Exists("friend"));
                BsonArray doc = mongoCollection.FindOne(query)["friend"].AsBsonArray;
                Console.WriteLine( doc.Count );

                if (doc != null)
                {
                    string[] friendName = new string[doc.Count];
                    for (int i = 0; i < doc.Count; i ++ )
                    {
                        friendName[i] = doc[i].ToString();
                    }
                    return friendName;
                }
                return null;

            }
            catch (Exception e)
            {
                //
                stateMessage = e.ToString();
                //Console.WriteLine("{0}角色：{1},返回经济系统异常, ErrorMessage:{3} ", collectionName, avatarName, stateMessage);
            }
            return null;
        }
        /// <summary>
        /// 添加好友
        /// </summary>
        /// <param name="friend"></param>
        /// <param name="avatarName"></param>
        /// <returns></returns>
        public bool AddFriend(string friend, string avatarName)
        {
            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            try
            {
                IMongoQuery query = Query.EQ("avatarName", avatarName) ;
                BsonArray friendArray = new BsonArray();
                friendArray.Add( friend );
                UpdateDocument update = new UpdateDocument { { "$addToSet", new QueryDocument { { "friend", friendArray } } } };

                if (mongoCollection.Update(query, update).Ok)
                {
                    Console.WriteLine("{0}角色：{1},添加好友成功 ", collectionName, avatarName);
                    return true;
                }
                else
                {
                    Console.WriteLine("{0}角色：{1},添加好友失败 ", collectionName, avatarName);
                    return false;
                }

            }
            catch (Exception e)
            {
                stateMessage = e.ToString();
                Console.WriteLine("{0}角色：{1},添加好友异常, ErrorMessage:{3} ", collectionName, avatarName, stateMessage);
            }
            return false;
        }

        /// <summary>
        /// 删除好友
        /// </summary>
        /// <param name="friendName"></param>
        /// <param name="tagName"></param>
        /// <returns></returns>
        public bool RemoveFriend(string friend, string avatarName)
        {
            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            try
            {
                IMongoQuery query = Query.And(Query.EQ("avatarName", avatarName), Query.Exists("friend"));
                BsonArray friendArray = new BsonArray();
                friendArray.Add(friend);
                UpdateDocument update = new UpdateDocument { { "$pull", new QueryDocument { { "friend", friendArray } } } };

                if (mongoCollection.Update(query, update).Ok)
                {
                    Console.WriteLine("{0}角色：{1},删除好友成功 ", collectionName, avatarName);
                    return true;
                }
                else
                {
                    Console.WriteLine("{0}角色：{1},删除好友失败 ", collectionName, avatarName);
                    return false;
                }

            }
            catch (Exception e)
            {
                stateMessage = e.ToString();
                Console.WriteLine("{0}角色：{1},删除好友异常, ErrorMessage:{3} ", collectionName, avatarName, stateMessage);
            }
            return false;
        }

        #endregion

        #region//离线消息
        /// <summary>
        /// 获取玩家离线消息 并且清空消息队列
        /// </summary>
        /// <param name="avatarName"></param>
        /// <returns></returns>
        public Dictionary<string, List<Message>> GetOffLineMessage(string avatarName)
        {
            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            Dictionary<string, List<Message>> msgDict = new Dictionary<string, List<Message>>();
            
            try
            {
                IMongoQuery query = Query.And(Query.EQ("avatarName", avatarName), Query.Exists("message"));
                BsonDocument bson = mongoCollection.FindOne(query)["message"].AsBsonDocument;
                if (bson != null)
                {
                    var bEle = bson.Elements;
                    //List<BsonElement> bElea = (List<BsonElement>) bson.Elements;
                    Console.WriteLine(bEle.GetType());
                    foreach (BsonElement bdoc in bEle)
                    {
                        string msgName = bdoc.Name;
                        BsonArray doc = bdoc.ToBsonDocument()["Value"].AsBsonArray;
                        List<Message> msgList = new List<Message>();
                        foreach (BsonDocument docs in doc)
                        {
                            Message msg = new Message();
                            msg.from = msgName;
                            if (docs.Contains("content"))
                                msg.content = docs["content"].ToString();
                            if (docs.Contains("sendTime"))
                                msg.sendTime = docs["sendTime"].AsDateTime;
                            msgList.Add(msg);
                        }

                        msgDict.Add(msgName, msgList);
                    }

                    UpdateDocument update = new UpdateDocument { { "$unset", new QueryDocument{ {"message", ""} } } };
                    mongoCollection.Update(query, update);
                    return msgDict;

                }
                else
                {
                    return null;
                }
            }
            catch (Exception e)
            {
                stateMessage = e.ToString();
            }
            return null;
          
        }

        /// <summary>
        /// 添加好友离线消息
        /// </summary>
        /// <param name="message"></param>
        /// <returns></returns>
        public bool AddOffLineMessage(string avatarName, Message message)
        {

            MongoClient mongoClient = new MongoClient(connection);
            MongoServer mongoServer = mongoClient.GetServer();
            MongoDatabase mongoDatabase = mongoServer.GetDatabase(databaseName);
            MongoCollection<BsonDocument> mongoCollection = mongoDatabase.GetCollection(collectionName);
            try
            {
                IMongoQuery query = Query.EQ("avatarName", avatarName);
                BsonDocument doc = new BsonDocument();
                doc.Add("content",  message.content );
                doc.Add("sendTime", message.sendTime);
                UpdateDocument update = new UpdateDocument { { "$addToSet", new QueryDocument { { "message." + message.from, doc } } } };



                if (mongoCollection.Update(query, update).Ok)
                {
                    Console.WriteLine("{0}角色：{1},离线消息添加成功 ", collectionName, avatarName);
                    return true;
                }
                else
                {
                    Console.WriteLine("{0}角色：{1},离线消息添加失败 ", collectionName, avatarName);
                    return false;
                }

            }
            catch (Exception e)
            {
                stateMessage = e.ToString();
                Console.WriteLine("{0}角色：{1},添加离线消息添加异常, ErrorMessage:{3} ", collectionName, avatarName, stateMessage);
            }
            return false;
        }
        #endregion



 

nicepainkiller
关注
专栏目录
MongoDB 获取数组中匹配到的第一个元素对象
北辰
07-03 1161
MongoDB 获取数组中匹配到的第一个元素对象
c#读取csv到数组_使用C＃将CSV文件读入数组 - c#
weixin_39604276的博客
12-22 1199
我正在尝试创建一个将拉入，读取和分隔csv文件的代码。它有四列，没有标题。我一直在网上找几个小时，似乎没有人真正找到答案，所以我希望这里有人可以。读入后，由于它是设计的一部分，因此我需要能够将其拉得很特别。提前谢谢！参考方案您的问题有点含糊，但我会尽力回答。CSV文件是(按定义)是包含逗号分隔值的文件-此处的关键是使用逗号作为分隔符。就个人而言，我发现在解析时使用不同的定界符易于减少麻烦。我创建了...
MongoDB .Net Driver(C#驱动) - 内嵌数组/嵌入文档的操作(增加、删除、修改、查询(Linq 分页))
InCerry的博客
03-16 2878
MongoDB .Net Driver(C#驱动) - 内嵌数组/嵌入文档的操作(增加、删除、修改、查询(Linq 分页)) 本教程是入门基础教程，主要是笔者在项目中使用MongoDB .Net官方驱动对MongoDB内嵌文档的操作时遇到了很多不方便的情况，踩了很多的坑，所以单独整理出来一篇文章，来讲一讲笔者踩坑的过程。
C# mongodb中内嵌文档数组条件查询
weixin_33736048的博客
08-17 498
样例数据： {     "_id" : "1064621564857",     "cNo" : "1064621564857",     "exPCodes" : [        {            "pType" : NumberInt(1),             "cDate" : ISODate("2017-07-27T10:30:11.7
Mongodb 内嵌数组操作
Accept
11-19 8545
mongodb update 数组 操作 张映 发表于 2014-07-29 分类目录： nosql 标签：$, $addtoset, $each, $pop, $pull, $pullall, $slice, mongodb, position, sort, update 前一篇文章说到了mongodb update 的字符操作，下面说一下mongodb
【mongo】更新特定数组元素
微笑丶1998的博客
09-08 1056
示例集合 { id: 1, data: [{ pid: 1, value: 1 }, { pid: 2, value: 2 }] }, { id: 2, data: [{ pid: 1, value: 1 }, { pid: 3, value: 3 }] } 命令 db.xx.update({id: 1, 'data.pid': 1}, {$set: {'data.$.value': 5}}) 修改第一个文档中的{pid: 1,value: 1}为
MongoDb在C#中使用
lnc2003的专栏
12-22 546
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Runtime.Serialization; using System.Data; using System.Data.SqlClient; using MongoDB.Bson; using Mong
mongodb 实现对数组中对象属性值的修改
weixin_43840538的博客
06-14 6941
数据库的更删改查，作为前端仔，每次用到都是现查文档，顺便做个笔记。 参考官方文档https://docs.mongodb.com/manual/reference/operator/update/positional-all/#positional-update-all 首先顺便说一下改变数组的基本值的操作 一、更新数组中的所有元素 操作符：$[] { "_id" : 1, "grades" : [ 85, 82, 80 ] } { "_id" : 2, "grades" : [ 88, 90, 92
MongoDB原生语句更新嵌套数组的值
最新发布
北辰
07-23 1024
MongoDB原生语句更新嵌套数组的值
Mongodb 内嵌文档中数组属性的更新和插入
tricheur的博客
05-14 1108
Mongodb 内嵌文档中数组属性的更新和插入 网上资料找的头疼，自己看文档弄个demo，做个笔记总结一下吧。 1、引入对应依赖 <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-mongodb</artifactId> </dependency>
Kernys.Bson:适用于C＃的简单BSON编码器和解码器
05-14
克尔尼斯·伯森 适用于C＃的简单BSON编码器和解码器 只需将Kernys.Bson / SimpleBSON.cs复制到您的项目文件夹中即可。 并在“使用Kernys.Bson”部分下面进行检查！ 使用Kernys.Bson 编码非常简单！ var obj = new BSONObject (); obj [ " hello " ] = 123 ; obj [ " where " ] = new BSONObject (); obj [ " where " ][ " Korea " ] = " Asia " ; obj [ " where " ][ " USA " ] = " America " ; obj [ " bytes " ] = new byte [ 128 ]; byte [] buf = SimpleBSON . Dump ( obj ); Console . Wri
C# BSON 协议
07-22
C# BSON 传输协议库 WP7可用，.net 可用
MongoDB怎么用C#插入Bson复杂对象，如数组，布尔值等
qq_35901148的博客
12-20 933
话不多说直接上BsonDocument代码，至于怎么插入，不想解释,只举例两种类型，其它的自己类推： var document = new BsonDocument { {“id”, pd.id }, {“name”,pd.name}, {“acct”,pd.acct}, {“pass”,pd.pass}, {“lv”,pd.lv }, {“imgHeadUrl”,pd.imgHeadUrl },...
留一个C#版。操作MONgoDB对数组进行增删改查
HiYooa的专栏
01-23 5785
[HttpPost]         [ValidateInput(false)]         public ActionResult Add(Title model)         {             List Item = new List();             //生成俩选项并且添加             Item item = new Item();
使用C#对MongoDB中的数据进行查询，修改等操作
热门推荐
rrrrssss00的专栏
04-22 2万+
使用官方C#组件对MongoDB中的数据进行查询，修改等操作
window下安装mongoDB
wangxuewei111的专栏
02-27 608
mongoDB简介 MongoDB 是由C++语言编写的开源数据库系统。 在高负载的情况下，添加更多的节点，可以保证服务器性能。 MongoDB 旨在为WEB应用提供可扩展的高性能数据存储解决方案。 主要特点 MongoDB的提供了一个面向文档存储，操作起来比较简单和容易。你可以在MongoDB记录中设置任何属性的索引 (如：FirstName="Sameer
C# 操作MongoDB
AESCR的博客
05-10 178
1 安装MongoDB.Driver2 建立数据库连接 #mongodb://127.0.0.1:27017 MongoClient client = new MongoClient(“连接字符串”); 3 获取数据库 var database = client.GetDatabase("数据库"); 4 获取数据集 Collection #如果数据是预先定义好的可以在<输入数据的类型&...
MongoDB——更新操作（Update）c#实现
世界中心的专栏
12-15 1万+
c#实现 Mongodb存储文档局部更新】 如下： MongoDB更新包含对象数组的元素： 使用mongodb中数组元素的下标来做更新(update)多维数组 例如有如下数据结构： {   "_id":ObjectId("4b97e62bf1d8c7152c9ccb74"),   ”comments“：[     {     "by":"joe",     "v
mongotemplate修改数组某个元素
04-14
好的，关于mongotemplate修改数组某个元素的问题，我可以回答。在使用mongotemplate时，修改数组某个元素可以使用$set操作符和$指定索引的方式实现，示例如下： ``` Query query = new Query(Criteria.where("id").is(id)); Update update = new Update().set("arrayField.1", "new value"); mongoTemplate.updateFirst(query, update, "collectionName"); ``` 其中，arrayField表示数组字段名，1表示要修改的元素在数组中的索引，new value表示修改后的内容。需要注意的是，$set操作符只能修改指定位置的元素，不能新增或删除元素。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

nicepainkiller

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值