2025/5/22 8:40:13:System.UnauthorizedAccessException: 对路径“find.mp4”的访问被拒绝。
   在 System.IO.Directory.DeleteHelper(String fullPath, String userPath, Boolean recursive, Boolean throwOnTopLevelDirectoryNotFound, WIN32_FIND_DATA& data)
   在 System.IO.Directory.Delete(String fullPath, String userPath, Boolean recursive, Boolean checkHost)
   在 Thinkrace.FilesServices.FilesServer.DeleteFiles()

2025/5/22 10:10:12:创建历史数据库失败，sql：\r\nuse master
declare @year int,@nyear int,@mon int,@mm varchar(2),@nmm varchar(2)
set @year=DatePart(YEAR,GETDATE())
set @nyear=@year
set @mon=DatePart(MONTH,GETDATE())
if(@mon<10) BEGIN
	set @mm='0'+CONVERT(varchar,@mon)
END ELSE BEGIN
	set @mm=CONVERT(varchar,@mon)
END
if(@mon=12) BEGIN
	set @nyear=@year+1
	set @nmm='01'
END ELSE BEGIN
	set @nyear=@year
	if(@mon<9)
	Begin
		set @nmm='0'+CONVERT(varchar,(@mon+1))
	END ELSE BEGIN
		set @nmm=CONVERT(varchar,(@mon+1))
	END
END

/*当前数据库名*/
declare @ldbname varchar(200)= 'BHVData'+CONVERT(varchar,@nyear)+@nmm
declare @fi varchar(200)
declare @file varchar(200)
declare @v_sql nvarchar(max)
	if not exists(select * from master.dbo.sysdatabases where name =@ldbname)
	Begin
		
		set @v_sql='CREATE DATABASE '+ @ldbname
		EXEC SP_EXECUTESQL @v_sql
		IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
		begin
			set @v_sql = '['+@ldbname+']'+'.[dbo].[sp_fulltext_database] @action =''enable'''
			EXEC SP_EXECUTESQL @v_sql
		end
		set @v_sql ='ALTER DATABASE ['+@ldbname+'] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
			ALTER database ['+@ldbname+'] collate Chinese_PRC_CI_AS
			ALTER DATABASE ['+@ldbname+'] SET MULTI_USER
			ALTER DATABASE ['+@ldbname+'] SET ANSI_NULL_DEFAULT OFF 
			ALTER DATABASE ['+@ldbname+'] SET ANSI_NULLS OFF 
			ALTER DATABASE ['+@ldbname+'] SET ANSI_PADDING OFF 
			ALTER DATABASE ['+@ldbname+'] SET ANSI_WARNINGS OFF 
			ALTER DATABASE ['+@ldbname+'] SET ARITHABORT OFF 
			ALTER DATABASE ['+@ldbname+'] SET AUTO_CLOSE OFF 
			ALTER DATABASE ['+@ldbname+'] SET AUTO_SHRINK OFF 
			ALTER DATABASE ['+@ldbname+'] SET AUTO_UPDATE_STATISTICS ON 
			ALTER DATABASE ['+@ldbname+'] SET CURSOR_CLOSE_ON_COMMIT OFF 
			ALTER DATABASE ['+@ldbname+'] SET CURSOR_DEFAULT GLOBAL 
			ALTER DATABASE ['+@ldbname+'] SET CONCAT_NULL_YIELDS_NULL OFF 
			ALTER DATABASE ['+@ldbname+'] SET NUMERIC_ROUNDABORT OFF 
			ALTER DATABASE ['+@ldbname+'] SET QUOTED_IDENTIFIER OFF 
			ALTER DATABASE ['+@ldbname+'] SET RECURSIVE_TRIGGERS OFF 
			ALTER DATABASE ['+@ldbname+'] SET  DISABLE_BROKER 
			ALTER DATABASE ['+@ldbname+'] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
			ALTER DATABASE ['+@ldbname+'] SET DATE_CORRELATION_OPTIMIZATION OFF 
			ALTER DATABASE ['+@ldbname+'] SET TRUSTWORTHY OFF 
			ALTER DATABASE ['+@ldbname+'] SET ALLOW_SNAPSHOT_ISOLATION OFF 
			ALTER DATABASE ['+@ldbname+'] SET PARAMETERIZATION SIMPLE 
			ALTER DATABASE ['+@ldbname+'] SET READ_COMMITTED_SNAPSHOT OFF 
			ALTER DATABASE ['+@ldbname+'] SET HONOR_BROKER_PRIORITY OFF 
			ALTER DATABASE ['+@ldbname+'] SET RECOVERY SIMPLE 
			ALTER DATABASE ['+@ldbname+'] SET MULTI_USER 
			ALTER DATABASE ['+@ldbname+'] SET PAGE_VERIFY CHECKSUM  
			ALTER DATABASE ['+@ldbname+'] SET DB_CHAINING OFF 
			ALTER DATABASE ['+@ldbname+'] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 
			ALTER DATABASE ['+@ldbname+'] SET TARGET_RECOVERY_TIME = 0 SECONDS '
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql
		set @v_sql='sys.sp_db_vardecimal_storage_format N'''+@ldbname+''', N''ON'''
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[ZLocation]    Script Date: 2018/7/11 16:00:00 ******/
		declare @i int 
		set @i=0 
		while @i<1000 
		begin 
			declare @tn varchar(3)
			if(@i<10)
			begin
				set @tn='00'+convert(varchar,@i)
			end 
			else if(@i>=10 And @i<100)
			begin
				set @tn='0'+convert(varchar,@i)
			end 
			else begin
				set @tn=convert(varchar,@i)
			end
			set @v_sql='Use '+@ldbname+' 
				SET ANSI_NULLS ON
				SET QUOTED_IDENTIFIER ON
				CREATE TABLE [dbo].[ZLocation_'+@tn+'](
				[LocationID] [int] IDENTITY(1,1) NOT NULL,
				[DeviceID] [int] NULL,
				[DeviceUTCTime] [datetime] NULL,
				[IsValid] [bit] NULL,
				[Latitude] [decimal](9, 6) NULL,
				[Longitude] [decimal](9, 6) NULL,
				[BaiduLat] [decimal](9, 6) NULL,
				[BaiduLng] [decimal](9, 6) NULL,
				[OLat] [decimal](9, 6) NULL,
				[OLng] [decimal](9, 6) NULL,
				[Address] [nvarchar](500) NULL,
				[Speed] [decimal](10, 2) NULL,
				[Course] [decimal](5, 0) NULL,
				[IPAddress] [nvarchar](30) NULL,
				[PhoneNumber] [nvarchar](20) NULL,
				[ServerUtcTime] [datetime] NULL,
				[ServerTime] [datetime] NULL,
				[DataType] [int] NULL,
				[DataContext] [nvarchar](500) NULL,
				[ObjectType] [int] NULL,
				[ObjectID] [int] NULL,
				[MCC] [int] NULL,
				[MNC] [int] NULL,
				[LAC] [int] NULL,
				[CellID] [int] NULL,
				[Distance] [float] NULL,
				[IsStop] [int] NULL,
				[SerialNumber] [nvarchar](20) NULL,
				[Local] [nvarchar](100) NULL,
				CONSTRAINT [ZLocation_'+@tn+'_PK] PRIMARY KEY CLUSTERED 
				(
					[LocationID] ASC
				)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
				) ON [PRIMARY] '
			EXEC SP_EXECUTESQL @v_sql
			set @v_sql='Use '+@ldbname+'
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_OLat]  DEFAULT ((0)) FOR [OLat]
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_OLng]  DEFAULT ((0)) FOR [OLng]
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_DataType]  DEFAULT ((1)) FOR [DataType]
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_DataContext]  DEFAULT ('''') FOR [DataContext]
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_ObjectType]  DEFAULT ((0)) FOR [ObjectType]
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_ObjectID]  DEFAULT ((0)) FOR [ObjectID]
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_MCC]  DEFAULT ('''') FOR [MCC]
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_MNC]  DEFAULT ('''') FOR [MNC]
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_LAC]  DEFAULT ('''') FOR [LAC] 
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_CellID]  DEFAULT ('''') FOR [CellID]
				ALTER TABLE [dbo].[ZLocation_'+@tn+'] ADD  CONSTRAINT [DF_ZLocation_'+@tn+'_IsStop]  DEFAULT ((0)) FOR [IsStop]'
			EXEC SP_EXECUTESQL @v_sql
			print 'ZLocation_'+@tn+' 创建成功!'
			set @i=@i+1
		end

		/****** Object:  Table [dbo].[ZOil]    Script Date: 2018/7/11 16:00:00 ******/
		set @i=0
		while @i<10
		begin
			set @tn=convert(varchar,@i)
			set @v_sql='Use '+@ldbname+' 
				SET ANSI_NULLS ON
				SET QUOTED_IDENTIFIER ON
				CREATE TABLE [dbo].[ZOil_'+@tn+'](
				[OilID] [int] IDENTITY(1,1) NOT NULL,
				[SerialNumber] [varchar](20) NULL,
				[DeviceUTCTime] [datetime] NULL,
				[ServerUtcTime] [datetime] NULL,
				[ServerTime] [datetime] NULL,
				[OLat] [decimal](9, 6) NULL,
				[OLng] [decimal](9, 6) NULL,
				[Speed] [decimal](7, 2) NULL,
				[Course] [decimal](5, 0) NULL,
				[DataType] [int] NULL,
				[IsStop] [int] NULL,
				[DataContext] [varchar](500) NULL,
				[OUnitValeOil] [decimal](5, 2) NULL,
				[UnitValeOil] [decimal](5, 2) NULL,
				CONSTRAINT [ZOil_'+@tn+'_PK] PRIMARY KEY CLUSTERED 
				(
					[OilID] ASC
				)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
				) ON [PRIMARY]'
			EXEC SP_EXECUTESQL @v_sql
			set @v_sql='Use '+@ldbname+' 
				ALTER TABLE [dbo].[ZOil_'+@tn+'] ADD  CONSTRAINT [DF_ZOil_'+@tn+'_OLat]  DEFAULT ((0)) FOR [OLat]
				ALTER TABLE [dbo].[ZOil_'+@tn+'] ADD  CONSTRAINT [DF_ZOil_'+@tn+'_OLng]  DEFAULT ((0)) FOR [OLng]
				ALTER TABLE [dbo].[ZOil_'+@tn+'] ADD  CONSTRAINT [DF_ZOil_'+@tn+'_DataType]  DEFAULT ((1)) FOR [DataType]
				ALTER TABLE [dbo].[ZOil_'+@tn+'] ADD  CONSTRAINT [DF_ZOil_'+@tn+'_IsStop]  DEFAULT ((0)) FOR [IsStop]
				ALTER TABLE [dbo].[ZOil_'+@tn+'] ADD  CONSTRAINT [DF_ZOil_'+@tn+'_DataContext]  DEFAULT ('''') FOR [DataContext] '
			EXEC SP_EXECUTESQL @v_sql
			print 'ZOil_'+@tn+' 创建成功!'
			set @i=@i+1
		end

		/****** Object:  Table [dbo].[IndoorPosition]    Script Date: 2018/7/11 16:00:00 ******/
		set @i=0
		while @i<10
		begin
			set @tn=convert(varchar,@i)
			set @v_sql='Use '+@ldbname+' 
				SET ANSI_NULLS ON
				SET QUOTED_IDENTIFIER ON
				CREATE TABLE [IndoorPosition_'+@tn+'](
					IMEI NVARCHAR(20) NOT NULL,
					DeviceUtcTime DATETIME NOT NULL,
					RoomName NVARCHAR(50),
					BuildingId INT,
					FloorId INT,
					BeaconMac NVARCHAR(32),
					PositionX BIGINT,
					PositionY BIGINT,
					CONSTRAINT PK_IndoorPosition_'+@tn+' PRIMARY KEY CLUSTERED (IMEI ASC ,DeviceUtcTime ASC ) ON [PRIMARY] 
				) ON [PRIMARY]'
			EXEC SP_EXECUTESQL @v_sql
			print 'IndoorPosition_'+@tn+' 创建成功!'
			set @i=@i+1
		end

		/****** Object:  Table [dbo].[Acc]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
			SET ANSI_NULLS ON
			SET QUOTED_IDENTIFIER ON
			CREATE TABLE [dbo].[Acc](
				[AccId] [int] IDENTITY(1,1) NOT NULL,
				[SerialNumber] [nvarchar](50) NOT NULL,
				[DeviceID] [int] NOT NULL,
				[StratTime] [datetime] NOT NULL,
				[OverTime] [datetime] NULL,
				[CreateTime] [datetime] NULL,
				[Status] [bit] NULL
			) ON [PRIMARY] '
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql
		set @v_sql='Use '+@ldbname+'
			ALTER TABLE [dbo].[Acc] ADD  CONSTRAINT [DF__Acc__CreateTime__1A14E395]  DEFAULT (getdate()) FOR [CreateTime]
			ALTER TABLE [dbo].[Acc] ADD  CONSTRAINT [DF__Acc__Status__1B0907CE]  DEFAULT ((0)) FOR [Status]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[CarCommandQueue]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
			SET ANSI_NULLS ON
			SET QUOTED_IDENTIFIER ON
			CREATE TABLE [dbo].[CarCommandQueue](
				[Id] [uniqueidentifier] NOT NULL,
				[SerialNumber] [varchar](20) NOT NULL,
				[Seq] [nvarchar](32) NULL,
				[CommandName] [nvarchar](32) NOT NULL,
				[CommandText] [nvarchar](500) NOT NULL,
				[CreateDate] [datetime] NOT NULL,
				[IsSend] [bit] NOT NULL,
				[SendDate] [datetime] NOT NULL,
				[IsResponse] [bit] NULL,
				[ResponseDate] [datetime] NULL,
				[ResponseText] [nvarchar](500) NULL,
				[IsOfflineSend] [bit] NULL,
				[Infos] [nvarchar](500) NULL,
				[Times] [int] NULL,
			 CONSTRAINT [PK_CarCommandQueue] PRIMARY KEY CLUSTERED 
			(
				[Id] ASC
			)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
			) ON [PRIMARY] '
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql
		set @v_sql='Use '+@ldbname+'
			ALTER TABLE [dbo].[CarCommandQueue] ADD  CONSTRAINT [DF__CarComman__IsSen__1DE57479]  DEFAULT ((0)) FOR [IsSend]
			ALTER TABLE [dbo].[CarCommandQueue] ADD  CONSTRAINT [DF__CarComman__SendD__1ED998B2]  DEFAULT (getdate()) FOR [SendDate]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[DanceHistory]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
			SET ANSI_NULLS ON
			SET QUOTED_IDENTIFIER ON
			CREATE TABLE [dbo].[DanceHistory](
				[Id] [int] IDENTITY(1,1) NOT NULL,
				[Imei] [varchar](20) NULL,
				[Up] [int] NULL,
				[Down] [int] NULL,
				[Left] [int] NULL,
				[Right] [int] NULL,
				[DataNum] [int] NULL,
				[DataState] [int] NULL,
				[IsCalculate] [bit] NULL,
				[CreateTime] [datetime] NULL,
			 CONSTRAINT [PK_DanceHistory] PRIMARY KEY CLUSTERED 
			(
				[Id] ASC
			)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
			) ON [PRIMARY] '
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[DanceStateHistory]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
			SET ANSI_NULLS ON
			SET QUOTED_IDENTIFIER ON
			CREATE TABLE [dbo].[DanceStateHistory](
				[Id] [int] IDENTITY(1,1) NOT NULL,
				[Imei] [varchar](20) NULL,
				[Up] [int] NULL,
				[Down] [int] NULL,
				[Left] [int] NULL,
				[Right] [int] NULL,
				[ContrastUp] [decimal](7, 3) NULL,
				[ContrastDown] [decimal](7, 3) NULL,
				[ContrastLeft] [decimal](7, 3) NULL,
				[ContrastRight] [decimal](7, 3) NULL,
				[ContrastTotal] [decimal](7, 3) NULL,
				[CreateTime] [datetime] NULL,
			 CONSTRAINT [PK_DanceHStateistory] PRIMARY KEY CLUSTERED 
			(
				[Id] ASC
			)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
			) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[DevicesReport]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[DevicesReport](
			[ID] [int] IDENTITY(1,1) NOT NULL,
			[DeviceID] [int] NOT NULL,
			[UserID] [int] NULL,
			[DeviceName] [nvarchar](100) NULL,
			[ModelName] [nvarchar](50) NULL,
			[NowDistance] [decimal](10, 2) NULL,
			[AllDistance] [decimal](10, 2) NULL,
			[WarnCount] [int] NULL,
			[SpeedLimitCount] [int] NULL,
			[StopCount] [int] NULL,
			[SerialNumber] [nvarchar](20) NULL,
			[CreateTime] [datetime] NULL,
			[UpdateTime] [datetime] NULL,
			[Type] [int] NULL,
		 CONSTRAINT [PK__DevicesR__3214EC270EA330E9] PRIMARY KEY CLUSTERED 
		(
			[ID] ASC
		)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql
		set @v_sql='Use '+@ldbname+'
			ALTER TABLE [dbo].[DevicesReport] ADD  CONSTRAINT [DF__DevicesRe__WarnC__108B795B]  DEFAULT ((0)) FOR [WarnCount]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[ExceptionMessage]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[ExceptionMessage](
			[ExceptionID] [int] IDENTITY(1,1) NOT NULL,
			[SerialNumber] [varchar](20) NULL,
			[NotificationType] [int] NULL,
			[Message] [nvarchar](50) NULL,
			[Created] [datetime] NULL,
			[Deleted] [bit] NULL,
			[ClearDate] [datetime] NULL,
			[ClearBy] [int] NULL,
			[DeviceUTCTime] [datetime] NULL,
			[OLat] [decimal](18, 15) NULL,
			[OLng] [decimal](18, 15) NULL,
			[BaiduLat] [decimal](18, 15) NULL,
			[BaiduLng] [decimal](18, 15) NULL,
			[Lat] [decimal](18, 15) NULL,
			[Lng] [decimal](18, 15) NULL,
			[DataType] [int] NULL,
			[Note] [nvarchar](100) NULL,
			[GeoFenceID] [int] NULL,
			[GeoFenceName] [varchar](100) NULL,
			[DeviceFenceNo] [int] NULL,
			[Power] [int] NULL,
			[Address] [nvarchar](250) NULL,
			[AccON] [bit] NULL,
			[EngineON] [bit] NULL,
			[OtherStatus] [nvarchar](50) NULL,
			[GSM] [int] NULL,
			[SerialNo] [int] NULL,
		 CONSTRAINT [PK_ExceptionMessage] PRIMARY KEY CLUSTERED 
		(
			[ExceptionID] ASC
		)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
		) ON [PRIMARY] '
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql
		set @v_sql='Use '+@ldbname+'
			ALTER TABLE [dbo].[ExceptionMessage] ADD  CONSTRAINT [DF__Exception__Delet__0BC6C43E]  DEFAULT ((0)) FOR [Deleted]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[Health]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[Health](
			[ID] [int] IDENTITY(1,1) NOT NULL,
			[IMEI] [varchar](20) NOT NULL,
			[Steps] [int] NULL,
			[Roll] [int] NULL,
			[Heartbeat] [int] NULL,
			[BloodPressure] [decimal](5, 2) NULL,
			[BodyTtemperature] [decimal](3, 1) NULL,
			[LastUpdate] [datetime] NULL,
			[Diastolic] [decimal](5, 2) NULL,
			[Shrink] [decimal](5, 2) NULL,
			[BloodSugar] [decimal](3, 1) NULL,
			[Distance] [decimal](5, 2) NULL,
			[Calorie] [decimal](5, 2) NULL,
		 CONSTRAINT [PK_Health] PRIMARY KEY CLUSTERED 
		(
			[ID] ASC
		)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql


		/****** Object:  Table [dbo].[HealthBloodSugar]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[HealthBloodSugar](
			[Imei] [varchar](30) NOT NULL,
			[BloodSugar] [decimal](5, 2) NULL,
			[BloodsugarType] [int] DEFAULT 3,
			[Type] [CHAR](1)   DEFAULT ''0'',
			[LastUpdate] [datetime] NULL
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[HealthSleep]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[HealthSleep](
			Id BIGINT NOT NULL IDENTITY(1,1),
			IMEI VARCHAR(32),
			Breath INT,
			Heartbeat INT,
			Wet BIT,
			Odor INT,
			Onbed NVARCHAR(32),
			PHead INT,
			PLeg INT,
			SleepStatus INT,
			Created DATETIME,
			CONSTRAINT PK_HealthSleep PRIMARY KEY CLUSTERED (Id ASC ) ON [PRIMARY] 
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[HealthBlood]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[HealthBlood](
			[Imei] [varchar](30) NOT NULL,
			[Diastolic] [decimal](7, 2) NULL,
			[Shrink] [decimal](7, 2) NULL,
			[Type] [CHAR](1)   DEFAULT ''0'',
			[LastUpdate] [datetime] NULL
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[HealthHeart]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[HealthHeart](
			[Imei] [varchar](30) NOT NULL,
			[Heartbeat] [int] NULL,
			[Type] [CHAR](1)   DEFAULT ''0'',
			[LastUpdate] [datetime] NULL
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

        /****** Object:  Table [dbo].[HealthTemperature]    Script Date: 2020/05/18 10:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[HealthTemperature](
			[Imei] [varchar](30) NOT NULL,
			[Temperature] [decimal](5, 2) NULL,
			[Temperature2] [decimal](5, 2) NULL,
			[LastUpdate] [datetime] NULL
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql
		
		
		 /****** Object:  Table [dbo].[HealthBloodOxygen]    Script Date: 2020/05/18 10:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[HealthBloodOxygen](
			[Imei] [varchar](30) NOT NULL,
			[BloodOxygen] [int] NULL,
			[LastUpdate] [datetime] NULL
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql
		
		 /****** Object:  Table [dbo].[HealthSleepCount]    Script Date: 2020/05/18 10:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[HealthSleepCount](
			[IMEI] [varchar](30) NOT NULL,
			[DeepSleep] [int] NULL,
			[LightSleep] [int] NULL,
			[Sober] [int] NULL,
			[QuickRotation] [int] NULL,
			[LastUpdate] [datetime] NULL,
			[ServerTime] [datetime] NULL,
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql
		
		/****** Object:  Table [dbo].[HealthStep]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[HealthStep](
			[Imei] [varchar](30) NOT NULL,
			[Step] [int] NULL,
			[Type] [CHAR](1)   DEFAULT ''0'',
			[LastUpdate] [datetime] NULL
		) ON [PRIMARY] '
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[Ids]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[Ids](
			[ID] [int] NULL,
			[IMEI] [varchar](20) NOT NULL
		) ON [PRIMARY] '
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[JxSleep]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[JxSleep](
			[Id] [int] IDENTITY(1,1) NOT NULL,
			[Imei] [varchar](20) NULL,
			[DataType] [int] NULL,
			[DeviceTime] [datetime] NULL,
			[HeartRate] [int] NULL,
			[RespirationRate] [int] NULL,
			[Roll] [int] NULL,
			[InBad] [bit] NULL,
			[Created] [datetime] NULL,
		 CONSTRAINT [PK_JxSleep] PRIMARY KEY CLUSTERED 
		(
			[Id] ASC
		)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[OBDDriving]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
			SET ANSI_NULLS ON
			SET QUOTED_IDENTIFIER ON
			CREATE TABLE [dbo].[OBDDriving](
				[Id] [int] IDENTITY(1,1) NOT NULL,
				[IMEI] [varchar](20) NULL,
				[CreateTime] [datetime] NULL,
				[EventType] [int] NULL,
				[Olat] [decimal](9, 6) NULL,
				[Olng] [decimal](9, 6) NULL,
				[Address] [varchar](200) NULL,
			 CONSTRAINT [PK_OBDDriving] PRIMARY KEY CLUSTERED 
			(
				[Id] ASC
			)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
			) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[ObdFailure]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[ObdFailure](
			[Id] [int] IDENTITY(1,1) NOT NULL,
			[Imei] [varchar](20) NULL,
			[Life] [int] NULL,
			[Idling] [int] NULL,
			[Cooling] [int] NULL,
			[Discharge] [int] NULL,
			[Valve] [int] NULL,
			[Circuit] [int] NULL,
			[Engine] [int] NULL,
			[Score] [int] NULL,
			[CreateTime] [datetime] NULL,
		 CONSTRAINT [PK_ObdFailure] PRIMARY KEY CLUSTERED 
		(
			[Id] ASC
		)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[OBDFault]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
			SET ANSI_NULLS ON
			SET QUOTED_IDENTIFIER ON
			CREATE TABLE [dbo].[OBDFault](
				[Id] [int] IDENTITY(1,1) NOT NULL,
				[IMEI] [varchar](20) NULL,
				[CreateTime] [datetime] NULL,
				[DeviceUtcTime] [datetime] NULL,
				[Deleted] [bit] NULL,
				[FaultType] [int] NULL,
				[FaultCode] [varchar](10) NULL,
				[FaultText] [varchar](50) NULL,
				[FaultDetail] [varchar](500) NULL,
			 CONSTRAINT [PK_OBDFault] PRIMARY KEY CLUSTERED 
			(
				[Id] ASC
			)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
			) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[OBDRecord]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
			SET ANSI_NULLS ON
			SET QUOTED_IDENTIFIER ON
			CREATE TABLE [dbo].[OBDRecord](
				[Id] [int] IDENTITY(1,1) NOT NULL,
				[IMEI] [varchar](20) NULL,
				[CreateTime] [datetime] NULL,
				[DeviceUtcTime] [datetime] NULL,
				[Rpm] [int] NULL,
				[Speed] [int] NULL,
				[WaterTemp] [int] NULL,
				[Fuel] [decimal](5, 2) NULL,
				[Load] [decimal](5, 2) NULL,
				[RunTime] [int] NULL,
				[Distance] [decimal](9, 2) NULL,
				[CoolantTemp] [int] NULL,
				[IntakeTemp] [int] NULL,
				[IntakePressue] [int] NULL,
				[Voltage] [decimal](5, 2) NULL,
				[Acc] [int] NULL,
				[fuelTrim] [decimal](5, 2) NULL,
				[IgnitionAngle] [decimal](5, 2) NULL,
				[AirFlow] [decimal](9, 2) NULL,
				[FaultDistance] [decimal](9, 2) NULL,
				[FaultTime] [int] NULL,
				[Throttle] [int] NULL,
				[HundredFuel] [decimal](9, 2) NULL,
				[RemainingOil] [decimal](5, 2) NULL,
				[OLat] [decimal](9, 6) NULL,
				[OLng] [decimal](9, 6) NULL,
				[Course] [int] NULL,
				[SerialNo] [int] NULL,
				[FuelPressure] [decimal](9, 2) NULL,
				[Air_Fuel] [decimal](9, 2) NULL,
				[RelativeThrottle] [decimal](9, 2) NULL,
			 CONSTRAINT [PK__OBDRecor__3214EC0721B6055D] PRIMARY KEY CLUSTERED 
			(
				[Id] ASC
			)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
			) ON [PRIMARY] '
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[OBDTravel]    SScript Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[OBDTravel](
			[Id] [int] IDENTITY(1,1) NOT NULL,
			[IMEI] [varchar](20) NULL,
			[BeginTime] [datetime] NULL,
			[EndTime] [datetime] NULL,
			[TravelTime] [int] NULL,
			[Distance] [decimal](9, 2) NULL,
			[FuelLv] [decimal](9, 2) NULL,
			[FuelCosts] [decimal](5, 2) NULL,
			[HundredFuelLv] [decimal](5, 2) NULL,
			[AvgSpeed] [int] NULL,
			[AvgWaterTemp] [int] NULL,
			[AvgLoading] [decimal](5, 2) NULL,
			[CreateTime] [datetime] NULL,
			[FormOLat] [decimal](9, 6) NULL,
			[FormOLng] [decimal](9, 6) NULL,
			[FormAddress] [varchar](200) NULL,
			[ToOLat] [decimal](9, 6) NULL,
			[ToOLng] [decimal](9, 6) NULL,
			[ToAddress] [varchar](200) NULL,
			[FastSpeedUp] [int] NULL,
			[FastSlowDown] [int] NULL,
			[FastCornering] [int] NULL,
			[MaxSpeed] [int] NULL,
			[MaxRpm] [int] NULL,
			[CardID] [varchar](30) NULL,
			[Overspeed] [int] NULL,
			[TiredDrive] [int] NULL,
			[FuelConsumption] [decimal](5, 2) NULL,
			[Stops] [int] NULL,
			[Idles] [int] NULL,
			[TripType] [int] NULL,
			[Passengers] [int] NULL,
			[DataContext] [varchar](500) NULL,
			[TripID] [nvarchar](50) NULL,
			[Coolant_temp] [decimal](5, 2) NULL,
			[FastAccelerate] [int] NULL,
			[SpeedingTime] [int] NULL,
			[SpeedingMileage] [decimal](9, 2) NULL,
			[SpeedingOil] [decimal](9, 2) NULL,
			[HighSpeedingTime] [int] NULL,
			[HighSpeedingMileage] [decimal](9, 2) NULL,
			[HighSpeedingOil] [decimal](9, 2) NULL,
			[MediumSpeedingTime] [int] NULL,
			[MediumSpeedingMileage] [decimal](9, 2) NULL,
			[MediumSpeedingOil] [decimal](9, 2) NULL,
			[LowSpeedingTime] [int] NULL,
			[LowSpeedingMileage] [decimal](9, 2) NULL,
			[LowSpeedingOil] [decimal](9, 2) NULL,
			[IdlingTime] [int] NULL,
			[IdlingOil] [decimal](9, 2) NULL,
			[HeatingTime] [int] NULL,
			[FastLaneChanging] [int] NULL,
			[UrgentRefueling] [int] NULL,
		 CONSTRAINT [PK_Obd] PRIMARY KEY CLUSTERED 
		(
			[Id] ASC
		)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
		) ON [PRIMARY] '
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[Sleep]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[Sleep](
			[IMEI] [varchar](20) NOT NULL,
			[StartTime] [datetime] NULL,
			[EndTime] [datetime] NULL,
			[TotalSec] [int] NULL,
			[DeepSleepSec] [int] NULL,
			[LightSleepSec] [int] NULL,
			[Roll] [int] NULL,
			[Wake] [int] NULL,
			[LastUpdated] [datetime] NULL,
			[Id] [int] IDENTITY(1,1) NOT NULL,
			[Quality] [int] NULL,
			[SleepInfo] [varchar](500) NULL,
			[EyeMoveSec] [int] NULL,
		 CONSTRAINT [PK_Sleep] PRIMARY KEY CLUSTERED 
		(
			[Id] ASC
		)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
		) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[SpeedReport]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
		SET ANSI_NULLS ON
		SET QUOTED_IDENTIFIER ON
		CREATE TABLE [dbo].[SpeedReport](
			[SID] [int] IDENTITY(1,1) NOT NULL,
			[DeviceID] [int] NULL,
			[SerialNumber] [nvarchar](20) NULL,
			[TypeID] [int] NULL,
			[StartTime] [datetime] NULL,
			[EndTime] [datetime] NULL,
			[CreateTime] [datetime] NULL,
			[OLat] [decimal](9, 6) NULL,
			[OLng] [decimal](9, 6) NULL,
			[Latitude] [decimal](9, 6) NULL,
			[Longitude] [decimal](9, 6) NULL,
			[Address] [nvarchar](500) NULL,
			[UpdateTime] [datetime] NULL,
			[Status] [bit] NULL,
			[TimediffMinute] [float] NULL,
			[SpeedLimit] [decimal](18, 2) NULL,
		 CONSTRAINT [PK__SpeedRep__CA1959701367E606] PRIMARY KEY CLUSTERED 
		(
			[SID] ASC
		)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
		) ON [PRIMARY] '
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		/****** Object:  Table [dbo].[TravelReport]    Script Date: 2018/7/11 16:00:00 ******/
		set @v_sql='Use '+@ldbname+'
			SET ANSI_NULLS ON
			SET QUOTED_IDENTIFIER ON
			CREATE TABLE [dbo].[TravelReport](
				[SID] [int] IDENTITY(1,1) NOT NULL,
				[DeviceID] [int] NULL,
				[SerialNumber] [nvarchar](20) NULL,
				[TypeID] [int] NULL,
				[StartTime] [datetime] NULL,
				[EndTime] [datetime] NULL,
				[CreateTime] [datetime] NULL,
				[OLat1] [decimal](9, 6) NULL,
				[OLng1] [decimal](9, 6) NULL,
				[Latitude1] [decimal](9, 6) NULL,
				[Longitude1] [decimal](9, 6) NULL,
				[Address1] [nvarchar](500) NULL,
				[OLat2] [decimal](9, 6) NULL,
				[OLng2] [decimal](9, 6) NULL,
				[Latitude2] [decimal](9, 6) NULL,
				[Longitude2] [decimal](9, 6) NULL,
				[Address2] [nvarchar](500) NULL,
				[UpdateTime] [datetime] NULL,
				[Status] [bit] NULL,
				[TimediffMinute] [float] NULL,
				[Distance] [decimal](18, 2) NULL,
				[AvgSpeed] [decimal](18, 2) NULL,
				[MaxSpeed] [decimal](18, 2) NULL,
				[MinSpeed] [decimal](18, 2) NULL,
			 CONSTRAINT [PK__TravelRe__CA195970173876EA] PRIMARY KEY CLUSTERED 
			(
				[SID] ASC
			)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
			) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql

		set @v_sql='Use '+@ldbname+'
			SET ANSI_NULLS ON
			SET QUOTED_IDENTIFIER ON
			CREATE TABLE [dbo].[WIFIQueue] (
				[Id] INT IDENTITY ( 1, 1 ) NOT NULL,
				[IMEI] VARCHAR ( 50 ) COLLATE Chinese_PRC_CI_AS NULL,
				[UTCTime] datetime NULL,
				[MAC] VARCHAR ( 4000 ) COLLATE Chinese_PRC_CI_AS NULL,
				[RAWDATA] VARCHAR ( 4000 ) COLLATE Chinese_PRC_CI_AS NULL,
				[Lat] FLOAT ( 53 ) NULL,
				[Lng] FLOAT ( 53 ) NULL,
				[Status] INT NULL,
				[UpdateTime] datetime NULL,
				[China] INT NULL,
				[AfterData] VARCHAR ( 4000 ),
			CONSTRAINT [PK__WIFIQueue__CA195970173876EA] PRIMARY KEY CLUSTERED ( [Id] ASC ) WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] 
			) ON [PRIMARY]'
		print @v_sql
		EXEC SP_EXECUTESQL @v_sql
	End

执行失败次数已超过10次，请检查。\r\n\r\n