/// <summary> /// 清空记录 /// </summary> /// <returns></returns> public int ClearAll() { string sql = "delete from UserInfo"; return(SqliteHelper.ExecuteNonQuery(sql)); }
/// <summary> /// 按ID删除设备 /// </summary> /// <param name="equipmentID"></param> /// <returns></returns> public static int DeleteByEquipmentID(long equipmentID) { string sql = string.Format("delete from tb_EquipmentData where EquipmentID={0}", equipmentID); return(SqliteHelper.ExecuteNonQuery(sql)); }
/// <summary> /// 清空 /// </summary> /// <returns></returns> public int ClearAll() { string sql = "delete from TmpBioData "; return(SqliteHelper.ExecuteNonQuery(sql)); }
public static int DeleteAll() { string sql = "delete from tb_EquipmentData"; return(SqliteHelper.ExecuteNonQuery(sql)); }
public static int DeleteByTime(long equipmentID, DateTime dt1, DateTime dt2) { string sql = string.Format("delete from tb_EquipmentData where EquipmentID={0} and AddTime >='{1}' and AddTime <='{2}'", equipmentID, dt1.ToString(), dt2.ToString()); return(SqliteHelper.ExecuteNonQuery(sql)); }
/// <summary>Update /// </summary> /// <param name="device"></param> /// <returns></returns> public int Update(DeviceModel device) { string sql = string.Format(@" update Device set TransInterval = @TransInterval , TransTimes = @TransTimes , Encrypt = @Encrypt , LastRequestTime = @LastRequestTime , DevIP = @DevIP , DevMac = @DevMac , DevFirmwareVersion = @DevFirmwareVersion , UserCount = @UserCount , AttCount = @AttCount , DevName = @DevName , TimeZone = @TimeZone , Timeout = @Timeout , SyncTime = @SyncTime , ATTLOGStamp = @ATTLOGStamp , OPERLOGStamp = @OPERLOGStamp , ATTPHOTOStamp = @ATTPHOTOStamp , ErrorDelay = @ErrorDelay , Delay = @Delay , TransFlag = @TransFlag , Realtime = @Realtime, VendorName = @VendorName, IRTempDetectionFunOn = @IRTempDetectionFunOn, MaskDetectionFunOn = @MaskDetectionFunOn, MultiBioDataSupport = @MultiBioDataSupport, MultiBioPhotoSupport = @MultiBioPhotoSupport, MultiBioVersion = @MultiBioVersion, MultiBioCount = @MultiBioCount, MaxMultiBioDataCount = @MaxMultiBioDataCount, MaxMultiBioPhotoCount = @MaxMultiBioPhotoCount where DevSN=@DevSN "); SQLiteParameter[] parameters = { new SQLiteParameter("@DevSN", device.DevSN), new SQLiteParameter("@TransInterval", device.TransInterval), new SQLiteParameter("@TransTimes", device.TransTimes), new SQLiteParameter("@Encrypt", device.Encrypt), new SQLiteParameter("@LastRequestTime", device.LastRequestTime), new SQLiteParameter("@DevIP", device.DevIP), new SQLiteParameter("@DevMac", device.DevMac), new SQLiteParameter("@DevFirmwareVersion", device.DevFirmwareVersion), new SQLiteParameter("@UserCount", device.UserCount), new SQLiteParameter("@AttCount", device.AttCount), new SQLiteParameter("@DevName", device.DevName), new SQLiteParameter("@TimeZone", device.TimeZone), new SQLiteParameter("@Timeout", device.Timeout), new SQLiteParameter("@SyncTime", device.SyncTime), new SQLiteParameter("@ATTLOGStamp", device.AttLogStamp), new SQLiteParameter("@OPERLOGStamp", device.OperLogStamp), new SQLiteParameter("@ATTPHOTOStamp", device.AttPhotoStamp), new SQLiteParameter("@ErrorDelay", device.ErrorDelay), new SQLiteParameter("@Delay", device.Delay), new SQLiteParameter("@TransFlag", device.TransFlag), new SQLiteParameter("@Realtime", device.Realtime), new SQLiteParameter("@VendorName", device.VendorName), new SQLiteParameter("@IRTempDetectionFunOn", device.IRTempDetectionFunOn), new SQLiteParameter("@MaskDetectionFunOn", device.MaskDetectionFunOn), new SQLiteParameter("@MultiBioDataSupport", device.MultiBioDataSupport), new SQLiteParameter("@MultiBioPhotoSupport", device.MultiBioPhotoSupport), new SQLiteParameter("@MultiBioVersion", device.MultiBioVersion), new SQLiteParameter("@MultiBioCount", device.MultiBioCount), new SQLiteParameter("@MaxMultiBioDataCount", device.MaxMultiBioDataCount), new SQLiteParameter("@MaxMultiBioPhotoCount", device.MaxMultiBioPhotoCount) }; return(SqliteHelper.ExecuteNonQuery(sql, parameters)); }
public static int DeleteByEqID(long eqid) { string sql = string.Format("delete from [tb_Chroma] where EquipmentID={0}", eqid); return(SqliteHelper.ExecuteNonQuery(sql)); }
public static int DeleteAll() { string sql = "delete from [tb_Chroma]"; return(SqliteHelper.ExecuteNonQuery(sql)); }