基本架构

model 实体

说得通俗一些，model中主要是定义前端传过来的变量以及其类型，或者是需要操作的数据库中的某些字段值。举个例子：

1
2
3
4
5
6
7
8
9
namespace Test.Models.Book
{
    public class BookModel
    {
        public int BookId { get; set; }
        public string BookName { get; set; }
        public DateTime CreateDate { get; set; }
    }
}

其中，上面的namespace是申明一个命名空间，Test表示解决方案，Models是实体文件夹，Book表示实体是Book。申明的每个变量都需要有它的类别以及get和set方法。

controller 控制器层

controller文件中主要定义路由的配置信息，请求方法等。举个例子：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
using Test.BLL.Book;
using Test.Models.Book;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using System.Threading.Tasks;

namespace Test.Controllers.Book
{
    [Route("api/book/[controller]/[action]")]
    [ApiController]

    public class Book : Controller
    {
        // 获取书
        [HttpGet]
        public async Task<ActionResult> GetBookDetail(int BookId)
        {
            var res = await bookBll.GetBookDetail(BookId);
            return Ok(res)
        }

        // 添加书
        [HttpPost]
        public async Task<ActionResult> AddBook([FromBody] BookModel model)
        {
            await bookBll.AddBook(model);
            return Ok("")
        }
    }
}

bll 业务逻辑层

bll文件中主要处理各种逻辑。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
using Test.DAL.Book;
using Test.Models.Book;
using System.Threading.Tasks;
using System;
using System.Collections.Generic;

namespace Test.BLL.Book
{
    public class Book
    {
        BookDal bookDal = new BookDal();

        public async Task<dynamic> GetBookDetail(int BookId)
        {
            return await bookDal.GetBookDetail(BookId);
        }

        public async Task AddBook(BookModel model)
        {
            string BookName = model.BookName;
            await bookDal.AddBook(BookName);
        }
    }
}

dal 数据操作层

dal文件主要用于数据库的操作。

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
using Test.BLL;
using Test.Models.Book;
using System.Threading.Tasks;
using System;
using System.Collections.Generic;

namespace Test.DAL.Book
{
    public class Book
    {
        public async Task<dynamic> GetBookDetail(int BookId)
        {
            IDbConnection conn = SqlUtil.SqlConnection(ConfigUtil.GetSysSettings().Book);
            string sql = @"SELECT * FROM book WHERE bookId = @bookId"
            return await SqlUtil.QueryAsync<dynamic>(sql, new { bookName }, connection: conn);
        }

        public async Task AddBook(string BookName)
        {
            IDbConnection conn = SqlUtil.SqlConnection(ConfigUtil.GetSysSettings().Book);
            string sql = @"INSERT INTO book(bookId,bookName,createDate) values(@bookId,@bookName,GETDATE())"
            await SqlUtil.ExecuteAsync(sql, new { bookName }, connection: conn);
        }
    }
}

前端调用方式

src下的service文件夹的book.js

1
2
3
4
5
6
7
8
9
10
11
12
export async function getBookDetail(params) {
  return request(`${SERVICE_BASE}/api/Book/GetBookDetail`, {
    method: 'GET',
    params
  });
}
export async function addBook(params) {
  return request(`${SERVICE_BASE}/api/Book/AddBook`, {
    method: 'POST',
    body: params
  });
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

import React, { useEffect } from 'react';
import * as service from '@/services/book';

function book(){
    useEffect(() => {
        service.getBookDetail({bookId: 1}).then(res=>{
            if (res.errorCode == 0) {
                console.log(res)
            }
        })
        service.addBook({bookName: "格列夫游记"}).then(res=>{
            if (res.errorCode == 0) {
                console.log(res)
            }
        })
    })
}