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