/// <code>
/// reader會動態綁定資料庫hand在那
/// var reader = cmd.ExecuteReader();
/// while (reader.Read())
/// { selectlist.Add(new SelectListItem { Text = reader.GetString(1), Value = reader.GetString(val) }); }
/// reader.Close();
/// </code>
/// <param name="insertdata"></param>
//新增借閱紀錄到資料庫
public async Task InsertLendRecord(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()))
{
await conn.ExecuteAsync(sql, new
{
BookId = insertdata.BookID,
KeeperId = insertdata.BookKeeperId
});
}
}
public async Task <IActionResult> UpdateBook([FromBody] BookUpdate bookUpdate, [FromQuery] string IniBookStatus, [FromQuery] string LaterBookStatus)
{
//借閱人借閱狀態關係
if ((bookUpdate.BookStatusId == "B" || bookUpdate.BookStatusId == "C") && (bookUpdate.BookKeeperId == "" || bookUpdate.BookKeeperId == null))
{
return(Ok("此借閱狀態,借閱人不能為空"));
}
else
{
//insert 借閱紀錄
if ((IniBookStatus == "A" || IniBookStatus == "U") && (LaterBookStatus == "B" || LaterBookStatus == "C"))
{
LendRecordInsert lendRecordInsert = new LendRecordInsert();
lendRecordInsert.BookKeeperId = bookUpdate.BookKeeperId;
lendRecordInsert.BookID = Convert.ToInt32(bookUpdate.BookID);
await _bookservice.InsertLendRecord(lendRecordInsert);
}
//update 書本資料
await _bookservice.UpdateBook(bookUpdate);
return(Ok("編輯成功"));
}
}
public void InsertLendRecord(LendRecordInsert insertdata)
{
throw new NotImplementedException();
}