public bool Execute() { try { byte[] Data; Data = new byte[4]; Array.Copy(_content, 6, Data, 0, 4); string SoftVersion = Version(Data); Data = new byte[4]; Array.Copy(_content, 10, Data, 0, 4); string HardwareVersion = Version(Data); Tb_LKCommunity_Mod info = new Tb_LKCommunity_Mod(); info.DeviceTime = ConverUtil.Time(_content, 0); //设备时间。 info.LastUpdateTime = DateTime.Now; //最后更新时间。 info.DeviceId = StationId.ToString(); //设备Id。 info.SoftVersion = SoftVersion; //软件版本号。 info.HardwareVersion = HardwareVersion; //硬件版本号。 info.Signal = _content[14].ToString(); //信号强度。 FileManagementDal.SocialAppTerminal.Tb_LKCommunity_Dal.Update(info); } catch (Exception ex) { MyLibrary.Log.Error(Name + "出错:" + ex.Message + " 原始代码:" + OriginalCode); } return(true); }
public static void Update(Tb_LKCommunity_Mod info) { Database db = DataConnect.GetConnect; string Sql = @"Update Tb_LKCommunity set DeviceTime= :DeviceTime, LastUpdateTime= :LastUpdateTime, SoftVersion=:SoftVersion, HardwareVersion=:HardwareVersion , Signal=:Signal where DeviceId=:DeviceId"; DbCommand cmd = db.GetSqlStringCommand(Sql); db.AddInParameter(cmd, ":DeviceTime", DbType.Date, info.DeviceTime); db.AddInParameter(cmd, ":LastUpdateTime", DbType.Date, info.LastUpdateTime); db.AddInParameter(cmd, ":SoftVersion", DbType.String, info.SoftVersion); db.AddInParameter(cmd, ":HardwareVersion", DbType.String, info.HardwareVersion); db.AddInParameter(cmd, ":Signal", DbType.String, info.Signal); db.AddInParameter(cmd, ":DeviceId", DbType.String, info.DeviceId); db.ExecuteNonQuery(cmd); }