/// <summary> /// 通过课程查看考试安排 /// </summary> /// <param name="courseNo">课程编号</param> /// <returns>课程安排数据集</returns> public ExamArrangeList GetExamArrangeByCourseNo(string courseNo) { ExamArrangeList examArrangeList = null; string cmdstring = "SELECT [examArrangeListId],[courseName],[examArrangeTime] ,[examArrageAddress],[remark] ,[teacherName] ,[courseNo] FROM [USTA].[dbo].[usta_ExamArrangeList] WHERE courseNo=@courseNo"; SqlParameter[] parameters = new SqlParameter[1]{ new SqlParameter("@courseNo",courseNo) }; SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, cmdstring, parameters); if (dr.Read()) examArrangeList = new ExamArrangeList { examArrangeListId = int.Parse(dr["examArrangeListId"].ToString()), courseName = dr["courseName"].ToString().Trim(), examArrangeTime = Convert.ToDateTime(dr["examArrangeTime"].ToString()), examArrageAddress = dr["examArrageAddress"].ToString(), remark = dr["remark"].ToString().Trim(), teacherName = dr["teacherName"].ToString().Trim(), courseNo = dr["courseNo"].ToString().Trim() }; dr.Close(); conn.Close(); return examArrangeList; }
/// <summary> ///将Excel表的信息数据保存到数据库 /// </summary> /// <param name="dt">文件名称</param> /// <param name="tableType">表类型</param> /// <returns>删除是否成功</returns> public int DataTabletoDBTables(DataTable dt,string tableType) { if (tableType.Equals("学生信息")) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { StudentsList student = new StudentsList(); student.studentNo = dt.Rows[i][1].ToString().Trim(); student.studentName = dt.Rows[i][2].ToString().Trim(); student.studentSpeciality = dt.Rows[i][3].ToString().Trim(); student.classNo = dt.Rows[i][4].ToString().Trim(); student.mobileNo = dt.Rows[i][5].ToString().Trim(); student.emailAddress = dt.Rows[i][6].ToString().Trim(); student.remark = dt.Rows[i][7].ToString().Trim(); student.studentUserPwd = student.studentNo;//密码默认与学号相同 this.AddStudent(student); } return dt.Rows.Count; } } else if (tableType.Equals("教师信息")) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { TeachersList teacher = new TeachersList(); teacher.teacherNo = dt.Rows[i][1].ToString().Trim(); teacher.teacherName = dt.Rows[i][2].ToString().Trim(); teacher.emailAddress = dt.Rows[i][3].ToString().Trim(); teacher.officeAddress = dt.Rows[i][4].ToString().Trim(); teacher.remark = dt.Rows[i][5].ToString().Trim(); teacher.teacherUserPwd = teacher.teacherNo;//密码默认与教师编号相同 this.AddTeacher(teacher); } return dt.Rows.Count; } } else if (tableType.Equals("助教信息")) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { AssistantsList assistant = new AssistantsList(); assistant.assistantNo = dt.Rows[i][1].ToString().Trim(); assistant.assistantName = dt.Rows[i][2].ToString().Trim(); assistant.emailAddress = dt.Rows[i][3].ToString().Trim(); assistant.officeAddress = dt.Rows[i][4].ToString().Trim(); assistant.remark = dt.Rows[i][5].ToString().Trim(); assistant.assistantUserPwd = assistant.assistantNo;//密码默认与助教编号相同 this.AddAssistant(assistant); } return dt.Rows.Count; } } else if (tableType.Equals("课程信息")) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Courses course = new Courses(); course.courseNo = dt.Rows[i][1].ToString().Trim(); course.courseName= dt.Rows[i][2].ToString().Trim(); course.period =dt.Rows[i][3].ToString().Trim(); course.credit=float.Parse( dt.Rows[i][4].ToString().Trim()); course.courseSpeciality= dt.Rows[i][5].ToString(); course.termTag =dt.Rows[i][6].ToString().Trim();//学期标识 new DalOperationAboutCourses().AddCourse(course); } return dt.Rows.Count; } } else if (tableType.Equals("考试安排")) { if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { ExamArrangeList examTime = new ExamArrangeList(); examTime.courseName= dt.Rows[i][1].ToString().Trim(); examTime.examArrangeTime =DateTime.Parse(dt.Rows[i][2].ToString().Trim()); examTime.examArrageAddress = dt.Rows[i][3].ToString().Trim(); examTime.remark =dt.Rows[i][4].ToString().Trim(); examTime.teacherName = dt.Rows[i][5].ToString(); examTime.courseNo= dt.Rows[i][6].ToString().Trim(); this.AddExamArrange(examTime); } return dt.Rows.Count; } } return 0; }
//---------------------------------------- /// <summary> /// 增加考试安排信息 /// </summary> /// <param name="examTime">考试安排信息</param> public void AddExamArrange(ExamArrangeList examTime) { try { string sql = "INSERT INTO usta_ExamArrangeList VALUES(@courseName,@examArrangeTime,@examArrageAddress,@remark, @teacherName,@courseNo)"; SqlParameter[] parameters = { new SqlParameter("@courseName", SqlDbType.NChar,50), new SqlParameter("@examArrangeTime", SqlDbType.DateTime), new SqlParameter("@examArrageAddress", SqlDbType.NChar,50), new SqlParameter("@remark", SqlDbType.NVarChar,500), new SqlParameter("@teacherName", SqlDbType.NChar,10), new SqlParameter("@courseNo", SqlDbType.NChar,20)}; parameters[0].Value = examTime.courseName; parameters[1].Value = examTime.examArrangeTime; parameters[2].Value = examTime.examArrageAddress; parameters[3].Value = examTime.remark; parameters[4].Value = examTime.teacherName; parameters[5].Value = examTime.courseNo; SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters); } catch (Exception ex) { MongoDBLog.LogRecord(ex); CommonUtility.RedirectUrl(); } finally { conn.Close(); } }