private static DataTable DisposeDataTable(DataTable dt)
{
dt.Columns.Add("SplitTimeAndArea");//单节课信息
dt.Columns["SplitTimeAndArea"].SetOrdinal(3);
DataTable TabCourseSimple = dt.Clone();//中转作用，保存拆分
TabCourseSimple.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
SplitToDataTable.SplitTimeAndArea(dt.Rows[i], 4, TabCourseSimple, 3, new char[] { '@' });
}
//表列结构[TeacherDepartment],[TeacherID],[TeacherName],[SplitTimeAndArea],[TimeAndArea]
TabCourseSimple.Columns.Add("CourseAllWeek"); //所有周
TabCourseSimple.Columns.Add("CourseWeek"); //星期数
TabCourseSimple.Columns.Add("CourseTime"); //节数
TabCourseSimple.Columns.Add("CourseAddress"); //教室地址
TabCourseSimple.Columns["CourseAllWeek"].SetOrdinal(3);
TabCourseSimple.Columns["CourseWeek"].SetOrdinal(4);
TabCourseSimple.Columns["CourseTime"].SetOrdinal(5);
TabCourseSimple.Columns["CourseAddress"].SetOrdinal(6);
for (int i = 0; i < TabCourseSimple.Rows.Count; i++)
{
SplitToDataTable.SplitTimeAndArea2(TabCourseSimple.Rows[i]);
}
TabCourseSimple.Columns.RemoveAt(7);
//ConnHelper.DataTableToSQLServer("TabTeacherAllCourse", TabCourseSimple);
//表列结构[TeacherDepartment],[TeacherID],[TeacherName],CourseAllWeek,CourseWeek,CourseTime,CourseAddress,[TimeAndArea]
return(TabCourseSimple);
}
/// <summary>
/// 数据表拆分主方法
/// </summary>
/// <returns></returns>
public static string TabTeacherAllCourse()
{
//查找不重复的课程信息（课程信息 伪主键）sql语句去重查找↓
string strSql = "select distinct [TimeAndArea],[TeacherDepartment],[TeacherID],[TeacherName],[CourseAllWeek],[CourseWeek],[CourseTime],[CourseAddress],[TimeAndArea],[CourseID],[CourseName] ,[t1] ,[t2] ,[t3] ,[Class] from [TabTeacherAllCourse]";
DataTable dt = ConnHelper.GetDistinceColoum(strSql);
dt.Columns.RemoveAt(0);
//表列结构[TeacherDepartment],[TeacherID],[TeacherName],CourseAllWeek,CourseWeek,CourseTime,CourseAddress,[TimeAndArea]
DataTable TabCourseSimple = dt.Clone();//中转作用，保存拆分
TabCourseSimple.Clear();
for (int i = 0; i < dt.Rows.Count; i++)
{
SplitToDataTable.SplitTimeAndArea(dt.Rows[i], 3, TabCourseSimple, 3, new char[] { ' ' });
}
return(ConnHelper.DataTableToSQLServer("TabTeacherCourseWeek", TabCourseSimple));
}
