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