예제 #1
0
 public ActionResult Edit(Student student)
 {
     if (ModelState.IsValid)
     {
         Db.Entry(student).State = EntityState.Modified;
         Db.SaveChanges();
         return RedirectToAction("Index");
     }
     return View(student);
 }
예제 #2
0
        public ActionResult Create(Student student)
        {
            if (ModelState.IsValid)
            {
                Db.Students.Add(student);
                Db.SaveChanges();
                return RedirectToAction("Index");
            }

            return View(student);
        }
예제 #3
0
        public virtual List<Student> AnalysisExcelToStudent(string filePath, ref string errorInfo)
        {
            var dataTable = NPOIHelper.Import(filePath);
            var resultList = new List<Student>();
            for (var i = 1; i < dataTable.Rows.Count; i++)
            {
                var name = dataTable.Rows[i][0].ToString();
                var sex = dataTable.Rows[i][1].ToString();
                var nation = dataTable.Rows[i][2].ToString();
                var department = dataTable.Rows[i][3].ToString();
                var grade = dataTable.Rows[i][4].ToString();
                var classabb = dataTable.Rows[i][5].ToString();
                var id = dataTable.Rows[i][6].ToString();
                var idcard = dataTable.Rows[i][7].ToString();
                var dormnum = dataTable.Rows[i][8].ToString();
                var ydtel = dataTable.Rows[i][9].ToString();
                var dxtel = dataTable.Rows[i][10].ToString();
                var lttel = dataTable.Rows[i][11].ToString();
                var province = dataTable.Rows[i][12].ToString();
                var city = dataTable.Rows[i][13].ToString();
                var address = dataTable.Rows[i][14].ToString();
                var teachername = dataTable.Rows[i][15].ToString();
                var teachertel = dataTable.Rows[i][16].ToString();
                var fathername = dataTable.Rows[i][17].ToString();
                var fathertel = dataTable.Rows[i][18].ToString();
                var mothertel = dataTable.Rows[i][19].ToString();
                var mothername = dataTable.Rows[i][20].ToString();

                if (String.IsNullOrEmpty(classabb) || String.IsNullOrEmpty(id))
                {
                    continue;
                }
                var classInfo = ClassInfoDao.GetClassInfoByAbbreviation(classabb);
                if (classInfo == null)
                {
                    if (!ClassInfoDao.AddClass(classabb, teachername))
                    {
                        errorInfo += "第" + i + "条数据班级不存在 ";
                        return null;
                    }
                }
                var student = new Student()
                {
                    Name = name,
                    Sex = sex,
                    Nation = nation,
                    ClassInfo = classInfo,
                    Id = id,
                    IdCard = idcard,
                    DormInfo = DormInfoDao.GetDormInfoByNum(dormnum),
                    YdTel = ydtel,
                    DxTel = dxtel,
                    LtTel = lttel,
                    Province = province,
                    City = city,
                    Address = address,
                    TeacherName = teachername,
                    TeacherTel = teachertel,
                    FatherName = fathername,
                    FatherTel = fathertel,
                    MotherName = mothername,
                    MotherTel = mothertel
                };
                if (Db.Students.FirstOrDefault(u => u.Id == student.Id) == null && resultList.FirstOrDefault(u => u.Id == student.Id) == null)
                {
                    resultList.Add(student);
                }
                else
                {
                    errorInfo = "第" + i + "条数据已存在";
                    return null;
                }
            }
            return resultList;
        }