数据查询与强大报表打印系统源码

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_SearchField_Search]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[SearchField] DROP CONSTRAINT FK_SearchField_Search GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_ShowField_Search]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[ShowField] DROP CONSTRAINT FK_ShowField_Search GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[return_ny]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[return_ny] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Login]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[Login] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[authors]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[authors] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Search]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[Search] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SearchField]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[SearchField] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ShowField]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[ShowField] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TUser] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[discounts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[discounts] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[employee]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[employee] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[jobs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[jobs] GO CREATE TABLE [dbo].[authors] ( [au_id] [varchar] (11) COLLATE Chinese_PRC_CI_AS NOT NULL , [au_lname] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL , [au_fname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [phone] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL , [address] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL , [city] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [state] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [zip] [char] (5) COLLATE Chinese_PRC_CI_AS NULL , [contract] [bit] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Search] ( [ID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Tablename] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SearchField] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [SearchId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [FieldName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [FieldType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [SearchName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[ShowField] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [SearchId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [FieldName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [FieldType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [ShowName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TUser] ( [UserId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [name] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL , [Admin] [int] NOT NULL , [password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[discounts] ( [discounttype] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL , [stor_id] [char] (4) COLLATE Chinese_PRC_CI_AS NULL , [lowqty] [smallint] NULL , [highqty] [smallint] NULL , [dis�