C#结合JS实现HtmlTable动态添加行并保存到数据库_html点击添加表格添加一行数据,并保存中数据

<form  runat="server">
<asp:TextBox ID="cid" style="display:none" runat="server"></asp:TextBox>
<asp:TextBox ID="com_name" style="display:none" runat="server"></asp:TextBox>
<asp:TextBox ID="xmbh" style="display:none" runat="server"></asp:TextBox>
<asp:TextBox ID="sfzh" style="display:none" runat="server"></asp:TextBox>
<asp:TextBox ID="p_acode"  Runat="server" Visible="true" style="display:none" ></asp:TextBox>
<asp:TextBox ID="curid"  Runat="server" Visible="true" style="display:none" ></asp:TextBox>
<asp:TextBox ID="pjson" TextMode="MultiLine"  Runat="server" Visible="true" style="display:none" ></asp:TextBox>
<asp:TextBox ID="djson" TextMode="MultiLine"  Runat="server" Visible="true" style="display:none" ></asp:TextBox>
<div id="topnavs" runat="server" style=" z-index:9999; border-bottom: 1px solid silver; padding:3px;display:flex;justify-content:start; background-color:rgb(235,235,235); position:fixed;top:0px;left:0px;width:100%;height:30px; text-align:center; line-height:30px;">
<input id="closebutton" runat="server" type="button" value='' style=" border-width:0px; background-position:center; background-image:url(/images/att_add6.jpg);font-size:14pt;cursor:pointer;width:25px;height:25px;" onclick="addRow()" class="" />
<input id="Button1" runat="server" type="button" value='' style=" border-width:0px;background-position:center;  background-image:url(/images/att_del.jpg); margin-left:5px; font-size:14pt;cursor:pointer;width:25px;height:25px;" onclick='delinfo()' class="" />
<input id="Button2" runat="server" type="button" value='' style="border-width:0px; background-position:center; background-image:url(/images/att_up2.jpg); margin-left:5px; font-size:14pt;cursor:pointer;width:25px;height:25px;" onclick="swarp(document.getElementById('curid').value,1);" class="" />
<input id="Button3" runat="server" type="button" value='' style="border-width:0px; background-position:center; background-image:url(/images/att_down3.jpg); margin-left:5px; font-size:14pt;cursor:pointer;width:25px;height:25px;" onclick="swarp(document.getElementById('curid').value,2);" class="" />
<input id="Button4" runat="server" type="button" value='' style="border-width:0px; background-position:center; background-image:url(/images/att_save.jpg); margin-left:5px; font-size:14pt;cursor:pointer;width:25px;height:25px;" onclick="if (validall('') == false) {document.getElementById('Button4').removeAttribute('disabled');return;}saveall();if(document.getElementById('mtable').rows.length>0){ this.setAttribute('disabled','true');}" class="" />
<div id="saved" style="margin-left:10px; font-weight:bold; font-size:11pt; color:Red; "></div>
</div>
<table align="left" id="ttable" runat="server" style="z-index:9999;position:fixed;left:0px;top:37px;table-layout: fixed;word-break: break-all; word-wrap: break-word;font-size:10pt; width:700px; background-color:rgb(235,235,235);border-color:rgb(235,235,235); border-width:1px 1px 1px 1px;border-collapse:collapse;"  border="1" cellspacing="0" cellpadding="3">
</table>
<table align="left" id="mtable" runat="server" style="table-layout: fixed;word-break: break-all; word-wrap: break-word;font-size:10pt; width:700px; position:absolute;left:0px;top:67px; border-color:rgb(235,235,235); border-width:1px 1px 1px 1px;border-collapse:collapse;"  border="1" cellspacing="0" cellpadding="3">
</table>
</form>

<script language="javascript">
    function simplecheck(chkobj, _chkvalue, allowAlert,etip) {
        check_result = true; check_errid = ''; check_errmsg = '';var _checkSchema = chkobj.getAttribute('checkSchema');var _cName = chkobj.getAttribute('cName');
        if (_checkSchema.indexOf('ctrim') != -1) { _chkvalue = ctrim(_chkvalue); } var _objlength = _chkvalue.length; if (_checkSchema.indexOf('abslen') != -1) { _objlength = PositionLen(_chkvalue); }
        var _schemaList = _checkSchema.split('|'); var _reqeustnotnull = false;
        for (var k = 0; k < _schemaList.length; k++) { if (_schemaList[k].toLowerCase() == 'notnull') { _reqeustnotnull = true; } }
        if ((!_reqeustnotnull) && (_chkvalue == '')) { return check_result; }
        for (var j = 0; j < _schemaList.length; j++) {
            var curSchema = _schemaList[j].toLowerCase(); check_errid = curSchema; var curErrmsg = ''; switch (true) { case curSchema == 'notnull': check_result = isNotNull(_chkvalue); curErrmsg = _cName + '需要填写内容！'; break; case curSchema == 'number': check_result = isNumber(_chkvalue); curErrmsg = _cName + ' 输入的数值不合理，请核对！'; break; case curSchema == 'bnumber': check_result = isBNumber(_chkvalue); curErrmsg = _cName + ' 输入的数值应为>=0的正数，请核对！'; break; case curSchema == 'snumber': check_result = isSNumber(_chkvalue); curErrmsg = _cName + ' 输入的数值应为<0的负数，请核对！'; break; case curSchema == 'date': check_result = isDate(_chkvalue, _cName); check_errid = 'date'; check_errmsg = (check_result ? '' : _cName + ' 输入的日期不合理，请核对！'); curErrmsg = ''; break; case curSchema.indexOf('minlen') != -1: var _slen = parseInt(curSchema.substr('minlen'.length, curSchema.length - 'minlen'.length), 10); if (isNaN(_slen)) { check_result = false; curErrmsg = _cName + ' 输入的最小位数参数不合理，请与软件供应商联系！'; } else { check_result = (_objlength < _slen ? false : true); curErrmsg = _cName + ' 的内容要求最小输入' + _slen + '位，请核对！'; } break; case curSchema.indexOf('maxlen') != -1: var _slen = parseInt(curSchema.substr('maxlen'.length, curSchema.length - 'maxlen'.length), 10); if (isNaN(_slen)) { check_result = false; curErrmsg = _cName + ' 输入的最大位数参数不合理，请与软件供应商联系！'; } else { check_result = (_objlength > _slen ? false : true); curErrmsg = _cName + ' 最大允许输入' + _slen + '位，请核对！'; } break; case curSchema.indexOf('mustlen') != -1: var _slen = parseInt(curSchema.substr('mustlen'.length, curSchema.length - 'mustlen'.length), 10); if (isNaN(_slen)) { check_result = false; curErrmsg = _cName + ' 输入的限制位数参数不合理，请与软件供应商联系！'; } else { check_result = (_objlength != _slen ? false : true); curErrmsg = _cName + ' 的内容输入长度只能是' + _slen + '位，请核对！'; } break; case curSchema == 'time': check_result = validRegs(_chkvalue, /^\d{1,2}:\d{1,2}:\d{1,2}$/); curErrmsg = _cName + ' 输入的时间不合理，请核对。'; break; case curSchema == 'alpha': check_result = isAlpha(_chkvalue); curErrmsg = _cName + ' 只能输入的数字、字母和下划线，请核对。'; break; case curSchema == 'mail': check_result = validRegs(_chkvalue, /^([a-zA-Z0-9._-])+@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-])+/); curErrmsg = _cName + ' 输入的邮件地址不合理，请核对。'; break; case curSchema == 'phone': check_result = validRegs(_chkvalue, /([a-zA-Z0-9\.-\u4e00-\u9fa5]{8,})$/); curErrmsg = _cName + ' 输入的电话号码不合理，请核对。'; break; case curSchema == 'mobile': check_result = validRegs(_chkvalue, /^1(3[0-9]|5[012356789]|8[056789])\d{8}$/); curErrmsg = _cName + ' 输入的手机号码不合理，请核对。'; break; case curSchema == 'money': check_result = validRegs(_chkvalue, /^\d+(\.\d+)?$/); curErrmsg = _cName + ' 输入的内容不符合货币类型的要求，请核对。'; break; case curSchema == 'zip': check_result = validRegs(_chkvalue, /^[1-9]\d{5}$/); curErrmsg = _cName + ' 输入的邮政编码不合理，请核对。'; break; case curSchema == 'int': check_result = validRegs(_chkvalue, /^[-\+]?\d+$/); curErrmsg = _cName + ' 需要输入一个整数，请核对。'; break; case curSchema == 'en': check_result = validRegs(_chkvalue, /^[A-Za-z]+$/); curErrmsg = _cName + ' 只能输入英文大小写字母，请核对。'; break; case curSchema == 'cn': check_result = validRegs(_chkvalue, /^[\u0391-\uFFE5]+$/); curErrmsg = _cName + ' 只能输入中文，请核对。'; break; case curSchema == 'url': check_result = validRegs(_chkvalue, /([\w-]+\.)+[\w-]+(\/[\w- .\/?%&=]*)?/); curErrmsg = _cName + ' 输入的网址不合理，请核对。'; break; case curSchema == 'idcard18': rv_result = checkIdcard(_chkvalue); check_result = (rv_result == '' ? true : false); curErrmsg = _cName + rv_result; break; case curSchema == 'idcard15': rv_result = checkIdcard(_chkvalue); check_result = (rv_result == '' ? true : false); curErrmsg = _cName + rv_result; break; case curSchema == 'idcard': rv_result = checkIdcard(_chkvalue); check_result = (rv_result == '' ? true : false); curErrmsg = _cName + rv_result; break; } if (!check_result) {
                if (curErrmsg != '') { check_errmsg = etip + curErrmsg; } if ((curErrmsg != '') && (allowAlert)) { document.getElementById('saved').innerHTML = etip + curErrmsg; alert(etip + curErrmsg); return check_result; }
            }
        }
        return check_result;
    }
    function checkIdcard(idcard) {
        var _idcard = idcard;  var Errors = new Array('', '身份证号码位数不对!', '身份证号码出生日期超出范围或含有非法字符!', '身份证号码校验错误!', '身份证地区非法!', '');
        if (_idcard == '') { return Errors[5]; }
        var area = { 11: '北京', 12: '天津', 13: '河北', 14: '山西', 15: '内蒙古', 21: '辽宁', 22: '吉林', 23: '黑龙江', 31: '上海', 32: '江苏', 33: '浙江', 34: '安徽', 35: '福建', 36: '江西', 37: '山东', 41: '河南', 42: '湖北', 43: '湖南', 44: '广东', 45: '广西', 46: '海南', 50: '重庆', 51: '四川', 52: '贵州', 53: '云南', 54: '西藏', 61: '陕西', 62: '甘肃', 63: '青海', 64: '宁夏', 65: '新疆', 71: '台湾', 81: '香港', 82: '澳门', 91: '国外' }
        var _idcard, Y, JYM; var S, M; var idcard_array = new Array(); idcard_array = _idcard.split('');
        if (area[parseInt(_idcard.substr(0, 2))] == null) { return Errors[4]; }
        switch (_idcard.length) {
            case 15: if ((parseInt(_idcard.substr(6, 2)) + 1900) % 4 == 0 || ((parseInt(_idcard.substr(6, 2)) + 1900) % 100 == 0 && (parseInt(_idcard.substr(6, 2)) + 1900) % 4 == 0)) {
                    ereg = /^[1-9][0-9]{5}[0-9]{2}((01|03|05|07|08|10|12)(0[1-9]|[1-2][0-9]|3[0-1])|(04|06|09|11)(0[1-9]|[1-2][0-9]|30)|02(0[1-9]|[1-2][0-9]))[0-9]{3}$/;
                } else {
                    ereg = /^[1-9][0-9]{5}[0-9]{2}((01|03|05|07|08|10|12)(0[1-9]|[1-2][0-9]|3[0-1])|(04|06|09|11)(0[1-9]|[1-2][0-9]|30)|02(0[1-9]|1[0-9]|2[0-8]))[0-9]{3}$/;
                }
                if (ereg.test(_idcard)) {
                    var iS = 0; var iW = new Array; iW[0] = 7; iW[1] = 9; iW[2] = 10; iW[3] = 5; iW[4] = 8; iW[5] = 4; iW[6] = 2; iW[7] = 1; iW[8] = 6; iW[9] = 3; iW[10] = 7; iW[11] = 9; iW[12] = 10; iW[13] = 5; iW[14] = 8; iW[15] = 4; iW[16] = 2;
                    var LastCode = '10X98765432'; var perIDNew; perIDNew = _idcard.substr(0, 6); perIDNew += '19'; perIDNew += _idcard.substr(6, 9);
                    for (var i = 0; i < 17; i++) { iS += parseInt(perIDNew.substr(i, 1)) * iW[i]; }
                    var iY = iS % 11; perIDNew += LastCode.substr(iY, 1);
                    return Errors[0];
                } else {
                    return Errors[2];
                }
                break;
            case 18: if (parseInt(_idcard.substr(6, 4)) % 4 == 0 || (parseInt(_idcard.substr(6, 4)) % 100 == 0 && parseInt(_idcard.substr(6, 4)) % 4 == 0)) {
                    ereg = _idcard.substr(6, 2) == '19' ? /^[1-9][0-9]{5}19[0-9]{2}((01|03|05|07|08|10|12)(0[1-9]|[1-2][0-9]|3[0-1])|(04|06|09|11)(0[1-9]|[1-2][0-9]|30)|02(0[1-9]|[1-2][0-9]))[0-9]{3}[0-9Xx]$/ : /^[1-9][0-9]{5}20[0-9]{2}((01|03|05|07|08|10|12)(0[1-9]|[1-2][0-9]|3[0-1])|(04|06|09|11)(0[1-9]|[1-2][0-9]|30)|02(0[1-9]|[1-2][0-9]))[0-9]{3}[0-9Xx]$/;
                } else {
                    ereg = _idcard.substr(6, 2) == '19' ? /^[1-9][0-9]{5}19[0-9]{2}((01|03|05|07|08|10|12)(0[1-9]|[1-2][0-9]|3[0-1])|(04|06|09|11)(0[1-9]|[1-2][0-9]|30)|02(0[1-9]|1[0-9]|2[0-8]))[0-9]{3}[0-9Xx]$/ : /^[1-9][0-9]{5}20[0-9]{2}((01|03|05|07|08|10|12)(0[1-9]|[1-2][0-9]|3[0-1])|(04|06|09|11)(0[1-9]|[1-2][0-9]|30)|02(0[1-9]|1[0-9]|2[0-8]))[0-9]{3}[0-9Xx]$/;
                }
                if (ereg.test(_idcard)) {
                    S = (parseInt(idcard_array[0]) + parseInt(idcard_array[10])) * 7 + (parseInt(idcard_array[1]) + parseInt(idcard_array[11])) * 9 + (parseInt(idcard_array[2]) + parseInt(idcard_array[12])) * 10 + (parseInt(idcard_array[3]) + parseInt(idcard_array[13])) * 5 + (parseInt(idcard_array[4]) + parseInt(idcard_array[14])) * 8 + (parseInt(idcard_array[5]) + parseInt(idcard_array[15])) * 4 + (parseInt(idcard_array[6]) + parseInt(idcard_array[16])) * 2 + parseInt(idcard_array[7]) * 1 + parseInt(idcard_array[8]) * 6 + parseInt(idcard_array[9]) * 3;
                    Y = S % 11; M = 'F'; JYM = '10X98765432'; M = JYM.substr(Y, 1); if (M == idcard_array[17]) return Errors[0]; else { return Errors[3]; } 
                } else { return Errors[2]; } break; default: return Errors[1]; break;
        } 
    }
    function getid(id) { alert(checkIdcard(id)) }
    function per18To15(perIDSrc) { rstr = ''; for (var i = 0; i < 17; i++) { if ((i == 6) || (i == 7)) { continue; } rstr += perIDSrc.charAt(i); } return rstr; }
    function per15To18(perIDSrc) {
        var iS = 0; var iW = new Array;
        iW[0] = 7; iW[1] = 9; iW[2] = 10; iW[3] = 5; iW[4] = 8; iW[5] = 4; iW[6] = 2; iW[7] = 1; iW[8] = 6; iW[9] = 3; iW[10] = 7; iW[11] = 9; iW[12] = 10; iW[13] = 5; iW[14] = 8; iW[15] = 4; iW[16] = 2;
        var LastCode = '10X98765432'; var perIDNew; perIDNew = perIDSrc.substr(0, 6); perIDNew += '19'; perIDNew += perIDSrc.substr(6, 9);
        for (var i = 0; i < 17; i++) { iS += parseInt(perIDNew.substr(i, 1)) * iW[i]; }
        var iY = iS % 11; perIDNew += LastCode.substr(iY, 1); return perIDNew;
    }
    var aCity = { 11: '北京', 12: '天津', 13: '河北', 14: '山西', 15: '内蒙古', 21: '辽宁', 22: '吉林', 23: '黑龙江', 31: '上海', 32: '江苏', 33: '浙江', 34: '安徽', 35: '福建', 36: '江西', 37: '山东', 41: '河南', 42: '湖北', 43: '湖南', 44: '广东', 45: '广西', 46: '海南', 50: '重庆', 51: '四川', 52: '贵州', 53: '云南', 54: '西藏', 61: '陕西', 62: '甘肃', 63: '青海', 64: '宁夏', 65: '新疆', 71: '台湾', 81: '香港', 82: '澳门', 91: '国外' }
    function cidInfo(sId) {
        var iSum = 0; var info = '';
        if (!/^\d{17}(\d|x)$/i.test(sId))
            return false; sId = sId.replace(/x$/i, 'a');
        if (aCity[parseInt(sId.substr(0, 2))] == null) return 'Error:非法地区'; sBirthday = sId.substr(6, 4) + '-' + Number(sId.substr(10, 2)) + '-' + Number(sId.substr(12, 2));
        var d = new Date(sBirthday.replace(/-/g, '/'))
        if (sBirthday != (d.getFullYear() + '-' + (d.getMonth() + 1) + '-' + d.getDate()))
            return 'Error:非法生日';
        for (var i = 17; i >= 0; i--) iSum += (Math.pow(2, i) % 11) * parseInt(sId.charAt(17 - i), 11)
        if (iSum % 11 != 1) return 'Error:非法证号';
        return aCity[parseInt(sId.substr(0, 2))] + ',' + sBirthday + ',' + (sId.substr(16, 1) % 2 ? '男' : '女')
    }
function PositionLen(s){var i,str1,str2,str3,nLen;	str1 =s;nLen = 0;for(i=1;i<=str1.length;i++){str2=str1.substring(i-1,i);str3=escape(str2);if(str3.length>3){	nLen = nLen + 2;}else{nLen = nLen + 1;}	}
return nLen;}
function isNotNull(str){return (str==''?false:true);}
function isNumber(str){if(str==''){return true;}return (isNaN(str)?false:true);}
function isNumber(str){if(str==''){return true;}return (isNaN(str)?false:true);}
function isBNumber(str){if(str==''){return true;}return (!isNaN(str)?parseInt(str,10)>=0?true:false:false);}
function isSNumber(str){if(str==''){return true;}return (!isNaN(str)?parseInt(str,10)<0?true:false:false);}
function isAlpha(_str){return (_str.replace(/\w/g,'').length == 0);}
function isAN(_str){var reg = /^(([a-z]+[0-9]+)|([0-9]+[a-z]+))[a-z0-9]*$/i;return reg.test(_str);}
function validRegs(_value,_Regs){return _Regs.test(_value); }
function isVisibled(obj){   if( (obj.style.display=='none')||( (obj.offsetHeight==0)&&(obj.offsetWidth==0) ) )       return false; if(obj.currentStyle){if(obj.currentStyle['display']=='none') return false;}  return true;}
function isFocused(obj){   if( (obj.disabled==false)&&(isVisibled(obj)) )       return true;   return false;}
function isDate(str,cname,notip){if(str==''){return true;}
str=str.replace(/\//g,'-');
dt=str.split(' ');if(dt.length>2){if(!notip) alert(cname+'日期输入不正确！可能包括非法的日期组成部分。');return false;	} dt1=dt[0].split('-');if(dt1.length!=3){if(!notip) 	alert(cname+'日期输入不正确！日期部分应为YYYY-MM-DD。');return false;}dt1n=(dt1[0]+dt1[1]+dt1[2]).split('');for(var i=0;i<dt1.length;i++){if((isNaN(dt1[i])||(ctrim(dt1[i])==''))){if(!notip) 	alert(cname+'字符：'+dt1[i]+'，年月日部分必须输入数字！');	return false;}	}_year=parseInt(dt1[0],10);	_month=parseInt(dt1[1],10);	_day=parseInt(dt1[2],10);if((_year<1000)||(_year>9999)||(_month<1)||(_month>12)||(_day<1)||(_day>31)){if(!notip) alert(cname+'年月日部分输入的数字不合理，请核对！');return false;	}v_date31=new Array;v_date31[0]=4;v_date31[1]=6;v_date31[2]=9;v_date31[3]=11;if((getArrayIndex(v_date31,_month)!=-1)&&(_day>30)){if(!notip) alert(cname+'月份：'+_month+'，天数输入范围不合理！');	return false;}if(_month==2){	if(((_year%4==0)&&(_year%100!=0))||(_year%400==0)){	if(_day>29){if(!notip) alert(cname+'月份：'+_month+'，天数输入范围不合理！');return false;	}}else{	if(_day>28){if(!notip) alert(cname+'月份：'+_month+'，天数输入范围不合理！');return false;	}}	}	return true;   }
function getArrayIndex(xArray,find){_rs=-1;for(var j=0;j<xArray.length;j++){if(xArray[j]==find){_rs=j;	break; 	}}	return _rs;	}
function ctrim(ename){ if(ename==undefined) return '';	return (ename.replace(/(^\s*)|(\s*$)/g, '')).replace(/^[\s　\t]+|[\s　\t]+$/, '');}
 
 
    var RowsCount = 0;
    var ErrorMessage = "";
 
    function swarp(mId, stype) {
        var mObj = document.getElementById(mId);
        if (mObj == undefined) {
            return false;
        }
        var premObj = mObj.previousElementSibling;
        if (stype == 2) {
            premObj = mObj.nextElementSibling;
        }
        if (premObj == null) return false;
        if (stype == 1) {
            mObj.parentNode.insertBefore(mObj, premObj);
        } else if (stype == 2) {
            mObj.parentNode.insertBefore(premObj, mObj);
        }
    }
    function setrow(rowobj) {
        document.getElementById('curid').value = rowobj.id;
        chnRowSelColor(rowobj);
    }
    function chnRowSelColor(rowobj) {
        var _com = "att_" + document.getElementById('com_name').value;
        var mt = document.getElementById('mtable');
        for (var i = 0; i < mt.rows.length; i++) {
            var mt_row = mt.rows[i];
            mt_row.style.backgroundColor = '';
            if (mt_row.id == rowobj.id) {continue;}
            for (var j = 0; j < mt_row.cells.length; j++) {
                var cell1 = mt_row.cells[j];
                if (cell1.getElementsByTagName('input').length > 0) {
                    cell1.innerHTML = cell1.getElementsByTagName('input')[0].value.replace(/<[^>]*>/g, '');
                }else 
                if (cell1.getElementsByTagName('select').length > 0) {
                        cell1.innerHTML = cell1.getElementsByTagName('select')[0].value.replace(/<[^>]*>/g, '');
                }
            }
        }
        rowobj.style.backgroundColor = 'rgb(235,235,235)';
        var pj = JSON.parse(document.getElementById('pjson').value);
        var jtcy = pj[_com][0].cols;
        var isadd = false;
        if (rowobj.cells.length == 0) {
            isadd = true;
        }
        for (var i = 0; i < jtcy.length; i++) {
            var cell1 = isadd==true?rowobj.insertCell(i):rowobj.cells[i];
            var ctype = jtcy[i].input;
            var innerhtml = "";
            var oldvalue = "";
            if(isadd==true){
                cell1.setAttribute("checkSchema",jtcy[i].check);
                cell1.setAttribute("cName",jtcy[i].cname);
            }
            if (ctype == "text") {
                oldvalue = cell1.innerText;
                innerhtml = "<input type='" + ctype + "' onchange='validchange(this)' placeholder='" + jtcy[i].cname + "'style='" + jtcy[i].ctl_style + "'/>";
            } else if (ctype == "select") {
                oldvalue = cell1.innerText;
                innerhtml = "<" + ctype + " onchange='validchange(this)' style='" + jtcy[i].ctl_style + "' />";
                innerhtml += "<option value=''>" + jtcy[i].cname + "</option>";
                var items = jtcy[i].list.split("|");
                for (var j = 0; j < items.length; j++) {
                    innerhtml += "<option>" + items[j] + "</option>";
                }
                innerhtml += "</" + ctype + ">";
            }
            cell1.innerHTML = innerhtml;
            cell1.style = jtcy[i].td_style;
            cell1.addEventListener('click', function (event) {
                event.stopPropagation();
                if (cell1.parentNode.id != document.getElementById('curid').value) {
                    setrow(cell1.parentNode);
                }
            });
            if (cell1.getElementsByTagName('input').length > 0) {
                cell1.getElementsByTagName('input')[0].value=oldvalue;
                cell1.getElementsByTagName('input')[0].addEventListener('click', function (event) {
                    event.stopPropagation();
                });
            } else if (cell1.getElementsByTagName('select').length > 0) {
                cell1.getElementsByTagName('select')[0].value = oldvalue;
                cell1.getElementsByTagName('select')[0].addEventListener('click', function (event) {
                    event.stopPropagation();
                });
            }
        }
 
    }
    function ss(type, result) {
        try {
            var robj = JSON.parse(result);
            if (robj.errcode != 0) {
                ErrorMessage = robj.errmsg;
                alert(ErrorMessage);
            } else {
                RowsCount++;
            }
        } catch (ss_e) {
            ErrorMessage=(ss_e);
            alert(ErrorMessage);
        }
        if (RowsCount == document.getElementById('mtable').rows.length) {
            document.getElementById('Button4').removeAttribute("disabled");
            document.getElementById('saved').style.color = 'green';
            document.getElementById('saved').innerHTML = "保存所有成功。";
            window.setTimeout(function () {
                document.getElementById('saved').style.color = 'red';
                document.getElementById('saved').innerHTML = "";
            }, 1000);
 
 
            callServerFunction("", "save_att_data", "{ypz_cid:'" +document.getElementById('cid').value+"',com_name:'"+document.getElementById('com_name').value + "'}", ss4);
        }
    }
    function ss4(type, result) {
        if (JSON.stringify(result) == "\"true\"") {
        } else {
            alert('同步更新简历信息失败，请点击修改简历按钮提交修改。' + JSON.stringify(result));
        }
    }
    function ss3(type, result) {
        try {
            var robj = JSON.parse(result);
            if (robj.errcode != 0) {
                ErrorMessage = robj.errmsg;
                alert(ErrorMessage);
            } else {
                RowsCount++;
            }
        } catch (ss3_e) {
            ErrorMessage = (ss3_e);
            alert(ErrorMessage);
        }
    }
    function tojsonstr(str) {
        var prv = str.replace(/["\\]/g, '\\$&').replace(/<[^>]*>/g, '').replace(/<[^>]*>/g, '') ;
        return prv;
    }
    function saveall() {
        var mt = document.getElementById('mtable');
        if (mt.rows.length == 0) {
            document.getElementById('saved').style.color = '#4169E1';
            document.getElementById('saved').innerHTML = "请添加行后再执行保存操作...";
            window.setTimeout(function () {
                document.getElementById('saved').style.color = 'red';
                document.getElementById('saved').innerHTML = "";
            }, 3000);
            return;
        }
        RowsCount = 0;
        ErrorMessage = "";
        document.getElementById('saved').style.color = '#4169E1';
        document.getElementById('saved').innerHTML = "正在保存...";
 
        var _com = "att_" + document.getElementById('com_name').value;
        var pj = JSON.parse(document.getElementById('pjson').value);
        var dj = JSON.parse(document.getElementById('djson').value);
        var jtcy = pj[_com][0].cols;
        for (var i = 0; i < mt.rows.length; i++) {
            var mt_row = mt.rows[i];
            dj.cid = mt_row.id;
            dj.sortid = (i + 1);
            for (var j = 0; j < mt_row.cells.length; j++) {
                var cell1 = mt_row.cells[j];
                var _value = cell1.innerText;
                if (cell1.getElementsByTagName('input').length > 0) {
                    _value = cell1.getElementsByTagName('input')[0].value;
                } else if (cell1.getElementsByTagName('select').length > 0) {
                    _value = cell1.getElementsByTagName('select')[0].value;
                }
                dj[jtcy[j].fname] =tojsonstr(_value);
            }
            callServerFunction("", "saveInfo", "{jdata:'" + JSON.stringify(dj).replace(/['\\]/g, '\\$&') + "'}", ss);
        }
    }
    function ss2(type, result) {
        try {
            var robj = JSON.parse(result);
            if (robj.errcode != 0) {
                ErrorMessage = robj.errmsg;
                alert(ErrorMessage);
            } else {
                RowsCount++;
                var curid = document.getElementById('curid').value;
                var mt_row = document.getElementById(curid);
                document.getElementById('mtable').deleteRow(mt_row.rowIndex);
                document.getElementById('saved').style.color = 'red';
                document.getElementById('saved').innerHTML = "";
                alert('删除当前行成功！');
            }
        } catch (ss2_e) {
            ErrorMessage = (ss2_e);
            alert(ErrorMessage);
        }
    }
 
    function delinfo() {
        var curid = document.getElementById('curid').value;
        if (curid == "") {
            alert('请选中记录后再执行删除操作。');
            return;
        }
        RowsCount = 0;
        ErrorMessage = "";
        var _com = "att_" + document.getElementById('com_name').value;
        var dj = JSON.parse(document.getElementById('djson').value);
        var mt_row = document.getElementById(curid);
        dj.cid = mt_row.id;
        callServerFunction("", "deleteInfo", "{jdata:'" + JSON.stringify(dj).replace(/['\\]/g, '\\$&') + "'}", ss2);
    }
    function validall(extip) {
        
 
        var _com = "att_" + document.getElementById('com_name').value;
        var mt = document.getElementById('mtable');
 
        var pj = JSON.parse(document.getElementById('pjson').value);
        var dj = JSON.parse(document.getElementById('djson').value);
        var jtcy = pj[_com][0].cols;
        for (var i = 0; i < mt.rows.length; i++) {
            var mt_row = mt.rows[i];
            for (var j = 0; j < mt_row.cells.length; j++) {
                var cell1 = mt_row.cells[j];
                var _value = cell1.innerText;
                if (cell1.getElementsByTagName('input').length > 0) {
                    _value = cell1.getElementsByTagName('input')[0].value;
                } else if (cell1.getElementsByTagName('select').length > 0) {
                    _value = cell1.getElementsByTagName('select')[0].value;
                }
                var isvalid = simplecheck(cell1, _value, true, extip+"第" + (i + 1) + "行：");
                if (isvalid == false) {
                    mt_row.style.backgroundColor = '#B22222';
                    
                    return false;
                }
            }
        }
        return true;
    }
    function validchange(obj) {
        document.getElementById('saved').innerText = '修改了'+obj.parentNode.getAttribute('cname')+'待保存';
    }
    function validsave(extip) {
        if (document.getElementById('saved').innerText != '') {
            return false;
        }
        return true;
    }
    function addRow() {
        if (validall('') == false) {
            return;
        }
        RowsCount = 0;
        ErrorMessage = "";
 
        var _com = "att_" + document.getElementById('com_name').value;
        var pj = JSON.parse(document.getElementById('pjson').value);
        
        var jtcy=pj[_com][0].cols;
        var mt = document.getElementById('mtable');
        var maxCount = parseInt(pj[_com][0].maxRowCount, 10);
        if (mt.rows.length >= maxCount) {
            alert("本内容最多允许添加" + maxCount + "行。");
            return;
        }
        var row = mt.insertRow(-1); // -1 表示在表的末尾插入新行
        row.id = gGuid();
        row.setAttribute("onclick", "setrow(this)");
        setrow(row);
        var dj = JSON.parse(document.getElementById('djson').value);
        dj["cid"] = row.id;
        dj["sortid"] = mt.rows.length;
 
        callServerFunction("", "saveInfo", "{jdata:'" + JSON.stringify(dj) + "'}", ss3);
        document.getElementById('saved').style.color = 'red';
        document.getElementById('saved').innerHTML = "添加新行未保存";
        ScrollToBottom();
    }
    function gGuid() {
        return 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function (c) {
            var r = Math.floor(Math.random() * 16);
            var v = c === 'x' ? r : (r & 0x3 | 0x8);
            return v.toString(16);
        });
    }
    function ScrollToBottom() {
        $("html, body").animate({ scrollTop: $(document).height() - $(window).height() });
    }
</script>

<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ Import Namespace="System.Data"%>
<%@ Import NameSpace="System.Data.SqlClient"%>
<%@ Import Namespace="System.IO"%>
<%@ Import Namespace="System.Web.Services"%>
<script language="C#" runat="server">
public CosysJaneCommonAPI.CODAL dal = new CosysJaneCommonAPI.CODAL();
void Page_Load(Object sender, EventArgs e)
{
    if (Page.IsPostBack) { return; }
    InitPage();
}
 
public void InitPage()
{
    dal.RunAt = Page.Form;
    string _xmbh = "001";
    string _p_att_json = pjson.Text;
    string _sfzh = "120102";
    xmbh.Text = _xmbh;
    sfzh.Text = _sfzh;
    
    com_name.Text = Request.QueryString["com_name"];
    Newtonsoft.Json.Linq.JObject jobj = Newtonsoft.Json.Linq.JObject.Parse(pjson.Text);
    djson.Text = "{";
    _sql = "select ";
    HtmlTableRow trow = new HtmlTableRow();
    ttable.Attributes["style"] = jobj["att_" + com_name.Text][0]["ttable_style"].ToString();
    mtable.Attributes["style"] = jobj["att_" + com_name.Text][0]["mtable_style"].ToString();
    for (int i = 0; i < jobj["att_" + com_name.Text][0]["cols"].Count(); i++)
    {
        HtmlTableCell tcell = new HtmlTableCell();
        tcell.InnerText = jobj["att_" + com_name.Text][0]["cols"][i]["cname"].ToString();
        tcell.Attributes["style"] = jobj["att_" + com_name.Text][0]["cols"][i]["td_style"].ToString();
        trow.Cells.Add(tcell);
        djson.Text += string.Format("\"{0}\":\"{1}\",", jobj["att_" + com_name.Text][0]["cols"][i]["fname"].ToString(), "");
        _sql += jobj["att_" + com_name.Text][0]["cols"][i]["fname"].ToString() + ",";
    }
    ttable.Rows.Add(trow);
    djson.Text += string.Format("\"{0}\":\"{1}\"", "xmbh", _xmbh);
    djson.Text += string.Format(",\"{0}\":\"{1}\"", "sfzh",_sfzh);
    djson.Text += string.Format(",\"{0}\":\"{1}\"", "sortid", "");
    djson.Text += string.Format(",\"{0}\":\"{1}\"", "cid", "");
    djson.Text += string.Format(",\"{0}\":\"{1}\"", "com_name", com_name.Text);
    djson.Text += "}";
    _sql = _sql + "cid from att_" + com_name.Text+" where xmbh=@xmbh and sfzh=@sfzh order by sortid"; 
    paras.Clear();
    paras.Add(new SqlParameter("xmbh", _xmbh));
    paras.Add(new SqlParameter("sfzh", _sfzh));
    rv = dal.GetDataSet(_sql, paras);
    if (dal.ErrorMessage != "")
    {
        return;
    }
    topnavs.Visible = true;
    ttable.Style["top"] = "37px";
    mtable.Style["top"] = "67px";
    if (dal.RowsCount == 0)
    {
        return;
    }
    dt = ((DataSet)rv).Tables[0];
 
    for (int i = 0; i < dt.Rows.Count; i++)
    {
        HtmlTableRow hrow = new HtmlTableRow();
        if (_zwmc == "" || (_bcbz == "true" && _bcsm != ""))
        {
            hrow.Attributes["onclick"] = "setrow(this)";
        }
        hrow.ID = dt.Rows[i]["cid"].ToString();
        for (int j = 0; j < dt.Columns.Count-1; j++)
        {
            HtmlTableCell hcell = new HtmlTableCell();
            hcell.Attributes["style"] = jobj["att_" + com_name.Text][0]["cols"][j]["td_style"].ToString();
            hcell.Attributes["cName"] = jobj["att_" + com_name.Text][0]["cols"][j]["cname"].ToString();
            hcell.Attributes["checkSchema"] = jobj["att_" + com_name.Text][0]["cols"][j]["check"].ToString();
            hcell.InnerText = dt.Rows[i][dt.Columns[j].ToString()].ToString();
            hrow.Cells.Add(hcell);
        }
        mtable.Rows.Add(hrow);
    }
 
}
[WebMethod(BufferResponse = true)]
public static string saveInfo(string jdata)
{
    Newtonsoft.Json.Linq.JObject jobj = Newtonsoft.Json.Linq.JObject.Parse(jdata);
    string tablename = "";
    string inssql = "";
    string inslist = "";
    string insparas = "";
    string updsql = "";
    string updparas = "";
    ArrayList paras = new ArrayList();
    paras.Clear();
 
    foreach (KeyValuePair<string, Newtonsoft.Json.Linq.JToken> kvp in jobj)
    {
        string key = kvp.Key.ToString();
        string value = kvp.Value.ToString();
        if (key == "com_name" && (value == "jtcy" || value == "shgx" || value == "jypx" || value == "gzjl"))
        {
            tablename = "att_"+value;
        }
        else
        {
            inslist += key + ",";
            insparas +="@"+ key + ",";
            updparas += string.Format(" {0}=@{1},",key,key);
            paras.Add(new SqlParameter(key, value));
        }
    }
    if (inslist.Length > 1)
    {
        inslist = inslist.Substring(0, inslist.Length - 1);
        insparas = insparas.Substring(0, insparas.Length - 1);
        inssql = string.Format("insert into {0} ({1}) values({2});", tablename, inslist, insparas);
    }
    if (updparas.Length > 1)
    {
        updparas = updparas.Substring(0, updparas.Length - 1);
        updsql = string.Format("update {0} set {1} where cid=@cid;", tablename, updparas);
    }
    string sql = string.Format(" if not exists(select cid from {0} where cid=@cid) begin {1} end else begin {2} end", tablename, inssql, updsql);
    
    CosysJaneCommonAPI.CODAL dal = new CosysJaneCommonAPI.CODAL();
   dal.ExecDbScripts(sql, paras);
   string rv = "{\"errcode\":0,\"errmsg\":\"\"}";
   if (dal.ErrorMessage != "")
   {
       rv="{\"errcode\":2,\"errmsg\":\""+String2Json(dal.ErrorMessage)+"\"}";
   }
   else if (dal.RowsCount == 0)
   {
       rv = "{\"errcode\":1,\"errmsg\":\"" + String2Json("未成功更新记录。") + "\"}";
   }
    return rv;
}
[WebMethod(BufferResponse = true)]
public static string deleteInfo(string jdata)
{
    Newtonsoft.Json.Linq.JObject jobj = Newtonsoft.Json.Linq.JObject.Parse(jdata);
    string tablename = "";
    string updsql = "";
    string updparas = "";
    ArrayList paras = new ArrayList();
    paras.Clear();
 
    foreach (KeyValuePair<string, Newtonsoft.Json.Linq.JToken> kvp in jobj)
    {
        string key = kvp.Key.ToString();
        string value = kvp.Value.ToString();
        if (key == "com_name" && (value == "jtcy" || value == "shgx"|| value == "jypx" || value == "gzjl"))
        {
            tablename = "att_"+value;
        }
        else if(key=="cid")
        {
            paras.Add(new SqlParameter(key, value));
        }
    }
    updsql = string.Format("delete from {0} where cid=@cid;", tablename);
 
    CosysJaneCommonAPI.CODAL dal = new CosysJaneCommonAPI.CODAL();
    dal.ExecDbScripts(updsql, paras);
    string rv = "{\"errcode\":0,\"errmsg\":\"\"}";
    if (dal.ErrorMessage != "")
    {
        rv = "{\"errcode\":2,\"errmsg\":\"" + String2Json(dal.ErrorMessage) +  "\"}";
    }
    else if (dal.RowsCount == 0)
    {
        rv = "{\"errcode\":1,\"errmsg\":\"" + String2Json("未成功更新记录。") + "\"}";
    }
    return rv;
}
 
private static string String2Json(String s)
{
 
    StringBuilder sb = new StringBuilder();
 
    for (int i = 0; i < s.Length; i++)
    {
 
        char c = s.ToCharArray()[i];
 
        switch (c)
        {
 
            case '\"':
 
                sb.Append("\\\""); break;
 
            case '\\':
 
                sb.Append("\\\\"); break;
 
            case '/':
 
                sb.Append("\\/"); break;
 
            case '\b':
 
                sb.Append("\\b"); break;
 
            case '\f':
 
                sb.Append("\\f"); break;
 
            case '\n':
 
                sb.Append("\\n"); break;
 
            case '\r':
 
                sb.Append("\\r"); break;
 
            case '\t':
 
                sb.Append("\\t"); break;
 
            default:
 
                if ((c >= 0 && c <= 31) || c == 127)//在ASCⅡ码中，第0～31号及第127号(共33个)是控制字符或通讯专用字符
                {
 
 
 
                }
 
                else
                {
 
                    sb.Append(c);
 
                }
 
                break;
 
        }
 
    }
 
    return sb.ToString();
 
}
 
</script>

​另外工具栏按钮的图片文件，我们可以按照自己的实际需要进行替换。本代码仅供您参考使用，感谢您的阅读，希望本文能够对您有所帮助。