下面的是先查询出表的数据,然后搜索的时候通过,string SetNumber这个来传输
然后这通这个来判断if (!string.IsNullOrEmpty(SetNumber))
{
linsqItems = linsqItems.Where(m => m.SetNumber.Contains(SetNumber.Trim()));
}
的
public ActionResult sousuochaxuntaocan(LayuiTablePage layuiTablePage, string SetNumber, string SetName, string PinyinCode)
{
try
{
var linsqItems = from tbhsld in myModels.PW_Set
orderby tbhsld.SetID descending
select new pwset
{
SetID = tbhsld.SetID,
SetNumber = tbhsld.SetNumber,
};
if (!string.IsNullOrEmpty(SetName))
{
linsqItems = linsqItems.Where(m => m.SetName.Contains(SetName.Trim()));
}
var totals = linsqItems.Count();
List lyAchievementInfor = linsqItems.OrderByDescending(m => m.SetName)
.Skip(layuiTablePage.GetStartIndex()).Take(layuiTablePage.limit).ToList();
LayuiTableData layuiTableData =
new LayuiTableData()
{
count = totals,
data = lyAchievementInfor
};
return Json(layuiTableData, JsonRequestBehavior.AllowGet);
}
catch (Exception)
{
return Json("", JsonRequestBehavior.AllowGet);
}
}
(视图)
function tjkaldasd() {
var SetNumber = $("#SetNumberf").val();前面的是ID,后面的是控制器的方法名
var SetName = $("#SReleasseTime").val();
var PinyinCode = $("#kdflflfksdk").val();
tabNosdtice = layuiTable.reload(‘tabNosdtice’, {
url: ‘/Jiucaixinxishizi/jiucaixhizi/sousuochaxuntaocan’,
page: {
curr: 1,
},
where: {
SetNumber: SetNumber, SetName: SetName, PinyinCode: PinyinCode
这里是对应的ID的
}
});
}