zhuhongbin
/
TMRWatchNew


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194
							<%@ page contentType="text/html; charset=utf-8" session="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN">
<head>
<title>我的工作台</title>
<%@ include file="../common/header.jsp" %>
<script type="text/javascript">

	var mydata,operType;
	$(document).ready( function() {
		loadList();	//加载jqgrid
		$("#list").jqGrid("setGridHeight",$(window).height() - 105);
		$("#list").jqGrid("setGridWidth",document.body.clientWidth - 5);
	});
	$(window).resize(function(){
		$("#list").jqGrid("setGridHeight",$(window).height() - 105);
		$("#list").jqGrid("setGridWidth",document.body.clientWidth - 5);
	});
	
	//jqgrid初始化
	function loadList(){

		jQuery("#list").jqGrid({ 
			datatype: "local",  //从服务器端返回的数据类型，（表格期望接收的数据类型）。可选类型：xml，xmlstring，json，local，function
			height: "70%", 	//高度
			colNames:["主键","车次","TMR","驾驶员","描述","生效","重量","配方模版"],  //列名
			colModel:[
				{name: "ID",index: "ID",width: 1,align: "center",sorttype: "string",hidden: true}, 
				{name: "SORT",index: "SORT",width: 50,align: "center",sorttype: "int",editable: true,editrules: {integer: true}}, 
				{name: "TNAME",index: "TNAME",width: 70,align: "center",sorttype: "int",editable: true,edittype: "select",
						editoptions:{
							dataUrl: "${contextPath }/admin/recipeplan/tmrselect.html",
							dataEvents: [{
								type: "change", fn: function(e){
									var selId = $("#list").jqGrid("getGridParam","selrow"); //获取当前选中行号
									var thisval = $(e.target).val();
									if(thisval != ""){
										$.ajax({
											async: false,
											type: "post",
											dataType: "json", //返回类型json
											data: "tmrId="+thisval,
											url: "${contextPath }/admin/recipeplan/getDnameByTmrId.html",
											error: function(){alert("系统错误");},
											success: function(json){
												if(json.status == "success"){
													$("#list").setCell(selId,"DNAME",json.DNAME);
												}
											}
										});
		
										
									}else{
										$("#list").setCell(selId,"DNAME"," ");
									}
								}
							}]
						}
				}, 
				{name: "DNAME",index: "DNAME",width: 70,align: "center",sorttype: "int",editable: true,edittype: "select",editoptions:{dataUrl: "${contextPath }/admin/recipeplan/pilotselect.html"}},
				{name: "remark",index: "remark",width: 70,align: "center",sorttype: "string",editable: true},
				{name: "Sel",index: "Sel",width: 70,align: "center",sorttype: "string",editable: true,edittype: "select",editoptions: {value:{"1":"是","0":"否"}}},
				{name: "sumWeight",index: "sumWeight",width: 70,align: "center",sorttype: "string",editable: true},
				{name: "templetName",index: "templetName",width: 70,align: "center",sorttype: "string",editable: true,edittype: "select",editoptions:{dataUrl: "${contextPath }/admin/recipeplan/templetselect.html"}}
			],
			caption: "补料计划",	//标题
			
			cellEdit: true,
			cellsubmit: "clientArray", //当单元格发生变化后不直接发送请求、"remote"默认直接发送请求
			
			
			afterSaveCell: function(rowid,name,val,iRow,iCol) {
				var rowData = $("#list").jqGrid("getRowData",rowid);
				$.ajax({
					async: false,
					type: 'POST',
					dataType:'json', //返回类型jsond
					data: "ID="+rowData.ID+"&colName="+name+"&colValue="+val,
					url: "${contextPath }/admin/recipeplan/plpdatedyg.html",
					error: function(){alert("系统错误");},
					success: function(json){
					}
				});
			},
			
			pager: "#page",	//#page分页控件绑定的位置对象
			rowNum: 1000,	//每页显示条数
		   	rowList: [100,200,300,400],	//分页下拉选项内容
		   	rownumbers: true,	//是否显示行数
			viewrecords: true,		//是否显示总条数
		   	emptyrecords: "无数据",	//服务器返回空列表时显示的内容

		   	autowidth: true,	//自动调节宽度
		   	sortname: 'SORT',	//按SORT进行排序 默认asc
		   	altRows: true,	//设置表格是否允许行交替变色值
		    altclass:"tdbgmouseover"	//自定义隔行变色的样式
		}); 
		
		//获取数据集
		mydata = getLists();
		
		if(mydata!=null){
			for(var i=0;i<=mydata.length;i++){
				jQuery("#list").jqGrid('addRowData',i+1,mydata[i]);
			}
			jQuery("#list").jqGrid().trigger("reloadGrid"); //添加完数据后客户端自动刷新一次、实现客户端数据与服务器数据的完全分离
		}

		//绑定、设置工具栏
		jQuery("#list").jqGrid("navGrid","#page",{
			add: true, addtext: "添加",
			edit: false, edittext: "编辑",
			del: true, deltext: "删除",refresh: false,search: false,
			addfunc: addRow, 	//自定义添加方法
			delfunc: deleteRow,	//自定义删除方法
			searchtext: "搜索",
			refreshtext: "刷新",  
			alerttext:"请选择一条记录!"
		});
		
	}
	
	//获取服务器数据
	function getLists(){
		$.ajax({
			async: false,
			type: 'POST',
			dataType:'json', //返回类型json
			url: "${contextPath }/admin/recipeplan/pluslpplanlist.html",
			error: function(){alert("系统错误");},
			success: function(json){
				mydata = json;
			}
		});
		return mydata;
	}
	
	//自定义添加方法
	function addRow(){
		var ids = $("#list").jqGrid("getDataIDs");
		$("#list").jqGrid("addRowData",ids.length+1,{},"first");
		$.ajax({
			async: false,
			type: "POST",
			dataType:"json", //返回类型jsond
			data: "oper=add&selId=",
			url: "${contextPath }/admin/recipeplan/pluslpplanupdate.html",
			error: function(){alert("系统错误");},
			success: function(json){
				$("#list").clearGridData();   //清空原grid数据
				loadList();	//重新载入服务器数据				
			}
		});
	}
	
	//自定义删除方法
	function deleteRow(){
		var row = $("#list").jqGrid("getGridParam","selrow");
		if(row!=null){
			var flag = confirm("您确定要删除吗?");
			if(flag){
			   	var selRow = $("#list").jqGrid("getRowData",row);
				$.ajax({
					async: false,
					type: "POST",
					dataType:"json", //返回类型jsond
					data: "oper=del&selId="+selRow.ID,
					url: "${contextPath }/admin/recipeplan/pluslpplanupdate.html",
					error: function(){alert("系统错误");},
					success: function(json){
						$("#list").clearGridData();   //清空原grid数据
						loadList();	//重新载入服务器数据			
					}
				});		
			}
		}else{
			alert("请选择记录");
		}
	}
</script>
</head>
<body style="background-color: #E0E0E0">
<div>
	<div class="navfrm">		
			<span>当前位置：</span>
			<span><a href="${contextPath }/admin/welcome.html">首页</a></span>
			<span>&nbsp;>>&nbsp;</span>
			<span>补料计划</span>		
	</div>
	<table id="list"></table>
	<div id="page"></div>
</div>
</body>
</html>