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.Alarm_param;
|
import com.fgkj.dto.Batttestdata_inf;
|
|
import java.util.ArrayList;
|
import java.util.List;
|
|
public class Alarm_paramImpl implements BaseDAO {
|
@Override
|
public boolean add(SQLiteDatabase db, Object obj) {
|
return false;
|
}
|
//修改参数根据alm——id
|
@Override
|
public boolean update(SQLiteDatabase db, Object obj) {
|
boolean bl=false;
|
Alarm_param aparam=(Alarm_param)obj;
|
ContentValues cv=Alarm_paramImpl.getContentValues(obj);
|
String sql="alm_id=?";
|
long row=db.update("tb_alarm_param",cv,sql,new String[]{String.valueOf(aparam.getAlm_id())});
|
if(row>0){
|
bl=true;
|
}else{
|
bl=false;
|
}
|
return bl;
|
}
|
|
@Override
|
public boolean del(SQLiteDatabase db, Object obj) {
|
return false;
|
}
|
//查询告警参数
|
@Override
|
public List searchAll(SQLiteDatabase db) {
|
String sql="select * from tb_alarm_param ";
|
Cursor rs=db.rawQuery(sql,null);
|
List list=new ArrayList();
|
try {
|
while (rs.moveToNext()){
|
Alarm_param aparam=new Alarm_param();
|
aparam.setNum(rs.getInt(rs.getColumnIndex("num")));
|
aparam.setAlm_id(rs.getInt(rs.getColumnIndex("alm_id")));
|
aparam.setAlm_name(rs.getString(rs.getColumnIndex("alm_name")));
|
aparam.setAlm_high_coe(rs.getDouble(rs.getColumnIndex("alm_high_coe")));
|
aparam.setAlm_low_coe(rs.getDouble(rs.getColumnIndex("alm_low_coe")));
|
aparam.setAlm_high_en(rs.getInt(rs.getColumnIndex("alm_high_en")));
|
aparam.setAlm_low_en(rs.getInt(rs.getColumnIndex("alm_low_en")));
|
list.add(aparam);
|
}
|
} catch (Exception e) {
|
e.printStackTrace();
|
}finally {
|
rs.close();
|
}
|
return null;
|
}
|
|
@Override
|
public List serchByCondition(SQLiteDatabase db, Object obj) {
|
return null;
|
}
|
|
@Override
|
public List serchByInfo(SQLiteDatabase db, Object obj) {
|
return null;
|
}
|
//获取ContentValues
|
public static ContentValues getContentValues(Object obj){
|
Alarm_param aparam=(Alarm_param)obj;
|
ContentValues cv=new ContentValues();
|
cv.put("num",aparam.getNum());
|
cv.put("alm_id",aparam.getAlm_id());
|
cv.put("alm_name",aparam.getAlm_name());
|
cv.put("alm_high_coe",aparam.getAlm_high_coe());
|
cv.put("alm_low_coe",aparam.getAlm_low_coe());
|
cv.put("alm_high_en",aparam.getAlm_high_en());
|
cv.put("alm_low_en",aparam.getAlm_low_en());
|
return cv;
|
}
|
}
|
