personinfo.aspx.cs

oa办公系统

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 PersonInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        staff s=new staff();
        SqlDataReader dr = s.sel_staffInfo(Convert.ToInt32(Session["uname"]));
        if (dr.Read())
        {
            labid.Text = dr["s_id"].ToString();
            labname.Text = dr["s_name"].ToString();
            labsex.Text = dr["s_sex"].ToString();
            labbirthday.Text = Convert.ToDateTime(dr["s_birthday"]).ToShortDateString();
            labnation.Text = dr["s_nation"].ToString();
            labschool.Text = dr["s_collage"].ToString();
            labedu.Text = dr["s_edu"].ToString();
            labphone.Text = dr["s_phone"].ToString();
            labmail.Text = dr["s_email"].ToString();
            labdepartment.Text = dr["s_department"].ToString();
            labstatus.Text = dr["s_status"].ToString();
            labrole.Text = dr["r_name"].ToString();
            labposition.Text = dr["s_position"].ToString();
            labtime.Text = Convert.ToDateTime(dr["s_registerDate"]).ToShortDateString();
            labmobile.Text = dr["s_mobile"].ToString();
        }
    }
}