string sql = "select * from I_CustomOrder where 1=1"; if(TextBox1.Text != "")
{
sql += " and WRFAC='" + TextBox1.Text.Trim() + "'"; }
if(TextBox2.Text != "" & TextBox3.Text != "" ) {
sql += " and (WRLOC like '" + TextBox2.Text.Trim() + "' or WRLOC like '" + TextBox3.Text.Trim() + "') ";
} if(TextBox4.Text != "" & TextBox5.Text != "") {
sql += " and (WRPROD like '" + TextBox4.Text.Trim() + "' or WRPROD like '" + TextBox5.Text.Trim() + "') ";
}
if(TextBox6.Text != "" & TextBox7.Text != "") {
sql += " and (WRTOOL like '" + TextBox6.Text.Trim() + "' or WRTOOL like '" + TextBox7.Text.Trim() + "') ";
}
if(TextBox8.Text != "" & TextBox9.Text != "") {
sql += " and (WRRDTE like '" + TextBox8.Text.Trim().ToString() + "' or WRRDTE like '" + TextBox9.Text.Trim().ToString() + "') ";
}
{
sql += " and WRFAC='" + TextBox1.Text.Trim() + "'"; }
if(TextBox2.Text != "" & TextBox3.Text != "" ) {
sql += " and (WRLOC like '" + TextBox2.Text.Trim() + "' or WRLOC like '" + TextBox3.Text.Trim() + "') ";
} if(TextBox4.Text != "" & TextBox5.Text != "") {
sql += " and (WRPROD like '" + TextBox4.Text.Trim() + "' or WRPROD like '" + TextBox5.Text.Trim() + "') ";
}
if(TextBox6.Text != "" & TextBox7.Text != "") {
sql += " and (WRTOOL like '" + TextBox6.Text.Trim() + "' or WRTOOL like '" + TextBox7.Text.Trim() + "') ";
}
if(TextBox8.Text != "" & TextBox9.Text != "") {
sql += " and (WRRDTE like '" + TextBox8.Text.Trim().ToString() + "' or WRRDTE like '" + TextBox9.Text.Trim().ToString() + "') ";
}
解决方案 »
- Ei检索的中文“IEEE互联网技术与应用国际会议”iTAP2010
- SQL查询问题
- access与sql server数据表的数据可以实现同步吗?
- MSSQL进程问题,求解惑
- SQL 多表查询
- 如何将VFP数据库转换成SQL SERVER数据库?100分相送!!!
- 怎样在安装程序中打包SQL SERVER备份文件?安装时自动恢复?
- 表游标的问题
- 怎样在查询中过滤记录在一定时间段?
- 为什么在函数中不能调用Select from mytable 语句?
- 再次发问,请真正懂SQL的进来看看
- SQL Server 2005中能否使用raiserror或者print方法,能使用的话为什么在2005的查询分析器中下面程序会出错?
sql+改為sql.Append()
StringBuilder sql = new StringBuilder( "select * from I_CustomOrder where 1=1"); if(TextBox1.Text != "")
{
sql.Append( " and WRFAC='" + TextBox1.Text.Trim() + "'");
}
在WRFAC上建索引