新建 文本文档.txt

基于asp.net的网上选课系统

//调用存储过程判断学生是否已经登录。
    public int StudentIfLogin(string stuid)
    {
        SqlCommand cmd = new SqlCommand("StudentIfLogin", stuConn);
        cmd.CommandType = CommandType.StoredProcedure;

        //给存储过程添加参数
        SqlParameter stu = new SqlParameter("@StudentID", SqlDbType.NVarChar, 50);
        stu.Value = stuid;
        cmd.Parameters.Add(stu);

        SqlParameter aff = new SqlParameter("@returnvalue", SqlDbType.Int, 4);
        aff.Direction = ParameterDirection.Output;
        cmd.Parameters.Add(aff);

        cmd.ExecuteNonQuery();
       if(aff.Value!=0)
            return (int)aff.Value;
        else
            return 0;
     }

//调用存储过程判断老师是否已经登录。
    public int TeacherIfLogin(string teaid)
    {
        SqlCommand cmd = new SqlCommand("TeacherIfLogin", teaConn);
        cmd.CommandType = CommandType.StoredProcedure;

        //给存储过程添加参数
        SqlParameter tea = new SqlParameter("@TeacherID", SqlDbType.NVarChar, 50);
        tea.Value = teaid;
        cmd.Parameters.Add(tea);

        SqlParameter aff = new SqlParameter("@returnvalue", SqlDbType.Int, 4);
        aff.Direction = ParameterDirection.Output;
        cmd.Parameters.Add(aff);

        cmd.ExecuteNonQuery();
       if(aff.Value!=0)
            return (int)aff.Value;
        else
            return 0;
}

//调用存储过程判断管理员是否已经登录。
    public int AdminIfLogin(string adminid)
    {
        SqlCommand cmd = new SqlCommand("AdminIfLogin", adminConn);
        cmd.CommandType = CommandType.StoredProcedure;

        //给存储过程添加参数
        SqlParameter admin = new SqlParameter("@AdminID", SqlDbType.NVarChar, 50);
        admin.Value = adminid;
        cmd.Parameters.Add(admin);

        SqlParameter aff = new SqlParameter("@returnvalue", SqlDbType.Int, 4);
        aff.Direction = ParameterDirection.Output;
        cmd.Parameters.Add(aff);

        cmd.ExecuteNonQuery();
       if(aff.Value!=0)
            return (int)aff.Value;
        else
            return 0;
    }