예제 #1
0
        /// <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);
        }
예제 #2
0
 /// <summary>
 /// 获取订单明细
 /// </summary>
 /// <param name="filter"></param>
 /// <returns></returns>
 /// <remarks>2016-1-7 王耀发 创建</remarks>
 public abstract Pager <CBSoOrderItem> GetOrderItemsRecordList(ParaOrderItemRecordFilter filter);
예제 #3
0
 /// <summary>
 /// 获取订单明细
 /// </summary>
 /// <param name="filter"></param>
 /// <returns></returns>
 /// <remarks>2016-1-7 王耀发 创建</remarks>
 public Pager <CBSoOrderItem> GetOrderItemsRecordList(ParaOrderItemRecordFilter filter)
 {
     return(ISoOrderItemDao.Instance.GetOrderItemsRecordList(filter));
 }