public static void QueryTransferStatistic() { Models.Maintain db = new Models.Maintain(); DateTime now = DateTime.Now; DateTime from = new DateTime( year: now.Year, month: now.Month, day: now.Day, hour: 9, minute: 0, second: 0 ); DateTime to = new DateTime( year: now.Year, month: now.Month, day: now.Day, hour: now.Hour, minute: 0, second: 0 ); List <Models.DK_E_INFO> dic = DAL.TransferDataService.ListErrorData(db, from, to); Models.TransferStatisticRecord records = new Models.TransferStatisticRecord(dic); foreach (KeyValuePair <DateTime, bool> data in records.datas) { Console.WriteLine(data.Key.ToString() + "\t" + (data.Value ? "Yes" : "No")); } }
//GET: transfer/statistic /// <summary> /// 获取数据转储统计信息,这里时间为年月日,直接在表中取当天9时-第二天8时之间的所有数据。只能查询一天的数据。 /// @param date:YYYY-MM-DD /// </summary> /// <returns></returns> public ActionResult statistic() { DateTime from; int id = 0; try { from = DateTime.Parse(Request.Params.Get("date")); id = int.Parse(Request.Params.Get("isubcenter")); } catch (Exception e) { return(Json(helper.DBHelper.SerializeDBReturnCode(helper.DBReturnCode.BAD_REQUEST), JsonRequestBehavior.AllowGet)); } Models.QueryResult result = new Models.QueryResult(); Models.Maintain db = new Models.Maintain(); List <Models.Station> stations = DAL.StationService.ListStationBySubcenterId(id); List <Models.M_status> datas = DAL.TransferDataService.ListMonitorData(db, from, 1); //仅查一天的数据 foreach (Models.Station station in stations) { Models.M_status data = datas.FirstOrDefault(i => i.STCD == station.stationId); Models.TransferStatisticRecord record = new Models.TransferStatisticRecord(station, data); result.records.Add(record); } JavaScriptSerializer jsSerializer = new JavaScriptSerializer(); jsSerializer.MaxJsonLength = Int32.MaxValue; string json = jsSerializer.Serialize(result); return(Json(json, JsonRequestBehavior.AllowGet)); }