后台代码如下:
string sql = @"select sd.TopicNum,sd.Result from StoreSurvey_SurveyDetail201608 sd
inner join StoreSurvey_SurveyRecord201608 sr on sr.ID=sd.SurveyID
where UserAccount={0}";
List<EntitySurveyResult> ess = db.ExecuteQuery<EntitySurveyResult>(sql, userAccount).ToList();
if (ess.Count > 0)
{
var resJsonObj = new
{
status = "S",
SurveyResult = ess
};
context.Response.Write(JsonConvert.SerializeObject(resJsonObj));
}
else
{
var resJsonObj = new
{
status = "F",
message = "获取失败"
};
context.Response.Write(JsonConvert.SerializeObject(resJsonObj));
}
前台获取处理如下:
success: function (result) {
var resultData = eval("(" + result + ")");
if (resultData.status == "F") {
...
} else {
...
}
},