public aballresponse AbUsageAmount()
{
var ret = new aballresponse {
status = 0, values = new List <values>(), labels = new List <labels>()
};
try
{
using (var abdb = new mvc104.abm.studyinContext())
{
var ah = abdb.Request.Where(a => a.Method.Contains("InspectPostStudyStatus")).Select(b => b.Time).ToList();
var aaaaa = from one in ah
group one by one.ToString("yyyy-MM-dd") into onegroup
select new aaa
{
day = onegroup.Key, count = onegroup.Count()
};
foreach (var cc in aaaaa)
{
ret.labels.Add(new labels {
label = cc.day
});
ret.values.Add(new values {
value = cc.count.ToString()
});
}
}
}
catch (Exception ex)
{
ret.content += ex.Message;
}
return(ret);
}
public aballresponse AbOkDailyCount()
{
var ret = new aballresponse {
status = 0, values = new List <values>(), labels = new List <labels>()
};
try
{
using (var abdb = new mvc104.abm.studyinContext())
{
var ah = abdb.History.Select(ab => ab.Finishdate).ToList();
var aaaaa = from one in ah
group one by one.ToString("yyyy-MM-dd") into onegroup
select new aaa
{
day = onegroup.Key, count = onegroup.Count()
};
// var memday=DateTime.Parse( aaaaa.First().day);
foreach (var cc in aaaaa)
{
// if(DateTime.Parse(cc.day).AddDays(-1).CompareTo(memday)>0){
// }
ret.labels.Add(new labels {
label = cc.day
});
ret.values.Add(new values {
value = cc.count.ToString()
});
}
//using (var command = abdb.Database.GetDbConnection().CreateCommand())
//{
// command.CommandText = "SELECT distinct(date( finishdate)),count(*) FROM studyin.history group by date( finishdate);";
// command.CommandText = "SELECT finishdate FROM studyin.history";
// command.CommandType = CommandType.Text;
// abdb.Database.OpenConnection();
// using (var result = command.ExecuteReader())
// {
// while (result.Read())
// {
// var aa = new aaa();
// aa.count = 1;
// aa.day = result.GetData(0).ToString();
// a.Add(aa);
// }
// }
//}
}
}
catch (Exception ex)
{
ret.content += ex.Message;
}
return(ret);
}
public aballresponse CheckBorder()
{
var ret = new aballresponse {
status = 0, values = new List <values>(), labels = new List <labels>()
};
try
{
var getpath = "/home/inspect/ftp/get/back";
var gt = new DirectoryInfo(getpath).GetFiles().Where(a => a.Name.Contains("studentmessage"));
var aaaaa = from one in gt
group one by one.Name.Substring(0, 10) into onegroup
orderby onegroup.Key descending
select new { day = onegroup.Key, count = onegroup.Count() };
foreach (var cc in aaaaa)
{
ret.labels.Add(new labels {
label = cc.day
});
ret.values.Add(new values {
value = cc.count.ToString()
});
}
}
catch (Exception ex)
{
ret.content += ex.Message;
}
return(ret);
}
public aballresponse AbOkDailyCount()
{
var ret = new aballresponse {
status = 0, values = new List <values>(), labels = new List <labels>()
};
try
{
using (var abdb = new mvc104.abm.studyinContext())
{
var ah = abdb.History.Select(ab => ab.Finishdate).ToList();
var aaaaa = from one in ah
group one by one.ToString("yyyy-MM-dd") into onegroup
orderby onegroup.Key descending
select new aaa
{
day = onegroup.Key, count = onegroup.Count()
};
// var memday=DateTime.Parse( aaaaa.First().day);
foreach (var cc in aaaaa)
{
// if(DateTime.Parse(cc.day).AddDays(-1).CompareTo(memday)>0){
// }
ret.labels.Add(new labels {
label = cc.day
});
ret.values.Add(new values {
value = cc.count.ToString()
});
}
}
}
catch (Exception ex)
{
ret.content += ex.Message;
}
return(ret);
}
public aballresponse CheckRequestDriver()
{
var ret = new aballresponse {
status = 0, values = new List <values>(), labels = new List <labels>()
};
try
{
using (var driverdb = new enaboContext())
{
var ah = driverdb.Request.Where(ab => ab.Time.CompareTo(DateTime.Now.AddDays(-1)) >= 0).Select(a => a.Time);
var aaaaa = from one in ah
group one by one.ToString("yyyy-MM-dd HH") + "点" into onegroup
orderby onegroup.Key descending
select new aaa
{
day = onegroup.Key, count = onegroup.Count()
};
foreach (var cc in aaaaa)
{
ret.labels.Add(new labels {
label = cc.day
});
ret.values.Add(new values {
value = cc.count.ToString()
});
}
}
}
catch (Exception ex)
{
ret.content += ex.Message;
}
return(ret);
}
