From 1dc456829623823fd9b4f2e6f3bed780f034710e Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期三, 23 七月 2025 18:11:42 +0800
Subject: [PATCH] 增加考勤记录的接口，从oa传过来的数据
---
entity/MesItemQt.cs | 167 ++++++++++++++++++++++++++++++++++++++++---------------
1 files changed, 120 insertions(+), 47 deletions(-)
diff --git a/entity/MesItemQt.cs b/entity/MesItemQt.cs
index 2548f32..5eeab57 100644
--- a/entity/MesItemQt.cs
+++ b/entity/MesItemQt.cs
@@ -1,149 +1,222 @@
锘縰sing SqlSugar;
+using System;
namespace NewPdaSqlServer.entity;
/// <summary>
+/// 鍏朵粬鍑哄簱鐢宠琛� - MES_ITEM_QT
/// </summary>
[SugarTable("MES_ITEM_QT")]
public class MesItemQt
{
/// <summary>
- /// 榛樿鍊�: (newid())
+ /// 涓婚敭Guid
/// </summary>
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
- public Guid Guid { get; set; }
+ public Guid Guid { get; set; } = Guid.NewGuid();
/// <summary>
- /// 鐢宠鍗曞彿
+ /// 鐢宠鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "qtck")]
- public string? Qtck { get; set; }
+ public string Qtck { get; set; }
/// <summary>
- /// 鐢宠鏃ユ湡
+ /// 鐢宠鏃ユ湡
/// </summary>
[SugarColumn(ColumnName = "qt001")]
- public DateTime? Qt001 { get; set; }
+ public DateTime Qt001 { get; set; } = DateTime.Now;
/// <summary>
- /// 瀹℃牳鏃ユ湡
+ /// 瀹℃牳鏃ユ湡
/// </summary>
[SugarColumn(ColumnName = "qt002")]
public DateTime? Qt002 { get; set; }
/// <summary>
- /// 鍑哄簱绫诲埆
+ /// 鍑哄簱绫诲埆
/// </summary>
[SugarColumn(ColumnName = "qt003")]
- public string? Qt003 { get; set; }
+ public string Qt003 { get; set; }
/// <summary>
- /// 涓氬姟绫诲瀷
+ /// 涓氬姟绫诲瀷
/// </summary>
[SugarColumn(ColumnName = "qt004")]
- public string? Qt004 { get; set; }
+ public string Qt004 { get; set; }
/// <summary>
- /// 鍒跺崟浜�
+ /// 鍒跺崟浜�
/// </summary>
[SugarColumn(ColumnName = "qt005")]
- public string? Qt005 { get; set; }
+ public string Qt005 { get; set; }
/// <summary>
- /// 鐢熶骇宸ュ崟
+ /// 鐢熶骇宸ュ崟
/// </summary>
[SugarColumn(ColumnName = "qt006")]
- public string? Qt006 { get; set; }
+ public string Qt006 { get; set; }
/// <summary>
- /// 鍙戞枡浠撳簱id
+ /// 鍙戞枡浠撳簱ID
/// </summary>
[SugarColumn(ColumnName = "qt008")]
- public string? Qt008 { get; set; }
+ public string Qt008 { get; set; }
/// <summary>
- /// 鐢宠閮ㄩ棬id
+ /// 棰嗙敤閮ㄩ棬ID
/// </summary>
[SugarColumn(ColumnName = "qt009")]
- public string? Qt009 { get; set; }
+ public string Qt009 { get; set; }
/// <summary>
- /// 鍑哄簱鍘熷洜
+ /// 鍑哄簱鍘熷洜
/// </summary>
[SugarColumn(ColumnName = "qt010")]
- public string? Qt010 { get; set; }
+ public string Qt010 { get; set; }
/// <summary>
- /// 浠撳簱缂栫爜
+ /// 浠撳簱缂栫爜
/// </summary>
[SugarColumn(ColumnName = "qt011")]
- public string? Qt011 { get; set; }
+ public string Qt011 { get; set; }
/// <summary>
- /// 閮ㄩ棬缂栫爜
+ /// 閮ㄩ棬缂栫爜
/// </summary>
[SugarColumn(ColumnName = "qt012")]
- public string? Qt012 { get; set; }
+ public string Qt012 { get; set; }
/// <summary>
- /// 鏁伴噺
+ /// 棰嗙敤瀹㈡埛ID
/// </summary>
[SugarColumn(ColumnName = "qt013")]
- public int? Qt013 { get; set; }
+ public int Qt013 { get; set; }
/// <summary>
- /// 瀹岀粨鏍囪瘑
- /// 榛樿鍊�: ((0))
+ /// 瀹岀粨鏍囪瘑锛岄粯璁�0
/// </summary>
[SugarColumn(ColumnName = "qt014")]
- public bool? Qt014 { get; set; }
+ public bool Qt014 { get; set; } = false;
/// <summary>
- /// 瀹℃牳鐘舵��
- /// 榛樿鍊�: ((0))
+ /// 瀹℃牳鐘舵�侊紝榛樿0
/// </summary>
[SugarColumn(ColumnName = "qt015")]
- public bool? Qt015 { get; set; }
+ public bool Qt015 { get; set; } = false;
/// <summary>
- /// 瀹℃牳浜�
+ /// 瀹℃牳浜�
/// </summary>
[SugarColumn(ColumnName = "qt016")]
- public string? Qt016 { get; set; }
+ public string Qt016 { get; set; }
/// <summary>
- /// 浠诲姟鍗曞彿
+ /// 浠诲姟鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "qt017")]
- public string? Qt017 { get; set; }
+ public string Qt017 { get; set; }
/// <summary>
- /// 瀹㈡埛
+ /// 璐т富
/// </summary>
[SugarColumn(ColumnName = "qt018")]
- public string? Qt018 { get; set; }
+ public string Qt018 { get; set; }
/// <summary>
- /// 鍑哄簱绫诲瀷 1鐩樹簭 2鍖呮潗棰嗙敤 3鐮斿彂棰嗙敤 4鍔炲叕鐢ㄥ搧棰嗙敤 5妯″叿鏉愭枡棰嗙敤 6浣庡�兼槗鑰楀搧棰嗙敤 7鐢熶骇閰嶄欢 8閲囪喘閫�鏂� 9娉ㄥ浠朵笉鑹��鏂�
+ /// 鍗曟嵁绫诲瀷锛�
+ /// 1鐩樹簭 2鍖呮潗棰嗙敤 3鐮斿彂棰嗙敤 4鍔炲叕鐢ㄥ搧棰嗙敤 5妯″叿鏉愭枡棰嗙敤 6浣庡�兼槗鑰楀搧棰嗙敤 7鐢熶骇閰嶄欢 8閲囪喘閫�鏂� 9娉ㄥ浠朵笉鑹��鏂�
/// </summary>
[SugarColumn(ColumnName = "qt019")]
- public string? Qt019 { get; set; }
+ public string Qt019 { get; set; }
/// <summary>
- /// 鍑哄簱鏂瑰悜锛堟櫘閫氾紝閫�璐э級
+ /// 搴撳瓨鏂瑰悜锛堟櫘閫氾紝閫�璐э級
/// </summary>
[SugarColumn(ColumnName = "qt020")]
- public string? Qt020 { get; set; }
+ public string Qt020 { get; set; }
/// <summary>
- /// 閿�鍞鍗曞彿
+ /// 閿�鍞鍗曞彿
/// </summary>
[SugarColumn(ColumnName = "qt021")]
- public string? Qt021 { get; set; }
+ public string Qt021 { get; set; }
/// <summary>
- /// 棰嗘枡浜�
+ /// 棰嗘枡浜�
/// </summary>
[SugarColumn(ColumnName = "qt022")]
- public string? Qt022 { get; set; }
+ public string Qt022 { get; set; }
+
+ /// <summary>
+ /// 搴撳瓨缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "qt023")]
+ public string Qt023 { get; set; }
+
+ /// <summary>
+ /// 棰嗙敤缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "qt024")]
+ public string Qt024 { get; set; }
+
+ /// <summary>
+ /// 璐т富绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "qt025")]
+ public string Qt025 { get; set; }
+
+ /// <summary>
+ /// 鏄惁鍞悗瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "qt026")]
+ public bool? Qt026 { get; set; }
+
+ /// <summary>
+ /// 鍞悗瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "qt027")]
+ public DateTime? Qt027 { get; set; }
+
+ /// <summary>
+ /// 鍞悗瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "qt028")]
+ public string Qt028 { get; set; }
+
+ /// <summary>
+ /// 璐㈠姟瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "qt029")]
+ public bool? Qt029 { get; set; }
+
+ /// <summary>
+ /// 璐㈠姟瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "qt030")]
+ public DateTime? Qt030 { get; set; }
+
+ /// <summary>
+ /// 璐㈠姟瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "qt031")]
+ public string Qt031 { get; set; }
+
+ /// <summary>
+ /// 閲囪喘瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "qt032")]
+ public bool? Qt032 { get; set; }
+
+ /// <summary>
+ /// 閲囪喘瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "qt033")]
+ public DateTime? Qt033 { get; set; }
+
+ /// <summary>
+ /// 閲囪喘瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "qt034")]
+ public string Qt034 { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3