是否在数据表中使用其他条件？

我是MVC应用程序的新手。我无法在DataTable中使用if else条件。请解决我的问题。

让我向您解释我的关注。实际上，我在该表的SQL中有一个数据库表，我有一个列名“ STATUS”。现在我在此表中几乎没有记录。现在我想要的是，如果Status = 1则显示在DataTable中的“删除按钮”，或者如果Status = 2则不显示“删除”按钮。

让我与您分享我的代码。

        $(document).ready(function () {
        dataTable = $("#tableId").DataTable({
            "ajax": {
                "url": "/Home/GetAllPurchaseOrder",
                "type": "GET",
                "datatype": "json"
            },
            "columns": [
                { "data": "PurchaseID", "autowidth": true },
                { "data": "SupplierID", "autowidth": true },
                { "data": "SupplierName", "autowidth": true },
                { "data": "Currency", "autowidth": true },
                { "data": "TotalAmount", "autowidth": true },
                { "data": "Date_Of_Purchase", "autowidth": true },
                { "data": "Due_Date", "width": "56px" },
                {
                    "data": "PurchaseID", "width": "50px", "render": function (data) {
                        return '<button class="btn btn-danger DeletePurchase" onclick="Delete(' + data + ')">Delete</button>'
                    }

                },
                {
                    "data": "PurchaseID", "width": "50px", "render": function (data) {
                        return '<button class="btn btn-success ViewPurchase" onclick="Display(' + data + ')">View</button>'
                    }
                }
            ]
        });
    });

我分享给我

最新截图

控制器代码：

        [HttpGet]
    public ActionResult GetAllPurchaseOrder()
    {
        string loginId = Convert.ToString(Session["LoginId"]);
        try
        {
            List<PurchaseOrderViewModel> purchaseDetail = new List<PurchaseOrderViewModel>();
            if (!string.IsNullOrEmpty(loginId))
            {
                string UserRoleName = Convert.ToString(Session["UserTypeName"]);
                if (UserRoleName == RoleTypeConstant.CustomerUserType)
                {
                    purchaseDetail = _websiteRepo.GetAllPurchaseDetailByLoginId(loginId).ToList();
                    var stock = purchaseDetail;
                    return Json(new { data = stock }, JsonRequestBehavior.AllowGet);
                    //return View(stockDetail);
                }
                else
                {
                    return RedirectToAction("Login", "Account");
                }
            }
            else
            {
                return RedirectToAction("Login", "Account");
            }
        }
        catch (Exception)
        {
            throw;
        }
    }

        public IQueryable<PurchaseOrderViewModel> GetAllPurchaseDetailByLoginId(string LoginId)
    {
        var StockList = (from aspuser in context.AspNetUsers
                         join cus in context.Customers on aspuser.Id equals cus.LoginID
                         join purchase in context.PurchaseOrders on aspuser.Id equals purchase.LoginID
                         where purchase.LoginID == LoginId
                         select new PurchaseOrderViewModel
                         {
                             LoginID = purchase.LoginID,
                             PurchaseID = purchase.PurchaseID,
                             SupplierID = purchase.SupplierID,
                             SupplierName = purchase.SupplierName,
                             Currency = purchase.Currency,
                             TotalAmount = purchase.TotalAmount,
                             Date_Of_Purchase = purchase.Date_Of_Purchase,
                             Date_Arrived = purchase.Date_Arrived,
                             Date_Departed = purchase.Date_Departed,
                             Due_Date = purchase.Due_Date,
                             Location = purchase.Location,
                             Notes = purchase.Notes,
                             Status = purchase.Status
                         }).AsQueryable();
        return StockList;
    }

JAVASCRIPT：

    <script>
    var dataTable;
    $(document).ready(function () {
        debugger;
        dataTable = $("#tableId").DataTable({
            "ajax": {
                "url": "/Home/GetAllPurchaseOrder",
                "type": "GET",
                "datatype": "json"
            },
            "columns": [
                { "data": "PurchaseID", "autowidth": true },
                { "data": "SupplierID", "autowidth": true },
                { "data": "SupplierName", "autowidth": true },
                { "data": "Currency", "autowidth": true },
                { "data": "TotalAmount", "autowidth": true },
                { "data": "Date_Of_Purchase", "autowidth": true },
                { "data": "Due_Date", "width": "56px" },
                {
                    "data": "STATUS", "width": "50px", "render": function (data) {
                        return '<button class="btn btn-danger DeletePurchase' + ((data != 1) ? ' invisible' : 'visible') + '" onclick="Delete(' + data + ')">Delete</button>'
                    }

                },
                {
                    "data": "PurchaseID", "width": "50px", "render": function (data) {
                        return '<button class="btn btn-success ViewPurchase" onclick="Display(' + data + ')">View</button>'
                    }
                }
            ]
        });
    });