From e08a2e8a24be0996dec3b681f3c4ab45333f331c Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期二, 22 十月 2024 17:54:29 +0800 Subject: [PATCH] 初始化 --- MES.Service/Modes/SysUser.cs | 347 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 347 insertions(+), 0 deletions(-) diff --git a/MES.Service/Modes/SysUser.cs b/MES.Service/Modes/SysUser.cs new file mode 100644 index 0000000..a318f0d --- /dev/null +++ b/MES.Service/Modes/SysUser.cs @@ -0,0 +1,347 @@ +using System.ComponentModel.DataAnnotations; +using System.ComponentModel.DataAnnotations.Schema; +using SqlSugar; + +namespace MES.Service.Modes; + +/// <summary> +/// </summary> +[Table("SYS_USER")] +[SugarTable("SYS_USER")] //鐢ㄤ簬SqlSugar +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; } + + /// <summary> + /// 鎺ユ敹鐗╂枡鏄惁杩涜妫�鏌� + /// </summary> + [Column("CHECK_FLAG")] + [SugarColumn(ColumnName = "CHECK_FLAG")] //鐢ㄤ簬SqlSugar + public decimal? CheckFlag { get; set; } + + /// <summary> + /// </summary> + [Column("COMPANY")] + [SugarColumn(ColumnName = "COMPANY")] //鐢ㄤ簬SqlSugar + [StringLength(20, ErrorMessage = "Company闀垮害涓嶈兘瓒呭嚭20")] + public string Company { get; set; } + + /// <summary> + /// </summary> + [Column("CREATE_BY")] + [SugarColumn(ColumnName = "CREATE_BY")] //鐢ㄤ簬SqlSugar + [StringLength(20, ErrorMessage = "CreateBy闀垮害涓嶈兘瓒呭嚭20")] + public string CreateBy { get; set; } + + /// <summary> + /// </summary> + [Column("CREATE_DATE")] + [SugarColumn(ColumnName = "CREATE_DATE")] //鐢ㄤ簬SqlSugar + public DateTime? CreateDate { get; set; } + + /// <summary> + /// 鏄惁鏈夊垹闄ょ壒鏉� + /// </summary> + [Column("DEL_FLAG")] + [SugarColumn(ColumnName = "DEL_FLAG")] //鐢ㄤ簬SqlSugar + public decimal? DelFlag { get; set; } + + /// <summary> + /// 閮ㄩ棬 + /// </summary> + [Column("DEPARTMENTID")] + [SugarColumn(ColumnName = "DEPARTMENTID")] //鐢ㄤ簬SqlSugar + [StringLength(20, ErrorMessage = "閮ㄩ棬闀垮害涓嶈兘瓒呭嚭20")] + public string Departmentid { get; set; } + + /// <summary> + /// </summary> + [Column("DEV")] + [SugarColumn(ColumnName = "DEV")] //鐢ㄤ簬SqlSugar + public decimal? Dev { get; set; } + + /// <summary> + /// </summary> + [Column("EXP_FIEL10")] + [SugarColumn(ColumnName = "EXP_FIEL10")] //鐢ㄤ簬SqlSugar + [StringLength(50, ErrorMessage = "ExpFiel10闀垮害涓嶈兘瓒呭嚭50")] + public string ExpFiel10 { get; set; } + + /// <summary> + /// </summary> + [Column("EXP_FIEL11")] + [SugarColumn(ColumnName = "EXP_FIEL11")] //鐢ㄤ簬SqlSugar + [StringLength(50, ErrorMessage = "ExpFiel11闀垮害涓嶈兘瓒呭嚭50")] + public string ExpFiel11 { get; set; } + + /// <summary> + /// </summary> + [Column("EXP_FIEL12")] + [SugarColumn(ColumnName = "EXP_FIEL12")] //鐢ㄤ簬SqlSugar + public decimal? ExpFiel12 { get; set; } + + /// <summary> + /// 鐝 + /// </summary> + [Column("EXP_FIELD1")] + [SugarColumn(ColumnName = "EXP_FIELD1")] //鐢ㄤ簬SqlSugar + [StringLength(20, ErrorMessage = "鐝闀垮害涓嶈兘瓒呭嚭20")] + public string ExpField1 { get; set; } + + /// <summary> + /// 绾夸綋 + /// </summary> + [Column("EXP_FIELD2")] + [SugarColumn(ColumnName = "EXP_FIELD2")] //鐢ㄤ簬SqlSugar + [StringLength(20, ErrorMessage = "绾夸綋闀垮害涓嶈兘瓒呭嚭20")] + public string ExpField2 { get; set; } + + /// <summary> + /// 鐓х墖 + /// </summary> + [Column("EXP_FIELD3")] + [SugarColumn(ColumnName = "EXP_FIELD3")] //鐢ㄤ簬SqlSugar + public byte[] ExpField3 { get; set; } + + /// <summary> + /// 鑱旂郴鏂瑰紡 + /// </summary> + [Column("EXP_FIELD4")] + [SugarColumn(ColumnName = "EXP_FIELD4")] //鐢ㄤ簬SqlSugar + [StringLength(20, ErrorMessage = "鑱旂郴鏂瑰紡闀垮害涓嶈兘瓒呭嚭20")] + public string ExpField4 { get; set; } + + /// <summary> + /// 鍥剧墖鍚� + /// </summary> + [Column("EXP_FIELD5")] + [SugarColumn(ColumnName = "EXP_FIELD5")] //鐢ㄤ簬SqlSugar + [StringLength(200, ErrorMessage = "鍥剧墖鍚嶉暱搴︿笉鑳借秴鍑�200")] + public string ExpField5 { get; set; } + + /// <summary> + /// </summary> + [Column("EXP_FIELD6")] + [SugarColumn(ColumnName = "EXP_FIELD6")] //鐢ㄤ簬SqlSugar + [StringLength(20, ErrorMessage = "ExpField6闀垮害涓嶈兘瓒呭嚭20")] + public string ExpField6 { get; set; } + + /// <summary> + /// 杞﹂棿缂栫爜 + /// </summary> + [Column("EXP_FIELD7")] + [SugarColumn(ColumnName = "EXP_FIELD7")] //鐢ㄤ簬SqlSugar + [StringLength(50, ErrorMessage = "杞﹂棿缂栫爜闀垮害涓嶈兘瓒呭嚭50")] + public string ExpField7 { 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> + /// 璐ㄩ噺妯″潡棣栦欢纭-鍘熷洜鍒嗘瀽璐d换浜� + /// </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(IsIgnore = true)] public string? Type { get; set; } +} \ No newline at end of file -- Gitblit v1.9.3