From 4f0cb973a7db26a9e65247033a95d9a8b3380d4b Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期二, 29 十月 2024 17:26:37 +0800
Subject: [PATCH] 基础信息和采购订单接口更新
---
MES.Service/Modes/SysUser.cs | 338 +++++++++----------------------------------------------
1 files changed, 58 insertions(+), 280 deletions(-)
diff --git a/MES.Service/Modes/SysUser.cs b/MES.Service/Modes/SysUser.cs
index a318f0d..9a97441 100644
--- a/MES.Service/Modes/SysUser.cs
+++ b/MES.Service/Modes/SysUser.cs
@@ -1,347 +1,125 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
using SqlSugar;
namespace MES.Service.Modes;
/// <summary>
/// </summary>
-[Table("SYS_USER")]
-[SugarTable("SYS_USER")] //鐢ㄤ簬SqlSugar
+[SugarTable("SYS_USER")]
public class SysUser
{
/// <summary>
- /// BASEINFO
+ /// 涓婚敭
/// </summary>
- [Key]
- [Column("FID")]
- [StringLength(20, ErrorMessage = "Fid闀垮害涓嶈兘瓒呭嚭20")]
- [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "BASEINFO",
- ColumnName = "FID")] //鐢ㄤ簬SqlSugar
- public string Fid { get; set; }
-
-
- [StringLength(20, ErrorMessage = "Sid闀垮害涓嶈兘瓒呭嚭20")]
- [SugarColumn(ColumnName = "SID")] //鐢ㄤ簬SqlSugar
- public decimal Sid { get; set; }
+ [SugarColumn(ColumnName = "GUID", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
/// <summary>
- /// 鎺ユ敹鐗╂枡鏄惁杩涜妫�鏌�
+ /// 璐﹀彿
/// </summary>
- [Column("CHECK_FLAG")]
- [SugarColumn(ColumnName = "CHECK_FLAG")] //鐢ㄤ簬SqlSugar
- public decimal? CheckFlag { get; set; }
+ [SugarColumn(ColumnName = "ACCOUNT")]
+ public string? Account { get; set; }
/// <summary>
+ /// 瀵嗙爜
/// </summary>
- [Column("COMPANY")]
- [SugarColumn(ColumnName = "COMPANY")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "Company闀垮害涓嶈兘瓒呭嚭20")]
- public string Company { get; set; }
+ [SugarColumn(ColumnName = "PASSWORD")]
+ public string? Password { get; set; }
/// <summary>
+ /// 鐢ㄦ埛濮撳悕
/// </summary>
- [Column("CREATE_BY")]
- [SugarColumn(ColumnName = "CREATE_BY")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "CreateBy闀垮害涓嶈兘瓒呭嚭20")]
- public string CreateBy { get; set; }
+ [SugarColumn(ColumnName = "USER_NAME")]
+ public string? UserName { get; set; }
/// <summary>
+ /// 浣忓潃
/// </summary>
- [Column("CREATE_DATE")]
- [SugarColumn(ColumnName = "CREATE_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? CreateDate { get; set; }
+ [SugarColumn(ColumnName = "ADDRESS")]
+ public string? Address { get; set; }
/// <summary>
- /// 鏄惁鏈夊垹闄ょ壒鏉�
+ /// 鐢佃瘽
/// </summary>
- [Column("DEL_FLAG")]
- [SugarColumn(ColumnName = "DEL_FLAG")] //鐢ㄤ簬SqlSugar
- public decimal? DelFlag { get; set; }
+ [SugarColumn(ColumnName = "TEL")]
+ public string? Tel { get; set; }
/// <summary>
- /// 閮ㄩ棬
+ /// 閭
/// </summary>
- [Column("DEPARTMENTID")]
- [SugarColumn(ColumnName = "DEPARTMENTID")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "閮ㄩ棬闀垮害涓嶈兘瓒呭嚭20")]
- public string Departmentid { get; set; }
+ [SugarColumn(ColumnName = "EMAIL")]
+ public string? Email { get; set; }
/// <summary>
+ /// 鏈�鍚庣櫥褰曟椂闂�
/// </summary>
- [Column("DEV")]
- [SugarColumn(ColumnName = "DEV")] //鐢ㄤ簬SqlSugar
- public decimal? Dev { get; set; }
+ [SugarColumn(ColumnName = "LASTLOGIN_TIME")]
+ public DateTime? LastloginTime { get; set; }
/// <summary>
+ /// 鏈�鍚庨��鍑烘椂闂�
/// </summary>
- [Column("EXP_FIEL10")]
- [SugarColumn(ColumnName = "EXP_FIEL10")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "ExpFiel10闀垮害涓嶈兘瓒呭嚭50")]
- public string ExpFiel10 { get; set; }
+ [SugarColumn(ColumnName = "LASTLOGOUT_TIME")]
+ public DateTime? LastlogoutTime { get; set; }
/// <summary>
+ /// 鐘舵��
/// </summary>
- [Column("EXP_FIEL11")]
- [SugarColumn(ColumnName = "EXP_FIEL11")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "ExpFiel11闀垮害涓嶈兘瓒呭嚭50")]
- public string ExpFiel11 { get; set; }
+ [SugarColumn(ColumnName = "IS_STATUS")]
+ public bool? IsStatus { get; set; }
/// <summary>
+ /// 寤虹珛鑰�
/// </summary>
- [Column("EXP_FIEL12")]
- [SugarColumn(ColumnName = "EXP_FIEL12")] //鐢ㄤ簬SqlSugar
- public decimal? ExpFiel12 { get; set; }
+ [SugarColumn(ColumnName = "CREATE_BY")]
+ public string? CreateBy { get; set; }
/// <summary>
- /// 鐝
+ /// 寤虹珛鏃堕棿
/// </summary>
- [Column("EXP_FIELD1")]
- [SugarColumn(ColumnName = "EXP_FIELD1")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "鐝闀垮害涓嶈兘瓒呭嚭20")]
- public string ExpField1 { get; set; }
+ [SugarColumn(ColumnName = "CREATE_TIME")]
+ public DateTime? CreateTime { get; set; }
/// <summary>
- /// 绾夸綋
+ /// 鏇存柊鏃堕棿
/// </summary>
- [Column("EXP_FIELD2")]
- [SugarColumn(ColumnName = "EXP_FIELD2")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "绾夸綋闀垮害涓嶈兘瓒呭嚭20")]
- public string ExpField2 { get; set; }
+ [SugarColumn(ColumnName = "LASTUPDATE_TIME")]
+ public DateTime? LastupdateTime { get; set; }
/// <summary>
- /// 鐓х墖
+ /// 鏇存柊浜�
/// </summary>
- [Column("EXP_FIELD3")]
- [SugarColumn(ColumnName = "EXP_FIELD3")] //鐢ㄤ簬SqlSugar
- public byte[] ExpField3 { get; set; }
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")]
+ public string? LastupdateBy { get; set; }
/// <summary>
- /// 鑱旂郴鏂瑰紡
+ /// 鏄惁鍦ㄧ嚎
/// </summary>
- [Column("EXP_FIELD4")]
- [SugarColumn(ColumnName = "EXP_FIELD4")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "鑱旂郴鏂瑰紡闀垮害涓嶈兘瓒呭嚭20")]
- public string ExpField4 { get; set; }
+ [SugarColumn(ColumnName = "FLAG_ONLINE")]
+ public int? FlagOnline { get; set; }
/// <summary>
- /// 鍥剧墖鍚�
+ /// 鐧诲綍娆℃暟
/// </summary>
- [Column("EXP_FIELD5")]
- [SugarColumn(ColumnName = "EXP_FIELD5")] //鐢ㄤ簬SqlSugar
- [StringLength(200, ErrorMessage = "鍥剧墖鍚嶉暱搴︿笉鑳借秴鍑�200")]
- public string ExpField5 { get; set; }
+ [SugarColumn(ColumnName = "LOGIN_COUNTER")]
+ public int? LoginCounter { get; set; }
/// <summary>
+ /// 澶囨敞
/// </summary>
- [Column("EXP_FIELD6")]
- [SugarColumn(ColumnName = "EXP_FIELD6")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "ExpField6闀垮害涓嶈兘瓒呭嚭20")]
- public string ExpField6 { get; set; }
+ [SugarColumn(ColumnName = "REMARK")]
+ public string? Remark { get; set; }
/// <summary>
- /// 杞﹂棿缂栫爜
+ /// 閮ㄩ棬缂栧彿
/// </summary>
- [Column("EXP_FIELD7")]
- [SugarColumn(ColumnName = "EXP_FIELD7")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "杞﹂棿缂栫爜闀垮害涓嶈兘瓒呭嚭50")]
- public string ExpField7 { get; set; }
+ [SugarColumn(ColumnName = "DEPART_NO")]
+ public string? DepartNo { get; set; }
/// <summary>
+ /// 鏄惁绯荤粺鍐呯疆
/// </summary>
- [Column("EXP_FIELD8")]
- [SugarColumn(ColumnName = "EXP_FIELD8")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "ExpField8闀垮害涓嶈兘瓒呭嚭50")]
- public string ExpField8 { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("EXP_FIELD9")]
- [SugarColumn(ColumnName = "EXP_FIELD9")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "ExpField9闀垮害涓嶈兘瓒呭嚭50")]
- public string ExpField9 { get; set; }
-
- /// <summary>
- /// 宸ュ巶
- /// </summary>
- [Column("FACTORY")]
- [SugarColumn(ColumnName = "FACTORY")] //鐢ㄤ簬SqlSugar
- [StringLength(1000, ErrorMessage = "宸ュ巶闀垮害涓嶈兘瓒呭嚭1000")]
- public string Factory { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("FBRANCH")]
- [SugarColumn(ColumnName = "FBRANCH")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "Fbranch闀垮害涓嶈兘瓒呭嚭20")]
- public string Fbranch { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("FCODE")]
- [SugarColumn(ColumnName = "FCODE")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "Fcode闀垮害涓嶈兘瓒呭嚭20")]
- public string Fcode { get; set; }
-
- /// <summary>
- /// 鍏徃
- /// </summary>
- [Column("FCOMPANY")]
- [SugarColumn(ColumnName = "FCOMPANY")] //鐢ㄤ簬SqlSugar
- [StringLength(1000, ErrorMessage = "鍏徃闀垮害涓嶈兘瓒呭嚭1000")]
- public string Fcompany { get; set; }
-
- /// <summary>
- /// 宸ュ巶
- /// </summary>
- [Column("FFACTORY")]
- [SugarColumn(ColumnName = "FFACTORY")] //鐢ㄤ簬SqlSugar
- [StringLength(1000, ErrorMessage = "宸ュ巶闀垮害涓嶈兘瓒呭嚭1000")]
- public string Ffactory { get; set; }
-
- /// <summary>
- /// 棣栨鐧婚檰
- /// </summary>
- [Column("FIRST_LOGIN")]
- [SugarColumn(ColumnName = "FIRST_LOGIN")] //鐢ㄤ簬SqlSugar
- public decimal? FirstLogin { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("FLOGIN_NAME")]
- [SugarColumn(ColumnName = "FLOGIN_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "FloginName闀垮害涓嶈兘瓒呭嚭20")]
- public string FloginName { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("FNAME")]
- [SugarColumn(ColumnName = "FNAME")] //鐢ㄤ簬SqlSugar
- [StringLength(40, ErrorMessage = "Fname闀垮害涓嶈兘瓒呭嚭40")]
- public string Fname { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("FPASSWORD")]
- [SugarColumn(ColumnName = "FPASSWORD")] //鐢ㄤ簬SqlSugar
- [StringLength(100, ErrorMessage = "Fpassword闀垮害涓嶈兘瓒呭嚭100")]
- public string Fpassword { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("FPLANT")]
- [SugarColumn(ColumnName = "FPLANT")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "Fplant闀垮害涓嶈兘瓒呭嚭20")]
- public string Fplant { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("FREADONLY")]
- [SugarColumn(ColumnName = "FREADONLY")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "Freadonly闀垮害涓嶈兘瓒呭嚭20")]
- public string Freadonly { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("FSYSTEM")]
- [SugarColumn(ColumnName = "FSYSTEM")] //鐢ㄤ簬SqlSugar
- [StringLength(10, ErrorMessage = "Fsystem闀垮害涓嶈兘瓒呭嚭10")]
- public string Fsystem { get; set; }
-
- /// <summary>
- /// 鏄惁涓洪噰闆嗕汉鍛�
- /// </summary>
- [Column("ISACQ")]
- [SugarColumn(ColumnName = "ISACQ")] //鐢ㄤ簬SqlSugar
- public decimal? Isacq { get; set; }
-
- /// <summary>
- /// 1涓虹鑱岋紝0涓烘甯稿憳宸�
- /// </summary>
- [Column("ISDEPARTURE")]
- [SugarColumn(ColumnName = "ISDEPARTURE")] //鐢ㄤ簬SqlSugar
- public decimal? Isdeparture { get; set; }
-
- /// <summary>
- /// 鏄惁涓虹鐞嗕汉鍛�
- /// </summary>
- [Column("ISMANAGER")]
- [SugarColumn(ColumnName = "ISMANAGER")] //鐢ㄤ簬SqlSugar
- public decimal? Ismanager { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("LASTLOGIN")]
- [SugarColumn(ColumnName = "LASTLOGIN")] //鐢ㄤ簬SqlSugar
- public DateTime? Lastlogin { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [Column("LASTUPDATE_BY")]
- [SugarColumn(ColumnName = "LASTUPDATE_BY")] //鐢ㄤ簬SqlSugar
- [StringLength(30, ErrorMessage = "鏈�鍚庢洿鏂颁汉闀垮害涓嶈兘瓒呭嚭30")]
- public string LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版棩鏈�
- /// </summary>
- [Column("LASTUPDATE_DATE")]
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 1涓哄紑鍙戠敤鎴凤紝0涓轰竴鑸搷浣滅敤鎴�
- /// </summary>
- [Column("LEVER")]
- [SugarColumn(ColumnName = "LEVER")] //鐢ㄤ簬SqlSugar
- public decimal? Lever { get; set; }
-
- /// <summary>
- /// 鏈夋晥鏈�
- /// </summary>
- [Column("PERIOD_VALIDITY")]
- [SugarColumn(ColumnName = "PERIOD_VALIDITY")] //鐢ㄤ簬SqlSugar
- public DateTime? PeriodValidity { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("PRD")]
- [SugarColumn(ColumnName = "PRD")] //鐢ㄤ簬SqlSugar
- public decimal? Prd { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("PSW_EDIT_TIME")]
- [SugarColumn(ColumnName = "PSW_EDIT_TIME")] //鐢ㄤ簬SqlSugar
- public DateTime? PswEditTime { get; set; }
-
- /// <summary>
- /// 璐ㄩ噺妯″潡棣栦欢纭-鍘熷洜鍒嗘瀽璐ｄ换浜�
- /// </summary>
- [Column("QM_USER")]
- [SugarColumn(ColumnName = "QM_USER")] //鐢ㄤ簬SqlSugar
- public decimal? QmUser { get; set; }
-
- /// <summary>
- /// 瑙掕壊
- /// </summary>
- [Column("ROLEID")]
- [SugarColumn(ColumnName = "ROLEID")] //鐢ㄤ簬SqlSugar
- public decimal? Roleid { get; set; }
-
- /// <summary>
- /// 鏄惁涓轰复鏃剁敤鎴�
- /// </summary>
- [Column("STATUS")]
- [SugarColumn(ColumnName = "STATUS")] //鐢ㄤ簬SqlSugar
- public decimal? Status { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("TET")]
- [SugarColumn(ColumnName = "TET")] //鐢ㄤ簬SqlSugar
- public decimal? Tet { get; set; }
+ [SugarColumn(ColumnName = "IS_SYS")]
+ public int? IsSys { get; set; }
[SugarColumn(IsIgnore = true)] public string? Type { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3