记录上让自己找了半天的代码，晕死了

记录下让自己找了半天的代码，晕死了

String sql = "select count(*) from si_order_second where ";
		sql += " si_order_second.Second_Line_IsRefund=0  ";
		sql += " and si_order_second.Second_Line_ID="+lineId;
		sql += " and si_order_second.Second_Line_Date='"+lineBeginDate+"' ";
		sql += " and si_order_second.Second_Start_Time='"+lineBeginTime+"' ";
		sql += " and si_order_second.Second_Line_Date>=current_date() ";
		sql += " and concat(si_order_second.Second_SiteDate,' ',si_order_second.Second_Line_Time) <= '"+lineSiteBeginDate+" "+lineSiteBeginTime+"'";
		sql += " and concat(si_order_second.LineArr_Date,' ',si_order_second.LineArr_Time) >= '"+lineSiteArrDate+" "+lineSiteArrTime+"'";
		sql += " and si_order_second.MainOrder_ID in ";
		//加入订单保留时限
		sql += "(select si_order_main.MainOrder_ID from si_order_main where si_order_main.MainOrder_IsSuccess<>3 and (si_order_main.MainOrder_IsSuccess in (1,2) or UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(MainOrder_Time)<1800))";