用react 构建电子表格（10)--把前端格式数据保存到服务端

本文链接：https://blog.csdn.net/wh_xia_jun/article/details/113934981

与服务端交互，采用axios,

抄作业：React应用中封装axios,
和anttd配套，抄react中使用antd的table组件,和axios的请求
用nginx做代理，解决服务端跨域访问
baseurl配置：由于采取nginx，baseurl的问题转到ngnix配置文件当中去了所以忽略掉项目中这个配置，这东西网上材料非常丰富

    // 获取state数据 保存到后端
    saveTable=(param_report_id)=>{
            //读取state 保存到后端
        let _current_table_model =this.state.history_record[this.state.history_record.length -1];
        let _mergeCellArray=this.state.mergeCellArray;
        let parm_table_mode={
            table_model:_current_table_model,
            mergeCellArray:_mergeCellArray,
            report_id:param_report_id
        }
        console.log("=============================================================================================");
console.log(parm_table_mode);
        saveReport(parm_table_mode).then(
            (res) => {
                console.log("get test response:", res.data);
            },
            (error) => {
                console.log("get response failed!");
            }
        );
    }

报表保存到服务端

需要保存的数据：

report:(id,name,type)
worksheet(id,report_id,name)
worktable(id,worksheetId,name)
data_model(id,worktableId,rowNo,colNo,value)
value_model(id,worktableId,rowNo,colNo,value)
struct_model(id,worktableId,rowNo,colNo,value1,value2)
cell_align_model(id,worktableId,rowNo,colNo,value)
cell_border_top_model(id,worktableId,rowNo,colNo,value)
cell_border_bottom_model(id,worktableId,rowNo,colNo,value)
cell_addFilter_bright_model(id,worktableId,rowNo,colNo,value)
cell_cellBackgroundColor_model(id,worktableId,rowNo,colNo,str_value)
cell_cell_font_css_model(id,worktableId,rowNo,colNo,value_1,value_2,value_3,value_4,value_5)
cell_editing_model(id,worktableId,rowNo,colNo,value)
colWidths(id,worktableId,colNo,value)
rowHeights(id,worktableId,rowNo,value)
mergeCellArray(id,worktableId,sortNo,value_1,value_2,value_3,value_4)

--report_table
drop table report_table;
create table report_table(
Id number primary key,　　--主键、自增长
Name varchar2(100) not null,
table_desc varchar2(120),
typeId number
);
insert into REPORT_TABLE values(1,'资产负债表','资产负债表',501);
insert into REPORT_TABLE values(2,'损益表','损益表',501);
insert into REPORT_TABLE values(3,'现金流量表','现金流量表',501);
commit;

--worksheet
drop table report_worksheet;
create table report_worksheet(
Id number primary key,　　
Name varchar2(100) not null,
description varchar2(120),
table_id number not null
);

drop table report_workbook_model;
create table report_workbook_model(
Id number primary key,　　
Name varchar2(100)  default '',
description varchar2(120) default '',
worksheet_id number not null,
rowNo number not null,
colNo number not null,
is_show number not null,   --是否显示本单元格 1 显示 0 不显示
str_value varchar2(120) default '',    --value
col_span NUMBER  default 1, --跨行数
row_span number   default 1,  --跨列数
align number(1,0)   default 1, --1 左对齐 2 中间对齐3 右对齐
top_border  varchar2(100) ,   --example 1px solid #F00
right_border  varchar2(100) ,
bottom_border  varchar2(100) ,
left_border   varchar2(100),
font_family  varchar2(50),
font_size  varchar2(50),
font_weight  varchar2(50),
font_sytle  varchar2(50),
font_css_underline  varchar2(50)
);
comment on column report_workbook_model.Name is 'Name 目前没有用';
comment on column report_workbook_model.description is '备注';
comment on column report_workbook_model.worksheet_id is 'sheet_id';
comment on column report_workbook_model.rowNo is '行号';
comment on column report_workbook_model.colNo is '列号';
comment on column report_workbook_model.align is '对齐方式 1 左对齐 2 中间对齐3 右对齐';
comment on column report_workbook_model.is_show is '备注名';
comment on column report_workbook_model.str_value is 'value';
comment on column report_workbook_model.col_span is '跨列数';
comment on column report_workbook_model.row_span is '跨行数';
comment on column report_workbook_model.top_border is '单元格顶边样式 example 1px solid #F00';
comment on column report_workbook_model.right_border is '单元格右边样式';
comment on column report_workbook_model.bottom_border is '单元格底边样式';
comment on column report_workbook_model.left_border is '单元格左边样式';
comment on column report_workbook_model.font_family is '字体类型 example 仿宋等';
comment on column report_workbook_model.font_size is '字体尺寸';
comment on column report_workbook_model.font_weight is '粗体';
comment on column report_workbook_model.font_css_underline is '下划线';

从服务端读取数据

操作	对应的处理办法	当前状态
新建报表	从模板数据中，生成新的报表格式数据	未实现
新建报表，但格式数据没有生成成功的时候	2种处理 a)直接报错 b)在此生成格式数据我们采取a办法	未实现
查询报表	直接从后台获取格式数据	已实现
保存报表	更新格式数据	已实现
删除报表	同时删除格式数据，如果报表删除格式数据没有删除呢弃用这些格式数据	未实现

当然数据库中必须有模板数据，

prompt Importing table REPORT_WORKBOOK_MODEL...
set feedback off
set define off
insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (381, null, null, 0, 1, 1, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (382, null, null, 0, 2, 1, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (383, null, null, 0, 3, 1, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (384, null, null, 0, 4, 1, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (385, null, null, 0, 5, 1, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (386, null, null, 0, 1, 2, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (387, null, null, 0, 2, 2, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (388, null, null, 0, 3, 2, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (389, null, null, 0, 4, 2, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (390, null, null, 0, 5, 2, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (391, null, null, 0, 1, 3, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (392, null, null, 0, 2, 3, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (393, null, null, 0, 3, 3, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (394, null, null, 0, 4, 3, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (395, null, null, 0, 5, 3, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (396, null, null, 0, 1, 4, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (397, null, null, 0, 2, 4, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (398, null, null, 0, 3, 4, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (399, null, null, 0, 4, 4, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (400, null, null, 0, 5, 4, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (401, null, null, 0, 1, 5, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (402, null, null, 0, 2, 5, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (403, null, null, 0, 3, 5, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (404, null, null, 0, 4, 5, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (405, null, null, 0, 5, 5, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (406, null, null, 0, 1, 6, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (407, null, null, 0, 2, 6, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (408, null, null, 0, 3, 6, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (409, null, null, 0, 4, 6, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (410, null, null, 0, 5, 6, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (411, null, null, 0, 1, 7, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (412, null, null, 0, 2, 7, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (413, null, null, 0, 3, 7, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (414, null, null, 0, 4, 7, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (415, null, null, 0, 5, 7, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (416, null, null, 0, 1, 8, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (417, null, null, 0, 2, 8, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (418, null, null, 0, 3, 8, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (419, null, null, 0, 4, 8, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (420, null, null, 0, 5, 8, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (421, null, null, 0, 1, 9, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (422, null, null, 0, 2, 9, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (423, null, null, 0, 3, 9, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (424, null, null, 0, 4, 9, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (425, null, null, 0, 5, 9, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (426, null, null, 0, 1, 10, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (427, null, null, 0, 2, 10, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (428, null, null, 0, 3, 10, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (429, null, null, 0, 4, 10, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

insert into REPORT_WORKBOOK_MODEL (ID, NAME, DESCRIPTION, WORKSHEET_ID, ROWNO, COLNO, IS_SHOW, STR_VALUE, COL_SPAN, ROW_SPAN, ALIGN, TOP_BORDER, RIGHT_BORDER, BOTTOM_BORDER, LEFT_BORDER, FONT_FAMILY, FONT_SIZE, FONT_WEIGHT, FONT_SYTLE, FONT_CSS_UNDERLINE, BACKGROUNDCOLOR)
values (430, null, null, 0, 5, 10, 1, null, 1, 1, 1, '0', '0', '0', '0', 'microYH', 'medium', 'font-weight_normal', 'font-sytle_normal', 'none', '#ffffff');

prompt Done.

查询数据：

    componentDidMount(){
        this.props.onRef(this)  //这个就是把自身传给调用者
        let _report_id=this.props.reportId;
        getReportPattern(_report_id).then(
            (res) => {
                let _table_mode={};
                let new_history_record=[];
                let _col_length=res.data.colwidthsList.length;
                let _row_length=res.data.rowheightsList.length;
                let _colwidths=[];
                let _rowHeights=[];

                let _data_mode=new Array(_rowHeights);
                let _value_mode=new Array(_rowHeights);
                let _struct_mode=new Array(_rowHeights);
                let _cell_align=new Array(_rowHeights);
                let _cell_border_top=new Array(_rowHeights);
                let _cell_border_right=new Array(_rowHeights);
                let _cell_border_bottom=new Array(_rowHeights);
                let _cell_border_left=new Array(_rowHeights);
                let _cell_cell_font_css=new Array(_rowHeights);
                let _cell_background_color=new  Array(_rowHeights);
                let _cell_addFilter_bright=new  Array(_rowHeights);
                let _cell_editing_model=new  Array(_rowHeights);



                for (var i=0;i<_row_length;i++){
                    _data_mode[i] = new Array(_col_length);
                    _value_mode[i]=new Array(_col_length);
                    _struct_mode[i]=new Array(_col_length);
                    _cell_align[i]=new Array(_col_length);
                    _cell_border_top[i]=new Array(_col_length);
                    _cell_border_right[i]=new Array(_col_length);
                    _cell_border_bottom[i]=new Array(_col_length);
                    _cell_border_left[i]=new Array(_col_length);
                    _cell_cell_font_css[i]=new Array(_col_length);
                    _cell_background_color[i]=new Array(_col_length);
                    _cell_addFilter_bright[i]=new Array(_col_length);
                    _cell_addFilter_bright[i].fill(0);
                    _cell_editing_model[i]=new Array(_col_length);
                    _cell_editing_model[i].fill(0);

                }


                // for (let i=0;i<_row_length;i++){
                //     for (let j=0;j<_col_length;j++){
                //     }
                // }

                _colwidths=res.data.colwidthsList.map(item => { // item为数组的元素
                    return item.value;
                });
                _rowHeights=res.data.rowheightsList.map(item => { // item为数组的元素
                    return item.value;
                });

                for(var val of res.data.modelList){
                    // if((val.rowno==2) && (val.colno==2)){
                    //     console.log("test~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~")
                    // }
                    _data_mode[val.rowno][val.colno]=val.isShow;
                    _value_mode[val.rowno][val.colno]=val.strValue;
                   // _struct_mode[val.rowno][val.colno]=[val.rowSpan,val.colSpan];
                    _struct_mode[val.rowno][val.colno]=new Array(2);
                    _struct_mode[val.rowno][val.colno][0]=val.rowSpan;
                    _struct_mode[val.rowno][val.colno][1]=val.colSpan;
                    _cell_align[val.rowno][val.colno]=val.align;
                    _cell_border_top[val.rowno][val.colno]=val.topBorder;
                    _cell_border_right[val.rowno][val.colno]=val.rightBorder;
                    _cell_border_bottom[val.rowno][val.colno]=val.bottomBorder;
                    _cell_border_left[val.rowno][val.colno]=val.leftBorder;
                    _cell_cell_font_css[val.rowno][val.colno]=[val.fontFamily,val.fontSize,val.fontWeight,val.fontSytle,val.fontCssUnderline];
                    _cell_background_color[val.rowno][val.colno]=val.backgroundcolor
                }

                new_history_record[0]={
                    data_model:_data_mode,   //数据 (是否显示数据)
                    value_model:_value_mode,  //值
                    struct_model:_struct_mode,  //表格结构
                    cell_align_model:_cell_align,  //对齐方式
                    cell_border_top_model:_cell_border_top,  //边
                    cell_border_bottom_model:_cell_border_bottom,
                    cell_border_left_model:_cell_border_left,
                    cell_border_right_model:_cell_border_right,
                    cell_addFilter_bright_model: _cell_addFilter_bright,   //filter
                    cell_cellBackgroundColor_model:_cell_background_color, //背景色
                    cell_cell_font_css_model:_cell_cell_font_css,   //字体
                    //cellSelectStates_model:{},    //是否去掉？
                    cell_editing_model:_cell_editing_model,
                    colWidths:_colwidths, //列宽度数组
                    rowHeights:_rowHeights //行高度数组
                }
              //  console.log( "''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''");

                console.log(new_history_record);
                //console.log( "''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''");
               this.setState({history_record: new_history_record});
               this.setState({mergeCellArray: res.data.mergecellarrayList});
                //this.setState({mergeCellArray: res.data.mergecellarrayList});
            },
            (error) => {
                console.log("get response failed!");
            }
        );
    }