asp.net實現三層架構的例子

usingSystem.Collections;
usingSystem.Web;
usingSystem.Web.Security;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.WebControls.WebParts;
usingSystem.Web.UI.HtmlControls;
usingSystem.Text;
usingMaticsoft.Common;
usingLTP.Accounts.Bus;
usingSystem;
namespaceMaticsoft.Web.Employees
{
 publicpartialclassMYAdd:Page
 {
 protectedvoidPage_Load(objectsender,EventArgse)
 {
 
 }
 
 
 protectedvoidButtonOK_Click(objectsender,EventArgse)
 {
 stringERRM ="";
 if(!PageValidate.IsNumber(Temployeeid.Text.Trim()))
 {
 ERRM +="輸入的id不是數字，不合法！";
 }
 if(this.Temployeeid.Text.Trim().Length ==0)
 {
 ERRM +="用戶id不能為空！";
 }
 if(ERRM !="")
 {
 MessageBox.Show(this, ERRM);
 ERRM ="";
 return;
 } intEmployeeID =int.Parse(this.Temployeeid.Text); /
 stringEmployeesName =this.Temployeename.Text;
 Maticsoft.Model.Employeesmodel =newModel.Employees(); //新建一個在dal層Employees的model對象，用于對數據庫Employees表的數據處理
 model.EmployeeID = EmployeeID; //將text里面用戶輸入的id數據傳給model
 model.EmployeesName = EmployeesName; //將text里面用戶輸入的name數據傳給model
 Maticsoft.BLL.Employeesbll =newBLL.Employees(); //新建一個在bll層的employees對象，用于調用dal層的model對象
 bll.Add(model); //在bll層調用add方法添加一條數據 
 
////////////////////////////////////// bll層的add 方法 ///////////////////////////////////////////////////////////////////////////
 /// 增加一條數據 
 publicboolAdd(Maticsoft.Model.Employeesmodel)
 {
 returndal.Add(model); //調用dal層的add方法添加一條數據
 }
 
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
 
 
 
 
////////////////////////////////////// dal層的 add 方法 ///////////////////////////////////////////////////////////////////////////
 ///增加一數據
 publicboolAdd(Maticsoft.Model.Employeesmodel)
 {
 StringBuilderstrSql=newStringBuilder();
 strSql.Append("insert into Employees(");
 strSql.Append("EmployeeID,EmployeesName)");
 strSql.Append(" values (");
 strSql.Append("@EmployeeID,@EmployeesName)");
 SqlParameter[] parameters = {
 newSqlParameter("@EmployeeID",SqlDbType.Int,4),
 newSqlParameter("@EmployeesName",SqlDbType.VarChar,90)};
 parameters[0].Value = model.EmployeeID;
 parameters[1].Value = model.EmployeesName;
 
 introws=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
 if(rows >0)
 {
 returntrue;
 }
 else
 {
 returnfalse;
 }
 }
 
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
 Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功|！","MYAdd.aspx"); //成功創建后彈出對話框，并跳轉到當前頁面！
 
 }
 
 protectedvoidButtonNo_Click(objectsender,EventArgse)
 {
 Response.Redirect("list.aspx");
 }
 
 }
}