/// <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));
}
public static DataTable SetData(string strSql)
{
return(ConnHelper.GetDistinceColoum(strSql));
}
public static List <string> GetDistinctString(string strTable, string str1)
{
string strSQL = BuildSQLDistinctString(strTable, str1);
return(ConnHelper.GetDistinceColoum(strSQL, str1));
}
public static List <string> GetDistinctStrings(string strTable, string str1)
{
string strSQL = "select distinct '" + str1 + "' from " + strTable + " ";
return(ConnHelper.GetDistinceColoum(strSQL, str1));
}
/// <summary>
/// ！猜测代码
/// 获取指定表中的指定字段中的所有数据
/// 查询的字段拥有一个约束条件【字段约束】
/// 返回一个list，包含每一行的数据
/// </summary>
/// <param name="strTable">表名</param>
/// <param name="name1">字段</param>
/// <param name="name2">约束字段名</param>
/// <param name="data">约束字段的值</param>
/// <returns></returns>
public static List <string> GetDistinctString(string strTable, string name1, string name2, string data)
{
string strSQL = SQLFactory.BuildSQLSelectString(strTable, name1, name2, data);
return(ConnHelper.GetDistinceColoum(strSQL, name1));
}
public static List <string> GetDistinctStrings(string strTable, string str1, string str2, int str3)
{
string strSQL = "select distinct " + str1 + " from " + strTable + " where " + str2 + " = " + str3 + " ";
return(ConnHelper.GetDistinceColoum(strSQL, str1));
}
