public List<QualificationStudent> Search(QualificationStudentCriteria c) { return this.Repository.Search(c); }
public List<QualificationStudent> Search(QualificationStudentCriteria c) { List<QualificationStudent> list = new List<QualificationStudent>(); StringBuilder sb = new StringBuilder(); var db = DatabaseFactory.CreateDatabase(); var sql = @"SELECT [Id], [Name] FROM [Qualification_Student] WHERE ((Consultant = '"+c.CurrentUserName+"') OR ('"+c.CurrentUserName+"' IN (SELECT [UserName] FROM Qualification_UnrestrictedUser))) "; if (c.Year.HasValue) sql += " AND YEAR(SignUpTime) = " + c.Year.Value.ToString(); if (!String.IsNullOrWhiteSpace(c.NameSrh)) sql += " AND ISNULL([Name],'') LIKE '%"+c.NameSrh+"%' "; if (!String.IsNullOrWhiteSpace(c.ConsultantSrh)) sql += " AND ISNULL([Consultant],'') LIKE '%"+c.ConsultantSrh+"%' "; if (!String.IsNullOrWhiteSpace(c.ReferrerSrh)) sql += " AND ISNULL([Referrer],'') LIKE '%" + c.ReferrerSrh + "%' "; if (!String.IsNullOrWhiteSpace(c.TargetSchoolNameSrh)) sql += " AND ISNULL([TargetSchoolName],'') LIKE '%" + c.TargetSchoolNameSrh + "%' "; if (!String.IsNullOrWhiteSpace(c.SubmitStatusSrh)) sql += " AND ISNULL([SubmitStatus],'') LIKE '%" + c.SubmitStatusSrh + "%' "; if (!String.IsNullOrWhiteSpace(c.OfferStatusSrh)) sql += " AND ISNULL([OfferStatus],'') LIKE '%" + c.OfferStatusSrh + "%' "; if (!String.IsNullOrWhiteSpace(c.PayStatusSrh)) sql += " AND ISNULL([PayStatus],'') LIKE '%" + c.PayStatusSrh + "%' "; if (!String.IsNullOrWhiteSpace(c.PaperStatusSrh)) sql += " AND ISNULL([PaperStatus],'') LIKE '%" + c.PaperStatusSrh + "%' "; sql += "ORDER BY YEAR(SignUpTime) DESC, [Name]"; using (var ir = db.ExecuteReader(CommandType.Text, sql)) { while (ir.Read()) { list.Add(new QualificationStudent { Id = ir["Id"].ToInt(), Name = ir["Name"].ToStr() }); /* list.Add(new QualificationStudent { BeginWorkTime = ir["BeginWorkTime"].ToNullableDateTime(), Birthday = ir["Birthday"].ToNullableDateTime(), Clazz = ir["Clazz"].ToStr(), CommAddress = ir["CommAddress"].ToStr(), Company = ir["Company"].ToStr(), CompanyTelephoneNo = ir["CompanyTelephoneNo"].ToStr(), Consultant=ir["Consultant"].ToStr(), GraduateDate = ir["GraduateDate"].ToNullableDateTime(), GruduateSchool = ir["GruduateSchool"].ToStr(), HighestEduLevel = ir["HighestEduLevel"].ToStr(), HighestQualification = ir["HighestQualification"].ToStr(), HighestQualificationNo = ir["HighestQualificationNo"].ToStr(), HomeAddress = ir["HomeAddress"].ToStr(), HomeTelephone = ir["HomeTelephone"].ToStr(), HuKouAddress = ir["HuKouAddress"].ToStr(), Id = ir["Id"].ToInt(), IdCardNo = ir["IdCardNo"].ToStr(), IsMarried = ir["IsMarried"].ToStr(), JiGuang = ir["JiGuang"].ToStr(), MatriculateTime = ir["MatriculateTime"].ToNullableDateTime(), MemberCompany1 = ir["MemberCompany1"].ToStr(), MemberCompany2 = ir["MemberCompany2"].ToStr(), MemberMianMao1 = ir["MemberMianMao1"].ToStr(), MemberMianMao2 = ir["MemberMianMao2"].ToStr(), MemberMobile1 = ir["MemberMobile1"].ToStr(), MemberMobile2 = ir["MemberMobile2"].ToStr(), MemberName1 = ir["MemberName1"].ToStr(), MemberName2 = ir["MemberName2"].ToStr(), MemberPosition1 = ir["MemberPosition1"].ToStr(), MemberPosition2 = ir["MemberPosition2"].ToStr(), MemberRelType1 = ir["MemberRelType1"].ToStr(), MemberRelType2 = ir["MemberRelType2"].ToStr(), MinZu = ir["MinZu"].ToStr(), Mobile = ir["Mobile"].ToStr(), Name = ir["Name"].ToStr(), NetPassword = ir["NetPassword"].ToStr(), NetUserName = ir["NetUserName"].ToStr(), OfferStatus = ir["OfferStatus"].ToStr(), OldOAId = ir["OldOAId"].ToStr(), PaperStatus = ir["PaperStatus"].ToStr(), PayStatus = ir["PayStatus"].ToStr(), Photo1 = ir["Photo1"].ToStr(), Photo2 = ir["Photo2"].ToStr(), Photo3 = ir["Photo3"].ToStr(), Postcode = ir["Postcode"].ToStr(), QQ = ir["QQ"].ToStr(), Referrer = ir["Referrer"].ToStr(), ReferrerMobile = ir["ReferrerMobile"].ToStr(), ReferrerQQ = ir["ReferrerQQ"].ToStr(), Remark = ir["Remark"].ToStr(), SeqNo = ir["SeqNo"].ToStr(), Sex = ir["Sex"].ToStr(), SignUpTime = ir["SignUpTime"].ToNullableDateTime(), Status = ir["Status"].ToStr(), StudentNo = ir["StudentNo"].ToStr(), StudyDuration1 = ir["StudyDuration1"].ToStr(), StudyDuration2 = ir["StudyDuration2"].ToStr(), StudyDuration3 = ir["StudyDuration3"].ToStr(), StudyPosition1 = ir["StudyPosition1"].ToStr(), StudyPosition2 = ir["StudyPosition2"].ToStr(), StudyPosition3 = ir["StudyPosition3"].ToStr(), StudySchool1 = ir["StudySchool1"].ToStr(), StudySchool2 = ir["StudySchool2"].ToStr(), StudySchool3 = ir["StudySchool3"].ToStr(), StudyType = ir["StudyType"].ToStr(), SubmitStatus = ir["SubmitStatus"].ToStr(), TargetLevel = ir["TargetLevel"].ToStr(), TargetProfession = ir["TargetProfession"].ToStr(), TargetSchoolName = ir["TargetSchoolName"].ToStr(), Title = ir["Title"].ToStr(), WorkedYears = ir["WorkedYears"].ToNullableInt(), ZhengZhiMianMao = ir["ZhengZhiMianMao"].ToStr() }); */ } ir.Close(); } return list; }