首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >删除Jqgrid中的ID始终为0

删除Jqgrid中的ID始终为0
EN

Stack Overflow用户
提问于 2013-06-17 10:06:35
回答 1查看 533关注 0票数 0

JqGrid编辑功能在我的网格中运行良好,但删除函数总是将记录id传递为0。

代码语言:javascript
复制
@model Shop.Models.ShopModels.lstMainCategory
<table id="list" class="scroll" cellpadding="0" cellspacing="0"></table>
    <div id="pager" class="scroll" style="text-align:center;"></div>                                                            

    <script type="text/javascript">

        var myGrid = $('#list');
        $(document).ready(function () {

            $.jgrid.nav.addtext = "Add";
            $.jgrid.nav.edittext = "Edit";
            $.jgrid.nav.deltext = "Delete";
            $.jgrid.edit.addCaption = "Add Main Category";
            $.jgrid.edit.closeAfterAdd = true;
            $.jgrid.edit.closeAfterEdit = true;
            $.jgrid.edit.editCaption = "Edit Main Category";
            $.jgrid.del.caption = "Delete Main Category";
            $.jgrid.del.msg = "Delete selected Main Category?";

            $.extend($.jgrid.edit, {
                beforeSubmit: function () {
                    $(this).jqGrid("setGridParam", { datatype: "json" });
                    return [true, "", ""];
                }
            });

            $("#list").jqGrid({
                url: '/MainCategory/DynamicGridData/',
                datatype: 'json',
                mtype: 'GET',

                colNames: ['Edit', 'Main Category'],
                colModel: [
         { name: 'MaincategoryID', index: 'MaincategoryID', width: 40, align: 'left', /* key: true,*/editable: true, editrules: { edithidden: false }, hidedlg: true, hidden: true },
         { name: 'MainCategoryName', index: 'MainCategoryName', search: true, width: 700, align: 'left', editable: true, edittype: 'text', editrules: { required: true }, formoptions: { elmsuffix: ' *'} }],
                pager: jQuery('#pager'),
                editurl: '@Url.Action("Update", "MainCategory")',
                rowNum: 10,
                width: '100%',
                height: '100%',
                rowList: [5, 10, 20, 50],
                viewrecords: true,
                loadonce: true,
                ignoreCase: true,
                caption: 'Main Categories'

            }).navGrid('#pager', { edit: true, add: true, del: true, search: true, searchtext: "Search" });

            $("#list").jqGrid('filterToolbar', { stringResult: true, searchOnEnter: false, defaultSearch: 'cn' });

            $("#list").setGridParam({ data: results.rows, localReader: reader }).trigger('reloadGrid');


    </script>

控制器:

代码语言:javascript
复制
  public ActionResult Update(lstMainCategory viewModel, FormCollection formCollection)
        {
            var operation = formCollection["oper"];
            lstMainCategory mcat = new lstMainCategory();
            rep = new MaincategoryRepository();
            if (operation.Equals("add"))
            {              

                mcat.MainCategoryName = viewModel.MainCategoryName;
                rep.Create(mcat);
                rep.Save();
            }
            else if (operation.Equals("edit"))
            {
                mcat.MaincategoryID = viewModel.MaincategoryID;
                mcat.MainCategoryName = viewModel.MainCategoryName;
                rep.Edit(mcat);
                rep.Save();
            }
            else if (operation.Equals("del"))
            {

                rep.Delete(viewModel.MaincategoryID);//here MaincategoryID is always 0 so it's not working
                rep.Save();
            }

            return Content("true");
        }

编辑

代码语言:javascript
复制
MainCategoryID  MainCategory
16           aaa
17           bbb

仓库:

代码语言:javascript
复制
 public object DynamicGridData(string sidx, string sord, int page, int rows, bool _search, string searchField, string searchOper, string searchString)
        {

            dc = new ShopDataContext(DBConnection.Connection);

            int pageIndex = Convert.ToInt32(page) - 1;
            int pageSize = rows;
            int totalRecords = dc.tblMainCategories.Count();
            int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);

            List<MainCategory> lst = (from tbm in dc.tblMainCategories
                                select new MainCategory
                                {
                                    MaincategoryID=tbm.MainCategoryID,
                                    MainCategoryName=tbm.MainCategory,
                                    DeleteID=tbm.MainCategoryID
                                }).ToList<MainCategory>().OrderBy(x=>x.MainCategoryName).ToList();

            List<MainCategory> Flst;



            if (_search && searchField == "MainCategory")
            {
                Flst = lst.Where(r => r.MainCategoryName.Contains(searchString)).OrderBy(x => x.MainCategoryName).ToList().ToList();
            }
            else
                Flst = lst;


            var GridData = new
            {
                total = totalPages,
                page = page,
                records = totalRecords,
                rows = (
                    from mcat in Flst
                    select new
                    {
                        i = mcat.MaincategoryID,
                        cell = new string[] { mcat.MaincategoryID.ToString(), mcat.MainCategoryName.ToString(),mcat.DeleteID.ToString() }
                    }).ToArray()
            };

            return GridData;
        }
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2013-06-17 11:48:53

首先,您应该修复您使用的服务器响应的格式。它有无属性,但有 id 属性而不是。线

代码语言:javascript
复制
i = mcat.MaincategoryID,

必须固定到

代码语言:javascript
复制
id = mcat.MaincategoryID,

您可以替换代码

代码语言:javascript
复制
rows = (
    from mcat in Flst
    select new
    {
        i = mcat.MaincategoryID,
        cell = new string[] { mcat.MaincategoryID.ToString(), mcat.MainCategoryName.ToString(),mcat.DeleteID.ToString() }
    }).ToArray()

代码语言:javascript
复制
rows = (
    from mcat in Flst
    select new[] {
        mcat.MaincategoryID.ToString(),
        mcat.MainCategoryName,
        mcat.DeleteID.ToString()
    }).ToArray()

不要重复相同的信息(发送两次mcat.MaincategoryID ),并从发送的每一项中删除"id:""cell:"字符串。要在客户端读取这种更紧凑的数据,您应该向jsonReader: { cell: "" }添加jqGrid选项。如果使用最后一个版本的jqGrid,则该选项是可选的。

如果希望发送包含MaincategoryID列的内容,则应在MaincategoryID列中使用editrules: { edithidden: true }选项(参见the answer)。或者,您可以添加prmNames: {id: "MaincategoryID"}。在这种情况下,jqGrid将发送rowid作为"MaincategoryID“,而不是默认值"id"

如果您不需要显示MaincategoryID列,那么可以从中删除它在这种情况下,可以将从服务器返回的数据顺序更改为

代码语言:javascript
复制
rows = (
    from mcat in Flst
    select new[] {
        mcat.MainCategoryName,
        mcat.MaincategoryID.ToString(),
        mcat.DeleteID.ToString()
    }).ToArray()

jqGrid中的更改将是

代码语言:javascript
复制
colNames: ['Edit', 'Main Category'],
colModel: [
    { name: 'MainCategoryName', width: 700, editable: true,
        editrules: { required: true }, formoptions: { elmsuffix: ' *'} }
],
pager: "#pager",
gridview: true,
jsonReader: {cell: "", id: 1},
prmNames: {id: "MaincategoryID"}

jqGrid将id属性分配给每一行(每个<tr>)。使用sonReader: {id: 1}通知jqGrid从行数据(mcat.MaincategoryID.ToString())的第二项获取rowid。pager: "#pager"gridview: true的其他更改与我以前在the answer中编写的相同。您应该另外删除<table id="list" ...<div id="paber" ...中的垃圾(请参阅我以前的答案)

票数 2
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/17144963

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档