考勤怎么加带薪假的计算

username@email.com

2023-02-10 efad4f05e52c89f3b42774e313144abd039370e4

 zhengcaioa/Model/zhengcaioaContext.cs

@@ -37,6 +37,8 @@
        public virtual DbSet<AdmAskMarketingCost> AdmAskMarketingCosts { get; set; }
        public virtual DbSet<AdmAskovertime> AdmAskovertimes { get; set; }
        public virtual DbSet<AdmAskYouHui> AdmAskYouHuis { get; set; }
        public virtual DbSet<AdmAskzczbwsy> AdmAskzczbwsies { get; set; }
        public virtual DbSet<AdmAskzczbwsydtl> AdmAskzczbwsydtls { get; set; }
        public virtual DbSet<AdmAttendance> AdmAttendances { get; set; }
        public virtual DbSet<AdmAttendanceDtl> AdmAttendanceDtls { get; set; }
        public virtual DbSet<AdmAttendanceRule> AdmAttendanceRules { get; set; }
@@ -49,6 +51,7 @@
        public virtual DbSet<AdmDocBase> AdmDocBases { get; set; }
        public virtual DbSet<AdmDocDoc> AdmDocDocs { get; set; }
        public virtual DbSet<AdmEvaluate> AdmEvaluates { get; set; }
        public virtual DbSet<AdmPhoneMessage> AdmPhoneMessages { get; set; }
        public virtual DbSet<AdmGoodsClassify> AdmGoodsClassifies { get; set; }
        public virtual DbSet<AdmGoodsManage> AdmGoodsManages { get; set; }
        public virtual DbSet<AdmPieceCheck> AdmPieceChecks { get; set; }
@@ -59,6 +62,8 @@
        public virtual DbSet<CooperOrder> CooperOrders { get; set; }
        public virtual DbSet<CooperVisit> CooperVisits { get; set; }
        public virtual DbSet<CooperatecustomCustomer> CooperatecustomCustomers { get; set; }
        public virtual DbSet<CustomerYwjl> CustomerYwjls { get; set; }
        public virtual DbSet<CustomerGuanlian> CustomerGuanlians { get; set; }
        public virtual DbSet<CusFangwenjilu> CusFangwenjilus { get; set; }
        public virtual DbSet<FiAccount> FiAccounts { get; set; }
        public virtual DbSet<FiAccountRecord> FiAccountRecords { get; set; }
@@ -131,6 +136,7 @@

        public virtual DbSet<TChallengeItem> TChallengeItems { get; set; }
        public virtual DbSet<TChallengeletter> TChallengeletters { get; set; }
        public virtual DbSet<TChallengeRequestInfo> TChallengeRequestInfos { get; set; }
        public virtual DbSet<TComplaintItem> TComplaintItems { get; set; }
        public virtual DbSet<TComplaintRespondent> TComplaintRespondents { get; set; }
        public virtual DbSet<TComplaintletter> TComplaintletters { get; set; }
@@ -854,6 +860,81 @@
                entity.Property(e => e.Youhuistandard).HasMaxLength(50);
            });

            modelBuilder.Entity<AdmAskzczbwsy>(entity =>
            {
                entity.ToTable("ADM_Askzczbwsy");

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

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

            modelBuilder.Entity<AdmAskzczbwsydtl>(entity =>
            {
                entity.ToTable("ADM_Askzczbwsydtl");

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

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

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

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

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

                entity.Property(e => e.Phone)
                    .HasMaxLength(500)
                    .HasColumnName("phone");
            });

            modelBuilder.Entity<AdmAskMarketingCost>(entity =>
            {
                entity.ToTable("ADM_AskMarketingCost");
@@ -948,6 +1029,11 @@
                entity.Property(e => e.Kuanggong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("kuanggong");

                entity.Property(e => e.Daixinjia)
                  .HasColumnType("decimal(18, 4)")
                  .HasColumnName("daixinjia")
                  .HasDefaultValueSql("(0)");

                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -1055,6 +1141,11 @@
                entity.Property(e => e.Qingjia)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("qingjia");

                entity.Property(e => e.Daixinjia)
                 .HasColumnType("decimal(18, 4)")
                 .HasColumnName("daixinjia")
                 .HasDefaultValueSql("(0)");

                entity.Property(e => e.RecStatus)
                    .IsRequired()
@@ -1775,6 +1866,22 @@
                    .HasMaxLength(50)
                    .HasColumnName("user_Id")
                    .HasComment("人员id");
            });

            modelBuilder.Entity<AdmPhoneMessage>(entity =>
            {
                entity.ToTable("ADM_PhoneMessage");

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

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

                entity.Property(e => e.Phone).HasMaxLength(50);
                entity.Property(e => e.Message).HasColumnName("message").HasMaxLength(100);
                
            });

            modelBuilder.Entity<AdmGoodsClassify>(entity =>
@@ -2625,6 +2732,10 @@
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");

                entity.Property(e => e.Ywjltime)
                    .HasColumnType("datetime")
                    .HasColumnName("ywjltime");

                entity.Property(e => e.YwName)
                    .HasMaxLength(500)
                    .HasColumnName("yw_name")
@@ -2659,6 +2770,41 @@
                entity.Property(e => e.Taocanjianshu)
                   .HasColumnType("int")
                   .HasColumnName("taocanjianshu");
            });


            modelBuilder.Entity<CustomerYwjl>(entity =>
            {
                entity.ToTable("Customer_Ywjl");

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

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

                entity.Property(e => e.UserId)
                    .HasMaxLength(50)
                    .HasColumnName("userId");

                entity.Property(e => e.YwjlId)
                    .HasMaxLength(50)
                    .HasColumnName("ywjlId");
            });

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

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

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

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

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

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

            modelBuilder.Entity<CusFangwenjilu>(entity =>
@@ -3128,6 +3274,10 @@
                    .HasColumnName("danjia")
                    .HasComment("单价");

                entity.Property(e => e.Jifen)
                   .HasColumnType("money")
                   .HasColumnName("jifen");

                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
@@ -3167,6 +3317,10 @@
                    .HasColumnType("money")
                    .HasColumnName("huifei")
                    .HasComment("会费");

                entity.Property(e => e.Jifen)
                    .HasColumnType("money")
                    .HasColumnName("jifen");

                entity.Property(e => e.MemberAuthority)
                    .HasMaxLength(500)
@@ -3217,6 +3371,10 @@
                    .HasColumnType("money")
                    .HasColumnName("feiyong")
                    .HasComment("费用");

                entity.Property(e => e.Jifen)
                  .HasColumnType("money")
                  .HasColumnName("jifen");

                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -3988,6 +4146,10 @@
                    .HasColumnName("khlx")
                    .HasComment("客户类型");

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

                entity.Property(e => e.Khly)
                    .HasMaxLength(50)
                    .HasColumnName("khly")
@@ -4080,6 +4242,10 @@
                entity.Property(e => e.Weixintime)
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");

                entity.Property(e => e.Ywjltime)
                  .HasColumnType("datetime")
                  .HasColumnName("ywjltime");

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

@@ -4663,6 +4829,14 @@
                entity.Property(e => e.Zhujiangren)
                    .HasMaxLength(100)
                    .HasColumnName("zhujiangren");

                entity.Property(e => e.Jiage)
                  .HasColumnType("numeric(18, 2)")
                  .HasColumnName("jiage");

                entity.Property(e => e.Jifen)
                  .HasColumnType("numeric(18, 2)")
                  .HasColumnName("Jifen");
            });

            modelBuilder.Entity<OrderBanciOrder>(entity =>
@@ -4695,6 +4869,10 @@
                entity.Property(e => e.Jine)
                    .HasColumnType("money")
                    .HasColumnName("jine");

                entity.Property(e => e.Jifen)
                 .HasColumnType("money")
                 .HasColumnName("jifen");

                entity.Property(e => e.Kechengleixing)
                    .HasMaxLength(100)
@@ -5220,6 +5398,8 @@

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

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

                entity.Property(e => e.ShiyongPrice).HasColumnType("numeric(18, 2)");

                entity.Property(e => e.Tel)
@@ -5399,6 +5579,10 @@
                    .HasDefaultValueSql("('')")
                    .HasComment("采购人名称");

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

                entity.Property(e => e.Cgfs)
                    .HasMaxLength(50)
                    .HasColumnName("cgfs");
@@ -5436,6 +5620,30 @@
                    .HasDefaultValueSql("('')")
                    .HasComment("采购人名称");

                entity.Property(e => e.DehxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_tousuchengli");

                entity.Property(e => e.DehxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dehx_tousushijian");

                entity.Property(e => e.DehxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_tousustatus");

                entity.Property(e => e.DehxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_zhiyichengli");

                entity.Property(e => e.DehxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dehx_zhiyishijian");

                entity.Property(e => e.DehxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("dehx_zhiyistatus");

                entity.Property(e => e.Drhx)
                    .HasMaxLength(500)
                    .HasColumnName("drhx");
@@ -5443,10 +5651,6 @@
                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)
@@ -5463,6 +5667,30 @@
                entity.Property(e => e.DshxPrice)
                    .HasMaxLength(500)
                    .HasColumnName("dshx_price");

                entity.Property(e => e.DshxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_tousuchengli");

                entity.Property(e => e.DshxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dshx_tousushijian");

                entity.Property(e => e.DshxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_tousustatus");

                entity.Property(e => e.DshxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_zhiyichengli");

                entity.Property(e => e.DshxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("dshx_zhiyishijian");

                entity.Property(e => e.DshxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("dshx_zhiyistatus");

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

@@ -5554,6 +5782,30 @@
                entity.Property(e => e.Reasonremark)
                    .HasMaxLength(500)
                    .HasColumnName("reasonremark");

                entity.Property(e => e.WxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("wx_tousuchengli");

                entity.Property(e => e.WxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("wx_tousushijian");

                entity.Property(e => e.WxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("wx_tousustatus");

                entity.Property(e => e.WxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("wx_zhiyichengli");

                entity.Property(e => e.WxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("wx_zhiyishijian");

                entity.Property(e => e.WxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("wx_zhiyistatus");
            });

            modelBuilder.Entity<Projectyouxiao>(entity =>
@@ -5577,6 +5829,30 @@
                entity.Property(e => e.ProjectId)
                    .IsRequired()
                    .HasMaxLength(50);

                entity.Property(e => e.YxTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("yx_tousuchengli");

                entity.Property(e => e.YxTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("yx_tousushijian");

                entity.Property(e => e.YxTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("yx_tousustatus");

                entity.Property(e => e.YxZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("yx_zhiyichengli");

                entity.Property(e => e.YxZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("yx_zhiyishijian");

                entity.Property(e => e.YxZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("yx_zhiyistatus");
            });

            modelBuilder.Entity<Projectzhongbiao>(entity =>
@@ -5590,6 +5866,10 @@
                    .HasMaxLength(50)
                    .HasColumnName("zhongbiaoId");

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

                entity.Property(e => e.Names)
                    .HasMaxLength(500)
                    .HasColumnName("names");
@@ -5602,8 +5882,29 @@
                    .IsRequired()
                    .HasMaxLength(50);

                entity.Property(e => e.Defen).HasColumnType("money")
                    .HasColumnName("defen"); ;
                entity.Property(e => e.ZbTousuchengli)
                    .HasMaxLength(1)
                    .HasColumnName("zb_tousuchengli");

                entity.Property(e => e.ZbTousushijian)
                    .HasColumnType("datetime")
                    .HasColumnName("zb_tousushijian");

                entity.Property(e => e.ZbTousustatus)
                    .HasMaxLength(1)
                    .HasColumnName("zb_tousustatus");

                entity.Property(e => e.ZbZhiyichengli)
                    .HasMaxLength(1)
                    .HasColumnName("zb_zhiyichengli");

                entity.Property(e => e.ZbZhiyishijian)
                    .HasColumnType("datetime")
                    .HasColumnName("zb_zhiyishijian");

                entity.Property(e => e.ZbZhiyistatus)
                    .HasMaxLength(1)
                    .HasColumnName("zb_zhiyistatus");
            });

            modelBuilder.Entity<SysAttachment>(entity =>
@@ -5796,7 +6097,7 @@
                    .HasColumnName("comments");

                entity.Property(e => e.Contents)
                    .HasMaxLength(300)
                    .HasMaxLength(500)
                    .HasColumnName("contents");

                entity.Property(e => e.Creater)
@@ -7063,6 +7364,10 @@
                    .HasMaxLength(300)
                    .HasColumnName("question");

                entity.Property(e => e.Questionname)
                 .HasMaxLength(500)
                 .HasColumnName("questionname");

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

@@ -7185,6 +7490,25 @@
                    .HasColumnName("xm_package");
            });

            modelBuilder.Entity<TChallengeRequestInfo>(entity =>
            {
                entity.ToTable("t_challenge_requestInfo");

                entity.Property(e => e.Id).HasColumnName("id");

                entity.Property(e => e.ChallengeId)
                    .HasMaxLength(50)
                    .HasColumnName("challenge_id");

                entity.Property(e => e.RequestInfo)
                    .HasMaxLength(50)
                    .HasColumnName("requestInfo");

                entity.Property(e => e.RequestInfoname)
                    .HasMaxLength(500)
                    .HasColumnName("requestInfoname");
            });

            modelBuilder.Entity<TComplaintItem>(entity =>
            {
                entity.ToTable("t_complaint_items");
@@ -7211,6 +7535,10 @@
                    .HasMaxLength(300)
                    .HasColumnName("question");

                entity.Property(e => e.Questionname)
                .HasMaxLength(500)
                .HasColumnName("questionname");

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