コード例 #1
0
 // GET: Student/Edit/5
 public ActionResult Edit(string id)
 {
     if (id == null)
     {
         return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
     }
     ViewModel.StudentsModel studend_Info = (from stus in db.Student_Infos
                                             where stus.stu_id == id
                                             select new ViewModel.StudentsModel
     {
         address = stus.stu_home_address,
         birthday = stus.stu_birthday,
         cardType = stus.stu_card_type,
         email = stus.stu_email,
         grade = stus.stu_grade_id,
         id = stus.stu_id,
         IdCard = stus.stu_idCard,
         name = stus.stu_name,
         phone = stus.stu_phone,
         photo = stus.stu_photo_path,
         school = stus.stu_school_id,
         sex = stus.stu_sex
     }).FirstOrDefault();
     if (studend_Info == null)
     {
         //return HttpNotFound();
         ViewBag.msg = "没有查到该学生信息,可能已被删除。";
     }
     CreateSelect();
     return(View(studend_Info));
 }
コード例 #2
0
        public ActionResult Edit([Bind(Include = "id,name,sex,birthday,photo,phone,email,school,grade,address,cardType,IdCard")] ViewModel.StudentsModel StudentsModel)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    Student_Info student_info = db.Student_Infos.Find(StudentsModel.id);
                    if (student_info == null)
                    {
                        ViewBag.msg = "没有查到该学生信息,可能已被删除。";
                        CreateSelect();
                        return(View(StudentsModel));
                    }
                    if (db.Student_Infos.Where(x => x.stu_id != StudentsModel.id && x.stu_card_type == StudentsModel.cardType && x.stu_idCard == StudentsModel.IdCard).Count() > 0)
                    {
                        ViewBag.msg = "该证件号已存在,请勿重新添加。";
                        CreateSelect();
                        return(View(StudentsModel));
                    }
                    student_info.stu_id           = StudentsModel.id;
                    student_info.stu_card_type    = StudentsModel.cardType;
                    student_info.stu_idCard       = PageValidate.InputText(StudentsModel.IdCard, 18);
                    student_info.stu_birthday     = StudentsModel.birthday;
                    student_info.stu_email        = PageValidate.InputText(StudentsModel.email, 200);
                    student_info.stu_grade_id     = StudentsModel.grade;
                    student_info.stu_home_address = PageValidate.InputText(StudentsModel.address, 500);
                    student_info.stu_name         = PageValidate.InputText(StudentsModel.name, 50);
                    student_info.stu_phone        = PageValidate.InputText(StudentsModel.phone, 20);
                    student_info.stu_school_id    = StudentsModel.school;
                    student_info.stu_sex          = PageValidate.InputText(StudentsModel.sex, 2);

                    string up_photo = PageValidate.InputText(StudentsModel.photo, 50);
                    if (up_photo != student_info.stu_photo_path)
                    {
                        string   file_name = string.Format("{0}.jpg", student_info.stu_idCard);
                        string   save_name = string.Format(Server.MapPath(string.Format("~/images/stu/{0}", file_name)));
                        string   old_path  = string.Format(Server.MapPath(string.Format("~/images/temp/{0}", up_photo)));
                        FileInfo fi        = new FileInfo(old_path);
                        fi.CopyTo(save_name, true);
                        student_info.stu_photo_path = file_name;
                    }

                    db.Entry(student_info).State = EntityState.Modified;
                    db.SaveChanges();
                    DataCache.RemoveCache("cache_student");
                }
                catch (Exception e)
                {
                    ViewBag.msg = e.ToString();
                    CreateSelect();
                    return(View(StudentsModel));
                }
            }
            return(RedirectToAction("ViewList"));
        }
コード例 #3
0
        public ActionResult Create([Bind(Include = "name,sex,birthday,photo,phone,email,school,grade,address,cardType,IdCard")] ViewModel.StudentsModel StudentsModel)
        {
            if (ModelState.IsValid)
            {
                if (db.Student_Infos.Where(x => x.stu_card_type == StudentsModel.cardType && x.stu_idCard == StudentsModel.IdCard).Count() > 0)
                {
                    ViewBag.msg = "该证件号已存在,请勿重新添加。";
                    CreateSelect();
                    return(View(StudentsModel));
                }
                Student_Info student_info = new Student_Info();
                student_info.stu_card_type    = StudentsModel.cardType;
                student_info.stu_idCard       = PageValidate.InputText(StudentsModel.IdCard, 18);
                student_info.stu_birthday     = StudentsModel.birthday;
                student_info.stu_email        = PageValidate.InputText(StudentsModel.email, 200);
                student_info.stu_grade_id     = StudentsModel.grade;
                student_info.stu_home_address = PageValidate.InputText(StudentsModel.address, 500);
                student_info.stu_name         = PageValidate.InputText(StudentsModel.name, 50);
                student_info.stu_phone        = PageValidate.InputText(StudentsModel.phone, 20);
                student_info.stu_photo_path   = PageValidate.InputText(StudentsModel.photo, 50);
                student_info.stu_school_id    = StudentsModel.school;
                student_info.stu_sex          = PageValidate.InputText(StudentsModel.sex, 2);

                string up_photo = PageValidate.InputText(StudentsModel.photo, 50);
                if (!string.IsNullOrEmpty(up_photo))
                {
                    string   file_name = string.Format("{0}.jpg", student_info.stu_idCard);
                    string   save_name = string.Format(Server.MapPath(string.Format("~/images/stu/{0}", file_name)));
                    string   old_path  = string.Format(Server.MapPath(string.Format("~/images/temp/{0}", up_photo)));
                    FileInfo fi        = new FileInfo(old_path);
                    fi.CopyTo(save_name, true);
                    student_info.stu_photo_path = file_name;
                }
                if (db.Student_Infos.Count() == 0)
                {
                    student_info.stu_id = DateTime.Now.ToString("yyyy") + "100001";
                }
                else
                {
                    string strNum = db.Student_Infos.OrderByDescending(x => x.stu_id).First().stu_id.Substring(4, 6);
                    int    Num    = Int32.Parse(strNum) + 1;
                    student_info.stu_id = DateTime.Now.ToString("yyyy") + Num.ToString();
                }
                db.Student_Infos.Add(student_info);
                db.SaveChanges();
                ViewBag.msg = "添加成功。";
                DataCache.RemoveCache("cache_student");
                //return RedirectToAction("Index");
            }
            CreateSelect();
            return(View(StudentsModel));
        }
コード例 #4
0
 // GET: Student/Create
 public ActionResult Create()
 {
     CreateSelect();
     ViewModel.StudentsModel model = new ViewModel.StudentsModel();
     return(View(model));
 }
コード例 #5
0
        // GET: Student/Details/5
        public ActionResult Details(string id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ViewModel.StudentDetail detail       = new ViewModel.StudentDetail();
            ViewModel.StudentsModel student_Info = (from stus in db.Student_Infos
                                                    join school in db.Dic_Schools
                                                    on stus.stu_school_id equals school.school_id into T1
                                                    from t1 in T1.DefaultIfEmpty()
                                                    join grade in db.Dic_Grades
                                                    on stus.stu_grade_id equals grade.grade_id into T2
                                                    from t2 in T2.DefaultIfEmpty()
                                                    where stus.stu_id == id
                                                    select new ViewModel.StudentsModel
            {
                address = stus.stu_home_address,
                birthday = stus.stu_birthday,
                cardType = stus.stu_card_type,
                email = stus.stu_email,
                grade = stus.stu_grade_id,
                id = stus.stu_id,
                IdCard = stus.stu_idCard,
                name = stus.stu_name,
                phone = stus.stu_phone,
                photo = stus.stu_photo_path,
                school = stus.stu_school_id,
                sex = stus.stu_sex,
                school_name = t1.school_name == null ? "" : t1.school_name,
                grade_name = t2.grade_name == null ? "" : t2.grade_name
            }).FirstOrDefault();
            if (student_Info == null)
            {
                ViewBag.msg = "没有找到学生信息。";
                return(View(student_Info));
            }
            detail.student_Info = student_Info;
            var stu_courses = from svc in db.Student_vs_Courses
                              join course in db.Course_Infos
                              on svc.svc_course_id equals course.course_id
                              join sub in db.Dic_Subjects
                              on course.c_sub_id equals sub.sub_id
                              join season in db.Course_Seasons
                              on course.c_cs_id equals season.c_season_id
                              where svc.svc_stu_id == id
                              orderby svc.svc_add_time
                              select new ViewModel.StudnentCourse
            {
                student     = id,
                course      = svc.svc_course_id,
                course_name = course.course_name,
                season      = season.c_season_name,
                state       = svc.svc_is_end ? "完结" : "进行中",
                subject     = sub.sub_name,
                time        = course.c_time_info
            };

            detail.stu_courses = stu_courses.ToList();
            return(View(detail));
        }