当前位置：移动技术网 > IT编程>开发语言>.net > asp.net mvc 三层加EF 登录注册增删改查

asp.net mvc 三层加EF 登录注册增删改查

2019年03月24日 | 移动技术网IT编程 | 我要评论

2013美国电影,白鲸的自述,pinset

首先打开vs软件
新建项目
创建web中的mvc项目
再右击解决方案创建类库项目
分别创建dal层和bll层再把dal层和bll层的类重命名
在mvc项目中的models文件夹创建model类
在dal创建ado.net实体数据模型后把dal层中app.config文件中的链接字符串复制到mvc项目的web.config文件中
dal层中的类开始打代码
登录

 /// <summary>
        /// 登录
        /// </summary>
        /// <param name="studentname">登录名</param>
        /// <param name="studentaddress">是否停用</param>
        /// <param name="phone">密码</param>
        /// <returns></returns>
        public static int login(string studentname, string phone)
        {
            using (zzqentities1 db = new zzqentities1())
            {
                int stu = db.student.where(s => s.studentname == studentname && s.studentaddress =="启用" && s.phone == phone).count();
                return stu;
            }
        
        }

查询

   /// <summary>
        /// 查询
        /// </summary>
        /// <returns></returns>
        public static  list<student>  studentselect() { 
            using (zzqentities1 db = new zzqentities1()) {
                list<student> stu = new list<student>();
                stu = db.student.tolist();
                return stu;
            }
         
        }

添加

 /// <summary>
        /// 添加
        /// </summary>
        /// <param name="studentname">姓名</param>
        /// <param name="studentaddress">是否停用</param>
        /// <param name="phone">密码</param>
        /// <returns></returns>
        public static int insert(string studentname, string studentaddress, string phone) {
            using (zzqentities1 db = new zzqentities1())
            {
                var stu = new student() { studentname = studentname, studentaddress = studentaddress, phone = phone };
                db.student.add(stu);
                return db.savechanges(); 
            }
        
        }

删除

  /// <summary>
        /// 删除
        /// </summary>
        /// <param name="studentid">编号</param>
        /// <returns></returns>
        public static int delete(int id)
        {
            using (zzqentities1 db = new zzqentities1())
            {
                var stu = new student() { studentid = id };
                db.student.attach(stu);
                db.student.remove(stu);
                return db.savechanges();
            }
        }

修改

  /// <summary>
        /// 查询编号
        /// </summary>
        /// <param name="studentid">编号</param>
        /// <returns></returns>
        public static list<student> updateselect(int id)
        {
            using (zzqentities1 db = new zzqentities1())
            {
                var st = db.student.where(x => x.studentid == id).tolist();
                return st;
            }
        }
   /// <summary>
        /// 修改
        /// </summary>
        /// <param name="studentid">编号</param>
        /// <param name="studentname">姓名</param>
        /// <param name="studentaddress">是否停用</param>
        /// <param name="phone">密码</param>
        /// <returns></returns>
        public static int update(int id, string studentname, string studentaddress, string phone)
        {
            using (zzqentities1 db = new zzqentities1())
            {
                var st = db.student.where(x => x.studentid == id).firstordefault();
                st.studentid = id;
                st.studentname = studentname;
                st.studentaddress = studentaddress;
                st.phone = phone;
                return db.savechanges();
            }
        
        }

bll层

using dal;
引用dal层

   /// <summary>
        /// 登录
        /// </summary>
        /// <param name="studentname"></param>
        /// <param name="studentaddress"></param>
        /// <param name="phone"></param>
        /// <returns></returns>
        public static int login(string studentname, string phone)
        {
            try
            {
                int count = kaoshidal.kaoshidal.login(studentname, phone);
                return count;
            }
            catch (exception ex)
            {
                
                throw ex;
            }
        }

查询

/// <summary>
       /// 查询
       /// </summary>
       /// <returns></returns>
        public static list<student> studentselect() {
            try
            {
                return kaoshidal.kaoshidal.studentselect();
            }
            catch (exception ex)
            {
                
                throw ex;
            }
        
        }

添加

   /// <summary>
        /// 添加
        /// </summary>
        /// <param name="studentname">姓名</param>
        /// <param name="studentaddress">是否停用</param>
        /// <param name="phone">密码</param>
        /// <returns></returns>
        public static int insert(string studentname, string studentaddress, string phone) {
            try
            {
                return kaoshidal.kaoshidal.insert(studentname,studentaddress,phone);
            }
            catch (exception ex)
            {
                throw ex;
            }
        
        }

删除

  /// <summary>
        /// 删除
        /// </summary>
        /// <param name="studentid"></param>
        /// <returns></returns>
        public static int delete(int id)
        {
            try
            {
                return kaoshidal.kaoshidal.delete(id);
            }
            catch (exception ex)
            {
                
                throw ex;
            }
        
        }

修改

 /// <summary>
        /// 查询编号
        /// </summary>
        /// <param name="studentid"></param>
        /// <returns></returns>
        public static list<student> updateselect(int id)
        {
            try
            {
                return kaoshidal.kaoshidal.updateselect(id);
            }
            catch (exception ex)
            {
                
                throw ex;
            }
        }
         /// <summary>
        /// 修改
        /// </summary>
        /// <param name="studentid"></param>
        /// <param name="studentname"></param>
        /// <param name="studentaddress"></param>
        /// <param name="phone"></param>
        /// <returns></returns>
        public static int update(int id, string studentname, string studentaddress, string phone)
        {
            try
            {
                return kaoshidal.kaoshidal.update(id, studentname, studentaddress, phone);
            }
            catch (exception ex)
            {
                
                throw ex;
            }
        }

mvc项目中的models文件夹的model类

using dal;
using bll;
这里引用dal层和bll层

  /// <summary>
        /// 登录
        /// </summary>
        /// <param name="studentname"></param>
        /// <param name="studentaddress"></param>
        /// <param name="phone"></param>
        /// <returns></returns>
        public static int login(string studentname, string phone)
        {
            try
            {
              int count= kaoshibll.kaoshibll.login(studentname, phone);
              return count;
            }
            catch (exception ex)
            {

                throw ex;
            }
        }

查询

  /// <summary>
        /// 查询
        /// </summary>
        /// <returns></returns>
        public static list<student> studentselect()
        {
            try
            {
                return kaoshibll.kaoshibll.studentselect();
            }
            catch (exception ex)
            {

                throw ex;
            }

        }

添加

  /// <summary>
        /// 添加
        /// </summary>
        /// <param name="studentname">姓名</param>
        /// <param name="studentaddress">是否停用</param>
        /// <param name="phone">密码</param>
        /// <returns></returns>
        public static int insert(string studentname, string studentaddress, string phone) {
            try
            {
                return kaoshibll.kaoshibll.insert(studentname,studentaddress,phone);
            }
            catch (exception ex)
            {
                throw ex;
            }
        
        }

删除

 /// <summary>
        /// 删除
        /// </summary>
        /// <param name="studentid"></param>
        /// <returns></returns>
        public static int delete(int id)
        {
            try
            {
                return kaoshibll.kaoshibll.delete(id);
            }
            catch (exception ex)
            {

                throw ex;
            }

        }

修改

/// <summary>
        /// 查询编号
        /// </summary>
        /// <param name="studentid"></param>
        /// <returns></returns>
        public static list<student> updateselect(int id)
        {
            try
            {
                return kaoshibll.kaoshibll.updateselect(id);
            }
            catch (exception ex)
            {

                throw ex;
            }
        }
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="studentid"></param>
        /// <param name="studentname"></param>
        /// <param name="studentaddress"></param>
        /// <param name="phone"></param>
        /// <returns></returns>
        public static int update(int id, string studentname, string studentaddress, string phone)
        {
            try
            {
                return kaoshibll.kaoshibll.update(id, studentname, studentaddress, phone);
            }
            catch (exception ex)
            {

                throw ex;
            }
        }

在mvc项目中的controllers文件夹创建home控制器

using kaoshi.models;
using kaoshidal；
using kaoshibll;

   /// <summary>
        /// 登录
        /// </summary>
        /// <returns></returns>
        public actionresult login()
        {
            
            return view();
        }
        public actionresult alogin(string studentname,  string phone)
        {
            int count = kaoshimodel.login(studentname, phone);
            if (count >0)
            {
                return content("<script>alert('登录成功');window.location.href='/home/index';</script>");
                  
            }
            else
            {
                return content("<script>alert('登录失败');window.location.href='/home/login';</script>");
            }
            
        }

查询

   /// <summary>
        /// 查询
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public actionresult index()
        {
            list<student> stu = kaoshimodel.studentselect();
            return view(stu);
        }

 /// <summary>
        /// 注册
        /// </summary>
        /// <returns></returns>
        public actionresult zhuce()
        {
            return view();
        }
        [httppost]
        public actionresult azhuce(string studentname, string studentaddress, string phone)
        {
            int  st = kaoshimodel.insert(studentname,studentaddress,phone);
            if (st > 0)
            {
                return content("<script>alert('注册成功');window.location.href='/home/login';</script>");
            }
            else {
                return content("<script>alert('注册失败');window.location.href='/home/zhuce';</script>");
            }
        }

删除

 /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public actionresult delete(int id)
        {
            int st = kaoshimodel.delete(id);
            if (st > 0)
            {
                return content("<script>alert('删除成功');window.location.href='/home/index';</script>");
            }
            else
            {
                return content("<script>alert('删除失败');window.location.href='/home/index';</script>");
            }
        }

修改

   //修改
        public actionresult update(int id)
        {
            list<student> li = kaoshimodel.updateselect(id);
            return view(li);
        }
        public actionresult updatestudent(int id, string studentname, string studentaddress, string phone)
        {
            int st = kaoshimodel.update(id, studentname, studentaddress, phone);
            if (st>0)
            {
                 return content("<script>alert('修改成功');window.location.href='/home/index';</script>");
            }
            else
            {
                return content("<script>alert('修改失败');window.location.href='/home/index';</script>");
            }
        }

index视图

@{
    viewbag.title = "index";
}
<script type="text/javascript">
    function update(id) {
        location.href = "/home/update/" + id;
    }

    function del(id) {
        if (confirm("是否删除?")) {
            
            location.href = '/home/delete/' + id;
        }
    }
</script> 
 <a href="/home/login">登录</a>
<table>
    <tr>
        <th>姓名<th>
         <th>密码</th>
         <th>是否停用</th>
        <th colspan="2">操作</th>
    </tr>
    @foreach (var item in model)
    {
    <tr>
     <td>@item.studentname</td>
        <td>@item.phone</td>
        <td>@item.studentaddress</td>
         <td><a href="#" onclick="update(@item.studentid)">修改</a></td>
         <td><a href="#" onclick="del(@item.studentid)">删除</a></td>
    </tr>
    }
</table>

login视图

@{
    viewbag.title = "login";
}

<h2>登录</h2>
 @using (html.beginform("alogin", "home", formmethod.post))
   {
       
   
           <input type ="text" name="studentname"   placeholder="请输入姓名"/> 
           <input type ="password" name="phone" placeholder="请输入密码"/>  
          
          
            <button type="submit" class="blue" >登录</button> 
             <a href="/home/zhuce">注册</a>
         }

update视图

@{
    viewbag.title = "update";
}
 
@using (html.beginform("updatestudent", "home", formmethod.post)) { 
<table>
    @foreach (var item in model)
    {
         <tr>
              <td>编号：</td>
            <td>
                <input   type="text" value="@item.studentid"  name="id" readonly="readonly"/>
            </td>
             
         </tr>
        <tr>
              <td>姓名：</td>
            <td>
                <input   type="text" value="@item.studentname"  name="studentname" readonly="readonly"/>
            </td>
             
         </tr>
        <tr>
              <td>是否停用：</td>
            <td>
                <input type="text" value="@item.studentaddress"  name="studentaddress"/>
            </td>
             
         </tr>
        <tr>
              <td>密码：</td>
            <td>
                <input  type="text" value="@item.phone"  name="phone" readonly="readonly"/>
            </td>
             
         </tr>
        
         <tr>
                <td colspan="2">
                    <input type="submit" id="btn" value="修改" /></td>
            </tr>
    }
     
</table>


}

zhuce视图

@{
    viewbag.title = "zhuce";
}
 
@using (html.beginform("azhuce", "home", formmethod.post)) { 

    <table style="width: 100%;">
        <tr>
            <td>姓名：</td>
            <td>
                <input type="text" placeholder="请输入姓名" name="studentname" />
            </td>
             
        </tr>
        <tr>
           <td>状态：</td>
            <td>
                <select name="studentaddress">
                    <option value="启用" selected="selected">启用</option>
                     <option value="禁用">禁用</option>
                </select>
            </td>  
        </tr>
        <tr>
             <td>密码：</td>
            <td>
                <input type="text" placeholder="请输入密码" name="phone" />
            </td>
        </tr>
        <tr>
            <td colspan="2">
                <input id="btn" type="submit" value="注册" />
            </td>
        </tr>
    </table>

}

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！点击进行留言回复

Blazor server side 自家的一些开源的, 实用型项目的进度之 CEF客户端

距离上次提出 [Asp.Net Core] Blazor Server Side 扩展用途 - 配合CEF来制作带浏览器核心的客户端软件的想法后,&#... [阅读全文]
武装你的WEBAPI-OData入门

本文属于OData系列目录（可能会有后续修改） "武装你的WEBAPI OData入门" 武装你的WEBAPI OData便捷查询武装你的WEBAP... [阅读全文]
.NET IoC模式依赖反转(DIP)、控制反转(Ioc)、依赖注入(DI)

依赖倒置原则(DIP) 依赖倒置(Dependency Inversion Principle,缩写DIP)是面向对象六大基本原则之一。他是指一种特定的... [阅读全文]
DevExpress+Winform（四）

视频：https://www.bilibili.com/video/BV15x411x7WN?p=5 新建Devexpress Winform Blan... [阅读全文]
Jenkins之Nunit的应用

一、在Jenkins中安装Nunit插件进入jenkins的插件管理模块，下载Nunit插件。此步骤不做截图说明二、引用nunit.console的nu... [阅读全文]
vue+.netcore可支持业务代码扩展的开发框架 VOL.Vue 2.0版本发布

框架介绍这是一个基于vue、element-ui、iview、.netcore3.1 可支持前端、后台动态扩展业务代码快速开发框架。框架内置定制开发... [阅读全文]
微信退款（在.net core 用http方式请求）

微信JSAPI支付申请退款接口地址接口链接：https://api.mch.weixin.qq.com/secapi/pay/refund 是否需... [阅读全文]
Owin Katana 的底层源码分析

最近看了一下开源项目asp.net katana，感觉公开的接口非常的简洁优雅，channel 9 说是受到node.js的启发设计的，Katana是一... [阅读全文]
jenkins发布application且并运行

一、发布配置差异配置：编译内容编译目标NetWorkClient/KJ90NetClient.csproj编译命令/t:build/p:Configur... [阅读全文]
WPF 简易日期控件魔改ListBox

先上截图修正：应该将SetTime方法修改为，行号为207行开始修改 var nk = Day_of_week(year, month, 1); i... [阅读全文]

网友评论


验证码：

asp.net mvc 三层加EF 登录注册 增删改查

2019年03月24日 | 移动技术网IT编程 | 我要评论

您可能感兴趣的文章:

相关文章:

网友评论

asp.net mvc 三层加EF 登录注册增删改查