public static int LoginFun(string account, string pwd)
{
StudentInfoManagementEntities se = new StudentInfoManagementEntities();
var modelID = se.StudentInfo.FirstOrDefault(m => m.StudentAlias == account);
var AdminModelID = se.AdminInfo.FirstOrDefault(m => m.AdminName == account); //管理员mmm
if (modelID != null && AdminModelID == null)
{
if (modelID.Password == pwd)
{
return(1);
}
else
{
return(0);
}
}
else if (modelID == null && AdminModelID != null)
{
if (AdminModelID.Password == pwd)
{
return(2);
}
else
{
return(0);
}
}
else
{
return(0);
}
}
public void Save()
{
using (StudentInfoManagementEntities se = new StudentInfoManagementEntities())
{
var Student01 = new StudentInfo()
{
StudentID = this.Account,
Password = this.Password
};
se.StudentInfo.Add(Student01);
se.SaveChanges();
}
}
public ActionResult Delete(string id)
{
try
{
StudentInfoManagementEntities se = new StudentInfoManagementEntities();
var Student01 = se.StudentInfo.FirstOrDefault(m => m.StudentID == id);
if (Student01 != null)
{
se.StudentInfo.Remove(Student01);
se.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
}
return(View());
}
public ActionResult Edit(string id, FormCollection collection)
{
try
{
if (ModelState.IsValid)
{
StudentInfoManagementEntities se = new StudentInfoManagementEntities();
var model = se.StudentInfo.FirstOrDefault(m => m.StudentID == id);
string[] strArr = collection.AllKeys;
TryUpdateModel(model, strArr);
se.SaveChanges();
return(RedirectToAction("Index"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
}
return(View());
}
public static StudentInfo LogFunction(Vm001 model)
{
StudentInfoManagementEntities se = new StudentInfoManagementEntities();
return(se.StudentInfo.FirstOrDefault(m => m.StudentID == model.account && m.Password == model.pwd));
}
public static StudentInfo GetById(string id)
{
StudentInfoManagementEntities se = new StudentInfoManagementEntities();
return(se.StudentInfo.FirstOrDefault(m => m.StudentID == id));
}
public static IEnumerable <StudentInfo> GetAll()
{
StudentInfoManagementEntities se = new StudentInfoManagementEntities();
return(se.StudentInfo);
}
