BUG #42086 irobotbox_reportcentre_customreportedit_aspx - 技术中心-需求池

重现步骤

prometheus告警

            开始时间: 14:42:36 

            错误代码: N14423611

            sql类型: --物流属性表

            sql: [14:42:36]  -------------------------------------------------------------

CODE:N14423611

Error:15_102_1_-2146232060

SQL:--物流属性表

DROP TABLE IF EXISTS #temp_WithBattery

select top 0 a.*

INTO #temp_WithBattery

FROM(

select top 0 1 WithBatteryValue, '普货' WithBatteryName UNION ALL

select top 0 2 WithBatteryValue, '纯电池' WithBatteryName UNION ALL

select top 0 3 WithBatteryValue, '带内置电池' WithBatteryName UNION ALL

select top 0 4 WithBatteryValue, '带外置电池' WithBatteryName UNION ALL

select top 0 5 WithBatteryValue, '含纽扣电池' WithBatteryName UNION ALL

select top 0 6 WithBatteryValue, '液体' WithBatteryName UNION ALL

select top 0 7 WithBatteryValue, '粉末' WithBatteryName UNION ALL

select top 0 8 WithBatteryValue, '打火机' WithBatteryName UNION ALL

select top 0 9 WithBatteryValue, '刀具_剪刀_仿真枪' WithBatteryName UNION ALL

select top 0 10 WithBatteryValue, '带磁物品' WithBatteryName UNION ALL

select top 0 12 WithBatteryValue, '木质类_竹质类' WithBatteryName UNION ALL

select top 0 11 WithBatteryValue, '其他禁运物品' WithBatteryName UNION ALL

select top 0 13 WithBatteryValue, '膏状' WithBatteryName UNION ALL

select top 0 14 WithBatteryValue, '易碎' WithBatteryName UNION ALL

select top 0 15 WithBatteryValue, '动物羽毛类' WithBatteryName UNION ALL

select top 0 16 WithBatteryValue, '大功率电池' WithBatteryName UNION ALL

select top 0 17 WithBatteryValue, '电子烟' WithBatteryName UNION ALL

select top 0 18 WithBatteryValue, '移动电源' WithBatteryName UNION ALL

select top 0 19 WithBatteryValue, '可拆卸电池' WithBatteryName UNION ALL

select top 0 20 WithBatteryValue, '厨具' WithBatteryName UNION ALL

select top 0 21 WithBatteryValue, '电机_马达' WithBatteryName UNION ALL

select top 0 22 WithBatteryValue, '超体积普' WithBatteryName UNION ALL

select top 0 23 WithBatteryValue, '超体积非普' WithBatteryName UNION ALL

select top 0 24 WithBatteryValue, '手机' WithBatteryName UNION ALL

select top 0 25 WithBatteryValue, '平衡车' WithBatteryName UNION ALL

select top 0 26 WithBatteryValue, '液体笔类' WithBatteryName UNION ALL

select top 0 27 WithBatteryValue, '纺织品' WithBatteryName UNION ALL

select top 0 28 WithBatteryValue, '植物种子' WithBatteryName UNION ALL

select top 0 29 WithBatteryValue, '深圳普货' WithBatteryName UNION ALL

select top 0 30 WithBatteryValue, '成人用品' WithBatteryName UNION ALL

select top 0 31 WithBatteryValue, '无' WithBatteryName UNION ALL

select top 0 32 WithBatteryValue, '眼镜' WithBatteryName UNION ALL

select top 0 33 WithBatteryValue, '口红' WithBatteryName UNION ALL

select top 0 34 WithBatteryValue, '手表' WithBatteryName UNION ALL

select top 0 35 WithBatteryValue, '香水' WithBatteryName UNION ALL

select top 0 36 WithBatteryValue, '纯液体' WithBatteryName UNION ALL

select top 0 37 WithBatteryValue, '医疗设备' WithBatteryName UNION ALL

select top 0 38 WithBatteryValue, '人造羽毛' WithBatteryName UNION ALL

select top 0 39 WithBatteryValue, '内置锂金属电池' WithBatteryName UNION ALL

select top 0 40 WithBatteryValue, '配套干电池' WithBatteryName UNION ALL

select top 0 41 WithBatteryValue, '厨房刀具' WithBatteryName UNION ALL

select top 0 42 WithBatteryValue, '军工刀具' WithBatteryName UNION ALL

select top 0 45 WithBatteryValue, '无线充' WithBatteryName UNION ALL

select top 0 46 WithBatteryValue, '原木' WithBatteryName UNION ALL

select top 0 47 WithBatteryValue, '面具类' WithBatteryName UNION ALL

select top 0 48 WithBatteryValue, '金属高密度' WithBatteryName UNION ALL

select top 0 49 WithBatteryValue, '防疫用品' WithBatteryName UNION ALL

select top 0 50 WithBatteryValue, '酒精' WithBatteryName UNION ALL

select top 0 51 WithBatteryValue, '酒精棉' WithBatteryName UNION ALL

select top 0 52 WithBatteryValue, '纸巾' WithBatteryName UNION ALL

select top 0 100 WithBatteryValue, '风扇' WithBatteryName UNION ALL

select top 0 0 WithBatteryValue, '未选择' WithBatteryName UNION ALL

select top 0 101 WithBatteryValue, '水杯' WithBatteryName UNION ALL

select top 0 102 WithBatteryValue, '测试' WithBatteryName UNION ALL

select top 0 103 WithBatteryValue, '面罩类' WithBatteryName UNION ALL

select top 0 104 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL

select top 0 105 WithBatteryValue, '食品' WithBatteryName UNION ALL

select top 0 106 WithBatteryValue, '颗粒状' WithBatteryName UNION ALL

select top 0 107 WithBatteryValue, '药品' WithBatteryName UNION ALL

select top 0 108 WithBatteryValue, '头盔' WithBatteryName UNION ALL

select top 0 109 WithBatteryValue, '纯普货' WithBatteryName UNION ALL

select top 0 110 WithBatteryValue, '尖锐利器' WithBatteryName UNION ALL

select top 0 111 WithBatteryValue, '无电池电子产品' WithBatteryName UNION ALL

select top 0 112 WithBatteryValue, '内置纽扣电池' WithBatteryName UNION ALL

select top 0 113 WithBatteryValue, '内置柱状电池' WithBatteryName UNION ALL

select top 0 114 WithBatteryValue, '内置块状电池' WithBatteryName UNION ALL

select top 0 115 WithBatteryValue, '其它内置电池' WithBatteryName UNION ALL

select top 0 116 WithBatteryValue, '配套纽扣电池' WithBatteryName UNION ALL

select top 0 117 WithBatteryValue, '配套柱状电池' WithBatteryName UNION ALL

select top 0 118 WithBatteryValue, '配套块状电池' WithBatteryName UNION ALL

select top 0 119 WithBatteryValue, '其它配套电池' WithBatteryName UNION ALL

select top 0 120 WithBatteryValue, '纽扣电池' WithBatteryName UNION ALL

select top 0 121 WithBatteryValue, '柱状电池' WithBatteryName UNION ALL

select top 0 122 WithBatteryValue, '块状电池' WithBatteryName UNION ALL

select top 0 123 WithBatteryValue, '其它纯电池' WithBatteryName UNION ALL

select top 0 124 WithBatteryValue, '易碎玻璃' WithBatteryName UNION ALL

select top 0 125 WithBatteryValue, '强磁' WithBatteryName UNION ALL

select top 0 126 WithBatteryValue, '微量膏体' WithBatteryName UNION ALL

select top 0 127 WithBatteryValue, '其它膏体' WithBatteryName UNION ALL

select top 0 128 WithBatteryValue, '微量粉末' WithBatteryName UNION ALL

select top 0 129 WithBatteryValue, '其它粉末' WithBatteryName UNION ALL

select top 0 130 WithBatteryValue, '微量液体' WithBatteryName UNION ALL

select top 0 131 WithBatteryValue, '少量液体' WithBatteryName UNION ALL

select top 0 132 WithBatteryValue, '较多液体' WithBatteryName UNION ALL

select top 0 133 WithBatteryValue, '其它液体' WithBatteryName UNION ALL

select top 0 134 WithBatteryValue, '办公刀具小尺寸' WithBatteryName UNION ALL

select top 0 135 WithBatteryValue, '办公刀具中尺寸' WithBatteryName UNION ALL

select top 0 136 WithBatteryValue, '办公刀具大尺寸' WithBatteryName UNION ALL

select top 0 137 WithBatteryValue, '厨房刀具小尺寸' WithBatteryName UNION ALL

select top 0 138 WithBatteryValue, '厨房刀具中尺寸' WithBatteryName UNION ALL

select top 0 139 WithBatteryValue, '厨房刀具大尺寸' WithBatteryName UNION ALL

select top 0 140 WithBatteryValue, '户外刀具小尺寸' WithBatteryName UNION ALL

select top 0 141 WithBatteryValue, '户外刀具中尺寸' WithBatteryName UNION ALL

select top 0 142 WithBatteryValue, '户外刀具大尺寸' WithBatteryName UNION ALL

select top 0 143 WithBatteryValue, '间谍器材' WithBatteryName UNION ALL

select top 0 144 WithBatteryValue, '其它易燃易爆' WithBatteryName UNION ALL

select top 0 145 WithBatteryValue, '管制刀具小尺寸' WithBatteryName UNION ALL

select top 0 146 WithBatteryValue, '其它管制器具' WithBatteryName UNION ALL

select top 0 147 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL

select top 0 148 WithBatteryValue, '其它禁寄物品' WithBatteryName UNION ALL

select top 0 149 WithBatteryValue, '111' WithBatteryName UNION ALL

select top 0 150 WithBatteryValue, '其它泛普货' WithBatteryName UNION ALL

select top 0 151 WithBatteryValue, '虎指' WithBatteryName UNION ALL

select top 0 152 WithBatteryValue, '甩棍' WithBatteryName UNION ALL

select top 0 153 WithBatteryValue, '弓弩' WithBatteryName UNION ALL

select top 0 154 WithBatteryValue, '金属大体积' WithBatteryName UNION ALL

select top 0 155 WithBatteryValue, '迷你蓝牙耳机' WithBatteryName UNION ALL

select top 0 156 WithBatteryValue, '其它蓝牙耳机' WithBatteryName UNION ALL

select top 0 157 WithBatteryValue, '迷你蓝牙音响' WithBatteryName UNION ALL

select top 0 158 WithBatteryValue, '其它蓝牙音响' WithBatteryName UNION ALL

select top 0 159 WithBatteryValue, '迷你移动电源' WithBatteryName UNION ALL

select top 0 160 WithBatteryValue, '其它移动电源' WithBatteryName UNION ALL

select top 0 161 WithBatteryValue, '其它带磁带电' WithBatteryName UNION ALL

select top 0 162 WithBatteryValue, '微量固体' WithBatteryName UNION ALL

select top 0 163 WithBatteryValue, '其它固体' WithBatteryName UNION ALL

select top 0 164 WithBatteryValue, '打火石' WithBatteryName UNION ALL

select top 0 165 WithBatteryValue, '指甲油' WithBatteryName UNION ALL

select top 0 166 WithBatteryValue, '香水' WithBatteryName UNION ALL

select top 0 167 WithBatteryValue, '管制刀具中尺寸' WithBatteryName UNION ALL

select top 0 168 WithBatteryValue, '管制刀具大尺寸' WithBatteryName UNION ALL

select top 0 169 WithBatteryValue, '微量胶体' WithBatteryName UNION ALL

select top 0 170 WithBatteryValue, '' WithBatteryName UNION ALL

select top 0 171 WithBatteryValue, '较多胶体' WithBatteryName UNION ALL

select top 0 172 WithBatteryValue, '其它胶体' WithBatteryName UNION ALL

select top 0 173 WithBatteryValue, '哈哈哈哈' WithBatteryName UNION ALL

select top 0 174 WithBatteryValue, '口罩' WithBatteryName UNION ALL

select top 0 175 WithBatteryValue, '李英' WithBatteryName UNION ALL

select top 0 176 WithBatteryValue, '蜡烛' WithBatteryName UNION ALL

select top 0 177 WithBatteryValue, '剪刀' WithBatteryName UNION ALL

select top 0 178 WithBatteryValue, '单边超过40cm抛货带磁' WithBatteryName UNION ALL

select top 0 179 WithBatteryValue, '强磁' WithBatteryName UNION ALL

select top 0 180 WithBatteryValue, '单边超过40cm抛货普货' WithBatteryName UNION ALL

select top 0 181 WithBatteryValue, '单边超过40cm抛货特货' WithBatteryName UNION ALL

select top 0 182 WithBatteryValue, '利器' WithBatteryName UNION ALL

select top 0 183 WithBatteryValue, '刀' WithBatteryName UNION ALL

select top 0 184 WithBatteryValue, '抛货特货' WithBatteryName UNION ALL

select top 0 185 WithBatteryValue, '抛货普货' WithBatteryName UNION ALL

select top 0 186 WithBatteryValue, '抛货带磁' WithBatteryName UNION ALL

select top 0 187 WithBatteryValue, '抛货纽扣电池' WithBatteryName UNION ALL

select top 0 188 WithBatteryValue, '单边超过40cm抛货纽扣电池' WithBatteryName UNION ALL

select top 0 189 WithBatteryValue, '自定义-液体' WithBatteryName UNION ALL

select top 0 190 WithBatteryValue, '面膜鼻膜眼膜胸膜' WithBatteryName UNION ALL

select top 0 191 WithBatteryValue, '办公刀具超大尺寸' WithBatteryName UNION ALL

select top 0 192 WithBatteryValue, '厨房刀具超大尺寸' WithBatteryName UNION ALL

select top 0 193 WithBatteryValue, '户外刀具超大尺寸' WithBatteryName UNION ALL

select top 0 194 WithBatteryValue, '管制刀具超大尺寸' WithBatteryName UNION ALL

select top 0 195 WithBatteryValue, '内电打火机' WithBatteryName UNION ALL

select top 0 196 WithBatteryValue, '压电打火机' WithBatteryName UNION ALL

select top 0 197 WithBatteryValue, '火石打火机' WithBatteryName UNION ALL

select top 0 198 WithBatteryValue, '超重超大件普货' WithBatteryName UNION ALL

select top 0 199 WithBatteryValue, '超重超大件非普货' WithBatteryName UNION ALL

select top 0 200 WithBatteryValue, '自定义-纯电池' WithBatteryName UNION ALL

select top 0 201 WithBatteryValue, '自定义-带外置电池' WithBatteryName UNION ALL

select top 0 202 WithBatteryValue, '内置电池-自定义' WithBatteryName UNION ALL

select top 0 203 WithBatteryValue, '自定义-膏体' WithBatteryName UNION ALL

select top 0 204 WithBatteryValue, '自定义-粉末' WithBatteryName UNION ALL

select top 0 205 WithBatteryValue, '自定义-带磁' WithBatteryName UNION ALL

select top 0 206 WithBatteryValue, '自定义-电机马达' WithBatteryName UNION ALL

select top 0 207 WithBatteryValue, '反倾销属性' WithBatteryName UNION ALL

select top 0 208 WithBatteryValue, '自主加工' WithBatteryName UNION ALL

select top 0 209 WithBatteryValue, '弱磁' WithBatteryName UNION ALL

select top 0 210 WithBatteryValue, '液体&带电' WithBatteryName UNION ALL

select top 0 211 WithBatteryValue, '液体（不带电）' WithBatteryName UNION ALL

select top 0 212 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL

select top 0 213 WithBatteryValue, '口红液体' WithBatteryName UNION ALL

select top 0 214 WithBatteryValue, '口红膏体' WithBatteryName UNION ALL

select top 0 215 WithBatteryValue, '测试物流属性' WithBatteryName UNION ALL

select top 0 216 WithBatteryValue, '612' WithBatteryName UNION ALL

select top 0 217 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL

select top 0 218 WithBatteryValue, '较多膏体' WithBatteryName UNION ALL

select top 0 219 WithBatteryValue, '少量膏体' WithBatteryName UNION ALL

select top 0 220 WithBatteryValue, '较多固体' WithBatteryName UNION ALL

select top 0 221 WithBatteryValue, '少量固体' WithBatteryName UNION ALL

select top 0 222 WithBatteryValue, '较多粉末' WithBatteryName UNION ALL

select top 0 223 WithBatteryValue, '少量粉末' WithBatteryName UNION ALL

select top 0 224 WithBatteryValue, '机械手表' WithBatteryName UNION ALL

select top 0 225 WithBatteryValue, '电子手表' WithBatteryName UNION ALL

select top 0 226 WithBatteryValue, '智能手表' WithBatteryName UNION ALL

select top 0 227 WithBatteryValue, '智能手环' WithBatteryName UNION ALL

select top 0 228 WithBatteryValue, '饼状' WithBatteryName UNION ALL

select top 0 229 WithBatteryValue, '干花' WithBatteryName UNION ALL

select top 0 230 WithBatteryValue, '枕头支架' WithBatteryName UNION ALL

select top 0 231 WithBatteryValue, 'NS-超体积普' WithBatteryName UNION ALL

select top 0 232 WithBatteryValue, '抛物' WithBatteryName UNION ALL

select top 0 233 WithBatteryValue, '口罩' WithBatteryName UNION ALL

select top 0 234 WithBatteryValue, '哑铃（10KG+）' WithBatteryName UNION ALL

select top 0 235 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL

select top 0 236 WithBatteryValue, '蜡烛类' WithBatteryName UNION ALL

select top 0 237 WithBatteryValue, '无电池' WithBatteryName UNION ALL

select top 0 238 WithBatteryValue, '轻抛类' WithBatteryName UNION ALL

select top 0 239 WithBatteryValue, '高价值产品' WithBatteryName UNION ALL

select top 0 240 WithBatteryValue, '蓝牙产品' WithBatteryName UNION ALL

select top 0 241 WithBatteryValue, 'FDA产品' WithBatteryName UNION ALL

select top 0 242 WithBatteryValue, 'HDMI产品' WithBatteryName UNION ALL

select top 0 243 WithBatteryValue, '儿童玩具' WithBatteryName UNION ALL

select top 0 244 WithBatteryValue, '磁铁' WithBatteryName UNION ALL

select top 0 245 WithBatteryValue, '木制品（无熏蒸）' WithBatteryName UNION ALL

select top 0 246 WithBatteryValue, '特定磁性产品（含电机以及马达）' WithBatteryName UNION ALL

select top 0 247 WithBatteryValue, '食品' WithBatteryName UNION ALL

select top 0 248 WithBatteryValue, '口罩' WithBatteryName UNION ALL

select top 0 249 WithBatteryValue, '洗手液' WithBatteryName UNION ALL

select top 0 250 WithBatteryValue, '温度计/额湿枪' WithBatteryName UNION ALL

select top 0 251 WithBatteryValue, '医用手套/鞋套' WithBatteryName UNION ALL

select top 0 252 WithBatteryValue, '护目镜' WithBatteryName UNION ALL

select top 0 253 WithBatteryValue, '防护服' WithBatteryName UNION ALL

select top 0 254 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL

select top 0 255 WithBatteryValue, '管制刀具' WithBatteryName UNION ALL

select top 0 256 WithBatteryValue, '特殊尖锐器具' WithBatteryName UNION ALL

select top 0 257 WithBatteryValue, '易燃易爆品' WithBatteryName UNION ALL

select top 0 258 WithBatteryValue, '刺激气味产品' WithBatteryName UNION ALL

select top 0 259 WithBatteryValue, '指甲油产品' WithBatteryName UNION ALL

select top 0 260 WithBatteryValue, '气雾产品' WithBatteryName UNION ALL

select top 0 261 WithBatteryValue, '枪支配件' WithBatteryName UNION ALL

select top 0 262 WithBatteryValue, '带电，带磁' WithBatteryName UNION ALL

select top 0 263 WithBatteryValue, 'NS-刀具_剪刀' WithBatteryName UNION ALL

select top 0 264 WithBatteryValue, 'NS-粉末' WithBatteryName UNION ALL

select top 0 265 WithBatteryValue, 'NS-超体积非普' WithBatteryName UNION ALL

select top 0 266 WithBatteryValue, '黄毛' WithBatteryName UNION ALL

select top 0 267 WithBatteryValue, '黄毛3' WithBatteryName UNION ALL

select top 0 268 WithBatteryValue, '食品接触类' WithBatteryName UNION ALL

select top 0 269 WithBatteryValue, '带电成人用品' WithBatteryName UNION ALL

select top 0 270 WithBatteryValue, '无电成人用品' WithBatteryName UNION ALL

select top 0 271 WithBatteryValue, '活性炭' WithBatteryName UNION ALL

select top 0 272 WithBatteryValue, '纪念币' WithBatteryName UNION ALL

select top 0 273 WithBatteryValue, '颗粒物' WithBatteryName UNION ALL

select top 0 274 WithBatteryValue, '测试' WithBatteryName UNION ALL

select top 0 275 WithBatteryValue, 'LED灯（不带电）' WithBatteryName UNION ALL

select top 0 276 WithBatteryValue, '仿枪支弹药' WithBatteryName UNION ALL

select top 0 277 WithBatteryValue, '打火石' WithBatteryName UNION ALL

select top 0 278 WithBatteryValue, '气体' WithBatteryName UNION ALL

select top 0 279 WithBatteryValue, '1111' WithBatteryName UNION ALL

select top 0 280 WithBatteryValue, '1111' WithBatteryName UNION ALL

select top 0 281 WithBatteryValue, '555' WithBatteryName UNION ALL

select top 0 282 WithBatteryValue, '武器' WithBatteryName UNION ALL

select top 0 283 WithBatteryValue, '上海普货' WithBatteryName UNION ALL

select top 0 284 WithBatteryValue, '沙子-敏感货' WithBatteryName UNION ALL

select top 0 285 WithBatteryValue, '敏感货' WithBatteryName UNION ALL

select top 0 286 WithBatteryValue, '违禁品' WithBatteryName UNION ALL

select top 0 287 WithBatteryValue, '普货物流灰' WithBatteryName UNION ALL

select top 0 288 WithBatteryValue, '带电物流灰' WithBatteryName UNION ALL

select top 0 289 WithBatteryValue, '你说是什么就是什么' WithBatteryName UNION ALL

select top 0 290 WithBatteryValue, '打火石' WithBatteryName UNION ALL

select top 0 291 WithBatteryValue, '干燥剂' WithBatteryName UNION ALL

select top 0 292 WithBatteryValue, '硬币' WithBatteryName UNION ALL

select top 0 293 WithBatteryValue, '测试' WithBatteryName UNION ALL

select top 0 294 WithBatteryValue, '内置电池+粉末' WithBatteryName UNION ALL

select top 0 295 WithBatteryValue, '迷彩' WithBatteryName UNION ALL

select top 0 296 WithBatteryValue, '电池类' WithBatteryName UNION ALL

select top 0 297 WithBatteryValue, '形态类' WithBatteryName UNION ALL

select top 0 298 WithBatteryValue, '违禁类' WithBatteryName UNION ALL

select top 0 299 WithBatteryValue, '特殊类' WithBatteryName UNION ALL

select top 0 300 WithBatteryValue, '基础类' WithBatteryName UNION ALL

select top 0 301 WithBatteryValue, '温度计' WithBatteryName UNION ALL

select top 0 302 WithBatteryValue, '骑行护目镜' WithBatteryName UNION ALL

select top 0 303 WithBatteryValue, '户外面具和护目镜 ' WithBatteryName UNION ALL

select top 0 304 WithBatteryValue, '护目镜' WithBatteryName UNION ALL

select top 0 305 WithBatteryValue, '超体积普（抛比小于3倍）' WithBatteryName UNION ALL

select top 0 306 WithBatteryValue, 'A-纯锂离子电池' WithBatteryName UNION ALL

select top 0 307 WithBatteryValue, 'A-带油状' WithBatteryName UNION ALL

select top 0 308 WithBatteryValue, 'A-带胶状' WithBatteryName UNION ALL

select top 0 309 WithBatteryValue, 'A-弱磁' WithBatteryName UNION ALL

select top 0 310 WithBatteryValue, 'A-带易燃固体' WithBatteryName UNION ALL

select top 0 311 WithBatteryValue, 'A-外形仿造' WithBatteryName UNION ALL

select top 0 312 WithBatteryValue, 'A-侵权' WithBatteryName UNION ALL

select top 0 313 WithBatteryValue, 'A-激光类' WithBatteryName UNION ALL

select top 0 314 WithBatteryValue, '内置电池+带磁性物品' WithBatteryName UNION ALL

select top 0 315 WithBatteryValue, '电池+带磁属性' WithBatteryName UNION ALL

select top 0 316 WithBatteryValue, '假的' WithBatteryName UNION ALL

select top 0 317 WithBatteryValue, '普通服装' WithBatteryName UNION ALL

select top 0 318 WithBatteryValue, 'test111' WithBatteryName UNION ALL

select top 0 319 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL

select top 0 320 WithBatteryValue, 'NS-含酒精' WithBatteryName UNION ALL

select top 0 321 WithBatteryValue, 'NS-防疫用品' WithBatteryName UNION ALL

select top 0 322 WithBatteryValue, 'NS-香水' WithBatteryName UNION ALL

select top 0 323 WithBatteryValue, 'NS-眼镜' WithBatteryName UNION ALL

select top 0 324 WithBatteryValue, 'NS-打火机' WithBatteryName UNION ALL

select top 0 325 WithBatteryValue, 'NS-厨具' WithBatteryName UNION ALL

select top 0 326 WithBatteryValue, 'NS-植物种子' WithBatteryName UNION ALL

select top 0 327 WithBatteryValue, '食品' WithBatteryName UNION ALL

select top 0 328 WithBatteryValue, 'NS-动物羽毛类' WithBatteryName UNION ALL

select top 0 329 WithBatteryValue, 'NS-易碎' WithBatteryName UNION ALL

select top 0 330 WithBatteryValue, 'NS-原木_木质类_竹质类' WithBatteryName UNION ALL

select top 0 331 WithBatteryValue, 'NS-膏状' WithBatteryName UNION ALL

select top 0 332 WithBatteryValue, 'NS-液体' WithBatteryName UNION ALL

select top 0 333 WithBatteryValue, 'NS-其他禁运物品' WithBatteryName UNION ALL

select top 0 334 WithBatteryValue, 'NS-纯电池' WithBatteryName UNION ALL

select top 0 335 WithBatteryValue, 'NS-移动电源' WithBatteryName UNION ALL

select top 0 336 WithBatteryValue, 'NS-成人用品' WithBatteryName UNION ALL

select top 0 337 WithBatteryValue, 'NS-电机_马达' WithBatteryName UNION ALL

select top 0 338 WithBatteryValue, 'NS-带磁物品' WithBatteryName UNION ALL

select top 0 339 WithBatteryValue, 'NS-带外置电池' WithBatteryName UNION ALL

select top 0 340 WithBatteryValue, 'NS-带内置电池' WithBatteryName UNION ALL

select top 0 341 WithBatteryValue, 'NS-含纽扣电池' WithBatteryName UNION ALL

select top 0 342 WithBatteryValue, 'NS-手表' WithBatteryName UNION ALL

select top 0 343 WithBatteryValue, 'NS-纺织品' WithBatteryName UNION ALL

select top 0 344 WithBatteryValue, 'NS-圆柱体' WithBatteryName UNION ALL

select top 0 345 WithBatteryValue, 'NS-普货' WithBatteryName UNION ALL

select top 0 346 WithBatteryValue, '违禁品' WithBatteryName UNION ALL

select top 0 347 WithBatteryValue, '爆款' WithBatteryName UNION ALL

select top 0 348 WithBatteryValue, '测款' WithBatteryName UNION ALL

select top 0 349 WithBatteryValue, '测款' WithBatteryName UNION ALL

select top 0 350 WithBatteryValue, '带内置电池+液体' WithBatteryName UNION ALL

select top 0 351 WithBatteryValue, '精油1' WithBatteryName UNION ALL

select top 0 352 WithBatteryValue, '超长普货' WithBatteryName UNION ALL

select top 0 353 WithBatteryValue, '超长非普' WithBatteryName UNION ALL

select top 0 354 WithBatteryValue, '锂电池UN3481' WithBatteryName UNION ALL

select top 0 355 WithBatteryValue, '可充电干电池A199' WithBatteryName UNION ALL

select top 0 356 WithBatteryValue, '不可充电干电池A123' WithBatteryName UNION ALL

select top 0 357 WithBatteryValue, '抛货' WithBatteryName UNION ALL

select top 0 358 WithBatteryValue, '测试自定义物流属性0426-11' WithBatteryName UNION ALL

select top 0 359 WithBatteryValue, '测试自定义物流属性' WithBatteryName UNION ALL

select top 0 360 WithBatteryValue, '木质类_竹质类抛货' WithBatteryName UNION ALL

select top 0 361 WithBatteryValue, '蓝牙头盔' WithBatteryName UNION ALL

select top 0 362 WithBatteryValue, '气雾产品' WithBatteryName UNION ALL

select top 0 363 WithBatteryValue, '指甲油产品' WithBatteryName UNION ALL

select top 0 364 WithBatteryValue, '刺激气味产品' WithBatteryName UNION ALL

select top 0 365 WithBatteryValue, '易燃易爆品' WithBatteryName UNION ALL

select top 0 366 WithBatteryValue, '特殊尖锐器具' WithBatteryName UNION ALL

select top 0 367 WithBatteryValue, '管制刀具' WithBatteryName UNION ALL

select top 0 368 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL

select top 0 369 WithBatteryValue, '洗手液' WithBatteryName UNION ALL

select top 0 370 WithBatteryValue, '食品' WithBatteryName UNION ALL

select top 0 371 WithBatteryValue, '儿童玩具' WithBatteryName UNION ALL

select top 0 372 WithBatteryValue, 'HDMI产品' WithBatteryName UNION ALL

select top 0 373 WithBatteryValue, 'FDA产品' WithBatteryName UNION ALL

select top 0 374 WithBatteryValue, '蓝牙产品' WithBatteryName UNION ALL

select top 0 375 WithBatteryValue, '无电池' WithBatteryName UNION ALL

select top 0 376 WithBatteryValue, '带电成人用品' WithBatteryName UNION ALL

select top 0 377 WithBatteryValue, '无电成人用品' WithBatteryName UNION ALL

select top 0 378 WithBatteryValue, '易燃' WithBatteryName UNION ALL

select top 0 379 WithBatteryValue, '带金属器件' WithBatteryName UNION ALL

select top 0 380 WithBatteryValue, '锐器' WithBatteryName UNION ALL

select top 0 381 WithBatteryValue, '万邑联KY仓' WithBatteryName UNION ALL

select top 0 382 WithBatteryValue, '食品接触类（易碎）' WithBatteryName UNION ALL

select top 0 383 WithBatteryValue, '食品接触类（木质）' WithBatteryName UNION ALL

select top 0 384 WithBatteryValue, '食品接触类（带电）' WithBatteryName UNION ALL

select top 0 385 WithBatteryValue, '配套电池' WithBatteryName UNION ALL

select top 0 386 WithBatteryValue, '内置电池（查验）' WithBatteryName UNION ALL

select top 0 387 WithBatteryValue, '内置电池（人体接触）' WithBatteryName UNION ALL

select top 0 388 WithBatteryValue, '外置电池（查验）' WithBatteryName UNION ALL

select top 0 389 WithBatteryValue, '纽扣电池（查验）' WithBatteryName UNION ALL

select top 0 390 WithBatteryValue, '弱磁' WithBatteryName UNION ALL

select top 0 391 WithBatteryValue, '弱磁（查验）' WithBatteryName UNION ALL

select top 0 392 WithBatteryValue, '强磁' WithBatteryName UNION ALL

select top 0 393 WithBatteryValue, '普通刀具_剪刀' WithBatteryName UNION ALL

select top 0 394 WithBatteryValue, '户外刀具' WithBatteryName UNION ALL

select top 0 395 WithBatteryValue, '仿真枪' WithBatteryName UNION ALL

select top 0 396 WithBatteryValue, '医疗用品' WithBatteryName UNION ALL

select top 0 397 WithBatteryValue, '酒精类' WithBatteryName UNION ALL

select top 0 398 WithBatteryValue, '玩具' WithBatteryName UNION ALL

select top 0 399 WithBatteryValue, '玩具（查验）' WithBatteryName UNION ALL

select top 0 400 WithBatteryValue, '植物类' WithBatteryName UNION ALL

select top 0 401 WithBatteryValue, '种子类' WithBatteryName UNION ALL

select top 0 402 WithBatteryValue, '按摩类' WithBatteryName UNION ALL

select top 0 403 WithBatteryValue, '普货（人体接触）' WithBatteryName UNION ALL

select top 0 404 WithBatteryValue, '查验' WithBatteryName UNION ALL

select top 0 405 WithBatteryValue, '印泥' WithBatteryName UNION ALL

select top 0 406 WithBatteryValue, '一次性塑料用品' WithBatteryName UNION ALL

select top 0 407 WithBatteryValue, '解压球' WithBatteryName UNION ALL

select top 0 408 WithBatteryValue, '成人用品带电' WithBatteryName UNION ALL

select top 0 409 WithBatteryValue, '面膜' WithBatteryName UNION ALL

select top 0 410 WithBatteryValue, '药膏' WithBatteryName UNION ALL

select top 0 411 WithBatteryValue, '深圳粉末液体' WithBatteryName UNION ALL

select top 0 412 WithBatteryValue, '深圳带电' WithBatteryName UNION ALL

select top 0 413 WithBatteryValue, '灰色产品' WithBatteryName UNION ALL

select top 0 414 WithBatteryValue, '牙套' WithBatteryName UNION ALL

select top 0 415 WithBatteryValue, '1231231' WithBatteryName UNION ALL

select top 0 416 WithBatteryValue, '食品接触（竹质）' WithBatteryName UNION ALL

select top 0 417 WithBatteryValue, '化妆品类液体粉末膏体' WithBatteryName UNION ALL

select top 0 418 WithBatteryValue, '打火机-敏感货' WithBatteryName UNION ALL

select top 0 419 WithBatteryValue, '普货-敏感货' WithBatteryName UNION ALL

select top 0 420 WithBatteryValue, '带内置电池-敏感货' WithBatteryName UNION ALL

select top 0 421 WithBatteryValue, '带内置电池-高货值' WithBatteryName UNION ALL

select top 0 422 WithBatteryValue, '智能手环' WithBatteryName UNION ALL

select top 0 423 WithBatteryValue, '液体-敏感货' WithBatteryName UNION ALL

select top 0 424 WithBatteryValue, '假睫毛' WithBatteryName UNION ALL

select top 0 425 WithBatteryValue, '太阳能充电宝' WithBatteryName UNION ALL

select top 0 426 WithBatteryValue, '带内置电池-敏感货' WithBatteryName UNION ALL

select top 0 427 WithBatteryValue, '普货-敏感货' WithBatteryName UNION ALL

select top 0 428 WithBatteryValue, '粉末-敏感货' WithBatteryName UNION ALL

select top 0 429 WithBatteryValue, '特殊属性' WithBatteryName UNION ALL

select top 0 430 WithBatteryValue, '带电容' WithBatteryName UNION ALL

select top 0 431 WithBatteryValue, '陈冠希A货' WithBatteryName UNION ALL

select top 0 432 WithBatteryValue, '包裹长度超60CM' WithBatteryName UNION ALL

select top 0 433 WithBatteryValue, '强磁' WithBatteryName UNION ALL

select top 0 434 WithBatteryValue, '111' WithBatteryName UNION ALL

select top 0 435 WithBatteryValue, 'AAAAAA' WithBatteryName UNION ALL

select top 0 436 WithBatteryValue, '强磁' WithBatteryName UNION ALL

select top 0 437 WithBatteryValue, '敏感货' WithBatteryName UNION ALL

select top 0 438 WithBatteryValue, '糖果超甜' WithBatteryName UNION ALL

select top 0 439 WithBatteryValue, '食品接触（宠物餐具）' WithBatteryName UNION ALL

select top 0 440 WithBatteryValue, '强磁' WithBatteryName UNION ALL

select top 0 441 WithBatteryValue, '弱磁' WithBatteryName UNION ALL

select top 0 442 WithBatteryValue, '超体积普（6000抛比小于2倍）' WithBatteryName UNION ALL

select top 0 443 WithBatteryValue, '弱磁产品' WithBatteryName UNION ALL

select top 0 444 WithBatteryValue, '气雾' WithBatteryName UNION ALL

select top 0 445 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL

select top 0 446 WithBatteryValue, '违禁品' WithBatteryName UNION ALL

select top 0 447 WithBatteryValue, '马达' WithBatteryName UNION ALL

select top 0 448 WithBatteryValue, '普通颗粒类' WithBatteryName UNION ALL

select top 0 449 WithBatteryValue, '带外置电池-敏感货' WithBatteryName UNION ALL

select top 0 450 WithBatteryValue, '带外置电池-敏感货' WithBatteryName UNION ALL

select top 0 451 WithBatteryValue, '成人用品（带电）' WithBatteryName UNION ALL

select top 0 452 WithBatteryValue, '化妆品' WithBatteryName UNION ALL

select top 0 453 WithBatteryValue, '新人-钢铁侠' WithBatteryName UNION ALL

select top 0 454 WithBatteryValue, '陶瓷' WithBatteryName UNION ALL

select top 0 455 WithBatteryValue, '带电带磁带电机' WithBatteryName UNION ALL

select top 0 456 WithBatteryValue, '仿牌' WithBatteryName UNION ALL

select top 0 457 WithBatteryValue, '激光笔' WithBatteryName UNION ALL

select top 0 458 WithBatteryValue, '带电蓝牙产品' WithBatteryName UNION ALL

select top 0 459 WithBatteryValue, '平板电脑' WithBatteryName UNION ALL

select top 0 460 WithBatteryValue, '头盔' WithBatteryName UNION ALL

select top 0 461 WithBatteryValue, '食品' WithBatteryName UNION ALL

select top 0 462 WithBatteryValue, '药品' WithBatteryName UNION ALL

select top 0 463 WithBatteryValue, '剪刀' WithBatteryName UNION ALL

select top 0 464 WithBatteryValue, '活性炭' WithBatteryName UNION ALL

select top 0 465 WithBatteryValue, '带刀产品' WithBatteryName UNION ALL

select top 0 466 WithBatteryValue, '水滤器（带碳粉）' WithBatteryName UNION ALL

select top 0 467 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL

select top 0 468 WithBatteryValue, '带电带磁带木材' WithBatteryName UNION ALL

select top 0 469 WithBatteryValue, '纽扣电池（内置）' WithBatteryName UNION ALL

select top 0 470 WithBatteryValue, '纽扣电池（外置）' WithBatteryName UNION ALL

select top 0 471 WithBatteryValue, '纽扣电池（纯电池）' WithBatteryName UNION ALL

select top 0 472 WithBatteryValue, '锂电池（内置）' WithBatteryName UNION ALL

select top 0 473 WithBatteryValue, '锂电池（外置）' WithBatteryName UNION ALL

select top 0 474 WithBatteryValue, '锂电池（纯电池）' WithBatteryName UNION ALL

select top 0 475 WithBatteryValue, '干电池（内置）' WithBatteryName UNION ALL

select top 0 476 WithBatteryValue, '干电池（外置）' WithBatteryName UNION ALL

select top 0 477 WithBatteryValue, '干电池（纯电池）' WithBatteryName UNION ALL

select top 0 478 WithBatteryValue, '镍氢电池（内置）' WithBatteryName UNION ALL

select top 0 479 WithBatteryValue, '镍氢电池（外置）' WithBatteryName UNION ALL

select top 0 480 WithBatteryValue, '镍氢电池（纯电池）' WithBatteryName UNION ALL

select top 0 481 WithBatteryValue, '成人用品（带电）' WithBatteryName

) a

select top 0 w.WareHouseName AS '仓库',

pr.ListNo AS '销单号',

pr.SKU AS 'SKU',

p.ProductNameCN AS '中文名',

CASE pl.IsUrgent WHEN 1 THEN '是' WHEN 0 THEN '否' END AS '是否加急',

CASE pl.IsSample WHEN 1 THEN '是' WHEN 0 THEN '否' END AS '是否样品',

CASE pr.NeedToPackType

WHEN 0 THEN '不需打包'

WHEN 1 THEN '需供应商打包'

WHEN 2 THEN '加工打包'

WHEN 3 THEN '销单打包'

ELSE ''

END AS '打包状态'

prd.ActualBuyNum AS '销单数量',

prd.ProcessNum AS '加工数量',

prd.BadNum AS '不良品',

prd.TallyNum AS '理货数量',

prd.PutInNum AS '入库数量',

t.WithBatteryName AS '物流属性',

CASE prd.TaskState

WHEN 0 THEN '待质检'

WHEN 1 THEN '待入库'

WHEN 2 THEN '部分入库'

WHEN 3 THEN '已完成'

ELSE ''

END AS '任务状态',

pr.ReceiptUserNmae AS '收货人',

pr.ReceiptTime AS '收货时间',

prc.PrepareBuyUserName AS '预销单人',

prc.PrepareBuyTime AS '预销单时间',

prd.BuyUserName AS '销单人',

prd.BuyTime AS '销单时间',

prd.ProcessUserName AS '加工人',

prd.ProcessTime AS '加工时间',

prd.CheckUserName AS '质检人',

prd.CheckTime AS '质检时间',

prd.TallyUserName AS '理货人',

prd.TallyTime AS '理货时间',

prd.PutInUserName AS '入库人',

prd.PutInTime AS '入库时间'

FROM dbo.RB_Procurement_ReceiptAndStorage (NOLOCK) pr

LEFT JOIN dbo.RB_Warehouse(NOLOCK) w ON pr.WarehouseId=w.ID AND pr.CustomerId=w.CustomerID

LEFT JOIN dbo.RB_Product (NOLOCK) p ON pr.SKU=p.SKU AND pr.CustomerId=p.CustomerID

LEFT JOIN dbo.RB_Procurement_ReceiptAndStorage_Details (NOLOCK)prd ON prd.ReceiptAndStorageId=pr.ID AND prd.CustomerId=pr.CustomerId

LEFT JOIN dbo.RB_Procurement_ReceiptAndStorage_CourierNum (NOLOCK)prc ON prc.CourierNum=pr.CourierNum AND prc.CustomerID=pr.CustomerId

LEFT JOIN dbo.RB_Procurement_List (NOLOCK) pl ON pl.P_Code=pr.P_Code AND pl.CustomerID=pr.CustomerId

LEFT JOIN #temp_WithBattery t ON t.WithBatteryValue=p.WithBattery

WHERE prc.PrepareBuyTime>=@StartDate AND prc.PrepareBuyTime<=@EndDate AND pr.CustomerId=@CustomerId

PARAMS:@StartDate = null ,@EndDate = null ,@CustomerId = 0 ,

MESSAGE:Incorrect syntax near 'prd'.

TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)

在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()

在 System.Data.SqlClient.SqlDataReader.get_MetaData()

在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)

在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DALExtend.RB_CustomReportExtend.GetSheetFieldsDr(String sqlContent, List1 sqlParameters)

在 Biz.Irobotbox.ReportCentre.CustomReportService.CheckSqlAndGetFields(String sqlContent, List`1 paramList)

在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.CheckSqlAndGetFields()

在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.Page_Load(Object sender, EventArgs e)

在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

在 System.Web.UI.Control.OnLoad(EventArgs e)

在 System.Web.UI.Control.LoadRecursive()

在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

在 System.Web.UI.Page.ProcessRequest()

在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)

在 System.Web.UI.Page.ProcessRequest(HttpContext context)

在 ASP.irobotbox_reportcentre_customreportedit_aspx.ProcessRequest(HttpContext context)

在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)

在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)

在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)

在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)

在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

历史记录

2023-10-20 15:05:35, 由 吴高发 创建。
2023-10-20 15:06:29, 由 李乐同 指派给程伟。
修改了 指派给，旧值为 "liletong"，新值为 "chengwei"。
2023-10-20 15:54:40, 由程伟指派给 谢业福。
修改了 指派给，旧值为 "chengwei"，新值为 "xieyefu"。
2023-10-20 16:36:29, 由 谢业福 编辑。
修改了 影响环境，旧值为 "577,"，新值为 "577"。
修改了 重现步骤，区别为：
001-
001+
002- ~~prometheus告警~~
002+ prometheus告警
011- ~~Error:15_102_1_-2146232060~~
011+ Error:15_102_1_-2146232060
012- ~~SQL:--物流属性表~~
012+ SQL:--物流属性表
013- ~~DROP TABLE IF EXISTS #temp_WithBattery~~
013+ DROP TABLE IF EXISTS #temp_WithBattery
014- select top 0 a.*
014+ select top 0 a.*
015- ~~INTO #temp_WithBattery~~
015+ INTO #temp_WithBattery
016- ~~FROM(~~
016+ FROM(
017- ~~select top 0 1 WithBatteryValue, '普货' WithBatteryName UNION ALL~~
017+ select top 0 1 WithBatteryValue, '普货' WithBatteryName UNION ALL
018- ~~select top 0 2 WithBatteryValue, '纯电池' WithBatteryName UNION ALL~~
018+ select top 0 2 WithBatteryValue, '纯电池' WithBatteryName UNION ALL
019- ~~select top 0 3 WithBatteryValue, '带内置电池' WithBatteryName UNION ALL~~
019+ select top 0 3 WithBatteryValue, '带内置电池' WithBatteryName UNION ALL
020- ~~select top 0 4 WithBatteryValue, '带外置电池' WithBatteryName UNION ALL~~
020+ select top 0 4 WithBatteryValue, '带外置电池' WithBatteryName UNION ALL
021- ~~select top 0 5 WithBatteryValue, '含纽扣电池' WithBatteryName UNION ALL~~
021+ select top 0 5 WithBatteryValue, '含纽扣电池' WithBatteryName UNION ALL
022- ~~select top 0 6 WithBatteryValue, '液体' WithBatteryName UNION ALL~~
022+ select top 0 6 WithBatteryValue, '液体' WithBatteryName UNION ALL
023- ~~select top 0 7 WithBatteryValue, '粉末' WithBatteryName UNION ALL~~
023+ select top 0 7 WithBatteryValue, '粉末' WithBatteryName UNION ALL
024- ~~select top 0 8 WithBatteryValue, '打火机' WithBatteryName UNION ALL~~
024+ select top 0 8 WithBatteryValue, '打火机' WithBatteryName UNION ALL
025- ~~select top 0 9 WithBatteryValue, '刀具_剪刀_仿真枪' WithBatteryName UNION ALL~~
025+ select top 0 9 WithBatteryValue, '刀具_剪刀_仿真枪' WithBatteryName UNION ALL
026- ~~select top 0 10 WithBatteryValue, '带磁物品' WithBatteryName UNION ALL~~
026+ select top 0 10 WithBatteryValue, '带磁物品' WithBatteryName UNION ALL
027- ~~select top 0 12 WithBatteryValue, '木质类_竹质类' WithBatteryName UNION ALL~~
027+ select top 0 12 WithBatteryValue, '木质类_竹质类' WithBatteryName UNION ALL
028- ~~select top 0 11 WithBatteryValue, '其他禁运物品' WithBatteryName UNION ALL~~
028+ select top 0 11 WithBatteryValue, '其他禁运物品' WithBatteryName UNION ALL
029- ~~select top 0 13 WithBatteryValue, '膏状' WithBatteryName UNION ALL~~
029+ select top 0 13 WithBatteryValue, '膏状' WithBatteryName UNION ALL
030- ~~select top 0 14 WithBatteryValue, '易碎' WithBatteryName UNION ALL~~
030+ select top 0 14 WithBatteryValue, '易碎' WithBatteryName UNION ALL
031- ~~select top 0 15 WithBatteryValue, '动物羽毛类' WithBatteryName UNION ALL~~
031+ select top 0 15 WithBatteryValue, '动物羽毛类' WithBatteryName UNION ALL
032- ~~select top 0 16 WithBatteryValue, '大功率电池' WithBatteryName UNION ALL~~
032+ select top 0 16 WithBatteryValue, '大功率电池' WithBatteryName UNION ALL
033- ~~select top 0 17 WithBatteryValue, '电子烟' WithBatteryName UNION ALL~~
033+ select top 0 17 WithBatteryValue, '电子烟' WithBatteryName UNION ALL
034- ~~select top 0 18 WithBatteryValue, '移动电源' WithBatteryName UNION ALL~~
034+ select top 0 18 WithBatteryValue, '移动电源' WithBatteryName UNION ALL
035- ~~select top 0 19 WithBatteryValue, '可拆卸电池' WithBatteryName UNION ALL~~
035+ select top 0 19 WithBatteryValue, '可拆卸电池' WithBatteryName UNION ALL
036- ~~select top 0 20 WithBatteryValue, '厨具' WithBatteryName UNION ALL~~
036+ select top 0 20 WithBatteryValue, '厨具' WithBatteryName UNION ALL
037- ~~select top 0 21 WithBatteryValue, '电机_马达' WithBatteryName UNION ALL~~
037+ select top 0 21 WithBatteryValue, '电机_马达' WithBatteryName UNION ALL
038- ~~select top 0 22 WithBatteryValue, '超体积普' WithBatteryName UNION ALL~~
038+ select top 0 22 WithBatteryValue, '超体积普' WithBatteryName UNION ALL
039- ~~select top 0 23 WithBatteryValue, '超体积非普' WithBatteryName UNION ALL~~
039+ select top 0 23 WithBatteryValue, '超体积非普' WithBatteryName UNION ALL
040- ~~select top 0 24 WithBatteryValue, '手机' WithBatteryName UNION ALL~~
040+ select top 0 24 WithBatteryValue, '手机' WithBatteryName UNION ALL
041- ~~select top 0 25 WithBatteryValue, '平衡车' WithBatteryName UNION ALL~~
041+ select top 0 25 WithBatteryValue, '平衡车' WithBatteryName UNION ALL
042- ~~select top 0 26 WithBatteryValue, '液体笔类' WithBatteryName UNION ALL~~
042+ select top 0 26 WithBatteryValue, '液体笔类' WithBatteryName UNION ALL
043- ~~select top 0 27 WithBatteryValue, '纺织品' WithBatteryName UNION ALL~~
043+ select top 0 27 WithBatteryValue, '纺织品' WithBatteryName UNION ALL
044- ~~select top 0 28 WithBatteryValue, '植物种子' WithBatteryName UNION ALL~~
044+ select top 0 28 WithBatteryValue, '植物种子' WithBatteryName UNION ALL
045- ~~select top 0 29 WithBatteryValue, '深圳普货' WithBatteryName UNION ALL~~
045+ select top 0 29 WithBatteryValue, '深圳普货' WithBatteryName UNION ALL
046- ~~select top 0 30 WithBatteryValue, '成人用品' WithBatteryName UNION ALL~~
046+ select top 0 30 WithBatteryValue, '成人用品' WithBatteryName UNION ALL
047- ~~select top 0 31 WithBatteryValue, '无' WithBatteryName UNION ALL~~
047+ select top 0 31 WithBatteryValue, '无' WithBatteryName UNION ALL
048- ~~select top 0 32 WithBatteryValue, '眼镜' WithBatteryName UNION ALL~~
048+ select top 0 32 WithBatteryValue, '眼镜' WithBatteryName UNION ALL
049- ~~select top 0 33 WithBatteryValue, '口红' WithBatteryName UNION ALL~~
049+ select top 0 33 WithBatteryValue, '口红' WithBatteryName UNION ALL
050- ~~select top 0 34 WithBatteryValue, '手表' WithBatteryName UNION ALL~~
050+ select top 0 34 WithBatteryValue, '手表' WithBatteryName UNION ALL
051- ~~select top 0 35 WithBatteryValue, '香水' WithBatteryName UNION ALL~~
051+ select top 0 35 WithBatteryValue, '香水' WithBatteryName UNION ALL
052- ~~select top 0 36 WithBatteryValue, '纯液体' WithBatteryName UNION ALL~~
052+ select top 0 36 WithBatteryValue, '纯液体' WithBatteryName UNION ALL
053- ~~select top 0 37 WithBatteryValue, '医疗设备' WithBatteryName UNION ALL~~
053+ select top 0 37 WithBatteryValue, '医疗设备' WithBatteryName UNION ALL
054- ~~select top 0 38 WithBatteryValue, '人造羽毛' WithBatteryName UNION ALL~~
054+ select top 0 38 WithBatteryValue, '人造羽毛' WithBatteryName UNION ALL
055- ~~select top 0 39 WithBatteryValue, '内置锂金属电池' WithBatteryName UNION ALL~~
055+ select top 0 39 WithBatteryValue, '内置锂金属电池' WithBatteryName UNION ALL
056- ~~select top 0 40 WithBatteryValue, '配套干电池' WithBatteryName UNION ALL~~
056+ select top 0 40 WithBatteryValue, '配套干电池' WithBatteryName UNION ALL
057- ~~select top 0 41 WithBatteryValue, '厨房刀具' WithBatteryName UNION ALL~~
057+ select top 0 41 WithBatteryValue, '厨房刀具' WithBatteryName UNION ALL
058- ~~select top 0 42 WithBatteryValue, '军工刀具' WithBatteryName UNION ALL~~
058+ select top 0 42 WithBatteryValue, '军工刀具' WithBatteryName UNION ALL
059- ~~select top 0 45 WithBatteryValue, '无线充' WithBatteryName UNION ALL~~
059+ select top 0 45 WithBatteryValue, '无线充' WithBatteryName UNION ALL
060- ~~select top 0 46 WithBatteryValue, '原木' WithBatteryName UNION ALL~~
060+ select top 0 46 WithBatteryValue, '原木' WithBatteryName UNION ALL
061- ~~select top 0 47 WithBatteryValue, '面具类' WithBatteryName UNION ALL~~
061+ select top 0 47 WithBatteryValue, '面具类' WithBatteryName UNION ALL
062- ~~select top 0 48 WithBatteryValue, '金属高密度' WithBatteryName UNION ALL~~
062+ select top 0 48 WithBatteryValue, '金属高密度' WithBatteryName UNION ALL
063- ~~select top 0 49 WithBatteryValue, '防疫用品' WithBatteryName UNION ALL~~
063+ select top 0 49 WithBatteryValue, '防疫用品' WithBatteryName UNION ALL
064- ~~select top 0 50 WithBatteryValue, '酒精' WithBatteryName UNION ALL~~
064+ select top 0 50 WithBatteryValue, '酒精' WithBatteryName UNION ALL
065- ~~select top 0 51 WithBatteryValue, '酒精棉' WithBatteryName UNION ALL~~
065+ select top 0 51 WithBatteryValue, '酒精棉' WithBatteryName UNION ALL
066- ~~select top 0 52 WithBatteryValue, '纸巾' WithBatteryName UNION ALL~~
066+ select top 0 52 WithBatteryValue, '纸巾' WithBatteryName UNION ALL
067- ~~select top 0 100 WithBatteryValue, '风扇' WithBatteryName UNION ALL~~
067+ select top 0 100 WithBatteryValue, '风扇' WithBatteryName UNION ALL
068- ~~select top 0 0 WithBatteryValue, '未选择' WithBatteryName UNION ALL~~
068+ select top 0 0 WithBatteryValue, '未选择' WithBatteryName UNION ALL
069- ~~select top 0 101 WithBatteryValue, '水杯' WithBatteryName UNION ALL~~
069+ select top 0 101 WithBatteryValue, '水杯' WithBatteryName UNION ALL
070- ~~select top 0 102 WithBatteryValue, '测试' WithBatteryName UNION ALL~~
070+ select top 0 102 WithBatteryValue, '测试' WithBatteryName UNION ALL
071- ~~select top 0 103 WithBatteryValue, '面罩类' WithBatteryName UNION ALL~~
071+ select top 0 103 WithBatteryValue, '面罩类' WithBatteryName UNION ALL
072- ~~select top 0 104 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL~~
072+ select top 0 104 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL
073- ~~select top 0 105 WithBatteryValue, '食品' WithBatteryName UNION ALL~~
073+ select top 0 105 WithBatteryValue, '食品' WithBatteryName UNION ALL
074- ~~select top 0 106 WithBatteryValue, '颗粒状' WithBatteryName UNION ALL~~
074+ select top 0 106 WithBatteryValue, '颗粒状' WithBatteryName UNION ALL
075- ~~select top 0 107 WithBatteryValue, '药品' WithBatteryName UNION ALL~~
075+ select top 0 107 WithBatteryValue, '药品' WithBatteryName UNION ALL
076- ~~select top 0 108 WithBatteryValue, '头盔' WithBatteryName UNION ALL~~
076+ select top 0 108 WithBatteryValue, '头盔' WithBatteryName UNION ALL
077- ~~select top 0 109 WithBatteryValue, '纯普货' WithBatteryName UNION ALL~~
077+ select top 0 109 WithBatteryValue, '纯普货' WithBatteryName UNION ALL
078- ~~select top 0 110 WithBatteryValue, '尖锐利器' WithBatteryName UNION ALL~~
078+ select top 0 110 WithBatteryValue, '尖锐利器' WithBatteryName UNION ALL
079- ~~select top 0 111 WithBatteryValue, '无电池电子产品' WithBatteryName UNION ALL~~
079+ select top 0 111 WithBatteryValue, '无电池电子产品' WithBatteryName UNION ALL
080- ~~select top 0 112 WithBatteryValue, '内置纽扣电池' WithBatteryName UNION ALL~~
080+ select top 0 112 WithBatteryValue, '内置纽扣电池' WithBatteryName UNION ALL
081- ~~select top 0 113 WithBatteryValue, '内置柱状电池' WithBatteryName UNION ALL~~
081+ select top 0 113 WithBatteryValue, '内置柱状电池' WithBatteryName UNION ALL
082- ~~select top 0 114 WithBatteryValue, '内置块状电池' WithBatteryName UNION ALL~~
082+ select top 0 114 WithBatteryValue, '内置块状电池' WithBatteryName UNION ALL
083- ~~select top 0 115 WithBatteryValue, '其它内置电池' WithBatteryName UNION ALL~~
083+ select top 0 115 WithBatteryValue, '其它内置电池' WithBatteryName UNION ALL
084- ~~select top 0 116 WithBatteryValue, '配套纽扣电池' WithBatteryName UNION ALL~~
084+ select top 0 116 WithBatteryValue, '配套纽扣电池' WithBatteryName UNION ALL
085- ~~select top 0 117 WithBatteryValue, '配套柱状电池' WithBatteryName UNION ALL~~
085+ select top 0 117 WithBatteryValue, '配套柱状电池' WithBatteryName UNION ALL
086- ~~select top 0 118 WithBatteryValue, '配套块状电池' WithBatteryName UNION ALL~~
086+ select top 0 118 WithBatteryValue, '配套块状电池' WithBatteryName UNION ALL
087- ~~select top 0 119 WithBatteryValue, '其它配套电池' WithBatteryName UNION ALL~~
087+ select top 0 119 WithBatteryValue, '其它配套电池' WithBatteryName UNION ALL
088- ~~select top 0 120 WithBatteryValue, '纽扣电池' WithBatteryName UNION ALL~~
088+ select top 0 120 WithBatteryValue, '纽扣电池' WithBatteryName UNION ALL
089- ~~select top 0 121 WithBatteryValue, '柱状电池' WithBatteryName UNION ALL~~
089+ select top 0 121 WithBatteryValue, '柱状电池' WithBatteryName UNION ALL
090- ~~select top 0 122 WithBatteryValue, '块状电池' WithBatteryName UNION ALL~~
090+ select top 0 122 WithBatteryValue, '块状电池' WithBatteryName UNION ALL
091- ~~select top 0 123 WithBatteryValue, '其它纯电池' WithBatteryName UNION ALL~~
091+ select top 0 123 WithBatteryValue, '其它纯电池' WithBatteryName UNION ALL
092- ~~select top 0 124 WithBatteryValue, '易碎玻璃' WithBatteryName UNION ALL~~
092+ select top 0 124 WithBatteryValue, '易碎玻璃' WithBatteryName UNION ALL
093- ~~select top 0 125 WithBatteryValue, '强磁' WithBatteryName UNION ALL~~
093+ select top 0 125 WithBatteryValue, '强磁' WithBatteryName UNION ALL
094- ~~select top 0 126 WithBatteryValue, '微量膏体' WithBatteryName UNION ALL~~
094+ select top 0 126 WithBatteryValue, '微量膏体' WithBatteryName UNION ALL
095- ~~select top 0 127 WithBatteryValue, '其它膏体' WithBatteryName UNION ALL~~
095+ select top 0 127 WithBatteryValue, '其它膏体' WithBatteryName UNION ALL
096- ~~select top 0 128 WithBatteryValue, '微量粉末' WithBatteryName UNION ALL~~
096+ select top 0 128 WithBatteryValue, '微量粉末' WithBatteryName UNION ALL
097- ~~select top 0 129 WithBatteryValue, '其它粉末' WithBatteryName UNION ALL~~
097+ select top 0 129 WithBatteryValue, '其它粉末' WithBatteryName UNION ALL
098- ~~select top 0 130 WithBatteryValue, '微量液体' WithBatteryName UNION ALL~~
098+ select top 0 130 WithBatteryValue, '微量液体' WithBatteryName UNION ALL
099- ~~select top 0 131 WithBatteryValue, '少量液体' WithBatteryName UNION ALL~~
099+ select top 0 131 WithBatteryValue, '少量液体' WithBatteryName UNION ALL
100- ~~select top 0 132 WithBatteryValue, '较多液体' WithBatteryName UNION ALL~~
100+ select top 0 132 WithBatteryValue, '较多液体' WithBatteryName UNION ALL
101- ~~select top 0 133 WithBatteryValue, '其它液体' WithBatteryName UNION ALL~~
101+ select top 0 133 WithBatteryValue, '其它液体' WithBatteryName UNION ALL
102- ~~select top 0 134 WithBatteryValue, '办公刀具小尺寸' WithBatteryName UNION ALL~~
102+ select top 0 134 WithBatteryValue, '办公刀具小尺寸' WithBatteryName UNION ALL
103- ~~select top 0 135 WithBatteryValue, '办公刀具中尺寸' WithBatteryName UNION ALL~~
103+ select top 0 135 WithBatteryValue, '办公刀具中尺寸' WithBatteryName UNION ALL
104- ~~select top 0 136 WithBatteryValue, '办公刀具大尺寸' WithBatteryName UNION ALL~~
104+ select top 0 136 WithBatteryValue, '办公刀具大尺寸' WithBatteryName UNION ALL
105- ~~select top 0 137 WithBatteryValue, '厨房刀具小尺寸' WithBatteryName UNION ALL~~
105+ select top 0 137 WithBatteryValue, '厨房刀具小尺寸' WithBatteryName UNION ALL
106- ~~select top 0 138 WithBatteryValue, '厨房刀具中尺寸' WithBatteryName UNION ALL~~
106+ select top 0 138 WithBatteryValue, '厨房刀具中尺寸' WithBatteryName UNION ALL
107- ~~select top 0 139 WithBatteryValue, '厨房刀具大尺寸' WithBatteryName UNION ALL~~
107+ select top 0 139 WithBatteryValue, '厨房刀具大尺寸' WithBatteryName UNION ALL
108- ~~select top 0 140 WithBatteryValue, '户外刀具小尺寸' WithBatteryName UNION ALL~~
108+ select top 0 140 WithBatteryValue, '户外刀具小尺寸' WithBatteryName UNION ALL
109- ~~select top 0 141 WithBatteryValue, '户外刀具中尺寸' WithBatteryName UNION ALL~~
109+ select top 0 141 WithBatteryValue, '户外刀具中尺寸' WithBatteryName UNION ALL
110- ~~select top 0 142 WithBatteryValue, '户外刀具大尺寸' WithBatteryName UNION ALL~~
110+ select top 0 142 WithBatteryValue, '户外刀具大尺寸' WithBatteryName UNION ALL
111- ~~select top 0 143 WithBatteryValue, '间谍器材' WithBatteryName UNION ALL~~
111+ select top 0 143 WithBatteryValue, '间谍器材' WithBatteryName UNION ALL
112- ~~select top 0 144 WithBatteryValue, '其它易燃易爆' WithBatteryName UNION ALL~~
112+ select top 0 144 WithBatteryValue, '其它易燃易爆' WithBatteryName UNION ALL
113- ~~select top 0 145 WithBatteryValue, '管制刀具小尺寸' WithBatteryName UNION ALL~~
113+ select top 0 145 WithBatteryValue, '管制刀具小尺寸' WithBatteryName UNION ALL
114- ~~select top 0 146 WithBatteryValue, '其它管制器具' WithBatteryName UNION ALL~~
114+ select top 0 146 WithBatteryValue, '其它管制器具' WithBatteryName UNION ALL
115- ~~select top 0 147 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL~~
115+ select top 0 147 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL
116- ~~select top 0 148 WithBatteryValue, '其它禁寄物品' WithBatteryName UNION ALL~~
116+ select top 0 148 WithBatteryValue, '其它禁寄物品' WithBatteryName UNION ALL
117- ~~select top 0 149 WithBatteryValue, '111' WithBatteryName UNION ALL~~
117+ select top 0 149 WithBatteryValue, '111' WithBatteryName UNION ALL
118- ~~select top 0 150 WithBatteryValue, '其它泛普货' WithBatteryName UNION ALL~~
118+ select top 0 150 WithBatteryValue, '其它泛普货' WithBatteryName UNION ALL
119- ~~select top 0 151 WithBatteryValue, '虎指' WithBatteryName UNION ALL~~
119+ select top 0 151 WithBatteryValue, '虎指' WithBatteryName UNION ALL
120- ~~select top 0 152 WithBatteryValue, '甩棍' WithBatteryName UNION ALL~~
120+ select top 0 152 WithBatteryValue, '甩棍' WithBatteryName UNION ALL
121- ~~select top 0 153 WithBatteryValue, '弓弩' WithBatteryName UNION ALL~~
121+ select top 0 153 WithBatteryValue, '弓弩' WithBatteryName UNION ALL
122- ~~select top 0 154 WithBatteryValue, '金属大体积' WithBatteryName UNION ALL~~
122+ select top 0 154 WithBatteryValue, '金属大体积' WithBatteryName UNION ALL
123- ~~select top 0 155 WithBatteryValue, '迷你蓝牙耳机' WithBatteryName UNION ALL~~
123+ select top 0 155 WithBatteryValue, '迷你蓝牙耳机' WithBatteryName UNION ALL
124- ~~select top 0 156 WithBatteryValue, '其它蓝牙耳机' WithBatteryName UNION ALL~~
124+ select top 0 156 WithBatteryValue, '其它蓝牙耳机' WithBatteryName UNION ALL
125- ~~select top 0 157 WithBatteryValue, '迷你蓝牙音响' WithBatteryName UNION ALL~~
125+ select top 0 157 WithBatteryValue, '迷你蓝牙音响' WithBatteryName UNION ALL
126- ~~select top 0 158 WithBatteryValue, '其它蓝牙音响' WithBatteryName UNION ALL~~
126+ select top 0 158 WithBatteryValue, '其它蓝牙音响' WithBatteryName UNION ALL
127- ~~select top 0 159 WithBatteryValue, '迷你移动电源' WithBatteryName UNION ALL~~
127+ select top 0 159 WithBatteryValue, '迷你移动电源' WithBatteryName UNION ALL
128- ~~select top 0 160 WithBatteryValue, '其它移动电源' WithBatteryName UNION ALL~~
128+ select top 0 160 WithBatteryValue, '其它移动电源' WithBatteryName UNION ALL
129- ~~select top 0 161 WithBatteryValue, '其它带磁带电' WithBatteryName UNION ALL~~
129+ select top 0 161 WithBatteryValue, '其它带磁带电' WithBatteryName UNION ALL
130- ~~select top 0 162 WithBatteryValue, '微量固体' WithBatteryName UNION ALL~~
130+ select top 0 162 WithBatteryValue, '微量固体' WithBatteryName UNION ALL
131- ~~select top 0 163 WithBatteryValue, '其它固体' WithBatteryName UNION ALL~~
131+ select top 0 163 WithBatteryValue, '其它固体' WithBatteryName UNION ALL
132- ~~select top 0 164 WithBatteryValue, '打火石' WithBatteryName UNION ALL~~
132+ select top 0 164 WithBatteryValue, '打火石' WithBatteryName UNION ALL
133- ~~select top 0 165 WithBatteryValue, '指甲油' WithBatteryName UNION ALL~~
133+ select top 0 165 WithBatteryValue, '指甲油' WithBatteryName UNION ALL
134- ~~select top 0 166 WithBatteryValue, '香水' WithBatteryName UNION ALL~~
134+ select top 0 166 WithBatteryValue, '香水' WithBatteryName UNION ALL
135- ~~select top 0 167 WithBatteryValue, '管制刀具中尺寸' WithBatteryName UNION ALL~~
135+ select top 0 167 WithBatteryValue, '管制刀具中尺寸' WithBatteryName UNION ALL
136- ~~select top 0 168 WithBatteryValue, '管制刀具大尺寸' WithBatteryName UNION ALL~~
136+ select top 0 168 WithBatteryValue, '管制刀具大尺寸' WithBatteryName UNION ALL
137- ~~select top 0 169 WithBatteryValue, '微量胶体' WithBatteryName UNION ALL~~
137+ select top 0 169 WithBatteryValue, '微量胶体' WithBatteryName UNION ALL
138- ~~select top 0 170 WithBatteryValue, '' WithBatteryName UNION ALL~~
138+ select top 0 170 WithBatteryValue, '' WithBatteryName UNION ALL
139- ~~select top 0 171 WithBatteryValue, '较多胶体' WithBatteryName UNION ALL~~
139+ select top 0 171 WithBatteryValue, '较多胶体' WithBatteryName UNION ALL
140- ~~select top 0 172 WithBatteryValue, '其它胶体' WithBatteryName UNION ALL~~
140+ select top 0 172 WithBatteryValue, '其它胶体' WithBatteryName UNION ALL
141- ~~select top 0 173 WithBatteryValue, '哈哈哈哈' WithBatteryName UNION ALL~~
141+ select top 0 173 WithBatteryValue, '哈哈哈哈' WithBatteryName UNION ALL
142- ~~select top 0 174 WithBatteryValue, '口罩' WithBatteryName UNION ALL~~
142+ select top 0 174 WithBatteryValue, '口罩' WithBatteryName UNION ALL
143- ~~select top 0 175 WithBatteryValue, '李英' WithBatteryName UNION ALL~~
143+ select top 0 175 WithBatteryValue, '李英' WithBatteryName UNION ALL
144- ~~select top 0 176 WithBatteryValue, '蜡烛' WithBatteryName UNION ALL~~
144+ select top 0 176 WithBatteryValue, '蜡烛' WithBatteryName UNION ALL
145- ~~select top 0 177 WithBatteryValue, '剪刀' WithBatteryName UNION ALL~~
145+ select top 0 177 WithBatteryValue, '剪刀' WithBatteryName UNION ALL
146- ~~select top 0 178 WithBatteryValue, '单边超过40cm抛货带磁' WithBatteryName UNION ALL~~
146+ select top 0 178 WithBatteryValue, '单边超过40cm抛货带磁' WithBatteryName UNION ALL
147- ~~select top 0 179 WithBatteryValue, '强磁' WithBatteryName UNION ALL~~
147+ select top 0 179 WithBatteryValue, '强磁' WithBatteryName UNION ALL
148- ~~select top 0 180 WithBatteryValue, '单边超过40cm抛货普货' WithBatteryName UNION ALL~~
148+ select top 0 180 WithBatteryValue, '单边超过40cm抛货普货' WithBatteryName UNION ALL
149- ~~select top 0 181 WithBatteryValue, '单边超过40cm抛货特货' WithBatteryName UNION ALL~~
149+ select top 0 181 WithBatteryValue, '单边超过40cm抛货特货' WithBatteryName UNION ALL
150- ~~select top 0 182 WithBatteryValue, '利器' WithBatteryName UNION ALL~~
150+ select top 0 182 WithBatteryValue, '利器' WithBatteryName UNION ALL
151- ~~select top 0 183 WithBatteryValue, '刀' WithBatteryName UNION ALL~~
151+ select top 0 183 WithBatteryValue, '刀' WithBatteryName UNION ALL
152- ~~select top 0 184 WithBatteryValue, '抛货特货' WithBatteryName UNION ALL~~
152+ select top 0 184 WithBatteryValue, '抛货特货' WithBatteryName UNION ALL
153- ~~select top 0 185 WithBatteryValue, '抛货普货' WithBatteryName UNION ALL~~
153+ select top 0 185 WithBatteryValue, '抛货普货' WithBatteryName UNION ALL
154- ~~select top 0 186 WithBatteryValue, '抛货带磁' WithBatteryName UNION ALL~~
154+ select top 0 186 WithBatteryValue, '抛货带磁' WithBatteryName UNION ALL
155- ~~select top 0 187 WithBatteryValue, '抛货纽扣电池' WithBatteryName UNION ALL~~
155+ select top 0 187 WithBatteryValue, '抛货纽扣电池' WithBatteryName UNION ALL
156- ~~select top 0 188 WithBatteryValue, '单边超过40cm抛货纽扣电池' WithBatteryName UNION ALL~~
156+ select top 0 188 WithBatteryValue, '单边超过40cm抛货纽扣电池' WithBatteryName UNION ALL
157- ~~select top 0 189 WithBatteryValue, '自定义-液体' WithBatteryName UNION ALL~~
157+ select top 0 189 WithBatteryValue, '自定义-液体' WithBatteryName UNION ALL
158- ~~select top 0 190 WithBatteryValue, '面膜鼻膜眼膜胸膜' WithBatteryName UNION ALL~~
158+ select top 0 190 WithBatteryValue, '面膜鼻膜眼膜胸膜' WithBatteryName UNION ALL
159- ~~select top 0 191 WithBatteryValue, '办公刀具超大尺寸' WithBatteryName UNION ALL~~
159+ select top 0 191 WithBatteryValue, '办公刀具超大尺寸' WithBatteryName UNION ALL
160- ~~select top 0 192 WithBatteryValue, '厨房刀具超大尺寸' WithBatteryName UNION ALL~~
160+ select top 0 192 WithBatteryValue, '厨房刀具超大尺寸' WithBatteryName UNION ALL
161- ~~select top 0 193 WithBatteryValue, '户外刀具超大尺寸' WithBatteryName UNION ALL~~
161+ select top 0 193 WithBatteryValue, '户外刀具超大尺寸' WithBatteryName UNION ALL
162- ~~select top 0 194 WithBatteryValue, '管制刀具超大尺寸' WithBatteryName UNION ALL~~
162+ select top 0 194 WithBatteryValue, '管制刀具超大尺寸' WithBatteryName UNION ALL
163- ~~select top 0 195 WithBatteryValue, '内电打火机' WithBatteryName UNION ALL~~
163+ select top 0 195 WithBatteryValue, '内电打火机' WithBatteryName UNION ALL
164- ~~select top 0 196 WithBatteryValue, '压电打火机' WithBatteryName UNION ALL~~
164+ select top 0 196 WithBatteryValue, '压电打火机' WithBatteryName UNION ALL
165- ~~select top 0 197 WithBatteryValue, '火石打火机' WithBatteryName UNION ALL~~
165+ select top 0 197 WithBatteryValue, '火石打火机' WithBatteryName UNION ALL
166- ~~select top 0 198 WithBatteryValue, '超重超大件普货' WithBatteryName UNION ALL~~
166+ select top 0 198 WithBatteryValue, '超重超大件普货' WithBatteryName UNION ALL
167- ~~select top 0 199 WithBatteryValue, '超重超大件非普货' WithBatteryName UNION ALL~~
167+ select top 0 199 WithBatteryValue, '超重超大件非普货' WithBatteryName UNION ALL
168- ~~select top 0 200 WithBatteryValue, '自定义-纯电池' WithBatteryName UNION ALL~~
168+ select top 0 200 WithBatteryValue, '自定义-纯电池' WithBatteryName UNION ALL
169- ~~select top 0 201 WithBatteryValue, '自定义-带外置电池' WithBatteryName UNION ALL~~
169+ select top 0 201 WithBatteryValue, '自定义-带外置电池' WithBatteryName UNION ALL
170- ~~select top 0 202 WithBatteryValue, '内置电池-自定义' WithBatteryName UNION ALL~~
170+ select top 0 202 WithBatteryValue, '内置电池-自定义' WithBatteryName UNION ALL
171- ~~select top 0 203 WithBatteryValue, '自定义-膏体' WithBatteryName UNION ALL~~
171+ select top 0 203 WithBatteryValue, '自定义-膏体' WithBatteryName UNION ALL
172- ~~select top 0 204 WithBatteryValue, '自定义-粉末' WithBatteryName UNION ALL~~
172+ select top 0 204 WithBatteryValue, '自定义-粉末' WithBatteryName UNION ALL
173- ~~select top 0 205 WithBatteryValue, '自定义-带磁' WithBatteryName UNION ALL~~
173+ select top 0 205 WithBatteryValue, '自定义-带磁' WithBatteryName UNION ALL
174- ~~select top 0 206 WithBatteryValue, '自定义-电机马达' WithBatteryName UNION ALL~~
174+ select top 0 206 WithBatteryValue, '自定义-电机马达' WithBatteryName UNION ALL
175- ~~select top 0 207 WithBatteryValue, '反倾销属性' WithBatteryName UNION ALL~~
175+ select top 0 207 WithBatteryValue, '反倾销属性' WithBatteryName UNION ALL
176- ~~select top 0 208 WithBatteryValue, '自主加工' WithBatteryName UNION ALL~~
176+ select top 0 208 WithBatteryValue, '自主加工' WithBatteryName UNION ALL
177- ~~select top 0 209 WithBatteryValue, '弱磁' WithBatteryName UNION ALL~~
177+ select top 0 209 WithBatteryValue, '弱磁' WithBatteryName UNION ALL
178- ~~select top 0 210 WithBatteryValue, '液体&带电' WithBatteryName UNION ALL~~
178+ select top 0 210 WithBatteryValue, '液体&带电' WithBatteryName UNION ALL
179- ~~select top 0 211 WithBatteryValue, '液体（不带电）' WithBatteryName UNION ALL~~
179+ select top 0 211 WithBatteryValue, '液体（不带电）' WithBatteryName UNION ALL
180- ~~select top 0 212 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL~~
180+ select top 0 212 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL
181- ~~select top 0 213 WithBatteryValue, '口红液体' WithBatteryName UNION ALL~~
181+ select top 0 213 WithBatteryValue, '口红液体' WithBatteryName UNION ALL
182- ~~select top 0 214 WithBatteryValue, '口红膏体' WithBatteryName UNION ALL~~
182+ select top 0 214 WithBatteryValue, '口红膏体' WithBatteryName UNION ALL
183- ~~select top 0 215 WithBatteryValue, '测试物流属性' WithBatteryName UNION ALL~~
183+ select top 0 215 WithBatteryValue, '测试物流属性' WithBatteryName UNION ALL
184- ~~select top 0 216 WithBatteryValue, '612' WithBatteryName UNION ALL~~
184+ select top 0 216 WithBatteryValue, '612' WithBatteryName UNION ALL
185- ~~select top 0 217 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL~~
185+ select top 0 217 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL
186- ~~select top 0 218 WithBatteryValue, '较多膏体' WithBatteryName UNION ALL~~
186+ select top 0 218 WithBatteryValue, '较多膏体' WithBatteryName UNION ALL
187- ~~select top 0 219 WithBatteryValue, '少量膏体' WithBatteryName UNION ALL~~
187+ select top 0 219 WithBatteryValue, '少量膏体' WithBatteryName UNION ALL
188- ~~select top 0 220 WithBatteryValue, '较多固体' WithBatteryName UNION ALL~~
188+ select top 0 220 WithBatteryValue, '较多固体' WithBatteryName UNION ALL
189- ~~select top 0 221 WithBatteryValue, '少量固体' WithBatteryName UNION ALL~~
189+ select top 0 221 WithBatteryValue, '少量固体' WithBatteryName UNION ALL
190- ~~select top 0 222 WithBatteryValue, '较多粉末' WithBatteryName UNION ALL~~
190+ select top 0 222 WithBatteryValue, '较多粉末' WithBatteryName UNION ALL
191- ~~select top 0 223 WithBatteryValue, '少量粉末' WithBatteryName UNION ALL~~
191+ select top 0 223 WithBatteryValue, '少量粉末' WithBatteryName UNION ALL
192- ~~select top 0 224 WithBatteryValue, '机械手表' WithBatteryName UNION ALL~~
192+ select top 0 224 WithBatteryValue, '机械手表' WithBatteryName UNION ALL
193- ~~select top 0 225 WithBatteryValue, '电子手表' WithBatteryName UNION ALL~~
193+ select top 0 225 WithBatteryValue, '电子手表' WithBatteryName UNION ALL
194- ~~select top 0 226 WithBatteryValue, '智能手表' WithBatteryName UNION ALL~~
194+ select top 0 226 WithBatteryValue, '智能手表' WithBatteryName UNION ALL
195- ~~select top 0 227 WithBatteryValue, '智能手环' WithBatteryName UNION ALL~~
195+ select top 0 227 WithBatteryValue, '智能手环' WithBatteryName UNION ALL
196- ~~select top 0 228 WithBatteryValue, '饼状' WithBatteryName UNION ALL~~
196+ select top 0 228 WithBatteryValue, '饼状' WithBatteryName UNION ALL
197- ~~select top 0 229 WithBatteryValue, '干花' WithBatteryName UNION ALL~~
197+ select top 0 229 WithBatteryValue, '干花' WithBatteryName UNION ALL
198- ~~select top 0 230 WithBatteryValue, '枕头支架' WithBatteryName UNION ALL~~
198+ select top 0 230 WithBatteryValue, '枕头支架' WithBatteryName UNION ALL
199- ~~select top 0 231 WithBatteryValue, 'NS-超体积普' WithBatteryName UNION ALL~~
199+ select top 0 231 WithBatteryValue, 'NS-超体积普' WithBatteryName UNION ALL
200- ~~select top 0 232 WithBatteryValue, '抛物' WithBatteryName UNION ALL~~
200+ select top 0 232 WithBatteryValue, '抛物' WithBatteryName UNION ALL
201- ~~select top 0 233 WithBatteryValue, '口罩' WithBatteryName UNION ALL~~
201+ select top 0 233 WithBatteryValue, '口罩' WithBatteryName UNION ALL
202- ~~select top 0 234 WithBatteryValue, '哑铃（10KG+）' WithBatteryName UNION ALL~~
202+ select top 0 234 WithBatteryValue, '哑铃（10KG+）' WithBatteryName UNION ALL
203- ~~select top 0 235 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL~~
203+ select top 0 235 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL
204- ~~select top 0 236 WithBatteryValue, '蜡烛类' WithBatteryName UNION ALL~~
204+ select top 0 236 WithBatteryValue, '蜡烛类' WithBatteryName UNION ALL
205- ~~select top 0 237 WithBatteryValue, '无电池' WithBatteryName UNION ALL~~
205+ select top 0 237 WithBatteryValue, '无电池' WithBatteryName UNION ALL
206- ~~select top 0 238 WithBatteryValue, '轻抛类' WithBatteryName UNION ALL~~
206+ select top 0 238 WithBatteryValue, '轻抛类' WithBatteryName UNION ALL
207- ~~select top 0 239 WithBatteryValue, '高价值产品' WithBatteryName UNION ALL~~
207+ select top 0 239 WithBatteryValue, '高价值产品' WithBatteryName UNION ALL
208- ~~select top 0 240 WithBatteryValue, '蓝牙产品' WithBatteryName UNION ALL~~
208+ select top 0 240 WithBatteryValue, '蓝牙产品' WithBatteryName UNION ALL
209- ~~select top 0 241 WithBatteryValue, 'FDA产品' WithBatteryName UNION ALL~~
209+ select top 0 241 WithBatteryValue, 'FDA产品' WithBatteryName UNION ALL
210- ~~select top 0 242 WithBatteryValue, 'HDMI产品' WithBatteryName UNION ALL~~
210+ select top 0 242 WithBatteryValue, 'HDMI产品' WithBatteryName UNION ALL
211- ~~select top 0 243 WithBatteryValue, '儿童玩具' WithBatteryName UNION ALL~~
211+ select top 0 243 WithBatteryValue, '儿童玩具' WithBatteryName UNION ALL
212- ~~select top 0 244 WithBatteryValue, '磁铁' WithBatteryName UNION ALL~~
212+ select top 0 244 WithBatteryValue, '磁铁' WithBatteryName UNION ALL
213- ~~select top 0 245 WithBatteryValue, '木制品（无熏蒸）' WithBatteryName UNION ALL~~
213+ select top 0 245 WithBatteryValue, '木制品（无熏蒸）' WithBatteryName UNION ALL
214- ~~select top 0 246 WithBatteryValue, '特定磁性产品（含电机以及马达）' WithBatteryName UNION ALL~~
214+ select top 0 246 WithBatteryValue, '特定磁性产品（含电机以及马达）' WithBatteryName UNION ALL
215- ~~select top 0 247 WithBatteryValue, '食品' WithBatteryName UNION ALL~~
215+ select top 0 247 WithBatteryValue, '食品' WithBatteryName UNION ALL
216- ~~select top 0 248 WithBatteryValue, '口罩' WithBatteryName UNION ALL~~
216+ select top 0 248 WithBatteryValue, '口罩' WithBatteryName UNION ALL
217- ~~select top 0 249 WithBatteryValue, '洗手液' WithBatteryName UNION ALL~~
217+ select top 0 249 WithBatteryValue, '洗手液' WithBatteryName UNION ALL
218- ~~select top 0 250 WithBatteryValue, '温度计/额湿枪' WithBatteryName UNION ALL~~
218+ select top 0 250 WithBatteryValue, '温度计/额湿枪' WithBatteryName UNION ALL
219- ~~select top 0 251 WithBatteryValue, '医用手套/鞋套' WithBatteryName UNION ALL~~
219+ select top 0 251 WithBatteryValue, '医用手套/鞋套' WithBatteryName UNION ALL
220- ~~select top 0 252 WithBatteryValue, '护目镜' WithBatteryName UNION ALL~~
220+ select top 0 252 WithBatteryValue, '护目镜' WithBatteryName UNION ALL
221- ~~select top 0 253 WithBatteryValue, '防护服' WithBatteryName UNION ALL~~
221+ select top 0 253 WithBatteryValue, '防护服' WithBatteryName UNION ALL
222- ~~select top 0 254 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL~~
222+ select top 0 254 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL
223- ~~select top 0 255 WithBatteryValue, '管制刀具' WithBatteryName UNION ALL~~
223+ select top 0 255 WithBatteryValue, '管制刀具' WithBatteryName UNION ALL
224- ~~select top 0 256 WithBatteryValue, '特殊尖锐器具' WithBatteryName UNION ALL~~
224+ select top 0 256 WithBatteryValue, '特殊尖锐器具' WithBatteryName UNION ALL
225- ~~select top 0 257 WithBatteryValue, '易燃易爆品' WithBatteryName UNION ALL~~
225+ select top 0 257 WithBatteryValue, '易燃易爆品' WithBatteryName UNION ALL
226- ~~select top 0 258 WithBatteryValue, '刺激气味产品' WithBatteryName UNION ALL~~
226+ select top 0 258 WithBatteryValue, '刺激气味产品' WithBatteryName UNION ALL
227- ~~select top 0 259 WithBatteryValue, '指甲油产品' WithBatteryName UNION ALL~~
227+ select top 0 259 WithBatteryValue, '指甲油产品' WithBatteryName UNION ALL
228- ~~select top 0 260 WithBatteryValue, '气雾产品' WithBatteryName UNION ALL~~
228+ select top 0 260 WithBatteryValue, '气雾产品' WithBatteryName UNION ALL
229- ~~select top 0 261 WithBatteryValue, '枪支配件' WithBatteryName UNION ALL~~
229+ select top 0 261 WithBatteryValue, '枪支配件' WithBatteryName UNION ALL
230- ~~select top 0 262 WithBatteryValue, '带电，带磁' WithBatteryName UNION ALL~~
230+ select top 0 262 WithBatteryValue, '带电，带磁' WithBatteryName UNION ALL
231- ~~select top 0 263 WithBatteryValue, 'NS-刀具_剪刀' WithBatteryName UNION ALL~~
231+ select top 0 263 WithBatteryValue, 'NS-刀具_剪刀' WithBatteryName UNION ALL
232- ~~select top 0 264 WithBatteryValue, 'NS-粉末' WithBatteryName UNION ALL~~
232+ select top 0 264 WithBatteryValue, 'NS-粉末' WithBatteryName UNION ALL
233- ~~select top 0 265 WithBatteryValue, 'NS-超体积非普' WithBatteryName UNION ALL~~
233+ select top 0 265 WithBatteryValue, 'NS-超体积非普' WithBatteryName UNION ALL
234- ~~select top 0 266 WithBatteryValue, '黄毛' WithBatteryName UNION ALL~~
234+ select top 0 266 WithBatteryValue, '黄毛' WithBatteryName UNION ALL
235- ~~select top 0 267 WithBatteryValue, '黄毛3' WithBatteryName UNION ALL~~
235+ select top 0 267 WithBatteryValue, '黄毛3' WithBatteryName UNION ALL
236- ~~select top 0 268 WithBatteryValue, '食品接触类' WithBatteryName UNION ALL~~
236+ select top 0 268 WithBatteryValue, '食品接触类' WithBatteryName UNION ALL
237- ~~select top 0 269 WithBatteryValue, '带电成人用品' WithBatteryName UNION ALL~~
237+ select top 0 269 WithBatteryValue, '带电成人用品' WithBatteryName UNION ALL
238- ~~select top 0 270 WithBatteryValue, '无电成人用品' WithBatteryName UNION ALL~~
238+ select top 0 270 WithBatteryValue, '无电成人用品' WithBatteryName UNION ALL
239- ~~select top 0 271 WithBatteryValue, '活性炭' WithBatteryName UNION ALL~~
239+ select top 0 271 WithBatteryValue, '活性炭' WithBatteryName UNION ALL
240- ~~select top 0 272 WithBatteryValue, '纪念币' WithBatteryName UNION ALL~~
240+ select top 0 272 WithBatteryValue, '纪念币' WithBatteryName UNION ALL
241- ~~select top 0 273 WithBatteryValue, '颗粒物' WithBatteryName UNION ALL~~
241+ select top 0 273 WithBatteryValue, '颗粒物' WithBatteryName UNION ALL
242- ~~select top 0 274 WithBatteryValue, '测试' WithBatteryName UNION ALL~~
242+ select top 0 274 WithBatteryValue, '测试' WithBatteryName UNION ALL
243- ~~select top 0 275 WithBatteryValue, 'LED灯（不带电）' WithBatteryName UNION ALL~~
243+ select top 0 275 WithBatteryValue, 'LED灯（不带电）' WithBatteryName UNION ALL
244- ~~select top 0 276 WithBatteryValue, '仿枪支弹药' WithBatteryName UNION ALL~~
244+ select top 0 276 WithBatteryValue, '仿枪支弹药' WithBatteryName UNION ALL
245- ~~select top 0 277 WithBatteryValue, '打火石' WithBatteryName UNION ALL~~
245+ select top 0 277 WithBatteryValue, '打火石' WithBatteryName UNION ALL
246- ~~select top 0 278 WithBatteryValue, '气体' WithBatteryName UNION ALL~~
246+ select top 0 278 WithBatteryValue, '气体' WithBatteryName UNION ALL
247- ~~select top 0 279 WithBatteryValue, '1111' WithBatteryName UNION ALL~~
247+ select top 0 279 WithBatteryValue, '1111' WithBatteryName UNION ALL
248- ~~select top 0 280 WithBatteryValue, '1111' WithBatteryName UNION ALL~~
248+ select top 0 280 WithBatteryValue, '1111' WithBatteryName UNION ALL
249- ~~select top 0 281 WithBatteryValue, '555' WithBatteryName UNION ALL~~
249+ select top 0 281 WithBatteryValue, '555' WithBatteryName UNION ALL
250- ~~select top 0 282 WithBatteryValue, '武器' WithBatteryName UNION ALL~~
250+ select top 0 282 WithBatteryValue, '武器' WithBatteryName UNION ALL
251- ~~select top 0 283 WithBatteryValue, '上海普货' WithBatteryName UNION ALL~~
251+ select top 0 283 WithBatteryValue, '上海普货' WithBatteryName UNION ALL
252- ~~select top 0 284 WithBatteryValue, '沙子-敏感货' WithBatteryName UNION ALL~~
252+ select top 0 284 WithBatteryValue, '沙子-敏感货' WithBatteryName UNION ALL
253- ~~select top 0 285 WithBatteryValue, '敏感货' WithBatteryName UNION ALL~~
253+ select top 0 285 WithBatteryValue, '敏感货' WithBatteryName UNION ALL
254- ~~select top 0 286 WithBatteryValue, '违禁品' WithBatteryName UNION ALL~~
254+ select top 0 286 WithBatteryValue, '违禁品' WithBatteryName UNION ALL
255- ~~select top 0 287 WithBatteryValue, '普货物流灰' WithBatteryName UNION ALL~~
255+ select top 0 287 WithBatteryValue, '普货物流灰' WithBatteryName UNION ALL
256- ~~select top 0 288 WithBatteryValue, '带电物流灰' WithBatteryName UNION ALL~~
256+ select top 0 288 WithBatteryValue, '带电物流灰' WithBatteryName UNION ALL
257- ~~select top 0 289 WithBatteryValue, '你说是什么就是什么' WithBatteryName UNION ALL~~
257+ select top 0 289 WithBatteryValue, '你说是什么就是什么' WithBatteryName UNION ALL
258- ~~select top 0 290 WithBatteryValue, '打火石' WithBatteryName UNION ALL~~
258+ select top 0 290 WithBatteryValue, '打火石' WithBatteryName UNION ALL
259- ~~select top 0 291 WithBatteryValue, '干燥剂' WithBatteryName UNION ALL~~
259+ select top 0 291 WithBatteryValue, '干燥剂' WithBatteryName UNION ALL
260- ~~select top 0 292 WithBatteryValue, '硬币' WithBatteryName UNION ALL~~
260+ select top 0 292 WithBatteryValue, '硬币' WithBatteryName UNION ALL
261- ~~select top 0 293 WithBatteryValue, '测试' WithBatteryName UNION ALL~~
261+ select top 0 293 WithBatteryValue, '测试' WithBatteryName UNION ALL
262- ~~select top 0 294 WithBatteryValue, '内置电池+粉末' WithBatteryName UNION ALL~~
262+ select top 0 294 WithBatteryValue, '内置电池+粉末' WithBatteryName UNION ALL
263- ~~select top 0 295 WithBatteryValue, '迷彩' WithBatteryName UNION ALL~~
263+ select top 0 295 WithBatteryValue, '迷彩' WithBatteryName UNION ALL
264- ~~select top 0 296 WithBatteryValue, '电池类' WithBatteryName UNION ALL~~
264+ select top 0 296 WithBatteryValue, '电池类' WithBatteryName UNION ALL
265- ~~select top 0 297 WithBatteryValue, '形态类' WithBatteryName UNION ALL~~
265+ select top 0 297 WithBatteryValue, '形态类' WithBatteryName UNION ALL
266- ~~select top 0 298 WithBatteryValue, '违禁类' WithBatteryName UNION ALL~~
266+ select top 0 298 WithBatteryValue, '违禁类' WithBatteryName UNION ALL
267- ~~select top 0 299 WithBatteryValue, '特殊类' WithBatteryName UNION ALL~~
267+ select top 0 299 WithBatteryValue, '特殊类' WithBatteryName UNION ALL
268- ~~select top 0 300 WithBatteryValue, '基础类' WithBatteryName UNION ALL~~
268+ select top 0 300 WithBatteryValue, '基础类' WithBatteryName UNION ALL
269- ~~select top 0 301 WithBatteryValue, '温度计' WithBatteryName UNION ALL~~
269+ select top 0 301 WithBatteryValue, '温度计' WithBatteryName UNION ALL
270- ~~select top 0 302 WithBatteryValue, '骑行护目镜' WithBatteryName UNION ALL~~
270+ select top 0 302 WithBatteryValue, '骑行护目镜' WithBatteryName UNION ALL
271- ~~select top 0 303 WithBatteryValue, '户外面具和护目镜 ' WithBatteryName UNION ALL~~
271+ select top 0 303 WithBatteryValue, '户外面具和护目镜 ' WithBatteryName UNION ALL
272- ~~select top 0 304 WithBatteryValue, '护目镜' WithBatteryName UNION ALL~~
272+ select top 0 304 WithBatteryValue, '护目镜' WithBatteryName UNION ALL
273- ~~select top 0 305 WithBatteryValue, '超体积普（抛比小于3倍）' WithBatteryName UNION ALL~~
273+ select top 0 305 WithBatteryValue, '超体积普（抛比小于3倍）' WithBatteryName UNION ALL
274- ~~select top 0 306 WithBatteryValue, 'A-纯锂离子电池' WithBatteryName UNION ALL~~
274+ select top 0 306 WithBatteryValue, 'A-纯锂离子电池' WithBatteryName UNION ALL
275- ~~select top 0 307 WithBatteryValue, 'A-带油状' WithBatteryName UNION ALL~~
275+ select top 0 307 WithBatteryValue, 'A-带油状' WithBatteryName UNION ALL
276- ~~select top 0 308 WithBatteryValue, 'A-带胶状' WithBatteryName UNION ALL~~
276+ select top 0 308 WithBatteryValue, 'A-带胶状' WithBatteryName UNION ALL
277- ~~select top 0 309 WithBatteryValue, 'A-弱磁' WithBatteryName UNION ALL~~
277+ select top 0 309 WithBatteryValue, 'A-弱磁' WithBatteryName UNION ALL
278- ~~select top 0 310 WithBatteryValue, 'A-带易燃固体' WithBatteryName UNION ALL~~
278+ select top 0 310 WithBatteryValue, 'A-带易燃固体' WithBatteryName UNION ALL
279- ~~select top 0 311 WithBatteryValue, 'A-外形仿造' WithBatteryName UNION ALL~~
279+ select top 0 311 WithBatteryValue, 'A-外形仿造' WithBatteryName UNION ALL
280- ~~select top 0 312 WithBatteryValue, 'A-侵权' WithBatteryName UNION ALL~~
280+ select top 0 312 WithBatteryValue, 'A-侵权' WithBatteryName UNION ALL
281- ~~select top 0 313 WithBatteryValue, 'A-激光类' WithBatteryName UNION ALL~~
281+ select top 0 313 WithBatteryValue, 'A-激光类' WithBatteryName UNION ALL
282- ~~select top 0 314 WithBatteryValue, '内置电池+带磁性物品' WithBatteryName UNION ALL~~
282+ select top 0 314 WithBatteryValue, '内置电池+带磁性物品' WithBatteryName UNION ALL
283- ~~select top 0 315 WithBatteryValue, '电池+带磁属性' WithBatteryName UNION ALL~~
283+ select top 0 315 WithBatteryValue, '电池+带磁属性' WithBatteryName UNION ALL
284- ~~select top 0 316 WithBatteryValue, '假的' WithBatteryName UNION ALL~~
284+ select top 0 316 WithBatteryValue, '假的' WithBatteryName UNION ALL
285- ~~select top 0 317 WithBatteryValue, '普通服装' WithBatteryName UNION ALL~~
285+ select top 0 317 WithBatteryValue, '普通服装' WithBatteryName UNION ALL
286- ~~select top 0 318 WithBatteryValue, 'test111' WithBatteryName UNION ALL~~
286+ select top 0 318 WithBatteryValue, 'test111' WithBatteryName UNION ALL
287- ~~select top 0 319 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL~~
287+ select top 0 319 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL
288- ~~select top 0 320 WithBatteryValue, 'NS-含酒精' WithBatteryName UNION ALL~~
288+ select top 0 320 WithBatteryValue, 'NS-含酒精' WithBatteryName UNION ALL
289- ~~select top 0 321 WithBatteryValue, 'NS-防疫用品' WithBatteryName UNION ALL~~
289+ select top 0 321 WithBatteryValue, 'NS-防疫用品' WithBatteryName UNION ALL
290- ~~select top 0 322 WithBatteryValue, 'NS-香水' WithBatteryName UNION ALL~~
290+ select top 0 322 WithBatteryValue, 'NS-香水' WithBatteryName UNION ALL
291- ~~select top 0 323 WithBatteryValue, 'NS-眼镜' WithBatteryName UNION ALL~~
291+ select top 0 323 WithBatteryValue, 'NS-眼镜' WithBatteryName UNION ALL
292- ~~select top 0 324 WithBatteryValue, 'NS-打火机' WithBatteryName UNION ALL~~
292+ select top 0 324 WithBatteryValue, 'NS-打火机' WithBatteryName UNION ALL
293- ~~select top 0 325 WithBatteryValue, 'NS-厨具' WithBatteryName UNION ALL~~
293+ select top 0 325 WithBatteryValue, 'NS-厨具' WithBatteryName UNION ALL
294- ~~select top 0 326 WithBatteryValue, 'NS-植物种子' WithBatteryName UNION ALL~~
294+ select top 0 326 WithBatteryValue, 'NS-植物种子' WithBatteryName UNION ALL
295- ~~select top 0 327 WithBatteryValue, '食品' WithBatteryName UNION ALL~~
295+ select top 0 327 WithBatteryValue, '食品' WithBatteryName UNION ALL
296- ~~select top 0 328 WithBatteryValue, 'NS-动物羽毛类' WithBatteryName UNION ALL~~
296+ select top 0 328 WithBatteryValue, 'NS-动物羽毛类' WithBatteryName UNION ALL
297- ~~select top 0 329 WithBatteryValue, 'NS-易碎' WithBatteryName UNION ALL~~
297+ select top 0 329 WithBatteryValue, 'NS-易碎' WithBatteryName UNION ALL
298- ~~select top 0 330 WithBatteryValue, 'NS-原木_木质类_竹质类' WithBatteryName UNION ALL~~
298+ select top 0 330 WithBatteryValue, 'NS-原木_木质类_竹质类' WithBatteryName UNION ALL
299- ~~select top 0 331 WithBatteryValue, 'NS-膏状' WithBatteryName UNION ALL~~
299+ select top 0 331 WithBatteryValue, 'NS-膏状' WithBatteryName UNION ALL
300- ~~select top 0 332 WithBatteryValue, 'NS-液体' WithBatteryName UNION ALL~~
300+ select top 0 332 WithBatteryValue, 'NS-液体' WithBatteryName UNION ALL
301- ~~select top 0 333 WithBatteryValue, 'NS-其他禁运物品' WithBatteryName UNION ALL~~
301+ select top 0 333 WithBatteryValue, 'NS-其他禁运物品' WithBatteryName UNION ALL
302- ~~select top 0 334 WithBatteryValue, 'NS-纯电池' WithBatteryName UNION ALL~~
302+ select top 0 334 WithBatteryValue, 'NS-纯电池' WithBatteryName UNION ALL
303- ~~select top 0 335 WithBatteryValue, 'NS-移动电源' WithBatteryName UNION ALL~~
303+ select top 0 335 WithBatteryValue, 'NS-移动电源' WithBatteryName UNION ALL
304- ~~select top 0 336 WithBatteryValue, 'NS-成人用品' WithBatteryName UNION ALL~~
304+ select top 0 336 WithBatteryValue, 'NS-成人用品' WithBatteryName UNION ALL
305- ~~select top 0 337 WithBatteryValue, 'NS-电机_马达' WithBatteryName UNION ALL~~
305+ select top 0 337 WithBatteryValue, 'NS-电机_马达' WithBatteryName UNION ALL
306- ~~select top 0 338 WithBatteryValue, 'NS-带磁物品' WithBatteryName UNION ALL~~
306+ select top 0 338 WithBatteryValue, 'NS-带磁物品' WithBatteryName UNION ALL
307- ~~select top 0 339 WithBatteryValue, 'NS-带外置电池' WithBatteryName UNION ALL~~
307+ select top 0 339 WithBatteryValue, 'NS-带外置电池' WithBatteryName UNION ALL
308- ~~select top 0 340 WithBatteryValue, 'NS-带内置电池' WithBatteryName UNION ALL~~
308+ select top 0 340 WithBatteryValue, 'NS-带内置电池' WithBatteryName UNION ALL
309- ~~select top 0 341 WithBatteryValue, 'NS-含纽扣电池' WithBatteryName UNION ALL~~
309+ select top 0 341 WithBatteryValue, 'NS-含纽扣电池' WithBatteryName UNION ALL
310- ~~select top 0 342 WithBatteryValue, 'NS-手表' WithBatteryName UNION ALL~~
310+ select top 0 342 WithBatteryValue, 'NS-手表' WithBatteryName UNION ALL
311- ~~select top 0 343 WithBatteryValue, 'NS-纺织品' WithBatteryName UNION ALL~~
311+ select top 0 343 WithBatteryValue, 'NS-纺织品' WithBatteryName UNION ALL
312- ~~select top 0 344 WithBatteryValue, 'NS-圆柱体' WithBatteryName UNION ALL~~
312+ select top 0 344 WithBatteryValue, 'NS-圆柱体' WithBatteryName UNION ALL
313- ~~select top 0 345 WithBatteryValue, 'NS-普货' WithBatteryName UNION ALL~~
313+ select top 0 345 WithBatteryValue, 'NS-普货' WithBatteryName UNION ALL
314- ~~select top 0 346 WithBatteryValue, '违禁品' WithBatteryName UNION ALL~~
314+ select top 0 346 WithBatteryValue, '违禁品' WithBatteryName UNION ALL
315- ~~select top 0 347 WithBatteryValue, '爆款' WithBatteryName UNION ALL~~
315+ select top 0 347 WithBatteryValue, '爆款' WithBatteryName UNION ALL
316- ~~select top 0 348 WithBatteryValue, '测款' WithBatteryName UNION ALL~~
316+ select top 0 348 WithBatteryValue, '测款' WithBatteryName UNION ALL
317- ~~select top 0 349 WithBatteryValue, '测款' WithBatteryName UNION ALL~~
317+ select top 0 349 WithBatteryValue, '测款' WithBatteryName UNION ALL
318- ~~select top 0 350 WithBatteryValue, '带内置电池+液体' WithBatteryName UNION ALL~~
318+ select top 0 350 WithBatteryValue, '带内置电池+液体' WithBatteryName UNION ALL
319- ~~select top 0 351 WithBatteryValue, '精油1' WithBatteryName UNION ALL~~
319+ select top 0 351 WithBatteryValue, '精油1' WithBatteryName UNION ALL
320- ~~select top 0 352 WithBatteryValue, '超长普货' WithBatteryName UNION ALL~~
320+ select top 0 352 WithBatteryValue, '超长普货' WithBatteryName UNION ALL
321- ~~select top 0 353 WithBatteryValue, '超长非普' WithBatteryName UNION ALL~~
321+ select top 0 353 WithBatteryValue, '超长非普' WithBatteryName UNION ALL
322- ~~select top 0 354 WithBatteryValue, '锂电池UN3481' WithBatteryName UNION ALL~~
322+ select top 0 354 WithBatteryValue, '锂电池UN3481' WithBatteryName UNION ALL
323- ~~select top 0 355 WithBatteryValue, '可充电干电池A199' WithBatteryName UNION ALL~~
323+ select top 0 355 WithBatteryValue, '可充电干电池A199' WithBatteryName UNION ALL
324- ~~select top 0 356 WithBatteryValue, '不可充电干电池A123' WithBatteryName UNION ALL~~
324+ select top 0 356 WithBatteryValue, '不可充电干电池A123' WithBatteryName UNION ALL
325- ~~select top 0 357 WithBatteryValue, '抛货' WithBatteryName UNION ALL~~
325+ select top 0 357 WithBatteryValue, '抛货' WithBatteryName UNION ALL
326- ~~select top 0 358 WithBatteryValue, '测试自定义物流属性0426-11' WithBatteryName UNION ALL~~
326+ select top 0 358 WithBatteryValue, '测试自定义物流属性0426-11' WithBatteryName UNION ALL
327- ~~select top 0 359 WithBatteryValue, '测试自定义物流属性' WithBatteryName UNION ALL~~
327+ select top 0 359 WithBatteryValue, '测试自定义物流属性' WithBatteryName UNION ALL
328- ~~select top 0 360 WithBatteryValue, '木质类_竹质类抛货' WithBatteryName UNION ALL~~
328+ select top 0 360 WithBatteryValue, '木质类_竹质类抛货' WithBatteryName UNION ALL
329- ~~select top 0 361 WithBatteryValue, '蓝牙头盔' WithBatteryName UNION ALL~~
329+ select top 0 361 WithBatteryValue, '蓝牙头盔' WithBatteryName UNION ALL
330- ~~select top 0 362 WithBatteryValue, '气雾产品' WithBatteryName UNION ALL~~
330+ select top 0 362 WithBatteryValue, '气雾产品' WithBatteryName UNION ALL
331- ~~select top 0 363 WithBatteryValue, '指甲油产品' WithBatteryName UNION ALL~~
331+ select top 0 363 WithBatteryValue, '指甲油产品' WithBatteryName UNION ALL
332- ~~select top 0 364 WithBatteryValue, '刺激气味产品' WithBatteryName UNION ALL~~
332+ select top 0 364 WithBatteryValue, '刺激气味产品' WithBatteryName UNION ALL
333- ~~select top 0 365 WithBatteryValue, '易燃易爆品' WithBatteryName UNION ALL~~
333+ select top 0 365 WithBatteryValue, '易燃易爆品' WithBatteryName UNION ALL
334- ~~select top 0 366 WithBatteryValue, '特殊尖锐器具' WithBatteryName UNION ALL~~
334+ select top 0 366 WithBatteryValue, '特殊尖锐器具' WithBatteryName UNION ALL
335- ~~select top 0 367 WithBatteryValue, '管制刀具' WithBatteryName UNION ALL~~
335+ select top 0 367 WithBatteryValue, '管制刀具' WithBatteryName UNION ALL
336- ~~select top 0 368 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL~~
336+ select top 0 368 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL
337- ~~select top 0 369 WithBatteryValue, '洗手液' WithBatteryName UNION ALL~~
337+ select top 0 369 WithBatteryValue, '洗手液' WithBatteryName UNION ALL
338- ~~select top 0 370 WithBatteryValue, '食品' WithBatteryName UNION ALL~~
338+ select top 0 370 WithBatteryValue, '食品' WithBatteryName UNION ALL
339- ~~select top 0 371 WithBatteryValue, '儿童玩具' WithBatteryName UNION ALL~~
339+ select top 0 371 WithBatteryValue, '儿童玩具' WithBatteryName UNION ALL
340- ~~select top 0 372 WithBatteryValue, 'HDMI产品' WithBatteryName UNION ALL~~
340+ select top 0 372 WithBatteryValue, 'HDMI产品' WithBatteryName UNION ALL
341- ~~select top 0 373 WithBatteryValue, 'FDA产品' WithBatteryName UNION ALL~~
341+ select top 0 373 WithBatteryValue, 'FDA产品' WithBatteryName UNION ALL
342- ~~select top 0 374 WithBatteryValue, '蓝牙产品' WithBatteryName UNION ALL~~
342+ select top 0 374 WithBatteryValue, '蓝牙产品' WithBatteryName UNION ALL
343- ~~select top 0 375 WithBatteryValue, '无电池' WithBatteryName UNION ALL~~
343+ select top 0 375 WithBatteryValue, '无电池' WithBatteryName UNION ALL
344- ~~select top 0 376 WithBatteryValue, '带电成人用品' WithBatteryName UNION ALL~~
344+ select top 0 376 WithBatteryValue, '带电成人用品' WithBatteryName UNION ALL
345- ~~select top 0 377 WithBatteryValue, '无电成人用品' WithBatteryName UNION ALL~~
345+ select top 0 377 WithBatteryValue, '无电成人用品' WithBatteryName UNION ALL
346- ~~select top 0 378 WithBatteryValue, '易燃' WithBatteryName UNION ALL~~
346+ select top 0 378 WithBatteryValue, '易燃' WithBatteryName UNION ALL
347- ~~select top 0 379 WithBatteryValue, '带金属器件' WithBatteryName UNION ALL~~
347+ select top 0 379 WithBatteryValue, '带金属器件' WithBatteryName UNION ALL
348- ~~select top 0 380 WithBatteryValue, '锐器' WithBatteryName UNION ALL~~
348+ select top 0 380 WithBatteryValue, '锐器' WithBatteryName UNION ALL
349- ~~select top 0 381 WithBatteryValue, '万邑联KY仓' WithBatteryName UNION ALL~~
349+ select top 0 381 WithBatteryValue, '万邑联KY仓' WithBatteryName UNION ALL
350- ~~select top 0 382 WithBatteryValue, '食品接触类（易碎）' WithBatteryName UNION ALL~~
350+ select top 0 382 WithBatteryValue, '食品接触类（易碎）' WithBatteryName UNION ALL
351- ~~select top 0 383 WithBatteryValue, '食品接触类（木质）' WithBatteryName UNION ALL~~
351+ select top 0 383 WithBatteryValue, '食品接触类（木质）' WithBatteryName UNION ALL
352- ~~select top 0 384 WithBatteryValue, '食品接触类（带电）' WithBatteryName UNION ALL~~
352+ select top 0 384 WithBatteryValue, '食品接触类（带电）' WithBatteryName UNION ALL
353- ~~select top 0 385 WithBatteryValue, '配套电池' WithBatteryName UNION ALL~~
353+ select top 0 385 WithBatteryValue, '配套电池' WithBatteryName UNION ALL
354- ~~select top 0 386 WithBatteryValue, '内置电池（查验）' WithBatteryName UNION ALL~~
354+ select top 0 386 WithBatteryValue, '内置电池（查验）' WithBatteryName UNION ALL
355- ~~select top 0 387 WithBatteryValue, '内置电池（人体接触）' WithBatteryName UNION ALL~~
355+ select top 0 387 WithBatteryValue, '内置电池（人体接触）' WithBatteryName UNION ALL
356- ~~select top 0 388 WithBatteryValue, '外置电池（查验）' WithBatteryName UNION ALL~~
356+ select top 0 388 WithBatteryValue, '外置电池（查验）' WithBatteryName UNION ALL
357- ~~select top 0 389 WithBatteryValue, '纽扣电池（查验）' WithBatteryName UNION ALL~~
357+ select top 0 389 WithBatteryValue, '纽扣电池（查验）' WithBatteryName UNION ALL
358- ~~select top 0 390 WithBatteryValue, '弱磁' WithBatteryName UNION ALL~~
358+ select top 0 390 WithBatteryValue, '弱磁' WithBatteryName UNION ALL
359- ~~select top 0 391 WithBatteryValue, '弱磁（查验）' WithBatteryName UNION ALL~~
359+ select top 0 391 WithBatteryValue, '弱磁（查验）' WithBatteryName UNION ALL
360- ~~select top 0 392 WithBatteryValue, '强磁' WithBatteryName UNION ALL~~
360+ select top 0 392 WithBatteryValue, '强磁' WithBatteryName UNION ALL
361- ~~select top 0 393 WithBatteryValue, '普通刀具_剪刀' WithBatteryName UNION ALL~~
361+ select top 0 393 WithBatteryValue, '普通刀具_剪刀' WithBatteryName UNION ALL
362- ~~select top 0 394 WithBatteryValue, '户外刀具' WithBatteryName UNION ALL~~
362+ select top 0 394 WithBatteryValue, '户外刀具' WithBatteryName UNION ALL
363- ~~select top 0 395 WithBatteryValue, '仿真枪' WithBatteryName UNION ALL~~
363+ select top 0 395 WithBatteryValue, '仿真枪' WithBatteryName UNION ALL
364- ~~select top 0 396 WithBatteryValue, '医疗用品' WithBatteryName UNION ALL~~
364+ select top 0 396 WithBatteryValue, '医疗用品' WithBatteryName UNION ALL
365- ~~select top 0 397 WithBatteryValue, '酒精类' WithBatteryName UNION ALL~~
365+ select top 0 397 WithBatteryValue, '酒精类' WithBatteryName UNION ALL
366- ~~select top 0 398 WithBatteryValue, '玩具' WithBatteryName UNION ALL~~
366+ select top 0 398 WithBatteryValue, '玩具' WithBatteryName UNION ALL
367- ~~select top 0 399 WithBatteryValue, '玩具（查验）' WithBatteryName UNION ALL~~
367+ select top 0 399 WithBatteryValue, '玩具（查验）' WithBatteryName UNION ALL
368- ~~select top 0 400 WithBatteryValue, '植物类' WithBatteryName UNION ALL~~
368+ select top 0 400 WithBatteryValue, '植物类' WithBatteryName UNION ALL
369- ~~select top 0 401 WithBatteryValue, '种子类' WithBatteryName UNION ALL~~
369+ select top 0 401 WithBatteryValue, '种子类' WithBatteryName UNION ALL
370- ~~select top 0 402 WithBatteryValue, '按摩类' WithBatteryName UNION ALL~~
370+ select top 0 402 WithBatteryValue, '按摩类' WithBatteryName UNION ALL
371- ~~select top 0 403 WithBatteryValue, '普货（人体接触）' WithBatteryName UNION ALL~~
371+ select top 0 403 WithBatteryValue, '普货（人体接触）' WithBatteryName UNION ALL
372- ~~select top 0 404 WithBatteryValue, '查验' WithBatteryName UNION ALL~~
372+ select top 0 404 WithBatteryValue, '查验' WithBatteryName UNION ALL
373- ~~select top 0 405 WithBatteryValue, '印泥' WithBatteryName UNION ALL~~
373+ select top 0 405 WithBatteryValue, '印泥' WithBatteryName UNION ALL
374- ~~select top 0 406 WithBatteryValue, '一次性塑料用品' WithBatteryName UNION ALL~~
374+ select top 0 406 WithBatteryValue, '一次性塑料用品' WithBatteryName UNION ALL
375- ~~select top 0 407 WithBatteryValue, '解压球' WithBatteryName UNION ALL~~
375+ select top 0 407 WithBatteryValue, '解压球' WithBatteryName UNION ALL
376- ~~select top 0 408 WithBatteryValue, '成人用品带电' WithBatteryName UNION ALL~~
376+ select top 0 408 WithBatteryValue, '成人用品带电' WithBatteryName UNION ALL
377- ~~select top 0 409 WithBatteryValue, '面膜' WithBatteryName UNION ALL~~
377+ select top 0 409 WithBatteryValue, '面膜' WithBatteryName UNION ALL
378- ~~select top 0 410 WithBatteryValue, '药膏' WithBatteryName UNION ALL~~
378+ select top 0 410 WithBatteryValue, '药膏' WithBatteryName UNION ALL
379- ~~select top 0 411 WithBatteryValue, '深圳粉末液体' WithBatteryName UNION ALL~~
379+ select top 0 411 WithBatteryValue, '深圳粉末液体' WithBatteryName UNION ALL
380- ~~select top 0 412 WithBatteryValue, '深圳带电' WithBatteryName UNION ALL~~
380+ select top 0 412 WithBatteryValue, '深圳带电' WithBatteryName UNION ALL
381- ~~select top 0 413 WithBatteryValue, '灰色产品' WithBatteryName UNION ALL~~
381+ select top 0 413 WithBatteryValue, '灰色产品' WithBatteryName UNION ALL
382- ~~select top 0 414 WithBatteryValue, '牙套' WithBatteryName UNION ALL~~
382+ select top 0 414 WithBatteryValue, '牙套' WithBatteryName UNION ALL
383- ~~select top 0 415 WithBatteryValue, '1231231' WithBatteryName UNION ALL~~
383+ select top 0 415 WithBatteryValue, '1231231' WithBatteryName UNION ALL
384- ~~select top 0 416 WithBatteryValue, '食品接触（竹质）' WithBatteryName UNION ALL~~
384+ select top 0 416 WithBatteryValue, '食品接触（竹质）' WithBatteryName UNION ALL
385- ~~select top 0 417 WithBatteryValue, '化妆品类液体粉末膏体' WithBatteryName UNION ALL~~
385+ select top 0 417 WithBatteryValue, '化妆品类液体粉末膏体' WithBatteryName UNION ALL
386- ~~select top 0 418 WithBatteryValue, '打火机-敏感货' WithBatteryName UNION ALL~~
386+ select top 0 418 WithBatteryValue, '打火机-敏感货' WithBatteryName UNION ALL
387- ~~select top 0 419 WithBatteryValue, '普货-敏感货' WithBatteryName UNION ALL~~
387+ select top 0 419 WithBatteryValue, '普货-敏感货' WithBatteryName UNION ALL
388- ~~select top 0 420 WithBatteryValue, '带内置电池-敏感货' WithBatteryName UNION ALL~~
388+ select top 0 420 WithBatteryValue, '带内置电池-敏感货' WithBatteryName UNION ALL
389- ~~select top 0 421 WithBatteryValue, '带内置电池-高货值' WithBatteryName UNION ALL~~
389+ select top 0 421 WithBatteryValue, '带内置电池-高货值' WithBatteryName UNION ALL
390- ~~select top 0 422 WithBatteryValue, '智能手环' WithBatteryName UNION ALL~~
390+ select top 0 422 WithBatteryValue, '智能手环' WithBatteryName UNION ALL
391- ~~select top 0 423 WithBatteryValue, '液体-敏感货' WithBatteryName UNION ALL~~
391+ select top 0 423 WithBatteryValue, '液体-敏感货' WithBatteryName UNION ALL
392- ~~select top 0 424 WithBatteryValue, '假睫毛' WithBatteryName UNION ALL~~
392+ select top 0 424 WithBatteryValue, '假睫毛' WithBatteryName UNION ALL
393- ~~select top 0 425 WithBatteryValue, '太阳能充电宝' WithBatteryName UNION ALL~~
393+ select top 0 425 WithBatteryValue, '太阳能充电宝' WithBatteryName UNION ALL
394- ~~select top 0 426 WithBatteryValue, '带内置电池-敏感货' WithBatteryName UNION ALL~~
394+ select top 0 426 WithBatteryValue, '带内置电池-敏感货' WithBatteryName UNION ALL
395- ~~select top 0 427 WithBatteryValue, '普货-敏感货' WithBatteryName UNION ALL~~
395+ select top 0 427 WithBatteryValue, '普货-敏感货' WithBatteryName UNION ALL
396- ~~select top 0 428 WithBatteryValue, '粉末-敏感货' WithBatteryName UNION ALL~~
396+ select top 0 428 WithBatteryValue, '粉末-敏感货' WithBatteryName UNION ALL
397- ~~select top 0 429 WithBatteryValue, '特殊属性' WithBatteryName UNION ALL~~
397+ select top 0 429 WithBatteryValue, '特殊属性' WithBatteryName UNION ALL
398- ~~select top 0 430 WithBatteryValue, '带电容' WithBatteryName UNION ALL~~
398+ select top 0 430 WithBatteryValue, '带电容' WithBatteryName UNION ALL
399- ~~select top 0 431 WithBatteryValue, '陈冠希A货' WithBatteryName UNION ALL~~
399+ select top 0 431 WithBatteryValue, '陈冠希A货' WithBatteryName UNION ALL
400- ~~select top 0 432 WithBatteryValue, '包裹长度超60CM' WithBatteryName UNION ALL~~
400+ select top 0 432 WithBatteryValue, '包裹长度超60CM' WithBatteryName UNION ALL
401- ~~select top 0 433 WithBatteryValue, '强磁' WithBatteryName UNION ALL~~
401+ select top 0 433 WithBatteryValue, '强磁' WithBatteryName UNION ALL
402- ~~select top 0 434 WithBatteryValue, '111' WithBatteryName UNION ALL~~
402+ select top 0 434 WithBatteryValue, '111' WithBatteryName UNION ALL
403- ~~select top 0 435 WithBatteryValue, 'AAAAAA' WithBatteryName UNION ALL~~
403+ select top 0 435 WithBatteryValue, 'AAAAAA' WithBatteryName UNION ALL
404- ~~select top 0 436 WithBatteryValue, '强磁' WithBatteryName UNION ALL~~
404+ select top 0 436 WithBatteryValue, '强磁' WithBatteryName UNION ALL
405- ~~select top 0 437 WithBatteryValue, '敏感货' WithBatteryName UNION ALL~~
405+ select top 0 437 WithBatteryValue, '敏感货' WithBatteryName UNION ALL
406- ~~select top 0 438 WithBatteryValue, '糖果超甜' WithBatteryName UNION ALL~~
406+ select top 0 438 WithBatteryValue, '糖果超甜' WithBatteryName UNION ALL
407- ~~select top 0 439 WithBatteryValue, '食品接触（宠物餐具）' WithBatteryName UNION ALL~~
407+ select top 0 439 WithBatteryValue, '食品接触（宠物餐具）' WithBatteryName UNION ALL
408- ~~select top 0 440 WithBatteryValue, '强磁' WithBatteryName UNION ALL~~
408+ select top 0 440 WithBatteryValue, '强磁' WithBatteryName UNION ALL
409- ~~select top 0 441 WithBatteryValue, '弱磁' WithBatteryName UNION ALL~~
409+ select top 0 441 WithBatteryValue, '弱磁' WithBatteryName UNION ALL
410- ~~select top 0 442 WithBatteryValue, '超体积普（6000抛比小于2倍）' WithBatteryName UNION ALL~~
410+ select top 0 442 WithBatteryValue, '超体积普（6000抛比小于2倍）' WithBatteryName UNION ALL
411- ~~select top 0 443 WithBatteryValue, '弱磁产品' WithBatteryName UNION ALL~~
411+ select top 0 443 WithBatteryValue, '弱磁产品' WithBatteryName UNION ALL
412- ~~select top 0 444 WithBatteryValue, '气雾' WithBatteryName UNION ALL~~
412+ select top 0 444 WithBatteryValue, '气雾' WithBatteryName UNION ALL
413- ~~select top 0 445 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL~~
413+ select top 0 445 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL
414- ~~select top 0 446 WithBatteryValue, '违禁品' WithBatteryName UNION ALL~~
414+ select top 0 446 WithBatteryValue, '违禁品' WithBatteryName UNION ALL
415- ~~select top 0 447 WithBatteryValue, '马达' WithBatteryName UNION ALL~~
415+ select top 0 447 WithBatteryValue, '马达' WithBatteryName UNION ALL
416- ~~select top 0 448 WithBatteryValue, '普通颗粒类' WithBatteryName UNION ALL~~
416+ select top 0 448 WithBatteryValue, '普通颗粒类' WithBatteryName UNION ALL
417- ~~select top 0 449 WithBatteryValue, '带外置电池-敏感货' WithBatteryName UNION ALL~~
417+ select top 0 449 WithBatteryValue, '带外置电池-敏感货' WithBatteryName UNION ALL
418- ~~select top 0 450 WithBatteryValue, '带外置电池-敏感货' WithBatteryName UNION ALL~~
418+ select top 0 450 WithBatteryValue, '带外置电池-敏感货' WithBatteryName UNION ALL
419- ~~select top 0 451 WithBatteryValue, '成人用品（带电）' WithBatteryName UNION ALL~~
419+ select top 0 451 WithBatteryValue, '成人用品（带电）' WithBatteryName UNION ALL
420- ~~select top 0 452 WithBatteryValue, '化妆品' WithBatteryName UNION ALL~~
420+ select top 0 452 WithBatteryValue, '化妆品' WithBatteryName UNION ALL
421- ~~select top 0 453 WithBatteryValue, '新人-钢铁侠' WithBatteryName UNION ALL~~
421+ select top 0 453 WithBatteryValue, '新人-钢铁侠' WithBatteryName UNION ALL
422- ~~select top 0 454 WithBatteryValue, '陶瓷' WithBatteryName UNION ALL~~
422+ select top 0 454 WithBatteryValue, '陶瓷' WithBatteryName UNION ALL
423- ~~select top 0 455 WithBatteryValue, '带电带磁带电机' WithBatteryName UNION ALL~~
423+ select top 0 455 WithBatteryValue, '带电带磁带电机' WithBatteryName UNION ALL
424- ~~select top 0 456 WithBatteryValue, '仿牌' WithBatteryName UNION ALL~~
424+ select top 0 456 WithBatteryValue, '仿牌' WithBatteryName UNION ALL
425- ~~select top 0 457 WithBatteryValue, '激光笔' WithBatteryName UNION ALL~~
425+ select top 0 457 WithBatteryValue, '激光笔' WithBatteryName UNION ALL
426- ~~select top 0 458 WithBatteryValue, '带电蓝牙产品' WithBatteryName UNION ALL~~
426+ select top 0 458 WithBatteryValue, '带电蓝牙产品' WithBatteryName UNION ALL
427- ~~select top 0 459 WithBatteryValue, '平板电脑' WithBatteryName UNION ALL~~
427+ select top 0 459 WithBatteryValue, '平板电脑' WithBatteryName UNION ALL
428- ~~select top 0 460 WithBatteryValue, '头盔' WithBatteryName UNION ALL~~
428+ select top 0 460 WithBatteryValue, '头盔' WithBatteryName UNION ALL
429- ~~select top 0 461 WithBatteryValue, '食品' WithBatteryName UNION ALL~~
429+ select top 0 461 WithBatteryValue, '食品' WithBatteryName UNION ALL
430- ~~select top 0 462 WithBatteryValue, '药品' WithBatteryName UNION ALL~~
430+ select top 0 462 WithBatteryValue, '药品' WithBatteryName UNION ALL
431- ~~select top 0 463 WithBatteryValue, '剪刀' WithBatteryName UNION ALL~~
431+ select top 0 463 WithBatteryValue, '剪刀' WithBatteryName UNION ALL
432- ~~select top 0 464 WithBatteryValue, '活性炭' WithBatteryName UNION ALL~~
432+ select top 0 464 WithBatteryValue, '活性炭' WithBatteryName UNION ALL
433- ~~select top 0 465 WithBatteryValue, '带刀产品' WithBatteryName UNION ALL~~
433+ select top 0 465 WithBatteryValue, '带刀产品' WithBatteryName UNION ALL
434- ~~select top 0 466 WithBatteryValue, '水滤器（带碳粉）' WithBatteryName UNION ALL~~
434+ select top 0 466 WithBatteryValue, '水滤器（带碳粉）' WithBatteryName UNION ALL
435- ~~select top 0 467 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL~~
435+ select top 0 467 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL
436- ~~select top 0 468 WithBatteryValue, '带电带磁带木材' WithBatteryName UNION ALL~~
436+ select top 0 468 WithBatteryValue, '带电带磁带木材' WithBatteryName UNION ALL
437- ~~select top 0 469 WithBatteryValue, '纽扣电池（内置）' WithBatteryName UNION ALL~~
437+ select top 0 469 WithBatteryValue, '纽扣电池（内置）' WithBatteryName UNION ALL
438- ~~select top 0 470 WithBatteryValue, '纽扣电池（外置）' WithBatteryName UNION ALL~~
438+ select top 0 470 WithBatteryValue, '纽扣电池（外置）' WithBatteryName UNION ALL
439- ~~select top 0 471 WithBatteryValue, '纽扣电池（纯电池）' WithBatteryName UNION ALL~~
439+ select top 0 471 WithBatteryValue, '纽扣电池（纯电池）' WithBatteryName UNION ALL
440- ~~select top 0 472 WithBatteryValue, '锂电池（内置）' WithBatteryName UNION ALL~~
440+ select top 0 472 WithBatteryValue, '锂电池（内置）' WithBatteryName UNION ALL
441- ~~select top 0 473 WithBatteryValue, '锂电池（外置）' WithBatteryName UNION ALL~~
441+ select top 0 473 WithBatteryValue, '锂电池（外置）' WithBatteryName UNION ALL
442- ~~select top 0 474 WithBatteryValue, '锂电池（纯电池）' WithBatteryName UNION ALL~~
442+ select top 0 474 WithBatteryValue, '锂电池（纯电池）' WithBatteryName UNION ALL
443- ~~select top 0 475 WithBatteryValue, '干电池（内置）' WithBatteryName UNION ALL~~
443+ select top 0 475 WithBatteryValue, '干电池（内置）' WithBatteryName UNION ALL
444- ~~select top 0 476 WithBatteryValue, '干电池（外置）' WithBatteryName UNION ALL~~
444+ select top 0 476 WithBatteryValue, '干电池（外置）' WithBatteryName UNION ALL
445- ~~select top 0 477 WithBatteryValue, '干电池（纯电池）' WithBatteryName UNION ALL~~
445+ select top 0 477 WithBatteryValue, '干电池（纯电池）' WithBatteryName UNION ALL
446- ~~select top 0 478 WithBatteryValue, '镍氢电池（内置）' WithBatteryName UNION ALL~~
446+ select top 0 478 WithBatteryValue, '镍氢电池（内置）' WithBatteryName UNION ALL
447- ~~select top 0 479 WithBatteryValue, '镍氢电池（外置）' WithBatteryName UNION ALL~~
447+ select top 0 479 WithBatteryValue, '镍氢电池（外置）' WithBatteryName UNION ALL
448- ~~select top 0 480 WithBatteryValue, '镍氢电池（纯电池）' WithBatteryName UNION ALL~~
448+ select top 0 480 WithBatteryValue, '镍氢电池（纯电池）' WithBatteryName UNION ALL
449- ~~select top 0 481 WithBatteryValue, '成人用品（带电）' WithBatteryName~~
449+ select top 0 481 WithBatteryValue, '成人用品（带电）' WithBatteryName
450- ~~) a~~
450+ ) a
451-
451+
452-
452+
453-
453+
454- ~~select top 0 w.WareHouseName AS '仓库',~~
454+ select top 0 w.WareHouseName AS '仓库',
455- ~~pr.ListNo AS '销单号',~~
455+ pr.ListNo AS '销单号',
456- ~~pr.SKU AS 'SKU',~~
456+ pr.SKU AS 'SKU',
457- ~~p.ProductNameCN AS '中文名',~~
457+ p.ProductNameCN AS '中文名',
458- ~~CASE pl.IsUrgent WHEN 1 THEN '是' WHEN 0 THEN '否' END AS '是否加急',~~
458+ CASE pl.IsUrgent WHEN 1 THEN '是' WHEN 0 THEN '否' END AS '是否加急',
459- ~~CASE pl.IsSample WHEN 1 THEN '是' WHEN 0 THEN '否' END AS '是否样品',~~
459+ CASE pl.IsSample WHEN 1 THEN '是' WHEN 0 THEN '否' END AS '是否样品',
460- ~~CASE pr.NeedToPackType~~
460+ CASE pr.NeedToPackType
461- ~~WHEN 0 THEN '不需打包'~~
461+ WHEN 0 THEN '不需打包'
462- ~~WHEN 1 THEN '需供应商打包'~~
462+ WHEN 1 THEN '需供应商打包'
463- ~~WHEN 2 THEN '加工打包'~~
463+ WHEN 2 THEN '加工打包'
464- ~~WHEN 3 THEN '销单打包'~~
464+ WHEN 3 THEN '销单打包'
465- ~~ELSE ''~~
465+ ELSE ''
466- ~~END AS '打包状态'~~
466+ END AS '打包状态'
467- ~~prd.ActualBuyNum AS '销单数量',~~
467+ prd.ActualBuyNum AS '销单数量',
468- ~~prd.ProcessNum AS '加工数量',~~
468+ prd.ProcessNum AS '加工数量',
469- ~~prd.BadNum AS '不良品',~~
469+ prd.BadNum AS '不良品',
470- ~~prd.TallyNum AS '理货数量',~~
470+ prd.TallyNum AS '理货数量',
471- ~~prd.PutInNum AS '入库数量',~~
471+ prd.PutInNum AS '入库数量',
472- ~~t.WithBatteryName AS '物流属性',~~
472+ t.WithBatteryName AS '物流属性',
473- ~~CASE prd.TaskState~~
473+ CASE prd.TaskState
474- ~~WHEN 0 THEN '待质检'~~
474+ WHEN 0 THEN '待质检'
475- ~~WHEN 1 THEN '待入库'~~
475+ WHEN 1 THEN '待入库'
476- ~~WHEN 2 THEN '部分入库'~~
476+ WHEN 2 THEN '部分入库'
477- ~~WHEN 3 THEN '已完成'~~
477+ WHEN 3 THEN '已完成'
478- ~~ELSE ''~~
478+ ELSE ''
479- ~~END AS '任务状态',~~
479+ END AS '任务状态',
480- ~~pr.ReceiptUserNmae AS '收货人',~~
480+ pr.ReceiptUserNmae AS '收货人',
481- ~~pr.ReceiptTime AS '收货时间',~~
481+ pr.ReceiptTime AS '收货时间',
482- ~~prc.PrepareBuyUserName AS '预销单人',~~
482+ prc.PrepareBuyUserName AS '预销单人',
483- ~~prc.PrepareBuyTime AS '预销单时间',~~
483+ prc.PrepareBuyTime AS '预销单时间',
484- ~~prd.BuyUserName AS '销单人',~~
484+ prd.BuyUserName AS '销单人',
485- ~~prd.BuyTime AS '销单时间',~~
485+ prd.BuyTime AS '销单时间',
486- ~~prd.ProcessUserName AS '加工人',~~
486+ prd.ProcessUserName AS '加工人',
487- ~~prd.ProcessTime AS '加工时间',~~
487+ prd.ProcessTime AS '加工时间',
488- ~~prd.CheckUserName AS '质检人',~~
488+ prd.CheckUserName AS '质检人',
489- ~~prd.CheckTime AS '质检时间',~~
489+ prd.CheckTime AS '质检时间',
490- ~~prd.TallyUserName AS '理货人',~~
490+ prd.TallyUserName AS '理货人',
491- ~~prd.TallyTime AS '理货时间',~~
491+ prd.TallyTime AS '理货时间',
492- ~~prd.PutInUserName AS '入库人',~~
492+ prd.PutInUserName AS '入库人',
493- ~~prd.PutInTime AS '入库时间'~~
493+ prd.PutInTime AS '入库时间'
494- ~~FROM dbo.RB_Procurement_ReceiptAndStorage (NOLOCK) pr~~
494+ FROM dbo.RB_Procurement_ReceiptAndStorage (NOLOCK) pr
495- ~~LEFT JOIN dbo.RB_Warehouse(NOLOCK) w ON pr.WarehouseId=w.ID AND pr.CustomerId=w.CustomerID~~
495+ LEFT JOIN dbo.RB_Warehouse(NOLOCK) w ON pr.WarehouseId=w.ID AND pr.CustomerId=w.CustomerID
496- ~~LEFT JOIN dbo.RB_Product (NOLOCK) p ON pr.SKU=p.SKU AND pr.CustomerId=p.CustomerID~~
496+ LEFT JOIN dbo.RB_Product (NOLOCK) p ON pr.SKU=p.SKU AND pr.CustomerId=p.CustomerID
497- ~~LEFT JOIN dbo.RB_Procurement_ReceiptAndStorage_Details (NOLOCK)prd ON prd.ReceiptAndStorageId=pr.ID AND prd.CustomerId=pr.CustomerId~~
497+ LEFT JOIN dbo.RB_Procurement_ReceiptAndStorage_Details (NOLOCK)prd ON prd.ReceiptAndStorageId=pr.ID AND prd.CustomerId=pr.CustomerId
498- ~~LEFT JOIN dbo.RB_Procurement_ReceiptAndStorage_CourierNum (NOLOCK)prc ON prc.CourierNum=pr.CourierNum AND prc.CustomerID=pr.CustomerId~~
498+ LEFT JOIN dbo.RB_Procurement_ReceiptAndStorage_CourierNum (NOLOCK)prc ON prc.CourierNum=pr.CourierNum AND prc.CustomerID=pr.CustomerId
499- ~~LEFT JOIN dbo.RB_Procurement_List (NOLOCK) pl ON pl.P_Code=pr.P_Code AND pl.CustomerID=pr.CustomerId~~
499+ LEFT JOIN dbo.RB_Procurement_List (NOLOCK) pl ON pl.P_Code=pr.P_Code AND pl.CustomerID=pr.CustomerId
500- ~~LEFT JOIN #temp_WithBattery t ON t.WithBatteryValue=p.WithBattery~~
500+ LEFT JOIN #temp_WithBattery t ON t.WithBatteryValue=p.WithBattery
501- ~~WHERE prc.PrepareBuyTime>=@StartDate AND prc.PrepareBuyTime<=@EndDate AND pr.CustomerId=@CustomerId~~
501+ WHERE prc.PrepareBuyTime>=@StartDate AND prc.PrepareBuyTime<=@EndDate AND pr.CustomerId=@CustomerId
502- ~~PARAMS:@StartDate = null ,@EndDate = null ,@CustomerId = 0 ,~~
502+ PARAMS:@StartDate = null ,@EndDate = null ,@CustomerId = 0 ,
503- ~~MESSAGE:Incorrect syntax near 'prd'.~~
503+ MESSAGE:Incorrect syntax near 'prd'.
504- TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
504+ TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
505- ~~在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)~~
505+ 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
506- 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
506+ 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
507- ~~在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()~~
507+ 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
508- ~~在 System.Data.SqlClient.SqlDataReader.get_MetaData()~~
508+ 在 System.Data.SqlClient.SqlDataReader.get_MetaData()
509- 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
509+ 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
510- 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
510+ 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
511- 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DALExtend.RB_CustomReportExtend.GetSheetFieldsDr(String sqlContent, List1 sqlParameters)
511+ 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DALExtend.RB_CustomReportExtend.GetSheetFieldsDr(String sqlContent, List1 sqlParameters)
512- ~~在 Biz.Irobotbox.ReportCentre.CustomReportService.CheckSqlAndGetFields(String sqlContent, List`1 paramList)~~
512+ 在 Biz.Irobotbox.ReportCentre.CustomReportService.CheckSqlAndGetFields(String sqlContent, List`1 paramList)
513- ~~在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.CheckSqlAndGetFields()~~
513+ 在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.CheckSqlAndGetFields()
514- ~~在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.Page_Load(Object sender, EventArgs e)~~
514+ 在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.Page_Load(Object sender, EventArgs e)
515- ~~在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)~~
515+ 在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
516- ~~在 System.Web.UI.Control.OnLoad(EventArgs e)~~
516+ 在 System.Web.UI.Control.OnLoad(EventArgs e)
517- ~~在 System.Web.UI.Control.LoadRecursive()~~
517+ 在 System.Web.UI.Control.LoadRecursive()
518- ~~在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)~~
518+ 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
519- ~~在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)~~
519+ 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
520- ~~在 System.Web.UI.Page.ProcessRequest()~~
520+ 在 System.Web.UI.Page.ProcessRequest()
521- ~~在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)~~
521+ 在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
522- ~~在 System.Web.UI.Page.ProcessRequest(HttpContext context)~~
522+ 在 System.Web.UI.Page.ProcessRequest(HttpContext context)
523- ~~在 ASP.irobotbox_reportcentre_customreportedit_aspx.ProcessRequest(HttpContext context)~~
523+ 在 ASP.irobotbox_reportcentre_customreportedit_aspx.ProcessRequest(HttpContext context)
524- ~~在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()~~
524+ 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
525- ~~在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)~~
525+ 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
526- ~~在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)~~
526+ 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
527- ~~在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)~~
527+ 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
528- ~~在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)~~
528+ 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
529- ~~在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)~~
529+ 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
530- ~~在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)~~
530+ 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
531- ~~在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)~~
531+ 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
532-
532+
533-
533+
534-
534+
535-
535+
536-
536+
537-
537+
538-
538+
539-
539+
540-
540+
541-

001- ~~<p>~~
001+ <p><br /></p>
002- ~~</p><div>prometheus告警</div>~~
002+ <div>prometheus告警</div>
011- ~~<div>Error:15_102_1_-2146232060</div>~~
011+ <div>Error:15_102_1_-2146232060</div>
012- ~~<div>SQL:--物流属性表</div>~~
012+ <div>SQL:--物流属性表</div>
013- ~~<div>DROP TABLE IF EXISTS #temp_WithBattery</div>~~
013+ <div>DROP TABLE IF EXISTS #temp_WithBattery</div>
014- ~~<div>select top 0 a.*</div>~~
014+ <div>select top 0 a.*</div>
015- ~~<div>INTO #temp_WithBattery</div>~~
015+ <div>INTO #temp_WithBattery</div>
016- ~~<div>FROM(</div>~~
016+ <div>FROM(</div>
017- ~~<div>select top 0 1 WithBatteryValue, '普货' WithBatteryName UNION ALL</div>~~
017+ <div>select top 0 1 WithBatteryValue, '普货' WithBatteryName UNION ALL</div>
018- ~~<div>select top 0 2 WithBatteryValue, '纯电池' WithBatteryName UNION ALL</div>~~
018+ <div>select top 0 2 WithBatteryValue, '纯电池' WithBatteryName UNION ALL</div>
019- ~~<div>select top 0 3 WithBatteryValue, '带内置电池' WithBatteryName UNION ALL</div>~~
019+ <div>select top 0 3 WithBatteryValue, '带内置电池' WithBatteryName UNION ALL</div>
020- ~~<div>select top 0 4 WithBatteryValue, '带外置电池' WithBatteryName UNION ALL</div>~~
020+ <div>select top 0 4 WithBatteryValue, '带外置电池' WithBatteryName UNION ALL</div>
021- ~~<div>select top 0 5 WithBatteryValue, '含纽扣电池' WithBatteryName UNION ALL</div>~~
021+ <div>select top 0 5 WithBatteryValue, '含纽扣电池' WithBatteryName UNION ALL</div>
022- ~~<div>select top 0 6 WithBatteryValue, '液体' WithBatteryName UNION ALL</div>~~
022+ <div>select top 0 6 WithBatteryValue, '液体' WithBatteryName UNION ALL</div>
023- ~~<div>select top 0 7 WithBatteryValue, '粉末' WithBatteryName UNION ALL</div>~~
023+ <div>select top 0 7 WithBatteryValue, '粉末' WithBatteryName UNION ALL</div>
024- ~~<div>select top 0 8 WithBatteryValue, '打火机' WithBatteryName UNION ALL</div>~~
024+ <div>select top 0 8 WithBatteryValue, '打火机' WithBatteryName UNION ALL</div>
025- ~~<div>select top 0 9 WithBatteryValue, '刀具_剪刀_仿真枪' WithBatteryName UNION ALL</div>~~
025+ <div>select top 0 9 WithBatteryValue, '刀具_剪刀_仿真枪' WithBatteryName UNION ALL</div>
026- ~~<div>select top 0 10 WithBatteryValue, '带磁物品' WithBatteryName UNION ALL</div>~~
026+ <div>select top 0 10 WithBatteryValue, '带磁物品' WithBatteryName UNION ALL</div>
027- ~~<div>select top 0 12 WithBatteryValue, '木质类_竹质类' WithBatteryName UNION ALL</div>~~
027+ <div>select top 0 12 WithBatteryValue, '木质类_竹质类' WithBatteryName UNION ALL</div>
028- ~~<div>select top 0 11 WithBatteryValue, '其他禁运物品' WithBatteryName UNION ALL</div>~~
028+ <div>select top 0 11 WithBatteryValue, '其他禁运物品' WithBatteryName UNION ALL</div>
029- ~~<div>select top 0 13 WithBatteryValue, '膏状' WithBatteryName UNION ALL</div>~~
029+ <div>select top 0 13 WithBatteryValue, '膏状' WithBatteryName UNION ALL</div>
030- ~~<div>select top 0 14 WithBatteryValue, '易碎' WithBatteryName UNION ALL</div>~~
030+ <div>select top 0 14 WithBatteryValue, '易碎' WithBatteryName UNION ALL</div>
031- ~~<div>select top 0 15 WithBatteryValue, '动物羽毛类' WithBatteryName UNION ALL</div>~~
031+ <div>select top 0 15 WithBatteryValue, '动物羽毛类' WithBatteryName UNION ALL</div>
032- ~~<div>select top 0 16 WithBatteryValue, '大功率电池' WithBatteryName UNION ALL</div>~~
032+ <div>select top 0 16 WithBatteryValue, '大功率电池' WithBatteryName UNION ALL</div>
033- ~~<div>select top 0 17 WithBatteryValue, '电子烟' WithBatteryName UNION ALL</div>~~
033+ <div>select top 0 17 WithBatteryValue, '电子烟' WithBatteryName UNION ALL</div>
034- ~~<div>select top 0 18 WithBatteryValue, '移动电源' WithBatteryName UNION ALL</div>~~
034+ <div>select top 0 18 WithBatteryValue, '移动电源' WithBatteryName UNION ALL</div>
035- ~~<div>select top 0 19 WithBatteryValue, '可拆卸电池' WithBatteryName UNION ALL</div>~~
035+ <div>select top 0 19 WithBatteryValue, '可拆卸电池' WithBatteryName UNION ALL</div>
036- ~~<div>select top 0 20 WithBatteryValue, '厨具' WithBatteryName UNION ALL</div>~~
036+ <div>select top 0 20 WithBatteryValue, '厨具' WithBatteryName UNION ALL</div>
037- ~~<div>select top 0 21 WithBatteryValue, '电机_马达' WithBatteryName UNION ALL</div>~~
037+ <div>select top 0 21 WithBatteryValue, '电机_马达' WithBatteryName UNION ALL</div>
038- ~~<div>select top 0 22 WithBatteryValue, '超体积普' WithBatteryName UNION ALL</div>~~
038+ <div>select top 0 22 WithBatteryValue, '超体积普' WithBatteryName UNION ALL</div>
039- ~~<div>select top 0 23 WithBatteryValue, '超体积非普' WithBatteryName UNION ALL</div>~~
039+ <div>select top 0 23 WithBatteryValue, '超体积非普' WithBatteryName UNION ALL</div>
040- ~~<div>select top 0 24 WithBatteryValue, '手机' WithBatteryName UNION ALL</div>~~
040+ <div>select top 0 24 WithBatteryValue, '手机' WithBatteryName UNION ALL</div>
041- ~~<div>select top 0 25 WithBatteryValue, '平衡车' WithBatteryName UNION ALL</div>~~
041+ <div>select top 0 25 WithBatteryValue, '平衡车' WithBatteryName UNION ALL</div>
042- ~~<div>select top 0 26 WithBatteryValue, '液体笔类' WithBatteryName UNION ALL</div>~~
042+ <div>select top 0 26 WithBatteryValue, '液体笔类' WithBatteryName UNION ALL</div>
043- ~~<div>select top 0 27 WithBatteryValue, '纺织品' WithBatteryName UNION ALL</div>~~
043+ <div>select top 0 27 WithBatteryValue, '纺织品' WithBatteryName UNION ALL</div>
044- ~~<div>select top 0 28 WithBatteryValue, '植物种子' WithBatteryName UNION ALL</div>~~
044+ <div>select top 0 28 WithBatteryValue, '植物种子' WithBatteryName UNION ALL</div>
045- ~~<div>select top 0 29 WithBatteryValue, '深圳普货' WithBatteryName UNION ALL</div>~~
045+ <div>select top 0 29 WithBatteryValue, '深圳普货' WithBatteryName UNION ALL</div>
046- ~~<div>select top 0 30 WithBatteryValue, '成人用品' WithBatteryName UNION ALL</div>~~
046+ <div>select top 0 30 WithBatteryValue, '成人用品' WithBatteryName UNION ALL</div>
047- ~~<div>select top 0 31 WithBatteryValue, '无' WithBatteryName UNION ALL</div>~~
047+ <div>select top 0 31 WithBatteryValue, '无' WithBatteryName UNION ALL</div>
048- ~~<div>select top 0 32 WithBatteryValue, '眼镜' WithBatteryName UNION ALL</div>~~
048+ <div>select top 0 32 WithBatteryValue, '眼镜' WithBatteryName UNION ALL</div>
049- ~~<div>select top 0 33 WithBatteryValue, '口红' WithBatteryName UNION ALL</div>~~
049+ <div>select top 0 33 WithBatteryValue, '口红' WithBatteryName UNION ALL</div>
050- ~~<div>select top 0 34 WithBatteryValue, '手表' WithBatteryName UNION ALL</div>~~
050+ <div>select top 0 34 WithBatteryValue, '手表' WithBatteryName UNION ALL</div>
051- ~~<div>select top 0 35 WithBatteryValue, '香水' WithBatteryName UNION ALL</div>~~
051+ <div>select top 0 35 WithBatteryValue, '香水' WithBatteryName UNION ALL</div>
052- ~~<div>select top 0 36 WithBatteryValue, '纯液体' WithBatteryName UNION ALL</div>~~
052+ <div>select top 0 36 WithBatteryValue, '纯液体' WithBatteryName UNION ALL</div>
053- ~~<div>select top 0 37 WithBatteryValue, '医疗设备' WithBatteryName UNION ALL</div>~~
053+ <div>select top 0 37 WithBatteryValue, '医疗设备' WithBatteryName UNION ALL</div>
054- ~~<div>select top 0 38 WithBatteryValue, '人造羽毛' WithBatteryName UNION ALL</div>~~
054+ <div>select top 0 38 WithBatteryValue, '人造羽毛' WithBatteryName UNION ALL</div>
055- ~~<div>select top 0 39 WithBatteryValue, '内置锂金属电池' WithBatteryName UNION ALL</div>~~
055+ <div>select top 0 39 WithBatteryValue, '内置锂金属电池' WithBatteryName UNION ALL</div>
056- ~~<div>select top 0 40 WithBatteryValue, '配套干电池' WithBatteryName UNION ALL</div>~~
056+ <div>select top 0 40 WithBatteryValue, '配套干电池' WithBatteryName UNION ALL</div>
057- ~~<div>select top 0 41 WithBatteryValue, '厨房刀具' WithBatteryName UNION ALL</div>~~
057+ <div>select top 0 41 WithBatteryValue, '厨房刀具' WithBatteryName UNION ALL</div>
058- ~~<div>select top 0 42 WithBatteryValue, '军工刀具' WithBatteryName UNION ALL</div>~~
058+ <div>select top 0 42 WithBatteryValue, '军工刀具' WithBatteryName UNION ALL</div>
059- ~~<div>select top 0 45 WithBatteryValue, '无线充' WithBatteryName UNION ALL</div>~~
059+ <div>select top 0 45 WithBatteryValue, '无线充' WithBatteryName UNION ALL</div>
060- ~~<div>select top 0 46 WithBatteryValue, '原木' WithBatteryName UNION ALL</div>~~
060+ <div>select top 0 46 WithBatteryValue, '原木' WithBatteryName UNION ALL</div>
061- ~~<div>select top 0 47 WithBatteryValue, '面具类' WithBatteryName UNION ALL</div>~~
061+ <div>select top 0 47 WithBatteryValue, '面具类' WithBatteryName UNION ALL</div>
062- ~~<div>select top 0 48 WithBatteryValue, '金属高密度' WithBatteryName UNION ALL</div>~~
062+ <div>select top 0 48 WithBatteryValue, '金属高密度' WithBatteryName UNION ALL</div>
063- ~~<div>select top 0 49 WithBatteryValue, '防疫用品' WithBatteryName UNION ALL</div>~~
063+ <div>select top 0 49 WithBatteryValue, '防疫用品' WithBatteryName UNION ALL</div>
064- ~~<div>select top 0 50 WithBatteryValue, '酒精' WithBatteryName UNION ALL</div>~~
064+ <div>select top 0 50 WithBatteryValue, '酒精' WithBatteryName UNION ALL</div>
065- ~~<div>select top 0 51 WithBatteryValue, '酒精棉' WithBatteryName UNION ALL</div>~~
065+ <div>select top 0 51 WithBatteryValue, '酒精棉' WithBatteryName UNION ALL</div>
066- ~~<div>select top 0 52 WithBatteryValue, '纸巾' WithBatteryName UNION ALL</div>~~
066+ <div>select top 0 52 WithBatteryValue, '纸巾' WithBatteryName UNION ALL</div>
067- ~~<div>select top 0 100 WithBatteryValue, '风扇' WithBatteryName UNION ALL</div>~~
067+ <div>select top 0 100 WithBatteryValue, '风扇' WithBatteryName UNION ALL</div>
068- ~~<div>select top 0 0 WithBatteryValue, '未选择' WithBatteryName UNION ALL</div>~~
068+ <div>select top 0 0 WithBatteryValue, '未选择' WithBatteryName UNION ALL</div>
069- ~~<div>select top 0 101 WithBatteryValue, '水杯' WithBatteryName UNION ALL</div>~~
069+ <div>select top 0 101 WithBatteryValue, '水杯' WithBatteryName UNION ALL</div>
070- ~~<div>select top 0 102 WithBatteryValue, '测试' WithBatteryName UNION ALL</div>~~
070+ <div>select top 0 102 WithBatteryValue, '测试' WithBatteryName UNION ALL</div>
071- ~~<div>select top 0 103 WithBatteryValue, '面罩类' WithBatteryName UNION ALL</div>~~
071+ <div>select top 0 103 WithBatteryValue, '面罩类' WithBatteryName UNION ALL</div>
072- ~~<div>select top 0 104 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL</div>~~
072+ <div>select top 0 104 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL</div>
073- ~~<div>select top 0 105 WithBatteryValue, '食品' WithBatteryName UNION ALL</div>~~
073+ <div>select top 0 105 WithBatteryValue, '食品' WithBatteryName UNION ALL</div>
074- ~~<div>select top 0 106 WithBatteryValue, '颗粒状' WithBatteryName UNION ALL</div>~~
074+ <div>select top 0 106 WithBatteryValue, '颗粒状' WithBatteryName UNION ALL</div>
075- ~~<div>select top 0 107 WithBatteryValue, '药品' WithBatteryName UNION ALL</div>~~
075+ <div>select top 0 107 WithBatteryValue, '药品' WithBatteryName UNION ALL</div>
076- ~~<div>select top 0 108 WithBatteryValue, '头盔' WithBatteryName UNION ALL</div>~~
076+ <div>select top 0 108 WithBatteryValue, '头盔' WithBatteryName UNION ALL</div>
077- ~~<div>select top 0 109 WithBatteryValue, '纯普货' WithBatteryName UNION ALL</div>~~
077+ <div>select top 0 109 WithBatteryValue, '纯普货' WithBatteryName UNION ALL</div>
078- ~~<div>select top 0 110 WithBatteryValue, '尖锐利器' WithBatteryName UNION ALL</div>~~
078+ <div>select top 0 110 WithBatteryValue, '尖锐利器' WithBatteryName UNION ALL</div>
079- ~~<div>select top 0 111 WithBatteryValue, '无电池电子产品' WithBatteryName UNION ALL</div>~~
079+ <div>select top 0 111 WithBatteryValue, '无电池电子产品' WithBatteryName UNION ALL</div>
080- ~~<div>select top 0 112 WithBatteryValue, '内置纽扣电池' WithBatteryName UNION ALL</div>~~
080+ <div>select top 0 112 WithBatteryValue, '内置纽扣电池' WithBatteryName UNION ALL</div>
081- ~~<div>select top 0 113 WithBatteryValue, '内置柱状电池' WithBatteryName UNION ALL</div>~~
081+ <div>select top 0 113 WithBatteryValue, '内置柱状电池' WithBatteryName UNION ALL</div>
082- ~~<div>select top 0 114 WithBatteryValue, '内置块状电池' WithBatteryName UNION ALL</div>~~
082+ <div>select top 0 114 WithBatteryValue, '内置块状电池' WithBatteryName UNION ALL</div>
083- ~~<div>select top 0 115 WithBatteryValue, '其它内置电池' WithBatteryName UNION ALL</div>~~
083+ <div>select top 0 115 WithBatteryValue, '其它内置电池' WithBatteryName UNION ALL</div>
084- ~~<div>select top 0 116 WithBatteryValue, '配套纽扣电池' WithBatteryName UNION ALL</div>~~
084+ <div>select top 0 116 WithBatteryValue, '配套纽扣电池' WithBatteryName UNION ALL</div>
085- ~~<div>select top 0 117 WithBatteryValue, '配套柱状电池' WithBatteryName UNION ALL</div>~~
085+ <div>select top 0 117 WithBatteryValue, '配套柱状电池' WithBatteryName UNION ALL</div>
086- ~~<div>select top 0 118 WithBatteryValue, '配套块状电池' WithBatteryName UNION ALL</div>~~
086+ <div>select top 0 118 WithBatteryValue, '配套块状电池' WithBatteryName UNION ALL</div>
087- ~~<div>select top 0 119 WithBatteryValue, '其它配套电池' WithBatteryName UNION ALL</div>~~
087+ <div>select top 0 119 WithBatteryValue, '其它配套电池' WithBatteryName UNION ALL</div>
088- ~~<div>select top 0 120 WithBatteryValue, '纽扣电池' WithBatteryName UNION ALL</div>~~
088+ <div>select top 0 120 WithBatteryValue, '纽扣电池' WithBatteryName UNION ALL</div>
089- ~~<div>select top 0 121 WithBatteryValue, '柱状电池' WithBatteryName UNION ALL</div>~~
089+ <div>select top 0 121 WithBatteryValue, '柱状电池' WithBatteryName UNION ALL</div>
090- ~~<div>select top 0 122 WithBatteryValue, '块状电池' WithBatteryName UNION ALL</div>~~
090+ <div>select top 0 122 WithBatteryValue, '块状电池' WithBatteryName UNION ALL</div>
091- ~~<div>select top 0 123 WithBatteryValue, '其它纯电池' WithBatteryName UNION ALL</div>~~
091+ <div>select top 0 123 WithBatteryValue, '其它纯电池' WithBatteryName UNION ALL</div>
092- ~~<div>select top 0 124 WithBatteryValue, '易碎玻璃' WithBatteryName UNION ALL</div>~~
092+ <div>select top 0 124 WithBatteryValue, '易碎玻璃' WithBatteryName UNION ALL</div>
093- ~~<div>select top 0 125 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>~~
093+ <div>select top 0 125 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>
094- ~~<div>select top 0 126 WithBatteryValue, '微量膏体' WithBatteryName UNION ALL</div>~~
094+ <div>select top 0 126 WithBatteryValue, '微量膏体' WithBatteryName UNION ALL</div>
095- ~~<div>select top 0 127 WithBatteryValue, '其它膏体' WithBatteryName UNION ALL</div>~~
095+ <div>select top 0 127 WithBatteryValue, '其它膏体' WithBatteryName UNION ALL</div>
096- ~~<div>select top 0 128 WithBatteryValue, '微量粉末' WithBatteryName UNION ALL</div>~~
096+ <div>select top 0 128 WithBatteryValue, '微量粉末' WithBatteryName UNION ALL</div>
097- ~~<div>select top 0 129 WithBatteryValue, '其它粉末' WithBatteryName UNION ALL</div>~~
097+ <div>select top 0 129 WithBatteryValue, '其它粉末' WithBatteryName UNION ALL</div>
098- ~~<div>select top 0 130 WithBatteryValue, '微量液体' WithBatteryName UNION ALL</div>~~
098+ <div>select top 0 130 WithBatteryValue, '微量液体' WithBatteryName UNION ALL</div>
099- ~~<div>select top 0 131 WithBatteryValue, '少量液体' WithBatteryName UNION ALL</div>~~
099+ <div>select top 0 131 WithBatteryValue, '少量液体' WithBatteryName UNION ALL</div>
100- ~~<div>select top 0 132 WithBatteryValue, '较多液体' WithBatteryName UNION ALL</div>~~
100+ <div>select top 0 132 WithBatteryValue, '较多液体' WithBatteryName UNION ALL</div>
101- ~~<div>select top 0 133 WithBatteryValue, '其它液体' WithBatteryName UNION ALL</div>~~
101+ <div>select top 0 133 WithBatteryValue, '其它液体' WithBatteryName UNION ALL</div>
102- ~~<div>select top 0 134 WithBatteryValue, '办公刀具小尺寸' WithBatteryName UNION ALL</div>~~
102+ <div>select top 0 134 WithBatteryValue, '办公刀具小尺寸' WithBatteryName UNION ALL</div>
103- ~~<div>select top 0 135 WithBatteryValue, '办公刀具中尺寸' WithBatteryName UNION ALL</div>~~
103+ <div>select top 0 135 WithBatteryValue, '办公刀具中尺寸' WithBatteryName UNION ALL</div>
104- ~~<div>select top 0 136 WithBatteryValue, '办公刀具大尺寸' WithBatteryName UNION ALL</div>~~
104+ <div>select top 0 136 WithBatteryValue, '办公刀具大尺寸' WithBatteryName UNION ALL</div>
105- ~~<div>select top 0 137 WithBatteryValue, '厨房刀具小尺寸' WithBatteryName UNION ALL</div>~~
105+ <div>select top 0 137 WithBatteryValue, '厨房刀具小尺寸' WithBatteryName UNION ALL</div>
106- ~~<div>select top 0 138 WithBatteryValue, '厨房刀具中尺寸' WithBatteryName UNION ALL</div>~~
106+ <div>select top 0 138 WithBatteryValue, '厨房刀具中尺寸' WithBatteryName UNION ALL</div>
107- ~~<div>select top 0 139 WithBatteryValue, '厨房刀具大尺寸' WithBatteryName UNION ALL</div>~~
107+ <div>select top 0 139 WithBatteryValue, '厨房刀具大尺寸' WithBatteryName UNION ALL</div>
108- ~~<div>select top 0 140 WithBatteryValue, '户外刀具小尺寸' WithBatteryName UNION ALL</div>~~
108+ <div>select top 0 140 WithBatteryValue, '户外刀具小尺寸' WithBatteryName UNION ALL</div>
109- ~~<div>select top 0 141 WithBatteryValue, '户外刀具中尺寸' WithBatteryName UNION ALL</div>~~
109+ <div>select top 0 141 WithBatteryValue, '户外刀具中尺寸' WithBatteryName UNION ALL</div>
110- ~~<div>select top 0 142 WithBatteryValue, '户外刀具大尺寸' WithBatteryName UNION ALL</div>~~
110+ <div>select top 0 142 WithBatteryValue, '户外刀具大尺寸' WithBatteryName UNION ALL</div>
111- ~~<div>select top 0 143 WithBatteryValue, '间谍器材' WithBatteryName UNION ALL</div>~~
111+ <div>select top 0 143 WithBatteryValue, '间谍器材' WithBatteryName UNION ALL</div>
112- ~~<div>select top 0 144 WithBatteryValue, '其它易燃易爆' WithBatteryName UNION ALL</div>~~
112+ <div>select top 0 144 WithBatteryValue, '其它易燃易爆' WithBatteryName UNION ALL</div>
113- ~~<div>select top 0 145 WithBatteryValue, '管制刀具小尺寸' WithBatteryName UNION ALL</div>~~
113+ <div>select top 0 145 WithBatteryValue, '管制刀具小尺寸' WithBatteryName UNION ALL</div>
114- ~~<div>select top 0 146 WithBatteryValue, '其它管制器具' WithBatteryName UNION ALL</div>~~
114+ <div>select top 0 146 WithBatteryValue, '其它管制器具' WithBatteryName UNION ALL</div>
115- ~~<div>select top 0 147 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL</div>~~
115+ <div>select top 0 147 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL</div>
116- ~~<div>select top 0 148 WithBatteryValue, '其它禁寄物品' WithBatteryName UNION ALL</div>~~
116+ <div>select top 0 148 WithBatteryValue, '其它禁寄物品' WithBatteryName UNION ALL</div>
117- ~~<div>select top 0 149 WithBatteryValue, '111' WithBatteryName UNION ALL</div>~~
117+ <div>select top 0 149 WithBatteryValue, '111' WithBatteryName UNION ALL</div>
118- ~~<div>select top 0 150 WithBatteryValue, '其它泛普货' WithBatteryName UNION ALL</div>~~
118+ <div>select top 0 150 WithBatteryValue, '其它泛普货' WithBatteryName UNION ALL</div>
119- ~~<div>select top 0 151 WithBatteryValue, '虎指' WithBatteryName UNION ALL</div>~~
119+ <div>select top 0 151 WithBatteryValue, '虎指' WithBatteryName UNION ALL</div>
120- ~~<div>select top 0 152 WithBatteryValue, '甩棍' WithBatteryName UNION ALL</div>~~
120+ <div>select top 0 152 WithBatteryValue, '甩棍' WithBatteryName UNION ALL</div>
121- ~~<div>select top 0 153 WithBatteryValue, '弓弩' WithBatteryName UNION ALL</div>~~
121+ <div>select top 0 153 WithBatteryValue, '弓弩' WithBatteryName UNION ALL</div>
122- ~~<div>select top 0 154 WithBatteryValue, '金属大体积' WithBatteryName UNION ALL</div>~~
122+ <div>select top 0 154 WithBatteryValue, '金属大体积' WithBatteryName UNION ALL</div>
123- ~~<div>select top 0 155 WithBatteryValue, '迷你蓝牙耳机' WithBatteryName UNION ALL</div>~~
123+ <div>select top 0 155 WithBatteryValue, '迷你蓝牙耳机' WithBatteryName UNION ALL</div>
124- ~~<div>select top 0 156 WithBatteryValue, '其它蓝牙耳机' WithBatteryName UNION ALL</div>~~
124+ <div>select top 0 156 WithBatteryValue, '其它蓝牙耳机' WithBatteryName UNION ALL</div>
125- ~~<div>select top 0 157 WithBatteryValue, '迷你蓝牙音响' WithBatteryName UNION ALL</div>~~
125+ <div>select top 0 157 WithBatteryValue, '迷你蓝牙音响' WithBatteryName UNION ALL</div>
126- ~~<div>select top 0 158 WithBatteryValue, '其它蓝牙音响' WithBatteryName UNION ALL</div>~~
126+ <div>select top 0 158 WithBatteryValue, '其它蓝牙音响' WithBatteryName UNION ALL</div>
127- ~~<div>select top 0 159 WithBatteryValue, '迷你移动电源' WithBatteryName UNION ALL</div>~~
127+ <div>select top 0 159 WithBatteryValue, '迷你移动电源' WithBatteryName UNION ALL</div>
128- ~~<div>select top 0 160 WithBatteryValue, '其它移动电源' WithBatteryName UNION ALL</div>~~
128+ <div>select top 0 160 WithBatteryValue, '其它移动电源' WithBatteryName UNION ALL</div>
129- ~~<div>select top 0 161 WithBatteryValue, '其它带磁带电' WithBatteryName UNION ALL</div>~~
129+ <div>select top 0 161 WithBatteryValue, '其它带磁带电' WithBatteryName UNION ALL</div>
130- ~~<div>select top 0 162 WithBatteryValue, '微量固体' WithBatteryName UNION ALL</div>~~
130+ <div>select top 0 162 WithBatteryValue, '微量固体' WithBatteryName UNION ALL</div>
131- ~~<div>select top 0 163 WithBatteryValue, '其它固体' WithBatteryName UNION ALL</div>~~
131+ <div>select top 0 163 WithBatteryValue, '其它固体' WithBatteryName UNION ALL</div>
132- ~~<div>select top 0 164 WithBatteryValue, '打火石' WithBatteryName UNION ALL</div>~~
132+ <div>select top 0 164 WithBatteryValue, '打火石' WithBatteryName UNION ALL</div>
133- ~~<div>select top 0 165 WithBatteryValue, '指甲油' WithBatteryName UNION ALL</div>~~
133+ <div>select top 0 165 WithBatteryValue, '指甲油' WithBatteryName UNION ALL</div>
134- ~~<div>select top 0 166 WithBatteryValue, '香水' WithBatteryName UNION ALL</div>~~
134+ <div>select top 0 166 WithBatteryValue, '香水' WithBatteryName UNION ALL</div>
135- ~~<div>select top 0 167 WithBatteryValue, '管制刀具中尺寸' WithBatteryName UNION ALL</div>~~
135+ <div>select top 0 167 WithBatteryValue, '管制刀具中尺寸' WithBatteryName UNION ALL</div>
136- ~~<div>select top 0 168 WithBatteryValue, '管制刀具大尺寸' WithBatteryName UNION ALL</div>~~
136+ <div>select top 0 168 WithBatteryValue, '管制刀具大尺寸' WithBatteryName UNION ALL</div>
137- ~~<div>select top 0 169 WithBatteryValue, '微量胶体' WithBatteryName UNION ALL</div>~~
137+ <div>select top 0 169 WithBatteryValue, '微量胶体' WithBatteryName UNION ALL</div>
138- ~~<div>select top 0 170 WithBatteryValue, '' WithBatteryName UNION ALL</div>~~
138+ <div>select top 0 170 WithBatteryValue, '' WithBatteryName UNION ALL</div>
139- ~~<div>select top 0 171 WithBatteryValue, '较多胶体' WithBatteryName UNION ALL</div>~~
139+ <div>select top 0 171 WithBatteryValue, '较多胶体' WithBatteryName UNION ALL</div>
140- ~~<div>select top 0 172 WithBatteryValue, '其它胶体' WithBatteryName UNION ALL</div>~~
140+ <div>select top 0 172 WithBatteryValue, '其它胶体' WithBatteryName UNION ALL</div>
141- ~~<div>select top 0 173 WithBatteryValue, '哈哈哈哈' WithBatteryName UNION ALL</div>~~
141+ <div>select top 0 173 WithBatteryValue, '哈哈哈哈' WithBatteryName UNION ALL</div>
142- ~~<div>select top 0 174 WithBatteryValue, '口罩' WithBatteryName UNION ALL</div>~~
142+ <div>select top 0 174 WithBatteryValue, '口罩' WithBatteryName UNION ALL</div>
143- ~~<div>select top 0 175 WithBatteryValue, '李英' WithBatteryName UNION ALL</div>~~
143+ <div>select top 0 175 WithBatteryValue, '李英' WithBatteryName UNION ALL</div>
144- ~~<div>select top 0 176 WithBatteryValue, '蜡烛' WithBatteryName UNION ALL</div>~~
144+ <div>select top 0 176 WithBatteryValue, '蜡烛' WithBatteryName UNION ALL</div>
145- ~~<div>select top 0 177 WithBatteryValue, '剪刀' WithBatteryName UNION ALL</div>~~
145+ <div>select top 0 177 WithBatteryValue, '剪刀' WithBatteryName UNION ALL</div>
146- ~~<div>select top 0 178 WithBatteryValue, '单边超过40cm抛货带磁' WithBatteryName UNION ALL</div>~~
146+ <div>select top 0 178 WithBatteryValue, '单边超过40cm抛货带磁' WithBatteryName UNION ALL</div>
147- ~~<div>select top 0 179 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>~~
147+ <div>select top 0 179 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>
148- ~~<div>select top 0 180 WithBatteryValue, '单边超过40cm抛货普货' WithBatteryName UNION ALL</div>~~
148+ <div>select top 0 180 WithBatteryValue, '单边超过40cm抛货普货' WithBatteryName UNION ALL</div>
149- ~~<div>select top 0 181 WithBatteryValue, '单边超过40cm抛货特货' WithBatteryName UNION ALL</div>~~
149+ <div>select top 0 181 WithBatteryValue, '单边超过40cm抛货特货' WithBatteryName UNION ALL</div>
150- ~~<div>select top 0 182 WithBatteryValue, '利器' WithBatteryName UNION ALL</div>~~
150+ <div>select top 0 182 WithBatteryValue, '利器' WithBatteryName UNION ALL</div>
151- ~~<div>select top 0 183 WithBatteryValue, '刀' WithBatteryName UNION ALL</div>~~
151+ <div>select top 0 183 WithBatteryValue, '刀' WithBatteryName UNION ALL</div>
152- ~~<div>select top 0 184 WithBatteryValue, '抛货特货' WithBatteryName UNION ALL</div>~~
152+ <div>select top 0 184 WithBatteryValue, '抛货特货' WithBatteryName UNION ALL</div>
153- ~~<div>select top 0 185 WithBatteryValue, '抛货普货' WithBatteryName UNION ALL</div>~~
153+ <div>select top 0 185 WithBatteryValue, '抛货普货' WithBatteryName UNION ALL</div>
154- ~~<div>select top 0 186 WithBatteryValue, '抛货带磁' WithBatteryName UNION ALL</div>~~
154+ <div>select top 0 186 WithBatteryValue, '抛货带磁' WithBatteryName UNION ALL</div>
155- ~~<div>select top 0 187 WithBatteryValue, '抛货纽扣电池' WithBatteryName UNION ALL</div>~~
155+ <div>select top 0 187 WithBatteryValue, '抛货纽扣电池' WithBatteryName UNION ALL</div>
156- ~~<div>select top 0 188 WithBatteryValue, '单边超过40cm抛货纽扣电池' WithBatteryName UNION ALL</div>~~
156+ <div>select top 0 188 WithBatteryValue, '单边超过40cm抛货纽扣电池' WithBatteryName UNION ALL</div>
157- ~~<div>select top 0 189 WithBatteryValue, '自定义-液体' WithBatteryName UNION ALL</div>~~
157+ <div>select top 0 189 WithBatteryValue, '自定义-液体' WithBatteryName UNION ALL</div>
158- ~~<div>select top 0 190 WithBatteryValue, '面膜鼻膜眼膜胸膜' WithBatteryName UNION ALL</div>~~
158+ <div>select top 0 190 WithBatteryValue, '面膜鼻膜眼膜胸膜' WithBatteryName UNION ALL</div>
159- ~~<div>select top 0 191 WithBatteryValue, '办公刀具超大尺寸' WithBatteryName UNION ALL</div>~~
159+ <div>select top 0 191 WithBatteryValue, '办公刀具超大尺寸' WithBatteryName UNION ALL</div>
160- ~~<div>select top 0 192 WithBatteryValue, '厨房刀具超大尺寸' WithBatteryName UNION ALL</div>~~
160+ <div>select top 0 192 WithBatteryValue, '厨房刀具超大尺寸' WithBatteryName UNION ALL</div>
161- ~~<div>select top 0 193 WithBatteryValue, '户外刀具超大尺寸' WithBatteryName UNION ALL</div>~~
161+ <div>select top 0 193 WithBatteryValue, '户外刀具超大尺寸' WithBatteryName UNION ALL</div>
162- ~~<div>select top 0 194 WithBatteryValue, '管制刀具超大尺寸' WithBatteryName UNION ALL</div>~~
162+ <div>select top 0 194 WithBatteryValue, '管制刀具超大尺寸' WithBatteryName UNION ALL</div>
163- ~~<div>select top 0 195 WithBatteryValue, '内电打火机' WithBatteryName UNION ALL</div>~~
163+ <div>select top 0 195 WithBatteryValue, '内电打火机' WithBatteryName UNION ALL</div>
164- ~~<div>select top 0 196 WithBatteryValue, '压电打火机' WithBatteryName UNION ALL</div>~~
164+ <div>select top 0 196 WithBatteryValue, '压电打火机' WithBatteryName UNION ALL</div>
165- ~~<div>select top 0 197 WithBatteryValue, '火石打火机' WithBatteryName UNION ALL</div>~~
165+ <div>select top 0 197 WithBatteryValue, '火石打火机' WithBatteryName UNION ALL</div>
166- ~~<div>select top 0 198 WithBatteryValue, '超重超大件普货' WithBatteryName UNION ALL</div>~~
166+ <div>select top 0 198 WithBatteryValue, '超重超大件普货' WithBatteryName UNION ALL</div>
167- ~~<div>select top 0 199 WithBatteryValue, '超重超大件非普货' WithBatteryName UNION ALL</div>~~
167+ <div>select top 0 199 WithBatteryValue, '超重超大件非普货' WithBatteryName UNION ALL</div>
168- ~~<div>select top 0 200 WithBatteryValue, '自定义-纯电池' WithBatteryName UNION ALL</div>~~
168+ <div>select top 0 200 WithBatteryValue, '自定义-纯电池' WithBatteryName UNION ALL</div>
169- ~~<div>select top 0 201 WithBatteryValue, '自定义-带外置电池' WithBatteryName UNION ALL</div>~~
169+ <div>select top 0 201 WithBatteryValue, '自定义-带外置电池' WithBatteryName UNION ALL</div>
170- ~~<div>select top 0 202 WithBatteryValue, '内置电池-自定义' WithBatteryName UNION ALL</div>~~
170+ <div>select top 0 202 WithBatteryValue, '内置电池-自定义' WithBatteryName UNION ALL</div>
171- ~~<div>select top 0 203 WithBatteryValue, '自定义-膏体' WithBatteryName UNION ALL</div>~~
171+ <div>select top 0 203 WithBatteryValue, '自定义-膏体' WithBatteryName UNION ALL</div>
172- ~~<div>select top 0 204 WithBatteryValue, '自定义-粉末' WithBatteryName UNION ALL</div>~~
172+ <div>select top 0 204 WithBatteryValue, '自定义-粉末' WithBatteryName UNION ALL</div>
173- ~~<div>select top 0 205 WithBatteryValue, '自定义-带磁' WithBatteryName UNION ALL</div>~~
173+ <div>select top 0 205 WithBatteryValue, '自定义-带磁' WithBatteryName UNION ALL</div>
174- ~~<div>select top 0 206 WithBatteryValue, '自定义-电机马达' WithBatteryName UNION ALL</div>~~
174+ <div>select top 0 206 WithBatteryValue, '自定义-电机马达' WithBatteryName UNION ALL</div>
175- ~~<div>select top 0 207 WithBatteryValue, '反倾销属性' WithBatteryName UNION ALL</div>~~
175+ <div>select top 0 207 WithBatteryValue, '反倾销属性' WithBatteryName UNION ALL</div>
176- ~~<div>select top 0 208 WithBatteryValue, '自主加工' WithBatteryName UNION ALL</div>~~
176+ <div>select top 0 208 WithBatteryValue, '自主加工' WithBatteryName UNION ALL</div>
177- ~~<div>select top 0 209 WithBatteryValue, '弱磁' WithBatteryName UNION ALL</div>~~
177+ <div>select top 0 209 WithBatteryValue, '弱磁' WithBatteryName UNION ALL</div>
178- ~~<div>select top 0 210 WithBatteryValue, '液体&带电' WithBatteryName UNION ALL</div>~~
178+ <div>select top 0 210 WithBatteryValue, '液体&带电' WithBatteryName UNION ALL</div>
179- ~~<div>select top 0 211 WithBatteryValue, '液体（不带电）' WithBatteryName UNION ALL</div>~~
179+ <div>select top 0 211 WithBatteryValue, '液体（不带电）' WithBatteryName UNION ALL</div>
180- ~~<div>select top 0 212 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL</div>~~
180+ <div>select top 0 212 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL</div>
181- ~~<div>select top 0 213 WithBatteryValue, '口红液体' WithBatteryName UNION ALL</div>~~
181+ <div>select top 0 213 WithBatteryValue, '口红液体' WithBatteryName UNION ALL</div>
182- ~~<div>select top 0 214 WithBatteryValue, '口红膏体' WithBatteryName UNION ALL</div>~~
182+ <div>select top 0 214 WithBatteryValue, '口红膏体' WithBatteryName UNION ALL</div>
183- ~~<div>select top 0 215 WithBatteryValue, '测试物流属性' WithBatteryName UNION ALL</div>~~
183+ <div>select top 0 215 WithBatteryValue, '测试物流属性' WithBatteryName UNION ALL</div>
184- ~~<div>select top 0 216 WithBatteryValue, '612' WithBatteryName UNION ALL</div>~~
184+ <div>select top 0 216 WithBatteryValue, '612' WithBatteryName UNION ALL</div>
185- ~~<div>select top 0 217 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL</div>~~
185+ <div>select top 0 217 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL</div>
186- ~~<div>select top 0 218 WithBatteryValue, '较多膏体' WithBatteryName UNION ALL</div>~~
186+ <div>select top 0 218 WithBatteryValue, '较多膏体' WithBatteryName UNION ALL</div>
187- ~~<div>select top 0 219 WithBatteryValue, '少量膏体' WithBatteryName UNION ALL</div>~~
187+ <div>select top 0 219 WithBatteryValue, '少量膏体' WithBatteryName UNION ALL</div>
188- ~~<div>select top 0 220 WithBatteryValue, '较多固体' WithBatteryName UNION ALL</div>~~
188+ <div>select top 0 220 WithBatteryValue, '较多固体' WithBatteryName UNION ALL</div>
189- ~~<div>select top 0 221 WithBatteryValue, '少量固体' WithBatteryName UNION ALL</div>~~
189+ <div>select top 0 221 WithBatteryValue, '少量固体' WithBatteryName UNION ALL</div>
190- ~~<div>select top 0 222 WithBatteryValue, '较多粉末' WithBatteryName UNION ALL</div>~~
190+ <div>select top 0 222 WithBatteryValue, '较多粉末' WithBatteryName UNION ALL</div>
191- ~~<div>select top 0 223 WithBatteryValue, '少量粉末' WithBatteryName UNION ALL</div>~~
191+ <div>select top 0 223 WithBatteryValue, '少量粉末' WithBatteryName UNION ALL</div>
192- ~~<div>select top 0 224 WithBatteryValue, '机械手表' WithBatteryName UNION ALL</div>~~
192+ <div>select top 0 224 WithBatteryValue, '机械手表' WithBatteryName UNION ALL</div>
193- ~~<div>select top 0 225 WithBatteryValue, '电子手表' WithBatteryName UNION ALL</div>~~
193+ <div>select top 0 225 WithBatteryValue, '电子手表' WithBatteryName UNION ALL</div>
194- ~~<div>select top 0 226 WithBatteryValue, '智能手表' WithBatteryName UNION ALL</div>~~
194+ <div>select top 0 226 WithBatteryValue, '智能手表' WithBatteryName UNION ALL</div>
195- ~~<div>select top 0 227 WithBatteryValue, '智能手环' WithBatteryName UNION ALL</div>~~
195+ <div>select top 0 227 WithBatteryValue, '智能手环' WithBatteryName UNION ALL</div>
196- ~~<div>select top 0 228 WithBatteryValue, '饼状' WithBatteryName UNION ALL</div>~~
196+ <div>select top 0 228 WithBatteryValue, '饼状' WithBatteryName UNION ALL</div>
197- ~~<div>select top 0 229 WithBatteryValue, '干花' WithBatteryName UNION ALL</div>~~
197+ <div>select top 0 229 WithBatteryValue, '干花' WithBatteryName UNION ALL</div>
198- ~~<div>select top 0 230 WithBatteryValue, '枕头支架' WithBatteryName UNION ALL</div>~~
198+ <div>select top 0 230 WithBatteryValue, '枕头支架' WithBatteryName UNION ALL</div>
199- ~~<div>select top 0 231 WithBatteryValue, 'NS-超体积普' WithBatteryName UNION ALL</div>~~
199+ <div>select top 0 231 WithBatteryValue, 'NS-超体积普' WithBatteryName UNION ALL</div>
200- ~~<div>select top 0 232 WithBatteryValue, '抛物' WithBatteryName UNION ALL</div>~~
200+ <div>select top 0 232 WithBatteryValue, '抛物' WithBatteryName UNION ALL</div>
201- ~~<div>select top 0 233 WithBatteryValue, '口罩' WithBatteryName UNION ALL</div>~~
201+ <div>select top 0 233 WithBatteryValue, '口罩' WithBatteryName UNION ALL</div>
202- ~~<div>select top 0 234 WithBatteryValue, '哑铃（10KG+）' WithBatteryName UNION ALL</div>~~
202+ <div>select top 0 234 WithBatteryValue, '哑铃（10KG+）' WithBatteryName UNION ALL</div>
203- ~~<div>select top 0 235 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL</div>~~
203+ <div>select top 0 235 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL</div>
204- ~~<div>select top 0 236 WithBatteryValue, '蜡烛类' WithBatteryName UNION ALL</div>~~
204+ <div>select top 0 236 WithBatteryValue, '蜡烛类' WithBatteryName UNION ALL</div>
205- ~~<div>select top 0 237 WithBatteryValue, '无电池' WithBatteryName UNION ALL</div>~~
205+ <div>select top 0 237 WithBatteryValue, '无电池' WithBatteryName UNION ALL</div>
206- ~~<div>select top 0 238 WithBatteryValue, '轻抛类' WithBatteryName UNION ALL</div>~~
206+ <div>select top 0 238 WithBatteryValue, '轻抛类' WithBatteryName UNION ALL</div>
207- ~~<div>select top 0 239 WithBatteryValue, '高价值产品' WithBatteryName UNION ALL</div>~~
207+ <div>select top 0 239 WithBatteryValue, '高价值产品' WithBatteryName UNION ALL</div>
208- ~~<div>select top 0 240 WithBatteryValue, '蓝牙产品' WithBatteryName UNION ALL</div>~~
208+ <div>select top 0 240 WithBatteryValue, '蓝牙产品' WithBatteryName UNION ALL</div>
209- ~~<div>select top 0 241 WithBatteryValue, 'FDA产品' WithBatteryName UNION ALL</div>~~
209+ <div>select top 0 241 WithBatteryValue, 'FDA产品' WithBatteryName UNION ALL</div>
210- ~~<div>select top 0 242 WithBatteryValue, 'HDMI产品' WithBatteryName UNION ALL</div>~~
210+ <div>select top 0 242 WithBatteryValue, 'HDMI产品' WithBatteryName UNION ALL</div>
211- ~~<div>select top 0 243 WithBatteryValue, '儿童玩具' WithBatteryName UNION ALL</div>~~
211+ <div>select top 0 243 WithBatteryValue, '儿童玩具' WithBatteryName UNION ALL</div>
212- ~~<div>select top 0 244 WithBatteryValue, '磁铁' WithBatteryName UNION ALL</div>~~
212+ <div>select top 0 244 WithBatteryValue, '磁铁' WithBatteryName UNION ALL</div>
213- ~~<div>select top 0 245 WithBatteryValue, '木制品（无熏蒸）' WithBatteryName UNION ALL</div>~~
213+ <div>select top 0 245 WithBatteryValue, '木制品（无熏蒸）' WithBatteryName UNION ALL</div>
214- ~~<div>select top 0 246 WithBatteryValue, '特定磁性产品（含电机以及马达）' WithBatteryName UNION ALL</div>~~
214+ <div>select top 0 246 WithBatteryValue, '特定磁性产品（含电机以及马达）' WithBatteryName UNION ALL</div>
215- ~~<div>select top 0 247 WithBatteryValue, '食品' WithBatteryName UNION ALL</div>~~
215+ <div>select top 0 247 WithBatteryValue, '食品' WithBatteryName UNION ALL</div>
216- ~~<div>select top 0 248 WithBatteryValue, '口罩' WithBatteryName UNION ALL</div>~~
216+ <div>select top 0 248 WithBatteryValue, '口罩' WithBatteryName UNION ALL</div>
217- ~~<div>select top 0 249 WithBatteryValue, '洗手液' WithBatteryName UNION ALL</div>~~
217+ <div>select top 0 249 WithBatteryValue, '洗手液' WithBatteryName UNION ALL</div>
218- ~~<div>select top 0 250 WithBatteryValue, '温度计/额湿枪' WithBatteryName UNION ALL</div>~~
218+ <div>select top 0 250 WithBatteryValue, '温度计/额湿枪' WithBatteryName UNION ALL</div>
219- ~~<div>select top 0 251 WithBatteryValue, '医用手套/鞋套' WithBatteryName UNION ALL</div>~~
219+ <div>select top 0 251 WithBatteryValue, '医用手套/鞋套' WithBatteryName UNION ALL</div>
220- ~~<div>select top 0 252 WithBatteryValue, '护目镜' WithBatteryName UNION ALL</div>~~
220+ <div>select top 0 252 WithBatteryValue, '护目镜' WithBatteryName UNION ALL</div>
221- ~~<div>select top 0 253 WithBatteryValue, '防护服' WithBatteryName UNION ALL</div>~~
221+ <div>select top 0 253 WithBatteryValue, '防护服' WithBatteryName UNION ALL</div>
222- ~~<div>select top 0 254 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL</div>~~
222+ <div>select top 0 254 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL</div>
223- ~~<div>select top 0 255 WithBatteryValue, '管制刀具' WithBatteryName UNION ALL</div>~~
223+ <div>select top 0 255 WithBatteryValue, '管制刀具' WithBatteryName UNION ALL</div>
224- ~~<div>select top 0 256 WithBatteryValue, '特殊尖锐器具' WithBatteryName UNION ALL</div>~~
224+ <div>select top 0 256 WithBatteryValue, '特殊尖锐器具' WithBatteryName UNION ALL</div>
225- ~~<div>select top 0 257 WithBatteryValue, '易燃易爆品' WithBatteryName UNION ALL</div>~~
225+ <div>select top 0 257 WithBatteryValue, '易燃易爆品' WithBatteryName UNION ALL</div>
226- ~~<div>select top 0 258 WithBatteryValue, '刺激气味产品' WithBatteryName UNION ALL</div>~~
226+ <div>select top 0 258 WithBatteryValue, '刺激气味产品' WithBatteryName UNION ALL</div>
227- ~~<div>select top 0 259 WithBatteryValue, '指甲油产品' WithBatteryName UNION ALL</div>~~
227+ <div>select top 0 259 WithBatteryValue, '指甲油产品' WithBatteryName UNION ALL</div>
228- ~~<div>select top 0 260 WithBatteryValue, '气雾产品' WithBatteryName UNION ALL</div>~~
228+ <div>select top 0 260 WithBatteryValue, '气雾产品' WithBatteryName UNION ALL</div>
229- ~~<div>select top 0 261 WithBatteryValue, '枪支配件' WithBatteryName UNION ALL</div>~~
229+ <div>select top 0 261 WithBatteryValue, '枪支配件' WithBatteryName UNION ALL</div>
230- ~~<div>select top 0 262 WithBatteryValue, '带电，带磁' WithBatteryName UNION ALL</div>~~
230+ <div>select top 0 262 WithBatteryValue, '带电，带磁' WithBatteryName UNION ALL</div>
231- ~~<div>select top 0 263 WithBatteryValue, 'NS-刀具_剪刀' WithBatteryName UNION ALL</div>~~
231+ <div>select top 0 263 WithBatteryValue, 'NS-刀具_剪刀' WithBatteryName UNION ALL</div>
232- ~~<div>select top 0 264 WithBatteryValue, 'NS-粉末' WithBatteryName UNION ALL</div>~~
232+ <div>select top 0 264 WithBatteryValue, 'NS-粉末' WithBatteryName UNION ALL</div>
233- ~~<div>select top 0 265 WithBatteryValue, 'NS-超体积非普' WithBatteryName UNION ALL</div>~~
233+ <div>select top 0 265 WithBatteryValue, 'NS-超体积非普' WithBatteryName UNION ALL</div>
234- ~~<div>select top 0 266 WithBatteryValue, '黄毛' WithBatteryName UNION ALL</div>~~
234+ <div>select top 0 266 WithBatteryValue, '黄毛' WithBatteryName UNION ALL</div>
235- ~~<div>select top 0 267 WithBatteryValue, '黄毛3' WithBatteryName UNION ALL</div>~~
235+ <div>select top 0 267 WithBatteryValue, '黄毛3' WithBatteryName UNION ALL</div>
236- ~~<div>select top 0 268 WithBatteryValue, '食品接触类' WithBatteryName UNION ALL</div>~~
236+ <div>select top 0 268 WithBatteryValue, '食品接触类' WithBatteryName UNION ALL</div>
237- ~~<div>select top 0 269 WithBatteryValue, '带电成人用品' WithBatteryName UNION ALL</div>~~
237+ <div>select top 0 269 WithBatteryValue, '带电成人用品' WithBatteryName UNION ALL</div>
238- ~~<div>select top 0 270 WithBatteryValue, '无电成人用品' WithBatteryName UNION ALL</div>~~
238+ <div>select top 0 270 WithBatteryValue, '无电成人用品' WithBatteryName UNION ALL</div>
239- ~~<div>select top 0 271 WithBatteryValue, '活性炭' WithBatteryName UNION ALL</div>~~
239+ <div>select top 0 271 WithBatteryValue, '活性炭' WithBatteryName UNION ALL</div>
240- ~~<div>select top 0 272 WithBatteryValue, '纪念币' WithBatteryName UNION ALL</div>~~
240+ <div>select top 0 272 WithBatteryValue, '纪念币' WithBatteryName UNION ALL</div>
241- ~~<div>select top 0 273 WithBatteryValue, '颗粒物' WithBatteryName UNION ALL</div>~~
241+ <div>select top 0 273 WithBatteryValue, '颗粒物' WithBatteryName UNION ALL</div>
242- ~~<div>select top 0 274 WithBatteryValue, '测试' WithBatteryName UNION ALL</div>~~
242+ <div>select top 0 274 WithBatteryValue, '测试' WithBatteryName UNION ALL</div>
243- ~~<div>select top 0 275 WithBatteryValue, 'LED灯（不带电）' WithBatteryName UNION ALL</div>~~
243+ <div>select top 0 275 WithBatteryValue, 'LED灯（不带电）' WithBatteryName UNION ALL</div>
244- ~~<div>select top 0 276 WithBatteryValue, '仿枪支弹药' WithBatteryName UNION ALL</div>~~
244+ <div>select top 0 276 WithBatteryValue, '仿枪支弹药' WithBatteryName UNION ALL</div>
245- ~~<div>select top 0 277 WithBatteryValue, '打火石' WithBatteryName UNION ALL</div>~~
245+ <div>select top 0 277 WithBatteryValue, '打火石' WithBatteryName UNION ALL</div>
246- ~~<div>select top 0 278 WithBatteryValue, '气体' WithBatteryName UNION ALL</div>~~
246+ <div>select top 0 278 WithBatteryValue, '气体' WithBatteryName UNION ALL</div>
247- ~~<div>select top 0 279 WithBatteryValue, '1111' WithBatteryName UNION ALL</div>~~
247+ <div>select top 0 279 WithBatteryValue, '1111' WithBatteryName UNION ALL</div>
248- ~~<div>select top 0 280 WithBatteryValue, '1111' WithBatteryName UNION ALL</div>~~
248+ <div>select top 0 280 WithBatteryValue, '1111' WithBatteryName UNION ALL</div>
249- ~~<div>select top 0 281 WithBatteryValue, '555' WithBatteryName UNION ALL</div>~~
249+ <div>select top 0 281 WithBatteryValue, '555' WithBatteryName UNION ALL</div>
250- ~~<div>select top 0 282 WithBatteryValue, '武器' WithBatteryName UNION ALL</div>~~
250+ <div>select top 0 282 WithBatteryValue, '武器' WithBatteryName UNION ALL</div>
251- ~~<div>select top 0 283 WithBatteryValue, '上海普货' WithBatteryName UNION ALL</div>~~
251+ <div>select top 0 283 WithBatteryValue, '上海普货' WithBatteryName UNION ALL</div>
252- ~~<div>select top 0 284 WithBatteryValue, '沙子-敏感货' WithBatteryName UNION ALL</div>~~
252+ <div>select top 0 284 WithBatteryValue, '沙子-敏感货' WithBatteryName UNION ALL</div>
253- ~~<div>select top 0 285 WithBatteryValue, '敏感货' WithBatteryName UNION ALL</div>~~
253+ <div>select top 0 285 WithBatteryValue, '敏感货' WithBatteryName UNION ALL</div>
254- ~~<div>select top 0 286 WithBatteryValue, '违禁品' WithBatteryName UNION ALL</div>~~
254+ <div>select top 0 286 WithBatteryValue, '违禁品' WithBatteryName UNION ALL</div>
255- ~~<div>select top 0 287 WithBatteryValue, '普货物流灰' WithBatteryName UNION ALL</div>~~
255+ <div>select top 0 287 WithBatteryValue, '普货物流灰' WithBatteryName UNION ALL</div>
256- ~~<div>select top 0 288 WithBatteryValue, '带电物流灰' WithBatteryName UNION ALL</div>~~
256+ <div>select top 0 288 WithBatteryValue, '带电物流灰' WithBatteryName UNION ALL</div>
257- ~~<div>select top 0 289 WithBatteryValue, '你说是什么就是什么' WithBatteryName UNION ALL</div>~~
257+ <div>select top 0 289 WithBatteryValue, '你说是什么就是什么' WithBatteryName UNION ALL</div>
258- ~~<div>select top 0 290 WithBatteryValue, '打火石' WithBatteryName UNION ALL</div>~~
258+ <div>select top 0 290 WithBatteryValue, '打火石' WithBatteryName UNION ALL</div>
259- ~~<div>select top 0 291 WithBatteryValue, '干燥剂' WithBatteryName UNION ALL</div>~~
259+ <div>select top 0 291 WithBatteryValue, '干燥剂' WithBatteryName UNION ALL</div>
260- ~~<div>select top 0 292 WithBatteryValue, '硬币' WithBatteryName UNION ALL</div>~~
260+ <div>select top 0 292 WithBatteryValue, '硬币' WithBatteryName UNION ALL</div>
261- ~~<div>select top 0 293 WithBatteryValue, '测试' WithBatteryName UNION ALL</div>~~
261+ <div>select top 0 293 WithBatteryValue, '测试' WithBatteryName UNION ALL</div>
262- ~~<div>select top 0 294 WithBatteryValue, '内置电池+粉末' WithBatteryName UNION ALL</div>~~
262+ <div>select top 0 294 WithBatteryValue, '内置电池+粉末' WithBatteryName UNION ALL</div>
263- ~~<div>select top 0 295 WithBatteryValue, '迷彩' WithBatteryName UNION ALL</div>~~
263+ <div>select top 0 295 WithBatteryValue, '迷彩' WithBatteryName UNION ALL</div>
264- ~~<div>select top 0 296 WithBatteryValue, '电池类' WithBatteryName UNION ALL</div>~~
264+ <div>select top 0 296 WithBatteryValue, '电池类' WithBatteryName UNION ALL</div>
265- ~~<div>select top 0 297 WithBatteryValue, '形态类' WithBatteryName UNION ALL</div>~~
265+ <div>select top 0 297 WithBatteryValue, '形态类' WithBatteryName UNION ALL</div>
266- ~~<div>select top 0 298 WithBatteryValue, '违禁类' WithBatteryName UNION ALL</div>~~
266+ <div>select top 0 298 WithBatteryValue, '违禁类' WithBatteryName UNION ALL</div>
267- ~~<div>select top 0 299 WithBatteryValue, '特殊类' WithBatteryName UNION ALL</div>~~
267+ <div>select top 0 299 WithBatteryValue, '特殊类' WithBatteryName UNION ALL</div>
268- ~~<div>select top 0 300 WithBatteryValue, '基础类' WithBatteryName UNION ALL</div>~~
268+ <div>select top 0 300 WithBatteryValue, '基础类' WithBatteryName UNION ALL</div>
269- ~~<div>select top 0 301 WithBatteryValue, '温度计' WithBatteryName UNION ALL</div>~~
269+ <div>select top 0 301 WithBatteryValue, '温度计' WithBatteryName UNION ALL</div>
270- ~~<div>select top 0 302 WithBatteryValue, '骑行护目镜' WithBatteryName UNION ALL</div>~~
270+ <div>select top 0 302 WithBatteryValue, '骑行护目镜' WithBatteryName UNION ALL</div>
271- ~~<div>select top 0 303 WithBatteryValue, '户外面具和护目镜 ' WithBatteryName UNION ALL</div>~~
271+ <div>select top 0 303 WithBatteryValue, '户外面具和护目镜 ' WithBatteryName UNION ALL</div>
272- ~~<div>select top 0 304 WithBatteryValue, '护目镜' WithBatteryName UNION ALL</div>~~
272+ <div>select top 0 304 WithBatteryValue, '护目镜' WithBatteryName UNION ALL</div>
273- ~~<div>select top 0 305 WithBatteryValue, '超体积普（抛比小于3倍）' WithBatteryName UNION ALL</div>~~
273+ <div>select top 0 305 WithBatteryValue, '超体积普（抛比小于3倍）' WithBatteryName UNION ALL</div>
274- ~~<div>select top 0 306 WithBatteryValue, 'A-纯锂离子电池' WithBatteryName UNION ALL</div>~~
274+ <div>select top 0 306 WithBatteryValue, 'A-纯锂离子电池' WithBatteryName UNION ALL</div>
275- ~~<div>select top 0 307 WithBatteryValue, 'A-带油状' WithBatteryName UNION ALL</div>~~
275+ <div>select top 0 307 WithBatteryValue, 'A-带油状' WithBatteryName UNION ALL</div>
276- ~~<div>select top 0 308 WithBatteryValue, 'A-带胶状' WithBatteryName UNION ALL</div>~~
276+ <div>select top 0 308 WithBatteryValue, 'A-带胶状' WithBatteryName UNION ALL</div>
277- ~~<div>select top 0 309 WithBatteryValue, 'A-弱磁' WithBatteryName UNION ALL</div>~~
277+ <div>select top 0 309 WithBatteryValue, 'A-弱磁' WithBatteryName UNION ALL</div>
278- ~~<div>select top 0 310 WithBatteryValue, 'A-带易燃固体' WithBatteryName UNION ALL</div>~~
278+ <div>select top 0 310 WithBatteryValue, 'A-带易燃固体' WithBatteryName UNION ALL</div>
279- ~~<div>select top 0 311 WithBatteryValue, 'A-外形仿造' WithBatteryName UNION ALL</div>~~
279+ <div>select top 0 311 WithBatteryValue, 'A-外形仿造' WithBatteryName UNION ALL</div>
280- ~~<div>select top 0 312 WithBatteryValue, 'A-侵权' WithBatteryName UNION ALL</div>~~
280+ <div>select top 0 312 WithBatteryValue, 'A-侵权' WithBatteryName UNION ALL</div>
281- ~~<div>select top 0 313 WithBatteryValue, 'A-激光类' WithBatteryName UNION ALL</div>~~
281+ <div>select top 0 313 WithBatteryValue, 'A-激光类' WithBatteryName UNION ALL</div>
282- ~~<div>select top 0 314 WithBatteryValue, '内置电池+带磁性物品' WithBatteryName UNION ALL</div>~~
282+ <div>select top 0 314 WithBatteryValue, '内置电池+带磁性物品' WithBatteryName UNION ALL</div>
283- ~~<div>select top 0 315 WithBatteryValue, '电池+带磁属性' WithBatteryName UNION ALL</div>~~
283+ <div>select top 0 315 WithBatteryValue, '电池+带磁属性' WithBatteryName UNION ALL</div>
284- ~~<div>select top 0 316 WithBatteryValue, '假的' WithBatteryName UNION ALL</div>~~
284+ <div>select top 0 316 WithBatteryValue, '假的' WithBatteryName UNION ALL</div>
285- ~~<div>select top 0 317 WithBatteryValue, '普通服装' WithBatteryName UNION ALL</div>~~
285+ <div>select top 0 317 WithBatteryValue, '普通服装' WithBatteryName UNION ALL</div>
286- ~~<div>select top 0 318 WithBatteryValue, 'test111' WithBatteryName UNION ALL</div>~~
286+ <div>select top 0 318 WithBatteryValue, 'test111' WithBatteryName UNION ALL</div>
287- ~~<div>select top 0 319 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL</div>~~
287+ <div>select top 0 319 WithBatteryValue, '圆柱体' WithBatteryName UNION ALL</div>
288- ~~<div>select top 0 320 WithBatteryValue, 'NS-含酒精' WithBatteryName UNION ALL</div>~~
288+ <div>select top 0 320 WithBatteryValue, 'NS-含酒精' WithBatteryName UNION ALL</div>
289- ~~<div>select top 0 321 WithBatteryValue, 'NS-防疫用品' WithBatteryName UNION ALL</div>~~
289+ <div>select top 0 321 WithBatteryValue, 'NS-防疫用品' WithBatteryName UNION ALL</div>
290- ~~<div>select top 0 322 WithBatteryValue, 'NS-香水' WithBatteryName UNION ALL</div>~~
290+ <div>select top 0 322 WithBatteryValue, 'NS-香水' WithBatteryName UNION ALL</div>
291- ~~<div>select top 0 323 WithBatteryValue, 'NS-眼镜' WithBatteryName UNION ALL</div>~~
291+ <div>select top 0 323 WithBatteryValue, 'NS-眼镜' WithBatteryName UNION ALL</div>
292- ~~<div>select top 0 324 WithBatteryValue, 'NS-打火机' WithBatteryName UNION ALL</div>~~
292+ <div>select top 0 324 WithBatteryValue, 'NS-打火机' WithBatteryName UNION ALL</div>
293- ~~<div>select top 0 325 WithBatteryValue, 'NS-厨具' WithBatteryName UNION ALL</div>~~
293+ <div>select top 0 325 WithBatteryValue, 'NS-厨具' WithBatteryName UNION ALL</div>
294- ~~<div>select top 0 326 WithBatteryValue, 'NS-植物种子' WithBatteryName UNION ALL</div>~~
294+ <div>select top 0 326 WithBatteryValue, 'NS-植物种子' WithBatteryName UNION ALL</div>
295- ~~<div>select top 0 327 WithBatteryValue, '食品' WithBatteryName UNION ALL</div>~~
295+ <div>select top 0 327 WithBatteryValue, '食品' WithBatteryName UNION ALL</div>
296- ~~<div>select top 0 328 WithBatteryValue, 'NS-动物羽毛类' WithBatteryName UNION ALL</div>~~
296+ <div>select top 0 328 WithBatteryValue, 'NS-动物羽毛类' WithBatteryName UNION ALL</div>
297- ~~<div>select top 0 329 WithBatteryValue, 'NS-易碎' WithBatteryName UNION ALL</div>~~
297+ <div>select top 0 329 WithBatteryValue, 'NS-易碎' WithBatteryName UNION ALL</div>
298- ~~<div>select top 0 330 WithBatteryValue, 'NS-原木_木质类_竹质类' WithBatteryName UNION ALL</div>~~
298+ <div>select top 0 330 WithBatteryValue, 'NS-原木_木质类_竹质类' WithBatteryName UNION ALL</div>
299- ~~<div>select top 0 331 WithBatteryValue, 'NS-膏状' WithBatteryName UNION ALL</div>~~
299+ <div>select top 0 331 WithBatteryValue, 'NS-膏状' WithBatteryName UNION ALL</div>
300- ~~<div>select top 0 332 WithBatteryValue, 'NS-液体' WithBatteryName UNION ALL</div>~~
300+ <div>select top 0 332 WithBatteryValue, 'NS-液体' WithBatteryName UNION ALL</div>
301- ~~<div>select top 0 333 WithBatteryValue, 'NS-其他禁运物品' WithBatteryName UNION ALL</div>~~
301+ <div>select top 0 333 WithBatteryValue, 'NS-其他禁运物品' WithBatteryName UNION ALL</div>
302- ~~<div>select top 0 334 WithBatteryValue, 'NS-纯电池' WithBatteryName UNION ALL</div>~~
302+ <div>select top 0 334 WithBatteryValue, 'NS-纯电池' WithBatteryName UNION ALL</div>
303- ~~<div>select top 0 335 WithBatteryValue, 'NS-移动电源' WithBatteryName UNION ALL</div>~~
303+ <div>select top 0 335 WithBatteryValue, 'NS-移动电源' WithBatteryName UNION ALL</div>
304- ~~<div>select top 0 336 WithBatteryValue, 'NS-成人用品' WithBatteryName UNION ALL</div>~~
304+ <div>select top 0 336 WithBatteryValue, 'NS-成人用品' WithBatteryName UNION ALL</div>
305- ~~<div>select top 0 337 WithBatteryValue, 'NS-电机_马达' WithBatteryName UNION ALL</div>~~
305+ <div>select top 0 337 WithBatteryValue, 'NS-电机_马达' WithBatteryName UNION ALL</div>
306- ~~<div>select top 0 338 WithBatteryValue, 'NS-带磁物品' WithBatteryName UNION ALL</div>~~
306+ <div>select top 0 338 WithBatteryValue, 'NS-带磁物品' WithBatteryName UNION ALL</div>
307- ~~<div>select top 0 339 WithBatteryValue, 'NS-带外置电池' WithBatteryName UNION ALL</div>~~
307+ <div>select top 0 339 WithBatteryValue, 'NS-带外置电池' WithBatteryName UNION ALL</div>
308- ~~<div>select top 0 340 WithBatteryValue, 'NS-带内置电池' WithBatteryName UNION ALL</div>~~
308+ <div>select top 0 340 WithBatteryValue, 'NS-带内置电池' WithBatteryName UNION ALL</div>
309- ~~<div>select top 0 341 WithBatteryValue, 'NS-含纽扣电池' WithBatteryName UNION ALL</div>~~
309+ <div>select top 0 341 WithBatteryValue, 'NS-含纽扣电池' WithBatteryName UNION ALL</div>
310- ~~<div>select top 0 342 WithBatteryValue, 'NS-手表' WithBatteryName UNION ALL</div>~~
310+ <div>select top 0 342 WithBatteryValue, 'NS-手表' WithBatteryName UNION ALL</div>
311- ~~<div>select top 0 343 WithBatteryValue, 'NS-纺织品' WithBatteryName UNION ALL</div>~~
311+ <div>select top 0 343 WithBatteryValue, 'NS-纺织品' WithBatteryName UNION ALL</div>
312- ~~<div>select top 0 344 WithBatteryValue, 'NS-圆柱体' WithBatteryName UNION ALL</div>~~
312+ <div>select top 0 344 WithBatteryValue, 'NS-圆柱体' WithBatteryName UNION ALL</div>
313- ~~<div>select top 0 345 WithBatteryValue, 'NS-普货' WithBatteryName UNION ALL</div>~~
313+ <div>select top 0 345 WithBatteryValue, 'NS-普货' WithBatteryName UNION ALL</div>
314- ~~<div>select top 0 346 WithBatteryValue, '违禁品' WithBatteryName UNION ALL</div>~~
314+ <div>select top 0 346 WithBatteryValue, '违禁品' WithBatteryName UNION ALL</div>
315- ~~<div>select top 0 347 WithBatteryValue, '爆款' WithBatteryName UNION ALL</div>~~
315+ <div>select top 0 347 WithBatteryValue, '爆款' WithBatteryName UNION ALL</div>
316- ~~<div>select top 0 348 WithBatteryValue, '测款' WithBatteryName UNION ALL</div>~~
316+ <div>select top 0 348 WithBatteryValue, '测款' WithBatteryName UNION ALL</div>
317- ~~<div>select top 0 349 WithBatteryValue, '测款' WithBatteryName UNION ALL</div>~~
317+ <div>select top 0 349 WithBatteryValue, '测款' WithBatteryName UNION ALL</div>
318- ~~<div>select top 0 350 WithBatteryValue, '带内置电池+液体' WithBatteryName UNION ALL</div>~~
318+ <div>select top 0 350 WithBatteryValue, '带内置电池+液体' WithBatteryName UNION ALL</div>
319- ~~<div>select top 0 351 WithBatteryValue, '精油1' WithBatteryName UNION ALL</div>~~
319+ <div>select top 0 351 WithBatteryValue, '精油1' WithBatteryName UNION ALL</div>
320- ~~<div>select top 0 352 WithBatteryValue, '超长普货' WithBatteryName UNION ALL</div>~~
320+ <div>select top 0 352 WithBatteryValue, '超长普货' WithBatteryName UNION ALL</div>
321- ~~<div>select top 0 353 WithBatteryValue, '超长非普' WithBatteryName UNION ALL</div>~~
321+ <div>select top 0 353 WithBatteryValue, '超长非普' WithBatteryName UNION ALL</div>
322- ~~<div>select top 0 354 WithBatteryValue, '锂电池UN3481' WithBatteryName UNION ALL</div>~~
322+ <div>select top 0 354 WithBatteryValue, '锂电池UN3481' WithBatteryName UNION ALL</div>
323- ~~<div>select top 0 355 WithBatteryValue, '可充电干电池A199' WithBatteryName UNION ALL</div>~~
323+ <div>select top 0 355 WithBatteryValue, '可充电干电池A199' WithBatteryName UNION ALL</div>
324- ~~<div>select top 0 356 WithBatteryValue, '不可充电干电池A123' WithBatteryName UNION ALL</div>~~
324+ <div>select top 0 356 WithBatteryValue, '不可充电干电池A123' WithBatteryName UNION ALL</div>
325- ~~<div>select top 0 357 WithBatteryValue, '抛货' WithBatteryName UNION ALL</div>~~
325+ <div>select top 0 357 WithBatteryValue, '抛货' WithBatteryName UNION ALL</div>
326- ~~<div>select top 0 358 WithBatteryValue, '测试自定义物流属性0426-11' WithBatteryName UNION ALL</div>~~
326+ <div>select top 0 358 WithBatteryValue, '测试自定义物流属性0426-11' WithBatteryName UNION ALL</div>
327- ~~<div>select top 0 359 WithBatteryValue, '测试自定义物流属性' WithBatteryName UNION ALL</div>~~
327+ <div>select top 0 359 WithBatteryValue, '测试自定义物流属性' WithBatteryName UNION ALL</div>
328- ~~<div>select top 0 360 WithBatteryValue, '木质类_竹质类抛货' WithBatteryName UNION ALL</div>~~
328+ <div>select top 0 360 WithBatteryValue, '木质类_竹质类抛货' WithBatteryName UNION ALL</div>
329- ~~<div>select top 0 361 WithBatteryValue, '蓝牙头盔' WithBatteryName UNION ALL</div>~~
329+ <div>select top 0 361 WithBatteryValue, '蓝牙头盔' WithBatteryName UNION ALL</div>
330- ~~<div>select top 0 362 WithBatteryValue, '气雾产品' WithBatteryName UNION ALL</div>~~
330+ <div>select top 0 362 WithBatteryValue, '气雾产品' WithBatteryName UNION ALL</div>
331- ~~<div>select top 0 363 WithBatteryValue, '指甲油产品' WithBatteryName UNION ALL</div>~~
331+ <div>select top 0 363 WithBatteryValue, '指甲油产品' WithBatteryName UNION ALL</div>
332- ~~<div>select top 0 364 WithBatteryValue, '刺激气味产品' WithBatteryName UNION ALL</div>~~
332+ <div>select top 0 364 WithBatteryValue, '刺激气味产品' WithBatteryName UNION ALL</div>
333- ~~<div>select top 0 365 WithBatteryValue, '易燃易爆品' WithBatteryName UNION ALL</div>~~
333+ <div>select top 0 365 WithBatteryValue, '易燃易爆品' WithBatteryName UNION ALL</div>
334- ~~<div>select top 0 366 WithBatteryValue, '特殊尖锐器具' WithBatteryName UNION ALL</div>~~
334+ <div>select top 0 366 WithBatteryValue, '特殊尖锐器具' WithBatteryName UNION ALL</div>
335- ~~<div>select top 0 367 WithBatteryValue, '管制刀具' WithBatteryName UNION ALL</div>~~
335+ <div>select top 0 367 WithBatteryValue, '管制刀具' WithBatteryName UNION ALL</div>
336- ~~<div>select top 0 368 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL</div>~~
336+ <div>select top 0 368 WithBatteryValue, '枪支弹药' WithBatteryName UNION ALL</div>
337- ~~<div>select top 0 369 WithBatteryValue, '洗手液' WithBatteryName UNION ALL</div>~~
337+ <div>select top 0 369 WithBatteryValue, '洗手液' WithBatteryName UNION ALL</div>
338- ~~<div>select top 0 370 WithBatteryValue, '食品' WithBatteryName UNION ALL</div>~~
338+ <div>select top 0 370 WithBatteryValue, '食品' WithBatteryName UNION ALL</div>
339- ~~<div>select top 0 371 WithBatteryValue, '儿童玩具' WithBatteryName UNION ALL</div>~~
339+ <div>select top 0 371 WithBatteryValue, '儿童玩具' WithBatteryName UNION ALL</div>
340- ~~<div>select top 0 372 WithBatteryValue, 'HDMI产品' WithBatteryName UNION ALL</div>~~
340+ <div>select top 0 372 WithBatteryValue, 'HDMI产品' WithBatteryName UNION ALL</div>
341- ~~<div>select top 0 373 WithBatteryValue, 'FDA产品' WithBatteryName UNION ALL</div>~~
341+ <div>select top 0 373 WithBatteryValue, 'FDA产品' WithBatteryName UNION ALL</div>
342- ~~<div>select top 0 374 WithBatteryValue, '蓝牙产品' WithBatteryName UNION ALL</div>~~
342+ <div>select top 0 374 WithBatteryValue, '蓝牙产品' WithBatteryName UNION ALL</div>
343- ~~<div>select top 0 375 WithBatteryValue, '无电池' WithBatteryName UNION ALL</div>~~
343+ <div>select top 0 375 WithBatteryValue, '无电池' WithBatteryName UNION ALL</div>
344- ~~<div>select top 0 376 WithBatteryValue, '带电成人用品' WithBatteryName UNION ALL</div>~~
344+ <div>select top 0 376 WithBatteryValue, '带电成人用品' WithBatteryName UNION ALL</div>
345- ~~<div>select top 0 377 WithBatteryValue, '无电成人用品' WithBatteryName UNION ALL</div>~~
345+ <div>select top 0 377 WithBatteryValue, '无电成人用品' WithBatteryName UNION ALL</div>
346- ~~<div>select top 0 378 WithBatteryValue, '易燃' WithBatteryName UNION ALL</div>~~
346+ <div>select top 0 378 WithBatteryValue, '易燃' WithBatteryName UNION ALL</div>
347- ~~<div>select top 0 379 WithBatteryValue, '带金属器件' WithBatteryName UNION ALL</div>~~
347+ <div>select top 0 379 WithBatteryValue, '带金属器件' WithBatteryName UNION ALL</div>
348- ~~<div>select top 0 380 WithBatteryValue, '锐器' WithBatteryName UNION ALL</div>~~
348+ <div>select top 0 380 WithBatteryValue, '锐器' WithBatteryName UNION ALL</div>
349- ~~<div>select top 0 381 WithBatteryValue, '万邑联KY仓' WithBatteryName UNION ALL</div>~~
349+ <div>select top 0 381 WithBatteryValue, '万邑联KY仓' WithBatteryName UNION ALL</div>
350- ~~<div>select top 0 382 WithBatteryValue, '食品接触类（易碎）' WithBatteryName UNION ALL</div>~~
350+ <div>select top 0 382 WithBatteryValue, '食品接触类（易碎）' WithBatteryName UNION ALL</div>
351- ~~<div>select top 0 383 WithBatteryValue, '食品接触类（木质）' WithBatteryName UNION ALL</div>~~
351+ <div>select top 0 383 WithBatteryValue, '食品接触类（木质）' WithBatteryName UNION ALL</div>
352- ~~<div>select top 0 384 WithBatteryValue, '食品接触类（带电）' WithBatteryName UNION ALL</div>~~
352+ <div>select top 0 384 WithBatteryValue, '食品接触类（带电）' WithBatteryName UNION ALL</div>
353- ~~<div>select top 0 385 WithBatteryValue, '配套电池' WithBatteryName UNION ALL</div>~~
353+ <div>select top 0 385 WithBatteryValue, '配套电池' WithBatteryName UNION ALL</div>
354- ~~<div>select top 0 386 WithBatteryValue, '内置电池（查验）' WithBatteryName UNION ALL</div>~~
354+ <div>select top 0 386 WithBatteryValue, '内置电池（查验）' WithBatteryName UNION ALL</div>
355- ~~<div>select top 0 387 WithBatteryValue, '内置电池（人体接触）' WithBatteryName UNION ALL</div>~~
355+ <div>select top 0 387 WithBatteryValue, '内置电池（人体接触）' WithBatteryName UNION ALL</div>
356- ~~<div>select top 0 388 WithBatteryValue, '外置电池（查验）' WithBatteryName UNION ALL</div>~~
356+ <div>select top 0 388 WithBatteryValue, '外置电池（查验）' WithBatteryName UNION ALL</div>
357- ~~<div>select top 0 389 WithBatteryValue, '纽扣电池（查验）' WithBatteryName UNION ALL</div>~~
357+ <div>select top 0 389 WithBatteryValue, '纽扣电池（查验）' WithBatteryName UNION ALL</div>
358- ~~<div>select top 0 390 WithBatteryValue, '弱磁' WithBatteryName UNION ALL</div>~~
358+ <div>select top 0 390 WithBatteryValue, '弱磁' WithBatteryName UNION ALL</div>
359- ~~<div>select top 0 391 WithBatteryValue, '弱磁（查验）' WithBatteryName UNION ALL</div>~~
359+ <div>select top 0 391 WithBatteryValue, '弱磁（查验）' WithBatteryName UNION ALL</div>
360- ~~<div>select top 0 392 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>~~
360+ <div>select top 0 392 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>
361- ~~<div>select top 0 393 WithBatteryValue, '普通刀具_剪刀' WithBatteryName UNION ALL</div>~~
361+ <div>select top 0 393 WithBatteryValue, '普通刀具_剪刀' WithBatteryName UNION ALL</div>
362- ~~<div>select top 0 394 WithBatteryValue, '户外刀具' WithBatteryName UNION ALL</div>~~
362+ <div>select top 0 394 WithBatteryValue, '户外刀具' WithBatteryName UNION ALL</div>
363- ~~<div>select top 0 395 WithBatteryValue, '仿真枪' WithBatteryName UNION ALL</div>~~
363+ <div>select top 0 395 WithBatteryValue, '仿真枪' WithBatteryName UNION ALL</div>
364- ~~<div>select top 0 396 WithBatteryValue, '医疗用品' WithBatteryName UNION ALL</div>~~
364+ <div>select top 0 396 WithBatteryValue, '医疗用品' WithBatteryName UNION ALL</div>
365- ~~<div>select top 0 397 WithBatteryValue, '酒精类' WithBatteryName UNION ALL</div>~~
365+ <div>select top 0 397 WithBatteryValue, '酒精类' WithBatteryName UNION ALL</div>
366- ~~<div>select top 0 398 WithBatteryValue, '玩具' WithBatteryName UNION ALL</div>~~
366+ <div>select top 0 398 WithBatteryValue, '玩具' WithBatteryName UNION ALL</div>
367- ~~<div>select top 0 399 WithBatteryValue, '玩具（查验）' WithBatteryName UNION ALL</div>~~
367+ <div>select top 0 399 WithBatteryValue, '玩具（查验）' WithBatteryName UNION ALL</div>
368- ~~<div>select top 0 400 WithBatteryValue, '植物类' WithBatteryName UNION ALL</div>~~
368+ <div>select top 0 400 WithBatteryValue, '植物类' WithBatteryName UNION ALL</div>
369- ~~<div>select top 0 401 WithBatteryValue, '种子类' WithBatteryName UNION ALL</div>~~
369+ <div>select top 0 401 WithBatteryValue, '种子类' WithBatteryName UNION ALL</div>
370- ~~<div>select top 0 402 WithBatteryValue, '按摩类' WithBatteryName UNION ALL</div>~~
370+ <div>select top 0 402 WithBatteryValue, '按摩类' WithBatteryName UNION ALL</div>
371- ~~<div>select top 0 403 WithBatteryValue, '普货（人体接触）' WithBatteryName UNION ALL</div>~~
371+ <div>select top 0 403 WithBatteryValue, '普货（人体接触）' WithBatteryName UNION ALL</div>
372- ~~<div>select top 0 404 WithBatteryValue, '查验' WithBatteryName UNION ALL</div>~~
372+ <div>select top 0 404 WithBatteryValue, '查验' WithBatteryName UNION ALL</div>
373- ~~<div>select top 0 405 WithBatteryValue, '印泥' WithBatteryName UNION ALL</div>~~
373+ <div>select top 0 405 WithBatteryValue, '印泥' WithBatteryName UNION ALL</div>
374- ~~<div>select top 0 406 WithBatteryValue, '一次性塑料用品' WithBatteryName UNION ALL</div>~~
374+ <div>select top 0 406 WithBatteryValue, '一次性塑料用品' WithBatteryName UNION ALL</div>
375- ~~<div>select top 0 407 WithBatteryValue, '解压球' WithBatteryName UNION ALL</div>~~
375+ <div>select top 0 407 WithBatteryValue, '解压球' WithBatteryName UNION ALL</div>
376- ~~<div>select top 0 408 WithBatteryValue, '成人用品带电' WithBatteryName UNION ALL</div>~~
376+ <div>select top 0 408 WithBatteryValue, '成人用品带电' WithBatteryName UNION ALL</div>
377- ~~<div>select top 0 409 WithBatteryValue, '面膜' WithBatteryName UNION ALL</div>~~
377+ <div>select top 0 409 WithBatteryValue, '面膜' WithBatteryName UNION ALL</div>
378- ~~<div>select top 0 410 WithBatteryValue, '药膏' WithBatteryName UNION ALL</div>~~
378+ <div>select top 0 410 WithBatteryValue, '药膏' WithBatteryName UNION ALL</div>
379- ~~<div>select top 0 411 WithBatteryValue, '深圳粉末液体' WithBatteryName UNION ALL</div>~~
379+ <div>select top 0 411 WithBatteryValue, '深圳粉末液体' WithBatteryName UNION ALL</div>
380- ~~<div>select top 0 412 WithBatteryValue, '深圳带电' WithBatteryName UNION ALL</div>~~
380+ <div>select top 0 412 WithBatteryValue, '深圳带电' WithBatteryName UNION ALL</div>
381- ~~<div>select top 0 413 WithBatteryValue, '灰色产品' WithBatteryName UNION ALL</div>~~
381+ <div>select top 0 413 WithBatteryValue, '灰色产品' WithBatteryName UNION ALL</div>
382- ~~<div>select top 0 414 WithBatteryValue, '牙套' WithBatteryName UNION ALL</div>~~
382+ <div>select top 0 414 WithBatteryValue, '牙套' WithBatteryName UNION ALL</div>
383- ~~<div>select top 0 415 WithBatteryValue, '1231231' WithBatteryName UNION ALL</div>~~
383+ <div>select top 0 415 WithBatteryValue, '1231231' WithBatteryName UNION ALL</div>
384- ~~<div>select top 0 416 WithBatteryValue, '食品接触（竹质）' WithBatteryName UNION ALL</div>~~
384+ <div>select top 0 416 WithBatteryValue, '食品接触（竹质）' WithBatteryName UNION ALL</div>
385- ~~<div>select top 0 417 WithBatteryValue, '化妆品类液体粉末膏体' WithBatteryName UNION ALL</div>~~
385+ <div>select top 0 417 WithBatteryValue, '化妆品类液体粉末膏体' WithBatteryName UNION ALL</div>
386- ~~<div>select top 0 418 WithBatteryValue, '打火机-敏感货' WithBatteryName UNION ALL</div>~~
386+ <div>select top 0 418 WithBatteryValue, '打火机-敏感货' WithBatteryName UNION ALL</div>
387- ~~<div>select top 0 419 WithBatteryValue, '普货-敏感货' WithBatteryName UNION ALL</div>~~
387+ <div>select top 0 419 WithBatteryValue, '普货-敏感货' WithBatteryName UNION ALL</div>
388- ~~<div>select top 0 420 WithBatteryValue, '带内置电池-敏感货' WithBatteryName UNION ALL</div>~~
388+ <div>select top 0 420 WithBatteryValue, '带内置电池-敏感货' WithBatteryName UNION ALL</div>
389- ~~<div>select top 0 421 WithBatteryValue, '带内置电池-高货值' WithBatteryName UNION ALL</div>~~
389+ <div>select top 0 421 WithBatteryValue, '带内置电池-高货值' WithBatteryName UNION ALL</div>
390- ~~<div>select top 0 422 WithBatteryValue, '智能手环' WithBatteryName UNION ALL</div>~~
390+ <div>select top 0 422 WithBatteryValue, '智能手环' WithBatteryName UNION ALL</div>
391- ~~<div>select top 0 423 WithBatteryValue, '液体-敏感货' WithBatteryName UNION ALL</div>~~
391+ <div>select top 0 423 WithBatteryValue, '液体-敏感货' WithBatteryName UNION ALL</div>
392- ~~<div>select top 0 424 WithBatteryValue, '假睫毛' WithBatteryName UNION ALL</div>~~
392+ <div>select top 0 424 WithBatteryValue, '假睫毛' WithBatteryName UNION ALL</div>
393- ~~<div>select top 0 425 WithBatteryValue, '太阳能充电宝' WithBatteryName UNION ALL</div>~~
393+ <div>select top 0 425 WithBatteryValue, '太阳能充电宝' WithBatteryName UNION ALL</div>
394- ~~<div>select top 0 426 WithBatteryValue, '带内置电池-敏感货' WithBatteryName UNION ALL</div>~~
394+ <div>select top 0 426 WithBatteryValue, '带内置电池-敏感货' WithBatteryName UNION ALL</div>
395- ~~<div>select top 0 427 WithBatteryValue, '普货-敏感货' WithBatteryName UNION ALL</div>~~
395+ <div>select top 0 427 WithBatteryValue, '普货-敏感货' WithBatteryName UNION ALL</div>
396- ~~<div>select top 0 428 WithBatteryValue, '粉末-敏感货' WithBatteryName UNION ALL</div>~~
396+ <div>select top 0 428 WithBatteryValue, '粉末-敏感货' WithBatteryName UNION ALL</div>
397- ~~<div>select top 0 429 WithBatteryValue, '特殊属性' WithBatteryName UNION ALL</div>~~
397+ <div>select top 0 429 WithBatteryValue, '特殊属性' WithBatteryName UNION ALL</div>
398- ~~<div>select top 0 430 WithBatteryValue, '带电容' WithBatteryName UNION ALL</div>~~
398+ <div>select top 0 430 WithBatteryValue, '带电容' WithBatteryName UNION ALL</div>
399- ~~<div>select top 0 431 WithBatteryValue, '陈冠希A货' WithBatteryName UNION ALL</div>~~
399+ <div>select top 0 431 WithBatteryValue, '陈冠希A货' WithBatteryName UNION ALL</div>
400- ~~<div>select top 0 432 WithBatteryValue, '包裹长度超60CM' WithBatteryName UNION ALL</div>~~
400+ <div>select top 0 432 WithBatteryValue, '包裹长度超60CM' WithBatteryName UNION ALL</div>
401- ~~<div>select top 0 433 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>~~
401+ <div>select top 0 433 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>
402- ~~<div>select top 0 434 WithBatteryValue, '111' WithBatteryName UNION ALL</div>~~
402+ <div>select top 0 434 WithBatteryValue, '111' WithBatteryName UNION ALL</div>
403- ~~<div>select top 0 435 WithBatteryValue, 'AAAAAA' WithBatteryName UNION ALL</div>~~
403+ <div>select top 0 435 WithBatteryValue, 'AAAAAA' WithBatteryName UNION ALL</div>
404- ~~<div>select top 0 436 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>~~
404+ <div>select top 0 436 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>
405- ~~<div>select top 0 437 WithBatteryValue, '敏感货' WithBatteryName UNION ALL</div>~~
405+ <div>select top 0 437 WithBatteryValue, '敏感货' WithBatteryName UNION ALL</div>
406- ~~<div>select top 0 438 WithBatteryValue, '糖果超甜' WithBatteryName UNION ALL</div>~~
406+ <div>select top 0 438 WithBatteryValue, '糖果超甜' WithBatteryName UNION ALL</div>
407- ~~<div>select top 0 439 WithBatteryValue, '食品接触（宠物餐具）' WithBatteryName UNION ALL</div>~~
407+ <div>select top 0 439 WithBatteryValue, '食品接触（宠物餐具）' WithBatteryName UNION ALL</div>
408- ~~<div>select top 0 440 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>~~
408+ <div>select top 0 440 WithBatteryValue, '强磁' WithBatteryName UNION ALL</div>
409- ~~<div>select top 0 441 WithBatteryValue, '弱磁' WithBatteryName UNION ALL</div>~~
409+ <div>select top 0 441 WithBatteryValue, '弱磁' WithBatteryName UNION ALL</div>
410- ~~<div>select top 0 442 WithBatteryValue, '超体积普（6000抛比小于2倍）' WithBatteryName UNION ALL</div>~~
410+ <div>select top 0 442 WithBatteryValue, '超体积普（6000抛比小于2倍）' WithBatteryName UNION ALL</div>
411- ~~<div>select top 0 443 WithBatteryValue, '弱磁产品' WithBatteryName UNION ALL</div>~~
411+ <div>select top 0 443 WithBatteryValue, '弱磁产品' WithBatteryName UNION ALL</div>
412- ~~<div>select top 0 444 WithBatteryValue, '气雾' WithBatteryName UNION ALL</div>~~
412+ <div>select top 0 444 WithBatteryValue, '气雾' WithBatteryName UNION ALL</div>
413- ~~<div>select top 0 445 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL</div>~~
413+ <div>select top 0 445 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL</div>
414- ~~<div>select top 0 446 WithBatteryValue, '违禁品' WithBatteryName UNION ALL</div>~~
414+ <div>select top 0 446 WithBatteryValue, '违禁品' WithBatteryName UNION ALL</div>
415- ~~<div>select top 0 447 WithBatteryValue, '马达' WithBatteryName UNION ALL</div>~~
415+ <div>select top 0 447 WithBatteryValue, '马达' WithBatteryName UNION ALL</div>
416- ~~<div>select top 0 448 WithBatteryValue, '普通颗粒类' WithBatteryName UNION ALL</div>~~
416+ <div>select top 0 448 WithBatteryValue, '普通颗粒类' WithBatteryName UNION ALL</div>
417- ~~<div>select top 0 449 WithBatteryValue, '带外置电池-敏感货' WithBatteryName UNION ALL</div>~~
417+ <div>select top 0 449 WithBatteryValue, '带外置电池-敏感货' WithBatteryName UNION ALL</div>
418- ~~<div>select top 0 450 WithBatteryValue, '带外置电池-敏感货' WithBatteryName UNION ALL</div>~~
418+ <div>select top 0 450 WithBatteryValue, '带外置电池-敏感货' WithBatteryName UNION ALL</div>
419- ~~<div>select top 0 451 WithBatteryValue, '成人用品（带电）' WithBatteryName UNION ALL</div>~~
419+ <div>select top 0 451 WithBatteryValue, '成人用品（带电）' WithBatteryName UNION ALL</div>
420- ~~<div>select top 0 452 WithBatteryValue, '化妆品' WithBatteryName UNION ALL</div>~~
420+ <div>select top 0 452 WithBatteryValue, '化妆品' WithBatteryName UNION ALL</div>
421- ~~<div>select top 0 453 WithBatteryValue, '新人-钢铁侠' WithBatteryName UNION ALL</div>~~
421+ <div>select top 0 453 WithBatteryValue, '新人-钢铁侠' WithBatteryName UNION ALL</div>
422- ~~<div>select top 0 454 WithBatteryValue, '陶瓷' WithBatteryName UNION ALL</div>~~
422+ <div>select top 0 454 WithBatteryValue, '陶瓷' WithBatteryName UNION ALL</div>
423- ~~<div>select top 0 455 WithBatteryValue, '带电带磁带电机' WithBatteryName UNION ALL</div>~~
423+ <div>select top 0 455 WithBatteryValue, '带电带磁带电机' WithBatteryName UNION ALL</div>
424- ~~<div>select top 0 456 WithBatteryValue, '仿牌' WithBatteryName UNION ALL</div>~~
424+ <div>select top 0 456 WithBatteryValue, '仿牌' WithBatteryName UNION ALL</div>
425- ~~<div>select top 0 457 WithBatteryValue, '激光笔' WithBatteryName UNION ALL</div>~~
425+ <div>select top 0 457 WithBatteryValue, '激光笔' WithBatteryName UNION ALL</div>
426- ~~<div>select top 0 458 WithBatteryValue, '带电蓝牙产品' WithBatteryName UNION ALL</div>~~
426+ <div>select top 0 458 WithBatteryValue, '带电蓝牙产品' WithBatteryName UNION ALL</div>
427- ~~<div>select top 0 459 WithBatteryValue, '平板电脑' WithBatteryName UNION ALL</div>~~
427+ <div>select top 0 459 WithBatteryValue, '平板电脑' WithBatteryName UNION ALL</div>
428- ~~<div>select top 0 460 WithBatteryValue, '头盔' WithBatteryName UNION ALL</div>~~
428+ <div>select top 0 460 WithBatteryValue, '头盔' WithBatteryName UNION ALL</div>
429- ~~<div>select top 0 461 WithBatteryValue, '食品' WithBatteryName UNION ALL</div>~~
429+ <div>select top 0 461 WithBatteryValue, '食品' WithBatteryName UNION ALL</div>
430- ~~<div>select top 0 462 WithBatteryValue, '药品' WithBatteryName UNION ALL</div>~~
430+ <div>select top 0 462 WithBatteryValue, '药品' WithBatteryName UNION ALL</div>
431- ~~<div>select top 0 463 WithBatteryValue, '剪刀' WithBatteryName UNION ALL</div>~~
431+ <div>select top 0 463 WithBatteryValue, '剪刀' WithBatteryName UNION ALL</div>
432- ~~<div>select top 0 464 WithBatteryValue, '活性炭' WithBatteryName UNION ALL</div>~~
432+ <div>select top 0 464 WithBatteryValue, '活性炭' WithBatteryName UNION ALL</div>
433- ~~<div>select top 0 465 WithBatteryValue, '带刀产品' WithBatteryName UNION ALL</div>~~
433+ <div>select top 0 465 WithBatteryValue, '带刀产品' WithBatteryName UNION ALL</div>
434- ~~<div>select top 0 466 WithBatteryValue, '水滤器（带碳粉）' WithBatteryName UNION ALL</div>~~
434+ <div>select top 0 466 WithBatteryValue, '水滤器（带碳粉）' WithBatteryName UNION ALL</div>
435- ~~<div>select top 0 467 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL</div>~~
435+ <div>select top 0 467 WithBatteryValue, '带电带磁' WithBatteryName UNION ALL</div>
436- ~~<div>select top 0 468 WithBatteryValue, '带电带磁带木材' WithBatteryName UNION ALL</div>~~
436+ <div>select top 0 468 WithBatteryValue, '带电带磁带木材' WithBatteryName UNION ALL</div>
437- ~~<div>select top 0 469 WithBatteryValue, '纽扣电池（内置）' WithBatteryName UNION ALL</div>~~
437+ <div>select top 0 469 WithBatteryValue, '纽扣电池（内置）' WithBatteryName UNION ALL</div>
438- ~~<div>select top 0 470 WithBatteryValue, '纽扣电池（外置）' WithBatteryName UNION ALL</div>~~
438+ <div>select top 0 470 WithBatteryValue, '纽扣电池（外置）' WithBatteryName UNION ALL</div>
439- ~~<div>select top 0 471 WithBatteryValue, '纽扣电池（纯电池）' WithBatteryName UNION ALL</div>~~
439+ <div>select top 0 471 WithBatteryValue, '纽扣电池（纯电池）' WithBatteryName UNION ALL</div>
440- ~~<div>select top 0 472 WithBatteryValue, '锂电池（内置）' WithBatteryName UNION ALL</div>~~
440+ <div>select top 0 472 WithBatteryValue, '锂电池（内置）' WithBatteryName UNION ALL</div>
441- ~~<div>select top 0 473 WithBatteryValue, '锂电池（外置）' WithBatteryName UNION ALL</div>~~
441+ <div>select top 0 473 WithBatteryValue, '锂电池（外置）' WithBatteryName UNION ALL</div>
442- ~~<div>select top 0 474 WithBatteryValue, '锂电池（纯电池）' WithBatteryName UNION ALL</div>~~
442+ <div>select top 0 474 WithBatteryValue, '锂电池（纯电池）' WithBatteryName UNION ALL</div>
443- ~~<div>select top 0 475 WithBatteryValue, '干电池（内置）' WithBatteryName UNION ALL</div>~~
443+ <div>select top 0 475 WithBatteryValue, '干电池（内置）' WithBatteryName UNION ALL</div>
444- ~~<div>select top 0 476 WithBatteryValue, '干电池（外置）' WithBatteryName UNION ALL</div>~~
444+ <div>select top 0 476 WithBatteryValue, '干电池（外置）' WithBatteryName UNION ALL</div>
445- ~~<div>select top 0 477 WithBatteryValue, '干电池（纯电池）' WithBatteryName UNION ALL</div>~~
445+ <div>select top 0 477 WithBatteryValue, '干电池（纯电池）' WithBatteryName UNION ALL</div>
446- ~~<div>select top 0 478 WithBatteryValue, '镍氢电池（内置）' WithBatteryName UNION ALL</div>~~
446+ <div>select top 0 478 WithBatteryValue, '镍氢电池（内置）' WithBatteryName UNION ALL</div>
447- ~~<div>select top 0 479 WithBatteryValue, '镍氢电池（外置）' WithBatteryName UNION ALL</div>~~
447+ <div>select top 0 479 WithBatteryValue, '镍氢电池（外置）' WithBatteryName UNION ALL</div>
448- ~~<div>select top 0 480 WithBatteryValue, '镍氢电池（纯电池）' WithBatteryName UNION ALL</div>~~
448+ <div>select top 0 480 WithBatteryValue, '镍氢电池（纯电池）' WithBatteryName UNION ALL</div>
449- ~~<div>select top 0 481 WithBatteryValue, '成人用品（带电）' WithBatteryName</div>~~
449+ <div>select top 0 481 WithBatteryValue, '成人用品（带电）' WithBatteryName</div>
450- ~~<div>) a</div>~~
450+ <div>) a</div>
451- ~~<div>~~
451+ <div>
452- ~~<div><br /></div>~~
452+ <div><br /></div>
453- ~~</div>~~
453+ </div>
454- ~~<div>select top 0 w.WareHouseName AS '仓库',</div>~~
454+ <div>select top 0 w.WareHouseName AS '仓库',</div>
455- ~~<div>pr.ListNo AS '销单号',</div>~~
455+ <div>pr.ListNo AS '销单号',</div>
456- ~~<div>pr.SKU AS 'SKU',</div>~~
456+ <div>pr.SKU AS 'SKU',</div>
457- ~~<div>p.ProductNameCN AS '中文名',</div>~~
457+ <div>p.ProductNameCN AS '中文名',</div>
458- ~~<div>CASE pl.IsUrgent WHEN 1 THEN '是' WHEN 0 THEN '否' END AS '是否加急',</div>~~
458+ <div>CASE pl.IsUrgent WHEN 1 THEN '是' WHEN 0 THEN '否' END AS '是否加急',</div>
459- ~~<div>CASE pl.IsSample WHEN 1 THEN '是' WHEN 0 THEN '否' END AS '是否样品',</div>~~
459+ <div>CASE pl.IsSample WHEN 1 THEN '是' WHEN 0 THEN '否' END AS '是否样品',</div>
460- ~~<div>CASE pr.NeedToPackType</div>~~
460+ <div>CASE pr.NeedToPackType</div>
461- ~~<div>WHEN 0 THEN '不需打包'</div>~~
461+ <div>WHEN 0 THEN '不需打包'</div>
462- ~~<div>WHEN 1 THEN '需供应商打包'</div>~~
462+ <div>WHEN 1 THEN '需供应商打包'</div>
463- ~~<div>WHEN 2 THEN '加工打包'</div>~~
463+ <div>WHEN 2 THEN '加工打包'</div>
464- ~~<div>WHEN 3 THEN '销单打包'</div>~~
464+ <div>WHEN 3 THEN '销单打包'</div>
465- ~~<div>ELSE ''</div>~~
465+ <div>ELSE ''</div>
466- ~~<div>END AS '打包状态'</div>~~
466+ <div>END AS '打包状态'</div>
467- ~~<div>prd.ActualBuyNum AS '销单数量',</div>~~
467+ <div>prd.ActualBuyNum AS '销单数量',</div>
468- ~~<div>prd.ProcessNum AS '加工数量',</div>~~
468+ <div>prd.ProcessNum AS '加工数量',</div>
469- ~~<div>prd.BadNum AS '不良品',</div>~~
469+ <div>prd.BadNum AS '不良品',</div>
470- ~~<div>prd.TallyNum AS '理货数量',</div>~~
470+ <div>prd.TallyNum AS '理货数量',</div>
471- ~~<div>prd.PutInNum AS '入库数量',</div>~~
471+ <div>prd.PutInNum AS '入库数量',</div>
472- ~~<div>t.WithBatteryName AS '物流属性',</div>~~
472+ <div>t.WithBatteryName AS '物流属性',</div>
473- ~~<div>CASE prd.TaskState</div>~~
473+ <div>CASE prd.TaskState</div>
474- ~~<div>WHEN 0 THEN '待质检'</div>~~
474+ <div>WHEN 0 THEN '待质检'</div>
475- ~~<div>WHEN 1 THEN '待入库'</div>~~
475+ <div>WHEN 1 THEN '待入库'</div>
476- ~~<div>WHEN 2 THEN '部分入库'</div>~~
476+ <div>WHEN 2 THEN '部分入库'</div>
477- ~~<div>WHEN 3 THEN '已完成'</div>~~
477+ <div>WHEN 3 THEN '已完成'</div>
478- ~~<div>ELSE ''</div>~~
478+ <div>ELSE ''</div>
479- ~~<div>END AS '任务状态',</div>~~
479+ <div>END AS '任务状态',</div>
480- ~~<div>pr.ReceiptUserNmae AS '收货人',</div>~~
480+ <div>pr.ReceiptUserNmae AS '收货人',</div>
481- ~~<div>pr.ReceiptTime AS '收货时间',</div>~~
481+ <div>pr.ReceiptTime AS '收货时间',</div>
482- ~~<div>prc.PrepareBuyUserName AS '预销单人',</div>~~
482+ <div>prc.PrepareBuyUserName AS '预销单人',</div>
483- ~~<div>prc.PrepareBuyTime AS '预销单时间',</div>~~
483+ <div>prc.PrepareBuyTime AS '预销单时间',</div>
484- ~~<div>prd.BuyUserName AS '销单人',</div>~~
484+ <div>prd.BuyUserName AS '销单人',</div>
485- ~~<div>prd.BuyTime AS '销单时间',</div>~~
485+ <div>prd.BuyTime AS '销单时间',</div>
486- ~~<div>prd.ProcessUserName AS '加工人',</div>~~
486+ <div>prd.ProcessUserName AS '加工人',</div>
487- ~~<div>prd.ProcessTime AS '加工时间',</div>~~
487+ <div>prd.ProcessTime AS '加工时间',</div>
488- ~~<div>prd.CheckUserName AS '质检人',</div>~~
488+ <div>prd.CheckUserName AS '质检人',</div>
489- ~~<div>prd.CheckTime AS '质检时间',</div>~~
489+ <div>prd.CheckTime AS '质检时间',</div>
490- ~~<div>prd.TallyUserName AS '理货人',</div>~~
490+ <div>prd.TallyUserName AS '理货人',</div>
491- ~~<div>prd.TallyTime AS '理货时间',</div>~~
491+ <div>prd.TallyTime AS '理货时间',</div>
492- ~~<div>prd.PutInUserName AS '入库人',</div>~~
492+ <div>prd.PutInUserName AS '入库人',</div>
493- ~~<div>prd.PutInTime AS '入库时间'</div>~~
493+ <div>prd.PutInTime AS '入库时间'</div>
494- ~~<div>FROM dbo.RB_Procurement_ReceiptAndStorage (NOLOCK) pr</div>~~
494+ <div>FROM dbo.RB_Procurement_ReceiptAndStorage (NOLOCK) pr</div>
495- ~~<div>LEFT JOIN dbo.RB_Warehouse(NOLOCK) w ON pr.WarehouseId=w.ID AND pr.CustomerId=w.CustomerID</div>~~
495+ <div>LEFT JOIN dbo.RB_Warehouse(NOLOCK) w ON pr.WarehouseId=w.ID AND pr.CustomerId=w.CustomerID</div>
496- ~~<div>LEFT JOIN dbo.RB_Product (NOLOCK) p ON pr.SKU=p.SKU AND pr.CustomerId=p.CustomerID</div>~~
496+ <div>LEFT JOIN dbo.RB_Product (NOLOCK) p ON pr.SKU=p.SKU AND pr.CustomerId=p.CustomerID</div>
497- ~~<div>LEFT JOIN dbo.RB_Procurement_ReceiptAndStorage_Details (NOLOCK)prd ON prd.ReceiptAndStorageId=pr.ID AND prd.CustomerId=pr.CustomerId</div>~~
497+ <div>LEFT JOIN dbo.RB_Procurement_ReceiptAndStorage_Details (NOLOCK)prd ON prd.ReceiptAndStorageId=pr.ID AND prd.CustomerId=pr.CustomerId</div>
498- ~~<div>LEFT JOIN dbo.RB_Procurement_ReceiptAndStorage_CourierNum (NOLOCK)prc ON prc.CourierNum=pr.CourierNum AND prc.CustomerID=pr.CustomerId</div>~~
498+ <div>LEFT JOIN dbo.RB_Procurement_ReceiptAndStorage_CourierNum (NOLOCK)prc ON prc.CourierNum=pr.CourierNum AND prc.CustomerID=pr.CustomerId</div>
499- ~~<div>LEFT JOIN dbo.RB_Procurement_List (NOLOCK) pl ON pl.P_Code=pr.P_Code AND pl.CustomerID=pr.CustomerId</div>~~
499+ <div>LEFT JOIN dbo.RB_Procurement_List (NOLOCK) pl ON pl.P_Code=pr.P_Code AND pl.CustomerID=pr.CustomerId</div>
500- ~~<div>LEFT JOIN #temp_WithBattery t ON t.WithBatteryValue=p.WithBattery</div>~~
500+ <div>LEFT JOIN #temp_WithBattery t ON t.WithBatteryValue=p.WithBattery</div>
501- ~~<div>WHERE prc.PrepareBuyTime>=@StartDate AND prc.PrepareBuyTime<=@EndDate AND pr.CustomerId=@CustomerId</div>~~
501+ <div>WHERE prc.PrepareBuyTime>=@StartDate AND prc.PrepareBuyTime<=@EndDate AND pr.CustomerId=@CustomerId</div>
502- ~~<div>PARAMS:@StartDate = null ,@EndDate = null ,@CustomerId = 0 ,</div>~~
502+ <div>PARAMS:@StartDate = null ,@EndDate = null ,@CustomerId = 0 ,</div>
503- ~~<div>MESSAGE:Incorrect syntax near 'prd'.</div>~~
503+ <div>MESSAGE:Incorrect syntax near 'prd'.</div>
504- <div>TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)</div>
504+ <div>TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)</div>
505- ~~<div>在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)</div>~~
505+ <div>在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)</div>
506- <div>在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)</div>
506+ <div>在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)</div>
507- ~~<div>在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()</div>~~
507+ <div>在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()</div>
508- ~~<div>在 System.Data.SqlClient.SqlDataReader.get_MetaData()</div>~~
508+ <div>在 System.Data.SqlClient.SqlDataReader.get_MetaData()</div>
509- <div>在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)</div>
509+ <div>在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)</div>
510- <div>在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)</div>
510+ <div>在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)</div>
511- <div>在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DALExtend.RB_CustomReportExtend.GetSheetFieldsDr(String sqlContent, List1 sqlParameters)</div>
511+ <div>在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DALExtend.RB_CustomReportExtend.GetSheetFieldsDr(String sqlContent, List1 sqlParameters)</div>
512- ~~<div>在 Biz.Irobotbox.ReportCentre.CustomReportService.CheckSqlAndGetFields(String sqlContent, List`1 paramList)</div>~~
512+ <div>在 Biz.Irobotbox.ReportCentre.CustomReportService.CheckSqlAndGetFields(String sqlContent, List`1 paramList)</div>
513- ~~<div>在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.CheckSqlAndGetFields()</div>~~
513+ <div>在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.CheckSqlAndGetFields()</div>
514- ~~<div>在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.Page_Load(Object sender, EventArgs e)</div>~~
514+ <div>在 PandaBuy.ERP.Web.IrobotBox.ReportCentre.CustomReportEdit.Page_Load(Object sender, EventArgs e)</div>
515- ~~<div>在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)</div>~~
515+ <div>在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)</div>
516- ~~<div>在 System.Web.UI.Control.OnLoad(EventArgs e)</div>~~
516+ <div>在 System.Web.UI.Control.OnLoad(EventArgs e)</div>
517- ~~<div>在 System.Web.UI.Control.LoadRecursive()</div>~~
517+ <div>在 System.Web.UI.Control.LoadRecursive()</div>
518- ~~<div>在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</div>~~
518+ <div>在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</div>
519- ~~<div>在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</div>~~
519+ <div>在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)</div>
520- ~~<div>在 System.Web.UI.Page.ProcessRequest()</div>~~
520+ <div>在 System.Web.UI.Page.ProcessRequest()</div>
521- ~~<div>在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)</div>~~
521+ <div>在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)</div>
522- ~~<div>在 System.Web.UI.Page.ProcessRequest(HttpContext context)</div>~~
522+ <div>在 System.Web.UI.Page.ProcessRequest(HttpContext context)</div>
523- ~~<div>在 ASP.irobotbox_reportcentre_customreportedit_aspx.ProcessRequest(HttpContext context)</div>~~
523+ <div>在 ASP.irobotbox_reportcentre_customreportedit_aspx.ProcessRequest(HttpContext context)</div>
524- ~~<div>在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()</div>~~
524+ <div>在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()</div>
525- ~~<div>在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)</div>~~
525+ <div>在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)</div>
526- ~~<div>在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)</div>~~
526+ <div>在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)</div>
527- ~~<div>在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)</div>~~
527+ <div>在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)</div>
528- ~~<div>在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)</div>~~
528+ <div>在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)</div>
529- ~~<div>在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)</div>~~
529+ <div>在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)</div>
530- ~~<div>在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)</div>~~
530+ <div>在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)</div>
531- ~~<div>在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)</div>~~
531+ <div>在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)</div>
532- ~~<div>~~
532+ <div>
533- ~~<hr /></div>~~
533+ <hr /></div>
534- ~~<div>~~
534+ <div>
535- ~~<div><br /></div>~~
535+ <div><br /></div>
536- ~~</div>~~
536+ </div>
537- ~~<div>~~
537+ <div>
538- ~~<div><br /><br /></div>~~
538+ <div><br /><br /></div>
539- ~~</div>~~
539+ </div>
540-
540+ <br />
541- ~~<br />~~

数据报表同事的可空字段写法错误

正确写法 AND {{osl.AddTime < @end_addtime}}
2023-10-20 16:36:36, 由 谢业福 指派给程伟。
修改了 指派给，旧值为 "xieyefu"，新值为 "chengwei"。
2023-10-20 19:10:33, 由程伟指派给 李乐同。
修改了 指派给，旧值为 "chengwei"，新值为 "liletong"。
2023-10-20 19:36:35, 由 李乐同 指派给 甘振豪。
修改了 指派给，旧值为 "liletong"，新值为 "ganzhenhao"。
2023-11-07 18:33:34, 由 甘振豪 指派给 黄爱琳。
修改了 指派给，旧值为 "ganzhenhao"，新值为 "huangailin"。

数据工程部同事没有禅道账号，自定义报告负责人：雷洋或者蓝静怡
2023-11-17 09:53:24, 由刘超编辑。
修改了 所属模块，旧值为 "1740"，新值为 "1863"。
2023-11-21 19:19:22, 由周杰指派给 吴高发。
修改了 指派给，旧值为 "huangailin"，新值为 "wugaofa"。

线下拉群和数据工程部的人沟通他们没有禅道账号，沟通解决完之后再操作关闭BUG
2023-11-22 09:53:15, 由 吴高发 解决，方案为 程序BUG 。
修改了 解决方案，旧值为 ""，新值为 "code"。
修改了 解决日期，旧值为 ""，新值为 "2023-11-22 09:52:21"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "wugaofa"。

差一个逗号。
2023-11-22 09:54:51, 由 吴高发 关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "wugaofa"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "wugaofa"。
修改了 关闭日期，旧值为 ""，新值为 "2023-11-22 09:54:51"。

已告知数据组。

基本信息
迭代/需求/任务

所属项目	技术中心-需求池
所属模块	系统运维性能优化
所属计划
所属迭代
Bug类型	程序BUG
严重程度	提示
优先级	P2
Bug状态	已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效	0
激活次数	0
激活日期
是否确认	是
当前指派	Closed 于 2023-11-22 09:54:51
截止日期	0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给

所属迭代
相关需求
相关任务

Bug的一生
其他相关

由谁创建	吴高发于 2023-10-20 15:05:34
影响环境	577
由谁解决	吴高发于 2023-11-22 09:52:21
解决版本
解决方案	程序BUG
由谁关闭	吴高发于 2023-11-22 09:54:51
最后修改	吴高发于 2023-11-22 09:54:51

相关Bug

差一个逗号。