asp.net源码旅行社平台分销系统源码+加盟商经纪人代理+利润分红模式

USE [jtly] GO /****** Object: Table [dbo].[pt_xl] Script Date: 01/16/2016 18:49:15 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[pt_xl]( [id] [int] IDENTITY(1,1) NOT NULL, [xl_title] [varchar](500) NULL, [xl_order] [int] NULL, [xl_type] [varchar](500) NULL, [xl_allnumsy] [int] NULL, [xl_allnum] [int] NULL, [xl_cr] [varchar](500) NULL, [xl_crjsj] [int] NULL, [xl_crscj] [int] NULL, [xl_crnum] [int] NULL, [xl_et] [varchar](500) NULL, [xl_etjsj] [int] NULL, [xl_etscj] [int] NULL, [xl_etnum] [int] NULL, [xl_lr] [varchar](500) NULL, [xl_lrjsj] [int] NULL, [xl_lrscj] [int] NULL, [xl_lrnum] [int] NULL, [xl_fttime] [varchar](500) NULL, [xl_fbr] [varchar](500) NULL, [xl_content] [ntext] NULL, [xl_state] [int] NULL, [xl_bz] [ntext] NULL, [xl_file] [varchar](500) NULL, [xl_filename] [varchar](500) NULL, [xl_pricesate] [int] NULL, CONSTRAINT [PK_pt_xl] 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] GO SET ANSI_PADDING OFF GO SET IDENTITY_INSERT [dbo].[pt_xl] ON INSERT [dbo].[pt_xl] ([id], [xl_title], [xl_order], [xl_type], [xl_allnumsy], [xl_allnum], [xl_cr], [xl_crjsj], [xl_crscj], [xl_crnum], [xl_et], [xl_etjsj], [xl_etscj], [xl_etnum], [xl_lr], [xl_lrjsj], [xl_lrscj], [xl_lrnum], [xl_fttime], [xl_fbr], [xl_content], [xl_state], [xl_bz], [xl_file], [xl_filename], [xl_pricesate]) VALUES (1, N'自驾游 六一儿童欢乐游组团', 1, N'卧铺汽车团', 50, 50, N'成人', 800, 900, 2, N'儿童', 400, 420, 1, N'老人', 700, 880, 1, N'2014-05-23', N'admin', N'<span style="white-space:nowrap;">自驾游 六一儿童欢乐游组团</span>', 2, NULL, NULL, NULL, NULL) INSERT [dbo].[pt_xl] ([id], [xl_title], [xl_order], [xl_type], [xl_allnumsy], [xl_allnum], [xl_cr], [xl_crjsj], [xl_crscj], [xl_crnum], [xl_et], [xl_etjsj], [xl_etscj], [xl_etnum], [xl_lr], [xl_lrjsj], [xl_lrscj], [xl_lrnum], [xl_fttime], [xl_fbr], [xl_content], [xl_state], [xl_bz], [xl_file], [xl_filename], [xl_pricesate]) VALUES (2, N'测试线路', 2, N'座位汽车团', 40, 40, N'成人', 200, 220, 7, N'儿童', 300, 320, 2, N'老人', 400, 430, 1, N'2014-06-07', N'admin', N'内容', 2, NULL, NULL, NULL, NULL) INSERT [dbo].[pt_xl] ([id], [xl_title], [xl_order], [xl_type], [xl_allnumsy], [xl_allnum], [xl_cr], [xl_crjsj], [xl_crscj], [xl_crnum], [xl_et], [xl_etjsj], [xl_etscj], [xl_etnum], [xl_lr], [xl_lrjsj], [xl_lrscj], [xl_lrnum], [xl_fttime], [xl_fbr], [xl_content], [xl_state], [xl_bz], [xl_file], [xl_filename], [xl_pricesate]) VALUES (3, N'测试线路2', 3, N'火车团', 50, 50, N'成人', 100, 1222, 0, N'儿童', 200, 1232, 0, N'老人', 300, 1231, 0, N'2014-06-07', N'admin', N'内容', 2, NULL, NULL, NULL, NULL) INSERT [dbo].[pt_xl] ([id], [xl_title], [xl_order], [xl_type], [xl_allnumsy], [xl_allnum], [xl_cr], [xl_crjsj], [xl_crscj], [xl_crnum], [xl_et], [xl_etjsj], [xl_etscj], [xl_etnum], [xl_lr], [xl_lrjsj], [xl_lrscj], [xl_lrnum], [xl_fttime], [xl_fbr], [xl_content], [xl_state], [xl_bz], [xl_file], [xl_filename], [xl_pricesate]) VALUES (4, N'北京精华四日游', 4, N'座位汽车团', 50, 50, N'成人', 400, 500, 0, N'儿童', 300, 400, 0, N'老人', 300, 400, 0, N'2014-06-07', N'admin', N'<br /> <br /> <p style="text-indent:188.85pt;"> <b><span style="font-family:宋体;font-size:18pt;">北京精华四日游</span></b><b><span style="font-size:18pt;"></span></b> </p> <br /> <br /> <p> <b><i><span style="font-family:楷体_GB2312;color:black;font-size:14pt;">行程</span></i></b><b><span style="font-family:楷体_GB2312;color:black;font-size:14pt;">：<span></span></span></b> </p> <br /> <br /> <p style="text-align:left;text-indent:-30.95pt;margin-left:30.95pt;" align="left"> <span style="font-family:幼圆;font-size:14px;">D1</span><span style="font-family:幼圆;"><span style="font-size:14px;">：洛阳下午</span><span style="font-size:14px;">5</span><span style="font-size:14px;">点左右乘豪华空调大巴赴盼望已久的首都北京</span><span style="font-size:14px;">(</span><span style="font-si�