/// <summary> /// 微盟-商品信息-批量上下架(ec/goods/updateGoodsShelfStatus) /// </summary> public void UpdateGoodsShelfStatusToWm(DateTime startDate, DateTime endDate) { string preMsg = "微盟 批量上下架 "; string sql = @"select a.F_ID, F_GoodsID, F_Stop from v_Item_NoPic a where a.F_UpdateTime >= '" + startDate.ToString("yyyy-MM-dd HH:mm:ss") + @"' and a.F_UpdateTime < '" + endDate.ToString("yyyy-MM-dd HH:mm:ss") + @"' and a.F_GoodsID is not null "; DataTable dtItem = sd.GetDataTable(sql); Log.WriteLog(preMsg + "取得的记录数:" + dtItem.Rows.Count + "行。", 1); if (dtItem.Rows.Count == 0) { return; } foreach (DataRow drItem in dtItem.Rows) { UpdateGoodsShelfStatusRequest request = new UpdateGoodsShelfStatusRequest(); List <long> goodsIdList = new List <long>(); goodsIdList.Add(NumUtil.GetVal_Long(drItem["F_GoodsID"])); request.goodsIdList = goodsIdList; request.isPutAway = NumUtil.ToInt(drItem["F_Stop"]); UpdateGoodsShelfStatusResponse response = HttpPostToWm <UpdateGoodsShelfStatusResponse>("ec/goods/updateGoodsShelfStatus", request, preMsg); } }
/// <summary> /// 微盟-商品信息-更新商品(ec/goods/updateGoods) /// </summary> public void UpdateGoodsToWm(DateTime startDate, DateTime endDate) { string preMsg = "微盟 更新商品 "; string sql = @"select a.F_GoodsID, a.F_SkuID, a.F_CategoryID, a.F_Name, a.F_ID, a.F_Stop, z.F_PosPrice, a.F_CostPrice, b.F_Qty from v_Item_NoPic a left join (select F_ItemZID,F_PosPrice from t_ItemZonePriceOne where F_ZoneID = '01') z on a.F_ID = z.F_ItemZID left join t_StorageQty b on a.F_ID = b.F_ItemID and a.F_ColorID = b.F_ColorID and a.F_SizeID = b.F_SizeID where a.F_UpdateTime >= '" + startDate.ToString("yyyy-MM-dd HH:mm:ss") + @"' and a.F_UpdateTime < '" + endDate.ToString("yyyy-MM-dd HH:mm:ss") + @"' and a.F_GoodsID is not null "; DataTable dtItem = sd.GetDataTable(sql); Log.WriteLog(preMsg + "取得的记录数:" + dtItem.Rows.Count + "行。", 1); if (dtItem.Rows.Count == 0) { return; } foreach (DataRow drItem in dtItem.Rows) { QueryGoodsDetailRequest queryReq = new QueryGoodsDetailRequest(); queryReq.goodsId = NumUtil.ToLong(drItem["F_GoodsID"]); QueryGoodsDetailResponse queryRsp = HttpPostToWm <QueryGoodsDetailResponse>("ec/goods/queryGoodsDetail", queryReq, preMsg); UpdateGoodsRequest request = new UpdateGoodsRequest(); PendingUpdateGoodsVo goods = new PendingUpdateGoodsVo(); goods.goodsId = NumUtil.GetVal_Long(drItem["F_GoodsID"]); goods.title = drItem["F_Name"].ToString(); goods.isMultiSku = 0; goods.goodsImageUrl = queryRsp.data.goods.goodsImageUrl; //goods.goodsDesc = ""; goods.initialSales = 0; goods.deductStockType = 1; goods.isPutAway = NumUtil.ToInt(drItem["F_Stop"]); goods.Sort = 0; goods.categoryId = NumUtil.ToLong(drItem["F_CategoryID"]); goods.b2cGoods = new PendingB2CGoodsVo { freightTemplateId = NumUtil.ToLong(G_INI.ReadValue("Local", "freightTemplateId")), deliveryTypeIdList = new List <long> { NumUtil.ToLong(G_INI.ReadValue("Local", "deliveryTypeId")) }, b2cGoodsType = 0 }; goods.skuList = new List <PendingSkuVo> { new PendingSkuVo { skuId = NumUtil.ToLong(drItem["F_SkuID"]), outerSkuCode = drItem["F_ID"].ToString(), salePrice = NumUtil.ToDecimal(drItem["F_CostPrice"]), costPrice = NumUtil.ToInt(drItem["F_Qty"]), editStockNum = 0, b2cSku = new PendingB2CSkuVo { weight = 0, volume = 0 } } }; request.goods = goods; UpdateGoodsResponse response = HttpPostToWm <UpdateGoodsResponse>("ec/goods/updateGoods", request, preMsg); } }