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();
	}
}