Asp.NET做的网上书店连接SQL SERVER数据库

using System;
using System.Collections.Generic;
using System.Text;
using MyBookShop.DAL;
using MyBookShop.Models;

namespace MyBookShop.BLL
{

    public static partial class BookManager
    {
        #region 查
        /// 

        /// 查询图书列表
        /// 包含了分类的查询
        /// 和有无排序的条件
        /// 

        /// 查询条件：分类。小于1时代表不分类
        /// 排序条件，为空则不排序
        /// 
        public static IList GetOrderedSmallBooksByCategoryId（int categoryId string order）
        {
            return BookService.GetPartialBooksBySql（categoryId order）;
        }
        /// 

        /// 搜索图书
        /// 

        /// 
        /// 
        public static IList SearchBooks（string keywordstring order）
        {
            return BookService.SearchBooks（keywordorder）;
        }
        /// 

        /// 返回Rss所用的图书列表
        /// 

        /// 
        public static IList GetNewBooks（）
        {
            return BookService.GetNewBooks（）;
        }

        #endregion
        #region 改

        /// 

        /// 更新图书分类
        /// 

        /// 
        /// 
        /// 
        public static void ModifyCatagory（string ids string catagory）
        {
            BookService.ModifyCatagory（ids catagory）;
        }
        /// 

        /// 专为图书修改页提供的图书更新
        /// 

        /// tle“>
        /// 
        /// 
        /// ription“>
        /// 
        /// 
        /// 
        /// 
        /// ription“>
        /// 
        /// 
        public static void ModifyBook（string title int Publisherid int WordsCount string AurhorDescription decimal UnitPrice string author string TOC DateTime PublishDate string ContentDescription string editorComment int id）
        {
            if （AurhorDescription == null）
                AurhorDescription = ““;
            if （ContentDescription == null）
                ContentDescription = ““;
            if （ContentDescription == null）
                ContentDescription = ““;
            if （editorComment == null）
                editorComment = ““;
            if （ContentDescription == null）
                ContentDescription = ““;
            if （editorComment == null）
                editorComment = ““;
            if （TOC == null）
                TOC = ““;

            Book book = B

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2012-12-04 20:53  BookShopOnline
     目录           0  2008-08-19 18:51  BookShopOnlineBin
     文件      753664  2006-07-18 20:21  BookShopOnlineBinFreeTextBox.dll
     文件       32768  2006-02-09 09:58  BookShopOnlineBinWebValidates.dll
     文件    10485760  2008-08-08 12:39  BookShopOnlineMyBookShop.mdf
     文件        5739  2008-01-07 10:03  BookShopOnlineMyBookShop.sln
     文件      293376  2008-08-08 12:21  BookShopOnlineMyBookShop.suo
     目录           0  2008-08-19 18:51  BookShopOnlineMyBookShopBLL
     目录           0  2008-08-19 18:51  BookShopOnlineMyBookShopBLLAuto Generated Code
     文件         811  2007-11-28 15:08  BookShopOnlineMyBookShopBLLAuto Generated CodeBookManager.cs
     文件        1053  2007-11-28 15:09  BookShopOnlineMyBookShopBLLAuto Generated CodeCategoryManager.cs
     文件        1362  2007-09-06 17:40  BookShopOnlineMyBookShopBLLAuto Generated CodeOrderBookManager.cs
     文件         960  2007-11-28 15:09  BookShopOnlineMyBookShopBLLAuto Generated CodeOrderManager.cs
     文件        1084  2007-11-28 15:09  BookShopOnlineMyBookShopBLLAuto Generated CodePublisherManager.cs
     文件        1208  2007-11-28 15:09  BookShopOnlineMyBookShopBLLAuto Generated CodeSearchKeywordManager.cs
     文件        1225  2007-11-28 15:09  BookShopOnlineMyBookShopBLLAuto Generated CodeUserManager.cs
     文件        1159  2007-11-28 15:09  BookShopOnlineMyBookShopBLLAuto Generated CodeUserRoleManager.cs
     文件        1193  2007-11-28 15:09  BookShopOnlineMyBookShopBLLAuto Generated CodeUserStateManager.cs
     文件        5535  2007-11-21 16:53  BookShopOnlineMyBookShopBLLBookManager.cs
     文件         698  2007-10-10 15:41  BookShopOnlineMyBookShopBLLCategoryManager.cs
     文件        3459  2008-01-07 10:03  BookShopOnlineMyBookShopBLLMyBookShopBLL.csproj
     文件         168  2007-08-09 10:37  BookShopOnlineMyBookShopBLLMyBookShopBLL.csproj.user
     文件         773  2007-11-13 09:01  BookShopOnlineMyBookShopBLLOrderBookManager.cs
     文件         725  2007-11-13 08:58  BookShopOnlineMyBookShopBLLOrdersManager.cs
     目录           0  2008-08-19 18:51  BookShopOnlineMyBookShopBLLProperties
     文件        1339  2007-07-27 14:11  BookShopOnlineMyBookShopBLLPropertiesAssemblyInfo.cs
     文件         923  2008-01-08 10:17  BookShopOnlineMyBookShopBLLSearchKeywordManager.cs
     文件        4226  2007-11-28 15:41  BookShopOnlineMyBookShopBLLUserManager.cs
     目录           0  2008-08-19 18:51  BookShopOnlineMyBookShopBLLin
     目录           0  2008-08-19 18:51  BookShopOnlineMyBookShopBLLinDebug
     文件       24576  2008-07-14 21:54  BookShopOnlineMyBookShopBLLinDebugMyBookShopBLL.dll
............此处省略250个文件信息