[源代码] C# ASP.NET 项目实战 - 运输管理平台

USE [master] GO /****** Object: Database [db_WL] Script Date: 2012/8/8 20:41:37 ******/ CREATE DATABASE [db_WL] ON PRIMARY ( NAME = N'db_WL_Data', FILENAME = N'E:\Developer\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\db_WL_Data.MDF' , SIZE = 1792KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) LOG ON ( NAME = N'db_WL_Log', FILENAME = N'E:\Developer\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\db_WL_log.LDF' , SIZE = 3136KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) GO EXEC dbo.sp_dbcmptlevel @dbname=N'db_WL', @new_cmptlevel=80 GO ALTER DATABASE [db_WL] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [db_WL] SET ANSI_NULLS OFF GO ALTER DATABASE [db_WL] SET ANSI_PADDING OFF GO ALTER DATABASE [db_WL] SET ANSI_WARNINGS OFF GO ALTER DATABASE [db_WL] SET ARITHABORT OFF GO ALTER DATABASE [db_WL] SET AUTO_CLOSE OFF GO ALTER DATABASE [db_WL] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [db_WL] SET AUTO_SHRINK ON GO ALTER DATABASE [db_WL] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [db_WL] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [db_WL] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [db_WL] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [db_WL] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [db_WL] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [db_WL] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [db_WL] SET RECOVERY SIMPLE GO ALTER DATABASE [db_WL] SET MULTI_USER GO ALTER DATABASE [db_WL] SET TORN_PAGE_DETECTION ON GO if ( ((@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 760)) or (@@microsoftversion / power(2, 24) >= 9) )begin exec dbo.sp_dboption @dbname = N'db_WL', @optname = 'db chaining', @optvalue = 'OFF' end GO USE [db_WL] GO /****** Object: Table [dbo].[tb_City] Script Date: 2012/8/8 20:41:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tb_City]( [ID] [int] IDENTITY(1,1) NOT NULL, [Sf] [varchar](23) NULL, [Cs] [varchar](25) NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[tb_Depot] Script Date: 2012/8/8 20:41:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tb_Depot]( [ID] [int] IDENTITY(1,1) NOT NULL, [UserName] [varchar](50) NULL, [DepotType] [varchar](50) NULL, [DepotCity] [varchar](50) NULL, [DepotSite] [varchar](50) NULL, [DepotAcreage] [int] NULL, [DepotSum] [int] NULL, [DepotPrice] [int] NULL, [Loading] [int] NULL, [Packing] [int] NULL, [Send] [int] NULL, [Linkman] [varchar](50) NULL, [Phone] [varchar](50) NULL, [Term] [datetime] NULL, [Content] [varchar](1000) NULL, [FBDate] [datetime] NULL, [userType] [char](10) NULL, [Auditing] [bit] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[tb_Freight] Script Date: 2012/8/8 20:41:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tb_Freight]( [ID] [int] IDENTITY(1,1) NOT NULL, [UserName] [varchar](50) NULL, [Start] [varchar](50) NULL, [Terminal] [varchar](50) NULL, [FreightType] [varchar](50) NULL, [FreightWeight] [int] NULL, [WeightUnit] [char](10) NULL, [Linkman] [varchar](50) NULL, [Phone] [varchar](50) NULL, [Term] [datetime] NULL, [Content] [varchar](1000) NULL, [FBDate] [datetime] NULL, [userType] [char](10) NULL, [Auditing] [bit] NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[tb_GrUser] Script Date: 2012/8/8 20:41:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[tb_GrUser]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NULL, [Pass] [varchar](50) NULL, [PassQuestion] [varchar](50) NULL, [PassSolution] [varchar](50) NULL, [Linkman] [varchar](50) NULL, [Phone] [varchar](50) NULL, [Address] [�