public ActionResult ClassDetail(int ID)
{
ViewBag.SchoolName = SchoolName;
ClassModels Class = db.Class.Include("ClassTeacher").Include("CompanyTeacher").Where(r => r.ID == ID).Where(r => r.School.Equals(SchoolID)).Where(r => r.Delete == 0).OrderBy(r => r.ID).FirstOrDefault();
if (Class == null)
{
return(RedirectToAction("index"));
}
return(View(Class));
}
//查詢類別
public List <ClassModels> Inquireclass()
{
command.CommandText = (@"SELECT Class_id, Class_name
FROM Table_Class");
var inquireclass = command.ExecuteReader();
List <ClassModels> list = new List <ClassModels>();
while (inquireclass.Read())
{
ClassModels models = new ClassModels();
models.Class_ID = (int)inquireclass["Class_id"];
models.Class_name = (String)inquireclass["Class_name"];
list.Add(models);
}
return(list);
}
