//新增借閱紀錄到資料庫
public void InsertLendRecord(Models.LendRecordInsert insertdata)
{
string sql = @"
BEGIN TRY
BEGIN TRANSACTION
INSERT INTO BOOK_LEND_RECORD
(
BOOK_ID,KEEPER_ID,LEND_DATE,CRE_DATE,CRE_USR,MOD_DATE,MOD_USR
)
VALUES
(
@BookId,@KeeperId, GETDATE(),
GETDATE(), '123', GETDATE(),
'123'
)
COMMIT TRANSACTION
End TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() as ErrorState,
ERROR_PROCEDURE() as ErrorProcedure,
ERROR_LINE() as ErrorLine,
ERROR_MESSAGE() as ErrorMessage
ROLLBACK TRANSACTION
END CATCH " ;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@BookId", insertdata.BookID));
cmd.Parameters.Add(new SqlParameter("@KeeperId", insertdata.BookKeeperId));
//ExecuteScalar 執行一個SQL命令返回結果集的第一列的第一行即id
cmd.ExecuteNonQuery();
conn.Close();
}
}
public ActionResult UpdateBook(Models.BookUpdate updatedata)
{
ViewBag.BookClass = bookservice.GetDropdownList("GetClass");
ViewBag.BookKeeper = bookservice.GetDropdownList("GetUpdateKeeper");
ViewBag.BookStatus = bookservice.GetDropdownList("GetStatus"); //顯示DropDownList
bool relation = ((updatedata.BookStatusId == "B" || updatedata.BookStatusId == "C") && (updatedata.BookKeeperId == "" || updatedata.BookKeeperId == null));
if (ModelState.IsValid && !relation)
{
string LaterBookStatus = updatedata.BookStatusId;
string IniBookStatus = updatedata.IniStatus;
if ((IniBookStatus == "A" || IniBookStatus == "U") && (LaterBookStatus == "B" || LaterBookStatus == "C"))
{
Models.LendRecordInsert lendRecordInsert = new Models.LendRecordInsert();
lendRecordInsert.BookKeeperId = updatedata.BookKeeperId;
lendRecordInsert.BookID = Convert.ToInt32(updatedata.BookID);
bookservice.InsertLendRecord(lendRecordInsert);
}
bookservice.UpdateBook(Convert.ToInt32(updatedata.BookID), updatedata);
return(RedirectToAction("Index"));
}
return(View());
}
