81041
2018-11-03 dab560a713cf4f7250bb8398578e78c7940d225f
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
package com.fgkj.actions;
 
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.Blob;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
 
import com.fgkj.dto.BattInf;
import com.fgkj.dto.Deverror_record;
import com.fgkj.dto.ServiceModel;
import com.fgkj.dto.User_inf;
import com.fgkj.services.Deverror_recordService;
 
public class Deverror_recordAction extends ActionUtil{
    private Deverror_recordService service=new Deverror_recordService();
    private String json;
    private String result;
    private List<File> file;
    //用户手动添加问题
    public String add(){
        Deverror_record dev_record=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, Deverror_record.class);
        User_inf uinf=(User_inf) getUser();
        dev_record.setUid(uinf.getUId());
        if(file!=null&&file.size()>0){
            for (int i=0;i<file.size();i++) {
                switch (i) {
                case 0:
                    dev_record.setPicture_one(file.get(i));
                    break;
                case 1:
                    dev_record.setPicture_two(file.get(i));
                    break;
                case 2:
                    dev_record.setPicture_three(file.get(i));
                    break;
                case 3:
                    dev_record.setPicture_four(file.get(i));
                    break;
                default:
                    break;
                }
            }
        }
        //dev_record.setPicture_num(file.size());
        //System.out.println(dev_record);
        ServiceModel model=service.add(dev_record);
        result=tojson(model);
        return SUCCESS;
    }
     //用户处理的结果
    public String update(){
        Deverror_record dev_record=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, Deverror_record.class);
        ServiceModel model=service.update(dev_record);
        result=tojson(model);
        return SUCCESS;
    }
    //根据stationid查询设备的问题记录
    public String serchByCondition(){
        BattInf binf=getGson().fromJson(json, BattInf.class);
        User_inf uinf=(User_inf) getUser();
        binf.setNum(uinf.getUId());
        ServiceModel model=service.serchByCondition(binf);
        result=tojson(model);
        return SUCCESS;
    }
    //根据num和列名查询图片(note放列名字)
    public void serchByInfo(){
        InputStream is = null;
        OutputStream os =null;
        Deverror_record dev_record=getGson("yyyy-MM-dd").fromJson(json, Deverror_record.class);
        ServiceModel model=service.serchByInfo(dev_record);
        if(model.code == 1){
            List list = (List) model.getData();
            Blob blob = (Blob) list.get(0);
            try {
                is = blob.getBinaryStream();
                os = ActionUtil.getResponse().getOutputStream();
                byte[] image = IStoByteArr(is);
                os.write(image);
                os.flush();
            } catch (SQLException e) {
                e.printStackTrace();
            } catch (IOException e) {
                e.printStackTrace();
            } finally{
                if(os != null){
                    try {
                        os.close();
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }
            }
        }
    }
    
    public String getResult() {
        return result;
    }
    public void setJson(String json) {
        this.json = json;
    }
    public List<File> getFile() {
        return file;
    }
    public void setFile(List<File> file) {
        this.file = file;
    }
    
 
}