入口页面main
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