public JsonResult GetBookData(int bookID)
{
BookSystem.Model.BookUpdate bookData = new BookSystem.Model.BookUpdate();
if (bookService.findBook(bookID) != "")
{
bookData = bookService.GetEditById(bookID);
return(Json(bookData));
}
else
{
string alert = "BookIDNotExist";
return(Json(alert));
}
}
/// <summary>
/// Map資料
/// </summary>
private BookSystem.Model.BookUpdate MapBookDataForUpdateToList(DataTable BookData)
{
BookSystem.Model.BookUpdate result = new BookSystem.Model.BookUpdate();
foreach (DataRow row in BookData.Rows)
{
result.BOOK_ID = (int)row["BookID"];
//result.BOOK_NAME = row["BookName"].ToString();
result.BOOK_NAME = Microsoft.Security.Application.Encoder.HtmlEncode(row["BookName"].ToString());
//result.BOOK_AUTHOR = row["Author"].ToString();
result.BOOK_AUTHOR = Microsoft.Security.Application.Encoder.HtmlEncode(row["Author"].ToString());
result.BOOK_PUBLISHER = row["Publisher"].ToString();
result.BOOK_NOTE = row["Note"].ToString();
result.BOOK_BOUGHT_DATE = row["BoughDate"].ToString();
result.BOOK_CLASS_NAME = row["BookClassName"].ToString();
result.BOOK_CLASS_ID = row["BookClassID"].ToString();
result.BOOK_STATUS = row["StatusName"].ToString();
result.BOOK_STATUS_ID = row["StatusID"].ToString();
result.USER_ENAME = row["UserName"].ToString();
result.KEEPER_ID = row["UserID"].ToString();
}
return(result);
}
/// <summary>
/// 修改書籍資料
/// </summary>
public void UpdateById(BookSystem.Model.BookUpdate arg)
{
string sql = @"UPDATE BOOK_DATA
SET
BOOK_NAME =@BOOK_NAME,
BOOK_AUTHOR =@BOOK_AUTHOR,
BOOK_PUBLISHER =@BOOK_PUBLISHER,
BOOK_NOTE =@BOOK_NOTE,
BOOK_BOUGHT_DATE =@BOOK_BOUGHT_DATE,
BOOK_CLASS_ID=@BOOK_CLASS_ID,
BOOK_STATUS=@BOOK_STATUS_ID,
BOOK_KEEPER=@KEEPER_ID
WHERE
BOOK_ID=@BOOK_ID;";
string sqlAboutInsertLendRecord = @"INSERT INTO BOOK_LEND_RECORD(
BOOK_ID,
KEEPER_ID,
LEND_DATE,
CRE_DATE,
MOD_DATE
)VALUES(
@BOOK_ID,
@KEEPER_ID,
@LEND_DATE,
@CRE_DATE,
@MOD_DATE) ";
if (arg.KEEPER_ID != null)
{
sql = sql + sqlAboutInsertLendRecord;
}
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@BOOK_NAME", arg.BOOK_NAME));
cmd.Parameters.Add(new SqlParameter("@BOOK_AUTHOR", arg.BOOK_AUTHOR));
cmd.Parameters.Add(new SqlParameter("@BOOK_PUBLISHER", arg.BOOK_PUBLISHER));
cmd.Parameters.Add(new SqlParameter("@BOOK_NOTE", arg.BOOK_NOTE));
cmd.Parameters.Add(new SqlParameter("@BOOK_BOUGHT_DATE", arg.BOOK_BOUGHT_DATE));
cmd.Parameters.Add(new SqlParameter("@BOOK_CLASS_ID", arg.BOOK_CLASS_ID));
cmd.Parameters.Add(new SqlParameter("@BOOK_STATUS_ID", arg.BOOK_STATUS_ID));
cmd.Parameters.Add(new SqlParameter("@KEEPER_ID", arg.KEEPER_ID == null ? string.Empty : arg.KEEPER_ID));
cmd.Parameters.Add(new SqlParameter("@BOOK_ID", arg.BOOK_ID));
cmd.Parameters.Add(new SqlParameter("@LEND_DATE", DateTime.Now.ToShortDateString()));
cmd.Parameters.Add(new SqlParameter("@CRE_DATE", DateTime.Now.ToShortDateString()));
cmd.Parameters.Add(new SqlParameter("@MOD_DATE", DateTime.Now.ToShortDateString()));
SqlTransaction tran = conn.BeginTransaction();
cmd.Transaction = tran;
try
{
cmd.ExecuteNonQuery();//可以知道影響幾筆(int)
tran.Commit();
}
catch
{
tran.Rollback();
throw;
}
finally
{
conn.Close();
}
}
}
public JsonResult UpdateBook(BookSystem.Model.BookUpdate book)
{
bookService.UpdateById(book);
return(Json(true));
}
public void UpdateById(BookSystem.Model.BookUpdate arg)
{
bookDao.UpdateById(arg);
}
