/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.TABSTATUS model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("insert into TABSTATUS(");
strSql.Append("DEVICECODE,DATETIME,SENDNUM,RECVNUM,TEMPERATURE,POWERSTATUS,FREEMEMO,WATERALARM,DOORALARM,SMOGALARM,STATIONSTATUS,RESERV0,RESERV1,RESERV2,HUMI");
strSql.Append(") values (");
strSql.Append(":DEVICECODE,:DATETIME,:SENDNUM,:RECVNUM,:TEMPERATURE,:POWERSTATUS,:FREEMEMO,:WATERALARM,:DOORALARM,:SMOGALARM,,:STATIONSTATUS,:RESERV0,:RESERV1,:RESERV2,:HUMI");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":DATETIME", OracleType.DateTime),
new OracleParameter(":SENDNUM", OracleType.Number, 22),
new OracleParameter(":RECVNUM", OracleType.Number, 22),
new OracleParameter(":TEMPERATURE", OracleType.Number, 16),
new OracleParameter(":POWERSTATUS", OracleType.Number, 22),
new OracleParameter(":FREEMEMO", OracleType.Number, 22),
new OracleParameter(":WATERALARM", OracleType.Number, 22),
new OracleParameter(":DOORALARM", OracleType.Number, 22),
new OracleParameter(":SMOGALARM", OracleType.Number, 22),
//new OracleParameter(":SENSERSTATUS", OracleType.Number,22) ,
new OracleParameter(":STATIONSTATUS", OracleType.Number, 22),
new OracleParameter(":RESERV0", OracleType.Number, 16),
new OracleParameter(":RESERV1", OracleType.Number, 16),
new OracleParameter(":RESERV2", OracleType.Number, 16),
new OracleParameter(":HUMI", OracleType.Number, 22)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.DATETIME;
parameters[2].Value = model.SENDNUM;
parameters[3].Value = model.RECVNUM;
parameters[4].Value = model.TEMPERATURE;
parameters[5].Value = model.POWERSTATUS;
parameters[6].Value = model.FREEMEMO;
parameters[7].Value = model.WATERALARM;
parameters[8].Value = model.DOORALARM;
parameters[9].Value = model.SMOGALARM;
//parameters[10].Value = model.SENSERSTATUS;
parameters[11].Value = model.STATIONSTATUS;
parameters[12].Value = model.RESERV0;
parameters[13].Value = model.RESERV1;
parameters[14].Value = model.RESERV2;
parameters[15].Value = model.HUMI;
dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.TABSTATUS model)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append("update TABSTATUS set ");
strSql.Append(" DEVICECODE = :DEVICECODE , ");
strSql.Append(" DATETIME = :DATETIME , ");
strSql.Append(" SENDNUM = :SENDNUM , ");
strSql.Append(" RECVNUM = :RECVNUM , ");
strSql.Append(" TEMPERATURE = :TEMPERATURE , ");
strSql.Append(" POWERSTATUS = :POWERSTATUS , ");
strSql.Append(" FREEMEMO = :FREEMEMO , ");
strSql.Append(" WATERALARM = :WATERALARM , ");
strSql.Append(" DOORALARM = :DOORALARM , ");
strSql.Append(" SMOGALARM = :SMOGALARM , ");
//strSql.Append(" SENSERSTATUS = :SENSERSTATUS , ");
strSql.Append(" STATIONSTATUS = :STATIONSTATUS , ");
strSql.Append(" RESERV0 = :RESERV0 , ");
strSql.Append(" RESERV1 = :RESERV1 , ");
strSql.Append(" RESERV2 = :RESERV2 , ");
strSql.Append(" HUMI = :HUMI ");
strSql.Append(" where ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", OracleType.Char, 6),
new OracleParameter(":DATETIME", OracleType.DateTime),
new OracleParameter(":SENDNUM", OracleType.Number, 22),
new OracleParameter(":RECVNUM", OracleType.Number, 22),
new OracleParameter(":TEMPERATURE", OracleType.Number, 16),
new OracleParameter(":POWERSTATUS", OracleType.Number, 22),
new OracleParameter(":FREEMEMO", OracleType.Number, 22),
new OracleParameter(":WATERALARM", OracleType.Number, 22),
new OracleParameter(":DOORALARM", OracleType.Number, 22),
new OracleParameter(":SMOGALARM", OracleType.Number, 22),
//new OracleParameter(":SENSERSTATUS", OracleType.Number,22) ,
new OracleParameter(":STATIONSTATUS", OracleType.Number, 22),
new OracleParameter(":RESERV0", OracleType.Number, 16),
new OracleParameter(":RESERV1", OracleType.Number, 16),
new OracleParameter(":RESERV2", OracleType.Number, 16),
new OracleParameter(":HUMI", OracleType.Number, 22)
};
parameters[0].Value = model.DEVICECODE;
parameters[1].Value = model.DATETIME;
parameters[2].Value = model.SENDNUM;
parameters[3].Value = model.RECVNUM;
parameters[4].Value = model.TEMPERATURE;
parameters[5].Value = model.POWERSTATUS;
parameters[6].Value = model.FREEMEMO;
parameters[7].Value = model.WATERALARM;
parameters[8].Value = model.DOORALARM;
parameters[9].Value = model.SMOGALARM;
//parameters[10].Value = model.SENSERSTATUS;
parameters[11].Value = model.STATIONSTATUS;
parameters[12].Value = model.RESERV0;
parameters[13].Value = model.RESERV1;
parameters[14].Value = model.RESERV2;
parameters[15].Value = model.HUMI;
int rows = dbHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 获取岸基站的设备状态信息
/// </summary>
public Entity.TABSTATUS GetModel(string deviceCode)
{
StringBuilder strSql = new StringBuilder();
DbAPI dbHelper = new DbAPI();
strSql.Append(" SELECT DATETIME, SENDNUM, RECVNUM, TEMPERATURE, POWERSTATUS, FREEMEMO, WATERALARM, DOORALARM, SMOGALARM, STATIONSTATUS, HUMI ");
strSql.Append(" FROM TABSTATUS ");
strSql.Append(" WHERE DEVICECODE=:DEVICECODE ");
strSql.Append(" AND DATETIME=(SELECT MAX(DATETIME) DATETIME FROM TABSTATUS WHERE DEVICECODE=:DEVICECODE) ");
OracleParameter[] parameters =
{
new OracleParameter(":DEVICECODE", deviceCode)
};
try
{
dbHelper.OpenConn("");
Entity.TABSTATUS model = new Entity.TABSTATUS();
DataTable ds = dbHelper.GetDataTable(strSql.ToString(), parameters);
dbHelper.CloseConn();
if (ds.Rows.Count > 0)
{
//model.DEVICECODE = ds.Rows[0]["DEVICECODE"].ToString();
if (ds.Rows[0]["DATETIME"].ToString() != "")
{
model.DATETIME = DateTime.Parse(ds.Rows[0]["DATETIME"].ToString());
}
if (ds.Rows[0]["SENDNUM"].ToString() != "")
{
model.SENDNUM = decimal.Parse(ds.Rows[0]["SENDNUM"].ToString());
}
if (ds.Rows[0]["RECVNUM"].ToString() != "")
{
model.RECVNUM = decimal.Parse(ds.Rows[0]["RECVNUM"].ToString());
}
if (ds.Rows[0]["TEMPERATURE"].ToString() != "")
{
model.TEMPERATURE = decimal.Parse(ds.Rows[0]["TEMPERATURE"].ToString());
}
if (ds.Rows[0]["POWERSTATUS"].ToString() != "")
{
model.POWERSTATUS = decimal.Parse(ds.Rows[0]["POWERSTATUS"].ToString());
}
if (ds.Rows[0]["FREEMEMO"].ToString() != "")
{
model.FREEMEMO = decimal.Parse(ds.Rows[0]["FREEMEMO"].ToString());
}
if (ds.Rows[0]["WATERALARM"].ToString() != "")
{
model.WATERALARM = decimal.Parse(ds.Rows[0]["WATERALARM"].ToString());
}
if (ds.Rows[0]["DOORALARM"].ToString() != "")
{
model.DOORALARM = decimal.Parse(ds.Rows[0]["DOORALARM"].ToString());
}
if (ds.Rows[0]["SMOGALARM"].ToString() != "")
{
model.SMOGALARM = decimal.Parse(ds.Rows[0]["SMOGALARM"].ToString());
}
if (ds.Rows[0]["STATIONSTATUS"].ToString() != "")
{
model.STATIONSTATUS = decimal.Parse(ds.Rows[0]["STATIONSTATUS"].ToString());
}
if (ds.Rows[0]["HUMI"].ToString() != "")
{
model.HUMI = decimal.Parse(ds.Rows[0]["HUMI"].ToString());
}
return(model);
}
else
{
return(null);
}
}
catch (Exception ex)
{
LogBN.WriteLog(typeof(TABSTATUS_BN), "GetModel 程序段的异常" + ex);
return(null);
}
}
