📄 updatesalaryitem.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.Salary
{
/// <summary>
/// UpdateSalaryItem 的摘要说明。
/// </summary>
public class UpdateSalaryItem : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label lblLReceiver;
protected System.Web.UI.WebControls.TextBox Name;
protected System.Web.UI.WebControls.RequiredFieldValidator rfN;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.DropDownList TypeList;
protected System.Web.UI.WebControls.Label lblAdditionalNo;
protected System.Web.UI.WebControls.TextBox BaseValue;
protected System.Web.UI.WebControls.RequiredFieldValidator rfB;
protected System.Web.UI.WebControls.RegularExpressionValidator reS;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.DropDownList BelongList;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.DropDownList OperationList;
protected System.Web.UI.WebControls.Label Label5;
protected System.Web.UI.WebControls.Label Label6;
protected System.Web.UI.WebControls.DropDownList SalaryList;
protected System.Web.UI.WebControls.Label Label3;
protected System.Web.UI.WebControls.TextBox Remark;
protected System.Web.UI.WebControls.Button UpdateBtn;
protected System.Web.UI.WebControls.Button ReturnBtn;
protected System.Web.UI.WebControls.DropDownList TaxRatioList;
private int nSalaryItemID = 0;
private int nSalaryID = -1;
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["SalaryID"] != null)
{
nSalaryID = Int32.Parse(Request.Params["SalaryID"].ToString());
}
if(Request.Params["SalaryItemID"] != null)
{
nSalaryItemID = Int32.Parse(Request.Params["SalaryItemID"].ToString());
}
if(!Page.IsPostBack)
{
///绑定控件的数据
BindSalaryData();
BindTaxRatioData();
///绑定控件的数据
if(nSalaryItemID > -1)
{
///显示信息
BindSalaryItemData(nSalaryItemID);
}
}
///控制按钮的可用性
UpdateBtn.Enabled = nSalaryItemID <= -1 ? false : true;
}
private void BindSalaryData()
{
///定义获取数据的类
MisPersonnel.Components.Salary salary = new MisPersonnel.Components.Salary();
SqlDataReader recs = salary.GetSalarys();
///设定控件的数据源
SalaryList.DataSource = recs;
///设定控件的Text属性和Value属性
SalaryList.DataTextField = "Desn";
SalaryList.DataValueField = "SalaryID";
///绑定控件的数据
SalaryList.DataBind();
///关闭数据读取器和数据库的连接
recs.Close();
}
private void BindTaxRatioData()
{
///定义获取数据的类
MisPersonnel.Components.TaxRatio ratio = new TaxRatio();
SqlDataReader recr = ratio.GetTaxRatios();
///设定控件的数据源
TaxRatioList.DataSource = recr;
///设定控件的Text属性和Value属性
TaxRatioList.DataTextField = "Desn";
TaxRatioList.DataValueField = "TaxRatioID";
///绑定控件的数据
TaxRatioList.DataBind();
///关闭数据读取器和数据库的连接
recr.Close();
}
private void BindSalaryItemData(int nSalaryItemID)
{
///定义获取数据的类
MisPersonnel.Components.SalaryItem salaryItem = new SalaryItem();
SqlDataReader recs = salaryItem.GetSingleSalaryItem(nSalaryItemID);
///从获取的数据中读取数据
if(recs.Read())
{
Name.Text = recs["Name"].ToString();
BaseValue.Text = recs["BaseValue"].ToString();
Remark.Text = recs["Remark"].ToString();
///设置列表控件的选择值
MisSystem.SetListBoxItem(TypeList,recs["Type"].ToString());
MisSystem.SetListBoxItem(BelongList,recs["IsBelong"].ToString());
MisSystem.SetListBoxItem(OperationList,recs["Operation"].ToString());
MisSystem.SetListBoxItem(TaxRatioList,recs["TaxRatioID"].ToString());
MisSystem.SetListBoxItem(SalaryList,recs["SalaryID"].ToString());
}
///关闭数据读取器和数据库的连接
recs.Close();
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.UpdateBtn.Click += new System.EventHandler(this.UpdateBtn_Click);
this.ReturnBtn.Click += new System.EventHandler(this.ReturnBtn_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void ReturnBtn_Click(object sender, System.EventArgs e)
{
///跳转到管理页面
Response.Redirect("~/DesktopModules/Salary/SalaryItemManage.aspx?SalaryID=" + nSalaryID.ToString());
}
private void UpdateBtn_Click(object sender, System.EventArgs e)
{
if(Page.IsValid == true)
{
///定义类
MisPersonnel.Components.SalaryItem salaryItem = new SalaryItem();
try
{
///修改操作
salaryItem.UpdateSalaryItem(nSalaryItemID,Name.Text.Trim(),
Int32.Parse(TypeList.SelectedValue),
Convert.ToDecimal(BaseValue.Text.Trim()),
Int32.Parse(BelongList.SelectedValue),
Int32.Parse(OperationList.SelectedValue),
Int32.Parse(TaxRatioList.SelectedValue),
Int32.Parse(SalaryList.SelectedValue),
Remark.Text);
///显示操作结果信息
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"," "));
}
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -