wangdaping
/
wp


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116
							<%@page language="java" pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>装备台账明细——发电机</title>
<!--框架必需start-->
<%@include file="../../../../include2.jsp" %>   
<script type="text/javascript" src="/nwyj/scripts/qui/libs/js/nav/pageNumber.js"></script>
<script type="text/javascript" src="/nwyj/scripts/ECM_gridtemplate/changeFormat.js"></script>
<link href="<%=path%>/scripts/ECM_gridtemplate/changeFormat.css" rel="stylesheet" type="text/css"/>
<!--引用资源文件，JS CSS-->
<script type="text/javascript" src="<%=path%>/scripts/jquery/plugins/jquery.extension.util.js"></script>
<script type="text/javascript" src="<%=path%>/scripts/freamwork/com/sinosoft/common/common.js"></script>
<script type="text/javascript" src="<%=path%>/scripts/freamwork/com/sinosoft/common/utils/utils.js"></script>
<script type="text/javascript" src="<%=path%>/scripts/freamwork/com/sinosoft/common/frameWork/frameWork.js"></script>
<script type="text/javascript" src="<%=path%>/scripts/freamwork/com/sinosoft/common/utils/Request.js"></script>
<script type="text/javascript" src="<%=path%>/scripts/freamwork/com/sinosoft/common/searchUtil.js"></script>
<link href="<%=path%>/scripts/freamwork/com/sinosoft/common/searchUtil.css" rel="stylesheet" type="text/css"/>
<!--基本选项卡start--> 
<!--框架必需end-->
<!-- 按钮权限start -->
<script type="text/javascript" src="/nwyj/scripts/freamwork/com/sinosoft/common/common.js"></script>
<!-- 按钮权限end -->

<script type="text/javascript">
		var deptId=top.com.sinosoft.lz.system.user.LoginInfo.getCorp_ids();//登录人的单位ID
       //数据表格
        var g;
        var condition = "";
		var value1 = (window.location.href).split('?')[1];
		var name = (window.location.href).split('?')[2];
	
		if(name=="content_min"){//容量在0到10之间
			if(value1==deptId)//传过来的单位ID等于本单位ID。只查跟自己单位挂着的发电机。
			condition = "IS_DEL='0' AND COMP_ID = '"+value1+"' AND (convert(double,CONTENT) BETWEEN '0' AND '10')";
			else//单位ID不等于登录人本单位ID情况下，可判定为查下属单位的明细，下属单位明细需要递归到最底层单位。
			condition = "IS_DEL='0' AND COMP_ID in (select dept_id from SYS_DEPARTMENT WHERE dept_type='1' start with dept_id = '"+value1+"' connect by prior dept_id = parent_id) AND (convert(double,CONTENT) BETWEEN '0' AND '10')";  
		}else if(name=="content_mid"){//容量在11到50之间
			if(value1==deptId)
			condition = "IS_DEL='0' AND COMP_ID = '"+value1+"' AND (convert(double,CONTENT) BETWEEN '11' AND '50')";
			else
			condition = "IS_DEL='0' AND COMP_ID in (select dept_id from SYS_DEPARTMENT WHERE dept_type='1' start with dept_id = '"+value1+"' connect by prior dept_id = parent_id) AND (convert(double,CONTENT) BETWEEN '11' AND '50')";
		}else if(name=="content_max"){//容量在51以上
			if(value1==deptId)
			condition = "IS_DEL='0' AND COMP_ID = '"+value1+"' AND (convert(double,CONTENT) >= '51' )";
			else
			condition = "IS_DEL='0' AND COMP_ID in (select dept_id from SYS_DEPARTMENT WHERE dept_type='1' start with dept_id = '"+value1+"' connect by prior dept_id = parent_id) AND (convert(double,CONTENT) >= '51' )";
		}else if(name=="kused"){//可调拨的情况下
			if(value1==deptId)
			condition = "IS_DEL='0' AND COMP_ID = '"+value1+"' AND IS_USED='1'";
			else
			condition = "IS_DEL='0' AND COMP_ID in (select dept_id from SYS_DEPARTMENT WHERE dept_type='1' start with dept_id = '"+value1+"' connect by prior dept_id = parent_id) AND IS_USED='1'";
		}else if(name=="bused"){//不可调拨的情况下
			if(value1==deptId)
			condition = "IS_DEL='0' AND COMP_ID = '"+value1+"' AND IS_USED='2' ";
			else
			condition = "IS_DEL='0' AND COMP_ID in (select dept_id from SYS_DEPARTMENT WHERE dept_type='1' start with dept_id = '"+value1+"' connect by prior dept_id = parent_id) AND IS_USED='2' ";
		} 

        var loadParams = {
    			"listId" : '266',
    			"condition" : condition,
				direction:'DESC',	
				sort: 'UPDATEDATE'
    	};
		function initComplete(){
			
			g = $("#maingrid").quiGrid({
	              columns: [{ 
						    	display: '所属单位', name: 'COMP_ID_266_SHOW', width: "10%", align: 'center' ,showTitle:true		    
				            },{ 
				            	display: '装备名称', name: 'NAME_266', width: "10%", align: 'center' ,showTitle:true
				            },{ 
				                display: '容量(kW)', name: 'CONTENT_266', width: "10%", align: 'center' ,showTitle:true
				            },{ 
				                display: '数量', name: 'NUM_266', width: "5%", align: 'center' ,showTitle:true
				            },{ 
				                display: '燃料', name: 'GAS_266_SHOW', width: "5%", align: 'center' ,showTitle:true
				            },{ 
				                display: '供应商', name: 'PROVIDER_266', width: "10%", align: 'center' ,showTitle:true
				            },{ 
				                display: '购买日期(年月)', name: 'BUY_DATE_266', width: "10%", align: 'center' ,showTitle:true
				            },{ 
				                display: '装备存放场所', name: 'STORE_PLACE_266', width: "10%", align: 'center' ,showTitle:true             	
				            },{ 
				                display: '负责人', name: 'INPIRE_266', width: "5%", align: 'center' ,showTitle:true
				            },{ 
				                display: '手机', name: 'MOBILE_PHONE_266', width: "10%", align: 'center' ,showTitle:true
				            },{
				            	display: '电压等级 (V)', name: 'VOLTAGE_LEVEL_266_SHOW', width: "5%", align: 'center',showTitle:true
				            },{ 
				                display: '调用状态', name: 'IS_USED_266_SHOW', width: "10%", align: 'center' ,showTitle:true
				            }], 
	                url :'/nwyj/ws/crud/CRUDService/queryQui',	
					params:loadParams,
	                pageSize: 10, 
	                rownumbers:true, 
	                width:"100%",
	                checkbox:true,
	                percentWidthMode:true
	               
	            });	
			
		}

</script>
</head>
  
<body style="height:500px;overflow: auto;">
<div class="adding_right5" style="height:500px; overflow-y:auto">
	<div id="maingrid" style="margin: 0; padding: 0"></div>
</div>	
  </body>
</html>