You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

20 lines
2.6 KiB

4 days ago
  1. ��¼ʱ�䣺2024-10-28 10:42:37,242 �߳�ID:[10] ��־������INFO �ࣺNFine.Application.SRM.RFQManagerApp - ������׷���쳣select id from OA.dbo.org_member where code='admin'
  2. ��¼ʱ�䣺2024-10-28 10:42:37,397 �߳�ID:[10] ��־������INFO �ࣺNFine.Application.SRM.RFQManagerApp - ������0
  3. ��¼ʱ�䣺2024-10-28 10:48:27,425 �߳�ID:[10] ��־������INFO �ࣺNFine.Application.SRM.RFQManagerApp - �������޸�״̬sql:update a
  4. set a.QUOSTATUS='PricingApproveByOA'
  5. from icsSORQUODETAILNORMAL a
  6. left join icsSORQUOTATION b ON a.QUOTATIONCODE=b.QUOTATIONCODE AND a.WorkPoint=b.WorkPoint
  7. LEFT JOIN dbo.ICSVendor c ON b.VENDORCODE=c.VenCode AND b.WorkPoint=c.WorkPoint
  8. where b.RFQCODE='XJD20241021001' and ITEMCODE='F004' and c.VenName='����������ѡ�Ƽ����޹�˾' UPDATE icsSORRFQ SET STATUS='PricingApproveByOA' where RFQCODE='XJD20241021001' UPDATE icsSORRFQ2NORMALITEM SET Remark='111' where RFQCODE='XJD20241021001' and ITEMCODE='F004'update a
  9. set a.QUOSTATUS='PricingApproveByOA'
  10. from icsSORQUODETAILNORMAL a
  11. left join icsSORQUOTATION b ON a.QUOTATIONCODE=b.QUOTATIONCODE AND a.WorkPoint=b.WorkPoint
  12. LEFT JOIN dbo.ICSVendor c ON b.VENDORCODE=c.VenCode AND b.WorkPoint=c.WorkPoint
  13. where b.RFQCODE='XJD20241021001' and ITEMCODE='F004' and c.VenName='���������ֹ����Ƽ��ɷ����޹�˾' UPDATE icsSORRFQ SET STATUS='PricingApproveByOA' where RFQCODE='XJD20241021001' UPDATE icsSORRFQ2NORMALITEM SET Remark='111' where RFQCODE='XJD20241021001' and ITEMCODE='F004'update a
  14. set a.QUOSTATUS='PricingApproveByOA'
  15. from icsSORQUODETAILNORMAL a
  16. left join icsSORQUOTATION b ON a.QUOTATIONCODE=b.QUOTATIONCODE AND a.WorkPoint=b.WorkPoint
  17. LEFT JOIN dbo.ICSVendor c ON b.VENDORCODE=c.VenCode AND b.WorkPoint=c.WorkPoint
  18. where b.RFQCODE='XJD20241021001' and ITEMCODE='F005' and c.VenName='���������ֹ����Ƽ��ɷ����޹�˾' UPDATE icsSORRFQ SET STATUS='PricingApproveByOA' where RFQCODE='XJD20241021001' UPDATE icsSORRFQ2NORMALITEM SET Remark='' where RFQCODE='XJD20241021001' and ITEMCODE='F005'
  19. ��¼ʱ�䣺2024-10-28 10:48:29,003 �߳�ID:[10] ��־������INFO �ࣺNFine.Application.SRM.RFQManagerApp - ������׷���쳣select id from OA.dbo.org_member where code='admin'
  20. ��¼ʱ�䣺2024-10-28 10:48:30,660 �߳�ID:[10] ��־������INFO �ࣺNFine.Application.SRM.RFQManagerApp - ������0