/// <summary>
/// 获取指定的学校信息
/// </summary>
/// <param name="schoolId">学校编号</param>
/// <returns>学校信息</returns>
public static SchoolBase GetSchoolBaseInfo(int schoolId)
{
using (DbCommander cmd = new DbCommander(DbConn.ReadDb, "SP_School_GetDetail", CommandType.StoredProcedure))
{
cmd.AddInputParameters("SchoolId", schoolId);
SchoolBase resultData = null;
using (IDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
resultData = new SchoolBase
{
SchoolId = (int)reader["SchoolId"],
FullName = (string)reader["FullName"],
ShortName = (string)reader["ShortName"],
EnglishName = (string)reader["EnglishName"],
LargerLogo = (string)reader["LargerLogo"],
SmallerLogo = (string)reader["SmallerLogo"],
SceneryLogo = (string)reader["SceneryLogo"],
AreaCity = (string)reader["AreaCity"],
AreaAddress = (string)reader["AreaAddress"],
Contacter = (string)reader["Contacter"],
Telphone = (string)reader["Telphone"],
Email = (string)reader["Email"],
WebSite = (string)reader["WebSite"],
Introduce = (string)reader["Introduce"],
CreateDate = (DateTime)reader["CreateDate"]
};
}
reader.Close();
}
return(resultData);
}
}
/// <summary>
/// 命令执行
/// </summary>
/// <param name="context"></param>
public override void Execute(DataContext context)
{
UserCacheInfo userCache = UserBiz.ReadUserCacheInfo(context.UserId);
if (userCache.UserSite > 0)
{
SchoolBase schoolBaseInfo = SchoolBiz.GetSchoolBaseInfo(userCache.UserSite);
if (null != schoolBaseInfo)
{
context.Flush <SchoolInfo>(schoolBaseInfo.ToSchoolInfo());
return;
}
}
context.Flush(RespondCode.DataInvalid);
}
private static void PruebasPolimorfismo()
{
PrintTitle("Pruebas de polimorfismo");
var studentTest = new Student {
Name = "Claire UnderWood"
};
PrintTitle("Alumno");
WriteLine($"Alumno: {studentTest.Name}");
WriteLine($"ID: {studentTest.UniqueId}");
WriteLine($"Tipo: {studentTest.GetType()}");
SchoolBase ob = studentTest;
PrintTitle("Objeto Escuela");
WriteLine($"Alumno: {ob.Name}");
WriteLine($"ID: {ob.UniqueId}");
WriteLine($"Tipo: {ob.GetType()}");
var objDummy = new SchoolBase()
{
Name = "Frank Underwood"
};
PrintTitle("Dummy");
WriteLine($"Alumno: {objDummy.Name}");
WriteLine($"ID: {objDummy.UniqueId}");
WriteLine($"Tipo: {objDummy.GetType()}");
var evaluation = new Evaluation {
Name = "Evaluacion de Matematicas", Score = 4.5f
};
PrintTitle("Evaluacion");
WriteLine($"Evaluacion: {evaluation.Name}");
WriteLine($"ID: {evaluation.UniqueId}");
WriteLine($"Nota: {evaluation.Score}");
WriteLine($"Tipo: {evaluation.GetType()}");
if (ob is Student)
{
Student recoveredStudent = (Student)ob;
}
// Mejor manera
Student recoveredStudent2 = ob as Student;
if (recoveredStudent2 != null)
{
// Haz cosas
}
}
