📄 usermanage.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 System.Collections.Generic;
using BookManage.BLL;
using BookManage.Model;
namespace BookManage.Admin
{
/// <summary>
/// UserManage 的摘要说明。
/// </summary>
public partial class UserManage : System.Web.UI.Page
{
protected string stars = "false";
EMUser user=new EMUser();
protected void Page_Load(object sender, System.EventArgs e)
{
if (Request.QueryString["action"] == "modify"&&Request.QueryString["UserID"]!=null&&!Page.IsPostBack)
{
EMUserProfile profile = new EMUserProfile();
profile = user.GetUserDetail(Request.QueryString["UserID"]);
txtUserName.Text = profile.UserName;
ddlPower.Value = profile.UserPower.ToString();
stars = "true";
}
if (Request.QueryString["power"] != null)
{
dgUserList.DataSource = user.GetUserListByPower(Convert.ToInt32(Request.QueryString["power"]));
dgUserList.DataBind();
}
}
#region
/// <summary>
/// 绑定datagrid的数据
/// </summary>
/// <param name="doFilter">是否指定用户权限读取数据</param>
/// <param name="userPower">用户权限</param>
/*
void BindData()
{
int pageCount;
int currentPage;
int rowCount;
int userPower;
const int pageSize=5;
SqlDataReader reader=null;
//获取设置当前页
if(Request.QueryString["page"]==null)
{
currentPage=1;
}
else
{
currentPage=Convert.ToInt32(Request.QueryString["page"]);
}
//开始读取数据
if(Request.QueryString["power"]==null)
{
rowCount=user.UserListCount(false,0);
user.GetUserList(currentPage,pageSize,out reader);
dgUserList.DataSource=reader;
dgUserList.DataBind();
//关闭数据库连接及dataReader
reader.Close();
pageCount=(int)Math.Ceiling((double)rowCount/pageSize);
//设定第一页的链接地址
lnkFirst.NavigateUrl="UserManage.aspx";
//设定下一页的链接地址
if(pageCount>1 && currentPage<pageCount)
lnkNext.NavigateUrl="UserManage.aspx?page="+(currentPage+1);
else if(currentPage==pageCount)
lnkNext.Enabled=false;
//设定上一页的链接地址
if(currentPage==1)
lnkPre.Enabled=false;
else
lnkPre.NavigateUrl="UserManage.aspx?page="+(currentPage-1);
//设定最后一页的链接地址
lnkLast.NavigateUrl="UserManage.aspx?page="+pageCount;
//请求的页码超过页数则重定向到最后一页
if(currentPage>pageCount)
Response.Redirect("UserManage.aspx?page="+pageCount);
}
else
{
userPower=Convert.ToInt32(Request.QueryString["power"]);
rowCount=user.UserListCount(true,userPower);
user.GetUserList(userPower,pageSize,out reader);
dgUserList.DataSource=reader;
dgUserList.DataBind();
//关闭数据库连接及dataReader
reader.Close();
pageCount=(int)Math.Ceiling((double)rowCount/pageSize);
//设定第一页的链接地址
lnkFirst.NavigateUrl="UserManage.aspx?power="+userPower;
//设定下一页的链接地址
if(pageCount>1 && currentPage<pageCount)
lnkNext.NavigateUrl="UserManage.aspx?page="+(currentPage+1)+"&power="+userPower;
else if(currentPage==pageCount)
lnkNext.Enabled=false;
//设定上一页的链接地址
if(currentPage==1)
lnkPre.Enabled=false;
else
lnkPre.NavigateUrl="UserManage.aspx?page="+(currentPage-1)+"&power="+userPower;
//设定最后一页的链接地址
lnkLast.NavigateUrl="UserManage.aspx?page="+pageCount+"&power="+userPower;
//请求的页码超过页数则重定向到最后一页
if(currentPage>pageCount)
Response.Redirect("UserManage.aspx?page="+pageCount+"&power="+userPower);
}
ViewState["pageCount"]=pageCount;
ViewState["currentPage"]=currentPage;
}*/
#endregion
protected void btnSubmit_Click(object sender, System.EventArgs e)
{
//确保表单已经通过验证
if(Page.IsValid)
{
EMUserProfile profile = new EMUserProfile();
profile.UserName = txtUserName.Text;
profile.Password = txtPwd.Value;
profile.UserPower = ddlPower.SelectedIndex;
//检查用户名是否存在
if (Request.QueryString["action"] == "modify" && Request.QueryString["UserID"] != null)
{
profile.UserID = Request.QueryString["UserID"];
int result= user.UpdateUserProfile(profile);
if (result > 0)
{
Message.Alert("更新成功", Request.QueryString["return"]);
}
else
Message.Alert("更新失败,请确保URL未被修改",this.Page);
}
else
{
if (user.UserNameExiste(profile.UserName))
{
lblNotifyAddUser.Text = "添加失败,用户名已存在";
return;
}
else
{
//用户名不存在则开始添加用户
int result = user.AddUser(profile);
if (result > 0)
{
Message.Alert("添加成功", "UserManage.aspx");
}
}
}
}
}
protected string SetUserPower()
{
string power = "普通用户";
if (Eval("UserPower").ToString() == "1")
power = "管理员";
return power;
}
protected void btnSearch_ServerClick(object sender, EventArgs e)
{
dgUserList.DataSource = user.SearchUserListResult(Request["txtSearch"]);
dgUserList.DataBind();
}
protected void dgUserList_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string userID = dgUserList.DataKeys[e.RowIndex].Value.ToString();
user.DeleteUser(userID);
if (Request.QueryString["power"] != null)
Message.Alert("删除成功", "UserManage.aspx?power=" + Request.QueryString["power"]);
else
Message.Alert("删除成功", "UserManage.aspx");
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -