GAT项目新需求：加油管理修改

新需求：加油管理列表要带付费方式，如果是加油卡，则显示卡号，类似江苏电力这样的页面

开发：

1.先增加数据库CAR_OIL表字段和注释

alter table CAR_OIL ADD  OILCARD_NO VARCHAR2(100);

alter table CAR_OIL ADD  PAYTYPE NUMBER(2);

comment on column CAR_OIL.OILCARD_NO is '加油卡号';

comment on column CAR_OIL.PAYTYPE is '付费方式';

2.手动在DICTIONARY_TYPE表中添加字典类型：1：现金；2：加油卡

在页面上添加字典：192.168.1.136:8093/sgat

查看DICTIONARY_ITEM表

导出SQL语句：

insert into DICTIONARY_ITEM (DIT_ID, DIC_TYPE, ITEM_VALUE, ITEM_NAME, ITEM_NAME_SPELL, ORDER_ID, PARENT_ID, FLAG, MARK, ITEM_LEVEL, MOD_DEL_FLAG, ROWID)
values ('20170414111953357011386', 'PAYTYPE', '1', '现金', 'XJ', 1, '-999', '1', null, 1, 1, 'AAAYJGAAGAAHHVqAAb');

insert into DICTIONARY_ITEM (DIT_ID, DIC_TYPE, ITEM_VALUE, ITEM_NAME, ITEM_NAME_SPELL, ORDER_ID, PARENT_ID, FLAG, MARK, ITEM_LEVEL, MOD_DEL_FLAG, ROWID)
values ('20170414112032302018699', 'PAYTYPE', '2', '加油卡', 'JYK', 2, '-999', '1', null, 1, 1, 'AAAYJGAAGAAHHVqAAc');

--------------------------------------------------------------------------------------------------------------------------

3.在代码中添加字典

4.实体类

5.映射文件：

6.CarOilEditReq：用于新增编辑

7.CarOilListResp：用于列表显示

8.列表要显示付费方式和加油卡卡号

9.修改新增代码，要新增加油卡表中已经存在的加油卡卡号

10.导入Excel付费方式是必填项，填了加油卡要填加油卡号，现金则不填加油卡号。代码中验证：1：现金；2：加油卡

开发完成测试接口OK：

查询：
car/oil/list

{
    "carHostNO":"15000",
    "startRow":0,
    "maxSize":20
}

{
    "retCode":1,
    "retMsg":"操作成功",
    "list":[
        {
            "recordId":"20170414162815565018900",
            "appSysId":23551,
            "appDeptId":6,
            "orgDeptName":"警保部_财务处",
            "carHostNO":"15000",
            "oilUseTime":"2016-10-31",
            "oilType":"1",
            "oilAccount":22,
            "oilPay":20,
            "oilAddress":"中山陵",
            "oilMileage":"100",
            "oilHandle":"啊哈哈的",
            "vehicleModel":"轿车",
            "oilcardNo":"22222222",
            "payType":2,
            "oilTypeDesc":"98#",
            "payTypeDesc":"加油卡"
        },
        {
            "recordId":"20170217135923927019191",
            "appSysId":23551,
            "appDeptId":6,
            "orgDeptName":"警保部_财务处",
            "carHostNO":"15000",
            "oilUseTime":"2017-01-01",
            "oilType":"1",
            "oilAccount":22,
            "oilPay":22,
            "oilAddress":"南京",
            "oilMileage":"22",
            "oilHandle":"李四217",
            "vehicleModel":"轿车",
            "payType":1,
            "oilTypeDesc":"98#",
            "payTypeDesc":"现金"
        },
        {
            "recordId":"20161130102253899019445",
            "appSysId":23551,
            "appDeptId":6,
            "orgDeptName":"警保部_财务处",
            "carHostNO":"15000",
            "oilUseTime":"2016-11-30",
            "oilType":"6",
            "oilAccount":22,
            "oilPay":22,
            "oilAddress":"南京",
            "oilMileage":"22",
            "oilHandle":"李四",
            "vehicleModel":"轿车",
            "payType":1,
            "oilTypeDesc":"90#",
            "payTypeDesc":"现金"
        }
    ],
    "totalNum":3,
    "curRecordNum":3,
    "startRow":0,
    "nextStartRow":3
}

新增：
car/oil/addCarOil

用加油卡卡号
{
        "carHostNO":"15000",
        "oilcardNo":"22222222",
        "payType":"2",
        "oilUseTime":"2016-10-31",
        "oilType":"1",
        "oilAccount":"22",
        "oilPay":"20",
        "oilAddress":"中山陵",
        "oilMileage":"100",
        "oilHandle":"啊哈哈的"
}

{
    "retCode":1,
    "retMsg":"操作成功"
}

用现金
{
        "carHostNO":"15000",
        "oilcardNo":"",
        "payType":"1",
        "oilUseTime":"2016-10-31",
        "oilType":"1",
        "oilAccount":"22",
        "oilPay":"20",
        "oilAddress":"快快快",
        "oilMileage":"100",
        "oilHandle":"哈哈哈"
}

{
    "retCode":1,
    "retMsg":"操作成功"
}

修改：
car/oil/modifyCarOil

用加油卡卡号
{
    "recordId":"20170417085938160010308",	
    "carHostNO":"15000",
    "oilcardNo":"22222222",
    "payType":"2",
    "oilUseTime":"2016-10-31",
    "oilType":"1",
    "oilAccount":"22",
    "oilPay":"20",
    "oilAddress":"中山陵1",
    "oilMileage":"100",
    "oilHandle":"啊哈哈的1"
}

{
    "retCode":1,
    "retMsg":"操作成功"
}

用现金
{
    "recordId":"20170417085938160010308",	
    "carHostNO":"15000",
    "payType":"1",
    "oilUseTime":"2016-10-31",
    "oilType":"1",
    "oilAccount":"22",
    "oilPay":"20",
    "oilAddress":"中山陵",
    "oilMileage":"100",
    "oilHandle":"啊哈哈的"
}

{
    "retCode":1,
    "retMsg":"操作成功"
}

导入：
car/oil/importRecords

[{
    "lineNo":"2",
    "carHostNO":"15000",
    "oilcardNo":"22222222",
    "payType":"现金",
    "oilType":"1",
    "oilUseTime":"2016-10-31",
    "oilType":"1",
    "oilAccount":"22",
    "oilPay":"20",
    "oilAddress":"日日日",
    "oilMileage":"100",
    "oilHandle":"一样一样"

}
]

{
    "retCode":8193,
    "retMsg":"操作失败：第2行不正确，付费方式为现金，不填加油卡卡号！"
}

[{
    "lineNo":"2",
    "carHostNO":"15000",
    "oilcardNo":"22222222",
    "payType":"加油卡",
    "oilUseTime":"2016-10-31",
    "oilType":"1",
    "oilAccount":"22",
    "oilPay":"20",
    "oilAddress":"日日日",
    "oilMileage":"100",
    "oilHandle":"一样一样"

}
]

{
    "retCode":1,
    "retMsg":"操作成功"
}