| New file |
| | |
| | | <template> |
| | | <div style="padding: 10px;"> |
| | | <el-form :model="queryParams" ref="queryForm" size="small" :inline="true" label-width="78px" class="searchBox"> |
| | | <el-form-item label="å¼å§æ¥æ" style="margin-left: 100px;"> |
| | | <el-date-picker v-model="queryParams.sTime" type="date" placeholder="å¼å§æ¥æ" style="width: 150px;"> |
| | | </el-date-picker> |
| | | </el-form-item> |
| | | <el-form-item label="ç»ææ¥æ"> |
| | | <el-date-picker v-model="queryParams.eTime" type="date" placeholder="ç»ææ¥æ" style="width: 150px;"> |
| | | </el-date-picker> |
| | | </el-form-item> |
| | | <el-form-item label="æ¥æé´é"> |
| | | <el-select v-model="queryParams.HInitTimeCycle" placeholder="è¯·éæ©" @change="riqiChange" style="width: 150px;"> |
| | | <el-option v-for="(item, index) in rqsgList" :key="index" :label="item.label" :value="item.value"> |
| | | </el-option> |
| | | </el-select> |
| | | </el-form-item> |
| | | <el-form-item label="æ¡ç ç¼å·" prop="HBarCode"> |
| | | <el-input v-model="queryParams.HBarCode" placeholder="请è¾å
¥æ¡ç ç¼å·" @keyup.enter.native="handleQuery" /> |
| | | </el-form-item> |
| | | <el-form-item label="ç»ç»" prop="HOrgID"> |
| | | <el-select v-model="queryParams.HOrgID" placeholder="è¯·éæ©ç»ç»"> |
| | | <el-option v-for="(item, index) in organizationList" :key="index" :label="item.Name" :value="item.ID"> |
| | | </el-option> |
| | | </el-select> |
| | | </el-form-item> |
| | | <el-form-item label="æºååå·" prop="HSourceBillNo"> |
| | | <el-input v-model="queryParams.HSourceBillNo" placeholder="请è¾å
¥æºååå·" @keyup.enter.native="handleQuery" /> |
| | | </el-form-item> |
| | | <el-form-item label="ç©æä»£ç " prop="HMaterNumber"> |
| | | <el-input v-model="queryParams.HMaterNumber" placeholder="请è¾å
¥ç©æä»£ç " @keyup.enter.native="handleQuery" /> |
| | | </el-form-item> |
| | | <el-form-item label="ç©æåç§°" prop="HMaterName"> |
| | | <el-input v-model="queryParams.HMaterName" placeholder="请è¾å
¥ç©æåç§°" @keyup.enter.native="handleQuery" /> |
| | | </el-form-item> |
| | | <el-form-item label-width="78px"> |
| | | <el-button type="primary" icon="el-icon-search" @click="handleQuery"> æ ç´¢</el-button> |
| | | <el-button icon="el-icon-circle-close" @click="resetQuery">é ç½®</el-button> |
| | | </el-form-item> |
| | | <el-collapse v-model="activeSeach"> |
| | | <el-collapse-item title="æ´å¤" name="1"> |
| | | <el-card class="box-card"> |
| | | <div slot="header" class="clearfix"><span>è¿æ»¤</span></div> |
| | | <div> |
| | | <el-row> |
| | | <el-form-item label-width="0"> |
| | | <el-row> |
| | | <el-col :span="7"> |
| | | <el-select v-model="queryParams.ColName1" placeholder="è¯·éæ©" @change="riqiChange"> |
| | | <span v-for="(item, index) in btList" :key="index"> |
| | | <el-option :label="item.field" :value="item.field" v-if="!item.hide"></el-option> |
| | | </span> |
| | | </el-select> |
| | | </el-col> |
| | | <el-col :span="6" style="padding: 0 10px;"> |
| | | <el-select v-model="queryParams.Comparator1" placeholder="è¯·éæ©" @change="riqiChange"> |
| | | <el-option v-for="(item, index) in comparatorList" :key="index" :label="item.label" |
| | | :value="item.value"></el-option> |
| | | </el-select> |
| | | </el-col> |
| | | <el-col :span="11"> |
| | | <el-input v-model="queryParams.ColContent1" placeholder="请è¾å
¥" clearable |
| | | @keyup.enter.native="handleQuery" /> |
| | | </el-col> |
| | | </el-row> |
| | | </el-form-item> |
| | | </el-row> |
| | | <el-row> |
| | | <el-form-item label-width="0"> |
| | | <el-row> |
| | | <el-col :span="7"> |
| | | <el-select v-model="queryParams.ColName2" placeholder="è¯·éæ©" @change="riqiChange"> |
| | | <span v-for="(item, index) in btList" :key="index"> |
| | | <el-option :label="item.field" :value="item.field" v-if="!item.hide"></el-option> |
| | | </span> |
| | | </el-select> |
| | | </el-col> |
| | | <el-col :span="6" style="padding: 0 10px;"> |
| | | <el-select v-model="queryParams.Comparator2" placeholder="è¯·éæ©" @change="riqiChange"> |
| | | <el-option v-for="(item, index) in comparatorList" :key="index" :label="item.label" |
| | | :value="item.value"></el-option> |
| | | </el-select> |
| | | </el-col> |
| | | <el-col :span="11"> |
| | | <el-input v-model="queryParams.ColContent2" placeholder="请è¾å
¥" clearable |
| | | @keyup.enter.native="handleQuery" /> |
| | | </el-col> |
| | | </el-row> |
| | | </el-form-item> |
| | | </el-row> |
| | | <el-form-item label-width="0"> |
| | | <el-row> |
| | | <el-col :span="7"> |
| | | <el-select v-model="queryParams.ColName" placeholder="è¯·éæ©" @change="riqiChange"> |
| | | <el-option v-for="(item, index) in btList" :key="index" :label="item.field" |
| | | :value="item.field"></el-option> |
| | | </el-select> |
| | | </el-col> |
| | | <el-col :span="6" style="padding: 0 10px;"> |
| | | <el-select v-model="queryParams.Comparator" placeholder="è¯·éæ©" @change="riqiChange"> |
| | | <el-option v-for="(item, index) in comparatorList" :key="index" :label="item.label" |
| | | :value="item.value"></el-option> |
| | | </el-select> |
| | | </el-col> |
| | | <el-col :span="11"> |
| | | <el-input v-model="queryParams.ColContent" placeholder="请è¾å
¥" clearable |
| | | @keyup.enter.native="handleQuery" /> |
| | | </el-col> |
| | | </el-row> |
| | | </el-form-item> |
| | | </div> |
| | | </el-card> |
| | | </el-collapse-item> |
| | | </el-collapse> |
| | | </el-form> |
| | | <el-row :gutter="10" class="mb8" style="margin-top: 10px;"> |
| | | <!-- <el-col :span="1.5"> |
| | | <el-button type="primary" icon="el-icon-delete" size="mini" :disabled="single" @click="handleDrop">å é¤ |
| | | </el-button> |
| | | </el-col> --> |
| | | <el-col :span="1.5"> |
| | | <el-button type="primary" icon="el-icon-delete" size="mini" :disabled="single" @click="handleDelete(0)">ä½åº |
| | | </el-button> |
| | | </el-col> |
| | | <el-col :span="1.5"> |
| | | <el-button type="primary" icon="el-icon-delete" size="mini" :disabled="single" @click="handleDelete(1)">åä½åº |
| | | </el-button> |
| | | </el-col> |
| | | <el-col :span="1.5"> |
| | | <el-button type="primary" icon="el-icon-download" size="mini" @click="handleExport">导åº</el-button> |
| | | </el-col> |
| | | <el-col :span="1.5"> |
| | | <el-button type="primary" icon="el-icon-date" size="mini" @click="handleRowHide">éèå设置</el-button> |
| | | </el-col> |
| | | <el-col :span="1.5"> |
| | | <el-button type="primary" icon="el-icon-printer" size="mini" @click="get_PrintReport">æå°</el-button> |
| | | </el-col> |
| | | </el-row> |
| | | <div class="tableBox" v-loading="loading"> |
| | | <el-table :data="tableData" ref="tableData" max-height="710" :summary-method="getSummaries" |
| | | @selection-change="handleSelectionChange" show-summary border @row-click="handleRowClick" :row-style="rowStyle" |
| | | @cell-dblclick="handleDblclick" v-if="tableShow"> |
| | | <template v-for="(item, index) in btList"> |
| | | <el-table-column type="selection" width="55" align="center" :fixed="item.fixed" v-if="item.type == 'checkbox'" |
| | | :key="index" /> |
| | | <el-table-column :align="item.align" :prop="item.field" :label="item.title" :width="item.width" :key="item.id" |
| | | v-else-if="!item.hide && item.type != 'checkbox'" :sortable="item.sort" show-overflow-tooltip |
| | | :fixed="item.fixed"> |
| | | <template slot-scope="{row, column }"> |
| | | <el-checkbox v-model="checked" v-if="item.type == 'checkbox'"></el-checkbox> |
| | | <div :style="item.style"> |
| | | <span v-if="column.property.includes('æ¥æ')">{{ parseTime(row[column.property], '{y}-{m}-{d}') }}</span> |
| | | <el-button type="text" @click="handleEdit(row, OperationType = 3)" |
| | | v-else-if="column.property == 'åæ®å·'">{{ |
| | | row.åæ®å· |
| | | }}</el-button> |
| | | <span v-else>{{ row[column.label] }}</span> |
| | | </div> |
| | | </template> |
| | | </el-table-column> |
| | | </template> |
| | | </el-table> |
| | | <!-- è®°å½æ°ã页æ°ãå½å页 --> |
| | | <pagination v-show="total > 0" :total="total" :page.sync="page" :limit.sync="pageSize" @pagination="handleQuery" /> |
| | | <!-- å设置 --> |
| | | <el-dialog title="éèå设置" :visible.sync="openRowHide" width="816px" append-to-body> |
| | | <RowSettings :colName="btResList" HModName="Kf_POStockInBillList" @rowEditClose="rowSetClose" |
| | | v-if="rowHideShow" /> |
| | | </el-dialog> |
| | | <!-- æå° --> |
| | | <el-dialog title="æå°æ¨¡æ¿éæ©" :visible.sync="openPrintList" width="800px" append-to-body> |
| | | <PrintList :linterid="rowSel.toString()" :MyMsg="rowSel.toString()" Type="HGy_BarCodeBill" |
| | | HModName="HGy_BarCodeBill" @rowEditClose="rowSetClose" v-if="printListShow" /> |
| | | </el-dialog> |
| | | </div> |
| | | </div> |
| | | </template> |
| | | |
| | | <script> |
| | | import axios from 'axios' |
| | | import moment from 'moment'; //导åºç»ä»¶ |
| | | import RowSettings from '@/views/component/rowSettings' //å设置ç»ä»¶ |
| | | import PrintList from "@/views/component/printList"; //æå°ç»ä»¶ |
| | | |
| | | export default { |
| | | name: 'Gy_BarCodeBillList', |
| | | components: { RowSettings, PrintList}, |
| | | data() { |
| | | return { |
| | | baseURL: process.env.VUE_APP_BASE_API, //å端æ¥å£åç¼(å端æå¡å¨ipå°å) |
| | | |
| | | HInterID: null, |
| | | rowSel: [], //ç¨äºæå°çæ°æ®éå |
| | | |
| | | rqsgList: [ //æ¥æé´é䏿åè¡¨æ°æ® |
| | | { label: 'ä»å¤©', value: 0 }, |
| | | { label: 'è¿ä¸¤å¤©', value: 1 }, |
| | | { label: 'è¿ä¸å¤©', value: 2 }, |
| | | { label: 'è¿å天', value: 3 }, |
| | | { label: 'è¿äºå¤©', value: 4 }, |
| | | { label: 'è¿å
天', value: 5 }, |
| | | { label: 'è¿ä¸å¤©', value: 6 }, |
| | | { label: 'è¿30天', value: 29 }, |
| | | { label: 'è¿åå¹´', value: 180 }, |
| | | { label: 'è¿ä¸å¹´', value: 365 }, |
| | | ], |
| | | organizationList: [], //ç»ç»å表 |
| | | btList: [], //åè¡¨è¡¨å¤´åæ®µå表 |
| | | comparatorList: [ //è¿ç®æ è¯ä¸æå表 |
| | | { label: '=', value: '=' }, |
| | | { label: '>=', value: '>=' }, |
| | | { label: '>', value: '>' }, |
| | | { label: '<=', value: '<=' }, |
| | | { label: '<', value: '<' }, |
| | | { label: '<>', value: '<>' }, |
| | | { label: 'å
å«', value: '7' }, |
| | | { label: 'å·¦å
å«', value: '8' }, |
| | | { label: 'å³å
å«', value: '9' }, |
| | | { label: 'ä¸å
å«', value: '10' }, |
| | | ], |
| | | |
| | | dialogTitle: '', // å¼¹çªæ é¢ |
| | | title: "", // å¼¹åºå±æ é¢ |
| | | open: false, // æ¯å¦æ¾ç¤ºå¼¹åºå± |
| | | loading: true, // é®ç½©å± |
| | | |
| | | activeSeach: '', |
| | | openPrintList: false, //æå°ç»ä»¶å®¹å¨æ¾ç¤ºæ è®° |
| | | printListShow: false, //æå°ç»ä»¶æ¾ç¤ºæ è®° |
| | | openBtnHide: false, //æé®ç»ä»¶å®¹å¨æ¾ç¤ºæ è®° |
| | | btnHideShow: false, //æé®ç»ä»¶æ¾ç¤ºæ è®° |
| | | openRowHide: false, //å设置ç»ä»¶æ¾ç¤ºæ è®° |
| | | rowHideShow: false, //å设置ç»ä»¶å®¹å¨æ¾ç¤ºæ è®° |
| | | |
| | | // æ¥è¯¢åæ° |
| | | sWhere: '', // æ¼æ¥è¿æ»¤æ¡ä»¶ |
| | | queryParams: { // formæ°æ® |
| | | HBarCode: '', |
| | | HInitTimeCycle: 29, |
| | | sTime: '', |
| | | eTime: '', |
| | | HOrgID: 0, |
| | | HSourceBillNo: '', |
| | | HMaterNumumber: '', |
| | | HMaterName: '', |
| | | |
| | | |
| | | ColName: '', |
| | | Comparator: '', |
| | | ColContent: '', |
| | | ColName1: '', |
| | | Comparator1: '', |
| | | ColContent1: '', |
| | | ColName2: '', |
| | | Comparator2: '', |
| | | ColContent2: '', |
| | | }, |
| | | |
| | | page: 1, //pageé¡µç´¢å¼ |
| | | pageSize: 0, //page页é¢è®°å½æ° |
| | | total: 0, //è®°å½åè®¡æ° |
| | | tableShow: true, // tableæ¾ç¤ºæ è®° |
| | | totalNameList: [], // éè¦è®¾ç½®å计è¡çåæ°ç» |
| | | tableData: [], // åè¡¨æ°æ®ãç¨äºtableçå¬äºä»¶ |
| | | ids: [], // éä¸è¡çhmainidæ°ç» |
| | | single: true, // å½éä¸çè¡æ°ä¸ä¸º1æ¶ä¸ºtrueãç¨äºç¦ç¨ç¸å
³æä½ |
| | | multiple: true, // å½éä¸çè¡æ°ä¸º0æ¶ä¸ºtrueãç¨äºç¦ç¨ç¸å
³æä½ |
| | | lastSelectedRowIndex: null, // ç¨äºè®°å½ä¸æ¬¡ç¹å»çè¡ç´¢å¼ |
| | | lastSelectedRow: null, // ä¸ä¸æ¬¡éä¸çè¡ |
| | | selectedRow: null, // å½åéä¸çè¡ |
| | | rowForm: {}, // å½éä¸çåªæä¸è¡æ¶ï¼æ´æ°æ°æ®ä¸ºè¯¥éä¸çè¡ã |
| | | checkDataList: [], // è¡¨æ ¼é䏿°æ®éå |
| | | |
| | | tyResList: [], // åè¡¨æ°æ®ï¼ç¨äºå¯¼åº |
| | | titleData: [], // ä¸éè¦æ¾ç¤ºçåæ®µ 坿©å± |
| | | btResList: [], // åè¡¨è¡¨å¤´æ°æ®ãç¨äºå设置 |
| | | dataList: [], // optionè®°å½ãç¨äºå½optionæ°æ®æ ææ¶ï¼ç¨äºå设置 |
| | | }; |
| | | }, |
| | | created() { |
| | | this.fetchData() //å è½½ç»ç»ä¸æåè¡¨æ°æ® |
| | | this.riqiChange() |
| | | this.handleQuery(); |
| | | }, |
| | | |
| | | methods: { |
| | | //#region 设置表头 |
| | | renderHeader(h, { column, $index }) {// æ°å»ºä¸ä¸ª span |
| | | let span = document.createElement(span)// 设置表头åç§° |
| | | span.innerText = column.label |
| | | //ä¸´æ¶æå
¥ document |
| | | document.body.appendChild(span)// éç¹:è·å span æå°å®½åº¦ï¼è®¾ç½®å½ååï¼æ³¨æè¿éå äº 20ï¼å段è¾å¤æ¶column.minWidth=span.getBoundingClientRect().width + 50.//ç§»é¤ document ä¸ä¸´æ¶ç span |
| | | document.body.removeChild(span) |
| | | return h(span, column.label) |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region ç¹å»è¡ |
| | | handleRowClick(row, column, event) { |
| | | this.lastSelectedRow = this.selectedRow; // è®°å½ä¸ä¸æ¬¡éä¸çè¡ |
| | | this.selectedRow = row; // è®°å½å½åéä¸çè¡ |
| | | this.lastSelectedRowIndex = this.tableData.indexOf(row); |
| | | this.$refs.tableData.toggleRowSelection(row); |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region éä¸è¡é«äº®æ ·å¼ |
| | | rowStyle({ row, rowIndex }) { |
| | | if (this.ids.includes(row.hmainid)) { |
| | | return { "background": "#ecf5ff" } |
| | | } |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region åå»è¡ |
| | | handleDblclick(row, column, cell, event) { |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region å¤éæ¡é䏿°æ® |
| | | handleSelectionChange(selection) { |
| | | // this.rowForm = {} |
| | | this.checkDataList = selection; |
| | | this.ids = selection.map(item => item.hmainid) |
| | | this.single = selection.length != 1 |
| | | this.multiple = !selection.length |
| | | if (!this.single) { |
| | | this.rowForm = selection[0] |
| | | } |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region æ ¹æ®æ¥æé´éï¼è®¾ç½®å¼å§æ¥æãç»ææ¥æ |
| | | riqiChange() { |
| | | const end = new Date(); |
| | | const start = new Date(); |
| | | start.setTime(start.getTime() - 3600 * 1000 * 24 * this.queryParams.HInitTimeCycle); |
| | | const yyyyS = start.getFullYear(); |
| | | const mmS = String(start.getMonth() + 1).padStart(2, '0'); // æä»½æ¯ä»0å¼å§ç |
| | | const ddS = String(start.getDate()).padStart(2, '0'); |
| | | const yyyyE = end.getFullYear(); |
| | | const mmE = String(end.getMonth() + 1).padStart(2, '0'); // æä»½æ¯ä»0å¼å§ç |
| | | const ddE = String(end.getDate()).padStart(2, '0'); |
| | | this.queryParams.sTime = yyyyS + '-' + mmS + '-' + ddS |
| | | this.queryParams.eTime = yyyyE + '-' + mmE + '-' + ddE |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region å è½½ç»ç»ä¸æåè¡¨æ°æ® |
| | | fetchData() { |
| | | axios.get(this.baseURL + "/Web/GetOrganizations", { |
| | | }).then(response => { |
| | | if (response.data.count == 1) { |
| | | this.organizationList = response.data.data;//ç»ç»å表 |
| | | } |
| | | }).catch(error => { |
| | | this.$modal.msgError("æ¥å£è¯·æ±å¤±è´¥!"); |
| | | }); |
| | | this.queryParams.HOrgID = sessionStorage["OrganizationID"]; |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region éç½® |
| | | resetQuery() { |
| | | this.sWhere = '' |
| | | this.queryParams = { |
| | | HBarCode: '', |
| | | HInitTimeCycle: 29, |
| | | HSourceBillNo: '', |
| | | HMaterNumber: '', |
| | | HMaterName: '', |
| | | |
| | | ColName: '', |
| | | Comparator: '', |
| | | ColContent: '', |
| | | ColName1: '', |
| | | Comparator1: '', |
| | | ColContent1: '', |
| | | ColName2: '', |
| | | Comparator2: '', |
| | | ColContent2: '', |
| | | |
| | | } |
| | | this.riqiChange() |
| | | this.resetForm("queryForm") |
| | | this.handleQuery() |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region å¿«éè¿æ»¤ |
| | | handleQuery() { |
| | | this.sWhere = '' |
| | | if (this.queryParams.ColName && this.queryParams.Comparator) { |
| | | var com = ""; |
| | | switch (this.queryParams.Comparator) { |
| | | case "7": |
| | | com = "like''%" + this.queryParams.ColContent + "%''"; |
| | | break; |
| | | case "8": |
| | | com = "like''%" + this.queryParams.ColContent + "''"; |
| | | break; |
| | | case "9": |
| | | com = "like''" + this.queryParams.ColContent + "%''"; |
| | | break; |
| | | case "10": |
| | | com = "not like''%" + this.queryParams.ColContent + "%''"; |
| | | break; |
| | | default: |
| | | com = "" + this.queryParams.Comparator + "''" + this.queryParams.ColContent + "''"; |
| | | break; |
| | | } |
| | | this.sWhere += " and " + this.queryParams.ColName + " " + com; |
| | | } |
| | | if (this.queryParams.ColName1 && this.queryParams.Comparator1) { |
| | | var com1 = ""; |
| | | switch (this.queryParams.Comparator1) { |
| | | case "7": |
| | | com1 = "like''%" + this.queryParams.ColContent1 + "%''"; |
| | | break; |
| | | case "8": |
| | | com1 = "like''%" + this.queryParams.ColContent1 + "''"; |
| | | break; |
| | | case "9": |
| | | com1 = "like''" + this.queryParams.ColContent1 + "%''"; |
| | | break; |
| | | case "10": |
| | | com1 = "not like''%" + this.queryParams.ColContent1 + "%''"; |
| | | break; |
| | | default: |
| | | com1 = "" + this.queryParams.Comparator1 + "''" + this.queryParams.ColContent1 + "''"; |
| | | break; |
| | | } |
| | | this.sWhere += " and " + this.queryParams.ColName1 + " " + com1; |
| | | } |
| | | if (this.queryParams.ColName2 && this.queryParams.Comparator2) { |
| | | var com2 = ""; |
| | | switch (this.queryParams.Comparator2) { |
| | | case "7": |
| | | com2 = "like''%" + this.queryParams.ColContent2 + "%''"; |
| | | break; |
| | | case "8": |
| | | com2 = "like''%" + this.queryParams.ColContent2 + "''"; |
| | | break; |
| | | case "9": |
| | | com2 = "like''" + this.queryParams.ColContent2 + "%''"; |
| | | break; |
| | | case "10": |
| | | com2 = "not like''%" + this.queryParams.ColContent2 + "%''"; |
| | | break; |
| | | default: |
| | | com2 = "" + this.queryParams.Comparator + "''" + this.queryParams.ColContent + "''"; |
| | | break; |
| | | } |
| | | this.sWhere += " and " + this.queryParams.ColName2 + " " + com2; |
| | | } |
| | | if (this.queryParams.sTime) { |
| | | this.queryParams.sTime = moment(this.queryParams.sTime).format('YYYY-MM-DD') |
| | | this.queryParams.eTime = moment(this.queryParams.eTime).format('YYYY-MM-DD') |
| | | console.log(this.queryParams.sTime, this.queryParams.eTime) |
| | | this.sWhere += " and CONVERT(varchar(100),æ¥æ, 23) >= ''" + this.queryParams.sTime + "''" + " and CONVERT(varchar(100),æ¥æ, 23) <= ''" + this.queryParams.eTime + "''"; |
| | | } |
| | | if (this.queryParams.HBarCode) { |
| | | this.sWhere += " and æ¡ç ç¼å· like ''%" + this.queryParams.HBarCode + "%''"; |
| | | } |
| | | if (this.queryParams.HSupName) { |
| | | this.sWhere += " and æºååå· like ''%" + this.queryParams.HSourceBillNo + "%''"; |
| | | } |
| | | if (this.queryParams.HMaterNumber) { |
| | | this.sWhere += " and ç©æä»£ç like ''%" + this.queryParams.HMaterNumber + "%''"; |
| | | } |
| | | if (this.queryParams.HMaterName) { |
| | | this.sWhere += " and ç©æåç§° like ''%" + this.queryParams.HMaterName + "%''"; |
| | | } |
| | | if (this.queryParams.HOrgID) { |
| | | this.sWhere += " and HStockOrgID = ''" + this.queryParams.HOrgID + "''"; |
| | | } |
| | | this.getList() |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region æ¥è¯¢ |
| | | getList() { |
| | | this.pageSize = 50 |
| | | if (this.pageSize == 0) { |
| | | this.pageSize = 50 |
| | | } |
| | | this.tableShow = false |
| | | this.loading = true |
| | | |
| | | // å表æ¥è¯¢ |
| | | axios.get(this.baseURL + '/Gy_BarCodeBillList/page', { |
| | | params: { |
| | | "sWhere": this.sWhere, |
| | | "user": sessionStorage["HUserName"], |
| | | "page": this.page, |
| | | "size": this.pageSize |
| | | }, |
| | | }).then(response => { |
| | | this.tyResList = response.data.data//æ»æ°æ® |
| | | let data1 = response.data |
| | | let option = [] |
| | | if (data1.code == 1) { |
| | | this.btResList = data1.list //åè¡¨è¡¨å¤´æ°æ® |
| | | this.total = data1.count; |
| | | var data = [];//ååæ®µæ°æ® |
| | | var col = []; |
| | | var totalArray = []; |
| | | //ç»ç©ºçæ°ç»èµå¼ |
| | | for (var key in data1.list) {//循åºéåæ°ç» |
| | | data.push({ "id": data1.list[key].ColmCols, "name": data1.list[key].ColmCols, "Type": data1.list[key].ColmType });//仿¯ä¸ªå¯¹è±¡ä¸æåæ°æ® |
| | | } |
| | | //å¨å表左边添å å¾éæ¡ |
| | | col.push({ type: 'checkbox', fixed: 'left', totalRowText: 'å计' }); |
| | | for (var i = 0; i < data.length; i++) {//éådataæ°ç»éçæ°æ® |
| | | if (this.titleData.indexOf(data[i].name) > -1) {//æ£æ¥dataãiã.nameæ¯å¦å¨æ°ç»ä¸ //计ç®å |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', hide: true }); //éèidå |
| | | } else if (totalArray.indexOf(data[i].name) > -1 || (data[i].Type == "Decimal" || data[i].Type == "Int32")) { //计ç®å |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, totalRow: true, width: 120 }); |
| | | } |
| | | else { |
| | | col.push({ field: data[i].id, title: data[i].name, align: 'center', sort: true, width: 200 }); |
| | | } |
| | | } |
| | | option.cols = [col] |
| | | this.dataList = option |
| | | option.data = data1.data; |
| | | var result = data1.data; |
| | | option.data = result; |
| | | this.checkDataList = []; |
| | | let HModName = "Gy_BarCodeBillList" |
| | | this.DisPlay_HideColumn(HModName, sessionStorage["HUserName"], option, this.dataList); |
| | | } |
| | | }).catch(error => { |
| | | this.$modal.msgError("æ¥å£è¯·æ±å¤±è´¥!"); |
| | | }); |
| | | }, |
| | | |
| | | //#region åè®¡è¡æ°æ®å¤ç |
| | | getSummaries(param) { |
| | | const { columns, data } = param; |
| | | const sums = []; |
| | | columns.forEach((column, index) => { |
| | | if (index === 0) { |
| | | sums[index] = 'å计'; |
| | | return; |
| | | } |
| | | const values = data.map(item => Number(item[column.property])); |
| | | if (this.totalNameList[index].totalRow) { |
| | | if (!values.every(value => isNaN(value))) { |
| | | sums[index] = values.reduce((prev, curr) => { |
| | | const value = Number(curr); |
| | | if (!isNaN(value)) { |
| | | return prev + curr; |
| | | } else { |
| | | return prev; |
| | | } |
| | | }, 0) |
| | | |
| | | } else { |
| | | sums[index] = ''; |
| | | } |
| | | } |
| | | }, 1000); |
| | | return sums; |
| | | }, |
| | | //#endregion |
| | | |
| | | //#endregion |
| | | |
| | | //#region å é¤ |
| | | handleDrop() { |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region ä½åº |
| | | handleDelete(num) { |
| | | if (this.checkDataList.length != 1) { |
| | | this.$modal.msgError("è¯·éæ©ä¸è¡æ°æ®"); |
| | | } else { |
| | | // this.rowSel = []; |
| | | // for (var i = 0; i < this.checkDataList.length; i++) { |
| | | // this.rowSel.push(this.checkDataList[i].HItemID.toString()); |
| | | // } |
| | | |
| | | var HInterID = this.checkDataList[0].HItemID; |
| | | // å表æ¥è¯¢ |
| | | axios.get(this.baseURL + '/Gy_BarCodeBillList/DeleteGy_BarCodeBillList', { |
| | | params: { |
| | | "HInterID": HInterID, |
| | | "IsAudit": num, |
| | | "CurUserName": sessionStorage["HUserName"], |
| | | }, |
| | | }).then(response => { |
| | | let data1 = response.data |
| | | if (data1.count == 1) { |
| | | this.handleQuery(); |
| | | }else{ |
| | | this.$modal.msgError(data1.Message); |
| | | } |
| | | }).catch(error => { |
| | | this.$modal.msgError("æ¥å£è¯·æ±å¤±è´¥!"); |
| | | }); |
| | | } |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region å设置 |
| | | handleRowHide() { |
| | | this.rowHideShow = true |
| | | this.openRowHide = true |
| | | }, |
| | | rowSetClose(val) { |
| | | this.rowHideShow = false |
| | | this.tableShow = true |
| | | this.openRowHide = val |
| | | this.handleQuery() |
| | | }, |
| | | DisPlay_HideColumn(HModName, user, option, dataOption) { |
| | | this.totalNameList = [] |
| | | axios.get(this.baseURL + '/Xt_grdAlignment_WMES/grdAlignmentWMESList', { |
| | | params: { |
| | | "HModName": HModName, |
| | | "user": user, |
| | | }, |
| | | }).then(res => { |
| | | let data1 = res.data |
| | | if (data1.data.length != 0) { |
| | | var dataCol = [];//æ°æ®åºæ¥è¯¢åºçåæ°æ® |
| | | var newCols = [[]];//å¯¹åºæ°æ®åºå顺åºcol |
| | | newCols[0].push(option.cols[0][0]);//æ¾å
¥ç¬¬ä¸ä¸ªcheckbox |
| | | dataCol = data1.data[0].HGridString.split(','); |
| | | //åè®¾ç½®åæ°ä¸é¡µé¢åæ°æ¯å¦ä¸è´ |
| | | if (dataCol.length == option.cols[0].length - 1) { |
| | | //éå寻æ¾å设置对åºåæé¡ºåºæå
¥ |
| | | for (var j = 0; j < option.cols[0].length - 1; j++) { |
| | | for (var i = 0; i < option.cols[0].length - 1; i++) { |
| | | var dataCols = dataCol[j].split('|'); |
| | | //éæ©ä¸datacolsç¸åºåè¿è¡ä¿®æ¹ |
| | | if (option.cols[0][i + 1]["field"] == dataCols[5]) { |
| | | //éèå |
| | | if (dataCols[1] == 1) { |
| | | option.cols[0][i + 1]["hide"] = true; |
| | | } |
| | | //设置å宽 |
| | | if (dataCols[3] > 0) { |
| | | option.cols[0][i + 1]["width"] = dataCols[3]; |
| | | } |
| | | //设置å
容åä½å¤§å° |
| | | if (data1.data[0].HFontSize != 0) { |
| | | option.cols[0][i + 1]["style"] = "font-size:" + data1.data[0].HFontSize + "px;"; |
| | | } else { |
| | | option.cols[0][i + 1]["style"] = "font-size:100%"; |
| | | } |
| | | //æ¾ç¤ºå |
| | | if (dataCols[1] == 0 && this.titleData.indexOf(option.cols[0][i + 1]["title"]) == -1) { |
| | | option.cols[0][i + 1]["hide"] = false; |
| | | } |
| | | //ç»è®¡å |
| | | if (dataCols[6] == 1) { |
| | | option.cols[0][i + 1]["totalRow"] = true; |
| | | } else { |
| | | option.cols[0][i + 1]["totalRow"] = false; |
| | | } |
| | | //å使å¨ä½ç½®(å·¦ å±
ä¸ å³) |
| | | switch (dataCols[2]) { |
| | | case "L": |
| | | option.cols[0][i + 1]["align"] = "left"; |
| | | break; |
| | | case "M": |
| | | option.cols[0][i + 1]["align"] = "center"; |
| | | break; |
| | | case "R": |
| | | option.cols[0][i + 1]["align"] = "right"; |
| | | break; |
| | | } |
| | | //è®¾ç½®è¡¨æ ¼title屿§æ¾ç¤ºå«å |
| | | if (dataCols[4] != null && dataCols[4] != "") { |
| | | option.cols[0][i + 1]["title"] = dataCols[4]; |
| | | } |
| | | newCols[0].push(option.cols[0][i + 1]); |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | //éå循ç¯å夿坹åºåæ°æ¯å¦ä¸è´ |
| | | if (dataCol.length == newCols[0].length - 1) { |
| | | option.cols = newCols; |
| | | //åæ¶å»ç»å |
| | | for (var i = 1; i < option.cols[0].length - 1; i++) { |
| | | if (option.cols[0][i + 1]["fixed"] != null) { |
| | | option.cols[0][i + 1]["fixed"] = null; |
| | | } |
| | | else { |
| | | break; |
| | | } |
| | | } |
| | | //å»ç»å |
| | | if (data1.data[0].HFixCols != 0) { |
| | | for (var i = 0; i < data1.data[0].HFixCols; i++) { |
| | | if (dataOption.cols[0].indexOf(option.cols[0][i + 1]["title"]) != -1) { |
| | | data1.data[0].HFixCols += 1; |
| | | } |
| | | |
| | | option.cols[0][i + 1]["fixed"] = "left"; |
| | | } |
| | | } |
| | | //设置åæåº |
| | | for (var i = 1; i < option.cols[0].length; i++) { |
| | | if (data1.data[0].HSortFlag == "æ¯") { |
| | | option.cols[0][i]["sort"] = true; |
| | | } |
| | | else { |
| | | option.cols[0][i]["sort"] = false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | this.btList = option.cols[0] |
| | | this.btList.map(item => { |
| | | if (!item.hide) { |
| | | this.totalNameList.push(item) |
| | | } |
| | | }) |
| | | if (data1.data[0].HPageSize == 0) { |
| | | this.pageSize = 50 |
| | | } else { |
| | | this.pageSize = data1.data[0].HPageSize |
| | | } |
| | | this.tableData = option.data |
| | | this.tableShow = true |
| | | this.loading = false |
| | | } else { |
| | | this.btList = dataOption.cols[0] |
| | | this.btList.map(item => { |
| | | if (!item.hide) { |
| | | this.totalNameList.push(item) |
| | | } |
| | | }) |
| | | this.tableData = dataOption.data |
| | | this.tableShow = true |
| | | this.loading = false |
| | | } |
| | | }).catch(error => { |
| | | this.$modal.msgError("æ¥å£è¯·æ±å¤±è´¥!"); |
| | | }); |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region æé®è®¾ç½® |
| | | handleBtnHide() { |
| | | this.btnHideShow = true |
| | | this.openBtnHide = true |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region å¯¼åº |
| | | handleExport() { |
| | | const ws = this.$XLSX.utils.json_to_sheet(this.tyResList); // å°æ°æ®è½¬æ¢ä¸ºå·¥ä½è¡¨ |
| | | const wb = this.$XLSX.utils.book_new(); // å建ä¸ä¸ªæ°çå·¥ä½ç°¿ |
| | | this.$XLSX.utils.book_append_sheet(wb, ws, "Sheet1"); // å°å·¥ä½è¡¨æ·»å å°å·¥ä½ç°¿ä¸ï¼å¹¶å½å为"Sheet1" |
| | | this.$XLSX.writeFile(wb, `Gy_BarCodeBillList_${new Date().getTime()}.xlsx`); // å¯¼åºæä»¶ |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region æå° |
| | | get_PrintReport() { |
| | | if (this.checkDataList.length == 0) { |
| | | this.$modal.msgError("è¯·éæ©æ°æ®"); |
| | | } else { |
| | | this.rowSel = []; |
| | | for (var i = 0; i < this.checkDataList.length; i++) { |
| | | this.rowSel.push(this.checkDataList[i].HItemID.toString()); |
| | | } |
| | | this.printListShow = true; |
| | | this.openPrintList = true; |
| | | } |
| | | }, |
| | | //#endregion |
| | | |
| | | //#region éåº |
| | | close() { |
| | | // this.reset() |
| | | this.tableShow = true |
| | | this.openEdit = false |
| | | this.editShow = false |
| | | this.handleQuery() |
| | | }, |
| | | //#endregion |
| | | } |
| | | }; |
| | | </script> |
| | | <style> |
| | | .xsckdBox .el-date-editor.el-input { |
| | | width: 100%; |
| | | } |
| | | </style> |