protected void ImageButton_delete_Click(object sender, ImageClickEventArgs e) { ImageButton imageButton = sender as ImageButton; string id = imageButton.CommandArgument; AttendanceBLL attendBLL = new AttendanceBLL(); CourseTableBLL ctBLL = new CourseTableBLL(); CourseTable ct = ctBLL.get(id); string filter = "courId='" + ct.CourId + "' and teachID='" + ct.TeachID + "' and classID='" + ct.ClassID; filter += "' and semester='" + ct.Semester + "' and weekDay='" + ct.WeekDay + "' and courseTime='" + ct.CourseTime + "'"; DataTable dt = PageUtil.getProcessedDataTable(ctBLL.getAll().Tables[0], filter, null, false); foreach (DataRow dr in dt.Rows) { attendBLL.deleteByCourseTableId(dr["ID"].ToString()); CourseTable tempCt = new CourseTable(); tempCt.Id = dr["ID"].ToString(); ctBLL.delete(tempCt); } Response.Write("<script>alert('删除成功!');location.href='showCourseTable.aspx';</script>"); }
protected void ImageButton_delete_Click(object sender, ImageClickEventArgs e) { ImageButton imageButton = sender as ImageButton; string id = imageButton.CommandArgument; AttendanceBLL attendBLL = new AttendanceBLL(); CourseTableBLL ctBLL = new CourseTableBLL(); CourseTable ct = ctBLL.get(id); string filter = "courId='" + ct.CourId + "' and teachID='" + ct.TeachID + "' and classID='" + ct.ClassID; filter += "' and semester='" + ct.Semester + "' and weekDay='" + ct.WeekDay + "' and courseTime='" + ct.CourseTime + "'"; DataTable dt = PageUtil.getProcessedDataTable(ctBLL.getAll().Tables[0], filter,null,false); foreach (DataRow dr in dt.Rows) { attendBLL.deleteByCourseTableId(dr["ID"].ToString()); CourseTable tempCt = new CourseTable(); tempCt.Id = dr["ID"].ToString(); ctBLL.delete(tempCt); } Response.Write("<script>alert('删除成功!');location.href='showCourseTable.aspx';</script>"); }
protected void Button_submit_Click(object sender, EventArgs e) { if (!checkEmpty()) { string userName = TextBox_userName.Text.Trim(); string password = TextBox_password.Text.Trim(); StaffBLL staffBLL = new StaffBLL(); UserBLL userBLL = new UserBLL(); User user = userBLL.getByUsername(userName); if (user != null) { //取得加密后的密码 string encryptPWD = EncryptUtil.MD5Encrypt(password); if (!user.Password.Equals(encryptPWD)) { //密码不匹配的情况 checkPassword.ErrorMessage = "密码输入错误!"; checkPassword.IsValid = false; } else { Staff staff = staffBLL.getByUserId(user.Id); if (staff != null && staff.Type.Equals("超级管理员")) { //用户检查通过的情况 AttendanceBLL attendBLL = new AttendanceBLL(); CourseTableBLL ctBLL = new CourseTableBLL(); string filter = "semester='" + GlobalVars.SEMESTER + "'"; DataTable dt = PageUtil.getProcessedDataTable(ctBLL.getAll().Tables[0], filter, null, false); foreach (DataRow dr in dt.Rows) { attendBLL.deleteByCourseTableId(dr["ID"].ToString()); } Response.Write("<script>alert('考勤初始化成功!');location.href='../mainPages/welcome.aspx';</script>"); } else { checkUsername.ErrorMessage = "该用户没有权限!"; checkUsername.IsValid = false; } } } else { checkUsername.ErrorMessage = "账号不存在!"; checkUsername.IsValid = false; } } }
protected void ImageButton_submit_Click(object sender, ImageClickEventArgs e) { if (check()) { AttendanceBLL attendBLL = new AttendanceBLL(); CourseTableBLL ctBLL = new CourseTableBLL(); string filter = "courId='" + ct.CourId + "' and teachID='" + ct.TeachID + "' and classID='" + ct.ClassID; filter += "' and semester='" + ct.Semester + "' and weekDay='" + ct.WeekDay + "' and courseTime='" + ct.CourseTime + "'"; #region 先删除旧数据 DataTable dt = PageUtil.getProcessedDataTable(ctBLL.getAll().Tables[0], filter, null, false); foreach (DataRow dr in dt.Rows) { attendBLL.deleteByCourseTableId(dr["ID"].ToString()); CourseTable tempCt = new CourseTable(); tempCt.Id = dr["ID"].ToString(); ctBLL.delete(tempCt); } #endregion #region 后添加新数据 string semester = DropDownList_semester_from.SelectedValue + "-" + DropDownList_semester_to.SelectedValue + "学年" + DropDownList_semester_end.SelectedValue; int week_from = Convert.ToInt32(DropDownList_week_from.SelectedValue); int week_to = Convert.ToInt32(DropDownList_week_to.SelectedValue); string weekDay = DropDownList_weekDay.SelectedValue; string place = TextBox_place.Text; string courseTime = DropDownList_courseTime.SelectedValue + "节"; string teachId = ct.TeachID; string classId = ct.ClassID; string courId = ct.CourId; CourseTable courTable = new CourseTable(); courTable.Semester = semester; courTable.WeekDay = weekDay; courTable.Place = place; courTable.CourseTime = courseTime; courTable.TeachID = teachId; courTable.ClassID = classId; courTable.CourId = courId; for (int i = week_from; i <= week_to; i++) { courTable.Week = i.ToString(); ctBLL.save(courTable); } #endregion Response.Write("<script>alert('修改成功!');location.href='showCourseTable.aspx';</script>"); } }
protected void ImageButton_submit_Click(object sender, ImageClickEventArgs e) { if (check()) { AttendanceBLL attendBLL = new AttendanceBLL(); CourseTableBLL ctBLL = new CourseTableBLL(); string filter = "courId='" + ct.CourId + "' and teachID='" + ct.TeachID + "' and classID='" + ct.ClassID; filter += "' and semester='" + ct.Semester + "' and weekDay='" + ct.WeekDay + "' and courseTime='" + ct.CourseTime + "'"; #region 先删除旧数据 DataTable dt = PageUtil.getProcessedDataTable(ctBLL.getAll().Tables[0], filter,null, false); foreach (DataRow dr in dt.Rows) { attendBLL.deleteByCourseTableId(dr["ID"].ToString()); CourseTable tempCt = new CourseTable(); tempCt.Id = dr["ID"].ToString(); ctBLL.delete(tempCt); } #endregion #region 后添加新数据 string semester = DropDownList_semester_from.SelectedValue + "-" + DropDownList_semester_to.SelectedValue + "学年" + DropDownList_semester_end.SelectedValue; int week_from = Convert.ToInt32(DropDownList_week_from.SelectedValue); int week_to = Convert.ToInt32(DropDownList_week_to.SelectedValue); string weekDay = DropDownList_weekDay.SelectedValue; string place = TextBox_place.Text; string courseTime = DropDownList_courseTime.SelectedValue + "节"; string teachId = ct.TeachID; string classId = ct.ClassID; string courId = ct.CourId; CourseTable courTable = new CourseTable(); courTable.Semester = semester; courTable.WeekDay = weekDay; courTable.Place = place; courTable.CourseTime = courseTime; courTable.TeachID = teachId; courTable.ClassID = classId; courTable.CourId = courId; for (int i = week_from; i <= week_to; i++) { courTable.Week = i.ToString(); ctBLL.save(courTable); } #endregion Response.Write("<script>alert('修改成功!');location.href='showCourseTable.aspx';</script>"); } }