using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; using SqlSugar; namespace MES.Service.Modes; /// /// [Table("SYS_USER")] [SugarTable("SYS_USER")] //用于SqlSugar public class SysUser { /// /// BASEINFO /// [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; } /// /// 接收物料是否进行检查 /// [Column("CHECK_FLAG")] [SugarColumn(ColumnName = "CHECK_FLAG")] //用于SqlSugar public decimal? CheckFlag { get; set; } /// /// [Column("COMPANY")] [SugarColumn(ColumnName = "COMPANY")] //用于SqlSugar [StringLength(20, ErrorMessage = "Company长度不能超出20")] public string Company { get; set; } /// /// [Column("CREATE_BY")] [SugarColumn(ColumnName = "CREATE_BY")] //用于SqlSugar [StringLength(20, ErrorMessage = "CreateBy长度不能超出20")] public string CreateBy { get; set; } /// /// [Column("CREATE_DATE")] [SugarColumn(ColumnName = "CREATE_DATE")] //用于SqlSugar public DateTime? CreateDate { get; set; } /// /// 是否有删除特权 /// [Column("DEL_FLAG")] [SugarColumn(ColumnName = "DEL_FLAG")] //用于SqlSugar public decimal? DelFlag { get; set; } /// /// 部门 /// [Column("DEPARTMENTID")] [SugarColumn(ColumnName = "DEPARTMENTID")] //用于SqlSugar [StringLength(20, ErrorMessage = "部门长度不能超出20")] public string Departmentid { get; set; } /// /// [Column("DEV")] [SugarColumn(ColumnName = "DEV")] //用于SqlSugar public decimal? Dev { get; set; } /// /// [Column("EXP_FIEL10")] [SugarColumn(ColumnName = "EXP_FIEL10")] //用于SqlSugar [StringLength(50, ErrorMessage = "ExpFiel10长度不能超出50")] public string ExpFiel10 { get; set; } /// /// [Column("EXP_FIEL11")] [SugarColumn(ColumnName = "EXP_FIEL11")] //用于SqlSugar [StringLength(50, ErrorMessage = "ExpFiel11长度不能超出50")] public string ExpFiel11 { get; set; } /// /// [Column("EXP_FIEL12")] [SugarColumn(ColumnName = "EXP_FIEL12")] //用于SqlSugar public decimal? ExpFiel12 { get; set; } /// /// 班次 /// [Column("EXP_FIELD1")] [SugarColumn(ColumnName = "EXP_FIELD1")] //用于SqlSugar [StringLength(20, ErrorMessage = "班次长度不能超出20")] public string ExpField1 { get; set; } /// /// 线体 /// [Column("EXP_FIELD2")] [SugarColumn(ColumnName = "EXP_FIELD2")] //用于SqlSugar [StringLength(20, ErrorMessage = "线体长度不能超出20")] public string ExpField2 { get; set; } /// /// 照片 /// [Column("EXP_FIELD3")] [SugarColumn(ColumnName = "EXP_FIELD3")] //用于SqlSugar public byte[] ExpField3 { get; set; } /// /// 联系方式 /// [Column("EXP_FIELD4")] [SugarColumn(ColumnName = "EXP_FIELD4")] //用于SqlSugar [StringLength(20, ErrorMessage = "联系方式长度不能超出20")] public string ExpField4 { get; set; } /// /// 图片名 /// [Column("EXP_FIELD5")] [SugarColumn(ColumnName = "EXP_FIELD5")] //用于SqlSugar [StringLength(200, ErrorMessage = "图片名长度不能超出200")] public string ExpField5 { get; set; } /// /// [Column("EXP_FIELD6")] [SugarColumn(ColumnName = "EXP_FIELD6")] //用于SqlSugar [StringLength(20, ErrorMessage = "ExpField6长度不能超出20")] public string ExpField6 { get; set; } /// /// 车间编码 /// [Column("EXP_FIELD7")] [SugarColumn(ColumnName = "EXP_FIELD7")] //用于SqlSugar [StringLength(50, ErrorMessage = "车间编码长度不能超出50")] public string ExpField7 { get; set; } /// /// [Column("EXP_FIELD8")] [SugarColumn(ColumnName = "EXP_FIELD8")] //用于SqlSugar [StringLength(50, ErrorMessage = "ExpField8长度不能超出50")] public string ExpField8 { get; set; } /// /// [Column("EXP_FIELD9")] [SugarColumn(ColumnName = "EXP_FIELD9")] //用于SqlSugar [StringLength(50, ErrorMessage = "ExpField9长度不能超出50")] public string ExpField9 { get; set; } /// /// 工厂 /// [Column("FACTORY")] [SugarColumn(ColumnName = "FACTORY")] //用于SqlSugar [StringLength(1000, ErrorMessage = "工厂长度不能超出1000")] public string Factory { get; set; } /// /// [Column("FBRANCH")] [SugarColumn(ColumnName = "FBRANCH")] //用于SqlSugar [StringLength(20, ErrorMessage = "Fbranch长度不能超出20")] public string Fbranch { get; set; } /// /// [Column("FCODE")] [SugarColumn(ColumnName = "FCODE")] //用于SqlSugar [StringLength(20, ErrorMessage = "Fcode长度不能超出20")] public string Fcode { get; set; } /// /// 公司 /// [Column("FCOMPANY")] [SugarColumn(ColumnName = "FCOMPANY")] //用于SqlSugar [StringLength(1000, ErrorMessage = "公司长度不能超出1000")] public string Fcompany { get; set; } /// /// 工厂 /// [Column("FFACTORY")] [SugarColumn(ColumnName = "FFACTORY")] //用于SqlSugar [StringLength(1000, ErrorMessage = "工厂长度不能超出1000")] public string Ffactory { get; set; } /// /// 首次登陆 /// [Column("FIRST_LOGIN")] [SugarColumn(ColumnName = "FIRST_LOGIN")] //用于SqlSugar public decimal? FirstLogin { get; set; } /// /// [Column("FLOGIN_NAME")] [SugarColumn(ColumnName = "FLOGIN_NAME")] //用于SqlSugar [StringLength(20, ErrorMessage = "FloginName长度不能超出20")] public string FloginName { get; set; } /// /// [Column("FNAME")] [SugarColumn(ColumnName = "FNAME")] //用于SqlSugar [StringLength(40, ErrorMessage = "Fname长度不能超出40")] public string Fname { get; set; } /// /// [Column("FPASSWORD")] [SugarColumn(ColumnName = "FPASSWORD")] //用于SqlSugar [StringLength(100, ErrorMessage = "Fpassword长度不能超出100")] public string Fpassword { get; set; } /// /// [Column("FPLANT")] [SugarColumn(ColumnName = "FPLANT")] //用于SqlSugar [StringLength(20, ErrorMessage = "Fplant长度不能超出20")] public string Fplant { get; set; } /// /// [Column("FREADONLY")] [SugarColumn(ColumnName = "FREADONLY")] //用于SqlSugar [StringLength(20, ErrorMessage = "Freadonly长度不能超出20")] public string Freadonly { get; set; } /// /// [Column("FSYSTEM")] [SugarColumn(ColumnName = "FSYSTEM")] //用于SqlSugar [StringLength(20, ErrorMessage = "Fsystem长度不能超出20")] public string Fsystem { get; set; } /// /// 是否为采集人员 /// [Column("ISACQ")] [SugarColumn(ColumnName = "ISACQ")] //用于SqlSugar public decimal? Isacq { get; set; } /// /// 1为离职,0为正常员工 /// [Column("ISDEPARTURE")] [SugarColumn(ColumnName = "ISDEPARTURE")] //用于SqlSugar public decimal? Isdeparture { get; set; } /// /// 是否为管理人员 /// [Column("ISMANAGER")] [SugarColumn(ColumnName = "ISMANAGER")] //用于SqlSugar public decimal? Ismanager { get; set; } /// /// [Column("LASTLOGIN")] [SugarColumn(ColumnName = "LASTLOGIN")] //用于SqlSugar public DateTime? Lastlogin { get; set; } /// /// 最后更新人 /// [Column("LASTUPDATE_BY")] [SugarColumn(ColumnName = "LASTUPDATE_BY")] //用于SqlSugar [StringLength(30, ErrorMessage = "最后更新人长度不能超出30")] public string LastupdateBy { get; set; } /// /// 最后更新日期 /// [Column("LASTUPDATE_DATE")] [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //用于SqlSugar public DateTime? LastupdateDate { get; set; } /// /// 1为开发用户,0为一般操作用户 /// [Column("LEVER")] [SugarColumn(ColumnName = "LEVER")] //用于SqlSugar public decimal? Lever { get; set; } /// /// 有效期 /// [Column("PERIOD_VALIDITY")] [SugarColumn(ColumnName = "PERIOD_VALIDITY")] //用于SqlSugar public DateTime? PeriodValidity { get; set; } /// /// [Column("PRD")] [SugarColumn(ColumnName = "PRD")] //用于SqlSugar public decimal? Prd { get; set; } /// /// [Column("PSW_EDIT_TIME")] [SugarColumn(ColumnName = "PSW_EDIT_TIME")] //用于SqlSugar public DateTime? PswEditTime { get; set; } /// /// 质量模块首件确认-原因分析责任人 /// [Column("QM_USER")] [SugarColumn(ColumnName = "QM_USER")] //用于SqlSugar public decimal? QmUser { get; set; } /// /// 角色 /// [Column("ROLEID")] [SugarColumn(ColumnName = "ROLEID")] //用于SqlSugar public decimal? Roleid { get; set; } /// /// 是否为临时用户 /// [Column("STATUS")] [SugarColumn(ColumnName = "STATUS")] //用于SqlSugar public decimal? Status { get; set; } /// /// [Column("TET")] [SugarColumn(ColumnName = "TET")] //用于SqlSugar public decimal? Tet { get; set; } [SugarColumn(IsIgnore = true)] public string? Type { get; set; } }