/*更新课程信息实现*/
public static bool EditCourseInfo(ENTITY.CourseInfo courseInfo)
{
string sql = "update CourseInfo set courseName=@courseName,courseTeacher=@courseTeacher,courseTime=@courseTime,coursePlace=@coursePlace,courseScore=@courseScore,courseMemo=@courseMemo where courseNumber=@courseNumber";
/*构建sql参数信息*/
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@courseName", SqlDbType.VarChar),
new SqlParameter("@courseTeacher", SqlDbType.VarChar),
new SqlParameter("@courseTime", SqlDbType.VarChar),
new SqlParameter("@coursePlace", SqlDbType.VarChar),
new SqlParameter("@courseScore", SqlDbType.Float),
new SqlParameter("@courseMemo", SqlDbType.VarChar),
new SqlParameter("@courseNumber", SqlDbType.VarChar)
};
/*为参数赋值*/
parm[0].Value = courseInfo.courseName;
parm[1].Value = courseInfo.courseTeacher;
parm[2].Value = courseInfo.courseTime;
parm[3].Value = courseInfo.coursePlace;
parm[4].Value = courseInfo.courseScore;
parm[5].Value = courseInfo.courseMemo;
parm[6].Value = courseInfo.courseNumber;
/*执行更新*/
return((DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false);
}
/*添加课程信息实现*/
public static bool AddCourseInfo(ENTITY.CourseInfo courseInfo)
{
string sql = "insert into CourseInfo(courseNumber,courseName,courseTeacher,courseTime,coursePlace,courseScore,courseMemo) values(@courseNumber,@courseName,@courseTeacher,@courseTime,@coursePlace,@courseScore,@courseMemo)";
/*构建sql参数*/
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@courseNumber", SqlDbType.VarChar),
new SqlParameter("@courseName", SqlDbType.VarChar),
new SqlParameter("@courseTeacher", SqlDbType.VarChar),
new SqlParameter("@courseTime", SqlDbType.VarChar),
new SqlParameter("@coursePlace", SqlDbType.VarChar),
new SqlParameter("@courseScore", SqlDbType.Float),
new SqlParameter("@courseMemo", SqlDbType.VarChar)
};
/*给参数赋值*/
parm[0].Value = courseInfo.courseNumber; //课程编号
parm[1].Value = courseInfo.courseName; //课程名称
parm[2].Value = courseInfo.courseTeacher; //上课老师
parm[3].Value = courseInfo.courseTime; //上课时间
parm[4].Value = courseInfo.coursePlace; //上课地点
parm[5].Value = courseInfo.courseScore; //课程学分
parm[6].Value = courseInfo.courseMemo; //附加信息
/*执行sql进行添加*/
return((DBHelp.ExecuteNonQuery(sql, parm) > 0) ? true : false);
}
/*根据courseNumber获取某条课程信息记录*/
public static ENTITY.CourseInfo getSomeCourseInfo(string courseNumber)
{
/*构建查询sql*/
string sql = "select * from CourseInfo where courseNumber='" + courseNumber + "'";
SqlDataReader DataRead = DBHelp.ExecuteReader(sql, null);
ENTITY.CourseInfo courseInfo = new ENTITY.CourseInfo();
/*如果查询存在记录，就包装到对象中返回*/
if (DataRead.Read())
{
courseInfo.courseNumber = DataRead["courseNumber"].ToString();
courseInfo.courseName = DataRead["courseName"].ToString();
courseInfo.courseTeacher = DataRead["courseTeacher"].ToString();
courseInfo.courseTime = DataRead["courseTime"].ToString();
courseInfo.coursePlace = DataRead["coursePlace"].ToString();
courseInfo.courseScore = float.Parse(DataRead["courseScore"].ToString());
courseInfo.courseMemo = DataRead["courseMemo"].ToString();
}
return(courseInfo);
}
