web系统开发过程概述.doc

用户权限管理子模块1、需求分析：用户角色管理功能主要包括的功能如下。(1) 用户管理：添加用户、删除用户、注销或激活用户、编辑用户、通过条件查询用户。点击“添加用户”进入填写用户相关信息提交，即可创建新用户。删除用户时直接点在此用户后的“删除” ，即可删除。当用户有效时，若想注销，则点用户后面的“注销” ，当用户无效时，若想激活，则点用户后面的“激活” 。可以指定分派用户具有的角色信息；除此之外，还可以通过用户名，角色、用户的审核状态来查询用户。(2)角色管理：添加角色分组、删除角色分组、更改角色组的成员角色、添加角色、删除角色、更改角色的成员用户。输入角色名，点击“添加”按钮，可直接添加新角色。若想删除某角色，点击此角色进入相关页面，即可删除，也可以改名。而且还可以增加或减少如何成员用户。同样，对于角色组的各功能与角色类似，这里不再赘述。（3）个人信息维护功能修改用户个人的密码、名字、所在系等信息二、概要设计：三、详细设计1、数据库设计表名：UserTable序号列名数据类型长度小数位标识主键允许空默认值说明1UserIdint40是是否2UserNamenvarchar500否3UserKeynvarchar500否4Checkedbit10否(0)表名：RoleGroupTable序号列名数据类型长度小数位标识主键允许空默认值说明1RoleGroupIdint40是是否2RoleGroupNamenvarchar500否3SingleValuedbit10是表名：RoleTable序号列名数据类型长度小数位标识主键允许空默认值说明1RoleIdint40是是否2RoleNamenvarchar500否3RoleGroupIdint40是表名：UserRoleTable序号列名数据类型长度小数位标识主键允许空默认值说明1UserRoleIdint40是是否2UserIdint40否3RoleIdint40否2、模块设计项目解决方案：表现层+业务罗基层+数据访问层+实体层实体层：using System;namespace UserPrivilege.Model / / 实体类UserTableModel 。(属性说明自动提取数据库字段的描述信息) / Serializable public class UserTableModel public UserTableModel() #region Model private int _userid; private string _username; private string _userkey; private bool _checked; / / / public int UserId set _userid = value; get return _userid; / / / public string UserName set _username = value; get return _username; / / / public string UserKey set _userkey = value; get return _userkey; / / / public bool Checked set _checked = value; get return _checked; #endregion Model 数据访问层：using System;using System.Data;using System.Text;using System.Data.SqlClient;using DBUtility;/请先添加引用namespace UserPrivilege.DAL / / 数据访问类UserTableDAL。 / public class UserTableDAL public UserTableDAL() #region 成员方法 / / 得到一个对象实体 / public UserPrivilege.Model.UserTableModel GetModelByName(string UserName) StringBuilder strSql = new StringBuilder(); strSql.Append(select top 1 UserId,UserName,UserKey,Checked from UserTable ); strSql.Append( where UserName=UserName ); SqlParameter parameters = new SqlParameter(UserName, SqlDbType.NVarChar,50); parameters0.Value = UserName; UserPrivilege.Model.UserTableModel model = new UserPrivilege.Model.UserTableModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables0.Rows.Count 0) if (ds.Tables0.Rows0UserId.ToString() != ) model.UserId = int.Parse(ds.Tables0.Rows0UserId.ToString(); model.UserName = ds.Tables0.Rows0UserName.ToString(); model.UserKey = ds.Tables0.Rows0UserKey.ToString(); if (ds.Tables0.Rows0Checked.ToString() != ) if (ds.Tables0.Rows0Checked.ToString() = 1) | (ds.Tables0.Rows0Checked.ToString().ToLower() = true) model.Checked = true; else model.Checked = false; return model; else return null; / / 获得数据列表 / public DataSet GetList(string strWhere) StringBuilder strSql = new StringBuilder(); strSql.Append(select UserId,UserName,UserKey,Checked ); strSql.Append( FROM UserTable ); if (strWhere.Trim() != ) strSql.Append( where + strWhere); strSql.Append( ORDER BY UserName ); return DbHelperSQL.Query(strSql.ToString(); / / 增加一条数据 / public int Add(UserPrivilege.Model.UserTableModel model) StringBuilder strSql = new StringBuilder(); strSql.Append(insert into UserTable(); strSql.Append(UserName,UserKey,Checked); strSql.Append( values (); strSql.Append(UserName,UserKey,Checked); strSql.Append(;select IDENTITY); SqlParameter parameters = new SqlParameter(UserName, SqlDbType.NVarChar,50),new SqlParameter(UserKey, SqlDbType.NVarChar,50),new SqlParameter(Checked, SqlDbType.Bit,1); parameters0.Value = model.UserName; parameters1.Value = model.UserKey; parameters2.Value = model.Checked; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj = null) return 1; else return Convert.ToInt32(obj); / / 删除一条数据 / public void Delete(int UserId) StringBuilder strSql = new StringBuilder(); strSql.Append(delete from UserTable ); strSql.Append( where UserId=UserId ); SqlParameter parameters = new SqlParameter(UserId, SqlDbType.Int,4); parameters0.Value = UserId; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); / / 更新一条数据 / public void Update(UserPrivilege.Model.UserTableModel model) StringBuilder strSql = new StringBuilder(); strSql.Append(update UserTable set ); strSql.Append(UserName=UserName,); strSql.Append(UserKey=UserKey,); strSql.Append(Checked=Checked); strSql.Append( where UserId=UserId ); SqlParameter parameters = new SqlParameter(UserId, SqlDbType.Int,4),new SqlParameter(UserName, SqlDbType.NVarChar,50),new SqlParameter(UserKey, SqlDbType.NVarChar,50),new SqlParameter(Checked, SqlDbType.Bit,1); parameters0.Value = model.UserId; parameters1.Value = model.UserName; parameters2.Value = model.UserKey; parameters3.Value = model.Checked; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); #endregion 成员方法 using System;using System.Data;using System.Collections.Generic;using UserPrivilege.Model;namespace UserPrivilege.BLL / / 业务逻辑类UserTableBLL 的摘要说明。 / public class UserTableBLL private readonly UserPrivilege.DAL.UserTableDAL dal = new UserPrivilege.DAL.UserTableDAL(); public UserTableBLL() #region 成员方法 / / 得到一个对象实体 / public UserPrivilege.Model.UserTableModel GetModelByUserName(string UserName) return dal.GetModelByName(UserName); / / 获得数据列表 / public DataSet GetList(string strWhere) return dal.GetList(strWhere); / / 获得数据列表 / public List GetModelList(string strWhere) DataSet ds = dal.GetList(strWhere); return DataTableToList(ds.Tables0); / / 获得数据列表 / public List DataTableToList(DataTable dt) List modelList = new List(); int rowsCount = dt.Rows.Count; if (rowsCount 0) UserPrivilege.Model.UserTableModel model; for (int n = 0; n rowsCount; n+) model = new UserPrivilege.Model.UserTableModel(); if (dt.RowsnUserId.ToString() != ) model.UserId = int.Parse(dt.RowsnUserId.ToString(); model.UserName = dt.RowsnUserName.ToString(); model.UserKey = dt.RowsnUserKey.ToString(); if (dt.RowsnChecked.ToString() != ) if (dt.RowsnChecked.ToString() = 1) | (dt.RowsnChecked.ToString().ToLower() = true) model.Checked = true; else model.Checked = false; modelList.Add(model); return modelList; / / 获得数据列表 / public DataSet GetAllList() return GetList(); / / 获得全部用户对象 / public List GetAllModelList() return GetModelList(); / / 增加一条数据 / public int Add(UserPrivilege.Model.UserTableModel model) return dal.Add(model); / / 删除一条数据 / public void Delete(int UserId) dal.Delete(UserId); / / 更新一条数据 / public void Update(UserPrivilege.Model.UserTableModel model) dal.Update(model); #endregion 成员方法 Web层（1）aspx页面Web层（2）页面后台代码using System;using System.Collections.Generic;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using System.Data;using UserPrivilege.Model;public partial class UserPrivilegeWeb_UserCreate2 : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) if (!Page.IsPostBack) UserPrivilege.BLL.RoleTableBLL roleTableBLL = new UserPrivilege.BLL.RoleTableBLL(); DataSet roleTableDS = roleTableBLL.GetAllList(); RoleCheckBoxList.DataSource = roleTableDS; RoleCheckBoxList.DataTextField = RoleName; RoleCheckBoxList.DataValueField = RoleId; RoleCheckBoxList.DataBind(); userNameTextBox.Focus(); protected void SubmiitButton_Click(object sender, EventArgs e) string userName = userNameTextBox.Text.Trim(); userName = userName.Replace( , ); userName = userName.Replace(, );/中文空格 userName = userName.Replace(*, ); userName = userName.Replace(, ); userName = userName.Replace(, ); userName = userName.Replace(=, ); userName = userName.Replace(, ); userName = userName.Replace(, ); userName = userName.Replace(/, ); userName = userName.Replace(%, ); userName = userName.Replace(, ); userName = userName.Replace(, ); userName = userName.Replace(?, ); userName = userName.Replace(#, ); string userKey = userKeyTextBox.Text; userKey = userKey.Replace( , ); userKey = userKey.Replace(, );/中文空格 userKey = userKey.Replace(*, ); userKey = userKey.Replace(, ); userKey = userKey.Replace(, ); userKey = userKey.Replace(=, ); userKey = userKey.Replace(, ); userKey = userKey.Replace(, ); userKey = userKey.Replace(/, ); userKey = userKey.Replace(%, ); userKey = userKey.Replace(, ); userKey = userKey.Replace(, ); userKey = userKey.Replace(?, ); userKey = userKey.Replace(#, ); if (String.IsNullOrEmpty(userName) Response.Write(window.alert(用户名不能为空！); userNameTextBox.Focus(); return; UserPrivilege.BLL.UserTableBLL userTableBLL = new UserPrivilege.BLL.UserTableBLL(); if (userTableBLL.GetModelByUserName(userName) != null) Response.Write(window.alert(用户名冲突！); userNameTextBox.Focus(); return; else UserTableModel user = new UserTableModel(); user.UserName = userName; user.UserKey = userKey; user.Checked = true; user.UserId = userTableBLL.Add(user); UserRoleTableModel userRole =