Mercurial > pub > bltoolkit
view Demo/Asp.Net/BusinessLogic/DataAccess/OrderAccessor.cs @ 0:f990fcb411a9
Копия текущей версии из github
author | cin |
---|---|
date | Thu, 27 Mar 2014 21:46:09 +0400 |
parents | |
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(); } }