提交

username@email.com

2021-06-28 6ee35d97c90d5aa8860b9c9d6df22f76315515f1

 zhengcaioa/Model/zhengcaioaContext.cs

@@ -16,6 +16,13 @@
            : 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; }
@@ -37,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; }
@@ -50,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; }
@@ -239,7 +251,7 @@
                entity.Property(e => e.Id).HasMaxLength(50);

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

                entity.Property(e => e.Creater)
@@ -260,11 +272,11 @@
                    .HasDefaultValueSql("('D')");

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

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

                entity.Property(e => e.Modifier)
@@ -281,11 +293,11 @@
                entity.Property(e => e.Month).HasColumnName("month");

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

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

                entity.Property(e => e.RecStatus)
@@ -295,7 +307,7 @@
                    .HasDefaultValueSql("('A')");

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

                entity.Property(e => e.Userid)
@@ -303,17 +315,17 @@
                    .HasMaxLength(50);

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

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

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

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

@@ -343,6 +355,14 @@
                    .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)
@@ -363,7 +383,7 @@
                entity.Property(e => e.OvertimeOut).HasColumnType("datetime");

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

                entity.Property(e => e.RecStatus)
@@ -376,9 +396,25 @@
                    .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, 2)")
                    .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 =>
@@ -1692,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");
@@ -2468,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");
@@ -2511,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 =>
@@ -2919,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");
@@ -3206,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")
@@ -3244,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")
@@ -3274,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")
@@ -3288,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")
@@ -3300,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)
@@ -3317,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()
@@ -3379,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")
@@ -3421,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);

@@ -3606,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");
@@ -3749,6 +4216,9 @@
                entity.Property(e => e.ProjectId)
                    .IsRequired()
                    .HasMaxLength(50);

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

            modelBuilder.Entity<SysAttachment>(entity =>