序号 | 列名 | 数据类型 | 长度 | 小数位 | 标识 | 主键 | 外键 | 允许空 | 默认值 | 说明 |
1 | ID | int | 4 | 0 | 是 | 是 | 否 | 主键 | ||
2 | OrderID | int | 4 | 0 | 是 | 排序ID | ||||
3 | ItemID | int | 4 | 0 | 是 | 从表ID | ||||
4 | Class | int | 4 | 0 | 是 | [未用][备用字段] | ||||
5 | Nodeid | int | 4 | 0 | 是 | 节点ID | ||||
6 | ModelID | int | 4 | 0 | 是 | 模型ID | ||||
7 | Categoryid | int | 4 | 0 | 是 | 所属专题ID | ||||
8 | ProCode | varchar | 50 | 0 | 是 | 商品编号 | ||||
9 | BarCode | varchar | 50 | 0 | 是 | 条形码 | ||||
10 | Proname | varchar | 255 | 0 | 是 | 商品名称 | ||||
11 | Kayword | varchar | 255 | 0 | 是 | 关键字 | ||||
12 | ProUnit | varchar | 50 | 0 | 是 | 单位 | ||||
13 | Weight | int | 4 | 0 | 是 | 重量 | ||||
14 | ServerPeriod | int | 4 | 0 | 是 | 服务期限 | ||||
15 | ServerType | int | 4 | 0 | 是 | 期限日期格式[3-年2-月1-日0-无限期],页面显示用GetServerPeriod | ||||
16 | ProClass | int | 4 | 0 | 是 | 商品类型[1:正常|店铺,2:特价,3:积分,4:团购,5:云购,6:IDC,7:旅游,8:酒店,9:机票] | ||||
17 | Properties | int | 4 | 0 | 是 | 商品属性 | ||||
18 | Sales | int | 4 | 0 | 是 | 销售操作[1-允许销售,2-不允许] | ||||
19 | Proinfo | text | 16 | 0 | 是 | 商品简介 | ||||
20 | Procontent | text | 16 | 0 | 是 | 商品详细介绍 | ||||
21 | Clearimg | varchar | 255 | 0 | 是 | 商品清晰图 | ||||
22 | Thumbnails | varchar | 255 | 0 | 是 | 商品缩略图 | ||||
23 | Producer | varchar | 255 | 0 | 是 | 厂商 | ||||
24 | Brand | varchar | 50 | 0 | 是 | 商标 | ||||
25 | Allowed | int | 4 | 0 | 是 | 1-缺货允许购买,0-不允许购买 | ||||
26 | Quota | int | 4 | 0 | 是 | 限制购买数量[购买上限]-1不限制 | ||||
27 | DownQuota | int | 4 | 0 | 是 | 最低购买数量[购买下限]-1不限制 | ||||
28 | Stock | int | 4 | 0 | 是 | 库存数量 | ||||
29 | StockDown | int | 4 | 0 | 是 | 最低库存数量[报警] | ||||
30 | JisuanFs | int | 4 | 0 | 是 | 0-实际库存,1-虚拟库存(含订购) | ||||
31 | Rate | money | 8 | 4 | 是 | 税率设置,百分数% | ||||
32 | Rateset | int | 4 | 0 | 是 | 税率设置 | ||||
33 | Dengji | int | 4 | 0 | 是 | 推荐等级 | ||||
34 | ShiPrice | money | 8 | 4 | 是 | 市场价 | ||||
35 | LinPrice | money | 8 | 4 | 是 | 零售价 | ||||
36 | MemberPrice | varchar | 255 | 0 | 是 | 会员价 | ||||
37 | ActPrice | varchar | 255 | 0 | 是 | [未用][备用字段] | ||||
38 | Wholesales | int | 4 | 0 | 是 | 是否允许批发 1:是 | ||||
39 | Wholesaleone | int | 4 | 0 | 是 | 零售 | ||||
40 | Wholesalesinfo | varchar | 255 | 0 | 是 | 多价格信息 | ||||
41 | Preset | varchar | 255 | 0 | 是 | 促销方案 | ||||
42 | Integral | int | 4 | 0 | 是 | 购物积分 | ||||
43 | Propeid | int | 4 | 0 | 是 | 自选购买数量 | ||||
44 | Recommend | int | 4 | 0 | 是 | 优惠率%数,不允许负数,不允许超过100,优惠5%,则减价5% | ||||
45 | Priority | int | 4 | 0 | 是 | 绑定销售(1=绑定 0=不绑定) | ||||
46 | MonthClickNum | int | 4 | 0 | 是 | [未用][备用字段] | ||||
47 | ModeTemplate | varchar | 255 | 0 | 是 | 模型模板 | ||||
48 | AddUser | varchar | 255 | 0 | 是 | 作者 | ||||
49 | DownCar | int | 4 | 0 | 是 | [未用][备用字段](是否下架) | ||||
50 | AddTime | datetime | 8 | 3 | 是 | 添加时间 | ||||
51 | UpdateTime | datetime | 8 | 3 | 是 | 更新时间类型 | ||||
52 | TableName | varchar | 50 | 0 | 是 | 模型表名 | ||||
53 | Istrue | int | 4 | 0 | 是 | 1:已审核,0:未审核 | ||||
54 | Isgood | int | 4 | 0 | 是 | [未用][备用字段] | ||||
55 | MakeHtml | int | 4 | 0 | 是 | [未用][备用字段] | ||||
56 | Sold | int | 4 | 0 | 是 | 购买商品人数 | ||||
57 | isnew | int | 4 | 0 | 是 | 新品 | ||||
58 | ishot | int | 4 | 0 | 是 | 热销 | ||||
59 | isbest | int | 4 | 0 | 是 | 精品 | ||||
60 | ComModelID | int | 4 | 0 | 是 | 内容ID | ||||
61 | AllClickNum | int | 4 | 0 | 是 | 点击数 | ||||
62 | Largess | int | 4 | 0 | 是 | 设为赠品(1-为赠品 0-非赠品) | ||||
63 | Largesspirx | money | 8 | 4 | 是 | 赠品价格 | ||||
64 | ProjectType | int | 4 | 0 | 是 | 促销方案 | ||||
65 | ProjectPronum | int | 4 | 0 | 是 | 促销方案涉及到数字的字段 | ||||
66 | ProjectMoney | money | 8 | 4 | 是 | 方案涉及金钱的字段 | ||||
67 | IntegralNum | int | 4 | 0 | 是 | 购物数量送积分 | ||||
68 | PesentNames | nvarchar | 255 | 0 | 是 | 赠品名称 | ||||
69 | PesentNameid | int | 4 | 0 | 是 | 赠品ID | ||||
70 | Recycler | bit | 1 | 0 | 是 | 是否进入回收站 | ||||
71 | ProSeller | nvarchar | 255 | 0 | 是 | 商品卖家 | ||||
72 | GuessType | int | 4 | 0 | 是 | 备用字段 | ||||
73 | GuessXML | nvarchar | 1000 | 0 | 是 | 商品属性,存储是否返修,竞猜,秒杀等字段等,repair,return | ||||
74 | FirstNodeID | int | 4 | 0 | 是 | 第一级节点 | ||||
75 | PointVal | int | 4 | 0 | 是 | 赠送积分 | ||||
76 | isStand | int | 4 | 0 | 是 | 是否设为标准:0为否,1为是 | ||||
77 | UserShopID | int | 4 | 0 | 是 | 店铺ID,StoreID | ||||
78 | BookPrice | money | 8 | 4 | 是 | 预订价 | ||||
79 | bookDay | int | 4 | 0 | 是 | 比节日时间提前多少天为预订价 | ||||
80 | UserType | int | 4 | 0 | 是 | 计价类型:0:不使用,1:为会员价,2:按会员组定价 | ||||
81 | UserPrice | nvarchar | 1000 | 0 | 是 | 如果按会员组打折,格式为:会员组ID|价格 | ||||
82 | FarePrice | nvarchar | 400 | 0 | 是 | 运费模板ID( 0|50,1|100,2|200,快递,平邮,EMS(Disuse)) | ||||
83 | ExpRemind | int | 4 | 0 | 是 | 物流信息 | ||||
84 | LinPrice_Json | nvarchar | 500 | 0 | 是 | 余额,银币,点数售价,前端标签取出后,转JSON判断输出 | ||||
85 | ParentID | int | 4 | 0 | 是 | 所属于哪个商品 | ||||
86 | UserID | int | 4 | 0 | 是 | 用户ID | ||||
87 | BindIDS | varchar | 4000 | 0 | 是 | 捆绑商品的IDS | ||||
88 | IDCPrice | ntext | 16 | 0 | 是 | IDC商品价格 | ||||
89 | Quota_Json | varchar | 8000 | 0 | 是 | |||||
90 | DownQuota_Json | varchar | 8000 | 0 | 是 | |||||
91 | ShortProName | nvarchar | 100 | 0 | 是 | 商品短名称 |
商城主表
GO
CREATE TABLE [dbo].[ZL_Commodities](
[ID] [int] IDENTITY(1,1) NOT NULL,
[OrderID] [int] NULL,
[ItemID] [int] NULL,
[Class] [int] NULL,
[Nodeid] [int] NULL,
[ModelID] [int] NULL,
[Categoryid] [int] NULL,
[ProCode] [varchar](50) NULL,
[BarCode] [varchar](50) NULL,
[Proname] [varchar](255) NULL,
[Kayword] [varchar](255) NULL,
[ProUnit] [varchar](50) NULL,
[Weight] [int] NULL,
[ServerPeriod] [int] NULL,
[ServerType] [int] NULL,
[ProClass] [int] NULL,
[Properties] [int] NULL,
[Sales] [int] NULL,
[Proinfo] [text] NULL,
[Procontent] [text] NULL,
[Clearimg] [varchar](255) NULL,
[Thumbnails] [varchar](255) NULL,
[Producer] [varchar](255) NULL,
[Brand] [varchar](50) NULL,
[Allowed] [int] NULL,
[Quota] [int] NULL,
[DownQuota] [int] NULL,
[Stock] [int] NULL,
[StockDown] [int] NULL,
[JisuanFs] [int] NULL,
[Rate] [money] NULL,
[Rateset] [int] NULL,
[Dengji] [int] NULL,
[ShiPrice] [money] NULL,
[LinPrice] [money] NULL,
[MemberPrice] [varchar](255) NULL,
[ActPrice] [varchar](255) NULL,
[Wholesales] [int] NULL,
[Wholesaleone] [int] NULL,
[Wholesalesinfo] [varchar](255) NULL,
[Preset] [varchar](255) NULL,
[Integral] [int] NULL,
[Propeid] [int] NULL,
[Recommend] [int] NULL,
[Priority] [int] NULL,
[MonthClickNum] [int] NULL,
[ModeTemplate] [varchar](255) NULL,
[AddUser] [varchar](255) NULL,
[DownCar] [int] NULL,
[AddTime] [datetime] NULL,
[UpdateTime] [datetime] NULL,
[TableName] [varchar](50) NULL,
[Istrue] [int] NULL,
[Isgood] [int] NULL,
[MakeHtml] [int] NULL,
[Sold] [int] NULL,
[isnew] [int] NULL,
[ishot] [int] NULL,
[isbest] [int] NULL,
[ComModelID] [int] NULL,
[AllClickNum] [int] NULL,
[Largess] [int] NULL,
[Largesspirx] [money] NULL,
[ProjectType] [int] NULL,
[ProjectPronum] [int] NULL,
[ProjectMoney] [money] NULL,
[IntegralNum] [int] NULL,
[PesentNames] [nvarchar](255) NULL,
[PesentNameid] [int] NULL,
[Recycler] [bit] NULL,
[ProSeller] [nvarchar](255) NULL,
[GuessType] [int] NULL,
[GuessXML] [nvarchar](1000) NULL,
[FirstNodeID] [int] NULL,
[PointVal] [money] NULL,
[isStand] [int] NULL,
[UserShopID] [int] NULL,
[BookPrice] [money] NULL,
[bookDay] [int] NULL,
[UserType] [int] NULL,
[UserPrice] [nvarchar](1000) NULL,
[FarePrice] [nvarchar](400) NULL,
[ExpRemind] [int] NULL,
[LinPrice_Json] [nvarchar](500) NULL,
[ParentID] [int] NULL,
[UserID] [int] NULL,
[BindIDS] [varchar](4000) NULL,
[IDCPrice] [ntext] NULL,
[Quota_Json] [varchar](8000) NULL,
[DownQuota_Json] [varchar](8000) NULL,
[ShortProName] [nvarchar](100) NULL,
CONSTRAINT [PK_ZL_Commodities] 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] TEXTIMAGE_ON [PRIMARY]
SET IDENTITY_INSERT [ZL_Commodities] ON
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[MemberPrice],[ActPrice],[Wholesales],[Wholesaleone],[Preset],[Integral],[Propeid],[Recommend],[Priority],[MonthClickNum],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[GuessXML],[FirstNodeID],[PointVal],[isStand],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 1,1,1,0,75,6,0,N'2012120145963411137',N'示例商品之一',N'件',0,0,3,1,0,1,N'这个冬天我们奉献最时尚的衣装和折扣...',N'<p>这里放置商品的详细介绍</p>',N'UploadFiles/demo/01.jpg',N'UploadFiles/demo/02.jpg',0,0,0,20,1,0,0.0000,1,3,100.0000,80.0000,N'0',N'0',0,1,N'1',0,0,0,0,0,N'admin',1,N'2016/10/13 16:59:52',N'2016/10/13 16:59:52',N'ZL_P_Shop',1,0,0,0,1,0,0,2,91,0,0.0000,7,0,1.0000,0,0,0,1,N'drawback,exchange',2,0,1,0,0.0000,0,0,N'1',0,N'{
"purse": "0.00",
"sicon": "0.00",
"point": "0.00"
}',1,0,N'时尚修身')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[MemberPrice],[ActPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[MonthClickNum],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[GuessXML],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 2,2,2,0,75,6,0,N'201212014584333148946',N'示例商品二',N'件',0,0,3,1,0,1,N'源自德国的男装风格',N'<p>源自德国的男装风格,为您的冬天装点一切。</p>',N'UploadFiles/demo/04.jpg',N'UploadFiles/demo/04.jpg',0,0,0,20,1,0,0.0000,1,3,988.0000,688.0000,N'0',N'0',0,1,0,0,0,0,0,N'admin',1,N'2016/10/12 8:40:54',N'2016/12/31 8:40:54',N'ZL_P_Shop',1,0,0,0,1,0,0,128,2,0,0.0000,1,0,0.0000,1,0,0,1,N'drawback,exchange',2,0,0,0.0000,0,0,N'1',0,N'{
"purse": "0.00",
"sicon": "0.00",
"point": "0.00"
}',1,0,N'加绒加厚')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Brand],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[MemberPrice],[ActPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[MonthClickNum],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[GuessXML],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 3,3,3,0,75,6,0,N'20121201533447191785',N'示例商品三',N'件',1,1,3,1,0,1,N'商品简介',N'<p> 商品简介商品简介商品简介商品简介</p>',N'UploadFiles/demo/04.jpg',N'UploadFiles/demo/04.jpg',N'九牧王',0,0,0,20,1,0,0.0000,1,3,500.0000,455.0000,N'0',N'0',0,1,0,0,0,0,0,N'admin',1,N'2016/1/20 15:01:19',N'2016/1/20 15:01:19',N'ZL_P_Shop',1,0,0,0,1,0,0,309,1,0,0.0000,1,0,0.0000,1,0,0,1,N'drawback,exchange',2,0,0,0.0000,0,0,N'1',0,N'{
"purse": "0.00",
"sicon": "0.00",
"point": "0.00"
}',1,0,N'轻薄透气')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[MemberPrice],[ActPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[MonthClickNum],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[ParentID],[UserID]) VALUES ( 4,4,27,0,129,6,0,N'2015227116463787783',N'希尔顿套房',N'次',0,0,3,8,0,1,1,-1,-1,10,1,0,0.0000,1,3,300.0000,300.0000,N'0',N'0',0,1,0,0,0,0,0,N'admin',0,N'2016/2/27 11:06:46',N'2016/2/27 11:06:46',N'ZL_P_Shop',1,0,0,0,1,0,0,54,0,0,0.0000,1,0,0.0000,1,0,0,1,2,0,0,0.0000,0,0,N'1',0,0,0)
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[MemberPrice],[ActPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[MonthClickNum],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[ParentID],[UserID]) VALUES ( 5,5,28,0,129,6,0,N'20152271173162133761',N'旅游商品(成人票)',N'张',0,0,3,7,0,1,0,-1,-1,10,1,0,0.0000,1,3,80.0000,80.0000,N'0',N'0',0,1,0,0,0,0,0,N'admin',0,N'2016/2/27 11:07:31',N'2016/2/27 11:07:31',N'ZL_P_Shop',1,0,0,0,1,0,0,55,0,0,0.0000,1,0,0.0000,1,0,0,1,2,0,0,0.0000,0,0,N'1',0,0,0)
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[MemberPrice],[ActPrice],[Wholesales],[Wholesaleone],[Wholesalesinfo],[Integral],[Propeid],[Recommend],[Priority],[MonthClickNum],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID]) VALUES ( 6,6,29,0,129,6,0,N'20152271175679146881',N'北京旅游',N'张',0,0,3,7,0,1,0,-1,-1,10,1,0,0.0000,1,3,20.0000,20.0000,N'0',N'0',0,1,N'[{"code":"5bd6u8","Proname":"成人","LinPrice":"120","ShiPrice":"100"},{"code":"pzFU9c","Proname":"儿童","LinPrice":"80","ShiPrice":"50"}]',0,0,0,0,0,N'admin',0,N'2016/2/27 11:07:56',N'2016/10/10 18:32:32',N'ZL_P_Shop',1,0,0,0,1,0,0,56,0,0,0.0000,1,0,0.0000,1,0,0,1,2,0,0,0.0000,0,0,N'1',1,N'{
"purse": "0.00",
"sicon": "0.00",
"point": "0.00"
}',0,0)
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[Kayword],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[IDCPrice]) VALUES ( 7,7,4,0,2,6,0,N'212016072900001',N'IDC示例商品',N'IDC',N'年',0,0,0,6,0,1,1,-1,-1,10,1,0,0.0000,1,3,0.0000,1.0000,0,0,0,0,0,0,N'admin',1,N'2016/7/29 19:14:01',N'2016/7/29 19:14:01',N'ZL_P_Shop',1,0,0,0,1,0,0,59,0,0,0.0000,0,0,0.0000,0,0,0,0,2,0,0,0.0000,0,0,N'0',0,N'{
"purse": "0",
"sicon": "0",
"point": "0"
}',0,0,N'[{"name":"7天 ¥30.00","time":"7天","price":"30"},{"name":"15天 ¥50.00","time":"15天","price":"50"},{"name":"1月 ¥90.00","time":"1月","price":"90"},{"name":"季度 ¥300.00","time":"季度","price":"300"},{"name":"半年 ¥500.00","time":"半年","price":"500"},{"name":"1年 ¥900.00","time":"1年","price":"900"},{"name":"2年 ¥1500.00","time":"2年","price":"1500"},{"name":"无限期 ¥5000.00","time":"无限期","price":"5000"}]')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 8,8,1,0,25,20,0,N'212017011000001',N'示例店铺商品',N'件',0,0,0,1,0,1,N'示例店铺商品',N'<p>示例店铺商品</p>',N'demo/04.jpg',N'demo/04.jpg',1,0,0,10,0,0,0.0000,1,1,99.0000,59.0000,0,0,0,0,0,0,N'admin',1,N'2017/1/10 18:41:51',N'2017/1/10 18:41:51',N'ZL_S_shop',1,0,0,0,1,0,1,0,2,0,0.0000,0,0,0.0000,0,0,0,0,3,0,59,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,0,N'示例店铺商')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Procontent],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[DownCar],[AddTime],[UpdateTime],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[GuessXML],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[ExpRemind],[ParentID],[UserID],[ShortProName]) VALUES ( 9,9,0,2,2,6,0,N'212017022700001',N'促销组合一',N'件',0,0,0,1,0,1,N'[{"id":"2","name":"示例商品二","price":"688.00","suitnum":1},{"id":"1","name":"示例商品之一","price":"80.00","suitnum":1}]',1,0,0,0,0,0,0.0000,0,3,700.0000,700.0000,0,0,0,0,0,0,1,N'2017/2/27 13:56:49',N'2017/2/27 13:56:49',1,0,0,0,1,0,0,0,1,0,0.0000,0,0,0.0000,0,0,0,0,N'drawback',2,0,0,0.0000,0,0,0,0,0,N'促销组合一')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Producer],[Brand],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 10,10,4,0,177,6,0,N'212017041000001',N'Apple iPhone 7 128G 红色特别版',N'件',0,0,0,1,0,1,N'Apple iPhone 7 128G 红色特别版',N'<p>4.7 英寸(对角线)显示屏,1334 x 750 分辨率 </p><p>3D Touch</p><p>1200 万像素摄像头</p><p>配备嵌入式 M10 运动协处理器的 A10 Fusion 芯片</p><p>4K 视频拍摄 (30 fps) 以及慢动作视频拍摄 (120 fps, 1080p)</p><p>配备 Retina 闪光灯的 700 万像素 FaceTime HD 摄像头</p><p>内置于主屏幕按钮的 Touch ID 指纹识别传感器</p><p>具备 MIMO 技术的 802.11a/b/g/n/ac 无线网络</p><p>法律免责声明</p><p>1 iPhone 7 和 iPhone 7 Plus 可防溅、抗水、防尘,在受控实验室条件下经测试,其效果在 IEC 60529 标准下达到 IP67 级别。防溅、抗水、防尘功能并非永久有效,防护性能可能会因日常磨损而下降。请勿为潮湿状态下的 iPhone 充电;请参阅使用手册了解清洁和干燥说明。由于浸入液体而导致的损坏不在保修范围之内。</p><p>2 亮黑色 iPhone 7 和 iPhone 7 Plus 高光泽度的外观,采用包含九道精密工序的阳极氧化与抛光工艺打造而成。其表面硬度与其他采用阳极氧化处理的 Apple 产品相同;但是,高光泽度表面可能随着日常使用而出现细微磨损。如果对此有所担心,建议你选择一款合适的保护壳来保护你的 iPhone。</p><p>3 Apple Pay 仅在部分市场提供。请到苹果官网查看 Apple Pay 适用的国家和地区列表。</p><p>4 所有电池性能信息取决于网络设置和许多其它因素,实际结果可能有所不同。电池充电周期次数有限,最终可能需由 Apple 服务提供商更换。 电池使用时间和充电周期次数依设置和使用情况的不同而可能有所差异。详情请参阅 www.apple.com/cn/batteries 和 www.apple.com/cn/iphone/battery.html。</p><p>5 需要使用数据计划。4G LTE Advanced 和 4G LTE 功能适用于特定国家或地区的特定运营商。速度依据理论上的数据吞吐量,并基于现场状况和不同运营商而可能有所差异。有关 4G LTE 支持的详情,请联系你的运营商并查看 www.apple.com/iphone/LTE。</p><p>6 亮黑色的 iPhone 7 和 iPhone 7 Plus 仅提供 128GB 和 256GB 机型。</p><p>7 实际可供使用的空间小于总容量,并会因许多因素而可能有所差异。</p><p>8 某些功能仅适用于部分国家或地区。烦请到苹果官网查看详情</p><p>9 所有产品信息,以苹果官网为准(apple.com.cn)</p><p> </p><p>技术规格 </p><p>请前往 www.apple.com/cn/iphone-7/specs/ 查看完整内容。</p>',N'System/field/images/20170329/20170329wpc8yA.jpg',N'System/field/images/20170329/20170329wpc8yA.jpg',N'0',N'0',1,0,0,10,0,0,0.0000,1,3,6288.0000,6288.0000,0,0,0,0,0,0,N'admin',1,N'2017/4/10 17:48:54',N'2017/4/10 17:48:54',N'ZL_P_Shop',1,0,0,0,1,0,0,0,5,0,0.0000,0,0,0.0000,0,0,0,0,144,0,0,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,0,N'Apple')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 11,11,2,0,178,20,0,N'212017041000002',N'香槟酒法国青口',N'件',0,0,0,1,0,1,N'香槟酒法国青口',N'<p><img src="/UploadFiles/Image/20170410/6362744428277491261485607.jpg" title="recipe_36891_39211.jpg" alt="recipe_36891_39211.jpg"/></p>',N'Image/20170410/6362744428277491261485607.jpg',N'Image/20170410/6362744428277491261485607.jpg',1,0,0,10,0,0,0.0000,1,1,999.0000,999.0000,0,0,0,0,0,0,N'金狮蓝蒂',1,N'2017/4/10 17:53:53',N'2017/4/10 17:53:53',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,144,0,73,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,3,N'香槟酒法国')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 12,12,3,0,178,20,0,N'212017041000003',N'烤南美大虾',N'件',0,0,0,1,0,1,N'烤南美大虾',N'<p>烤南美大虾</p>',N'System/field/images/20170329/20170329Pm6cJf.jpg',N'System/field/images/20170329/20170329Pm6cJf.jpg',1,0,0,10,0,0,0.0000,1,1,20.0000,10.0000,0,0,0,0,0,0,N'炭香园自助烧烤',1,N'2017/4/10 18:08:09',N'2017/4/10 18:08:09',N'ZL_S_shop',1,0,0,0,1,0,0,0,1,0,0.0000,0,0,0.0000,0,0,0,0,144,0,74,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,4,N'烤南美大虾')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 13,13,4,0,201,20,0,N'212017041100001',N'百草味 坚果干果 开心果200g/袋 炒货零食',N'件',0,0,0,1,0,1,N'百草味 坚果干果 开心果200g/袋 炒货零食',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750140238112757632237.jpg"/></p><p style="white-space: normal;">百草味 坚果干果 开心果200g/袋 炒货零食</p>',N'Image/20170411/6362750140238112757632237.jpg',N'Image/20170411/6362750140238112757632237.jpg',1,0,0,10,0,0,0.0000,1,1,30.0000,28.9000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 9:54:47',N'2017/4/11 9:54:47',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'百草味 坚')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 14,14,6,0,201,20,0,N'212017041100002',N'内蒙古科尔沁 休闲零食 风干牛肉干五香味400g',N'件',0,0,0,1,0,1,N'内蒙古科尔沁 休闲零食 风干牛肉干五香味400g',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750166765507753220198.jpg" title="56651e90Naa7ab8b8.jpg" alt="56651e90Naa7ab8b8.jpg"/></p><p style="white-space: normal;">内蒙古科尔沁 休闲零食 风干牛肉干五香味400g</p><p><br/></p>',N'Image/20170411/6362750166765507753220198.jpg',N'Image/20170411/6362750166765507753220198.jpg',1,0,0,10,0,0,0.0000,1,1,100.0000,99.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 9:58:47',N'2017/4/11 9:58:47',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'内蒙古科尔')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 15,15,7,0,201,20,0,N'212017041100003',N'百草味 休闲零食 精制猪肉脯200g/袋 靖江肉干肉铺 零食特产小吃',N'件',0,0,0,1,0,1,N'百草味 休闲零食 精制猪肉脯200g/袋 靖江肉干肉铺 零食特产小吃',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750178443079792077573.jpg" title="570d2cbcN0d0776b3.jpg" alt="570d2cbcN0d0776b3.jpg"/></p><p style="white-space: normal;">百草味 休闲零食 精制猪肉脯200g/袋 靖江肉干肉铺 零食特产小吃</p><p><br/></p>',N'Image/20170411/6362750178443079792077573.jpg',N'Image/20170411/6362750178443079792077573.jpg',1,0,0,10,0,0,0.0000,1,1,20.0000,17.8000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:02:37',N'2017/4/11 10:02:37',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'百草味 休')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 16,16,8,0,201,20,0,N'212017041100004',N'沃隆 每日坚果 成人款 25g*30包 750g',N'件',0,0,0,1,0,1,N'沃隆 每日坚果 成人款 25g*30包 750g',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750199536030522006647.jpg" title="56555bbdNa94e0209.jpg" alt="56555bbdNa94e0209.jpg"/></p><p style="white-space: normal;">沃隆 每日坚果 成人款 25g*30包 750g</p><p><br/></p>',N'Image/20170411/6362750199536030522006647.jpg',N'Image/20170411/6362750199536030522006647.jpg',1,0,0,10,0,0,0.0000,1,1,150.0000,148.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:06:12',N'2017/4/11 10:06:12',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'沃隆 每日')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 17,17,9,0,201,20,0,N'212017041100005',N'韩国进口海牌海苔2g*40包',N'件',0,0,0,1,0,1,N'韩国进口海牌海苔2g*40包',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750217217091872588519.jpg" title="54cb5c7aNf9a28e62.jpg" alt="54cb5c7aNf9a28e62.jpg"/></p><p style="white-space: normal;">韩国进口海牌海苔2g*40包</p><p><br/></p>',N'Image/20170411/6362750217217091872588519.jpg',N'Image/20170411/6362750217217091872588519.jpg',1,0,0,10,0,0,0.0000,1,1,40.0000,39.9000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:09:21',N'2017/4/11 10:09:21',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'韩国进口海')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 18,18,10,0,201,20,0,N'212017041100006',N'越南进口利葡面包干300g*2袋(Lipo商品名称更换中随机发货)',N'件',0,0,0,1,0,1,N'越南进口利葡面包干300g*2袋(Lipo商品名称更换中随机发货)',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750223499394112027278.jpg" title="56e0ebf7N28ec31f5.jpg" alt="56e0ebf7N28ec31f5.jpg"/></p><p style="white-space: normal;">越南进口利葡面包干300g*2袋(Lipo商品名称更换中随机发货)</p><p><br/></p>',N'Image/20170411/6362750223499394112027278.jpg',N'Image/20170411/6362750223499394112027278.jpg',1,0,0,10,0,0,0.0000,1,1,30.0000,27.8000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:10:15',N'2017/4/11 10:10:15',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'越南进口利')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 19,19,11,0,202,20,0,N'212017041100007',N'Ochirly欧时力2016新女夏装蕾丝拼接假两件伞裙连衣裙1HY2084050 粉红180 M',N'件',0,0,0,1,0,1,N'Ochirly欧时力2016新女夏装蕾丝拼接假两件伞裙连衣裙1HY2084050 粉红180 M',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750228597412596489828.jpg" title="571722aeNe91a0144.jpg" alt="571722aeNe91a0144.jpg"/></p><p style="white-space: normal;">Ochirly欧时力2016新女夏装蕾丝拼接假两件伞裙连衣裙1HY2084050 粉红180 M</p><p><br/></p>',N'Image/20170411/6362750228597412596489828.jpg',N'Image/20170411/6362750228597412596489828.jpg',1,0,0,10,0,0,0.0000,1,1,600.0000,559.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:11:15',N'2017/4/11 10:11:15',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'Ochir')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 20,20,12,0,202,20,0,N'212017041100008',N'红袖2016夏装新款 知性清爽细条纹短款套头衬衫女 E6201C402 906白底蓝条 S',N'件',0,0,0,1,0,1,N'红袖2016夏装新款 知性清爽细条纹短款套头衬衫女 E6201C402 906白底蓝条 S',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750241482379538321878.jpg" title="56e12b7bN279c5afc.jpg" alt="56e12b7bN279c5afc.jpg"/></p><p style="white-space: normal;">红袖2016夏装新款 知性清爽细条纹短款套头衬衫女 E6201C402 906白底蓝条 S</p><p><br/></p>',N'Image/20170411/6362750241482379538321878.jpg',N'Image/20170411/6362750241482379538321878.jpg',1,0,0,10,0,0,0.0000,1,1,200.0000,199.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:13:10',N'2017/4/11 10:13:10',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'红袖201')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 21,21,13,0,202,20,0,N'212017041100009',N'红袖2016夏装新款 清爽白领风尚短款开衫衬衫 E6202C206 007白色 S',N'件',0,0,0,1,0,1,N'红袖2016夏装新款 清爽白领风尚短款开衫衬衫 E6202C206 007白色 S',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750251881088052888542.jpg" title="56e27f91Nab8057a9.jpg" alt="56e27f91Nab8057a9.jpg"/></p><p style="white-space: normal;">红袖2016夏装新款 清爽白领风尚短款开衫衬衫 E6202C206 007白色 S</p><p><br/></p>',N'Image/20170411/6362750251881088052888542.jpg',N'Image/20170411/6362750251881088052888542.jpg',1,0,0,10,0,0,0.0000,1,1,300.0000,279.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:14:49',N'2017/4/11 10:14:49',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'红袖201')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 22,22,14,0,204,20,0,N'212017041100010',N'佳能(Canon) EOS 70D 单反套机',N'件',0,0,0,1,0,1,N'佳能革新的自动对焦,约2020万像素 — 带来高精细成像的CMOS图像感应器。走进单反的世界',N'<p>Dual Pixel CMOS AF(全像素双核CMOS AF)凝聚了EOS全新科技,当启用液晶监视器进行实时显示拍摄时,将带来CMOS像面高速相差检测自动对焦,可获得与使用取景器拍摄接近的对焦速度,以及比取景器更宽广的对焦范围,使液晶监视器成为第二个“取景器”。这项技术将改变对实时显示拍摄的传统认知。而利用传统取景器拍摄时,引以为傲的中央八向双十字全19点十字型自动对焦系统,能够准确捕捉到精彩瞬间,不论是发烧友还是专业摄影师的要求都能得到满足。现在 ,用户可以根据场景的不同,区分这两种“取景器”的优势进行使用。拍摄风格的范围将大大扩展,可拍摄出之前难以实现的照片。 Dual Pixel CMOS AF或将改变数码单反相机的使用方式。</p><p style="text-align:center"><img src="/UploadFiles/Image/20170411/6362750272363174215878834.jpg"/></p><p><br/></p>',N'Image/20170411/6362750272363174215878834.jpg',N'Image/20170411/6362750272363174215878834.jpg',1,0,0,10,0,0,0.0000,1,1,6900.0000,6800.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:17:40',N'2017/4/11 10:17:40',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'佳能(Ca')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 23,23,15,0,204,20,0,N'212017041100011',N'卡西欧(CASIO)EX-TR600 数码相机',N'件',0,0,0,1,0,1,N'美,是TR的标签, 美,亦是TR的使命 ;全新自拍神器!部分地区可极速达,自营品质保障',N'<p>美,是TR的标签, 美,亦是TR的使命 ;全新自拍神器!部分地区可极速达,自营品质保障</p><p><img src="/UploadFiles/Image/20170411/6362750304024350091885535.jpg" title="201604285qj0zz.jpg" alt="201604285qj0zz.jpg"/></p>',N'Image/20170411/6362750304024350091885535.jpg',N'Image/20170411/6362750304024350091885535.jpg',1,0,0,10,0,0,0.0000,1,1,6199.0000,6099.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:22:23',N'2017/4/11 10:22:23',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'卡西欧(C')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 24,24,16,0,204,20,0,N'212017041100012',N'任e行((Rexing))D3 行车记录仪双镜头高清后视镜款倒车影像1080P一体机',N'件',0,0,0,1,0,1,N'任e行((Rexing))D3 行车记录仪双镜头高清后视镜款倒车影像1080P一体机',N'<p>任e行((Rexing))D3 行车记录仪双镜头高清后视镜款倒车影像1080P一体机</p>',N'System/field/images/20170411/20170411ZeLh1X.jpg',N'System/field/images/20170411/20170411ZeLh1X.jpg',1,0,0,10,0,0,0.0000,1,1,300.0000,288.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:25:17',N'2017/4/11 10:25:17',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'任e行((')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 25,25,17,0,204,20,0,N'212017041100013',N'帝狼TS400智能行车记录仪高清广角夜视1296P Wifi无线遥控记录仪 一.TS400金色+不带遥控+无卡',N'件',0,0,0,1,0,1,N'帝狼TS400智能行车记录仪高清广角夜视1296P Wifi无线遥控记录仪 一.TS400金色+不带遥控+无卡',N'<p>帝狼TS400智能行车记录仪高清广角夜视1296P Wifi无线遥控记录仪 一.TS400金色+不带遥控+无卡</p>',N'System/field/images/20170411/20170411Py4nOt.jpg',N'System/field/images/20170411/20170411Py4nOt.jpg',1,0,0,10,0,0,0.0000,1,1,369.0000,345.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:30:20',N'2017/4/11 10:30:20',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'帝狼TS4')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 26,26,18,0,203,20,0,N'212017041100014',N'kay时代 现代双人床 皮床 1.8米',N'件',0,0,0,1,0,1,N'真皮床+椰棕两面双用床垫+床头柜 668 1.8*2.0米床+床垫+1柜',N'<p>真皮床+椰棕两面双用床垫+床头柜 668 1.8*2.0米床+床垫+1柜</p>',N'System/field/images/20170411/20170411sQbQsE.jpg',N'System/field/images/20170411/20170411sQbQsE.jpg',1,0,0,10,0,0,0.0000,1,1,3220.0000,3120.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:33:45',N'2017/4/11 10:33:45',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'kay时代')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 27,27,19,0,202,20,0,N'212017041100015',N'美特斯邦威男棒球服针织开衫ZY 红色 170/92A',N'件',0,0,0,1,0,1,N'商品名称:美特斯邦威男棒球服针织开衫ZY 红色 170/92A
商品编号:1729363707',N'<p>商品名称:美特斯邦威男棒球服针织开衫ZY 红色 170/92A</p><p>商品编号:1729363707</p><p><br/></p>',N'System/field/images/20170411/201704112WfMUJ.jpg',N'System/field/images/20170411/201704112WfMUJ.jpg',1,0,0,10,0,0,0.0000,1,1,158.0000,120.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:36:59',N'2017/4/11 10:36:59',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'美特斯邦威')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 28,28,20,0,202,20,0,N'212017041100016',N'2016春装新款棒球服男卫衣运动套装 深蓝色',N'件',0,0,0,1,0,1,N'【新春焕装 限量500件 】2016春装新款棒球服男卫衣运动套装 深蓝色商品编号:10117664853',N'System/field/images/20170411/20170411wwoZPE.jpg',N'System/field/images/20170411/20170411wwoZPE.jpg',1,0,0,10,0,0,0.0000,1,1,99.0000,88.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:39:12',N'2017/4/11 10:39:12',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'2016春')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 29,29,21,0,201,20,0,N'212017041100017',N'手造麻薯1050g 麻薯礼盒饼干糕点零食',N'件',0,0,0,1,0,1,N'51出游68包邮还送兰花豆,满128顺丰包邮,满158送U盘,更有199减100',N'<p>51出游68包邮还送兰花豆,满128顺丰包邮,满158送U盘,更有199减100</p>',N'System/field/images/20170411/20170411Rt0Amk.jpg',N'System/field/images/20170411/20170411Rt0Amk.jpg',1,0,0,10,0,0,0.0000,1,1,32.9000,30.0000,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:41:55',N'2017/4/11 10:41:55',N'ZL_S_shop',1,0,0,0,1,1,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'手造麻薯1')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 30,30,22,0,201,20,0,N'212017041100018',N'百草味 肉脯零食 牛肉干100g/袋 肉类小吃牛肉片五香味',N'件',0,0,0,1,0,1,N'百草味 肉脯零食 牛肉干100g/袋 肉类小吃牛肉片五香味',N'<p>百草味 肉脯零食 牛肉干100g/袋 肉类小吃牛肉片五香味</p>',N'System/field/images/20170411/20170411Por8VQ.jpg',N'System/field/images/20170411/20170411Por8VQ.jpg',1,0,0,10,0,0,0.0000,1,1,18.9000,0.0100,0,0,0,0,0,0,N'爱上木数码',1,N'2017/4/11 10:43:06',N'2017/4/11 10:43:06',N'ZL_S_shop',1,0,0,0,1,1,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,81,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,5,N'百草味 肉')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 31,31,23,0,205,20,0,N'212017041100019',N'瑞动SWISSMOBILITY 拉杆箱',N'件',0,0,0,1,0,1,N'缤纷5月,箱包特惠!24寸国际旅行出差适用,细节不肯将就/外观不肯平庸/色彩不肯单调',N'<p>缤纷5月,箱包特惠!24寸国际旅行出差适用,细节不肯将就/外观不肯平庸/色彩不肯单调</p>',N'System/field/images/20170411/20170411okAOrI.jpg',N'System/field/images/20170411/20170411okAOrI.jpg',1,0,0,10,0,0,0.0000,1,1,254.0000,235.0000,0,0,0,0,0,0,N'达芙妮鞋店',1,N'2017/4/11 10:46:13',N'2017/4/11 10:46:13',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,82,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,6,N'瑞动SWI')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 32,32,24,0,205,20,0,N'212017041100020',N'新秀丽Samsonite ENGENERO优雅 万向轮登机箱',N'件',0,0,0,1,0,1,N'新春“放假”,感恩钜惠,新秀丽专场品牌特惠,爆款热卖',N'<p>新春“放假”,感恩钜惠,新秀丽专场品牌特惠,爆款热卖</p>',N'System/field/images/20170411/20170411N374D7.jpg',N'System/field/images/20170411/20170411N374D7.jpg',1,0,0,10,0,0,0.0000,1,1,2179.0000,2179.0000,0,0,0,0,0,0,N'达芙妮鞋店',1,N'2017/4/11 10:50:51',N'2017/4/11 10:50:51',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,82,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,6,N'新秀丽Sa')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 33,33,25,0,205,20,0,N'212017041100021',N'维艾 面条机压面机家用手动多功能不锈钢馄饨饺子皮擀面机',N'件',0,0,0,1,0,1,N'送包饺子五件套【拒绝黑心面,自己做面条,安全健康,简易操作,口感筋道】',N'<p>送包饺子五件套【拒绝黑心面,自己做面条,安全健康,简易操作,口感筋道】</p>',N'System/field/images/20170411/2017041158Mrd1.jpg',N'System/field/images/20170411/2017041158Mrd1.jpg',1,0,0,10,0,0,0.0000,1,1,99.0000,88.0000,0,0,0,0,0,0,N'达芙妮鞋店',1,N'2017/4/11 10:53:23',N'2017/4/11 10:53:23',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,82,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,6,N'维艾 面条')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 34,34,26,0,204,20,0,N'212017041100022',N'美之扣手动绞肉机',N'件',0,0,0,1,0,1,N'家用多功能切菜器 绞馅机',N'<p>家用多功能切菜器 绞馅机</p>',N'System/field/images/20170411/20170411pbbseL.jpg',N'System/field/images/20170411/20170411pbbseL.jpg',1,0,0,10,0,0,0.0000,1,1,199.0000,199.0000,0,0,0,0,0,0,N'达芙妮鞋店',1,N'2017/4/11 10:55:45',N'2017/4/11 10:55:45',N'ZL_S_shop',1,0,0,0,1,1,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,82,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,6,N'美之扣手动')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 35,35,27,0,203,20,0,N'212017041100023',N'朗司 淋浴房整体 简易浴室 钢化玻璃隔断浴屏洗浴房整体浴室',N'件',0,0,0,1,0,1,N'扇形定制WL101 8mm厚玻璃 900*900mm/送石基',N'<p>扇形定制WL101 8mm厚玻璃 900*900mm/送石基</p>',N'System/field/images/20170411/20170411Srzy9i.jpg',N'System/field/images/20170411/20170411Srzy9i.jpg',1,0,0,10,0,0,0.0000,1,1,1199.0000,1099.0000,0,0,0,0,0,0,N'达芙妮鞋店',1,N'2017/4/11 10:57:31',N'2017/4/11 10:57:31',N'ZL_S_shop',1,0,0,0,1,1,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,82,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,6,N'朗司 淋浴')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 36,36,28,0,203,20,0,N'212017041100024',N'一米青品 护眼落地灯可爱创意时尚卧室客厅落地台灯儿童房',N'件',0,0,0,1,0,1,N'儿童房卡通送孩子落地工作学习创意礼品台灯 黑脸猫不可调光款',N'<p>儿童房卡通送孩子落地工作学习创意礼品台灯 黑脸猫不可调光款</p>',N'System/field/images/20170411/20170411q00vIy.jpg',N'System/field/images/20170411/20170411q00vIy.jpg',1,0,0,10,0,0,0.0000,1,1,158.0000,138.0000,0,0,0,0,0,0,N'达芙妮鞋店',1,N'2017/4/11 10:58:38',N'2017/4/11 10:58:38',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,82,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,6,N'一米青品')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 37,37,29,0,202,20,0,N'212017041100025',N'春秋女士打底裤外穿薄款高腰弹力大码',N'件',0,0,0,1,0,1,N'时尚版型设计 修身百搭 外穿显瘦 超弹透气',N'<p>时尚版型设计 修身百搭 外穿显瘦 超弹透气</p>',N'System/field/images/20170411/20170411fQqL4m.jpg',N'System/field/images/20170411/20170411fQqL4m.jpg',1,0,0,10,0,0,0.0000,1,1,20.0000,18.0000,0,0,0,0,0,0,N'达芙妮鞋店',1,N'2017/4/11 11:04:13',N'2017/4/11 11:04:13',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,82,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,6,N'春秋女士打')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 38,38,30,0,202,20,0,N'212017041100026',N'施豪特斯(SHTS)穿衣镜',N'件',0,0,0,1,0,1,N'优雅落地穿衣镜加宽型试衣镜全身镜DHSW-650 白色',N'<p>优雅落地穿衣镜加宽型试衣镜全身镜DHSW-650 白色</p>',N'System/field/images/20170411/201704118gZ1uo.jpg',N'System/field/images/20170411/201704118gZ1uo.jpg',1,0,0,10,0,0,0.0000,1,1,199.0000,188.0000,0,0,0,0,0,0,N'达芙妮鞋店',1,N'2017/4/11 11:05:33',N'2017/4/11 11:05:33',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,82,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,6,N'施豪特斯(')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 39,39,31,0,203,20,0,N'212017041100027',N'冠雅 LED护眼灯 学生学习台灯触摸可折叠工作卧室床头阅读调光灯LA-A608 白色',N'件',0,0,0,1,0,1,N'冠雅 LED护眼灯 学生学习台灯触摸可折叠工作卧室床头阅读调光灯LA-A608 白色',N'<p><img src="/UploadFiles/Image/20170411/6362750580467459017158555.jpg" title="5711abbcN03da0756.jpg" alt="5711abbcN03da0756.jpg"/></p>',N'Image/20170411/6362750580467459017158555.jpg',N'Image/20170411/6362750580467459017158555.jpg',1,0,0,10,0,0,0.0000,1,1,200.0000,198.0000,0,0,0,0,0,0,N'旧金山海归',1,N'2017/4/11 11:09:39',N'2017/4/11 11:09:39',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,90,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,14,N'冠雅 LE')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 40,40,32,0,203,20,0,N'212017041100028',N'红瑞 床品家纺 单人爽肤夏凉被 一剪梅 150*200cm',N'件',0,0,0,1,0,1,N'红瑞 床品家纺 单人爽肤夏凉被 一剪梅 150*200cm',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750589588241964961925.jpg" title="5707c60fN4f57dd9f.jpg" alt="5707c60fN4f57dd9f.jpg"/></p><p style="white-space: normal;">红瑞 床品家纺 单人爽肤夏凉被 一剪梅 150*200cm</p><p><br/></p>',N'Image/20170411/6362750589588241964961925.jpg',N'Image/20170411/6362750589588241964961925.jpg',1,0,0,10,0,0,0.0000,1,1,100.0000,79.0000,0,0,0,0,0,0,N'旧金山海归',1,N'2017/4/11 11:11:16',N'2017/4/11 11:11:16',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,90,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,14,N'红瑞 床品')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 41,41,33,0,203,20,0,N'212017041100029',N'英国Joseph Joseph正品 多功能厨房用具整理槽 厨房神器收纳架 白色/绿色',N'件',0,0,0,1,0,1,N'英国Joseph Joseph正品 多功能厨房用具整理槽 厨房神器收纳架 白色/绿色',N'<p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750603319926541573848.jpg" title="540885c7Na8680a0b.jpg" alt="540885c7Na8680a0b.jpg"/></p><p style="white-space: normal;">英国Joseph Joseph正品 多功能厨房用具整理槽 厨房神器收纳架 白色/绿色</p><p><br/></p>',N'Image/20170411/6362750603319926541573848.jpg',N'Image/20170411/6362750603319926541573848.jpg',1,0,0,10,0,0,0.0000,1,1,300.0000,249.0000,0,0,0,0,0,0,N'旧金山海归',1,N'2017/4/11 11:13:29',N'2017/4/11 11:13:29',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,90,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,14,N'英国Jos')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 42,42,34,0,203,20,0,N'212017041100030',N'水星家纺 奥斯丁玫瑰四孔春秋被 粉色被芯 双人被子200*230cm',N'件',0,0,0,1,0,1,N'水星家纺 奥斯丁玫瑰四孔春秋被 粉色被芯 双人被子200*230cm',N'<p style="white-space: normal;">水星家纺 奥斯丁玫瑰四孔春秋被 粉色被芯 双人被子200*230cm</p><p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750609689041513584539.jpg" title="551378d2N404652a1.jpg" alt="551378d2N404652a1.jpg"/></p><p><br/></p>',N'Image/20170411/6362750609689041513584539.jpg',N'Image/20170411/6362750609689041513584539.jpg',1,0,0,10,0,0,0.0000,1,1,200.0000,149.0000,0,0,0,0,0,0,N'旧金山海归',1,N'2017/4/11 11:14:27',N'2017/4/11 11:14:27',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,90,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,14,N'水星家纺')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 43,43,35,0,203,20,0,N'212017041100031',N'红瑞 床品家纺 三开门方顶加密双拉链坐床式蚊帐 米黄 1.5米床',N'件',0,0,0,1,0,1,N'红瑞 床品家纺 三开门方顶加密双拉链坐床式蚊帐 米黄 1.5米床',N'<p style="white-space: normal;">红瑞 床品家纺 三开门方顶加密双拉链坐床式蚊帐 米黄 1.5米床</p><p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750620030002232792890.jpg" title="56a31447N20c2a5f5.jpg" alt="56a31447N20c2a5f5.jpg"/></p><p><br/></p>',N'Image/20170411/6362750620030002232792890.jpg',N'Image/20170411/6362750620030002232792890.jpg',1,0,0,10,0,0,0.0000,1,1,200.0000,199.0000,0,0,0,0,0,0,N'旧金山海归',1,N'2017/4/11 11:16:31',N'2017/4/11 11:16:31',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,90,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,14,N'红瑞 床品')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 44,44,36,0,203,20,0,N'212017041100032',N'家逸 松木折叠挂衣架 实木衣帽架 卧室落地挂衣架 创意欧式木质衣服架子衣架',N'件',0,0,0,1,0,1,N'家逸 松木折叠挂衣架 实木衣帽架 卧室落地挂衣架 创意欧式木质衣服架子衣架',N'<p style="white-space: normal;">家逸 松木折叠挂衣架 实木衣帽架 卧室落地挂衣架 创意欧式木质衣服架子衣架</p><p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750626073241041161313.jpg" title="54574f17N266f7090.jpg" alt="54574f17N266f7090.jpg"/></p><p><br/></p>',N'Image/20170411/6362750626073241041161313.jpg',N'Image/20170411/6362750626073241041161313.jpg',1,0,0,10,0,0,0.0000,1,1,200.0000,158.0000,0,0,0,0,0,0,N'旧金山海归',1,N'2017/4/11 11:17:18',N'2017/4/11 11:17:18',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,90,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,14,N'家逸 松木')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 45,45,37,0,204,20,0,N'212017041100033',N'博都家具 床 实木床 双人床金丝檀木床卧室高箱储物床1.8米大床811 标准床 1800*2000',N'件',0,0,0,1,0,1,N'博都家具 床 实木床 双人床金丝檀木床卧室高箱储物床1.8米大床811 标准床 1800*2000',N'<p style="white-space: normal;">博都家具 床 实木床 双人床金丝檀木床卧室高箱储物床1.8米大床811 标准床 1800*2000</p><p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750648738935244351256.jpg" title="56a5933eNfdcf22b4.jpg" alt="56a5933eNfdcf22b4.jpg"/></p><p><br/></p>',N'Image/20170411/6362750648738935244351256.jpg',N'Image/20170411/6362750648738935244351256.jpg',1,0,0,10,0,0,0.0000,1,1,4999.0000,4099.0000,0,0,0,0,0,0,N'旧金山海归',1,N'2017/4/11 11:21:17',N'2017/4/11 11:21:17',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,90,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,14,N'博都家具')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 46,46,38,0,205,20,0,N'212017041100034',N'永久27速自行车 锁死前叉/2培林花鼓/铝合金26寸山地车/建大轮胎/轴承中轴 乐途 黑绿色 27速',N'件',0,0,0,1,0,1,N'永久27速自行车 锁死前叉/2培林花鼓/铝合金26寸山地车/建大轮胎/轴承中轴 乐途 黑绿色 27速',N'<p style="white-space: normal;">永久27速自行车 锁死前叉/2培林花鼓/铝合金26寸山地车/建大轮胎/轴承中轴 乐途 黑绿色 27速</p><p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750670678745136587621.jpg" title="566ecf95Na5161c4a.jpg" alt="566ecf95Na5161c4a.jpg"/></p><p><br/></p>',N'Image/20170411/6362750670678745136587621.jpg',N'Image/20170411/6362750670678745136587621.jpg',1,0,0,10,0,0,0.0000,1,1,1500.0000,1388.0000,0,0,0,0,0,0,N'旧金山海归',1,N'2017/4/11 11:24:58',N'2017/4/11 11:24:58',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,90,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,14,N'永久27速')
INSERT [ZL_Commodities] ([ID],[OrderID],[ItemID],[Class],[Nodeid],[ModelID],[Categoryid],[ProCode],[Proname],[ProUnit],[Weight],[ServerPeriod],[ServerType],[ProClass],[Properties],[Sales],[Proinfo],[Procontent],[Clearimg],[Thumbnails],[Allowed],[Quota],[DownQuota],[Stock],[StockDown],[JisuanFs],[Rate],[Rateset],[Dengji],[ShiPrice],[LinPrice],[Wholesales],[Wholesaleone],[Integral],[Propeid],[Recommend],[Priority],[AddUser],[DownCar],[AddTime],[UpdateTime],[TableName],[Istrue],[Isgood],[MakeHtml],[Sold],[isnew],[ishot],[isbest],[ComModelID],[AllClickNum],[Largess],[Largesspirx],[ProjectType],[ProjectPronum],[ProjectMoney],[IntegralNum],[PesentNameid],[Recycler],[GuessType],[FirstNodeID],[PointVal],[UserShopID],[BookPrice],[bookDay],[UserType],[FarePrice],[ExpRemind],[LinPrice_Json],[ParentID],[UserID],[ShortProName]) VALUES ( 47,47,39,0,205,20,0,N'212017041100035',N'捷豹 山地自行车21速26寸双碟刹变速山地车 男女学生公路单车减震前叉 21速高碳钢-标-白蓝',N'件',0,0,0,1,0,1,N'捷豹 山地自行车21速26寸双碟刹变速山地车 男女学生公路单车减震前叉 21速高碳钢-标-白蓝',N'<p style="white-space: normal;">捷豹 山地自行车21速26寸双碟刹变速山地车 男女学生公路单车减震前叉 21速高碳钢-标-白蓝</p><p style="white-space: normal;"><img src="/UploadFiles/Image/20170411/6362750677450076567666285.jpg" title="5649dfb9Nb49f70a8.jpg" alt="5649dfb9Nb49f70a8.jpg"/> </p><p><br/></p>',N'Image/20170411/6362750677450076567666285.jpg',N'Image/20170411/6362750677450076567666285.jpg',1,0,0,10,0,0,0.0000,1,1,400.0000,358.0000,0,0,0,0,0,0,N'旧金山海归',1,N'2017/4/11 11:25:58',N'2017/4/11 11:25:58',N'ZL_S_shop',1,0,0,0,1,0,0,0,0,0,0.0000,0,0,0.0000,0,0,0,0,179,0,90,0.0000,0,0,N'1',0,N'{
"purse": null,
"sicon": null,
"point": null
}',0,14,N'捷豹 山地')
SET IDENTITY_INSERT [ZL_Commodities] OFF
detele from ZL_Commodities
drop table ZL_Commodities
TRUNCATE table ZL_Commodities