danweitxl.aspx.cs

OA自动化办公系统,就是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 COM.OA.Entity;
using COM.OA.BLL;
using System.Collections.Generic;
using System.Data.SqlClient;

public partial class qs_Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        

        IList<addresslisttx> lists = BLLGeneric.Select<addresslisttx>(CommandType.StoredProcedure, "tongxunlu");
       
        this.gdvSelectAll.DataSource = lists;
        this.gdvSelectAll.DataBind();

    }
   

    protected void Button1_Click(object sender, EventArgs e)
    {
        String bumen = this.ddl_bumen1.Text;

        string where = "dept_department='{0}'";
        where = string.Format(where, bumen);
         IList<department> list =departmentBLL.Select(where);
         department dt = list[0];
         int bumenId = dt.dept_id;
        // String where = "em_dept_id='{0}'";
        //  where = string.Format(where,bumen);
        //   IList<employee> list = employeeBLL.Select(where);


         SqlParameter parambumen = new SqlParameter("@deptid", bumenId);
       IList<addresslisttx> lists = BLLGeneric.Select<addresslisttx>(CommandType.StoredProcedure, "tongxunluBumen", parambumen);
        this.gdvSelectAll.DataSource = lists;
        this.gdvSelectAll.DataBind();

    }
    protected void gdvSelectAll_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes["onmouseover"] = "orgColor=this.style.backgroundColor;this.style.backgroundColor='#D5EEBB';";
            e.Row.Attributes["onmouseout"] = "this.style.backgroundColor=orgColor;";
        }
    }
}