public ResponseBo <List <OrderListBo> > GetList(OrderGetListCriteriaBo criteriaBo) { ResponseBo <List <OrderListBo> > responseBo = new ResponseBo <List <OrderListBo> >(); try { using (SqlConnection conn = DbAccess.Connection.GetConn()) { var p = new DynamicParameters(); base.AddStandartSpParams(ref p, criteriaBo); p.Add("@CaseId", criteriaBo.CaseId, DbType.Int32, ParameterDirection.Input); p.Add("@PersonId", criteriaBo.PersonId, DbType.Int64, ParameterDirection.Input); p.Add("@GetIncomings", criteriaBo.GetIncomings, DbType.Boolean, ParameterDirection.Input); p.Add("@GetReturns", criteriaBo.GetReturns, DbType.Boolean, ParameterDirection.Input); p.Add("@OrderStatList", criteriaBo.OrderStatList.ToStrSeparated(), DbType.String, ParameterDirection.Input, 255); p.Add("@CurrencyId", criteriaBo.CurrencyId, DbType.Int32, ParameterDirection.Input); p.Add("@PageOffSet", criteriaBo.PageOffSet, DbType.Int32, ParameterDirection.Input); responseBo.Bo = conn.Query <OrderListBo>("spOrderList", p, commandType: CommandType.StoredProcedure).ToList(); responseBo.Message = p.Get <string>("@Message"); responseBo.IsSuccess = p.Get <bool>("@IsSuccess"); if (responseBo.IsNotNull() && responseBo.Bo.IsNotNull()) { foreach (OrderListBo itemBo in responseBo.Bo) { if (itemBo.CodeListRawJson.IsNotNull()) { itemBo.CodeList = JsonConvert.DeserializeObject <List <ProductCodeBo> >(itemBo.CodeListRawJson); } if (itemBo.OptionListRawJson.IsNotNull()) { itemBo.OptionList = JsonConvert.DeserializeObject <List <OptionListBo> >(itemBo.OptionListRawJson); } if (itemBo.IncludeExcludeListRawJson.IsNotNull()) { itemBo.IncludeExcludeList = JsonConvert.DeserializeObject <List <IncludeExcludeBo> >(itemBo.IncludeExcludeListRawJson); } } } } } catch (Exception ex) { responseBo = base.SaveExLog(ex, this.GetType(), MethodBase.GetCurrentMethod().Name, criteriaBo).ToResponse <List <OrderListBo> >(); } return(responseBo); }
public ResponseDto <List <OrderListDto> > GetList(OrderGetListCriteriaDto criteriaDto) { OrderGetListCriteriaBo criteriaBo = new OrderGetListCriteriaBo() { CaseId = criteriaDto.CaseId, PersonId = criteriaDto.PersonId, GetIncomings = criteriaDto.GetIncomings, GetReturns = criteriaDto.GetReturns, OrderStatList = criteriaDto.OrderStatList, CurrencyId = criteriaDto.CurrencyId, PageOffSet = criteriaDto.PageOffSet, Session = Session }; ResponseBo <List <OrderListBo> > responseBo = orderBusiness.GetList(criteriaBo); ResponseDto <List <OrderListDto> > responseDto = responseBo.ToResponseDto <List <OrderListDto>, List <OrderListBo> >(); if (responseBo.IsSuccess && responseBo.Bo != null) { responseDto.Dto = responseBo.Bo. GroupBy(x => x.Id).Select(x => x.First()). Select( x => new OrderListDto() { Id = x.Id, DebtPersonId = x.DebtPersonId, DebtPersonFullName = x.DebtPersonFullName, DebtPersonTypeId = x.DebtPersonTypeId, CreditPersonId = x.CreditPersonId, CreditPersonFullName = x.CreditPersonFullName, CreditPersonTypeId = x.CreditPersonTypeId, OrderStatId = x.OrderStatId, CurrencyId = x.CurrencyId, GrandTotal = x.GrandTotal, Notes = x.Notes, IsReturn = x.IsReturn, RelatedOrderId = x.RelatedOrderId, BasketId = x.BasketId, DeliveryAddressId = x.DeliveryAddressId, ShopId = x.ShopId, ShopFullName = x.ShopFullName, ShopStarCount = x.ShopStarCount, ShopStarSum = x.ShopStarSum, ShopUrlName = x.ShopUrlName, CommentId = x.PersonCommentId, IsCommentable = x.IsCommentable, CreateDateNumber = x.CreateDate.ToNumberFromDateTime(), UpdateDateNumber = x.UpdateDate.ToNumberFromDateTimeNull(), Phone = x.Phone, ProductList = responseBo.Bo.Where(y => y.Id == x.Id).Select( y => new OrderProductListDto() { Id = y.OrderProductId, Quantity = y.Quantity, UnitPrice = y.UnitPrice, GrandTotal = y.RowGrandTotal, Notes = y.RowNotes, ProductId = y.ProductId, ProductName = y.ProductName, ProductTypeId = y.ProductTypeId, CategoryId = y.CategoryId, StarCount = y.StarCount, StarSum = y.StarSum, PortraitImageUniqueIdStr = base.GetImageName(y.PortraitImageUniqueId, y.PortraitImageFileTypeId), CommentId = y.PersonProductCommentId, CodeList = (from z in y.CodeList select new ProductCodeDto() { Code = z.Code, ProductCodeTypeId = z.ProductCodeTypeId, ProductId = z.ProductId }).ToList(), OptionList = y.OptionList == null ? null : (from o in y.OptionList select new OptionListDto() { Id = o.OptionId, Name = o.OptionName, PriceGap = o.OptionPriceGap }).ToList(), IncludeExcludeList = y.IncludeExcludeList == null ? null : (from i in y.IncludeExcludeList select new IncludeExcludeDto() { Id = i.Id, PriceGap = i.PriceGap, Name = i.Name, IsInclude = i.IsInclude }).ToList() }).ToList() }).ToList(); } return(responseDto); }