📄 departmentmanage.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using MisPersonnel.Components;
using System.Data.SqlClient;
using SQLHelper;
namespace MisPersonnel.DesktopModules.Department
{
/// <summary>
/// DepartManage 的摘要说明。
/// </summary>
public class DepartmentManage : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Button AddDepartment;
protected System.Web.UI.WebControls.DataGrid DepartmentList;
protected System.Web.UI.WebControls.Label Label3;
private void Page_Load(object sender, System.EventArgs e)
{
///判断用户是否登陆
if(Session["UserID"] == null)
{
Response.Redirect("~/Default.aspx");
}
///判断用户是否是超级管理员
if(Components.User.IsAuthorityAdmin(Session["UserID"].ToString()) >= Components.User.USERTYPENORMAL)
{
Response.Write("<script>alert(\"你没有权限,请与管理员联系!\")</script>");
Response.Write("<script>history.back();</script>");
}
if(!Page.IsPostBack)
{
///绑定控件的数据
BindDepartData();
}
}
private void BindDepartData()
{
///定义获取数据的类
MisPersonnel.Components.Department depart = new MisPersonnel.Components.Department();
SqlDataReader recd = depart.GetDepartments();
///创建DataSet数据源
DataTable dataTable = SystemTools.ConvertDataReaderToDataTable(recd);
DataSet dataSet = new DataSet("Department");
dataSet.Tables.Add(dataTable);
///设定控件的数据源
DepartmentList.DataSource = dataSet;
///绑定控件的数据
DepartmentList.DataBind();
}
public string DepartParentName(string nParentID)
{
///定义保存上级部门的名称
string sDepartParentName = "无上级部门";
///定义获取数据的类
MisPersonnel.Components.Department depart = new MisPersonnel.Components.Department();
SqlDataReader recd = depart.GetSingleDepartment(Int32.Parse(nParentID));
///从获取的数据中读取数据
if(recd.Read())
{
sDepartParentName = recd["DepartName"].ToString();
}
///关闭数据读取器和数据库的连接
recd.Close();
return(sDepartParentName);
}
public string FormatString(string oldString)
{
return(oldString.Length > 50 ? oldString.Substring(0,50) + "..." : oldString);
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.AddDepartment.Click += new System.EventHandler(this.AddDepartment_Click);
this.DepartmentList.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DepartmentList_ItemCommand);
this.DepartmentList.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DepartmentList_PageIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void AddDepartment_Click(object sender, System.EventArgs e)
{
///跳转到添加页面
Response.Redirect("~/DesktopModules/Department/AddDepartment.aspx");
}
private void DepartmentList_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if(e.CommandName.ToLower() == "delete")
{
///跳转到删除页面
Response.Redirect("~/DesktopModules/Department/DeleteDepartment.aspx?DepartmentID="
+ DepartmentList.DataKeys[e.Item.ItemIndex].ToString());
}
}
private void DepartmentList_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
///设置新的页码,并重新绑定数据
DepartmentList.CurrentPageIndex = e.NewPageIndex;
BindDepartData();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -