GO
CREATE TABLE [dbo].[ZL_API_JsonP](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Alias] [nvarchar](50) NULL,
[PK] [nvarchar](50) NULL,
[Fields] [nvarchar](1000) NULL,
[T1] [nvarchar](2000) NULL,
[T2] [nvarchar](2000) NULL,
[WhereStr] [nvarchar](1000) NULL,
[ONStr] [nvarchar](1000) NULL,
[OrderStr] [nvarchar](1000) NULL,
[Params] [varchar](4000) NULL,
[MyState] [int] NULL,
[Remind] [nvarchar](200) NULL,
[AdminID] [int] NULL,
[CDate] [datetime] NULL,
[Remark] [nvarchar](1000) NULL,
CONSTRAINT [PK_ZL_API_JsonP] 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]

GO
SET IDENTITY_INSERT [ZL_API_JsonP] ON
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 1,N'product',N'ID',N'procontent,id,shiprice,proname',N'ZL_Commodities',N'procontent like @proid',N'[{"name":"proid","type":"like","defval":"0"}]',1,1,N'2017/2/27 14:01:14',N'获取指定商品套餐')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 2,N'propic',N'ID',N'thumbnails,shiprice',N'ZL_Commodities',N'ID=@proid',N'[{"name":"proid","type":"int","defval":"0"}]',1,1,N'2017/2/27 14:01:54',N'获取指定商品缩略图')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 3,N'shoplist',N'ID',N'id,thumbnails,proinfo,proname,linprice,shiprice,addtime,storename=(select Title from ZL_CommonModel left join ZL_Store_reg on ItemID=ID where GeneralID=UserShopID)',N'ZL_Commodities',N'(NodeID=@NodeID or FirstNodeID=@NodeID or NodeID in (select NodeID from ZL_Node where ParentID=@NodeID)) And Sales=1 And Istrue=1 And Recycler=0 And Proname like @Proname',N'AddTime DESC',N'[{"name":"NodeID","type":"int","defval":"180"},{"name":"Proname","type":"like","defval":""}]',1,1,N'2017/4/11 11:28:30',N'获取指定节点商品列表')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 4,N'nodeinfo',N'NodeID',N'nodename',N'ZL_Node',N'NodeID=@NodeID',N'[{"name":"NodeID","type":"int","defval":"0"}]',1,1,N'2017/4/11 11:29:06',N'获取指定节点名')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[T2],[WhereStr],[ONStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 5,N'proinfo',N'A.ID',N'A.id,A.nodeid,A.proname,A.proinfo,A.procontent,A.stock,A.shiprice,A.linprice,A.adduser,A.thumbnails,A.usershopid,A.userid,b.pics',N'ZL_Commodities',N'ZL_S_shop',N'A.ID=@ProID',N'A.ItemID=B.ID',N'A.AddTime DESC',N'[{"name":"ProID","type":"int","defval":"0"}]',1,1,N'2017/4/11 11:29:53',N'获取店铺商品信息')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[T2],[WhereStr],[ONStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 6,N'usershoplist',N'A.GeneralID',N'A.generalid,B.storename,B.logo,B.addr,B.area,B.lxr,B.tel',N'ZL_CommonModel',N'ZL_Store_reg',N'ModelID=24 And Status=99 And ShopType=@ShopType',N'A.ItemID=B.ID',N'A.CreateTime DESC',N'[{"name":"ShopType","type":"string","defval":""}]',1,1,N'2017/4/11 11:30:36',N'获取店铺列表')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[T2],[WhereStr],[ONStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 7,N'usershopdetail',N'A.GeneralID',N'B.storename,B.logo,B.addr,B.area,B.lxr,B.tel,B.content,B.pics,B.videourl',N'ZL_CommonModel',N'ZL_Store_reg',N'GeneralID=@GeneralID',N'A.ItemID=B.ID',N'[{"name":"GeneralID","type":"int","defval":"0"}]',1,1,N'2017/4/11 11:34:38',N'获取店铺详情')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 8,N'hotshop',N'ID',N'dengji,id,thumbnails,proinfo,proname,linprice,shiprice,addtime',N'ZL_Commodities',N'(NodeID=@NodeID or FIrstNodeID=@NodeID or NodeID in (select NodeID from ZL_Node where ParentID=@NodeID)) And Istrue=1 And Sales=1 And ishot=1 And Recycler=0',N'AddTime DESC',N'[{"name":"NodeID","type":"int","defval":"180"}]',1,1,N'2017/4/11 11:35:30',N'获取热销商品')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 9,N'userprolist',N'ID',N'id,thumbnails,proinfo,proname,linprice,shiprice,addtime',N'ZL_Commodities',N'UserShopID=@UserShopID And Sales=1 And Istrue=1 And Recycler=0',N'AddTime DESC',N'[{"name":"UserShopID","type":"int","defval":""}]',1,1,N'2017/4/11 11:36:01',N'获取指定店铺商品列表')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[T2],[WhereStr],[ONStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 10,N'articlelist',N'A.GeneralID',N'A.generalid,A.title,A.topimg,A.createtime,B.author',N'ZL_CommonModel',N'ZL_C_Article',N'(NodeID=@NodeID or FirstNodeID=@NodeID or NodeID in (select NodeID from ZL_Node where ParentID=@NodeID)) And Status=99',N'A.ItemID=B.ID',N'A.CreateTime DESC',N'[{"name":"NodeID","type":"int","defval":"181"}]',1,1,N'2017/4/11 11:36:43',N'获取指定节点下文章列表')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[T2],[WhereStr],[ONStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 11,N'getcontent',N'A.GeneralID',N'A.nodeid,A.generalid,A.title,A.createtime,A.hits,B.author,B.content',N'ZL_CommonModel',N'ZL_C_Article',N'GeneralID=@GeneralID',N'A.ItemID=B.ID',N'A.CreateTime DESC',N'[{"name":"GeneralID","type":"int","defval":""}]',1,1,N'2017/4/11 11:37:19',N'获取指定文章内容')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[OrderStr],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 12,N'userlist',N'UserID',N'userid,username,groupid,lastlogintime,salt',N'ZL_User',N'Status=0',N'LastLoginTime DESC',1,1,N'2017/4/11 11:37:46',N'获取用户列表')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[T2],[WhereStr],[ONStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 13,N'courierlist',N'A.GeneralID',N'generalid,title,createtime,inputer,fhd,mdd,nums,price,salt=(select salt from ZL_User where UserName=Inputer)',N'ZL_CommonModel',N'ZL_C_kdxx',N'(NodeID=@NodeID or FirstNodeID=@NodeID or NodeID in (select NodeID from ZL_Node where ParentID=@NodeID)) And Status=99',N'A.ItemID=B.ID',N'CreateTime DESC',N'[{"name":"NodeID","type":"int","defval":"187"}]',1,1,N'2017/4/11 11:38:56',N'获取快递信息列表')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 14,N'gradelist',N'GradeID',N'gradeid,gradename',N'ZL_Grade',N'Cate=@Cate And Grade=@Grade And ParentID=@ParentID',N'GradeID ASC',N'[{"name":"Cate","type":"int","defval":"0"},{"name":"Grade","type":"int","defval":"0"},{"name":"ParentID","type":"int","defval":"0"}]',1,1,N'2017/4/11 11:39:56',N'获取数据字典列表')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 15,N'prolikelist',N'ID',N'id,thumbnails,proinfo,proname,linprice,shiprice,addtime,(select COUNT(*) from ZL_Pub_spdz where PubContentid=A.ID And Pubstart=1) As Likes',N'ZL_Commodities',N'(NodeID=@NodeID or FirstNodeID=@NodeID or NodeID in (select NodeID from ZL_Node where ParentID=@NodeID)) And Sales=1 And Istrue=1 And Recycler=0',N'AddTime DESC',N'[{"name":"NodeID","type":"int","defval":"180"}]',1,1,N'2017/4/11 11:40:51',N'获取点赞商品列表')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[T2],[WhereStr],[ONStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 16,N'videolist',N'A.GeneralID',N'A.generalid,A.createtime,A.title,B.pic',N'ZL_CommonModel',N'ZL_C_Video',N'(NodeID=@NodeID or FirstNodeID=@NodeID or NodeID in (select NodeID from ZL_Node where ParentID=@NodeID)) And Status=99 And ModelID=7',N'A.ItemID=B.ID',N'A.CreateTime DESC',N'[{"name":"NodeID","type":"int","defval":"191"}]',1,1,N'2017/4/11 11:42:19',N'获取视频列表')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[T2],[WhereStr],[ONStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 17,N'getvideocont',N'A.GeneralID',N'A.nodeid,A.generalid,A.title,A.createtime,A.hits,B.author,B.content,B.url',N'ZL_CommonModel',N'ZL_C_Video',N'GeneralID=@GeneralID',N'A.ItemID=B.ID',N'A.CreateTime DESC',N'[{"name":"GeneralID","type":"int","defval":""}]',1,1,N'2017/4/11 11:42:55',N'获取视频内容详情')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 18,N'shoplist_tasc',N'ID',N'id,thumbnails,proinfo,proname,linprice,shiprice,addtime,storename=(select StoreName from ZL_CommonModel left join ZL_Store_reg on ItemID=ID where GeneralID=UserShopID)',N'ZL_Commodities',N'(NodeID=@NodeID or FirstNodeID=@NodeID or NodeID in (select NodeID from ZL_Node where ParentID=@NodeID)) And Sales=1 And Istrue=1 And Recycler=0 And Proname like @Proname',N'AddTime ASC',N'[{"name":"NodeID","type":"int","defval":"180"},{"name":"Proname","type":"like","defval":""}]',1,1,N'2017/4/11 11:43:36',N'获取指定节点商品列表 时间升序')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 19,N'shoplist_pdesc',N'ID',N'id,thumbnails,proinfo,proname,linprice,shiprice,addtime,storename=(select StoreName from ZL_CommonModel left join ZL_Store_reg on ItemID=ID where GeneralID=UserShopID)',N'ZL_Commodities',N'(NodeID=@NodeID or FirstNodeID=@NodeID or NodeID in (select NodeID from ZL_Node where ParentID=@NodeID)) And Sales=1 And Istrue=1 And Recycler=0 And Proname like @Proname',N'LinPrice DESC',N'[{"name":"NodeID","type":"int","defval":"180"},{"name":"Proname","type":"like","defval":""}]',1,1,N'2017/4/11 11:44:17',N'获取指定节点商品列表 价格降序')
INSERT [ZL_API_JsonP] ([ID],[Alias],[PK],[Fields],[T1],[WhereStr],[OrderStr],[Params],[MyState],[AdminID],[CDate],[Remark]) VALUES ( 20,N'shoplist_pasc',N'ID',N'id,thumbnails,proinfo,proname,linprice,shiprice,addtime,storename=(select StoreName from ZL_CommonModel left join ZL_Store_reg on ItemID=ID where GeneralID=UserShopID)',N'ZL_Commodities',N'(NodeID=@NodeID or FirstNodeID=@NodeID or NodeID in (select NodeID from ZL_Node where ParentID=@NodeID)) And Sales=1 And Istrue=1 And Recycler=0 And Proname like @Proname',N'LinPrice ASC',N'[{"name":"NodeID","type":"int","defval":"180"},{"name":"Proname","type":"like","defval":""}]',1,1,N'2017/4/11 11:44:59',N'获取指定节点商品列表 价格升序')
SET IDENTITY_INSERT [ZL_API_JsonP] OFF