/*
Navicat SQL Server Data Transfer

Source Server         : 192.168.1.120
Source Server Version : 105000
Source Host           : 192.168.1.120:1433
Source Database       : HealthOne
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2015-11-24 17:09:22
*/


-- ----------------------------
-- Table structure for Mobile_Seat
-- ----------------------------
DROP TABLE [dbo].[Mobile_Seat]
GO
CREATE TABLE [dbo].[Mobile_Seat] (
[SEAT01] int NOT NULL ,
[BCK01A] int NULL ,
[SEAT03] varchar(20) NULL ,
[SEAT04] varchar(20) NULL ,
[BCK01B] int NULL ,
[ABW01] varchar(1) NULL ,
[ACG02] varchar(20) NULL ,
[BBY01] int NULL ,
[SEAT09] tinyint NULL DEFAULT ((0)) ,
[ROWNR] int NULL ,
[SEAT11] varchar(128) NULL ,
[VAA01] int NULL DEFAULT ((0)) ,
[SEAT13] tinyint NULL DEFAULT ((0)) ,
[BBY01B] int NULL ,
[SEAT15] tinyint NULL ,
[SEAT16] varchar(20) NULL ,
[BBY01C] int NULL 
)


GO

-- ----------------------------
-- Records of Mobile_Seat
-- ----------------------------
INSERT INTO [dbo].[Mobile_Seat] ([SEAT01], [BCK01A], [SEAT03], [SEAT04], [BCK01B], [ABW01], [ACG02], [BBY01], [SEAT09], [ROWNR], [SEAT11], [VAA01], [SEAT13], [BBY01B], [SEAT15], [SEAT16], [BBY01C]) VALUES (N'1', N'69', N'门诊输液室', N'001', N'69', null, null, null, N'1', N'1', null, N'0', N'1', null, N'1', N'普通座位', null)
GO
GO
INSERT INTO [dbo].[Mobile_Seat] ([SEAT01], [BCK01A], [SEAT03], [SEAT04], [BCK01B], [ABW01], [ACG02], [BBY01], [SEAT09], [ROWNR], [SEAT11], [VAA01], [SEAT13], [BBY01B], [SEAT15], [SEAT16], [BBY01C]) VALUES (N'2', N'69', N'门诊输液室', N'002', N'69', null, null, null, N'1', N'2', null, N'0', N'1', null, N'1', N'普通座位', null)
GO
GO
INSERT INTO [dbo].[Mobile_Seat] ([SEAT01], [BCK01A], [SEAT03], [SEAT04], [BCK01B], [ABW01], [ACG02], [BBY01], [SEAT09], [ROWNR], [SEAT11], [VAA01], [SEAT13], [BBY01B], [SEAT15], [SEAT16], [BBY01C]) VALUES (N'3', N'69', N'门诊输液室', N'003', N'69', null, null, null, N'1', N'3', null, N'0', N'0', null, N'2', N'特殊座位', null)
GO
GO
INSERT INTO [dbo].[Mobile_Seat] ([SEAT01], [BCK01A], [SEAT03], [SEAT04], [BCK01B], [ABW01], [ACG02], [BBY01], [SEAT09], [ROWNR], [SEAT11], [VAA01], [SEAT13], [BBY01B], [SEAT15], [SEAT16], [BBY01C]) VALUES (N'4', N'69', N'门诊输液室', N'004', N'69', null, null, null, N'1', N'4', null, N'0', N'0', null, N'2', N'特殊座位', null)
GO
GO
INSERT INTO [dbo].[Mobile_Seat] ([SEAT01], [BCK01A], [SEAT03], [SEAT04], [BCK01B], [ABW01], [ACG02], [BBY01], [SEAT09], [ROWNR], [SEAT11], [VAA01], [SEAT13], [BBY01B], [SEAT15], [SEAT16], [BBY01C]) VALUES (N'5', N'69', N'门诊输液室', N'005', N'69', null, null, null, N'0', N'5', null, N'0', N'0', null, N'3', N'临时加座', null)
GO
GO
INSERT INTO [dbo].[Mobile_Seat] ([SEAT01], [BCK01A], [SEAT03], [SEAT04], [BCK01B], [ABW01], [ACG02], [BBY01], [SEAT09], [ROWNR], [SEAT11], [VAA01], [SEAT13], [BBY01B], [SEAT15], [SEAT16], [BBY01C]) VALUES (N'6', N'69', N'门诊输液室', N'006', N'69', null, null, null, N'1', N'6', null, N'0', N'0', null, N'3', N'临时加座', null)
GO
GO
INSERT INTO [dbo].[Mobile_Seat] ([SEAT01], [BCK01A], [SEAT03], [SEAT04], [BCK01B], [ABW01], [ACG02], [BBY01], [SEAT09], [ROWNR], [SEAT11], [VAA01], [SEAT13], [BBY01B], [SEAT15], [SEAT16], [BBY01C]) VALUES (N'7', N'69', N'门诊输液室', N'007', N'69', null, null, null, N'0', N'7', null, N'0', N'0', null, N'4', N'VIP座位', null)
GO
GO
INSERT INTO [dbo].[Mobile_Seat] ([SEAT01], [BCK01A], [SEAT03], [SEAT04], [BCK01B], [ABW01], [ACG02], [BBY01], [SEAT09], [ROWNR], [SEAT11], [VAA01], [SEAT13], [BBY01B], [SEAT15], [SEAT16], [BBY01C]) VALUES (N'8', N'69', N'门诊输液室', N'008', N'69', null, null, null, N'0', N'8', null, N'0', N'0', null, N'4', N'VIP座位', null)
GO
GO

-- ----------------------------
-- Table structure for Mobile_SY_Program
-- ----------------------------
DROP TABLE [dbo].[Mobile_SY_Program]
GO
CREATE TABLE [dbo].[Mobile_SY_Program] (
[SYP01] int NOT NULL ,
[SYP01A] int NULL ,
[SYP03] varchar(50) NULL ,
[SYP04] tinyint NULL ,
[SYP05] varchar(255) NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'Mobile_SY_Program', 
'COLUMN', N'SYP03')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'名称'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'Mobile_SY_Program'
, @level2type = 'COLUMN', @level2name = N'SYP03'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'名称'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'Mobile_SY_Program'
, @level2type = 'COLUMN', @level2name = N'SYP03'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'Mobile_SY_Program', 
'COLUMN', N'SYP04')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'执行阶段1=开始，2进行中，3结束'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'Mobile_SY_Program'
, @level2type = 'COLUMN', @level2name = N'SYP04'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'执行阶段1=开始，2进行中，3结束'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'Mobile_SY_Program'
, @level2type = 'COLUMN', @level2name = N'SYP04'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'Mobile_SY_Program', 
'COLUMN', N'SYP05')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'描述'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'Mobile_SY_Program'
, @level2type = 'COLUMN', @level2name = N'SYP05'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'描述'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'Mobile_SY_Program'
, @level2type = 'COLUMN', @level2name = N'SYP05'
GO

-- ----------------------------
-- Records of Mobile_SY_Program
-- ----------------------------
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'1', N'0', N'输液', N'0', N'输液')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'2', N'0', N'注射', N'0', N'注射')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'3', N'0', N'皮试', N'0', N'皮试')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'4', N'0', N'配液', N'0', N'配液')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'5', N'0', N'穿刺', N'0', N'穿刺')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'6', N'0', N'换瓶', N'0', N'换瓶')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'101', N'1', N'输液开始', N'1', N'输液开始')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'102', N'1', N'输液通畅', N'2', N'输液通畅')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'103', N'1', N'不通畅调整后通畅', N'2', N'不通畅调整后通畅')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'104', N'1', N'不通畅换管重新穿刺', N'2', N'不通畅换管重新穿刺')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'105', N'1', N'视血压调整滴速', N'2', N'视血压调整滴速')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'106', N'1', N'视心率调整滴速', N'2', N'视心率调整滴速')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'107', N'1', N'输液结束', N'3', N'输液结束')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'201', N'2', N'注射开始', N'1', N'注射开始')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'202', N'2', N'注射进行中', N'2', N'注射进行中')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'203', N'2', N'注射结束', N'3', N'注射结束')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'301', N'3', N'皮试开始', N'1', N'皮试开始')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'302', N'3', N'皮试进行中', N'2', N'皮试进行中')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'303', N'3', N'皮试结束', N'3', N'皮试结束')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'401', N'4', N'未配液', N'1', N'未配液')
GO
GO
INSERT INTO [dbo].[Mobile_SY_Program] ([SYP01], [SYP01A], [SYP03], [SYP04], [SYP05]) VALUES (N'402', N'4', N'已配液', N'3', N'已配液')
GO
GO

-- ----------------------------
-- Table structure for Mobile_SY_WORK
-- ----------------------------
DROP TABLE [dbo].[Mobile_SY_WORK]
GO
CREATE TABLE [dbo].[Mobile_SY_WORK] (
[SYW01] int NOT NULL ,
[SYP01A] int NULL ,
[SYP01] int NULL ,
[SYW04] varchar(255) NULL ,
[VAA01] int NULL ,
[VAA07] int NULL ,
[ABW01] int NULL ,
[VAA05] int NULL ,
[BCE01A] int NULL ,
[BCE02A] varchar(10) NULL ,
[BCE03A] varchar(30) NULL ,
[BCE01B] int NULL ,
[BCE02B] varchar(10) NULL ,
[BCE03B] varchar(30) NULL ,
[BCK01A] int NULL ,
[SYW16] varchar(1) NULL ,
[SYW17] datetime NULL ,
[VBI21] varchar(30) NULL ,
[VAF22] varchar(100) NULL ,
[VAF01] int NULL ,
[BCK01B] int NULL ,
[BCK03A] varchar(50) NULL ,
[SEAT16] varchar(20) NULL ,
[SEAT04] varchar(20) NULL ,
[VAA10] int NULL ,
[AAU01] varchar(2) NULL ,
[VAP01] int NULL ,
[SYW28] varchar(50) NULL ,
[SYW29] varchar(50) NULL ,
[SYW30] varchar(50) NULL ,
[SYW31] varchar(50) NULL ,
[SYW32] varchar(50) NULL ,
[SYW33] varchar(50) NULL ,
[SYW34] varchar(50) NULL ,
[SYW35] varchar(50) NULL 
)


GO

-- ----------------------------
-- Records of Mobile_SY_WORK
-- ----------------------------
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'2', N'1', N'101', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 13:48:47.643', N'548668', N'注射用丹参（冻干） 400mg/支,每次400 mg', N'3299155', N'69', N'门诊输液室', N'普通座位', N'001', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'3', N'1', N'107', N'输液结束', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 13:51:20.953', N'548668', N'注射用丹参（冻干） 400mg/支,每次400 mg', N'3299155', N'69', N'门诊输液室', N'普通座位', N'001', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'4', N'1', N'101', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 13:51:18.743', N'548665', N'葡萄糖酸钙注射液 1g*5支,每次1 g', N'3299149', N'69', N'门诊输液室', N'普通座位', N'001', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'5', N'1', N'107', N'输液结束', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 14:08:00.553', N'548665', N'葡萄糖酸钙注射液 1g*5支,每次1 g', N'3299149', N'69', N'门诊输液室', N'普通座位', N'001', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'6', N'1', N'101', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 14:07:57.900', N'548670', N'10%葡萄糖注射液 250ml,每次250 ml', N'3299159', N'69', N'门诊输液室', N'普通座位', N'001', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'7', N'1', N'107', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 14:08:10.323', N'548670', N'10%葡萄糖注射液 250ml,每次250 ml', N'3299159', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'8', N'1', N'101', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 14:10:21.317', N'548692', N'10%葡萄糖注射液 100ml,每次100 ml', N'3299203', N'69', N'门诊输液室', N'普通座位', N'001', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'9', N'1', N'107', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 14:13:24.480', N'548692', N'10%葡萄糖注射液 100ml,每次100 ml', N'3299203', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'10', N'1', N'101', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 14:14:35.333', N'548690', N'10%葡萄糖注射液 250ml,每次250 ml', N'3299200', N'69', N'门诊输液室', N'普通座位', N'001', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'11', N'1', N'107', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 14:15:47.843', N'548690', N'10%葡萄糖注射液 250ml,每次250 ml', N'3299200', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'12', N'1', N'101', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 14:20:03.530', N'548662', N'右旋糖酐40葡萄糖注射液 0.25g*500ml,每次500 ml', N'3299143', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'13', N'1', N'103', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 14:24:45.653', N'548662', N'右旋糖酐40葡萄糖注射液 0.25g*500ml,每次500 ml', N'3299143', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'80', N'80', N'80', N'80', N'80', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'14', N'1', N'105', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 14:47:59.710', N'548662', N'右旋糖酐40葡萄糖注射液 0.25g*500ml,每次500 ml', N'3299143', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'80', N'80', N'80', N'80', N'80', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'15', N'1', N'106', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 15:04:10.687', N'548662', N'右旋糖酐40葡萄糖注射液 0.25g*500ml,每次500 ml', N'3299143', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'60', N'60', N'60', N'60', N'60', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'16', N'1', N'107', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-17 19:03:13.967', N'548662', N'右旋糖酐40葡萄糖注射液 0.25g*500ml,每次500 ml', N'3299143', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'17', N'1', N'101', N'开始输液 输液畅通', N'32907', N'44922', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 11:04:52.223', N'548720', N'10%葡萄糖注射液 500ml,每次500 ml 氢溴酸高乌甲素注射液 4mg*10支,每次4 mg', N'3299276', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'18', N'1', N'107', N'输液结束', N'32907', N'44922', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 11:40:04.653', N'548720', N'10%葡萄糖注射液 500ml,每次500 ml 氢溴酸高乌甲素注射液 4mg*10支,每次4 mg', N'3299276', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'19', N'1', N'101', N'开始输液 输液畅通', N'32907', N'44922', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 11:40:00.407', N'548722', N'5%葡萄糖氯化钠注射液 500ml,每次500 ml 精蛋白生物合成人胰岛素/诺和灵50R 300IU/3ml,每次300 IU', N'3299282', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'20', N'1', N'103', N'开始输液 输液畅通', N'32907', N'44922', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 11:40:48.157', N'548722', N'5%葡萄糖氯化钠注射液 500ml,每次500 ml 精蛋白生物合成人胰岛素/诺和灵50R 300IU/3ml,每次300 IU', N'3299282', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'50', N'50', N'80', N'80', N'50', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'21', N'1', N'104', N'开始输液 输液畅通', N'32907', N'44922', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 11:42:45.210', N'548722', N'5%葡萄糖氯化钠注射液 500ml,每次500 ml 精蛋白生物合成人胰岛素/诺和灵50R 300IU/3ml,每次300 IU', N'3299282', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'50', N'50', N'80', N'80', N'50', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'22', N'1', N'107', N'开始输液 输液畅通', N'32907', N'44922', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 12:00:47.930', N'548722', N'5%葡萄糖氯化钠注射液 500ml,每次500 ml 精蛋白生物合成人胰岛素/诺和灵50R 300IU/3ml,每次300 IU', N'3299282', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'23', N'1', N'101', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 14:31:33.110', N'548718', N'5%葡萄糖氯化钠注射液 250ml*12.5g,每次250 ml 甲磺酸酚妥拉明注射液 10mg*5支,每次10 mg', N'3299270', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'24', N'1', N'107', N'输液结束', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 15:55:53.560', N'548718', N'5%葡萄糖氯化钠注射液 250ml*12.5g,每次250 ml 甲磺酸酚妥拉明注射液 10mg*5支,每次10 mg', N'3299270', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'25', N'1', N'101', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 15:55:52.350', N'548719', N'10%葡萄糖注射液 100ml,每次100 ml 盐酸二甲双胍缓释片 0.5g*30片,每次0.5 g', N'3299273', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'26', N'1', N'107', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 16:06:38.350', N'548719', N'10%葡萄糖注射液 100ml,每次100 ml 盐酸二甲双胍缓释片 0.5g*30片,每次0.5 g', N'3299273', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'27', N'1', N'101', N'开始输液 输液畅通', N'32582', N'44559', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 19:23:32.483', N'548726', N'10%葡萄糖注射液 500ml,每次500 ml', N'3299291', N'69', N'门诊输液室', N'', N'', N'45', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'28', N'1', N'101', N'开始输液 输液畅通', N'32908', N'44923', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 19:28:43.227', N'548725', N'葡萄糖酸钙注射液 1g*5支,每次1 g', N'3299289', N'69', N'门诊输液室', N'', N'', N'29', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'29', N'1', N'107', N'开始输液 输液畅通', N'32908', N'44923', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-18 19:32:36.687', N'548725', N'葡萄糖酸钙注射液 1g*5支,每次1 g', N'3299289', N'69', N'门诊输液室', N'', N'', N'29', N'Y', N'0', N'', N'', N'', N'', N'', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'30', N'1', N'101', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-20 14:52:22.967', N'548727', N'10%葡萄糖注射液 250ml,每次250 ml 曲克芦丁注射液 100mg*10支,每次100 mg', N'3299293', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'31', N'1', N'102', N'开始输液 输液畅通', N'32887', N'44918', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-20 15:01:40.507', N'548727', N'10%葡萄糖注射液 250ml,每次250 ml 曲克芦丁注射液 100mg*10支,每次100 mg', N'3299293', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'80', N'80', N'80', N'80', N'80', null, null, null)
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'32', N'1', N'101', N'开始输液 输液畅通', N'32913', N'44928', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-23 17:10:31.387', N'548743', N'5%葡萄糖氯化钠注射液 250ml*12.5g,每次250 ml', N'3299325', N'69', N'门诊输液室', N'', N'', N'22', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'33', N'1', N'101', N'开始输液 输液畅通', N'32915', N'44930', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-23 17:12:22.853', N'548747', N'葡萄糖酸钙注射液 1g*5支,每次1 g', N'3299333', N'69', N'门诊输液室', N'', N'', N'22', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO
INSERT INTO [dbo].[Mobile_SY_WORK] ([SYW01], [SYP01A], [SYP01], [SYW04], [VAA01], [VAA07], [ABW01], [VAA05], [BCE01A], [BCE02A], [BCE03A], [BCE01B], [BCE02B], [BCE03B], [BCK01A], [SYW16], [SYW17], [VBI21], [VAF22], [VAF01], [BCK01B], [BCK03A], [SEAT16], [SEAT04], [VAA10], [AAU01], [VAP01], [SYW28], [SYW29], [SYW30], [SYW31], [SYW32], [SYW33], [SYW34], [SYW35]) VALUES (N'34', N'1', N'101', N'开始输液 输液畅通', N'32907', N'44922', null, null, N'111', N'3047', N'王莉丽', null, null, null, N'69', N'N', N'2015-11-24 14:53:59.763', N'548764', N'5%葡萄糖氯化钠注射液 500ml,每次500 ml', N'3299370', N'69', N'门诊输液室', N'', N'', N'20', N'Y', N'0', N'', N'', N'', N'', N'', N'', N'', N'')
GO
GO

-- ----------------------------
-- Table structure for Mobile_Version
-- ----------------------------
DROP TABLE [dbo].[Mobile_Version]
GO
CREATE TABLE [dbo].[Mobile_Version] (
[MVS01] int NOT NULL ,
[MVS02] varchar(50) NULL ,
[MVS03] varchar(500) NULL ,
[MVS04] varchar(255) NULL ,
[MVS05] varchar(500) NULL ,
[BCE01A] int NULL ,
[BCE03A] varchar(50) NULL ,
[MVS06] datetime NULL ,
[MVS07] tinyint NULL 
)


GO

-- ----------------------------
-- Records of Mobile_Version
-- ----------------------------
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'1', N'0000.0000.0092', N'新特性1', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/mtransfuse-1.0.2.apk', N'备注', N'1', N'管理员', N'2015-11-23 10:16:02.000', N'2')
GO
GO
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'2', N'0000.0001.0093', N'新特性2', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/mtransfuse-1.0.2.apk', N'备注', N'1', N'管理员', N'2015-11-23 10:16:06.000', N'2')
GO
GO
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'3', N'0001.0000.0000', N'新特性3', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/mtransfuse-1.0.2.apk', N'备注', N'1', N'管理员', N'2015-11-23 10:16:10.000', N'2')
GO
GO
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'4', N'1.0.0', N'新特性4', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/mtransfuse-1.0.2.apk', N'备注', N'1', N'管理员', N'2015-11-23 10:16:13.000', N'2')
GO
GO
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'5', N'1.0.1', N'添加禁止弹出软键盘功能
去除了Splash页
界面优化，提醒信息优化', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/mtransfuse-1.0.2.apk', N'备注', N'1', N'管理员', N'2015-11-23 10:16:16.000', N'2')
GO
GO
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'6', N'1.0.2', N'代码混淆', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/mtransfuse-1.0.2.apk', N'备注', N'1', N'管理员', N'2015-11-23 10:40:53.000', N'2')
GO
GO
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'7', N'302.31', N'移动医生站新特性', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/hodoctorapp.apk', N'移动医生站新特性', N'1', N'管理员', N'2015-11-23 13:39:58.100', N'0')
GO
GO
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'8', N'1.0.0', N'移动护士站新特性', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/honurseapp.apk', N'移动护士站新特性', N'1', N'管理员', N'2015-11-23 15:49:49.590', N'1')
GO
GO
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'10', N'1.0.1', N'移动护士新特性1', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/honurseapp.apk', N'备注', N'304', N'', N'2015-11-24 15:51:55.630', N'1')
GO
GO
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'11', N'302.27', N'1.护士站扫描腕带、再扫描瓶签后现在会弹出医嘱信息，点击确定或者取消，才正常执行
2.修复小屏有的下拉被挤压没显示出来。
3.录入界面文字现在向右对齐。
4.录入界面输入保存后清除输入框内容
5.修复医嘱界面显示时间被挤压
6.瓶签重复扫描现在会弹出提示框', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/honurseapp.apk', N'备注
', N'304', N'', N'2015-11-25 11:14:50.000', N'1')
GO
GO
INSERT INTO [dbo].[Mobile_Version] ([MVS01], [MVS02], [MVS03], [MVS04], [MVS05], [BCE01A], [BCE03A], [MVS06], [MVS07]) VALUES (N'15', N'1.0.3', N'修复界面错误
添加重复输入提示
修复BUG', N'http://192.168.1.120:8081/honurse/commutil/download?filePath=D:/HOServer/Update/Apk/mtransfuse-1.0.3.apk', N'备注', N'1', N'管理员', N'2015-11-24 16:15:06.903', N'2')
GO
GO

-- ----------------------------
-- Indexes structure for table Mobile_Seat
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table Mobile_Seat
-- ----------------------------
ALTER TABLE [dbo].[Mobile_Seat] ADD PRIMARY KEY ([SEAT01])
GO

-- ----------------------------
-- Indexes structure for table Mobile_SY_Program
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table Mobile_SY_Program
-- ----------------------------
ALTER TABLE [dbo].[Mobile_SY_Program] ADD PRIMARY KEY ([SYP01])
GO

-- ----------------------------
-- Indexes structure for table Mobile_SY_WORK
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table Mobile_SY_WORK
-- ----------------------------
ALTER TABLE [dbo].[Mobile_SY_WORK] ADD PRIMARY KEY ([SYW01])
GO

-- ----------------------------
-- Indexes structure for table Mobile_Version
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table Mobile_Version
-- ----------------------------
ALTER TABLE [dbo].[Mobile_Version] ADD PRIMARY KEY ([MVS01])
GO





--alter 8058 2013.11.26
--巡视工作录入
create  proc [dbo].[oh_Nurse_MSYWORK_INSERT]
  @lXml ntext,
  @VAA01 int,
  @VAA07 int,
  @SYP01A int,
  @SYP01 int,
  @SYW16 varchar(1),
  @VBI21 varchar(20),
  @isFlag tinyint
As
begin
  DECLARE @iDOM int, @iret int
  Exec @iret = sp_xml_preparedocument @iDOM OUTPUT, @lXml

  if @iret > 0
  BEGIN
    exec sp_xml_removedocument @iDOM	
    RAISERROR('解析XML文档时发生错误，错误号: %d.', 16, 1, @iret) with nowait
    return @iret
  END 
  if OBJECT_ID('tempdb..#tmpSYWORK') is not null drop table #tmpSYWORK
  create table #tmpSYWORK(
[SYP01A] int,
[SYP01] int, 
[SYW04] varchar(255),
[VAA01] int, 
[VAA07] int, 
[ABW01] int,
[VAA05] int,
[BCE01A] int,
[BCE02A] varchar(10),
[BCE03A] varchar(30),
[BCE01B] int,
[BCE02B] varchar(10),
[BCE03B] varchar(30),
[BCK01A] int,
[SYW16] varchar(1),
[SYW17] datetime,
[VBI21] varchar(30),
[VAF22] varchar(100),
[VAF01] int,
[BCK01B] int ,
[BCK03A] varchar(50) ,
[SEAT16] varchar(20) ,
[SEAT04] varchar(20) ,
[VAA10] int ,
[AAU01] varchar(2) ,
[VAP01] int ,
[SYW28] varchar(50) ,
[SYW29] varchar(50) ,
[SYW30] varchar(50) ,
[SYW31] varchar(50),
[SYW32] varchar(50),
[SYW33] varchar(50),
[SYW34] varchar(50),
[SYW35] varchar(50))   

  INSERT INTO #tmpSYWORK
  SELECT *
  from OpenXml(@iDOM,'/Root/MSY_WORK/Ie',8)
  with(
[SYP01A] int,
[SYP01] int, 
[SYW04] varchar(255),
[VAA01] int, 
[VAA07] int, 
[ABW01] int,
[VAA05] int,
[BCE01A] int,
[BCE02A] varchar(10),
[BCE03A] varchar(30),
[BCE01B] int,
[BCE02B] varchar(10),
[BCE03B] varchar(30),
[BCK01A] int,
[SYW16] varchar(1),
[SYW17] datetime,
[VBI21] varchar(30),
[VAF22] varchar(100),
[VAF01] int,
[BCK01B] int ,
[BCK03A] varchar(50) ,
[SEAT16] varchar(20) ,
[SEAT04] varchar(20) ,
[VAA10] int ,
[AAU01] varchar(2) ,
[VAP01] int ,
[SYW28] varchar(50) ,
[SYW29] varchar(50) ,
[SYW30] varchar(50) ,
[SYW31] varchar(50),
[SYW32] varchar(50),
[SYW33] varchar(50),
[SYW34] varchar(50),
[SYW35] varchar(50))

exec sp_xml_removedocument @iDOM
	    
  IF ISNULL(@VBI21,'') = '' 
	BEGIN   
   RAISERROR('提交文档错误，条码信息为空', 16, 1) with nowait
   RETURN 1
  END

  If not exists(select * from #tmpSYWORK)
  BEGIN   
   RAISERROR('提交文档错误，条码信息为空', 16, 1) with nowait
   RETURN 1
  END
    
  If exists(SELECT * from Mobile_SY_WORK where VAA01=@VAA01 and VAA07=@VAA07 and VBI21=@VBI21 and SYP01A=1 and SYP01=101 and @SYP01=101)
  BEGIN   
   RAISERROR('病人IDVAA01=%d，瓶签=%s的输液已经开始！', 16, 1, @VAA01,@VBI21) with nowait
   RETURN 1
  END
  
  /*if OBJECT_ID('tempdb..#tmpSYWORKVAA') is not null drop table #tmpSYWORKVAA
	SELECT a.VAA01,a.VAA07,c.VAA05,a.VAF01,a.VBI21,a.VAF22, CASE WHEN a.syp01>106 THEN 'Y' ELSE 'N' END SYW16 INTO #tmpSYWORKVAA
	FROM Mobile_SY_WORK a 
	JOIN (SELECT max(syw01) syw01, VAF01,VBI21 FROM Mobile_SY_WORK  where VAA01=@VAA01 and vaa07=@VAA07 AND syp01A=1 GROUP BY VAF01,VBI21) b ON a.syw01 = b.syw01
	JOIN VAA1 c ON c.VAA01=a.VAA01
	DECLARE @VAA05 varchar(30)
	SELECT @VAA05=VAA05,@VBI21=VBI21 from #tmpSYWORKVAA where SYW16='N'
  
  If exists(SELECT SYW16 from #tmpSYWORKVAA where SYW16='N' and @SYP01=107 GROUP BY SYW16 HAVING COUNT(*)>0 )
  BEGIN   
   RAISERROR('病人 %s，瓶签=%s的输液未结束，请先结束当前输液！', 16, 1, @VAA05,@VBI21) with nowait
   RETURN 1
  END*/

  DECLARE @oldVBI21 VARCHAR(20)
  set @oldVBI21=''
  SELECT top 1 @oldVBI21=a.VBI21 from Mobile_SY_WORK a where a.VAA01=@VAA01 and a.vaa07=@VAA07 and a.VBI21 NOT IN (select VBI21 from Mobile_SY_WORK where VAA01=@VAA01 and vaa07=@VAA07 and syp01A=1 and syp01=107)
	
  set @oldVBI21=ISNULL(@oldVBI21, '')
  if(@oldVBI21<>'')
  BEGIN
		if (@isFlag=0) and ( @oldVBI21<>@VBI21)
		BEGIN   
		 RAISERROR('病人 %d，瓶签=%s的输液未结束，请先结束当前输液！', 16, 1, @VAA01,@oldVBI21) with nowait
		 RETURN 1
		END
  END

  If exists(SELECT * from Mobile_SY_WORK where VAA01=@VAA01 and VAA07=@VAA07 and VBI21=@VBI21 and SYP01A=1 and SYP01=107 and @SYP01=107)
  BEGIN   
   RAISERROR('病人IDVAA01=%d，瓶签=%s的输液已经结束！', 16, 1, @VAA01,@VBI21) with nowait
   RETURN 1
  END

  update #tmpSYWORK set SYW16='N'  --where VAA01=@VAA01 and SYP01A=@SYP01A and VBI21=@VBI21 and @SYW16='Y'
      
  begin tran

		DECLARE @SYW01 INT
		IF @isFlag=0  --不换瓶
		BEGIN
			SELECT @SYW01=MAX(SYW01) from Mobile_SY_Work
			set @SYW01 = ISNULL(@SYW01, 1)+1
			insert into Mobile_SY_Work select @SYW01 SYW01,* from #tmpSYWORK
		END
		ELSE IF @isFlag=1 --换瓶
		BEGIN
			--先结束此病人的未结束的输液
			DECLARE @nowDate datetime,@SEAT16 varchar(20),@SEAT04 varchar(10)
			set @nowDate=GETDATE()
			if OBJECT_ID('tempdb..#tmpSYWORKinsert') is not null drop table #tmpSYWORKinsert
			SELECT top 1 SYP01A,SYP01, SYW04, VAA01, VAA07, ABW01, VAA05, BCE01A,BCE02A,BCE03A,BCE01B,BCE02B,BCE03B,BCK01A,SYW16, SYW17, VBI21, VAF22, VAF01, BCK01B,BCK03A,SEAT16,SEAT04,VAA10, AAU01, VAP01, SYW28, SYW29, SYW30, SYW31,SYW32,SYW33,SYW34,SYW35 
			INTO #tmpSYWORKinsert from Mobile_SY_WORK where VAA01=@VAA01 and VAA07=@VAA07
			and VBI21 NOT IN (SELECT DISTINCT VBI21 from Mobile_SY_WORK where VAA01=@VAA01 and VAA07=@VAA07 and SYP01A=1 and SYP01=107) ORDER BY SYP01 DESC
      SELECT @SEAT16=SEAT16,@SEAT04=SEAT04 from #tmpSYWORKinsert

			UPDATE #tmpSYWORKinsert set SYP01=107,SYW04='输液结束',SYW16='N',SYW17=@nowDate

			SELECT @SYW01=MAX(SYW01) from Mobile_SY_Work
			set @SYW01 = ISNULL(@SYW01, 1)+1
			insert into Mobile_SY_Work select @SYW01 SYW01,* from #tmpSYWORKinsert
			
			--然后插入新的瓶签数据
      UPDATE #tmpSYWORK set SEAT04=@SEAT04,SEAT16=@SEAT16
			SELECT @SYW01=MAX(SYW01) from Mobile_SY_Work
			set @SYW01 = ISNULL(@SYW01, 1)+1
			insert into Mobile_SY_Work select @SYW01 SYW01,* from #tmpSYWORK
		END
  
  commit tran  

  if OBJECT_ID('tempdb..#tmpSYWORK') is not null drop table #tmpSYWORK
  if OBJECT_ID('tempdb..#tmpSYWORKinsert') is not null drop table #tmpSYWORKinsert
  if OBJECT_ID('tempdb..#tmpSYWORKVAA') is not null drop table #tmpSYWORKVAA
end

