public Core.Business.Student GetStudentByCode(string code)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Code", SqlDbType.NVarChar, code);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetStudentByCode);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Student student = new Core.Business.Student();
if (!reader.IsDBNull(0)) student.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) student.Code = reader.GetString(1);
if (!reader.IsDBNull(2)) student.StdName = reader.GetString(2);
if (!reader.IsDBNull(3)) student.UsedName = reader.GetString(3);
if (!reader.IsDBNull(4)) student.StdState = reader.GetString(4);
if (!reader.IsDBNull(5)) student.IndentifyType = reader.GetString(5);
if (!reader.IsDBNull(6)) student.StdCate = reader.GetString(6);
if (!reader.IsDBNull(7)) student.IndentifyCode = reader.GetString(7);
if (!reader.IsDBNull(8)) student.Gender = reader.GetInt32(8);
if (!reader.IsDBNull(9)) student.AdmissDate = reader.GetDateTime(9);
if (!reader.IsDBNull(10)) student.ProfessCode = reader.GetString(10);
if (!reader.IsDBNull(11)) student.ResidenceName = reader.GetString(11);
if (!reader.IsDBNull(12)) student.ResidenceType = reader.GetString(12);
if (!reader.IsDBNull(13)) student.Nation = reader.GetString(13);
if (!reader.IsDBNull(14)) student.Birthday = reader.GetDateTime(14);
if (!reader.IsDBNull(15)) student.AdmissTypeCode = reader.GetString(15);
if (!reader.IsDBNull(16)) student.Phone = reader.GetString(16);
if (!reader.IsDBNull(17)) student.CorSchlCode = reader.GetString(17);
if (!reader.IsDBNull(18)) student.CorTypeCode = reader.GetString(18);
if (!reader.IsDBNull(19)) student.Zip_Code = reader.GetString(19);
if (!reader.IsDBNull(20)) student.RegistedCode = reader.GetString(20);
if (!reader.IsDBNull(21)) student.PoliticalCode = reader.GetString(21);
if (!reader.IsDBNull(22)) student.Origin = reader.GetString(22);
if (!reader.IsDBNull(23)) student.OverSea = reader.GetBoolean(23);
if (!reader.IsDBNull(24)) student.GrdSchool = reader.GetString(24);
if (!reader.IsDBNull(25)) student.StdAddress = reader.GetString(25);
if (!reader.IsDBNull(26)) student.Email = reader.GetString(26);
if (!reader.IsDBNull(27)) student.Des = reader.GetString(27);
if (!reader.IsDBNull(28)) student.RegisteDate = reader.GetDateTime(28);
reader.Close();
student.MarkOld();
return student;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IList<Core.Business.Student> GetRegisteredStudent(string strWhere, int isHighLevel)
{
StringBuilder sb = new StringBuilder();
sb.Append(SqlGetRegisteredStudentList);
if (!string.IsNullOrEmpty(strWhere))
sb.Append(" AND " + strWhere);
SqlServerUtility sql = new SqlServerUtility();
CY.GFive.Core.Business.AcademicYear ayear = CY.GFive.Core.Business.AcademicYear.GetCurrentAcademicYear();
try
{
sql.AddParameter("@YearNum", SqlDbType.NVarChar, ayear.Name);
sql.AddParameter("@Term", SqlDbType.Int, ayear.Semesters[0].Id);
sql.AddParameter("@IsHighLevel", SqlDbType.Int, isHighLevel);
}
catch (Exception ex)
{
throw ex;
}
IList<Core.Business.Student> studentlist = new List<Core.Business.Student>();
SqlDataReader reader = sql.ExecuteSqlReader(sb.ToString());
if (reader != null)
{
while (reader.Read())
{
Core.Business.Student student = new Core.Business.Student();
if (!reader.IsDBNull(0)) student.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) student.Code = reader.GetString(1);
if (!reader.IsDBNull(2)) student.StdName = reader.GetString(2);
if (!reader.IsDBNull(3)) student.UsedName = reader.GetString(3);
if (!reader.IsDBNull(4)) student.StdState = reader.GetString(4);
if (!reader.IsDBNull(5)) student.IndentifyType = reader.GetString(5);
if (!reader.IsDBNull(6)) student.StdCate = reader.GetString(6);
if (!reader.IsDBNull(7)) student.IndentifyCode = reader.GetString(7);
if (!reader.IsDBNull(8)) student.Gender = reader.GetInt32(8);
if (!reader.IsDBNull(9)) student.AdmissDate = reader.GetDateTime(9);
if (!reader.IsDBNull(10)) student.ProfessCode = reader.GetString(10);
if (!reader.IsDBNull(11)) student.ResidenceName = reader.GetString(11);
if (!reader.IsDBNull(12)) student.ResidenceType = reader.GetString(12);
if (!reader.IsDBNull(13)) student.Nation = reader.GetString(13);
if (!reader.IsDBNull(14)) student.Birthday = reader.GetDateTime(14);
if (!reader.IsDBNull(15)) student.AdmissTypeCode = reader.GetString(15);
if (!reader.IsDBNull(16)) student.Phone = reader.GetString(16);
if (!reader.IsDBNull(17)) student.CorSchlCode = reader.GetString(17);
if (!reader.IsDBNull(18)) student.CorTypeCode = reader.GetString(18);
if (!reader.IsDBNull(19)) student.Zip_Code = reader.GetString(19);
if (!reader.IsDBNull(20)) student.RegistedCode = reader.GetString(20);
if (!reader.IsDBNull(21)) student.PoliticalCode = reader.GetString(21);
if (!reader.IsDBNull(22)) student.Origin = reader.GetString(22);
if (!reader.IsDBNull(23)) student.OverSea = reader.GetBoolean(23);
if (!reader.IsDBNull(24)) student.GrdSchool = reader.GetString(24);
if (!reader.IsDBNull(25)) student.StdAddress = reader.GetString(25);
if (!reader.IsDBNull(26)) student.Email = reader.GetString(26);
if (!reader.IsDBNull(27)) student.Des = reader.GetString(27);
if (!reader.IsDBNull(28)) student.RegisteDate = reader.GetDateTime(28);
student.MarkOld();
studentlist.Add(student);
}
reader.Close();
}
return studentlist;
}
public Core.Business.Student GetTheMaxCodeStudent(string stdcode)
{
Student stemp = GetStudentByCode(stdcode);
string yearparam = stemp.AdmissDate.Year.ToString();
string SqlGetMaxStuCodeByParam = "SELECT [Id], [Code],[StdName],[UsedName],[StdState],[IndentifyType],[StdCate],[IndentifyCode],[Gender],[AdmissDate],[ProfessCode],[ResidenceName],[ResidenceType],[Nation],[Birthday],[AdmissTypeCode],[Phone],[CorSchlCode],[CorTypeCode],[Zip_Code],[RegistedCode],[PoliticalCode],[Origin],[OverSea],[GrdSchool],[StdAddress],[Email],[Des],[RegisteDate] FROM [Student] where substring(Code,0,5)='" + yearparam + "' ORDER BY [Code] DESC";
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetMaxStuCodeByParam);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Student student = new Core.Business.Student();
if (!reader.IsDBNull(0)) student.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) student.Code = reader.GetString(1);
if (!reader.IsDBNull(2)) student.StdName = reader.GetString(2);
if (!reader.IsDBNull(3)) student.UsedName = reader.GetString(3);
if (!reader.IsDBNull(4)) student.StdState = reader.GetString(4);
if (!reader.IsDBNull(5)) student.IndentifyType = reader.GetString(5);
if (!reader.IsDBNull(6)) student.StdCate = reader.GetString(6);
if (!reader.IsDBNull(7)) student.IndentifyCode = reader.GetString(7);
if (!reader.IsDBNull(8)) student.Gender = reader.GetInt32(8);
if (!reader.IsDBNull(9)) student.AdmissDate = reader.GetDateTime(9);
if (!reader.IsDBNull(10)) student.ProfessCode = reader.GetString(10);
if (!reader.IsDBNull(11)) student.ResidenceName = reader.GetString(11);
if (!reader.IsDBNull(12)) student.ResidenceType = reader.GetString(12);
if (!reader.IsDBNull(13)) student.Nation = reader.GetString(13);
if (!reader.IsDBNull(14)) student.Birthday = reader.GetDateTime(14);
if (!reader.IsDBNull(15)) student.AdmissTypeCode = reader.GetString(15);
if (!reader.IsDBNull(16)) student.Phone = reader.GetString(16);
if (!reader.IsDBNull(17)) student.CorSchlCode = reader.GetString(17);
if (!reader.IsDBNull(18)) student.CorTypeCode = reader.GetString(18);
if (!reader.IsDBNull(19)) student.Zip_Code = reader.GetString(19);
if (!reader.IsDBNull(20)) student.RegistedCode = reader.GetString(20);
if (!reader.IsDBNull(21)) student.PoliticalCode = reader.GetString(21);
if (!reader.IsDBNull(22)) student.Origin = reader.GetString(22);
if (!reader.IsDBNull(23)) student.OverSea = reader.GetBoolean(23);
if (!reader.IsDBNull(24)) student.GrdSchool = reader.GetString(24);
if (!reader.IsDBNull(25)) student.StdAddress = reader.GetString(25);
if (!reader.IsDBNull(26)) student.Email = reader.GetString(26);
if (!reader.IsDBNull(27)) student.Des = reader.GetString(27);
if (!reader.IsDBNull(28)) student.RegisteDate = reader.GetDateTime(28);
reader.Close();
student.MarkOld();
return student;
}
else
return null;
}
public IList<Student> GetByWhere(string strwhere)
{
IList<Core.Business.Student> studentlist = new List<Core.Business.Student>();
SqlServerUtility sql = new SqlServerUtility();
string str = SqlGetByWhere + strwhere;
SqlDataReader reader = sql.ExecuteSqlReader(str);
if (reader != null)
{
while (reader.Read())
{
Core.Business.Student student = new Core.Business.Student();
if (!reader.IsDBNull(0)) student.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) student.Code = reader.GetString(1);
if (!reader.IsDBNull(2)) student.StdName = reader.GetString(2);
if (!reader.IsDBNull(3)) student.UsedName = reader.GetString(3);
if (!reader.IsDBNull(4)) student.StdState = reader.GetString(4);
if (!reader.IsDBNull(5)) student.IndentifyType = reader.GetString(5);
if (!reader.IsDBNull(6)) student.StdCate = reader.GetString(6);
if (!reader.IsDBNull(7)) student.IndentifyCode = reader.GetString(7);
if (!reader.IsDBNull(8)) student.Gender = reader.GetInt32(8);
if (!reader.IsDBNull(9)) student.AdmissDate = reader.GetDateTime(9);
if (!reader.IsDBNull(10)) student.ProfessCode = reader.GetString(10);
if (!reader.IsDBNull(11)) student.ResidenceName = reader.GetString(11);
if (!reader.IsDBNull(12)) student.ResidenceType = reader.GetString(12);
if (!reader.IsDBNull(13)) student.Nation = reader.GetString(13);
if (!reader.IsDBNull(14)) student.Birthday = reader.GetDateTime(14);
if (!reader.IsDBNull(15)) student.AdmissTypeCode = reader.GetString(15);
if (!reader.IsDBNull(16)) student.Phone = reader.GetString(16);
if (!reader.IsDBNull(17)) student.CorSchlCode = reader.GetString(17);
if (!reader.IsDBNull(18)) student.CorTypeCode = reader.GetString(18);
if (!reader.IsDBNull(19)) student.Zip_Code = reader.GetString(19);
if (!reader.IsDBNull(20)) student.RegistedCode = reader.GetString(20);
if (!reader.IsDBNull(21)) student.PoliticalCode = reader.GetString(21);
if (!reader.IsDBNull(22)) student.Origin = reader.GetString(22);
if (!reader.IsDBNull(23)) student.OverSea = reader.GetBoolean(23);
if (!reader.IsDBNull(24)) student.GrdSchool = reader.GetString(24);
if (!reader.IsDBNull(25)) student.StdAddress = reader.GetString(25);
if (!reader.IsDBNull(26)) student.Email = reader.GetString(26);
if (!reader.IsDBNull(27)) student.Des = reader.GetString(27);
if (!reader.IsDBNull(28)) student.RegisteDate = reader.GetDateTime(28);
student.MarkOld();
studentlist.Add(student);
}
reader.Close();
}
return studentlist;
}
/// <summary>
/// ��ȡѧ���б��רҵѧ��ѧ��
/// </summary>
/// <param name="classInfo"></param>
/// <returns></returns>
public IList<Student> GetStuListByYearTermAndPro(string year, int term, string proCode, string grade)
{
IList<Core.Business.Student> studentlist = new List<Core.Business.Student>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Year", SqlDbType.NVarChar, year);
sql.AddParameter("@Term", SqlDbType.Int, term);
sql.AddParameter("@ProName", SqlDbType.NVarChar, proCode);
sql.AddParameter("@Grade", SqlDbType.NVarChar, grade);
SqlDataReader reader = sql.ExecuteSqlReader(SqlGetStuListByYearAndTeamAndPro);
if (reader != null)
{
while (reader.Read())
{
Core.Business.Student student = new Core.Business.Student();
if (!reader.IsDBNull(0)) student.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) student.Code = reader.GetString(1);
if (!reader.IsDBNull(2)) student.StdName = reader.GetString(2);
if (!reader.IsDBNull(3)) student.UsedName = reader.GetString(3);
if (!reader.IsDBNull(4)) student.StdState = reader.GetString(4);
if (!reader.IsDBNull(5)) student.IndentifyType = reader.GetString(5);
if (!reader.IsDBNull(6)) student.StdCate = reader.GetString(6);
if (!reader.IsDBNull(7)) student.IndentifyCode = reader.GetString(7);
if (!reader.IsDBNull(8)) student.Gender = reader.GetInt32(8);
if (!reader.IsDBNull(9)) student.AdmissDate = reader.GetDateTime(9);
if (!reader.IsDBNull(10)) student.ProfessCode = reader.GetString(10);
if (!reader.IsDBNull(11)) student.ResidenceName = reader.GetString(11);
if (!reader.IsDBNull(12)) student.ResidenceType = reader.GetString(12);
if (!reader.IsDBNull(13)) student.Nation = reader.GetString(13);
if (!reader.IsDBNull(14)) student.Birthday = reader.GetDateTime(14);
if (!reader.IsDBNull(15)) student.AdmissTypeCode = reader.GetString(15);
if (!reader.IsDBNull(16)) student.Phone = reader.GetString(16);
if (!reader.IsDBNull(17)) student.CorSchlCode = reader.GetString(17);
if (!reader.IsDBNull(18)) student.CorTypeCode = reader.GetString(18);
if (!reader.IsDBNull(19)) student.Zip_Code = reader.GetString(19);
if (!reader.IsDBNull(20)) student.RegistedCode = reader.GetString(20);
if (!reader.IsDBNull(21)) student.PoliticalCode = reader.GetString(21);
if (!reader.IsDBNull(22)) student.Origin = reader.GetString(22);
if (!reader.IsDBNull(23)) student.OverSea = reader.GetBoolean(23);
if (!reader.IsDBNull(24)) student.GrdSchool = reader.GetString(24);
if (!reader.IsDBNull(25)) student.StdAddress = reader.GetString(25);
if (!reader.IsDBNull(26)) student.Email = reader.GetString(26);
if (!reader.IsDBNull(27)) student.Des = reader.GetString(27);
if (!reader.IsDBNull(28)) student.RegisteDate = reader.GetDateTime(28);
student.MarkOld();
studentlist.Add(student);
}
reader.Close();
}
return studentlist;
}
