DEMOMySql/MicroServices/Business/Business.Host/Controllers/JavaScript.js

debugger;
let filename = this.formData['field_1701071916854'];
var newrow = "";
var arr = [];
console.log(filename);
ajax.post('/Think/excelImport', qs.stringify({
    filename: filename,
    headerRows: 3,
    hashead: 0,
    cols: "",
    sheetnum: ""
})).then((res) => {
    console.log(res);
    this.formData['subtable_1678085442815'] = [];
    let myArray = [];
    let k = 0;
    for (var i = 0; i < res.data.rows.length; i++) {
        if (res.data.rows[i].A1 != "") {
            k++;
            console.log(res.data.rows[i].A1);
            let b = utils.createGuid(false);
            let scrqyear = (new Date(res.data.rows[i].A11)).getFullYear();
            if (scrqyear.toString().length > 4) if (confirm("生产日期格式错误")) continue;
            newrow = '{"key":"' + b
            newrow = newrow + '","sh_material_code": "' + res.data.rows[i].A4;
            newrow = newrow + '","sh_material_name": "' + res.data.rows[i].A5;
            newrow = newrow + '","th": "' + res.data.rows[i].A6;
            newrow = newrow + '","bbh": "' + res.data.rows[i].A7;
            newrow = newrow + '","sh_material_dw": "' + res.data.rows[i].A10;
            newrow = newrow + '","sh_delivery_quantity": "' + res.data.rows[i].A8;
            newrow = newrow + '","bzsl": "' + res.data.rows[i].A9;
            if (res.data.rows[i].A9 == 0 || res.data.rows[i].A9 == null) {
                newrow = newrow + '","bqsl": "1';
            }
            else {
                newrow = newrow + '","bqsl": "' + (Math.ceil((parseFloat(res.data.rows[i].A8) / parseFloat(res.data.rows[i].A9)).toFixed(4)));
            }
            newrow = newrow + '","order_type": "' + res.data.rows[i].A3;
            let sql = `SELECT count(*) as num from PurOrdDetail where purord='${res.data.rows[i].A1}' and ItemNum='${res.data.rows[i].A4}' and line=${res.data.rows[i].A2}`;
            let res1 = utils.getSelectvalue2("dopflow", sql, sysConfig['SERVER_APIADDRESS']);
            if (res1.data <= 0) {
                if (confirm("采购明细不存在")) continue;
            }
            newrow = newrow + '","po_bill": "' + res.data.rows[i].A1;
            newrow = newrow + '","po_billline": "' + res.data.rows[i].A2;
            newrow = newrow + '","djsl": "' + res.data.rows[i].A13;
            newrow = newrow + '","remarks": "' + res.data.rows[i].A15;
            newrow = newrow + '","scrq": "' + res.data.rows[i].A11;
            newrow = newrow + '","scph": "' + res.data.rows[i].A12.trim();
            newrow = newrow + '","jhdbh": "' + res.data.rows[i].A14;
            newrow = newrow + '","hh": "' + k;
            newrow = newrow + '"  }'
            console.log(newrow);
            this.formData['subtable_1678085442815'].push(JSON.parse(newrow));
        }
    }
}).catch(() => { });