dataTable与DataTable获取行数据,上传文件功能

zlscTable = $('#lxzlTable').dataTable({
    destroy: true,
    serverSide: true,
    responsive: true,
    processing:true,
    autoWidth: true,//自动计算列宽
    deferRender: true,//设置延迟渲染，提高效率用
    draw:false,
    searching : false, 
    bLengthChange: false,
    order: [ 0, 'asc' ],
    ajax: {
        url: "sjxm2/getLxzlInfoData",
        type: "POST",
        data : function(d) {  
            var sentJson = GET_SENT_JSON(d);
            sentJson.search1 = sjxmglArr[0].xmfldm.split('/')[0];
            sentJson.search2 = sjxmglArr[0].sjxmdm;
            return sentJson;
        },
        error: function (e) {
            ALERT_ERROR(zlscTable,e);
        },
    },
    lengthMenu: PAGELENGTH,
    "language": LANGUAGESETTING,
    columnDefs : [
        { "targets": 0 ,"name":"wdlx","title": "文档类型" ,"width": "10%" },
        { "targets": 1 ,"name":"wdmc","title": "文档名称" ,"width": "15%" },
        { "targets": 2 ,"name":"fj","title": "附件名（点击下载）" ,"width": "15%" },
        { "targets": 3 ,"name":"isby","title": "必要否" ,"width": "6%" ,orderable :false},
        { "targets": 4 ,"name":"is_zlsc","title": "资料生成" ,"width": "6%" ,orderable :false},
        { "targets": 5, "name":"lxzl_type", "title": "立项资料", "visible" : true, "width" : "15%", orderable : false },
        { "targets": 6 ,"name":"edit","title": "操作" ,"visible": true,"width": "20%"  ,orderable :false},
        { "targets": 7 ,"name":"wdbh","title": "文档编号" ,"visible": false,"width": "10%" , orderable :false ,},
        {
            "render": function ( data, type, row ) {
                var file = data.split(",");
                var result="";
                for(var i=0; i<file.length; i++){
                    //checkbox形式
                    //result += "<input type='checkbox' value=' + file[i] + '/><span style=\"color:green\">"  + file[i] + "</span><br>";
                    result += "<a class='download' id ='file' href='javascript:;' >"  + file[i] + "</a><br>"
                }
                return result;
            },
            "targets": [2],
            "visible": true
        },  
        {
            "render": function ( data, type, row ) {
                var result = "";
                if(data == "1"){
                    result = "<span style=\"color:green\">"  + "是" + "</span>";
                }else{
                    result = "<span style=\"color:red\">" + "否" + "</span>";
                }
                return result;
            },
            "targets": [3],
            "visible": true
        },
        {
            "render": function ( data, type, row ) {
                var result = "";
                if(data == "1"){
                    result = "<span style=\"color:green\">"  + "是" + "</span>";
                }else{
                    result = "<span style=\"color:red\">" + "否" + "</span>";
                }
                return result;
            },
            "targets": [4],
            "visible": true
        },
    ],
    columns: [
        { data: 'wdlx' },
        { data: 'wdmc' },
        { data: 'fj' },
        { data: 'isby' },
        { data: 'is_zlsc' },
        {
            "sClass": "text-center",
            "data": "lxzl_type",
            "render": function (data, type, row, meta) {
                var result = "";
                var i = meta.row;
                
                result = "<select selected id='sel_lxzl" + i + "' class='form-control' style='border:0;width: 100%'>";
                result += "<option value=''></option>";
                
                
                for(var i = 0; i < lxzl_list.length; i++){
                    if(data == lxzl_list[i].sybh){
                        result += "<option selected value='" + lxzl_list[i].sybh + "/" + lxzl_list[i].symc + "'> " + lxzl_list[i].symc + "</option>";
                    }
                }
                for(var i = 0; i < lxzl_list.length; i++){
                    if(data != lxzl_list[i].sybh){
                        result += "<option value='" + lxzl_list[i].sybh + "/" + lxzl_list[i].symc + "'> " + lxzl_list[i].symc + "</option>";
                    }
                }

                result += "</select>";
                return result;
            },
        },
        //带下载
        //{ data: null  ,defaultContent: "<button class='btn btn-primary upload' href='javascript:;'>上传</button>&nbsp;&nbsp;<button class='btn btn-primary download' href='javascript:;'>下载</button>" },
        { data: null  ,defaultContent: "<button class='btn btn-primary upload' href='javascript:;'>上传</button>&nbsp;&nbsp;<button class='btn btn-primary' id='deletefj' href='javascript:;'>删除</button>" },
        { data: 'wdbh' },
    ]
});

$('#lxzlTable tbody tr').live('click', function() { 
});

//鼠标移动添加背景颜色
mouseEvent("lxzlTable");



$("table#lxzlTable").on("change", "select", function(){
    
    var jzszDataArr = [];
    var nRowmc = $(this).parents('tr')[0];
    var aDatamc = zlscTable.fnGetData(nRowmc);   //dataTable
//  var aDatamc = $('#lxzlTable').DataTable().row(this).data(); //dataTable
//  var aDatamc = lxzlTable.row(this).data() //DataTable
    rowNummc = $(this).parents('tr')[0].rowIndex - 1;
});


//上传
$('#lxzlTable').on('click', '.upload', function (e) {
    
    uploadFiles();
    
    return false;
    
});

//文件上传
function uploadFiles() {
    
    form = $("<form id= 'uploadFile' enctype='multipart/form-data' method='post'></form>");
    input1 = $("<input id='fileName' type='file' name='fileName' style = 'display:none' multiple />");
    form.append(input1);
    form.appendTo("body")

    $("#fileName").click();

    // 获取文件对象
//    var file = $('#fileName')[0].files;
//    if (!file || file.length === 0) {
//      alert('请先选择文件');
//      return false;
//    } else {
//      return file[0];
//    }
};

$('#uploadFile').live("change","#fileName",function(){
    var file = $('#fileName')[0].files;
    var sjxm = sjxmglArr[0].sjxmdm;
    
    // 构建form数据
    var formFile = new FormData;
    
    //把文件放入form对象中
    for(var i=0; i<file.length; i++){
        formFile.append("action", "UploadPath");
        formFile.append('file', file[i]);
    }
    formFile.append('sjxmdm', sjxm);
    formFile.append('lxzl', $('#sel_lxzl' + rowNummc).val().split("/")[0]);
    var nRow = $(this).parents('tr')[0];
    var aData = zlscTable.fnGetData(nRow);
    
    $.ajax({
        type : 'POST',
        url : BASEPATH + "sjxm2/uploadFile",
        data : formFile,
        contentType : false, //定义格式
        processData : false, //必须要
        success : function(data) {
            if(data.message == 'success'){
                var fjList = [];
                var fj;
                for(var i=0; i<file.length; i++){
                    fjList.push(file[i].name)
                }
                fj = fjList.join(",");
                var paramData = {
                    sjxmdm : aData[0].sjxmdm,
                    wdmc : aData[0].wdmc,
                    fj : fj
                }
                $.ajax({
                    type : 'POST',
                    url : 'sjxm2/uploadFileName',
                    dataType : "json",
                    contentType : 'application/json', //定义格式
                    data : JSON.stringify(paramData),
                    async : false,
                    processData : false, //必须要
                    success : function(data) {
                        if(data.message == 'success'){
                            Metronic.alert({
                                type: 'success',
                                icon: 'success',
                                message: '资料上传成功!',
                                place: 'prepend',
                                closeInSeconds:5,
                                container:'#lxzlUDAlertsMsg',
                                focus:true
                            });
                            freshZlscTable();
                        } else {
                            Metronic.alert({
                                type: 'danger',
                                icon: 'warning',
                                message: "资料上传不成功!",
                                place: 'prepend',
                                closeInSeconds:5,
                                container:'#lxzlUDAlertsMsg',
                                focus:true
                            });
                        }
                    },
                    error : function(data) {
                        console.log(JSON.stringify(data))
                    }
                });
            } else {
                Metronic.alert({
                    type: 'danger',
                    icon: 'warning',
                    message : "文件上传失败",
                    place : 'prepend',
                    closeInSeconds : 5,
                    container : '#lxzlUDAlertsMsg',
                    focus : true
                });
            }
        },
        error : function(data) {
            console.log(JSON.stringify(data))
        }
    });
});

转载于:https://www.cnblogs.com/sunBinary/p/11592487.html