NET中三层构架开发实例

1、NET中三层构架开发实例-用户注册系统.txt39人生旅程并不是一帆风顺的，逆境失意会经常伴随着我们，但人性的光芒往往在不如意中才显示出来，希望是激励我们前进的巨大的无形的动力。40奉献是爱心，勇于付出，你一定会收到意外之外的馈赠。数据库基类usingSystem;usingSystem.Data;usingSystem.Data.SqlClient;namespaceHaiSky.HtJob/summary/DbClass的摘要说明。/</summary>publicclassDbClassprivatestringconnectionString;protectedSqlCon

2、nectionConnection;publicDbClass(stringnewConnectionString)connectionString=newConnectionString;Connection=newSqlConnection(connectionString);publicstringConnectionStringgetreturnconnectionString;privateSqlCommandBuildQueryCommand(stringstoredProcName,IDataParameterparameters)SqlCommandcommand=newSql

3、Command(storedProcName,Connection);command.CommandType=CommandType.StoredProcedure;foreach(SqlParameterparameterinparameters)command.Parameters.Add(parameter);returncommand;privateSqlCommandBuildIntCommand(stringstoredProcName,IDataParameterparameters)SqlCommandcommand=BuildQueryCommand(storedProcNa

4、me,parameters);command.Parameters.Add(newSqlParameter("ReturnValue”,SqlDbType.Int,4,ParameterDirection.ReturnValue,false,0,0,string.Empty,DataRowVersion.Default,null);returncommand;protectedintRunProcedure(stringstoredProcName,IDataParameter口parameters,outintrowsAffected)intresult;Connection.Op

5、en();SqlCommandcommand=BuildIntCommand(storedProcName,parameters);rowsAffected=command.ExecuteNonQuery();result=(int)command.Parameters"ReturnValue".Value;Connection.Close();returnresult;protectedSqlDataReaderRunProcedure(stringstoredProcName,IDataParameterparameters)SqlDataReaderreturnRea

6、der;Connection.Open();SqlCommandcommand=BuildQueryCommand(storedProcName,parameters);command.CommandType=CommandType.StoredProcedure;returnReader=command.ExecuteReader();returnreturnReader;protectedDataSetRunProcedure(stringstoredProcName,IDataParameterparameters,stringtableName)DataSetdataSet=newDa

7、taSet();Connection.Open();SqlDataAdaptersqlDA=newSqlDataAdapter();sqlDA.SelectCommand=BuildQueryCommand(storedProcName,parameters);sqlDA.Fill(dataSet,tableName);Connection.Close();returndataSet;protectedvoidRunProcedure(stringstoredProcName,IDataParameter口parameters,DataSetdataSet,stringtableName)Co

8、nnection.Open();SqlDataAdaptersqlDA=newSqlDataAdapter();sqlDA.SelectCommand=BuildIntCommand(storedProcName,parameters);sqlDA.Fill(dataSet,tableName);Connection.Close();商务层基类逻辑层usingSystem;namespaceWrox.WebModules.Business(publicclassBizObject(publicBizObject()(下面是用户注册系统开发的三层构架实例：数据库基类采用上面提供的代码。1、用户注

9、册模块数据层开发：usingSystem;usingSystem.Data;usingSystem.Data.SqlClient;usingHaiSky.HtJob;usingSystem.Xml;namespaceHaiSky.HtJob.Accounts.AccountsData(publicclassUser:HaiSky.HtJob.HaiSkyDbObject(publicUser(stringnewConnectionString):base(newConnectionString)(/直接路由连接字符串publicintCreate(stringuser_nm,stringuse

10、r_pwd)(introwsAffected;SqlParameter口parameters=(newSqlParameter("user_nm”,SqlDbType.Char,16),newSqlParameter("user_pwd”,SqlDbType.Char,16);parameters0.Value=user_nm;parameters1.Value=user_pwd;parameters2.Direction=ParameterDirection.Output;try(RunProcedure("IF_user_info”,parameters,ou

11、trowsAffected);catch(return(int)parameters2.Value;2、用户注册商务层开发：usingSystem;usingSystem.Configuration;usingHaiSky.HtJob.Accounts.AccountsData;namespaceHaiSky.HtJob.Accounts.AccountBusiness(publicclassUser:HaiSky.HtJob.HaiSkyBizObject(intuserID;stringuserName;stringuserPwd;stringstrConn;publicUser()(st

12、rConn=ConfigurationSettings.AppSettings"strConn"publicintCareate()(AccountsData.UserdataUser=newAccountsData.User(strConn);userID=dataUser.Create(userName,userPwd);returnuserID;publicintUserID(get(returnuserID;set(userID=value;publicstringUserNameget(returnuserName;set(userName=value;publi

13、cstringUserPwd(get(returnuserPwd;set(userPwd=value;3、用户注册表示层开发：usingSystem;usingSystem.Collections;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Web;usingSystem.Web.SessionState;usingSystem.Web.UI;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.HtmlControls;usingHaiSk

14、y.HtJob.Accounts.AccountBusiness;namespaceHaiSky.HtJob.Modules.Accounts(publicclassRegister:System.Web.UI.Page(protectedSystem.Web.UI.WebControls.TextBoxTextBox1;protectedSystem.Web.UI.WebControls.TextBoxTextBox2;protectedSystem.Web.UI.WebControls.TableTable1;protectedSystem.Web.UI.WebControls.Butto

15、nButton1;privatevoidPage_Load(objectsender,System.EventArgse)(Table1.Rows0.Cells0.Visible=false;#regionWebFormDesignergeneratedcodeoverrideprotectedvoidOnInit(EventArgse)(InitializeComponent();base.OnInit(e);privatevoidInitializeComponent()(this.Button1.Click+=newSystem.EventHandler(this.Button1_Cli

16、ck);this.Load+=newSystem.EventHandler(this.Page_Load);#endregionprivatevoidButton1_Click(objectsender,System.EventArgse)(inti;HtJob.Accounts.AccountBusiness.UserBusinessUser=newHtJob.Accounts.AccountBusiness.User();BusinessUser.UserName=TextBox1.Text;BusinessUser.UserPwd=TextBox2.Text;i=BusinessUser.Careate();Response.Write(i.ToString();