清空剃須刀頁面檢查id是否存在

對于我自己的專案，我希望能夠洗掉提示文章，這是有效的。但我知道我有一個問題，它也會洗掉不存在的提示文章。有人知道如何解決這個問題嗎？

提示文章管理器中的代碼：

 *//Delete tip article in db
        public bool DeleteTipArticle(int articleNumber)
        {
                FillTipArticleList();
                return tipArticleDB.DeleteDb(articleNumber);          
        }*

資料庫中的代碼：

//Delete the tip article for the tiparticle database
        public bool DeleteDb(int articleNumber)
        {
            MySqlConnection connection = new MySqlConnection(databaseConnection);

            //Sql string for deleting the tip article
            string sql = "DELETE FROM tiparticle WHERE ArticleNumber = @ArticleNumber";

            MySqlCommand command = new MySqlCommand(sql, connection);
            command.Parameters.AddWithValue("@ArticleNumber", articleNumber);

            try
            {
                connection.Open();
                int amount = command.ExecuteNonQuery();
                return amount > 0;
            }
            catch (MySqlException ex)
            {
                return false;
            }
            catch (FormatException ex)
            {
                return false;
            }
            catch (NullReferenceException ex)
            {
                return false;
            }
            finally
            {
                if (connection.State == System.Data.ConnectionState.Open)
                {
                    connection.Close();
                }
            }
        }

剃刀頁面背后的代碼：

[Authorize(Roles = "admin")]
    public class DeleteTipArticleModel : PageModel
    {
        [BindProperty]
        public int articleNumber { get; set; }

        public void OnGet()
        {
        }
        public IActionResult OnPost()
        {
            if (ModelState.IsValid)
            {
                string message = "The tip article has been deleted!";
                ViewData["Message"] = message;

                TipArticleManager deleteToTipArticleDatabase = new TipArticleManager();
                deleteToTipArticleDatabase.DeleteTipArticle(articleNumber);

                return Page();
            }
            else
            {
                ViewData["Message"] = "Please enter all data fields";
                return Page();
            }
        }
    }

我認為我必須對回傳的金額> 0 做一些事情，但我不確定在哪里以及如何執行此操作。

uj5u.com熱心網友回復：

您可以檢查的回傳值bool succeeded = deleteToTipArticleDatabase.DeleteTipArticle(articleNumber);來檢查金額 > 0。

[Authorize(Roles = "admin")]
public class DeleteTipArticleModel : PageModel
{
    [BindProperty]
    public int articleNumber { get; set; }

    public void OnGet()
    {
    }
    public IActionResult OnPost()
    {
        if (ModelState.IsValid)
        {
            TipArticleManager deleteToTipArticleDatabase = new TipArticleManager();
            bool succeeded =   DeleteToTipArticleDatabase.DeleteTipArticle(articleNumber);
            if(succeeded)
            {         
                 string message = "The tip article has been deleted!";
                 ViewData["Message"] = message;
            }
            return Page();
        }
        else
        {
            ViewData["Message"] = "Please enter all data fields";
            return Page();
        }
    }
}

否則，您可以對文章編號進行資料庫呼叫，以查看它是否已經存在。

標籤：C＃ 数据库 剃刀

上一篇：基于會話變數在MySQL中正確使用If/else條件

下一篇：當first_name列為空時，sql查詢將值從second_names列移動到first_name列