上海仓
搜索城市配送区域
select DefineRemark,DefineValue,DefineName FROM [Efruit_CN_SH].[dbo].[Dim_DefineData] where DefineType='城市区域'
定位上海配送周边城市仓ID
<div>select * from [Efruit_CN_SH].[dbo].Dim_Area where WebCode='128'</div><div> AND Disabled=0</div>
找出所有匹配的城市
select HighName,priorName,DeliveryAreaRemark,AreaName,AreaCode from [Efruit_CN_SH].[dbo].Dim_Area where WebCode='128' AND grade in(2,3,4) AND Disabled=0 order by HighName
逐一筛选要查看的单一城市的234级城区
select HighName,priorName,DeliveryAreaRemark,AreaName,AreaCode from [Efruit_CN_SH].[dbo].Dim_Area where WebCode='128' AND grade in(2,3,4) AND Disabled=0 AND PriorName='苏州市'
杭州仓
搜索城市配送区域
select DefineRemark,DefineValue,DefineName FROM [Efruit_CN_SH].[dbo].[Dim_DefineData] where DefineType='城市区域'
定位杭州配送周边城市仓ID
<div>select * from [Efruit_CN_SH].[dbo].Dim_Area where WebCode='131072'</div><div> AND Disabled=0</div>
找出所有匹配的城市
select HighName,priorName,DeliveryAreaRemark,AreaName,AreaCode from [Efruit_CN_SH].[dbo].Dim_Area where WebCode='131072' AND grade in(2,3,4) AND Disabled=0 order by HighName
切仓checklist
选择区域 城市为宁波( 镇海区、江北区、鄞州区、海曙区、江东区)地址下单,商品从杭州仓发货
选择区域 城市为宁波( 北仑、宁海、象山)地址下单,商品不从杭州仓发货
城市为宁波，发货仓=杭州仓，有对应的促销规则，正常显示促销规则
城市为宁波，发货仓=杭州仓，有对应的促销规则，正常促销金额下单正常
<p class="MsoNormal"><span style="font-size: 9pt;">判断城市区域定义，从[dbo].[Dim_DefineData]的[DefineRemark]字段获取，获取方式如下：</span><span style="font-size: 9pt;"><o:p></o:p></span></p><p class="MsoNormal"><span style="font-size: 9pt;">Select * from [dbo].[Dim_DefineData] where definetype = '城市区域 '</span><span style="font-size: 9pt;"><o:p></o:p></span></p>
