public Dictionary <string, List <ChartMainModel> > GetMainChartJson(DbConn PubConn, int num, string key, int type) { return(SqlHelper.Visit(ps => { Dictionary <string, List <ChartMainModel> > d = new Dictionary <string, List <ChartMainModel> >(); DateTime date = DateTime.Now; string Stime = date.AddDays(num).ToString("yyyy-MM-dd"); string Etime = date.ToString("yyyy-MM-dd"); List <ChartMainModel> chartMainModel = new List <ChartMainModel>(); ChartMainModel MainModel = new ChartMainModel(); MainModel.Tkey = "avgtime"; MainModel.Tvalue = 0; chartMainModel.Add(MainModel); MainModel = new ChartMainModel(); MainModel.Tkey = "maxtime"; MainModel.Tvalue = 0; chartMainModel.Add(MainModel); MainModel = new ChartMainModel(); MainModel.Tkey = "mintime"; MainModel.Tvalue = 0; chartMainModel.Add(MainModel); for (int i = num; i <= 0; i++) { d.Add(date.AddDays(i).ToString("yyyy-MM-dd"), chartMainModel); } ps.Add("Stime", Stime); ps.Add("Etime", Etime); ps.Add("key", key); string sql = ""; if (type == 1) { sql = "select date,avgtime,maxtime,mintime from tb_timewatchlog_sql_dayreport where date>=@Stime and date<=@Etime and sqlhash=@key order by date"; } else { sql = "select date,avgtime,maxtime,mintime from tb_timewatchlog_api_dayreport where date>=@Stime and date<=@Etime and url=@key order by date"; } DataTable dt = PubConn.SqlToDataTable(sql, ps.ToParameters()); foreach (DataRow dr in dt.Rows) { List <ChartMainModel> m = new List <ChartMainModel>(); foreach (DataColumn c in dr.Table.Columns) { if (c.ColumnName != "date") { ChartMainModel main = new ChartMainModel(); main.Tkey = c.ColumnName; main.Tvalue = Convert.ToDecimal(dr[c.ColumnName]); m.Add(main); } } d[Convert.ToDateTime(dr["date"]).ToString("yyyy-MM-dd")] = m; } return d; })); }
public Dictionary <string, List <ChartMainModel> > GetMainChartJson(DbConn PubConn, int num, string key) { return(SqlHelper.Visit(ps => { Dictionary <string, List <ChartMainModel> > d = new Dictionary <string, List <ChartMainModel> >(); DateTime date = DateTime.Now; string Stime = date.AddDays(num).ToString("yyyy-MM-dd"); string Etime = date.ToString("yyyy-MM-dd"); ps.Add("Stime", Stime); ps.Add("Etime", Etime); ps.Add("key", key); string sql = @"select date,avgcpu,maxcpu,mincpu,avgmemory,maxmemory,minmemory, avgnetworkupload,maxnetworkupload,minnetworkupload,avgnetworkdownload, maxnetworkdownload,miniowrite,avgiisrequest,maxiisrequest,miniisrequest, minnetworkdownload,avgioread,maxioread,minioread,avgiowrite,maxiowrite from tb_performance_dayreport where date>=@Stime and date<=@Etime and serverid=@key order by date"; DataTable dt = PubConn.SqlToDataTable(sql, ps.ToParameters()); List <ChartMainModel> chartMainModel = new List <ChartMainModel>(); foreach (DataColumn c in dt.Columns) { if (c.ColumnName != "date") { ChartMainModel MainModel = new ChartMainModel(); MainModel.Tkey = c.ColumnName; MainModel.Tvalue = 0; chartMainModel.Add(MainModel); } } for (int i = num; i <= 0; i++) { d.Add(date.AddDays(i).ToString("yyyy-MM-dd"), chartMainModel); } foreach (DataRow dr in dt.Rows) { List <ChartMainModel> m = new List <ChartMainModel>(); foreach (DataColumn c in dr.Table.Columns) { if (c.ColumnName != "date") { ChartMainModel main = new ChartMainModel(); main.Tkey = c.ColumnName; main.Tvalue = Convert.ToDecimal(dr[c.ColumnName]); m.Add(main); } } d[Convert.ToDateTime(dr["date"]).ToString("yyyy-MM-dd")] = m; } return d; })); }