/// <summary>
/// 获取订单明细
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
/// <remarks>2016-1-7 王耀发 创建</remarks>
public override Pager <CBSoOrderItem> GetOrderItemsRecordList(ParaOrderItemRecordFilter filter)
{
string sqlWhere = "1=1";
string sql = @"(select a.*,b.ErpCode, b.EasName,b.LastUpdateDate,c.RebateRtio,c.OperatFee
from SoOrderItem a left join PdProduct b on a.Productsysno = b.SysNo
left join SoOrder c on a.OrderSysNo = c.SysNo
where (@0 = 0 or a.OrderSysNo = @1)
and " + sqlWhere + " ) tb";
var dataList = Context.Select <CBSoOrderItem>("tb.*").From(sql);
var dataCount = Context.Select <int>("count(1)").From(sql);
var paras = new object[]
{
filter.OrderSysNo,
filter.OrderSysNo
};
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBSoOrderItem>
{
CurrentPage = filter.Id,
PageSize = filter.PageSize
};
var totalRows = dataCount.QuerySingle();
var rows = dataList.OrderBy(" tb.LastUpdateDate desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = totalRows;
pager.Rows = rows;
return(pager);
}
/// <summary> /// 获取订单明细 /// </summary> /// <param name="filter"></param> /// <returns></returns> /// <remarks>2016-1-7 王耀发 创建</remarks> public abstract Pager <CBSoOrderItem> GetOrderItemsRecordList(ParaOrderItemRecordFilter filter);
/// <summary>
/// 获取订单明细
/// </summary>
/// <param name="filter"></param>
/// <returns></returns>
/// <remarks>2016-1-7 王耀发 创建</remarks>
public Pager <CBSoOrderItem> GetOrderItemsRecordList(ParaOrderItemRecordFilter filter)
{
return(ISoOrderItemDao.Instance.GetOrderItemsRecordList(filter));
}
