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));
}
