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