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)); }