/// <summary>
/// 通过审核
/// </summary>
/// <param name="CourseId">审核课程的课程编号</param>
/// <param name="courseExt">教务处新增信息</param>
/// <returns>1成功，0失败</returns>
public int checkCourseToY(int CourseId, CourseMana courseExt)
{
int result1 = new CourseService().checkCourseY(CourseId);
if (result1 == 0)
{
return(result1);
}
CourseMes course = new CourseService().queryCourseById(CourseId);
return(new CourseService().addCoursetoMana(course, courseExt));
}
//向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));
}
//对课程进行审批
//protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
//{
// CourseManege bll = new CourseManege();
// int id = Convert.ToInt32(e.CommandArgument);
// if (e.CommandName.Equals("past"))
// {
// //bll.checkCourseToY(id,);
// }
// else if (e.CommandName.Equals("nopast"))
// {
// bll.checkCourseToN(id);
// }
//}
//添加到课程信息表中
protected void btn_save_Click(object sender, EventArgs e)
{
int CourseId = Convert.ToInt32(Request.Form["courseId"]);
CourseMana course = new CourseMana();
CourseManege bll = new CourseManege();
course.Season = season.SelectedItem.Text.Trim();
course.Time = Day.SelectedItem.Text.Trim() + Time.SelectedItem.Text.Trim();
course.CourseAdd = Request.Form["txt_add"];
if (bll.checkCourseToY(CourseId, course) == 1)
{
Response.Write("<script>alert('审核课程成功');</script>");
}
else
{
Response.Write("<script>alert('成功');</script>");
}
}
//查看课程的成绩的计算比例
public CourseMana queryRatio(int CourseId)
{
string sql = "select CourseId,TeaId,MatchRatio,ClassRatio from CourseMana where CourseId = @CourseId";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@CourseId", CourseId)
};
CourseMana course = null;
SqlDataReader res = new Helper.SQLHelper().queryAllResult(sql, param, false);
while (res.Read())
{
course = new CourseMana()
{
CourseID = Convert.ToInt32(res["CourseId"]),
TeaId = Convert.ToInt32(res["TeaId"]),
MatchRatio = float.Parse(res["MatchRatio"].ToString()),
ClassRatio = float.Parse(res["ClassRatio"].ToString())
};
}
return(course);
}
//通过课程编号查看选课信息
public CourseMana selectCourseById(int courseId)
{
string sql = "select CourseId,TeaId,Season,Time,CourseAdd from CourseMana where CourseID=@CourseId";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@CourseId", courseId),
};
SqlDataReader result = new Helper.SQLHelper().queryAllResult(sql, param, false);
CourseMana course = null;
while (result.Read())
{
course = new CourseMana()
{
CourseID = courseId,
Time = result["Time"].ToString(),
Season = result["Season"].ToString(),
CourseAdd = result["CourseAdd"].ToString(),
TeaId = Convert.ToInt32(result["TeaId"])
};
}
return(course);
}
