新需求:加油管理列表要带付费方式,如果是加油卡,则显示卡号,类似江苏电力这样的页面
开发:
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');
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":"操作成功"
}