public DataTable getSelectedCourse(int sid)
 {
     int startyear = int.Parse(new StudentBusiness().getStuBySid(sid).Startyear.ToString());
     int year = DateTime.Now.Year;
     int month = DateTime.Now.Month;
     int semester = (month >= 1 && month <= 6) ? 2 * (year - startyear) : 2 * (year - startyear) + 1;
     CourseService couService = new CourseService();
     DataTable dt = couService.getSelectedCourse(sid, semester);
     dt.Columns.Add("trans_week", typeof(string));
     foreach (DataRow dr in dt.Rows)
     {
         if (dr["week"].ToString() == "1")
         {
             dr["trans_week"] = "1-16";
         }
         else if (dr["week"].ToString() == "2")
         {
             dr["trans_week"] = "1-8";
         }
         else
         {
             dr["trans_week"] = "9-16";
         }
     }
     dt.Columns.Add("trans_section", typeof(string));
     foreach (DataRow dr in dt.Rows)
     {
         switch (dr["section"].ToString())
         {
             case "1": dr["trans_section"] = "周一(1)"; break;
             case "2": dr["trans_section"] = "周一(2)"; break;
             case "3": dr["trans_section"] = "周一(3)"; break;
             case "4": dr["trans_section"] = "周一(4)"; break;
             case "5": dr["trans_section"] = "周一(5)"; break;
             case "6": dr["trans_section"] = "周一(6)"; break;
             case "7": dr["trans_section"] = "周二(1)"; break;
             case "8": dr["trans_section"] = "周二(2)"; break;
             case "9": dr["trans_section"] = "周二(3)"; break;
             case "10": dr["trans_section"] = "周二(4)"; break;
             case "11": dr["trans_section"] = "周二(5)"; break;
             case "12": dr["trans_section"] = "周二(6)"; break;
             case "13": dr["trans_section"] = "周三(1)"; break;
             case "14": dr["trans_section"] = "周三(2)"; break;
             case "15": dr["trans_section"] = "周三(3)"; break;
             case "16": dr["trans_section"] = "周三(4)"; break;
             case "17": dr["trans_section"] = "周三(5)"; break;
             case "18": dr["trans_section"] = "周三(6)"; break;
             case "19": dr["trans_section"] = "周四(1)"; break;
             case "20": dr["trans_section"] = "周四(2)"; break;
             case "21": dr["trans_section"] = "周四(3)"; break;
             case "22": dr["trans_section"] = "周四(4)"; break;
             case "23": dr["trans_section"] = "周四(5)"; break;
             case "24": dr["trans_section"] = "周四(6)"; break;
             case "25": dr["trans_section"] = "周五(1)"; break;
             case "26": dr["trans_section"] = "周五(2)"; break;
             case "27": dr["trans_section"] = "周五(3)"; break;
             case "28": dr["trans_section"] = "周五(4)"; break;
             case "29": dr["trans_section"] = "周五(5)"; break;
             case "30": dr["trans_section"] = "周五(6)"; break;
             case "31": dr["trans_section"] = "周六(1)"; break;
             case "32": dr["trans_section"] = "周六(2)"; break;
             case "33": dr["trans_section"] = "周六(3)"; break;
             case "34": dr["trans_section"] = "周六(4)"; break;
             case "35": dr["trans_section"] = "周六(5)"; break;
             case "36": dr["trans_section"] = "周六(6)"; break;
             case "37": dr["trans_section"] = "周日(1)"; break;
             case "38": dr["trans_section"] = "周日(2)"; break;
             case "39": dr["trans_section"] = "周日(3)"; break;
             case "40": dr["trans_section"] = "周日(4)"; break;
             case "41": dr["trans_section"] = "周日(5)"; break;
             case "42": dr["trans_section"] = "周日(6)"; break;
         }
     }
     TeacherService teachService = new TeacherService();
     dt.Columns.Add("tname", typeof(string));
     foreach (DataRow dr in dt.Rows)
     {
         dr["tname"] = teachService.getTnameByTid(int.Parse(dr["tid"].ToString()));
     }
     dt.Columns.Add("trans_pid", typeof(string));
     PlaceService placeService = new PlaceService();
     foreach (DataRow dr in dt.Rows)
     {
         dr["trans_pid"] = placeService.getPlacebyPid(int.Parse(dr["pid"].ToString())).Pname;
     }
     return dt;
 }