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(); } } }
private void InitialPWD()//密码加密 { List <string> str = new List <string>(); str = AddSQLStringToDAL.GetDistinctStrings("TabAllTeachers", "UserID"); for (int i = 0; i < str.Count; i++) { if (AddSQLStringToDAL.UpdateTabTeachers("TabAllTeachers", FormsAuthentication.HashPasswordForStoringInConfigFile(str[i].ToString(), "MD5").ToString(), str[i].ToString())) { lblMessage3.Text = "正在初始化密码..."; } } List <string> str1 = new List <string>(); str1 = AddSQLStringToDAL.GetDistinctStrings("TabAllTeachers", "UserID"); for (int i = 0; i < str1.Count; i++) { if (AddSQLStringToDAL.UpdateTabTeachers("TabTeachers", FormsAuthentication.HashPasswordForStoringInConfigFile(str[i].ToString(), "MD5").ToString(), str[i].ToString())) { lblMessage3.Text = "正在初始化密码..."; } } List <string> str2 = new List <string>(); str2 = AddSQLStringToDAL.GetDistinctStrings("TabAllTeachers", "UserID"); for (int i = 0; i < str2.Count; i++) { if (AddSQLStringToDAL.UpdateTabTeachers("TabOtherTeachers", PWDProcess.MD5Encrypt(str2[i].ToString(), PWDProcess.CreateKey(str2[i].ToString())), str2[i].ToString())) { lblMessage3.Text = "正在初始化密码..."; } } }
private void InsertTeacherStatus() { Clear(); List <string> str = new List <string>(); str = AddSQLStringToDAL.GetDistinctStrings("TabAllCourses", "TeacherID"); lblMessage3.Text = "第一步:教师信息对比完成!正在进行第二步..."; InsertCoursesSimpleMap(str); lblMessage3.Text = "所有信息核对无误!请对数据进行处理"; }
protected void btnOK_Click(object sender, EventArgs e) { if (chkToLeader.Checked == false && chkToSecretary.Checked == false && chkToTeacher.Checked == false) { lblMessage.Text = "请选中要发布通知的对象!"; } else { if (txtxMessage.Text == "") { lblMessage.Text = "通知不能为空!"; } else { List <string> strSum = new List <string>(); List <string> strID1 = new List <string>(); List <string> strID2 = new List <string>(); List <string> strID3 = new List <string>(); List <string> strID4 = new List <string>(); if (chkToLeader.Checked)//找出校领导ID { strID1 = AddSQLStringToDAL.GetDistinctStrings("TabTeachers", "UserID", "Role", 2); } if (chkToSecretary.Checked)//找出辅导员ID { strID2 = AddSQLStringToDAL.GetDistinctStrings("TabTeachers", "UserID", "Role", 3); } if (chkToTeacher.Checked)//找出所有有课教师的ID { strID3 = AddSQLStringToDAL.GetDistinctStrings("Tabteachers", "UserID"); } //将这三个找出来的全部放到strSum里 strSum.AddRange(strID1); strSum.AddRange(strID2); strSum.AddRange(strID3); //因为有课的教师也可能是辅导员或者校领导,所以移除相同的ID for (int i = 0; i < strSum.Count; i++) { for (int j = 0; j < strSum.Count; j++) { if (i != j) { if (strSum[i] == strSum[j]) { strSum.RemoveAt(j); } } } } if (strSum.Count > 0) { for (int i = 0; i < strSum.Count; i++) { if (AddSQLStringToDAL.InsertTabTeachers("TabMessage", System.DateTime.Now.ToString(), txtxMessage.Text.ToString(), strSum[i].ToString(), "false", "", "")) { } } lblMessage.Text = "消息发送成功!"; txtxMessage.Text = ""; } } } }