/**
|
* EC_InHomeDataDAL.cs
|
*
|
* 功 能: 获取首页数据接口实现
|
* 类 名: EC_InHomeDataDAL
|
*
|
* Ver 变更日期 负责人 变更内容
|
* ───────────────────────────────────
|
* V0.01 2013-6-1 13:41 吴崎均 初版(首页获取订单、需求、秒杀)
|
*
|
*
|
*/
|
using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using CY.Model;
|
using System.Data;
|
using CY.Infrastructure.Domain;
|
using CY.IDAL;
|
|
namespace CY.SQLDAL
|
{
|
/// <summary>
|
/// 首页数据访问接口实现
|
/// </summary>
|
public class EC_InHomeDataDAL : IEC_InHomeDataDAL
|
{
|
private Database _dataBase = null;
|
|
/// <summary>
|
/// 初始化构造
|
/// </summary>
|
public EC_InHomeDataDAL()
|
{
|
_dataBase = new Database();
|
}
|
|
/// <summary>
|
/// 根据存储获取信息
|
/// </summary>
|
/// <returns></returns>
|
private List<T> SelectModel<T>(string procName) where T : IAggregateRoot, new()
|
{
|
List<T> result = null;
|
try
|
{
|
using (IDataReader reader = _dataBase.QueryDataReader(procName, System.Data.CommandType.StoredProcedure))
|
{
|
result = _dataBase.ReadDataToModel<T>(reader);
|
}
|
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return result;
|
}
|
|
/// <summary>
|
/// 获取订单信息
|
/// </summary>
|
/// <returns></returns>
|
public List<EC_OrderBasic> SelectOrder()
|
{
|
return SelectModel<EC_OrderBasic>("sp_InHome_Order_Select");
|
}
|
|
/// <summary>
|
/// 获取秒杀业务信息
|
/// </summary>
|
/// <returns></returns>
|
public List<EC_SeckillBusiness> SelectSeckillBusiness()
|
{
|
return SelectModel<EC_SeckillBusiness>("sp_InHome_SeckillBusiness_Select");
|
}
|
|
/// <summary>
|
/// 获取报价需求信息
|
/// </summary>
|
/// <returns></returns>
|
public List<EC_QuoteDemand> SelectQuoteDemand()
|
{
|
return SelectModel<EC_QuoteDemand>("sp_InHome_QuoteDemand_Select");
|
}
|
}
|
}
|