homeadminStudfind.aspx.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class adminStudfind : System.Web.UI.Page
{
    SqlConnection conn;
    SqlCommand cmd,cmd1;
    SqlDataReader dr,dr1;

    protected void Page_Load(object sender, EventArgs e)
    {
        this.Panel1.Visible = false;
        this.Panel2.Visible = false;
    }
    protected void enter_Click(object sender, EventArgs e)
    {
        conn = sqldata.createCon();
        conn.Open();
        string classID = "";
        string studNo = this.key.Text;
        string sql = "select studNo,studName,Sex,birthday,enterDate,eareName,floodName,homeNo,classID,shenfen from ((eare inner join flood on eare.eareID=flood.eareID)inner join home on flood.floodID=home.floodID)inner join student on student.homeID=home.homeID and studNo=@studNo";
        cmd = new SqlCommand(sql, conn);
        SqlParameter id1 = new SqlParameter("@studNo", SqlDbType.VarChar, 10);
        id1.Value = studNo;
        cmd.Parameters.Add(id1);
        dr = cmd.ExecuteReader(); 
        if (dr.Read())
        {
            this.Panel1.Visible = true;
            this.studName.Text = dr["studName"].ToString();
            this.studNo.Text = dr["studNo"].ToString();
            this.Sex.Text = dr["Sex"].ToString();
            this.birthday.Text = dr["birthday"].ToString();
            this.enterDate.Text = dr["enterDate"].ToString();
            this.home.Text = dr["eareName"].ToString() + " " + dr["floodName"].ToString() + " " + dr["homeNo"].ToString();
            this.shenFen.Text = dr["shenfen"].ToString();
            classID = dr["classID"].ToString();
            conn.Close();

            string sql2 = "select deptName,classID from dept inner join class on dept.deptID=class.deptID where classID='" + classID + "'";
            conn.Open();
            cmd1 = new SqlCommand(sql2, conn);
            dr1 = cmd1.ExecuteReader();
            if (dr1.Read())
            {
                this.dept.Text = dr1["deptName"].ToString() + " " + dr1["classID"].ToString()+"班";
            }
            conn.Close();
        }
        else
        {