【正文】 2][J].安陽師范學院學報,2007(2)2628.[13][D].廣東:中山大學碩士學位論文,2005.[14][D].山東:山東大學碩士學位論文,2009.[15]Fox －過程原理與模式[M].:清華大學出版社,[16]Rafael Richard [M]::電子工業(yè)出版社,[17][M].北京:清華大學出版社,[18]Workflow Manasement Proeess Definition InterfaceXML Proeess Definition Language[S].WFMCTC1025,[19][D].北京:北京郵電大學碩士學位論文,2010.[20][J].軟件導刊,2009(5)3032.[21][J].信息技術(shù),2010(3)2527.[22]Roza democracy：Technology，cities and civicNetworks[M].Routledge,[23]Steve with Web Services[J].IEEE Internet Computing,2003,7(6):7577.[24]XML Signature Working Syntax and W3C Proposed Remendation[S].August 20,2001.[25]GUSTAVO Alonso and The Role of Database Teehnology in Workflow Management Systems[M].CooIS，[26][J] .高等農(nóng)業(yè)育 ,2006 (11):4851.[27]XML Schema W3C Remendation[EB/OL].2 May 2001,200109.[28] [M].北京:電子工業(yè)出版社,[29]John ,Stephen D Analysis and Design In a Changing World[M]:Fourth Learning Asia Pte.,[30][M]::中國人民大學出版社,[31][D].福建:東南大學碩士學位論文,2005. [32][M].北京:國防工業(yè)出版社,[33][M].北京:[34][M].北京:中國水利水電出版社,[35][D].上海:同濟大學碩士學位論文,2006.[36][EB/OL]. ,.附 錄附錄 數(shù)據(jù)庫關(guān)鍵存儲過程實現(xiàn)主要代碼/******************************************************************* 表名：userb* 時間：2010223 8:27:56* Made by Kingjunzhang******************************************************************/if exists (select * from 某市ere id = object_id(N39。[dbo].[UP_userb_Exists]39。) and OBJECTPROPERTY(id, N39。IsProcedure39。) = 1)drop procedure [dbo].[UP_userb_Exists]GO用途：是否已經(jīng)存在 項目名稱：ArchiveManage說明：時間：2009223 8:27:56CREATE PROCEDURE UP_userb_Exists@id bigint,@username varchar(50)AS DECLARE @TempID int SELECT @TempID = count(1) FROM [userb] 某市ERE id=@id and username=@username IF @TempID = 0 RETURN 0 ELSE RETURN 1GOif exists (select * from 某市ere id = object_id(N39。[dbo].[UP_userb_ADD]39。) and OBJECTPROPERTY(id, N39。IsProcedure39。) = 1)drop procedure [dbo].[UP_userb_ADD]GO用途：增加一條記錄 項目名稱：ArchiveManage說明：時間：2010223 8:27:56CREATE PROCEDURE UP_userb_ADD@id bigint output,@username varchar(50),@mm varchar(100),@zhlx varchar(50),@dwmc varchar(100),@dwdm varchar(50),@status varchar(50),@name varchar(50),@sex varchar(3),@csrq varchar(10),@sjhm varchar(50),@bgshm varchar(50),@ varchar(200),@zc varchar(50),@gzsj varchar(10),@photourl varchar(200),@lxdz varchar(500),@bz varchar(500) AS INSERT INTO [userb]( [username],[mm],[zhlx],[dwmc],[dwdm],[status],[name],[sex],[csrq],[sjhm],[bgshm],[],[zc],[gzsj],[photourl],[lxdz],[bz] )VALUES( @username,@mm,@zhlx,@dwmc,@dwdm,@status,@name,@sex,@csrq,@sjhm,@bgshm,@,@zc,@gzsj,@photourl,@lxdz,@bz ) SET @id = @@IDENTITYGOif exists (select * from 某市ere id = object_id(N39。[dbo].[UP_userb_Update]39。) and OBJECTPROPERTY(id, N39。IsProcedure39。) = 1)drop procedure [dbo].[UP_userb_Update]GO用途：修改一條記錄 項目名稱：ArchiveManage說明：時間：2010223 8:27:56CREATE PROCEDURE UP_userb_Update@id bigint,@username varchar(50),@mm varchar(100),@zhlx varchar(50),@dwmc varchar(100),@dwdm varchar(50),@status varchar(50),@name varchar(50),@sex varchar(3),@csrq varchar(10),@sjhm varchar(50),@bgshm varchar(50),@ varchar(200),@zc varchar(50),@gzsj varchar(10),@photourl varchar(200),@lxdz varchar(500),@bz varchar(500) AS UPDATE [userb] SET [mm] = @mm,[zhlx] = @zhlx,[dwmc] = @dwmc,[dwdm] = @dwdm,[status] = @status,[name] = @name,[sex] = @sex,[csrq] = @csrq,[sjhm] = @sjhm,[bgshm] = @bgshm,[] = @,[zc] = @zc,[gzsj] = @gzsj,[photourl] = @photourl,[lxdz] = @lxdz,[bz] = @bz 某市ERE id=@id and username=@username GOif exists (select * from 某市ere id = object_id(N39。[dbo].[UP_userb_Delete]39。) and OBJECTPROPERTY(id, N39。IsProcedure39。) = 1)drop procedure [dbo].[UP_userb_Delete]GO用途：刪除一條記錄 項目名稱：ArchiveManage說明：時間：2010223 8:27:56CREATE PROCEDURE UP_userb_Delete@id bigint,@username varchar(50) AS DELETE [userb] 某市ERE id=@id and username=@username GOif exists (select * from 某市ere id = object_id(N39。[dbo].[UP_userb_GetModel]39。) and OBJECTPROPERTY(id, N39。IsProcedure39。) = 1)drop procedure [dbo].[UP_userb_GetModel]GO用途：得到實體對象的詳細信息 項目名稱：ArchiveManage說明：時間：2010223 8:27:56CREATE PROCEDURE UP_userb_GetModel@id bigint,@username varchar(50) AS SELECT id,username,mm,zhlx,dwmc,dwdm,status,name,sex,csrq,sjhm,bgshm,,zc,gzsj,photourl,lxdz,bz FROM [userb] 某市ERE id=@id and username=@username GOif exists (select * from 某市ere id = object_id(N39。[dbo].[UP_userb_GetList]39。) and OBJECTPROPERTY(id, N39。IsProcedure39。) = 1)drop procedure [dbo].[UP_userb_GetList]GO系統(tǒng)詳細設(shè)計關(guān)鍵實體類及關(guān)鍵接口主要代碼using System。using 。using 。using 。using 。//請先添加引用namespace { /// summary /// 數(shù)據(jù)訪問類userb。 /// /summary public class userb { public userb() {} region 成員方法 /// summary /// 是否存在該記錄 /// /summary public bool Exists(string username,long id) { StringBuilder strSql=new StringBuilder()。 (select count(1) from userb)。 ( 某市ere username=@username and id=@id )。 SqlParameter[] parameters = { new SqlParameter(@username, ,50), new SqlParameter(@id, )}。 parameters[0].Value = username。 parameters[1].Value = id。 return ((),parameters)。 } /// summary /// 增加一條數(shù)據(jù) /// /summary public int Add( model) { StringBuilder strSql=new StringBuilder()。 (insert into userb()。 (username,mm,zhlx,dwmc,dwdm,status,name,sex,csrq,sjhm,bgshm,,zc,gzsj,photourl,lxdz,bz))。 ( values ()。 (@username