public List <Dictionary <string, object> > GetChartJson(DbConn PubConn, string Sday, string Eday, string mainday, string secday, string ckey, string gkey) { return(SqlHelper.Visit(ps => { List <Dictionary <string, object> > model = new List <Dictionary <string, object> >(); ChartDal dal = new ChartDal(); string sqlwhere = "where "; if (!string.IsNullOrWhiteSpace(Sday)) { ps.Add("Sday", Sday); ps.Add("Eday", Eday); sqlwhere += " date>=@Sday and date<=@Eday "; } else { ps.Add("Mday", mainday); ps.Add("Sday", secday); sqlwhere += " date in (@Mday,@Sday) "; } string sql = "select * from tb_timewatchlog_api_dayreport " + sqlwhere; DataSet ds = new DataSet(); PubConn.SqlToDataSet(ds, sql, ps.ToParameters()); foreach (DataRow dr in ds.Tables[0].Rows) { model.Add(dal.CreateDicModel(dr, ckey, gkey)); } return model; })); }
public List <Dictionary <string, object> > GetChartJson(DbConn PubConn, string Fday, string Nday, string key) { return(SqlHelper.Visit(ps => { List <Dictionary <string, object> > model = new List <Dictionary <string, object> >(); ChartDal dal = new ChartDal(); ps.Add("Fday", Fday); ps.Add("Nday", Nday); string sql = "select date,AVG(" + key + ") Cvalue from tb_timewatchlog_api_dayreport where date=@Fday or date=@Nday group by date"; DataSet ds = new DataSet(); PubConn.SqlToDataSet(ds, sql, ps.ToParameters()); foreach (DataRow dr in ds.Tables[0].Rows) { Dictionary <string, object> m = new Dictionary <string, object>(); m.Add("Date", dr["date"]); m.Add("Cvalue", dr["Cvalue"]); model.Add(m); } return model; })); }