列表编辑列下的“上移” “下移”操作

本文介绍了如何在列表编辑中实现元素的上移和下移功能,通过方法复用提供了一个具体的案例。
摘要由CSDN通过智能技术生成
if("moveUsers".equals(opration)){
		    	String userId       = UtilParam.isEmpty(request.getParameter("user_id"),"null");
		    	String orderId      = UtilParam.isEmpty(request.getParameter("order_id"),"null");
		    	String orderType    = UtilParam.isEmpty(request.getParameter("order_type"),"null");
		    	
		    	if(!"null".equals(userId)){		    	
			    	StringBuffer selSql = new StringBuffer();
			    	selSql.append(" SELECT (SELECT COUNT(*) FROM s_class_user WHERE TYPE = 'N' AND status = 'Y' AND class_info_id = ? ) all_num,                      ")
			    		  .append("        (SELECT COUNT(*) FROM s_class_user WHERE TYPE = 'N' AND status = 'Y' AND order_id = 0 AND class_info_id = ? ) default_num  ") 
			    		  .append(" FROM dual ");
			    	String[] userNumInfo = DaoHelper.getResultStrings(selSql.toString(),new String[]{classInfoId,classInfoId},2);
			    	
			    	//全部数量等于默认排序的数量时,说明尚未手动排序过
			    	if(userNumInfo[0].equals(userNumInfo[1])){
			    		//获取排序ID表
			    		StringBuffer defaultOrderSql = new StringBuffer();
			    		defaultOrderSql.append("   select zhiji.id,zhiji.username,zhiji.useroid,zhiji.order_id as zhijioid,gongsi.order_id as gsoid ")
				    	               .append("     from (select cu.id,cu.order_id as useroid,cu.username,so.name,so.order_id ")
				    	               .append("     from s_class_user cu, s_class_other so where cu.type = 'N' and cu.status = 'Y' and cu.class_info_id = ?")
				    	               .append("   and so.id = cu.zhiji_id) zhiji,(select cu.id,cu.order_id as useroid,cu.username,so.order_id from s_class_user cu, s_class_other so ")
				    	               .append("   where cu.type = 'N' and cu.status = 'Y' and cu.class_info_id = ? and so.id = cu.company_id) gongsi where gongsi.id = zhiji.id  order by zhiji.useroid, gsoid, zhijioid, zhiji.username ");				    	   
 	               
			    		List defaultOrderList = DaoHelper.getResultSet(defaultOrderSql.toString(),new String[]{classInfoId},3);
			    		int orderSize = defaultOrderList.size();
			    		String[] idArr = new String[orderSize];
			    		for(int i=0;i<orderSize;i++){     //按照排序重构ID数组
			    			String[] tmpArr = (String[])defaultOrderList.get(i);
			    			idArr[i] = tm
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值