TMRWatchNew/linux安装方法/TMRWatch/webapps/ROOT/recipeplan/plan1.jsp

<%@ page contentType="text/html; charset=utf-8" session="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<script type="text/javascript">

	var mydataP1,colName;
	$(document).ready( function() {
		loadNames();	//动态生成字段名称
		loadPlan1();	//加载jqgrid
		panelC = $("body").layout("panel","center").panel();
		panelSHeight = document.body.clientHeight - panelC.height();
		$("#p1list").jqGrid("setGridHeight",panelSHeight-130);
		$("#p2list").jqGrid("setGridHeight",panelSHeight-130);
		$("#p1list").jqGrid("setGridWidth",document.body.clientWidth*0.49);
	});
	$(window).resize(function(){
		$("#p1list").jqGrid("setGridWidth",document.body.clientWidth*0.49);
	});	
	
	//jqgrid初始化
	function loadPlan1(){

		jQuery("#p1list").jqGrid({ 
			datatype: "local",  //从服务器端返回的数据类型，（表格期望接收的数据类型）。可选类型：xml，xmlstring，json，local，function
			height: 150, 	//高度
			colNames: colName,
			colModel:[
				{
					name: "ID",
					index: "ID",
					width: 1, 
					align: "center", 
					sorttype: "string", 
					hidden: true
				}, 
				{
					name: "SORT",
					index: "SORT",
					align: "center", 
					sorttype: "int"
				}, 
				{
					name: "Fname",
					index: "Fname", 
					align: "center", 
					sorttype: "string"
				}, 
				{
					name: "LWEIGHT",
					index: "LWEIGHT", 
					align: "center", 
					sorttype:"number",
					editable: true,
					formatter:"number", 
					summaryType:"sum"
				},
				{
					name: "L1",
					index: "L1", 
					align: "center", 
					sorttype:"number"
				}
			],
			
			cellEdit: true,
			cellsubmit: "clientArray", //当单元格发生变化后不直接发送请求、"remote"默认直接发送请求
			
			afterSaveCell: function(rowid,name,val,iRow,iCol) {
				var rowData = $("#p1list").jqGrid("getRowData",rowid);
				var currentpId = $("#currentpId").val();
				$.ajax({
					async: false,
					type: 'POST',
					dataType:'json', //返回类型jsond
					data: "ID="+rowData.ID+"&colValue="+val+"&currentpId="+currentpId,
					url: "${contextPath }/admin/recipeplan/dateplan1updatedyg.html",
					error: function(){alert("系统错误");},
					success: function(json){
					}
				});
			},
			
			grouping: true,
			groupingView: {
				groupField: ["SORT"],
				groupSummary: [true],
				groupText: ["操作序号[{0}]小计"],
				groupCollapse: false
			},
			rowNum: 1000,	//每页显示条数
			footerrow: true,	//统计运算的功能
		    gridComplete: completeMethod,
		   	autowidth: true	//自动调节宽度
		}); 
		
		//获取数据集
		mydataP1 = getPlan1();
		
		if(mydataP1!=null){
			for(var i=0;i<=mydataP1.length;i++){
				jQuery("#p1list").jqGrid('addRowData',i+1,mydataP1[i]);
			}
			jQuery("#p1list").jqGrid("sortGrid","SORT"); //手动让某字段排序
		}

	}
	
	//获取服务器数据
	function getPlan1(){
		var currentpId = $("#currentpId").val();
		$.ajax({
			async: false,
			type: 'POST',
			dataType:'json', //返回类型json
			url: "${contextPath }/admin/recipeplan/plan1list.html?currentpId="+currentpId,
			error: function(){alert("系统错误");},
			success: function(json){
				mydataP1 = json;
			}
		});
		return mydataP1;
	}

	//页脚统计
	function completeMethod(){
		var sum_lweight=$("#p1list").getCol("LWEIGHT",false,"sum");
		$("#p1list").footerData("set", {SORT:"合计:", LWEIGHT: sum_lweight.toFixed(2)});
	}
	//动态生成字段名称
	function loadNames(){
		var lpplanType = $("#lpplanType").val();
		if(lpplanType == 2){
			//如果是发料车
			colName = ["主键","操作序号","需加料","加料重量","加料重量合计"];  //列名
		}else{
			//如果是混合、上料车
			colName = ["主键","操作序号","饲料名称","设计重量","同序号设计重量合计"];  //列名
		}
	}
</script>
<table id="p1list"></table>