From f9eb1a419834f97a3ab0124b132de4f977b1973b Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期六, 28 十二月 2024 21:00:56 +0800
Subject: [PATCH] 通用导入Excel更新
---
src/views/tigerprojects/system/lowcode/entityts/BIZ_MES_WO.ts | 114 ++++++++++++++++++++++++++++++++++++++++++++++++++++-----
1 files changed, 104 insertions(+), 10 deletions(-)
diff --git a/src/views/tigerprojects/system/lowcode/entityts/BIZ_MES_WO.ts b/src/views/tigerprojects/system/lowcode/entityts/BIZ_MES_WO.ts
index 85c5dc0..a7656bb 100644
--- a/src/views/tigerprojects/system/lowcode/entityts/BIZ_MES_WO.ts
+++ b/src/views/tigerprojects/system/lowcode/entityts/BIZ_MES_WO.ts
@@ -22,6 +22,7 @@
import { useForm } from '/@/components/Form/index';
import { cloneDeep } from 'lodash-es';
import { useProdRouteStore } from '/@/store/modules/prodRoute';
+import { Tag, Tooltip } from 'ant-design-vue';
const { t } = useI18n();
const { createErrorModal } = useMessage();
@@ -43,10 +44,86 @@
* @description: 鑾峰彇鏂板鎸夐挳鐨勮涓�
* @return {*}
*/
- CreateAction: (type: string) => {
- return {
- action: 'drawer', //drawer(鎵撳紑宸︿晶鎶藉眽妗�) | go(璺宠浆鍒版柊鐨勯〉闈�)
- };
+ CreateAction: (type: string, fnName: string) => {
+ let action = {} as any;
+ switch (fnName) {
+ case 'ImportExcel':
+ action = {
+ action: 'importModal', //drawer(鎵撳紑宸︿晶鎶藉眽妗�) | go(璺宠浆鍒版柊鐨勯〉闈�) | modal(鎵撳紑妯℃�佺獥鍙�) | importModal(鎵撳紑瀵煎叆妯℃�佺獥鍙�)
+ params: {
+ tmpHeader: ['宸ュ崟鍙�', '璁″垝鏃ユ湡', '璁″垝鏁伴噺'], /* 涓嬭浇妯℃澘鐨勬爣棰樺瓧娈� */
+ filename: '宸ュ崟璁″垝妯℃澘.xlsx', /* 涓嬭浇妯℃澘鐨勬枃浠跺悕 */
+ entityName: 'BIZ_MES_WO_BATCH', /* 瀵煎叆琛ㄧ殑琛ㄥ悕 */
+ checkJson: ['ORDER_NO', 'PLAN_DATE', 'PLAN_QTY'], /* 瀵煎叆琛ㄩ渶瑕佹鏌ョ殑瀛楁鍒楄〃 */
+ where: ['ORDER_NO'], /* 瀵煎叆琛ㄩ渶瑕佹煡璇㈢殑瀛楁鍒楄〃 */
+ typeFullName:'Tiger.IBusiness.MES.IImportWoPlan,Tiger.IBusiness.MES', /* 瀵煎叆鐨勬柟娉曞叏鍚嶏紝閫氱敤瀵煎叆鐢ㄨ繖涓細Tiger.IBusiness.ICommonImportExcel,Tiger.IBusiness */
+ baseColumns: [ /* 瀵煎叆鏃剁晫闈㈡樉绀烘暟鎹殑瀛楁 */
+ {
+ title: '宸ュ崟鍙�',
+ dataIndex: 'ORDER_NO',
+ ifShow: true,
+ width: 180,
+ },
+ {
+ title: '宸ュ崟鎵规鍙�',
+ dataIndex: 'BATCH_NO',
+ ifShow: true,
+ width: 180,
+ // customRender: ({ record }) => {
+ // record.BATCH_NO = record.ORDER_NO+'-01'
+ // return record.BATCH_NO
+ // },
+ },
+ {
+ title: '璁″垝鏃ユ湡',
+ dataIndex: 'PLAN_DATE',
+ ifShow: true,
+ width: 180,
+ },
+ {
+ title: '璁″垝鏁伴噺',
+ dataIndex: 'PLAN_QTY',
+ ifShow: true,
+ width: 180,
+ },
+ {
+ title: '澶勭悊鏂瑰紡',
+ dataIndex: 'VALIDATION_TYPE',
+ ifShow: true,
+ width: 180,
+ customRender: ({ record }) => {
+ const status = record.VALIDATION_TYPE;
+ var text = '';
+ var color = 'green';
+ if (status == '鏁版嵁寮傚父') {
+ color = 'red';
+ text = status;
+ } else if (status == '淇敼') {
+ color = 'yellow';
+ text = status;
+ } else {
+ text = status;
+ }
+ return h(Tooltip, { title: text }, () => h(Tag, { color: color }, () => text));
+ },
+ },
+ {
+ title: '澶勭悊缁撴灉',
+ dataIndex: 'VALIDATION_RESULT',
+ ifShow: true,
+ width: 180,
+ },
+ ],
+ },
+ };
+ break;
+ default:
+ action = {
+ action: 'drawer', //drawer(鎵撳紑宸︿晶鎶藉眽妗�) | go(璺宠浆鍒版柊鐨勯〉闈�) | modal(鎵撳紑妯℃�佺獥鍙�)
+ };
+ break;
+ }
+ return action;
},
/**
* @description: 鎿嶄綔瀛楁鑷畾涔夋寜閽�
@@ -262,6 +339,16 @@
break;
}
},
+ /**
+ * @description: 鑾峰彇鏍囬淇℃伅
+ * @param {string} type
+ * @return {*}
+ */
+ GetTitle: () => {
+ return {
+ importTitle: '宸ュ崟璁″垝瀵煎叆', /* 鎵撳紑妯℃�佺獥鍙ｆ樉绀虹殑鏍囬 */
+ };
+ },
};
/* 浠ヤ笅鏄唴閮ㄦ柟娉曪紝涓峞xport锛屼緵涓婇潰鐨勬柟娉曡皟鐢� */
@@ -312,7 +399,7 @@
try {
const form = param.values['forminfo'];
const wo = param.values['mValues'];
- wo.STATUS = wo.STATUS == 3?wo.STATUS: 2;
+ wo.STATUS = wo.STATUS == 3 ? wo.STATUS : 2;
let input: SaveWoBatchInput = {
Wo: wo,
WoBatch: {
@@ -348,7 +435,7 @@
ACT_END_TIME: wo.ACT_END_TIME,
BATCH_NO: '',
},
- IfToCust: form.IfToCust
+ IfToCust: form.IfToCust,
};
SaveMesBatchWo(input).then((action) => {
resolve(action);
@@ -402,15 +489,22 @@
Name: 'WoRouteBinding',
CODE: params['record'].ORDER_NO,
Title: `宸ュ崟[${params['record'].ORDER_NO}]宸ヨ壓缁戝畾`,
- colSlots: params['colSlots'].value, /* 琛ㄦ牸鍐呯殑鏌ヨ琛ㄥ崟瀛楁鐨勬彃妲藉垪琛紝涓�鑸敤浜庡脊鍑洪�夋嫨妗嗘寜閽� */
- crudColSlots: {BAS_PKG_DTL:['BAS_LABEL_TEMP1add'], ItemCode: ['BAS_CODE_RULE1add']} /* 澧炲垹鏀硅〃鍗曞瓧娈电殑鎻掓Ы鍒楄〃锛屼竴鑸敤浜庡脊鍑洪�夋嫨妗嗘寜閽� */,
- OtherTableName: ['BAS_PKG_DTL', 'ItemCode'], /* 鑷畾涔夋樉绀哄垪琛ㄧ殑琛ㄥ悕锛岃窡涓婇潰澧炲垹鏀圭殑琛ㄥ悕涓�鑷达紝鏈夊涓氨鏀惧垪琛ㄤ腑 */
+ colSlots:
+ params['colSlots'].value /* 琛ㄦ牸鍐呯殑鏌ヨ琛ㄥ崟瀛楁鐨勬彃妲藉垪琛紝涓�鑸敤浜庡脊鍑洪�夋嫨妗嗘寜閽� */,
+ crudColSlots: {
+ BAS_PKG_DTL: ['BAS_LABEL_TEMP1add'],
+ ItemCode: ['BAS_CODE_RULE1add'],
+ } /* 澧炲垹鏀硅〃鍗曞瓧娈电殑鎻掓Ы鍒楄〃锛屼竴鑸敤浜庡脊鍑洪�夋嫨妗嗘寜閽� */,
+ OtherTableName: [
+ 'BAS_PKG_DTL',
+ 'ItemCode',
+ ] /* 鑷畾涔夋樉绀哄垪琛ㄧ殑琛ㄥ悕锛岃窡涓婇潰澧炲垹鏀圭殑琛ㄥ悕涓�鑷达紝鏈夊涓氨鏀惧垪琛ㄤ腑 */,
dense: true,
pageTitle: `宸ュ崟宸ヨ壓缁戝畾`,
pageContent: `杩欓噷鏄鐞嗗伐鍗曠殑宸ヨ壓缁戝畾锛屼竴涓伐鍗曞彲浠ョ粦瀹氫竴涓伐鑹鸿矾绾匡紝骞跺彲浠ヤ繚瀛樹负瀹㈡埛涓撶敤鐨勫伐鑹鸿矾绾縛,
SessionName: 'WoRouteBinding_update',
ifSave: false,
- rotType: 'Wo'
+ rotType: 'Wo',
};
// 灏嗗璞¤浆鎹负JSON瀛楃涓插苟淇濆瓨鍒皊essionStorage
sessionStorage.removeItem(`${id.SessionName}_params`);
--
Gitblit v1.9.3