TASK#74560 删除服务唯一键调整 / 智能中心-智能刊登迭代

任务描述

需求描述

需求背景：由于后续ordersourceskuid需要去除，提前对删除服务做调整，将主键修改为OrderSourceSku+OrderSourceId唯一

需求实现

1、新增删除服务表，以OrderSourceSku+OrderSourceId唯一

2、新增一个临时服务，对数据做迁移

3、服务调整
listing检测服务对接新表
listing删除服务对接新表
同步服务对接新表
4.重刷数据

验收标准

暂无

历史记录

2024-05-21 09:58:48, 由 罗友军 创建。
2024-05-22 10:48:50, 由 梁秀丽 编辑。
修改了 最初预计，旧值为 "24"，新值为 "25"。
修改了 预计剩余，旧值为 "24"，新值为 "25"。
2024-05-23 17:33:18, 由商雷完成。
修改了 总计消耗，旧值为 "0"，新值为 "25"。
修改了 指派给 ，旧值为 "shanglei"，新值为 "luoyoujun"。
修改了 实际完成，旧值为 ""，新值为 "2024-05-23 17:32:20"。
修改了 任务状态，旧值为 "wait"，新值为 "done"。
修改了 实际开始，旧值为 "0000-00-00 00:00:00"，新值为 "2024-05-23 17:33:18"。
修改了 预计剩余，旧值为 "25"，新值为 "0"。
修改了 由谁完成，旧值为 ""，新值为 "shanglei"。

关联 Amazon.Rebuild Amzon.Cron
新增数据迁移服务
新增服务处理新表数据

2024-05-27 19:48:51, 由商雷添加备注。


20789 删除服务唯一键调整

ListingRemove_SyncHistory

删除服务-同步历史数据
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_SyncHistory","Params":{},"AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"SyncHistory","IsMultiThread":false,"TimeOut":0}


ListingRemove-Sync
删除服务-同步
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_Sync","Params":{},"AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"Sync","IsMultiThread":false,"TimeOut":0}



ListingRemove-Migration
删除服务-迁移历史数据
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_Migration-{0}","Params":{"Action":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"MigrationAsync","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG


ListingRemove-RunHistory
删除服务-执行历史数据
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_RunHistory-{0}","Params":{"Action":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"RunHistoryAsync","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG

ListingRemove-Run
删除服务-sku匹配listing
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_Run-{0}","Params":{"Action":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"Run","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG


ListingRemove-ResetSkuStatus
删除服务-重置sku检测状态
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_ResetSkuStatus-{0}","Params":{"Action":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"ResetSkuStatus","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG

ListingRemove-SyncStatus
删除服务-同步删除状态
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_SyncStatus-{0}","Params":{"Action":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"SyncStatus","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG

ListingRemove-CheckDeleteStatus
删除服务-检测删除状态
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_CheckDeleteStatus-{0}","Params":{"Action":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"CheckDeleteStatus","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG

2024-05-27 19:49:25, 由商雷添加备注。

测试时候服务开启顺序问我

2024-06-27 11:40:41, 由商雷添加备注。

20789 删除服务唯一键调整

ListingRemove_SyncHistory

删除服务-同步历史数据
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_SyncHistory","Params":{"Action:"SyncSku"},"AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"SyncHistory","IsMultiThread":false,"TimeOut":0}


ListingRemove-Sync
删除服务-同步
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_Sync","Params":{"Action":"SyncSku"},"AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"Sync","IsMultiThread":false,"TimeOut":0}



ListingRemove-Migration
删除服务-迁移历史数据
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_Migration-{0}","Params":{"SiteCode":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"MigrationAsync","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG


ListingRemove-RunHistory
删除服务-执行历史数据
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_RunHistory-{0}","Params":{"SiteCode":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"RunHistoryAsync","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG

ListingRemove-Run
删除服务-sku匹配listing
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_Run-{0}","Params":{"SiteCode":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"Run","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG


ListingRemove-ResetSkuStatus
删除服务-重置sku检测状态
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_ResetSkuStatus-{0}","Params":{"SiteCode":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"ResetSkuStatus","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG

ListingRemove-SyncStatus
删除服务-同步删除状态
ErpAmazonWorker
0 0 0/1 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_SyncStatus-{0}","Params":{"SiteCode":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"SyncStatus","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG

ListingRemove-CheckDeleteStatus
删除服务-检测删除状态
ErpAmazonWorker
0 0 0/12 * * ?
{"Exchange": "amazon.worker","Queue": "amazon.worker","ExchangeType": "topic","RouteKey":""}

{"ServiceName":"AmazonListingRemoveJob_CheckDeleteStatus-{0}","Params":{"SiteCode":"{0}"}, "AssemblyFullName":"Erp.Amazon.Worker","TypeFullName":"Erp.Amazon.Worker.CronJob.Remove.AmazonListingRemoveJob","ExecMethod":"CheckDeleteStatus","IsMultiThread":false,"TimeOut":0}

US,AE,AU,BR,CA,DE,ES,FR,GB,IN,IT,JP,MX,NL,PL,SA,SE,SG,TR,BE,EG

2024-06-27 16:11:21, 由商雷添加备注。

发版前关闭服务 AmazonDeleteListingV3Operation AmazonDeleteListingV3Run
2025-06-27 16:08:22, 由商雷关闭。
修改了 任务状态，旧值为 "done"，新值为 "closed"。
修改了 指派给 ，旧值为 "luoyoujun"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "shanglei"。
修改了 关闭时间，旧值为 "0000-00-00 00:00:00"，新值为 "2025-06-27 16:08:22"。
修改了 关闭原因，旧值为 ""，新值为 "done"。

基本信息
任务的一生

所属迭代	智能中心-智能刊登迭代
所属模块	智能中心-需求池战略独立项目智能刊登
相关需求	删除服务唯一键调整
指派给	Closed 于 2025-06-27 16:08:22
任务类型	后端
任务标签	初始
开发组
任务状态	已关闭
进度	100%
优先级	P1
关键词
抄送给

由谁创建	罗友军于 2024-05-21 09:58:48
由谁完成	商雷于 2024-05-23 17:32:20
由谁取消	暂无
由谁关闭	商雷于 2025-06-27 16:08:22
关闭原因	已完成
最后编辑	商雷于 2025-06-27 16:08:22

团队	最初预计	总计消耗	预计剩余

工时信息

最初预计	25工时
总计消耗	25工时
预计剩余	0工时
预计开始	2024-05-21
实际开始	2024-05-23
截止日期	2024-05-31