//根据TeachId查找CourseName public List <T_Task_Course> FindCourse(int id) { SqlConnection co = new SqlConnection(); co.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dataConnection"]; SqlCommand cm = new SqlCommand(); cm.CommandText = "select Id from T_Task_Course where TeaId=" + id; co.Open(); cm.Connection = co; SqlDataReader dr = cm.ExecuteReader(); List <T_Task_Course> list = new List <T_Task_Course>(); while (dr.Read()) { T_Task_Course head = new T_Task_Course(); DALT_Task_Course head_dal = new DALT_Task_Course(); int Id = Convert.ToInt32(dr["Id"]); head = head_dal.GetModel(Id); list.Add(head); } dr.Close(); co.Close(); return(list); }
//王一情 public string GetCourseTask(int userid, int userlevel) { T_Base_Teacher teacher = new T_Base_Teacher(); DALT_Base_Teacher dal_Teacher = new DALT_Base_Teacher(); teacher = dal_Teacher.GetModel(userid); DALT_Event_CourseTask dal = new DALT_Event_CourseTask(); List <T_Event_CourseTask> list = new List <T_Event_CourseTask>(); if (userlevel != 10 && userlevel != 11) { list = dal.GetStuCourseList(userid); } else { list = dal.GetTeaCourseList("WPeople=" + "'" + teacher.Name + "'"); } string res = ""; foreach (T_Event_CourseTask item in list) { T_Task_Course course = new T_Task_Course(); DALT_Task_Course dal_course = new DALT_Task_Course(); course = dal_course.GetModel(item.CourseId); string st_date = ((DateTime)item.StartWeek).ToString("yyyy-MM-dd"); string st = st_date + " " + item.StartTime; string ed = st_date + " " + item.EndTime; res += "{\"id\":\"" + item.Id + "\",\"title\":\"" + course.Name + "\",\"type\":\"" + item.Type + "\",\"des\":\"" + item.Description + "\",\"start\":\"" + st + "\",\"end\":\"" + ed + "\"}"; res += ","; } return(res); }