//获取专业信息 by majorid public Major GetMajorByMajorId(string majorid) { //sql连接字符串 string sql = "select * from Major,College where Major.Belong=College.CollegeId and MajorId=@majorid"; //参数赋值 SqlParameter[] para = new SqlParameter[] { new SqlParameter("@majorid", majorid), }; //执行sql SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, sql, para); Major major = null; if (reader.Read()) { CollegeService collegeService = new CollegeService(); major = new Major(); major.MajorId = (string)reader["MajorId"]; major.MajorName = (string)reader["MajorName"]; major.Belong = collegeService.GetCollegeByCollegeId((string)reader["Belong"]); } return(major); }
//获取教师基本信息 public TBasic GetTeacherBsaicByTNumber(string tnumber) { //sql连接字符串 string sql = "select * from TBasic where TNumber=@tnumber"; //参数赋值 SqlParameter[] para = new SqlParameter[] { new SqlParameter("@tnumber", tnumber), }; //执行sql SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, sql, para); TBasic tBasic = null; if (reader.Read()) { CollegeService collegeService = new CollegeService(); tBasic = new TBasic(); tBasic.TNumber = (string)reader["TNumber"]; tBasic.TName = (string)reader["TName"]; tBasic.TIDNumber = (string)reader["TIDNumber"]; tBasic.TCollege = collegeService.GetCollegeByCollegeId((string)reader["TCollege"]); tBasic.TPhone = (string)reader["TPhone"]; tBasic.TEmail = (string)reader["TEmail"]; tBasic.TBirthday = reader["TBirthday"] != DBNull.Value ? (DateTime?)reader["TBirthday"] : null; tBasic.TAddress = (string)reader["TAddress"]; tBasic.TPicAddress = (string)reader["TPicAddress"]; } return(tBasic); }
//获取学生基本信息 public SBasic GetStudentBsaicBySNumber(string snumber) { //sql连接字符串 string sql = "select * from SBasic where SNumber=@snumber"; //参数赋值 SqlParameter[] para = new SqlParameter[] { new SqlParameter("@snumber", snumber), }; //执行sql SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.ConnString, CommandType.Text, sql, para); SBasic sBasic = null; if (reader.Read()) { StatusService status = new StatusService(); CollegeService collegeService = new CollegeService(); MajorService majorService = new MajorService(); sBasic = new SBasic(); sBasic.SNumber = (string)reader["SNumber"]; sBasic.SName = (string)reader["SName"]; sBasic.SIDNumber = (string)reader["SIDNumber"]; sBasic.SCollege = collegeService.GetCollegeByCollegeId((string)reader["SCollege"]); sBasic.SMajor = majorService.GetMajorByMajorId((string)reader["SMajor"]); sBasic.SEnrollment = reader["SEnrollment"] != DBNull.Value ? (DateTime?)reader["SEnrollment"] : null; sBasic.SStatus = status.GetStatusById((int)reader["SStatus"]); sBasic.SSex = (string)reader["SSex"]; sBasic.SPhone = (string)reader["SPhone"]; sBasic.SEmail = reader["SEmail"].ToString(); sBasic.SBirthday = reader["SBirthday"] != DBNull.Value ? (DateTime?)reader["SBirthday"] : null; sBasic.SAddress = (string)reader["SAddress"]; sBasic.SPicAddress = (string)reader["SPicAddress"]; } return(sBasic); }