📄 employeemanage.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;
namespace MisPersonnel.DesktopModules.Employee
{
/// <summary>
/// EmployeeManage 的摘要说明。
/// </summary>
public class EmployeeManage : System.Web.UI.Page
{
protected System.Web.UI.WebControls.ListBox EmployeeList;
protected System.Web.UI.WebControls.Button AddBtn;
protected System.Web.UI.WebControls.Button UpdateBtn;
protected System.Web.UI.WebControls.Button DeleteBtn;
protected System.Web.UI.WebControls.Label lblLReceiver;
protected System.Web.UI.WebControls.TextBox EmployName;
protected System.Web.UI.WebControls.RequiredFieldValidator rfEN;
protected System.Web.UI.WebControls.Label lblAdditionalNo;
protected System.Web.UI.WebControls.TextBox EmployNo;
protected System.Web.UI.WebControls.RequiredFieldValidator rfDN;
protected System.Web.UI.WebControls.Label Label14;
protected System.Web.UI.WebControls.DropDownList SexList;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox Nationality;
protected System.Web.UI.WebControls.RequiredFieldValidator rfNa;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.TextBox Birthday;
protected System.Web.UI.WebControls.RequiredFieldValidator rfBD;
protected System.Web.UI.WebControls.RegularExpressionValidator reBD;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.TextBox Political;
protected System.Web.UI.WebControls.Label Label6;
protected System.Web.UI.WebControls.RequiredFieldValidator rfCu;
protected System.Web.UI.WebControls.Label Label15;
protected System.Web.UI.WebControls.DropDownList Maritallist;
protected System.Web.UI.WebControls.Label Label7;
protected System.Web.UI.WebControls.TextBox FamilyPlace;
protected System.Web.UI.WebControls.RequiredFieldValidator rfFP;
protected System.Web.UI.WebControls.Label Label8;
protected System.Web.UI.WebControls.TextBox IdentityCard;
protected System.Web.UI.WebControls.RequiredFieldValidator rfIC;
protected System.Web.UI.WebControls.Label Label9;
protected System.Web.UI.WebControls.TextBox Phone;
protected System.Web.UI.WebControls.Label Label10;
protected System.Web.UI.WebControls.TextBox Mobile;
protected System.Web.UI.WebControls.Label Label16;
protected System.Web.UI.WebControls.TextBox HireDate;
protected System.Web.UI.WebControls.RequiredFieldValidator rfHD;
protected System.Web.UI.WebControls.RegularExpressionValidator reHD;
protected System.Web.UI.WebControls.Label Label11;
protected System.Web.UI.WebControls.TextBox Position;
protected System.Web.UI.WebControls.RequiredFieldValidator rfPs;
protected System.Web.UI.WebControls.Label Label17;
protected System.Web.UI.WebControls.DropDownList StateList;
protected System.Web.UI.WebControls.Label Label12;
protected System.Web.UI.WebControls.TextBox BankName;
protected System.Web.UI.WebControls.RequiredFieldValidator rfBN;
protected System.Web.UI.WebControls.Label Label13;
protected System.Web.UI.WebControls.TextBox AccountNo;
protected System.Web.UI.WebControls.RequiredFieldValidator rfAN;
protected System.Web.UI.WebControls.Label Label18;
protected System.Web.UI.WebControls.TextBox PubName;
protected System.Web.UI.WebControls.RequiredFieldValidator rfPN;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.DropDownList DepartmentList;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.TextBox Remark;
protected System.Web.UI.WebControls.TextBox MisCulture;
protected System.Web.UI.WebControls.Button topAddBtn;
protected System.Web.UI.WebControls.Button topUpdateBtn;
protected System.Web.UI.WebControls.Button topDeleteBtn;
protected System.Web.UI.WebControls.Label CurrentEmployeeName;
public int nEmployeeID = -1;
private static string EmployeeName = "";
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(Request.Params["EmployeeID"] != null)
{
nEmployeeID = Int32.Parse(Request.Params["EmployeeID"].ToString());
}
if(!Page.IsPostBack)
{
///绑定控件的数据
BindEmployeeData();
///设置员工的选择项
MisSystem.SetListBoxItem(EmployeeList,nEmployeeID.ToString());
if(nEmployeeID > -1)
{ ///显示操作前的信息
BindEmployeeData(nEmployeeID);
CurrentEmployeeName.Text = EmployeeName;
}
else
{
///显示当前选择项的信息
if(EmployeeList.SelectedIndex > -1)
{
///显示信息
BindEmployeeData(Int32.Parse(EmployeeList.SelectedValue));
CurrentEmployeeName.Text = EmployeeList.SelectedItem.Text;
}
else
{
if(EmployeeList.Items.Count > 0)
{ ///显示第一项的信息
BindEmployeeData(Int32.Parse(EmployeeList.Items[0].Value));
CurrentEmployeeName.Text = EmployeeList.Items[0].Text;
EmployeeList.SelectedIndex = 0;
}
}
}
}
///设置按钮的可用性
UpdateBtn.Enabled = DeleteBtn.Enabled = (EmployeeList.Items.Count <= 0) ? false : true;
topUpdateBtn.Enabled = UpdateBtn.Enabled;
topDeleteBtn.Enabled = DeleteBtn.Enabled;
///添加删除确认对话框
DeleteBtn.Attributes.Add("onclick","return confirm('" + MisSystem.OPERATIONDELETEMESSAGE + "');");
topDeleteBtn.Attributes.Add("onclick","return confirm('" + MisSystem.OPERATIONDELETEMESSAGE + "');");
}
private void BindEmployeeData()
{
///定义获取数据的类
MisPersonnel.Components.Employee employee = new MisPersonnel.Components.Employee();
SqlDataReader recu = employee.GetEmployees();
///设定控件的数据源
EmployeeList.DataSource = recu;
///设定控件的Text属性和Value属性
EmployeeList.DataTextField = "EmployName";
EmployeeList.DataValueField = "EmployeeID";
///绑定控件的数据
EmployeeList.DataBind();
///关闭数据读取器和数据库的连接
recu.Close();
}
private void BindDepartData()
{
///定义获取数据的类
MisPersonnel.Components.Department depart = new MisPersonnel.Components.Department();
SqlDataReader recd = depart.GetDepartments();
///设定控件的数据源
DepartmentList.DataSource = recd;
///设定控件的Text属性和Value属性
DepartmentList.DataTextField = "DepartName";
DepartmentList.DataValueField = "DepartmentID";
///绑定控件的数据
DepartmentList.DataBind();
///关闭数据读取器和数据库的连接
recd.Close();
}
private void BindEmployeeData(int nEmployeeID)
{
///绑定所属部门的信息
BindDepartData();
///定义获取数据的类
MisPersonnel.Components.Employee employ = new MisPersonnel.Components.Employee();
SqlDataReader rece = employ.GetSingleEmployee(nEmployeeID);
///从获取的数据中读取数据
if(rece.Read())
{
///设置列表控件的选择值
MisSystem.SetListBoxItem(SexList,rece["Sex"].ToString());
MisSystem.SetListBoxItem(Maritallist,rece["Marital"].ToString());
MisSystem.SetListBoxItem(StateList,rece["State"].ToString());
MisSystem.SetListBoxItem(DepartmentList,rece["DepartmentID"].ToString());
EmployName.Text = rece["EmployName"].ToString();
EmployNo.Text = rece["EmployNo"].ToString();
Nationality.Text = rece["Nationality"].ToString();
Birthday.Text = (Convert.ToDateTime(rece["Birthday"].ToString())).ToShortDateString();
Political.Text = rece["Political"].ToString();
MisCulture.Text = rece["Culture"].ToString();
FamilyPlace.Text = rece["FamilyPlace"].ToString();
IdentityCard.Text = rece["IdentityCard"].ToString();
Phone.Text = rece["Phone"].ToString();
Mobile.Text = rece["Mobile"].ToString();
HireDate.Text = (Convert.ToDateTime(rece["HireDate"].ToString())).ToShortDateString();
Position.Text = rece["Position"].ToString();
BankName.Text = rece["BankName"].ToString();
AccountNo.Text = rece["AccountNo"].ToString();
PubName.Text = rece["PubName"].ToString();
Remark.Text = rece["Remark"].ToString();
}
///关闭数据读取器和数据库的连接
rece.Close();
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.EmployeeList.SelectedIndexChanged += new System.EventHandler(this.EmployeeList_SelectedIndexChanged);
this.topAddBtn.Click += new System.EventHandler(this.AddBtn_Click);
this.topUpdateBtn.Click += new System.EventHandler(this.UpdateBtn_Click);
this.topDeleteBtn.Click += new System.EventHandler(this.DeleteBtn_Click);
this.AddBtn.Click += new System.EventHandler(this.AddBtn_Click);
this.UpdateBtn.Click += new System.EventHandler(this.UpdateBtn_Click);
this.DeleteBtn.Click += new System.EventHandler(this.DeleteBtn_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void AddBtn_Click(object sender, System.EventArgs e)
{
///跳转到添加页面
Response.Redirect("~/DesktopModules/Employee/AddEmployee.aspx?EmployeeID="
+ ((EmployeeList.SelectedIndex > -1) ? EmployeeList.SelectedValue : "-1"));
}
private void DeleteBtn_Click(object sender, System.EventArgs e)
{
if(EmployeeList.SelectedIndex > -1)
{
///定义类
MisPersonnel.Components.Employee employ = new MisPersonnel.Components.Employee();
try
{
///删除操作
employ.DeleteEmployee(Int32.Parse(EmployeeList.SelectedValue));
///重新显示员工的信息
BindEmployeeData();
if(EmployeeList.Items.Count > 0)
{
BindEmployeeData(Int32.Parse(EmployeeList.Items[0].Value));
EmployeeList.SelectedIndex = 0;
}
///显示操作结果信息
Response.Write ("<script>window.alert('" + MisSystem.OPERATIONDELETESUCCESSMESSAGE + "')</script>");
}
catch(Exception ex)
{
///显示添加操作中的失败、错误信息
Response.Redirect("~/DesktopModules/ErrorPage.aspx?ErrorUrl="
+ MisSystem.RedirectErrorUrl(Request.RawUrl)
+ "&ErrorMessage=" + ex.Message.Replace("\n"," "));
}
}
else
{
///显示操作结果信息
Response.Write ("<script>window.alert('" + MisSystem.OPERATIONNOSELECTMESSAGE + "')</script>");
}
}
private void UpdateBtn_Click(object sender, System.EventArgs e)
{
if(Page.IsValid == true)
{
if(EmployeeList.SelectedIndex > -1)
{
///定义类
MisPersonnel.Components.Employee employ = new MisPersonnel.Components.Employee();
try
{
int nCurrentEmployeeID = Int32.Parse(EmployeeList.SelectedValue);
int nCurrentIndex = EmployeeList.SelectedIndex;
///修改操作
employ.UpdateEmployee(Int32.Parse(EmployeeList.SelectedValue),
EmployName.Text.Trim(),EmployNo.Text.Trim(),
Int32.Parse(SexList.SelectedValue),Nationality.Text.Trim(),
Convert.ToDateTime(Birthday.Text.Trim()),Political.Text,
MisCulture.Text.Trim(),Int32.Parse(Maritallist.SelectedValue),
FamilyPlace.Text,IdentityCard.Text.Trim(),Phone.Text.Trim(),
Mobile.Text,Convert.ToDateTime(HireDate.Text.Trim()),Position.Text,
Int32.Parse(StateList.SelectedValue),BankName.Text,
AccountNo.Text,PubName.Text,Int32.Parse(DepartmentList.SelectedValue),
Remark.Text);
///重新显示员工的信息
BindEmployeeData();
BindEmployeeData(nCurrentEmployeeID);
EmployeeList.SelectedIndex = nCurrentIndex;
///显示操作结果信息
Response.Write ("<script>window.alert('" + MisSystem.OPERATIONUPDATESUCCESSMESSAGE + "')</script>");
}
catch(Exception ex)
{
///显示添加操作中的失败、错误信息
Response.Redirect("~/DesktopModules/ErrorPage.aspx?ErrorUrl="
+ MisSystem.RedirectErrorUrl(Request.RawUrl)
+ "&ErrorMessage=" + ex.Message.Replace("\n"," "));
}
}
else
{
///显示操作结果信息
Response.Write ("<script>window.alert('" + MisSystem.OPERATIONNOSELECTMESSAGE + "')</script>");
}
}
}
private void EmployeeList_SelectedIndexChanged(object sender, System.EventArgs e)
{
if(EmployeeList.SelectedIndex > -1)
{
///显示员工的信息
BindEmployeeData(Int32.Parse(EmployeeList.SelectedValue));
EmployeeName = EmployeeList.SelectedItem.Text;
CurrentEmployeeName.Text = EmployeeList.SelectedItem.Text;
nEmployeeID = Int32.Parse(EmployeeList.SelectedValue);
///设置按钮的可用性
UpdateBtn.Enabled = topUpdateBtn.Enabled = DeleteBtn.Enabled = topDeleteBtn.Enabled = true;
}
else
{
///显示操作结果信息
Response.Write ("<script>window.alert('" + MisSystem.OPERATIONNOSELECTMESSAGE + "')</script>");
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -