using MongoDB.Bson;
using MongoDB.Driver;
按指定用户名,指定日期查询数据
string username="lee";//定义用户名
string[] Dates = new string[] { "2020-03-05", "2020-03-02","2020-03-06"};//定义时间段,数量不限
List<FilterDefinition<Message>> filterlist = new List<FilterDefinition<Message>>();//Message是数据实体
foreach (string date in Dates)
{
filterlist.Add(builderFilter.And(builderFilter.Gte("AddTime", DateTime.Parse(date + " 00:00:00")), builderFilter.Lte("AddTime", DateTime.Parse(date + " 23:59:59"))));//查询一整天的数据,AddTime是数据插入时间字段
}
var filter = builderFilter.And(builderFilter.Eq("User", username),builderFilter.Or(filterlist));//时间段条件用OR拼在一起
var result= FindList(filter);//将条件传入查询方法查出结果(略)