123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173 |
- $(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;
- }
- }
- });
|