schangxiang@126.com
2025-11-04 f5ed29dc26c7cd952d56ec5721a2efc43cd25992
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
using HxModel; 
using MySql.Data.EntityFramework;
using System.Data.Entity;
using System.Linq;
 
namespace HxDbContext
{
    /// <summary>
    /// MySQL 数据库的DbContext
    /// </summary>
    [DbConfigurationType(typeof(MySqlEFConfiguration))]
    public partial class MySql_DbContext : DbContext
    {
        /// <summary>
        /// 配置默认的字符串连接
        /// </summary>
        public MySql_DbContext()
         : base("MySqlDbContext")
        {
        }
 
        /// <summary>
        /// 自定义数据库连接
        /// </summary>
        /// <param name="ConnectNameOrConnectString"></param>
        public MySql_DbContext(string ConnectNameOrConnectString)
            : base(ConnectNameOrConnectString)
        {
        }
        /// <summary>
        /// 实体对应规则的映射配置
        /// </summary>
        /// <param name="modelBuilder"></param>
        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
        }
         
        /// <summary>
        /// 设备方法参数表
        /// </summary>
        //public DbSet<DeviceconfigMethodParametersModel> DeviceconfigMethodParametersModelDbSet { get; set; }
 
        public DbSet<UserInfoModel> UserInfoModelDbSet { get; set; }
        public DbSet<RolesModel> RolesModelDbSet { get; set; }
        public DbSet<MenuModel> MenuModelDbSet { get; set; }
 
        public DbSet<OperateAuditLogModel> OperateAuditLogModelDbSet { get; set; }
 
        //public override int SaveChanges()
        //{
        //    var entities = ChangeTracker
        //             .Entries()
        //             .Where(x => x.Entity is UserInfoModel)
        //             .Where(x => x.State == EntityState.Modified || x.State == EntityState.Deleted || x.State == EntityState.Added)
        //             .GroupBy(x => x.State, x => x.Entity as UserInfoModel)
        //             .ToList();
 
        //    return base.SaveChanges();
        //}
        public void ReportChanges()
        {
            var entities = ChangeTracker
                     .Entries()
                     .Where(x => x.Entity is UserInfoModel)
                     .Where(x => x.State == EntityState.Modified || x.State == EntityState.Deleted || x.State == EntityState.Added)
                     .GroupBy(x => x.State, x => x.Entity as UserInfoModel)
                     .ToList();
 
        }
    }
}