From 3b9bf8c309d77d9817e973aa036e045695c78d70 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 26 七月 2021 16:17:45 +0800
Subject: [PATCH] 今日开发 加班申请· 统计报表：没有任何工作的人，不显示。显示人员的 部门 职位 姓名 工作时间 在计算考勤的时候只有有加班申请的加班才算加班
---
zhengcaioa/Model/zhengcaioaContext.cs | 259 ++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 253 insertions(+), 6 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index 6d92116..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")
@@ -1296,6 +1473,14 @@
.HasColumnType("datetime")
.HasColumnName("createtime")
.HasDefaultValueSql("(getdate())");
+
+ entity.Property(e => e.HuifangJdr)
+ .HasMaxLength(100)
+ .HasColumnName("huifang_jdr");
+
+ entity.Property(e => e.HuifangKehuyijian)
+ .HasMaxLength(500)
+ .HasColumnName("huifang_kehuyijian");
entity.Property(e => e.HuifangStatus)
.HasMaxLength(2)
@@ -1423,11 +1608,23 @@
.HasColumnName("shr_tel")
.HasComment("鑱旂郴鐢佃瘽");
+ entity.Property(e => e.SonghuoDanhao)
+ .HasMaxLength(100)
+ .HasColumnName("songhuo_danhao");
+
+ entity.Property(e => e.SonghuoGongsi)
+ .HasMaxLength(100)
+ .HasColumnName("songhuo_gongsi");
+
entity.Property(e => e.SonghuoStatus)
.HasMaxLength(2)
.HasColumnName("songhuo_status")
.HasDefaultValueSql("('D')")
.HasComment("閫佽揣鐘舵��");
+
+ entity.Property(e => e.SonghuoTime1)
+ .HasColumnType("datetime")
+ .HasColumnName("songhuo_time");
entity.Property(e => e.Songhuoer)
.HasMaxLength(50)
@@ -1617,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")
@@ -1721,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)
@@ -3046,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");
@@ -3302,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()
@@ -3351,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");
@@ -4208,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)
@@ -4842,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