问题反馈添加修改

81041

2018-11-02 f8cb1fc3fce89569bd3a6e7fec7b7b39be362d61

问题反馈添加修改

 gx_tieta/src/com/fgkj/actions/Deverror_recordAction.java

@@ -46,7 +46,7 @@
                }

            }

        }

        //dev_record.setPicture_num(file.size());

        dev_record.setPicture_num(file.size());

        //System.out.println(dev_record);

        ServiceModel model=service.add(dev_record);

        result=tojson(model);


 gx_tieta/src/com/fgkj/dao/impl/Deverror_recordImpl.java

@@ -26,20 +26,34 @@
   //用户手动添加问题

    public boolean add(Object obj) {

        Deverror_record dev_record=(Deverror_record) obj;

		
        String sql=" insert into db_battinf.tb_deverror_record(stationId,record_time,error_descript,uid,picture_num ";

        String endsql=") values(?,?,?,?,?";

        List list=new ArrayList();

        list.add(dev_record.getStationId());

        list.add(dev_record.getRecord_time());

        list.add(dev_record.getError_descript());

        list.add(dev_record.getUid());

        list.add(dev_record.getPicture_num());

        if(dev_record.getPicture_num()>=1){

            sql+=",picture_one";

            endsql+=",? ";

        }

        if(dev_record.getPicture_num()>=2){

            sql+=",picture_two";

            endsql+=",? ";

        }if(dev_record.getPicture_num()>=3){

            sql+=",picture_three";

            endsql+=",? ";

        }if(dev_record.getPicture_num()>=4){

            sql+=",picture_four";

            endsql+=",? ";

        }

        list.add(dev_record.getPicture_one());

        list.add(dev_record.getPicture_two());

        list.add(dev_record.getPicture_three());

        list.add(dev_record.getPicture_four());

		
		
        String sql=" insert into db_battinf.tb_deverror_record(stationId,record_time,error_descript,uid,picture_num,picture_one,picture_two,picture_three,picture_four) values(?,?,?,?,?,?,?,?,?)";

        endsql+=")";

        sql+=endsql;

        boolean bl=DAOHelper.executeUpdatePicture(DBUtil.getConn(), sql, list);

        return bl;

    }