LIOT/EMIS.ViewModel/ExaminationApply/StudentListForExportView.cs

using EMIS.ViewModel.Cache;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;

namespace EMIS.ViewModel.ExaminationApply
{
    public class StudentListForExportView
    {
        public int? OrderNumber { get; set; }

        public Guid? UserID { get; set; }

        public Guid? ExaminationRegistrationID { get; set; }


        /// <summary>
        /// 考试报名学年学期ID
        /// </summary>
        public Guid? ExaminationSchoolyearID { get; set; }

        [DisplayName("学年学期")]
        public Guid? SchoolyearID { get; set; }

        [DisplayName("学年学期")]
        public string SchoolyearCode { get; set; }

        [DisplayName("考试批次")]
        public Guid? ExaminationBatchID { get; set; }

        [DisplayName("考试批次")]
        public string ExaminationBatchName { get; set; }

        [DisplayName("项目级别")]
        public int? ExaminationLevelID { get; set; }

        [DisplayName("项目级别")]
        public string ExaminationLevelName {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.EX_ExaminationLevel.ToString())
                    .Where(x => x.Value == ExaminationLevelID)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("考试类型")]
        public Guid? ExaminationTypeID { get; set; }

        [DisplayName("项目种类")]
        public string ExaminationTypeName { get; set; }

        [DisplayName("考试批次")]
        public Guid? ExaminationBatchProjectID { get; set; }

        //[DisplayName("考试批次")]
        //public string ExaminationBatchProjectName { get; set; }

        [DisplayName("项目名称")]
        public Guid? ExaminationProjectID { get; set; }

        [DisplayName("项目名称")]
        public string ExaminationProjectName { get; set; }

        public DateTime? StartDate { get; set; }
        public DateTime? EndDate { get; set; }

        [DisplayName("院系")]
        public Guid? CollegeID { get; set; }

        [DisplayName("院系")]
        public string CollegeName { get; set; }

        /// <summary>
        /// 校区
        /// </summary>
        public int? SchoolAreaID { get; set; }
        public string SchoolAreaName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.CF_SchoolArea.ToString())
                    .Where(x => x.Value == SchoolAreaID)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        /// <summary>
        /// 校区ID
        /// </summary>
        [Display(ResourceType = typeof(EMIS.Resources.DataAnnotations.Label), Name = "CampusID")]
        public Guid? CampusID { get; set; }

        /// <summary>
        /// 校区ID
        /// </summary>
        [Display(ResourceType = typeof(EMIS.Resources.DataAnnotations.Label), Name = "Campus")]
        public string CampusName { get; set; }

        [DisplayName("年级")]
        public int? SchoolyearNumID { get; set; }

        [DisplayName("年级")]
        public string SchoolyearNumName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.CF_SchoolyearNum.ToString())
                    .Where(x => x.Value == SchoolyearNumID)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("班级名称")]
        public Guid? ClassmajorID { get; set; }

        [DisplayName("班级名称")]
        public string ClassmajorName { get; set; }

        /// <summary>
        /// 班级编号
        /// </summary>
        [DisplayName("班级编号")]
        public string ClassmajorCode { get; set; }

        [DisplayName("班号")]
        public string ClassmajorNo { get; set; }

        [DisplayName("是否交费")]
        public string IsPay { get; set; }

        [DisplayName("是否已确认")]
        public bool IsConfirm { get; set; }

        [DisplayName("学号")]
        public string StudentNo { get; set; }

        [DisplayName("姓名")]
        public string UserName { get; set; }

        [DisplayName("英文名")]
        public string EnglishName { get; set; }

        [DisplayName("性别")]
        public int? Sex { get; set; }
        /// <summary>
        /// 性别导入
        /// </summary>
        public string SexForImport { get; set; }
        [DisplayName("性别")]
        public string SexName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.CF_Sex.ToString())
                    .Where(x => x.Value == Sex)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("出生日期")]
        [DataType(DataType.Date)]
        [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}")]
        public DateTime? BirthDate { get; set; }

        [DisplayName("报名日期")]
        [DataType(DataType.Date)]
        [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}")]
        public DateTime? RegistrDate { get; set; }

        [DisplayName("收费日期")]
        [DataType(DataType.Date)]
        [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}")]
        public DateTime? PayDate { get; set; }

        /// <summary>
        /// 入学日期
        /// </summary>
        [DisplayName("入学日期")]
        [DataType(DataType.Date)]
        [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}")]
        public DateTime? EntranceDate { get; set; }

        /// <summary>
        /// 预计毕业日期
        /// </summary>
        [DisplayName("预计毕业日期")]
        [DataType(DataType.Date)]
        [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}")]
        public DateTime? PlanningGraduateDate { get; set; }


        /// <summary>
        /// 毕业结论
        /// </summary>
        [Required]
        [DisplayName("毕业结论")]
        public int? GraduationResult { get; set; }
        /// <summary>
        /// 毕业结论
        /// </summary>
        [DisplayName("毕业结论")]
        public string GraduationResultName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.ER_GraduationResult.ToString())
                    .Where(x => x.Value == GraduationResult)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("微信号")]
        public string WeChatNo { get; set; }

        [DisplayName("QQ")]
        public string QQ { get; set; }

        [DisplayName("邮箱")]
        public string Email { get; set; }

        [DisplayName("联系电话")]
        public string PhoneNumber { get; set; }

        /// <summary>
        /// 民族
        /// </summary>
        [DisplayName("民族")]
        public int? Nation { get; set; }

        /// <summary>
        /// 民族
        /// </summary>
        [DisplayName("民族")]
        public string NationName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.CF_Nation.ToString())
                    .Where(x => x.Value == Nation)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("报名费")]
        public decimal? Cost { get; set; }

        [DisplayName("证件类型")]
        public int? CertificatesType { get; set; }

        /// <summary>
        /// 证件类型导入
        /// </summary>
        public string CertificatesTypeNameForImport { get; set; }

        [DisplayName("证件类型")]
        public string CertificatesTypeName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.CF_CertificatesType.ToString())
                    .Where(x => x.Value == CertificatesType)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("证件号码")]
        public string IDNumber { get; set; }

        [DisplayName("项目收费标准对应收费项ID")]
        public Guid? ExaminationProjectFeeTypeID { get; set; }

        [DisplayName("项目收费标准对应收费项")]
        public string ExaminationProjectFeeTypeName { get; set; }

        [DisplayName("项目收费标准")]
        public Guid? ExaminationProjectFeeID { get; set; }

        [DisplayName("项目收费标准")]
        public string ExaminationProjectFeeName { get; set; }

        [DisplayName("收费项")]
        public int? FeeTypeID { get; set; }

        /// <summary>
        /// 编辑绑定下拉用
        /// </summary>
        [DisplayName("收费项")]
        public int? Value { get; set; }

        [DisplayName("收费项")]
        public string FeeTypeName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.EX_ExaminationProjectFeeType.ToString())
                    .Where(x => x.Value == FeeTypeID)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("费用")]
        public decimal? Fee { get; set; }

        [DisplayName("总费用")]
        public decimal? PayFee { get; set; }

        [DisplayName("报名项目（费用）")]
        public string FeeTypeAndFee
        {
            get
            {
                return FeeTypeName + "(" + Fee.ToString() + ")";
            }
        }

        /// <summary>
        /// 银行卡号
        /// </summary>
        [DisplayName("银行卡号")]
        public string CardNo { get; set; }

        [DisplayName("学历")]
        public int? EducationID { get; set; }

        [DisplayName("学历")]
        public string EducationName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.CF_Education.ToString())
                    .Where(x => x.Value == EducationID)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("户口性质")]
        public string ResidenceTypeName { get; set; }

        /// <summary>
        /// 通讯地址
        /// </summary>
        [DisplayName("通讯地址")]
        public string Address { get; set; }

        /// <summary>
        /// 家庭地址
        /// </summary>
        [DisplayName("家庭地址")]
        public string HomeAddress { get; set; }

        /// <summary>
        /// 移动电话
        /// </summary>
        [DisplayName("联系电话")]
        public string Mobile { get; set; }

        /// <summary>
        /// 户口所在地
        /// </summary>
        [DisplayName("户口所在地")]
        public string Residence { get; set; }

        public string ResidenceStr {
            get {
                int tryResidence = 0;
                return (Residence != "" && Residence != null && int.TryParse(Residence,out tryResidence)) ? IdNameExt.GetDictionaryItem(DictionaryItem.CF_Origin.ToString())
                    .Where(x => x.Value == int.Parse(Residence))
                    .Select(x => x.Name).FirstOrDefault() : Residence ;
            }
        }

        [DisplayName("缴费状态")]
        public int? RecordStatus { get; set; }

        [DisplayName("缴费状态")]
        public string RecordStatusStr
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.EX_ExaminationRegistrationStatus.ToString())
                    .Where(x => x.Value == RecordStatus)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("确认单号ID")]
        public Guid? ExaminationRegistrationConfirmID { get; set; }

        [DisplayName("确认单号")]
        public string ExaminationRegistrationConfirmNo { get; set; }

        [DisplayName("备注")]
        public string Remark { get; set; }

        [DisplayName("学制")]
        public decimal? LearnSystem { get; set; }

        /// <summary>
        /// 学习形式
        /// </summary>
        [DisplayName("学习形式")]
        public int? LearningformID { get; set; }

        /// <summary>
        /// 标准专业名称
        /// </summary>
        [DisplayName("学习形式")]
        public string LearningformName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.CF_Learningform.ToString())
                    .Where(x => x.Value == LearningformID)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("入学年份")]
        public int? Year { get; set; }

        [DisplayName("专业")]
        public int? StandardID { get; set; }

        [DisplayName("专业")]
        public string StandardName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.CF_Standard.ToString())
                    .Where(x => x.Value == StandardID)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        /// <summary>
        /// 专业代码
        /// </summary>
        [DisplayName("专业代码")]
        public string StandardCode
        {
            get
            {
                var inistStandardCode = IdNameExt.GetDictionaryItem(DictionaryItem.CF_Standard.ToString())
                    .Where(x => x.Value == StandardID)
                    .Select(x => x.Code).FirstOrDefault();
                return (inistStandardCode != null ? inistStandardCode.PadLeft(6, '0') : "");
            }
        }

        [DisplayName("报考次数")]
        public int RegistedCount { get; set; }

        [DisplayName("照片")]
        public string PhotoUrl { get; set; }

        ///<summary>
        ///
        /// </summary>
        public bool IsExcelVaildateOK { get; set; }
        /// <summary>
        /// 错误信息
        /// </summary>
        [DisplayName("错误信息")]
        public string ErrorMessage { get; set; }

        [DisplayName("特殊标志")]
        public string SpecialSign { get; set; }

        [DisplayName("工龄")]
        public decimal? WorkingYears { get; set; }

        [DisplayName("工作单位")]
        public string WorkPlace { get; set; }

        [DisplayName("上一级职业资格级别")]
        public string ProfessionalQualificationLevel { get; set; }

        [DisplayName("副本")]
        public string Copy { get; set; }

        [DisplayName("考试类型")]
        public string TestType { get; set; }

        [DisplayName("鉴定人员类别")]
        public string AppraisalPersonalType { get; set; }

        [DisplayName("人员类别")]
        public string PersonalType { get; set; }

        /// <summary>
        /// 政治面貌
        /// </summary>
        [DisplayName("政治面貌")]
        [Required]
        public int? Politics { get; set; }

        //<summary>
        //政治面貌
        //</summary>
        [DisplayName("政治面貌")]
        public string PoliticsName
        {
            get
            {
                return IdNameExt.GetDictionaryItem(DictionaryItem.CF_Politics.ToString())
                    .Where(x => x.Value == Politics)
                    .Select(x => x.Name).FirstOrDefault();
            }
        }

        [DisplayName("婚姻状况")]
        public string MaritalStatus { get; set; }

        [DisplayName("国家职业资格等级")]
        public string NationalQualificationLevel { get; set; }

        [DisplayName("专业技术职务级别")]
        public string PositionLevel { get; set; }

        [DisplayName("国家/地区代码")]
        public string NationalAndCode { get; set; }

        [DisplayName("补考理论")]
        public string ResitTheory { get; set; }

        [DisplayName("补考实操")]
        public string ResitPractice { get; set; }

        [DisplayName("补加考1")]
        public string ResitOne { get; set; }

        [DisplayName("补加考2")]
        public string ResitTwo { get; set; }

        [DisplayName("补加考3")]
        public string ResitThree { get; set; }

        [DisplayName("补加考4")]
        public string ResitFour { get; set; }

        [DisplayName("职称")]
        public string ProfessionalTitle { get; set; }

        [DisplayName("是否免考理论")]
        public string IsNotTheory { get; set; }

        [DisplayName("理论成绩")]
        public decimal? TheoryScore { get; set; }

        [DisplayName("实操成绩")]
        public decimal? PracticeScore { get; set; }

        [DisplayName("补加考1成绩")]
        public string ResitOneScore { get; set; }

        [DisplayName("补加考2成绩")]
        public string ResitTwoScore { get; set; }

        [DisplayName("补加考3成绩")]
        public string ResitThreeScore { get; set; }

        [DisplayName("补加考4成绩")]
        public string ResitFourScore { get; set; }

        [DisplayName("参加工作时间")]
        [DataType(DataType.Date)]
        [DisplayFormat(DataFormatString = "{0:yyyy-MM-dd}")]
        public DateTime? JoinWorkDate { get; set; }

        [DisplayName("从事职业")]
        public string WorkType { get; set; }

        /// <summary>
        /// 考生来源
        /// </summary>
        [DisplayName("考生来源")]
        public string Area { get; set; }

        /// <summary>
        /// 户口所在市（区）
        /// </summary>
        [DisplayName("户口所在市（区）")]
        public string Place { get; set; }

        /// <summary>
        /// 邮编
        /// </summary>
        [DisplayName("邮编")]
        public string ZipCode { get; set; }

        [DisplayName("身份证住址")]
        public string IDCardAddress { get; set; }

        [DisplayName("现役军人")]
        public string IsSoldier { get; set; }

        [DisplayName("下岗人员")]
        public string IsLaidOff { get; set; }

        [DisplayName("失业人员")]
        public string IsUnemployment { get; set; }

        [DisplayName("残疾人员")]
        public string IsDisability { get; set; }

        [DisplayName("农民工")]
        public string IsFarmer { get; set; }

        [DisplayName("劳教劳改人员")]
        public string IsLabour { get; set; }

        [DisplayName("其他")]
        public string Other { get; set; }

        [DisplayName("申报职业")]
        public string DeclareOccupation { get; set; }

        [DisplayName("申报级别")]
        public string DeclareLevel { get; set; }

        [DisplayName("申报条件")]
        public string DeclareCondition { get; set; }

        [DisplayName("鉴定分类")]
        public string AppraisalType { get; set; }

        [DisplayName("原证书编号")]
        public string OldCertificateNumber{ get; set; }

        [DisplayName("考生类别")]
        public string ExamineeType { get; set; }

        [DisplayName("补贴对象")]
        public string SubsidyTarget { get; set; }

        [DisplayName("补贴证件类型")]
        public string SubsidyCertificateType { get; set; }

        [DisplayName("补贴证件编码")]
        public string SubsidyCertificateNumber { get; set; }

        [DisplayName("报名备注")]
        public string ExamineeRemark { get; set; }

        [DisplayName("报名单位")]
        public string ExamineeCampus { get; set; }

        [DisplayName("考生号")]
        public string ExamineeNum { get; set; }

        /// <summary>
        /// 院校代码
        /// </summary>
        [DisplayName("院校代码")]
        public string SchoolCode { get; set; }

        /// <summary>
        /// 院校名称
        /// </summary>
        [DisplayName("院校名称")]
        public string SchoolName { get; set; }

    }
}