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>
|
/// 质量模块首件确认-原因分析责任人
|
/// </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; }
|
}
|