From efad4f05e52c89f3b42774e313144abd039370e4 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 10 二月 2023 11:26:06 +0800
Subject: [PATCH] 考勤怎么加带薪假的计算
---
zhengcaioa/Model/zhengcaioaContext.cs | 418 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 411 insertions(+), 7 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index 4c8e020..9b1addc 100644
--- a/zhengcaioa/Model/zhengcaioaContext.cs
+++ b/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,11 +136,15 @@
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; }
public virtual DbSet<TComplaintGongyingshang> TComplaintGongyingshangs { get; set; }
public virtual DbSet<TComplaintShouquandaibiao> TComplaintShouquandaibiaos { get; set; }
+
+
+ public virtual DbSet<Zxdsfxl> Zxdsfxls { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
@@ -851,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");
@@ -945,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()
@@ -1052,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()
@@ -1774,6 +1868,22 @@
.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 =>
{
entity.ToTable("adm_goods_classify");
@@ -2199,6 +2309,18 @@
.HasColumnName("money")
.HasComment("閲戦");
+ entity.Property(e => e.Jichumoney)
+ .HasColumnType("numeric(18, 2)")
+ .HasColumnName("jichumoney");
+
+ entity.Property(e => e.Xmcode)
+ .HasMaxLength(50)
+ .HasColumnName("xmcode");
+
+ entity.Property(e => e.Xmname)
+ .HasMaxLength(500)
+ .HasColumnName("xmname");
+
entity.Property(e => e.OrderNo)
.HasMaxLength(100)
.HasColumnName("order_no")
@@ -2610,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")
@@ -2641,6 +2767,44 @@
entity.Property(e => e.Shenyushouxin)
.HasColumnType("money")
.HasColumnName("shenyushouxin");
+ 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 =>
@@ -3110,6 +3274,10 @@
.HasColumnName("danjia")
.HasComment("鍗曚环");
+ entity.Property(e => e.Jifen)
+ .HasColumnType("money")
+ .HasColumnName("jifen");
+
entity.Property(e => e.Modifier)
.IsRequired()
.HasMaxLength(50)
@@ -3149,6 +3317,10 @@
.HasColumnType("money")
.HasColumnName("huifei")
.HasComment("浼氳垂");
+
+ entity.Property(e => e.Jifen)
+ .HasColumnType("money")
+ .HasColumnName("jifen");
entity.Property(e => e.MemberAuthority)
.HasMaxLength(500)
@@ -3199,6 +3371,10 @@
.HasColumnType("money")
.HasColumnName("feiyong")
.HasComment("璐圭敤");
+
+ entity.Property(e => e.Jifen)
+ .HasColumnType("money")
+ .HasColumnName("jifen");
entity.Property(e => e.Modifier)
.IsRequired()
@@ -3970,6 +4146,10 @@
.HasColumnName("khlx")
.HasComment("瀹㈡埛绫诲瀷");
+ entity.Property(e => e.HuiyuanId)
+ .HasMaxLength(50)
+ .HasColumnName("huiyuanId");
+
entity.Property(e => e.Khly)
.HasMaxLength(50)
.HasColumnName("khly")
@@ -4062,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);
@@ -4645,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 =>
@@ -4677,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)
@@ -5200,6 +5396,10 @@
entity.Property(e => e.ShiyongDateEnd).HasColumnType("datetime");
+ 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)
@@ -5379,6 +5579,10 @@
.HasDefaultValueSql("('')")
.HasComment("閲囪喘浜哄悕绉�");
+ entity.Property(e => e.Caigouyusuan)
+ .HasColumnType("money")
+ .HasColumnName("caigouyusuan");
+
entity.Property(e => e.Cgfs)
.HasMaxLength(50)
.HasColumnName("cgfs");
@@ -5416,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");
@@ -5423,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)
@@ -5443,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);
@@ -5534,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 =>
@@ -5557,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 =>
@@ -5570,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");
@@ -5582,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 =>
@@ -5776,7 +6097,7 @@
.HasColumnName("comments");
entity.Property(e => e.Contents)
- .HasMaxLength(300)
+ .HasMaxLength(500)
.HasColumnName("contents");
entity.Property(e => e.Creater)
@@ -7043,6 +7364,10 @@
.HasMaxLength(300)
.HasColumnName("question");
+ entity.Property(e => e.Questionname)
+ .HasMaxLength(500)
+ .HasColumnName("questionname");
+
entity.Property(e => e.Sort).HasColumnName("sort");
});
@@ -7165,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");
@@ -7190,6 +7534,10 @@
entity.Property(e => e.Question)
.HasMaxLength(300)
.HasColumnName("question");
+
+ entity.Property(e => e.Questionname)
+ .HasMaxLength(500)
+ .HasColumnName("questionname");
entity.Property(e => e.Sort).HasColumnName("sort");
});
@@ -7454,6 +7802,62 @@
.HasColumnName("youbian");
});
+
+ modelBuilder.Entity<Zxdsfxl>(entity =>
+ {
+ entity.ToTable("zxdsfxls");
+
+ 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.Huiyuanid)
+ .HasMaxLength(50)
+ .HasColumnName("huiyuanid");
+
+ entity.Property(e => e.Huiyuanname)
+ .HasMaxLength(100)
+ .HasColumnName("huiyuanname");
+
+ entity.Property(e => e.Leixing)
+ .HasMaxLength(1)
+ .HasColumnName("leixing");
+
+ 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.Token)
+ .HasMaxLength(500)
+ .HasColumnName("token");
+
+ entity.Property(e => e.Visittime)
+ .HasColumnType("datetime")
+ .HasColumnName("visittime");
+ });
+
OnModelCreatingPartial(modelBuilder);
}
--
Gitblit v1.9.1