From 8736042f4116942b2253d6eb4e782645125c40e2 Mon Sep 17 00:00:00 2001
From: Ben Lin <maobin001@msn.com>
Date: 星期一, 24 二月 2025 20:13:11 +0800
Subject: [PATCH] 低代码更新

---
 src/api/tigerapi/system.ts |   40 ++++++++++++++++++++++++++++++++++++++++
 1 files changed, 40 insertions(+), 0 deletions(-)

diff --git a/src/api/tigerapi/system.ts b/src/api/tigerapi/system.ts
index b419524..6ba9e68 100644
--- a/src/api/tigerapi/system.ts
+++ b/src/api/tigerapi/system.ts
@@ -29,6 +29,8 @@
   EntityList,
   iSYS_ROLE_PROD,
   pParams,
+  ImportEntityValidate,
+  ImportInput,
 } from './model/systemModel';
 import { defHttp } from '/@/utils/http/axios';
 import { isArray, isNullOrEmpty, isTimeViaRegExp8601 } from '/@/utils/is';
@@ -41,6 +43,8 @@
   EntityPageList = '/Base/QueryCustomPage',
   IsAccountExist = '/Base/IsExist',
   AddAfterDelete = '/Base/AddAfterDelete',
+  ImportExcel = '/Base/ImportExcel',
+  BaseValidateTableImport = '/Base/ValidateTableImport',
   setRoleStatus = '/system/setRoleStatus',
   MenuList = '/SYS/getMenuListAll',
   SaveMenu = '/SYS/SaveMenu',
@@ -823,6 +827,8 @@
         }
       } else if (isNumber(params[Keys[k]])) {
         sqlcmd += `And ${Keys[k]} = ${params[Keys[k]]}`;
+      } else if(Keys[k].toString().startsWith('IFEMPTY_')){
+        sqlcmd +=params[Keys[k]]=='Y'? `And (${Keys[k].split('IFEMPTY_')[1]} != '' OR ${Keys[k].split('IFEMPTY_')[1]} is not NULL)`: `And (${Keys[k].split('IFEMPTY_')[1]} = '' OR ${Keys[k].split('IFEMPTY_')[1]} is NULL)`;
       } else {
         sqlcmd +=
           params['nolike'] == 'Y'
@@ -1028,3 +1034,37 @@
       isTransformResponse: false,
     },
   );
+
+  /**
+   * @desc 瀵煎叆Excel
+   */
+export async function ImportExcel(entityName: string, items: ImportInput) {
+  const data = await defHttp.post(
+    {
+      url: Api.ImportExcel,
+      params: genAction(entityName, items),
+    },
+    {
+      errorMessageMode: 'none',
+      isTransformResponse: false,
+    },
+  );
+  return data;
+}
+
+/**
+ * @desc 瀵煎叆Excel
+ */
+export async function ValidateTableImport(entityName: string, items: ImportEntityValidate) {
+const data = await defHttp.post(
+  {
+    url: Api.BaseValidateTableImport,
+    params: genAction(entityName, items),
+  },
+  {
+    errorMessageMode: 'none',
+    isTransformResponse: false,
+  },
+);
+return data;
+}

--
Gitblit v1.9.3