Exemplo n.º 1
0
        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);
        }