TypeScript rs-query-service.rsQuery函数代码示例

	getFieldFunctions(field, functionPurpose) {
		if (!angular.isObject(field))
			throw 'Field should be object';
		let parameters: any = null;
		const typeGroup = this.getCurrentTypeGroup(field);
		if (functionPurpose === 'subtotal') {
			// available functions for subtotals
			parameters = {
				'cmd': 'GetOptionsByPath',
				'p': 'FunctionList',
				'type': field.sqlType,
				'typeGroup': typeGroup,
				'includeBlank': 'true',
				'includeGroupBy': 'false',
				'forSubtotals': 'true',
				'extraFunction': 'false',
				'forDundasMap': 'false',
				'onlyNumericResults': 'false',
				'resultType': 'json'
			};
		} else if (functionPurpose === 'field') {
			// available functions for column
			parameters = {
				'cmd': 'GetOptionsByPath',
				'p': 'FunctionList',
				'type': field.sqlType,
				'typeGroup': typeGroup,
				'includeBlank': 'true',
				'includeGroupBy': 'true',
				'forSubtotals': 'false',
				'extraFunction': 'false',
				'forDundasMap': 'false',
				'onlyNumericResults': 'false',
				'resultType': 'json'
			};
		} else if (functionPurpose === 'pivotField') {
			parameters = {
				'cmd': 'GetOptionsByPath',
				'p': 'FunctionList',
				'type': field.sqlType,
				'typeGroup': typeGroup,
				'includeBlank': 'true',
				'includeGroupBy': 'true',
				'forSubtotals': 'false',
				'extraFunction': 'true',
				'forDundasMap': 'false',
				'onlyNumericResults': 'false',
				'resultType': 'json'
			};
		}
		return this.$izendaRsQueryService.rsQuery(parameters, {
			dataType: 'json',
			cache: true
		}, {
				handler: fieldParam => `Failed to get function list info for field ${fieldParam.sysname}`,
				params: [field]
			});
	}

	getVgStyles() {
		return this.$izendaRsQueryService.rsQuery({
			'cmd': 'GetOptionsByPath',
			'p': 'VgStyleList',
			'resultType': 'json'
		}, {
				dataType: 'json',
				cache: true
			}, {
				handler: () => 'Failed to get available visual group styles.',
				params: []
			});
	}

	getSubreports() {
		return this.$izendaRsQueryService.rsQuery({
			'cmd': 'GetOptionsByPath',
			'p': 'SubreportsList',
			'resultType': 'json'
		}, {
				dataType: 'json',
				cache: true
			}, {
				handler: () => 'Failed to get subreports.',
				params: []
			});
	}

	getExpressionTypes() {
		return this.$izendaRsQueryService.rsQuery({
			'cmd': 'GetOptionsByPath',
			'p': 'ExpressionTypeList',
			'resultType': 'json'
		}, {
				dataType: 'json',
				cache: true
			}, {
				handler: () => 'Failed to get expression types.',
				params: []
			});
	}

	getDrillDownStyles() {
		return this.$izendaRsQueryService.rsQuery({
			'cmd': 'GetOptionsByPath',
			'p': 'DrillDownStyleList',
			'resultType': 'json'
		}, {
				dataType: 'json',
				cache: true
			}, {
				handler: () => 'Failed to get drilldown styles.',
				params: []
			});
	}

	getPeriodList() {
		return this.$izendaRsQueryService.rsQuery({
			'cmd': 'GetOptionsByPath',
			'p': 'PeriodList',
			'resultType': 'json'
		}, {
				dataType: 'json',
				cache: true
			}, {
				handler: () => 'Failed to get period list.',
				params: []
			});
	};

	getExistentPopupValuesList(field, table) {
		return this.$izendaRsQueryService.rsQuery({
			'cmd': 'GetOptionsByPath',
			'p': 'ExistentPopupValuesList',
			'columnName': field.sysname,
			'tbl0': table.sysname,
			'ta0': '',
			'resultType': 'json'
		}, {
				dataType: 'json',
				cache: true
			}, {
				handler: () => 'Failed to get custom popups styles.',
				params: []
			});
	};

	getFieldFormats(field, dataTypeGroup?) {
		if (!angular.isObject(field))
			throw 'Field should be object';
		const typeGroup = this.getCurrentTypeGroup(field, dataTypeGroup);
		return this.$izendaRsQueryService.rsQuery({
			'cmd': 'GetOptionsByPath',
			'p': 'FormatList',
			'typeGroup': typeGroup,
			'resultType': 'json'
		}, {
				dataType: 'json',
				cache: true
			}, {
				handler: fieldParam => `Failed to get format list info for field ${fieldParam.sysname}`,
				params: [field]
			});
	}

	getFieldOperatorList(field, tablesString, dataTypeGroup?) {
		if (!angular.isObject(field))
			throw 'Field should be object.';
		const typeGroup = this.getCurrentTypeGroup(field, dataTypeGroup);
		return this.$izendaRsQueryService.rsQuery({
			'cmd': 'GetOptionsByPath',
			'p': 'OperatorList',
			'typeGroup': typeGroup,
			'tables': tablesString,
			'colFullName': field.sysname,
			'resultType': 'json'
		}, {
				dataType: 'json',
				cache: true
			}, {
				handler: fieldParam => `Failed to get operator list for field ${fieldParam.sysname}`,
				params: [field]
			});
	}

	getFilterFormats(filter) {
		if (!angular.isObject(filter) || !angular.isObject(filter.field))
			throw 'filter and filter.field should be objects.';
		const typeGroup = this.getCurrentTypeGroup(filter.field);
		return this.$izendaRsQueryService.rsQuery({
			'cmd': 'GetOptionsByPath',
			'p': 'FormatList',
			'typeGroup': typeGroup,
			'onlySimple': 'true',
			'forceSimple': 'true',
			'resultType': 'json'
		}, {
				dataType: 'json',
				cache: true
			}, {
				handler: filterParam => `Failed to get format list info for filter ${filterParam.field.sysname}`,
				params: [filter]
			});
	}