/// <summary>
/// 保存二进制数值
/// </summary>
/// <param name="serialNumber">序号</param>
/// <param name="dataValue">二进制数值</param>
protected void SaveBytes(int serialNumber, byte[] dataValue)
{
AC.Base.Database.DbConnection dbConn = this.Device.Application.GetDbConnection();
if (dbConn != null)
{
try
{
System.Data.IDbDataParameter parDeviceId = (System.Data.IDbDataParameter)dbConn.GetNewDbDataParameter();
parDeviceId.ParameterName = "@" + Tables.DevicePropertyBytes.DeviceId;
parDeviceId.Value = this.Device.DeviceId;
System.Data.IDbDataParameter parPropertyType = (System.Data.IDbDataParameter)dbConn.GetNewDbDataParameter();
parPropertyType.ParameterName = "@" + Tables.DevicePropertyBytes.PropertyType;
parPropertyType.Value = Function.SqlStr(this.GetType().FullName);
System.Data.IDbDataParameter parSerialNumber = (System.Data.IDbDataParameter)dbConn.GetNewDbDataParameter();
parSerialNumber.ParameterName = "@" + Tables.DevicePropertyBytes.SerialNumber;
parSerialNumber.Value = serialNumber;
System.Data.IDbDataParameter parDataValue = (System.Data.IDbDataParameter)dbConn.GetNewDbDataParameter();
parDataValue.ParameterName = "@" + Tables.DevicePropertyBytes.DataValue;
parDataValue.Value = dataValue;
string strSql = "@" + Tables.DevicePropertyBytes.DeviceId + "," + "@" + Tables.DevicePropertyBytes.PropertyType + "," + "@" + Tables.DevicePropertyBytes.SerialNumber + "," + "@" + Tables.DevicePropertyBytes.DataValue;
strSql = "INSERT INTO " + Tables.DevicePropertyBytes.TableName + " (" + Tables.DevicePropertyBytes.DeviceId + "," + Tables.DevicePropertyBytes.PropertyType + "," + Tables.DevicePropertyBytes.SerialNumber + "," + Tables.DevicePropertyBytes.DataValue + ") VALUES (" + strSql + ")";
dbConn.ExecuteNonQuery(strSql, -1, System.Data.CommandType.Text, parDeviceId, parPropertyType, parSerialNumber, parDataValue);
}
catch (Exception ex)
{
throw ex;
}
finally
{
dbConn.Close();
}
}
}
