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);
            }
    
    评论

报告相同问题?

悬赏问题

  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!
  • ¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像,如何解决?
  • ¥15 求daily translation(DT)偏差订正方法的代码
  • ¥15 js调用html页面需要隐藏某个按钮