From ea037964dba48654bdaf7169517c64508984841e Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 19 七月 2021 14:53:45 +0800
Subject: [PATCH] 今日开发： 工作考评 按部门排序。不显示离职员工 工作统计，去掉标题 所有查询，只选择开始或者结束日期，自动补充另外一个日期 工作统计增加根据日期查询，只显示有数据的项 增加全员工作统计菜单，可以查询每个每个在职员工的工作统计
---
zhengcaioa/Model/Sim.cs | 88 +++++++++++++++++++++++++++++++++++++++++++
1 files changed, 87 insertions(+), 1 deletions(-)
diff --git a/zhengcaioa/Model/Sim.cs b/zhengcaioa/Model/Sim.cs
index 7b98670..1528968 100644
--- a/zhengcaioa/Model/Sim.cs
+++ b/zhengcaioa/Model/Sim.cs
@@ -147,8 +147,94 @@
{
get
{
- return status=="0"?"姝ｅ父":"鍏宠处";
+ return status=="0"?"鏈牳鍑�":"宸叉牳鍑�";
}
}
}
+
+ [Table("v_sim_costyear")]
+ public class SimCostYearView
+ {
+ /// <summary>
+ /// 鍗″彿
+ /// </summary>
+ [Key]
+ public string sim_id { get; set; }
+
+ /// <summary>
+ /// 骞�
+ /// </summary>
+ public int bill_year { get; set; }
+
+ /// <summary>
+ /// 1鏈�
+ /// </summary>
+ public decimal Jan { get; set; }
+
+ /// <summary>
+ /// 2鏈�
+ /// </summary>
+ public decimal Feb { get; set; }
+
+ /// <summary>
+ /// 3鏈�
+ /// </summary>
+ public decimal Mar { get; set; }
+
+ /// <summary>
+ /// 4鏈�
+ /// </summary>
+ public decimal Apr { get; set; }
+
+ /// <summary>
+ /// 5鏈�
+ /// </summary>
+ public decimal May { get; set; }
+
+ /// <summary>
+ /// 6鏈�
+ /// </summary>
+ public decimal Jun { get; set; }
+
+ /// <summary>
+ /// 7鏈�
+ /// </summary>
+ public decimal Jul { get; set; }
+
+ /// <summary>
+ /// 8鏈�
+ /// </summary>
+ public decimal Aug { get; set; }
+
+ /// <summary>
+ /// 9鏈�
+ /// </summary>
+ public decimal Sept { get; set; }
+
+ /// <summary>
+ /// 10鏈�
+ /// </summary>
+ public decimal Oct { get; set; }
+
+ /// <summary>
+ /// 11鏈�
+ /// </summary>
+ public decimal Nov { get; set; }
+
+ /// <summary>
+ /// 12鏈�
+ /// </summary>
+ public decimal Dece { get; set; }
+
+ /// <summary>
+ /// 鍗″彿
+ /// </summary>
+ public string sim { get; set; }
+
+ /// <summary>
+ /// 妫�鏌ョ紪杈戞湀
+ /// </summary>
+ [NotMapped]
+ public int month { get; set; }
+ }
}
--
Gitblit v1.9.1