aspnet实现搜索查询_如何在Web网站实现搜索功能

InsusSearchUtility objIsu=newInsusSearchUtility();stringkey;stringvalue;stringcondition;//搜索数据库表的字段key="[MemberName]";//取TextBox的值value=this.TextBox1.Text.Trim();//值表过式condition=string.Format("LIKE '%{0}%'", value);//存入对象中InsusSearchObject sioScrapNumber=newInsusSearchObject(key, value, condition);//InsusSearchUtility添加一个对象objIsu.Add(sioScrapNumber);//DropDownList下拉式选择if(ddlUnitMeasure.SelectedItem.Value!=null)

{

key="[TitleId]";

value=this.ddlTitle.SelectedItem.Value;

condition=string.Format("= '{0}'", value);

InsusSearchObject sioTitle=newInsusSearchObject(key, value, condition);

objIsu.Add(sioTitle);

}//日期搜索key="[Birday]";//下面这个InsusDateTimeUtility可以从这里下载;http://www.cnblogs.com/insus/articles/1735126.html//可以某一天，输入同一天，也可以是一段日期，两个参数，开始日期与结束日期value=objInsusDateTimeUtility.GetDateTime(this.DateSelector1.StartDate.Text.Trim(),this.DateSelector1.EndDate.Text.Trim());//注意一下这个表达式,没有使用谓词，因为上面这个类别已经带出BETWEEN ... AND ...了。condition=string.Format("{0}", value);

InsusSearchObject sioBirday=newInsusSearchObject(key, value, condition);

objIsu.Add(sioBirday);//多选,如CheckBoxkey="[ClassId]";

value=GetCheckBoxSelectedValue(dlAccuracyClass,"CheckBox1");//搜索整形，注意一下表达式,使用IN谓词, 如"1,5,9,3,2"condition=string.Format("IN ({0})", value.Replace("''","'"));

InsusSearchObject sioClass=newInsusSearchObject(key, value, condition);

objIsu.Add(sioClass);//多选,如CheckBoxListkey="[ComputerName]";

value=GetCheckBoxListSelectedValue(this.cblCS);//搜索字符串，如"hp,lo,yf,wr"condition=string.Format("IN ('{0}')", value.Replace(",","','"));

InsusSearchObject sioComputerName=newInsusSearchObject(key, value, condition);

objIsu.Add(sioComputerName);