//年对比12个月 public void MonthContrastByYear(HttpContext context) { string compareObject = context.Request["compareObject"]; string year = context.Request["year"]; if (year != "") { year = year.ToString(); } else { year = "2019"; } IDataParameter[] parames = new IDataParameter[2]; parames[0] = new SqlParameter("@View", compareObject); parames[1] = new SqlParameter("@Year", year); SqlDataReader MonthTreeDR = DbHelperSQL.RunProcedure("GetCountByMonthInYearNODepart", parames); List <ChartDa> list = null; if (MonthTreeDR.HasRows) { list = new List <ChartDa>(); while (MonthTreeDR.Read()) { ChartDa data = new ChartDa(); data.Time = MonthTreeDR["Time"].ToString(); data.TreeNum = int.Parse(MonthTreeDR["Sum"].ToString()); list.Add(data); } } string jsonData = JsonConvert.SerializeObject(list); context.Response.Write(jsonData); }
//各树类对比 public void TreeTypeContrast(HttpContext context) { string compareObject = context.Request["compareObject"]; if (compareObject == "") { compareObject = "vwTreeSumByYear"; } SqlDataReader PartyTreeDR = DbHelperSQL.ExecuteReader("select * from " + compareObject); List <ChartDa> list = null; if (PartyTreeDR.HasRows) { list = new List <ChartDa>(); while (PartyTreeDR.Read()) { ChartDa data = new ChartDa(); data.Time = PartyTreeDR["treename"].ToString(); data.TreeNum = int.Parse(PartyTreeDR["Sum"].ToString()); list.Add(data); } } string jsonData = JsonConvert.SerializeObject(list); context.Response.Write(jsonData); }
//当月数据 public void GetTreeAndTaskCountByDayMonth(HttpContext context) { IDataParameter[] parame = null; SqlDataReader dr = DbHelperSQL.RunProcedure("GetTreeCountByDayInMonth", parame); SqlDataReader dr2 = DbHelperSQL.RunProcedure("GetTaskCountByDayInMonth", parame); List <ChartDa> list = null; ArrayList liststr = new ArrayList(); if (dr2.HasRows) { while (dr2.Read()) { liststr.Add(int.Parse(dr2["num"].ToString())); } } if (dr.HasRows) { int i = 0; list = new List <ChartDa>(); while (dr.Read()) { ChartDa data = new ChartDa(); data.Time = dr["Time"].ToString(); data.TreeNum = int.Parse(dr["num"].ToString()); data.TaskNum = int.Parse(liststr[i].ToString()); list.Add(data); i++; } } string jsonData = JsonConvert.SerializeObject(list); context.Response.Write(jsonData); }
//党支部对比 public void PartyContrast(HttpContext context) { string compareObject = context.Request["compareObject"]; string year = context.Request["year"]; string TownName = context.Request["TownName"]; if (compareObject == "") { compareObject = "vwPartyTreeSum"; } if (year != "") { year = year.ToString(); } else { year = "2019"; } if (TownName != "") { TownName = TownName.ToString(); } else { TownName = "石龙镇"; } IDataParameter[] parames = new IDataParameter[3]; parames[0] = new SqlParameter("@View", compareObject); parames[1] = new SqlParameter("@Year", year); parames[2] = new SqlParameter("@TownName", TownName); SqlDataReader PartyTreeDR = DbHelperSQL.RunProcedure("GetPartyCountByYear", parames); List <ChartDa> list = null; if (PartyTreeDR.HasRows) { list = new List <ChartDa>(); while (PartyTreeDR.Read()) { ChartDa data = new ChartDa(); data.Time = PartyTreeDR["Time"].ToString(); data.PartyName = PartyTreeDR["PartyName"].ToString(); data.TreeNum = int.Parse(PartyTreeDR["Sum"].ToString()); list.Add(data); } } string jsonData = JsonConvert.SerializeObject(list); context.Response.Write(jsonData); }