private void InsertCoursesSimpleMap(List <string> strDistinctTeacherID)
{
for (int i = 0; i < strDistinctTeacherID.Count; i++)
{
List <string> strDD = new List <string>();
strDD = AddSQLStringToDAL.GetDistinctStrings("TabAllCourses", "TimeAndArea", "TeacherID", strDistinctTeacherID[i].ToString());//获取TimeAndArea
for (int k = 0; k < strDD.Count; k++)
{
List <string> strResult = new List <string>();
strResult = SplitString.GetSplitCountAndDetails(strDD[k]);
DataTable dt = AddSQLStringToDAL.GetDataTableBysql("select * from TabAllCourses where TeacherID = '" + strDistinctTeacherID[i].ToString() + "' and TimeAndArea = '" + strDD[k].ToString() + "'");
for (int j = 0; j < (strResult.Count / 4); j++)
{
string WeekRange = SplitString.GetWithoutWeek(strResult[j * 4 + 0].ToString());//如果想用空格隔开，只是在最后加一个空格（以，作为例子试的）
string Week = strResult[j * 4 + 1].ToString();
string Time = strResult[j * 4 + 2].ToString();
string Area = strResult[j * 4 + 3].ToString();
string Course = dt.Rows[0]["Course"].ToString().Trim();
if (AddSQLStringToDAL.InsertTabTeachers("TabTeacherCourseSimpleMap", strDistinctTeacherID[i].ToString(), dt.Rows[0]["TeacherName"].ToString(), Course, WeekRange, Week, Time, strDD[k].ToString(), dt.Rows[0]["Class"].ToString(), dt.Rows.Count.ToString(), dt.Rows[0]["TeacherDepartment"].ToString(), dt.Rows[0]["StudentDepartment"].ToString(), Area))
{
}
}
dt.Clear();
}
}
}
