student_basicinfo.aspx.cs

该系统是一个集成多功能的信息管理系统

/// <summary>
/// 哈尔滨师范大学教务系统开发
/// 作者:易继勇
/// 邮箱:[e-mail]
/// qq:610068468
/// 哈尔滨师范大学教务平台图片展示地址:http://photo.sina.com.cn/yijiyong100
/// 如果您有什么问题,将您的问题发送至邮箱[e-mail],欢迎大家和我交流讨论,多多希望您提出您宝贵的意见!
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 student_student_basicInfo : System.Web.UI.Page
{
    BaseClass bc = new BaseClass();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Convert.ToString(Session["stdUserName"]) == "")
        {
            Response.Write("<script language=javascript>location='../TS_login.aspx'</script>");
            return;
        }
        studyNumber.Text = Session["stdUserName"].ToString();
        IDcardNumber.Text = Session["stdIDcardNumber"].ToString();
        studentName.Text = Session["stdName"].ToString();
        
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["strcon"]);
        con.Open();
        SqlCommand sd1= new SqlCommand("select usedName  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'",con);
        string usedName = Convert.ToString(sd1.ExecuteScalar());
        this.usedName.Text = usedName;
        SqlCommand sd2 = new SqlCommand("select sex  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string sex = Convert.ToString(sd2.ExecuteScalar());
        this.sex.Text = sex;
        SqlCommand sd3 = new SqlCommand("select birthday  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string birthday = Convert.ToString(sd3.ExecuteScalar());
        this.birthday.Text = birthday;
        SqlCommand sd4 = new SqlCommand("select nation  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string nation = Convert.ToString(sd4.ExecuteScalar());
        this.nation.Text = nation;
        SqlCommand sd5 = new SqlCommand("select nativePlace  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string nativePlace = Convert.ToString(sd5.ExecuteScalar());
        this.nativePlace.Text = nativePlace;
        SqlCommand sd6 = new SqlCommand("select politicsVisage  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string politicsVisage = Convert.ToString(sd6.ExecuteScalar());
        this.politicsVisage.Text = politicsVisage;
        SqlCommand sd7 = new SqlCommand("select fromArea  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string fromArea = Convert.ToString(sd7.ExecuteScalar());
        this.fromArea.Text = fromArea;
        SqlCommand sd8 = new SqlCommand("select fromProvince  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string fromProvince = Convert.ToString(sd8.ExecuteScalar());
        this.fromProvince.Text = fromProvince;
        SqlCommand sd9 = new SqlCommand("select homePlace  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string homePlace = Convert.ToString(sd9.ExecuteScalar());
        this.homePlace.Text = homePlace;
        SqlCommand sd10 = new SqlCommand("select healthCondition  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string healthCondition = Convert.ToString(sd10.ExecuteScalar());
        this.healthCondition.Text = healthCondition;
        SqlCommand sd11 = new SqlCommand("select college  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string college = Convert.ToString(sd11.ExecuteScalar());
        this.college.Text = college;
        SqlCommand sd12 = new SqlCommand("select department  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string department = Convert.ToString(sd12.ExecuteScalar());
        this.department.Text = department;
        SqlCommand sd13 = new SqlCommand("select speciality  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string speciality = Convert.ToString(sd13.ExecuteScalar());
        this.speciality.Text = speciality;
        SqlCommand sd14 = new SqlCommand("select teachedClass  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string teachedClass = Convert.ToString(sd14.ExecuteScalar());
        this.teachedClass.Text = teachedClass;
        SqlCommand sd15 = new SqlCommand("select adminClass  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string adminClass = Convert.ToString(sd15.ExecuteScalar());
        this.adminClass.Text = adminClass;
        SqlCommand sd16 = new SqlCommand("select eductionalSystme  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string eductionalSystme = Convert.ToString(sd16.ExecuteScalar());
        this.eductionalSystme.Text = eductionalSystme;
        SqlCommand sd17 = new SqlCommand("select studyLength  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string studyLength = Convert.ToString(sd17.ExecuteScalar());
        this.studyLength.Text = studyLength;
        SqlCommand sd18 = new SqlCommand("select studyState  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string studyState = Convert.ToString(sd18.ExecuteScalar());
        this.studyState.Text = studyState;
        SqlCommand sd19 = new SqlCommand("select currentlyGrade  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string currentlyGrade = Convert.ToString(sd19.ExecuteScalar());
        this.currentlyGrade.Text = currentlyGrade;
        SqlCommand sd20 = new SqlCommand("select stdproveCode  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string stdproveCode = Convert.ToString(sd20.ExecuteScalar());
        this.stdproveCode.Text = stdproveCode;
        SqlCommand sd21 = new SqlCommand("select culitivateDirection  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string culitivateDirection = Convert.ToString(sd21.ExecuteScalar());
        this.culitivateDirection.Text = culitivateDirection;
        SqlCommand sd22 = new SqlCommand("select specialityDirection  from ts_xs_basicInfo where studyNumber='" + Session["stdUserName"] + "'", con);
        string specialityDirection = Convert.ToString(sd22.ExecuteScalar());
        this.specialityDirection.Text = specialityDirection;