public DeluxeJsonResult AddEvalPoint(StudentTagsModel model)
{
HPITMemberInfo currentUser = DeluxeUser.CurrentMember;
string stuNo = "";
if (currentUser.FullName != "学生" && currentUser.FullName != "项目组组长" && currentUser.FullName != "技术主管" && currentUser.FullName != "项目主管" && currentUser.FullName != "人事主管")
{
return(new DeluxeJsonResult(new { data = "只能学生进行技术评估", status = 403 }));
}
List <EvalStudent> matchList = EvaluteDal.Instance.GetMatchStudent(currentUser.RealName, "");
StudentEval studentEval = new StudentEval();
if (matchList.Count == 1)
{
EvalStudent match = matchList.FirstOrDefault();
stuNo = match.StudentNo;
studentEval.PEM = match.PEM;
studentEval.PRM = match.PRM;
}
foreach (var stag in model.tags)
{
stag.StudentName = currentUser.RealName;
stag.StudentNo = stuNo;
}
studentEval.StudentName = currentUser.RealName;
studentEval.StudentNo = stuNo;
studentEval.Direction = model.positionName;
studentEval.CreateTime = DateTime.Now;
studentEval.Score = model.tags.Sum(r => r.SelfPoint);
var result = StudentDal.Instance.AddStudentTags(stuNo, model.tags, studentEval);
return(new DeluxeJsonResult(new { data = result, status = 200 }));
}
/// <summary>
/// 添加学生标签
/// </summary>
/// <param name="tags"></param>
/// <returns></returns>
public int AddStudentTags(string stuNo, List <StudentTags> tags, StudentEval eval)
{
//添加一次评分
var match = context.StudentEvaluate.FirstOrDefault(r => r.StudentNo == stuNo);
if (match == null)
{
context.StudentEvaluate.Add(eval);
}
else
{
using (var db = new SurveyContext())
{
db.Database.ExecuteSqlCommand(
string.Format("update dbo.StudentEvaluate set Score={0}, Direction = '{1}' where StudentNo='{2}'", eval.Score, eval.Direction, stuNo));
}
}
using (var db = new SurveyContext())
{
db.Database.ExecuteSqlCommand(
string.Format("delete from dbo.StudentTags where StudentNo='{0}'", stuNo));
}
context.StudentTags.AddRange(tags);
return(context.SaveChanges());
}
public void TestAddStudentEval()
{
StudentEval studentEval = new StudentEval();
studentEval.Direction = "NET";
studentEval.StudentName = "王瑞祥";
studentEval.StudentNo = "123456";
studentEval.TeacherPoint = 5;
studentEval.CreateTime = DateTime.Now;
studentEval.Score = 10;
SurveyContext context = new SurveyContext();
context.StudentEvaluate.Add(studentEval);
var result = context.SaveChanges();
string json = JsonConvert.SerializeObject(result);
}