js数组传入后台处理方法。

js代码  
  function savePrivileges() {
        var Privileges = []
        var Role = $('#selectRole').val();
        $("input:checked").each(function (i) {
            Privileges.push($(this).attr("id")) 
        });
  
            $.ajax({
                type: 'POST',
                url: '@Url.Action("savePrivileges")',
                //contentType: "application/json; charset=utf-8",
                data: {
                    Privileges: JSON.stringify(Privileges),
                    Role:Role,
                },
                async: false,

                //dataType: "json",
                success: function (data) {
                    alert('保存成功！')
                },
                error: function (message) {
                    // alert(message);
                }
            });
    }

MVC controller
       
 public JsonResult savePrivileges(UserModel um)
        {
            int result = com.canmax.DAL.User.savePrivileges(um);
            return Json(result);
        }

 

DAL 层
        public static int savePrivileges(UserModel um)
        {
            string sql = string.Format("DELETE FROM Privileges WHERE Role = '{0}' ;", um.Role);

            var objects = JArray.Parse(um.Privileges);
            foreach (var x in objects)
            {
                sql += string.Format(@"INSERT INTO Privileges ( Role,Privileges,CreateDate )
                                           VALUES ('{0}','{1}', now()) ; ", um.Role, x);
            }

            MySqlParameter[] sqlParameter = new MySqlParameter[] {
                //new MySqlParameter("Role",um.Role),
                //new MySqlParameter("Privileges",um.Privileges), 
            };

            int result =   MySqlHelper_.ExecuteNonQuery(sql, sqlParameter);

            return result;
        }

 

 

Models
 
   public class UserModel  
    {
        public string UserCode { get; set; }
        public string UserName { get; set; }
        public string Password { get; set; }
        public string Role { get; set; }
        public string Privileges { get; set; }
    }