Mercurial > pub > bltoolkit
view Demo/Asp.Net/BusinessLogic/DataAccess/OrderAccessor.cs @ 9:1e85f66cf767 default tip
update bltoolkit
author | nickolay |
---|---|
date | Thu, 05 Apr 2018 20:53:26 +0300 |
parents | f990fcb411a9 |
children |
line wrap: on
line source
using System; using System.Collections.Generic; using BLToolkit.Data; using BLToolkit.DataAccess; namespace PetShop.BusinessLogic.DataAccess { using ObjectModel; public abstract class OrderAccessor : AccessorBase<OrderAccessor.DB, OrderAccessor> { public class DB : DbManager { public DB() : base("OrderDB") {} } [SqlQuery(@"INSERT INTO OrderStatus (OrderId, LineNum, Timestamp, Status) VALUES (@id, @id, GetDate(), 'P')")] public abstract void InsertStatus(DbManager db, int @id); [SqlQuery(@" SELECT o.*, os.Status FROM Orders o JOIN OrderStatus os ON os.OrderId = o.OrderId ORDER BY o.OrderId DESC")] public abstract List<Order> GetAllOrderList(); } }