//声明全局变量
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);
}
}