using Models;
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; }

        /// <summary>
        /// 车辆
        /// </summary>
        [Navigate(NavigateType.OneToOne, nameof(Keyid), nameof(OA_CarManage.StaffID))]
        public OA_CarManage? Car { get; set; }


    }
    

}