/// <summary> /// 查询城市下的区县 /// </summary> /// <param name="provice">选中的省份</param> /// <param name="city">选中的城市</param> /// <returns></returns> public string GetCountryList(string provice, string city) { string UserID = Session["UserID"].ToString(); string CompanyID = Session["CompanyID"].ToString(); var country_Entity = companyBll.GetCountryListByUser(UserID, provice, city, CompanyID); return(SerializerDataToClient.GetResponseJsonString(true, country_Entity)); }
public string GetPeriodData(int StationID, DateTime?Sdate, DateTime?Edate) { RWEntities db = new RWEntities(); var _sdate = Sdate == null ? new DateTime(1999, 1, 1) : Sdate.Value; var _edate = Edate == null ? new DateTime(2999, 1, 1) : Edate.Value; List <MResults> mrList = new List <MResults>(); var mr = db.FlowTable.Where(p => p.FTestStartTime >= _sdate && p.FTestStartTime <= Edate && p.StationID == StationID) .Select(s => new MResults { CPId = s.CPId, FTId = s.FTId, //数据接收时间 RevTime = s.RevTime, //观测时间 Time = s.FTestStartTime, }).OrderByDescending(s => s.Time).ToList(); for (int i = 0; i < mr.Count; i++) { int CPId = mr[i].CPId; int FTId = mr[i].FTId; var obj = db.FlowTable.Where(p => p.FTId == FTId && p.StationID == StationID) .Select(s => new MResults { //数据接收时间 RevTime = s.RevTime, //起始水位 StartWaterLev = s.StartwaterLev, //结束水位 EndWaterLev = s.EndwaterLev, //总流量 TotalFlow = s.FlowValue, //过水面积 SecArea = s.SecArea, //平均流速 MeanVelocity = s.MeanVelocity, //最大流速 MaxSpeed = s.MaxVelocity, //水面宽 WaterWidth = s.WaterWidth, //平均水深 TotalDepth = s.MeanDepth, //最大水深 MaxDepth = s.MaxDepth, //水位模式 WaterModel = s.WaterModel, //SoundLine = new List<SoundLineInfo>() }).FirstOrDefault(); obj.SoundLine = new List <SoundLineInfo>(); SoundLineInfo sli = new SoundLineInfo(); sli.StartDistL = 0; sli.RiverElva = 0; obj.SoundLine.Add(sli); List <SoundLineInfo> slilist = db.SoundverData.Where(p => p.StationID == StationID && p.CPId == CPId) .Select(s => new SoundLineInfo { StartDistL = s.StartDistL, RiverElva = s.VerData }).ToList(); obj.SoundLine.AddRange(slilist); obj.VelocityLine = new List <VelocityLineInfo>(); VelocityLineInfo vli = new VelocityLineInfo(); vli.StartDistV = 0; vli.RiverElva = 0; obj.VelocityLine.Add(vli); List <VelocityLineInfo> vlilist = db.SpeedData.Where(p => p.StationID == StationID && p.CPId == CPId) .Select(s => new VelocityLineInfo { StartDistV = s.StartDistV, RiverElva = s.RiverElva, HCoeffA = s.HCoeffA, HCoeffB = s.HCoeffB, MCoeffA = s.MCoeffA, MCoeffB = s.MCoeffB, LCoeffA = s.LCoeffA, LCoeffB = s.LCoeffB }).ToList(); obj.VelocityLine.AddRange(vlilist); DateTime Time = Convert.ToDateTime(obj.RevTime); obj.RevTime = Time.ToString("yyyy - MM - dd HH: mm:ss"); //一对多关系 查询出每条测试结果对应垂线数据 var Partobj = db.FlowParArea.Where(p => p.StationID == StationID && p.FTId == FTId) .Select(d => new PartData { //线平均水深 Depth = d.PMeanDepth, //线面流速 MSpeed = d.FlowData, //线平均流速 MeanSpeed = d.PMeanVelocity, //线部分面积 PartArea = d.PartArea, //线平均流量 PartFlow = d.PartArea * d.PMeanVelocity, }).ToList(); obj.PartData = new List <PartData>(); PartData pd = new PartData(); pd.Depth = 0; pd.MSpeed = 0; pd.MeanSpeed = 0; pd.PartArea = 0; pd.PartFlow = 0; obj.PartData.Add(pd); obj.PartData.AddRange(Partobj); mrList.Add(obj); } return(SerializerDataToClient.GetResponseJsonString(true, mrList)); }