public getCourseScore(string ja1)
{
JArray ja = (JArray)JsonConvert.DeserializeObject(ja1);
int i = 0;
while (i < ja.Count)
{
JObject courseScore = (JObject)ja[i];
this.score = (short)courseScore["score"];
this.gradePoint = 0;
this.courseid = (long)courseScore["courseid"];
this.userid = (long)courseScore["userid"];
this.courseType = courseScore["courseType"].ToString();
this.credits = (double)courseScore["credits"];
this.courseName = courseScore["courseName"].ToString();
this.teacherName = courseScore["teacherName"].ToString();
this.school = courseScore["school"].ToString();
this.Year = (short)courseScore["year"];
this.Term = (bool)courseScore["term"];
CourseScore score = new CourseScore(this.courseName, this.score, this.gradePoint, this.courseid, this.userid, this.courseType, this.credits, this.teacherName, this.school, this.Year, this.Term);
score.addCourseScore(score);
i++;
}
}
static void Main(string[] args)
{
//Request req = new Request("2018302110248", "061314", "19990606");
//string a = req.get_info();
//Console.WriteLine(a);
//string b = req.get_course();
//Console.WriteLine(b);
//string c = req.get_score();
//Console.WriteLine(c);
Course co = new Course(4, 20183011, "操作系统", "专业必修", "普通", "计算机学院", "王磊", "计科", "9：50-11：25", "Mon:1-16周,每1周;11-12节,1区,5-103Wed:1-16周,每1周;11-12节,1区,5-103", 2018302110253);
Course co1 = new Course(4, 20183012, "组合数学", "专业必修", "普通", "计算机学院", "玉玉", "计科", "9：50-11：25", "Tue:9-14周,每1周;11-13节", 2018302110253);
Course co3 = new Course(4, 20183013, "离散数学", "专业必修", "普通", "计算机学院", "憨憨", "计科", "9：50-11：25", "Tue:1-16周,每1周;3-4节,3区,1-532", 2018302110253);
CourseScore cs0 = new CourseScore("计算机网络", 95, 0, 2001532450, 2018302110253, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs1 = new CourseScore("操作系统", 95, 0, 2001532451, 2018302110253, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs2 = new CourseScore("离散数学", 95, 0, 2001532452, 2018302110253, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs3 = new CourseScore("组合数学", 95, 0, 2001532453, 2018302110253, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs4 = new CourseScore("大学英语3", 95, 0, 2001532454, 2018302110253, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs5 = new CourseScore("操作系统", 95, 0, 2001532455, 2018302110253, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs6 = new CourseScore("基础体育", 95, 0, 2001532456, 2018302110253, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs7 = new CourseScore("计算机网络", 95, 0, 2001532450, 2018302110245, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs8 = new CourseScore("操作系统", 95, 0, 2001532451, 2018302110245, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs9 = new CourseScore("离散数学", 95, 0, 2001532452, 2018302110245, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs10 = new CourseScore("组合数学", 95, 0, 2001532453, 2018302110245, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs11 = new CourseScore("大学英语3", 95, 0, 2001532454, 2018302110245, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs12 = new CourseScore("操作系统", 95, 0, 2001532455, 2018302110245, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
CourseScore cs13 = new CourseScore("基础体育", 95, 0, 2001532456, 2018302110245, "专业必修", 3.0, "蒋老师", "计算机学院", 2018, true);
User user0 = new User(2018302110253, 2018, "123456", "123456", "蒋海澜", "计算机学院", "女", "计算机科学与技术", "", "");
User user1 = new User(2018302110245, 2018, "123456", "123456", "于宸欣", "计算机学院", "女", "计算机科学与技术", "", "");
user0.Add(user0);
user0.Add(user1);
cs0.addCourseScore(cs0);
cs0.addCourseScore(cs1);
cs0.addCourseScore(cs2);
cs0.addCourseScore(cs3);
cs0.addCourseScore(cs4);
cs0.addCourseScore(cs5);
cs0.addCourseScore(cs6);
cs0.addCourseScore(cs7);
cs0.addCourseScore(cs8);
cs0.addCourseScore(cs9);
cs0.addCourseScore(cs10);
cs0.addCourseScore(cs11);
cs0.addCourseScore(cs12);
cs0.addCourseScore(cs13);
co.Add(co);
co.Add(co1);
co.Add(co3);
;
}
//增加
public void addCourseScore(CourseScore co)
{
using (var db = new compusDB())
{
var courselist = db.CourseScore.Where(p => p.courseid == co.courseid).ToList();
var course = courselist.Where(p => p.userid == co.userid).FirstOrDefault();
if (course == null)
{
db.CourseScore.Add(co);
db.SaveChanges();
Console.WriteLine(teacherName);
}
else
{
Console.WriteLine("该数据已存在");
}
}
}