数据库:添加字段<ProcessState,int>,属于表MachineBreak
INSERT TOP 1000 [RV]
[ProcessState]
FROM [HemoSystem].[dbo].[MachineBreak]
V S:ProcessState,属于MachineBreak.cs
数据库:添加表MachineStatus(设备状态表)
字段:Id,RV,IsBreak,IsReport,IsRepairing,IsRepair,IsSuccess,IsRun。均为bit类型。
对应:是否【停机,报修,正在维修,维修,成功,启用】
USE [HemoSystem]
GO
/****** Object: Table [dbo].[MachineBreak] Script Date: 2016/8/24 20:34:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MachineStatus](
[RV] [timestamp] NOT NULL,
[Id] [int] IDENTITY(1,1) NOT NULL,
[MachineId] [int] NOT NULL,
IsBreak [bit] NOT NULL DEFAULT ((0)),
IsReport [bit] NOT NULL DEFAULT ((0)),
IsRepair [bit] NOT NULL DEFAULT ((0)),
IsSuccess [bit] NOT NULL DEFAULT ((0)),
IsRun [bit] NOT NULL DEFAULT ((0)))
GO
VS:创建类MachineStatus(设备状态表),位置:EF