入口页面main

http://localhost:5775/batools

https://howso.rg1008.com/batools

社保数据类型



  /// <summary>
  /// 
  /// </summary>
  Unknown = 0,
  /// <summary>
  /// 段落文本
  /// </summary>
  Text = 1,
  /// <summary>
  /// 表格
  /// </summary>
  Table = 2,
  /// <summary>
  /// 图片
  /// </summary>
  Image = 3,
  /// <summary>
  /// 时间
  /// </summary>
  Date = 4,
  /// <summary>
  /// 条形二维码
  /// </summary>
  BarCode = 5

社保配置模板

isHead 按columnIndex顺序读取excel里列,然后转换为对应的field、alias表头

“fileName”: “realName”, //文件名称对应的字段
“fileField”: “realName”, //文件路径名称对应的字段
“dataSource”: “~/App_Export/{ownerId}/Pdfs/gzsb/data.elsx”,

{
  "data": {
    "fileName": "realName",
    "fileField": "realName",
    "dataSource": "~/App_Export/{ownerId}/Pdfs/gzsb/data.elsx",
    "startRowIndex": 2,
    "cells": [
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "wordFirstNo",
        "key": "&=wordFirstNo$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "wordSecondNo",
        "key": "&=wordSecondNo$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "gjjNo",
        "key": "&=gjjNo$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "sbNo",
        "key": "&=sbNo$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "citySub",
        "key": "&=citySub$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "enterprise",
        "key": "&=enterprise$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "city",
        "key": "&=city$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "province",
        "key": "&=province$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Text",
        "dataType": "Unknown",
        "isText": null,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {

        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "currentDate",
        "key": "&=currentDate$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Date",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": "yyyy-MM-dd HH:mm",
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "isHead": true,
        "field": "realName",
        "alias": "real_name",
        "cellValue": null,
        "columnName": null,
        "path": "realName",
        "key": "&=realName$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 1,
        "cellValue": null,
        "columnName": null,
        "isHead": true,
        "field": "idCard",
        "alias": "id_card",
        "path": "idCard",
        "key": "&=idCard$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 2,
        "cellValue": null,
        "columnName": null,
        "isHead": true,
        "field": "currentDate",
        "alias": "current_date",
        "path": "currentDate",
        "key": "&=currentDate$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Date",
        "isText": null,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": "yyyy-MM-dd HH:mm",
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 3,
        "isHead": true,
        "field": "startDate",
        "alias": "start_date",
        "cellValue": null,
        "columnName": null,
        "path": "startDate",
        "key": "&=startDate$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 4,
        "isHead": true,
        "field": "endDate",
        "alias": "end_date",
        "cellValue": null,
        "columnName": null,
        "path": "endDate",
        "key": "&=endDate$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 5,
        "isHead": true,
        "field": "yl",
        "alias": "yl",
        "cellValue": null,
        "columnName": null,
        "path": "yl",
        "key": "&=yl$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 6,
        "isHead": true,
        "field": "yln",
        "alias": "yln",
        "cellValue": null,
        "columnName": null,
        "path": "yln",
        "key": "&=yln$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 7,
        "isHead": true,
        "field": "gs",
        "alias": "gs",
        "cellValue": null,
        "columnName": null,
        "path": "gs",
        "key": "&=gs$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 8,
        "isHead": true,
        "field": "gsn",
        "alias": "gsn",
        "cellValue": null,
        "columnName": null,
        "path": "gsn",
        "key": "&=gsn$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 9,
        "isHead": true,
        "field": "sy",
        "alias": "sy",
        "cellValue": null,
        "columnName": null,
        "path": "sy",
        "key": "&=sy$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 10,
        "isHead": true,
        "field": "syn",
        "alias": "syn",
        "cellValue": null,
        "columnName": null,
        "path": "syn",
        "key": "&=syn$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Table",
        "dataType": "Unknown",
        "isText": null,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "isHead": true,
        "cellValue": null,
        "columnName": null,
        "path": "signP",
        "key": "&=signP",
        "imgPath": null,
        "imgWidth": 108,
        "imgHeight": 108,
        "wordStyle": "Image",
        "dataType": "Unknown",
        "isText": null,
        "x": 400.0,
        "y": 266.0,
        "pageIndex": 0,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "barcodeP",
        "key": "&=barcodeP",
        "imgPath": null,
        "imgWidth": 222,
        "imgHeight": 34,
        "wordStyle": "Image",
        "dataType": "BarCode",
        "isText": null,
        "x": 340.0,
        "y": 10.0,
        "pageIndex": 0,
        "format": "yyyyMMddHHmmss",
        "formatA": "filetime",
        "max": 10000,
        "min": 1000
      },
      {
        "disabled": null,
        "rowIndex": 0,
        "columnIndex": 0,
        "cellValue": null,
        "columnName": null,
        "path": "barcodeV",
        "key": "&=barcodeV$",
        "imgPath": null,
        "imgWidth": null,
        "imgHeight": null,
        "wordStyle": "Text",
        "dataType": "Unknown",
        "isText": true,
        "x": null,
        "y": null,
        "pageIndex": null,
        "format": null,
        "formatA": null,
        "max": 0,
        "min": 0
      }
    ]
  },
  "appSecretKey": null,
  "documentUrl": null,
  "field": null,
  "cacheKey": null,
  "cacheType": null,
  "dataCrypto": null,
  "currentDay": "2024-05-09",
  "cacheDate": null,
  "cacheDateTimestamp": 0,
  "auth": null,
  "path": null,
  "code": "0",
  "retCode": "0",
  "version": null,
  "title": null,
  "success": true,
  "message": null,
  "differencer": null,
  "error": null,
  "schema": null,
  "children": null,
  "paging": null,
  "fromApi": null,
  "fromEnv": null,
  "description": null,
  "downurl": null
}
文档更新时间: 2024-05-12 22:45   作者:admin