10 面试题目

1，第一列长度不影藏改为长度为0
2，增加年度查询条件
3，增加时间字段
4，删除按单条删除
5，删除按钮放在前面
6，默认给表加标题
7，解决excel导入的问题

设置为uuid赋值，字段类型改为 vchar；

Batch entry 0 INSERT INTO "fr_party_year_recruit_member_count" ("org_id","user_id","create_time","enterprise_name","project","total_number","girl","ethnic_minority","under_25",
"belong_26_30","belong_31_35","belong_36_40","belong_41_45","belong_46_60","other_on_61","graduate_student","undergraduate_college","junior_college","specialized_school",
"secondary_technical_school","junior_school_under") VALUES (NULL,NULL,NULL,'222','2',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL)
was aborted: ERROR: null value in column "base_id" violates not-null constraint
详细：Failing row contains (null, null, null, null, null, 222, 2, 2, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null). Call getNextException to see other errors in the batch.

if(len(C2)=0,UUID(32),C2)

http://192.168.103.11:3088/WebReport/ReportServer?reportlet=tyydj%2Ffr_party_year_recruit_member_count.cpt&op=write&org_id=323&user_id=654

提交触发查询
主键隐藏
导入数据的样式和保存数据
删除行确定

1、删除按钮
按钮类型-普通
按钮名称-删除行
图标

按钮添加事件：


            //获取当前控件所在单元格的编号
            var cell = this.options.location;
            FR.Msg.confirm("警告", "确定要删除吗？", function(value) {
                if (value) {
                //删除当前行
                _g().deleteReportRC(cell);
                //校验并提交
                _g().verifyAndWriteReport();
            
                    }
            })


按钮控件名：sc

2、日期控件添加‘编辑后’事件： _g().parameterCommit();

1、表样
表格列背景色：#fafafa
网格：只保留横向

2、插入、删除按钮

删除按钮-初始化后
var el = this.element.children();
('.x-emb-delete').css('color','#ff5e2f');

新增按钮-初始化后
var el = this.element.children();
('.x-emb-add').css('color','#1890ff');

   fr_party_org_member_count 

决策报表

http://192.168.103.11:3088/WebReport/ReportServer?reportlet=tyydj%2Ffr_party_org_member_count.cpt&op=write&org_id=323&user_id=654

&orgId=323&userId=654