empinfo.aspx.cs

介绍学习的管理系统说明什么的

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;
using DataAccess;

public partial class employees_EmpSelect : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection sql = new SqlConnection("database=PersonalManagement;server=(local);user id=sa");
        sql.Open();
        string a = Request["emplogin"];
        string sqlcmd = "select EmployeeId,EmpName,Photo,EmpMail,DepName,Manager_number,(select EmpName from employees,Department where Department.DepartmentId=employees.DepartmentId and employeeid=(select top 1 Manager_number from employees,Department where Department.DepartmentId=(select Department.DepartmentId from employees,Department where emplogin='" + Session["emplogin"] + "' and Department.DepartmentId=employees.DepartmentId))) as Emp from employees,Department where emplogin='" + Session["emplogin"] + "' and Department.DepartmentId=employees.DepartmentId";
        SqlCommand cmd = new SqlCommand(sqlcmd, sql);
        DataSet ds = new DataSet();
        SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
        dataAdapter.Fill(ds);
        SqlDataReader re = cmd.ExecuteReader();
        if (re.Read())
        {
            LabId.Text = re.GetValue(0).ToString();
            LabMail.Text = re.GetValue(3).ToString();
            LableName.Text = re.GetValue(1).ToString();
            LabDep.Text = re.GetValue(4).ToString();
            LabManager.Text = re.GetValue(6).ToString();
            LabTel.Text = re.GetValue(2).ToString();
            img.ImageUrl = "~/UpImage/"+ re.GetValue(2).ToString()+ "";
        }
    }
}