javascript实现年、季度、月、时间段的查询条件切换

效果：

页面代码

 年季月时间段           			至    	

JAVASCRIPT代码

具体在后台查询处理过程的代码

传过来的参数有：yearSelect,stageSelect,monthSelect,startDate,endDate，分别判断处理。

		//0.1timeString yearSelect = request.getParameter("yearSelect");String stageSelect = request.getParameter("stageSelect");String monthSelect = request.getParameter("monthSelect");String startDateString = request.getParameter("startDate");String endDateString = request.getParameter("endDate");String startDate=null;String endDate=null;if(!("").equals(startDateString) && null!=startDateString){startDate=startDateString;}else{startDate="";}if(!("").equals(endDateString) && null!=endDateString){endDate=endDateString;}else{endDate="";}String firstPar,secondPar,datePar=null;//firstPar= year/startDate;  secondPar=month/stage/endDateif(!("").equals(yearSelect) && null!=yearSelect){//month,stage,nullif(!("").equals(monthSelect) && null!=monthSelect){//monthdatePar=" and Month([adate]) ="+monthSelect+" and year([adate])="+yearSelect;}else if(!("").equals(stageSelect) && null!=stageSelect){//stagesecondPar=stageSelect;if(secondPar.equals("1")){datePar=" and year([adate])="+yearSelect+" and  ( Month([adate])=1 or month([adate])=2 or month([adate])=3 )" ;}if(secondPar.equals("2")){datePar=" and year([adate])="+yearSelect+" and  ( month([adate])=4 or month([adate])=5 or month([adate])=6 )" ;}if(secondPar.equals("3")){datePar=" and year([adate])="+yearSelect+" and  ( month([adate])=7 or month([adate])=8 or month([adate])=9 )" ;}if(secondPar.equals("4")){datePar=" and year([adate])="+yearSelect+" and  ( month([adate])=10 or month([adate])=11 or month([adate])=12 )" ;}}else{//yeardatePar=" and Year([adate]) ="+yearSelect;}}else if(!("").equals(startDate) && !("").equals(endDate) ){//have startDate and endDatefirstPar=startDate;secondPar=endDate;datePar=" and main.adate between '"+startDate+"' and  '"+ endDate+"'";}else{firstPar="";secondPar="";datePar="";}

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！