//获取专业信息 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);
}
