var strCon = "";
var con1 = window.form1.FEmployeeName.value;
var con2 = window.form1.FCompanyName.value;
var con3 = window.form1.FOrganizationName.value;
var con4 = window.form1.FPositionName.value;
if(con1!="")
strCon ="FEmployeeName like '%"+window.form1.FEmployeeName.value+"%'";
if(con2!="")
strCon ="FCompany_ID_Name like '%"+window.form1.FCompanyName.value+"%'";
if(con3!="")
strCon ="FOrganization_ID_Name like '%"+window.form1.FOrganizationName.value+"%'";
if(con4!="")
strCon ="FPosition_ID_Name like '%"+window.form1.FPositionName.value+"%'";以上是只能单个查询,如果要con1,con2,con3,con4两个或者三个不为空的时候 查询咋办
var con1 = window.form1.FEmployeeName.value;
var con2 = window.form1.FCompanyName.value;
var con3 = window.form1.FOrganizationName.value;
var con4 = window.form1.FPositionName.value;
if(con1!="")
strCon ="FEmployeeName like '%"+window.form1.FEmployeeName.value+"%'";
if(con2!="")
strCon ="FCompany_ID_Name like '%"+window.form1.FCompanyName.value+"%'";
if(con3!="")
strCon ="FOrganization_ID_Name like '%"+window.form1.FOrganizationName.value+"%'";
if(con4!="")
strCon ="FPosition_ID_Name like '%"+window.form1.FPositionName.value+"%'";以上是只能单个查询,如果要con1,con2,con3,con4两个或者三个不为空的时候 查询咋办
解决方案 »
- 新手求解:js播放器 浏览器兼容问题
- jquery 拖拽互换,不是sortable()
- attachEvent中函数参数传递的问题
- 邮箱、论坛之类的富文本编辑框如何实现的?
- [有偿帮助]想在网站上实现3D云标签,那个高手可以啊?
- 求一个浮动图片的JS代码大家帮帮忙
- 如何将一个div最大化到父div的大小,位置也一样,并可以还原成原来大小和位置
- 从下拉框选出n个值付给n个动态生成的checkbox(即选几个值)生成几个checkbox并分别付值?
- ExtJs4.2里面的搜索怎么实现?
- JavaScript高级教程中说对象传递参数是按值传递的,想问一下大佬是怎么理解这个的。
- jQuery ui 拖拽的,来个高人看看代码哪里有问题
- 请问用ExtJs的朋友,qWikiOffice有.Net版本吗?
var con1 = window.form1.FEmployeeName.value;
var con2 = window.form1.FCompanyName.value;
var con3 = window.form1.FOrganizationName.value;
var con4 = window.form1.FPositionName.value;
if(con1!="")
strCon +="and FEmployeeName like '%"+window.form1.FEmployeeName.value+"%' ";
if(con2!="")
strCon +="and FCompany_ID_Name like '%"+window.form1.FCompanyName.value+"%'";
if(con3!="")
strCon +="and FOrganization_ID_Name like '%"+window.form1.FOrganizationName.value+"%'";
if(con4!="")
strCon +="and FPosition_ID_Name like '%"+window.form1.FPositionName.value+"%'";
strCon=strCon.TrimStart("and");
或者 if(con1!=""&&con2!="")
你自己拼凑嘛
JS没有TrimStart方法
你可以初始让
var strCon = "1=1 ";
var con1 = window.form1.FEmployeeName.value;
var con2 = window.form1.FCompanyName.value;
var con3 = window.form1.FOrganizationName.value;
var con4 = window.form1.FPositionName.value;
if(con1!="")
strCon +="and FEmployeeName like '%"+window.form1.FEmployeeName.value+"%' ";
if(con2!="")
strCon +="and FCompany_ID_Name like '%"+window.form1.FCompanyName.value+"%'";
if(con3!="")
strCon +="and FOrganization_ID_Name like '%"+window.form1.FOrganizationName.value+"%'";
if(con4!="")
strCon +="and FPosition_ID_Name like '%"+window.form1.FPositionName.value+"%'";
这样就不会出错了
var strCon = "1=1 ";