.net layui mvc EF xm-select 多选下拉框 动态赋值 用于列表多选查询

首先得引用js ,(js也文件可以自己去下载,也可以点下面链接下载https://download.csdn.net/download/Tenderness104/85585086

 <script src="/Scripts/xm-select.js"></script>

然后,前台放一个这个

 <div class="layui-inline">
                <div id="demo1" style="width:200px;"></div>
            </div>

js里这样写

<script>

    layui.use('table', function () {
        var table = layui.table;//实例化layui 表格
        var layer = layui.layer;
        var form = layui.form;
        $ = layui.$;

        var demo1 = xmSelect.render({
            el: '#demo1',
            language: 'zn',
            toolbar: {
                show: true,
                list: ['ALL', 'CLEAR', 'REVERSE']
            },
            tips: '请选择公司',
            filterable: true,
            //paging: true,
            //pageSize: 10,
            data: []
        })
        $.ajax({
            url: "/Role/GetCorp1",
            dataType: 'json',
            type: 'post',
            success: function (result) {
                /*console.log(result);*/
                demo1.update({
                    data: result,
                  
                })
            }
        });
        //查询
        $("#search").on("click", function () {

            var dxcorp = demo1.getValue('valueStr');
            
            table.reload("idTest", {
                page: { curr: 1 },
                where: {
                  
                    dxcorp: dxcorp
                }
            }, 'data');
        })
    });
</script>

后台

ajax里动态赋值的方法

  public JsonResult GetCorp1()

        {
            using (ModelsContainer1 db = new ModelsContainer1())

            {
                db.Configuration.ProxyCreationEnabled = false;//关闭EF的默认加载


                var queryAll = db.XH_CorpInfo.ToList();

                var query = queryAll.Where(u => true);//定义list变量进行条件查询

                //判断属于哪个账号
                XH_LoginUser loginuser = (XH_LoginUser)Session["user"];
                XH_LoginUser corp = db.XH_LoginUser.Where(d => d.IsDel == 0 && d.ID == loginuser.ID).FirstOrDefault<XH_LoginUser>();
                if (loginuser.ID != 1)
                {
                    if (!string.IsNullOrWhiteSpace(corp.CorpId))
                    {
                        int cid = 0;
                        string corpid = corp.CorpId;
                        List<string> list = new List<string>(corpid.Split(','));
                        List<int?> list1 = new List<int?>();

                        foreach (var item in list)
                        {
                            cid = Convert.ToInt32(item.ToString());
                            list1.Add(cid);
                        }

                        query = query.Where(u => list1.Contains(u.CorpId));

                    }
                }
                query = query.Where(u => u.IsDel != 1);
                var pageQuery = new List<XH_CorpInfo>();

                if (query != null && query.Any())
                {
                    pageQuery = query.ToList();
                }

                List<huchi1> HuChiList = new List<huchi1>();

                StringBuilder str = new StringBuilder();
                //将数据Json化并传到前台视图
                foreach (var item in pageQuery)
                {
                    huchi1 aaa = new huchi1();
                    aaa.value = item.CorpId;
                    aaa.name = item.CorpName;

                    HuChiList.Add(aaa);

                    //str.Append("{");
                    //str.Append("id:"+ item.PlanId + ",");
                    //str.Append("name:\"" + item.PlanName + "\"");
                    //str.Append("},");

                }

                var json1 = Json(HuChiList, JsonRequestBehavior.AllowGet);
                return json1;
                //var serJson = "["+ str.ToString()+"]";


                //return Json(serJson, JsonRequestBehavior.AllowGet);

            }

        }

后台,查询列表方法

public ActionResult GetAjaxplanPageList(int page, int limit, string keyWord, string select,string dxcorp)
        {
            using (ModelsContainer1 entities = new ModelsContainer1())
            {
                var queryAll = entities.XH_CorpPlanInfo.ToList();

                var query = queryAll.Where(u => true);//定义list变量进行条件查询

                //按名称查询
                if (!string.IsNullOrWhiteSpace(keyWord))
                {
                    keyWord = keyWord.Trim();
                    //query = query.Where(u => u.Title.Contains(keyWord));
                    query = query.Where(u => string.IsNullOrWhiteSpace(u.Title) ? false : u.Title.Contains(keyWord));


                }
               
                //按公司多选查询
                if (!string.IsNullOrWhiteSpace(dxcorp))
                {
                   
                        int cid = 0;
                        string corpid = dxcorp;
                        List<string> list = new List<string>(corpid.Split(','));
                        List<int?> list1 = new List<int?>();

                        foreach (var item in list)
                        {
                            cid = Convert.ToInt32(item.ToString());
                            list1.Add(cid);
                        }

                        query = query.Where(u => list1.Contains(u.CorpId));

                    

                }



                //判断属于哪个账号
                XH_LoginUser loginuser = (XH_LoginUser)Session["user"];
                XH_LoginUser corp = entities.XH_LoginUser.Where(d => d.IsDel == 0 && d.ID == loginuser.ID).FirstOrDefault<XH_LoginUser>();
                if (loginuser.ID != 1)
                {
                    if (!string.IsNullOrWhiteSpace(corp.CorpId))
                    {
                        int cid = 0;
                        string corpid = corp.CorpId;
                        List<string> list = new List<string>(corpid.Split(','));
                        List<int?> list1 = new List<int?>();

                        foreach (var item in list)
                        {
                            cid = Convert.ToInt32(item.ToString());
                            list1.Add(cid);
                        }

                        query = query.Where(u => list1.Contains(u.CorpId));

                    }
                }

                //判断不是已删除数据
                query = query.Where(u => u.IsDel != 1);

                var pageQuery = new List<XH_CorpPlanInfo>();

                if (query != null && query.Any())
                {
                    pageQuery = query.OrderByDescending(a => a.Id).Skip(limit * (page - 1)).Take(limit).ToList();
                }

                var result = new
                {
                    code = 0,
                    msg = "",
                    count = query.Count(),
                    data = pageQuery
                };
                return Json(result, JsonRequestBehavior.AllowGet);

            }
        }

ok

效果图

  • 1
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值