Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. {
  2. "category":"Homepage",
  3. "subject":"TEST",
  4. "content":"<p>TEST 'EQULAS" Common he's mine</p>",
  5. "publish":"0",
  6. "userName":"testname"
  7. }
  8.  
  9. + [0] {[category, Homepage]} System.Collections.Generic.KeyValuePair<string,object>
  10. + [1] {[subject, TEST]} System.Collections.Generic.KeyValuePair<string,object>
  11. + [2] {[content, <p>TEST 'EQULAS" Common he's mine</p>]}
  12. + [3] {[publish, 0]} System.Collections.Generic.KeyValuePair<string,object>
  13. + [4] {[userName, dmjung]} System.Collections.Generic.KeyValuePair<string,object>
  14.  
  15. public Boolean Create(dynamic Forms)
  16. {
  17. Boolean result = false;
  18.  
  19. string query = String.Format(@"
  20. INSERT INTO UPDATE_HISTORY (
  21. CATEGORY
  22. ,SUBJECT
  23. ,CONTENT
  24. ,PUBLISH
  25. ,USERNAME
  26. ,REGUSER
  27. ,REGDATE
  28. ,UPDUSER
  29. ,UPDDATE
  30. ) VALUES (
  31. '{0}'
  32. ,'{1}'
  33. ,'{2}'
  34. ,{3}
  35. ,'{4}'
  36. ,'{4}'
  37. ,NOW()
  38. ,'{4}'
  39. ,NOW()
  40. )
  41. ", Forms["category"]
  42. , Forms["subject"]
  43. , Forms["content"]
  44. , Forms["publish"]
  45. , Forms["userName"]);
  46.  
  47. .
  48. .
  49. .
  50. .
  51.  
  52. INSERT INTO UPDATE_HISTORY (
  53. CATEGORY
  54. ,SUBJECT
  55. ,CONTENT
  56. ,PUBLISH
  57. ,USERNAME
  58. ,REGUSER
  59. ,REGDATE
  60. ,UPDUSER
  61. ,UPDDATE
  62. ) VALUES (
  63. 'Homepage'
  64. ,'TEST'
  65. ,'<p>TEST 'EQULAS" Common he's mine</p>
  66. ,0
  67. ,'dmjung'
  68. ,'dmjung'
  69. ,NOW()
  70. ,'dmjung'
  71. ,NOW()
  72. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement