. NET three-tier architecture development example-User registration system

User Registration The Following is an example of a three-tier architecture developed by the user registration system: The database base class uses the code provided above.

1, user registration module data layer development:
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)
{//Direct routing connection string}
public int Create (string user_nm,string user_pwd)
{
int rowsaffected;
sqlparameter[] Parameters = {New SqlParameter ("@user_nm", sqldbtype.char,16),
New
SqlParameter ("@user_pwd", sqldbtype.char,16)};
Parameters[0]. Value = user_nm;
PARAMETERS[1]. Value = user_pwd;
PARAMETERS[2]. Direction = ParameterDirection.Output;
Try
{
Runprocedure ("If_user_info", Parameters,out rowsaffected);
}
Catch
{    }
return (int) parameters[2]. Value;
}
}
}

2, the user registers the business layer development:
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;
}
}
}
}

3, the user registers the presentation layer development:
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 TextBox1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.Table Table1;
protected System.Web.UI.WebControls.Button Button1;

private void Page_Load (object sender, System.EventArgs e)
{
Table1.rows[0]. Cells[0]. Visible = false;
}
#region Web Form Designer generated code
Override protected void OnInit (EventArgs e)
{
InitializeComponent ();
Base. OnInit (e);
}
private void InitializeComponent ()
{
This. Button1.Click + = new System.EventHandler (this. Button1_Click);
This. Load + = new System.EventHandler (this. Page_Load);
}
#endregion
private void Button1_Click (object sender, System.EventArgs e)
{
int i;
HtJob.Accounts.AccountBusiness.User businessuser = new HtJob.Accounts.AccountBusiness.User ();
Businessuser.username = TextBox1.Text;
Businessuser.userpwd = TextBox2.Text;
i = Businessuser.careate ();
Response.Write (i.ToString ()); Output return value here
}
}
}

4, the system calls the stored procedures:
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 > 0
BEGIN
RAISERROR (' Insert of Article failed ', 16, 1)