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