From 072169e3c5446f94e2cf4e570e5c7952bb5b15b9 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 27 七月 2021 14:47:44 +0800
Subject: [PATCH] 今日开发 考勤规则里增加 公司安排加班 调整请假时间计算 加班日考勤计算
---
zhengcaioa/Model/zhengcaioaContext.cs | 239 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 233 insertions(+), 6 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index ec20a40..f142b9c 100644
--- a/zhengcaioa/Model/zhengcaioaContext.cs
+++ b/zhengcaioa/Model/zhengcaioaContext.cs
@@ -24,9 +24,11 @@
public virtual DbSet<HrSalaryAppeal> HrSalaryAppeal { get; set; }
public virtual DbSet<SimCostYearView> SimCostYearView { get; set; }
-
+ public virtual DbSet<AdmAskcost> AdmAskcosts { get; set; }
+ public virtual DbSet<AdmAskGood> AdmAskGoods { get; set; }
public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; }
public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { get; set; }
+ public virtual DbSet<AdmAskovertime> AdmAskovertimes { get; set; }
public virtual DbSet<AdmAttendance> AdmAttendances { get; set; }
public virtual DbSet<AdmAttendanceDtl> AdmAttendanceDtls { get; set; }
public virtual DbSet<AdmAttendanceRule> AdmAttendanceRules { get; set; }
@@ -90,6 +92,7 @@
public virtual DbSet<SysCode> SysCodes { get; set; }
public virtual DbSet<SysCodeDtl> SysCodeDtls { get; set; }
public virtual DbSet<Systemsetting> Systemsettings { get; set; }
+ public virtual DbSet<SysUpdatetime> SysUpdatetimes { get; set; }
public virtual DbSet<WfApplytype> WfApplytypes { get; set; }
public virtual DbSet<WfHistory> WfHistories { get; set; }
public virtual DbSet<WfLog> WfLogs { get; set; }
@@ -117,6 +120,117 @@
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.HasAnnotation("Relational:Collation", "Chinese_PRC_CI_AS");
+
+ modelBuilder.Entity<AdmAskcost>(entity =>
+ {
+ entity.ToTable("ADM_Askcost");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.Cost)
+ .HasColumnType("money")
+ .HasDefaultValueSql("((0))");
+
+ 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.Tittle)
+ .HasMaxLength(50)
+ .HasColumnName("tittle");
+ });
+
+ modelBuilder.Entity<AdmAskGood>(entity =>
+ {
+ entity.ToTable("ADM_AskGoods");
+
+ 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.GoodsId).HasMaxLength(50);
+
+ 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.Shuliang)
+ .HasColumnType("money")
+ .HasDefaultValueSql("((0))");
+
+ entity.Property(e => e.Tittle)
+ .HasMaxLength(50)
+ .HasColumnName("tittle");
+ });
+
modelBuilder.Entity<AdmAskLeave>(entity =>
{
entity.ToTable("ADM_AskLeave");
@@ -248,6 +362,65 @@
entity.Property(e => e.Tittle)
.HasMaxLength(100)
+ .HasColumnName("tittle");
+ });
+
+ modelBuilder.Entity<AdmAskovertime>(entity =>
+ {
+ entity.ToTable("ADM_Askovertime");
+
+ 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.Jiabantime)
+ .HasColumnType("datetime")
+ .HasColumnName("jiabantime");
+
+ 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.Overtime)
+ .HasColumnType("money")
+ .HasColumnName("overtime")
+ .HasDefaultValueSql("((0))");
+
+ 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.Tittle)
+ .HasMaxLength(50)
.HasColumnName("tittle");
});
@@ -1208,6 +1381,10 @@
.HasColumnName("remark")
.HasComment("宸ヤ綔鍐呭");
+ entity.Property(e => e.Shuliang)
+ .HasColumnType("money")
+ .HasColumnName("shuliang");
+
entity.Property(e => e.UserId)
.HasMaxLength(50)
.HasColumnName("userId")
@@ -1637,6 +1814,11 @@
.HasColumnName("f_tel")
.HasComment("鑱旂郴鐢佃瘽");
+ entity.Property(e => e.HuiyuanId)
+ .HasMaxLength(50)
+ .HasColumnName("huiyuanId")
+ .HasComment("浼氬憳Id");
+
entity.Property(e => e.Hyfl)
.HasMaxLength(50)
.HasColumnName("hyfl")
@@ -1741,6 +1923,14 @@
entity.Property(e => e.Weixin)
.HasMaxLength(50)
.HasColumnName("weixin");
+
+ entity.Property(e => e.Weixiner)
+ .HasMaxLength(50)
+ .HasColumnName("weixiner");
+
+ entity.Property(e => e.Weixintime)
+ .HasColumnType("datetime")
+ .HasColumnName("weixintime");
entity.Property(e => e.YwName)
.HasMaxLength(500)
@@ -3066,6 +3256,14 @@
.HasMaxLength(50)
.HasColumnName("weixin");
+ entity.Property(e => e.Weixiner)
+ .HasMaxLength(50)
+ .HasColumnName("weixiner");
+
+ entity.Property(e => e.Weixintime)
+ .HasColumnType("datetime")
+ .HasColumnName("weixintime");
+
entity.Property(e => e.Yixiang).HasMaxLength(50);
entity.Property(e => e.Yixiangtime).HasColumnType("datetime");
@@ -3322,13 +3520,14 @@
.HasColumnName("anwser");
entity.Property(e => e.ChushuStatus)
- .HasMaxLength(1)
- .HasColumnName("chushu_status")
- .HasDefaultValueSql("('D')");
+ .HasMaxLength(1)
+ .HasColumnName("chushu_status")
+ .HasDefaultValueSql("('D')");
entity.Property(e => e.Clientid)
.HasMaxLength(50)
- .HasColumnName("clientid");
+ .HasColumnName("clientid")
+ .HasDefaultValueSql("('a')");
entity.Property(e => e.Creater)
.IsRequired()
@@ -3371,11 +3570,18 @@
.HasColumnName("rec_status")
.HasDefaultValueSql("('a')");
+ entity.Property(e => e.Shenheer)
+ .HasMaxLength(50)
+ .HasColumnName("shenheer");
+
+ entity.Property(e => e.Shenhetime)
+ .HasColumnType("datetime")
+ .HasColumnName("shenhetime");
+
entity.Property(e => e.Shiyongfatiao)
.HasMaxLength(500)
.HasColumnName("shiyongfatiao");
});
-
modelBuilder.Entity<LiaotianShoucang>(entity =>
{
entity.ToTable("Liaotian_shoucang");
@@ -4228,6 +4434,10 @@
entity.Property(e => e.Weixin).HasMaxLength(50);
+ entity.Property(e => e.Yaoqingma)
+ .HasMaxLength(50)
+ .HasColumnName("yaoqingma");
+
entity.Property(e => e.Zhengzhi).HasMaxLength(50);
entity.Property(e => e.Zhiwustatus)
@@ -4862,6 +5072,23 @@
.HasColumnName("wedding_leave")
.HasComment("濠氬亣澶╂暟");
});
+
+ modelBuilder.Entity<SysUpdatetime>(entity =>
+ {
+ entity.ToTable("sys_updatetime");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.Updatename)
+ .IsRequired()
+ .HasMaxLength(100)
+ .HasColumnName("updatename");
+
+ entity.Property(e => e.Updatetime)
+ .HasColumnType("datetime")
+ .HasColumnName("updatetime");
+ });
+
modelBuilder.Entity<WfApplytype>(entity =>
{
entity.ToTable("wf_applytype");
--
Gitblit v1.9.1