//insert
public async Task <int> InsertBook(BookInsert insertdata)
{
string sql = @"
BEGIN TRY
BEGIN TRANSACTION
INSERT INTO BOOK_DATA
(
BOOK_NAME,BOOK_CLASS_ID,BOOK_AUTHOR,
BOOK_BOUGHT_DATE,BOOK_PUBLISHER,BOOK_NOTE,
BOOK_STATUS,BOOK_KEEPER,BOOK_AMOUNT,CREATE_DATE,
CREATE_USER,MODIFY_DATE,MODIFY_USER
)
VALUES
(
@BookName,@BookClass, @BookAuthor,
@BoughtDate, @BookPublisher, @Note,
'A','',0,GETDATE(),
'123',GETDATE(), '123'
)
SELECT SCOPE_IDENTITY();
COMMIT TRANSACTION
End TRY
BEGIN CATCH
SELECT
0 AS IsError
ROLLBACK TRANSACTION
END CATCH " ;
using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString()))
{
int InsertID = await conn.ExecuteScalarAsync <int>(sql, new
{
BookName = insertdata.BookName,
BookClass = insertdata.BookClass,
BookAuthor = insertdata.BookAuthor,
BoughtDate = insertdata.BoughtDate,
BookPublisher = insertdata.BookPublisher,
Note = insertdata.Note
});
return(InsertID);
}
}
public async Task InsertBook([FromBody] BookInsert insertdata)
{
int InsertID = await _bookservice.InsertBook(insertdata); //test用
}
public int InsertBook(BookInsert insertdata)
{
throw new NotImplementedException();
}
