public async Task <ActionResult <List <GroupStudents> > > PostGroupStudents(StudentCriteria studentCriteria)
{
var requiredStudents = _context.Stmtr.Where(s => s.EnrlStatus.Equals(studentCriteria.enrollmentStatus) &&
s.BirthDate.Year >= (DateTime.Now.Year - studentCriteria.age[1]) &&
s.BirthDate.Year <= (DateTime.Now.Year - studentCriteria.age[0])
//s.Sex.Equals(studentCriteria.gender[0]) || s.BirthDate.Year <= (DateTime.Now.Year - studentCriteria.age[0]) ||
//s.Sex.Equals(studentCriteria.gender[1]) || s.FinalCourse.Equals(studentCriteria.discipline[0]) ||
//s.FinalCourse.Equals(studentCriteria.discipline[1]) || s.FinalCourse.Equals(studentCriteria.discipline[2]) ||
//s.FinalCourse.Equals(studentCriteria.discipline[3])
);
List <Stmtr> stmtrs = new List <Stmtr>();
stmtrs.AddRange(requiredStudents.ToList());
List <Stmtr> genderFilteredstmtrs = new List <Stmtr>();
List <Stmtr> dispFilteredStmtrs = new List <Stmtr>();
foreach (var gender in studentCriteria.gender)
{
genderFilteredstmtrs.AddRange(stmtrs.Where(s => s.Sex.Equals(gender)).ToList());
}
stmtrs = genderFilteredstmtrs;
foreach (var disp in studentCriteria.discipline)
{
dispFilteredStmtrs.AddRange(stmtrs.Where(s => s.FinalCourse.Equals(disp)).ToList());
}
stmtrs = dispFilteredStmtrs;
foreach (var student in stmtrs)
{
_context.GroupStudents.Add(new GroupStudents {
StId = student.RegNo, Gid = studentCriteria.gid
});
}
await _context.SaveChangesAsync();
var groupStudents = _context.GroupStudents.Where(g => g.Gid == studentCriteria.gid).Include(s => s.St).ToList();
return(groupStudents);
}
public IEnumerable<Student> FindByCriteria(StudentCriteria c)
{
return this.DbContext.Students.Include("District").Include("InfoSourceSmall").Include("GruduateSchool").Include("Clazz").Include("Master1").Include("Master2").Include("Master3").Include("Teacher1").Include("Teacher2").Include("Teacher3").Where(o =>
(!c.IdSrh.HasValue || o.Id.Equals(c.IdSrh.Value))
&& (!c.IdFromSrh.HasValue || o.Id >= c.IdFromSrh.Value)
&& (!c.IdToSrh.HasValue || o.Id <= c.IdToSrh.Value)
&& (String.IsNullOrEmpty(c.NameSrh) || o.Name.Contains(c.NameSrh))
&& (String.IsNullOrEmpty(c.PinYinSrh) || o.PinYin.Contains(c.PinYinSrh))
&& (String.IsNullOrEmpty(c.GenderSrh) || o.Gender.Contains(c.GenderSrh))
&& (!c.BirthdaySrh.HasValue || (o.Birthday.HasValue && o.Birthday.Value.Equals(c.BirthdaySrh.Value)))
&& (!c.BirthdayFromSrh.HasValue || (o.Birthday.HasValue && o.Birthday.Value >= c.BirthdayFromSrh.Value))
&& (!c.BirthdayToSrh.HasValue || (o.Birthday.HasValue && o.Birthday.Value <= c.BirthdayToSrh.Value))
&& (String.IsNullOrEmpty(c.EduLevelSrh) || o.EduLevel.Contains(c.EduLevelSrh))
&& (!c.GraduateDateSrh.HasValue || (o.GraduateDate.HasValue && o.GraduateDate.Value.Equals(c.GraduateDateSrh.Value)))
&& (!c.GraduateDateFromSrh.HasValue || (o.GraduateDate.HasValue && o.GraduateDate.Value >= c.GraduateDateFromSrh.Value))
&& (!c.GraduateDateToSrh.HasValue || (o.GraduateDate.HasValue && o.GraduateDate.Value <= c.GraduateDateToSrh.Value))
&& (!c.ScoreSrh.HasValue || (o.Score.HasValue && o.Score.Value.Equals(c.ScoreSrh.Value)))
&& (!c.ScoreFromSrh.HasValue || (o.Score.HasValue && o.Score.Value >= c.ScoreFromSrh.Value))
&& (!c.ScoreToSrh.HasValue || (o.Score.HasValue && o.Score.Value <= c.ScoreToSrh.Value))
&& (!c.GruduateSchoolIdSrh.HasValue || (o.GruduateSchoolId.HasValue && o.GruduateSchoolId.Value.Equals(c.GruduateSchoolIdSrh.Value)))
&& (!c.GruduateSchoolIdFromSrh.HasValue || (o.GruduateSchoolId.HasValue && o.GruduateSchoolId.Value >= c.GruduateSchoolIdFromSrh.Value))
&& (!c.GruduateSchoolIdToSrh.HasValue || (o.GruduateSchoolId.HasValue && o.GruduateSchoolId.Value <= c.GruduateSchoolIdToSrh.Value))
&& (String.IsNullOrEmpty(c.ProfessionSrh) || o.Profession.Contains(c.ProfessionSrh))
&& (String.IsNullOrEmpty(c.IdCardNoSrh) || o.IdCardNo.Contains(c.IdCardNoSrh))
&& (String.IsNullOrEmpty(c.HuKouTypeSrh) || o.HuKouType.Contains(c.HuKouTypeSrh))
&& (String.IsNullOrEmpty(c.AddressSrh) || o.Address.Contains(c.AddressSrh))
&& (String.IsNullOrEmpty(c.PostcodeSrh) || o.Postcode.Contains(c.PostcodeSrh))
&& (String.IsNullOrEmpty(c.FeeSourceSrh) || o.FeeSource.Contains(c.FeeSourceSrh))
&& (!c.SmallInfoSourceIdSrh.HasValue || (o.SmallInfoSourceId.HasValue && o.SmallInfoSourceId.Value.Equals(c.SmallInfoSourceIdSrh.Value)))
&& (!c.SmallInfoSourceIdFromSrh.HasValue || (o.SmallInfoSourceId.HasValue && o.SmallInfoSourceId.Value >= c.SmallInfoSourceIdFromSrh.Value))
&& (!c.SmallInfoSourceIdToSrh.HasValue || (o.SmallInfoSourceId.HasValue && o.SmallInfoSourceId.Value <= c.SmallInfoSourceIdToSrh.Value))
&& (String.IsNullOrEmpty(c.QQSrh) || o.QQ.Contains(c.QQSrh))
&& (String.IsNullOrEmpty(c.EmailSrh) || o.Email.Contains(c.EmailSrh))
&& (String.IsNullOrEmpty(c.MobileSrh) || o.Mobile.Contains(c.MobileSrh))
&& (String.IsNullOrEmpty(c.HomeTelephoneSrh) || o.HomeTelephone.Contains(c.HomeTelephoneSrh))
&& (String.IsNullOrEmpty(c.OfficeTelephoneSrh) || o.OfficeTelephone.Contains(c.OfficeTelephoneSrh))
&& (String.IsNullOrEmpty(c.MemberRelType1Srh) || o.MemberRelType1.Contains(c.MemberRelType1Srh))
&& (String.IsNullOrEmpty(c.MemberName1Srh) || o.MemberName1.Contains(c.MemberName1Srh))
&& (String.IsNullOrEmpty(c.MemberCompany1Srh) || o.MemberCompany1.Contains(c.MemberCompany1Srh))
&& (String.IsNullOrEmpty(c.MemberPosition1Srh) || o.MemberPosition1.Contains(c.MemberPosition1Srh))
&& (String.IsNullOrEmpty(c.MemberMobile1Srh) || o.MemberMobile1.Contains(c.MemberMobile1Srh))
&& (String.IsNullOrEmpty(c.MemberRelType2Srh) || o.MemberRelType2.Contains(c.MemberRelType2Srh))
&& (String.IsNullOrEmpty(c.MemberName2Srh) || o.MemberName2.Contains(c.MemberName2Srh))
&& (String.IsNullOrEmpty(c.MemberCompany2Srh) || o.MemberCompany2.Contains(c.MemberCompany2Srh))
&& (String.IsNullOrEmpty(c.MemberPosition2Srh) || o.MemberPosition2.Contains(c.MemberPosition2Srh))
&& (String.IsNullOrEmpty(c.MemberMobile2Srh) || o.MemberMobile2.Contains(c.MemberMobile2Srh))
&& (String.IsNullOrEmpty(c.MemberRelType3Srh) || o.MemberRelType3.Contains(c.MemberRelType3Srh))
&& (String.IsNullOrEmpty(c.MemberName3Srh) || o.MemberName3.Contains(c.MemberName3Srh))
&& (String.IsNullOrEmpty(c.MemberCompany3Srh) || o.MemberCompany3.Contains(c.MemberCompany3Srh))
&& (String.IsNullOrEmpty(c.MemberPosition3Srh) || o.MemberPosition3.Contains(c.MemberPosition3Srh))
&& (String.IsNullOrEmpty(c.MemberMobile3Srh) || o.MemberMobile3.Contains(c.MemberMobile3Srh))
&& (String.IsNullOrEmpty(c.MemberRelType4Srh) || o.MemberRelType4.Contains(c.MemberRelType4Srh))
&& (String.IsNullOrEmpty(c.MemberName4Srh) || o.MemberName4.Contains(c.MemberName4Srh))
&& (String.IsNullOrEmpty(c.MemberCompany4Srh) || o.MemberCompany4.Contains(c.MemberCompany4Srh))
&& (String.IsNullOrEmpty(c.MemberPosition4Srh) || o.MemberPosition4.Contains(c.MemberPosition4Srh))
&& (String.IsNullOrEmpty(c.MemberMobile4Srh) || o.MemberMobile4.Contains(c.MemberMobile4Srh))
&& (String.IsNullOrEmpty(c.WorkStateSrh) || o.WorkState.Contains(c.WorkStateSrh))
&& (String.IsNullOrEmpty(c.StudyDuration1Srh) || o.StudyDuration1.Contains(c.StudyDuration1Srh))
&& (String.IsNullOrEmpty(c.StudySchool1Srh) || o.StudySchool1.Contains(c.StudySchool1Srh))
&& (String.IsNullOrEmpty(c.StudyPosition1Srh) || o.StudyPosition1.Contains(c.StudyPosition1Srh))
&& (String.IsNullOrEmpty(c.StudyDuration2Srh) || o.StudyDuration2.Contains(c.StudyDuration2Srh))
&& (String.IsNullOrEmpty(c.StudySchool2Srh) || o.StudySchool2.Contains(c.StudySchool2Srh))
&& (String.IsNullOrEmpty(c.StudyPosition2Srh) || o.StudyPosition2.Contains(c.StudyPosition2Srh))
&& (String.IsNullOrEmpty(c.StudyDuration3Srh) || o.StudyDuration3.Contains(c.StudyDuration3Srh))
&& (String.IsNullOrEmpty(c.StudySchool3Srh) || o.StudySchool3.Contains(c.StudySchool3Srh))
&& (String.IsNullOrEmpty(c.StudyPosition3Srh) || o.StudyPosition3.Contains(c.StudyPosition3Srh))
&& (String.IsNullOrEmpty(c.SoftwareExpSrh) || o.SoftwareExp.Contains(c.SoftwareExpSrh))
&& (String.IsNullOrEmpty(c.ProgramExpSrh) || o.ProgramExp.Contains(c.ProgramExpSrh))
&& (String.IsNullOrEmpty(c.NetworkExpSrh) || o.NetworkExp.Contains(c.NetworkExpSrh))
&& (String.IsNullOrEmpty(c.RelCourseSrh) || o.RelCourse.Contains(c.RelCourseSrh))
&& (!c.DistrictIdSrh.HasValue || (o.DistrictId.HasValue && o.DistrictId.Value.Equals(c.DistrictIdSrh.Value)))
&& (!c.DistrictIdFromSrh.HasValue || (o.DistrictId.HasValue && o.DistrictId.Value >= c.DistrictIdFromSrh.Value))
&& (!c.DistrictIdToSrh.HasValue || (o.DistrictId.HasValue && o.DistrictId.Value <= c.DistrictIdToSrh.Value))
&& (String.IsNullOrEmpty(c.IntentCitySrh) || o.IntentCity.Contains(c.IntentCitySrh))
&& (!c.ClazzIdSrh.HasValue || (o.ClazzId.HasValue && o.ClazzId.Value.Equals(c.ClazzIdSrh.Value)))
&& (!c.ClazzIdFromSrh.HasValue || (o.ClazzId.HasValue && o.ClazzId.Value >= c.ClazzIdFromSrh.Value))
&& (!c.ClazzIdToSrh.HasValue || (o.ClazzId.HasValue && o.ClazzId.Value <= c.ClazzIdToSrh.Value))
&& (String.IsNullOrEmpty(c.StudentNoSrh) || o.StudentNo.Contains(c.StudentNoSrh))
&& (!c.InSchoolDateSrh.HasValue || (o.InSchoolDate.HasValue && o.InSchoolDate.Value.Equals(c.InSchoolDateSrh.Value)))
&& (!c.InSchoolDateFromSrh.HasValue || (o.InSchoolDate.HasValue && o.InSchoolDate.Value >= c.InSchoolDateFromSrh.Value))
&& (!c.InSchoolDateToSrh.HasValue || (o.InSchoolDate.HasValue && o.InSchoolDate.Value <= c.InSchoolDateToSrh.Value))
&& (String.IsNullOrEmpty(c.IsDormSrh) || o.IsDorm.Contains(c.IsDormSrh))
&& (String.IsNullOrEmpty(c.DormNoSrh) || o.DormNo.Contains(c.DormNoSrh))
&& (String.IsNullOrEmpty(c.GiveCoursewareSrh) || o.GiveCourseware.Contains(c.GiveCoursewareSrh))
&& (String.IsNullOrEmpty(c.ConsultantsSrh) || o.Consultants.Contains(c.ConsultantsSrh))
&& (String.IsNullOrEmpty(c.RemarkSrh) || o.Remark.Contains(c.RemarkSrh))
&& (!c.CreateTimeSrh.HasValue || o.CreateTime.Equals(c.CreateTimeSrh.Value))
&& (!c.LastUpdateTimeSrh.HasValue || o.LastUpdateTime.Equals(c.LastUpdateTimeSrh.Value))
&& (String.IsNullOrEmpty(c.IsGetQualificationSrh) || o.IsGetQualification.Contains(c.IsGetQualificationSrh))
&& (String.IsNullOrEmpty(c.StatusSrh) || o.Status.Contains(c.StatusSrh))
&& (String.IsNullOrEmpty(c.TechnicalWaySrh) || o.TechnicalWay.Contains(c.TechnicalWaySrh))
&& (String.IsNullOrEmpty(c.NeedObtainWorkSrh) || o.NeedObtainWork.Contains(c.NeedObtainWorkSrh))
&& (String.IsNullOrEmpty(c.IntentPositionSrh) || o.IntentPosition.Contains(c.IntentPositionSrh))
&& (!c.TargetSalarySrh.HasValue || (o.TargetSalary.HasValue && o.TargetSalary.Value.Equals(c.TargetSalarySrh.Value)))
&& (!c.TargetSalaryFromSrh.HasValue || (o.TargetSalary.HasValue && o.TargetSalary.Value >= c.TargetSalaryFromSrh.Value))
&& (!c.TargetSalaryToSrh.HasValue || (o.TargetSalary.HasValue && o.TargetSalary.Value <= c.TargetSalaryToSrh.Value))
&& (!c.InsuranceStartDateSrh.HasValue || (o.InsuranceStartDate.HasValue && o.InsuranceStartDate.Value.Equals(c.InsuranceStartDateSrh.Value)))
&& (!c.InsuranceStartDateFromSrh.HasValue || (o.InsuranceStartDate.HasValue && o.InsuranceStartDate.Value >= c.InsuranceStartDateFromSrh.Value))
&& (!c.InsuranceStartDateToSrh.HasValue || (o.InsuranceStartDate.HasValue && o.InsuranceStartDate.Value <= c.InsuranceStartDateToSrh.Value))
&& (!c.InsuranceEndDateSrh.HasValue || (o.InsuranceEndDate.HasValue && o.InsuranceEndDate.Value.Equals(c.InsuranceEndDateSrh.Value)))
&& (!c.InsuranceEndDateFromSrh.HasValue || (o.InsuranceEndDate.HasValue && o.InsuranceEndDate.Value >= c.InsuranceEndDateFromSrh.Value))
&& (!c.InsuranceEndDateToSrh.HasValue || (o.InsuranceEndDate.HasValue && o.InsuranceEndDate.Value <= c.InsuranceEndDateToSrh.Value))
&& (String.IsNullOrEmpty(c.GaoKaoBatchSrh) || o.GaoKaoBatch.Contains(c.GaoKaoBatchSrh))
&& (String.IsNullOrEmpty(c.GiveNotebookSrh) || o.GiveNotebook.Contains(c.GiveNotebookSrh))
&& (!c.MaxSalarySrh.HasValue || (o.MaxSalary.HasValue && o.MaxSalary.Value.Equals(c.MaxSalarySrh.Value)))
&& (!c.MaxSalaryFromSrh.HasValue || (o.MaxSalary.HasValue && o.MaxSalary.Value >= c.MaxSalaryFromSrh.Value))
&& (!c.MaxSalaryToSrh.HasValue || (o.MaxSalary.HasValue && o.MaxSalary.Value <= c.MaxSalaryToSrh.Value))
&& (!c.CurrentSalarySrh.HasValue || (o.CurrentSalary.HasValue && o.CurrentSalary.Value.Equals(c.CurrentSalarySrh.Value)))
&& (!c.CurrentSalaryFromSrh.HasValue || (o.CurrentSalary.HasValue && o.CurrentSalary.Value >= c.CurrentSalaryFromSrh.Value))
&& (!c.CurrentSalaryToSrh.HasValue || (o.CurrentSalary.HasValue && o.CurrentSalary.Value <= c.CurrentSalaryToSrh.Value))
&& (!c.FirstSalarySrh.HasValue || (o.FirstSalary.HasValue && o.FirstSalary.Value.Equals(c.FirstSalarySrh.Value)))
&& (!c.FirstSalaryFromSrh.HasValue || (o.FirstSalary.HasValue && o.FirstSalary.Value >= c.FirstSalaryFromSrh.Value))
&& (!c.FirstSalaryToSrh.HasValue || (o.FirstSalary.HasValue && o.FirstSalary.Value <= c.FirstSalaryToSrh.Value))
&& (!c.BeginSchoolTimeSrh.HasValue || (o.BeginSchoolTime.HasValue && o.BeginSchoolTime.Value.Equals(c.BeginSchoolTimeSrh.Value)))
&& (!c.BeginSchoolTimeFromSrh.HasValue || (o.BeginSchoolTime.HasValue && o.BeginSchoolTime.Value >= c.BeginSchoolTimeFromSrh.Value))
&& (!c.BeginSchoolTimeToSrh.HasValue || (o.BeginSchoolTime.HasValue && o.BeginSchoolTime.Value <= c.BeginSchoolTimeToSrh.Value))
&& (String.IsNullOrEmpty(c.MasterName1Srh) || o.MasterName1.Contains(c.MasterName1Srh))
&& (String.IsNullOrEmpty(c.MasterName2Srh) || o.MasterName2.Contains(c.MasterName2Srh))
&& (String.IsNullOrEmpty(c.MasterName3Srh) || o.MasterName3.Contains(c.MasterName3Srh))
&& (String.IsNullOrEmpty(c.TeacherName1Srh) || o.TeacherName1.Contains(c.TeacherName1Srh))
&& (String.IsNullOrEmpty(c.TeacherName2Srh) || o.TeacherName2.Contains(c.TeacherName2Srh))
&& (String.IsNullOrEmpty(c.TeacherName3Srh) || o.TeacherName3.Contains(c.TeacherName3Srh))
&& (!c.MasterId1Srh.HasValue || (o.MasterId1.HasValue && o.MasterId1.Value.Equals(c.MasterId1Srh.Value)))
&& (!c.MasterId1FromSrh.HasValue || (o.MasterId1.HasValue && o.MasterId1.Value >= c.MasterId1FromSrh.Value))
&& (!c.MasterId1ToSrh.HasValue || (o.MasterId1.HasValue && o.MasterId1.Value <= c.MasterId1ToSrh.Value))
&& (!c.MasterId2Srh.HasValue || (o.MasterId2.HasValue && o.MasterId2.Value.Equals(c.MasterId2Srh.Value)))
&& (!c.MasterId2FromSrh.HasValue || (o.MasterId2.HasValue && o.MasterId2.Value >= c.MasterId2FromSrh.Value))
&& (!c.MasterId2ToSrh.HasValue || (o.MasterId2.HasValue && o.MasterId2.Value <= c.MasterId2ToSrh.Value))
&& (!c.MasterId3Srh.HasValue || (o.MasterId3.HasValue && o.MasterId3.Value.Equals(c.MasterId3Srh.Value)))
&& (!c.MasterId3FromSrh.HasValue || (o.MasterId3.HasValue && o.MasterId3.Value >= c.MasterId3FromSrh.Value))
&& (!c.MasterId3ToSrh.HasValue || (o.MasterId3.HasValue && o.MasterId3.Value <= c.MasterId3ToSrh.Value))
&& (!c.TeacherId1Srh.HasValue || (o.TeacherId1.HasValue && o.TeacherId1.Value.Equals(c.TeacherId1Srh.Value)))
&& (!c.TeacherId1FromSrh.HasValue || (o.TeacherId1.HasValue && o.TeacherId1.Value >= c.TeacherId1FromSrh.Value))
&& (!c.TeacherId1ToSrh.HasValue || (o.TeacherId1.HasValue && o.TeacherId1.Value <= c.TeacherId1ToSrh.Value))
&& (!c.TeacherId2Srh.HasValue || (o.TeacherId2.HasValue && o.TeacherId2.Value.Equals(c.TeacherId2Srh.Value)))
&& (!c.TeacherId2FromSrh.HasValue || (o.TeacherId2.HasValue && o.TeacherId2.Value >= c.TeacherId2FromSrh.Value))
&& (!c.TeacherId2ToSrh.HasValue || (o.TeacherId2.HasValue && o.TeacherId2.Value <= c.TeacherId2ToSrh.Value))
&& (!c.TeacherId3Srh.HasValue || (o.TeacherId3.HasValue && o.TeacherId3.Value.Equals(c.TeacherId3Srh.Value)))
&& (!c.TeacherId3FromSrh.HasValue || (o.TeacherId3.HasValue && o.TeacherId3.Value >= c.TeacherId3FromSrh.Value))
&& (!c.TeacherId3ToSrh.HasValue || (o.TeacherId3.HasValue && o.TeacherId3.Value <= c.TeacherId3ToSrh.Value))
&& (String.IsNullOrEmpty(c.QualificationSchoolSrh) || o.QualificationSchool.Contains(c.QualificationSchoolSrh))
&& (String.IsNullOrEmpty(c.InsuranceStatusSrh) || o.InsuranceStatus.Contains(c.InsuranceStatusSrh))
&& (String.IsNullOrEmpty(c.OldOaIdSrh) || o.OldOaId.Contains(c.OldOaIdSrh))
&& (String.IsNullOrEmpty(c.OldOaInfoSourceSubTypeNameSrh) || o.OldOaInfoSourceSubTypeName.Contains(c.OldOaInfoSourceSubTypeNameSrh))
&& (String.IsNullOrEmpty(c.OldOaClassSrh) || o.OldOaClass.Contains(c.OldOaClassSrh))
&& (String.IsNullOrEmpty(c.HasRelTeacherSrh) || o.HasRelTeacher.Contains(c.HasRelTeacherSrh))
&& (String.IsNullOrEmpty(c.RelTeacherSrh) || o.RelTeacher.Contains(c.RelTeacherSrh))
&& (String.IsNullOrEmpty(c.HomeIntroSrh) || o.HomeIntro.Contains(c.HomeIntroSrh))
&& (String.IsNullOrEmpty(c.Give1Srh) || o.Give1.Contains(c.Give1Srh))
&& (String.IsNullOrEmpty(c.Give2Srh) || o.Give2.Contains(c.Give2Srh))
&& (String.IsNullOrEmpty(c.Give3Srh) || o.Give3.Contains(c.Give3Srh))
&& (String.IsNullOrEmpty(c.Receive1Srh) || o.Receive1.Contains(c.Receive1Srh))
&& (String.IsNullOrEmpty(c.Receive2Srh) || o.Receive2.Contains(c.Receive2Srh))
&& (String.IsNullOrEmpty(c.Receive3Srh) || o.Receive3.Contains(c.Receive3Srh))
&& (String.IsNullOrEmpty(c.Receive4Srh) || o.Receive4.Contains(c.Receive4Srh))
&& (String.IsNullOrEmpty(c.Receive5Srh) || o.Receive5.Contains(c.Receive5Srh))
&& (String.IsNullOrEmpty(c.Receive6Srh) || o.Receive6.Contains(c.Receive6Srh))
&& (String.IsNullOrEmpty(c.Pic1Srh) || o.Pic1.Contains(c.Pic1Srh))
&& (String.IsNullOrEmpty(c.Pic2Srh) || o.Pic2.Contains(c.Pic2Srh))
&& (String.IsNullOrEmpty(c.Pic3Srh) || o.Pic3.Contains(c.Pic3Srh))
&& (String.IsNullOrEmpty(c.Pic4Srh) || o.Pic4.Contains(c.Pic4Srh))
&& (String.IsNullOrEmpty(c.Pic5Srh) || o.Pic5.Contains(c.Pic5Srh))
&& (String.IsNullOrEmpty(c.Pic6Srh) || o.Pic6.Contains(c.Pic6Srh))
);
}
public PagedModel<Student> FindByCriteria(StudentCriteria c)
{
PagedModel<Student> m = new PagedModel<Student>();
var r = this.Repository.FindByCriteria(c);
if(!String.IsNullOrEmpty(c.sortname)){
if(c.sortname.ToLower().Equals("id")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Id);
}else{
r = r.OrderByDescending(o=>o.Id);
}
}
if(c.sortname.ToLower().Equals("name")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Name);
}else{
r = r.OrderByDescending(o=>o.Name);
}
}
if(c.sortname.ToLower().Equals("pinyin")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.PinYin);
}else{
r = r.OrderByDescending(o=>o.PinYin);
}
}
if(c.sortname.ToLower().Equals("gender")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Gender);
}else{
r = r.OrderByDescending(o=>o.Gender);
}
}
if(c.sortname.ToLower().Equals("birthday")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Birthday);
}else{
r = r.OrderByDescending(o=>o.Birthday);
}
}
if(c.sortname.ToLower().Equals("edulevel")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.EduLevel);
}else{
r = r.OrderByDescending(o=>o.EduLevel);
}
}
if(c.sortname.ToLower().Equals("graduatedate")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.GraduateDate);
}else{
r = r.OrderByDescending(o=>o.GraduateDate);
}
}
if(c.sortname.ToLower().Equals("score")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Score);
}else{
r = r.OrderByDescending(o=>o.Score);
}
}
if(c.sortname.ToLower().Equals("gruduateschoolid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.GruduateSchoolId);
}else{
r = r.OrderByDescending(o=>o.GruduateSchoolId);
}
}
if(c.sortname.ToLower().Equals("profession")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Profession);
}else{
r = r.OrderByDescending(o=>o.Profession);
}
}
if(c.sortname.ToLower().Equals("idcardno")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.IdCardNo);
}else{
r = r.OrderByDescending(o=>o.IdCardNo);
}
}
if(c.sortname.ToLower().Equals("hukoutype")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.HuKouType);
}else{
r = r.OrderByDescending(o=>o.HuKouType);
}
}
if(c.sortname.ToLower().Equals("address")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Address);
}else{
r = r.OrderByDescending(o=>o.Address);
}
}
if(c.sortname.ToLower().Equals("postcode")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Postcode);
}else{
r = r.OrderByDescending(o=>o.Postcode);
}
}
if(c.sortname.ToLower().Equals("feesource")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.FeeSource);
}else{
r = r.OrderByDescending(o=>o.FeeSource);
}
}
if(c.sortname.ToLower().Equals("smallinfosourceid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.SmallInfoSourceId);
}else{
r = r.OrderByDescending(o=>o.SmallInfoSourceId);
}
}
if(c.sortname.ToLower().Equals("qq")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.QQ);
}else{
r = r.OrderByDescending(o=>o.QQ);
}
}
if(c.sortname.ToLower().Equals("email")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Email);
}else{
r = r.OrderByDescending(o=>o.Email);
}
}
if(c.sortname.ToLower().Equals("mobile")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Mobile);
}else{
r = r.OrderByDescending(o=>o.Mobile);
}
}
if(c.sortname.ToLower().Equals("hometelephone")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.HomeTelephone);
}else{
r = r.OrderByDescending(o=>o.HomeTelephone);
}
}
if(c.sortname.ToLower().Equals("officetelephone")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.OfficeTelephone);
}else{
r = r.OrderByDescending(o=>o.OfficeTelephone);
}
}
if(c.sortname.ToLower().Equals("memberreltype1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberRelType1);
}else{
r = r.OrderByDescending(o=>o.MemberRelType1);
}
}
if(c.sortname.ToLower().Equals("membername1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberName1);
}else{
r = r.OrderByDescending(o=>o.MemberName1);
}
}
if(c.sortname.ToLower().Equals("membercompany1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberCompany1);
}else{
r = r.OrderByDescending(o=>o.MemberCompany1);
}
}
if(c.sortname.ToLower().Equals("memberposition1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberPosition1);
}else{
r = r.OrderByDescending(o=>o.MemberPosition1);
}
}
if(c.sortname.ToLower().Equals("membermobile1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberMobile1);
}else{
r = r.OrderByDescending(o=>o.MemberMobile1);
}
}
if(c.sortname.ToLower().Equals("memberreltype2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberRelType2);
}else{
r = r.OrderByDescending(o=>o.MemberRelType2);
}
}
if(c.sortname.ToLower().Equals("membername2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberName2);
}else{
r = r.OrderByDescending(o=>o.MemberName2);
}
}
if(c.sortname.ToLower().Equals("membercompany2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberCompany2);
}else{
r = r.OrderByDescending(o=>o.MemberCompany2);
}
}
if(c.sortname.ToLower().Equals("memberposition2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberPosition2);
}else{
r = r.OrderByDescending(o=>o.MemberPosition2);
}
}
if(c.sortname.ToLower().Equals("membermobile2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberMobile2);
}else{
r = r.OrderByDescending(o=>o.MemberMobile2);
}
}
if(c.sortname.ToLower().Equals("memberreltype3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberRelType3);
}else{
r = r.OrderByDescending(o=>o.MemberRelType3);
}
}
if(c.sortname.ToLower().Equals("membername3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberName3);
}else{
r = r.OrderByDescending(o=>o.MemberName3);
}
}
if(c.sortname.ToLower().Equals("membercompany3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberCompany3);
}else{
r = r.OrderByDescending(o=>o.MemberCompany3);
}
}
if(c.sortname.ToLower().Equals("memberposition3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberPosition3);
}else{
r = r.OrderByDescending(o=>o.MemberPosition3);
}
}
if(c.sortname.ToLower().Equals("membermobile3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberMobile3);
}else{
r = r.OrderByDescending(o=>o.MemberMobile3);
}
}
if(c.sortname.ToLower().Equals("memberreltype4")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberRelType4);
}else{
r = r.OrderByDescending(o=>o.MemberRelType4);
}
}
if(c.sortname.ToLower().Equals("membername4")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberName4);
}else{
r = r.OrderByDescending(o=>o.MemberName4);
}
}
if(c.sortname.ToLower().Equals("membercompany4")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberCompany4);
}else{
r = r.OrderByDescending(o=>o.MemberCompany4);
}
}
if(c.sortname.ToLower().Equals("memberposition4")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberPosition4);
}else{
r = r.OrderByDescending(o=>o.MemberPosition4);
}
}
if(c.sortname.ToLower().Equals("membermobile4")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MemberMobile4);
}else{
r = r.OrderByDescending(o=>o.MemberMobile4);
}
}
if(c.sortname.ToLower().Equals("workstate")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.WorkState);
}else{
r = r.OrderByDescending(o=>o.WorkState);
}
}
if(c.sortname.ToLower().Equals("studyduration1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.StudyDuration1);
}else{
r = r.OrderByDescending(o=>o.StudyDuration1);
}
}
if(c.sortname.ToLower().Equals("studyschool1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.StudySchool1);
}else{
r = r.OrderByDescending(o=>o.StudySchool1);
}
}
if(c.sortname.ToLower().Equals("studyposition1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.StudyPosition1);
}else{
r = r.OrderByDescending(o=>o.StudyPosition1);
}
}
if(c.sortname.ToLower().Equals("studyduration2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.StudyDuration2);
}else{
r = r.OrderByDescending(o=>o.StudyDuration2);
}
}
if(c.sortname.ToLower().Equals("studyschool2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.StudySchool2);
}else{
r = r.OrderByDescending(o=>o.StudySchool2);
}
}
if(c.sortname.ToLower().Equals("studyposition2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.StudyPosition2);
}else{
r = r.OrderByDescending(o=>o.StudyPosition2);
}
}
if(c.sortname.ToLower().Equals("studyduration3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.StudyDuration3);
}else{
r = r.OrderByDescending(o=>o.StudyDuration3);
}
}
if(c.sortname.ToLower().Equals("studyschool3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.StudySchool3);
}else{
r = r.OrderByDescending(o=>o.StudySchool3);
}
}
if(c.sortname.ToLower().Equals("studyposition3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.StudyPosition3);
}else{
r = r.OrderByDescending(o=>o.StudyPosition3);
}
}
if(c.sortname.ToLower().Equals("softwareexp")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.SoftwareExp);
}else{
r = r.OrderByDescending(o=>o.SoftwareExp);
}
}
if(c.sortname.ToLower().Equals("programexp")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.ProgramExp);
}else{
r = r.OrderByDescending(o=>o.ProgramExp);
}
}
if(c.sortname.ToLower().Equals("networkexp")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.NetworkExp);
}else{
r = r.OrderByDescending(o=>o.NetworkExp);
}
}
if(c.sortname.ToLower().Equals("relcourse")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.RelCourse);
}else{
r = r.OrderByDescending(o=>o.RelCourse);
}
}
if(c.sortname.ToLower().Equals("districtid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.DistrictId);
}else{
r = r.OrderByDescending(o=>o.DistrictId);
}
}
if(c.sortname.ToLower().Equals("intentcity")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.IntentCity);
}else{
r = r.OrderByDescending(o=>o.IntentCity);
}
}
if(c.sortname.ToLower().Equals("clazzid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.ClazzId);
}else{
r = r.OrderByDescending(o=>o.ClazzId);
}
}
if(c.sortname.ToLower().Equals("studentno")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.StudentNo);
}else{
r = r.OrderByDescending(o=>o.StudentNo);
}
}
if(c.sortname.ToLower().Equals("inschooldate")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.InSchoolDate);
}else{
r = r.OrderByDescending(o=>o.InSchoolDate);
}
}
if(c.sortname.ToLower().Equals("isdorm")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.IsDorm);
}else{
r = r.OrderByDescending(o=>o.IsDorm);
}
}
if(c.sortname.ToLower().Equals("dormno")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.DormNo);
}else{
r = r.OrderByDescending(o=>o.DormNo);
}
}
if(c.sortname.ToLower().Equals("givecourseware")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.GiveCourseware);
}else{
r = r.OrderByDescending(o=>o.GiveCourseware);
}
}
if(c.sortname.ToLower().Equals("consultants")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Consultants);
}else{
r = r.OrderByDescending(o=>o.Consultants);
}
}
if(c.sortname.ToLower().Equals("remark")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Remark);
}else{
r = r.OrderByDescending(o=>o.Remark);
}
}
if(c.sortname.ToLower().Equals("createtime")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.CreateTime);
}else{
r = r.OrderByDescending(o=>o.CreateTime);
}
}
if(c.sortname.ToLower().Equals("lastupdatetime")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.LastUpdateTime);
}else{
r = r.OrderByDescending(o=>o.LastUpdateTime);
}
}
if(c.sortname.ToLower().Equals("isgetqualification")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.IsGetQualification);
}else{
r = r.OrderByDescending(o=>o.IsGetQualification);
}
}
if(c.sortname.ToLower().Equals("status")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Status);
}else{
r = r.OrderByDescending(o=>o.Status);
}
}
if(c.sortname.ToLower().Equals("technicalway")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.TechnicalWay);
}else{
r = r.OrderByDescending(o=>o.TechnicalWay);
}
}
if(c.sortname.ToLower().Equals("needobtainwork")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.NeedObtainWork);
}else{
r = r.OrderByDescending(o=>o.NeedObtainWork);
}
}
if(c.sortname.ToLower().Equals("intentposition")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.IntentPosition);
}else{
r = r.OrderByDescending(o=>o.IntentPosition);
}
}
if(c.sortname.ToLower().Equals("targetsalary")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.TargetSalary);
}else{
r = r.OrderByDescending(o=>o.TargetSalary);
}
}
if(c.sortname.ToLower().Equals("insurancestartdate")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.InsuranceStartDate);
}else{
r = r.OrderByDescending(o=>o.InsuranceStartDate);
}
}
if(c.sortname.ToLower().Equals("insuranceenddate")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.InsuranceEndDate);
}else{
r = r.OrderByDescending(o=>o.InsuranceEndDate);
}
}
if(c.sortname.ToLower().Equals("gaokaobatch")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.GaoKaoBatch);
}else{
r = r.OrderByDescending(o=>o.GaoKaoBatch);
}
}
if(c.sortname.ToLower().Equals("givenotebook")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.GiveNotebook);
}else{
r = r.OrderByDescending(o=>o.GiveNotebook);
}
}
if(c.sortname.ToLower().Equals("maxsalary")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MaxSalary);
}else{
r = r.OrderByDescending(o=>o.MaxSalary);
}
}
if(c.sortname.ToLower().Equals("currentsalary")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.CurrentSalary);
}else{
r = r.OrderByDescending(o=>o.CurrentSalary);
}
}
if(c.sortname.ToLower().Equals("firstsalary")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.FirstSalary);
}else{
r = r.OrderByDescending(o=>o.FirstSalary);
}
}
if(c.sortname.ToLower().Equals("beginschooltime")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.BeginSchoolTime);
}else{
r = r.OrderByDescending(o=>o.BeginSchoolTime);
}
}
if(c.sortname.ToLower().Equals("mastername1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MasterName1);
}else{
r = r.OrderByDescending(o=>o.MasterName1);
}
}
if(c.sortname.ToLower().Equals("mastername2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MasterName2);
}else{
r = r.OrderByDescending(o=>o.MasterName2);
}
}
if(c.sortname.ToLower().Equals("mastername3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MasterName3);
}else{
r = r.OrderByDescending(o=>o.MasterName3);
}
}
if(c.sortname.ToLower().Equals("teachername1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.TeacherName1);
}else{
r = r.OrderByDescending(o=>o.TeacherName1);
}
}
if(c.sortname.ToLower().Equals("teachername2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.TeacherName2);
}else{
r = r.OrderByDescending(o=>o.TeacherName2);
}
}
if(c.sortname.ToLower().Equals("teachername3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.TeacherName3);
}else{
r = r.OrderByDescending(o=>o.TeacherName3);
}
}
if(c.sortname.ToLower().Equals("masterid1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MasterId1);
}else{
r = r.OrderByDescending(o=>o.MasterId1);
}
}
if(c.sortname.ToLower().Equals("masterid2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MasterId2);
}else{
r = r.OrderByDescending(o=>o.MasterId2);
}
}
if(c.sortname.ToLower().Equals("masterid3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.MasterId3);
}else{
r = r.OrderByDescending(o=>o.MasterId3);
}
}
if(c.sortname.ToLower().Equals("teacherid1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.TeacherId1);
}else{
r = r.OrderByDescending(o=>o.TeacherId1);
}
}
if(c.sortname.ToLower().Equals("teacherid2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.TeacherId2);
}else{
r = r.OrderByDescending(o=>o.TeacherId2);
}
}
if(c.sortname.ToLower().Equals("teacherid3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.TeacherId3);
}else{
r = r.OrderByDescending(o=>o.TeacherId3);
}
}
if(c.sortname.ToLower().Equals("qualificationschool")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.QualificationSchool);
}else{
r = r.OrderByDescending(o=>o.QualificationSchool);
}
}
if(c.sortname.ToLower().Equals("insurancestatus")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.InsuranceStatus);
}else{
r = r.OrderByDescending(o=>o.InsuranceStatus);
}
}
if(c.sortname.ToLower().Equals("oldoaid")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.OldOaId);
}else{
r = r.OrderByDescending(o=>o.OldOaId);
}
}
if(c.sortname.ToLower().Equals("oldoainfosourcesubtypename")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.OldOaInfoSourceSubTypeName);
}else{
r = r.OrderByDescending(o=>o.OldOaInfoSourceSubTypeName);
}
}
if(c.sortname.ToLower().Equals("oldoaclass")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.OldOaClass);
}else{
r = r.OrderByDescending(o=>o.OldOaClass);
}
}
if(c.sortname.ToLower().Equals("hasrelteacher")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.HasRelTeacher);
}else{
r = r.OrderByDescending(o=>o.HasRelTeacher);
}
}
if(c.sortname.ToLower().Equals("relteacher")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.RelTeacher);
}else{
r = r.OrderByDescending(o=>o.RelTeacher);
}
}
if(c.sortname.ToLower().Equals("homeintro")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.HomeIntro);
}else{
r = r.OrderByDescending(o=>o.HomeIntro);
}
}
if(c.sortname.ToLower().Equals("give1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Give1);
}else{
r = r.OrderByDescending(o=>o.Give1);
}
}
if(c.sortname.ToLower().Equals("give2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Give2);
}else{
r = r.OrderByDescending(o=>o.Give2);
}
}
if(c.sortname.ToLower().Equals("give3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Give3);
}else{
r = r.OrderByDescending(o=>o.Give3);
}
}
if(c.sortname.ToLower().Equals("receive1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Receive1);
}else{
r = r.OrderByDescending(o=>o.Receive1);
}
}
if(c.sortname.ToLower().Equals("receive2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Receive2);
}else{
r = r.OrderByDescending(o=>o.Receive2);
}
}
if(c.sortname.ToLower().Equals("receive3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Receive3);
}else{
r = r.OrderByDescending(o=>o.Receive3);
}
}
if(c.sortname.ToLower().Equals("receive4")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Receive4);
}else{
r = r.OrderByDescending(o=>o.Receive4);
}
}
if(c.sortname.ToLower().Equals("receive5")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Receive5);
}else{
r = r.OrderByDescending(o=>o.Receive5);
}
}
if(c.sortname.ToLower().Equals("receive6")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Receive6);
}else{
r = r.OrderByDescending(o=>o.Receive6);
}
}
if(c.sortname.ToLower().Equals("pic1")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Pic1);
}else{
r = r.OrderByDescending(o=>o.Pic1);
}
}
if(c.sortname.ToLower().Equals("pic2")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Pic2);
}else{
r = r.OrderByDescending(o=>o.Pic2);
}
}
if(c.sortname.ToLower().Equals("pic3")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Pic3);
}else{
r = r.OrderByDescending(o=>o.Pic3);
}
}
if(c.sortname.ToLower().Equals("pic4")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Pic4);
}else{
r = r.OrderByDescending(o=>o.Pic4);
}
}
if(c.sortname.ToLower().Equals("pic5")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Pic5);
}else{
r = r.OrderByDescending(o=>o.Pic5);
}
}
if(c.sortname.ToLower().Equals("pic6")){
if(c.sortorder.ToLower().Equals("asc")){
r = r.OrderBy(o=>o.Pic6);
}else{
r = r.OrderByDescending(o=>o.Pic6);
}
}
}
m.RecordCount = r.Count();
if (c.pagesize.HasValue) {
int page = c.page ?? 1;
int pageCount = m.RecordCount / c.pagesize.Value;
if (m.RecordCount % c.pagesize.Value > 0) {
pageCount++;
}
int skip = (page - 1) * c.pagesize.Value;
if (skip > 0) {
r = r.Skip(skip);
}
r = r.Take(c.pagesize.Value);
}
m.Data = r.ToList();
return m;
}
