kendu 的下拉复选+linq 的复杂查询+一句话二次筛选+前端使用

来源:互联网 发布:mac数位板驱动怎么安装 编辑:程序博客网 时间:2024/06/03 18:27

view

 <input type="text" id="BB_TYPE" name="BB_TYPE" value="" placeholder="" style="width: 68%;" />

前端js

<script type="text/javascript">    var app = new kendo.mobile.Application(document.body, { skin: "nova" });    $(function () {        var dict_jx_type = new kendo.data.DataSource({            transport: {                read: {                    type: "get",                    url: "/DICT/JX_TYPE?PY=XYJX",                    dataType: "json"                }            },            schema: {                data: "results"            }        });        var JX_TYPE = $("#BB_TYPE");        JX_TYPE.kendoDropDownList({            dataTextField: "NAME",//json返回的name            dataValueField: "ID",            dataSource: dict_jx_type        });    });</script>
之后后台服务端linq和 json传递,这个是在mvc的控制器里

 /// <summary>        /// json获取申报类别前端调用        /// </summary>        /// <returns></returns>        [HttpGet]        public JsonResult sblb()        {            var r = (from a in base_db.BB_TYPE                     select new                     {                         ID = a.ID,                         NAME = a.UNAME,                         SORT_NUM = a.SORT_NUM                     }).AsEnumerable().Select(p => new V_DICT_ALL                     {                         ID = p.ID,                         SORT_NUM = p.SORT_NUM,                         NAME = p.NAME                     });            var empty = new V_DICT_ALL { ID = 0, NAME = "--选择全部--", SORT_NUM = 0 };            List<V_DICT_ALL> v = new List<V_DICT_ALL>();            v = r.ToList<V_DICT_ALL>();            v.Add(empty);            v.Sort(SortNumber);            return Json(new { results = v }, JsonRequestBehavior.AllowGet);        }


结果,前端出现下拉选择,数据是从后台的库里面获取的同时通过json格式传递到前台,

原创粉丝点击