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;
}));
}
