From 1bb18b7bd0e348c71bf8e3d57d77cf1a2d0e03a9 Mon Sep 17 00:00:00 2001
From: 快乐的昕的电脑 <快乐的昕的电脑@DESKTOP-C2BQPQU>
Date: 星期一, 22 九月 2025 15:10:17 +0800
Subject: [PATCH] 1.受托退料:优化。2.受托入库：列表查询与选择改为存储过程，添加成功声音
---
entity/SysDepartment.cs | 309 +++++++++++++++++++++++++++-----------------------
1 files changed, 166 insertions(+), 143 deletions(-)
diff --git a/entity/SysDepartment.cs b/entity/SysDepartment.cs
index a918d51..b704cc4 100644
--- a/entity/SysDepartment.cs
+++ b/entity/SysDepartment.cs
@@ -1,147 +1,170 @@
锘縰sing SqlSugar;
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+/// </summary>
+[SugarTable("SYS_DEPARTMENT")]
+public class SysDepartment
{
/// <summary>
- ///
- ///</summary>
- [SugarTable("SYS_DEPARTMENT")]
- public class SysDepartment
- {
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
- public Guid Guid { get; set; }
- /// <summary>
- /// 鍏徃
- ///</summary>
- [SugarColumn(ColumnName="company" )]
- public string Company { get; set; }
- /// <summary>
- /// 閮ㄩ棬ID
- ///</summary>
- [SugarColumn(ColumnName="departmentid" )]
- public int? Departmentid { get; set; }
- /// <summary>
- /// 閮ㄩ棬缂栧彿
- ///</summary>
- [SugarColumn(ColumnName="departmentcode" )]
- public string Departmentcode { get; set; }
- /// <summary>
- /// 閮ㄩ棬鍚嶇О
- ///</summary>
- [SugarColumn(ColumnName="departmentname" )]
- public string Departmentname { get; set; }
- /// <summary>
- /// 閮ㄩ棬灞炴��
- ///</summary>
- [SugarColumn(ColumnName="depextr1" )]
- public string Depextr1 { get; set; }
- /// <summary>
- /// 閮ㄩ棬鍒嗙粍
- ///</summary>
- [SugarColumn(ColumnName="depextr2" )]
- public string Depextr2 { get; set; }
- /// <summary>
- /// WIP浠撳簱
- ///</summary>
- [SugarColumn(ColumnName="depextr3" )]
- public string Depextr3 { get; set; }
- /// <summary>
- /// 鏄惁绂佺敤 A 鍚敤 B绂佺敤
- ///</summary>
- [SugarColumn(ColumnName="depextr4" )]
- public string Depextr4 { get; set; }
- /// <summary>
- /// 閮ㄩ棬鎵╁睍瀛楁5
- ///</summary>
- [SugarColumn(ColumnName="depextr5" )]
- public string Depextr5 { get; set; }
- /// <summary>
- /// 杞﹂棿ID
- ///</summary>
- [SugarColumn(ColumnName="workshop_no" )]
- public string WorkshopNo { get; set; }
- /// <summary>
- /// 杞﹂棿鍚�
- ///</summary>
- [SugarColumn(ColumnName="workshop_name" )]
- public string WorkshopName { get; set; }
- /// <summary>
- /// 閮ㄩ棬缁忕悊
- ///</summary>
- [SugarColumn(ColumnName="fmanager" )]
- public string Fmanager { get; set; }
- /// <summary>
- /// 宸ュ巶
- ///</summary>
- [SugarColumn(ColumnName="factory" )]
- public string Factory { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- ///</summary>
- [SugarColumn(ColumnName="create_by" )]
- public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName="create_date" )]
- public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏈�鍚庝慨鏀逛汉
- ///</summary>
- [SugarColumn(ColumnName="lastupdate_by" )]
- public string LastupdateBy { get; set; }
- /// <summary>
- /// 鏈�鍚庝慨鏀规棩鏈�
- ///</summary>
- [SugarColumn(ColumnName="lastupdate_date" )]
- public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 澶囨敞
- ///</summary>
- [SugarColumn(ColumnName="remark" )]
- public string Remark { get; set; }
- /// <summary>
- /// 閮ㄩ棬id
- ///</summary>
- [SugarColumn(ColumnName="id" )]
- public int? Id { get; set; }
- /// <summary>
- /// 鐢熶骇杞﹂棿
- ///</summary>
- [SugarColumn(ColumnName="production_workshop" )]
- public string ProductionWorkshop { get; set; }
- /// <summary>
- /// 鐗╂枡灞炴��
- ///</summary>
- [SugarColumn(ColumnName="material_properti" )]
- public string MaterialProperti { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�4
- ///</summary>
- [SugarColumn(ColumnName="remark4" )]
- public string Remark4 { get; set; }
- /// <summary>
- /// 鑷畾涔夊瓧娈�5
- ///</summary>
- [SugarColumn(ColumnName="remark5" )]
- public string Remark5 { get; set; }
- /// <summary>
- /// 鍒涘缓缁勭粐
- ///</summary>
- [SugarColumn(ColumnName="Fumbrella" )]
- public string Fumbrella { get; set; }
- /// <summary>
- /// 浣跨敤缁勭粐
- ///</summary>
- [SugarColumn(ColumnName="FSubsidiary" )]
- public string FSubsidiary { get; set; }
- /// <summary>
- /// 涓婄骇閮ㄩ棬
- ///</summary>
- [SugarColumn(ColumnName="FParentID" )]
- public string FParentID { get; set; }
- }
-}
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
+
+ /// <summary>
+ /// 鍏徃
+ /// </summary>
+ [SugarColumn(ColumnName = "company")]
+ public string Company { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬ID
+ /// </summary>
+ [SugarColumn(ColumnName = "departmentid")]
+ public int? Departmentid { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "departmentcode")]
+ public string Departmentcode { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬鍚嶇О
+ /// </summary>
+ [SugarColumn(ColumnName = "departmentname")]
+ public string Departmentname { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬灞炴��
+ /// </summary>
+ [SugarColumn(ColumnName = "depextr1")]
+ public string Depextr1 { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬鍒嗙粍
+ /// </summary>
+ [SugarColumn(ColumnName = "depextr2")]
+ public string Depextr2 { get; set; }
+
+ /// <summary>
+ /// WIP浠撳簱
+ /// </summary>
+ [SugarColumn(ColumnName = "depextr3")]
+ public string Depextr3 { get; set; }
+
+ /// <summary>
+ /// 鏄惁绂佺敤 A 鍚敤 B绂佺敤
+ /// </summary>
+ [SugarColumn(ColumnName = "depextr4")]
+ public string Depextr4 { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬鎵╁睍瀛楁5
+ /// </summary>
+ [SugarColumn(ColumnName = "depextr5")]
+ public string Depextr5 { get; set; }
+
+ /// <summary>
+ /// 杞﹂棿ID
+ /// </summary>
+ [SugarColumn(ColumnName = "workshop_no")]
+ public string WorkshopNo { get; set; }
+
+ /// <summary>
+ /// 杞﹂棿鍚�
+ /// </summary>
+ [SugarColumn(ColumnName = "workshop_name")]
+ public string WorkshopName { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬缁忕悊
+ /// </summary>
+ [SugarColumn(ColumnName = "fmanager")]
+ public string Fmanager { get; set; }
+
+ /// <summary>
+ /// 宸ュ巶
+ /// </summary>
+ [SugarColumn(ColumnName = "factory")]
+ public string Factory { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "create_by")]
+ public string CreateBy { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "create_date")]
+ public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ /// 鏈�鍚庝慨鏀逛汉
+ /// </summary>
+ [SugarColumn(ColumnName = "lastupdate_by")]
+ public string LastupdateBy { get; set; }
+
+ /// <summary>
+ /// 鏈�鍚庝慨鏀规棩鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "lastupdate_date")]
+ public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ /// 澶囨敞
+ /// </summary>
+ [SugarColumn(ColumnName = "remark")]
+ public string Remark { get; set; }
+
+ /// <summary>
+ /// 閮ㄩ棬id
+ /// </summary>
+ [SugarColumn(ColumnName = "id")]
+ public int? Id { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇杞﹂棿
+ /// </summary>
+ [SugarColumn(ColumnName = "production_workshop")]
+ public string ProductionWorkshop { get; set; }
+
+ /// <summary>
+ /// 鐗╂枡灞炴��
+ /// </summary>
+ [SugarColumn(ColumnName = "material_properti")]
+ public string MaterialProperti { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�4
+ /// </summary>
+ [SugarColumn(ColumnName = "remark4")]
+ public string Remark4 { get; set; }
+
+ /// <summary>
+ /// 鑷畾涔夊瓧娈�5
+ /// </summary>
+ [SugarColumn(ColumnName = "remark5")]
+ public string Remark5 { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "Fumbrella")]
+ public string Fumbrella { get; set; }
+
+ /// <summary>
+ /// 浣跨敤缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "FSubsidiary")]
+ public string FSubsidiary { get; set; }
+
+ /// <summary>
+ /// 涓婄骇閮ㄩ棬
+ /// </summary>
+ [SugarColumn(ColumnName = "FParentID")]
+ public string FParentID { get; set; }
+}
\ No newline at end of file
--
Gitblit v1.9.3