国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁(yè) > 學(xué)院 > 開(kāi)發(fā)設(shè)計(jì) > 正文

一個(gè)用三層架構(gòu)實(shí)現(xiàn)數(shù)據(jù)訪問(wèn)的例子

2019-11-14 15:56:32
字體:
來(lái)源:轉(zhuǎn)載
供稿:網(wǎng)友

看了2天的三層架構(gòu),其實(shí)自己以前也看過(guò)這個(gè),可以由于沒(méi)有使用過(guò),所以對(duì)于三層架構(gòu)也只是知道罷了,昨天看了一下他一些內(nèi)部的具體架構(gòu),三層分別是BLL、WEB、DAL,在web接受用戶請(qǐng)求,bll處理業(yè)務(wù),dal處理數(shù)據(jù)庫(kù)事務(wù),下面是一個(gè)簡(jiǎn)單的例子!這是一個(gè)添加新員工的頁(yè)面:

后臺(tái)代碼如下:
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不是數(shù)字,不合法!";
            }
           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();                 //新建一個(gè)在dal層Employees的model對(duì)象,用于對(duì)數(shù)據(jù)庫(kù)Employees表的數(shù)據(jù)處理
            model.EmployeeID = EmployeeID;                                                                 //將text里面用戶輸入的id數(shù)據(jù)傳給model
            model.EmployeesName = EmployeesName;                                                    //將text里面用戶輸入的name數(shù)據(jù)傳給model
           Maticsoft.BLL.Employeesbll =newBLL.Employees();                             //新建一個(gè)在bll層的employees對(duì)象,用于調(diào)用dal層的model對(duì)象
            bll.Add(model);                                                                                                   //在bll層調(diào)用add方法添加一條數(shù)據(jù)                                                                   
 
//////////////////////////////////////   bll層的add 方法    ///////////////////////////////////////////////////////////////////////////
                 /// 增加一條數(shù)據(jù)             
                                publicboolAdd(Maticsoft.Model.Employeesmodel)
                                {
                                                returndal.Add(model);                                          //調(diào)用dal層的add方法添加一條數(shù)據(jù)
                                }
 
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
 
 
 
 
//////////////////////////////////////  dal層的 add 方法    ///////////////////////////////////////////////////////////////////////////
            ///增加一數(shù)據(jù)
                                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");                     //成功創(chuàng)建后彈出對(duì)話框,并跳轉(zhuǎn)到當(dāng)前頁(yè)面!
 
        }
 
       protectedvoidButtonNo_Click(objectsender,EventArgse)
       {
           Response.Redirect("list.aspx");
        }
    
    }
}

發(fā)表評(píng)論 共有條評(píng)論
用戶名: 密碼:
驗(yàn)證碼: 匿名發(fā)表
主站蜘蛛池模板: 雅安市| 岳普湖县| 虞城县| 逊克县| 乌什县| 乌拉特后旗| 灵丘县| 孟津县| 卫辉市| 郸城县| 易门县| 吴川市| 密山市| 来宾市| 枣庄市| 花莲县| 乐昌市| 绍兴市| 清水县| 盱眙县| 宾川县| 英德市| 双鸭山市| 固原市| 翁牛特旗| 英德市| 康保县| 上思县| 遵化市| 固镇县| 农安县| 鹤山市| 贞丰县| 湟源县| 吉林省| 左贡县| 和林格尔县| 临猗县| 昌乐县| 年辖:市辖区| 象州县|