public static string Add(ExamsBox eb)
{
var name = eb.StudentsId;
var score = eb.Score;
var namearr = name.Split(',');
var scorearr = score.Split(',');
using (var db = new XuejiContext())
{
var str = "[";
for (var i = 0; i < namearr.Length; i++)
{
var studentsid = Convert.ToInt16(namearr[i]);
var single = db.Studentses.SingleOrDefault(s => s.Id == studentsid);
str += str == "[" ? "{\"StudentsId\":\"" + namearr[i] + "\",\"StudentsName\":\"" + single.Name + "\",\"Score\":\"" + scorearr[i] + "\"}" : ",{\"StudentsId\":\"" + namearr[i] + "\",\"StudentsName\":\"" + single.Name + "\",\"Score\":\"" + scorearr[i] + "\"}";
}
str += "]";//后更换stringbuilder
var exams = new Exams
{
CoursesArrangingId = eb.CoursesArrangingId,
TimeStamp = eb.Examstime,
Name = eb.Examsname,
StudentScore = str
};
db.Examses.Add(exams);
db.SaveChanges();
}
return("1");
}
/// <summary>
/// 为exams表修改一条记录
/// </summary>
/// <param name="eb">类型 Examsbox中id 供exams修改对应数据</param>
/// <returns>返回字符串“1”为修改成功</returns>
public static string Edit(ExamsBox eb)
{
var name = eb.StudentsId;
var score = eb.Score;
var namearr = name.Split(',');
var scorearr = score.Split(',');
using (var db = new XuejiContext())
{
var str = "[";
for (var i = 0; i < namearr.Length; i++)
{
var studentsid = Convert.ToInt16(namearr[i]);
var single = db.Studentses.SingleOrDefault(s => s.Id == studentsid);
str += str == "["
? "{\"StudentsId\":\"" + namearr[i] + "\",\"StudentsName\":\"" + single.Name +
"\",\"Score\":\"" + scorearr[i] + "\"}"
: ",{\"StudentsId\":\"" + namearr[i] + "\",\"StudentsName\":\"" + single.Name +
"\",\"Score\":\"" + scorearr[i] + "\"}";
}
str += "]"; //后更换stringbuilder
var singlescore = db.Examses.SingleOrDefault(ex => ex.Id == eb.Id);
singlescore.StudentScore = str;
db.SaveChanges();
}
return("1");
}
/// <summary>
///
/// </summary>
/// <param name="eb"></param>
/// <returns></returns>
public ActionResult Addexams(ExamsBox eb)
{
return(Content(ExamsDal.Add(eb)));
}
/// <summary>
/// 修改学生成绩
/// </summary>
/// <param name="studentscore">类型 ExamsBox</param>
/// <returns>返回字符串，返回“1”则修改成功</returns>
public ActionResult Edit(ExamsBox studentscore)
{
return(Content(ExamsDal.Edit(studentscore)));
}
