protected void Page_Load(object sender, EventArgs e) { //页面载入之前,先进行登录检查以及权限检查 ScriptManager1.RegisterAsyncPostBackControl(this.DropDownList_Grade); // ScriptManager1.RegisterAsyncPostBackControl(this.lessLessonTime); if (!IsPostBack) // 如果是为响应客户端回发而加载该页,则为 true;否则为 false。 { if (!(LoginAndPermissionChecking.LoginChecking())) { Response.Redirect("/ErrorPage/error_NotLogin.aspx"); } if (!(LoginAndPermissionChecking.PermissionChecking(PermissionEnum.EducationDean))) { Response.Redirect("/ErrorPage/error_DeniedPermission.aspx"); } ListItem i1 = new ListItem(HttpUtility.HtmlDecode(" ") + "初一", "1"); ListItem i2 = new ListItem(HttpUtility.HtmlDecode(" ") + "初二", "2"); ListItem i3 = new ListItem(HttpUtility.HtmlDecode(" ") + "初三", "3"); DropDownList_Grade.Items.Add(i1);//这里这么做完全是为了显示的时候可以居中,没别的意思 DropDownList_Grade.Items.Add(i2); DropDownList_Grade.Items.Add(i3); SetItemForChoosableCourse(); } Page.MaintainScrollPositionOnPostBack = true; //刷新后滚动条回到之前的位置,但是会导致页面闪烁 // Page.MaintainScrollPositionOnPostBack = false;//刷新后滚动条回到顶部 SelectCourseByGrade(); //一开始显示默认的年级的科目 }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!(LoginAndPermissionChecking.LoginChecking())) { Response.Redirect("/ErrorPage/error_NotLogin.aspx"); } if (!(LoginAndPermissionChecking.PermissionChecking(PermissionEnum.AcademicDean))) { Response.Redirect("/ErrorPage/error_DeniedPermission.aspx"); } SetItemForDropDownList_Class(); } // object o = Session["HasShownTable"]; // if (o != null) //SetItemForDropDownList_Class(); /* * string select_class = "DropDownList_Class" + DropDownList_Grade.SelectedValue; * if (Session[select_class] == null) * { * Session[select_class] = 0; * } * else * { * // DropDownList_class.SelectedIndex = (int)Session[select_class]; * }*/ ShowClassTable(); // } }
/* * protected override void OnLoad(EventArgs e) * { * * } */ protected void Page_Load(object sender, EventArgs e) { //外部添加局部刷新控件 ScriptManager1.RegisterAsyncPostBackControl(this.DropDownList_Grade); ScriptManager1.RegisterAsyncPostBackControl(this.DropDownList_semester); ScriptManager1.RegisterAsyncPostBackControl(this.DropDownList_year); if (!IsPostBack) { if (!(LoginAndPermissionChecking.LoginChecking())) { Response.Redirect("/ErrorPage/error_NotLogin.aspx"); } if (!(LoginAndPermissionChecking.PermissionChecking(PermissionEnum.EducationDean))) { Response.Redirect("/ErrorPage/error_DeniedPermission.aspx"); } //首先先检查是否有gcgFeedBack这张表,如果不存在就新建 string sql_LookForgcgFeedBack = "select * from sysobjects where name = 'gcgFeedBack' and xtype = 'U'"; DBManipulation dbm = new DBManipulation(); object o = dbm.ExecuteScalar(sql_LookForgcgFeedBack, null); if (o == null) { string sql_CreategcgFeedBack = "create table gcgFeedBack(" + "class_id char(4) not null," + "CourseNo char(3) not null," + "TeacherNo char(8) not null," + "primary key(class_id, CourseNo)" + ")"; dbm.ExecuteNonQuery(sql_CreategcgFeedBack, null); } /*create table gcgFeedBack( --排课组内部专用表 * class_id char(4) not null, * CourseNo char(3) not null, * TeacherNo char(8) not null, * primary key(class_id,CourseNo) * )*/ //页面第一次载入之前,要查询gcgFeedBack授课安排反馈表,看看是不是还有未确认的反馈信息 string sql = "select class_id,CourseNo from gcgFeedBack"; // DBManipulation dbm = new DBManipulation(); SqlDataReader dr = dbm.ExecuteQueryOnLine(sql, null); while (dr.Read()) { string buttonName = dr.GetString(0) + dr.GetString(1); //Session[buttonName] = "nameRedButton";//我们使用Session保存有意见的老师安排的css样式 Session[buttonName] = "aspTableCellBrown2";//把原先红色的恢复成黑色 } dr.Close(); dbm.Close(); } createtable(GetSemesterNo()); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!(LoginAndPermissionChecking.LoginChecking())) { Response.Redirect("/ErrorPage/error_NotLogin.aspx"); } SetItemForDropDownList_Class(); } CreateTheWholeSchedule(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!(LoginAndPermissionChecking.LoginChecking())) { Response.Redirect("/ErrorPage/error_NotLogin.aspx"); } if (!(LoginAndPermissionChecking.PermissionChecking(PermissionEnum.CourseMaster))) { Response.Redirect("/ErrorPage/error_DeniedPermission.aspx"); } } Label_SubjectGroup.Text = Session["subjectGroupName"].ToString(); CreateTable(); }
private ArrayList DropDownLists = new ArrayList(); //存放所有供选择的学科组 protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!(LoginAndPermissionChecking.LoginChecking())) { Response.Redirect("/ErrorPage/error_NotLogin.aspx"); } if (!(LoginAndPermissionChecking.PermissionChecking(PermissionEnum.EducationDean))) { Response.Redirect("/ErrorPage/error_DeniedPermission.aspx"); } setItem_deleteDropDownList(); } Page.MaintainScrollPositionOnPostBack = true; //刷新后滚动条回到之前的位置,但是会导致页面闪烁 CreateTableDynamicly(); setItemsForSelectGroup(); //为每一个科目的可选学科组下拉框准备数据 }
protected void Page_Load(object sender, EventArgs e) { ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_11); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_12); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_21); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_22); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_31); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_32); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_41); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_42); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_51); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_52); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_61); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_62); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_71); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_72); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_81); ScriptManager1.RegisterAsyncPostBackControl(this.TextBox_82); //ScriptManager1.RegisterAsyncPostBackControl(this.DropDownList_Grade); //ScriptManager1.RegisterAsyncPostBackControl(this.DropDownList_Week); //不能使用UpdatePanel绑定两个下拉框,否则页面不会刷新。,这是为什么呢? // ScriptManager1.RegisterAsyncPostBackControl(this.Button_submit); if (!IsPostBack) {// 如果是为响应客户端回发而加载该页,则为 true;否则为 false。 // ScriptManager1.RegisterAsyncPostBackControl(this.Button_submit); if (!(LoginAndPermissionChecking.LoginChecking())) { Response.Redirect("/ErrorPage/error_NotLogin.aspx"); } if (!(LoginAndPermissionChecking.PermissionChecking(PermissionEnum.EducationDean))) { Response.Redirect("/ErrorPage/error_DeniedPermission.aspx"); } SetValueForHtmlTextBox(); } }
protected void Page_Load(object sender, EventArgs e) { //ScriptManager1.RegisterAsyncPostBackControl(this.DropDownList_Grade); ScriptManager1.RegisterAsyncPostBackControl(this.DropDownList_Course); ScriptManager1.RegisterAsyncPostBackControl(this.DropDownList_semester); ScriptManager1.RegisterAsyncPostBackControl(this.DropDownList_year); if (!IsPostBack) { if (!(LoginAndPermissionChecking.LoginChecking())) { Response.Redirect("/ErrorPage/error_NotLogin.aspx"); } if (!(LoginAndPermissionChecking.PermissionChecking(PermissionEnum.CourseMaster))) { Response.Redirect("/ErrorPage/error_DeniedPermission.aspx"); } Object o = Session["subjectGroupName"]; if (o == null) { Response.Redirect("/login/login.aspx"); } else { //Label_SubjectGroup.Text = Request.QueryString["subjectGroupName"].ToString(); Label_SubjectGroup.Text = Session["subjectGroupName"].ToString(); } ProvideDataForSelectSubject(); //页面刚刚载入的时候查询学科表中所有学科的对应课时数,并放置在一张学科课时表中,以待后面使用 string sql_MappingCourseNoAndCourseTime = "select CourseNo,CourseTime from gcgCourse"; DBManipulation dbm = new DBManipulation(); SqlDataReader dr = dbm.ExecuteQueryOnLine(sql_MappingCourseNoAndCourseTime, null); Dictionary <string, Byte> dict_CourseNo_CourseTime = new Dictionary <string, Byte>(); while (dr.Read()) { dict_CourseNo_CourseTime.Add(dr.GetString(0), dr.GetByte(1)); } dr.Close(); dbm.Close(); Cache["dict_CourseNo_CourseTime"] = dict_CourseNo_CourseTime; //同时计算所有老师的授课课时数,放在一个映射表中,以待后面使用 string sql_getTeacherSet = "select TeacherNo from temp_teacher"; DataSet ds = dbm.ExecuteQueryOffLine(sql_getTeacherSet, null); DataTable teacherTable = ds.Tables["defaultTable"]; Dictionary <string, int> dict_TeacherNo_CourseTime = new Dictionary <string, int>(); foreach (DataRow r in teacherTable.Rows) { string TeacherNo = r["TeacherNo"].ToString(); string sql_countTeacherTime = "select sum(CourseTime) from gcgLectureForm,temp_teacher,gcgCourse " + "where gcgLectureForm.TeacherNo = temp_teacher.TeacherNo " + "and gcgLectureForm.CourseNo = gcgCourse.CourseNo " + "and temp_teacher.TeacherNo = '" + TeacherNo + "'"; // DBManipulation dbm = new DBManipulation(); object obj = dbm.ExecuteScalar(sql_countTeacherTime, null); if (obj == null || obj.ToString() == "") {//还没有给这个老师安排带班 dict_TeacherNo_CourseTime[TeacherNo] = 0; } else { dict_TeacherNo_CourseTime[TeacherNo] = int.Parse(obj.ToString()); } } Cache["dict_TeacherNo_CourseTime"] = dict_TeacherNo_CourseTime; //保存每一个下拉菜单的索引值,方便下面进行课时计算 CreateTableBasedOnClass(); setDataForEachTeacherDropDownList(); foreach (DropDownList l in DropDownList_select) { Session[l.ID] = l.SelectedIndex;//使用对象的唯一标识符作为唯一ID保存 } } //debug1.Text = Request.QueryString["subjectGroupName"].ToString(); CreateTableBasedOnClass(); setDataForEachTeacherDropDownList(); // Page.MaintainScrollPositionOnPostBack = true;//刷新后滚动条回到之前的位置,但是会导致页面闪烁 }