| | |
| | | EntityList, |
| | | iSYS_ROLE_PROD, |
| | | pParams, |
| | | ImportEntityValidate, |
| | | ImportInput, |
| | | } from './model/systemModel'; |
| | | import { defHttp } from '/@/utils/http/axios'; |
| | | import { isArray, isNullOrEmpty, isTimeViaRegExp8601 } from '/@/utils/is'; |
| | |
| | | EntityPageList = '/Base/QueryCustomPage', |
| | | IsAccountExist = '/Base/IsExist', |
| | | AddAfterDelete = '/Base/AddAfterDelete', |
| | | ImportExcel = '/Base/ImportExcel', |
| | | BaseValidateTableImport = '/Base/ValidateTableImport', |
| | | setRoleStatus = '/system/setRoleStatus', |
| | | MenuList = '/SYS/getMenuListAll', |
| | | SaveMenu = '/SYS/SaveMenu', |
| | |
| | | } |
| | | } 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' |
| | |
| | | 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; |
| | | } |