首先得引用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
效果图