private List<DailyItem> GetDayAndEventTotalNumbers() { List<DailyItem> day_and_event_number = new List<DailyItem>(); //按行遍历 DataTable dt = DAL.SQLHelper.ExecuteDt("select SUBSTRING(CONVERT(CHAR(23),t.TimeStamp , 121),1,10) day,count(*) amount from TripletsSet t group by SUBSTRING(CONVERT(CHAR(23),t.TimeStamp , 121),1,10) order by SUBSTRING(CONVERT(CHAR(23),t.TimeStamp , 121),1,10) asc"); foreach (DataRow row in dt.Rows) { //day_and_event_number.Add(Convert.ToString(row["day"]),Convert.ToInt32(row["amount"])); DateTime date = Convert.ToDateTime(row["day"]); String JSFormatDate= date.Year.ToString() + "," + (date.Month - 1).ToString() + "," + date.Day.ToString(); DailyItem item = new DailyItem() { date = JSFormatDate, number = Convert.ToInt32(row["amount"]) }; day_and_event_number.Add(item); } return day_and_event_number; }
private List<DailyItem> GetSingleEventList(String verbStr,String objectStr) { List<DailyItem> day_and_single_event_number = new List<DailyItem>(); //按行遍历 //////////////////////////////////////////////////////////////////!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! SqlParameter[] parameters = new SqlParameter[2]; parameters[0] = new SqlParameter("@verbStr", SqlDbType.VarChar) { Value = verbStr }; parameters[1] = new SqlParameter("@objectStr", SqlDbType.VarChar) { Value = objectStr }; String t_sql = "select SUBSTRING(CONVERT(CHAR(23),t.TimeStamp , 121),1,10) day,count(*) amount from TripletsSet t where Verb=@verbStr and Object=@objectStr group by SUBSTRING(CONVERT(CHAR(23),t.TimeStamp , 121),1,10) order by SUBSTRING(CONVERT(CHAR(23),t.TimeStamp , 121),1,10) asc"; DataTable dt = DAL.SQLHelper.GetDataTable(t_sql,parameters); //DataTable dt = DAL.SQLHelper.ExecuteDt("select SUBSTRING(CONVERT(CHAR(23),t.TimeStamp , 121),1,10) day,count(*) amount from TripletsSet t where Verb='activity_expand ' and Object='marie-architecture ' group by SUBSTRING(CONVERT(CHAR(23),t.TimeStamp , 121),1,10) order by SUBSTRING(CONVERT(CHAR(23),t.TimeStamp , 121),1,10) asc"); foreach (DataRow row in dt.Rows) { //day_and_event_number.Add(Convert.ToString(row["day"]),Convert.ToInt32(row["amount"])); DateTime date = Convert.ToDateTime(row["day"]); String JSFormatDate = date.Year.ToString() + "," + (date.Month - 1).ToString() + "," + date.Day.ToString(); DailyItem item = new DailyItem() { date = JSFormatDate, number = Convert.ToInt32(row["amount"]) }; day_and_single_event_number.Add(item); } return day_and_single_event_number; }