public void addStudent()
        {
            try
            {
                Student student = new Student();
                setValue(student, context);

                HttpPostedFile hpf = context.Request.Files["headImgFile"];
                if (hpf != null)
                {
                    string serverPath = "/uploadFile/headImg/" + System.DateTime.Now.Ticks + "." + hpf.FileName.Split('.')[1];
                    string savePath = context.Server.MapPath(serverPath);//路径,相对于服务器当前的路径
                    hpf.SaveAs(savePath);//保存
                    student.HeadImage = serverPath;
                }
                string FacultyID = context.Request.Form.Get("Faculty");
                DepartmentService ds = new DepartmentService();
                string professionID = context.Request.Form.Get("Profession");
                if (!string.IsNullOrEmpty(professionID))
                {
                    Profession profession = ds.getProfessionByID(professionID);
                    if (profession != null)
                        student.Profession = profession;
                }

                string ClassGradeID = context.Request.Form.Get("ClassGrade");
                if (!string.IsNullOrEmpty(ClassGradeID))
                {
                    ClassGrade classGrade = ds.getClassGradeByID(ClassGradeID);
                    if (classGrade != null)
                        student.ClassGrade = classGrade;
                }
                StudentService s = new StudentService();
                student.Password = student.Sn;
                s.save(student);

                context.Response.Write("1");
            }
            catch (Exception e)
            {
                context.Response.Write("0");
            }
        }
        public void getColumn()
        {
            DepartmentService ds = new DepartmentService();
            IList professionList = new ArrayList();
            string ProfessionID = context.Request.Form.Get("ProfessionID");
            string YearNo = context.Request.Form.Get("YearNo");
            string LevelNo = context.Request.Form.Get("LevelNo");
            if (!string.IsNullOrEmpty(ProfessionID))
            {
                Profession profession = ds.getProfessionByID(ProfessionID);
                professionList.Add(profession);
            }
            PlanService ps = new PlanService();
            object[] planObjArr = ps.searchPlan(professionList, YearNo, LevelNo,
            int.MaxValue, 1);
            if (planObjArr[1] != null)
            {
                IList<ExamPlan> examPlanList = (IList<ExamPlan>)planObjArr[1];
                if (examPlanList == null) return;
                ExamPlan ep = examPlanList.ElementAt(0);
                ArrayList newArrayList = new ArrayList();
                if (examPlanList.ElementAt(0).CouresSet == null) return;
                foreach (Coures c in examPlanList.ElementAt(0).CouresSet)
                {
                    newArrayList.Add(c.Name);
                }
                newArrayList.Sort();

                IList<Hashtable> columnList = new List<Hashtable>();
                foreach (string s in newArrayList) {
                    Hashtable ht = new Hashtable();
                    ht.Add("columnName",s);
                    columnList.Add(ht);
                }
                String json = JsonConvert.SerializeObject(columnList);
                context.Response.Write(json);

            }
        }
        private void searchExamResult()
        {
            DepartmentService ds = new DepartmentService();
            IList professionList = new ArrayList();
            string ProfessionID = context.Request.Form.Get("ProfessionID");
            string YearNo = context.Request.Form.Get("YearNo");
            string LevelNo = context.Request.Form.Get("LevelNo");
            if (!string.IsNullOrEmpty(ProfessionID))
            {
                Profession profession = ds.getProfessionByID(ProfessionID);
                professionList.Add(profession);
            }
            PlanService ps = new PlanService();
            object[] planObjArr = ps.searchPlan(professionList, YearNo, LevelNo,
            int.MaxValue, 1);
            if (planObjArr[1] != null)
            {
                IList<ExamPlan> examPlanList = (IList<ExamPlan>)planObjArr[1];
                if (examPlanList == null || examPlanList.Count == 0) return;
                ExamResultService ers = new ExamResultService();
                IList<ExamPlan> planList = new List<ExamPlan>();
                planList.Add(examPlanList[0]);
                object[] examResultObjArr = ers.searchExamResult(planList, int.MaxValue, 1);
                if (examResultObjArr[1] != null)
                {
                    IList<ExamResult> examResultList = (IList<ExamResult>)examResultObjArr[1];
                    IList<Hashtable> examRsultMapList = new List<Hashtable>();
                    foreach (ExamResult er in examResultList)
                    {
                        Hashtable cht = new Hashtable();
                        cht.Add("Id", er.Id);
                        cht.Add("StudentSN", er.StudentSN);
                        cht.Add("StudentName", er.StudentName);
                        cht.Add("ExamPlanName", er.ExamPlanName);

                        if (er.CouresScoreMap != null)
                        {
                            ArrayList newArrayList = new ArrayList();
                            foreach (Coures c in planList.ElementAt(0).CouresSet)
                            {
                                newArrayList.Add(c.Name);
                            }
                            newArrayList.Sort();
                            foreach (string key in newArrayList)
                            {
                                if (er.CouresScoreMap.ContainsKey(key)) {
                                    cht.Add(key, er.CouresScoreMap[key]);
                                }

                            }
                        }
                        examRsultMapList.Add(cht);
                    }
                    Hashtable ht = new Hashtable();
                    ht.Add("total", examResultObjArr[0]);
                    ht.Add("rows", examRsultMapList);
                    String json = JsonConvert.SerializeObject(ht);
                    context.Response.Write(json);
                }
            }
        }
        public void updateStudent()
        {
            try
            {
                Student student = new Student();
                setValue(student, context);

                HttpPostedFile hpf = context.Request.Files["headImgFile"];
                if (hpf != null) {
                    string savepath = context.Server.MapPath("/uploadFile/headImg/" + student.Id + "." + hpf.GetType());//路径,相对于服务器当前的路径
                    hpf.SaveAs(savepath);//保存
                    student.HeadImage = savepath;
                }

                DepartmentService ds = new DepartmentService();
                string professionID = context.Request.Form.Get("Profession");
                if (!string.IsNullOrEmpty(professionID)) {
                    Profession profession = ds.getProfessionByID(professionID);
                    if (profession != null)
                        student.Profession = profession;
                }

                string ClassGradeID = context.Request.Form.Get("ClassGrade");
                if (!string.IsNullOrEmpty(ClassGradeID)) {
                    ClassGrade classGrade = ds.getClassGradeByID(ClassGradeID);
                    if (classGrade != null)
                        student.ClassGrade = classGrade;
                }

                StudentService s = new StudentService();
                s.save(student);
                context.Response.Write("1");
            }
            catch (Exception e)
            {
                context.Response.Write("0");
            }
        }
        public void getStudents()
        {
            try
            {
                StudentService service = new StudentService();
                Student student = new Student();
                setValue(student, context);

                string ProfessionID = context.Request.Form.Get("FacultyID");
                string FacultyID = context.Request.Form.Get("ProfessionID");

                IList<Profession> professionList = new List<Profession>();
                DepartmentService ds = new DepartmentService();
                if (!string.IsNullOrEmpty(ProfessionID)) {
                   Profession profession = ds.getProfessionByID(ProfessionID);
                   if (profession != null) professionList.Add(profession);
                }
                else if (!string.IsNullOrEmpty(FacultyID)) {
                    Faculty faculty = ds.getFacultyByID(FacultyID);
                    if (faculty != null && faculty.professionList != null)
                        foreach (Profession p in faculty.professionList)
                            professionList.Add(p);
                }

                student.ProfessionList = professionList;
                int rows = Convert.ToInt32(context.Request.Form["rows"]);
                int page = Convert.ToInt32(context.Request.Form["page"]);
                object[] data = service.getStudentList(student, rows, page);
                Hashtable ht = new Hashtable();
                ht.Add("total", data[0]);
                ht.Add("rows", data[1]);
                String json = JsonConvert.SerializeObject(ht);
                context.Response.Write(json);
            }
            catch (Exception e)
            {

            }
        }
 private void searchCoures()
 {
     System.Collections.IList professionList = new ArrayList();
     string FacultyID = context.Request.Form.Get("FacultyID");
     string ProfessionID = context.Request.Form.Get("ProfessionID");
     string YearNo = context.Request.Form.Get("YearNo");
     string LevelNo = context.Request.Form.Get("LevelNo");
     if (!string.IsNullOrEmpty(ProfessionID)) {
         DepartmentService ds = new DepartmentService();
         Profession p = ds.getProfessionByID(ProfessionID);
         professionList.Add(p);
     }else if(!string.IsNullOrEmpty(FacultyID)){
        DepartmentService ds = new DepartmentService();
        Iesi.Collections.Generic.ISet<Profession> iset = ds.getProfessionSet(FacultyID);
         foreach(Profession pf in iset){
            professionList.Add(pf);
        }
     }
     CouresService cs = new CouresService();
     int rows = Convert.ToInt32(context.Request.Form["rows"]);
     int page = Convert.ToInt32(context.Request.Form["page"]);
     object[] data = cs.searchCoures(professionList, YearNo, LevelNo, rows, page);
     Hashtable ht = new Hashtable();
     ht.Add("total", data[0]);
     ht.Add("rows", data[1]);
     String json = JsonConvert.SerializeObject(ht);
     context.Response.Write(json);
 }
 private void saveCoures()
 {
     try
     {
         string professionID = context.Request.Form.Get("profession");
         DepartmentService ds = new DepartmentService();
         Profession profession = ds.getProfessionByID(professionID);
         if (profession != null)
         {
             Coures c = new Coures();
             setValue(c, context);
             c.Profession = profession;
             ds.save(c);
             context.Response.Write("1");
         }
     }
     catch (Exception e) {
         context.Response.Write("0");
     }
 }
        private void searchPlan()
        {
            try
            {
                PlanService planService = new PlanService();
                DepartmentService ds = new DepartmentService();
                IList professionList = new ArrayList();
                string ProfessionID = context.Request.Form.Get("ProfessionID");
                string YearNo = context.Request.Form.Get("YearNo");
                string LevelNo = context.Request.Form.Get("LevelNo");
                if (!string.IsNullOrEmpty(ProfessionID)) {
                    Profession profession = ds.getProfessionByID(ProfessionID);
                    professionList.Add(profession);
                }

                int rows = Convert.ToInt32(context.Request.Form["rows"]);
                int page = Convert.ToInt32(context.Request.Form["page"]);
                object[] data = planService.searchPlan(professionList, YearNo, LevelNo, rows, page);
                Hashtable ht = new Hashtable();
                ht.Add("total", data[0]);
                ht.Add("rows", data[1]);
                String json = JsonConvert.SerializeObject(ht);
                context.Response.Write(json);
            }
            catch (Exception e) {
                context.Response.Write("0");
            }
        }
        private void saveCoures()
        {
            try
            {
                string ProfessionID = context.Request.Form.Get("Profession");
                string FacultyID = context.Request.Form.Get("Faculty");

                DepartmentService ds = new DepartmentService();
                Profession profession = ds.getProfessionByID(ProfessionID);
                Faculty faculty = ds.getFacultyByID(FacultyID);
                if (profession != null && faculty != null)
                {
                    ISet<Coures> couresSet = new HashedSet<Coures>();
                    string[] couresArr = context.Request.Form.GetValues("Coures");
                    CouresService cs = new CouresService();
                    foreach (string c in couresArr) {
                       Coures coures = cs.getCouresByID(c);
                       if (coures != null)
                       couresSet.Add(coures);
                    }

                    ExamPlan p = new ExamPlan();
                    setValue(p, context);
                    p.Profession = profession;
                    p.Faculty = faculty;
                    p.CouresSet = couresSet;
                    PlanService ps = new PlanService();
                    ps.save(p);
                    context.Response.Write("1");
                }
            }
            catch (Exception e)
            {
                context.Response.Write("0");
            }
        }