private void GetPollutionQuality() { HttpContext context = HttpContext.Current; StringBuilder sb = new StringBuilder("{"); FirstGridManagerManager firstGridManager = new FirstGridManagerManager(); var gridCode = ConfigurationManager.AppSettings["GridCode"]; DataTable dt = firstGridManager.GetPollutionQuality($"GridCode in('{gridCode}')"); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { sb.Append($"{dr["gridCode"]}:"); sb.Append("{"); sb.Append( $@"color:'{dr["color"]}',gridName:'{dr["gridName"]}',quality:'{dr["quality"]}',AQI:'{dr["AQI"]}',PM10:'{dr["PM10"]}' ,PM25:'{dr["PM25"]}',SO2:'{dr["SO2"]}',CO:'{dr["CO"]}',NO2:'{dr["NO2"]}',O3:'{dr["O3"]}'"); sb.Append("},"); } } sb = sb.Remove(sb.Length - 1, 1); sb.Replace("\r\n", "").Replace("\n", ""); sb.Append("}"); context.Response.Write(sb.ToString()); }
private void GetGridInfo() { HttpContext context = HttpContext.Current; string gridCode = context.Request.Params["gridCode"]; StringBuilder sb = new StringBuilder("{"); FirstGridManagerManager firstGridManager = new FirstGridManagerManager(); DataTable dtInfo = firstGridManager.GetGridInfoByGridCode(gridCode); DataTable dtLeader = firstGridManager.GetGridLeaderByGridCode(gridCode); DataTable dtUser = firstGridManager.GetGridUserByGridCode(gridCode); DataTable dtCount = firstGridManager.GetGridCountByGridCode(gridCode); sb.Append("gridInfo:{"); if (dtInfo.Rows.Count > 0) { sb.Append($@"'网格编号':'{dtInfo.Rows[0]["gridCode"]}','区域名称':'{dtInfo.Rows[0]["gridName"]}','网格区域':'{dtInfo.Rows[0]["gridDiction"]}',"); if (dtLeader.Rows.Count > 0) { sb.Append($@"'网格长':'{dtLeader.Rows[0]["leaderName"]}','联系方式':'{dtLeader.Rows[0]["ContactNumber"]}',"); } if (dtCount.Rows.Count > 0) { sb.Append($@"'二级网格数量':'{dtCount.Rows[0]["secondGridCount"]}','二级网格巡查员':'{dtCount.Rows[0]["secondUserCount"]}' ,'三级网格数量':'{dtCount.Rows[0]["thirdGridCount"]}','三级网格巡查员':'{dtCount.Rows[0]["thirdUserCount"]}','污染源数量':'{dtCount.Rows[0]["pollutionCount"]}',"); } sb = sb.Remove(sb.Length - 1, 1); } sb.Append("},userList:{"); if (dtUser.Rows.Count > 0) { foreach (DataRow dr in dtUser.Rows) { sb.Append($@"'{dr["userName"]}':'{dr["contactNumber"]}',"); } sb = sb.Remove(sb.Length - 1, 1); } sb.Append("}}"); context.Response.Write(sb.ToString()); }