protected void btnAttdance_Click(object sender, EventArgs e)//上报 { StringBuilder strNO = new StringBuilder("未完成作业名单:"); int sum = 0; foreach (GridViewRow row in this.gvHomeworkDetails.Rows) { Control ctl2 = row.FindControl("rdoNO"); TableCellCollection cell = row.Cells; if ((ctl2 as RadioButton).Checked) { if (AddSQLStringToDAL.InsertTabTeachers("TabStudentHomework", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "未完成", "")) { sum++; strNO.Append(cell[3].Text.ToString() + ";");//添加上姓名 } } } if (strNO.ToString() == "未完成作业名单:") { strNO.Append("无"); } if (AddSQLStringToDAL.UpdateTabTeachers("TabTeacherAttendance", "Count", "已批改作业", "IsAttendance", "已考勤", "TeacherID", Session["UserID"].ToString(), "Course", Session["CurrentCourse"].ToString(), "CurrentWeek", (Convert.ToInt32(Session["CurrentWeek"].ToString()) - 1).ToString(), "Week", Session["Week"].ToString(), "Time", Session["Time"].ToString())) { lblHomeWorkMessage.Text = strNO.ToString(); lblResultMessage.Text = "本次作业记录已经上报成功!请返回主页面!"; btnClose.Visible = true; } gvHomeworkDetails.Visible = false; }
protected void Button5_Click(object sender, EventArgs e)//导入系部人数按钮 { if (TextBox1.Text != "" && TextBox2.Text != "" && TextBox3.Text != "" && TextBox4.Text != "" && TextBox5.Text != "" && TextBox6.Text != "" && TextBox7.Text != "") { string[] str = { "会计系", "信息工程系", "经济管理系", "食品工程系", "机械工程系", "商务外语系", "建筑工程系" }; int[] sum = new int[str.Length]; sum[0] = Convert.ToInt32(TextBox1.Text.Trim()); sum[1] = Convert.ToInt32(TextBox2.Text.Trim()); sum[2] = Convert.ToInt32(TextBox3.Text.Trim()); sum[3] = Convert.ToInt32(TextBox4.Text.Trim()); sum[4] = Convert.ToInt32(TextBox5.Text.Trim()); sum[5] = Convert.ToInt32(TextBox6.Text.Trim()); sum[6] = Convert.ToInt32(TextBox7.Text.Trim()); if (AddSQLStringToDAL.DeleteTabTeachers("TabDepartmentSum")) { } for (int i = 0; i < str.Length; i++) { if (AddSQLStringToDAL.InsertTabTeachers("TabDepartmentSum", str[i], sum[i].ToString())) { label6.Visible = true; label6.Text = "各系人数设置完毕!"; } } } else { label6.Visible = true; label6.Text = "部分系部人数未设置,请全部设置!"; } }
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 GetTeacherCourseSimpleMap() { DataTable dt = AddSQLStringToDAL.GetDataTableBysql("select * from TabTeacherCourseSimpleMap"); foreach (DataRow dr in dt.Rows) { string[] strT = dr["WeekRange"].ToString().Split(new char[] { ' ' }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < strT.Length; i++) { string WeekNumber = ""; string TeacherDepartment = dr["TeacherDepartment"].ToString(); string TeacherID = dr["TeacherID"].ToString(); string TeacherName = dr["TeacherName"].ToString(); string Week = dr["Week"].ToString(); switch (Week) { case "星期一": WeekNumber = "1"; break; case "星期二": WeekNumber = "2"; break; case "星期三": WeekNumber = "3"; break; case "星期四": WeekNumber = "4"; break; case "星期五": WeekNumber = "5"; break; case "星期六": WeekNumber = "6"; break; default: WeekNumber = "7"; break; } string Time = dr["Time"].ToString(); string Course = dr["Course"].ToString(); string Area = dr["Area"].ToString(); if (strT[i].Length == 1) { strT[i] = "0" + strT[i]; } if (AddSQLStringToDAL.InsertTabTeachers("TabTeacherAttendance", WeekNumber, TeacherDepartment, TeacherID, TeacherName, strT[i].ToString(), Week, Time, Course, Area, "未考勤", "", dr["WithoutWeek"].ToString(), "", "")) { } } lblMessage7.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 = ""; } } } }
protected void btnAttdance_Click(object sender, EventArgs e)//将非正常学生名单录入数据库 { StringBuilder strLate = new StringBuilder("迟到名单:"); StringBuilder strAbsence = new StringBuilder("旷课名单:"); StringBuilder strEarly = new StringBuilder("早退名单:"); StringBuilder strLeave = new StringBuilder("请假名单:"); int sum = 0; foreach (GridViewRow row in this.gvAttendanceDetails.Rows) { Control ctl2 = row.FindControl("rdoLate"); Control ctl3 = row.FindControl("rdoAbsence"); Control ctl4 = row.FindControl("rdoEarly"); Control ctl5 = row.FindControl("rdoLeave"); TableCellCollection cell = row.Cells; if ((ctl2 as RadioButton).Checked) { if (AddSQLStringToDAL.InsertTabTeachers("TabStudentAttendance", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "迟到", "")) { sum++; strLate.Append(cell[3].Text.ToString() + ";"); } } if ((ctl3 as RadioButton).Checked) { if (AddSQLStringToDAL.InsertTabTeachers("TabStudentAttendance", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "旷课", "")) { sum++; strAbsence.Append(cell[3].Text.ToString() + ";"); } } if ((ctl4 as RadioButton).Checked) { if (AddSQLStringToDAL.InsertTabTeachers("TabStudentAttendance", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "早退", "")) { sum++; strEarly.Append(cell[3].Text.ToString() + ";"); } } if ((ctl5 as RadioButton).Checked) { if (AddSQLStringToDAL.InsertTabTeachers("TabStudentAttendance", Session["UserID"].ToString(), Session["UserName"].ToString(), Session["CurrentCourse"].ToString(), Session["CurrentWeek"].ToString(), Session["Week"].ToString(), Session["Time"].ToString(), cell[0].Text.ToString(), cell[1].Text.ToString(), cell[2].Text.ToString(), cell[3].Text.ToString(), "请假", "")) { sum++; strLeave.Append(cell[3].Text.ToString() + ";"); } } } if (strLate.ToString() == "迟到名单:") { strLate.Append("无"); } if (strAbsence.ToString() == "旷课名单:") { strAbsence.Append("无"); } if (strEarly.ToString() == "早退名单:") { strEarly.Append("无"); } if (strLeave.ToString() == "请假名单:") { strLeave.Append("无"); } if (AddSQLStringToDAL.UpdateTabTeachers("TabTeacherAttendance", "IsAttendance", "已考勤", "Count", Session["Homework"].ToString(), "TeacherID", Session["UserID"].ToString(), "Course", Session["CurrentCourse"].ToString(), "CurrentWeek", Session["CurrentWeek"].ToString(), "Week", Session["Week"].ToString(), "Time", Session["Time"].ToString())) { lblAttendanceMessage.Text = strAbsence.ToString(); lblLateMessage.Text = strLate.ToString(); lblEarlyMessage.Text = strEarly.ToString(); lblLeaveMessage.Text = strLeave.ToString(); strLate.Remove(0, strLate.Length); strAbsence.Remove(0, strAbsence.Length); strEarly.Remove(0, strEarly.Length); strLeave.Remove(0, strLeave.Length); SetControlsVisibleFalse(); lblResultMessage.Text = "本次考勤记录已经上报成功!本次课您" + Session["Homework"].ToString() + ",请返回主页面!"; btnClose.Visible = true; } }