📄 updateresource.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 System.Data.SqlClient;
using MisOfficeAffair.Components;
namespace MisOfficeAffair.DesktopModules.Resource
{
/// <summary>
/// UpdateResource 的摘要说明。
/// </summary>
public class UpdateResource : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Label lblLReceiver;
protected System.Web.UI.WebControls.TextBox Name;
protected System.Web.UI.WebControls.RequiredFieldValidator rfSub;
protected System.Web.UI.WebControls.Label Label6;
protected System.Web.UI.WebControls.DropDownList TypeList;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox Quantity;
protected System.Web.UI.WebControls.RegularExpressionValidator reP;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.TextBox Price;
protected System.Web.UI.WebControls.RequiredFieldValidator rfNew;
protected System.Web.UI.WebControls.RegularExpressionValidator reNew;
protected System.Web.UI.WebControls.Label Label4;
protected System.Web.UI.WebControls.TextBox Detail;
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.RequiredFieldValidator rfQ;
protected System.Web.UI.WebControls.Button ReturnBtn;
private int nResourceID = -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["ResourceID"] != null)
{
nResourceID = Int32.Parse(Request.Params["ResourceID"].ToString());
}
if(!Page.IsPostBack)
{
///绑定控件的数据
BindTypeData();
if(nResourceID > -1)
{
BindResourceData(nResourceID);
}
}
///设置添加按钮的可用性
UpdateBtn.Enabled = (TypeList.Items.Count <= 0 || nResourceID <= -1) ? false : true;
}
private void BindTypeData()
{
///定义获取数据的类
MisOfficeAffair.Components.Type type = new MisOfficeAffair.Components.Type();
SqlDataReader rect = type.GetTypes();
///设定控件的数据源
TypeList.DataSource = rect;
///设定控件的Text属性和Value属性
TypeList.DataTextField = "Name";
TypeList.DataValueField = "TypeID";
///绑定控件的数据
TypeList.DataBind();
///关闭数据读取器和数据库的连接
rect.Close();
}
private void BindResourceData(int nResourceID)
{
///定义获取数据的类
MisOfficeAffair.Components.Resource resource = new MisOfficeAffair.Components.Resource();
SqlDataReader recr = resource.GetSingleResource(nResourceID);
///从获取的数据中读取数据
if(recr.Read())
{
Name.Text = recr["Name"].ToString();
Quantity.Text = recr["Quantity"].ToString();
Price.Text = recr["Price"].ToString();
Detail.Text = recr["Detail"].ToString();
Remark.Text = recr["Remark"].ToString();
///设置列表控件的数据
MisSystem.SetListBoxItem(TypeList,recr["TypeID"].ToString());
}
///关闭数据读取器和数据库的连接
recr.Close();
}
private void ReturnBtn_Click(object sender, System.EventArgs e)
{
///跳转到管理页面
Response.Redirect("~/DesktopModules/Resource/ResourceManage.aspx");
}
private void UpdateBtn_Click(object sender, System.EventArgs e)
{
if(Page.IsValid == true)
{
///定义类
MisOfficeAffair.Components.Resource resource = new MisOfficeAffair.Components.Resource();
try
{
///修改操作
resource.UpdateResource(nResourceID,Name.Text,
Int32.Parse(TypeList.SelectedValue),
Int32.Parse(Quantity.Text),
Convert.ToDecimal(Price.Text),
Detail.Text,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"," "));
}
}
}
#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
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -