using SqlSugar;
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace cylsg.Model.ECTEModel
|
{
|
|
|
|
|
|
/// <summary>
|
/// 办公系统员工表
|
/// </summary>
|
[Tenant( "ECTESTOADB")]
|
[SugarTable("Oa_Staff")]
|
public class OaStaff
|
{
|
/// <summary>
|
/// 主键ID
|
/// </summary>
|
[SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
|
public int Keyid { get; set; }
|
|
/// <summary>
|
/// 所属厂商编号
|
/// </summary>
|
[SugarColumn(ColumnName = "FirmId")]
|
public Guid FirmId { get; set; }
|
|
/// <summary>
|
/// 姓名
|
/// </summary>
|
[SugarColumn(ColumnName = "Name", Length = 20)]
|
public string Name { get; set; }
|
|
/// <summary>
|
/// 性别
|
/// </summary>
|
[SugarColumn(ColumnName = "Sex", Length = 4)]
|
public string Sex { get; set; }
|
|
/// <summary>
|
/// 登录账号
|
/// </summary>
|
[SugarColumn(ColumnName = "StaffUserName", Length = 20)]
|
public string StaffUserName { get; set; }
|
|
/// <summary>
|
/// 密码
|
/// </summary>
|
[SugarColumn(ColumnName = "StaffUserPwd", Length = 20)]
|
public string StaffUserPwd { get; set; }
|
|
/// <summary>
|
/// 手机 ==对应用户ITCode
|
/// </summary>
|
[SugarColumn(ColumnName = "MobieNum", Length = 20)]
|
public string MobieNum { get; set; }
|
|
/// <summary>
|
/// QQ
|
/// </summary>
|
[SugarColumn(ColumnName = "QQ", Length = 20)]
|
public string QQ { get; set; }
|
|
/// <summary>
|
/// 联系电话
|
/// </summary>
|
[SugarColumn(ColumnName = "PhoneNum", Length = 20)]
|
public string PhoneNum { get; set; }
|
|
/// <summary>
|
/// Email
|
/// </summary>
|
[SugarColumn(ColumnName = "Email", Length = 50)]
|
public string Email { get; set; }
|
|
/// <summary>
|
/// 状态
|
/// </summary>
|
[SugarColumn(ColumnName = "Status", Length = 10)]
|
public string Status { get; set; }
|
|
/// <summary>
|
/// 最后修改时间
|
/// </summary>
|
[SugarColumn(ColumnName = "LastUpdateTime")]
|
public DateTime LastUpdateTime { get; set; }
|
|
/// <summary>
|
/// 操作人
|
/// </summary>
|
[SugarColumn(ColumnName = "Operator", Length = 20)]
|
public string Operator { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "Remark", Length = 200)]
|
public string Remark { get; set; }
|
|
/// <summary>
|
/// 关联会员
|
/// </summary>
|
[SugarColumn(ColumnName = "MemberId")]
|
public Guid? MemberId { get; set; }
|
|
/// <summary>
|
/// 是否为业务经理
|
/// </summary>
|
[SugarColumn(ColumnName = "IsBusinessManager")]
|
public bool? IsBusinessManager { get; set; }
|
|
/// <summary>
|
/// 是否为账户经理
|
/// </summary>
|
[SugarColumn(ColumnName = "IsAccountManager")]
|
public bool? IsAccountManager { get; set; }
|
|
/// <summary>
|
/// 部门ID
|
/// </summary>
|
[SugarColumn(ColumnName = "DepartmentId")]
|
public int? DepartmentId { get; set; }
|
/// <summary>
|
/// 部门
|
/// </summary>
|
[Navigate(NavigateType.OneToOne,nameof( DepartmentId),nameof(OaDepartment.Keyid))]
|
public OaDepartment Department { get; set; }
|
/// <summary>
|
/// 个人档案唯一编码
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_Number", Length = 50)]
|
public string SM_Number { get; set; }
|
|
/// <summary>
|
/// 爱人姓名
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_SpouseName", Length = 50)]
|
public string SM_SpouseName { get; set; }
|
|
/// <summary>
|
/// 爱人电话
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_SpousePhone", Length = 50)]
|
public string SM_SpousePhone { get; set; }
|
|
/// <summary>
|
/// 其他记录
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_OtherLog")]
|
public string SM_OtherLog { get; set; }
|
|
/// <summary>
|
/// 职务
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_Post", Length = 50)]
|
public string SM_Post { get; set; }
|
|
/// <summary>
|
/// 学历
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_Degree", Length = 50)]
|
public string SM_Degree { get; set; }
|
|
/// <summary>
|
/// 入职时间
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_StartWorkTime")]
|
public DateTime? SM_StartWorkTime { get; set; }
|
|
/// <summary>
|
/// 薪资待遇
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_Money", Length = 100)]
|
public string SM_Money { get; set; }
|
|
/// <summary>
|
/// 是否购买社保
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_IsSocialSecurity")]
|
public int? SM_IsSocialSecurity { get; set; }
|
|
/// <summary>
|
/// 社保类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_SocialSecurityType", Length = 50)]
|
public string SM_SocialSecurityType { get; set; }
|
|
/// <summary>
|
/// 社保卡号
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_SocialSecurityNumber", Length = 50)]
|
public string SM_SocialSecurityNumber { get; set; }
|
|
/// <summary>
|
/// 是否签订合同
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_IsContract")]
|
public int? SM_IsContract { get; set; }
|
|
/// <summary>
|
/// 合同签订时间
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_ContractStartTime")]
|
public DateTime? SM_ContractStartTime { get; set; }
|
|
/// <summary>
|
/// 合同到期时间
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_ContractEndTime")]
|
public DateTime? SM_ContractEndTime { get; set; }
|
|
/// <summary>
|
/// 离职审批
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_EndWorkStatus")]
|
public int? SM_EndWorkStatus { get; set; }
|
|
/// <summary>
|
/// 离职申请时间
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_EndWorkStartTime")]
|
public DateTime? SM_EndWorkStartTime { get; set; }
|
|
/// <summary>
|
/// 离职时间
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_EndWorkTime")]
|
public DateTime? SM_EndWorkTime { get; set; }
|
|
/// <summary>
|
/// 离职原因
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_EndWorkContent", Length = 200)]
|
public string SM_EndWorkContent { get; set; }
|
|
/// <summary>
|
/// 部门主管签字
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_DepartmentHeads", Length = 50)]
|
public string SM_DepartmentHeads { get; set; }
|
|
/// <summary>
|
/// 行政部签字
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_AdministrationDepartment", Length = 50)]
|
public string SM_AdministrationDepartment { get; set; }
|
|
/// <summary>
|
/// 财务部签字
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_MinistryFinance", Length = 50)]
|
public string SM_MinistryFinance { get; set; }
|
|
/// <summary>
|
/// 总经理签字
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_GeneralManager", Length = 50)]
|
public string SM_GeneralManager { get; set; }
|
|
/// <summary>
|
/// 是否导入
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_IsImporting")]
|
public int? SM_IsImporting { get; set; }
|
|
/// <summary>
|
/// 是否删除
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_IsDelete")]
|
public int? SM_IsDelete { get; set; }
|
|
/// <summary>
|
/// 出生日期
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_Birthday")]
|
public DateTime? SM_Birthday { get; set; }
|
|
/// <summary>
|
/// 身份证号码
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_IDCardNum", Length = 50)]
|
public string SM_IDCardNum { get; set; }
|
|
/// <summary>
|
/// 身份证图片
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_IDCardPic", Length = 200)]
|
public string SM_IDCardPic { get; set; }
|
|
/// <summary>
|
/// 证书类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_CertificateType")]
|
public string SM_CertificateType { get; set; }
|
|
/// <summary>
|
/// 证书图片
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_CertificatePic")]
|
public string SM_CertificatePic { get; set; }
|
|
/// <summary>
|
/// 现居省
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_NowProvince", Length = 50)]
|
public string SM_NowProvince { get; set; }
|
|
/// <summary>
|
/// 现居市
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_NowCity", Length = 50)]
|
public string SM_NowCity { get; set; }
|
|
/// <summary>
|
/// 现居区
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_NowArea", Length = 50)]
|
public string SM_NowArea { get; set; }
|
|
/// <summary>
|
/// 现居地址
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_NowAddress", Length = 50)]
|
public string SM_NowAddress { get; set; }
|
|
/// <summary>
|
/// 籍贯省
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_OldProvence", Length = 50)]
|
public string SM_OldProvence { get; set; }
|
|
/// <summary>
|
/// 籍贯市
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_OldCity", Length = 50)]
|
public string SM_OldCity { get; set; }
|
|
/// <summary>
|
/// 籍贯区
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_OldArea", Length = 50)]
|
public string SM_OldArea { get; set; }
|
|
/// <summary>
|
/// 籍贯地址
|
/// </summary>
|
[SugarColumn(ColumnName = "SM_OldAdress", Length = 50)]
|
public string SM_OldAdress { get; set; }
|
|
/// <summary>
|
/// 是否是司机
|
/// </summary>
|
[SugarColumn(ColumnName = "BF_IsDriver")]
|
public bool BF_IsDriver { get; set; }
|
|
/// <summary>
|
/// 是否是配送管理员
|
/// </summary>
|
[SugarColumn(ColumnName = "BF_IsDeliverManage")]
|
public bool BF_IsDeliverManage { get; set; }
|
|
/// <summary>
|
/// 是否为报销主管
|
/// </summary>
|
[SugarColumn(ColumnName = "BF_IsBaoxiaozhuguan")]
|
public bool BF_IsBaoxiaozhuguan { get; set; }
|
|
/// <summary>
|
/// 是否为报销经理
|
/// </summary>
|
[SugarColumn(ColumnName = "BF_Isbaoxiaojingli")]
|
public bool BF_Isbaoxiaojingli { get; set; }
|
|
|
}
|
|
|
}
|
