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();

        }
    }
}