.Net Core Web Api_筆記15_api結合ADO.NET資料庫操作part3_資料刪除
我們在上一篇的Show.html
已經完成了資料查詢呈現
這裡要多出操作(比方像是編輯、刪除...)
先撰寫好刪除的action method
刪除很單純就是針對id作條件式指定的HttpDelete操作
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | [HttpDelete("Delete")] public ActionResult<int> DeleteNewsType(int? id) { if(id == null) { return NotFound(); } string strSQL = @"delete from NewsType where NewsTypeId=@Id"; Hashtable htParms = new Hashtable(); htParms.Add("@Id", id); int RowCount = MSSQLHelper.ExecuteNonQuery(strSQL, htParms); return RowCount; } |
在Show.html下我們可以擴充一個欄位呈現刪除的操作
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 | <!DOCTYPE html> <html> <head> <meta charset="utf-8" /> <title>Show NewsType</title> <link href="../css/bootstrap.min.css" rel="stylesheet" /> <script src="../js/jquery/jquery.min.js"></script> </head> <body style="margin:20px;"> <table id="tbNewsType" class="table table-bordered"> <thead> <tr> <td>文章ID</td> <td>分類</td> <td>是否啟用</td> <td>刪除</td> </tr> </thead> <tbody> </tbody> </table> <script type="text/javascript"> $(function () { var tbody = $('#tbNewsType tbody') $.ajax({ type: 'get', url: '/api/NewsType/Show', dataType: 'json', success: function (result) { $.each(result, function (n, value) { var IsEnabled; value.isEnabled ? IsEnabled = '啟用' : IsEnabled = '關閉'; var tr_val = ""; tr_val += "<tr><td>" + value.newsTypeId + "</td><td>" + value.newsTypeName + "</td><td>" + IsEnabled + "</td><td><a href='javascript:Del(" + value.newsTypeId + ")'>刪除</a>" + "</td></tr>"; tbody += tr_val; }); $('#tbNewsType').append(tbody); } }); }); function Del(id) { $.ajax({ type: "delete", url: "/api/newstype/delete?id=" + id, dataType: "json", success: function (result) { if (result != "0") { location.href = "Show.html"; } } }); } </script> </body> </html> |
留言
張貼留言