/// <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 void InsertLendRecord(Book_Maintain_Ajax.Model.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.Execute(sql, new
{
BookId = insertdata.BookID,
KeeperId = insertdata.BookKeeperId
});
}
}
public void InsertLendRecord(Book_Maintain_Ajax.Model.LendRecordInsert insertdata)
{
bookDao.InsertLendRecord(insertdata);
}