网上书店系统毕业论文 - 图文

后台核心代码：

public static Book AddBook(Book book) {

string sql =

\WordsCount, UnitPrice, ContentDescription, AuthorDescription, EditorComment, TOC, CategoryId, Clicks)\

\ALUES (@Title, @Author, @PublisherId, @PublishDate, @ISBN, @WordsCount, @UnitPrice, @ContentDescription, @AuthorDescription, @EditorComment, @TOC, @CategoryId, @Clicks)\

sql += \

try {

SqlParameter[] para = new SqlParameter[] { new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\

33

new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ };

int newId = DBHelper.GetScalar(sql, para); return GetBookById(newId); }

catch (Exception e) {

Console.WriteLine(e.Message); throw e; } }

public static void ModifyBook(Book book) {

string sql =

\ \

\ \ \ \

\ \

\ \

\ \ \ \ \

try {

SqlParameter[] para = new SqlParameter[] { new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\

34

new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ new SqlParameter(\ };

DBHelper.ExecuteCommand(sql, para); }

catch (Exception e) {

Console.WriteLine(e.Message); throw e; }

}

public static IList GetAllBooks() {

string sqlAll = \ return GetBooksBySql(sqlAll); }

35

5.1.9订单管理

图5-9 订单管理

页面部分实现代码：

<%@ Page Language=\

AutoEventWireup=\Title=\订单详情|IT之友网上书店\

36