From 8f5009a3d57821c2c97690b8419e428967b5e981 Mon Sep 17 00:00:00 2001 From: Ben Lin <maobin001@msn.com> Date: 星期一, 03 六月 2024 22:48:41 +0800 Subject: [PATCH] 低代码更新 --- src/api/tigerapi/system.ts | 184 ++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 184 insertions(+), 0 deletions(-) diff --git a/src/api/tigerapi/system.ts b/src/api/tigerapi/system.ts index e52da83..3ead966 100644 --- a/src/api/tigerapi/system.ts +++ b/src/api/tigerapi/system.ts @@ -1,4 +1,5 @@ import { UserConfigFn } from 'vite'; +import { useGlobSetting } from '/@/hooks/setting'; import { buildUUID } from '../../utils/uuid'; import { DateFormat } from '../../utils/dataformat'; import { ApiAction, ApiActionJob, ApiActionPage } from '../model/baseModel'; @@ -25,8 +26,11 @@ LoginLogPageListGetResultModel, iSYS_ROLE_ORG, iSYS_ROLE_WH, + EntityParams, + EntityList, } from './model/systemModel'; import { defHttp } from '/@/utils/http/axios'; +import { isNullOrEmpty, isTimeType } from '/@/utils/is'; export enum Api { QueryUrl = '/Base/Query', @@ -72,7 +76,13 @@ GetStatusRestored = '/WMS/ProductInput/StatusRestored', // 鎵归噺鏇存柊鍐呭 GetUpdateTime = '/MaterialInfo/UpdateTime', + //瀵煎叆 + ValidateTableImport = '/SMT/ValidateTableImport', + SaveValidateTableImport = '/SMT/SaveValidateTableImport', + GetEntityNameList = '/System/Entitys/Get', } + +const globSetting = useGlobSetting(); /** * 鐢熸垚apiaction,甯﹀垎椤� @@ -625,3 +635,177 @@ }; return model; } + +/* + *閫氱敤鏂规硶======================================================== + */ + +export const GetEnum = async (enumName: { name: string }) => { + const usParams = genAction(enumName.name, ''); + return await defHttp.post( + { url: Api.urlQueryEnum, params: usParams }, + { + errorMessageMode: 'none', + isTransformResponse: false, + //apiUrl: globSetting.taskApiUrl + }, + ); +}; + +/* 閫氱敤鏌ヨ鍒嗛〉 */ +export async function getListByPage<T>(params: T) { + const Keys = Object.getOwnPropertyNames(params); + let sqlcmd = '1=1 '; + let order = ''; + for (const k in Keys) { + console.log(`${k}:${Keys[k]}`); + if ( + !isNullOrEmpty(params[Keys[k]]) && + Keys[k] != 'page' && + Keys[k] != 'pageSize' && + Keys[k] != 'TABLE_NAME' && + Keys[k] != 'order' && + Keys[k] != 'field' && + Keys[k] != '0' + ) { + if (!isNullOrEmpty(params[Keys[k]].length) && isTimeType(params[Keys[k]][0])) { + sqlcmd += ` And ${Keys[k]} > '${params[Keys[k]][0]}'`; + sqlcmd += ` And ${Keys[k]} < '${params[Keys[k]][1]}'`; + } else { + sqlcmd += `And ${Keys[k]} like '%${params[Keys[k]]}%'`; + } + } + } + if (!isNullOrEmpty(params['order'])) { + order = params['order'] == 'descend' ? params['field'] + ' desc' : params['field']; + } + const rParams = genAction(params['TABLE_NAME'], { + QueryAble_T: '', + where: sqlcmd, + order: order, + page: { + pageAble_T: 'string', + draw: 1, + pageIndex: params['page'], + pageSize: params['pageSize'], + }, + }); + return getListByPageAsync(rParams); +} +async function getListByPageAsync(params: any) { + const data = await defHttp.post( + { url: Api.QueryUrl, params }, + { + isTransformResponse: false, + }, + ); + const model = { + items: data.Data.page.data, + total: data.Data.page.totals, + }; + return model; +} + +export async function SaveEntity<T>(params: T, isUpdate: boolean, entityName: string) { + let data; + if (isUpdate) { + data = await defHttp.post( + { url: Api.UpdateEntity, params: genAction(entityName, params) }, + { + errorMessageMode: 'none', + isTransformResponse: false, + }, + ); + } else { + params.ID = buildUUID(); //鐢熸垚GUID + data = await defHttp.post( + { url: Api.AddEntity, params: genAction(entityName, params) }, + { + errorMessageMode: 'none', + isTransformResponse: false, + }, + ); + } + return data; +} + +export async function DeleteEntity<T>(params: T, entityName: string) { + const usParams = genAction(entityName, [params]); + return await defHttp.post( + { url: Api.DeleteList, params: usParams }, + { + errorMessageMode: 'none', + isTransformResponse: false, + }, + ); +} + +//鑾峰彇鏈嶅姟鍣↗son鏂囦欢杩斿洖Json鏁版嵁 +export async function fetchJson(url: string) { + try { + const response = await fetch(url); + return await response.json(); + } catch (error) { + console.error('Error fetching columns:', error); + } +} + +// 娉涘瀷鍑芥暟锛岃幏鍙栫被鐨勫悕绉� +export function getClassName<T>(ctor: new () => T): string { + return ctor.name; +} + +export const getEntityList = (params?: EntityParams) => + defHttp.get<EntityList>( + { url: Api.GetEntityNameList, params }, + { + isTransformResponse: false, + apiUrl: globSetting.sysApiUrl, + }, + ); + +export async function getEntityNameList(params?: EntityParams) { + const data = await defHttp.get<EntityList>( + { url: Api.GetEntityNameList, params }, + { + isTransformResponse: false, + apiUrl: globSetting.sysApiUrl, + }, + ); + const model = { + items: data.Data, + total: data.Total, + }; + return model; +} + +export async function getEntityPropertieList(params?: EntityParams) { + const data = await defHttp.get<EntityList>( + { url: Api.GetEntityNameList, params }, + { + isTransformResponse: false, + apiUrl: globSetting.sysApiUrl, + }, + ); + const model = { + items: data.Data.filter((x) => x.Name == params?.StartWith)[0].Properties, + total: data.Total, + }; + return model; +} + +/* 閫氱敤鑾峰彇瀹炰綋璁板綍 */ +export const getEntity = async (params: { sqlcmd: string; entityName: string }) => { + const usParams = genAction(params.entityName, { + QueryAble_T: '', + where: params.sqlcmd, + order: '', + }); + return await defHttp.post( + { url: Api.QueryUrl, params: usParams }, + { + errorMessageMode: 'none', + isTransformResponse: false, + }, + ); +}; -- Gitblit v1.9.3