MongoDB 多条件查询实现(C#)

        dataAccessMongo dam = new dataAccessMongo();

        MongoCollection coll = dam.Open();

        //QueryDocument query = new QueryDocument();

        //var query = Query.EQ("destination_number", destination_number);

        List<IMongoQuery> list = new List<IMongoQuery>();

        if (source_number != "") list.Add(Query.EQ("source_number", source_number));

        if (destination_number != "") list.Add(Query.EQ("destination_number", destination_number));

        if (talk_datetime1 != "") list.Add(Query.GTE("talk_datetime", DateTime.Parse(talk_datetime1).AddHours(8)));

        if (talk_datetime2 != "") list.Add(Query.LTE("talk_datetime", DateTime.Parse(talk_datetime2).AddHours(8)));

        if (talk_second != "") list.Add(Query.GTE("talk_second", int.Parse(talk_second)));

        if (department != "") list.Add(Query.Matches("department", department));

        var query = Query.And(list);

        //if (source_number != "") query.Add("source_number", source_number);

        //if (destination_number != "") query.Add("destination_number", destination_number);

        ////通话时间

        //if (talk_datetime1 != "" || talk_datetime2 != "")

        //{

        //    BsonDocument bsonTalkTime = new BsonDocument();

        //    if (talk_datetime1 != "") bsonTalkTime.Add("$gte", DateTime.Parse(talk_datetime1).AddHours(8));

        //    if (talk_datetime2 != "") bsonTalkTime.Add("$lte", DateTime.Parse(talk_datetime2).AddHours(8));

        //    query.Add("talk_datetime", bsonTalkTime);

        //}

        ////时长

        //if (talk_second != "")

        //{

        //    BsonDocument bsonTalkSecond = new BsonDocument();

        //    bsonTalkSecond.Add("$gte", int.Parse(talk_second));

        //    query.Add("talk_second", bsonTalkSecond);

        //}

        //if(department != "")

        //    query.Add("department",  new BsonRegularExpression(new Regex("/.*"+department+".*/")));

        

        int i = 0;

        string sHTML = "";

        foreach (BsonDocument bDocQuery in coll.FindAs<BsonDocument>(query))

        {

            sHTML += "<tr class='item_out_1' style='height:18px;' onmousemove='this.className=\"item_over\";' onmouseout='this.className=\"item_out_1\";'>";

            if(bDocQuery.Contains("transfer_serial") && bDocQuery["transfer_serial"].ToString() == "87833522")

                sHTML += "<td class='item1'>呼出</td>";

            else

                sHTML += "<td class='item1'>呼入</td>";

            //sHTML += "<td class='item2'><a href='SsgCRM_GetTelephoneRecord.aspx?id=" + bDocQuery["_id"].ToString() + "' target='_blank' title='听录音'>" + bDocQuery["source_number"].ToString() + "</a></td>";

            sHTML += "<td class='item2'><a href='PHONE://" + bDocQuery["_id"].ToString() + "' target='_top' title='听录音'>播放</a>   " + bDocQuery["source_number"].ToString() + "</td>";

            sHTML += "<td class='item2'>" + bDocQuery["destination_number"].ToString() + "</td>";

            sHTML += "<td class='item2'>" + bDocQuery["talk_datetime"].ToString() + "</td>";

            sHTML += "<td class='item2'>" + bDocQuery["talk_second"].ToString() + "</td>";

            if (bDocQuery.Contains("department"))

                sHTML += "<td class='item2'>" + bDocQuery["department"].ToString() + "</td>";

            else

                sHTML += "<td class='item2'>&nbsp</td>";

            sHTML += "<td class='item2'><a href='saveg729://" + bDocQuery["_id"].ToString() + "' target='_top' title='下载g729格式音频文件'>g729</a>" +

                "   <a href='savewav://" + bDocQuery["_id"].ToString() + "' target='_top' title='下载wav格式音频文件'>wav</a></td>";

            sHTML += "</tr>";

            i++;

        }

        dam.Close();