工作交接

username@email.com

2021-08-27 7b9e068cfe4e295f9ee960457d848c631f0136c7

 zhengcaioa/Model/zhengcaioaContext.cs

@@ -24,14 +24,24 @@
        public virtual DbSet<HrSalaryAppeal> HrSalaryAppeal { get; set; }
        public virtual DbSet<SimCostYearView> SimCostYearView { get; set; }


        public virtual DbSet<AdmAskBaiFang> AdmAskBaiFangs { get; set; }
        public virtual DbSet<AdmAskCar> AdmAskCars { get; set; }
        public virtual DbSet<AdmAskCiZhi> AdmAskCiZhis { get; set; }
        public virtual DbSet<AdmAskcost> AdmAskcosts { get; set; }
        public virtual DbSet<AdmAskGood> AdmAskGoods { get; set; }
        public virtual DbSet<AdmAskJiaojie> AdmAskJiaojies { get; set; }
        public virtual DbSet<AdmAskJiaojieDtl> AdmAskJiaojieDtls { get; set; }
        public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; }
        public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { get; set; }
        public virtual DbSet<AdmAskMarketingCost> AdmAskMarketingCosts { get; set; }
        public virtual DbSet<AdmAskovertime> AdmAskovertimes { get; set; }
        public virtual DbSet<AdmAskYouHui> AdmAskYouHuis { get; set; }
        public virtual DbSet<AdmAttendance> AdmAttendances { get; set; }
        public virtual DbSet<AdmAttendanceDtl> AdmAttendanceDtls { get; set; }
        public virtual DbSet<AdmAttendanceRule> AdmAttendanceRules { get; set; }
        public virtual DbSet<AdmAttendanceRulesDtl> AdmAttendanceRulesDtls { get; set; }
        public virtual DbSet<AdmBreakPrecedent> AdmBreakPrecedents { get; set; }
        public virtual DbSet<AdmCustomerWithdrawal> AdmCustomerWithdrawals { get; set; }
        public virtual DbSet<AdmHoldPhone> AdmHoldPhones { get; set; }
        public virtual DbSet<AdmMemoBook> AdmMemoBooks { get; set; }
        public virtual DbSet<AdmSignIn> AdmSignIns { get; set; }
@@ -46,6 +56,7 @@
        public virtual DbSet<CooperOrder> CooperOrders { get; set; }
        public virtual DbSet<CooperVisit> CooperVisits { get; set; }
        public virtual DbSet<CooperatecustomCustomer> CooperatecustomCustomers { get; set; }
        public virtual DbSet<CusFangwenjilu> CusFangwenjilus { get; set; }
        public virtual DbSet<FiAccount> FiAccounts { get; set; }
        public virtual DbSet<FiAccountRecord> FiAccountRecords { get; set; }
        public virtual DbSet<FiOrderrecievemoney> FiOrderrecievemoneys { get; set; }
@@ -66,8 +77,14 @@
        public virtual DbSet<IntentionCustomer> IntentionCustomers { get; set; }
        public virtual DbSet<IntentionOrder> IntentionOrders { get; set; }
        public virtual DbSet<IntentionVisit> IntentionVisits { get; set; }
        public virtual DbSet<IntentionVisitDuanxin> IntentionVisitDuanxins { get; set; }
        public virtual DbSet<Liaotian> Liaotians { get; set; }
        public virtual DbSet<LiaotianShoucang> LiaotianShoucangs { get; set; }
        public virtual DbSet<LZhuanjiahuidum> LZhuanjiahuida { get; set; }
        public virtual DbSet<Oayouhui> Oayouhuis { get; set; }
        public virtual DbSet<OrderBanci> OrderBancis { get; set; }
        public virtual DbSet<OrderBanciDtl> OrderBanciDtls { get; set; }
        public virtual DbSet<OrderBanciOrder> OrderBanciOrders { get; set; }
        public virtual DbSet<PltAuth> PltAuths { get; set; }
        public virtual DbSet<PltPage> PltPages { get; set; }
        public virtual DbSet<PltRole> PltRoles { get; set; }
@@ -83,6 +100,7 @@
        public virtual DbSet<SysCode> SysCodes { get; set; }
        public virtual DbSet<SysCodeDtl> SysCodeDtls { get; set; }
        public virtual DbSet<Systemsetting> Systemsettings { get; set; }
        public virtual DbSet<SysUpdatetime> SysUpdatetimes { get; set; }
        public virtual DbSet<WfApplytype> WfApplytypes { get; set; }
        public virtual DbSet<WfHistory> WfHistories { get; set; }
        public virtual DbSet<WfLog> WfLogs { get; set; }
@@ -110,6 +128,401 @@
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.HasAnnotation("Relational:Collation", "Chinese_PRC_CI_AS");

            modelBuilder.Entity<AdmAskBaiFang>(entity =>
            {
                entity.ToTable("ADM_AskBaiFang");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.BaiFangtime).HasColumnType("datetime");

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.CreaterName)
                    .HasMaxLength(50)
                    .HasColumnName("createrName");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.CustomerId).HasMaxLength(500);

                entity.Property(e => e.Jtype).HasMaxLength(50);

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Remark).HasMaxLength(500);

                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");

                entity.Property(e => e.VisType).HasMaxLength(50);
            });

            modelBuilder.Entity<AdmAskCar>(entity =>
            {
                entity.ToTable("ADM_AskCar");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.CarLaiyuan).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.CreaterName)
                    .HasMaxLength(50)
                    .HasColumnName("createrName");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Feiyong)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Remark).HasMaxLength(500);

                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");
            });

            modelBuilder.Entity<AdmAskCiZhi>(entity =>
            {
                entity.ToTable("ADM_AskCiZhi");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.CreaterName)
                    .HasMaxLength(50)
                    .HasColumnName("createrName");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.CreatetimeName).HasMaxLength(50);

                entity.Property(e => e.DeptName).HasMaxLength(50);

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.OrderType).HasMaxLength(50);

                entity.Property(e => e.Outtime).HasColumnType("datetime");

                entity.Property(e => e.PostName).HasMaxLength(50);

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Remark).HasMaxLength(2000);

                entity.Property(e => e.RuzhitimeName).HasMaxLength(50);

                entity.Property(e => e.JiaojieUser).HasMaxLength(500);

                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");
            });

            modelBuilder.Entity<AdmAskcost>(entity =>
            {
                entity.ToTable("ADM_Askcost");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Cost)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.CreaterName)
                    .HasMaxLength(50)
                    .HasColumnName("createrName");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Remark).HasMaxLength(500);

                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");
            });

            modelBuilder.Entity<AdmAskGood>(entity =>
            {
                entity.ToTable("ADM_AskGoods");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.CreaterName)
                    .HasMaxLength(50)
                    .HasColumnName("createrName");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.GoodsId).HasMaxLength(50);

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Remark).HasMaxLength(500);

                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Shuliang)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");
            });

            modelBuilder.Entity<AdmAskJiaojie>(entity =>
            {
                entity.ToTable("ADM_AskJiaojie");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.CiZhiId).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.CreaterName)
                    .HasMaxLength(50)
                    .HasColumnName("createrName");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Remark).HasMaxLength(500);

                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");
            });

            modelBuilder.Entity<AdmAskJiaojieDtl>(entity =>
            {
                entity.ToTable("ADM_AskJiaojieDtl");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.JiaojieId).HasMaxLength(50);

                entity.Property(e => e.JiaojieNeirong).HasMaxLength(500);

                entity.Property(e => e.JiaojieStatus)
                    .HasMaxLength(1)
                    .HasColumnName("jiaojie_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.JiaojieType).HasMaxLength(50);

                entity.Property(e => e.JiaojieUserId).HasMaxLength(50);

                entity.Property(e => e.Jiaojietime).HasColumnType("datetime");

                entity.Property(e => e.JieShoutime).HasColumnType("datetime");

                entity.Property(e => e.Kehudanwei).HasMaxLength(500);

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");
            });

            modelBuilder.Entity<AdmAskLeave>(entity =>
            {
                entity.ToTable("ADM_AskLeave");
@@ -242,6 +655,185 @@
                entity.Property(e => e.Tittle)
                    .HasMaxLength(100)
                    .HasColumnName("tittle");
            });

            modelBuilder.Entity<AdmAskovertime>(entity =>
            {
                entity.ToTable("ADM_Askovertime");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.CreaterName)
                    .HasMaxLength(50)
                    .HasColumnName("createrName");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Jiabantime)
                    .HasColumnType("datetime")
                    .HasColumnName("jiabantime");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Overtime)
                    .HasColumnType("money")
                    .HasColumnName("overtime")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Remark).HasMaxLength(500);

                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");
            });

            modelBuilder.Entity<AdmAskYouHui>(entity =>
            {
                entity.ToTable("ADM_AskYouHui");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.CreaterName)
                    .HasMaxLength(50)
                    .HasColumnName("createrName");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.CustomerId).HasMaxLength(50);

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.OrderType).HasMaxLength(50);

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Remark).HasMaxLength(500);

                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");

                entity.Property(e => e.YouHui)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.Youhuistandard).HasMaxLength(50);
            });

            modelBuilder.Entity<AdmAskMarketingCost>(entity =>
            {
                entity.ToTable("ADM_AskMarketingCost");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.BreakPrecedentId)
                    .HasMaxLength(50)
                    .HasColumnName("break_precedentId");

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.CreaterName)
                    .HasMaxLength(50)
                    .HasColumnName("createrName");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Feiyong)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Remark).HasMaxLength(500);

                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");

                entity.Property(e => e.ToUserId).HasMaxLength(50);
            });

            modelBuilder.Entity<AdmAttendance>(entity =>
@@ -666,6 +1258,78 @@
                    .HasMaxLength(50)
                    .HasColumnName("userId")
                    .HasComment("员工");
            });

            modelBuilder.Entity<AdmCustomerWithdrawal>(entity =>
            {
                entity.ToTable("ADM_Customer_withdrawal");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.CreaterName)
                    .HasMaxLength(50)
                    .HasColumnName("createrName");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.HuiyuanId).HasMaxLength(50);

                entity.Property(e => e.HuiyuanName).HasMaxLength(100);

                entity.Property(e => e.HuiyuanPhone).HasMaxLength(50);

                entity.Property(e => e.BankAcount).HasMaxLength(50);

                entity.Property(e => e.BankName).HasMaxLength(50);

                entity.Property(e => e.Username).HasMaxLength(50);

                entity.Property(e => e.Jine)
                    .HasColumnType("money")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.OrderNo).HasMaxLength(50);

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Remark).HasMaxLength(500);

                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Shenqingtime)
                    .HasColumnType("datetime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Tittle)
                    .HasMaxLength(50)
                    .HasColumnName("tittle");
            });

            modelBuilder.Entity<AdmHoldPhone>(entity =>
@@ -1129,6 +1793,11 @@
                    .HasDefaultValueSql("('A')")
                    .HasComment("物品状态");

                entity.Property(e => e.HaocaiStatus)
                   .HasMaxLength(1)
                   .HasColumnName("haocai_status")
                   .HasDefaultValueSql("('D')");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
@@ -1200,6 +1869,10 @@
                    .HasMaxLength(4000)
                    .HasColumnName("remark")
                    .HasComment("工作内容");

                entity.Property(e => e.Shuliang)
                    .HasColumnType("money")
                    .HasColumnName("shuliang");

                entity.Property(e => e.UserId)
                    .HasMaxLength(50)
@@ -1289,6 +1962,14 @@
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.HuifangJdr)
                    .HasMaxLength(100)
                    .HasColumnName("huifang_jdr");

                entity.Property(e => e.HuifangKehuyijian)
                    .HasMaxLength(500)
                    .HasColumnName("huifang_kehuyijian");

                entity.Property(e => e.HuifangStatus)
                    .HasMaxLength(2)
@@ -1416,11 +2097,23 @@
                    .HasColumnName("shr_tel")
                    .HasComment("联系电话");

                entity.Property(e => e.SonghuoDanhao)
                    .HasMaxLength(100)
                    .HasColumnName("songhuo_danhao");

                entity.Property(e => e.SonghuoGongsi)
                    .HasMaxLength(100)
                    .HasColumnName("songhuo_gongsi");

                entity.Property(e => e.SonghuoStatus)
                    .HasMaxLength(2)
                    .HasColumnName("songhuo_status")
                    .HasDefaultValueSql("('D')")
                    .HasComment("送货状态");

                entity.Property(e => e.SonghuoTime1)
                    .HasColumnType("datetime")
                    .HasColumnName("songhuo_time");

                entity.Property(e => e.Songhuoer)
                    .HasMaxLength(50)
@@ -1610,6 +2303,11 @@
                    .HasColumnName("f_tel")
                    .HasComment("联系电话");

                entity.Property(e => e.HuiyuanId)
                    .HasMaxLength(50)
                    .HasColumnName("huiyuanId")
                    .HasComment("会员Id");

                entity.Property(e => e.Hyfl)
                    .HasMaxLength(50)
                    .HasColumnName("hyfl")
@@ -1682,6 +2380,10 @@
                    .HasColumnName("sheng")
                    .HasComment("省");

                entity.Property(e => e.Shifoutianjiaweixin)
                    .HasMaxLength(1)
                    .HasColumnName("shifoutianjiaweixin");

                entity.Property(e => e.ShrAddress)
                    .HasMaxLength(500)
                    .HasColumnName("shr_address")
@@ -1707,6 +2409,18 @@
                    .HasColumnName("url")
                    .HasComment("网址");

                entity.Property(e => e.Weixin)
                    .HasMaxLength(50)
                    .HasColumnName("weixin");

                entity.Property(e => e.Weixiner)
                    .HasMaxLength(50)
                    .HasColumnName("weixiner");

                entity.Property(e => e.Weixintime)
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");

                entity.Property(e => e.YwName)
                    .HasMaxLength(500)
                    .HasColumnName("yw_name")
@@ -1726,6 +2440,53 @@
                    .HasMaxLength(50)
                    .HasColumnName("ywjl")
                    .HasComment("业务经理");
            });

            modelBuilder.Entity<CusFangwenjilu>(entity =>
            {
                entity.ToTable("cus_fangwenjilu");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Fasongfangshi)
                    .HasMaxLength(50)
                    .HasColumnName("fasongfangshi");

                entity.Property(e => e.Fasongneirong)
                    .HasMaxLength(4000)
                    .HasColumnName("fasongneirong");

                entity.Property(e => e.Jieshouren)
                    .HasMaxLength(2000)
                    .HasColumnName("jieshouren");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");
            });

            modelBuilder.Entity<FiAccount>(entity =>
@@ -2123,7 +2884,7 @@
                    .HasComment("会费");

                entity.Property(e => e.MemberAuthority)
                    .HasMaxLength(100)
                    .HasMaxLength(500)
                    .HasColumnName("member_authority")
                    .HasComment("会员权限");

@@ -2855,6 +3616,10 @@
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Dianxiaozhuanyuan)
                    .HasMaxLength(50)
                    .HasColumnName("dianxiaozhuanyuan");

                entity.Property(e => e.Email)
                    .HasMaxLength(500)
                    .HasColumnName("email")
@@ -2947,6 +3712,10 @@
                    .HasColumnName("sheng")
                    .HasComment("省");

                entity.Property(e => e.Shifoutianjiaweixin)
                    .HasMaxLength(1)
                    .HasColumnName("shifoutianjiaweixin");

                entity.Property(e => e.ShrAddress)
                    .HasMaxLength(500)
                    .HasColumnName("shr_address")
@@ -2972,6 +3741,22 @@
                    .HasColumnName("url")
                    .HasComment("网址");

                entity.Property(e => e.Weixin)
                    .HasMaxLength(50)
                    .HasColumnName("weixin");

                entity.Property(e => e.Weixiner)
                    .HasMaxLength(50)
                    .HasColumnName("weixiner");

                entity.Property(e => e.Weixintime)
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");

                entity.Property(e => e.Yixiang).HasMaxLength(50);

                entity.Property(e => e.Yixiangtime).HasColumnType("datetime");

                entity.Property(e => e.YwName)
                    .HasMaxLength(500)
                    .HasColumnName("yw_name")
@@ -2991,6 +3776,10 @@
                    .HasMaxLength(50)
                    .HasColumnName("ywjl")
                    .HasComment("业务经理");

                entity.Property(e => e.Zuijinzhuizongtime)
                    .HasColumnType("datetime")
                    .HasColumnName("zuijinzhuizongtime");
            });

            modelBuilder.Entity<IntentionOrder>(entity =>
@@ -3086,6 +3875,10 @@
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.DuanxinNeirong)
                    .HasMaxLength(500)
                    .HasColumnName("duanxin_neirong");

                entity.Property(e => e.Jdr)
                    .HasMaxLength(500)
                    .HasColumnName("jdr")
@@ -3155,6 +3948,49 @@
                    .HasComment("职务");
            });

            modelBuilder.Entity<IntentionVisitDuanxin>(entity =>
            {
                entity.ToTable("IntentionVisit_duanxin");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.DuanxinNeirong)
                    .HasMaxLength(500)
                    .HasColumnName("duanxin_neirong");

                entity.Property(e => e.DuanxinTitle)
                    .HasMaxLength(50)
                    .HasColumnName("duanxin_title");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");
            });

            modelBuilder.Entity<Liaotian>(entity =>
            {
                entity.ToTable("Liaotian");
@@ -3172,9 +4008,15 @@
                    .HasMaxLength(4000)
                    .HasColumnName("anwser");

                entity.Property(e => e.ChushuStatus)
                    .HasMaxLength(1)
                    .HasColumnName("chushu_status")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Clientid)
                    .HasMaxLength(50)
                    .HasColumnName("clientid");
                    .HasColumnName("clientid")
                    .HasDefaultValueSql("('a')");

                entity.Property(e => e.Creater)
                    .IsRequired()
@@ -3217,9 +4059,112 @@
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('a')");

                entity.Property(e => e.Shenheer)
                    .HasMaxLength(50)
                    .HasColumnName("shenheer");

                entity.Property(e => e.Shenhetime)
                    .HasColumnType("datetime")
                    .HasColumnName("shenhetime");

                entity.Property(e => e.Shiyongfatiao)
                    .HasMaxLength(500)
                    .HasMaxLength(1000)
                    .HasColumnName("shiyongfatiao");
            });
            modelBuilder.Entity<LiaotianShoucang>(entity =>
            {
                entity.ToTable("Liaotian_shoucang");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.LiaotianId)
                    .HasMaxLength(50)
                    .HasColumnName("Liaotian_id");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('a')");
            });

            modelBuilder.Entity<LZhuanjiahuidum>(entity =>
            {
                entity.ToTable("l_zhuanjiahuida");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Anwser)
                    .HasMaxLength(4000)
                    .HasColumnName("anwser");

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Question)
                    .HasMaxLength(500)
                    .HasColumnName("question");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.HuidaStatus)
                   .IsRequired()
                   .HasMaxLength(1)
                   .HasColumnName("huida_status")
                   .HasDefaultValueSql("('D')");

                entity.Property(e => e.Userid)
                    .HasMaxLength(50)
                    .HasColumnName("userid");

                entity.Property(e => e.Username)
                    .HasMaxLength(100)
                    .HasColumnName("username");
            });

            modelBuilder.Entity<Oayouhui>(entity =>
@@ -3272,6 +4217,205 @@
                entity.Property(e => e.Youtype)
                    .HasMaxLength(50)
                    .HasComment("优惠类型");
            });

            modelBuilder.Entity<OrderBanci>(entity =>
            {
                entity.ToTable("order_banci");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Mingcheng)
                    .HasMaxLength(100)
                    .HasColumnName("mingcheng");

                entity.Property(e => e.Banci)
                   .HasMaxLength(100)
                   .HasColumnName("banci");

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Didian)
                    .HasMaxLength(500)
                    .HasColumnName("didian");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");


                entity.Property(e => e.Renshu)
                    .HasColumnName("renshu");

                entity.Property(e => e.Shijian)
                    .HasColumnType("datetime")
                    .HasColumnName("shijian");

                entity.Property(e => e.Shijianend)
                    .HasColumnType("datetime")
                    .HasColumnName("shijianend");
            });

            modelBuilder.Entity<OrderBanciDtl>(entity =>
            {
                entity.ToTable("order_banci_dtl");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.OrderBanciId)
                    .HasMaxLength(50)
                    .HasColumnName("order_banci_id");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Shangxiawu)
                    .HasMaxLength(100)
                    .HasColumnName("shangxiawu");

                entity.Property(e => e.Shijian)
                    .HasMaxLength(100)
                    .HasColumnName("shijian");

                entity.Property(e => e.Shixiamg)
                    .HasMaxLength(500)
                    .HasColumnName("shixiamg");

                entity.Property(e => e.Sort)
                    .HasColumnName("sort")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.Zhujiangren)
                    .HasMaxLength(100)
                    .HasColumnName("zhujiangren");
            });

            modelBuilder.Entity<OrderBanciOrder>(entity =>
            {
                entity.ToTable("order_banci_order");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.BanciId)
                    .HasMaxLength(50)
                    .HasColumnName("banci_id");

                entity.Property(e => e.Baomingrenshu).HasColumnName("baomingrenshu");

                entity.Property(e => e.Baomingtime)
                    .HasColumnType("datetime")
                    .HasColumnName("baomingtime");

                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("creater")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Createtime)
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Jine)
                    .HasColumnType("money")
                    .HasColumnName("jine");

                entity.Property(e => e.Kechengleixing)
                    .HasMaxLength(100)
                    .HasColumnName("kechengleixing");

                entity.Property(e => e.KechengleixingId)
                    .HasMaxLength(50)
                    .HasColumnName("kechengleixing_id");

                entity.Property(e => e.Lianxidianhua)
                    .HasMaxLength(100)
                    .HasColumnName("lianxidianhua");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");

                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");

                entity.Property(e => e.Peixunbanci)
                    .HasMaxLength(100)
                    .HasColumnName("peixunbanci");

                entity.Property(e => e.PersonId)
                    .HasMaxLength(100)
                    .HasColumnName("person_id");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.Shenfenzheng)
                  .HasMaxLength(100)
                  .HasColumnName("shenfenzheng");

                entity.Property(e => e.Xingming)
                    .HasMaxLength(100)
                    .HasColumnName("xingming");

                entity.Property(e => e.Xuefei)
                    .HasColumnType("money")
                    .HasColumnName("xuefei");
            });

            modelBuilder.Entity<PltAuth>(entity =>
@@ -3779,6 +4923,10 @@

                entity.Property(e => e.Weixin).HasMaxLength(50);

                entity.Property(e => e.Yaoqingma)
                  .HasMaxLength(50)
                  .HasColumnName("yaoqingma");

                entity.Property(e => e.Zhengzhi).HasMaxLength(50);

                entity.Property(e => e.Zhiwustatus)
@@ -3888,6 +5036,7 @@
                    .HasMaxLength(50)
                    .HasColumnName("userId");
            });

            modelBuilder.Entity<Project>(entity =>
            {
                entity.ToTable("Project");
@@ -3957,6 +5106,14 @@
                    .HasMaxLength(500)
                    .HasColumnName("drhx");

                entity.Property(e => e.DrhxDefen)
                    .HasColumnType("money")
                    .HasColumnName("drhx_defen");

                entity.Property(e => e.Caigouyusuan)
                   .HasColumnType("money")
                   .HasColumnName("caigouyusuan");

                entity.Property(e => e.DrhxPrice)
                    .HasMaxLength(500)
                    .HasColumnName("drhx_price");
@@ -3964,6 +5121,10 @@
                entity.Property(e => e.Dshx)
                    .HasMaxLength(500)
                    .HasColumnName("dshx");

                entity.Property(e => e.DshxDefen)
                    .HasColumnType("money")
                    .HasColumnName("dshx_defen");

                entity.Property(e => e.DshxPrice)
                    .HasMaxLength(500)
@@ -3976,6 +5137,8 @@
                entity.Property(e => e.Feibiaocishu)
                    .HasMaxLength(100)
                    .HasColumnName("feibiaocishu");

                entity.Property(e => e.Fencha).HasColumnType("money");

                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -4104,6 +5267,9 @@
                entity.Property(e => e.ProjectId)
                    .IsRequired()
                    .HasMaxLength(50);

                entity.Property(e => e.Defen).HasColumnType("money")
                    .HasColumnName("defen"); ;
            });

            modelBuilder.Entity<SysAttachment>(entity =>
@@ -4399,6 +5565,23 @@
                    .HasColumnName("wedding_leave")
                    .HasComment("婚假天数");
            });

            modelBuilder.Entity<SysUpdatetime>(entity =>
            {
                entity.ToTable("sys_updatetime");

                entity.Property(e => e.Id).HasMaxLength(50);

                entity.Property(e => e.Updatename)
                    .IsRequired()
                    .HasMaxLength(100)
                    .HasColumnName("updatename");

                entity.Property(e => e.Updatetime)
                    .HasColumnType("datetime")
                    .HasColumnName("updatetime");
            });

            modelBuilder.Entity<WfApplytype>(entity =>
            {
                entity.ToTable("wf_applytype");
@@ -4746,6 +5929,10 @@
                    .HasColumnName("danjuId")
                    .HasComment("单据Id");

                entity.Property(e => e.Deelurl)
                    .HasMaxLength(500)
                    .HasColumnName("deelurl");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)