public IList <Teacher_course> SelectCourseList(string courseType, string collegeId)
{
string collegeSql = " ";
if (collegeId != null && !"".Equals(collegeId))
{
collegeSql = " college_id='" + collegeId + "' and ";
}
int currentYear = DateTime.Now.Year % 100;
int currentMonth = DateTime.Now.Month;
string opentime = currentYear + ((currentMonth >= 7) ? "02" : "01");
string sql = "select * from Teacher_course where " + collegeSql + " course_id in (select course_id from Course where course_type=@courseType and course_opentime=@opentime)";
SqlParameter[] pars =
{
new SqlParameter("@courseType", courseType),
new SqlParameter("@opentime", opentime)
};
DataTable dataTable = DBUtils.getDBUtils().getRecords(sql, pars);
IList <Teacher_course> courseList = new List <Teacher_course>();
foreach (DataRow row in dataTable.Rows)
{
Teacher_course course = new Teacher_course();
BeanUils.SetStringValues(course, row);
if (row["status"] != null)
{
course.status = Convert.ToInt32(row["status"]);
}
courseList.Add(course);
}
return(courseList);
}
public IList <Teacher_course> SelectAllCourse(string teacher_id)
{
string sql = "select * from Teacher_course where teacher_id = @teacher_id";
SqlParameter[] pars = { new SqlParameter("@teacher_id", teacher_id) };
DataTable dataTable = DBUtils.getDBUtils().getRecords(sql, pars);
IList <Teacher_course> CourseList = new List <Teacher_course>();
foreach (DataRow dataRow in dataTable.Rows)
{
Teacher_course course = new Teacher_course {
teacher_course_id = dataRow["teacher_course_id"].ToString(),
course_id = dataRow["course_id"].ToString(),
course_name = dataRow["course_name"].ToString(),
teacher_id = dataRow["teacher_id"].ToString(),
teacher_name = dataRow["teacher_name"].ToString(),
_class = dataRow["class"].ToString(),
class_id = dataRow["class_id"].ToString(),
grade = dataRow["grade"].ToString(),
department = dataRow["department"].ToString(),
college_id = dataRow["college_id"].ToString(),
major = dataRow["major"].ToString(),
major_id = dataRow["major_id"].ToString(),
course_credit = Convert.ToDecimal(dataRow["course_credit"]),
classroom_id = dataRow["classroom_id"].ToString(),
status = Convert.ToInt32(dataRow["status"]),
yuliu1 = dataRow["yuliu1"].ToString(),
yuliu2 = dataRow["yuliu2"].ToString()
};
CourseList.Add(course);
}
return(CourseList);
}
public IList <Teacher_course> SelectCourseList(string courseType, string collegeId)
{
string collegeSql = " ";
if (collegeId != null && !"".Equals(collegeId))
{
collegeSql = " college_id='" + collegeId + "' and ";
}
string sql = "select * from Teacher_course where " + collegeSql + " course_id in (select course_id from Course where course_type=@courseType)";
SqlParameter[] pars =
{
new SqlParameter("@courseType", courseType)
};
DataTable dataTable = DBUtils.getDBUtils().getRecords(sql, pars);
IList <Teacher_course> courseList = new List <Teacher_course>();
foreach (DataRow row in dataTable.Rows)
{
Teacher_course course = new Teacher_course();
BeanUils.SetStringValues(course, row);
if (row["status"] != null)
{
course.status = Convert.ToInt32(row["status"]);
}
courseList.Add(course);
}
return(courseList);
}
/// <summary>
/// 选课
/// </summary>
/// <param name="stuId"></param>
/// <param name="teacherCourseId"></param>
/// <returns></returns>
public bool ChooseCourse(string stuId, string teacherCourseId)
{
Student student = studengDAL.SelectStudentById(stuId);
Teacher_course teacher_Course = teacherCourseDAL.SelectById(teacherCourseId);
if (student == null || teacher_Course == null)
{
return(false);
}
courseDAL.ChooseCourse(student, teacher_Course);
return(true);
}
/// <summary>
/// 选课
/// </summary>
/// <param name="student"></param>
/// <param name="courseInfo"></param>
public void ChooseCourse(Student student, Teacher_course courseInfo)
{
Course_choosing course_Choosing = new Course_choosing();
BeanUils.TransFields(student, course_Choosing);
BeanUils.TransFields(courseInfo, course_Choosing);
//学生课程表id由教师选课表id和学生id联合组成
course_Choosing.course_choosing_id = courseInfo.teacher_course_id + student.student_id;
//status默认为1
string sql = "insert into Course_choosing(course_choosing_id,student_id,student_name,teacher_course_id,teacher_id,teacher_name,course_id,course_name,classroom_id,status,course_credit) "
+ " values(@course_choosing_id,@student_id,@student_name,@teacher_course_id,@teacher_id,@teacher_name,@course_id,@course_name,@classroom_id,@status,@course_credit)";
IList <SqlParameter> sqlParameterList = BeanUils.SetInSQL(sql, course_Choosing);
DBUtils.getDBUtils().cud(sql, sqlParameterList.ToArray());
}
public IList <Teacher_course> SelTeacher_CourseByDetail(string course_id, string teacher_id, string class_id)
{
string sql = "select * from teacher_course where teacher_course_id=@teacher_course_id";
SqlParameter[] pars =
{
new SqlParameter("@teacher_course_id", course_id + teacher_id + class_id),
};
DataTable dataTable = DBUtils.getDBUtils().getRecords(sql, pars);
IList <Teacher_course> tcList = new List <Teacher_course>();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
Teacher_course tc = new Teacher_course();
tc.teacher_course_id = dataTable.Rows[i]["major_id"].ToString();
tcList.Add(tc);
}
return(tcList);
}
/// <summary>
/// 根据主键查询所有信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Teacher_course SelectById(string id)
{
string sql = "select * from Teacher_course where teacher_course_id='" + id + "'";
DataTable dataTable = DBUtils.getDBUtils().getRecords(sql);
if (dataTable.Rows.Count > 0)
{
DataRow row = dataTable.Rows[0];
Teacher_course teacher_Course = new Teacher_course();
BeanUils.SetStringValues(teacher_Course, row);
if (row["course_credit"] != null)
{
teacher_Course.course_credit = Convert.ToDecimal(row["course_credit"]);
}
if (row["status"] != null)
{
teacher_Course.status = Convert.ToInt32(row["status"]);
}
return(teacher_Course);
}
return(null);
}
