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

来源：互联网发布：天津基础教研网络平台编辑：程序博客网时间：2024/05/21 22:42

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

开发：

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":"操作成功"}

0 0