updateteacher.aspx.cs
来自「《精通ASP.NET2.0网络应用系统开发》书中的源码」· CS 代码 · 共 114 行
CS
114 行
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using StudentManager;
public partial class UpdateTeacher : System.Web.UI.Page
{
int nTeacherID = -1;
protected void Page_Load(object sender,EventArgs e)
{
///获取ID的值
if (Request.Params["TeacherID"] != null)
{
nTeacherID = Int32.Parse(Request.Params["TeacherID"].ToString());
}
if (!Page.IsPostBack)
{
///绑定控件的数据
BindDepartmentData();
if (nTeacherID > -1)
{
BindTeacherData(nTeacherID);
}
}
///设置按钮的可用性
UpdateBtn.Enabled = DepartmentList.Items.Count > 0 && nTeacherID >= 0 ? true : false;
}
private void BindDepartmentData()
{
///获取数据源
StudentManager.Department department = new Department();
SqlDataReader recd = department.GetDepartments();
///设定控件的数据源,Text域属性、value域属性
DepartmentList.DataSource = recd;
DepartmentList.DataTextField = "Desn";
DepartmentList.DataValueField = "DepartmentID";
///绑定控件的数据
DepartmentList.DataBind();
///关闭数据源和数据库的链接
recd.Close();
}
private void BindTeacherData(int nTeacherID)
{
///获取数据
Teacher teacher = new Teacher();
SqlDataReader rect = teacher.GetSingleTeacher(nTeacherID);
///读取数据
if (rect.Read())
{
///显示数据
Name.Text = rect["Name"].ToString();
Age.Text = rect["Age"].ToString();
Address.Text = rect["Address"].ToString();
Phone.Text = rect["Phone"].ToString();
Birthday.Text = rect["Birthday"].ToString();
HireDate.Text = rect["HireDate"].ToString();
ASPNET2System.SetListBoxItem(DepartmentList,rect["DepartmentID"].ToString());
}
rect.Close(); ///关闭数据源
}
protected void UpdateBtn_Click(object sender,EventArgs e)
{
///如果页面输入内容合法
if (Page.IsValid == true)
{
///定义类
StudentManager.Teacher department = new StudentManager.Teacher();
try
{
///修改
department.UpdateTeacher(nTeacherID,Name.Text.Trim(),Int32.Parse(Age.Text.Trim()),
Address.Text.Trim(),Phone.Text.Trim(),DateTime.Parse(Birthday.Text.Trim()),
DateTime.Parse(HireDate.Text.Trim()),
Int32.Parse(DepartmentList.SelectedValue));
///显示操作结果信息
Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONUPDATESUCCESSMESSAGE + "')</script>");
}
catch (Exception ex)
{
///显示修改操作中的失败、错误信息
Response.Redirect("~/DesktopModules/ErrorPage.aspx?ErrorUrl="
+ ASPNET2System.RedirectErrorUrl(Request.RawUrl)
+ "&ErrorMessage=" + ex.Message.Replace("\n"," "));
}
}
}
protected void ReturnBtn_Click(object sender,EventArgs e)
{
///返回管理页面
Response.Redirect("~/DesktopModules/Teacher/TeacherManage.aspx");
}
}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?