组合查询

function select() {

            var
Putaway = $("#Putaway").prop("checked");

            var
cont = $("#contID").val();

            var XianmuID =
$("#XianmuID").val();

            

            url:
"/EverydayAffair/ShopAdministration/SelectShop";

           
ShopAdministion = layuiTable.reload("ShopAdministion", {

                   
url: "/EverydayAffair/ShopAdministration/SelectShop",

                       
//接口的其它参数。格式：where: {token: 'sasasas', id: 123}

                   
page: {

                       
curr: 1 //重新从第 1 页开始

                   
},

                   
where: {

                       
XianmuID:XianmuID,

                       
cont:cont,

                       
Putaway: Putaway,

                   
}

            });

                }

主要是获取到页面的筛选数据再传到后台进行一个数据的筛选

if (XianmuID == "0")

            {

                list = list.Where(m =>
m.CommodityNumber.Contains(cont)).ToList();

            }

            if
(XianmuID == "1")

            {

                list = list.Where(m =>
m.ClassifyName.Contains(cont)).ToList();

            }

            if (XianmuID
== "2")

            {

                list = list.Where(m =>
m.StyleNumber.Contains(cont)).ToList();

            }

            if
(XianmuID == "3")

            {

                list = list.Where(m =>
m.ColourName.Contains(cont)).ToList();

            }