using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using EMIS.DataLogic.StudentSystem.StudentMaterial;
using EMIS.ViewModel.Students;
using EMIS.ViewModel.CacheManage;
using EMIS.ViewModel;
using EMIS.Entities;
using System.Web;
using EMIS.CommonLogic.CalendarManage;
using EMIS.DataLogic.Common.Students;
using System.ComponentModel;
using EMIS.DataLogic.Common.CalendarManage;
using EMIS.DataLogic.UniversityManage.SpecialtyClassManage;
using EMIS.DataLogic.Repositories;
using EMIS.DataLogic.StudentManage.OnlineChecking;

namespace EMIS.CommonLogic.Students
{
    class StudentRecordServices : BaseServices, IStudentRecordServices
    {
        public OpenObjectDAL openObjectsDAL { get; set; }
        public GrademajorDAL GrademajorDAL { get; set; }
        public SchoolYearDAL schoolYearDAL { get; set; }
        public StudentsDAL StudentsDAL { get; set; }
        public StudentRecordDAL studentRecordDAL { get; set; }
        public Lazy<ISchoolYearServices> SchoolYearServices { get; set; }
        //public Lazy<AuditProcessDAL> AuditProcessDAL { get; set; }
        public StudentEditColumnDescriptionRepository studentEditColumnDescriptionRepository { get; set; }
        //public StudentProofreadControlRepository studentProofreadControlRepository { get; set; }

        public StudentRecordView GetStudentByStudentNo(Guid StudentID)
        {
            
           
            return studentRecordDAL.GetStudentByStudentNo(StudentID);
        }

        private bool IsCanEdit(Guid studentID)
        {
            var nowTime = DateTime.Now;
            var curSchoolYear = SchoolYearServices.Value.GetCurrentSchoolYear();
            var student = studentRecordDAL.StudentRepository.GetSingle(x => x.UserID == studentID, 
                (x => x.CF_Classmajor.CF_Grademajor.CF_Facultymajor));
            var schoolyearNum = curSchoolYear.Years - student.CF_Classmajor.CF_Grademajor.GradeID + 1;
            var editControl = studentRecordDAL.StudentEditObjectsRepository.GetList(x => x.Starttime <= nowTime && x.Endtime >= nowTime
                && x.SchoolyearNumID == schoolyearNum && x.EducationID == student.CF_Classmajor.CF_Grademajor.CF_Facultymajor.EducationID).ToList();

            if (editControl.Count > 0)
            {
                return true;
            }

            return false;
        }

        public void ProofreadIsOpen(Guid UserID)
        {
            //当前学年学期
            var nowSchoolYear = this.schoolYearDAL.schoolyearRepository.GetList(x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE && x.IsCurrent == true).FirstOrDefault();
            //全部学年学期
            var schoolYearList = this.schoolYearDAL.schoolyearRepository.GetList(x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE).ToList();
            //学生
            var studentclass = this.StudentsDAL.StudentRepository.GetList(x => x.UserID == UserID).Select(x => x.CF_Classmajor).FirstOrDefault();
            //学生所在班级
            CF_Grademajor grademajor = this.GrademajorDAL.GrademajorRepository.GetSingle(x => x.GrademajorID == studentclass.GrademajorID);

            CF_Facultymajor facultymajor = GrademajorDAL.GrademajorRepository.GetList(x => x.GrademajorID == studentclass.GrademajorID).Select(x => x.CF_Facultymajor).FirstOrDefault();
            //学生入学学年学期
            //schoolYearList.FirstOrDefault(x => x.Value == (grademajor.SchoolyearID + (grademajor.SchoolcodeID - 1)) * 2);

            var startSchoolyear = schoolYearList.FirstOrDefault(x => x.Years == grademajor.GradeID && x.SchoolcodeID == grademajor.SemesterID);

            //var courseSchoolyear = (startSchoolyear.Value + ((grademajor.SchoolcodeID - 1) * 2)) + (nowSchoolYear.SchoolcodeID == grademajor.SchoolcodeID ? 0 : 1);

            var now = (nowSchoolYear.Value - (nowSchoolYear.SchoolcodeID == grademajor.SemesterID ? 0 : 1) - startSchoolyear.Value) / 2 + 1;

            //开放学年查询
            var open = this.openObjectsDAL.StudentEditObjectsRepository.GetList(x => x.SchoolyearNumID == now && x.EducationID == facultymajor.EducationID).FirstOrDefault();

            if (open == null)
            {
                throw new Exception("没有开放该功能。");
            }
            else
            {
                if (open.EducationID != grademajor.CF_Facultymajor.EducationID)
                {
                    throw new Exception("您没有操作权限。");
                }
                if (open.Starttime > System.DateTime.Now)
                {
                    throw new Exception("当前时间不在开放时间范围内。");
                }
                if (open.Endtime.Value.AddDays(1) < System.DateTime.Now)
                {
                    throw new Exception("当前时间不在开放时间范围内。");
                }
            }
        }

        public void ProofreadStudent(Guid userID)
        {
            try
            {
                CF_Student student = StudentsDAL.StudentRepository.GetSingle(x => x.UserID == userID);
                student.IsProofread = true;
                SetModifyStatus(student);
                student.ModifyTime = DateTime.Now;
                student.ModifyUserID = userID;
                UnitOfWork.Commit();
            }
            catch (Exception)
            {
                throw;
            }

        }


        //public List<StudentChangeFeildView> GetStudentChangeFeilds(Guid StudentID)
        //{
        //    ////学生信息
        //    //var Student = StudentsDAL.GetStudentQueryable(x => x.UserID == StudentID, (x => true), (x => true)).FirstOrDefault();
        //    //var studentType = typeof(StudentsView);

        //    List<StudentChangeFeildView> Feilds = new List<StudentChangeFeildView>();

        //    #region
        //    //var SexName = IdNameExt.GetDictionaryItem("CF_Sex")
        //    //        .Where(x => x.Value == Student.Sex)
        //    //        .Select(x => x.Name).FirstOrDefault();
        //    //var NationName = IdNameExt.GetDictionaryItem("CF_Nation")
        //    //       .Where(x => x.Value == Student.Nation)
        //    //       .Select(x => x.Name).FirstOrDefault();
        //    //var EducationName = IdNameExt.GetDictionaryItem("CF_Education")
        //    //       .Where(x => x.Value == Student.EducationID)
        //    //       .Select(x => x.Name).FirstOrDefault();
        //    //var LearningformName = IdNameExt.GetDictionaryItem("CF_Learningform")
        //    //        .Where(x => x.Value == Student.LearningformID)
        //    //        .Select(x => x.Name).FirstOrDefault();
        //    //var LearningstyleName = IdNameExt.GetDictionaryItem("CF_Learningstyle")
        //    //        .Where(x => x.Value == Student.LearningstyleID)
        //    //        .Select(x => x.Name).FirstOrDefault();
        //    //var CultureModelName = IdNameExt.GetDictionaryItem("CF_CULTUREMODEL")
        //    //        .Where(x => x.Value == Student.CultureModel)
        //    //        .Select(x => x.Name).FirstOrDefault();
        //    //var StudentTypeName = IdNameExt.GetDictionaryItem("CF_STUDENTTYPE")
        //    //       .Where(x => x.Value == Student.StudentType)
        //    //       .Select(x => x.Name).FirstOrDefault();
        //    //var StudentStatusName = IdNameExt.GetDictionaryItem("CF_StudentStatus")
        //    //        .Where(x => x.Value == Student.StudentStatus)
        //    //        .Select(x => x.Name).FirstOrDefault();
        //    //var EntranceWayName = IdNameExt.GetDictionaryItem("CF_EntranceWay")
        //    //       .Where(x => x.Value == Student.EntranceWay)
        //    //       .Select(x => x.Name).FirstOrDefault();
        //    //var ExamineeTypeName = IdNameExt.GetDictionaryItem("CF_EXAMINEETYPE")
        //    //       .Where(x => x.Value == Student.ExamineeType)
        //    //       .Select(x => x.Name).FirstOrDefault();
        //    //var HealthyName = IdNameExt.GetDictionaryItem("CF_HealthState")
        //    //       .Where(x => x.Value == Student.Healthy)
        //    //       .Select(x => x.Name).FirstOrDefault();


        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "照片", ColumnFeild = "PhotoUrl", OrderBy = 1, Value = Student.PhotoUrl, TypeName = "基本信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "学号", ColumnFeild = "LoginID", OrderBy = 2, Value = Student.LoginID, TypeName = "基本信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "姓名", ColumnFeild = "UserName", OrderBy = 3, Value = Student.UserName, TypeName = "基本信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "曾用名", ColumnFeild = "UsedName", OrderBy = 4, Value = Student.UsedName, TypeName = "基本信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "性别", ColumnFeild = "Sex", OrderBy = 5, Value = SexName, TypeName = "基本信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "出生日期", ColumnFeild = "BirthDate", OrderBy = 6, Value = Student.BirthDate.HasValue ? Student.BirthDate.Value.ToString("yyyy-MM-dd") : "", TypeName = "基本信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "民族", ColumnFeild = "Nation", OrderBy = 7, Value = NationName, TypeName = "基本信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "政治面貌", ColumnFeild = "Politics", OrderBy = 8, Value = Student.Politics, TypeName = "基本信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "身份证", ColumnFeild = "IDNumber", OrderBy = 9, Value = Student.IDNumber, TypeName = "基本信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "年级", ColumnFeild = "GradeName", OrderBy = 10, Value = Student.GradeName, TypeName = "专业班级区" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "年级专业", ColumnFeild = "GradeCode", OrderBy = 11, Value = Student.GradeCode, TypeName = "专业班级区" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "班级名称", ColumnFeild = "ClassName", OrderBy = 12, Value = Student.ClassName, TypeName = "专业班级区" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "学制", ColumnFeild = "LearnSystem", OrderBy = 13, Value = Student.LearnSystem.HasValue ? Student.LearnSystem.ToString() : "", TypeName = "专业班级区" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "班序", ColumnFeild = "No", OrderBy = 14, Value = Student.No, TypeName = "专业班级区" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = EMIS.Utility.RSL.Get("EducationID"), ColumnFeild = "EducationID", OrderBy = 15, Value = EducationName, TypeName = "专业班级区" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "学习形式", ColumnFeild = "LearningformID", OrderBy = 16, Value = LearningformName, TypeName = "专业班级区" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "学习方式", ColumnFeild = "LearningstyleID", OrderBy = 17, Value = LearningstyleName, TypeName = "专业班级区" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "培养方式/办学类型", ColumnFeild = "CultureModel", OrderBy = 18, Value = CultureModelName, TypeName = "补充信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "学生类别", ColumnFeild = "StudentType", OrderBy = 19, Value = StudentTypeName, TypeName = "补充信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "学籍状态", ColumnFeild = "StudentStatus", OrderBy = 20, Value = StudentStatusName, TypeName = "补充信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "入学日期", ColumnFeild = "EntranceDate", OrderBy = 21, Value = Student.EntranceDate.HasValue ? Student.EntranceDate.Value.ToString("yyyy-MM-dd") : "", TypeName = "高考招生信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "入学方式", ColumnFeild = "EntranceWay", OrderBy = 22, Value = EntranceWayName, TypeName = "高考招生信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "教育部考生号", ColumnFeild = "ExamineeNum", OrderBy = 23, Value = Student.ExamineeNum, TypeName = "高考招生信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "考生类别", ColumnFeild = "ExamineeType", OrderBy = 24, Value = ExamineeTypeName, TypeName = "高考招生信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "考生特征", ColumnFeild = "Features", OrderBy = 25, Value = Student.Features.HasValue ? Student.Features.ToString() : "", TypeName = "高考招生信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "高考总分", ColumnFeild = "Score", OrderBy = 26, Value = Student.Score.HasValue ? Student.Score.ToString() : "", TypeName = "高考招生信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "生源所属地", ColumnFeild = "Territorial", OrderBy = 27, Value = Student.Territorial.HasValue ? Student.Territorial.ToString() : "", TypeName = "高考招生信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "来源地区", ColumnFeild = "Area", OrderBy = 28, Value = Student.Area, TypeName = "高考招生信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "籍贯", ColumnFeild = "Place", OrderBy = 29, Value = Student.Place, TypeName = "高考招生信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "出生地", ColumnFeild = "BornPlace", OrderBy = 30, Value = Student.BornPlace, TypeName = "高考招生信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "健康状况", ColumnFeild = "Healthy", OrderBy = 31, Value = HealthyName, TypeName = "个人附加信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "特长", ColumnFeild = "Specialty", OrderBy = 32, Value = Student.Specialty, TypeName = "个人附加信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "身高(CM)", ColumnFeild = "Height", OrderBy = 33, Value = Student.Height, TypeName = "个人附加信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "体重(KG)", ColumnFeild = "Weight", OrderBy = 34, Value = Student.Weight, TypeName = "个人附加信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "Email", ColumnFeild = "Email", OrderBy = 35, Value = Student.Email, TypeName = "联系信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "QQ", ColumnFeild = "QQ", OrderBy = 36, Value = Student.QQ, TypeName = "联系信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "宿舍", ColumnFeild = "Dormitory", OrderBy = 37, Value = Student.Dormitory, TypeName = "联系信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "固定电话", ColumnFeild = "Telephone", OrderBy = 38, Value = Student.Telephone, TypeName = "联系信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "移动电话", ColumnFeild = "Mobile", OrderBy = 39, Value = Student.Mobile, TypeName = "联系信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "地址", ColumnFeild = "HomeAddress", OrderBy = 40, Value = Student.HomeAddress, TypeName = "联系信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "工作单位", ColumnFeild = "WorkUnit", OrderBy = 1, Value = Student.WorkUnit, TypeName = "联系信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "邮编", ColumnFeild = "Zipcode", OrderBy = 1, Value = Student.Zipcode, TypeName = "联系信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "收件人", ColumnFeild = "Recipient", OrderBy = 1, Value = Student.Recipient, TypeName = "联系信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "拟毕业日期", ColumnFeild = "PlanningGraduateDate", OrderBy = 1, Value = Student.PlanningGraduateDate.HasValue ? Student.PlanningGraduateDate.Value.ToString("yyyy-MM-dd") : "", TypeName = "其他信息" });
        //    //Feilds.Add(new StudentChangeFeildView() { ColumnNmae = "备注", ColumnFeild = "Remarks", OrderBy = 1, Value = Student.Remarks, TypeName = "其他信息" });
        //    #endregion

        //    //var canEdit = this.IsCanEdit(StudentID);

        //    //字段修改设定
        //    var Controls = studentRecordDAL.ControlRepository.Entities.ToList().Select(q =>
        //        new StudentChangeFeildView
        //        {
        //            ColumnFeild = q.ColumnName,
        //            ColumnNmae = q.DisplayColumnName,
        //            IsChange = (q.CheckingTypeID != (int)CF_CheckingType.Close),
        //            OrderBy = q.OrderNo ?? 1
        //        }).ToList();
        //    //Feilds = Feilds.Where(q => Controls.Contains(q.ColumnFeild)).ToList();
        //    return Controls;
        //}

        /// <summary>
        /// 修改学生信息
        /// </summary>
        /// <param name="Data"></param>
        /// <param name="UserID"></param>
        //public void ChangeStudentInfo(Dictionary<string, object> Data, Guid UserID)
        //{
        //    //当前学年学期
        //    var nowSchoolYear = this.schoolYearDAL.schoolyearRepository.GetList(x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE && x.IsCurrent == true).FirstOrDefault();
        //    //全部学年学期
        //    var schoolYearList = this.schoolYearDAL.schoolyearRepository.GetList(x => x.RecordStatus > (int)SYS_STATUS.UNUSABLE).ToList();
        //    //学生
        //    var student = this.StudentsDAL.StudentRepository.GetList(x => x.UserID == UserID, x => x.CF_Classmajor).FirstOrDefault();
        //    //学生所在班级
        //    CF_Grademajor grademajor = this.GrademajorDAL.GrademajorRepository.GetSingle(x => x.GrademajorID == student.CF_Classmajor.GrademajorID, x => x.CF_Facultymajor);
        //    //学生入学学年学期
        //    //schoolYearList.FirstOrDefault(x => x.Value == (grademajor.SchoolyearID + (grademajor.SchoolcodeID - 1)) * 2);
        //    var startSchoolyear = schoolYearList.FirstOrDefault(x => x.Years == grademajor.SchoolyearID && x.SchoolcodeID == grademajor.SchoolcodeID);
        //    var courseSchoolyear = (startSchoolyear.Value + ((grademajor.SchoolcodeID - 1) * 2)) + (nowSchoolYear.SchoolcodeID == grademajor.SchoolcodeID ? 0 : 1);
        //    var now = (nowSchoolYear.Value - (nowSchoolYear.SchoolcodeID == grademajor.SchoolcodeID ? 0 : 1) - startSchoolyear.Value) / 2 + 1;
        //    //开放学年查询
        //    var open = this.openObjectsDAL.StudentEditObjectsRepository.GetList(x => x.SchoolyearNumID == now && x.EducationID == grademajor.CF_Facultymajor.EducationID).FirstOrDefault();

        //    if (open == null)
        //    {
        //        throw new Exception("您没有操作权限。");
        //    }
        //    else
        //    {
        //        if (open.EducationID != grademajor.CF_Facultymajor.EducationID)
        //        {
        //            throw new Exception("您没有操作权限。");
        //        }
        //        if (open.Starttime > System.DateTime.Now)
        //        {
        //            throw new Exception("当前时间不在开放时间范围内。");
        //        }
        //        if (open.Endtime.Value.AddDays(1) < System.DateTime.Now)
        //        {
        //            throw new Exception("当前时间不在开放时间范围内。");
        //        }
        //    }

        //    int c = 0;
        //    //字段修改设定
        //    var Controls = studentRecordDAL.ControlRepository.Entities.Where(q => q.CheckingTypeID != (int)CF_CheckingType.Close).ToList();

        //    ////需要记录的字段
        //    //var RecordFeilds = Controls.Where(q => q.CheckingTypeID == (int)CF_CheckingType.OpenRecord || q.CheckingTypeID == (int)CF_CheckingType.OpenApprove).Select(q => q.ColumnName);

        //    //先修改不需要记录的，再修改需要记录不需要审核的，再修改需要记录需要审核的
        //    //直接修改数据的字段
        //    var NeedFeilds = Controls.Where(q => q.CheckingTypeID == (int)CF_CheckingType.AllOpen).Select(q => q.ColumnName);

        //    c = UpdateStudent(Data.Where(q => NeedFeilds.Contains(q.Key)).ToDictionary(q => q.Key, q => q.Value), UserID);


        //    //需要记录日志后修改数据的字段
        //    var NeedLogFeilds = Controls.Where(q => q.CheckingTypeID == (int)CF_CheckingType.OpenRecord).Select(q => q.ColumnName);

        //    //var istrue = Data.Where(q => NeedLogFeilds.Contains(q.Key));

        //    c += UpdateAndRecordStudent(Data.Where(q => NeedLogFeilds.Contains(q.Key)).ToDictionary(q => q.Key, q => q.Value), UserID);


        //    //检查重复提交，学生提交修改字段时，已提交修改的字段在审批前，不能再提交：邓智荣
        //    var NeedAuditFeilds = Controls.Where(q => q.CheckingTypeID == (int)CF_CheckingType.OpenApprove).Select(q => q.ColumnName);

        //    CheckStudentFields(Data.Where(q => NeedAuditFeilds.Contains(q.Key)).ToDictionary(q => q.Key, q => q.Value), UserID, Controls.Where(q => q.CheckingTypeID == (int)CF_CheckingType.OpenApprove).Select(q => q.ColumnName).ToList());

        //    c += InsertRecord(Data.Where(q => NeedAuditFeilds.Contains(q.Key)).ToDictionary(q => q.Key, q => q.Value), UserID, Controls.Where(q => q.CheckingTypeID == (int)CF_CheckingType.OpenApprove).Select(q => q.ColumnName).ToList());




        //    if (c == 0)
        //    {
        //        throw new Exception("没有修改任何字段！");
        //    }
        //}

        public int UpdateStudent(Dictionary<string, object> Data, Guid UserID)
        {
            var Student = studentRecordDAL.StudentRepository.GetSingle(q => q.UserID == UserID, x => x.CF_StudentAccount, x => x.CF_StudentProfile, x => x.CF_StudentContact, x => x.CF_Recruitstudents, x => x.Sys_User);
            
            List<string> modifiedColumns = new List<string>();
            var studentProperties = typeof(CF_Student).GetProperties();
            var studentAccountProperties = typeof(CF_StudentAccount).GetProperties();
            var studentProfileProperties = typeof(CF_StudentProfile).GetProperties();
            var studentContactProperties = typeof(CF_StudentContact).GetProperties();
            var recruitStudentsProperties = typeof(CF_Recruitstudents).GetProperties();
            var studentUserProperties = typeof(Sys_User).GetProperties();

            //Dictionary<string, string> tableAndcol = new Dictionary<string, string>();
            //Guid StudentContrastID = ;
            #region
            foreach (var key in Data.Keys)
            {
                var studentProperty = studentProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentProperty != null)
                {
                    var oldValue = studentProperty.GetValue(Student, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        
                    }
                    studentProperty.SetValue(Student, Data[key], null);
                }

                var studentAccountProperty = studentAccountProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentAccountProperty != null)
                {
                    var oldValue = studentAccountProperty.GetValue(Student.CF_StudentAccount, null);
                     if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                     {
                         modifiedColumns.Add(key);
                         
                     }
                     studentAccountProperty.SetValue(Student.CF_StudentAccount, Data[key], null);
                }

                var studentProfileProperty = studentProfileProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentProfileProperty != null)
                {
                    var oldValue = studentProfileProperty.GetValue(Student.CF_StudentProfile, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        
                    }
                    studentProfileProperty.SetValue(Student.CF_StudentProfile, Data[key], null);
                }

                var studentContactProperty = studentContactProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentContactProperty != null)
                {
                    var oldValue = studentContactProperty.GetValue(Student.CF_StudentContact, null);
                     if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                     {
                         modifiedColumns.Add(key);
                         
                     }
                     studentContactProperty.SetValue(Student.CF_StudentContact, Data[key], null);
                }

                var recruitStudentsProperty = recruitStudentsProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (recruitStudentsProperty != null)
                {
                    var oldValue = recruitStudentsProperty.GetValue(Student.CF_Recruitstudents, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                    }
                    recruitStudentsProperty.SetValue(Student.CF_Recruitstudents, Data[key], null);
                }

                
                if (key.Equals("UserName"))
                {
                    var nameKey = "Name";
                    var studentUserProperty = studentUserProperties.FirstOrDefault(x => x.Name.ToLower() == nameKey.ToLower());
                    if (studentUserProperty != null)
                    {
                        var oldValue = studentUserProperty.GetValue(Student.Sys_User, null);
                        if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                        {
                            modifiedColumns.Add(key);
                        }
                        studentUserProperty.SetValue(Student.Sys_User, Data[key], null);
                    }
                }
                //var studentUserProperty = studentUserProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                //if (studentUserProperty != null)
                //{
                //    var oldValue = studentUserProperty.GetValue(Student.Sys_User, null);
                //    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                //    {
                //        modifiedColumns.Add(key);

                //    }
                //    studentUserProperty.SetValue(Student.Sys_User, Data[key], null);
                //}
                //string tableNameStr = tableColumnDescriptionRepository.GetList(x => x.ColumnName == key).Select(x => x.TableName).FirstOrDefault();
                //tableAndcol.Add(key, tableNameStr);
            }
            #endregion

            studentRecordDAL.StudentRepository.UnitOfWork.Update(Student);
            studentRecordDAL.StudentRepository.UnitOfWork.Commit();
            //foreach (KeyValuePair<string, string> tablecol in tableAndcol)
            //{
            //    CF_StudentRecordChangeHistory stuRecordChangeHistory = new CF_StudentRecordChangeHistory();
            //    stuRecordChangeHistory.StudentRecordChangeHistoryID = Guid.NewGuid();
            //    stuRecordChangeHistory.TableName = tablecol.Value;
            //    stuRecordChangeHistory.ColumnName = tablecol.Key;
            //    //stuRecordChangeHistory.StudentContrastID = StudentContrastID;
            //    stuRecordChangeHistory.ApproveTime = DateTime.Now;
            //    SetNewStatus(stuRecordChangeHistory);
            //    UnitOfWork.Add(stuRecordChangeHistory);
            //    UnitOfWork.Commit();
            //    //stuRecordChangeHistoryList.Add(stuRecordChangeHistory);
            //}
            return modifiedColumns.Count;
        }

        public int UpdateAndRecordStudent(Dictionary<string, object> Data, Guid UserID)
        {
            var Student = studentRecordDAL.StudentRepository.GetSingle(q => q.UserID == UserID, x => x.CF_StudentAccount, x => x.CF_StudentProfile, x => x.CF_StudentContact, x => x.CF_Recruitstudents, x => x.Sys_User);
            var StudentContrast = new CF_StudentContrast();
            List<string> modifiedColumns = new List<string>();

            #region
            StudentContrast.StudentContrastID = Guid.NewGuid();
            StudentContrast.UserID = Student.UserID;
            StudentContrast.ClassmajorID = Student.ClassmajorID;
            StudentContrast.PhotoUrl = Student.PhotoUrl;
            StudentContrast.SexID = Student.SexID.Value;
            StudentContrast.CertificatesType = Student.CertificatesType;
            StudentContrast.IDNumber = Student.IDNumber;
            StudentContrast.StudentCardNo = Student.StudentCardNo;
            StudentContrast.PlanningGraduateDate = Student.PlanningGraduateDate;
            StudentContrast.CF_StudentProfileContrast.CultureModelID = Student.CF_StudentProfile.CultureModelID;
            StudentContrast.StudentType = Student.StudentType;
            StudentContrast.StudentStatus = Student.StudentStatus;
            StudentContrast.InSchoolStatusID = Student.InSchoolStatusID;
            StudentContrast.Career = Student.Career;
            //this.SetNewStatus(StudentContrast);
            StudentContrast.CreateTime = DateTime.Now;
            StudentContrast.CreateUserID = UserID;
            StudentContrast.IP = HttpContext.Current.Request.UserHostAddress;

            StudentContrast.CF_StudentSource = new CF_StudentSource();
            StudentContrast.CF_StudentSource.ClassmajorID = Student.ClassmajorID;
            StudentContrast.CF_StudentSource.PhotoUrl = Student.PhotoUrl;
            StudentContrast.CF_StudentSource.SexID = Student.SexID.Value;
            StudentContrast.CF_StudentSource.CertificatesType = Student.CertificatesType;
            StudentContrast.CF_StudentSource.IDNumber = Student.IDNumber;
            StudentContrast.CF_StudentSource.StudentCardNo = Student.StudentCardNo;
            StudentContrast.CF_StudentSource.PlanningGraduateDate = Student.PlanningGraduateDate;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.CultureModelID = Student.CF_StudentProfile.CultureModelID;
            StudentContrast.CF_StudentSource.StudentType = Student.StudentType;
            StudentContrast.CF_StudentSource.StudentStatus = Student.StudentStatus;
            StudentContrast.CF_StudentSource.InSchoolStatusID = Student.InSchoolStatusID;
            StudentContrast.CF_StudentSource.Career = Student.Career;

            StudentContrast.CF_StudentAccountContrast = new CF_StudentAccountContrast();
            StudentContrast.CF_StudentAccountContrast.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentAccountContrast.BankName = Student.CF_StudentAccount.BankName;
            StudentContrast.CF_StudentAccountContrast.CardNo = Student.CF_StudentAccount.CardNo;
            //this.SetNewStatus(StudentContrast.CF_StudentAccountContrast);
            StudentContrast.CF_StudentAccountContrast.CreateTime = DateTime.Now;
            StudentContrast.CF_StudentAccountContrast.CreateUserID = UserID;

            StudentContrast.CF_StudentSource.CF_StudentAccountSource = new CF_StudentAccountSource();
            StudentContrast.CF_StudentSource.CF_StudentAccountSource.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentSource.CF_StudentAccountSource.BankName = Student.CF_StudentAccount.BankName;
            StudentContrast.CF_StudentSource.CF_StudentAccountSource.CardNo = Student.CF_StudentAccount.CardNo;

            StudentContrast.CF_RecruitstudentsContrast = new CF_RecruitstudentsContrast();
            StudentContrast.CF_RecruitstudentsContrast.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_RecruitstudentsContrast.EnteringSchoolYearID = Student.CF_Recruitstudents.EnteringSchoolYearID;
            StudentContrast.CF_RecruitstudentsContrast.EntranceDate = Student.CF_Recruitstudents.EntranceDate;
            StudentContrast.CF_RecruitstudentsContrast.EntranceWayID = Student.CF_Recruitstudents.EntranceWayID;
            StudentContrast.CF_RecruitstudentsContrast.ExamineeNum = Student.CF_Recruitstudents.ExamineeNum;
            //StudentContrast.CF_RecruitstudentsContrast.PlaceBirth = Student.CF_Recruitstudents.PlaceBirth;
            StudentContrast.CF_RecruitstudentsContrast.ExamineeType = Student.CF_Recruitstudents.ExamineeType;
            StudentContrast.CF_RecruitstudentsContrast.FeaturesID = Student.CF_Recruitstudents.FeaturesID;
            StudentContrast.CF_RecruitstudentsContrast.Score = Student.CF_Recruitstudents.Score;
            StudentContrast.CF_RecruitstudentsContrast.TerritorialID = Student.CF_Recruitstudents.TerritorialID;
            StudentContrast.CF_RecruitstudentsContrast.Area = Student.CF_Recruitstudents.Area;
            //this.SetNewStatus(StudentContrast.CF_RecruitstudentsContrast);
            StudentContrast.CF_RecruitstudentsContrast.CreateTime = DateTime.Now;
            StudentContrast.CF_RecruitstudentsContrast.CreateUserID = UserID;

            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource = new CF_RecruitstudentsSource();
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.EnteringSchoolYearID = Student.CF_Recruitstudents.EnteringSchoolYearID;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.EntranceDate = Student.CF_Recruitstudents.EntranceDate;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.EntranceWayID = Student.CF_Recruitstudents.EntranceWayID;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.ExamineeNum = Student.CF_Recruitstudents.ExamineeNum;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.BornPlace = Student.CF_StudentProfile.BornPlace;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.ExamineeType = Student.CF_Recruitstudents.ExamineeType;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.FeaturesID = Student.CF_Recruitstudents.FeaturesID;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.Score = Student.CF_Recruitstudents.Score;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.TerritorialID = Student.CF_Recruitstudents.TerritorialID;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.Area = Student.CF_Recruitstudents.Area;

            StudentContrast.CF_StudentContactContrast = new CF_StudentContactContrast();
            StudentContrast.CF_StudentContactContrast.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentContactContrast.Email = Student.CF_StudentContact.Email;
            StudentContrast.CF_StudentContactContrast.QQ = Student.CF_StudentContact.QQ;
            StudentContrast.CF_StudentContactContrast.Mobile = Student.CF_StudentContact.Mobile;
            StudentContrast.CF_StudentContactContrast.Telephone = Student.CF_StudentContact.Telephone;
            StudentContrast.CF_StudentContactContrast.WeChatNum = Student.CF_StudentContact.WeChatNum;
            StudentContrast.CF_StudentContactContrast.ZIPCode = Student.CF_StudentContact.ZIPCode;
            StudentContrast.CF_StudentContactContrast.Address = Student.CF_StudentContact.Address;
            StudentContrast.CF_StudentContactContrast.WorkUnit = Student.CF_StudentContact.WorkUnit;
            StudentContrast.CF_StudentContactContrast.HomeAddress = Student.CF_StudentContact.HomeAddress;
            StudentContrast.CF_StudentContactContrast.Recipient = Student.CF_StudentContact.Recipient;
            StudentContrast.CF_StudentContactContrast.Dormitory = Student.CF_StudentContact.Dormitory;
            //this.SetNewStatus(StudentContrast.CF_StudentContactContrast);
            StudentContrast.CF_StudentContactContrast.CreateTime = DateTime.Now;
            StudentContrast.CF_StudentContactContrast.CreateUserID = UserID;

            StudentContrast.CF_StudentSource.CF_StudentContactSource = new CF_StudentContactSource();
            StudentContrast.CF_StudentSource.CF_StudentContactSource.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Email = Student.CF_StudentContact.Email;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.QQ = Student.CF_StudentContact.QQ;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Mobile = Student.CF_StudentContact.Mobile;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Telephone = Student.CF_StudentContact.Telephone;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.WeChatNum = Student.CF_StudentContact.WeChatNum;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.ZIPCode = Student.CF_StudentContact.ZIPCode;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Address = Student.CF_StudentContact.Address;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.WorkUnit = Student.CF_StudentContact.WorkUnit;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.HomeAddress = Student.CF_StudentContact.HomeAddress;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Recipient = Student.CF_StudentContact.Recipient;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Dormitory = Student.CF_StudentContact.Dormitory;

            StudentContrast.CF_StudentProfileContrast = new CF_StudentProfileContrast();
            StudentContrast.CF_StudentProfileContrast.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentProfileContrast.UsedName = Student.CF_StudentProfile.UsedName;
            StudentContrast.CF_StudentProfileContrast.DirectorName = Student.CF_StudentProfile.DirectorName;
            StudentContrast.BirthDate = Student.BirthDate;
            StudentContrast.CF_StudentProfileContrast.Country = Student.CF_StudentProfile.Country;
            StudentContrast.PoliticsID = Student.PoliticsID;
            StudentContrast.NationID = Student.NationID;
            StudentContrast.CF_StudentProfileContrast.Place = Student.CF_StudentProfile.Place;
            StudentContrast.CF_StudentProfileContrast.HealthStateID = Student.CF_StudentProfile.HealthStateID;
            StudentContrast.CF_StudentProfileContrast.BloodGroup = Student.CF_StudentProfile.BloodGroup;
            StudentContrast.CF_StudentProfileContrast.BornPlace = Student.CF_StudentProfile.BornPlace;
            StudentContrast.CF_StudentProfileContrast.Specialty = Student.CF_StudentProfile.Specialty;
            StudentContrast.CF_StudentProfileContrast.Height = Student.CF_StudentProfile.Height;
            StudentContrast.CF_StudentProfileContrast.Weight = Student.CF_StudentProfile.Weight;
            StudentContrast.CF_StudentProfileContrast.LiteracyLevelID = Student.CF_StudentProfile.LiteracyLevelID;
            StudentContrast.Remark = Student.Remark;
            //this.SetNewStatus(StudentContrast.CF_StudentProfileContrast);
            StudentContrast.CF_StudentProfileContrast.CreateTime = DateTime.Now;
            StudentContrast.CF_StudentProfileContrast.CreateUserID = UserID;

            StudentContrast.CF_StudentSource.CF_StudentProfileSource = new CF_StudentProfileSource();
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.UsedName = Student.CF_StudentProfile.UsedName;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.DirectorName = Student.CF_StudentProfile.DirectorName;
            StudentContrast.BirthDate = Student.BirthDate;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.Country = Student.CF_StudentProfile.Country;
            StudentContrast.CF_StudentSource.PoliticsID = Student.PoliticsID;
            StudentContrast.CF_StudentSource.NationID = Student.NationID;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.Place = Student.CF_StudentProfile.Place;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.HealthStateID = Student.CF_StudentProfile.HealthStateID;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.BloodGroup = Student.CF_StudentProfile.BloodGroup;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.BornPlace = Student.CF_StudentProfile.BornPlace;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.Specialty = Student.CF_StudentProfile.Specialty;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.Height = Student.CF_StudentProfile.Height;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.Weight = Student.CF_StudentProfile.Weight;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.LiteracyLevelID = Student.CF_StudentProfile.LiteracyLevelID;
            StudentContrast.CF_StudentSource.Remark = Student.Remark;

            StudentContrast.Sys_UserContrast = new Sys_UserContrast();
            StudentContrast.Sys_UserContrast.Name = Student.Sys_User.Name;
            StudentContrast.Sys_UserContrast.LoginID = Student.Sys_User.LoginID;

            StudentContrast.CF_StudentSource.Sys_UserSource = new Sys_UserSource();
            StudentContrast.CF_StudentSource.Sys_UserSource.Name = Student.Sys_User.Name;
            StudentContrast.CF_StudentSource.Sys_UserSource.LoginID = Student.Sys_User.LoginID;

            #endregion

            var studentProperties = typeof(CF_Student).GetProperties();
            var studentAccountProperties = typeof(CF_StudentAccount).GetProperties();
            var studentProfileProperties = typeof(CF_StudentProfile).GetProperties();
            var studentContactProperties = typeof(CF_StudentContact).GetProperties();
            var recruitStudentsProperties = typeof(CF_Recruitstudents).GetProperties();
            var userProperties = typeof(Sys_User).GetProperties();

            var studentContrastProperties = typeof(CF_StudentContrast).GetProperties();
            var studentAccountContrastProperties = typeof(CF_StudentAccountContrast).GetProperties();
            var studentProfileContrastProperties = typeof(CF_StudentProfileContrast).GetProperties();
            var studentContactContrastProperties = typeof(CF_StudentContactContrast).GetProperties();
            var recruitStudentsContrastProperties = typeof(CF_RecruitstudentsContrast).GetProperties();
            var studentUserProperties = typeof(Sys_UserContrast).GetProperties();
            //var studentContrastProperty = studentContrastProperties.Where();
            Guid StudentContrastID = StudentContrast.StudentContrastID;

            Dictionary<string, string> tableAndcol = new Dictionary<string, string>();

            #region
            foreach (var key in Data.Keys)
            {
                string tableNameStr = studentEditColumnDescriptionRepository.GetList(x => x.ColumnName == key).Select(x => x.TableName).FirstOrDefault();
                var studentContrastProperty = studentContrastProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentContrastProperty != null)
                {
                    var studentProperty = studentProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                    var oldValue = studentProperty.GetValue(Student, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        studentContrastProperty.SetValue(StudentContrast, Data[key], null);
                        studentProperty.SetValue(Student, Data[key], null);
                        //记录修改的字段还有对应的表名
                        tableAndcol.Add(key, tableNameStr);
                    }
                }
                var studentAccountContrastProperty = studentAccountContrastProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentAccountContrastProperty != null)
                {
                    var studentAccountProperty = studentAccountProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                    var oldValue = studentAccountProperty.GetValue(Student.CF_StudentAccount, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        studentAccountContrastProperty.SetValue(StudentContrast.CF_StudentAccountContrast, Data[key], null);
                        studentAccountProperty.SetValue(Student.CF_StudentAccount, Data[key], null);
                        //记录修改的字段还有对应的表名
                        tableAndcol.Add(key, tableNameStr);
                    }
                }
                var studentProfileContrastProperty = studentProfileContrastProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentProfileContrastProperty != null)
                {
                    var studentProfileProperty = studentProfileProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                    var oldValue = studentProfileProperty.GetValue(Student.CF_StudentProfile, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        studentProfileContrastProperty.SetValue(StudentContrast.CF_StudentProfileContrast, Data[key], null);
                        studentProfileProperty.SetValue(Student.CF_StudentProfile, Data[key], null);
                        //记录修改的字段还有对应的表名
                        tableAndcol.Add(key, tableNameStr);
                    }
                }
                var studentContactContrastProperty = studentContactContrastProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentContactContrastProperty != null)
                {
                    var studentContactProperty = studentContactProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                    var oldValue = studentContactProperty.GetValue(Student.CF_StudentContact, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        studentContactContrastProperty.SetValue(StudentContrast.CF_StudentContactContrast, Data[key], null);
                        studentContactProperty.SetValue(Student.CF_StudentContact, Data[key], null);
                        //记录修改的字段还有对应的表名
                        tableAndcol.Add(key, tableNameStr);
                    }
                }
                var recruitStudentsContrastProperty = recruitStudentsContrastProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (recruitStudentsContrastProperty != null)
                {
                    var recruitStudentsProperty = recruitStudentsProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                    var oldValue = recruitStudentsProperty.GetValue(Student.CF_Recruitstudents, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        recruitStudentsContrastProperty.SetValue(StudentContrast.CF_RecruitstudentsContrast, Data[key], null);
                        recruitStudentsProperty.SetValue(Student.CF_Recruitstudents, Data[key], null);
                        //记录修改的字段还有对应的表名
                        tableAndcol.Add(key, tableNameStr);
                    }
                }

                if (key.Equals("UserName"))
                {
                    var nameKey = "Name";
                    var userStudentsContrastProperty = studentUserProperties.FirstOrDefault(x => x.Name.ToLower() == nameKey.ToLower());
                    if (userStudentsContrastProperty != null)
                    {
                        var studentUserProperty = userProperties.FirstOrDefault(x => x.Name.ToLower() == nameKey.ToLower());
                        var oldValue = studentUserProperty.GetValue(Student.Sys_User, null);
                        if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                        {
                            modifiedColumns.Add(key);
                        }
                        userStudentsContrastProperty.SetValue(StudentContrast.Sys_UserContrast, Data[key], null);
                        studentUserProperty.SetValue(Student.Sys_User, Data[key], null);
                        //记录修改的字段还有对应的表名
                        tableAndcol.Add(nameKey, "Sys_UserContrast");
                    }
                }
            }
            #endregion


            StudentContrast.RecordStatus = (int)CF_CheckingType.OpenRecord;
            if (modifiedColumns.Count != 0)
            {
                studentRecordDAL.StudentContrastRepository.UnitOfWork.Add(StudentContrast);
                studentRecordDAL.StudentContrastRepository.UnitOfWork.Commit();
                studentRecordDAL.StudentRepository.UnitOfWork.Update(Student);
                studentRecordDAL.StudentRepository.UnitOfWork.Commit();
            }
            foreach (KeyValuePair<string, string> tablecol in tableAndcol)
            {
                CF_StudentRecordChangeHistory stuRecordChangeHistory = new CF_StudentRecordChangeHistory();
                stuRecordChangeHistory.StudentRecordChangeHistoryID = Guid.NewGuid();
                stuRecordChangeHistory.TableName = tablecol.Value;
                stuRecordChangeHistory.ColumnName = tablecol.Key;
                stuRecordChangeHistory.StudentContrastID = StudentContrastID;
                //stuRecordChangeHistory.ApproveTime = null;//记录不需要审核
                //SetNewStatus(stuRecordChangeHistory);
                stuRecordChangeHistory.CreateTime = DateTime.Now;
                stuRecordChangeHistory.CreateUserID = UserID;
                UnitOfWork.Add(stuRecordChangeHistory);
                UnitOfWork.Commit();
                //stuRecordChangeHistoryList.Add(stuRecordChangeHistory);
            }
            return modifiedColumns.Count;
        }

        ///// <summary>
        ///// 学生提交修改字段时，已提交修改的字段在审批前，不能再提交
        ///// </summary>
        ///// <param name="Data"></param>
        ///// <param name="UserID"></param>
        ///// <param name="needApproveColumns"></param>
        //public void CheckStudentFields(Dictionary<string, object> Data, Guid UserID, List<string> needApproveColumns)
        //{
        //    var Student = studentRecordDAL.StudentRepository.GetSingle(q => q.UserID == UserID, x => x.CF_StudentAccount, x => x.CF_StudentProfile, x => x.CF_StudentContact, x => x.CF_Recruitstudents);
        //    var studentProperties = typeof(CF_Student).GetProperties();
        //    var studentAccountProperties = typeof(CF_StudentAccount).GetProperties();
        //    var studentProfileProperties = typeof(CF_StudentProfile).GetProperties();
        //    var studentContactProperties = typeof(CF_StudentContact).GetProperties();
        //    var recruitStudentsProperties = typeof(CF_Recruitstudents).GetProperties();
        //    var result = AuditProcessDAL.Value.GetAuditProcessQuery(w => w.UserID == UserID && w.RecordStatus == (int)CF_CheckingType.OpenRecord).Where(x => x.RecordStatus == (int)CF_CheckingType.OpenRecord).ToList();

        //    #region
        //    if (result.Count > 0)
        //    {
        //        throw new Exception("您有待审核的修改请求，如需继续修改请在反馈页面撤回！");
        //    }
        //    //照片
        //    if (Data.Where(x => x.Key == "PhotoUrl") != null && needApproveColumns.IndexOf("PhotoUrl") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "PhotoUrl").FirstOrDefault().Value) != Convert.ToString(Student.PhotoUrl))
        //        {
        //            if (result.Where(x => x.PhotoUrl != Student.PhotoUrl).Count() > 0)
        //                throw new Exception("照片已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }
        //    //学号
        //    if (Data.Where(x => x.Key == "StudentCardNo") != null && needApproveColumns.IndexOf("StudentCardNo") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "StudentCardNo").FirstOrDefault().Value) != Convert.ToString(Student.StudentCardNo))
        //        {
        //            if (result.Where(x => x.StudentCardNo != Student.StudentCardNo).Count() > 0)
        //                throw new Exception("学号已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }
        //    //姓名
        //    if (Data.Where(x => x.Key == "UserName") != null && needApproveColumns.IndexOf("UserName") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "UserName").FirstOrDefault().Value) != Convert.ToString(Student.Sys_User.Name))
        //        {
        //            if (result.Where(x => x.UserName != Student.Sys_User.Name).Count() > 0)
        //                throw new Exception("姓名已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }


        //    //曾用名
        //    if (Data.Where(x => x.Key == "UsedName") != null && needApproveColumns.IndexOf("UsedName") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "UsedName").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentProfile.UsedName))
        //        {
        //            if (result.Where(x => x.UsedName != Student.CF_StudentProfile.UsedName && !(string.IsNullOrEmpty(x.UsedName) && string.IsNullOrEmpty(Student.CF_StudentProfile.UsedName))).Count() > 0)
        //                throw new Exception("曾用名已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //性别
        //    if (Data.Where(x => x.Key == "Sex") != null && needApproveColumns.IndexOf("Sex") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Sex").FirstOrDefault().Value) != Convert.ToString(Student.SexID))
        //        {
        //            if (result.Where(x => x.Sex != Student.SexID).Count() > 0)
        //                throw new Exception("性别已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //民族
        //    if (Data.Where(x => x.Key == "Nation") != null && needApproveColumns.IndexOf("Nation") != -1)
        //    {
        //        Student.NationID = null;
        //        if (Convert.ToString(Data.Where(x => x.Key == "Nation").FirstOrDefault().Value) != Convert.ToString(Student.NationID))
        //        {
        //            if (result.Where(x => x.Nation != Student.NationID).Count() > 0)
        //                throw new Exception("民族已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //出生日期
        //    if (Data.Where(x => x.Key == "BirthDate") != null && needApproveColumns.IndexOf("BirthDate") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "BirthDate").FirstOrDefault().Value) != Convert.ToString(Student.BirthDate))
        //        {
        //            if (result.Where(x => x.BirthDate != Student.BirthDate).Count() > 0)
        //                throw new Exception("出生日期已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //政治面貌
        //    if (Data.Where(x => x.Key == "Politics") != null && needApproveColumns.IndexOf("Politics") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Politics").FirstOrDefault().Value) != Convert.ToString(Student.PoliticsID))
        //        {
        //            if (result.Where(x => x.Politics != Student.PoliticsID).Count() > 0)
        //                throw new Exception("政治面貌已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //证件类型
        //    if (Data.Where(x => x.Key == "CertificatesType") != null && needApproveColumns.IndexOf("CertificatesType") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "CertificatesType").FirstOrDefault().Value) != Convert.ToString(Student.CertificatesType))
        //        {
        //            if (result.Where(x => x.CertificatesType != Student.CertificatesType).Count() > 0)
        //                throw new Exception("证件类型已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //证件号码
        //    if (Data.Where(x => x.Key == "IDNumber") != null && needApproveColumns.IndexOf("IDNumber") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "IDNumber").FirstOrDefault().Value) != Convert.ToString(Student.IDNumber))
        //        {
        //            if (result.Where(x => x.IDNumber != Student.IDNumber && !(string.IsNullOrEmpty(x.IDNumber) && string.IsNullOrEmpty(Student.IDNumber))).Count() > 0)
        //                throw new Exception("证件号码已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //班级
        //    if (Data.Where(x => x.Key == "ClassMajorID") != null && needApproveColumns.IndexOf("ClassMajorID") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "ClassMajorID").FirstOrDefault().Value) != Convert.ToString(Student.CF_Classmajor.ClassmajorID))
        //        {
        //            if (result.Where(x => x.ClassMajorID != Student.CF_Classmajor.ClassmajorID).Count() > 0)
        //                throw new Exception("班级已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //培养方式
        //    if (Data.Where(x => x.Key == "CultureModel") != null && needApproveColumns.IndexOf("CultureModel") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "CultureModel").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentProfile.CultureModelID))
        //        {
        //            if (result.Where(x => x.CultureModel != Student.CF_StudentProfile.CultureModelID).Count() > 0)
        //                throw new Exception("培养方式已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //学生类别
        //    if (Data.Where(x => x.Key == "StudentType") != null && needApproveColumns.IndexOf("StudentType") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "StudentType").FirstOrDefault().Value) != Convert.ToString(Student.StudentType))
        //        {
        //            if (result.Where(x => x.StudentType != Student.StudentType).Count() > 0)
        //                throw new Exception("学生类别已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //学籍状态
        //    if (Data.Where(x => x.Key == "StudentStatus") != null && needApproveColumns.IndexOf("StudentStatus") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "StudentStatus").FirstOrDefault().Value) != Convert.ToString(Student.StudentStatus))
        //        {
        //            if (result.Where(x => x.StudentStatus != Student.StudentStatus).Count() > 0)
        //                throw new Exception("学籍状态已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //在校状态
        //    if (Data.Where(x => x.Key == "InSchoolStatusID") != null && needApproveColumns.IndexOf("InSchoolStatusID") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "InSchoolStatusID").FirstOrDefault().Value) != Convert.ToString(Student.InSchoolStatusID))
        //        {
        //            if (result.Where(x => x.InSchoolStatusID != Student.InSchoolStatusID).Count() > 0)
        //                throw new Exception("在校状态已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //入学日期
        //    if (Data.Where(x => x.Key == "EntranceDate") != null && needApproveColumns.IndexOf("EntranceDate") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "EntranceDate").FirstOrDefault().Value) != Convert.ToString(Student.CF_Recruitstudents.EntranceDate))
        //        {
        //            if (result.Where(x => x.EntranceDate != Student.CF_Recruitstudents.EntranceDate).Count() > 0)
        //                throw new Exception("入学日期已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }
        //    //入学方式
        //    if (Data.Where(x => x.Key == "EntranceWay") != null && needApproveColumns.IndexOf("EntranceWay") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "EntranceWay").FirstOrDefault().Value) != Convert.ToString(Student.CF_Recruitstudents.EntranceWayID))
        //        {
        //            if (result.Where(x => x.EntranceWay != Student.CF_Recruitstudents.EntranceWayID).Count() > 0)
        //                throw new Exception("入学方式已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }
        //    //考生号
        //    if (Data.Where(x => x.Key == "ExamineeNum") != null && needApproveColumns.IndexOf("ExamineeNum") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "ExamineeNum").FirstOrDefault().Value) != Convert.ToString(Student.CF_Recruitstudents.ExamineeNum))
        //        {
        //            if (result.Where(x => x.ExamineeNum != Student.CF_Recruitstudents.ExamineeNum && !(string.IsNullOrEmpty(x.ExamineeNum) && string.IsNullOrEmpty(Student.CF_Recruitstudents.ExamineeNum))).Count() > 0)
        //                throw new Exception("考生号已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //考生类别
        //    if (Data.Where(x => x.Key == "ExamineeType") != null && needApproveColumns.IndexOf("ExamineeType") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "ExamineeType").FirstOrDefault().Value) != Convert.ToString(Student.CF_Recruitstudents.ExamineeType))
        //        {
        //            if (result.Where(x => x.ExamineeType != Student.CF_Recruitstudents.ExamineeType).Count() > 0)
        //                throw new Exception("考生类别已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //考生特征
        //    if (Data.Where(x => x.Key == "Features") != null && needApproveColumns.IndexOf("Features") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Features").FirstOrDefault().Value) != Convert.ToString(Student.CF_Recruitstudents.FeaturesID))
        //        {
        //            if (result.Where(x => x.Features != Student.CF_Recruitstudents.FeaturesID).Count() > 0)
        //                throw new Exception("考生特征已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //高考总分
        //    if (Data.Where(x => x.Key == "Score") != null && needApproveColumns.IndexOf("Score") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Score").FirstOrDefault().Value) != Convert.ToString(Student.CF_Recruitstudents.Score))
        //        {
        //            if (result.Where(x => x.Score != Student.CF_Recruitstudents.Score).Count() > 0)
        //                throw new Exception("高考总分已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //生源所属地
        //    if (Data.Where(x => x.Key == "Territorial") != null && needApproveColumns.IndexOf("Territorial") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Territorial").FirstOrDefault().Value) != Convert.ToString(Student.CF_Recruitstudents.TerritorialID))
        //        {
        //            if (result.Where(x => x.Territorial != Student.CF_Recruitstudents.TerritorialID).Count() > 0)
        //                throw new Exception("生源所属地已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //籍贯
        //    if (Data.Where(x => x.Key == "Place") != null && needApproveColumns.IndexOf("Place") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Place").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentProfile.Place))
        //        {
        //            if (result.Where(x => x.Place != Student.CF_StudentProfile.Place && !(string.IsNullOrEmpty(x.Place) && string.IsNullOrEmpty(Student.CF_StudentProfile.Place))).Count() > 0)
        //                throw new Exception("籍贯已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //来源地区
        //    if (Data.Where(x => x.Key == "Area") != null && needApproveColumns.IndexOf("Area") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Area").FirstOrDefault().Value) != Convert.ToString(Student.CF_Recruitstudents.Area))
        //        {
        //            if (result.Where(x => x.Area != Student.CF_Recruitstudents.Area && !(string.IsNullOrEmpty(x.Area) && string.IsNullOrEmpty(Student.CF_Recruitstudents.Area))).Count() > 0)
        //                throw new Exception("来源地区已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //健康状况
        //    if (Data.Where(x => x.Key == "Healthy") != null && needApproveColumns.IndexOf("Healthy") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Healthy").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentProfile.HealthyID))
        //        {
        //            if (result.Where(x => x.Healthy != Student.CF_StudentProfile.HealthyID).Count() > 0)
        //                throw new Exception("健康状况已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //特长
        //    if (Data.Where(x => x.Key == "Specialty") != null && needApproveColumns.IndexOf("Specialty") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Specialty").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentProfile.Specialty))
        //        {
        //            if (result.Where(x => x.Specialty != Student.CF_StudentProfile.Specialty && !(string.IsNullOrEmpty(x.Specialty) && string.IsNullOrEmpty(Student.CF_StudentProfile.Specialty))).Count() > 0)
        //                throw new Exception("特长已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //身高
        //    if (Data.Where(x => x.Key == "Height") != null && needApproveColumns.IndexOf("Height") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Height").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentProfile.Height))
        //        {
        //            if (result.Where(x => x.Height != Student.CF_StudentProfile.Height && !(string.IsNullOrEmpty(x.Height) && string.IsNullOrEmpty(Student.CF_StudentProfile.Height))).Count() > 0)
        //                throw new Exception("身高已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //体重
        //    if (Data.Where(x => x.Key == "Weight") != null && needApproveColumns.IndexOf("Weight") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Weight").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentProfile.Weight))
        //        {
        //            if (result.Where(x => x.Weight != Student.CF_StudentProfile.Weight && !(string.IsNullOrEmpty(x.Weight) && string.IsNullOrEmpty(Student.CF_StudentProfile.Weight))).Count() > 0)
        //                throw new Exception("体重已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //邮件
        //    if (Data.Where(x => x.Key == "Email") != null && needApproveColumns.IndexOf("Email") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Email").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentContact.Email))
        //        {
        //            if (result.Where(x => x.Email != Student.CF_StudentContact.Email && !(string.IsNullOrEmpty(x.Email) && string.IsNullOrEmpty(Student.CF_StudentContact.Email))).Count() > 0)
        //                throw new Exception("邮件已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //QQ
        //    if (Data.Where(x => x.Key == "QQ") != null && needApproveColumns.IndexOf("QQ") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "QQ").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentContact.QQ))
        //        {
        //            if (result.Where(x => x.QQ != Student.CF_StudentContact.QQ && !(string.IsNullOrEmpty(x.QQ) && string.IsNullOrEmpty(Student.CF_StudentContact.QQ))).Count() > 0)
        //                throw new Exception("QQ已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //宿舍编号
        //    if (Data.Where(x => x.Key == "Dormitory") != null && needApproveColumns.IndexOf("Dormitory") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Dormitory").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentContact.Dormitory))
        //        {
        //            if (result.Where(x => x.Dormitory != Student.CF_StudentContact.Dormitory && !(string.IsNullOrEmpty(x.Dormitory) && string.IsNullOrEmpty(Student.CF_StudentContact.Dormitory))).Count() > 0)
        //                throw new Exception("宿舍编号已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //固定电话
        //    if (Data.Where(x => x.Key == "Telephone") != null && needApproveColumns.IndexOf("Telephone") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Telephone").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentContact.Telephone))
        //        {
        //            if (result.Where(x => x.Telephone != Student.CF_StudentContact.Telephone && !(string.IsNullOrEmpty(x.Telephone) && string.IsNullOrEmpty(Student.CF_StudentContact.Telephone))).Count() > 0)
        //                throw new Exception("固定电话已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //移动电话
        //    if (Data.Where(x => x.Key == "Mobile") != null && needApproveColumns.IndexOf("Mobile") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Mobile").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentContact.Mobile))
        //        {
        //            if (result.Where(x => x.Mobile != Student.CF_StudentContact.Mobile && !(string.IsNullOrEmpty(x.Mobile) && string.IsNullOrEmpty(Student.CF_StudentContact.Mobile))).Count() > 0)
        //                throw new Exception("移动电话已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //通信地址
        //    if (Data.Where(x => x.Key == "Address") != null && needApproveColumns.IndexOf("Address") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Address").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentContact.Address))
        //        {
        //            if (result.Where(x => x.Address != Student.CF_StudentContact.Address && !(string.IsNullOrEmpty(x.Address) && string.IsNullOrEmpty(Student.CF_StudentContact.Address))).Count() > 0)
        //                throw new Exception("通信地址已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //工作单位
        //    if (Data.Where(x => x.Key == "WorkUnit") != null && needApproveColumns.IndexOf("WorkUnit") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "WorkUnit").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentContact.WorkUnit))
        //        {
        //            if (result.Where(x => x.WorkUnit != Student.CF_StudentContact.WorkUnit && !(string.IsNullOrEmpty(x.WorkUnit) && string.IsNullOrEmpty(Student.CF_StudentContact.WorkUnit))).Count() > 0)
        //                throw new Exception("工作单位已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //邮编
        //    if (Data.Where(x => x.Key == "ZipCode") != null && needApproveColumns.IndexOf("ZipCode") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "ZipCode").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentContact.ZipCode))
        //        {
        //            if (result.Where(x => x.ZipCode != Student.CF_StudentContact.ZipCode && !(string.IsNullOrEmpty(x.ZipCode) && string.IsNullOrEmpty(Student.CF_StudentContact.ZipCode))).Count() > 0)
        //                throw new Exception("邮编已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //收件人
        //    if (Data.Where(x => x.Key == "Recipient") != null && needApproveColumns.IndexOf("Recipient") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Recipient").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentContact.Recipient))
        //        {
        //            if (result.Where(x => x.Recipient != Student.CF_StudentContact.Recipient && !(string.IsNullOrEmpty(x.Recipient) && string.IsNullOrEmpty(Student.CF_StudentContact.Recipient))).Count() > 0)
        //                throw new Exception("收件人已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //开户银行
        //    if (Data.Where(x => x.Key == "BankName") != null && needApproveColumns.IndexOf("BankName") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "BankName").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentAccount.BankName))
        //        {
        //            if (result.Where(x => x.BankName != Student.CF_StudentAccount.BankName && !(string.IsNullOrEmpty(x.BankName) && string.IsNullOrEmpty(Student.CF_StudentAccount.BankName))).Count() > 0)
        //                throw new Exception("开户银行已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //银行卡号
        //    if (Data.Where(x => x.Key == "CardNo") != null && needApproveColumns.IndexOf("CardNo") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "CardNo").FirstOrDefault().Value) != Convert.ToString(Student.CF_StudentAccount.CardNo))
        //        {
        //            if (result.Where(x => x.CardNo != Student.CF_StudentAccount.CardNo && !(string.IsNullOrEmpty(x.CardNo) && string.IsNullOrEmpty(Student.CF_StudentAccount.CardNo))).Count() > 0)
        //                throw new Exception("银行卡号已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }

        //    //备注
        //    if (Data.Where(x => x.Key == "Remarks") != null && needApproveColumns.IndexOf("Remarks") != -1)
        //    {
        //        if (Convert.ToString(Data.Where(x => x.Key == "Remarks").FirstOrDefault().Value) != Convert.ToString(Student.Remark))
        //        {
        //            if (result.Where(x => x.Remarks != Student.Remark).Count() > 0)
        //                throw new Exception("备注已提交修改，等待老师审批确认，不能重复提交修改");
        //        }
        //    }


        //    #endregion



        //    //studentRecordDAL.StudentRepository.UnitOfWork.Update(Student);
        //    //studentRecordDAL.StudentRepository.UnitOfWork.Commit();
        //}


        public int InsertRecord(Dictionary<string, object> Data, Guid UserID, List<string> needApproveColumns)
        {
            var Student = studentRecordDAL.StudentRepository.GetSingle(q => q.UserID == UserID, x => x.CF_StudentAccount, x => x.CF_StudentProfile, x => x.CF_StudentContact, x => x.CF_Recruitstudents, x => x.Sys_User);
            var StudentContrast = new CF_StudentContrast();
            List<string> modifiedColumns = new List<string>();

            #region
            StudentContrast.StudentContrastID = Guid.NewGuid();
            StudentContrast.UserID = Student.UserID;
            StudentContrast.ClassmajorID = Student.ClassmajorID;
            StudentContrast.PhotoUrl = Student.PhotoUrl;
            StudentContrast.SexID = Student.SexID.Value;
            StudentContrast.CertificatesType = Student.CertificatesType;
            StudentContrast.IDNumber = Student.IDNumber;
            StudentContrast.StudentCardNo = Student.StudentCardNo;
            StudentContrast.PlanningGraduateDate = Student.PlanningGraduateDate;
            StudentContrast.CF_StudentProfileContrast.CultureModelID = Student.CF_StudentProfile.CultureModelID;
            StudentContrast.StudentType = Student.StudentType;
            StudentContrast.StudentStatus = Student.StudentStatus;
            StudentContrast.InSchoolStatusID = Student.InSchoolStatusID;
            StudentContrast.Career = Student.Career;
            //this.SetNewStatus(StudentContrast);
            StudentContrast.CreateTime = DateTime.Now;
            StudentContrast.CreateUserID = UserID;

            StudentContrast.IP = HttpContext.Current.Request.UserHostAddress;

            StudentContrast.CF_StudentSource = new CF_StudentSource();
            StudentContrast.CF_StudentSource.ClassmajorID = Student.ClassmajorID;
            StudentContrast.CF_StudentSource.PhotoUrl = Student.PhotoUrl;
            StudentContrast.CF_StudentSource.SexID = Student.SexID.Value;
            StudentContrast.CF_StudentSource.CertificatesType = Student.CertificatesType;
            StudentContrast.CF_StudentSource.IDNumber = Student.IDNumber;
            StudentContrast.CF_StudentSource.StudentCardNo = Student.StudentCardNo;
            StudentContrast.CF_StudentSource.PlanningGraduateDate = Student.PlanningGraduateDate;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.CultureModelID = Student.CF_StudentProfile.CultureModelID;
            StudentContrast.CF_StudentSource.StudentType = Student.StudentType;
            StudentContrast.CF_StudentSource.StudentStatus = Student.StudentStatus;
            StudentContrast.CF_StudentSource.InSchoolStatusID = Student.InSchoolStatusID;
            StudentContrast.CF_StudentSource.Career = Student.Career;

            StudentContrast.CF_StudentAccountContrast = new CF_StudentAccountContrast();
            StudentContrast.CF_StudentAccountContrast.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentAccountContrast.BankName = Student.CF_StudentAccount.BankName;
            StudentContrast.CF_StudentAccountContrast.CardNo = Student.CF_StudentAccount.CardNo;
            //this.SetNewStatus(StudentContrast.CF_StudentAccountContrast);
            StudentContrast.CF_StudentAccountContrast.CreateTime = DateTime.Now;
            StudentContrast.CF_StudentAccountContrast.CreateUserID = UserID;

            StudentContrast.CF_StudentSource.CF_StudentAccountSource = new CF_StudentAccountSource();
            StudentContrast.CF_StudentSource.CF_StudentAccountSource.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentSource.CF_StudentAccountSource.BankName = Student.CF_StudentAccount.BankName;
            StudentContrast.CF_StudentSource.CF_StudentAccountSource.CardNo = Student.CF_StudentAccount.CardNo;

            StudentContrast.CF_RecruitstudentsContrast = new CF_RecruitstudentsContrast();
            StudentContrast.CF_RecruitstudentsContrast.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_RecruitstudentsContrast.EnteringSchoolYearID = Student.CF_Recruitstudents.EnteringSchoolYearID;
            StudentContrast.CF_RecruitstudentsContrast.EntranceDate = Student.CF_Recruitstudents.EntranceDate;
            StudentContrast.CF_RecruitstudentsContrast.EntranceWayID = Student.CF_Recruitstudents.EntranceWayID;
            StudentContrast.CF_RecruitstudentsContrast.ExamineeNum = Student.CF_Recruitstudents.ExamineeNum;
            //StudentContrast.CF_RecruitstudentsContrast.PlaceBirth = Student.CF_Recruitstudents.PlaceBirth;
            StudentContrast.CF_RecruitstudentsContrast.ExamineeType = Student.CF_Recruitstudents.ExamineeType;
            StudentContrast.CF_RecruitstudentsContrast.FeaturesID = Student.CF_Recruitstudents.FeaturesID;
            StudentContrast.CF_RecruitstudentsContrast.Score = Student.CF_Recruitstudents.Score;
            StudentContrast.CF_RecruitstudentsContrast.TerritorialID = Student.CF_Recruitstudents.TerritorialID;
            StudentContrast.CF_RecruitstudentsContrast.Area = Student.CF_Recruitstudents.Area;
            //this.SetNewStatus(StudentContrast.CF_RecruitstudentsContrast);
            StudentContrast.CF_RecruitstudentsContrast.CreateTime = DateTime.Now;
            StudentContrast.CF_RecruitstudentsContrast.CreateUserID = UserID;

            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource = new CF_RecruitstudentsSource();
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.EnteringSchoolYearID = Student.CF_Recruitstudents.EnteringSchoolYearID;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.EntranceDate = Student.CF_Recruitstudents.EntranceDate;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.EntranceWayID = Student.CF_Recruitstudents.EntranceWayID;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.ExamineeNum = Student.CF_Recruitstudents.ExamineeNum;
            //StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.PlaceBirth = Student.CF_Recruitstudents.PlaceBirth;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.ExamineeType = Student.CF_Recruitstudents.ExamineeType;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.FeaturesID = Student.CF_Recruitstudents.FeaturesID;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.Score = Student.CF_Recruitstudents.Score;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.TerritorialID = Student.CF_Recruitstudents.TerritorialID;
            StudentContrast.CF_StudentSource.CF_RecruitstudentsSource.Area = Student.CF_Recruitstudents.Area;

            StudentContrast.CF_StudentContactContrast = new CF_StudentContactContrast();
            StudentContrast.CF_StudentContactContrast.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentContactContrast.Email = Student.CF_StudentContact.Email;
            StudentContrast.CF_StudentContactContrast.QQ = Student.CF_StudentContact.QQ;
            StudentContrast.CF_StudentContactContrast.Mobile = Student.CF_StudentContact.Mobile;
            StudentContrast.CF_StudentContactContrast.Telephone = Student.CF_StudentContact.Telephone;
            StudentContrast.CF_StudentContactContrast.WeChatNum = Student.CF_StudentContact.WeChatNum;
            StudentContrast.CF_StudentContactContrast.ZIPCode = Student.CF_StudentContact.ZIPCode;
            StudentContrast.CF_StudentContactContrast.Address = Student.CF_StudentContact.Address;
            StudentContrast.CF_StudentContactContrast.WorkUnit = Student.CF_StudentContact.WorkUnit;
            StudentContrast.CF_StudentContactContrast.HomeAddress = Student.CF_StudentContact.HomeAddress;
            StudentContrast.CF_StudentContactContrast.Recipient = Student.CF_StudentContact.Recipient;
            StudentContrast.CF_StudentContactContrast.Dormitory = Student.CF_StudentContact.Dormitory;
            //this.SetNewStatus(StudentContrast.CF_StudentContactContrast);
            StudentContrast.CF_StudentContactContrast.CreateTime = DateTime.Now;
            StudentContrast.CF_StudentContactContrast.CreateUserID = UserID;

            StudentContrast.CF_StudentSource.CF_StudentContactSource = new CF_StudentContactSource();
            StudentContrast.CF_StudentSource.CF_StudentContactSource.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Email = Student.CF_StudentContact.Email;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.QQ = Student.CF_StudentContact.QQ;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Mobile = Student.CF_StudentContact.Mobile;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Telephone = Student.CF_StudentContact.Telephone;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.WeChatNum = Student.CF_StudentContact.WeChatNum;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.ZIPCode = Student.CF_StudentContact.ZIPCode;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Address = Student.CF_StudentContact.Address;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.WorkUnit = Student.CF_StudentContact.WorkUnit;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.HomeAddress = Student.CF_StudentContact.HomeAddress;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Recipient = Student.CF_StudentContact.Recipient;
            StudentContrast.CF_StudentSource.CF_StudentContactSource.Dormitory = Student.CF_StudentContact.Dormitory;

            StudentContrast.CF_StudentProfileContrast = new CF_StudentProfileContrast();
            StudentContrast.CF_StudentProfileContrast.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentProfileContrast.UsedName = Student.CF_StudentProfile.UsedName;
            StudentContrast.CF_StudentProfileContrast.DirectorName = Student.CF_StudentProfile.DirectorName;
            StudentContrast.BirthDate = Student.BirthDate;
            StudentContrast.CF_StudentProfileContrast.Country = Student.CF_StudentProfile.Country;
            StudentContrast.PoliticsID = Student.PoliticsID;
            StudentContrast.NationID = Student.NationID;
            StudentContrast.CF_StudentProfileContrast.Place = Student.CF_StudentProfile.Place;
            StudentContrast.CF_StudentProfileContrast.HealthStateID = Student.CF_StudentProfile.HealthStateID;
            StudentContrast.CF_StudentProfileContrast.BloodGroup = Student.CF_StudentProfile.BloodGroup;
            StudentContrast.CF_StudentProfileContrast.BornPlace = Student.CF_StudentProfile.BornPlace;
            StudentContrast.CF_StudentProfileContrast.Specialty = Student.CF_StudentProfile.Specialty;
            StudentContrast.CF_StudentProfileContrast.Height = Student.CF_StudentProfile.Height;
            StudentContrast.CF_StudentProfileContrast.Weight = Student.CF_StudentProfile.Weight;
            StudentContrast.Remark = Student.Remark;
            //this.SetNewStatus(StudentContrast.CF_StudentProfileContrast);
            StudentContrast.CF_StudentProfileContrast.CreateTime = DateTime.Now;
            StudentContrast.CF_StudentProfileContrast.CreateUserID = UserID;

            StudentContrast.CF_StudentSource.CF_StudentProfileSource = new CF_StudentProfileSource();
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.UsedName = Student.CF_StudentProfile.UsedName;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.DirectorName = Student.CF_StudentProfile.DirectorName;
            StudentContrast.CF_StudentSource.BirthDate = Student.BirthDate;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.Country = Student.CF_StudentProfile.Country;
            StudentContrast.CF_StudentSource.PoliticsID = Student.PoliticsID;
            StudentContrast.CF_StudentSource.NationID = Student.NationID;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.Place = Student.CF_StudentProfile.Place;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.HealthStateID = Student.CF_StudentProfile.HealthStateID;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.BloodGroup = Student.CF_StudentProfile.BloodGroup;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.BornPlace = Student.CF_StudentProfile.BornPlace;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.Specialty = Student.CF_StudentProfile.Specialty;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.Height = Student.CF_StudentProfile.Height;
            StudentContrast.CF_StudentSource.CF_StudentProfileSource.Weight = Student.CF_StudentProfile.Weight;
            StudentContrast.CF_StudentSource.Remark = Student.Remark;

            StudentContrast.Sys_UserContrast = new Sys_UserContrast();
            StudentContrast.Sys_UserContrast.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.Sys_UserContrast.Name = Student.Sys_User.Name;
            StudentContrast.Sys_UserContrast.LoginID = Student.Sys_User.LoginID;

            StudentContrast.CF_StudentSource.Sys_UserSource = new Sys_UserSource();
            StudentContrast.CF_StudentSource.Sys_UserSource.StudentContrastID = StudentContrast.StudentContrastID;
            StudentContrast.CF_StudentSource.Sys_UserSource.Name = Student.Sys_User.Name;
            StudentContrast.CF_StudentSource.Sys_UserSource.LoginID = Student.Sys_User.LoginID;
            #endregion

            var studentProperties = typeof(CF_Student).GetProperties();
            var studentAccountProperties = typeof(CF_StudentAccount).GetProperties();
            var studentProfileProperties = typeof(CF_StudentProfile).GetProperties();
            var studentContactProperties = typeof(CF_StudentContact).GetProperties();
            var recruitStudentsProperties = typeof(CF_Recruitstudents).GetProperties();
            var userProperties = typeof(Sys_User).GetProperties();
            var studentContrastProperties = typeof(CF_StudentContrast).GetProperties();
            var studentAccountContrastProperties = typeof(CF_StudentAccountContrast).GetProperties();
            var studentProfileContrastProperties = typeof(CF_StudentProfileContrast).GetProperties();
            var studentContactContrastProperties = typeof(CF_StudentContactContrast).GetProperties();
            var recruitStudentsContrastProperties = typeof(CF_RecruitstudentsContrast).GetProperties();
            var studentUserProperties = typeof(Sys_UserContrast).GetProperties();
            //var studentContrastProperty = studentContrastProperties.Where();
            Guid StudentContrastID = StudentContrast.StudentContrastID;
            Dictionary<string, string> tableAndcol = new Dictionary<string, string>();
            #region
            foreach (var key in Data.Keys)
            {
                string tableNameStr = studentEditColumnDescriptionRepository.GetList(x => x.ColumnName == key).Select(x => x.TableName).FirstOrDefault();
                var studentContrastProperty = studentContrastProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentContrastProperty != null)
                {
                    var studentProperty = studentProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                    var oldValue = studentProperty.GetValue(Student, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        studentContrastProperty.SetValue(StudentContrast, Data[key], null);
                        ////记录修改的字段还有对应的表名
                        //tableAndcol.Add(key, tableNameStr);
                    }
                }
                var studentAccountContrastProperty = studentAccountContrastProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentAccountContrastProperty != null)
                {
                    var studentAccountProperty = studentAccountProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                    var oldValue = studentAccountProperty.GetValue(Student.CF_StudentAccount, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        studentAccountContrastProperty.SetValue(StudentContrast.CF_StudentAccountContrast, Data[key], null);
                        ////记录修改的字段还有对应的表名
                        //tableAndcol.Add(key, tableNameStr);
                    }
                }
                var studentProfileContrastProperty = studentProfileContrastProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentProfileContrastProperty != null)
                {
                    var studentProfileProperty = studentProfileProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                    var oldValue = studentProfileProperty.GetValue(Student.CF_StudentProfile, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        studentProfileContrastProperty.SetValue(StudentContrast.CF_StudentProfileContrast, Data[key], null);
                        ////记录修改的字段还有对应的表名
                        //tableAndcol.Add(key, tableNameStr);
                    }
                }
                var studentContactContrastProperty = studentContactContrastProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (studentContactContrastProperty != null)
                {
                    var studentContactProperty = studentContactProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                    var oldValue = studentContactProperty.GetValue(Student.CF_StudentContact, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        studentContactContrastProperty.SetValue(StudentContrast.CF_StudentContactContrast, Data[key], null);
                        ////记录修改的字段还有对应的表名
                        //tableAndcol.Add(key, tableNameStr);
                    }
                }
                var recruitStudentsContrastProperty = recruitStudentsContrastProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (recruitStudentsContrastProperty != null)
                {
                    var recruitStudentsProperty = recruitStudentsProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                    var oldValue = recruitStudentsProperty.GetValue(Student.CF_Recruitstudents, null);
                    if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                    {
                        modifiedColumns.Add(key);
                        recruitStudentsContrastProperty.SetValue(StudentContrast.CF_RecruitstudentsContrast, Data[key], null);
                        ////记录修改的字段还有对应的表名
                        //tableAndcol.Add(key, tableNameStr);
                    }
                }

                //var userStudentsContrastProperty = studentUserProperties.FirstOrDefault(x => x.Name.ToLower() == key.ToLower());
                if (key.Equals("UserName"))
                {
                    var nameKey = "Name";
                    var userStudentsContrastProperty = studentUserProperties.FirstOrDefault(x => x.Name.ToLower() == nameKey.ToLower());
                    if (userStudentsContrastProperty != null)
                    {
                        var studentUserProperty = userProperties.FirstOrDefault(x => x.Name.ToLower() == nameKey.ToLower());
                        var oldValue = studentUserProperty.GetValue(Student.Sys_User, null);
                        if (!(oldValue ?? "").Equals(Data[key] ?? ""))
                        {
                            modifiedColumns.Add(key);
                        }
                        userStudentsContrastProperty.SetValue(StudentContrast.Sys_UserContrast, Data[key], null);
                        //记录修改的字段还有对应的表名
                        //tableAndcol.Add(key, "Sys_User");
                    }
                }
            }
            #endregion
            
            if (modifiedColumns.Any(x => needApproveColumns.Contains(x)))
            {
                StudentContrast.RecordStatus = (int)CF_CheckingType.OpenRecord;
            }
            else
            {
                StudentContrast.RecordStatus = (int)CF_CheckingType.OpenRecord;
            }
            if (modifiedColumns.Count != 0)
            {
            studentRecordDAL.StudentContrastRepository.UnitOfWork.Add(StudentContrast);
            
            studentRecordDAL.StudentContrastRepository.UnitOfWork.Commit();
            }
            //foreach (KeyValuePair<string, string> tablecol in tableAndcol)
            //{
            //    CF_StudentRecordChangeHistory stuRecordChangeHistory = new CF_StudentRecordChangeHistory();
            //    stuRecordChangeHistory.StudentRecordChangeHistoryID = Guid.NewGuid();
            //    stuRecordChangeHistory.TableName = tablecol.Value;
            //    stuRecordChangeHistory.ColumnName = tablecol.Key;
            //    stuRecordChangeHistory.StudentContrastID = StudentContrastID;
            //    stuRecordChangeHistory.ApproveTime = null;//修改不需要审核
            //    SetNewStatus(stuRecordChangeHistory);
            //    UnitOfWork.Add(stuRecordChangeHistory);
            //    UnitOfWork.Commit();
            //    //stuRecordChangeHistoryList.Add(stuRecordChangeHistory);
            //}
            return modifiedColumns.Count;
        }



        //public IEnumerable<AuditProcessView> GetAuditProcessView(Guid UserID)
        //{
        //    var Student = AuditProcessDAL.Value.GetAuditProcessQuery(w => w.UserID == UserID && w.RecordStatus == (int)CF_CheckingType.OpenRecord).AsEnumerable();

        //    //if (result != null)
        //    //{
        //    //    result.StudentsView = StudentsDAL.Value.GetStudentQueryable(w => w.UserID == result.UserID).FirstOrDefault();
        //    //}

        //    return Student;
        //}

        

    }
}