| | |
| | | EntityParams, |
| | | EntityList, |
| | | iSYS_ROLE_PROD, |
| | | pParams, |
| | | } from './model/systemModel'; |
| | | import { defHttp } from '/@/utils/http/axios'; |
| | | import { isArray, isNullOrEmpty, isTimeViaRegExp8601 } from '/@/utils/is'; |
| | | import { isNumber } from 'xe-utils'; |
| | | |
| | | export enum Api { |
| | | QueryUrl = '/Base/Query', |
| | |
| | | MenuList = '/SYS/getMenuListAll', |
| | | SaveMenu = '/SYS/SaveMenu', |
| | | SaveRole = '/SYS/SaveRole', |
| | | getSysParam = '/SYS/getSysParam', |
| | | AddEntity = '/Base/Add', |
| | | AddListEntity = '/Base/AddList', |
| | | UpdateEntity = '/Base/Update', |
| | |
| | | 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'], |
| | | const rParams = genAction( |
| | | params['TABLE_NAME'], |
| | | { |
| | | QueryAble_T: '', |
| | | where: sqlcmd, |
| | | order: order, |
| | | page: { |
| | | pageAble_T: 'string', |
| | | draw: 1, |
| | | pageIndex: params['page'], |
| | | pageSize: params['pageSize'], |
| | | }, |
| | | }, |
| | | }); |
| | | params['option'], |
| | | ); |
| | | return getListByPageAsync(rParams); |
| | | } |
| | | async function getListByPageAsync(params: any) { |
| | |
| | | Keys[k] != 'TABLE_NAME' && |
| | | Keys[k] != 'order' && |
| | | Keys[k] != 'field' && |
| | | Keys[k] != 'option' && |
| | | Keys[k] != '0' && |
| | | !Keys[k].toString().endsWith('PSelect_0') |
| | | ) { |
| | | if (!isNullOrEmpty(params[Keys[k]].length) && isTimeViaRegExp8601(params[Keys[k]][0])) { |
| | | sqlcmd += ` And ${Keys[k]} > '${params[Keys[k]][0]}'`; |
| | | sqlcmd += ` And ${Keys[k]} < '${params[Keys[k]][1]}'`; |
| | | } else if (isNumber(params[Keys[k]])) { |
| | | sqlcmd += `And ${Keys[k]} = ${params[Keys[k]]}`; |
| | | } else { |
| | | sqlcmd += `And ${Keys[k]} like '%${params[Keys[k]]}%'`; |
| | | } |
| | |
| | | |
| | | export async function SaveEntity<T>(params: T, isUpdate: boolean, entityName: string, ...args) { |
| | | let data; |
| | | /* 针对模板地址做替换,特殊处理 */ |
| | | // if(params['TEMP_PATH']){ |
| | | // params['TEMP_PATH'] = params['TEMP_PATH'].toString().replace('/','//'); |
| | | // } |
| | | if (isUpdate) { |
| | | data = await defHttp.post( |
| | | { url: Api.UpdateEntity, params: genAction(entityName, params) }, |
| | |
| | | check.Message = '记录已经存在,不能新增!'; |
| | | return check; |
| | | } |
| | | params.ID = buildUUID(); //生成GUID |
| | | params['ID'] = args[1] == true ? params['ID'] : buildUUID(); //生成GUID |
| | | data = await defHttp.post( |
| | | { url: Api.AddEntity, params: genAction(entityName, params) }, |
| | | { |
| | |
| | | } |
| | | |
| | | /* 通用获取实体记录 */ |
| | | export const getEntity = async (params: { sqlcmd: string; entityName: string, order: string }) => { |
| | | export const getEntity = async (params: { sqlcmd: string; entityName: string; order: string }) => { |
| | | const usParams = genAction(params.entityName, { |
| | | QueryAble_T: '', |
| | | where: params.sqlcmd, |
| | |
| | | } |
| | | return values; |
| | | } |
| | | |
| | | /** |
| | | * @description: 获取参数 |
| | | * @param {pParams} params |
| | | * @return {*} |
| | | */ |
| | | export const getSysParam = (params?: pParams) => |
| | | defHttp.get<ApiAction<treeParamsListItem[]>>( |
| | | { url: Api.getSysParam, params }, |
| | | { |
| | | isTransformResponse: false, |
| | | }, |
| | | ); |