server/aspnetapp/CounterContext.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using aspnetapp.Models;
using Microsoft.EntityFrameworkCore;

namespace aspnetapp
{
    public partial class CounterContext : DbContext
    {
        public CounterContext()
        {
        }
        public DbSet<AddressEntity> Address{ get; set; } = null!;
        public DbSet<BuyrUserEntity> BuyrUsers { get; set; } = null!;
        public DbSet<CategoryEntity> Categories { get; set; } = null!;
        public DbSet<Counter> Counters { get; set; } = null!;
        public DbSet<CompanyEntity> Companys { get; set; } = null!;
        public DbSet<DepartmentEntity> Departments { get; set; } = null!;
        public DbSet<OrderEntity> Orders { get; set; } = null!;
        public DbSet<LogEntity> Logs { get; set; } = null!;
        public DbSet<GoodsEntity> Goods { get; set; } = null!;
        public DbSet<SysUserEntity> SysUsers { get; set; } = null!;
        public DbSet<SysSettings> Settings { get; set; } = null!;
        public DbSet<TemplateEntity> Templates { get; set; } = null!;
        public DbSet<RU2User> RU2Users { get; set; } = null!;

        public CounterContext(DbContextOptions<CounterContext> options)
            : base(options)
        {
        }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            if (!optionsBuilder.IsConfigured)
            {
                var username = Environment.GetEnvironmentVariable("MYSQL_USERNAME");
                var password = Environment.GetEnvironmentVariable("MYSQL_PASSWORD");
                var addressParts = Environment.GetEnvironmentVariable("MYSQL_ADDRESS")?.Split(':');
                var host = addressParts?[0];
                var port = addressParts?[1];

                var connstr = $"server={host};port={port};user={username};password={password};database=advanceoa";

                optionsBuilder.UseMySql(connstr, Microsoft.EntityFrameworkCore.ServerVersion.Parse("5.7.18-mysql"));
            }
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.UseCollation("utf8_general_ci")
                .HasCharSet("utf8");
            modelBuilder.Entity<AddressEntity>().ToTable("address").HasQueryFilter(x => x.IsDeleted == 0);
            modelBuilder.Entity<BuyrUserEntity>().ToTable("buyrusers").HasQueryFilter(x => x.IsDeleted == 0);
            modelBuilder.Entity<Counter>().ToTable("counters");
            modelBuilder.Entity<CategoryEntity>().ToTable("categories").HasQueryFilter(x => x.IsDeleted == 0);
            modelBuilder.Entity<CompanyEntity>().ToTable("companys").HasQueryFilter(x => x.IsDeleted == 0);
            modelBuilder.Entity<DepartmentEntity>().ToTable("departments").HasQueryFilter(x => x.IsDeleted == 0);
            modelBuilder.Entity<SysUserEntity>().ToTable("sysusers").HasQueryFilter(x => x.IsDeleted == 0);
            modelBuilder.Entity<LogEntity>().ToTable("syslog");
            modelBuilder.Entity<OrderEntity>().ToTable("order").HasQueryFilter(x => x.IsDeleted == 0);
            modelBuilder.Entity<GoodsEntity>().ToTable("goods").HasQueryFilter(x => x.IsDeleted == 0);
            modelBuilder.Entity<SysSettings>().ToTable("syssettings");