算工资

username@email.com

2021-06-21 83280d90d12545d36a301c437c7d9095f190aac3

 zhengcaioa/Model/zhengcaioaContext.cs

@@ -50,7 +50,10 @@
        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; }
@@ -239,7 +242,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 +263,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 +284,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 +298,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 +306,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");
            });

@@ -332,6 +335,10 @@
                    .HasMaxLength(50)
                    .HasColumnName("attendance_id");

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

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

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

                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -363,7 +374,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)
@@ -377,8 +388,12 @@
                    .HasDefaultValueSql("(getdate())");

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

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

            modelBuilder.Entity<AdmAttendanceRule>(entity =>
@@ -2468,6 +2483,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 +2660,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 =>
@@ -3206,11 +3488,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 +3538,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 +3572,10 @@
                    .HasDefaultValueSql("(getdate())")
                    .HasComment("启用时间");

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

                entity.Property(e => e.IsGmsb)
                    .HasMaxLength(1)
                    .HasColumnName("is_gmsb")
@@ -3288,29 +3590,23 @@
                    .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")
                    .HasDefaultValueSql("('')")
                    .HasComment("是业务经理");

                entity.Property(e => e.Isxmenter)
                   .HasMaxLength(1)
                   .HasColumnName("is_xmenter")
                   .HasDefaultValueSql("('')")
                   .HasComment("是项目录入");

                entity.Property(e => e.Iswdenter)
                   .HasMaxLength(1)
                   .HasColumnName("is_wdenter")
                   .HasDefaultValueSql("('')")
                   .HasComment("是问答录入");

                entity.Property(e => e.Istravelsubsidy)
                   .HasMaxLength(1)
                   .HasColumnName("is_travelsubsidy")
                   .HasDefaultValueSql("('')")
                   .HasComment("有交通补贴");

                entity.Property(e => e.Jg)
                    .HasMaxLength(500)
@@ -3318,9 +3614,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)
@@ -3335,6 +3639,10 @@
                    .HasColumnName("length_price")
                    .HasDefaultValueSql("('')")
                    .HasComment("工龄工资，入职满一年的下一个月可享受");

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

                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -3397,6 +3705,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")
@@ -3440,6 +3752,10 @@
                    .HasMaxLength(2)
                    .HasColumnName("user_type");

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

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

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