Files

551 lines
21 KiB
C#
Raw Permalink Normal View History

2025-11-20 09:14:00 +08:00
using System;
using System.Collections.Generic;
using Microsoft.EntityFrameworkCore;
using Pomelo.EntityFrameworkCore.MySql.Scaffolding.Internal;
namespace SupplierManager.Models;
public partial class AgentApprovalSystemContext : DbContext
{
public AgentApprovalSystemContext()
{
}
public AgentApprovalSystemContext(DbContextOptions<AgentApprovalSystemContext> options)
: base(options)
{
}
public virtual DbSet<AasCompanyInfo> AasCompanyInfos { get; set; }
public virtual DbSet<AasCustomerInfo> AasCustomerInfos { get; set; }
public virtual DbSet<AasProjectInfo> AasProjectInfos { get; set; }
public virtual DbSet<AasProjectReportReady> AasProjectReportReadies { get; set; }
public virtual DbSet<AasProjectShenpi> AasProjectShenpis { get; set; }
public virtual DbSet<AasUser> AasUsers { get; set; }
public virtual DbSet<AasUserPermission> AasUserPermissions { get; set; }
public virtual DbSet<AasUsersOperateLog> AasUsersOperateLogs { get; set; }
public virtual DbSet<Autokeygenerater> Autokeygeneraters { get; set; }
public virtual DbSet<WyLog> WyLogs { get; set; }
public virtual DbSet<WyUser> WyUsers { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see https://go.microsoft.com/fwlink/?LinkId=723263.
=> optionsBuilder.UseMySql("server=blv-cloud-db.mysql.rds.aliyuncs.com;database=agent_approval_system;uid=blv_rcu;pwd=fnadiaJDIJ7546;charset=utf8;port=3307", Microsoft.EntityFrameworkCore.ServerVersion.Parse("8.0.28-mysql"));
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder
.UseCollation("utf8mb4_bin")
.HasCharSet("utf8mb4");
modelBuilder.Entity<AasCompanyInfo>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity.ToTable("aas_company_info");
entity.Property(e => e.Id).HasColumnName("id");
entity.Property(e => e.Code)
.HasMaxLength(255)
.HasComment("公司代码")
.HasColumnName("code");
entity.Property(e => e.Createtime)
.HasColumnType("datetime")
.HasColumnName("createtime");
entity.Property(e => e.Identity)
.HasMaxLength(255)
.HasComment("身份")
.HasColumnName("identity");
entity.Property(e => e.Industry)
.HasMaxLength(255)
.HasComment("所属行业")
.HasColumnName("industry");
entity.Property(e => e.LicenseCode)
.HasMaxLength(255)
.HasComment("营业执照")
.HasColumnName("licenseCode");
entity.Property(e => e.Logoaddress)
.HasComment("logo地址")
.HasColumnType("text")
.HasColumnName("logoaddress");
entity.Property(e => e.NameCn)
.HasMaxLength(255)
.HasComment("中文名")
.HasColumnName("nameCn");
entity.Property(e => e.NameEn)
.HasMaxLength(255)
.HasComment("英文名")
.HasColumnName("nameEn");
entity.Property(e => e.Region)
.HasMaxLength(255)
.HasColumnName("region");
entity.Property(e => e.Updatetime)
.HasColumnType("datetime")
.HasColumnName("updatetime");
});
modelBuilder.Entity<AasCustomerInfo>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity.ToTable("aas_customer_info");
entity.Property(e => e.Id)
.ValueGeneratedNever()
.HasColumnName("id");
entity.Property(e => e.ComName)
.HasMaxLength(255)
.HasColumnName("com_name");
entity.Property(e => e.Job)
.HasMaxLength(255)
.HasColumnName("job");
entity.Property(e => e.Mark)
.HasColumnType("text")
.HasColumnName("mark");
entity.Property(e => e.Mobile)
.HasMaxLength(255)
.HasColumnName("mobile");
entity.Property(e => e.Realname)
.HasMaxLength(255)
.HasColumnName("realname");
entity.Property(e => e.Weixin)
.HasMaxLength(255)
.HasColumnName("weixin");
});
modelBuilder.Entity<AasProjectInfo>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity.ToTable("aas_project_info");
entity.HasIndex(e => e.UpdatetimeUnix, "Unixupdatetime");
entity.HasIndex(e => e.CompanyId, "comid");
entity.Property(e => e.Id).HasColumnName("id");
entity.Property(e => e.AddressDetail)
.HasMaxLength(255)
.HasComment("详细地址")
.HasColumnName("address_detail");
entity.Property(e => e.Blueprint)
.HasComment("设计图")
.HasColumnType("text")
.HasColumnName("blueprint");
entity.Property(e => e.CompanyId)
.HasComment("公司ID")
.HasColumnName("company_id");
entity.Property(e => e.Createtime)
.HasColumnType("datetime")
.HasColumnName("createtime");
entity.Property(e => e.CreatetimeUnix)
.HasComment("Unix时间")
.HasColumnName("createtime_unix");
entity.Property(e => e.Customization)
.HasMaxLength(255)
.HasComment("套餐名称")
.HasColumnName("customization");
entity.Property(e => e.HangyeClass)
.HasMaxLength(255)
.HasComment("行业类型")
.HasColumnName("hangye_class");
entity.Property(e => e.ProjectCode)
.HasMaxLength(255)
.HasComment("项目编码")
.HasColumnName("project_code");
entity.Property(e => e.ProjectName)
.HasMaxLength(255)
.HasComment("项目名称")
.HasColumnName("project_name");
entity.Property(e => e.Quyu)
.HasMaxLength(255)
.HasComment("所属区域")
.HasColumnName("quyu");
entity.Property(e => e.RoomTotalCount)
.HasComment("房间总数")
.HasColumnName("room_total_count");
entity.Property(e => e.RoomTypeCount)
.HasComment("房型数量")
.HasColumnName("room_type_count");
entity.Property(e => e.Shengfen)
.HasMaxLength(255)
.HasComment("所属省份")
.HasColumnName("shengfen");
entity.Property(e => e.ShengpiStatus)
.HasMaxLength(64)
.HasComment("审批状态")
.HasColumnName("shengpi_status");
entity.Property(e => e.Uid)
.HasComment("申请人")
.HasColumnName("uid");
entity.Property(e => e.Updatetime)
.HasColumnType("datetime")
.HasColumnName("updatetime");
entity.Property(e => e.UpdatetimeUnix).HasColumnName("updatetime_unix");
});
modelBuilder.Entity<AasProjectReportReady>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity.ToTable("aas_project_report_ready");
entity.Property(e => e.Id).HasColumnName("id");
entity.Property(e => e.Createtime)
.HasColumnType("datetime")
.HasColumnName("createtime");
entity.Property(e => e.CustomerContactsH)
.HasMaxLength(255)
.HasColumnName("customer_contacts_h");
entity.Property(e => e.ProjectCode)
.HasMaxLength(255)
.HasColumnName("project_code");
entity.Property(e => e.Unixtime).HasColumnName("unixtime");
entity.Property(e => e.Updatetime)
.HasColumnType("datetime")
.HasColumnName("updatetime");
});
modelBuilder.Entity<AasProjectShenpi>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity.ToTable("aas_project_shenpi");
entity.Property(e => e.Id).HasColumnName("id");
entity.Property(e => e.Createtime)
.HasColumnType("datetime")
.HasColumnName("createtime");
entity.Property(e => e.ProjectCode)
.HasMaxLength(255)
.HasComment("项目代码")
.HasColumnName("project_code");
entity.Property(e => e.RejectReason)
.HasMaxLength(255)
.HasComment("驳回理由")
.HasColumnName("reject_reason");
entity.Property(e => e.ShenpiNumber)
.HasComment("审批序号")
.HasColumnName("shenpi_number");
entity.Property(e => e.ShenpiSuggest)
.HasMaxLength(255)
.HasComment("审批建议")
.HasColumnName("shenpi_suggest");
entity.Property(e => e.Updatetime)
.HasColumnType("datetime")
.HasColumnName("updatetime");
});
modelBuilder.Entity<AasUser>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity.ToTable("aas_users");
entity.Property(e => e.Id)
.HasComment("主键")
.HasColumnName("id");
entity.Property(e => e.Avatar)
.HasComment("账户头像")
.HasColumnType("text")
.HasColumnName("avatar");
entity.Property(e => e.ComId)
.HasComment("所属公司ID")
.HasColumnName("com_id");
entity.Property(e => e.CreationTime)
.HasComment("创建时间")
.HasColumnType("datetime")
.HasColumnName("creation_time");
entity.Property(e => e.Email)
.HasMaxLength(255)
.HasComment("邮箱")
.HasColumnName("email");
entity.Property(e => e.Isdelete)
.HasComment("是否删除")
.HasColumnName("isdelete");
entity.Property(e => e.Mobile)
.HasMaxLength(255)
.HasComment("电话号码")
.HasColumnName("mobile");
entity.Property(e => e.Password)
.HasMaxLength(255)
.HasComment("密码")
.HasColumnName("password");
entity.Property(e => e.Position)
.HasMaxLength(255)
.HasComment("职位")
.HasColumnName("position");
entity.Property(e => e.PswEncryption)
.HasMaxLength(255)
.HasComment("密码加密处理")
.HasColumnName("psw_encryption");
entity.Property(e => e.Realname)
.HasMaxLength(64)
.HasComment("真实姓名")
.HasColumnName("realname");
entity.Property(e => e.RoleId)
.HasComment("角色ID")
.HasColumnName("role_id");
entity.Property(e => e.UpdateTime)
.HasComment("更新时间")
.HasColumnType("datetime")
.HasColumnName("update_time");
entity.Property(e => e.Username)
.HasMaxLength(64)
.HasComment("用户名(登录名)")
.HasColumnName("username");
entity.Property(e => e.Weixin)
.HasMaxLength(255)
.HasComment("微信号")
.HasColumnName("weixin");
});
modelBuilder.Entity<AasUserPermission>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity.ToTable("aas_user_permission");
entity.Property(e => e.Id).HasColumnName("id");
entity.Property(e => e.ProxyClass)
.HasMaxLength(255)
.HasColumnName("proxy_class");
entity.Property(e => e.ProxyRegion)
.HasMaxLength(255)
.HasColumnName("proxy_region");
});
modelBuilder.Entity<AasUsersOperateLog>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity.ToTable("aas_users_operate_log");
entity.Property(e => e.Id)
.HasComment("主键")
.HasColumnName("id");
entity.Property(e => e.Browser)
.HasMaxLength(255)
.HasComment("浏览器版本")
.HasColumnName("browser")
.UseCollation("utf8_general_ci")
.HasCharSet("utf8");
entity.Property(e => e.CreationTime)
.HasComment("创建时间")
.HasColumnType("datetime")
.HasColumnName("creation_time");
entity.Property(e => e.Device)
.HasMaxLength(255)
.HasComment("设备型号")
.HasColumnName("device")
.UseCollation("utf8_general_ci")
.HasCharSet("utf8");
entity.Property(e => e.Ip)
.HasMaxLength(255)
.HasComment("ip地址")
.HasColumnName("ip")
.UseCollation("utf8_general_ci")
.HasCharSet("utf8");
entity.Property(e => e.Location)
.HasMaxLength(255)
.HasComment("地理位置")
.HasColumnName("location")
.UseCollation("utf8_general_ci")
.HasCharSet("utf8");
entity.Property(e => e.Operate)
.HasComment("执行操作")
.HasColumnType("text")
.HasColumnName("operate");
entity.Property(e => e.Operation)
.HasMaxLength(255)
.HasComment("操作类型")
.HasColumnName("operation")
.UseCollation("utf8_general_ci")
.HasCharSet("utf8");
entity.Property(e => e.TypeId)
.HasComment("日志类型ID")
.HasColumnName("type_id");
entity.Property(e => e.Username)
.HasMaxLength(100)
.HasComment("用户名字")
.HasColumnName("username")
.UseCollation("utf8_general_ci")
.HasCharSet("utf8");
});
modelBuilder.Entity<Autokeygenerater>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity.ToTable("autokeygenerater");
entity.Property(e => e.CompanyCode).HasColumnName("Company_code");
entity.Property(e => e.ProjectInfoCode).HasColumnName("ProjectInfo_code");
});
modelBuilder.Entity<WyLog>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity.ToTable("wy_logs");
entity.Property(e => e.Id)
.HasComment("主键")
.HasColumnName("id");
entity.Property(e => e.CreationTime)
.HasComment("创建时间")
.HasColumnName("creation_time");
entity.Property(e => e.Introduced)
.HasComment("传入参数")
.HasColumnType("text")
.HasColumnName("introduced");
entity.Property(e => e.Ip)
.HasMaxLength(255)
.HasComment("ip地址")
.HasColumnName("ip")
.UseCollation("utf8_general_ci")
.HasCharSet("utf8");
entity.Property(e => e.Operation)
.HasMaxLength(255)
.HasComment("操作类型")
.HasColumnName("operation")
.UseCollation("utf8_general_ci")
.HasCharSet("utf8");
entity.Property(e => e.ReturnValue)
.HasComment("返回值")
.HasColumnType("text")
.HasColumnName("return_value");
});
modelBuilder.Entity<WyUser>(entity =>
{
entity.HasKey(e => e.Id).HasName("PRIMARY");
entity
.ToTable("wy_users", tb => tb.HasComment("用户信息表"))
.UseCollation("utf8mb4_general_ci");
entity.HasIndex(e => e.Username, "idx_account");
entity.Property(e => e.Id)
.HasComment("主键")
.HasColumnName("id");
entity.Property(e => e.Avatar)
.HasMaxLength(500)
.HasComment("头像")
.HasColumnName("avatar");
entity.Property(e => e.Birthday)
.HasComment("生日")
.HasColumnType("datetime")
.HasColumnName("birthday");
entity.Property(e => e.Code)
.HasMaxLength(12)
.HasComment("用户编号")
.HasColumnName("code");
entity.Property(e => e.ComId)
.HasComment("所属公司ID")
.HasColumnName("com_id");
entity.Property(e => e.CreateDept)
.HasComment("创建部门")
.HasColumnName("create_dept");
entity.Property(e => e.CreateUser)
.HasComment("创建人")
.HasColumnName("create_user");
entity.Property(e => e.CreationTime)
.HasDefaultValueSql("CURRENT_TIMESTAMP")
.HasComment("创建时间")
.HasColumnType("datetime")
.HasColumnName("creation_time");
entity.Property(e => e.DeptId)
.HasMaxLength(1000)
.HasComment("部门id")
.HasColumnName("dept_id");
entity.Property(e => e.Email)
.HasMaxLength(45)
.HasComment("邮箱")
.HasColumnName("email");
entity.Property(e => e.Isdelete)
.HasDefaultValueSql("'0'")
.HasComment("是否已删除")
.HasColumnName("isdelete");
entity.Property(e => e.Mobile)
.HasMaxLength(45)
.HasComment("手机")
.HasColumnName("mobile");
entity.Property(e => e.Name)
.HasMaxLength(20)
.HasComment("昵称")
.HasColumnName("name");
entity.Property(e => e.Password)
.HasMaxLength(45)
.HasComment("密码")
.HasColumnName("password");
entity.Property(e => e.Position)
.HasMaxLength(255)
.HasComment("职位")
.HasColumnName("position")
.UseCollation("utf8mb4_bin");
entity.Property(e => e.PostId)
.HasMaxLength(1000)
.HasComment("岗位id")
.HasColumnName("post_id");
entity.Property(e => e.Realname)
.HasMaxLength(10)
.HasComment("真名")
.HasColumnName("realname");
entity.Property(e => e.RoleId)
.HasMaxLength(1000)
.HasComment("角色id")
.HasColumnName("role_id");
entity.Property(e => e.RoleIdAas)
.HasComment("角色ID")
.HasColumnName("role_id_aas");
entity.Property(e => e.Sex)
.HasComment("性别")
.HasColumnName("sex");
entity.Property(e => e.Status)
.HasComment("状态")
.HasColumnName("status");
entity.Property(e => e.TenantId)
.HasMaxLength(12)
.HasDefaultValueSql("'000000'")
.HasComment("租户ID")
.HasColumnName("tenant_id");
entity.Property(e => e.UpdateTime)
.ValueGeneratedOnAddOrUpdate()
.HasDefaultValueSql("CURRENT_TIMESTAMP")
.HasComment("修改时间")
.HasColumnType("datetime")
.HasColumnName("update_time");
entity.Property(e => e.UpdateUser)
.HasComment("修改人")
.HasColumnName("update_user");
entity.Property(e => e.UserType)
.HasComment("用户平台")
.HasColumnName("user_type");
entity.Property(e => e.Username)
.HasMaxLength(45)
.HasComment("账号")
.HasColumnName("username");
entity.Property(e => e.Weixin)
.HasMaxLength(255)
.HasComment("微信")
.HasColumnName("weixin");
});
OnModelCreatingPartial(modelBuilder);
}
partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
}