EF数据持久化(三层架构，公司查，改)

最新推荐文章于 2024-11-16 18:22:10 发布

W少年没有乌托邦

最新推荐文章于 2024-11-16 18:22:10 发布

阅读量320

点赞数 2

分类专栏： EF数据持久化文章标签： asp.net 后端架构

本文链接：https://blog.csdn.net/Mr_wangzu/article/details/137356180

版权

EF数据持久化专栏收录该内容

6 篇文章 0 订阅

订阅专栏

效果图

Model设置具体流程在下面链接中

https://blog.csdn.net/Mr_wangzu/article/details/136805824?spm=1001.2014.3001.5501

DAL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using WebApplication2.Models;
namespace WebApplication2.DAL
{
    public class CompanyListDAL
    {
        public static List<CompanyList> Show()
        {
            AdvertisesEntities db = new AdvertisesEntities();
         return   db.CompanyLists.ToList();
        }
        public static List<CompanyList> Find(string gangwei)
        {
            AdvertisesEntities db = new AdvertisesEntities();
            return db.CompanyLists.Where(x => x.CompanyJobs.Contains(gangwei)).ToList();
        }
        public static bool Apply(int id)
        {

            AdvertisesEntities db = new AdvertisesEntities();
         var v=   db.CompanyLists.FirstOrDefault(s => s.CompanyID == id);
         if (v!=null&&v.CompanyCount>0)
         {
             v.CompanyCount --;
             db.SaveChanges();
             return true;
         }
         else
         {
             return false;
         }

        }
    }
}

BLL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using WebApplication2.Models;
namespace WebApplication2.BLL
{
    public class CompanyListBLL
    {

        public static List<CompanyList> Show()
        {

            return DAL.CompanyListDAL.Show();
        }
        public static List<CompanyList> Find(string gangwei)
        {

            return DAL.CompanyListDAL.Find(gangwei);
        }
        public static bool Apply(int id)
        {
            return DAL.CompanyListDAL.Apply(id);

        }
    }
}

WebForm1.aspx

前端部分

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication2.WebForm1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Label ID="Label1" runat="server" Text="岗位："></asp:Label><asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><asp:Button ID="Button1" runat="server" Text="查询" OnClick="Button1_Click" />
        <table border="1">
            <tr>
                <th>公司名称</th>
                   <th>招募岗位</th>
                   <th>招募人数</th>
                   <th>岗位申请</th>
            </tr>
            <asp:Repeater ID="Repeater1" runat="server" OnItemCommand="Repeater1_ItemCommand">
                <ItemTemplate>
                     <tr>

                      <td><%#Eval("CompanyName") %></td>
                           <td><%#Eval("CompanyJobs") %></td>
                           <td><%#Eval("CompanyCount") %></td>
                         <td>
                             <asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%#Eval("CompanyID") %>' OnClientClick="return confirm('确定申请岗位？')">申请岗位</asp:LinkButton></td>
                    </tr>
                </ItemTemplate>
                 
            </asp:Repeater>
          
        </table>
    </div>
    </form>
</body>
</html>

后端部分

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebApplication2
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
           Repeater1.DataSource= BLL.CompanyListBLL.Show();
           Repeater1.DataBind();
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            Repeater1.DataSource = BLL.CompanyListBLL.Find(TextBox1.Text);
            Repeater1.DataBind();
        }

        protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            
           int id=Convert.ToInt32(e.CommandArgument); 

           bool sta = BLL.CompanyListBLL.Apply(id);

           if (sta)
           {
               ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('成功')", true);
           }
           else
           {
               ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('名额满了')", true);
           } 

                Repeater1.DataSource = BLL.CompanyListBLL.Show();
                Repeater1.DataBind();
        
        }
    }
}