public static void Insert(Tb_LKCommunity_Alarm_Mod info) { Database db = DataConnect.GetConnect; string Sql = @"insert into tb_lkcommunity_alarm(ListId, DeviceId, DeviceTime, Alarm, InTime) values (:ListId, :DeviceId, :DeviceTime, :Alarm, :InTime)"; DbCommand cmd = db.GetSqlStringCommand(Sql); db.AddInParameter(cmd, ":ListId", DbType.String, info.ListId); db.AddInParameter(cmd, ":DeviceId", DbType.String, info.DeviceId); db.AddInParameter(cmd, ":DeviceTime", DbType.Date, info.DeviceTime); db.AddInParameter(cmd, ":Alarm", DbType.String, info.Alarm); db.AddInParameter(cmd, ":InTime", DbType.Date, info.InTime); db.ExecuteNonQuery(cmd); }
private void Single(byte[] content) { try { Tb_LKCommunity_Alarm_Mod info = new Tb_LKCommunity_Alarm_Mod(); info.ListId = Guid.NewGuid().ToString("N"); info.DeviceId = StationId.ToString(); info.DeviceTime = ConverUtil.Time(content, 0); info.Alarm = ConverUtil.ByteToStr_Q(content, 6, 3); info.InTime = DateTime.Now; FileManagementDal.SocialAppTerminal.Tb_LKCommunity_Alarm_Dal.Insert(info); } catch (Exception ex) { MyLibrary.Log.Error(Name + "错误:" + ex.Message + " 原始代码:" + OriginalCode); } }