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;//刷新后滚动条回到之前的位置,但是会导致页面闪烁
}
