//通过课程编号查看课程信息，
public CourseMes queryCourseById(int courseId)
{
string sql = "select CourseName,Xuefen,CourseNum,courseproperty,CollegeName,TeaId from CoursesMes where CourseID=@CourseId";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@CourseId", courseId),
};
SqlDataReader result = new Helper.SQLHelper().queryAllResult(sql, param, false);
CourseMes course = null;
while (result.Read())
{
course = new CourseMes()
{
CourseID = courseId,
CourseName = result["CourseName"].ToString(),
Xuefen = float.Parse(result["Xuefen"].ToString()),
CourseNum = Convert.ToInt32(result["CourseNum"]),
courseproperty = result["courseproperty"].ToString(),
CollegeName = result["CollegeName"].ToString(),
TeaId = Convert.ToInt32(result["TeaId"])
};
}
return(course);
}
//向CourseMana中插入数据
public int addCoursetoMana(CourseMes course, CourseMana courseExt)
{
string sql = "insert into CourseMana (CourseId,TeaId,Season,Time,CourseAdd)" +
"values (@CourseId,@TeaId,@Season,@Time,@CourseAdd)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@CourseId", course.CourseID),
new SqlParameter("@TeaId", course.TeaId),
new SqlParameter("@Season", courseExt.Season),
new SqlParameter("@Time", courseExt.Time),
new SqlParameter("@CourseAdd", courseExt.CourseAdd)
};
return(new Helper.SQLHelper().update(sql, param, false));
}
/// <summary>
/// 增加课程
/// </summary>
/// <param name="course"></param>
/// <returns></returns>
public int addCourse(CourseMes course)
{
string sql = "insert into CoursesMes (CourseName,CollegeName,Xuefen,CourseNum,courseproperty,TeaId) Values (@CourseName,@CollegeName,@Xuefen,@CourseNum,@courseproperty,@TeaId)";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@CourseName", course.CourseName),
new SqlParameter("@Xuefen", course.Xuefen),
new SqlParameter("@courseproperty", course.courseproperty),
new SqlParameter("@CourseNum", course.CourseNum),
new SqlParameter("@CollegeName", course.CollegeName),
new SqlParameter("@TeaId", course.TeaId)
};
return(new Helper.SQLHelper().update(sql, param, false));
}
protected void btn_save_Click(object sender, EventArgs e)
{
CourseMes course = new CourseMes();
CourseManege bll = new CourseManege();
//course.CourseID= Convert.ToInt32(Request.Form["txt_id"]);
course.CourseName = Request.Form["txt_name"];
//course.TeaId= Convert.ToInt32(Request.Form["txt_tid"]);
course.Xuefen = Convert.ToSingle(Request.Form["txt_xuefen"]);
course.courseproperty = Request.Form["ddl_coursexingzhi"];
course.CourseNum = Convert.ToInt32(Request.Form["txt_number"]);
//course.SStatus= Request.Form["txt_zhuangtai"];
course.TeaId = Convert.ToInt32(((Model.Login)Session["CurrentUser"]).UserName);
course.CollegeName = Request.Form["ddl_college"];
if (bll.AddCourseByTea(course) == 1)
{
Response.Write("<script>alert('添加成功');</script>");
}
else
{
Response.Write("<script>alert('添加失败');</script>");
}
}
/// <summary>
/// 增加课程
/// </summary>
/// <param name="course">课程对象（包含课程名、课程性质、学分、课时数）</param>
/// <returns>1成功</returns>
public int AddCourseByTea(CourseMes course)
{
return(new CourseService().addCourse(course));
}
