getsql.java

来自「ERO系统.针对生产型、分销型、服务型企业等不同的行业特点」· Java 代码 · 共 268 行 · 第 1/2 页

		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+condition+" "+queue+"";
		}
		else{
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+condition+" "+queue+"";
		}
		}else{
		if(timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&sales.equals("")&&trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+condition+"&&"+tableName+"."+fieldName5+"='"+fieldValue5+"' "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
			sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}

		else if(!timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(sales.equals("")||sales==null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(timea.equals("")&&!timeb.equals("")&&marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&!trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+"<='"+timeb+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else if(!timea.equals("")&&timeb.equals("")&&!marketarea.equals("")&&(!sales.equals("")&&sales!=null)&&trade.equals("")){
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName2+"='"+marketarea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}
		else{
					sql="select * from "+tableName+" where "+tableName+"."+fieldName1+">='"+timea+"' and "+tableName+"."+fieldName4+"='"+sales+"' and "+tableName+"."+fieldName3+"='"+trade+"' and "+tableName+"."+fieldName5+"='"+fieldValue5+"' and "+condition+" "+queue+"";
		}

		}

		}catch (Exception ex) {}

		return sql;
		}

}