public void TestAnaSensorDataBLL()
{
AnaSensorDataBLL bll = new AnaSensorDataBLL(new AnaSensorDataDAL());
AnaSensorData data1 = new AnaSensorData(0, "U2SYS001AM", false, 1.2);
bll.Add(data1);
AnaSensorData data2 = new AnaSensorData();
data2.Id = 2;
bll.Delete(data2);
AnaSensorData data3 = new AnaSensorData();
data3.Id = 1;
AnaSensorData data4 = new AnaSensorData();
data4.Id = 3;
data4.Av = 1.5;
bll.Modify(data1, data4);
AnaSensorData data5 = (AnaSensorData)bll.GetObjById(1.ToString());
List <object> objs2 = bll.GetAllObjs();
string strSQL = "select * from anaSensorData";
MySqlParameter[] parms = new MySqlParameter[] {
//new MySqlParameter("","")
};
List <object> objs1 = bll.GetObjsBySQL(strSQL, parms);
}
public List <object> GetObjsBySQL(string strSQL, MySqlParameter[] parms)
{
List <object> objs = new List <object>();
MySqlDataReader reader = this.MySqlHelper.ExecuteReader(strSQL, parms);
while (reader.Read())
{
AnaSensorData anaData = new AnaSensorData();
anaData.Id = long.Parse(reader[0].ToString().Trim());
anaData.Name = reader[1].ToString().Trim();
anaData.Time = DateTime.Parse(reader[2].ToString().Trim());
if (reader[3].ToString().Trim() == "0")
{
anaData.Q = false;
}
else
{
anaData.Q = true;
}
anaData.Av = double.Parse(reader[4].ToString().Trim());
objs.Add(anaData);
}
this.mySqlHelper.CloseConn();
return(objs);
}
/// <summary>
/// 获取某个传感器的所有数据
/// </summary>
/// <param name="id">传感器名称</param>
/// <returns></returns>
public object GetObjById(string id)
{
AnaSensorData anaData = new AnaSensorData();
string cmdText = "select * from anaSensorData where id=@id";
MySqlParameter[] parms = new MySqlParameter[] { new MySqlParameter("@id", id) };
MySqlDataReader reader = this.MySqlHelper.ExecuteReader(cmdText, parms);
while (reader.Read())
{
anaData.Id = long.Parse(id);
anaData.Name = reader[1].ToString().Trim();
anaData.Time = DateTime.Parse(reader[2].ToString().Trim());
if (reader[3].ToString().Trim() == "0")
{
anaData.Q = false;
}
else
{
anaData.Q = true;
}
anaData.Av = double.Parse(reader[4].ToString().Trim());
}
this.mySqlHelper.CloseConn();
return(anaData);
}
/// <summary>
/// 删除数据库中指定传感器的数据
/// </summary>
/// <param name="obj">传感器</param>
/// <returns删除数据库中指定传感器的数据></returns>
public int Delete(object obj)
{
AnaSensorData data = (AnaSensorData)obj;
MySqlParameter[] parms = new MySqlParameter[] {
new MySqlParameter("@id", data.Id)
};
string cmdText = "delete from anaSensorData where id=@id";
return(base.MySqlHelper.ExecuteNonQuery(cmdText, parms));
}
public int Add(object obj)
{
AnaSensorData data = (AnaSensorData)obj;
MySqlParameter[] parms = new MySqlParameter[] {
new MySqlParameter("@name", data.Name),
new MySqlParameter("@q", data.Q),
new MySqlParameter("@av", data.Av)
};
string cmdText = "insert into anaSensorData (name,q,av) values(@name,@q,@av);";
return(base.MySqlHelper.ExecuteNonQuery(cmdText, parms));
}
