本文主要是介绍SQL 圆通大头笔对应全国建包拆包地的对应关系(以山东省青岛建包关系为例),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
打印出圆通电子面单效果图如下:
邵阳县780-252 015则为: 大头笔,邵阳县下面的条码为: 拆包地的5位数码,运送时机器会自动扫描此条码然后分配各个省份的拆包地中心,780为 :一段码【与面单上第一段码或前两段码对应】
Sp函数:
/* SELECT dbo.FN_Delete_Chinese('东营523-390 204','东营市','C'),dbo.FN_Delete_Chinese('武汉','武汉市','C'),
dbo.FN_Delete_Chinese('010100-041 201','东营市','C'),dbo.FN_Delete_Chinese('六安', '安徽省','P')
SELECT * from BAS_ExpressDestination where codeid like'%'+dbo.FN_Delete_Chinese('东营372-390 204')+'%'
SELECT * from BAS_ExpressDestination where PATINDEX('%'+dbo.FN_Delete_Chinese('东营372-390 204')+'%',codeid) > 0
SELECT * from BAS_ExpressDestination where CHARINDEX(dbo.FN_Delete_Chinese('宁波372-390 204'),codeid) > 0
*****************************************************************
作者: wei kong
日期: 2018/02/23
功能描述:截取去掉汉字并获取一段码
******************************************************************
* Change Log *
******************************************************************
Date CR/EN No. Programmer Descr
------------------------------------------------------------------
20180223 wei kong 增加截取去掉汉字的处理功能
******************************************************************
*/
ALTER FUNCTION [dbo].[FN_Delete_Chinese](@col varchar(100),@CityOrProv VARCHAR(100),@ifCityOrProv CHAR(1))
returns varchar(100)
AS
begindeclare @returnchar varchar(100),@len intselect @returnchar='',@len=1while(@len<=len(@col))begin--如果包含汉字IF(ASCII(substring(@col,@len,1))<122)set @returnchar=@returnchar+substring(@col,@len,1)set @len=@len+1end--用于直接截取横杠前面的数字 523-390 204--不为空并且汉字 数字混合情况if( @returnchar<>'' and charindex('-',@returnchar)>0 --处理横杠分割符后的长度大于0 and len(SUBSTRING(@returnchar,1, charindex('-',@returnchar)-1))=3--分割横线后的字节数等于3)BEGINSET @returnchar=SUBSTRING(@returnchar,1, charindex('-',@returnchar)-1)ENDELSEBEGIN--只有汉字情况和分割横线后的字节数大于3的处理如020600-142 088 ORDER BY SplitPkCode--处理没有横杠分割符 如010SET @returnchar=(SELECT top 1 CodeID from BAS_ExpressDestination where CHARINDEX(@CityOrProv,CASE when @ifCityOrProv='C' then BuildPkNameELSE CodeProv END )> 0 )ENDreturn @returnchar
end
使用示例:返回数据库中的一段码【与面单上第一段码或前两段码对应】
SELECT dbo.FN_Delete_Chinese('010', '北京','C') result:100
SELECT dbo.FN_Delete_Chinese('库尔勒', '新疆','P') result:960
SELECT dbo.FN_Delete_Chinese('嫩江', '黑龙江','P') result:240
上海 上海中心 上海浦西包 210901 210901 300 Y 2018-02-23 14:57:39.670 system 2018-02-23 14:57:39.670
浙江 杭州中心 杭州市内包 571926 571926 340 Y 2018-02-23 14:59:18.800 system 2018-02-23 14:59:18.800
上海 浦东中心 上海浦东包 210902 210902 330 Y 2018-02-23 14:57:39.860 system 2018-02-23 14:57:39.860
浙江 杭州中心 萧山包 571901 571065 343 Y 2018-02-23 14:59:18.820 system 2018-02-23 14:59:18.820
浙江 杭州中心 杭州中转包 571901 571901 342 Y 2018-02-23 14:59:18.840 system 2018-02-23 14:59:18.840
浙江 绍兴中转 绍兴中转包 575001 575001 360 Y 2018-02-23 14:59:18.863 system 2018-02-23 14:59:18.863
浙江 宁波中心 宁波市内包 574908 574908 370 Y 2018-02-23 14:59:18.880 system 2018-02-23 14:59:18.880
浙江 宁波中心 慈溪包 574901 574032 375 Y 2018-02-23 14:59:18.900 system 2018-02-23 14:59:18.900
浙江 嘉兴中心 嘉兴市内包 573902 573902 378 Y 2018-02-23 14:59:21.413 system 2018-02-23 14:59:21.413
浙江 嘉兴中心 桐乡包 573901 573010 377 Y 2018-02-23 14:59:21.433 system 2018-02-23 14:59:21.433
浙江 嘉兴中心 嘉兴中转包 573901 573901 376 Y 2018-02-23 14:59:21.453 system 2018-02-23 14:59:21.453
浙江 金华中心 义乌包 579901 579008 381 Y 2018-02-23 14:59:22.863 system 2018-02-23 14:59:22.863
浙江 金华中心 丽水中转包 579901 578001 382 Y 2018-02-23 14:59:22.887 system 2018-02-23 14:59:22.887
浙江 金华中心 金华中转包 579901 579901 380 Y 2018-02-23 14:59:22.907 system 2018-02-23 14:59:22.907
浙江 湖州中转 湖州中转包 572001 572001 366 Y 2018-02-23 14:59:24.477 system 2018-02-23 14:59:24.477
浙江 温州中心 温州市内包 577907 577907 390 Y 2018-02-23 14:59:24.497 system 2018-02-23 14:59:24.497
浙江 温州中心 温州中转包 577901 577901 392 Y 2018-02-23 14:59:24.517 system 2018-02-23 14:59:24.517
浙江 宁波中心 宁波中转包 574901 574901 372,371,373 Y 2018-02-23 14:59:18.900 system 2018-02-23 14:59:18.900
浙江 临海中心 临海中转包 576901 576901 386,387 Y 2018-02-23 14:59:22.927 system 2018-02-23 15:10:24.357
江苏 无锡中心 无锡市内包 510904 510904 411 Y 2018-02-23 15:14:10.790 system 2018-02-23 15:14:10.790
江苏 无锡中心 镇江包 510901 511001 412 Y 2018-02-23 15:14:10.810 system 2018-02-23 15:14:10.810
江苏 无锡中心 常熟包 510901 512102 413 Y 2018-02-23 15:14:10.840 system 2018-02-23 15:14:10.840
江苏 无锡中心 江阴包 510901 510031 415 Y 2018-02-23 15:14:10.913 system 2018-02-23 15:14:10.913
江苏 无锡中心 无锡中转包 510901 510901 410,417 Y 2018-02-23 15:14:11.010 system 2018-02-23 15:14:11.010
江苏 苏州中心 昆山包 512001 512053 421 Y 2018-02-23 15:14:11.063 system 2018-02-23 15:14:11.063
江苏 苏州中心 苏州中转包 512001 512001 420 Y 2018-02-23 15:14:11.113 system 2018-02-23 15:14:11.113
江苏 常州中转 常州中转包 519001 519001 426 Y 2018-02-23 15:14:11.153 system 2018-02-23 15:14:11.153
江苏 南京中心 南京市内包 250911 250911 400 Y 2018-02-23 15:14:11.190 system 2018-02-23 15:14:11.190
江苏 南京中心 南京中转包 250901 250901 402 Y 2018-02-23 15:14:11.210 system 2018-02-23 15:14:11.210
江苏 南通中心 南通市内包 513901 513001 437 Y 2018-02-23 15:14:11.230 system 2018-02-23 15:14:11.230
江苏 南通中心 南通中转包 513901 513901 436 Y 2018-02-23 15:14:11.250 system 2018-02-23 15:14:11.250
江苏 泰州中心 扬州包 523901 514001 431 Y 2018-02-23 15:14:11.270 system 2018-02-23 15:14:11.270
江苏 泰州中心 泰州中转包 523901 523901 430 Y 2018-02-23 15:14:11.287 system 2018-02-23 15:14:11.287
江苏 淮安中心 淮安中转包 517901 517901 440,441,443 Y 2018-02-23 15:14:11.307 system 2018-02-23 15:14:11.307
江苏 徐州中转 徐州中转包 516001 516001 446 Y 2018-02-23 15:14:11.327 system 2018-02-23 15:14:11.327
安徽 合肥中心 合肥市内包 551906 551906 450 Y 2018-02-23 15:19:57.463 system 2018-02-23 15:19:57.463
安徽 合肥中心 合肥中转包 551901 551901 452 Y 2018-02-23 15:19:57.483 system 2018-02-23 15:19:57.483
安徽 安庆接驳点 安庆中转包 556001 556001 454 Y 2018-02-23 15:19:57.507 system 2018-02-23 15:19:57.507
安徽 蚌埠中心 蚌埠中转包 552901 552901 470,471 Y 2018-02-23 15:19:57.537 system 2018-02-23 15:19:57.537
安徽 芜湖中心 芜湖市内包 553901 553001 461 Y 2018-02-23 15:19:57.587 system 2018-02-23 15:19:57.587
安徽 芜湖中心 芜湖中转包 553901 553901 460 Y 2018-02-23 15:19:57.883 system 2018-02-23 15:19:57.883
福建 泉州中心 厦门岛内包 595901 592001 571 Y 2018-02-23 15:22:17.300 system 2018-02-23 15:22:17.300
福建 泉州中心 厦门岛外包 595901 592007 573 Y 2018-02-23 15:22:17.320 system 2018-02-23 15:22:17.320
福建 泉州中心 泉州中转包 595901 595901 572 Y 2018-02-23 15:22:17.350 system 2018-02-23 15:22:17.350
福建 泉州中心 泉州市内包 595908 595908 570 Y 2018-02-23 15:22:17.373 system 2018-02-23 15:22:17.373
福建 三明中心 三明中转包 598901 598901 590 Y 2018-02-23 15:22:17.393 system 2018-02-23 15:22:17.393
福建 福州中心 福州市内包 591907 591907 580 Y 2018-02-23 15:22:17.413 system 2018-02-23 15:22:17.413
福建 福州中心 莆田包 591906 594001 575 Y 2018-02-23 15:22:17.433 system 2018-02-23 15:22:17.433
福建 福州中心 福州中转包 591906 591906 582 Y 2018-02-23 15:22:17.457 system 2018-02-23 15:22:17.457
山东 济南中心 济南市内包 531909 531909 500 Y 2018-02-23 15:24:55.610 system 2018-02-23 15:24:55.610
山东 济南中心 淄博包 531901 533001 503 Y 2018-02-23 15:24:55.627 system 2018-02-23 15:24:55.627
山东 济南中心 济南中转包 531901 531901 502 Y 2018-02-23 15:24:55.647 system 2018-02-23 15:24:55.647
山东 青岛中心 青岛包 532905 532905 526 Y 2018-02-23 15:24:55.673 system 2018-02-23 15:24:55.673
山东 潍坊中心 潍坊市内包 536901 536001 521 Y 2018-02-23 15:24:55.693 system 2018-02-23 15:24:55.693
山东 潍坊中心 潍坊中转包 536901 536901 520 Y 2018-02-23 15:24:55.710 system 2018-02-23 15:24:55.710
山东 临沂中心 临沂市内包 539006 539001 512 Y 2018-02-23 15:24:55.730 system 2018-02-23 15:24:55.730
山东 临沂中心 临沂中转包 539006 539006 510 Y 2018-02-23 15:24:55.750 system 2018-02-23 15:24:55.750
山东 济宁中心 济宁中转包 537901 537901 516 Y 2018-02-23 15:24:55.767 system 2018-02-23 15:24:55.767
山东 济宁中心 济宁市内包 537901 537001 518 Y 2018-02-23 15:24:55.787 system 2018-02-23 15:24:55.787
山东 烟台中心 烟台中转包 535001 535001 530 Y 2018-02-23 15:24:55.803 system 2018-02-23 15:24:55.803
湖北 武汉中心 武汉市内包 270918 270918 730 Y 2018-02-23 15:36:23.897 system 2018-02-23 15:36:23.897
湖北 武汉中心 武汉中转包 270902 270902 732 Y 2018-02-23 15:36:23.917 system 2018-02-23 15:36:23.917
湖北 荆州中心 荆州中转包 716901 716901 750,751 Y 2018-02-23 15:36:23.933 system 2018-02-23 15:36:23.933
湖北 襄阳中心 襄阳中转包 710901 710901 760 Y 2018-02-23 15:36:23.953 system 2018-02-23 15:36:23.953
湖北 武昌中心 武昌市内包 270919 270919 746 Y 2018-02-23 15:36:23.970 system 2018-02-23 15:36:23.970
湖北 武昌中心 武昌中转包 270919 270919 740 Y 2018-02-23 15:36:23.990 system 2018-02-23 15:36:23.990
湖南 长沙中心 长沙市内包 731917 731917 770 Y 2018-02-23 15:38:09.073 system 2018-02-23 15:38:09.073
湖南 长沙中心 长沙中转包 731901 731901 772 Y 2018-02-23 15:38:09.097 system 2018-02-23 15:38:09.097
湖南 常德接驳点 常德中转包 731901 736001 771 Y 2018-02-23 15:38:09.117 system 2018-02-23 15:38:09.117
湖南 怀化接驳点 怀化中转包 745001 745001 774 Y 2018-02-23 15:38:09.137 system 2018-02-23 15:38:09.137
湖南 衡阳中心 衡阳市内包 734901 734001 782 Y 2018-02-23 15:38:09.157 system 2018-02-23 15:38:09.157
湖南 衡阳中心 衡阳中转包 734901 734901 780 Y 2018-02-23 15:38:09.177 system 2018-02-23 15:38:09.177
河南 漯河中心 漯河市内包 395902 395902 710 Y 2018-02-23 15:39:13.017 system 2018-02-23 15:39:13.017
河南 漯河中心 漯河中转包 395901 395901 712 Y 2018-02-23 15:39:13.040 system 2018-02-23 15:39:13.040
河南 郑州中心 郑州市内包 371910 371910 700 Y 2018-02-23 15:39:13.060 system 2018-02-23 15:39:13.060
河南 郑州中心 郑州中转包 371901 371901 702 Y 2018-02-23 15:39:13.077 system 2018-02-23 15:39:13.077
河南 郑州中心 商丘包 371901 370001 707 Y 2018-02-23 15:39:13.097 system 2018-02-23 15:39:13.097
河南 郑州中心 洛阳包 371901 379001 703 Y 2018-02-23 15:39:13.113 system 2018-02-23 15:39:13.113
广东 广州中心 广州市内包 200992 200992 600 Y 2018-02-23 15:39:48.107 system 2018-02-23 15:39:48.107
广东 广州中心 广州中转包 200901 200901 602 Y 2018-02-23 15:39:48.127 system 2018-02-23 15:39:48.127
广东 虎门中心 东莞包 769901 769901 632 Y 2018-02-23 15:39:48.147 system 2018-02-23 15:39:48.147
广东 虎门中心 虎门中转包 769901 769901 630 Y 2018-02-23 15:39:48.163 system 2018-02-23 15:39:48.163
广东 虎门中心 汕尾包 769901 660001 631 Y 2018-02-23 15:39:48.197 system 2018-02-23 15:39:48.197
广东 虎门中心 惠州包 769901 752001 634 Y 2018-02-23 15:39:48.217 system 2018-02-23 15:39:48.217
广东 深圳中心 深圳中转包 755901 755901 650 Y 2018-02-23 15:39:48.233 system 2018-02-23 15:39:48.233
广东 揭阳中心 揭阳中转包 754903 754903 646 Y 2018-02-23 15:39:48.257 system 2018-02-23 15:39:48.257
广东 江门中心 江门中转包 750902 750902 640 Y 2018-02-23 15:39:48.280 system 2018-02-23 15:39:48.280
广东 江门中心 湛江包 750902 759001 641 Y 2018-02-23 15:39:48.300 system 2018-02-23 15:39:48.300
广东 江门中心 茂名包 750902 668001 642 Y 2018-02-23 15:39:48.320 system 2018-02-23 15:39:48.320
广东 佛山中心 佛山中转包 757902 757902 626 Y 2018-02-23 15:39:48.340 system 2018-02-23 15:39:48.340
海南 海口中心 海口市内包 898055 898055 672 Y 2018-02-23 15:42:07.530 system 2018-02-23 15:42:07.530
海南 海口中心 海口中转包 898031 898031 670 Y 2018-02-23 15:42:07.547 system 2018-02-23 15:42:07.547
广西 南宁中心 南宁市内包 771069 771069 660 Y 2018-02-23 15:53:59.627 system 2018-02-23 15:53:59.627
海南 三亚中心 三亚中转包 898907 898907 671 Y 2018-02-23 15:42:07.590 system 2018-02-23 15:42:07.590
广西 南宁中心 南宁中转包 771001 771001 662,661 Y 2018-02-23 15:53:59.650 system 2018-02-23 15:53:59.650
广西 南宁中心 玉林中转包 771001 775001 665 Y 2018-02-23 15:53:59.670 system 2018-02-23 15:53:59.670
广西 柳州中心 柳州市内包 772903 772003 668 Y 2018-02-23 15:53:59.690 system 2018-02-23 15:53:59.690
广西 柳州中心 柳州中转包 772903 772903 667 Y 2018-02-23 15:53:59.710 system 2018-02-23 15:53:59.710
广西 桂林接驳点 桂林中转包 773023 773023 664 Y 2018-02-23 15:53:59.730 system 2018-02-23 15:53:59.730
江西 南昌中心 南昌市内包 771906 771906 540 Y 2018-02-23 16:03:19.957 system 2018-02-23 16:03:19.957
江西 南昌中心 景德镇包 791901 798001 541 Y 2018-02-23 16:03:19.977 system 2018-02-23 16:03:19.977
江西 南昌中心 南昌中转包 791901 791901 542 Y 2018-02-23 16:03:20.000 system 2018-02-23 16:03:20.000
江西 九江接驳点 九江包 791901 792014 543 Y 2018-02-23 16:03:20.020 system 2018-02-23 16:03:20.020
江西 新余接驳点 新余中转包 790003 790003 556 Y 2018-02-23 16:03:20.043 system 2018-02-23 16:03:20.043
江西 赣州中心 赣州市内包 797903 797903 552 Y 2018-02-23 16:03:20.063 system 2018-02-23 16:03:20.063
江西 赣州中心 赣州中转包 797908 797908 550 Y 2018-02-23 16:03:20.080 system 2018-02-23 16:03:20.080
江西 横峰中心 横峰中转包 701901 701901 560 Y 2018-02-23 16:03:20.100 system 2018-02-23 16:03:20.100
北京 北京中心 北京市内包 100955 100955 100 Y 2018-02-23 16:04:27.807 system 2018-02-23 16:04:27.807
北京 北京中心 北京中转河北包 311039 100901 102,111 Y 2018-02-23 16:04:27.827 system 2018-02-23 16:04:27.827
北京 北京中心 秦皇岛包 311039 335001 105 Y 2018-02-23 16:04:27.850 system 2018-02-23 16:04:27.850
北京 北京中心 唐山包 311039 315001 101 Y 2018-02-23 16:04:27.893 system 2018-02-23 16:04:27.893
北京 北京中心 北京中转内蒙包 471015 100901 104 Y 呼伦贝尔地区 2018-02-23 16:04:27.913 system 2018-02-23 16:04:27.913
内蒙古 呼和浩特中心 呼市市内包 471021 471021 190 Y 2018-02-23 16:06:46.240 system 2018-02-23 16:06:46.240
内蒙古 呼和浩特中心 呼市中转包 471001 471001 192 Y 2018-02-23 16:06:46.263 system 2018-02-23 16:06:46.263
内蒙古 呼和浩特中心 包头包 471001 472001 193 Y 2018-02-23 16:06:46.280 system 2018-02-23 16:06:46.280
河北 石家庄中心 石家庄市内包 311909 311909 160 Y 2018-02-23 16:09:26.747 system 2018-02-23 16:09:26.747
河北 石家庄中心 石家庄中转包 311901 311901 162 Y 2018-02-23 16:09:26.770 system 2018-02-23 16:09:26.770
河北 石家庄中心 邯郸包 311901 310001 167 Y 2018-02-23 16:09:26.790 system 2018-02-23 16:09:26.790
河北 石家庄中心 保定包 311901 312001 163 Y 2018-02-23 16:09:26.807 system 2018-02-23 16:09:26.807
河北 石家庄中心 沧州包 311901 317001 161 Y 2018-02-23 16:09:26.827 system 2018-02-23 16:09:26.827
山西 太原中心 太原市内包 351908 351908 180 Y 2018-02-23 16:10:30.707 system 2018-02-23 16:10:30.707
山西 太原中心 太原中转包 351901 351901 182,183 Y 2018-02-23 16:10:30.723 system 2018-02-23 16:10:30.723
山西 侯马接驳点 侯马中转包 357017 357017 184 Y 2018-02-23 16:10:30.743 system 2018-02-23 16:10:30.743
山西 长治接驳点 长治中转包 355001 355001 186 Y 2018-02-23 16:10:30.763 system 2018-02-23 16:10:30.763
天津 天津中心 天津包 220902 220902 140 Y 2018-02-23 16:11:58.927 system 2018-02-23 16:11:58.927
陕西 西安中心 西安市内包 290911 290911 900 Y 2018-02-23 16:21:32.930 system 2018-02-23 16:21:32.930
陕西 西安中心 西安中转包 290901 290901 902 Y 2018-02-23 16:21:32.950 system 2018-02-23 16:21:32.950
陕西 西安中心 宝鸡包 290901 917014 908 Y 2018-02-23 16:21:32.970 system 2018-02-23 16:21:32.970
陕西 西安中心 庆阳包 934001 934001 913 Y 甘肃庆阳地区 2018-02-23 16:21:38.413 system 2018-02-23 16:21:38.413
陕西 西安中心 天水包 938001 938001 915 Y 甘肃天水地区、陇南地区:成县、两当县、徽县、西和县、礼县、康县 2018-02-23 16:21:38.457 system 2018-02-23 16:21:38.457
陕西 西安中心 陇南包 939001 939001 917 Y 甘肃陇南地区:仅陇南市、文县、宕昌县 2018-02-23 16:21:38.473 system 2018-02-23 16:21:38.473
陕西 西安中心 哈密包 902001 902001 921 Y 新疆哈密地区 2018-02-23 16:21:38.493 system 2018-02-23 16:21:38.493
陕西 榆林接驳点 榆林中转包 912006 912006 903 Y 2018-02-23 16:21:38.513 system 2018-02-23 16:21:38.513
陕西 咸阳接驳点 咸阳中转包 290785 290785 904 Y 2018-02-23 16:21:38.530 system 2018-02-23 16:21:38.530
陕西 汉中接驳点 汉中中转包 290088 290088 906 Y 2018-02-23 16:21:38.550 system 2018-02-23 16:21:38.550
甘肃 兰州中转 兰州市内包 931001 931001 932 Y 2018-02-23 16:24:17.487 system 2018-02-23 16:24:17.487
甘肃 兰州中转 兰州中转包 931001 931001 930 Y 2018-02-23 16:24:17.633 system 2018-02-23 16:24:17.633
宁夏 银川中转 银川中转包 951001 951001 950 Y 2018-02-23 16:24:52.717 system 2018-02-23 16:24:52.717
青海 西宁中转 西宁中转包 971001 971001 940 Y 2018-02-23 16:24:52.733 system 2018-02-23 16:24:52.733
新疆 乌鲁木齐中转 乌市市内包 991001 991001 960 Y 2018-02-23 16:25:50.800 system 2018-02-23 16:25:50.800
新疆 乌鲁木齐中转 乌市中转包 991001 991001 962,965 Y 2018-02-23 16:25:50.823 system 2018-02-23 16:25:50.823
黑龙江 哈尔滨中心 哈尔滨市内包 451023 451023 240 Y 2018-02-23 16:27:42.497 system 2018-02-23 16:27:42.497
黑龙江 哈尔滨中心 哈尔滨中转包 451001 451001 242 Y 2018-02-23 16:27:42.520 system 2018-02-23 16:27:42.520
黑龙江 哈尔滨中心 大庆包 451001 459001 241 Y 2018-02-23 16:27:42.543 system 2018-02-23 16:27:42.543
黑龙江 牡丹江接驳点 牡丹江中转包 453001 453001 244 Y 2018-02-23 16:27:42.567 system 2018-02-23 16:27:42.567
黑龙江 佳木斯接驳点 佳木斯中转包 454001 454001 245 Y 2018-02-23 16:27:42.590 system 2018-02-23 16:27:42.590
吉林 长春中心 长春市内包 431067 431067 220 Y 2018-02-23 16:29:21.413 system 2018-02-23 16:29:21.413
吉林 长春中心 长春中转包 431001 431001 222 Y 2018-02-23 16:29:21.440 system 2018-02-23 16:29:21.440
吉林 延吉接驳点 延吉中转包 431001 433002 226 Y 2018-02-23 16:29:21.460 system 2018-02-23 16:29:21.460
吉林 梅河口接驳点 梅河口中转包 435007 435007 224 Y 2018-02-23 16:29:21.483 system 2018-02-23 16:29:21.483
辽宁 盘锦中心 盘锦中转包 427901 427901 210 Y 2018-02-23 16:30:06.113 system 2018-02-23 16:30:06.113
辽宁 盘锦中心 大连包 427901 411001 211 Y 2018-02-23 16:30:06.143 system 2018-02-23 16:30:06.143
辽宁 沈阳中心 沈阳市内包 240091 240091 200 Y 2018-02-23 16:30:06.163 system 2018-02-23 16:30:06.163
辽宁 沈阳中心 沈阳中转包 240001 240001 202 Y 2018-02-23 16:30:06.187 system 2018-02-23 16:30:06.187
四川 成都中心 成都市内包 280104 280104 830 Y 2018-02-23 16:33:50.377 system 2018-02-23 16:33:50.377
四川 成都中心 成都中转包 280001 280001 832,836 Y 2018-02-23 16:33:50.400 system 2018-02-23 16:33:50.400
四川 成都中心 成都中转包 891001 280001 839 Y 西藏:昌都地区2018-02-23 16:33:50.420 system 2018-02-23 16:33:50.420
四川 西昌接驳点 西昌中转包 280001 834001 836 Y 凉山州西昌地区2018-02-23 16:33:50.443 system 2018-02-23 16:33:50.443
四川 绵阳接驳点 绵阳中转包 816001 816001 833 Y 2018-02-23 16:33:50.467 system 2018-02-23 16:33:50.467
四川 自贡中心 自贡中转包 813901 813901 846 Y 2018-02-23 16:33:50.487 system 2018-02-23 16:33:50.487
四川 自贡中心 自贡中转包 852019 813901 849 Y 贵州遵义地区:赤水市 2018-02-23 16:33:50.507 system 2018-02-23 16:33:50.507
四川 自贡中心 自贡中转包 870006 813901 849 Y 云南昭通地区:盐津县 2018-02-23 16:33:50.527 system 2018-02-23 16:33:50.527
四川 自贡中心 自贡中转包 870003 813901 849 Y 云南昭通地区:威信县 2018-02-23 16:33:50.547 system 2018-02-23 16:33:50.547
四川 南充中心 南充中转包 825901 825901 840 Y 2018-02-23 16:33:50.567 system 2018-02-23 16:33:50.567
四川 南充中心 达州包 825901 818001 843 Y 2018-02-23 16:33:50.587 system 2018-02-23 16:33:50.587
西藏 拉萨中转 拉萨中转包 891001 891001 880 Y 西藏自治区(除昌都地区) 2018-02-23 16:45:52.577 system 2018-02-23 16:45:52.577
云南 昆明中心 昆明市内包 871909 871909 870 Y 2018-02-23 16:46:26.977 system 2018-02-23 16:46:26.977
云南 昆明中心 滇南包 871906 871906 874 Y 2018-02-23 16:46:26.997 system 2018-02-23 16:46:26.997
云南 昆明中心 昆明中转包 871906 871906 872 Y 2018-02-23 16:46:27.020 system 2018-02-23 16:46:27.020
云南 滇西中心 滇西中转包 872901 872901 876 Y 2018-02-23 16:46:27.040 system 2018-02-23 16:46:27.040
贵州 贵阳中心 贵阳市内包 851053 851053 860 Y 2018-02-23 16:47:33.120 system 2018-02-23 16:47:33.120
贵州 贵阳中心 贵阳中转包 851001 851001 862 Y 2018-02-23 16:47:33.140 system 2018-02-23 16:47:33.140
贵州 贵阳中心 贵阳中转包 870002 851001 869 Y 云南昭通地区:镇雄县2018-02-23 16:47:33.157 system 2018-02-23 16:47:33.157
贵州 遵义接驳点 遵义中转包 852001 852001 864 Y 2018-02-23 16:47:33.183 system 2018-02-23 16:47:33.183
重庆 重庆中心 重庆中转包 230901 230901 800 Y 2018-02-23 16:49:45.617 system 2018-02-23 16:49:45.617
重庆 重庆中心 万州中转包 230039 230039 801 Y 2018-02-23 16:49:45.637 system 2018-02-23 16:49:45.637
陕西 西安中心 平凉包 933001 933001 911 Y 甘肃平凉地区 2018-02-23 16:21:32.977 system 2018-02-23 16:43:01.297
SQL语句:
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'上海', N'上海中心', N'上海浦西包', '210901', '210901', '300', 'Y', NULL, '2018-02-23 14:57:39.670', 'system', '2018-02-23 14:57:39.670');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'杭州中心', N'杭州市内包', '571926', '571926', '340', 'Y', NULL, '2018-02-23 14:59:18.800', 'system', '2018-02-23 14:59:18.800');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'上海', N'浦东中心', N'上海浦东包', '210902', '210902', '330', 'Y', NULL, '2018-02-23 14:57:39.860', 'system', '2018-02-23 14:57:39.860');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'杭州中心', N'萧山包', '571901', '571065', '343', 'Y', NULL, '2018-02-23 14:59:18.820', 'system', '2018-02-23 14:59:18.820');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'杭州中心', N'杭州中转包', '571901', '571901', '342', 'Y', NULL, '2018-02-23 14:59:18.840', 'system', '2018-02-23 14:59:18.840');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'绍兴中转', N'绍兴中转包', '575001', '575001', '360', 'Y', NULL, '2018-02-23 14:59:18.863', 'system', '2018-02-23 14:59:18.863');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'宁波中心', N'宁波市内包', '574908', '574908', '370', 'Y', NULL, '2018-02-23 14:59:18.880', 'system', '2018-02-23 14:59:18.880');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'宁波中心', N'慈溪包', '574901', '574032', '375', 'Y', NULL, '2018-02-23 14:59:18.900', 'system', '2018-02-23 14:59:18.900');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'嘉兴中心', N'嘉兴市内包', '573902', '573902', '378', 'Y', NULL, '2018-02-23 14:59:21.413', 'system', '2018-02-23 14:59:21.413');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'嘉兴中心', N'桐乡包', '573901', '573010', '377', 'Y', NULL, '2018-02-23 14:59:21.433', 'system', '2018-02-23 14:59:21.433');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'嘉兴中心', N'嘉兴中转包', '573901', '573901', '376', 'Y', NULL, '2018-02-23 14:59:21.453', 'system', '2018-02-23 14:59:21.453');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'金华中心', N'义乌包', '579901', '579008', '381', 'Y', NULL, '2018-02-23 14:59:22.863', 'system', '2018-02-23 14:59:22.863');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'金华中心', N'丽水中转包', '579901', '578001', '382', 'Y', NULL, '2018-02-23 14:59:22.887', 'system', '2018-02-23 14:59:22.887');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'金华中心', N'金华中转包', '579901', '579901', '380', 'Y', NULL, '2018-02-23 14:59:22.907', 'system', '2018-02-23 14:59:22.907');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'湖州中转', N'湖州中转包', '572001', '572001', '366', 'Y', NULL, '2018-02-23 14:59:24.477', 'system', '2018-02-23 14:59:24.477');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'温州中心', N'温州市内包', '577907', '577907', '390', 'Y', NULL, '2018-02-23 14:59:24.497', 'system', '2018-02-23 14:59:24.497');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'温州中心', N'温州中转包', '577901', '577901', '392', 'Y', NULL, '2018-02-23 14:59:24.517', 'system', '2018-02-23 14:59:24.517');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'宁波中心', N'宁波中转包', '574901', '574901', '372,371,373', 'Y', NULL, '2018-02-23 14:59:18.900', 'system', '2018-02-23 14:59:18.900');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'浙江', N'临海中心', N'临海中转包', '576901', '576901', '386,387', 'Y', NULL, '2018-02-23 14:59:22.927', 'system', '2018-02-23 15:10:24.357');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'无锡中心', N'无锡市内包', '510904', '510904', '411', 'Y', NULL, '2018-02-23 15:14:10.790', 'system', '2018-02-23 15:14:10.790');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'无锡中心', N'镇江包', '510901', '511001', '412', 'Y', NULL, '2018-02-23 15:14:10.810', 'system', '2018-02-23 15:14:10.810');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'无锡中心', N'常熟包', '510901', '512102', '413', 'Y', NULL, '2018-02-23 15:14:10.840', 'system', '2018-02-23 15:14:10.840');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'无锡中心', N'江阴包', '510901', '510031', '415', 'Y', NULL, '2018-02-23 15:14:10.913', 'system', '2018-02-23 15:14:10.913');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'无锡中心', N'无锡中转包', '510901', '510901', '410,417', 'Y', NULL, '2018-02-23 15:14:11.010', 'system', '2018-02-23 15:14:11.010');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'苏州中心', N'昆山包', '512001', '512053', '421', 'Y', NULL, '2018-02-23 15:14:11.063', 'system', '2018-02-23 15:14:11.063');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'苏州中心', N'苏州中转包', '512001', '512001', '420', 'Y', NULL, '2018-02-23 15:14:11.113', 'system', '2018-02-23 15:14:11.113');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'常州中转', N'常州中转包', '519001', '519001', '426', 'Y', NULL, '2018-02-23 15:14:11.153', 'system', '2018-02-23 15:14:11.153');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'南京中心', N'南京市内包', '250911', '250911', '400', 'Y', NULL, '2018-02-23 15:14:11.190', 'system', '2018-02-23 15:14:11.190');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'南京中心', N'南京中转包', '250901', '250901', '402', 'Y', NULL, '2018-02-23 15:14:11.210', 'system', '2018-02-23 15:14:11.210');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'南通中心', N'南通市内包', '513901', '513001', '437', 'Y', NULL, '2018-02-23 15:14:11.230', 'system', '2018-02-23 15:14:11.230');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'南通中心', N'南通中转包', '513901', '513901', '436', 'Y', NULL, '2018-02-23 15:14:11.250', 'system', '2018-02-23 15:14:11.250');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'泰州中心', N'扬州包', '523901', '514001', '431', 'Y', NULL, '2018-02-23 15:14:11.270', 'system', '2018-02-23 15:14:11.270');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'泰州中心', N'泰州中转包', '523901', '523901', '430', 'Y', NULL, '2018-02-23 15:14:11.287', 'system', '2018-02-23 15:14:11.287');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'淮安中心', N'淮安中转包', '517901', '517901', '440,441,443', 'Y', NULL, '2018-02-23 15:14:11.307', 'system', '2018-02-23 15:14:11.307');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江苏', N'徐州中转', N'徐州中转包', '516001', '516001', '446', 'Y', NULL, '2018-02-23 15:14:11.327', 'system', '2018-02-23 15:14:11.327');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'安徽', N'合肥中心', N'合肥市内包', '551906', '551906', '450', 'Y', NULL, '2018-02-23 15:19:57.463', 'system', '2018-02-23 15:19:57.463');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'安徽', N'合肥中心', N'合肥中转包', '551901', '551901', '452', 'Y', NULL, '2018-02-23 15:19:57.483', 'system', '2018-02-23 15:19:57.483');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'安徽', N'安庆接驳点', N'安庆中转包', '556001', '556001', '454', 'Y', NULL, '2018-02-23 15:19:57.507', 'system', '2018-02-23 15:19:57.507');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'安徽', N'蚌埠中心', N'蚌埠中转包', '552901', '552901', '470,471', 'Y', NULL, '2018-02-23 15:19:57.537', 'system', '2018-02-23 15:19:57.537');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'安徽', N'芜湖中心', N'芜湖市内包', '553901', '553001', '461', 'Y', NULL, '2018-02-23 15:19:57.587', 'system', '2018-02-23 15:19:57.587');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'安徽', N'芜湖中心', N'芜湖中转包', '553901', '553901', '460', 'Y', NULL, '2018-02-23 15:19:57.883', 'system', '2018-02-23 15:19:57.883');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'福建', N'泉州中心', N'厦门岛内包', '595901', '592001', '571', 'Y', NULL, '2018-02-23 15:22:17.300', 'system', '2018-02-23 15:22:17.300');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'福建', N'泉州中心', N'厦门岛外包', '595901', '592007', '573', 'Y', NULL, '2018-02-23 15:22:17.320', 'system', '2018-02-23 15:22:17.320');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'福建', N'泉州中心', N'泉州中转包', '595901', '595901', '572', 'Y', NULL, '2018-02-23 15:22:17.350', 'system', '2018-02-23 15:22:17.350');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'福建', N'泉州中心', N'泉州市内包', '595908', '595908', '570', 'Y', NULL, '2018-02-23 15:22:17.373', 'system', '2018-02-23 15:22:17.373');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'福建', N'三明中心', N'三明中转包', '598901', '598901', '590', 'Y', NULL, '2018-02-23 15:22:17.393', 'system', '2018-02-23 15:22:17.393');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'福建', N'福州中心', N'福州市内包', '591907', '591907', '580', 'Y', NULL, '2018-02-23 15:22:17.413', 'system', '2018-02-23 15:22:17.413');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'福建', N'福州中心', N'莆田包', '591906', '594001', '575', 'Y', NULL, '2018-02-23 15:22:17.433', 'system', '2018-02-23 15:22:17.433');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'福建', N'福州中心', N'福州中转包', '591906', '591906', '582', 'Y', NULL, '2018-02-23 15:22:17.457', 'system', '2018-02-23 15:22:17.457');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'济南中心', N'济南市内包', '531909', '531909', '500', 'Y', NULL, '2018-02-23 15:24:55.610', 'system', '2018-02-23 15:24:55.610');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'济南中心', N'淄博包', '531901', '533001', '503', 'Y', NULL, '2018-02-23 15:24:55.627', 'system', '2018-02-23 15:24:55.627');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'济南中心', N'济南中转包', '531901', '531901', '502', 'Y', NULL, '2018-02-23 15:24:55.647', 'system', '2018-02-23 15:24:55.647');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'青岛中心', N'青岛包', '532905', '532905', '526', 'Y', NULL, '2018-02-23 15:24:55.673', 'system', '2018-02-23 15:24:55.673');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'潍坊中心', N'潍坊市内包', '536901', '536001', '521', 'Y', NULL, '2018-02-23 15:24:55.693', 'system', '2018-02-23 15:24:55.693');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'潍坊中心', N'潍坊中转包', '536901', '536901', '520', 'Y', NULL, '2018-02-23 15:24:55.710', 'system', '2018-02-23 15:24:55.710');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'临沂中心', N'临沂市内包', '539006', '539001', '512', 'Y', NULL, '2018-02-23 15:24:55.730', 'system', '2018-02-23 15:24:55.730');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'临沂中心', N'临沂中转包', '539006', '539006', '510', 'Y', NULL, '2018-02-23 15:24:55.750', 'system', '2018-02-23 15:24:55.750');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'济宁中心', N'济宁中转包', '537901', '537901', '516', 'Y', NULL, '2018-02-23 15:24:55.767', 'system', '2018-02-23 15:24:55.767');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'济宁中心', N'济宁市内包', '537901', '537001', '518', 'Y', NULL, '2018-02-23 15:24:55.787', 'system', '2018-02-23 15:24:55.787');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山东', N'烟台中心', N'烟台中转包', '535001', '535001', '530', 'Y', NULL, '2018-02-23 15:24:55.803', 'system', '2018-02-23 15:24:55.803');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖北', N'武汉中心', N'武汉市内包', '270918', '270918', '730', 'Y', NULL, '2018-02-23 15:36:23.897', 'system', '2018-02-23 15:36:23.897');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖北', N'武汉中心', N'武汉中转包', '270902', '270902', '732', 'Y', NULL, '2018-02-23 15:36:23.917', 'system', '2018-02-23 15:36:23.917');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖北', N'荆州中心', N'荆州中转包', '716901', '716901', '750,751', 'Y', NULL, '2018-02-23 15:36:23.933', 'system', '2018-02-23 15:36:23.933');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖北', N'襄阳中心', N'襄阳中转包', '710901', '710901', '760', 'Y', NULL, '2018-02-23 15:36:23.953', 'system', '2018-02-23 15:36:23.953');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖北', N'武昌中心', N'武昌市内包', '270919', '270919', '746', 'Y', NULL, '2018-02-23 15:36:23.970', 'system', '2018-02-23 15:36:23.970');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖北', N'武昌中心', N'武昌中转包', '270919', '270919', '740', 'Y', NULL, '2018-02-23 15:36:23.990', 'system', '2018-02-23 15:36:23.990');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖南', N'长沙中心', N'长沙市内包', '731917', '731917', '770', 'Y', NULL, '2018-02-23 15:38:09.073', 'system', '2018-02-23 15:38:09.073');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖南', N'长沙中心', N'长沙中转包', '731901', '731901', '772', 'Y', NULL, '2018-02-23 15:38:09.097', 'system', '2018-02-23 15:38:09.097');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖南', N'常德接驳点', N'常德中转包', '731901', '736001', '771', 'Y', NULL, '2018-02-23 15:38:09.117', 'system', '2018-02-23 15:38:09.117');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖南', N'怀化接驳点', N'怀化中转包', '745001', '745001', '774', 'Y', NULL, '2018-02-23 15:38:09.137', 'system', '2018-02-23 15:38:09.137');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖南', N'衡阳中心', N'衡阳市内包', '734901', '734001', '782', 'Y', NULL, '2018-02-23 15:38:09.157', 'system', '2018-02-23 15:38:09.157');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'湖南', N'衡阳中心', N'衡阳中转包', '734901', '734901', '780', 'Y', NULL, '2018-02-23 15:38:09.177', 'system', '2018-02-23 15:38:09.177');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河南', N'漯河中心', N'漯河市内包', '395902', '395902', '710', 'Y', NULL, '2018-02-23 15:39:13.017', 'system', '2018-02-23 15:39:13.017');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河南', N'漯河中心', N'漯河中转包', '395901', '395901', '712', 'Y', NULL, '2018-02-23 15:39:13.040', 'system', '2018-02-23 15:39:13.040');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河南', N'郑州中心', N'郑州市内包', '371910', '371910', '700', 'Y', NULL, '2018-02-23 15:39:13.060', 'system', '2018-02-23 15:39:13.060');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河南', N'郑州中心', N'郑州中转包', '371901', '371901', '702', 'Y', NULL, '2018-02-23 15:39:13.077', 'system', '2018-02-23 15:39:13.077');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河南', N'郑州中心', N'商丘包', '371901', '370001', '707', 'Y', NULL, '2018-02-23 15:39:13.097', 'system', '2018-02-23 15:39:13.097');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河南', N'郑州中心', N'洛阳包', '371901', '379001', '703', 'Y', NULL, '2018-02-23 15:39:13.113', 'system', '2018-02-23 15:39:13.113');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'广州中心', N'广州市内包', '200992', '200992', '600', 'Y', NULL, '2018-02-23 15:39:48.107', 'system', '2018-02-23 15:39:48.107');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'广州中心', N'广州中转包', '200901', '200901', '602', 'Y', NULL, '2018-02-23 15:39:48.127', 'system', '2018-02-23 15:39:48.127');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'虎门中心', N'东莞包', '769901', '769901', '632', 'Y', NULL, '2018-02-23 15:39:48.147', 'system', '2018-02-23 15:39:48.147');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'虎门中心', N'虎门中转包', '769901', '769901', '630', 'Y', NULL, '2018-02-23 15:39:48.163', 'system', '2018-02-23 15:39:48.163');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'虎门中心', N'汕尾包', '769901', '660001', '631', 'Y', NULL, '2018-02-23 15:39:48.197', 'system', '2018-02-23 15:39:48.197');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'虎门中心', N'惠州包', '769901', '752001', '634', 'Y', NULL, '2018-02-23 15:39:48.217', 'system', '2018-02-23 15:39:48.217');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'深圳中心', N'深圳中转包', '755901', '755901', '650', 'Y', NULL, '2018-02-23 15:39:48.233', 'system', '2018-02-23 15:39:48.233');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'揭阳中心', N'揭阳中转包', '754903', '754903', '646', 'Y', NULL, '2018-02-23 15:39:48.257', 'system', '2018-02-23 15:39:48.257');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'江门中心', N'江门中转包', '750902', '750902', '640', 'Y', NULL, '2018-02-23 15:39:48.280', 'system', '2018-02-23 15:39:48.280');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'江门中心', N'湛江包', '750902', '759001', '641', 'Y', NULL, '2018-02-23 15:39:48.300', 'system', '2018-02-23 15:39:48.300');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'江门中心', N'茂名包', '750902', '668001', '642', 'Y', NULL, '2018-02-23 15:39:48.320', 'system', '2018-02-23 15:39:48.320');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广东', N'佛山中心', N'佛山中转包', '757902', '757902', '626', 'Y', NULL, '2018-02-23 15:39:48.340', 'system', '2018-02-23 15:39:48.340');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'海南', N'海口中心', N'海口市内包', '898055', '898055', '672', 'Y', NULL, '2018-02-23 15:42:07.530', 'system', '2018-02-23 15:42:07.530');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'海南', N'海口中心', N'海口中转包', '898031', '898031', '670', 'Y', NULL, '2018-02-23 15:42:07.547', 'system', '2018-02-23 15:42:07.547');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广西', N'南宁中心', N'南宁市内包', '771069', '771069', '660', 'Y', NULL, '2018-02-23 15:53:59.627', 'system', '2018-02-23 15:53:59.627');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'海南', N'三亚中心', N'三亚中转包', '898907', '898907', '671', 'Y', NULL, '2018-02-23 15:42:07.590', 'system', '2018-02-23 15:42:07.590');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广西', N'南宁中心', N'南宁中转包', '771001', '771001', '662,661', 'Y', NULL, '2018-02-23 15:53:59.650', 'system', '2018-02-23 15:53:59.650');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广西', N'南宁中心', N'玉林中转包', '771001', '775001', '665', 'Y', NULL, '2018-02-23 15:53:59.670', 'system', '2018-02-23 15:53:59.670');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广西', N'柳州中心', N'柳州市内包', '772903', '772003', '668', 'Y', NULL, '2018-02-23 15:53:59.690', 'system', '2018-02-23 15:53:59.690');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广西', N'柳州中心', N'柳州中转包', '772903', '772903', '667', 'Y', NULL, '2018-02-23 15:53:59.710', 'system', '2018-02-23 15:53:59.710');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'广西', N'桂林接驳点', N'桂林中转包', '773023', '773023', '664', 'Y', NULL, '2018-02-23 15:53:59.730', 'system', '2018-02-23 15:53:59.730');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江西', N'南昌中心', N'南昌市内包', '771906', '771906', '540', 'Y', NULL, '2018-02-23 16:03:19.957', 'system', '2018-02-23 16:03:19.957');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江西', N'南昌中心', N'景德镇包', '791901', '798001', '541', 'Y', NULL, '2018-02-23 16:03:19.977', 'system', '2018-02-23 16:03:19.977');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江西', N'南昌中心', N'南昌中转包', '791901', '791901', '542', 'Y', NULL, '2018-02-23 16:03:20.000', 'system', '2018-02-23 16:03:20.000');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江西', N'九江接驳点', N'九江包', '791901', '792014', '543', 'Y', NULL, '2018-02-23 16:03:20.020', 'system', '2018-02-23 16:03:20.020');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江西', N'新余接驳点', N'新余中转包', '790003', '790003', '556', 'Y', NULL, '2018-02-23 16:03:20.043', 'system', '2018-02-23 16:03:20.043');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江西', N'赣州中心', N'赣州市内包', '797903', '797903', '552', 'Y', NULL, '2018-02-23 16:03:20.063', 'system', '2018-02-23 16:03:20.063');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江西', N'赣州中心', N'赣州中转包', '797908', '797908', '550', 'Y', NULL, '2018-02-23 16:03:20.080', 'system', '2018-02-23 16:03:20.080');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'江西', N'横峰中心', N'横峰中转包', '701901', '701901', '560', 'Y', NULL, '2018-02-23 16:03:20.100', 'system', '2018-02-23 16:03:20.100');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'北京', N'北京中心', N'北京市内包', '100955', '100955', '100', 'Y', NULL, '2018-02-23 16:04:27.807', 'system', '2018-02-23 16:04:27.807');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'北京', N'北京中心', N'北京中转河北包', '311039', '100901', '102,111', 'Y', NULL, '2018-02-23 16:04:27.827', 'system', '2018-02-23 16:04:27.827');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'北京', N'北京中心', N'秦皇岛包', '311039', '335001', '105', 'Y', NULL, '2018-02-23 16:04:27.850', 'system', '2018-02-23 16:04:27.850');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'北京', N'北京中心', N'唐山包', '311039', '315001', '101', 'Y', NULL, '2018-02-23 16:04:27.893', 'system', '2018-02-23 16:04:27.893');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'北京', N'北京中心', N'北京中转内蒙包', '471015', '100901', '104', 'Y', N'呼伦贝尔地区
', '2018-02-23 16:04:27.913', 'system', '2018-02-23 16:04:27.913');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'内蒙古', N'呼和浩特中心', N'呼市市内包', '471021', '471021', '190', 'Y', NULL, '2018-02-23 16:06:46.240', 'system', '2018-02-23 16:06:46.240');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'内蒙古', N'呼和浩特中心', N'呼市中转包', '471001', '471001', '192', 'Y', NULL, '2018-02-23 16:06:46.263', 'system', '2018-02-23 16:06:46.263');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'内蒙古', N'呼和浩特中心', N'包头包', '471001', '472001', '193', 'Y', NULL, '2018-02-23 16:06:46.280', 'system', '2018-02-23 16:06:46.280');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河北', N'石家庄中心', N'石家庄市内包', '311909', '311909', '160', 'Y', NULL, '2018-02-23 16:09:26.747', 'system', '2018-02-23 16:09:26.747');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河北', N'石家庄中心', N'石家庄中转包', '311901', '311901', '162', 'Y', NULL, '2018-02-23 16:09:26.770', 'system', '2018-02-23 16:09:26.770');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河北', N'石家庄中心', N'邯郸包', '311901', '310001', '167', 'Y', NULL, '2018-02-23 16:09:26.790', 'system', '2018-02-23 16:09:26.790');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河北', N'石家庄中心', N'保定包', '311901', '312001', '163', 'Y', NULL, '2018-02-23 16:09:26.807', 'system', '2018-02-23 16:09:26.807');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'河北', N'石家庄中心', N'沧州包', '311901', '317001', '161', 'Y', NULL, '2018-02-23 16:09:26.827', 'system', '2018-02-23 16:09:26.827');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山西', N'太原中心', N'太原市内包', '351908', '351908', '180', 'Y', NULL, '2018-02-23 16:10:30.707', 'system', '2018-02-23 16:10:30.707');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山西', N'太原中心', N'太原中转包', '351901', '351901', '182,183', 'Y', NULL, '2018-02-23 16:10:30.723', 'system', '2018-02-23 16:10:30.723');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山西', N'侯马接驳点', N'侯马中转包', '357017', '357017', '184', 'Y', NULL, '2018-02-23 16:10:30.743', 'system', '2018-02-23 16:10:30.743');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'山西', N'长治接驳点', N'长治中转包', '355001', '355001', '186', 'Y', NULL, '2018-02-23 16:10:30.763', 'system', '2018-02-23 16:10:30.763');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'天津', N'天津中心', N'天津包', '220902', '220902', '140', 'Y', NULL, '2018-02-23 16:11:58.927', 'system', '2018-02-23 16:11:58.927');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'西安中心', N'西安市内包', '290911', '290911', '900', 'Y', NULL, '2018-02-23 16:21:32.930', 'system', '2018-02-23 16:21:32.930');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'西安中心', N'西安中转包', '290901', '290901', '902', 'Y', NULL, '2018-02-23 16:21:32.950', 'system', '2018-02-23 16:21:32.950');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'西安中心', N'宝鸡包', '290901', '917014', '908', 'Y', NULL, '2018-02-23 16:21:32.970', 'system', '2018-02-23 16:21:32.970');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'西安中心', N'庆阳包', '934001', '934001', '913', 'Y', N'甘肃庆阳地区', '2018-02-23 16:21:38.413', 'system', '2018-02-23 16:21:38.413');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'西安中心', N'天水包', '938001', '938001', '915', 'Y', N'甘肃天水地区、陇南地区:成县、两当县、徽县、西和县、礼县、康县', '2018-02-23 16:21:38.457', 'system', '2018-02-23 16:21:38.457');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'西安中心', N'陇南包', '939001', '939001', '917', 'Y', N'甘肃陇南地区:仅陇南市、文县、宕昌县', '2018-02-23 16:21:38.473', 'system', '2018-02-23 16:21:38.473');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'西安中心', N'哈密包', '902001', '902001', '921', 'Y', N'新疆哈密地区', '2018-02-23 16:21:38.493', 'system', '2018-02-23 16:21:38.493');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'榆林接驳点', N'榆林中转包', '912006', '912006', '903', 'Y', NULL, '2018-02-23 16:21:38.513', 'system', '2018-02-23 16:21:38.513');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'咸阳接驳点', N'咸阳中转包', '290785', '290785', '904', 'Y', NULL, '2018-02-23 16:21:38.530', 'system', '2018-02-23 16:21:38.530');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'汉中接驳点', N'汉中中转包', '290088', '290088', '906', 'Y', NULL, '2018-02-23 16:21:38.550', 'system', '2018-02-23 16:21:38.550');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'甘肃', N'兰州中转', N'兰州市内包', '931001', '931001', '932', 'Y', NULL, '2018-02-23 16:24:17.487', 'system', '2018-02-23 16:24:17.487');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'甘肃', N'兰州中转', N'兰州中转包', '931001', '931001', '930', 'Y', NULL, '2018-02-23 16:24:17.633', 'system', '2018-02-23 16:24:17.633');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'宁夏', N'银川中转', N'银川中转包', '951001', '951001', '950', 'Y', NULL, '2018-02-23 16:24:52.717', 'system', '2018-02-23 16:24:52.717');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'青海', N'西宁中转', N'西宁中转包', '971001', '971001', '940', 'Y', NULL, '2018-02-23 16:24:52.733', 'system', '2018-02-23 16:24:52.733');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'新疆', N'乌鲁木齐中转', N'乌市市内包', '991001', '991001', '960', 'Y', NULL, '2018-02-23 16:25:50.800', 'system', '2018-02-23 16:25:50.800');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'新疆', N'乌鲁木齐中转', N'乌市中转包', '991001', '991001', '962,965', 'Y', NULL, '2018-02-23 16:25:50.823', 'system', '2018-02-23 16:25:50.823');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'黑龙江', N'哈尔滨中心', N'哈尔滨市内包', '451023', '451023', '240', 'Y', NULL, '2018-02-23 16:27:42.497', 'system', '2018-02-23 16:27:42.497');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'黑龙江', N'哈尔滨中心', N'哈尔滨中转包', '451001', '451001', '242', 'Y', NULL, '2018-02-23 16:27:42.520', 'system', '2018-02-23 16:27:42.520');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'黑龙江', N'哈尔滨中心', N'大庆包', '451001', '459001', '241', 'Y', NULL, '2018-02-23 16:27:42.543', 'system', '2018-02-23 16:27:42.543');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'黑龙江', N'牡丹江接驳点', N'牡丹江中转包', '453001', '453001', '244', 'Y', NULL, '2018-02-23 16:27:42.567', 'system', '2018-02-23 16:27:42.567');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'黑龙江', N'佳木斯接驳点', N'佳木斯中转包', '454001', '454001', '245', 'Y', NULL, '2018-02-23 16:27:42.590', 'system', '2018-02-23 16:27:42.590');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'吉林', N'长春中心', N'长春市内包', '431067', '431067', '220', 'Y', NULL, '2018-02-23 16:29:21.413', 'system', '2018-02-23 16:29:21.413');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'吉林', N'长春中心', N'长春中转包', '431001', '431001', '222', 'Y', NULL, '2018-02-23 16:29:21.440', 'system', '2018-02-23 16:29:21.440');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'吉林', N'延吉接驳点', N'延吉中转包', '431001', '433002', '226', 'Y', NULL, '2018-02-23 16:29:21.460', 'system', '2018-02-23 16:29:21.460');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'吉林', N'梅河口接驳点', N'梅河口中转包', '435007', '435007', '224', 'Y', NULL, '2018-02-23 16:29:21.483', 'system', '2018-02-23 16:29:21.483');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'辽宁', N'盘锦中心', N'盘锦中转包', '427901', '427901', '210', 'Y', NULL, '2018-02-23 16:30:06.113', 'system', '2018-02-23 16:30:06.113');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'辽宁', N'盘锦中心', N'大连包', '427901', '411001', '211', 'Y', NULL, '2018-02-23 16:30:06.143', 'system', '2018-02-23 16:30:06.143');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'辽宁', N'沈阳中心', N'沈阳市内包', '240091', '240091', '200', 'Y', NULL, '2018-02-23 16:30:06.163', 'system', '2018-02-23 16:30:06.163');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'辽宁', N'沈阳中心', N'沈阳中转包', '240001', '240001', '202', 'Y', NULL, '2018-02-23 16:30:06.187', 'system', '2018-02-23 16:30:06.187');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'成都中心', N'成都市内包', '280104', '280104', '830', 'Y', NULL, '2018-02-23 16:33:50.377', 'system', '2018-02-23 16:33:50.377');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'成都中心', N'成都中转包', '280001', '280001', '832,836', 'Y', NULL, '2018-02-23 16:33:50.400', 'system', '2018-02-23 16:33:50.400');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'成都中心', N'成都中转包', '891001', '280001', '839', 'Y', N'西藏:昌都地区
', '2018-02-23 16:33:50.420', 'system', '2018-02-23 16:33:50.420');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'西昌接驳点', N'西昌中转包', '280001', '834001', '836', 'Y', N'凉山州西昌地区
', '2018-02-23 16:33:50.443', 'system', '2018-02-23 16:33:50.443');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'绵阳接驳点', N'绵阳中转包', '816001', '816001', '833', 'Y', NULL, '2018-02-23 16:33:50.467', 'system', '2018-02-23 16:33:50.467');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'自贡中心', N'自贡中转包', '813901', '813901', '846', 'Y', NULL, '2018-02-23 16:33:50.487', 'system', '2018-02-23 16:33:50.487');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'自贡中心', N'自贡中转包', '852019', '813901', '849', 'Y', N'贵州遵义地区:赤水市', '2018-02-23 16:33:50.507', 'system', '2018-02-23 16:33:50.507');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'自贡中心', N'自贡中转包', '870006', '813901', '849', 'Y', N'云南昭通地区:盐津县', '2018-02-23 16:33:50.527', 'system', '2018-02-23 16:33:50.527');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'自贡中心', N'自贡中转包', '870003', '813901', '849', 'Y', N'云南昭通地区:威信县', '2018-02-23 16:33:50.547', 'system', '2018-02-23 16:33:50.547');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'南充中心', N'南充中转包', '825901', '825901', '840', 'Y', NULL, '2018-02-23 16:33:50.567', 'system', '2018-02-23 16:33:50.567');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'四川', N'南充中心', N'达州包', '825901', '818001', '843', 'Y', NULL, '2018-02-23 16:33:50.587', 'system', '2018-02-23 16:33:50.587');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'西藏', N'拉萨中转', N'拉萨中转包', '891001', '891001', '880', 'Y', N'西藏自治区(除昌都地区)', '2018-02-23 16:45:52.577', 'system', '2018-02-23 16:45:52.577');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'云南', N'昆明中心', N'昆明市内包', '871909', '871909', '870', 'Y', NULL, '2018-02-23 16:46:26.977', 'system', '2018-02-23 16:46:26.977');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'云南', N'昆明中心', N'滇南包', '871906', '871906', '874', 'Y', NULL, '2018-02-23 16:46:26.997', 'system', '2018-02-23 16:46:26.997');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'云南', N'昆明中心', N'昆明中转包', '871906', '871906', '872', 'Y', NULL, '2018-02-23 16:46:27.020', 'system', '2018-02-23 16:46:27.020');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'云南', N'滇西中心', N'滇西中转包', '872901', '872901', '876', 'Y', NULL, '2018-02-23 16:46:27.040', 'system', '2018-02-23 16:46:27.040');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'贵州', N'贵阳中心', N'贵阳市内包', '851053', '851053', '860', 'Y', NULL, '2018-02-23 16:47:33.120', 'system', '2018-02-23 16:47:33.120');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'贵州', N'贵阳中心', N'贵阳中转包', '851001', '851001', '862', 'Y', NULL, '2018-02-23 16:47:33.140', 'system', '2018-02-23 16:47:33.140');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'贵州', N'贵阳中心', N'贵阳中转包', '870002', '851001', '869', 'Y', N'云南昭通地区:镇雄县
', '2018-02-23 16:47:33.157', 'system', '2018-02-23 16:47:33.157');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'贵州', N'遵义接驳点', N'遵义中转包', '852001', '852001', '864', 'Y', NULL, '2018-02-23 16:47:33.183', 'system', '2018-02-23 16:47:33.183');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'重庆', N'重庆中心', N'重庆中转包', '230901', '230901', '800', 'Y', NULL, '2018-02-23 16:49:45.617', 'system', '2018-02-23 16:49:45.617');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'重庆', N'重庆中心', N'万州中转包', '230039', '230039', '801', 'Y', NULL, '2018-02-23 16:49:45.637', 'system', '2018-02-23 16:49:45.637');
INSERT INTO [dbo].[BAS_ExpressDestination]([CodeProv], [CodeCityCenter], [BuildPkName], [CollectionCode], [SplitPkCode], [CodeID], [UDF_OPR_CHK], [Notes], [AddTime], [AddWho], [EditTime]) VALUES (N'陕西', N'西安中心', N'平凉包', '933001', '933001', '911', 'Y', N'甘肃平凉地区', '2018-02-23 16:21:32.977', 'system', '2018-02-23 16:43:01.297');
使用示例:
c.C_City =青岛市 c.C_Province=山东省
select ISNULL(dbo.FN_Delete_Chinese(c.SOReference4,SUBSTRING(c.C_City,0, len(c.C_City)),'C'), dbo.FN_Delete_Chinese(c.SOReference4,SUBSTRING(c.C_Province,0, 3),'P') ) as Code --15,(SELECT SplitPkCode from BAS_ExpressDestination where CHARINDEX(ISNULL(dbo.FN_Delete_Chinese(c.SOReference4,SUBSTRING(c.C_City,0, len(c.C_City)),'C') ,
dbo.FN_Delete_Chinese(c.SOReference4,SUBSTRING(c.C_Province,0, 3),'P') ),codeid) > 0) as CodeName_C
返回结果是Code: 526 CodeName_C:532905.
这篇关于SQL 圆通大头笔对应全国建包拆包地的对应关系(以山东省青岛建包关系为例)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!