public JsonResult Update(NET_MVC_WorkShop2.Model.BookData book)
{
NET_MVC_WorkShop2.Service.BookService BookService = new NET_MVC_WorkShop2.Service.BookService();
var result = BookService.UpdateBook(book);
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 新增書籍
/// </summary>
/// <param name="book"></param>
/// <returns>書籍編號</returns>
public int InsertBook(NET_MVC_WorkShop2.Model.BookData book)
{
string sql = @" INSERT INTO [dbo].[BOOK_DATA]
(
BOOK_NAME, BOOK_AUTHOR, BOOK_PUBLISHER, BOOK_NOTE, BOOK_BOUGHT_DATE, BOOK_CLASS_ID , BOOK_STATUS, BOOK_KEEPER
)
VALUES
(
@Book_Name,@Book_Author, @Book_Publisher, @Book_Note, @Book_BoughtDate, @Book_Class_ID , @Book_Status, @Book_Keeper
)
Select SCOPE_IDENTITY()";
int BookId;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@Book_Name", book.Book_Name));
cmd.Parameters.Add(new SqlParameter("@Book_Author", book.Book_Author));
cmd.Parameters.Add(new SqlParameter("@Book_Publisher", book.Book_Publisher));
cmd.Parameters.Add(new SqlParameter("@Book_Note", book.Book_Note));
cmd.Parameters.Add(new SqlParameter("@Book_BoughtDate", book.Book_BoughtDate));
cmd.Parameters.Add(new SqlParameter("@Book_Class_ID", book.Book_Class_ID));
cmd.Parameters.Add(new SqlParameter("@Book_Status", book.Book_Status));
cmd.Parameters.Add(new SqlParameter("@Book_Keeper", book.Book_Keeper));
BookId = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
}
return(BookId);
}
/// <summary>
/// 修改書籍
/// </summary>
/// <returns>書籍編號</returns>
public int UpdateBook(NET_MVC_WorkShop2.Model.BookData book)
{
string sql = @" UPDATE [dbo].[BOOK_DATA]
SET BOOK_NAME = @Book_Name, BOOK_AUTHOR = @Book_Author, BOOK_PUBLISHER = @Book_Publisher, BOOK_NOTE = @Book_Note,
BOOK_BOUGHT_DATE = @Book_BoughtDate, BOOK_CLASS_ID = @Book_Class_ID, BOOK_STATUS = @Book_Status, BOOK_KEEPER = @Book_Keeper
WHERE BOOK_ID = @Book_ID";
int BookID;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@Book_ID", book.Book_ID));
cmd.Parameters.Add(new SqlParameter("@Book_Name", book.Book_Name));
cmd.Parameters.Add(new SqlParameter("@Book_Author", book.Book_Author));
cmd.Parameters.Add(new SqlParameter("@Book_Publisher", book.Book_Publisher));
cmd.Parameters.Add(new SqlParameter("@Book_Note", book.Book_Note));
cmd.Parameters.Add(new SqlParameter("@Book_BoughtDate", book.Book_BoughtDate));
cmd.Parameters.Add(new SqlParameter("@Book_Class_ID", book.Book_Class_ID));
cmd.Parameters.Add(new SqlParameter("@Book_Status", book.Book_Status));
cmd.Parameters.Add(new SqlParameter("@Book_Keeper", book.Book_Keeper));
BookID = (int)(cmd.ExecuteNonQuery());
conn.Close();
}
return(BookID);
}
public JsonResult Insert(NET_MVC_WorkShop2.Model.BookData book)
{
NET_MVC_WorkShop2.Service.BookService BookService = new NET_MVC_WorkShop2.Service.BookService();
var result = BookService.InsertBook(book);
TempData["message"] = "存檔成功";
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改書籍
/// </summary>
/// <returns>書籍編號</returns>
public int UpdateBook(NET_MVC_WorkShop2.Model.BookData book)
{
NET_MVC_WorkShop2.Dao.BookDao bookDao = new Dao.BookDao();
return(bookDao.UpdateBook(book));
}
/// <summary>
/// 新增書籍
/// </summary>
/// <param name="book"></param>
/// <returns>書籍編號</returns>
public int InsertBook(NET_MVC_WorkShop2.Model.BookData book)
{
NET_MVC_WorkShop2.Dao.BookDao bookDao = new Dao.BookDao();
return(bookDao.InsertBook(book));
}
