/// <summary> /// 河道水情数据查询 /// </summary> /// <param name="fromTime"></param> /// <param name="toTime"></param> /// <param name="stationIds"></param> /// <returns></returns> public static QueryResult ListHourWater_Standard(DateTime fromTime, DateTime toTime, string stationId) { //查询为空 if (stationId == null) { return(new QueryResult()); } //创建数据库对象 using (RWDB rw = new RWDB()) { QueryResult result = new QueryResult(); //获取数据 IQueryable <ST_RIVER_R> riverRecord = ListHourRiver_Standard(rw, fromTime, toTime, stationId); IQueryable <ST_RSVR_R> rsvrRecord = ListHourReservoir_Standard(rw, fromTime, toTime, stationId); if (riverRecord.Count() != 0) { //是河道水情站 List <ST_RIVER_R> singleStationRecord = new List <ST_RIVER_R>(); singleStationRecord = riverRecord.Where(r => r.STCD.Equals(stationId)).OrderByDescending(r => r.TM).ToList(); Station station = StationService.GetStationById(stationId); TimeRecord record = new TimeRecord { stationId = station.stationId, stationName = station.stationName, stationType = station.stationType }; foreach (var r in singleStationRecord) { TimeRiver tr = new TimeRiver(r.TM, r.Z, r.Q); record.trivers.Add(tr); } result.records.Add(record); } else if (rsvrRecord.Count() != 0) { //是水库水情站 //是河道水情站 List <ST_RSVR_R> singleStationRecord = new List <ST_RSVR_R>(); singleStationRecord = rsvrRecord.Where(r => r.STCD.Equals(stationId)).OrderByDescending(r => r.TM).ToList(); Station station = StationService.GetStationById(stationId); TimeRecord record = new TimeRecord { stationId = station.stationId, stationName = station.stationName, stationType = station.stationType }; foreach (var r in singleStationRecord) { TimeReservoir tr = new TimeReservoir(r.TM, r.RZ, r.W); record.treserviors.Add(tr); } result.records.Add(record); } else { //两个表都没有这个站点的数据 } return(result); } }
public string TestregularMonths(string currMonth) { return(TimeRiver.regularMonths(currMonth)); }
public void TestmissedClasses(ComplexTest <object[], int> test) { Assert.AreEqual(test.ExpectedResult, TimeRiver.missedClasses((int)test.Input[0], (int[])test.Input[1], (string[])test.Input[2])); }
public int Testholiday(int x, string weekDay, string month, int yearNumber) { return(TimeRiver.holiday(x, weekDay, month, yearNumber)); }
public int[] TestvideoPart(string part, string total) { return(TimeRiver.videoPart(part, total)); }
public int TestdayOfWeek(string birthdayDate) { return(TimeRiver.dayOfWeek(birthdayDate)); }
public string TestcuriousClock(string someTime, string leavingTime) { return(TimeRiver.curiousClock(someTime, leavingTime)); }
public int TestnewYearCelebrations(string takeOffTime, int[] minutes) { return(TimeRiver.newYearCelebrations(takeOffTime, minutes)); }
/// <summary> /// 原始库单站水情数据查询 /// </summary> /// <param name="fromTime"></param> /// <param name="toTime"></param> /// <param name="stationIds"></param> /// <returns></returns> public static QueryResult ListHourWater(DateTime fromTime, DateTime toTime, string id) { //查询为空 if (id == null) { return(new QueryResult()); } //传递得参数 Dictionary <string, object> param = new Dictionary <string, object>(); //TODO添加datatime转string timeStart timeEnd //查询条件 Dictionary <string, string> paramInner = new Dictionary <string, string>(); paramInner["stationid"] = id; paramInner["strttime"] = fromTime.ToString(); paramInner["endtime"] = toTime.ToString(); //返回结果 QueryResult result = new QueryResult(); List <WaterDbData> waterList = new List <WaterDbData>(); //string suffix = "/subcenter/getSubcenter"; //string suffix = System.Configuration.ConfigurationManager.AppSettings["InterfaceAddr"]; string url = suffix + "/water/getWaterBS"; //string url = "http://127.0.0.1:8088/water/getWaterBS"; string jsonStr = HttpHelper.SerializeDictionaryToJsonString(paramInner); param["water"] = jsonStr; try { string resultJson = HttpHelper.Post(url, param); //warningInfoList = (List<CEntityWarningInfo>)HttpHelper.JsonToObject(resultJson, new List<CEntityWarningInfo>()); waterList = (List <WaterDbData>)HttpHelper.JsonDeserialize <List <WaterDbData> >(resultJson, new List <WaterDbData>()); } catch (Exception e) { Debug.WriteLine("查询水位信息失败"); throw e; } //处理数据 Station station = StationService.GetStationByRawId(id); TimeRecord record = new TimeRecord { stationId = station.id, stationName = station.stationName, stationType = station.stationType }; List <TimeRiver> trivers = new List <TimeRiver>(); foreach (WaterDbData water in waterList) { TimeRiver timeRiver = new TimeRiver(water.datatime, water.waterstage, water.waterflow); timeRiver.time = water.datatime; timeRiver.waterStage = water.waterstage; timeRiver.waterFlow = water.waterflow; trivers.Add(timeRiver); } record.trivers = trivers; record.trivers = record.trivers.OrderByDescending(r => r.time).ToList(); result.records.Add(record); return(result); ////获取数据 ////List<WaterDbData> waterRecord = ListRawHourWater(fromTime, toTime, id); //QueryResult result = new QueryResult(); //Station station = StationService.GetStationByRawId(id); //TimeRecord record = new TimeRecord { stationId = station.id, stationName = station.stationName, stationType = station.stationType }; //List<TimeRiver> twaters = new List<TimeRiver>(); //LNRRDB ln = new LNRRDB(); //List<string> tableNameList = TableNameHelper.getTableName("water", fromTime, toTime); //#region 循环获取所有数据 辣鸡代码 是gm写的 //foreach (string tableName in tableNameList) //{ // switch (tableName) // { // case "water20188A": // var waterrecords20188A = from water in ln.water20188A where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20188A = dataTransfer(waterrecords20188A); // twaters.AddRange(waters20188A); // break; // case "water20188B": // var waterrecords20188B = from water in ln.water20188B where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20188B = dataTransfer(waterrecords20188B); // twaters.AddRange(waters20188B); // break; // case "water20189A": // var waterrecords20189A = from water in ln.water20189A where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20189A = dataTransfer(waterrecords20189A); // twaters.AddRange(waters20189A); // break; // case "water20189B": // var waterrecords20189B = from water in ln.water20189B where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20189B = dataTransfer(waterrecords20189B); // twaters.AddRange(waters20189B); // break; // case "water201810A": // var waterrecords201810A = from water in ln.water201810A where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters201810A = dataTransfer(waterrecords201810A); // twaters.AddRange(waters201810A); // break; // case "water201810B": // var waterrecords201810B = from water in ln.water201810B where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters201810B = dataTransfer(waterrecords201810B); // twaters.AddRange(waters201810B); // break; // case "water201811A": // var waterrecords201811A = from water in ln.water201811A where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters201811A = dataTransfer(waterrecords201811A); // twaters.AddRange(waters201811A); // break; // case "water201811B": // var waterrecords201811B = from water in ln.water201811B where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters201811B = dataTransfer(waterrecords201811B); // twaters.AddRange(waters201811B); // break; // case "water201812A": // var waterrecords201812A = from water in ln.water201812A where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters201812A = dataTransfer(waterrecords201812A); // twaters.AddRange(waters201812A); // break; // case "water201812B": // var waterrecords201812B = from water in ln.water201812B where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters201812B = dataTransfer(waterrecords201812B); // twaters.AddRange(waters201812B); // break; // case "water20191A": // var waterrecords20191A = from water in ln.water20191A where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20191A = dataTransfer(waterrecords20191A); // twaters.AddRange(waters20191A); // break; // case "water20191B": // var waterrecords20191B = from water in ln.water20191B where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20191B = dataTransfer(waterrecords20191B); // twaters.AddRange(waters20191B); // break; // case "water20192A": // var waterrecords20192A = from water in ln.water20192A where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20192A = dataTransfer(waterrecords20192A); // twaters.AddRange(waters20192A); // break; // case "water20192B": // var waterrecords20192B = from water in ln.water20192B where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20192B = dataTransfer(waterrecords20192B); // twaters.AddRange(waters20192B); // break; // case "water20193A": // var waterrecords20193A = from water in ln.water20193A where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20193A = dataTransfer(waterrecords20193A); // twaters.AddRange(waters20193A); // break; // case "water20193B": // var waterrecords20193B = from water in ln.water20193B where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20193B = dataTransfer(waterrecords20193B); // twaters.AddRange(waters20193B); // break; // case "water20194A": // var waterrecords20194A = from water in ln.water20194A where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20194A = dataTransfer(waterrecords20194A); // twaters.AddRange(waters20194A); // break; // case "water20194B": // var waterrecords20194B = from water in ln.water20194B where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20194B = dataTransfer(waterrecords20194B); // twaters.AddRange(waters20194B); // break; // case "water20195A": // var waterrecords20195A = from water in ln.water20195A where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20195A = dataTransfer(waterrecords20195A); // twaters.AddRange(waters20195A); // break; // case "water20195B": // var waterrecords20195B = from water in ln.water20195B where id == water.stationid && water.datatime <= toTime && water.datatime >= fromTime select water; // List<TimeRiver> waters20195B = dataTransfer(waterrecords20195B); // twaters.AddRange(waters20195B); // break; // default: // break; // } //} //record.trivers = twaters; //#endregion ////List<Models.WaterDbData> singleStationRecord = new List<WaterDbData>(); ////singleStationRecord = waterRecord.Where(r => r.stationid.Equals(id)).OrderByDescending(r => r.datatime).ToList(); //////数据处理 ////Station station = StationService.GetStationByRawId(id); ////TimeRecord record = new TimeRecord { stationId = station.id, stationName = station.stationName, stationType = station.stationType }; ////foreach (var r in singleStationRecord) ////{ //// TimeRiver tr = new TimeRiver(r.datatime, r.waterstage, r.waterflow); //// record.trivers.Add(tr); ////} //record.trivers = record.trivers.OrderByDescending(r => r.time).ToList(); //result.records.Add(record); //return result; }