c# - 试图将json值从视图传递到控制器

Question

我正在尝试CloseCase从 cshtml 页面以操作方法传递数据，并希望在控制器的操作端传递一个值数组。但我收到错误消息。我是 asp.net mvc 的新手，所以我不能说我的方法是否正确。

从 ajax 传递值时，它在CloseCase方法中显示空值。我想获得command.Parameters.Add(":ICD_CASE_ID", casedetail[0]);均值casedetail[0]，但在调试时我发现方法 CloseCase 空值的值。任何想法将不胜感激。

.cshtml

$(".btnrowvalue2").click(function () {
            //var casedetails = new Array();
            var tr = $(this).closest('tr');
            var casedetail={};
            var casedetails=[];
            casedetail["FirstCol"] = tr.find('input[name="Chkb"]').val();
            casedetail["SecondCol"] = tr.find('input[name="CaseId"]').val();
            casedetail["ThirdCol"] = tr.find('input[name="Desc"]').val();
            casedetail["FourthCol"] = tr.find('input[name="NBill"]').val();
            casedetail["FifthCol"] = tr.find('input[name="TAmnt"]').val();
            casedetail["SixthCol"] = tr.find('input[name="Stat"]').val();
            casedetail["SeventhCol"] = tr.find('input[name="Cron"]').val();
            casedetail["EightCol"] = tr.find('input[name="Clon"]').val();
            casedetails.push(casedetail);
            //alert('Type1 : ' + FirstCol + ' ' + SecondCol + ' ' + ThirdCol);
            $.ajax({
                type:"POST",
                url:"/Home/CloseCase",
                data:JSON.stringify(casedetails),
                contentType:"application/json; charset=utf-8",
            datatype:"json",
            success:function(r){
                alert(r + " record(s) inserted.");
            }
            });
        });

控制器端

 public JsonResult CloseCase(List<Ipcell> casedetail)
        {            
          
            try
            {
                conn.Open();
                string qry = "UPDATE ASE_S SET ICD_STATUS='O',ICD_CLOSED_ON=:ICD_CLOSED_ON,ICD_CLOSED_BY=:ICD_CLOSED_BY WHERE ICD_CASE_ID =:ICD_CASE_ID";
                OracleCommand command = new OracleCommand(qry, conn);
                command.Parameters.Add(":ICD_CLOSED_ON", DateTime.Now);
                command.Parameters.Add(":ICD_CLOSED_BY", Session[CommonConstants.SESSION_USER_ID]);
                command.Parameters.Add(":ICD_CASE_ID", casedetail[0]);
               int insertedRecords=command.ExecuteNonQuery();
                return Json(insertedRecords);
            }
            catch (Exception ex)
            {

            }
            finally
            {
                conn.Close();
            }
            return null;
        }

模型类

public class Ipcell
    {        
        public string CaseId { get; set; }
        public string Descripton { get; set; }
        public int NoOfBill { get; set; }
        public decimal TotalAmount { get; set; }
        public DateTime From { get; set; }
        public DateTime To { get; set; }
        public string Type { get; set; }
        public string Status { get; set; }
        public DateTime CreatedOn { get; set; }
        public DateTime ClosedOn { get; set; }
    }

标签： c#jqueryasp.netajaxasp.net-mvc

Answer 1

我检查了你的代码，我发现了问题

检查我的屏幕截图并实现它对我有用。

阿贾克斯调用

var casedetail = {};
    var casedetails = [];
    var date = new Date();
    casedetail["CaseId"] = "1";
    casedetail["Descripton"] = "2";
    casedetail["NoOfBill"] = "3";
    casedetail["TotalAmount"] = "4";
    //casedetail["From"] = date.toISOString();
    //casedetail["To"] = date.toISOString();
    casedetail["Type"] = "7";
    casedetail["Status"] = "8";
    //casedetail["CreatedOn"] = date.toISOString();
    //casedetail["ClosedOn"] = date.toISOString();
    casedetails.push(casedetail);
    $.ajax({
        type: "POST",
        url: "../Home/CloseCase",
        data: JSON.stringify(casedetails),
        contentType: "application/json; charset=utf-8",
        datatype: "json",
        success: function (r) {
            alert(r + " record(s) inserted.");
        }
    });

代码

public JsonResult CloseCase(List<Ipcell> casedetail)
        {

            try
            {
                return Json(new { },JsonRequestBehavior.AllowGet);
            }
            catch (Exception ex)
            {

            }
            finally
            {
            }
            return Json(new { }, JsonRequestBehavior.AllowGet);
        }

        public class Ipcell
        {
            public string CaseId { get; set; }
            public string Descripton { get; set; }
            public int NoOfBill { get; set; }
            public decimal TotalAmount { get; set; }
            public DateTime From { get; set; }
            public DateTime To { get; set; }
            public string Type { get; set; }
            public string Status { get; set; }
            public DateTime CreatedOn { get; set; }
            public DateTime ClosedOn { get; set; }
        }