提交

username@email.com

2021-06-28 6ee35d97c90d5aa8860b9c9d6df22f76315515f1

 zhengcaioa/Model/zhengcaioaContext.cs

@@ -16,8 +16,17 @@
            : base(options)
        {
        }

        public virtual DbSet<SimBind> SimBind { get; set; }
        public virtual DbSet<SimBindView> SimBindView { get; set; }
        public virtual DbSet<SimCost> SimCost { get; set; }
        public virtual DbSet<SimCostView> SimCostView { get; set; }
        public virtual DbSet<HrSalaryAppeal> HrSalaryAppeal { get; set; }

        public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; }
        public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { 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; }
@@ -35,6 +44,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; }
@@ -48,11 +58,15 @@
        public virtual DbSet<GroupTopic> GroupTopics { get; set; }
        public virtual DbSet<GroupTuiguang> GroupTuiguangs { get; set; }
        public virtual DbSet<HrDept> HrDepts { get; set; }
        public virtual DbSet<HrJibengongzi> HrJibengongzis { get; set; }
        public virtual DbSet<HrJixiaoticheng> HrJixiaotichengs { get; set; }
        public virtual DbSet<HrPosition> HrPositions { get; set; }
        public virtual DbSet<HrSalary> HrSalaries { get; set; }
        public virtual DbSet<IntentionCustomer> IntentionCustomers { get; set; }
        public virtual DbSet<IntentionOrder> IntentionOrders { get; set; }
        public virtual DbSet<IntentionVisit> IntentionVisits { get; set; }
        public virtual DbSet<Liaotian> Liaotians { get; set; }
        public virtual DbSet<LZhuanjiahuidum> LZhuanjiahuida { get; set; }
        public virtual DbSet<Oayouhui> Oayouhuis { get; set; }
        public virtual DbSet<PltAuth> PltAuths { get; set; }
        public virtual DbSet<PltPage> PltPages { get; set; }
@@ -108,79 +122,26 @@
                    .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.EndPoint).HasMaxLength(50);

                entity.Property(e => e.EndTime)
                    .HasColumnType("datetime")
                    .HasDefaultValueSql("(getdate())")
                    .HasComment("结束时间");

                entity.Property(e => e.LaveDay).HasComment("请假天");

                entity.Property(e => e.LavehHour).HasComment("请假时");

                entity.Property(e => e.Lavetype)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasComment("请假类型");

                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.LaveDay).HasDefaultValueSql("((0))");

                entity.Property(e => e.Remark)
                    .HasMaxLength(500)
                    .HasComment("备注");

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

                entity.Property(e => e.StratTime)
                    .HasColumnType("datetime")
                    .HasDefaultValueSql("(getdate())")
                    .HasComment("开始时间");
            });

            modelBuilder.Entity<AdmAskLeaveOff>(entity =>
            {
                entity.ToTable("ADM_AskLeaveOff");

                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.EndTime).HasColumnType("datetime");
                entity.Property(e => e.LavehHour).HasDefaultValueSql("((0))");

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

                entity.Property(e => e.MedicalRecord)
                    .HasMaxLength(200)
                    .HasColumnName("MedicalRecord ")
                    .HasComment("病例");

                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -201,18 +162,266 @@

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

                entity.Property(e => e.SigninId)
                entity.Property(e => e.ShenpiStatus)
                    .HasMaxLength(1)
                    .HasColumnName("shenpi_status");

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

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

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

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

            modelBuilder.Entity<AdmAskLeaveOff>(entity =>
            {
                entity.ToTable("ADM_AskLeaveOff");

                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.EndPoint).HasMaxLength(50);

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

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

                entity.Property(e => e.MedicalRecord)
                    .HasMaxLength(200)
                    .HasColumnName("MedicalRecord ");

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

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

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

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

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

            modelBuilder.Entity<AdmAttendance>(entity =>
            {
                entity.ToTable("ADM_Attendance");

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

                entity.Property(e => e.Chidao)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("chidao");

                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.Islock)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("islock")
                    .HasDefaultValueSql("('D')");

                entity.Property(e => e.Jiaban)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("jiaban");

                entity.Property(e => e.Kuanggong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("kuanggong");

                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.Month).HasColumnName("month");

                entity.Property(e => e.Offdays)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("offdays");

                entity.Property(e => e.Qingjia)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("qingjia");

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

                entity.Property(e => e.Shijichuqin)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("shijichuqin");

                entity.Property(e => e.Userid)
                    .IsRequired()
                    .HasMaxLength(50);

                entity.Property(e => e.StratTime).HasColumnType("datetime");
                entity.Property(e => e.Xiaojia)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("xiaojia");

                entity.Property(e => e.Year).HasColumnName("year");

                entity.Property(e => e.Yingchuqin)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("yingchuqin");

                entity.Property(e => e.Zaotui)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("zaotui");
            });

            modelBuilder.Entity<AdmAttendanceDtl>(entity =>
            {
                entity.ToTable("ADM_Attendance_dtl");

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

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

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

                entity.Property(e => e.AttendanceId)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("attendance_id");

                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.Iswork)
                   .HasMaxLength(1)
                   .HasColumnName("iswork");

                entity.Property(e => e.Kuanggongtianshu)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("kuanggongtianshu");

                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.MorningIn).HasColumnType("datetime");

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

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

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

                entity.Property(e => e.Qingjia)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("qingjia");

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

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

                entity.Property(e => e.Shangwuchidaofenzhong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("shangwuchidaofenzhong");

                entity.Property(e => e.Shangwuzaotuifenzhong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("shangwuzaotuifenzhong");

                entity.Property(e => e.Xiaojia)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("xiaojia");

                entity.Property(e => e.Xiawuchidaofenzhong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("xiawuchidaofenzhong");

                entity.Property(e => e.Xiawuzaotuifenzhong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("xiawuzaotuifenzhong");
            });

            modelBuilder.Entity<AdmAttendanceRule>(entity =>
            {
                entity.HasNoKey();

                entity.ToTable("ADM_AttendanceRules");

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

                entity.Property(e => e.Absenteeism)
                    .HasColumnType("decimal(18, 2)")
@@ -247,10 +456,6 @@
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("holiday");

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

                entity.Property(e => e.LatePayment1)
                    .HasColumnType("decimal(18, 2)")
@@ -340,21 +545,19 @@
                entity.Property(e => e.Weekend1).HasColumnName("weekend");

                entity.Property(e => e.WorkingEnd)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("working_end");

                entity.Property(e => e.WorkingStart)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("working_start");
            });

            modelBuilder.Entity<AdmAttendanceRulesDtl>(entity =>
            {
                entity.HasNoKey();

                entity.ToTable("ADM_AttendanceRules_dtl");

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

                entity.Property(e => e.Creater)
                    .IsRequired()
@@ -366,10 +569,6 @@
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");

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

                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -385,7 +584,6 @@
                entity.Property(e => e.Name).HasMaxLength(200);

                entity.Property(e => e.Pid)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("pid");

@@ -396,14 +594,12 @@
                    .HasDefaultValueSql("('A')");

                entity.Property(e => e.ValueEnd)
                    .HasColumnType("date")
                    .HasColumnName("value_end")
                    .HasDefaultValueSql("(getdate())");
                    .HasColumnType("datetime")
                    .HasColumnName("value_end");

                entity.Property(e => e.ValueStart)
                    .HasColumnType("date")
                    .HasColumnName("value_start")
                    .HasDefaultValueSql("(getdate())");
                    .HasColumnType("datetime")
                    .HasColumnName("value_start");
            });

            modelBuilder.Entity<AdmBreakPrecedent>(entity =>
@@ -1532,6 +1728,53 @@
                    .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 =>
            {
                entity.ToTable("fi_account");
@@ -1611,6 +1854,8 @@
                entity.Property(e => e.Id).HasMaxLength(50);

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

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

                entity.Property(e => e.Creater)
                    .IsRequired()
@@ -2306,6 +2551,140 @@
                    .HasColumnName("superior_top");
            });

            modelBuilder.Entity<HrJibengongzi>(entity =>
            {
                entity.ToTable("hr_jibengongzi");

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

                entity.Property(e => e.Baomifei)
                    .HasColumnType("money")
                    .HasColumnName("baomifei");

                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.Dianhuabutie)
                    .HasMaxLength(50)
                    .HasColumnName("dianhuabutie");

                entity.Property(e => e.Effecttime)
                    .HasColumnType("datetime")
                    .HasColumnName("effecttime");

                entity.Property(e => e.Jiaotongbutie)
                    .HasColumnType("money")
                    .HasColumnName("jiaotongbutie");

                entity.Property(e => e.Jibengongzi)
                    .HasColumnType("money")
                    .HasColumnName("jibengongzi");

                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.PostId)
                    .HasMaxLength(50)
                    .HasColumnName("post_id");

                entity.Property(e => e.Quanqingjiang)
                    .HasColumnType("money")
                    .HasColumnName("quanqingjiang");

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

                entity.Property(e => e.Shebaodanwei)
                    .HasColumnType("money")
                    .HasColumnName("shebaodanwei");

                entity.Property(e => e.Shebaogeren)
                    .HasColumnType("money")
                    .HasColumnName("shebaogeren");
            });

            modelBuilder.Entity<HrJixiaoticheng>(entity =>
            {
                entity.ToTable("hr_jixiaoticheng");

                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.Effecttime)
                    .HasColumnType("datetime")
                    .HasColumnName("effecttime");

                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.PiecerateId)
                    .HasMaxLength(50)
                    .HasColumnName("piecerate_id");

                entity.Property(e => e.PostId)
                    .HasMaxLength(50)
                    .HasColumnName("post_id");

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

                entity.Property(e => e.Renwu)
                    .HasColumnType("money")
                    .HasColumnName("renwu");

                entity.Property(e => e.Renwustandard)
                    .HasMaxLength(50)
                    .HasColumnName("renwustandard");

                entity.Property(e => e.Ticheng)
                    .HasColumnType("money")
                    .HasColumnName("ticheng");

                entity.Property(e => e.Tichengstandard)
                    .HasMaxLength(50)
                    .HasColumnName("tichengstandard");
            });

            modelBuilder.Entity<HrPosition>(entity =>
            {
                entity.ToTable("hr_position");
@@ -2349,6 +2728,139 @@
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");
            });

            modelBuilder.Entity<HrSalary>(entity =>
            {
                entity.ToTable("hr_salary");

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

                entity.Property(e => e.Baomifei)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("baomifei");

                entity.Property(e => e.Bufagongzi)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("bufagongzi");

                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.Daozhanggongzi)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("daozhanggongzi");

                entity.Property(e => e.Dianhuabutie)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("dianhuabutie");

                entity.Property(e => e.Dianhuafei)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("dianhuafei");

                entity.Property(e => e.Fakuan)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("fakuan");

                entity.Property(e => e.Geshui)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("geshui");

                entity.Property(e => e.Gongzuobutie)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("gongzuobutie");

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

                entity.Property(e => e.Jiabangongzi)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("jiabangongzi");

                entity.Property(e => e.Jiangjin)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("jiangjin");

                entity.Property(e => e.Jiaotngbutie)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("jiaotngbutie");

                entity.Property(e => e.Jibengongzi)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("jibengongzi");

                entity.Property(e => e.Jiucuo)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("jiucuo");

                entity.Property(e => e.Jixiaoticheng)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("jixiaoticheng");

                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.Month).HasColumnName("month");

                entity.Property(e => e.Peichang)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("peichang");

                entity.Property(e => e.Quanqinjiang)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("quanqinjiang");

                entity.Property(e => e.Queqin)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("queqin");

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

                entity.Property(e => e.Shebao)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("shebao");

                entity.Property(e => e.Shebaokou)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("shebaokou");

                entity.Property(e => e.Userid)
                    .IsRequired()
                    .HasMaxLength(50);

                entity.Property(e => e.Year).HasColumnName("year");

                entity.Property(e => e.Yufagongzi)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("yufagongzi");

                entity.Property(e => e.Yufagongziheji)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("yufagongziheji");
            });

            modelBuilder.Entity<IntentionCustomer>(entity =>
@@ -2757,6 +3269,63 @@
                    .HasColumnName("shiyongfatiao");
            });

            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 =>
            {
                entity.ToTable("Oayouhui");
@@ -3044,11 +3613,23 @@

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

                entity.Property(e => e.advancewages)
                    .HasColumnType("decimal(10, 2)")
                    .HasColumnName("advancewages");

                entity.Property(e => e.BasicPrice)
                    .HasMaxLength(500)
                    .HasColumnName("basic_price")
                    .HasDefaultValueSql("('')")
                    .HasComment("薪资待遇");

                entity.Property(e => e.baomisalary)
                    .HasColumnType("decimal(10, 2)")
                    .HasColumnName("baomisalary");
  
                entity.Property(e => e.Beizhu)
                    .HasMaxLength(500)
                    .HasColumnName("beizhu");

                entity.Property(e => e.Birthday)
                    .HasColumnType("datetime")
@@ -3082,6 +3663,10 @@
                    .HasMaxLength(50)
                    .HasColumnName("email");

                entity.Property(e => e.geshuiqizheng)
                   .HasColumnType("decimal(10, 2)")
                   .HasColumnName("geshuiqizheng");

                entity.Property(e => e.HjAddress)
                    .HasMaxLength(500)
                    .HasColumnName("hj_address")
@@ -3112,6 +3697,10 @@
                    .HasDefaultValueSql("(getdate())")
                    .HasComment("启用时间");

                entity.Property(e => e.IpMac)
                    .HasMaxLength(30)
                    .HasColumnName("ipmac");

                entity.Property(e => e.IsGmsb)
                    .HasMaxLength(1)
                    .HasColumnName("is_gmsb")
@@ -3126,6 +3715,18 @@
                    .HasDefaultValueSql("('')")
                    .HasComment("已签订合同");

                entity.Property(e => e.Istravelsubsidy)
                    .HasMaxLength(1)
                    .HasColumnName("is_travelsubsidy");

                entity.Property(e => e.Iswdenter)
                    .HasMaxLength(1)
                    .HasColumnName("is_wdenter");

                entity.Property(e => e.Isxmenter)
                    .HasMaxLength(1)
                    .HasColumnName("is_xmenter");

                entity.Property(e => e.IsYwjl)
                    .HasMaxLength(1)
                    .HasColumnName("is_ywjl")
@@ -3138,9 +3739,17 @@
                    .HasDefaultValueSql("('')")
                    .HasComment("籍贯");

                entity.Property(e => e.jibensalary)
                    .HasColumnType("decimal(10, 2)")
                    .HasColumnName("jibensalary");

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

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

                entity.Property(e => e.jintiesalary)
                    .HasColumnType("decimal(10, 2)")
                    .HasColumnName("jintiesalary");

                entity.Property(e => e.JzAddress)
                    .HasMaxLength(500)
@@ -3155,6 +3764,10 @@
                    .HasColumnName("length_price")
                    .HasDefaultValueSql("('')")
                    .HasComment("工龄工资，入职满一年的下一个月可享受");

                entity.Property(e => e.miniyearsalary)
                    .HasColumnType("decimal(10, 2)")
                    .HasColumnName("miniyearsalary");

                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -3217,6 +3830,10 @@

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

                entity.Property(e => e.senioritywages)
                    .HasColumnType("decimal(10, 2)")
                    .HasColumnName("senioritywages");

                entity.Property(e => e.Sex)
                    .HasMaxLength(1)
                    .HasColumnName("sex")
@@ -3259,6 +3876,10 @@
                    .IsRequired()
                    .HasMaxLength(2)
                    .HasColumnName("user_type");

                entity.Property(e => e.Usernumber)
                    .HasMaxLength(30)
                    .HasColumnName("usernumber");

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

@@ -3444,6 +4065,14 @@
                    .HasMaxLength(500)
                    .HasColumnName("drhx_price");

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

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

                entity.Property(e => e.Dshx)
                    .HasMaxLength(500)
                    .HasColumnName("dshx");
@@ -3587,6 +4216,9 @@
                entity.Property(e => e.ProjectId)
                    .IsRequired()
                    .HasMaxLength(50);

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

            modelBuilder.Entity<SysAttachment>(entity =>