public ActionResult Index_Already(SeeAboutModel model, int pageid = 1) { List <IMongoQuery> queries = new List <IMongoQuery>(); //queries.Add(Query.NE("status", new BsonString("待审核"))); queries.Add(Query.Or(Query.EQ("status", new BsonString("审核通过")), Query.EQ("status", new BsonString("审核驳回")))); if (model != null) { if (!string.IsNullOrEmpty(model.civetno)) { queries.Add(Query.Or(Query.EQ("civetno", new BsonString(model.civetno)), Query.EQ("user_name", new BsonString(model.civetno)))); } if (!string.IsNullOrEmpty(model.serviceno_uid)) { queries.Add(Query.EQ("serviceno_uid", new BsonString(model.serviceno_uid))); } } else { model = new SeeAboutModel(); } ViewBag.SearchCondtion = model; var serachResult = mongoh.GetCollection <ModUApiPowerAplictionFind>().FindByAnd(queries) .MOrderByDescending(m => m._id).MToPagedList(pageid, 20); return(View(serachResult)); }
public ActionResult Detail(SeeAboutModel model, string code = "", int pageid = 1) { List <IMongoQuery> queries = new List <IMongoQuery>(); queries.Add(Query.EQ("interface_code", new BsonString(code))); if (model != null) { if (!string.IsNullOrEmpty(model.serviceno_uid)) { queries.Add(Query.EQ("serviceno_uid", new BsonString(model.serviceno_uid))); } if (!string.IsNullOrEmpty(model.visited_time)) { queries.Add(Query.GTE("visited_time", CUtil.CDate(model.visited_time))); } } else { model = new SeeAboutModel(); } ViewBag.seeAboutModel = model; ViewBag.Code = code; var serachResult = mongoh.GetCollection <ModUApiUseLogFind>().FindByAnd(queries) .MOrderByDescending(m => m.visited_time).MToPagedList(pageid, 10); return(View(serachResult)); }
// // GET: /DownCount/ public ActionResult Index(SeeAboutModel model, int pageid = 1) { List <IMongoQuery> queries = new List <IMongoQuery>(); queries.Add(Query.NE("", new BsonString(""))); if (model != null) { if (!string.IsNullOrEmpty(model.serviceno_uid)) { queries.Add(Query.EQ("serviceno_uid", new BsonString(model.serviceno_uid))); } if (!string.IsNullOrEmpty(model.visited_time)) { queries.Add(Query.GTE("visited_time", CUtil.CDate(model.visited_time))); } } else { model = new SeeAboutModel(); } ViewBag.SearchCondtion = model; var serachResult = mongoh.GetCollection <ModUApiUseLogFind>().FindByAnd(queries) .MOrderByDescending(m => m.visited_time).MToPagedList(pageid, 20); int totalCount = 0; int theMonth = 0; int thetoday = 0; string serviceno_uid_name = ""; if (!string.IsNullOrEmpty(model.serviceno_uid))//仅限于某个频道号的统计 { List <IMongoQuery> newqueries = new List <IMongoQuery>(); newqueries.Add(Query.EQ("serviceno_uid", new BsonString(model.serviceno_uid))); var newserachResult = mongoh.GetCollection <ModUApiUseLogFind>().FindByAnd(newqueries).ToList(); TimeCount(ref totalCount, ref theMonth, ref thetoday, newserachResult); serviceno_uid_name = model.serviceno_uid; } ViewBag.TotalCount = totalCount; ViewBag.TheMonth = theMonth; ViewBag.Thetoday = thetoday; ViewBag.ServicenoUidName = serviceno_uid_name; return(View(serachResult)); }
// // GET: /AccountManage/ public ActionResult Index(SeeAboutModel model, int pageid = 1) { List <IMongoQuery> queries = new List <IMongoQuery>(); queries.Add(Query.NE("", new BsonString(""))); if (model != null) { if (!string.IsNullOrEmpty(model.civetno)) { queries.Add(Query.Or(Query.EQ("_id", new BsonString(model.civetno)), Query.EQ("user_name", new BsonString(model.civetno)))); } } else { model = new SeeAboutModel(); } ViewBag.SearchCondtion = model; var serachResult = mongoh.GetCollection <ModUApiManager>().FindByAnd(queries) .MOrderByDescending(m => m.last_login_time).MToPagedList(pageid, 20); return(View(serachResult)); }
// // GET: /ChanncelPower/ public ActionResult Index(SeeAboutModel model, int pageid = 1) { List <IMongoQuery> queries = new List <IMongoQuery>(); queries.Add(Query.NE("", new BsonString(""))); //queries.Add(Query.EQ("status", new BsonString("待审核"))); if (model != null) { if (!string.IsNullOrEmpty(model.civetno)) { queries.Add(Query.Or(Query.EQ("civetno", new BsonString(model.civetno)), Query.EQ("user_name", new BsonString(model.civetno)))); } if (!string.IsNullOrEmpty(model.serviceno_uid)) { queries.Add(Query.EQ("_id", new BsonString(model.serviceno_uid))); } } else { model = new SeeAboutModel(); } ViewBag.SearchCondition = model; PagedList <ModChanncelList> result = mongoh.GetCollection <ModChanncelList>().FindByAnd(queries) .MOrderByDescending(m => m.start_date).MToPagedList(pageid, 20); if (result.Count != 0) { //获得本次显示的所有频道号 List <string> ids = new List <string>(); foreach (ModChanncelList item in result) { ids.Add(item._id); } #region 查询统计数据 BsonDocument match = new BsonDocument { { "$match", new BsonDocument { { "serviceno_uid", new BsonDocument("$in", new BsonArray(ids.ToArray())) } } } }; DateTime MonthlyFirstDate = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-01")); List <object> objarray = new List <object>(); objarray.Add("$visited_time"); objarray.Add(new BsonDateTime(MonthlyFirstDate)); BsonDocument group = new BsonDocument { { "$group", new BsonDocument { { "_id", "$serviceno_uid" }, { "MonthlyNum", new BsonDocument { { "$sum", new BsonDocument { { "$cond", new BsonDocument { { "if", new BsonDocument("$gte", new BsonArray(objarray.ToArray())) } , { "then", 1 } , { "else", 0 } } } } } } }, { "TotalNum", new BsonDocument { { "$sum", 1 } } } } } }; AggregateArgs args = new AggregateArgs(); args.Pipeline = new BsonDocument[] { match, group }; var statResult = mongoh.GetCollection <ModUApiUseLogFind>().Aggregate(args).ToList(); #endregion foreach (BsonDocument item in statResult) { string uid = item["_id"].AsString; int monthlyNum = item["MonthlyNum"].AsInt32; int totalNum = item["TotalNum"].AsInt32; ModChanncelList oneDate = (from m in result where m._id == uid select m).FirstOrDefault(); if (oneDate != null) { oneDate.MonthlyNum = monthlyNum; oneDate.TotalNum = totalNum; } } } return(View(result)); }