MVC Action直接在網頁上回傳Class to Json資料

MVC Action直接在網頁上回傳Class to Json資料

  1. [HttpGet]
  2. public JsonResult SampleAction()
  3. {
  4. UserData udata = new UserData();
  5. using (ssEntities ssDBContext = new ssEntities())
  6. {
  7. var query = from t1 in ssDBContext.UserData
  8. select t1;
  9. udata = query.FirstOrDefault();
  10. }
  11. /*
  12. 回傳是一個字串, 內容都是文字
  13. "{\"PKID\":1,\"UserName\":\"彼得\",\"UserName_Eng\":\"Peter\",\"Sex\":\"Male\",\"Birthday\":\"1980-04-04T00:00:00\",\"MobilePhoneNo\":\"0968123123\",\"Interest\":\"Movie\",\"DeleteDate\":null,\"DeleteUserID\":null,\"DeleteUserName\":null,\"InterestText\":null,\"BirthdayString\":null}"
  14. */
  15. string json = JsonConvert.SerializeObject(udata);
  16. return Json(json, JsonRequestBehavior.AllowGet);
  17. /*
  18. 回傳是Json格式, 沒有字串的雙引號包起來
  19. {
  20. "PKID": 1,
  21. "UserName": "彼得",
  22. "UserName_Eng": "Peter",
  23. "Sex": "Male",
  24. "Birthday": "/Date(323625600000)/",
  25. "MobilePhoneNo": "0968123123",
  26. "Interest": "Movie",
  27. "DeleteDate": null,
  28. "DeleteUserID": null,
  29. "DeleteUserName": null,
  30. "InterestText": null,
  31. "BirthdayString": null
  32. }
  33. */
  34. //return Json(udata, JsonRequestBehavior.AllowGet);
  35. }
  36. public class User
  37. {
  38. public int PKID { get; set; }
  39. public string UserName { get; set; }
  40. public string UserName_Eng { get; set; }
  41. public string Sex { get; set; }
  42. public DateTime Birthday { get; set; }
  43. public string MobilePhoneNo { get; set; }
  44. public string Interest { get; set; }
  45. public DateTime? DeleteDate { get; set; }
  46. public int? DeleteUserID { get; set; }
  47. public string DeleteUserName { get; set; }
  48. public string InterestText { get; set; }
  49. public string BirthdayString { get; set; }
  50. }

 

留言

這個網誌中的熱門文章

ORA-12514: TNS: 監聽器目前不知道連線描述區中要求的服務

Oracle 工作排程 DBMS_JOB 筆記

Oracle 例外控制(Exception Control)