public static StoreBasicInfo QueryStoreBasicInfoBySellerSysNo(int sellerSysNo) { DataCommand cmd = DataCommandManager.GetDataCommand("QueryStoreBasicInfoBySellerSysNo"); cmd.SetParameterValue("@SellerSysNo", sellerSysNo); var ds = cmd.ExecuteDataSet(); List <string> BrandNames = new List <string>(); if (ds.Tables.Count > 0) { var dt0 = ds.Tables[0]; foreach (DataRow row in dt0.Rows) { BrandNames.Add(row[0].ToString()); } } List <string> CategoryNames = new List <string>(); if (ds.Tables.Count > 1) { var dt1 = ds.Tables[1]; foreach (DataRow row in dt1.Rows) { CategoryNames.Add(row[0].ToString()); } } StoreBasicInfo result = new StoreBasicInfo(); if (ds.Tables.Count > 2) { var dt2 = ds.Tables[2]; if (dt2.Rows.Count > 0) { DataMapper.AutoMap <StoreBasicInfo>(result, dt2.Rows[0]); } } result.MainBrand = String.Join("/", BrandNames.ToArray()); result.MainProductCategory = String.Join("/", CategoryNames.ToArray()); return(result); }
private RefundPrintInfo GetRefundInfo(int refundSysNo) { RefundPrintInfo refundInfo = new RefundPrintInfo(); refundInfo.Items = new List <RefundItemPrintInfo>(); var dtRefund = ObjectFactory <RefundProcessor> .Instance.GetRefundPrintDetail(refundSysNo); var dtRefundItems = ObjectFactory <RefundProcessor> .Instance.GetRefundPrintItems(refundSysNo); if (dtRefund.Rows.Count == 0) { throw new BizException(ResouceManager.GetMessageString("RMA.Refund", "Refund_Refund_NotExists")); } DataMapper.AutoMap <RefundPrintInfo>(refundInfo, dtRefund.Rows[0]); if (dtRefundItems.Rows.Count > 0) { foreach (DataRow row in dtRefundItems.Rows) { RefundItemPrintInfo item = new RefundItemPrintInfo(); DataMapper.AutoMap <RefundItemPrintInfo>(item, row); refundInfo.Items.Add(item); } } if (refundInfo.Items != null) { refundInfo.Items.ForEach(item => { item.Quantity = -1; item.IsPoint = false; item.Price = refundInfo.RefundPayType == RefundPayType.TransferPointRefund ? 0M : (item.RefundCash ?? 0M); item.TotalAmount = item.Quantity * item.Price; }); if (refundInfo.DeductPointFromCurrentCash != null && refundInfo.DeductPointFromCurrentCash != 0) { RefundItemPrintInfo printItem = new RefundItemPrintInfo() { ProductID = "赎回积分", IsPoint = false, TotalAmount = refundInfo.DeductPointFromCurrentCash.Value }; refundInfo.Items.Add(printItem); } if (refundInfo.CompensateShipPrice != null && refundInfo.CompensateShipPrice.Value != 0) { RefundItemPrintInfo printItem = new RefundItemPrintInfo() { ProductID = "补偿运费", IsPoint = false, TotalAmount = -1 * refundInfo.CompensateShipPrice.Value }; refundInfo.Items.Add(printItem); } if (refundInfo.PointAmount != null && refundInfo.PointAmount.Value != 0) { RefundItemPrintInfo printItem = new RefundItemPrintInfo() { ProductID = "影响积分", IsPoint = true, TotalAmount = refundInfo.PointAmount.Value + (refundInfo.RefundPayType == RefundPayType.TransferPointRefund ? (refundInfo.CashAmount ?? 0M) * ExternalDomainBroker.GetPointToMoneyRatio() : 0M) }; refundInfo.Items.Add(printItem); } } return(refundInfo); }