protected void Button2_Click(object sender, EventArgs e) {//删除一个学科组,先将组内的学科设为待定组 // string sql2 = "select subjectGroupNo,subjectGroupName from gcgSubjectGroup"; //string sql1 = "select subjectno from gcgSubject where subjectGroupNo in (select subjectGroupNo from gcgSubjectGroup where subjectGroupName = @subjectGroupName)"; string subjectGroupNo = DropDownList1.SelectedValue; DBManipulation dbm = new DBManipulation(); string sql1 = "select subjectGroupNo from gcgSubjectGroup where subjectGroupName = '待定'"; Object o = dbm.ExecuteScalar(sql1, null); string subjectGroup_DefalutNo = o.ToString(); string sql2 = "select subjectno from gcgSubject where subjectGroupNo ='" + subjectGroupNo + "'"; DataSet ds = dbm.ExecuteQueryOffLine(sql2, null); DataTable t = ds.Tables["defaultTable"]; foreach (DataRow r in t.Rows) { string subjectno = r["subjectno"].ToString(); string sql3 = "update gcgSubject set subjectGroupNo = @subjectGroupNo where subjectno = @subjectno"; ParameterStruct p1 = new ParameterStruct("@subjectGroupNo", subjectGroup_DefalutNo); ParameterStruct p2 = new ParameterStruct("@subjectno", subjectno); ArrayList p = new ArrayList(); p.Add(p1); p.Add(p2); dbm.ExecuteNonQuery(sql3, p); } string sql = "delete from gcgSubjectGroup where subjectGroupNo = '" + subjectGroupNo + "'"; dbm.ExecuteNonQuery(sql, null); setItem_deleteDropDownList();//为删除下拉框提供新的数据 this.Page_Load(this, null); }
protected void Button_submit_Click(object sender, EventArgs e) { //点击此按钮,清除该学科组收到的所有反馈信息 /*create table gcgFeedBack( --排课组内部专用表 * class_id char(4) not null, * CourseNo char(3) not null, * TeacherNo char(8) not null, * primary key(class_id,CourseNo) * )*/ string subjectGroupName = Label_SubjectGroup.Text; string sql0 = "select subjectGroupNo from gcgSubjectGroup where subjectGroupName ='" + subjectGroupName + "'"; DBManipulation dbm = new DBManipulation(); Object o = dbm.ExecuteScalar(sql0, null); if (o == null) { //说明没有这个学科组 System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('没有该学科组存在!')", true); //实际上是不可能的 return;//不再查询数据 } string subjectGroupNo = o.ToString(); dbm.Close(); string sql1 = "select CourseNo from gcgSubject,gcgCourse where gcgCourse.SubjectNo = gcgSubject.subjectno and Grade = @Grade and subjectGroupNo = @subjectGroupNo"; ParameterStruct p1 = new ParameterStruct("@Grade", DropDownList_Grade.SelectedValue); ParameterStruct p2 = new ParameterStruct("@subjectGroupNo", subjectGroupNo); ArrayList pList1 = new ArrayList(); pList1.Add(p1); pList1.Add(p2); SqlDataReader dr = dbm.ExecuteQueryOnLine(sql1, pList1); ArrayList courseNoList = new ArrayList(); while (dr.Read()) { courseNoList.Add(dr.GetString(0)); } dr.Close(); foreach (string courseno in courseNoList) { string sql_deletefromGcgFeedBack = "delete from gcgFeedBack where CourseNo = '" + courseno + "'"; dbm.ExecuteNonQuery(sql_deletefromGcgFeedBack, null); } //如果发现反馈表中已经没有了记录,那么就直接删掉,神不知鬼不觉~ string sql_checkgcgFeedBack = "select * from gcgFeedBack"; object isEmpty = dbm.ExecuteScalar(sql_checkgcgFeedBack, null); if (isEmpty == null) { //没有反馈记录了 string sql_droptable = "drop table gcgFeedBack"; dbm.ExecuteNonQuery(sql_droptable, null); } dbm.Close(); System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('已清除反馈信息!')", true); CreateTable(); }
protected void ButtonDelete_Click(object sender, EventArgs e) { Button b = (Button)sender; string ButtonID = b.ID; int i; for (i = 0; i < ButtonLists.Count; i++) { Button b1 = (Button)ButtonLists[i]; if (ButtonID.Equals(b1.ID)) { break; } } TableCell t = (TableCell)TableCellLists[i]; string courseName = t.Text; string grade = DropDownList_Grade.SelectedValue; string sql1 = "select subjectno from gcgSubject where subjectname ='" + courseName + "'"; DBManipulation dbm = new DBManipulation(); Object o = dbm.ExecuteScalar(sql1, null); if (o != null) { string subjectno = o.ToString(); string sql2 = "delete from gcgCourse where SubjectNo ='" + subjectno + "' and Grade ='" + grade + "'"; dbm.ExecuteNonQuery(sql2, null); } dbm.Close(); SetItemForChoosableCourse(); this.Page_Load(this, null); }
protected void Button1_Click(object sender, EventArgs e) { //点击增加科目 //从年级已知,科目号和科目名已知,默认课时为0 string grade = DropDownList_Grade.SelectedValue; string subjectno = DropDownList2.SelectedValue; if (subjectno == "") //当下拉框已经没有可增加科目时,按钮点击无效 { return; } string CourseNo = grade + subjectno; string courseCount = "0"; DBManipulation dbm = new DBManipulation(); string sql2 = "insert into gcgCourse values(@CourseNo,@SubjectNo,@Grade,@CourseTime)"; ParameterStruct p3 = new ParameterStruct("@CourseNo", CourseNo + ""); ParameterStruct p4 = new ParameterStruct("@SubjectNo", subjectno); ParameterStruct p5 = new ParameterStruct("@Grade", grade + ""); ParameterStruct p6 = new ParameterStruct("@CourseTime", courseCount + ""); ArrayList parameterList2 = new ArrayList(); parameterList2.Add(p3); parameterList2.Add(p4); parameterList2.Add(p5); parameterList2.Add(p6); dbm.ExecuteNonQuery(sql2, parameterList2); dbm.Close(); SetItemForChoosableCourse(); this.Page_Load(this, null); // Response.Redirect("classTimesArrange.aspx"); }
protected void Button_submit_Click(object sender, EventArgs e) { //点击确认,提交课时安排 //通过 TableCellLists DropDownLists获得每一条记录的科目名以及课时,通过DropDownList_Grade获得年级 //步骤:一条一条来看,如果原先有课时安排的,就更新,没有的,就插入 string grade = DropDownList_Grade.SelectedValue; DBManipulation dbm = new DBManipulation(); // Response.Write("<script>alert('有新"+ HasNewCourse+" ')</script>"); for (int i = 0; i < DropDownLists.Count; i++) { //步骤一:查询这门科目是否有过旧的课时安排记录 //注意:一开始没有学科,所以要通过按钮增加学科,此时会保证所有记录都有初始课时分布,所以提交按钮仅仅需要将这些记录更新就行了 TableCell tc = (TableCell)TableCellLists[i]; DropDownList ddl = (DropDownList)DropDownLists[i]; string courseName = tc.Text; //获得科目名 string courseCount = ddl.SelectedValue; //获得新的分配课时 string SearchSql = "select CourseNo from gcgCourse,gcgSubject where gcgSubject.subjectno = gcgCourse.SubjectNo and Grade = @Grade and subjectname = @subjectname"; ParameterStruct p1 = new ParameterStruct("@Grade", grade); ParameterStruct p2 = new ParameterStruct("@subjectname", courseName); ArrayList parameterList1 = new ArrayList(); parameterList1.Add(p1); parameterList1.Add(p2); Object o = dbm.ExecuteScalar(SearchSql, parameterList1); string CourseNo = o.ToString(); string sql4 = "update gcgCourse set CourseTime = " + courseCount + " where CourseNo = " + CourseNo; dbm.ExecuteNonQuery(sql4, null); } dbm.Close(); System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('提交已完成!')", true); }
protected void Button_AddSubjectGroup_Click(object sender, EventArgs e) {//增加学科组 string subjectGroupName = TextBox_SubjectGroup.Text; string subjectGroupId; DBManipulation dbm = new DBManipulation(); string sql1 = "select subjectGroupNo from gcgSubjectGroup order by subjectGroupNo"; DataSet ds_subjectGroup = dbm.ExecuteQueryOffLine(sql1, null); int i = 0, j; bool mark = true; //一个标志量 for (i = 1; i < 90; i++) //学科组号仅有2位 { mark = true; for (j = 0; j < ds_subjectGroup.Tables["defaultTable"].Rows.Count; j++) { string str = ds_subjectGroup.Tables["defaultTable"].Rows[j]["subjectGroupNo"].ToString(); char[] ch = str.ToCharArray(); if (ch[0] == '0') { str = ch[1] + ""; } if (i == int.Parse(str)) { mark = false; break; } } if (mark) //如果没有任何一个id相等,那么这个就是可用id { break; } } if (i < 10) { subjectGroupId = "0" + i; } else { Response.Write("<script>alert('i > 10')</script>"); subjectGroupId = i + ""; } string sql2 = "insert into gcgSubjectGroup values(@subjectGroupNo,@subjectGroupName,null)"; ParameterStruct p1 = new ParameterStruct("@subjectGroupNo", subjectGroupId); ParameterStruct p2 = new ParameterStruct("@subjectGroupName", subjectGroupName); ArrayList parameterlist = new ArrayList(); parameterlist.Add(p1); parameterlist.Add(p2); debug1.Text = subjectGroupId; debug2.Text = subjectGroupName; dbm.ExecuteNonQuery(sql2, parameterlist); CreateTableDynamicly(); //生成表 setItemsForSelectGroup(); //为每一个科目的可选学科组下拉框准备数据 setItem_deleteDropDownList(); //为删除下拉框生成数据 TextBox_SubjectGroup.Text = ""; }
/* * 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 ButtonForFeedBack_onClick(object sender, EventArgs e) { MyButton button = (MyButton)sender; string buttonName = button.Class_id + button.CourseNo1; if (Session[buttonName] == null || Session[buttonName].ToString().Equals("aspTableCell")) { Session[buttonName] = "aspTableCellBrown2";//用session记录这个Button被点击过 //插入反馈记录 /*create table gcgFeedBack( * class_id char(4) not null, * CourseNo char(3) not null, * TeacherNo char(8) not null, * primary key(class_id,CourseNo) * )*/ string sql = "insert into gcgFeedBack values(@class_id,@CourseNo,@TeacherNo)"; ParameterStruct p_classid = new ParameterStruct("@class_id", button.Class_id); ParameterStruct p_courseno = new ParameterStruct("@CourseNo", button.CourseNo1); ParameterStruct p_teacherno = new ParameterStruct("@TeacherNo", button.TeacherNo1); ArrayList plist = new ArrayList(); plist.Add(p_classid); plist.Add(p_courseno); plist.Add(p_teacherno); DBManipulation dbm = new DBManipulation(); try { dbm.ExecuteNonQuery(sql, plist); } catch (Exception) { } } else { Session[buttonName] = "aspTableCell"; string sql = "delete from gcgFeedBack where class_id = @class_id and CourseNo = @CourseNo"; ParameterStruct p_classid = new ParameterStruct("@class_id", button.Class_id); ParameterStruct p_courseno = new ParameterStruct("@CourseNo", button.CourseNo1); //ParameterStruct p_teacherno = new ParameterStruct("@TeacherNo", button.TeacherNo1); ArrayList plist = new ArrayList(); plist.Add(p_classid); plist.Add(p_courseno); //plist.Add(p_teacherno); DBManipulation dbm = new DBManipulation(); dbm.ExecuteNonQuery(sql, plist); // Session.Remove(name); } createtable(GetSemesterNo()); }
protected void ButtonSubmit_Click(object sender, EventArgs e) { string subjectGroupNo; string subjectNo; DBManipulation dbm = new DBManipulation(); for (int i = 0; i < TableCellLists.Count; i++) { TableCell c = (TableCell)TableCellLists[i]; DropDownList d = (DropDownList)DropDownLists[i]; subjectNo = (string)SubjectnoLists[i]; subjectGroupNo = d.SelectedValue; string sql = "update gcgSubject set subjectGroupNo = @subjectGroupNo where subjectno = @subjectno"; ParameterStruct p1 = new ParameterStruct("@subjectGroupNo", subjectGroupNo); ParameterStruct p2 = new ParameterStruct("@subjectno", subjectNo); ArrayList parameterlist = new ArrayList(); parameterlist.Add(p1); parameterlist.Add(p2); dbm.ExecuteNonQuery(sql, parameterlist); } System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('修改已完成!')", true); }
protected void Button_SubmitSchedule_Click(object sender, EventArgs e) { if (Cache["auto"] == null) { System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('请先生成课表。')", true); //Response.Write("<script>alert('请先生成课表。')</script>"); return; } string lessonTableName = "LessonTable" + DropDownList_Grade.SelectedValue; if (Cache[lessonTableName] == null) { System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('请先生成课表。')", true); return; } string dict_CourseNo_SubjectName_Name = "dict_CourseNo_SubjectName" + DropDownList_Grade.SelectedValue; if (Cache[dict_CourseNo_SubjectName_Name] == null) { System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('请先生成课表。')", true); return; } string dict_SubjectName_CourseNo_Name = "dict_SubjectName_CourseNo" + DropDownList_Grade.SelectedValue; if (Cache[dict_SubjectName_CourseNo_Name] == null) { System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('请先生成课表。')", true); return; } string dict_ClassName_ClassNo_Name = "dict_ClassName_ClassNo" + DropDownList_Grade.SelectedValue; if (Cache[dict_ClassName_ClassNo_Name] == null) { System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('请先生成课表。')", true); return; } Dictionary <string, string> dict_SubjectName_CourseNo = (Dictionary <string, string>)Cache[dict_SubjectName_CourseNo_Name]; Dictionary <string, string> dict_CourseNo_SubjectName = (Dictionary <string, string>)Cache[dict_CourseNo_SubjectName_Name]; Dictionary <string, string> dict_ClassName_ClassNo = (Dictionary <string, string>)Cache[dict_ClassName_ClassNo_Name]; Tea[,] Lessontable = (Tea[, ])Cache[lessonTableName]; //以上已获得某一个年级的全部课表,老师号-科目名映射,学科号-科目名映射,班级名和班级号映射 /* * create table gcgLectureForm(--授课安排表 * LectureNo char(7) primary key,--授课安排编号 * SemesterNo char(6),--学期号,蕴含年份和上下学期信息 * TeacherNo char(8),--教师工号 * CourseNo char(3) foreign key references gcgcourse(CourseNo),--学科编号 * ClassNo char(4)--班级编号 * ) * create table gcgLesson(--课表 * LectureNo char(7) foreign key references gcgLectureForm(LectureNo),--授课安排编号 * --ClassRoomNo char(*) * Timeid char(4) foreign key references gcgSchedule(Timeid),--时间段编号 * primary key(LectureNo,Timeid)--表级主码 * ) */ string sql_forSemester = "select MAX(SemesterNo) from gcgLectureForm "; DBManipulation dbm = new DBManipulation(); object o = dbm.ExecuteScalar(sql_forSemester, null); string semesterNo = o.ToString(); string grade = DropDownList_Grade.SelectedValue; string sql_deleteTheSameSemesterRecord = "delete from gcgLesson where LectureNo in ( select LectureNo from gcgLectureForm,temp_class where gcgLectureForm.ClassNo = temp_class.class_id and class_grade = @Grade and SemesterNo = @SemesterNo)"; ParameterStruct p_grade = new ParameterStruct("@Grade", grade); ParameterStruct p_seme = new ParameterStruct("@SemesterNo", semesterNo); ArrayList palist = new ArrayList(); palist.Add(p_grade); palist.Add(p_seme); dbm.ExecuteNonQuery(sql_deleteTheSameSemesterRecord, palist); /*string sql_MappingClassNameAndClassNo = * " select class_name,class_id * from temp_class,( * select distinct ClassNo * from gcgLectureForm * where SemesterNo = ( * select MAX(SemesterNo) * from gcgLectureForm)) AS temp * where class_id = ClassNo and class_grade = '" + DropDownList_Grade.SelectedValue + "'"; */ string sql_forClassNo = "select class_id from temp_class,(select distinct ClassNo from gcgLectureForm where SemesterNo = (select MAX(SemesterNo) from gcgLectureForm)) AS temp where class_id = ClassNo and class_grade = '" + DropDownList_Grade.SelectedValue + "'"; ArrayList classlist = new ArrayList(); SqlDataReader dr = dbm.ExecuteQueryOnLine(sql_forClassNo, null); while (dr.Read()) { classlist.Add(dr.GetString(0)); } dr.Close(); for (int i = 0; i < classlist.Count; i++) {//一个一个班的写入 //[,]Lessontable一行就存放了一个班的所有记录 Tea[] classTable = new Tea[Lessontable.GetLength(1) + 1]; string[] courseTable = new string[Lessontable.GetLength(1) + 1]; for (int t = 0; t < 40; t++) { classTable[t] = Lessontable[i + 1, t + 1]; //取到某一个班40节课的所有教师工号 string subjectname = dict_CourseNo_SubjectName[classTable[t].cno]; courseTable[t] = dict_SubjectName_CourseNo[subjectname]; //取到这四十节课的学科号 } for (int t = 0; t < 40; t++) { //classlist[i-1]就是对应的班级号 string sql_forLectureID = "select LectureNo from gcgLectureForm where SemesterNo = @SemesterNo and ClassNo = @ClassNo and CourseNo = @CourseNo"; ParameterStruct p_semester = new ParameterStruct("@SemesterNo", semesterNo); ParameterStruct p_classNo = new ParameterStruct("@ClassNo", (string)classlist[i]);//第i个班级的班级号 ParameterStruct p_courseNo = new ParameterStruct("@CourseNo", courseTable[t]); ArrayList plist = new ArrayList(); plist.Add(p_semester); plist.Add(p_classNo); plist.Add(p_courseNo); Object lectureID = dbm.ExecuteScalar(sql_forLectureID, plist); //string Timeid1 = grade + week + "0" + "1"; string Time_part1 = DropDownList_Grade.SelectedValue; int week = 0; string Time_part3; int temp = t + 1; if (temp % 8 == 0) { week = temp / 8; Time_part3 = "0" + 8; } else { week = temp / 8 + 1; Time_part3 = "0" + (temp - (week - 1) * 8); } string Time_part2 = week + ""; // string Time_part3 = "0" + (t - (t / 8) * 8); string sql_insert = "insert into gcgLesson values(@lectureID,@TimeID)"; ParameterStruct p_LectureID = new ParameterStruct("@lectureID", lectureID.ToString()); ParameterStruct p_timeID = new ParameterStruct("@TimeID", Time_part1 + Time_part2 + Time_part3);//第i个班级的班级号 ArrayList plist1 = new ArrayList(); plist1.Add(p_LectureID); plist1.Add(p_timeID); dbm.ExecuteNonQuery(sql_insert, plist1); } } dbm.Close(); System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('课表已保存!')", true); }
protected void Update() { // Response.Write("<script>alert('nihao')</script>"); int i; ArrayList startTime = new ArrayList(); ArrayList endTime = new ArrayList(); DBManipulation dbm = new DBManipulation(); string grade = DropDownList_Grade.SelectedValue; string week = DropDownList_Week.SelectedValue; string sql1 = "delete from gcgSchedule where Grade = @Grade and DayNo =@DayNo"; ParameterStruct p1 = new ParameterStruct("@Grade", grade); ParameterStruct p2 = new ParameterStruct("@DayNo", week); ArrayList plist1 = new ArrayList(); plist1.Add(p1); plist1.Add(p2); dbm.ExecuteNonQuery(sql1, plist1); string starttime1 = TextBox_11.Text; string endtime1 = TextBox_12.Text; string Timeid1 = grade + week + "0" + "1"; string[] stime1 = starttime1.Split(':'); string[] etime1 = endtime1.Split(':'); string sql11 = "insert into gcgSchedule values('" + Timeid1 + "'," + week + "," + grade + "," + 1 + "," + stime1[0] + "," + etime1[0] + "," + stime1[1] + "," + etime1[1] + ")"; dbm.ExecuteNonQuery(sql11, null); string starttime2 = TextBox_21.Text; string endtime2 = TextBox_22.Text; string Timeid2 = grade + week + "0" + "2"; string[] stime2 = starttime2.Split(':'); string[] etime2 = endtime2.Split(':'); string sql112 = "insert into gcgSchedule values('" + Timeid2 + "'," + week + "," + grade + "," + 1 + "," + stime2[0] + "," + etime2[0] + "," + stime2[1] + "," + etime2[1] + ")"; dbm.ExecuteNonQuery(sql112, null); string starttime3 = TextBox_31.Text; string endtime3 = TextBox_32.Text; string Timeid3 = grade + week + "0" + "3"; string[] stime3 = starttime3.Split(':'); string[] etime3 = endtime3.Split(':'); string sql113 = "insert into gcgSchedule values('" + Timeid3 + "'," + week + "," + grade + "," + 1 + "," + stime3[0] + "," + etime3[0] + "," + stime3[1] + "," + etime3[1] + ")"; dbm.ExecuteNonQuery(sql113, null); string starttime4 = TextBox_41.Text; string endtime4 = TextBox_42.Text; string Timeid4 = grade + week + "0" + "4"; string[] stime4 = starttime4.Split(':'); string[] etime4 = endtime4.Split(':'); string sql114 = "insert into gcgSchedule values('" + Timeid4 + "'," + week + "," + grade + "," + 1 + "," + stime4[0] + "," + etime4[0] + "," + stime4[1] + "," + etime4[1] + ")"; dbm.ExecuteNonQuery(sql114, null); string starttime5 = TextBox_51.Text; string endtime5 = TextBox_52.Text; string Timeid5 = grade + week + "0" + "5"; string[] stime5 = starttime5.Split(':'); string[] etime5 = endtime5.Split(':'); string sql115 = "insert into gcgSchedule values('" + Timeid5 + "'," + week + "," + grade + "," + 1 + "," + stime5[0] + "," + etime5[0] + "," + stime5[1] + "," + etime5[1] + ")"; dbm.ExecuteNonQuery(sql115, null); string starttime6 = TextBox_61.Text; string endtime6 = TextBox_62.Text; string Timeid6 = grade + week + "0" + "6"; string[] stime6 = starttime5.Split(':'); string[] etime6 = endtime6.Split(':'); string sql116 = "insert into gcgSchedule values('" + Timeid6 + "'," + week + "," + grade + "," + 1 + "," + stime6[0] + "," + etime6[0] + "," + stime6[1] + "," + etime6[1] + ")"; dbm.ExecuteNonQuery(sql116, null); string starttime7 = TextBox_71.Text; string endtime7 = TextBox_72.Text; string Timeid7 = grade + week + "0" + "7"; string[] stime7 = starttime6.Split(':'); string[] etime7 = endtime7.Split(':'); string sql117 = "insert into gcgSchedule values('" + Timeid7 + "'," + week + "," + grade + "," + 1 + "," + stime7[0] + "," + etime7[0] + "," + stime7[1] + "," + etime7[1] + ")"; dbm.ExecuteNonQuery(sql117, null); string starttime8 = TextBox_81.Text; string endtime8 = TextBox_82.Text; string Timeid8 = grade + week + "0" + "8"; string[] stime8 = starttime7.Split(':'); string[] etime8 = endtime8.Split(':'); string sql118 = "insert into gcgSchedule values('" + Timeid8 + "'," + week + "," + grade + "," + 1 + "," + stime8[0] + "," + etime8[0] + "," + stime8[1] + "," + etime8[1] + ")"; dbm.ExecuteNonQuery(sql118, null); }
protected void Button_submit_Click(object sender, EventArgs e) { //点击确认按钮,写入数据库 //首先检查是否该年级该门学科所有班级都已经分配了老师,如果没有,则不允许插入,并弹窗提醒 foreach (DropDownList d in DropDownList_select) { if (d.SelectedValue == "-1") { System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('尚未完成所有班级的教师安排!')", true); return; } } // Response.Write("<script>alert('aaa')</script>"); string year = DropDownList_year.SelectedValue; string semester = DropDownList_semester.SelectedValue; string semesterNo = year + semester; //得到学期号 DBManipulation dbm = new DBManipulation(); string sql1 = "select class_id,class_name from temp_class where class_grade = '" + DropDownList_Grade.SelectedValue + "'"; DataSet ds_class = dbm.ExecuteQueryOffLine(sql1, null); DataTable classTable = ds_class.Tables["defaultTable"]; for (int i = 0; i < TableCellList_class.Count; i++) { TableCell tc = (TableCell)TableCellList_class[i]; string className = tc.Text; string classNo = ""; //查询班级编号 foreach (DataRow r in classTable.Rows) { if (className.Equals(r["class_name"].ToString())) { classNo = r["class_id"].ToString(); break; } } DropDownList d = (DropDownList)DropDownList_select[i]; string TeacherNo = d.SelectedValue; /* * if (TeacherNo.Equals("-1")) {//如果教师号为-1,说明还没有安排老师,不写入 * continue; * } */ //得到教师工号 string courseNo = DropDownList_Course.SelectedValue; //得到学科号 /*主码,前2位代表年份,一位代表年级+学期(初一1,2 初二3,4 初三5,6),2位代表班级,2位代表学科*/ string LectureNo_part1 = year.Substring(2); string LectureNo_part2 = ""; switch (DropDownList_Grade.SelectedValue) { case "1": { if (DropDownList_semester.SelectedValue.Equals("01")) { LectureNo_part2 = "1"; } else { LectureNo_part2 = "2"; } break; } case "2": { if (DropDownList_semester.SelectedValue.Equals("01")) { LectureNo_part2 = "3"; } else { LectureNo_part2 = "4"; } break; } case "3": { if (DropDownList_semester.SelectedValue.Equals("01")) { LectureNo_part2 = "5"; } else { LectureNo_part2 = "6"; } break; } } /*主码,前2位代表年份,一位代表年级+学期(初一1,2 初二3,4 初三5,6),2位代表班级,2位代表学科*/ string LectureNo_part3 = classNo.Substring(2); string LectureNo_part4 = courseNo.Substring(1); string LectureNo = LectureNo_part1 + LectureNo_part2 + LectureNo_part3 + LectureNo_part4; //得到授课记录主码 //查询gcgLectureForm看是不是已经记录了这条记录,如果存在,则删除 string sql3 = "select * from gcgLectureForm where LectureNo ='" + LectureNo + "'"; Object o = dbm.ExecuteScalar(sql3, null); if (o != null) { string sql4 = "delete from gcgLectureForm where LectureNo ='" + LectureNo + "'"; dbm.ExecuteNonQuery(sql4, null); } /*create table gcgLectureForm(--授课安排表 * LectureNo char(7) primary key,--授课安排编号 * SemesterNo char(6),--学期号 201601 * TeacherNo char(8),--教师工号 * CourseNo char(3) ,--学科编号 * ClassNo char(4)--班级编号 * )*/ string sql2 = "insert into gcgLectureForm values(@LectureNo,@SemesterNo,@TeacherNo,@CourseNo,@ClassNo)"; ParameterStruct p1 = new ParameterStruct("@LectureNo", LectureNo); ParameterStruct p2 = new ParameterStruct("@SemesterNo", semesterNo); ParameterStruct p3 = new ParameterStruct("@TeacherNo", TeacherNo); ParameterStruct p4 = new ParameterStruct("@CourseNo", courseNo); ParameterStruct p5 = new ParameterStruct("@ClassNo", classNo); ArrayList plist1 = new ArrayList(); plist1.Add(p1); plist1.Add(p2); plist1.Add(p3); plist1.Add(p4); plist1.Add(p5); dbm.ExecuteNonQuery(sql2, plist1); } System.Web.UI.ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "Button6_Click", "alert('修改已完成!')", true); }