首页 \ 问答 \ 搜索字符串从视图中键入两个字段的“名字”和“姓氏”组合(Search Strings Typed from View for Two Fields 'First Name' and 'Last Name' Combined)

搜索字符串从视图中键入两个字段的“名字”和“姓氏”组合(Search Strings Typed from View for Two Fields 'First Name' and 'Last Name' Combined)

目前,我有一个搜索框,以便当您在其中键入任何内容时,将显示该关键字。 但是如果我想输入两个关键字,我想返回这些组合关键字并从数据库中找到它。

在我的控制器中的Index方法:

            if (!String.IsNullOrEmpty(searchString))
        {
            result = result.Where(b =>
                b.LastName.Contains(searchString) || b.FirstName.Contains(searchString)
                || b.Id.ToString().Contains(searchString)
                || b.Email.Contains(searchString)
                || b.City.Contains(searchString)
                || b.State.ToString().Contains(searchString)
                || b.FirstName.Contains(searchString)
                || b.FirstName.Contains(searchString) && b.LastName.Contains(searchString) // was trying to do something like this... I tried adding a FullName property and concactenated FirstName and LastName... didn't like it
                );
            ...
        }

视图:

@Html.TextBox("SearchString", ViewBag.CurrentFilter as string, new { @class = "form-control", @placeholder = "Search first name, last name, city, state, ID", @type = "search" })

当您使用两个字段进行搜索时,它显示:

http://localhost:59818/Broker?SearchString=Some+Name

没有结果。 显然我设置错了? 或者是否可以关注我当前的架构,以便我可以简单地传递组合关键字并显示它? 谢谢。


Currently, I have a search box so that when you type anything in it, will show that keyword. But if I want to type two keywords, I'd like to return these combined keywords and find it from database.

On my Index method in a controller:

            if (!String.IsNullOrEmpty(searchString))
        {
            result = result.Where(b =>
                b.LastName.Contains(searchString) || b.FirstName.Contains(searchString)
                || b.Id.ToString().Contains(searchString)
                || b.Email.Contains(searchString)
                || b.City.Contains(searchString)
                || b.State.ToString().Contains(searchString)
                || b.FirstName.Contains(searchString)
                || b.FirstName.Contains(searchString) && b.LastName.Contains(searchString) // was trying to do something like this... I tried adding a FullName property and concactenated FirstName and LastName... didn't like it
                );
            ...
        }

View:

@Html.TextBox("SearchString", ViewBag.CurrentFilter as string, new { @class = "form-control", @placeholder = "Search first name, last name, city, state, ID", @type = "search" })

When you search with two fields it shows:

http://localhost:59818/Broker?SearchString=Some+Name

There was no result. Obviously I'm setting this up wrong? Or is there away to follow my current architecture so that I can simply pass combined keywords and displays it? Thanks.


原文:https://stackoverflow.com/questions/45043017
更新时间:2024-05-04 12:05

最满意答案

好吧,我已经解决了:

$("#selectList").focus(function() {
  var selectedOption = $(this).find("option:selected");
  selectedOption.text(selectedOption.attr("description"));
});

$("#selectList").change(function() {
  var selectedOption = $(this).find("option:selected");
  selectedOption.attr("description", selectedOption.text());
  selectedOption.text(selectedOption.val());
});

var currSelOption = $("#selectList").find("option:selected");
currSelOption.attr("description", currSelOption .text());
currSelOption.text(currSelOption .val());

它可能会稍微优化一下。


Alright, I've worked it out:

$("#selectList").focus(function() {
  var selectedOption = $(this).find("option:selected");
  selectedOption.text(selectedOption.attr("description"));
});

$("#selectList").change(function() {
  var selectedOption = $(this).find("option:selected");
  selectedOption.attr("description", selectedOption.text());
  selectedOption.text(selectedOption.val());
});

var currSelOption = $("#selectList").find("option:selected");
currSelOption.attr("description", currSelOption .text());
currSelOption.text(currSelOption .val());

It could probably be optimized a bit.

相关问答

更多

相关文章

更多

最新问答

更多
  • python的访问器方法有哪些
  • 使用Zend Framework 2中的JOIN sql检索数据(Retrieve data using JOIN sql in Zend Framework 2)
  • 透明度错误IE11(Transparency bug IE11)
  • linux的基本操作命令。。。
  • 响应navi重叠h1和nav上的h1链接不起作用(Responsive navi overlaps h1 and navi links on h1 isn't working)
  • 在C中读取文件:“r”和“a +”标志的不同行为(Reading a File in C: different behavior for “r” and “a+” flags)
  • NFC提供什么样的带宽?(What Kind of Bandwidth does NFC Provide?)
  • 元素上的盒子阴影行为(box-shadow behaviour on elements)
  • Laravel检查是否存在记录(Laravel Checking If a Record Exists)
  • 设置base64图像的大小javascript - angularjs(set size of a base64 image javascript - angularjs)
  • 想学Linux 运维 深圳有哪个培训机构好一点
  • 为什么有时不需要在lambda中捕获一个常量变量?(Why is a const variable sometimes not required to be captured in a lambda?)
  • 在Framework 3.5中使用服务器标签<%=%>设置Visible属性(Set Visible property with server tag <%= %> in Framework 3.5)
  • AdoNetAppender中的log4net连接类型无效(log4net connection type invalid in AdoNetAppender)
  • 错误:发送后无法设置标题。(Error: Can't set headers after they are sent. authentication system)
  • 等待EC2实例重启(Wait for an EC2 instance to reboot)
  • 如何在红宝石中使用正则表达式?(How to do this in regex in ruby?)
  • 使用鼠标在OpenGL GLUT中绘制多边形(Draw a polygon in OpenGL GLUT with mouse)
  • 江民杀毒软件的KSysnon.sys模块是什么东西?
  • 处理器在传递到add_xpath()或add_value()时调用了什么顺序?(What order are processors called when passed into add_xpath() or add_value()?)
  • sp_updatestats是否导致SQL Server 2005中无法访问表?(Does sp_updatestats cause tables to be inaccessible in SQL Server 2005?)
  • 如何创建一个可以与持续运行的服务交互的CLI,类似于MySQL的shell?(How to create a CLI that can interact with a continuously running service, similar to MySQL's shell?)
  • AESGCM解密失败的MAC(AESGCM decryption failing with MAC)
  • SQL查询,其中字段不包含$ x(SQL Query Where Field DOES NOT Contain $x)
  • PerSession与PerCall(PerSession vs. PerCall)
  • C#:有两个构造函数的对象:如何限制哪些属性设置在一起?(C#: Object having two constructors: how to limit which properties are set together?)
  • 平衡一个精灵(Balancing a sprite)
  • n2cms Asp.net在“文件”菜单上给出错误(文件管理器)(n2cms Asp.net give error on Files menu (File Manager))
  • Zurb Foundation 4 - 嵌套网格对齐问题(Zurb Foundation 4 - Nested grid alignment issues)
  • 湖北京山哪里有修平板计算机的