表名:ZL_Commodities












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40  主键
2OrderIDint40    排序ID
3ItemIDint40    从表ID
4Classint40    [未用][备用字段]
5Nodeidint40    节点ID
6ModelIDint40    模型ID
7Categoryidint40    所属专题ID
8ProCodevarchar500    商品编号
9BarCodevarchar500    条形码
10Pronamevarchar2550    商品名称
11Kaywordvarchar2550    关键字
12ProUnitvarchar500    单位
13Weightint40    重量
14ServerPeriodint40    服务期限
15ServerTypeint40    期限日期格式[3-年2-月1-日0-无限期],页面显示用GetServerPeriod
16ProClassint40    商品类型[1:正常|店铺,2:特价,3:积分,4:团购,5:云购,6:IDC,7:旅游,8:酒店,9:机票]
17Propertiesint40    商品属性
18Salesint40    销售操作[1-允许销售,2-不允许]
19Proinfotext160    商品简介
20Procontenttext160    商品详细介绍
21Clearimgvarchar2550    商品清晰图
22Thumbnailsvarchar2550    商品缩略图
23Producervarchar2550    厂商
24Brandvarchar500    商标
25Allowedint40    1-缺货允许购买,0-不允许购买
26Quotaint40    限制购买数量[购买上限]-1不限制
27DownQuotaint40    最低购买数量[购买下限]-1不限制
28Stockint40    库存数量
29StockDownint40    最低库存数量[报警]
30JisuanFsint40    0-实际库存,1-虚拟库存(含订购)
31Ratemoney84    税率设置,百分数%
32Ratesetint40    税率设置
33Dengjiint40    推荐等级
34ShiPricemoney84    市场价
35LinPricemoney84    零售价
36MemberPricevarchar2550    会员价
37ActPricevarchar2550    [未用][备用字段]
38Wholesalesint40    是否允许批发 1:是
39Wholesaleoneint40    零售
40Wholesalesinfovarchar2550    多价格信息
41Presetvarchar2550    促销方案
42Integralint40    购物积分
43Propeidint40    自选购买数量
44Recommendint40    优惠率%数,不允许负数,不允许超过100,优惠5%,则减价5%
45Priorityint40    绑定销售(1=绑定 0=不绑定)
46MonthClickNumint40    [未用][备用字段]
47ModeTemplatevarchar2550    模型模板
48AddUservarchar2550    作者
49DownCarint40    [未用][备用字段](是否下架)
50AddTimedatetime83    添加时间
51UpdateTimedatetime83    更新时间类型
52TableNamevarchar500    模型表名
53Istrueint40    1:已审核,0:未审核
54Isgoodint40    [未用][备用字段]
55MakeHtmlint40    [未用][备用字段]
56Soldint40    购买商品人数
57isnewint40    新品
58ishotint40    热销
59isbestint40    精品
60ComModelIDint40    内容ID
61AllClickNumint40    点击数
62Largessint40    设为赠品(1-为赠品 0-非赠品)
63Largesspirxmoney84    赠品价格
64ProjectTypeint40    促销方案
65ProjectPronumint40    促销方案涉及到数字的字段
66ProjectMoneymoney84    方案涉及金钱的字段
67IntegralNumint40    购物数量送积分
68PesentNamesnvarchar2550    赠品名称
69PesentNameidint40    赠品ID
70Recyclerbit10    是否进入回收站
71ProSellernvarchar2550    商品卖家
72GuessTypeint40    备用字段
73GuessXMLnvarchar10000    商品属性,存储是否返修,竞猜,秒杀等字段等,repair,return
74FirstNodeIDint40    第一级节点
75PointValint40    赠送积分
76isStandint40    是否设为标准:0为否,1为是
77UserShopIDint40    店铺ID,StoreID
78BookPricemoney84    预订价
79bookDayint40    比节日时间提前多少天为预订价
80UserTypeint40    计价类型:0:不使用,1:为会员价,2:按会员组定价
81UserPricenvarchar10000    如果按会员组打折,格式为:会员组ID|价格
82FarePricenvarchar4000    运费模板ID( 0|50,1|100,2|200,快递,平邮,EMS(Disuse))
83ExpRemindint40    物流信息
84LinPrice_Jsonnvarchar5000    余额,银币,点数售价,前端标签取出后,转JSON判断输出
85ParentIDint40    所属于哪个商品
86UserIDint40    用户ID
87BindIDSvarchar40000    捆绑商品的IDS
88IDCPricentext160    IDC商品价格
89Quota_Jsonvarchar80000     
90DownQuota_Jsonvarchar80000     
91ShortProNamenvarchar1000    商品短名称

简要说明:

商城主表

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 分辨率&nbsp;</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/batterieswww.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> &nbsp;</p><p>技术规格&nbsp;</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"/>&nbsp; &nbsp;&nbsp;</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

--注意:清空且复位表ID序列为初始值

TRUNCATE table ZL_Commodities