OA系统

开发平台：

ASP/ASPX

authority_employee_list.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;
public partial class web_system_authority_employee_list : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            EmployeeList.DataKeyNames = new string[] { "id" };
        }
    }
    protected void EmployeeList_RowCreated(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            Label lbl = (Label)e.Row.FindControl("LblDepartment");
            SqlConnection conn = dbConnection.getConnection();
            conn.Open();
            SqlCommand cmd = new SqlCommand("select department_id from OA_EMPLOYEE where id="+EmployeeList.DataKeys[e.Row.RowIndex].Value.ToString(), conn);
            int department_id = Convert.ToInt32(cmd.ExecuteScalar().ToString());
            conn.Close();
            DepartmentDAO departmentDAO = new DepartmentDAO();
            Department department = departmentDAO.queryById(department_id);
            lbl.Text = department.Full_name;
        }
    }
    protected void EmployeeList_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //行高亮
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");
        }
    }
}

						