/// <summary>
/// 取得满足条件的结果
/// </summary>
/// <param name="Lesson"></param>
/// <returns></returns>
public DataTable GetCourseList(string key, string value)
{
string sql = "select * from lesson where " + key + "='" + value + "'";
databaseContorl dbs = new databaseContorl();
DataTable dt = dbs.GetDataAdapter(sql);
return(dt);
}
/// <summary>
/// 获取单列
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public DataTable GetDISTINCT(string para)
{
string sql = "select DISTINCT " + para + " from lesson";
databaseContorl dbs = new databaseContorl();
DataTable dt = dbs.GetDataAdapter(sql);
return(dt);
}
/// <summary>
/// 登陆
/// </summary>
/// <param name="STD">student对象的实例</param>
/// <returns>登陆</returns>
public bool getLogin(student Student)
{
string sql = "select * from stuInfo where stuId ='" + Student.ID + "' and Password='******'";
databaseContorl dbs = new databaseContorl();
DataTable dt = dbs.GetDataAdapter(sql);
if (dt.Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
student Student = new student();
if (context.Session["id"] != null)
{
Student.ID = context.Session["id"].ToString();
string sql = "select lessonCode from lessonTable where stuId='" + Student.ID + "'";
databaseContorl dbs = new databaseContorl();
DataTable dt = dbs.GetDataAdapter(sql);
DataRow[] dr = dt.Select();
if (dt.Rows.Count > 0)
{
string Course = dr[0]["lessoncode"].ToString();
string[] everyCourse = Course.Split('@');
lesson Lesson = new lesson();
string strCourse = string.Empty;
stuMgr StuMgr = new stuMgr();
foreach (string course in everyCourse)
{
Lesson.LessonCode = course;
DataRow[] dataRows = StuMgr.GetSubjectDetail(Lesson).Select();
foreach (DataRow dar in dataRows)
{
strCourse += "<tr><td>" + dar["lessonName"] + "</td><td>" + dar["lessonTeam"] + "</td><td>" + dar["lessonTeacher"] + "</td><td>" + dar["lessonStartTime"] + "~" + dar["lessonEndTime"] + "</td><td>" + dar["lessonAddress"] + "</td>/tr>";
}
}
context.Response.Write(strCourse);
}
else
{
context.Response.Write("你还没有选课");
}
}
else
{
context.Response.Write("fail");
}
}
