csdn产品小助手 2019-06-10 09:57 采纳率: 0%
浏览 52

使用AJAX更新DropDownList

after typing client name #NAME1 im trying to get this client subaccounts #SUB in list from other table in db, but my list is empty . What im doing wrong?

html

 <script type="text/javascript">
    var kunnr; var ROLA;
    $(document).ready(function () {

        $('#NAME1').autocomplete({
            source: function (request, response) {
                $.ajax({
                    url: "Form2",
                    method: 'POST',
                    data: {
                        term: $('#NAME1').val()
                    },
                    success: function (data) {
                        response(data);
                    }});},
            select: function (event, ui) {
                kunnr = ui.item.kunnr;
            }});});
    $('#NAME1').change; ({
        source: function (request, response) {
            $.ajax({
                type: "GET",
                url: "Form3",
                method: 'POST',
                data: {
                    term: $('#SUB').val(), kunnr: kunnr, ROLA:"Slave"
                },
                success: function (data) {
                    response(data);
                }});}, });

controller

    [HttpPost]
    public JsonResult Form2(string term)
    {
        return Json(db.KLIENCI.Where(c => (term!=null && c.NAME1.Contains(term))||(term==null)).OrderBy(x=>x.NAME1).Take(10).Select(a => new { label = a.NAME1,kunnr=a.KUNNR }));
    }
    [HttpPost]
    public JsonResult Form3(string term, string kunnr)
    {
        return Json(db.CLI2LOGIN.Where(c => ((term != null && c.LOGIN.Contains(term)) || (term == null))&& c.KUNNR== kunnr && c.ROLA == "Slave").OrderBy(x => x.LOGIN).Select(a => new { label = a.LOGIN }).ToList(),JsonRequestBehavior.AllowGet);}
  • 写回答

1条回答 默认 最新

  • 乱世@小熊 2019-06-10 10:07
    关注

    Please find below an example:

    View:

    <script>
    $(document).ready(function () {
        $('.maincat').change(function () {
            updateSubCategoryList($(this).val());       
        });
    
    function updateSubCategoryList(catId) {
        $('.subcat').empty();
        $('.subsubcat').empty();
        $.ajax({
            url: '@Url.Action("GetSubCategories")',
            type: 'Get',
            data: { main: catId },
            success: function (response) {
                var subcat = $('.subcat');
                subcat.append('<option value=""></option>');
                if (response != null && response != '') {
                    $.each(response, function (index, value) {
                        subcat.append('<option value="' + this.SubCategoryID + '">' + this.SubCategoryDescription + '</option>');
                    });
                }
            }
        });
    }
    </script>
    

    Controller:

            [HttpGet]
            public JsonResult GetSubCategories(int main)
            {
                var i = _jobsservice.GetSubCategories(main);
                return Json(i, JsonRequestBehavior.AllowGet);
            }
    
    评论

报告相同问题?

悬赏问题

  • ¥15 如何在scanpy上做差异基因和通路富集?
  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?
  • ¥15 c++头文件不能识别CDialog