//修改书本信息
public int EditBookFace(Model.BooksInfo item)
{
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@bookId", item.BookId),
new SqlParameter("@bookName", item.BookName),
new SqlParameter("@BookIntroduction", item.BookIntroduction),
new SqlParameter("@bookState", item.BookState),
new SqlParameter("@booktType", item.BookType)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "EditBookFace", parm));
}
//添加新书
public int AuaddBook(Model.BooksInfo item)
{
SqlParameter[] parm = new SqlParameter[] {
new SqlParameter("@bookName", item.BookName),
new SqlParameter("@authorId", item.AuthorId),
new SqlParameter("@images", item.Images),
new SqlParameter("@BookIntroDuction", item.BookIntroduction),
new SqlParameter("@bookType", item.BookType)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "AuAddNewBook", parm));
}
//根据作者ID获取作者作品
public List <Model.BooksInfo> getAuthorBooks(int AuthorId)
{
List <Model.BooksInfo> list = new List <Model.BooksInfo>();
SqlParameter parm = new SqlParameter("@AuthorId", AuthorId);
using (SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, "getAuthorBooks", parm))
{
while (dr.Read())
{
Model.BooksInfo item = new Model.BooksInfo();
item.BookId = Convert.ToInt32(dr["bookId"]);
item.BookName = dr["BookName"].ToString();
item.BookType = Convert.ToInt32(dr["BookType"]);
item.BookState = Convert.ToInt32(dr["BookState"]);
item.Images = dr["Images"].ToString();
list.Add(item);
}
}
return(list);
}
//添加新书
public int addBook(Model.BooksInfo item)
{
return(novel.addBook(item));
}
//添加新书
public int AuaddBook(Model.BooksInfo item)
{
return(IA.AuaddBook(item));
}
//修改书本信息
public int EditBookFace(Model.BooksInfo item)
{
return(IA.EditBookFace(item));
}