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