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