/*页面表单的验证
*在input文本域加入属性chk，同时在页面的提交按钮的客户端的click事件绑定return allSubmit()；
*chk的值为:在标示前加un标示此文本域不能为空；
*   tel(untel)电话号码的验证
*   mobile(unmobile)手机号码的验证
*   email(unemail)邮件账号的验证
*   post(unpost)邮编号码的验证
*   idcard(unidcard)身份证号码的验证
*   num(unnum)是否为数字码的验证
*   bank(unbank)银行卡号的验证
*   url(unurl)网址的验证
*  unnull说明此文本不允许为空
*/


var checkChar = "%\(\)><\\/"; //特殊字符

//返回url最后字符串
var getLocation = function() {
    var url = window.location.href.toLowerCase();
    var lm = url.split('/');
    lm = lm[lm.length - 1].split('.');
    return lm[0] || "com";
}

//特殊字符
function charCheck(str) {
    for (var i = 0; i < checkChar.length; i++)
        if (str.indexOf(checkChar.charAt(i)) >= 0)
        return true;
    return false;
}
//特殊词组
function charArray(str) {
    str = str.toLowerCase();
    for (var i = 0; i < checkArray.length; i++)
        if (str.indexOf(checkArray[i].toLowerCase()) >= 0)
        return true;
    return false;
}

function numCheck(str) {
    if (str.search("^-?\\d+$") == 0) {
        return true;
    }
    return false;
}

function telcheck(vtel) {
    var regname = /^(([0\+]\d{2,3}-)?(0\d{2,3})-)(\d{7,8})(-(\d{3,}))?$/;
    if (regname.test(vtel)) {
        return true;
    } else {
        return false;
    }
}

function emailcheck(vemail) {
    var reg = /^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/;
    if (reg.test(vemail)) {
        return true;
    } else {
        return false;
    }
}

function mobilecheck(vmobile) {
    var reg = /(\d{11})|^((\d{7,8})|(\d{4}|\d{3})-(\d{7,8})|(\d{4}|\d{3})-(\d{7,8})-(\d{4}|\d{3}|\d{2}|\d{1})|(\d{7,8})-(\d{4}|\d{3}|\d{2}|\d{1}))$/;
    if (reg.test(vmobile)) {
        return true;
    } else {
        return false;
    }
}

function qqcheck(vqq) {
    var reg = /^\d{5,11}$/;
    if (reg.test(vqq)) {
        return true;
    } else {
        return false;
    }
}

function msncheck(vmsn) {
    var myReg = /^[-_A-Za-z0-9]+@([_A-Za-z0-9]+\.)+[A-Za-z0-9]{2,3}$/;
    if (myReg.test(vmsn)) {
        return true;
    } else {
        return false;
    }
}

function Money(moneycheck) {
    var monval = /^([1-9]\d+|[0-9])(\.\d\d?)*$/;
    if (monval.test(moneycheck)) {
        if (moneycheck.split(".").length <= 2) {
            return true;
        } else {
            return false;
        }
    } else {
        return false;
    }
}

function checkNum(nubmer) {
    var re = /^[-\+]?\d+(\.\d+)?$/;
    if (re.test(nubmer)) {
        return true;
    }
    return false;
}
$(document).ready(function() {
    var o = $("input[chk]");
    o.checkRequired();
});
$.fn.extend({
    checkRequired: function(inputArg) {
        if ($(this).is("input") || $(this).is("textarea")) {
            //绑定获得焦点事件
            $(this).bind("focus", function() {
                $(this).css('background-image', '');
            });
        }
    }
});

function allSubmit() {
    var sta = "";
    var list = new Array();
    var o = $("input[chk]");
    ////function 1:
    var count = 0;
    jQuery.each(o, function(i, k) {
        var obj = $(k);
        sta = InputCheck.checkInput(obj);
        if (sta.toString().substring(0, 1) != "d") {
            if (sta) {
                obj.css('background-image', 'url(../images/accept.png)').css('background-repeat', 'no-repeat').css('background-position', 'right');
            } else {
                obj.css('background-image', 'url(../images/cross.png)').css('background-repeat', 'no-repeat').css('background-position', 'right');
            } //cross.png  tick.png
            if (!sta) { list[count] = sta; count++; }
        }
    });
    for (var i = 0; i < list.length; i++) {
        if (!list[i]) { sta = list[i]; break; }
    }
    ////function 2:
    //    for (var i = 0; i < o.length; i++) {
    //        var obj = $(o[i]);
    //        sta = InputCheck.checkInput(obj);
    //         if (sta.toString().substring(0, 1) != "d") {
    //            if (sta) {
    //                obj.css('background-image', 'url(../images/accept.png)').css('background-repeat', 'no-repeat').css('background-position', 'right');
    //            } else {
    //                obj.css('background-image', 'url(../images/cross.png)').css('background-repeat', 'no-repeat').css('background-position', 'right');
    //            } //cross.png  tick.png
    //            if (!sta) {break; }
    //        } else {
    //            sta = true;
    //        }
    //    }
    return sta;
}

var InputCheck = {
    checkInput: function(o) {
        //var o = $("input[chk]");
        var y = o.attr("chk").toLowerCase();
        var sta = "default";
        o.css('background-image', '');
        if (y == "unnull") {
            sta = this.checkNull(o);
        } else if (y == "untel" && this.checkNull(o)) {
            sta = this.checkTel(o);
        } else if (y == "unmobile" && this.checkNull(o)) {
            sta = this.checkMobile(o);
        } else if (y == "unemail" && this.checkNull(o)) {
            sta = this.checkEmail(o);
        } else if (y == "unpost" && this.checkNull(o)) {
            sta = this.checkPost(o);
        } else if (y == "unidcard" && this.checkNull(o)) {
            sta = this.checkIdentity(o);
        } else if (y == "unnum" && this.checkNull(o)) {
            sta = this.checkNum(o);
        }
        //        else if (y == "unsel" && this.checkNull(o)) {
        //            sta = this.checkSel(o);
        //        } 
        else if (y == "tel") {
            if (this.checkNull(o)) {
                sta = this.checkTel(o);
            }
        } else if (y == "mobile") {
            if (this.checkNull(o)) {
                sta = this.checkMobile(o);
            }
        } else if (y == "email") {
            if (this.checkNull(o)) {
                sta = this.checkEmail(o);
            }
        } else if (y == "post") {
            if (this.checkNull(o)) {
                sta = this.checkPost(o);
            }
        } else if (y == "idcard") {
            if (this.checkNull(o)) {
                sta = this.checkIdentity(o);
            }
        } else if (y == "num") {
            if (this.checkNull(o)) {
                sta = this.checkNum(o);
            }
        } else {
            sta = this.checkNull(o);
        }
        return sta;

    },
    checkNull: function(_obj) {
        if (_obj.val() != "") {
            return true;
        } else {
            return false;
        }
    },
    checkSel: function(_obj) {
        if (_obj.val() != "-1") {
            return true;
        } else {
            return false;
        }
    },
    checkTel: function(_obj) {
        //var reg = /^(([0\+]\d{2,3}-)?(0\d{2,3})-)(\d{7,8})(-(\d{3,}))?$/;
        var reg = /(^[0-9]{3,4}\-[0-9]{7,8}$)|(^[0-9]{7,8}$)|(^[0-9]{3,4}[0-9]{7,8}$)|(^\([0-9]{3,4}\)[0-9]{7,8}$)/;
        if (reg.test(_obj.val())) {
            return true;
        } else {
            return false;
        }
    },
    checkMobile: function(_obj) {
        var reg = /(\d{11})|^((\d{7,8})|(\d{4}|\d{3})-(\d{7,8})|(\d{4}|\d{3})-(\d{7,8})-(\d{4}|\d{3}|\d{2}|\d{1})|(\d{7,8})-(\d{4}|\d{3}|\d{2}|\d{1}))$/;
        if (reg.test(_obj.val())) {
            return true;
        } else {
            return false;
        }
    },
    checkEmail: function(_obj) {
        var reg = /^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$/;
        if (reg.test(_obj.val())) {
            return true;
        } else {
            return false;
        }
    },
    checkPost: function(_obj) {
        var reg = "";
        if (reg.test(_obj.val())) {
            return true;
        } else {
            return false;
        }
    },
    checkIdentity: function(_obj) {
        var vidcard = _obj.val();
        var sErrMsg = "";
        var reg_15 = /\d{15}/;
        var reg_18 = /\d{17}([0-9]{1}|x|X)/;
        var monthPerDays = new Array("31", "28", "31", "30", "31", "30", "31", "31", "30", "31", "30", "31");
        vidcard = vidcard.toLowerCase();
        /*if (vidcard == "") {
        sErrMsg = "2";
        }*/
        var ret = vidcard.length == 15 ? reg_15.test(vidcard) : reg_18.test(vidcard);
        if (!ret) {
            sErrMsg = "2";
        }
        birthDate = vidcard.length == 15 ? "19" + vidcard.substr(6, 6) : vidcard.substr(6, 8);
        year = birthDate.substr(0, 4);
        if (birthDate.substr(4, 1) == '0')
            month = birthDate.substr(5, 1);
        else
            month = birthDate.substr(4, 2);
        if (birthDate.substr(6, 1) == '0')
            day = birthDate.substr(7, 1);
        else
            day = birthDate.substr(6, 2);
        dd = parseInt(day);
        mm = parseInt(month);
        yy = parseInt(year);
        days = new Date();
        gdate = days.getDate();
        gmonth = days.getMonth();
        gyear18 = days.getFullYear() - 18;
        if (mm > 12 || mm < 1 || dd > 31 || dd < 1) {
            sErrMsg = "2";
        }
        if (year % 100 != 0) {
            if (year % 4 == 0)
                monthPerDays[1] = 29;
        }
        else {
            if (year % 400 == 0)
                monthPerDays[1] = 29;
        }
        if (monthPerDays[mm - 1] < dd) {
            sErrMsg = "2";
        }
        if (vidcard.length == 18) {
            var arTemp = new Array(7, 9, 10, 5, 8, 4, 2, 1, 6, 3, 7, 9, 10, 5, 8, 4, 2);
            var num = 0;
            var proof;
            for (var i = 0; i < 17; i++) {
                num = num + vidcard.substr(i, 1) * arTemp[i];
            }
            num = num % 11;
            switch (num) {
                case 0: proof = '1'; break;
                case 1: proof = '0'; break;
                case 2: proof = 'x'; break;
                case 3: proof = '9'; break;
                case 4: proof = '8'; break;
                case 5: proof = '7'; break;
                case 6: proof = '6'; break;
                case 7: proof = '5'; break;
                case 8: proof = '4'; break;
                case 9: proof = '3'; break;
                case 10: proof = '2'; break;
            }
            if (vidcard.substr(17, 1) != proof) {
                sErrMsg = "2";
            } else {
                sErrMsg = "4";
            }
        }
        mm = mm - 1;
        var prevTS18 = new Date(gyear18, gmonth, gdate, 0, 0, 0);
        var ageTs = new Date(yy, mm, dd, 0, 0, 0)
        if (prevTS18 < ageTs) {
            sErrMsg = "1";
        }
        if (sErrMsg == "4") {
            sErrMsg = true;
        } else {
            sErrMsg = false;
        }
        return sErrMsg;
    },
    checkNum: function(_obj) {
        var reg = /^[-\+]?\d+(\.\d+)?$/;
        if (reg.test(_obj.val())) {
            return true;
        } else {
            return false;
        }
    }
}

// Lee dialog 1.0 http://www.xij.cn/blog/?p=68
//应用：
//dialog(title,content,width,height,cssName);
//演示：
//   1. post提交表单返回信息$("#form1").submit(function(){
//      var str=escape($("#str").val());
//      dialog("我的标题","url:post?test.asp?str="+str+"","200px","auto","from");
//      return false;
//      });
//      get加载一个.html文件（也可以是.php/.asp?id=4之类的） dialog("我的标题","url:get?test.html","200px","auto","text");
//   2. 弹出纯文本内容 dialog("我的标题","text:我的内容","200px","auto","text"); 
//   3. 弹出某id里面的html页面有<div id="testID" style="display:none;"><h2>Lee dialog</h2></div>
//      dialog("我的标题","id:testID","300px","auto","id");
//      Lee dialog
//   4. 加载一个页面以框架示 把blueidea加载进来，定义css:body .iframe .content{padding:0;}复盖一下，因为.content默认padding:20px;
//      dialog("blueidea","iframe:http://www.blueidea.com","500px","500px","iframe"); 
var dialogFirst = true;
function dialog(title, content, width, height, cssName) {

    if (dialogFirst == true) {
        var temp_float = new String;
        temp_float = "<div id=\"floatBoxBg\" style=\"height:" + $(document).height() + "px;filter:alpha(opacity=0);opacity:0;\"></div>";
        temp_float += "<div id=\"floatBox\" class=\"floatBox\">";
        temp_float += "<div class=\"title\"><h4></h4><span>关闭</span></div>";
        temp_float += "<div class=\"content\"></div>";
        temp_float += "</div>";
        $("body").append(temp_float);
        dialogFirst = false;
    }

    $("#floatBox .title span").click(function() {
        $("#floatBoxBg").animate({ opacity: "0" }, "normal", function() { $(this).hide(); });
        $("#floatBox").animate({ top: ($(document).scrollTop() - (height == "auto" ? 300 : parseInt(height))) + "px" }, "normal", function() { $(this).hide(); });
    });

    $("#floatBox .title h4").html(title);
    contentType = content.substring(0, content.indexOf(":"));
    content = content.substring(content.indexOf(":") + 1, content.length);
    switch (contentType) {
        case "url":
            var content_array = content.split("?");
            $("#floatBox .content").ajaxStart(function() {
                $(this).html("loading...");
            });
            $.ajax({
                type: content_array[0],
                url: content_array[1],
                data: content_array[2],
                error: function() {
                    $("#floatBox .content").html("error...");
                },
                success: function(html) {
                    $("#floatBox .content").html(html);
                }
            });
            break;
        case "text":
            $("#floatBox .content").html(content);
            break;
        case "id":
            $("#floatBox .content").html($("#" + content + "").html());
            break;
        case "iframe":
            $("#floatBox .content").html("<iframe src=\"" + content + "\" width=\"100%\" height=\"" + (parseInt(height) - 70) + "px" + "\" scrolling=\"auto\" frameborder=\"0\" marginheight=\"0\" marginwidth=\"0\"></iframe>");
    }

    $("#floatBoxBg").show();
    $("#floatBoxBg").animate({ opacity: "0.5" }, "normal");
    $("#floatBox").attr("class", "floatBox " + cssName);
    $("#floatBox").css({ display: "block", left: (($(document).width()) / 2 - (parseInt(width) / 2)) + "px", top: ($(document).scrollTop() - (height == "auto" ? 300 : parseInt(height))) + "px", width: width, height: height });
    $("#floatBox").animate({ top: ($(document).scrollTop() + 50) + "px" }, "normal");
}

jQuery.cookie = function(name, value, options) {
    if (typeof value != 'undefined') { // name and value given, set cookie
        options = options || {};
        if (value === null) {
            value = '';
            options = $.extend({}, options); // clone object since it's unexpected behavior if the expired property were changed
            options.expires = -1;
        }
        var expires = '';
        if (options.expires && (typeof options.expires == 'number' || options.expires.toUTCString)) {
            var date;
            if (typeof options.expires == 'number') {
                date = new Date();
                date.setTime(date.getTime() + (options.expires * 24 * 60 * 60 * 1000));
            } else {
                date = options.expires;
            }
            expires = '; expires=' + date.toUTCString(); // use expires attribute, max-age is not supported by IE
        }
        // NOTE Needed to parenthesize options.path and options.domain
        // in the following expressions, otherwise they evaluate to undefined
        // in the packed version for some reason...
        var path = options.path ? '; path=' + (options.path) : '';
        var domain = options.domain ? '; domain=' + (options.domain) : '';
        var secure = options.secure ? '; secure' : '';
        document.cookie = [name, '=', encodeURIComponent(value), expires, path, domain, secure].join('');
    } else { // only name given, get cookie
        var cookieValue = null;
        if (document.cookie && document.cookie != '') {
            var cookies = document.cookie.split(';');
            for (var i = 0; i < cookies.length; i++) {
                var cookie = jQuery.trim(cookies[i]);
                // Does this cookie string begin with the name we want?
                if (cookie.substring(0, name.length + 1) == (name + '=')) {
                    cookieValue = decodeURIComponent(cookie.substring(name.length + 1));
                    break;
                }
            }
        }
        return cookieValue;
    }
};

/* 函数功能：字符串按照指定字符串分割转换为数组 
参数: 
str :需转换的字符串 
substr:分割字符串 
返回值: 
转换后的数组 
*/
function StringToArray(str, substr) {

    var arrTmp = new Array();
    if (substr == "") {
        arrTmp.push(str);
        return arrTmp;
    }
    var i = 0, j = 0, k = str.length;
    while (i < k) {
        j = str.indexOf(substr, i);
        if (j != -1) {
            if (str.substring(i, j) != "") { arrTmp.push(str.substring(i, j)); }
            i = j + 1;
        } else {
            if (str.substring(i, k) != "") { arrTmp.push(str.substring(i, k)); }
            i = k;
        }
    }
    return arrTmp;
}

//   删除数组中第一个匹配的元素，成功则返回位置索引，失败则返回   -1。 
Array.prototype.deleteElementByValue = function(varElement) {
    var numDeleteIndex = -1;
    for (var i = 0; i < this.length; i++) {
        //   严格比较，即类型与数值必须同时相等。 
        if (this[i] === varElement) {
            this.splice(i, 1);
            numDeleteIndex = i;
            break;
        }
    }
    return numDeleteIndex;
}

//导出excel  
function exportExcel_txt(tableid, name) //读取表格中每个单元到EXCEL中
{
    var oXL
    var curTbl = document.getElementById(tableid);
    try {
        //插件初始化失败时作出提示  
        oXL = new ActiveXObject('Excel.Application');
    } catch (e) {
        //alert("无法启动Excel!\n\n如果您确信您的电脑中已经安装了Excel，" + "那么请调整IE的安全级别。\n\n具体操作：\n\n" + "工具 → Internet选项 → 安全 → 自定义级别 → 对没有标记为安全的ActiveX进行初始化和脚本运行 → 启用");
        return false;
    }

    //创建AX对象excel
    var oWB = oXL.Workbooks.Add();

    //获取workbook对象
    var oSheet = oWB.ActiveSheet;
    oSheet.name = name;

    //var xlsheet = oWB.Worksheets(1);
    //xlsheet.Range(xlsheet.Cells(1, 1), xlsheet(1, 3)).mergecells = true;
    //激活当前sheet 
    var Lenr = curTbl.rows.length;
    //取得表格行数 
    for (i = 0; i < Lenr; i++) {
        var Lenc = curTbl.rows(i).cells.length;
        //取得每行的列数 
        for (j = 0; j < Lenc; j++) {
            oSheet.Cells(i + 1, j + 1).value = curTbl.rows(i).cells(j).innerText;
            //赋值 
        }
    }
    oXL.Visible = true;
    //设置excel可见属性 
}

function exportExcel2(tableid, name) //读取表格中每个单元到EXCEL中
{
    var curTbl = document.getElementById(tableid);
    var oXL = new ActiveXObject("Excel.Application");
    //创建AX对象excel 
    var oWB = oXL.Workbooks.Add();
    //获取workbook对象
    var oSheet = oWB.ActiveSheet;
    oSheet.name = name;

    //激活当前sheet 
    var Lenr = curTbl.rows.length;
    //取得表格行数
    for (i = 0; i < Lenr; i++) {

        var Lenc = curTbl.rows(i).cells.length;
        //oSheet.Columns(14).NumberFormatLocal = "@";
        //取得每行的列数
        for (j = 0; j < Lenc; j++) {
            oSheet.Columns(j + 1).NumberFormatLocal = "@";
            var ss = curTbl.rows(i).cells(j).innerText;
            oSheet.Cells(i + 1, j + 1).value = "  " + ss;
            //赋值
        }
    }
    oXL.Visible = true;
    //设置excel可见属性
}

   // function exportExcel(tableid, name) {//整个表格拷贝到EXCEL中 
   //     var curTbl = document.getElementById(tableid);
   //     var oXL = new ActiveXObject("Excel.Application");
   //     //创建AX对象excel 
   //     var oWB = oXL.Workbooks.Add();
   //     //获取workbook对象
   //     var oSheet = oWB.ActiveSheet;
   // oSheet.name = name;
   // 
   //     /*var Lenr = curTbl.rows.length;
   //     //取得表格行数
   //     for (i = 0; i < Lenr - 1; i++) {
   //         var Lenc = curTbl.rows(i).cells.length;
   //         //取得每行的列数
   //         for (j = 0; j < Lenc; j++) {
   //             oSheet.Columns(j + 1).NumberFormatLocal = "@";
   //             //赋值
   //         }
   //     }*/
   //     //oSheet.Columns(11).NumberFormatLocal = "@";
   //     //激活当前sheet
   //     var sel = document.body.createTextRange();
   //     
   //     sel.moveToElementText(curTbl);
   //     //把表格中的内容移到TextRange中 
   //     sel.select();
   //     //全选TextRange中内容 
   //     sel.execCommand("Copy");
   //     //复制TextRange中内容  
   //     oSheet.Paste();
   //     //粘贴到活动的EXCEL中
   //     oSheet.Columns.AutoFit;
   //     oXL.Visible = true; //设置excel可见属性
  //  oXL.UserControl = true;
//}


function exportExcel(tableid, name) {//整个表格拷贝到EXCEL中 
    //    var curTbl = document.getElementById(tableid);
    //    var oXL = new ActiveXObject("Excel.Application");
    //    //创建AX对象excel 
    //    var oWB = oXL.Workbooks.Add();
    //    //获取workbook对象
    //    var oSheet = oWB.ActiveSheet;
    //    oSheet.name = name;

    //    /*var Lenr = curTbl.rows.length;
    //    //取得表格行数
    //    for (i = 0; i < Lenr - 1; i++) {
    //        var Lenc = curTbl.rows(i).cells.length;
    //        //取得每行的列数
    //        for (j = 0; j < Lenc; j++) {
    //            oSheet.Columns(j + 1).NumberFormatLocal = "@";
    //            //赋值
    //        }
    //    }*/
    //    //oSheet.Columns(11).NumberFormatLocal = "@";
    //    //激活当前sheet
    //    var sel = document.body.createTextRange();
    //    
    //    sel.moveToElementText(curTbl);
    //    //把表格中的内容移到TextRange中 
    //    sel.select();
    //    //全选TextRange中内容 
    //    sel.execCommand("Copy");
    //    //复制TextRange中内容  
    //    oSheet.Paste();
    //    //粘贴到活动的EXCEL中
    //    oSheet.Columns.AutoFit;
    //    oXL.Visible = true; //设置excel可见属性
    //    oXL.UserControl = true;

    var curTbl = document.getElementById(tableid);
    var oXL = new ActiveXObject("Excel.Application");
    //创建AX对象excel 
    var oWB = oXL.Workbooks.Add();
    //获取workbook对象 
    var oSheet = oWB.ActiveSheet;
    //激活当前sheet 
    var Lenr = curTbl.rows.length;
    //取得表格行数

    oSheet.Cells(1, 1).value = "西安锦绣物流" + name;
    oSheet.Range(oSheet.Cells(1, 1), oSheet.Cells(1, 20)).Merge();
    oSheet.Cells(1, 1).HorizontalAlignment = 3;
    oSheet.Cells(1, 1).Font.Size = 14;
    oSheet.Cells(1, 1).Font.Bold = true;
    oSheet.Range(oSheet.Cells(2, 1), oSheet.Cells(2, 20)).Merge();
    var da = new Date();
    oSheet.Cells(2, 1).value = "导出日期：" + da.toLocaleDateString();
    oSheet.Range(oSheet.Cells(3, 1), oSheet.Cells(3, 10)).Merge();

    for (i = 0; i < Lenr; i++) {
        var Lenc = curTbl.rows(i).cells.length;
        //取得每行的列数
        if (i == Lenr - 1) {
            var hej = curTbl.rows(i).cells(0).innerText.substring(0, 2);
            if (hej == "合计") {
                for (j = 0; j < Lenc; j++) {

                    oSheet.Columns(j + 2).NumberFormatLocal = "@";
                    oSheet.Cells(i + 4, j + 2).value = curTbl.rows(i).cells(j).innerText;
                    oSheet.Cells(i + 4, j + 2).Borders.Weight = 2;
                    //赋值 
                }
            } else {
                for (j = 0; j < Lenc; j++) {
                    oSheet.Columns(j + 1).NumberFormatLocal = "@";
                    oSheet.Cells(i + 4, j + 1).value = curTbl.rows(i).cells(j).innerText;
                    oSheet.Cells(i + 4, j + 1).Borders.Weight = 2;

                    //赋值 
                }
            }
        } else {
            for (j = 0; j < Lenc; j++) {
                oSheet.Columns(j + 1).NumberFormatLocal = "@";
                oSheet.Cells(i + 4, j + 1).value = curTbl.rows(i).cells(j).innerText;
                oSheet.Cells(i + 4, j + 1).Borders.Weight = 2;

                //赋值 
            }
        }
    }
    oSheet.Columns.AutoFit;
    oXL.Visible = true;
    //设置excel可见属性
}