web系统开发过程概述

1、用户权限管理子模块1、需求分析：用户角色管理功能主要包括的功能如下。(1) 用户管理：添加用户、删除用户、注销或激活用户、编辑用户、通过条件查询用户。点击“添加用户”进入填写用户和关信息提交，即可创建新用户。删除用户时直接点在此 用户后的“删除”，即可删除。当用户有效时，若想注销，则点用户后面的“注销”，当用 户无效时，若想激活，则点用户后面的“激活”。可以指定分派用户具有的角色信息；除此之 外，还可以通过用户名，角色、用户的审核状态来査询用户。(2) 角色管理：添加角色分组、删除角色分组、更改角色组的成员角色、添加角色、删除角 色、更改角色的成员用户。输入角色名，点击“添加”按钮，可直接添加

2、新角色。若想删除某角色，点击此角色进入 相关页面，即可删除，也可以改名。而且还可以增加或减少如何成员用户。同样，对于角色组 的各功能与角色类似，这里不再赘述。(3) 个人信息维护功能修改用户个人的密码、名字、所在系等信息二、概要设计:三、详细设计1、数据库设计表名:usertable序号列名数裾类型长度小数位标识主键允许空默认值说明1useridint40是是否2usernamenvarchar500否3userkeynvarchar500否4checkedbit10否（）表名：rolegrouptable序号列名数据类型长度小数位标识主键允许空默认值说明1rolegroupidint40是是

3、否2rolcgroupnamcnvarchar500否3singlevaluedbit10是表名:roletable序号列名数据类型长度小数位标识主键允许空默认值说明1roleldint40是是否2rolenamcnvarchar500否3rolegroupidint40是表名:userroletable序号列名数据类型长度小数位标识主键允许空默认值说明1userroleldint40是是否2useridint40否3roleldint40否2、模块设计项目解决方案：表现层+业务罗基层+数据访问层+实体层实体层:using system;namespace uscrprivilcgc. mod

4、el/ summary/实体类usertablemodel。（属性说明自动提取数据库字段的描述信总） / /summaryserializablepublic class l'sertablevlodelpublic uscrtablemodel()region model private int userid; private string username; private string _uscrkey; private bool _checked;/ summary/ /summarypublic int useridset jjserid = value;) get retu

5、rn _userid; iii summaryiiiiii /summarypublic string usernctmeset _username = value; get return _username; iii summaryiiiiii /summarypublic string userkeyset userkey = value; get return userkey; iii summaryiiiiii /summarypublic bool checkedset checked = value: get return .checked;)#endregion model数据访

6、问层：c33解决方案'jt （12个项目）+1+1+1+1+1+1+1+1+1+1commond：.jxsys笠1 dbutilitypaper management. bll paper management. dal paper management. model jji projectmanagement. bll 詔 projectlanagebent.dal jji proj ectmanagement. model userprivilege. bll userprivilege. dal l:s| properties 隨引用rolegrouptabledal. cs r

7、oletabledal.es userroletabledal. cs userroleviewdal.es usertabledal. csl+ll+l+1userprivilege. modelg解决方案资源管理器类视团jgl馬性using system;using system. delta;using system. text;using system. data. sqlclicnt: using dbutility;/请先添加引用 namespace userprivilege. dal / <sumniciry>/ 数hi访问类usertabledal。 iii /s

8、ummary public class usertabledal public usertabledal()region成w方法/ summary/得到一个对象实体iii /summarypublic userprivilege. model. usertablcmodel got.viodclbyname(string uscrname)stringbuiider strsql = new stringbuiider();strsql. append ("select top 1 userid, userncime, userkey, checked from usertable

9、)； strsql. append (/z where uscrname-uscrnamc )；sqlparameter parameters = new sq1 parameter(username，sq1dbtype. nvarchar, 50);parametersfo. value = username;userprivilege. model. usertable.vlodel model = new userprivilege. model. usertable.vlodel (): dcitciset ds = dbhel persqi,. query (strsql. tost

10、ringo, parameters): if (ds. tables0. rows. count > 0)if (ds. tables0. rows0 "userid". tostringo != ”)model. usertd = int. parse (ds. tables0. rows0 "usertd". tostringo):model. username = ds. tables0. rows0 username. tostringo ； model. userkey = ds. tables0. rows0 "userkoy

11、". tostringo ; if (ds. tables0. rows0 "checked". tostringo !="")if (ds. tables0. rows0 "checked". tostringo = 1)| |(ds. tables0. rows0 "checked". tostringo. tolowero = "true")model. checked = true;elsemodel. checked = false;)return model;elseret

12、urn null;/ summary/获得数据列表 iii </summary>public dataset getlist(string strwhere)stringbuilder strsql = new stringbuilder0:strsql.append ("select usertd, username, userkey, checked ");strsql. append(" from usertable ");if (strwhere. trim() != )strsql. append( where + strwhere

13、):strsql.append( order by username "); return dbllel persql. query (strsql. tostringo):iii <suniniary>iii增加一条数据iii /summarypublic int add(userprivilege. model. usertablemodel model)stringbuiider strsql = new stringbuiider(): strsql. append(，zinsert into usertable()； strsql. append("u

14、sername, userkey, checked)"); strsql. append( values ()；strsql. append("username, uscrkey, checked)"); strsql. append(":select 綱identity");sqlparameter parameters = new sqlparameter ("即sername", sqldbtype. nvarchar, 50), new sq1 parameter(userkey，sq1dbtype. nvarcha

15、r, 50), new sqlparameter("checked”，sqldbtypc. bit,1);parameters0. value = model. username; parametersl. value = model. userkey; parameters2. value = model. checked;object obj = dbhclpcrsql. getsingle(strsql. tostringo, parameters): if (obj - null)return 1;elsereturn convert. tolnt32(obj):iii su

16、mmaryiii删除一条数据iii /summarypublic void delete(int userid)stringbuiider strsql = new stringbuiider():strsql. append ('"delete from usertable ");strsql. append(" where userid=userid )；sqlpcirameler parameters = new sqlparameter(userid，sqldbtypc. int,4);parameters0. value = userid;dbh

17、elpersql. executesql (strsql. tostringo, parameters):/ <sumniciry>iii更新一条数据iii "summarypublic void update(userprivilege. model. usertablemodel model)slringbuiider strsql = new slringbuiider(); strsql. append (叩date usertablc set )； strsql. append c'ljsername=ljsername, )； strsql. appe

18、nd (z，userkeyuserkey,z，): strsql. append ("checkecmchecked"); strsql.append(" where userld=userid ");sqlparamctcr parameters = new sq1 parameter("userid", sqldbtype. int, 4), new sqlparameter("username", sqldbtype. nvarchar, 50), new sq 1 parameter czuserkey，z

19、, sqldbtype. nvarchar, 50), new sqlparameter(checked，sqldbtype. bit, 1):paramctcrsfo. value = model. userid; parameters1. value = model. username; parameters2. value = model. userkey; parameters3j. value = model. checked;dbhclpersql. executcsql(strsql. tostringo, parameters):#endregion成员方法解决方案资源官理器-

20、解决方案（12个.®+1+1+1+1+1+1+1為dbutility+1paper management. bll paper management. dal paper management. model proj ectmanagement. bll proj ectlanagebent.dal proj ectmanagement. model userprivilege. bll i:ul properties 阑引用l：=1 rolegrouptablebll.es 省 roletablebll.cs l：=1 userroletablebll. cs c=1 userro

21、levi ewbll. cs省画画画userprivilege. dal i:ul properties 阑引用rolegrouptabledal.es 省 roletabledal.csuserroletabledal. cs 进 1 userroleviewdal. csusertabledal. cs userprivilege. modelg解决方案资源管理器陶类视呵舒屆司using system;using system. data;using system. collections. generic; using userprivilege. model; namespace us

22、erprivilege. blliii summary/业务逻辑类usertablebll的摘要说明。iii /summarypublic class usertablcbllprivate readonly userprivilege. dal. usertabledal dal = new userprivilege. dal. usertabledal(): public usertablebllo region成员方法iii summaryiii得到一个对象实体 iii /summarypublic userprivilege. model. usertablemodel getmod

23、e 1 byuserncime(string userncime)return dal. getmodelbyname(username):iii summary/获得数据列表/ /summarypublic dataset getlist (string strwherc)return dal. getlist(strwhere):iii summary/获得数据列表iii /summarypublic lis 1 <userprivi 1 ege. model. usertab 1 emode 1 > getmodell.ist (string strwhere)dataset

24、 ds = dal.getlist (strwherc): return datatabletolist(ds. tables0):iii summary/获得数据列表 iii /summarypublic list<userprivilege. model. usertablemodel> datatabletolist(dcitcitable dt)list<uscrprivilcge. model. usertablcmodel> modcllist = new list<uscrprivilcgc. model. usertablcmodel>();

25、 int rowscount = dt. rows. count; if (rowscount > 0)userprivilege. model. usertab1emode1 model; for (int n = 0; n < rowscount; n+)model = new userprivilege.model. usertab1emode1 (): if (dt. rowsn "userid". tostringo != ")model. userid = int. parse(dt. kowsn "userid". t

26、ostringo);model. username = dt. rowsn us(?rname. tostringo : model. userkey = dt. rowsn "userkey". tostringo ; if (dt. rowsnchecked". tostringo !=")if (dt. rowsn "checked". tostringo = 1)i i (dt. rowsn "checked". tostringo. tolowero = "true")model. c

27、hecked = true;elsemodel. checked = false;modellist. add(model);return modellist;iii summary/获得数据列表 iii /summarypublic dataset getalilist()return getlist()；iii (summaryiii获得全部川户对象 iii /summarypublic list<userprivi 1 ege. model. usertablemodelgetal l.vlodell.ist () return getmodellist(")：/ <

28、;summciry>/增加一条数据/ /summarypublic int add (user privilege. model. usertablevlodel model)return dal. add(model);iii summary/删除一条数据iii /summarypublic void delete(int usertd)dal. deleteserld);/ <summciry>/史新一条数据iii /summarypublic void update(userprivilege. model. usertablemodel model)dcil. upd

29、ate (model);舞end region成员方法web层(1) aspx页面解决方案资源官理器-解决方案'jr （12个項自）®33解决方案'jr (12个项目)+common日jksys+app一code一 app一data 丨由eg binhl jxsys i 由 c3 bookweb田 £3 common + 一j paper web+_| p er s onallnform at i onffl anagetf eb田 projectffeb (-)l/ userprivilegetf eb 困 flash. sw£+ jj inde

30、x, aspx -jj menuback. jpg + 底| menuli st. as ex pot3. gi £l+ll+ll+lusercreate. aspxroleedi t. aspx rolegroupedi t. aspx rolemanage. aspxusercreate. aspx. cs +usermanage. aspx+us errol eh anage. aspx"|事 web. confi g 1+ 画 default. aspx +logincontrol. as ex+_ masterpage. master画| welcomeflash

31、. sw£global, asax web. confi gdbutilityjxlicrosoft visual studiodebu any cpv，check:otwll.otr咖itio，效；祥式明笾）：手动.目标规則®）:撕注卻kit式）-m，獻认字体）jxsys/vserp.*ra為ite. a:px. « jxsts/userf . . create apz jlsis/userf?.aspx dbmelpersql. cs u2«r&oleviev»bll cs usertablebl.trnwr er page. ma

32、ster人cohterifiaceholderl (自定i创建新用户个人论文査龜 个人论文壜沪兑9论交眘曲用户名: 密码. 说明:用户角色:用户名或密码中不能包含* ,v=<>%及空格等倌息.否则将被过滤厂未绑定沪i&s.个人ar査由 个人項u蠼沪角色说明:.个ok 理臂篡b用nesfllslsgsb合合隴询全全查户ggweb层(2)页面后台代码using system;using system. collections. generic;using system. web;using system. web. ut:using system. web. ui. webco

33、ntrols;using system. data;using userprivilege. model:public partial class userpri vi legeweb usercrecite2 : system. web. ut. pageprotected void page_load(object sender, evcntargs c)if (!page. ispostback)userprivilege. bll. roletablebll roletablebll = new userpri vi lege. bll. roletciblebllo ; datase

34、t roletableds = roletablebll. gctalllist();rolecheckboxlist. datasource = roletableds;rolecheckboxlist. datatextfield = "rolename":rolecheckboxijst. datavaluefield = "roletd；rolecheckboxlist. databindo ;usernametextbox. focus ();protected void submi itbutton click (object sender, even

35、targs e)string username = usernametextbox. text. trim();username =username. kepi ace ( ，username -z username. replace(,username =username. replace(*，username :z username. replace (", ，username =:usernctme. repace(" ，username =username. kepi ace (=，username -z username. replace (<，userna

36、me =username. replace("，username :z username. replace(,username =username. repace(/，username =username. kepi ace(，username -z username. replaced,username =username. replace(，username :z username. replaceusername =:usernctme. replace(z/#z/,string uscrkcy = userkeytcxtbox.text; userkey = userkey.

37、 replace( userkey = userkey. replace (，? userkey = userkey. repace("氺 userkey = userkey. replace(， uscrkcy = userkey. replace( uscrkcy = userkey. replace(二 userkey = userkey. replace(丫 userkey = userkey. replace (，z>zz userkey = userkey. repace( userkey = userkey. replace(/ uscrkcy = userkey

38、. replace( userkey = userkey. rep1 ace( userkey = userkey. replace (，z userkey = userkey. repace("?" userkey = userkey. replace(/ / / / / / / / z zz / / / / :/中文空格if (string. isnul1orempty(username)response. write ("script language="javascript">window. alert ("用户名不能为空! ")/script");userncimetextbox. focus ();return;userprivilege. bll. usertablebll usertablebll = new userprivilege. bll. usertablebllo:if (usertablebll. getmodelbyusername(username) != null)response. write ("script language二"javascript"window. a