student/SuLogin_in.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Specialized;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.Net;
using System.Net.Sockets;
using System.Web;
using System.Web.UI;
using System.Data.SqlClient;

public partial class student_SuLogin_in : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        //登录按钮
        string connstr = System.Configuration.ConfigurationManager.AppSettings["GradeSys"];
        SqlConnection conn = new SqlConnection(connstr);
        string Name = this.txtName.Text.ToString();//名字
        string Num = this.txtNumber.Text.ToString();//学号
        string ACT = "login";//行为
        string result = "";//结果
        string Kind = "student";//账户类型
        string sql = string.Empty;
        string error = "";
        sql = string.Format("select 学号,姓名,所在院系,班级名 from 学生信息表 where 学号='{0}' and 姓名='{1}'", Num, Name);
        SqlDataReader dr;
        SqlCommand cmd = new SqlCommand(sql, conn);
        try
        {
            conn.Open();
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                result = "1";
                Session["num"] = dr["学号"].ToString();
                Session["name"] = dr["姓名"].ToString();
                Session["acad"] = dr["所在院系"].ToString();
                Session["class"] = dr["班级名"].ToString();
                conn.Close();
                OPDB.operate.login(Num, ACT, result, Kind,ref error);
                Response.Redirect("suDefault.aspx");
            }
            else
            {
                result = "0";
                Response.Write("<script>alert('用户名或者密码错误,请重新输入!')</script>");
                conn.Close();
                OPDB.operate.login(Num, ACT, result, Kind, ref error);
            }
        }
        catch (Exception ex)
        {
            Response.Write(ex);
        }
        finally