表格

普通表格，数据存放在一个栏位里面

对于数据量较少的应用，不需要单独建表保存

可视化编辑

JSON：

[{
        "id": "PM",
        "width": 200,
        "name": "品名",
        "itemtype": "ChooseButton",
        "filter": "BUSITYPE like '%安检收费%'",
        "sort": "iorder asc",
        "loaddefault": "STATE like '%默认%'",
        "itemvalue": "@FORMTABLEDATA,3005",
        "onchoose": {
            "PM": "TEXT",
            "MID": "MID",
            "DW": "UNIT",
            "DJ": "UNITPRICE"
        },
        "showitems": "",
        "rowformat": "@PM:@JINE元(@SL × @DJ元)"
    },
    {
        "id": "MID",
        "width": 100,
        "name": "编号",
        "itemtype": "Hidden"
    },
    {
        "id": "DJ",
        "width": 100,
        "name": "单价(元)",
        "itemtype": "Numberic"
    },
    {
        "id": "SL",
        "width": 100,
        "name": "数量",
        "itemtype": "Numberic",
        "isrequired": "true",
        "defaultvalue": 1
    },
    {
        "id": "JINE",
        "width": 100,
        "name": "金额",
        "formula": "@DJ*@SL",
        "itemtype": "Numberic"
    }
]

表格运算

@GRIDSUMCOL,@SHOUFEIXIANGMU,"JINE"

表格某列合计

@GRIDAVGCOL,@SHOUFEIXIANGMU,"JINE"

表格某列求平均

@GRIDJOINCOL,@SHOUFEIXIANGMU, "NAME"

表格某列合并，逗号隔开

@GRIDCOUNT,@GDCL

表格行数