public string GetTCTWPanicbuyingEventKV(string pRequest) { TCTWPanicbuyingEventKVRD rd = new TCTWPanicbuyingEventKVRD(); try { var rp = pRequest.DeserializeJSONTo <APIRequest <GetTCTWPanicbuyingEventKVRP> >(); //var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID); var bll = new PanicbuyingEventSkuMappingBLL(loggingSessionInfo); DataSet ds = bll.GetTCTWPanicbuyingEventKV(rp.Parameters.CTWEventId); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count != 0) { rd.TCTWPanicbuyingEventKVInfo = DataTableToObject.ConvertToObject <T_CTW_PanicbuyingEventKVEntity>(ds.Tables[0].Rows[0]); } var rsp = new SuccessResponse <IAPIResponseData>(rd); return(rsp.ToJSON()); } catch (Exception ex) { throw new APIException(ex.Message); } //return "{\"ResultCode\":0,\"Message\":\"OK\",\"Data\":{\"ItemList\":[{\"ItemID\":\"22\",\"ItemName\":\"美的\",\"ImageUrl\":\"http://www.o2omarketing.cn: 8400/Framework/Javascript/Other/kindeditor/attached/image/lzlj/album1.jpg\",\"SkuList\":[{\"kuID\":\"1111\",\"SkuName\":\"138L(银灰色)\",\"Qty\":\"250\",\"KeepQty\":\"200\",\"SoldQty\":\"30\",\"InverTory\":\"20\"}]}]}}"; }
public string GetEventMerchandise(string pRequest) { EventMerchandiseRD rd = new EventMerchandiseRD(); try { var rp = pRequest.DeserializeJSONTo <APIRequest <EventMerchandiseRP> >(); //var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID); var bll = new PanicbuyingEventSkuMappingBLL(loggingSessionInfo); DataSet ds = bll.GetEventMerchandise(rp.Parameters.EventId); if (ds.Tables.Count > 0 && ds.Tables[0] != null) { rd.ItemList = DataTableToObject.ConvertToList <Item>(ds.Tables[0]); foreach (var item in rd.ItemList) { DataSet skuds = bll.GetGetEventMerchandiseSku(item.EventItemMappingId.ToString()); if (skuds.Tables.Count > 0 && skuds.Tables[0] != null) { item.SkuList = DataTableToObject.ConvertToList <Sku>(skuds.Tables[0]); } } } //查询 var eventBll = new PanicbuyingEventBLL(loggingSessionInfo); var tempEvent = eventBll.GetPanicbuyingEventDetails(rp.Parameters.EventId); PanicbuyingEvent eventEntity = new PanicbuyingEvent(); eventEntity.EventId = tempEvent.EventId; eventEntity.EventName = tempEvent.EventName; eventEntity.EventTypeId = tempEvent.EventTypeId; eventEntity.BeginTime = tempEvent.BeginTime.ToString("yyyy-MM-dd HH:mm"); eventEntity.EndTime = tempEvent.EndTime.ToString("yyyy-MM-dd HH:mm"); eventEntity.CustomerID = tempEvent.CustomerID; eventEntity.Qty = tempEvent.Qty; eventEntity.RemainQty = tempEvent.RemainQty; eventEntity.EventStatus = tempEvent.EventStatus.ToString(); //倒计时 // TimeSpan nowSpan = tempEvent.EndTime - DateTime.Now;//应该是结束时间减去当前时间 // eventEntity.DeadlineSecond = nowSpan.TotalSeconds<=0?0: Convert.ToInt32( nowSpan.TotalSeconds); rd.TimeFlag = "begin"; if (tempEvent.BeginTime > DateTime.Now) { TimeSpan nowSpan = tempEvent.BeginTime - DateTime.Now;//应该是结束时间减去当前时间 eventEntity.DeadlineSecond = nowSpan.TotalSeconds <= 0 ? 0 : Convert.ToInt32(nowSpan.TotalSeconds); if (eventEntity.DeadlineSecond > 0) { eventEntity.DeadlineTime = nowSpan.Days + "天" + nowSpan.Hours + "时" + nowSpan.Minutes + "分" + nowSpan.Seconds; } else { eventEntity.DeadlineTime = 0 + "天" + 0 + "时" + 0 + "分" + 0; } } else { rd.TimeFlag = "end"; TimeSpan nowSpan = tempEvent.EndTime - DateTime.Now;//应该是结束时间减去当前时间 eventEntity.DeadlineSecond = nowSpan.TotalSeconds <= 0 ? 0 : Convert.ToInt32(nowSpan.TotalSeconds); if (eventEntity.DeadlineSecond > 0) { eventEntity.DeadlineTime = nowSpan.Days + "天" + nowSpan.Hours + "时" + nowSpan.Minutes + "分" + nowSpan.Seconds; } else { eventEntity.DeadlineTime = 0 + "天" + 0 + "时" + 0 + "分" + 0; } } rd.BeginTime = tempEvent.BeginTime.ToString("MM月dd日"); rd.PanicbuyingEvent = eventEntity; var rsp = new SuccessResponse <IAPIResponseData>(rd); return(rsp.ToJSON()); } catch (Exception ex) { throw new APIException(ex.Message); } //return "{\"ResultCode\":0,\"Message\":\"OK\",\"Data\":{\"ItemList\":[{\"ItemID\":\"22\",\"ItemName\":\"美的\",\"ImageUrl\":\"http://www.o2omarketing.cn: 8400/Framework/Javascript/Other/kindeditor/attached/image/lzlj/album1.jpg\",\"SkuList\":[{\"kuID\":\"1111\",\"SkuName\":\"138L(银灰色)\",\"Qty\":\"250\",\"KeepQty\":\"200\",\"SoldQty\":\"30\",\"InverTory\":\"20\"}]}]}}"; }
protected override GetBargainDetailsRD ProcessRequest(DTO.Base.APIRequest <GetBargainDetailsRP> pRequest) { var rd = new GetBargainDetailsRD(); var para = pRequest.Parameters; var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; var ItemBll = new T_ItemBLL(loggingSessionInfo); var EventItemMappingBll = new PanicbuyingKJEventItemMappingBLL(loggingSessionInfo); //砍价活动sku业务对象 var PanicbuyingKJEventSkuMappingBll = new PanicbuyingKJEventSkuMappingBLL(loggingSessionInfo); var SkuBll = new T_SkuBLL(loggingSessionInfo); //活动 var SkuMappingBLL = new PanicbuyingEventSkuMappingBLL(loggingSessionInfo); // string ItemID = string.Empty; var SkuMappingList = new List <PanicbuyingKJEventSkuMappingEntity>(); if (!string.IsNullOrWhiteSpace(para.EventItemMappingID)) { var EventItemData = EventItemMappingBll.GetByID(para.EventItemMappingID); if (EventItemData != null) { ItemID = EventItemData.ItemID; //商品信息赋值 rd.SinglePurchaseQty = EventItemData.SinglePurchaseQty.Value; rd.ItemID = EventItemData.ItemID; rd.BargaingingInterval = EventItemData.BargaingingInterval.Value; } //砍价Sku集合 SkuMappingList = PanicbuyingKJEventSkuMappingBll.QueryByEntity(new PanicbuyingKJEventSkuMappingEntity() { EventItemMappingID = para.EventItemMappingID }, null).ToList(); } else { ItemID = para.ItemId; } var ItemData = ItemBll.GetByID(ItemID); if (ItemData == null) { throw new APIException("未找到相关商品,请确认参数") { ErrorCode = ERROR_CODES.INVALID_BUSINESS } } ; //商品ID、名称赋值 rd.ItemID = ItemID; rd.ItemName = ItemData.item_name; #region sku rd.SkuInfoList = new List <SkuInfos>(); //var SkuList = SkuBll.QueryByEntity(new T_SkuEntity() { item_id = ItemID }, null).ToList(); DataSet ds = SkuMappingBLL.GetItemSku("", ItemID, ""); var SkuList = new List <Sku>(); if (ds.Tables.Count > 0 && ds.Tables[0] != null) { SkuList = DataTableToObject.ConvertToList <Sku>(ds.Tables[0]); } foreach (var item in SkuList) { var SkuInfos = new SkuInfos(); SkuInfos.SkuID = item.SkuID; SkuInfos.SkuName = item.SkuName; SkuInfos.Price = item.price; if (!string.IsNullOrWhiteSpace(para.EventItemMappingID)) { var Result = SkuMappingList.FirstOrDefault(m => m.SkuID.Equals(item.SkuID)); if (Result != null) { SkuInfos.EventSkuInfo = new EventSkuInfo(); SkuInfos.EventSkuInfo.EventSKUMappingId = Result.EventSKUMappingId.ToString(); SkuInfos.EventSkuInfo.EventItemMappingID = Result.EventItemMappingID.ToString(); SkuInfos.EventSkuInfo.SkuID = Result.SkuID; SkuInfos.EventSkuInfo.Qty = Result.Qty.Value; SkuInfos.EventSkuInfo.Price = Result.Price.Value; SkuInfos.EventSkuInfo.BasePrice = Result.BasePrice.Value; SkuInfos.EventSkuInfo.BargainStartPrice = Result.BargainStartPrice.Value; SkuInfos.EventSkuInfo.BargainEndPrice = Result.BargainEndPrice.Value; } } // rd.SkuInfoList.Add(SkuInfos); } #endregion return(rd); } }