表格动态新增一行、后台取值存库

2 篇文章 0 订阅

//声明全局变量

    var firstCell = "";
    var secondCell = "";
    var thirdCell = "";
    var fourthCell = "";
    var fifthCell = "";
    var sixthCell = "";
    var seventhCell = "";
    var seventhCell5 = "";
    var seventhCell6 = "";
    var seventhCell7 = "";
    var seventhCell8 = "";
    var seventhCell9 = "";
    var seventhCell10 = "";
    var seventhCell11 = "";
    var seventhCell12 = "";
    var eighthCell = "";
    var nineCell = "";
    var tenCell = "";
    var elevenCell = "";
    var twelveCell = "";
    var twelveCell5 = "";
    var twelveCell6 = "";
    var twelveCell7 = "";
    var twelveCell8 = "";
    var twelveCell9 = "";
    var twelveCell10 = "";
    var twelveCell11 = "";
    var twelveCell12 = "";

//初始化第一行

    $(function() {
                    firstCell = $("#row0 td:eq(0)").html();
        secondCell = $("#row0 td:eq(1)").html();
        thirdCell = $("#row0 td:eq(2)").html();
        fourthCell = $("#row0 td:eq(3)").html();
        fifthCell = $("#row0 td:eq(4)").html();
        sixthCell = $("#row0 td:eq(5)").html();
        seventhCell = $("#row0 td:eq(6)").html();
        seventhCell5 = $("#row0 td:eq(7)").html();
        seventhCell6 = $("#row0 td:eq(8)").html();
        seventhCell7 = $("#row0 td:eq(9)").html();
        seventhCell8 = $("#row0 td:eq(10)").html();
        seventhCell9 = $("#row0 td:eq(11)").html();
        seventhCell10 = $("#row0 td:eq(12)").html();
        seventhCell11 = $("#row0 td:eq(13)").html();
        seventhCell12 = $("#row0 td:eq(14)").html();
        eighthCell = $("#row0 td:eq(15)").html();
        nineCell = $("#row0 td:eq(16)").html();
        tenCell = $("#row0 td:eq(17)").html();
        elevenCell = $("#row0 td:eq(18)").html();
        twelveCell = $("#row0 td:eq(19)").html();
        twelveCell5 = $("#row0 td:eq(20)").html();
        twelveCell6 = $("#row0 td:eq(21)").html();
        twelveCell7 = $("#row0 td:eq(22)").html();
        twelveCell8 = $("#row0 td:eq(23)").html();
        twelveCell9 = $("#row0 td:eq(24)").html();
        twelveCell10 = $("#row0 td:eq(25)").html();
        twelveCell11 = $("#row0 td:eq(26)").html();
        twelveCell12 = $("#row0 td:eq(27)").html();
 }); 

//新增行

 function insertNewRow() {
    //**获取表格有多少行**
    var rowLength = $("#orderTable tr").length;
    //这里的rowId就是row加上标志位的组合。是每新增一行的tr的id。
    var rowId = "row" + (rowLength - 3);//减去表头的行和新增按钮占的那一行(我的表头2行)
    //中间加了验证  不需要验证的可以去掉
    var j = parseInt(rowLength-4);
    var reg =/^-?\d+\.?\d*$/;
	if($("#paragraphName"+j).val()==""){
		layer.tips("标段名称及建设内容不能为空","#paragraphName"+j);
		return false;
	}
	if($("#contractAmount"+j).val() == null || $("#contractAmount"+j).val() == ""){
		layer.tips("合同金额不能为空","#contractAmount"+j);
		return false;
	}else if(!reg.test($("#contractAmount"+j).val())){
		layer.tips("请输入正确的数字","#contractAmount"+j);
		return false;
	}
	if($("#paymentCompleted"+j).val() == null || $("#paymentCompleted"+j).val() == ""){
	}else if(!reg.test($("#paymentCompleted"+j).val())){
		layer.tips("请输入正确的数字","#paymentCompleted"+j);
		return false;
	}
	if($("#firstQuarter"+j).val() == null || $("#firstQuarter"+j).val() == ""){
	}else if(!reg.test($("#firstQuarter"+j).val())){
		layer.tips("请输入正确的数字","#firstQuarter"+j);
		return false;
	}
	if($("#twoQuarter"+j).val() == null || $("#twoQuarter"+j).val() == ""){
	}else if(!reg.test($("#twoQuarter"+j).val())){
		layer.tips("请输入正确的数字","#twoQuarter"+j);
		return false;
	}
	if($("#threeQuarter"+j).val() == null || $("#threeQuarter"+j).val() == ""){
	}else if(!reg.test($("#threeQuarter"+j).val())){
		layer.tips("请输入正确的数字","#threeQuarter"+j);
		return false;
	}
	if($("#fourQuarter"+j).val() == null || $("#fourQuarter"+j).val() == ""){
	}else if(!reg.test($("#fourQuarter"+j).val())){
		layer.tips("请输入正确的数字","#fourQuarter"+j);
		return false;
	}
	if($("#fiveQuarter"+j).val() == null || $("#fiveQuarter"+j).val() == ""){
	}else if(!reg.test($("#fiveQuarter"+j).val())){
		layer.tips("请输入正确的数字","#fiveQuarter"+j);
		return false;
	}
	if($("#sixQuarter"+j).val() == null || $("#sixQuarter"+j).val() == ""){
	}else if(!reg.test($("#sixQuarter"+j).val())){
		layer.tips("请输入正确的数字","#sixQuarter"+j);
		return false;
	}
	if($("#sevenQuarter"+j).val() == null || $("#sevenQuarter"+j).val() == ""){
	}else if(!reg.test($("#sevenQuarter"+j).val())){
		layer.tips("请输入正确的数字","#sevenQuarter"+j);
		return false;
	}
	if($("#eightQuarter"+j).val() == null || $("#eightQuarter"+j).val() == ""){
	}else if(!reg.test($("#eightQuarter"+j).val())){
		layer.tips("请输入正确的数字","#eightQuarter"+j);
		return false;
	}
	if($("#nineQuarter"+j).val() == null || $("#nineQuarter"+j).val() == ""){
	}else if(!reg.test($("#nineQuarter"+j).val())){
		layer.tips("请输入正确的数字","#nineQuarter"+j);
		return false;
	}
	if($("#tenQuarter"+j).val() == null || $("#tenQuarter"+j).val() == ""){
	}else if(!reg.test($("#tenQuarter"+j).val())){
		layer.tips("请输入正确的数字","#tenQuarter"+j);
		return false;
	}
	if($("#elevenQuarter"+j).val() == null || $("#elevenQuarter"+j).val() == ""){
	}else if(!reg.test($("#elevenQuarter"+j).val())){
		layer.tips("请输入正确的数字","#elevenQuarter"+j);
		return false;
	}
	
	if($("#twelveQuarter"+j).val() == null || $("#twelveQuarter"+j).val() == ""){
	}else if(!reg.test($("#twelveQuarter"+j).val())){
		layer.tips("请输入正确的数字","#twelveQuarter"+j);
		return false;
	}
	
	
	if($("#woneQuarter"+j).val() == null || $("#woneQuarter"+j).val() == ""){
	}else if(!reg.test($("#woneQuarter"+j).val())){
		layer.tips("请输入正确的数字","#woneQuarter"+j);
		return false;
	}
	
	if($("#wtwoQuarter"+j).val() == null || $("#wtwoQuarter"+j).val() == ""){
	}else if(!reg.test($("#wtwoQuarter"+j).val())){
		layer.tips("请输入正确的数字","#wtwoQuarter"+j);
		return false;
	}
	
	if($("#wthreeQuarter"+j).val() == null || $("#wthreeQuarter"+j).val() == ""){
	}else if(!reg.test($("#wthreeQuarter"+j).val())){
		layer.tips("请输入正确的数字","#wthreeQuarter"+j);
		return false;
	}
	
	if($("#wfourQuarter"+j).val() == null || $("#wfourQuarter"+j).val() == ""){
	}else if(!reg.test($("#wfourQuarter"+j).val())){
		layer.tips("请输入正确的数字","#wfourQuarter"+j);
		return false;
	}
	
	if($("#wfiveQuarter"+j).val() == null || $("#wfiveQuarter"+j).val() == ""){
	}else if(!reg.test($("#wfiveQuarter"+j).val())){
		layer.tips("请输入正确的数字","#wfiveQuarter"+j);
		return false;
	}
	
	if($("#wsixQuarter"+j).val() == null || $("#wsixQuarter"+j).val() == ""){
	}else if(!reg.test($("#wsixQuarter"+j).val())){
		layer.tips("请输入正确的数字","#wsixQuarter"+j);
		return false;
	}
	
	if($("#wsevenQuarter"+j).val() == null || $("#wsevenQuarter"+j).val() == ""){
	}else if(!reg.test($("#wsevenQuarter"+j).val())){
		layer.tips("请输入正确的数字","#wsevenQuarter"+j);
		return false;
	}
	if($("#weightQuarter"+j).val() == null || $("#weightQuarter"+j).val() == ""){
	}else if(!reg.test($("#weightQuarter"+j).val())){
		layer.tips("请输入正确的数字","#weightQuarter"+j);
		return false;
	}
	if($("#wnineQuarter"+j).val() == null || $("#wnineQuarter"+j).val() == ""){
	}else if(!reg.test($("#wnineQuarter"+j).val())){
		layer.tips("请输入正确的数字","#wnineQuarter"+j);
		return false;
	}
	if($("#wtenQuarter"+j).val() == null || $("#wtenQuarter"+j).val() == ""){
	}else if(!reg.test($("#wtenQuarter"+j).val())){
		layer.tips("请输入正确的数字","#wtenQuarter"+j);
		return false;
	}
	if($("#welevenQuarter"+j).val() == null || $("#welevenQuarter"+j).val() == ""){
	}else if(!reg.test($("#welevenQuarter"+j).val())){
		layer.tips("请输入正确的数字","#welevenQuarter"+j);
		return false;
	}
	if($("#wtwelveQuarter"+j).val() == null || $("#wtwelveQuarter"+j).val() == ""){
	}else if(!reg.test($("#wtwelveQuarter"+j).val())){
		layer.tips("请输入正确的数字","#wtwelveQuarter"+j);
		return false;
	}
	
	//每次往下标下面添加tr,因为append是往标签内追加。所以用after
    var insertStr = "<tr id=" + rowId + ">"
                  + "<td >" + firstCell + "</td>"
                  + "<td >" + secondCell + "</td>"
                  + "<td >" + thirdCell + "</td>"
                  + "<td >" + fourthCell + "</td>"
                  + "<td >" + fifthCell + "</td>"
                  + "<td >" + sixthCell + "</td>"
                  + "<td >" + seventhCell + "</td>"
                  + "<td >" + seventhCell5 + "</td>"
                  + "<td >" + seventhCell6 + "</td>"
                  + "<td >" + seventhCell7 + "</td>"
                  + "<td >" + seventhCell8 + "</td>"
                  + "<td >" + seventhCell9 + "</td>"
                  + "<td >" + seventhCell10 + "</td>"
                  + "<td >" + seventhCell11 + "</td>"
                  + "<td >" + seventhCell12 + "</td>"
                  + "<td >" + eighthCell + "</td>"
                  + "<td >" + nineCell + "</td>"
                  + "<td >" + tenCell + "</td>"
                  + "<td >" + elevenCell + "</td>"
                  + "<td >" + twelveCell + "</td>"
                  + "<td >" + twelveCell5 + "</td>"
                  + "<td >" + twelveCell6 + "</td>"
                  + "<td >" + twelveCell7 + "</td>"
                  + "<td >" + twelveCell8 + "</td>"
                  + "<td >" + twelveCell9 + "</td>"
                  + "<td >" + twelveCell10 + "</td>"
                  + "<td >" + twelveCell11 + "</td>"
                  + "<td >" + twelveCell12 + "</td>"
                  + "<td style='text-align: center;'>" + '<img title="删除" src="${ctxStatic}/images/caozuo_icon_sc_moren.png" onclick="deleteSelectedRow(\'' + rowId + '\')">' + "</td>"
                  +"</tr>";
      //这里的行数减2,是因为要减去底部的一行和顶部的一行,剩下的为开始要插入行的索引
      $("#orderTable tr:eq(" + (rowLength - 2) + ")").after(insertStr); //将新拼接的一行插入到当前行的下面
     //为新添加的行里面的控件添加新的id属性。
     $("#" + rowId + " td:eq(0)").children().eq(0).attr("id", "paragraphName"+(rowLength-3));
     $("#" + rowId + " td:eq(1)").children().eq(0).attr("id", "contractAmount" + (rowLength-3));
     $("#" + rowId + " td:eq(2)").children().eq(0).attr("id", "paymentCompleted" + (rowLength-3));
     $("#" + rowId + " td:eq(3)").children().eq(0).attr("id", "firstQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(4)").children().eq(0).attr("id", "twoQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(5)").children().eq(0).attr("id", "threeQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(6)").children().eq(0).attr("id", "fourQuarter" + (rowLength-3));
     
     $("#" + rowId + " td:eq(7)").children().eq(0).attr("id", "fiveQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(8)").children().eq(0).attr("id", "sixQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(9)").children().eq(0).attr("id", "sevenQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(10)").children().eq(0).attr("id", "eightQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(11)").children().eq(0).attr("id", "nineQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(12)").children().eq(0).attr("id", "tenQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(13)").children().eq(0).attr("id", "elevenQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(14)").children().eq(0).attr("id", "twelveQuarter" + (rowLength-3));
     
     $("#" + rowId + " td:eq(15)").children().eq(0).attr("id", "remarks" + (rowLength-3)); 
     $("#" + rowId + " td:eq(16)").children().eq(0).attr("id", "woneQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(17)").children().eq(0).attr("id", "wtwoQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(18)").children().eq(0).attr("id", "wthreeQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(19)").children().eq(0).attr("id", "wfourQuarter" + (rowLength-3));
     
     $("#" + rowId + " td:eq(20)").children().eq(0).attr("id", "wfiveQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(21)").children().eq(0).attr("id", "wsixQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(22)").children().eq(0).attr("id", "wsevenQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(23)").children().eq(0).attr("id", "weightQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(24)").children().eq(0).attr("id", "wnineQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(25)").children().eq(0).attr("id", "wtenQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(26)").children().eq(0).attr("id", "welevenQuarter" + (rowLength-3));
     $("#" + rowId + " td:eq(27)").children().eq(0).attr("id", "wtwelveQuarter" + (rowLength-3));
  }

//-----------------删除一行,根据行ID删除-start

 function deleteSelectedRow(rowID) {
     layer.confirm('确定删除该行吗?', {
   	  btn: ['确定','取消'] //按钮
   	}, function(){
   	  $("#" + rowID).remove();
  		  layer.msg('已删除成功', {icon: 1});
   	}, function(){
   		layer.msg('已取消删除', {icon: 4});
   	});
 }

//保存表格中最新的值

function saveTableValue() { 
	if($("#projectId").val() == null || $("#projectId").val() == ""){
		layer.tips("请选择项目名称!","#projectName");
		return false;
	}
	
	if($("#getYear").val() == null || $("#getYear").val() == ""){
		layer.tips("请选择年份!","#getYear");
		return false;
	}else{
		$("#date").val($("#getYear").val());
	}
   
    
	var myTable = document.getElementById("orderTable");
	tableValue=""; 
	for (var i=2;i<myTable.rows.length-1;i++){
		var value0 = myTable.rows[i].cells[0].getElementsByTagName("input")[1].value;//id
		var value1 = myTable.rows[i].cells[0].getElementsByTagName("input")[0].value;//标段名称及建设内容
		var value2 = myTable.rows[i].cells[1].getElementsByTagName("input")[0].value;//合同金额
		var value3 = myTable.rows[i].cells[2].getElementsByTagName("input")[0].value;//截止上年
		var value4 = myTable.rows[i].cells[3].getElementsByTagName("input")[0].value;//1月计划
		var value5 = myTable.rows[i].cells[4].getElementsByTagName("input")[0].value;//2
		var value6 = myTable.rows[i].cells[5].getElementsByTagName("input")[0].value;//3
		var value7 = myTable.rows[i].cells[6].getElementsByTagName("input")[0].value;//4
		var value8 = myTable.rows[i].cells[7].getElementsByTagName("input")[0].value;//5
		var value9 = myTable.rows[i].cells[8].getElementsByTagName("input")[0].value;//6
		var value10 = myTable.rows[i].cells[9].getElementsByTagName("input")[0].value;//7
		var value11 = myTable.rows[i].cells[10].getElementsByTagName("input")[0].value;//8
		var value12 = myTable.rows[i].cells[11].getElementsByTagName("input")[0].value;//9
		var value13 = myTable.rows[i].cells[12].getElementsByTagName("input")[0].value;//10
		var value14 = myTable.rows[i].cells[13].getElementsByTagName("input")[0].value;//11
		var value15 = myTable.rows[i].cells[14].getElementsByTagName("input")[0].value;//12
		var value16 = myTable.rows[i].cells[15].getElementsByTagName("input")[0].value;//备注
		
		var value17 = myTable.rows[i].cells[16].getElementsByTagName("input")[0].value;//1月实际
		var value18 = myTable.rows[i].cells[17].getElementsByTagName("input")[0].value;//2
		var value19 = myTable.rows[i].cells[18].getElementsByTagName("input")[0].value;//3
		var value20 = myTable.rows[i].cells[19].getElementsByTagName("input")[0].value;//4
		var value21 = myTable.rows[i].cells[20].getElementsByTagName("input")[0].value;//5
		var value22 = myTable.rows[i].cells[21].getElementsByTagName("input")[0].value;//6
		var value23 = myTable.rows[i].cells[22].getElementsByTagName("input")[0].value;//7
		var value24 = myTable.rows[i].cells[23].getElementsByTagName("input")[0].value;//8
		var value25 = myTable.rows[i].cells[24].getElementsByTagName("input")[0].value;//9
		var value26 = myTable.rows[i].cells[25].getElementsByTagName("input")[0].value;//10
		var value27 = myTable.rows[i].cells[26].getElementsByTagName("input")[0].value;//11
		var value28 = myTable.rows[i].cells[27].getElementsByTagName("input")[0].value;//12
		
		//验证  不需要的可以去掉
		var j = parseInt(i-2);
        var reg =/^-?\d+\.?\d*$/;
		if($("#paragraphName"+j).val()==""){
			layer.tips("标段名称及建设内容不能为空","#paragraphName"+j);
			return false;
		}
		if($("#contractAmount"+j).val() == null || $("#contractAmount"+j).val() == ""){
			layer.tips("合同金额不能为空","#contractAmount"+j);
			return false;
		}else if(!reg.test($("#contractAmount"+j).val())){
    		layer.tips("请输入正确的数字","#contractAmount"+j);
			return false;
    	}
		if($("#paymentCompleted"+j).val() == null || $("#paymentCompleted"+j).val() == ""){
		}else if(!reg.test($("#paymentCompleted"+j).val())){
    		layer.tips("请输入正确的数字","#paymentCompleted"+j);
			return false;
    	}
		if($("#firstQuarter"+j).val() == null || $("#firstQuarter"+j).val() == ""){
		}else if(!reg.test($("#firstQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#firstQuarter"+j);
			return false;
    	}
		if($("#twoQuarter"+j).val() == null || $("#twoQuarter"+j).val() == ""){
		}else if(!reg.test($("#twoQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#twoQuarter"+j);
			return false;
    	}
		if($("#threeQuarter"+j).val() == null || $("#threeQuarter"+j).val() == ""){
		}else if(!reg.test($("#threeQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#threeQuarter"+j);
			return false;
    	}
		if($("#fourQuarter"+j).val() == null || $("#fourQuarter"+j).val() == ""){
		}else if(!reg.test($("#fourQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#fourQuarter"+j);
			return false;
    	}
		if($("#fiveQuarter"+j).val() == null || $("#fiveQuarter"+j).val() == ""){
		}else if(!reg.test($("#fiveQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#fiveQuarter"+j);
			return false;
    	}
		if($("#sixQuarter"+j).val() == null || $("#sixQuarter"+j).val() == ""){
		}else if(!reg.test($("#sixQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#sixQuarter"+j);
			return false;
    	}
		if($("#sevenQuarter"+j).val() == null || $("#sevenQuarter"+j).val() == ""){
		}else if(!reg.test($("#sevenQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#sevenQuarter"+j);
			return false;
    	}
		if($("#eightQuarter"+j).val() == null || $("#eightQuarter"+j).val() == ""){
		}else if(!reg.test($("#eightQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#eightQuarter"+j);
			return false;
    	}
		if($("#nineQuarter"+j).val() == null || $("#nineQuarter"+j).val() == ""){
		}else if(!reg.test($("#nineQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#nineQuarter"+j);
			return false;
    	}
		if($("#tenQuarter"+j).val() == null || $("#tenQuarter"+j).val() == ""){
		}else if(!reg.test($("#tenQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#tenQuarter"+j);
			return false;
    	}
		if($("#elevenQuarter"+j).val() == null || $("#elevenQuarter"+j).val() == ""){
		}else if(!reg.test($("#elevenQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#elevenQuarter"+j);
			return false;
    	}
		
		if($("#twelveQuarter"+j).val() == null || $("#twelveQuarter"+j).val() == ""){
		}else if(!reg.test($("#twelveQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#twelveQuarter"+j);
			return false;
    	}
		
		
		if($("#woneQuarter"+j).val() == null || $("#woneQuarter"+j).val() == ""){
		}else if(!reg.test($("#woneQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#woneQuarter"+j);
			return false;
    	}
		
		if($("#wtwoQuarter"+j).val() == null || $("#wtwoQuarter"+j).val() == ""){
		}else if(!reg.test($("#wtwoQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#wtwoQuarter"+j);
			return false;
    	}
		
		if($("#wthreeQuarter"+j).val() == null || $("#wthreeQuarter"+j).val() == ""){
		}else if(!reg.test($("#wthreeQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#wthreeQuarter"+j);
			return false;
    	}
		
		if($("#wfourQuarter"+j).val() == null || $("#wfourQuarter"+j).val() == ""){
		}else if(!reg.test($("#wfourQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#wfourQuarter"+j);
			return false;
    	}
		
		if($("#wfiveQuarter"+j).val() == null || $("#wfiveQuarter"+j).val() == ""){
		}else if(!reg.test($("#wfiveQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#wfiveQuarter"+j);
			return false;
    	}
		
    	if($("#wsixQuarter"+j).val() == null || $("#wsixQuarter"+j).val() == ""){
		}else if(!reg.test($("#wsixQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#wsixQuarter"+j);
			return false;
    	}
    	
    	if($("#wsevenQuarter"+j).val() == null || $("#wsevenQuarter"+j).val() == ""){
		}else if(!reg.test($("#wsevenQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#wsevenQuarter"+j);
			return false;
    	}
    	if($("#weightQuarter"+j).val() == null || $("#weightQuarter"+j).val() == ""){
		}else if(!reg.test($("#weightQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#weightQuarter"+j);
			return false;
    	}
    	if($("#wnineQuarter"+j).val() == null || $("#wnineQuarter"+j).val() == ""){
		}else if(!reg.test($("#wnineQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#wnineQuarter"+j);
			return false;
    	}
    	if($("#wtenQuarter"+j).val() == null || $("#wtenQuarter"+j).val() == ""){
		}else if(!reg.test($("#wtenQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#wtenQuarter"+j);
			return false;
    	}
    	if($("#welevenQuarter"+j).val() == null || $("#welevenQuarter"+j).val() == ""){
		}else if(!reg.test($("#welevenQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#welevenQuarter"+j);
			return false;
    	}
    	if($("#wtwelveQuarter"+j).val() == null || $("#wtwelveQuarter"+j).val() == ""){
		}else if(!reg.test($("#wtwelveQuarter"+j).val())){
    		layer.tips("请输入正确的数字","#wtwelveQuarter"+j);
			return false;
    	}
		//拼接
		var rowValue=value0+"@"+value1+"@"+value2+"@"+value3+"@"+value4+"@"+value5+"@"+value6+"@"+value7+"@"+value8+"@"+value9+"@"+value10+"@"+value11+"@"+value12+"@"+value13+"@"+value14+"@"+value15+"@"+value16
		+"@"+value17+"@"+value18+"@"+value19+"@"+value20+"@"+value21+"@"+value22+"@"+value23+"@"+value24+"@"+value25+"@"+value26+"@"+value27+"@"+value28; //"@"来连接 
		tableValue=tableValue+rowValue+"//";
	} 
	//塞到隐藏的input中提交到后台   后台截取
	$("#dataList").val(tableValue);//把表格的值付给input 
	$("#inputForm").attr("action","${ctx}/group/paymentPlanCopy/save");
	$("#inputForm").submit();
}

页面

页面效果
页面样式,没有截全。

jsp 表格

标段名称及建设内容合同金额截止上年底
已完成支付
计划完成(万元)备注实际完成(万元)操作
一月二月三月四月五月六月七月八月九月十月十一月十二月一月二月三月四月五月六月七月八月九月十月十一月十二月
新增一行

后台

	String id=paymentPlanCopy.getId();
	if(id.equals("") || "".equals(id) || id=="" || id==null) {
		id=IdGen.uuid();
		paymentPlanCopy.setId(id);
		paymentPlanCopy.setCreateBy(UserUtils.getU
		ser());
		paymentPlanCopy.setCreateDate(new Date());
		paymentPlanCopy.setUpdateBy(UserUtils.getUser());
		paymentPlanCopy.setUpdateDate(new Date());
		paymentPlanCopyService.insert(paymentPlanCopy);
	}else {
		paymentPlanCopyService.save(paymentPlanCopy);
	}
	
	//获取刚才隐藏提交的input的值
	String str = paymentPlanCopy.getDataList();
	String[] strs=str.split("//");
	for(int i=0,len=strs.length;i<=len-1;i++){
		String[] strs2 = strs[i].split("@");
		if(strs2[0].equals("tid")) {
			PaymentPlanDetail tidPlan =new PaymentPlanDetail();
			tidPlan.setId(IdGen.uuid());
			tidPlan.setFatherId(id);
			if(strs2.length>1) {
				if(strs2[1].equals("") || "".equals(strs2[1]) || strs2[1]=="" || strs2[1]==null) {
					tidPlan.setParagraphName("--");
				}else {
					tidPlan.setParagraphName(strs2[1]);
				}
			}
			if(strs2.length>2) {
				if(strs2[2].equals("") || "".equals(strs2[2]) || strs2[2]=="" || strs2[2]==null) {
					tidPlan.setContractAmount(0+"");
				}else {
					tidPlan.setContractAmount(strs2[2]);
				}
			
			}
			if(strs2.length>3) {
				if(strs2[3].equals("") || "".equals(strs2[3]) || strs2[3]=="" || strs2[3]==null) {
					tidPlan.setPaymentCompleted(0+"");
				}else {
					tidPlan.setPaymentCompleted(strs2[3]);
				}
			
			}
			if(strs2.length>4) {
				if(strs2[4].equals("") || "".equals(strs2[4]) || strs2[4]=="" || strs2[4]==null) {
					tidPlan.setFirstQuarter(0+"");
				}else {
					tidPlan.setFirstQuarter(strs2[4]);
				}
			}
			
			if(strs2.length>5) {
				if(strs2[5].equals("") || "".equals(strs2[5]) || strs2[5]=="" || strs2[5]==null) {
					tidPlan.setTwoQuarter(0+"");
				}else {
					tidPlan.setTwoQuarter(strs2[5]);
				}
			}
			if(strs2.length>6) {
				if(strs2[6].equals("") || "".equals(strs2[6]) || strs2[6]=="" || strs2[6]==null) {
					tidPlan.setThreeQuarter(0+"");
				}else {
					tidPlan.setThreeQuarter(strs2[6]);
				}
			}
			if(strs2.length>7) {
				if(strs2[7].equals("") || "".equals(strs2[7]) || strs2[7]=="" || strs2[7]==null) {
					tidPlan.setFourQuarter(0+"");
				}else {
					tidPlan.setFourQuarter(strs2[7]);
				}
			}
			if(strs2.length>8) {
				if(strs2[8].equals("") || "".equals(strs2[8]) || strs2[8]=="" || strs2[8]==null) {
					tidPlan.setFiveQuarter(0+"");
				}else {
					tidPlan.setFiveQuarter(strs2[8]);
				}
			}
			if(strs2.length>9) {
				if(strs2[9].equals("") || "".equals(strs2[9]) || strs2[9]=="" || strs2[9]==null) {
					tidPlan.setSixQuarter(0+"");
				}else {
					tidPlan.setSixQuarter(strs2[9]);
				} 
			}
			if(strs2.length>10) {
				if(strs2[10].equals("") || "".equals(strs2[10]) || strs2[10]=="" || strs2[10]==null) {
					tidPlan.setSevenQuarter(0+"");
				}else {
					tidPlan.setSevenQuarter(strs2[10]);
				} 
			}
			if(strs2.length>11) {
				if(strs2[11].equals("") || "".equals(strs2[11]) || strs2[11]=="" || strs2[11]==null) {
					tidPlan.setEightQuarter(0+"");
				}else {
					tidPlan.setEightQuarter(strs2[11]);
				} 
			}
			
			if(strs2.length>12) {
				if(strs2[12].equals("") || "".equals(strs2[12]) || strs2[12]=="" || strs2[12]==null) {
					tidPlan.setNineQuarter(0+"");
				}else {
					tidPlan.setNineQuarter(strs2[12]);
				} 
			}
			if(strs2.length>13) {
				if(strs2[13].equals("") || "".equals(strs2[13]) || strs2[13]=="" || strs2[13]==null) {
					tidPlan.setTenQuarter(0+"");
				}else {
					tidPlan.setTenQuarter(strs2[13]);
				} 
			}
			if(strs2.length>14) {
				if(strs2[14].equals("") || "".equals(strs2[14]) || strs2[14]=="" || strs2[14]==null) {
					tidPlan.setElevenQuarter(0+"");
				}else {
					tidPlan.setElevenQuarter(strs2[14]);
				} 
			}
			if(strs2.length>15) {
				if(strs2[15].equals("") || "".equals(strs2[15]) || strs2[15]=="" || strs2[15]==null) {
					tidPlan.setTwelveQuarter(0+"");
				}else {
					tidPlan.setTwelveQuarter(strs2[15]);
				} 
			}
			if(strs2.length>16) {
				if(strs2[16].equals("") || "".equals(strs2[16]) || strs2[16]=="" || strs2[16]==null) {
					tidPlan.setRemarks("无");
				}else {
					tidPlan.setRemarks(strs2[16]);
				} 
			}
			if(strs2.length>17) {
				if(strs2[17].equals("") || "".equals(strs2[17]) || strs2[17]=="" || strs2[17]==null) {
					tidPlan.setWoneQuarter(0+"");
				}else {
					tidPlan.setWoneQuarter(strs2[17]);
				} 
			}
			if(strs2.length>18) {
				if(strs2[18].equals("") || "".equals(strs2[18]) || strs2[18]=="" || strs2[18]==null) {
					tidPlan.setWtwoQuarter(0+"");
				}else {
					tidPlan.setWtwoQuarter(strs2[18]);
				} 
			}
			if(strs2.length>19) {
				if(strs2[19].equals("") || "".equals(strs2[19]) || strs2[19]=="" || strs2[19]==null) {
					tidPlan.setWthreeQuarter(0+"");
				}else {
					tidPlan.setWthreeQuarter(strs2[19]);
				} 
			}
			if(strs2.length>20) {
				if(strs2[20].equals("") || "".equals(strs2[20]) || strs2[20]=="" || strs2[20]==null) {
					tidPlan.setWfourQuarter(0+"");
				}else {
					tidPlan.setWfourQuarter(strs2[20]);
				} 
			}
			if(strs2.length>21) {
				if(strs2[21].equals("") || "".equals(strs2[21]) || strs2[21]=="" || strs2[21]==null) {
					tidPlan.setWfiveQuarter(0+"");
				}else {
					tidPlan.setWfiveQuarter(strs2[21]);
				} 
			}
			if(strs2.length>22) {
				if(strs2[22].equals("") || "".equals(strs2[22]) || strs2[22]=="" || strs2[22]==null) {
					tidPlan.setWsixQuarter(0+"");
				}else {
					tidPlan.setWsixQuarter(strs2[22]);
				} 
			}
			if(strs2.length>23) {
				if(strs2[23].equals("") || "".equals(strs2[23]) || strs2[23]=="" || strs2[23]==null) {
					tidPlan.setWsevenQuarter(0+"");
				}else {
					tidPlan.setWsevenQuarter(strs2[23]);
				} 
			}
			if(strs2.length>24) {
				if(strs2[24].equals("") || "".equals(strs2[24]) || strs2[24]=="" || strs2[24]==null) {
					tidPlan.setWeightQuarter(0+"");
				}else {
					tidPlan.setWeightQuarter(strs2[24]);
				} 
			}
			if(strs2.length>25) {
				if(strs2[25].equals("") || "".equals(strs2[25]) || strs2[25]=="" || strs2[25]==null) {
					tidPlan.setWnineQuarter(0+"");
				}else {
					tidPlan.setWnineQuarter(strs2[25]);
				} 
			}
			if(strs2.length>26) {
				if(strs2[26].equals("") || "".equals(strs2[26]) || strs2[26]=="" || strs2[26]==null) {
					tidPlan.setWtenQuarter(0+"");
				}else {
					tidPlan.setWtenQuarter(strs2[26]);
				} 
			}
			if(strs2.length>27) {
				if(strs2[27].equals("") || "".equals(strs2[27]) || strs2[27]=="" || strs2[27]==null) {
					tidPlan.setWelevenQuarter(0+"");
				}else {
					tidPlan.setWelevenQuarter(strs2[27]);
				} 
			}
			if(strs2.length>28) {
				if(strs2[28].equals("") || "".equals(strs2[28]) || strs2[28]=="" || strs2[28]==null) {
					tidPlan.setWtwelveQuarter(0+"");
				}else {
					tidPlan.setWtwelveQuarter(strs2[28]);
				} 
			}
			tidPlan.setCreateBy(UserUtils.getUser());
			tidPlan.setCreateDate(new Date());
			tidPlan.setUpdateBy(UserUtils.getUser());
			tidPlan.setUpdateDate(new Date());
			paymentPlanDetailService.insert(tidPlan);
		}else if(strs2[0].equals("")){
			
		}else {
			PaymentPlanDetail idPlan =new PaymentPlanDetail();
			idPlan.setId(strs2[0]);
			idPlan.setFatherId(id);
			if(strs2.length>1) {
				if(strs2[1].equals("") || "".equals(strs2[1]) || strs2[1]=="" || strs2[1]==null) {
					idPlan.setParagraphName("--");
				}else {
					idPlan.setParagraphName(strs2[1]);
				}
			}
			if(strs2.length>2) {
				if(strs2[2].equals("") || "".equals(strs2[2]) || strs2[2]=="" || strs2[2]==null) {
					idPlan.setContractAmount(0+"");
				}else {
					idPlan.setContractAmount(strs2[2]);
				}
			
			}
			if(strs2.length>3) {
				if(strs2[3].equals("") || "".equals(strs2[3]) || strs2[3]=="" || strs2[3]==null) {
					idPlan.setPaymentCompleted(0+"");
				}else {
					idPlan.setPaymentCompleted(strs2[3]);
				}
			
			}
			if(strs2.length>4) {
				if(strs2[4].equals("") || "".equals(strs2[4]) || strs2[4]=="" || strs2[4]==null) {
					idPlan.setFirstQuarter(0+"");
				}else {
					idPlan.setFirstQuarter(strs2[4]);
				}
			}
			
			if(strs2.length>5) {
				if(strs2[5].equals("") || "".equals(strs2[5]) || strs2[5]=="" || strs2[5]==null) {
					idPlan.setTwoQuarter(0+"");
				}else {
					idPlan.setTwoQuarter(strs2[5]);
				}
			}
			if(strs2.length>6) {
				if(strs2[6].equals("") || "".equals(strs2[6]) || strs2[6]=="" || strs2[6]==null) {
					idPlan.setThreeQuarter(0+"");
				}else {
					idPlan.setThreeQuarter(strs2[6]);
				}
			}
			if(strs2.length>7) {
				if(strs2[7].equals("") || "".equals(strs2[7]) || strs2[7]=="" || strs2[7]==null) {
					idPlan.setFourQuarter(0+"");
				}else {
					idPlan.setFourQuarter(strs2[7]);
				}
			}
			if(strs2.length>8) {
				if(strs2[8].equals("") || "".equals(strs2[8]) || strs2[8]=="" || strs2[8]==null) {
					idPlan.setFiveQuarter(0+"");
				}else {
					idPlan.setFiveQuarter(strs2[8]);
				}
			}
			if(strs2.length>9) {
				if(strs2[9].equals("") || "".equals(strs2[9]) || strs2[9]=="" || strs2[9]==null) {
					idPlan.setSixQuarter(0+"");
				}else {
					idPlan.setSixQuarter(strs2[9]);
				} 
			}
			if(strs2.length>10) {
				if(strs2[10].equals("") || "".equals(strs2[10]) || strs2[10]=="" || strs2[10]==null) {
					idPlan.setSevenQuarter(0+"");
				}else {
					idPlan.setSevenQuarter(strs2[10]);
				} 
			}
			if(strs2.length>11) {
				if(strs2[11].equals("") || "".equals(strs2[11]) || strs2[11]=="" || strs2[11]==null) {
					idPlan.setEightQuarter(0+"");
				}else {
					idPlan.setEightQuarter(strs2[11]);
				} 
			}
			
			if(strs2.length>12) {
				if(strs2[12].equals("") || "".equals(strs2[12]) || strs2[12]=="" || strs2[12]==null) {
					idPlan.setNineQuarter(0+"");
				}else {
					idPlan.setNineQuarter(strs2[12]);
				} 
			}
			if(strs2.length>13) {
				if(strs2[13].equals("") || "".equals(strs2[13]) || strs2[13]=="" || strs2[13]==null) {
					idPlan.setTenQuarter(0+"");
				}else {
					idPlan.setTenQuarter(strs2[13]);
				} 
			}
			if(strs2.length>14) {
				if(strs2[14].equals("") || "".equals(strs2[14]) || strs2[14]=="" || strs2[14]==null) {
					idPlan.setElevenQuarter(0+"");
				}else {
					idPlan.setElevenQuarter(strs2[14]);
				} 
			}
			if(strs2.length>15) {
				if(strs2[15].equals("") || "".equals(strs2[15]) || strs2[15]=="" || strs2[15]==null) {
					idPlan.setTwelveQuarter(0+"");
				}else {
					idPlan.setTwelveQuarter(strs2[15]);
				} 
			}
			if(strs2.length>16) {
				if(strs2[16].equals("") || "".equals(strs2[16]) || strs2[16]=="" || strs2[16]==null) {
					idPlan.setRemarks("无");
				}else {
					idPlan.setRemarks(strs2[16]);
				} 
			}
			if(strs2.length>17) {
				if(strs2[17].equals("") || "".equals(strs2[17]) || strs2[17]=="" || strs2[17]==null) {
					idPlan.setWoneQuarter(0+"");
				}else {
					idPlan.setWoneQuarter(strs2[17]);
				} 
			}
			if(strs2.length>18) {
				if(strs2[18].equals("") || "".equals(strs2[18]) || strs2[18]=="" || strs2[18]==null) {
					idPlan.setWtwoQuarter(0+"");
				}else {
					idPlan.setWtwoQuarter(strs2[18]);
				} 
			}
			if(strs2.length>19) {
				if(strs2[19].equals("") || "".equals(strs2[19]) || strs2[19]=="" || strs2[19]==null) {
					idPlan.setWthreeQuarter(0+"");
				}else {
					idPlan.setWthreeQuarter(strs2[19]);
				} 
			}
			if(strs2.length>20) {
				if(strs2[20].equals("") || "".equals(strs2[20]) || strs2[20]=="" || strs2[20]==null) {
					idPlan.setWfourQuarter(0+"");
				}else {
					idPlan.setWfourQuarter(strs2[20]);
				} 
			}
			if(strs2.length>21) {
				if(strs2[21].equals("") || "".equals(strs2[21]) || strs2[21]=="" || strs2[21]==null) {
					idPlan.setWfiveQuarter(0+"");
				}else {
					idPlan.setWfiveQuarter(strs2[21]);
				} 
			}
			if(strs2.length>22) {
				if(strs2[22].equals("") || "".equals(strs2[22]) || strs2[22]=="" || strs2[22]==null) {
					idPlan.setWsixQuarter(0+"");
				}else {
					idPlan.setWsixQuarter(strs2[22]);
				} 
			}
			if(strs2.length>23) {
				if(strs2[23].equals("") || "".equals(strs2[23]) || strs2[23]=="" || strs2[23]==null) {
					idPlan.setWsevenQuarter(0+"");
				}else {
					idPlan.setWsevenQuarter(strs2[23]);
				} 
			}
			if(strs2.length>24) {
				if(strs2[24].equals("") || "".equals(strs2[24]) || strs2[24]=="" || strs2[24]==null) {
					idPlan.setWeightQuarter(0+"");
				}else {
					idPlan.setWeightQuarter(strs2[24]);
				} 
			}
			if(strs2.length>25) {
				if(strs2[25].equals("") || "".equals(strs2[25]) || strs2[25]=="" || strs2[25]==null) {
					idPlan.setWnineQuarter(0+"");
				}else {
					idPlan.setWnineQuarter(strs2[25]);
				} 
			}
			if(strs2.length>26) {
				if(strs2[26].equals("") || "".equals(strs2[26]) || strs2[26]=="" || strs2[26]==null) {
					idPlan.setWtenQuarter(0+"");
				}else {
					idPlan.setWtenQuarter(strs2[26]);
				} 
			}
			if(strs2.length>27) {
				if(strs2[27].equals("") || "".equals(strs2[27]) || strs2[27]=="" || strs2[27]==null) {
					idPlan.setWelevenQuarter(0+"");
				}else {
					idPlan.setWelevenQuarter(strs2[27]);
				} 
			}
			if(strs2.length>28) {
				if(strs2[28].equals("") || "".equals(strs2[28]) || strs2[28]=="" || strs2[28]==null) {
					idPlan.setWtwelveQuarter(0+"");
				}else {
					idPlan.setWtwelveQuarter(strs2[28]);
				} 
			}
			idPlan.setUpdateBy(UserUtils.getUser());
			idPlan.setUpdateDate(new Date());
			paymentPlanDetailService.save(idPlan);
		}
	}
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Java是一种功能强大的编程语言,可以很好地处理超大文本解析存库的需求。在处理超大文本时,我们可以使用Java提供的各种库和技术来实现高效的解析和存储。 首先,我们可以使用Java的输入输出流来读取超大文本文件。通过逐行读取文本文件,我们可以避免一次性将整个文件加载到内存中,从而减少了内存的消耗。同时,我们也可以使用缓冲流来提高读写效率。 其次,我们可以使用Java提供的字符串处理函数和正则表达式来解析和提取超大文本中的数据。通过使用合适的字符串处理方法,我们可以快速准确地提取出所需的信息,并进行必要的格式转换和数据清洗。 在解析过程中,我们可以使用Java的多线程技术来提高解析速度。通过将文本分割成多个子任务,每个子任务由一个独立的线程处理,可以并行地进行解析操作,从而大大加快了整个解析过程。 最后,我们可以使用Java的数据库连接技术将解析得到的数据存储到数据库中。Java提供了多种数据库连接方式,如JDBC、Hibernate等,可以方便地将解析得到的数据插入到数据库中,实现持久化存储。 总的来说,Java提供了丰富的库和技术,可以很好地解决超大文本解析存库的问题。通过合理地选择和使用Java提供的功能,我们可以高效地处理大量的文本数据,并将其存储到数据库中,为后续的分析和应用提供便利。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值