2025/6/21 0:00:12 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS20250610155622A380,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250620113409B31B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202505131129363827,COS20250618172234E3C1,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250620182717DDF7,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 1:00:06 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS20250610155622A380,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250620113409B31B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202505131129363827,COS20250618172234E3C1,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250620182717DDF7,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 2:00:09 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS20250610155622A380,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250620113409B31B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202505131129363827,COS20250618172234E3C1,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250620182717DDF7,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 3:00:07 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS20250610155622A380,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250620113409B31B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202505131129363827,COS20250618172234E3C1,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250620182717DDF7,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 4:00:05 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS20250610155622A380,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250620113409B31B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202505131129363827,COS20250618172234E3C1,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250620182717DDF7,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 5:00:07 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS20250610155622A380,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250620113409B31B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202505131129363827,COS20250618172234E3C1,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250620182717DDF7,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 6:00:08 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS20250610155622A380,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250620113409B31B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202505131129363827,COS20250618172234E3C1,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250620182717DDF7,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 7:00:06 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS20250610155622A380,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250620113409B31B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202505131129363827,COS20250618172234E3C1,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250620182717DDF7,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 8:00:01 UpdateHandlingPrescription结果：异常：System.Exception: 
SELECT 
DISTINCT t.Id
FROM SinadealTradeDB.dbo.WorkOrder t
CROSS APPLY SinadealTradeDB.dbo.dnt_split(t.ToDepartmentId, ',') s
WHERE 
t.Status in(0,5)
AND EXISTS (
    SELECT 1
    FROM SinadealTradeDB.dbo.dnt_split('31771058,593417534', ',') d
    WHERE s.item = d.item
);在从服务器接收结果时发生传输级错误。 (provider: TCP Provider, error: 0 - 远程主机强迫关闭了一个现有的连接。)
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 434
   在 PDSys.Domain.Services.WorkOrderRepository.UpdateHandlingPrescription() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\WorkOrderRepository.cs:行号 155
2025/6/21 9:00:10 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS20250610155622A380,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250620113409B31B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202505131129363827,COS20250618172234E3C1,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250620182717DDF7,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 10:00:07 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 10:08:04 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@CommitTime","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 10:38:13 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@CommitTime","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 11:00:06 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS2025061810275213D0,COS202505291503151256,COS202503041559104E30,COS202506161506039293,COS20250613093414DED0,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506101755198396,COS202506181753526EF2,COS20250621103813D2E4,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 11:59:55 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@CommitTime","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 12:00:11 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS2025061810275213D0,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202506161506039293,COS20250613093414DED0,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202504241058233757,COS202506101755198396,COS202506181753526EF2,COS20250621103813D2E4,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250621115955D51C,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 13:00:07 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS2025061810275213D0,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202506161506039293,COS20250613093414DED0,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202504241058233757,COS202506101755198396,COS202506181753526EF2,COS20250621103813D2E4,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS20250621115955D51C,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 13:59:12 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@CommitTime","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 14:00:09 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS2025061810275213D0,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202506161506039293,COS20250613093414DED0,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS20250620191711AD65,COS20250620113447606A,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202504241058233757,COS202506101755198396,COS202506181753526EF2,COS20250621103813D2E4,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS202506211359120796,COS20250621115955D51C,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 15:00:05 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS2025061810275213D0,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202506161506039293,COS20250613093414DED0,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202505261356164952,COS202504092306533063,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS2025051511234002D6,COS20250620191711AD65,COS20250620113447606A,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202504241058233757,COS202506101755198396,COS202506181753526EF2,COS20250621103813D2E4,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS202506211359120796,COS20250621115955D51C,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 15:28:14 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@CommitTime","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 15:29:32 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@CommitTime","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 16:00:11 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS2025061810275213D0,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202506161506039293,COS20250613093414DED0,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS2025062115281473E2,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS2025051511234002D6,COS20250620191711AD65,COS20250620113447606A,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202504241058233757,COS202506101755198396,COS202506181753526EF2,COS20250621103813D2E4,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS202506211359120796,COS20250621115955D51C,COS20250617181430515F,COS202505201732079476,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 16:29:07 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@CommitTime","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 17:00:00 UpdateHandlingPrescription结果：异常：System.Exception: 
SELECT 
DISTINCT t.Id
FROM SinadealTradeDB.dbo.WorkOrder t
CROSS APPLY SinadealTradeDB.dbo.dnt_split(t.ToDepartmentId, ',') s
WHERE 
t.Status in(0,5)
AND EXISTS (
    SELECT 1
    FROM SinadealTradeDB.dbo.dnt_split('31771058,593417534', ',') d
    WHERE s.item = d.item
);无法继续执行，因为会话处于终止状态。
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 434
   在 PDSys.Domain.Services.WorkOrderRepository.UpdateHandlingPrescription() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\PDSys.Domain\Services\WorkOrderRepository.cs:行号 155
2025/6/21 17:12:48 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@CommitTime","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 18:00:06 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS202505161110438BFC,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS2025061810275213D0,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202506161506039293,COS20250613093414DED0,COS2025050817110851BC,COS20250603142818330D,COS20250620190044D21E,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS2025062115281473E2,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS2025051511234002D6,COS20250620191711AD65,COS20250620113447606A,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506211712488C27,COS202504241058233757,COS202506101755198396,COS20250621162907A933,COS202506181753526EF2,COS20250621103813D2E4,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS202506211359120796,COS20250621115955D51C,COS20250617181430515F,COS202505201732079476,COS20250611093545AB8A,COS202505241704487EAB,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 18:16:49 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@CommitTime","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 18:41:02 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@CommitTime","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 18:50:12 sql:
IF EXISTS(SELECT [Id] FROM SinadealTradeDB.dbo.WorkOrder WHERE Id=@Id)
BEGIN
    Update SinadealTradeDB.dbo.WorkOrder 
    Set RelationId=@RelationId,PlatformId=@PlatformId,AccountId=@AccountId,Title=@Title,Content=@Content,OrderId=@OrderId, SKUInfoJson=@SKUInfoJson, PaymentTime=@PaymentTime, SigningTime=@SigningTime, FeedbackTime=@FeedbackTime,Feedback=@Feedback,CustomerRemark=@CustomerRemark, Priority=@Priority, Status=@Status, AssignUserIds=@AssignUserIds,AssignTime=@AssignTime,
ToDepartmentId=@ToDepartmentId,ToId=@ToId,FromDepartmentId=@FromDepartmentId,FromId=@FromId,UpdatedUserId=@UpdatedUserId, UpdatedTime=@UpdatedTime,FileType=@FileType
    Where Id = @Id;
END
ELSE BEGIN
    INSERT INTO SinadealTradeDB.dbo.WorkOrder
    (Id, RelationId, PlatformId,AccountId, Title, Content, OrderId, SKUInfoJson, PaymentTime, SigningTime, FeedbackTime,Feedback,CustomerRemark, Priority, Status, AssignUserIds,AssignTime,FromId,FromDepartmentId,ToId,ToDepartmentId, CreatedUserId, CreatedTime,FileType,CommitTime,TicketUrl)
    VALUES(@Id, @RelationId, @PlatformId, @AccountId, @Title, @Content, @OrderId, @SKUInfoJson, @PaymentTime, @SigningTime, @FeedbackTime,@Feedback,@CustomerRemark, @Priority, @Status, @AssignUserIds,@AssignTime,@FromId,@FromDepartmentId,@ToId,@ToDepartmentId, @CreatedUserId, @CreatedTime,@FileType,@CommitTime,@TicketUrl);
END,pars:["@Status","@CommitTime","@ToId","@ToDepartmentId","@FromId","@FromDepartmentId","@TicketUrl","@Id","@RelationId","@PlatformId","@AccountId","@Title","@Content","@OrderId","@SKUInfoJson","@PaymentTime","@SigningTime","@FeedbackTime","@Feedback","@CustomerRemark","@Priority","@AssignUserIds","@AssignTime","@FileType","@CreatedUserId","@CreatedTime","@UpdatedUserId","@UpdatedTime"]
2025/6/21 19:00:01 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS202505161110438BFC,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS2025061810275213D0,COS202505281348230492,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202506161506039293,COS20250613093414DED0,COS2025050817110851BC,COS20250603142818330D,COS20250620190044D21E,COS20250621181649D3D7,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS2025062115281473E2,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS20250525164219CEBF,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS2025051511234002D6,COS20250620191711AD65,COS20250620113447606A,COS20250603093309C1EC,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506211712488C27,COS202504241058233757,COS202506101755198396,COS20250621162907A933,COS202506181753526EF2,COS20250621103813D2E4,COS20250621184102232E,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS202506211359120796,COS20250621115955D51C,COS20250617181430515F,COS202505201732079476,COS20250611093545AB8A,COS20250621185012AD6D,COS202505241704487EAB,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 20:00:09 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS202505161110438BFC,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS2025061810275213D0,COS202505281348230492,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202506161506039293,COS20250613093414DED0,COS2025050817110851BC,COS20250603142818330D,COS20250620190044D21E,COS20250621181649D3D7,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS2025062115281473E2,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS20250525164219CEBF,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS2025051511234002D6,COS20250620191711AD65,COS20250620113447606A,COS20250603093309C1EC,COS20250611110744F46B,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506211712488C27,COS202504241058233757,COS202506101755198396,COS20250621162907A933,COS202506181753526EF2,COS20250621103813D2E4,COS20250621184102232E,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS202506211359120796,COS20250621115955D51C,COS20250617181430515F,COS202505201732079476,COS20250611093545AB8A,COS20250621185012AD6D,COS202505241704487EAB,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 21:00:05 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS202505161110438BFC,COS20250526111945246F,COS20250507170034CF5B,COS202501031705045C17,COS2025061810275213D0,COS202505281348230492,COS202506201610379E26,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202505171849233FD0,COS202506161506039293,COS20250613093414DED0,COS2025050817110851BC,COS20250603142818330D,COS20250620190044D21E,COS20250621181649D3D7,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS2025062115281473E2,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS20250525164219CEBF,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS2025051511234002D6,COS2025061911024213A4,COS20250620191711AD65,COS20250620113447606A,COS20250603093309C1EC,COS20250531224815FA41,COS20250611110744F46B,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506211712488C27,COS202504241058233757,COS202506101755198396,COS20250621162907A933,COS202506181753526EF2,COS20250621103813D2E4,COS20250621184102232E,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS202506211359120796,COS20250621115955D51C,COS20250617181430515F,COS202505201732079476,COS20250611093545AB8A,COS20250621185012AD6D,COS202505241704487EAB,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 22:00:07 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS202505161110438BFC,COS20250526111945246F,COS20250507170034CF5B,COS202505312123489A33,COS202501031705045C17,COS2025032613441648B7,COS2025061810275213D0,COS202505281348230492,COS202506201610379E26,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202505171849233FD0,COS202506161506039293,COS20250613093414DED0,COS2025050817110851BC,COS20250603142818330D,COS20250620190044D21E,COS20250621181649D3D7,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS20250620103436E74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS2025062115281473E2,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS20250525164219CEBF,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS2025051511234002D6,COS2025061911024213A4,COS20250620191711AD65,COS20250620113447606A,COS20250603093309C1EC,COS20250531224815FA41,COS20250611110744F46B,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506211712488C27,COS202504241058233757,COS202506101755198396,COS20250621162907A933,COS202506181753526EF2,COS20250621103813D2E4,COS20250621184102232E,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS202506211359120796,COS20250621115955D51C,COS2025050913215292A9,COS20250617181430515F,COS202505201732079476,COS20250611093545AB8A,COS20250621185012AD6D,COS202505241704487EAB,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：
2025/6/21 23:00:00 UpdateHandlingPrescription结果：成功：COS202504022102449A8D,COS20250605100711AED6,COS202506211008045546,COS202505161110438BFC,COS20250526111945246F,COS20250507170034CF5B,COS202505312123489A33,COS202501031705045C17,COS2025032613441648B7,COS2025061810275213D0,COS202505281348230492,COS202506201610379E26,COS202505291503151256,COS202503041559104E30,COS202506201411121A7E,COS20250602112137ACFA,COS202505171849233FD0,COS202506161506039293,COS20250613093414DED0,COS2025050817110851BC,COS20250603142818330D,COS20250620190044D21E,COS20250621181649D3D7,COS2025062019442161FE,COS202505212340277055,COS20250617172522A74E,COS20250620103436E74E,COS202505291039073B14,COS202504301410263176,COS202504092306533063,COS2025062115281473E2,COS20250603180856D30E,COS20250620184327B9E4,COS2025062018570405CB,COS20250525164219CEBF,COS2025062020153954CD,COS2025040215300986A8,COS202506031222041DEB,COS202506121028128430,COS20241108142112541C,COS20250620110835D06B,COS20250619142659B6B2,COS2025051511234002D6,COS2025061911024213A4,COS20250620191711AD65,COS20250620113447606A,COS20250603093309C1EC,COS20250531224815FA41,COS20250611110744F46B,COS202506161145472BEE,COS20250620155609A752,COS202506171705120755,COS202506211712488C27,COS202504241058233757,COS202506101755198396,COS20250621162907A933,COS202506181753526EF2,COS20250621103813D2E4,COS20250621184102232E,COS20250620192348E9D3,COS202504060244089336,COS202506080958057FC3,COS20250506180238FF22,COS20250619163932983A,COS20250620112500BFD3,COS202506211359120796,COS20250621115955D51C,COS2025050913215292A9,COS20250617181430515F,COS202505201732079476,COS20250611093545AB8A,COS20250621185012AD6D,COS202505241704487EAB,COS20250620163319F4C8,COS202506091714129AC0,COS20250520102340A3A8,COS2025050717355487F8，失败：