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);
        }
예제 #2
0
 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);
     }
 }