/// <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;
}
}
