public XueShengYuBanJiDuiYingBiao GetXueShengYuBanJiDuiYingBiao(int ID, int bjID)
{
List <SqlParameter> spls = new List <SqlParameter>();
string sql = "Select * From XueShengYuBanJiDuiYingBiao where StudentID = @ID and StudentClassID = @bjID and EndTime is null";
SqlParameter p1 = new SqlParameter("@ID", ID);
SqlParameter p2 = new SqlParameter("@bjID", bjID);
spls.Add(p1);
spls.Add(p2);
XueShengYuBanJiDuiYingBiao list = context.Database.SqlQuery <XueShengYuBanJiDuiYingBiao>(sql, spls.ToArray()).First();
return(list);
}
public int GetXsBj1(XueShengBiao xs, BanJiBiao bj)
{
XueShengYuBanJiDuiYingBiao xb = new XueShengYuBanJiDuiYingBiao
{
StudentID = xs.ID,
StudentName = xs.StudentName,
StudentClassID = bj.ID,
StudentClass = bj.BanJiMing,
StartTiem = bj.KaiBanShiJian
};
context.XueShengYuBanJiDuiYingBiao.Add(xb);
return(context.SaveChanges());
}
