/// <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;
}
