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");
}
}