$(function () { $("#jqGrid").jqGrid({ url: '../salesdataupload/list', datatype: "json", colModel: [ {label: 'fileId', name: 'fileId', index: 'file_id', key: true, hidden: true, align: 'center'}, {label: '文件名称', name: 'fileName', index: 'file_name', width: 80, align: 'center'}, {label: '文件类型', name: 'fileType', index: 'file_type', width: 80, align: 'center'}, {label: '上传地址', name: 'uploadAddress', index: 'upload_address', width: 80 ,align: 'center'}, {label: '添加人', name: 'username', index: 'username', width: 80, align: 'center'}, {label: '上传时间', name: 'createrTime', index: 'creater_time', width: 80, align: 'center', formatter: function (value) { return transDate(value, 'yyyy-MM-dd hh:mm:ss'); } }], viewrecords: true, height: 550, rowNum: 10, rowList: [10, 30, 50], rownumbers: true, rownumWidth: 25, autowidth: true, multiselect: true, pager: "#jqGridPager", jsonReader: { root: "page.list", page: "page.currPage", total: "page.totalPage", records: "page.totalCount" }, prmNames: { page: "page", rows: "limit", order: "order" }, gridComplete: function () { $("#jqGrid").closest(".ui-jqgrid-bdiv").css({"overflow-x": "hidden"}); } }); }); let vm = new Vue({ el: '#rrapp', data: { showList: true, title: null, salesDataUpload: {}, ruleValidate: { name: [ {required: true, message: '名称不能为空', trigger: 'blur'} ] }, q: { name: '' } }, methods: { query: function () { vm.reload(); }, add: function () { vm.showList = false; vm.title = "新增"; vm.salesDataUpload = {}; }, update: function (event) { let fileId = getSelectedRow(); if (fileId == null) { return; } vm.showList = false; vm.title = "修改"; vm.getInfo(fileId) }, saveOrUpdate: function (event) { let url = vm.salesDataUpload.fileId == null ? "../salesdataupload/save" : "../salesdataupload/update"; $.ajax({ type: "POST", url: url, contentType: "application/json", data: JSON.stringify(vm.salesDataUpload), success: function (r) { if (r.code === 0) { alert('操作成功', function (index) { vm.reload(); }); } else { alert(r.msg); } } }); }, del: function (event) { let fileIds = getSelectedRows(); if (fileIds == null){ return; } confirm('确定要删除选中的记录?', function () { $.ajax({ type: "POST", url: "../salesdataupload/delete", contentType: "application/json", data: JSON.stringify(fileIds), success: function (r) { if (r.code == 0) { alert('操作成功', function (index) { $("#jqGrid").trigger("reloadGrid"); }); } else { alert(r.msg); } } }); }); }, getInfo: function(fileId){ $.get("../salesdataupload/info/"+fileId, function (r) { vm.salesDataUpload = r.salesDataUpload; }); }, reloadSearch: function() { vm.q = { name: '' } vm.reload(); }, reload: function (event) { vm.showList = true; let page = $("#jqGrid").jqGrid('getGridParam', 'page'); $("#jqGrid").jqGrid('setGridParam', { postData: {'name': vm.q.name}, page: page }).trigger("reloadGrid"); vm.handleReset('formValidate'); }, handleSubmit: function (name) { handleSubmitValidate(this, name, function () { vm.saveOrUpdate() }); }, handleReset: function (name) { handleResetForm(this, name); }, uploadExcelSuccess: function (data) { if(data.code==0){ alert('导入成功', function (index) { $("#jqGrid").trigger("reloadGrid"); }); }else{ alert(data.msg); } }, uploadExcelError: function () { alert('上传出现异常,请重试!'); }, uploadExcelFormatError: function (file) { this.$Notice.warning({ title: '文件格式不正确', desc: '文件 ' + file.name + ' 格式不正确,请上传 xls 或 xlsx 格式的文件。' }); }, download: function (event){ debugger; let fileData = getSelectedRowData(); if (fileData.length != 1 && fileData.length != undefined){ return; } window.location.href = "../salesdataupload/download?filePath="+fileData.uploadAddress+"&fileName="+fileData.fileName+"&fileId="+fileData.fileId; } } });