📄 addtransfer.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;
namespace PMS.DesktopModules.TransferMng
{
/// <summary>
/// AddTransfer 的摘要说明。
/// </summary>
public partial class AddTransfer : System.Web.UI.Page
{
protected void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
///判断用户是否登陆
if(Session["UserID"] == null)
{
Response.Redirect("~/Default.aspx");
}
///判断用户是否是超级管理员或普通管理员
if(Components.User.IsAuthority(Session["UserID"].ToString()) != Components.User.USERTYPESUPERADMIN && Components.User.IsAuthority(Session["UserID"].ToString()) != Components.User.USERTYPEADMIN)
{
Response.Write("<script>alert(\"你没有权限,请与管理员联系!\")</script>");
Response.Write("<script>history.back();</script>");
}
else
{
if(!Page.IsPostBack)
{
BindEmployeeList();
BindDepartmentList();
if(EmployeeList.Items.Count > 0)
{
EmployeeList.SelectedIndex = 0;
EmployeeID.Text = EmployeeList.SelectedItem.Text.Trim();
PMS.Components.Employee Employee = new PMS.Components.Employee();
DataTable DT = Employee.GetEmployee();
OldDepart.Text = GetOldDepartmentName(EmployeeID.Text.Trim());
}
}
}
}
private void BindEmployeeList()
{
///定义获取数据的类
PMS.Components.Employee Employee = new PMS.Components.Employee();
DataTable DT = Employee.GetEmployee();
///设定控件的数据源
EmployeeList.DataSource = DT;
///设定控件的Text属性和Value属性
EmployeeList.DataTextField = "EmployeeID";
EmployeeList.DataValueField = "EmployeeID";
///绑定控件的数据
EmployeeList.DataBind();
}
private void BindDepartmentList()
{
///定义获取数据的类
PMS.Components.Department Department = new PMS.Components.Department();
DataTable DT = Department.GetDepartment();
///设定控件的数据源
DepartmentList.DataSource = DT;
///设定控件的Text属性和Value属性
DepartmentList.DataTextField = "DepartName";
DepartmentList.DataValueField = "DepartID";
///绑定控件的数据
DepartmentList.DataBind();
}
private string GetOldDepartmentID(string EmployeeID)
{
PMS.Components.Employee Employee = new PMS.Components.Employee();
DataTable DT1 = Employee.GetEmployee(EmployeeID);
string OldDepartID = DT1.Rows[0]["DepartID"].ToString();
return OldDepartID;
}
private string GetOldDepartmentName(string EmployeeID)
{
string OldDepartID = GetOldDepartmentID(EmployeeID);
PMS.Components.Department Department = new PMS.Components.Department();
DataTable DT2 = Department.GetDepartment(OldDepartID);
string OldDepartName = DT2.Rows[0]["DepartName"].ToString();
return OldDepartName;
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
}
#endregion
protected void ReturnBtn_Click(object sender, System.EventArgs e)
{
Response.Redirect("TransferMng.aspx");
}
protected void AddBtn_Click(object sender, System.EventArgs e)
{
if(Page.IsValid == true)
{
///定义类
PMS.Components.Transfer Transfer = new PMS.Components.Transfer();
string OldDepartID = GetOldDepartmentID(EmployeeID.Text.Trim());
try
{
///添加操作
string str = "insert into [Transfer]([Position],OldDepart,NewDepart,Pubdate,Reason,EmployeeID,Remark ) values('"+NewPosition.Text.Trim()
+ "','" + OldDepartID + "','" + DepartmentList.SelectedValue.Trim() + "','" + Convert.ToDateTime(PubDate.Text.Trim())
+ "','" + Reason.Text.Trim() + "','" + EmployeeList.SelectedValue.Trim() + "','" + Remark.Text.Trim() +"' )";
if(Transfer.AddTransfer(str))
{
///显示操作结果信息
Response.Write ("<script>window.alert('" + "添加数据子项成功!!!" + "')</script>");
Response.Redirect("TransferMng.aspx",false);
}
}
catch(Exception ex)
{
///显示添加操作中的失败、错误信息
PMS.Common.SystemError.SystemLog(ex.Message) ;
Response.Redirect(ex.Message) ;
}
}
}
protected void EmployeeList_SelectedIndexChanged(object sender, System.EventArgs e)
{
if(EmployeeList.SelectedIndex > -1)
{
EmployeeID.Text = EmployeeList.SelectedItem.Text.Trim();
OldDepart.Text = GetOldDepartmentName(EmployeeID.Text.Trim());
}
else
{
///显示操作结果信息
Response.Write ("<script>window.alert('" + "请选择操作的数据子项!!!" + "')</script>");
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -