public bool updateWsdByHouseCode(bean.houseInfo hi)
{
int ret = 0;
String sql = "update lb_device_information set t_high='" + hi.t_high + "',t_low='" + hi.t_low + "',h_high='" + hi.h_high + "',h_low='" + hi.h_low + "',housetype='" + hi.isUsed + "',State=1 where house_code='" + hi.id + "'";
ret = DbHelperMySQL.ExecuteSql(sql);
return(ret == 0 ? false : true);
}
public bool updateWsdByHouseKong(bean.houseInfo hi)
{
int ret = 0;
String sql = "update lb_device_information set housetype='" + hi.isUsed + "' where house_code='" + hi.id + "'";
ret = DbHelperMySQL.ExecuteSql(sql);
return(ret == 0 ? false : true);
}
public bool updateHouseInfoById(bean.houseInfo hi)
{
int ret = 0;
String sql = "update lb_house_type set name='" + hi.name + "', t_high='" + hi.t_high + "', t_low='" + hi.t_low + "', h_high='" + hi.h_high + "', h_low='" + hi.h_low + "',isUsed='" + hi.isUsed + "' where id = '" + hi.id + "'";
ret = DbHelperMySQL.ExecuteSql(sql);
return(ret == 0 ? false : true);
}
public bool addHouseManage(bean.houseInfo hi)
{
int ret = 0;
string id = Result.GetNewId();
String sql = "insert into lb_house_type (id,name,t_high,t_low,h_high,h_low) values ('" + id + "','" + hi.name + "', '" + hi.t_high + "', '" + hi.t_low + "', '" + hi.h_high + "', '" + hi.h_low + "')";
ret = DbHelperMySQL.ExecuteSql(sql);
return(ret == 0 ? false : true);
}
public bool updateWsdByHouseKong(bean.houseInfo hi)
{
return(deviceinfo.updateWsdByHouseKong(hi));
}
public bool updateHouseInfoById(bean.houseInfo hi)
{
return(ht.updateHouseInfoById(hi));
}
public bool addHouseManage(bean.houseInfo hi)
{
return(ht.addHouseManage(hi));
}
