乐五八用户注册 .NET中三层构架开发实例-用户注册系统

.NET中三层构架开发实例-用户注册系统  

下面是用户注册系统开发的三层构架实例 数据库基类采用上面提供的代码 用户注册模块数据层开发 using System;using System Data;using System Data SqlClient;using HaiSky HtJob;using System Xml;namespace HaiSky HtJob Accounts AccountsData{    public class User : HaiSky HtJob HaiSkyDbObject    {        public User(string newConnectionString) : base(newConnectionString)        {//直接路由连接字符串}        public int Create(string user_nm string user_pwd)        {            int rowsAffected;            SqlParameter[] parameters = {new SqlParameter( @user_nm SqlDbType Char )                                         new SqlParameter( @user_pwd SqlDbType Char )};            parameters[ ] Value = user_nm;            parameters[ ] Value = user_pwd;            parameters[ ] Direction = ParameterDirection Output;            try            {                RunProcedure( IF_user_info parameters out rowsAffected);            }            catch            {    }            return (int)parameters[ ] Value;        }    }} 用户注册商务层开发using System;using System Configuration;using HaiSky HtJob Accounts AccountsData;namespace HaiSky HtJob Accounts AccountBusiness{    public class User : HaiSky HtJob HaiSkyBizObject     {        int userID;        string userName;        string userPwd;        string strConn;        public User()        {            strConn = ConfigurationSettings AppSettings[ strConn ];        }        public int Careate()        {            AccountsData User dataUser = new AccountsData User(strConn);            userID = dataUser Create(userName userPwd);            return userID;        }        public int UserID        {            get            {                return userID;            }            set            {                userID = value;            }        }        public string UserName        {            get            {                return userName;            }            set            {                userName = value;            }        }        public string UserPwd        {            get            {                return userPwd;            }            set            {                userPwd = value;            }        }    }}  用户注册表示层开发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 HaiSky HtJob Accounts AccountBusiness;namespace HaiSky HtJob Modules Accounts{    public class Register : System Web UI Page    {        protected System Web UI WebControls TextBox TextBox ;        protected System Web UI WebControls TextBox TextBox ;        protected System Web UI WebControls Table Table ;        protected System Web UI WebControls Button Button ;        private void Page_Load(object sender System EventArgs e)        {            Table Rows[ ] Cells[ ] Visible = false;        }        #region Web Form Designer generated code        override protected void OnInit(EventArgs e)        {            InitializeComponent();            base OnInit(e);        }            private void InitializeComponent()        {                this Button Click += new System EventHandler(this Button _Click);            this Load += new System EventHandler(this Page_Load);        }        #endregion        private void Button _Click(object sender System EventArgs e)        {            int i;            HtJob Accounts AccountBusiness User BusinessUser = new HtJob Accounts AccountBusiness User();            BusinessUser UserName = TextBox Text;            BusinessUser UserPwd = TextBox Text;            i = BusinessUser Careate();            Response Write (i ToString());                         //这里输出返回值        }    }} 该系统调用的存储过程CREATE PROCEDURE IF_user_info (@user_nm char( ) @user_pwd char( ) @user_ID int output)AS    insert user_info(user_nm user_pwd) values(@user_nm @user_pwd)set @user_ID = @@identity    IF @@ERROR >         BEGIN        RAISERROR ( Insert of Article failed ) lishixinzhi/Article/program/net/201311/13704