POST Visual/SaveExcelForm

保存excel导出模板

Request Information

URI Parameters

None.

Body Parameters

数据源

ExcelModel
NameDescriptionTypeAdditional information
obj

t_ClassExcel

None.
list

Collection of t_ClassExcelEntry

None.
listCond

Collection of t_ClassExcelCondition

None.
listMatch

Collection of t_ClassExcelCondition

None.
listSheet

Collection of t_ClassExcelSheetEntry

None.

Request Formats

application/json, text/json

Sample: 
{
  "obj": {
    "fInterId": 1,
    "fBillTypeId": 2,
    "fName": "sample string 3",
    "fIsDefault": true,
    "fProcedure": "sample string 5",
    "fFileNameFormat": "sample string 6"
  },
  "list": [
    {
      "fInterId": 1,
      "fIndex": 2,
      "fId": 3,
      "fIsActiveText": true,
      "fPageIndex": 5,
      "fFieldName": "sample string 6",
      "fText": "sample string 7",
      "fRowBegin": 8,
      "fRowEnd": 9,
      "fColBegin": 10,
      "fColEnd": 11,
      "fFontSize": 12,
      "fFont": "sample string 13",
      "fFontBold": true,
      "fIsEntry": true,
      "fHorizontalAlign": 16,
      "fVerticalAlign": 17,
      "fHeight": 18,
      "fInterval": 19,
      "fTableId": 20,
      "fTop": 21.0,
      "fWidth": 22.0,
      "fLeft": 23.0,
      "fFourLine": "sample string 24",
      "fFourLineSize": "sample string 25",
      "fFourLineColor": "sample string 26",
      "fFourLineType": "sample string 27",
      "fFontColor": "sample string 28",
      "fEntryPosition": 29,
      "fSumType": 30,
      "fWrap": true,
      "fCodeType": 32,
      "fLCnt": 33,
      "fCtlType": 34,
      "fStyle": "sample string 35",
      "fDynFieldName": "sample string 36",
      "fDynCol": 37,
      "fMask": "sample string 38"
    },
    {
      "fInterId": 1,
      "fIndex": 2,
      "fId": 3,
      "fIsActiveText": true,
      "fPageIndex": 5,
      "fFieldName": "sample string 6",
      "fText": "sample string 7",
      "fRowBegin": 8,
      "fRowEnd": 9,
      "fColBegin": 10,
      "fColEnd": 11,
      "fFontSize": 12,
      "fFont": "sample string 13",
      "fFontBold": true,
      "fIsEntry": true,
      "fHorizontalAlign": 16,
      "fVerticalAlign": 17,
      "fHeight": 18,
      "fInterval": 19,
      "fTableId": 20,
      "fTop": 21.0,
      "fWidth": 22.0,
      "fLeft": 23.0,
      "fFourLine": "sample string 24",
      "fFourLineSize": "sample string 25",
      "fFourLineColor": "sample string 26",
      "fFourLineType": "sample string 27",
      "fFontColor": "sample string 28",
      "fEntryPosition": 29,
      "fSumType": 30,
      "fWrap": true,
      "fCodeType": 32,
      "fLCnt": 33,
      "fCtlType": 34,
      "fStyle": "sample string 35",
      "fDynFieldName": "sample string 36",
      "fDynCol": 37,
      "fMask": "sample string 38"
    }
  ],
  "listCond": [
    {
      "fInterId": 1,
      "fPageIndex": 2,
      "fText": "sample string 3",
      "fValue": "sample string 4",
      "fOpt": "sample string 5",
      "fTableId": 6
    },
    {
      "fInterId": 1,
      "fPageIndex": 2,
      "fText": "sample string 3",
      "fValue": "sample string 4",
      "fOpt": "sample string 5",
      "fTableId": 6
    }
  ],
  "listMatch": [
    {
      "fInterId": 1,
      "fPageIndex": 2,
      "fText": "sample string 3",
      "fValue": "sample string 4",
      "fOpt": "sample string 5",
      "fTableId": 6
    },
    {
      "fInterId": 1,
      "fPageIndex": 2,
      "fText": "sample string 3",
      "fValue": "sample string 4",
      "fOpt": "sample string 5",
      "fTableId": 6
    }
  ],
  "listSheet": [
    {
      "fInterId": 1,
      "fIndex": 2,
      "fNameFormat": "sample string 3"
    },
    {
      "fInterId": 1,
      "fIndex": 2,
      "fNameFormat": "sample string 3"
    }
  ]
}

application/xml, text/xml

Sample: 
<ExcelModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/DbFrameModel">
  <list xmlns:d2p1="http://schemas.datacontract.org/2004/07/DbFrameModel.DbEntity">
    <d2p1:t_ClassExcelEntry>
      <d2p1:fCodeType>32</d2p1:fCodeType>
      <d2p1:fColBegin>10</d2p1:fColBegin>
      <d2p1:fColEnd>11</d2p1:fColEnd>
      <d2p1:fCtlType>34</d2p1:fCtlType>
      <d2p1:fDynCol>37</d2p1:fDynCol>
      <d2p1:fDynFieldName>sample string 36</d2p1:fDynFieldName>
      <d2p1:fEntryPosition>29</d2p1:fEntryPosition>
      <d2p1:fFieldName>sample string 6</d2p1:fFieldName>
      <d2p1:fFont>sample string 13</d2p1:fFont>
      <d2p1:fFontBold>true</d2p1:fFontBold>
      <d2p1:fFontColor>sample string 28</d2p1:fFontColor>
      <d2p1:fFontSize>12</d2p1:fFontSize>
      <d2p1:fFourLine>sample string 24</d2p1:fFourLine>
      <d2p1:fFourLineColor>sample string 26</d2p1:fFourLineColor>
      <d2p1:fFourLineSize>sample string 25</d2p1:fFourLineSize>
      <d2p1:fFourLineType>sample string 27</d2p1:fFourLineType>
      <d2p1:fHeight>18</d2p1:fHeight>
      <d2p1:fHorizontalAlign>16</d2p1:fHorizontalAlign>
      <d2p1:fId>3</d2p1:fId>
      <d2p1:fIndex>2</d2p1:fIndex>
      <d2p1:fInterId>1</d2p1:fInterId>
      <d2p1:fInterval>19</d2p1:fInterval>
      <d2p1:fIsActiveText>true</d2p1:fIsActiveText>
      <d2p1:fIsEntry>true</d2p1:fIsEntry>
      <d2p1:fLCnt>33</d2p1:fLCnt>
      <d2p1:fLeft>23</d2p1:fLeft>
      <d2p1:fMask>sample string 38</d2p1:fMask>
      <d2p1:fPageIndex>5</d2p1:fPageIndex>
      <d2p1:fRowBegin>8</d2p1:fRowBegin>
      <d2p1:fRowEnd>9</d2p1:fRowEnd>
      <d2p1:fStyle>sample string 35</d2p1:fStyle>
      <d2p1:fSumType>30</d2p1:fSumType>
      <d2p1:fTableId>20</d2p1:fTableId>
      <d2p1:fText>sample string 7</d2p1:fText>
      <d2p1:fTop>21</d2p1:fTop>
      <d2p1:fVerticalAlign>17</d2p1:fVerticalAlign>
      <d2p1:fWidth>22</d2p1:fWidth>
      <d2p1:fWrap>true</d2p1:fWrap>
    </d2p1:t_ClassExcelEntry>
    <d2p1:t_ClassExcelEntry>
      <d2p1:fCodeType>32</d2p1:fCodeType>
      <d2p1:fColBegin>10</d2p1:fColBegin>
      <d2p1:fColEnd>11</d2p1:fColEnd>
      <d2p1:fCtlType>34</d2p1:fCtlType>
      <d2p1:fDynCol>37</d2p1:fDynCol>
      <d2p1:fDynFieldName>sample string 36</d2p1:fDynFieldName>
      <d2p1:fEntryPosition>29</d2p1:fEntryPosition>
      <d2p1:fFieldName>sample string 6</d2p1:fFieldName>
      <d2p1:fFont>sample string 13</d2p1:fFont>
      <d2p1:fFontBold>true</d2p1:fFontBold>
      <d2p1:fFontColor>sample string 28</d2p1:fFontColor>
      <d2p1:fFontSize>12</d2p1:fFontSize>
      <d2p1:fFourLine>sample string 24</d2p1:fFourLine>
      <d2p1:fFourLineColor>sample string 26</d2p1:fFourLineColor>
      <d2p1:fFourLineSize>sample string 25</d2p1:fFourLineSize>
      <d2p1:fFourLineType>sample string 27</d2p1:fFourLineType>
      <d2p1:fHeight>18</d2p1:fHeight>
      <d2p1:fHorizontalAlign>16</d2p1:fHorizontalAlign>
      <d2p1:fId>3</d2p1:fId>
      <d2p1:fIndex>2</d2p1:fIndex>
      <d2p1:fInterId>1</d2p1:fInterId>
      <d2p1:fInterval>19</d2p1:fInterval>
      <d2p1:fIsActiveText>true</d2p1:fIsActiveText>
      <d2p1:fIsEntry>true</d2p1:fIsEntry>
      <d2p1:fLCnt>33</d2p1:fLCnt>
      <d2p1:fLeft>23</d2p1:fLeft>
      <d2p1:fMask>sample string 38</d2p1:fMask>
      <d2p1:fPageIndex>5</d2p1:fPageIndex>
      <d2p1:fRowBegin>8</d2p1:fRowBegin>
      <d2p1:fRowEnd>9</d2p1:fRowEnd>
      <d2p1:fStyle>sample string 35</d2p1:fStyle>
      <d2p1:fSumType>30</d2p1:fSumType>
      <d2p1:fTableId>20</d2p1:fTableId>
      <d2p1:fText>sample string 7</d2p1:fText>
      <d2p1:fTop>21</d2p1:fTop>
      <d2p1:fVerticalAlign>17</d2p1:fVerticalAlign>
      <d2p1:fWidth>22</d2p1:fWidth>
      <d2p1:fWrap>true</d2p1:fWrap>
    </d2p1:t_ClassExcelEntry>
  </list>
  <listCond xmlns:d2p1="http://schemas.datacontract.org/2004/07/DbFrameModel.DbEntity">
    <d2p1:t_ClassExcelCondition>
      <d2p1:fInterId>1</d2p1:fInterId>
      <d2p1:fOpt>sample string 5</d2p1:fOpt>
      <d2p1:fPageIndex>2</d2p1:fPageIndex>
      <d2p1:fTableId>6</d2p1:fTableId>
      <d2p1:fText>sample string 3</d2p1:fText>
      <d2p1:fValue>sample string 4</d2p1:fValue>
    </d2p1:t_ClassExcelCondition>
    <d2p1:t_ClassExcelCondition>
      <d2p1:fInterId>1</d2p1:fInterId>
      <d2p1:fOpt>sample string 5</d2p1:fOpt>
      <d2p1:fPageIndex>2</d2p1:fPageIndex>
      <d2p1:fTableId>6</d2p1:fTableId>
      <d2p1:fText>sample string 3</d2p1:fText>
      <d2p1:fValue>sample string 4</d2p1:fValue>
    </d2p1:t_ClassExcelCondition>
  </listCond>
  <listMatch xmlns:d2p1="http://schemas.datacontract.org/2004/07/DbFrameModel.DbEntity">
    <d2p1:t_ClassExcelCondition>
      <d2p1:fInterId>1</d2p1:fInterId>
      <d2p1:fOpt>sample string 5</d2p1:fOpt>
      <d2p1:fPageIndex>2</d2p1:fPageIndex>
      <d2p1:fTableId>6</d2p1:fTableId>
      <d2p1:fText>sample string 3</d2p1:fText>
      <d2p1:fValue>sample string 4</d2p1:fValue>
    </d2p1:t_ClassExcelCondition>
    <d2p1:t_ClassExcelCondition>
      <d2p1:fInterId>1</d2p1:fInterId>
      <d2p1:fOpt>sample string 5</d2p1:fOpt>
      <d2p1:fPageIndex>2</d2p1:fPageIndex>
      <d2p1:fTableId>6</d2p1:fTableId>
      <d2p1:fText>sample string 3</d2p1:fText>
      <d2p1:fValue>sample string 4</d2p1:fValue>
    </d2p1:t_ClassExcelCondition>
  </listMatch>
  <listSheet xmlns:d2p1="http://schemas.datacontract.org/2004/07/DbFrameModel.DbEntity">
    <d2p1:t_ClassExcelSheetEntry>
      <d2p1:fIndex>2</d2p1:fIndex>
      <d2p1:fInterId>1</d2p1:fInterId>
      <d2p1:fNameFormat>sample string 3</d2p1:fNameFormat>
    </d2p1:t_ClassExcelSheetEntry>
    <d2p1:t_ClassExcelSheetEntry>
      <d2p1:fIndex>2</d2p1:fIndex>
      <d2p1:fInterId>1</d2p1:fInterId>
      <d2p1:fNameFormat>sample string 3</d2p1:fNameFormat>
    </d2p1:t_ClassExcelSheetEntry>
  </listSheet>
  <obj xmlns:d2p1="http://schemas.datacontract.org/2004/07/DbFrameModel.DbEntity">
    <d2p1:fBillTypeId>2</d2p1:fBillTypeId>
    <d2p1:fFileNameFormat>sample string 6</d2p1:fFileNameFormat>
    <d2p1:fInterId>1</d2p1:fInterId>
    <d2p1:fIsDefault>true</d2p1:fIsDefault>
    <d2p1:fName>sample string 3</d2p1:fName>
    <d2p1:fProcedure>sample string 5</d2p1:fProcedure>
  </obj>
</ExcelModel>

application/x-www-form-urlencoded

Sample:

Sample not available.

Response Information

Resource Description

SaveExcelFormModel
NameDescriptionTypeAdditional information
error

integer

None.
Msg

string

None.
fInterId

integer

None.

Response Formats

application/json, text/json

Sample: 
{
  "fInterId": 1,
  "error": 1,
  "Msg": "sample string 2"
}

application/xml, text/xml

Sample: 
<SaveExcelFormModel xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/BLL.Visual">
  <Msg>sample string 2</Msg>
  <error>1</error>
  <fInterId>1</fInterId>
</SaveExcelFormModel>