//年对比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);
}
