深圳智汇创想科技有限公司

一、查询sql

SELECT count(1)

FROM RB_AliExpress_Listing (nolock)

WHERE CustomerID=1

AND onlineState=1  --在线状态

AND  Detail IS NOT NULL AND  convert(nvarchar(max),Detail)<>'' --web产品描述

AND ISNULL(IsMobileDetail,0)=1 --开启无线状态

AND  (MobileDetail IS NULL OR convert(nvarchar(max),MobileDetail)='')  --app产品描述

SELECT count(1)
FROM RB_AliExpress_Listing (nolock)
WHERE CustomerID=1
AND onlineState=1 --在线状态
AND (Detail IS NULL OR convert(nvarchar(max),Detail)='') --web产品描述
AND ISNULL(IsMobileDetail,0)=1 --开启无线状态
AND (MobileDetail IS NULL OR convert(nvarchar(max),MobileDetail)='') --app产品描述

二、描述赋值位置

1. AliExpressListing.cs==》DownloadSingleProduct==》262

2. 下载速卖通单个产品

AliExpressListing.cs==》DownloadSingleProductV2==》3408--3414

3. 发布商品（速卖通发布Listing队列任务）

AliExpressListing.cs==》PrepareUploadProductDetailV2

AliExpressListingID
1005006289731890
1005006214008670
1005006214051429
1005006214112149
1005006265570692
1005006313190491
1005006328646714
1005006329095467
1005006329074669
1005006328970456
1005006329090643
1005006329139629
1005006329183449
1005006329247971
1005006329391288
1005006329347505
1005006329467972
1005006330143097
1005006330616024
1005006333905299
1005001544256276
1005001541194067
1005004832167845
1005006342498873
1005006357553142
1005006357403845
1005006357430760
1005006357770061
1005006357666987
1005006292786035
1005006293012393
1005006292823842
1005006292909501
1005006342732610
1005006342731743
32922246200
1005006279641397
4000266621998
4000242007802
4000219555626
1005006283692609
1005006352882254
1005006352760507
第一种获取不到描述原因：

1005001544256276 该数据返回的描述获取到两个类型数据，但此处判断并未判定是htnl的，随机获取了其中一条数据判定有无html是否有数据，因此赋值失败

第二种获取不到描述原因：

返回数据多个html，

1. <div class="detailmodule_dynamic"></div><div class="detailmodule_dynamic"></div>

2.<br />
<br />
<p><span style="font-family: times new roman , times , serif;"><span style="font-size: 20.0px;"><span style="font-size: 14.0px;"><strong>Description</strong><br />
    The item is a set of colorful hourglass sand clock timers, which includes one 30 second sandglass, one 1 min sandglass, one 3 mins sandglass, one 5 mins sandglass and one 10 mins sandglass, and is made of durable PVC, ABS, glass tube and sand materials. They are perfect for timing cooking, games, exercising and so on, and also a wonderful decroation for your home and office.<br />
    <br />
    <strong>Features</strong><br />
    - 5 pieces of different time hourglass sand clock timers in one set will be sold together by random color.<br />
    - Material: durable PVC, ABS, glass tube and sand.<br />
    - Each Size: about 8.5&times;2.5cm.<br />
    - Counting time: 30 seconds, 1 minute, 3 minutes, 5 minutes, 10 minutes, each one with 10% time deviation.<br />
    - 100% and high quality Colorful Hourglass Sandglass Sand Clock Timers.<br />
    - Ideal for timing cooking, games, exercising and so on.<br />
    - Also act as a wonderful decoration for your home and office.</span><br />
    <strong><span style="color: #ff0000;">- Note: This is a sand timer made for games. It is not a precision timing device, so there is time deviation. </span></strong></span></span></p>
<p>
    <img alt="3" src="https://ae01.alicdn.com/kf/HTB1zTyFa5zxK1RkSnaVq6xn9VXaM.jpg" />
</p>
<p>
    <img alt="4" src="http://ae01.alicdn.com/kf/HTB1DPIBkBTH8KJjy0Fiq6ARsXXa5.jpg" width="800" height="800" /><img alt="1" src="http://ae01.alicdn.com/kf/HTB1WUTXc6gy_uJjSZPxq6ynNpXaC.jpg" width="800" height="800" /><img alt="2" src="http://ae01.alicdn.com/kf/HTB1rDf0kxTI8KJjSspiq6zM4FXal.jpg" width="800" height="800" /><img alt="3" src="http://ae01.alicdn.com/kf/HTB19c2lc6gy_uJjSZJnq6zuOXXaV.jpg" width="800" height="800" />
</p>
<br />
<br />
<div class="detailmodule_dynamic"></div>
<div class="detailmodule_dynamic"></div>

3. </div>
<div class="detailmodule_html"><div class="detail-desc-decorate-richtext"></div>
</div></div>

返回了这三种html类型的内容，保存了第一条

第三种结果

其一结果标签<p>

其二真是内容

第四中结果：

其一结果标签<p>   <strong>

其二结果内容

建议：

1.首选去掉获取第一条数据做判断

2.筛选出返回类型是html数据

3.若返回类型未html数据只有一条则直接写入，返回有多条则排除内容小于150长度的数据或者获取最长数据

4.将所有html全部拼接一起

3和4二选一