/// <summary> /// 获得学段、科目、教材、教材版本 /// </summary> /// <param name="context"></param> public void GetPSTVData(HttpContext context) { try { Hashtable ht = new Hashtable(); ht.Add("func", "GetPSTVData"); //年级、科目 ht["Columns"] = "a.Id,b.Id as GradeID,b.Name,c.Id as SubjectID,c.Name as SubjectName"; ht["TableName"] = "Edu_Major_Sub_Rel a inner join Edu_MajorInfo b on a.MajorID=b.Id inner join Edu_SubJect c on a.SubID=c.Id"; result = "{"; //result += ","; JsonModel GradeOfSubject = com.GetData_NoVerification(ht); result += "\"GradeOfSubject\":" + jss.Serialize(GradeOfSubject); //教材版本 ht["Columns"] = "*"; ht["TableName"] = "Edu_BookVersion"; ht["Where"] = ""; JsonModel TextbookVersion = com.GetData_NoVerification(ht); result += ","; result += "\"TextbookVersion\":" + jss.Serialize(TextbookVersion); //教材 ht["Columns"] = "a.*,b.Name as VersionName"; ht["TableName"] = "Edu_Book a left join Edu_BookVersion b on a.VersionID=b.Id"; ht["Where"] = ""; JsonModel Textbook = com.GetData_NoVerification(ht); result += ","; result += "\"Textbook\":" + jss.Serialize(Textbook); result += "}"; } catch (Exception ex) { jsonModel = new JsonModel() { errNum = 400, errMsg = ex.Message, retData = "" }; LogService.WriteErrorLog(ex.Message); return; } }