C#MongDB数据库取某时间段内的数据

 BsonDocument bsonDoc = new BsonDocument();
            bsonDoc.Add("TimeData", new BsonDocument() { { "$gte", DateTimeToInt(StartTime) }, { "$lte", DateTimeToInt(EndTime) } });//StartTime,EndTime分别为起始时间和终止时间
            var collection = MoDataBase.GetCollection<BsonDocument>(string.Format("{0}_{1}_Day", StatioID, PullutionID));
            var sort = Builders<BsonDocument>.Sort.Ascending("TimeData");
            var list = collection.Find(bsonDoc).Sort(sort).ToList();
 /// <summary>
        /// 将取到的时间转为Int
        /// </summary>
        /// <param name="datetime"></param>
        /// <returns></returns>
        private static BsonInt64 DateTimeToInt(string datetime)
        {
            return BsonInt64.Create(System.DateTime.Parse(datetime).ToString("yyyyMMddHHmmss"));
        }

 

posted @ 2018-05-24 14:48  风轻云淡wjr  阅读(276)  评论(0编辑  收藏  举报