页面展示，用到了ajax，sqlsugar，layui

 一、项目创建

如果启动错误大概率是连接字符串出错了，字符串内的是数据库名，而不是表名

1.创建项目使用ASP.NET Core Web API

 2.选择net6.0，把配置HTTPS取消

二、netcore后端

1.引入sqlsugarcore包

 2.创建SqlSugarHelper类来连接数据库

public static class SqlSugarHelper

{

public static void Connection

(this IServiceCollection services,

IConfiguration configuration,

string connect = "ConnectionString")

{

SqlSugarScope sqlSugarScope = new SqlSugarScope(new ConnectionConfig()

{

DbType = DbType.SqlServer,

ConnectionString = configuration[connect],

IsAutoCloseConnection = true

},

db =>

{

//单例参数配置，所有上下文生效

db.Aop.OnLogExecuting = (sql, pars) =>

{

Console.WriteLine(sql);//输出sql到控制台

};

});

services.AddSingleton(sqlSugarScope);

}

}

3.在appsettings.json内写入连接字符串，我把全文粘下来，文档数据库名为New_Demo

{

  "Logging": {

    "LogLevel": {

      "Default": "Information",

      "Microsoft.AspNetCore": "Warning"

    }

  },

  "AllowedHosts": "*",

  "ConnectionString": "Server=.;Database=sqldemo;Uid=sa;Pwd=123456;"

}

4.创建实体类ticket表

public class ticket

{

///

[SugarColumn(IsIdentity = true, IsPrimaryKey = true)]

public int ID { get; set; }

///

[SugarColumn(ColumnDataType = "varchar(20)", IsNullable = true)]

public string OtherId { get; set; }

///

[SugarColumn(ColumnDataType = "varchar(20)", IsNullable = true)]

public string CunQU { get; set; }

///

[SugarColumn(ColumnDataType = "varchar(20)", IsNullable = true)]

public string Price { get; set; }

///

[SugarColumn(ColumnDataType = "varchar(20)", IsNullable = true)]

public string Remove { get; set; }

///

[SugarColumn(ColumnDataType = "varchar(20)", IsNullable = true)]

public string DealTime { get; set; }

///

[SugarColumn(ColumnDataType = "varchar(20)", IsNullable = true)]

public string Day { get; set; }

///

[SugarColumn(ColumnDataType = "varchar(20)", IsNullable = true)]

public string DealType { get; set; }

///

[SugarColumn(ColumnDataType = "varchar(50)", IsNullable = true)]

public string DealName { get; set; }

///

[SugarColumn(ColumnDataType = "varchar(20)", IsNullable = true)]

public string txt { get; set; }

///

[SugarColumn(ColumnDataType = "varchar(20)", IsNullable = true)]

public string Kind { get; set; }

}

5.创建控制器写接口

[Route("api/[controller]/[action]")]//控制器的路由模板

[ApiController]

public class HomeController : Controller

{

private readonly ISqlSugarClient db;

public HomeController(ISqlSugarClient db)

{

this.db = db;

}

///

[HttpGet]

public List Get()

{

//使用db.Queryable()方法从数据库中查询所有的todos记录，

//并将结果保存在list变量中

var list = db.Queryable().ToList();

return list;

}

}

6.Program内

using TestDemo;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

builder.Services.AddControllers();

// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle

builder.Services.AddEndpointsApiExplorer();

builder.Services.AddSwaggerGen();

//应用程序构建后，不能修改ServiceCollection,所以这句话必须在build上面

builder.Services.Connection(builder.Configuration);

var app = builder.Build();

//1.注释掉Properties/launchsettings.json里的"launchUrl": "swagger",

//2.注释掉下面的if，这样默认打开的页面就是wwwroot的index.html

//注释这两个把下面的if取消注释，并取消launchsettings.json的注释，默认页面就是api页面

app.UseDefaultFiles();

app.UseStaticFiles();

// Configure the HTTP request pipeline.

//if (app.Environment.IsDevelopment())

//{

// app.UseSwagger();

// app.UseSwaggerUI();

//}

app.UseCors(t => t.AllowAnyOrigin().AllowAnyHeader().AllowAnyMethod());

app.UseHttpsRedirection();

app.UseAuthorization();

app.MapControllers();

app.Run();

7.创建wwwroot文件夹

下载layuiLayui - 经典开源模块化前端 UI 框架 (ilayuis.com)

将layui.css引入css文件

创建index.html,代码如下

参考文章

 您阅读本篇文章共花了：