121 lines
6.2 KiB
C#
121 lines
6.2 KiB
C#
using Microsoft.EntityFrameworkCore;
|
||
using Mini.Common;
|
||
using Mini.Model.Entity;
|
||
using MySql.Data.MySqlClient;
|
||
using System;
|
||
using System.Collections.Generic;
|
||
using System.Data;
|
||
using System.Text;
|
||
|
||
namespace Mini.Model
|
||
{
|
||
public class crmContext : DbContext
|
||
{
|
||
public crmContext(DbContextOptions<crmContext> options) : base(options)
|
||
{
|
||
|
||
|
||
}
|
||
public crmContext()
|
||
{
|
||
|
||
}
|
||
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
|
||
{
|
||
optionsBuilder.UseMySQL(Utility.GetSettingByKey("ConnectionStrings:crmContext"));
|
||
base.OnConfiguring(optionsBuilder);
|
||
}
|
||
//protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
|
||
//{
|
||
// base.OnConfiguring(optionsBuilder);
|
||
// optionsBuilder.UseMySQL("Server=127.0.0.1;database=testdb;uid=root;password=pwd123456;TreatTinyAsBoolean=true");//配置连接字符串 必须TreatTinyAsBoolean=true 如果不加 bool类型会自动转化成bit类型 疯狂报错
|
||
//}
|
||
|
||
public DbSet<Ww_Role_Dept> Ww_Role_Dept { get; set; }
|
||
public DbSet<Ww_hhuser_Eid> Ww_hhuser_Eid { get; set; }
|
||
public DbSet<Ww_GroupChat> Ww_GroupChat { get; set; }
|
||
public DbSet<Ww_RoomChat> Ww_RoomChat { get; set; }
|
||
public DbSet<Bas_InnerUser> Bas_InnerUser { get; set; }
|
||
public DbSet<Bas_InnerUserRole> Bas_InnerUserRole { get; set; }
|
||
public DbSet<Bas_InnerUserSalt> Bas_InnerUserSalt { get; set; }
|
||
public DbSet<Bas_LeftMemu> Bas_LeftMemu { get; set; }
|
||
public DbSet<Bas_ModuleMenu> Bas_ModuleMenu { get; set; }
|
||
public DbSet<Bas_Right> Bas_Right { get; set; }
|
||
public DbSet<Bas_RightGroup> Bas_RightGroup { get; set; }
|
||
public DbSet<Bas_Right_ToolButton> Bas_Right_ToolButton { get; set; }
|
||
public DbSet<Bas_Role> Bas_Role { get; set; }
|
||
public DbSet<Bas_RoleRightResource> Bas_RoleRightResource { get; set; }
|
||
public DbSet<Bas_Supplier> Bas_Supplier { get; set; }
|
||
public DbSet<Ww_hhuser> Ww_hhuser { get; set; }
|
||
public DbSet<Ww_Extuser> Ww_Extuser { get; set; }
|
||
public DbSet<Ww_User_Extuser> Ww_User_Extuser { get; set; }
|
||
public DbSet<Ww_Dept> Ww_Dept { get; set; }
|
||
public DbSet<Ww_Corp> Ww_Corp { get; set; }
|
||
public DbSet<Ww_Record> Ww_Record { get; set; }
|
||
public DbSet<Bas_Config> Bas_Config { get; set; }
|
||
public DbSet<Ww_hhuser_Name> Ww_hhuser_Name { get; set; }
|
||
|
||
public DbSet<Bas_Parameter> Bas_Parameter { get; set; }
|
||
public DbSet<Bas_LoginLog> Bas_LoginLog { get; set; }
|
||
public DbSet<Ww_DeptUser> Ww_DeptUser { get; set; }
|
||
public DbSet<Ww_UserChat> Ww_UserChat { get; set; }
|
||
|
||
|
||
|
||
|
||
//自定义DbContext实体属性名与数据库表对应名称（默认 表名与属性名对应是 User与Users）
|
||
protected override void OnModelCreating(ModelBuilder modelBuilder)
|
||
{
|
||
|
||
modelBuilder.Entity<Ww_UserChat>().ToTable("Ww_UserChat".ToLower());
|
||
modelBuilder.Entity<Ww_DeptUser>().ToTable("Ww_DeptUser".ToLower());
|
||
modelBuilder.Entity<Ww_GroupChat>().ToTable("Ww_GroupChat".ToLower());
|
||
modelBuilder.Entity<Ww_RoomChat>().ToTable("Ww_RoomChat".ToLower());
|
||
modelBuilder.Entity<Bas_Config>().ToTable("Bas_Config".ToLower());
|
||
modelBuilder.Entity<Bas_InnerUser>().ToTable("Bas_InnerUser".ToLower());
|
||
modelBuilder.Entity<Bas_InnerUserRole>().ToTable("Bas_InnerUserRole".ToLower());
|
||
modelBuilder.Entity<Bas_InnerUserSalt>().ToTable("Bas_InnerUserSalt".ToLower());
|
||
modelBuilder.Entity<Bas_LeftMemu>().ToTable("Bas_LeftMemu".ToLower());
|
||
modelBuilder.Entity<Bas_ModuleMenu>().ToTable("Bas_ModuleMenu".ToLower());
|
||
modelBuilder.Entity<Bas_Right>().ToTable("Bas_Right".ToLower());
|
||
modelBuilder.Entity<Bas_RightGroup>().ToTable("Bas_RightGroup".ToLower());
|
||
modelBuilder.Entity<Bas_Right_ToolButton>().ToTable("Bas_Right_ToolButton".ToLower());
|
||
modelBuilder.Entity<Bas_Role>().ToTable("Bas_Role".ToLower());
|
||
modelBuilder.Entity<Bas_RoleRightResource>().ToTable("Bas_RoleRightResource".ToLower());
|
||
modelBuilder.Entity<Bas_Supplier>().ToTable("Bas_Supplier".ToLower());
|
||
modelBuilder.Entity<Ww_hhuser>().ToTable("Ww_hhuser".ToLower());
|
||
modelBuilder.Entity<Ww_Extuser>().ToTable("Ww_Extuser".ToLower());
|
||
modelBuilder.Entity<Ww_User_Extuser>().ToTable("Ww_User_Extuser".ToLower());
|
||
modelBuilder.Entity<Ww_Dept>().ToTable("Ww_Dept".ToLower());
|
||
modelBuilder.Entity<Ww_Corp>().ToTable("Ww_Corp".ToLower());
|
||
modelBuilder.Entity<Ww_Record>().ToTable("Ww_Record".ToLower());
|
||
modelBuilder.Entity<Ww_hhuser_Name>().ToTable("Ww_hhuser_Name".ToLower());
|
||
modelBuilder.Entity<Bas_Parameter>().ToTable("Bas_Parameter".ToLower());
|
||
modelBuilder.Entity<Bas_LoginLog>().ToTable("Bas_LoginLog".ToLower());
|
||
modelBuilder.Entity<Ww_Role_Dept>().ToTable("Ww_Role_Dept".ToLower());
|
||
modelBuilder.Entity<Ww_hhuser_Eid>().ToTable("Ww_hhuser_Eid".ToLower());
|
||
|
||
|
||
modelBuilder.Entity<Bas_InnerUserRole>().HasKey(t => new { t.InnerUserId, t.RoleId });
|
||
|
||
modelBuilder.Entity<Bas_RoleRightResource>().HasKey(t => new { t.RoleId, t.RightId });
|
||
modelBuilder.Entity<Bas_Right_ToolButton>().HasKey(t => new { t.RightId, t.ButtonId });
|
||
modelBuilder.Entity<Ww_User_Extuser>().HasKey(t => new { t.userid, t.extuserid });
|
||
modelBuilder.Entity<Ww_hhuser_Name>().HasKey(t => new { t.userid, t.corpid });
|
||
modelBuilder.Entity<Ww_Role_Dept>().HasKey(t => new { t.corpid, t.roleid, t.deptid });
|
||
modelBuilder.Entity<Ww_Dept>().HasKey(t => new { t.deptid, t.corpid });
|
||
modelBuilder.Entity<Ww_hhuser_Eid>().HasKey(t => new { t.corpid, t.userid });
|
||
modelBuilder.Entity<Ww_hhuser>().HasKey(t => new { t.corpid, t.userid });
|
||
|
||
modelBuilder.Entity<Ww_UserChat>().HasKey(t => new { t.userid, t.corpid,t.deptuserid });
|
||
modelBuilder.Entity<Ww_DeptUser>().HasKey(t => new { t.userid, t.corpid });
|
||
|
||
base.OnModelCreating(modelBuilder);
|
||
|
||
|
||
}
|
||
|
||
}
|
||
|
||
}
|