需要一个新功能云表模板在MSSQL数据库中字段的含义对照表

新人帖

2017-6-27 15:45:26

67273

场景：
由于公司有多个业务系统，为实现数据共享，因此需要开放一些云表平台的数据给其他平台的业务系统进行数据共享。
共享方式；授权 ”自定义的数据库视图“给外部程序。

问题：
由于云表模板对应的数据库表，在数据库中字段全部是，“f1-f2....”等等数字段没有实际的意义，无法和模板中的数据字段关联起来，自定义视图不能实习。
需求：
希望官方给出模板和数据库字段对照表。或则别的解决方式。

+10

分享至：微博微信 QQ空间

3 条回帖

mfkpie8云粉2017-6-28 09:29:45

沙发

在lato_template_svn2中m_templateJson中有字段对照
例子：
{
"allowManualLock": true,
"attachmentTableCaption": "附件",
"barBtnIndex": -1,
"caption": "",
"catalogCaption": "基础档案",
"catalogId": "60",
"classInfo": {
      "name": "表单定义",
      "version": 1
},
"classTemplateName": "表单定义",
"clientFormConfig": {
      "fieldControlList": []
},
"creatorViewClassId": "",
"dataSourceName": "",
"dataTableList": [],
"enabled": false,
"formId": "339",
"formListConfig": {
      "caption": "",
      "isDontShowZero": false,
      "isShowDetail": false,
      "pageConfig": {
         "defaultPageSize": 50,
         "isRowCount": 200,
         "isUseRowIndex": true
      }
},
"formListViewClassId": "formListGridView",
"formStyle": "page",
"formViewClassId": "rangeFormView",
"functions": {
      "nameSeed": 1
},
"hasBizFormula": false,
"imageIndex": 55,
"isDefault": false,
"isNonpersistent": false,
"isOnlyDeveloperVisible": false,
"isShowInCatalog": false,
"isSupportMultiDevice": false,
"isUseAttachment": false,
"latoVersion": 0,
"lockCondition": "",
"privilegeList": [],
"seq": 0,
"styleFileId": "339",
"styleFileType": "ejun",
"tableMapList": [
      {
         "fieldMapList": [
            {
                  "caption": "车型",
                  "col": 8,
                  "dataSpec": null,
                  "defValue": "",
                  "editable": true,
                  "fieldKind": "dataField",
                  "formatString": "@",
                  "friendlyName": "",
                  "gridName": "sheet1",
                  "isMergeSameValue": false,
                  "isPrimaryKey": false,
                  "isTemp": false,
                  "mustFill": false,
                  "name": "f2",
                  "readOnly": false,
                  "row": 4,
                  "type": 0,
                  "visible": true,
                  "width": 75
            },
            {
                  "caption": "代号",
                  "col": 3,
                  "dataSpec": null,
                  "defValue": "",
                  "editable": true,
                  "fieldKind": "dataField",
                  "formatString": "@",
                  "friendlyName": "",
                  "gridName": "sheet1",
                  "isMergeSameValue": false,
                  "isPrimaryKey": true,
                  "isTemp": false,
                  "mustFill": false,
                  "name": "f3",
                  "readOnly": false,
                  "row": 4,
                  "type": 0,
                  "visible": true,
                  "width": 75
            }
         ],
         "fillDirection": 0,
         "formCodeFieldCaption": "",
         "gridName": "",
         "gridRange": "",
         "isAllowExtendData": true,
         "isAllowHoriExtendData": false,
         "isCreateDB": true,
         "name": "tableDefine0",
         "nameSeed": 3,
         "sortFieldList": [],
         "tableCaption": "车型",
         "tableName": "t10001_C2301",
         "version": 1,
         "formCodeFieldName": ""
      }
],
"tableMapNameSeed": 0,
"templateCode": "车型",
"templateName": "车型",
"templateUrl": "template",
"toolBar": "",
"type": "form",
"url": "new",
"workflowDefine": {
      "actionType": "review",
      "completeButtonCaption": "",
      "enable": true,
      "isLockFormAfterFinish": false,
      "isSendEmail": false,
      "isSendSMS": false,
      "startButtonCaption": "",
      "summaryExpress": "",
      "taskList": {
         "itemList": [],
         "stateField": ""
      },
      "type": "simple",
      "user": {
         "srcObject": {
            "filter": "",
            "functionCaption": "11",
            "functionName": "11",
            "functionType": 3,
            "isAllowInput": false,
            "isComposeMultiRecAsOne": false,
            "isMultiSelect": false,
            "isNotShowDlgWhenEmpty": false,
            "isShowDialog": true,
            "templateId": "0",
            "templateName": "",
            "type": "templateFunction"
         }
      },
      "version": 2
}
}

+10