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