/// <summary> /// 根据teacherNo和courseNo查询当前学期该教师对此门课程的任课类型 /// </summary> /// <returns></returns> public CoursesTeachersCorrelation GetCoursesTypeTeacher(string teacherNo, string courseNo, string classId) { CoursesTeachersCorrelation ctCorrelation = null; if(string.IsNullOrWhiteSpace(teacherNo) || string.IsNullOrWhiteSpace(courseNo)){ return ctCorrelation; } string commandString = "SELECT atCourseType FROM usta_CoursesTeachersCorrelation WHERE teacherNo = @teacherNo AND courseNo = @courseNo AND classID = @classId AND termTag = @termTag"; SqlParameter[] parameters = new SqlParameter[]{ new SqlParameter("@teacherNo", teacherNo), new SqlParameter("@courseNo", courseNo), new SqlParameter("@termTag", termTag), new SqlParameter("@classId", classId) }; IDataReader reader = SqlHelper.ExecuteReader(conn, CommandType.Text, commandString, parameters); if(reader.Read()){ int atCourseType = int.Parse(reader["atCourseType"].ToString().Trim()); ctCorrelation = new CoursesTeachersCorrelation() { atCourseType = atCourseType }; } return ctCorrelation; }
/// <summary> /// 根据工作薄的名称判断进行对应实体类数据的封装 /// </summary> /// <param name="sheetName">工作薄名称</param> /// <param name="list">具体实体类项目的集合</param> /// <returns>返回封装后的实体类数据</returns> public static object ReturnModelDataJudgeBySheetName(string sheetName, List<string> list) { object modelClassCorrelationSheet = null; switch (sheetName) { case "Sheet1": modelClassCorrelationSheet = new TeachersList { teacherNo = list[0], teacherName = list[1], emailAddress = list[2], officeAddress = list[3], remark = list[4], teacherUserPwd = list[5] }; break; case "Sheet2": modelClassCorrelationSheet = new AssistantsList { assistantNo = list[0], assistantName = list[1], emailAddress = list[2], officeAddress = list[3], remark = list[4], assistantUserPwd = list[5] }; break; case "Sheet3": modelClassCorrelationSheet = new StudentsList { studentNo = list[0], studentName = list[1], studentSpeciality = list[2], classNo = list[3], mobileNo = list[4], emailAddress = list[5], remark = list[6], studentUserPwd = list[7] }; break; case "Sheet4": modelClassCorrelationSheet = new TermTags { termTag = list[0] }; break; case "Sheet5": modelClassCorrelationSheet = new Courses { courseNo = list[0], courseName = list[1], period = list[2], credit = float.Parse(list[3]), courseSpeciality = list[4], termTag = list[5], preCourse = string.Empty, referenceBooks = string.Empty, attachmentIds = string.Empty }; break; case "Sheet6": modelClassCorrelationSheet = new CoursesTeachersCorrelation { teacherNo = list[0], courseNo = list[1] }; break; case "Sheet7": modelClassCorrelationSheet = new CoursesAssistantsCorrelation { assistantNo = list[0], courseNo = list[1] }; break; case "Sheet8": modelClassCorrelationSheet = new CoursesStudentsCorrelation { studentNo = list[0], courseNo = list[1] }; break; default: break; } return modelClassCorrelationSheet; }