/// <summary>
/// 远程升级时,数据库操作
/// </summary>
private void RemotUpdate()
{
if (WriteData == null)
{
return;
}
using (DataTable dt = WriteData.Read("select top 1 * from AllTestStationTime"))
{
if (dt == null || dt.Columns.Count <= 0)
{
WriteData.Write("CREATE TABLE [dbo].[AllTestStationTime](" +
"[ID] [bigint] IDENTITY(1,1) NOT NULL," +
" [TestTime] [datetime] NOT NULL,"+
" [TestYear] [int] NULL,"+
" [TestMonth] [int] NULL,"+
" [TestDay] [int] NULL,"+
" [WorkStation] [int] NOT NULL,"+
" [StationName] [nvarchar](100) NULL,"+
" [TimeCount] [int] NULL,"+
" [OperaCount] [int] NULL,"+
"CONSTRAINT [PK_AllTestStationTime] PRIMARY KEY CLUSTERED " +
"(" +
" [ID] ASC,"+
" [TestTime] ASC,"+
" [WorkStation] ASC"+
")WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]" +
") ON [PRIMARY]");
}
}
using (DataTable dt = WriteData.Read("select top 1 * from AllTestStationTimeEveryHour"))
{
if (dt == null || dt.Columns.Count <= 0)
{
WriteData.Write("CREATE TABLE [dbo].[AllTestStationTimeEveryHour](" +
" [ID] [bigint] IDENTITY(1,1) NOT NULL,"+
" [TestTime] [datetime] NOT NULL,"+
" [UseTime] [int] NULL,"+
" [WorkStation] [int] NULL,"+
" [StationName] [nvarchar](100) NOT NULL,"+
" CONSTRAINT [PK_AllTestStationTimeEveryHour] PRIMARY KEY CLUSTERED" +
"(" +
" [ID] ASC,"+
" [TestTime] ASC,"+
" [StationName] ASC"+
")WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]" +
") ON [PRIMARY]");
}
}
}
