public IList <HourTotalInfo> GetHourZhiTongOrZuanZhanPVTotal(string nickNo, DateTime date, bool zhi)
{
string sql = "";
if (zhi)
{
sql = SQL_SELECT_GETZHITONG_HOURTOTAL.Replace("@tableName", GetRealTable(nickNo));
}
else
{
sql = SQL_SELECT_GETZUANZHAN_HOURTOTAL.Replace("@tableName", GetRealTable(nickNo));
}
DataTable dt = DBHelper.ExecuteDataTable(sql, new SqlParameter("@date", date));
IList <HourTotalInfo> list = new List <HourTotalInfo>();
foreach (DataRow dr in dt.Rows)
{
HourTotalInfo info = new HourTotalInfo();
info.PVCount = int.Parse(dr["PVCount"].ToString());
info.Hour = int.Parse(dr["PVHour"].ToString());
list.Add(info);
}
IList <HourTotalInfo> rlist = list.OrderBy(o => o.Hour).ToList();
return(rlist);
}
public IList <HourTotalInfo> GetHourIPTotal(string nickNo, DateTime date)
{
string sql = SQL_HOUR_IPTOTAL_TABLE.Replace("@tableName", GetRealTable(nickNo));
DataTable dt = DBHelper.ExecuteDataTable(sql, new SqlParameter("@date", date));
IList <HourTotalInfo> list = new List <HourTotalInfo>();
foreach (DataRow dr in dt.Rows)
{
HourTotalInfo info = new HourTotalInfo();
info.PVCount = int.Parse(dr["IPCount"].ToString());
info.Hour = int.Parse(dr["IPHour"].ToString());
list.Add(info);
}
IList <HourTotalInfo> rlist = list.OrderBy(o => o.Hour).ToList();
return(rlist);
}
