修改

81041

2019-12-03 45fa5fe74137f5774d14d2c7b59ce9ed1a1ea1d5

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
117
118
119
120
121
122
123
124
125
126
127
package com.fgkj.impl;
 
 
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
 
import com.fgkj.dao.ActionUtil;
import com.fgkj.dao.BaseDAO;
import com.fgkj.dto.Battresdata_inf;
 
import java.text.ParseException;
import java.util.ArrayList;
import java.util.List;
 
public class Battresdata_infImpl implements BaseDAO {
    //插入数据
    @Override
    public boolean add(SQLiteDatabase db, Object obj) {
        boolean bl=true;
        ContentValues cv=Battresdata_infImpl.getContentValues(obj);
        long row=db.insert("tb_batttestdata_inf",null,cv);
        if(row<0){
         bl=false;  
        }
        return bl;
    }
   //编辑数据
    @Override
    public boolean update(SQLiteDatabase db, Object obj) {
        Battresdata_inf rinf=(Battresdata_inf)obj;
        boolean bl=true;
        ContentValues cv=Battresdata_infImpl.getContentValues(obj);
        String sql="num=?";
        long row=db.update("tb_batttestdata_inf",cv,sql,new String[]{String.valueOf(rinf.getNum())});
        if(row<0){
            bl=false;
        }
        return bl;
    }
    //删除内阻测试记录
    @Override
    public boolean del(SQLiteDatabase db, Object obj) {
        Battresdata_inf rinf=(Battresdata_inf)obj;
        boolean bl=true;
        String sql="num=?";
        long row=db.delete("tb_batttestdata_inf",sql,new String[]{String.valueOf(rinf.getNum())});
        if(row<0){
            bl=false;
        }
        return bl;
    }
   //查询所有得内阻放电记录
    @Override
    public List searchAll(SQLiteDatabase db) {
        String sql=" select num,BattGroupId,test_record_count,test_type,test_starttime,record_time,group_vol,test_curr " +
                " from tb_batttestdata_inf order by num asc ";
        Cursor rs=db.rawQuery(sql,new String[]{});
        List list=new ArrayList();
        try {
            while (rs.moveToNext()){
                Battresdata_inf rinf=new Battresdata_inf();
                rinf.setNum(rs.getInt(rs.getColumnIndex("num")));
                rinf.setBattGroupId(rs.getInt(rs.getColumnIndex("BattGroupId")));
                rinf.setTest_record_count(rs.getColumnIndex("test_record_count"));
                rinf.setTest_type(rs.getInt(rs.getColumnIndex("test_type")));
                rinf.setTest_starttime(ActionUtil.sdf.parse(rs.getString(rs.getColumnIndex("test_starttime"))));
                rinf.setRecord_time(ActionUtil.sdf.parse(rs.getString(rs.getColumnIndex("record_time"))));
                rinf.setGroup_vol(rs.getFloat(rs.getColumnIndex("group_vol")));
                rinf.setTest_curr(rs.getFloat(rs.getColumnIndex("test_curr")));
                list.add(rinf);
            }
        } catch (ParseException e) {
            e.printStackTrace();
        }finally {
            rs.close();
        }
        return list;
    }
    //根据电池组id查询该电池放电记录
    @Override
    public List serchByCondition(SQLiteDatabase db, Object obj) {
        Battresdata_inf r=(Battresdata_inf)obj;
        String sql=" select num,BattGroupId,test_record_count,test_type,test_starttime,record_time,group_vol,test_curr " +
                " from tb_batttestdata_inf where BattGroupId=? order by num asc ";
        Cursor rs=db.rawQuery(sql,new String[]{String.valueOf(r.getBattGroupId())});
        List list=new ArrayList();
        try {
            while (rs.moveToNext()){
                Battresdata_inf rinf=new Battresdata_inf();
                rinf.setNum(rs.getInt(rs.getColumnIndex("num")));
                rinf.setBattGroupId(rs.getInt(rs.getColumnIndex("BattGroupId")));
                rinf.setTest_record_count(rs.getColumnIndex("test_record_count"));
                rinf.setTest_type(rs.getInt(rs.getColumnIndex("test_type")));
                rinf.setTest_starttime(ActionUtil.sdf.parse(rs.getString(rs.getColumnIndex("test_starttime"))));
                rinf.setRecord_time(ActionUtil.sdf.parse(rs.getString(rs.getColumnIndex("record_time"))));
                rinf.setGroup_vol(rs.getFloat(rs.getColumnIndex("group_vol")));
                rinf.setTest_curr(rs.getFloat(rs.getColumnIndex("test_curr")));
                list.add(rinf);
            }
        } catch (ParseException e) {
            e.printStackTrace();
        }finally {
            rs.close();
        }
        return list;
    }
 
    @Override
    public List serchByInfo(SQLiteDatabase db, Object obj) {
        return null;
    }
    //获取ContentValues
    public static ContentValues getContentValues(Object obj){
        Battresdata_inf rinf=(Battresdata_inf)obj;
        ContentValues cv=new ContentValues();
        cv.put("num",rinf.getNum());
        cv.put("BattGroupId", rinf.getBattGroupId());
        cv.put("test_record_count", rinf.getTest_record_count());
        cv.put("test_type",rinf.getTest_type());
        cv.put("test_starttime", ActionUtil.sdf.format(rinf.getTest_starttime()));
        cv.put("record_time", ActionUtil.sdf.format(rinf.getRecord_time()));
        cv.put("group_vol",rinf.getGroup_vol());
        cv.put("test_curr", rinf.getTest_curr());
        return  cv;
    }
}