Home Explore Help
Register Sign In
dulip3ng
/
nebula
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 5e5771d935
Branches Tags
nebula
/
tests
/
page_test
/
test_data
/
data_generate_bill_page.py

data_generate_bill_page.py 15 KB
History Raw

123456789101112131415161718192021222324252627282930 
  1. 

  2. 

  3. class DataGenerateBillPage:
    4. 

  4.     # 创建采购申请单，测试合并下推
    5. 

  5.     CREATE_REQUESTION_TEST_DATA = """
    6. 

  6.             BEGIN
    7. 

  7.             DELETE FROM T_PUR_Requisition WHERE (FID IN (2757747));
    8. 

  8.             INSERT INTO T_PUR_Requisition (FID, FDOCUMENTSTATUS, FBILLNO, FBILLTYPEID, FAPPLICATIONORGID, FAPPLICANTID, FAPPLICATIONDATE, FCURRENCYID, FEXCHANGETYPEID, FAPPLICATIONDEPTID, FTOTALAMOUNT, FCREATORID, FCREATEDATE, FAPPROVERID, FAPPROVEDATE, FMODIFIERID, FMODIFYDATE, FCLOSERID, FCLOSEDATE, FCLOSESTATUS, FCANCELLERID, FCANCELDATE, FCANCELSTATUS, FNOTE, FREQUESTTYPE, FISCONVERT, FOBJECTTYPEID, FISMERGECANCEL, FSRCTYPE, FISBONDED_LT, FCUSID_LT, FPURCONTRACTDATE_LT, FLFSALEORDERNO_LT, FLTINVOICENO_LT, FATTACHMENTCOUNTHEAD, FDEPT_LT, FPUBLISHSTATUS, FSALESMANID, FSALESGROUPID, FISPRICEEXCLUDETAX, FMANUALCLOSE, FACCTYPE, FCLOSEREASON) VALUES (2757747, 'C', N'CGSQ2501040001', '93591469feb54ca2b08eb635f8b79de3', 1, 9679702, TO_DATE('2025-01-04 08:40:03', 'YYYY-MM-DD HH24:MI:SS'), 1, 1, 100545, 0.00, 9930639, TO_DATE('2025-01-04 08:47:02', 'YYYY-MM-DD HH24:MI:SS'), 9930639, TO_DATE('2025-01-04 08:47:14', 'YYYY-MM-DD HH24:MI:SS'), 9930639, TO_DATE('2025-01-04 08:47:03', 'YYYY-MM-DD HH24:MI:SS'), 0, NULL, 'A', 0, NULL, 'A', N' ', 'Material', '0', 'PUR_Requisition', '0', ' ', '9e0f496814614151af232644a3a29538', 0, NULL, ' ', ' ', 0, 100545, ' ', 0, 0, '1', '0', N'Q', N' ');
    9. 

  9.             DELETE FROM T_PUR_ReqEntry WHERE (FID IN (2757747));
    10. 

  10.             INSERT INTO T_PUR_ReqEntry (FENTRYID, FID, FMATERIALID, FSEQ, FUNITID, FREQQTY, FAPPROVEQTY, FPRICEUNITID, FPRICEUNITQTY, FBASEUNITID, FBASEUNITQTY, FARRIVALDATE, FLEADTIME, FSUGGESTPURDATE, FSUGGESTSUPPLIERID, FREQTRACENO, FAUXPROPID, FBOMID, FMRPTERMINATESTATUS, FTERMINATERID, FTERMINATEDATE, FEVALUATEPRICE, FREQAMOUNT, FPURCHASEGROUPID, FENTRYSTATUS, FPLANCONFIRM, FMRPCLOSESTATUS, FENTRYNOTE, FBFLOWID, FISSPLITCANCEL, FMTONO, FBASEREQQTY, FRECEIVEDEPTID, FREQUIREDEPTID, FCHARGEPROJECTID, FSHIRTORDNO_LT, FCUSTSTYLENO_LT, FSELFSTYLENO_LT, FOUTSTOCKLMTH_LT, FOUTSTOCKLMTL_LT, FINITREQQTY_LT, FMATERIALSOURCE_LT, FDECLARELISTNO_LT, FDECLAREITEMNO_LT, FTRADEMODE_LT, FDECLARATIONDATE_LT, FDECLARATIONNO_LT, FDECLARATIONPORT_LT, FWEIGHT, FWEIGHTUNITID, FORIGINALCOUNTRY, FSTOCKERID_LT, FIDENTIFY_LT, FSTATUSCONVERTINFO_LT, FUSERDEFSTYLE_LT, FATTACHMENTCOUNTENTRY, FROWCANCELDATE, FROWCANCELERID, FROWCANCELSTATUS, FQUERYPRICEID, FHASPUBLISH, FCUTPLANDATE_LT, FFINSHTRACKNO_LT, FURGENT_LT, FURGENTREASON, FROWPUBLISHSTATUS, FNETWEIGHT, FSPECIALARTTYPE_TXT, FADDSUMQTY_LT, FADDSUMBASEQTY_LT, FINSPECTIONNO_LT, FTAXPRICE, FSALUNITID, FSALQTY, FSALBASEQTY, FREQSTOCKUNITID, FREQSTOCKQTY, FREQSTOCKBASEQTY, FPRICEBASEQTY, FPURBASENUM, FSTOCKBASEDEN, FSRCBIZUNITID, FTAXRATE, FAMOUNT, FPRICELISTENTRY, FSLY_LT, FGETARRIVESTATUS, FCALCULATEDATE, FCALCULATERID, FBOXNO_LT, FFABRICORDERNO_LT, FEVERPURCH, FSUPPLYLOT, FWORKSHOPID, FQDBILLNO, FQDDECLAREDATE, FBARCODE_LT, FCYLINDERNO_LT, FSUPMATID, FSUPMATNAME, FMATCHNO_LT, FFABRICSALLOGISTICNO_LT, FENCHASENUM_LT, FFABRICSOUCEFROM_LT) VALUES (11774827, 2757747, 42972531, 1, 10087, 100, 100, 10087, 100, 10087, 100, TO_DATE('2025-01-14 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 10, TO_DATE('2025-01-04 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 13389069, N' ', 0, 0, 'A', 0, NULL, 0.00, 0.00, 0, ' ', '1', 'A', N' ', ' ', '0', N'24123101', 100, 0, 0, 0, N' ', N' ', N' ', 0.00, 0.00, 0.00, 'bb87cf081a2848f695b50c7402ac313f', N' ', N' ', ' ', NULL, 0, ' ', 0.00, 10095, ' ', 0, N' ', N' ', N' ', 0, NULL, 0, 'A', 0.00, 'A', NULL, 0.00, 'B', ' ', '0', 0.00, N' ', 0.00, 0.00, N' ', 0.00, 0, 0.00, 0.00, 10087, 100, 100, 100, 0.00, 0.00, 0, 0.00, 0.00, 0, 0.00, 'A', NULL, 0, N' ', N' ', '1', N' ', 0, N' ', NULL, N' ', N' ', N' ', N' ', N' ', N' ', N' ', ' ');
    11. 

  11.             INSERT INTO T_PUR_ReqEntry (FENTRYID, FID, FMATERIALID, FSEQ, FUNITID, FREQQTY, FAPPROVEQTY, FPRICEUNITID, FPRICEUNITQTY, FBASEUNITID, FBASEUNITQTY, FARRIVALDATE, FLEADTIME, FSUGGESTPURDATE, FSUGGESTSUPPLIERID, FREQTRACENO, FAUXPROPID, FBOMID, FMRPTERMINATESTATUS, FTERMINATERID, FTERMINATEDATE, FEVALUATEPRICE, FREQAMOUNT, FPURCHASEGROUPID, FENTRYSTATUS, FPLANCONFIRM, FMRPCLOSESTATUS, FENTRYNOTE, FBFLOWID, FISSPLITCANCEL, FMTONO, FBASEREQQTY, FRECEIVEDEPTID, FREQUIREDEPTID, FCHARGEPROJECTID, FSHIRTORDNO_LT, FCUSTSTYLENO_LT, FSELFSTYLENO_LT, FOUTSTOCKLMTH_LT, FOUTSTOCKLMTL_LT, FINITREQQTY_LT, FMATERIALSOURCE_LT, FDECLARELISTNO_LT, FDECLAREITEMNO_LT, FTRADEMODE_LT, FDECLARATIONDATE_LT, FDECLARATIONNO_LT, FDECLARATIONPORT_LT, FWEIGHT, FWEIGHTUNITID, FORIGINALCOUNTRY, FSTOCKERID_LT, FIDENTIFY_LT, FSTATUSCONVERTINFO_LT, FUSERDEFSTYLE_LT, FATTACHMENTCOUNTENTRY, FROWCANCELDATE, FROWCANCELERID, FROWCANCELSTATUS, FQUERYPRICEID, FHASPUBLISH, FCUTPLANDATE_LT, FFINSHTRACKNO_LT, FURGENT_LT, FURGENTREASON, FROWPUBLISHSTATUS, FNETWEIGHT, FSPECIALARTTYPE_TXT, FADDSUMQTY_LT, FADDSUMBASEQTY_LT, FINSPECTIONNO_LT, FTAXPRICE, FSALUNITID, FSALQTY, FSALBASEQTY, FREQSTOCKUNITID, FREQSTOCKQTY, FREQSTOCKBASEQTY, FPRICEBASEQTY, FPURBASENUM, FSTOCKBASEDEN, FSRCBIZUNITID, FTAXRATE, FAMOUNT, FPRICELISTENTRY, FSLY_LT, FGETARRIVESTATUS, FCALCULATEDATE, FCALCULATERID, FBOXNO_LT, FFABRICORDERNO_LT, FEVERPURCH, FSUPPLYLOT, FWORKSHOPID, FQDBILLNO, FQDDECLAREDATE, FBARCODE_LT, FCYLINDERNO_LT, FSUPMATID, FSUPMATNAME, FMATCHNO_LT, FFABRICSALLOGISTICNO_LT, FENCHASENUM_LT, FFABRICSOUCEFROM_LT) VALUES (11774828, 2757747, 42972539, 2, 10087, 200, 200, 10087, 200, 10087, 200, TO_DATE('2025-01-14 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 10, TO_DATE('2025-01-04 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 13389069, N' ', 0, 0, 'A', 0, NULL, 0.00, 0.00, 0, ' ', '1', 'A', N' ', ' ', '0', N'24123101', 200, 0, 0, 0, N' ', N' ', N' ', 0.00, 0.00, 0.00, 'bb87cf081a2848f695b50c7402ac313f', N' ', N' ', ' ', NULL, 0, ' ', 0.00, 10095, ' ', 0, N' ', N' ', N' ', 0, NULL, 0, 'A', 0.00, 'A', NULL, 0.00, 'B', ' ', '0', 0.00, N' ', 0.00, 0.00, N' ', 0.00, 0, 0.00, 0.00, 10087, 200, 200, 200, 0.00, 0.00, 0, 0.00, 0.00, 0, 0.00, 'A', NULL, 0, N' ', N' ', '1', N' ', 0, N' ', NULL, N' ', N' ', N' ', N' ', N' ', N' ', N' ', ' ');
    12. 

  12.             INSERT INTO T_PUR_ReqEntry (FENTRYID, FID, FMATERIALID, FSEQ, FUNITID, FREQQTY, FAPPROVEQTY, FPRICEUNITID, FPRICEUNITQTY, FBASEUNITID, FBASEUNITQTY, FARRIVALDATE, FLEADTIME, FSUGGESTPURDATE, FSUGGESTSUPPLIERID, FREQTRACENO, FAUXPROPID, FBOMID, FMRPTERMINATESTATUS, FTERMINATERID, FTERMINATEDATE, FEVALUATEPRICE, FREQAMOUNT, FPURCHASEGROUPID, FENTRYSTATUS, FPLANCONFIRM, FMRPCLOSESTATUS, FENTRYNOTE, FBFLOWID, FISSPLITCANCEL, FMTONO, FBASEREQQTY, FRECEIVEDEPTID, FREQUIREDEPTID, FCHARGEPROJECTID, FSHIRTORDNO_LT, FCUSTSTYLENO_LT, FSELFSTYLENO_LT, FOUTSTOCKLMTH_LT, FOUTSTOCKLMTL_LT, FINITREQQTY_LT, FMATERIALSOURCE_LT, FDECLARELISTNO_LT, FDECLAREITEMNO_LT, FTRADEMODE_LT, FDECLARATIONDATE_LT, FDECLARATIONNO_LT, FDECLARATIONPORT_LT, FWEIGHT, FWEIGHTUNITID, FORIGINALCOUNTRY, FSTOCKERID_LT, FIDENTIFY_LT, FSTATUSCONVERTINFO_LT, FUSERDEFSTYLE_LT, FATTACHMENTCOUNTENTRY, FROWCANCELDATE, FROWCANCELERID, FROWCANCELSTATUS, FQUERYPRICEID, FHASPUBLISH, FCUTPLANDATE_LT, FFINSHTRACKNO_LT, FURGENT_LT, FURGENTREASON, FROWPUBLISHSTATUS, FNETWEIGHT, FSPECIALARTTYPE_TXT, FADDSUMQTY_LT, FADDSUMBASEQTY_LT, FINSPECTIONNO_LT, FTAXPRICE, FSALUNITID, FSALQTY, FSALBASEQTY, FREQSTOCKUNITID, FREQSTOCKQTY, FREQSTOCKBASEQTY, FPRICEBASEQTY, FPURBASENUM, FSTOCKBASEDEN, FSRCBIZUNITID, FTAXRATE, FAMOUNT, FPRICELISTENTRY, FSLY_LT, FGETARRIVESTATUS, FCALCULATEDATE, FCALCULATERID, FBOXNO_LT, FFABRICORDERNO_LT, FEVERPURCH, FSUPPLYLOT, FWORKSHOPID, FQDBILLNO, FQDDECLAREDATE, FBARCODE_LT, FCYLINDERNO_LT, FSUPMATID, FSUPMATNAME, FMATCHNO_LT, FFABRICSALLOGISTICNO_LT, FENCHASENUM_LT, FFABRICSOUCEFROM_LT) VALUES (11774829, 2757747, 3494484, 3, 10101, 30, 30, 10101, 30, 10101, 30, TO_DATE('2025-01-14 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 10, TO_DATE('2025-01-04 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2579992, N' ', 102057, 0, 'A', 0, NULL, 0.00, 0.00, 0, ' ', '1', 'A', N' ', ' ', '0', N'24123101', 30, 100553, 0, 0, N' ', N' ', N' ', 0.00, 0.00, 0.00, 'bb87cf081a2848f695b50c7402ac313f', N' ', N' ', ' ', NULL, 0, ' ', 0.00, 10095, ' ', 7664280, N' ', N' ', N' ', 0, NULL, 0, 'A', 0.00, 'A', NULL, 0.00, 'B', ' ', '0', 0.00, N' ', 0.00, 0.00, N' ', 0.00, 0, 0.00, 0.00, 10101, 30, 30, 30, 0.00, 0.00, 0, 0.00, 0.00, 0, 0.00, 'A', NULL, 0, N' ', N' ', '1', N' ', 0, N' ', NULL, N' ', N' ', N' ', N' ', N' ', N' ', N' ', ' ');
    13. 

  13.             INSERT INTO T_PUR_ReqEntry (FENTRYID, FID, FMATERIALID, FSEQ, FUNITID, FREQQTY, FAPPROVEQTY, FPRICEUNITID, FPRICEUNITQTY, FBASEUNITID, FBASEUNITQTY, FARRIVALDATE, FLEADTIME, FSUGGESTPURDATE, FSUGGESTSUPPLIERID, FREQTRACENO, FAUXPROPID, FBOMID, FMRPTERMINATESTATUS, FTERMINATERID, FTERMINATEDATE, FEVALUATEPRICE, FREQAMOUNT, FPURCHASEGROUPID, FENTRYSTATUS, FPLANCONFIRM, FMRPCLOSESTATUS, FENTRYNOTE, FBFLOWID, FISSPLITCANCEL, FMTONO, FBASEREQQTY, FRECEIVEDEPTID, FREQUIREDEPTID, FCHARGEPROJECTID, FSHIRTORDNO_LT, FCUSTSTYLENO_LT, FSELFSTYLENO_LT, FOUTSTOCKLMTH_LT, FOUTSTOCKLMTL_LT, FINITREQQTY_LT, FMATERIALSOURCE_LT, FDECLARELISTNO_LT, FDECLAREITEMNO_LT, FTRADEMODE_LT, FDECLARATIONDATE_LT, FDECLARATIONNO_LT, FDECLARATIONPORT_LT, FWEIGHT, FWEIGHTUNITID, FORIGINALCOUNTRY, FSTOCKERID_LT, FIDENTIFY_LT, FSTATUSCONVERTINFO_LT, FUSERDEFSTYLE_LT, FATTACHMENTCOUNTENTRY, FROWCANCELDATE, FROWCANCELERID, FROWCANCELSTATUS, FQUERYPRICEID, FHASPUBLISH, FCUTPLANDATE_LT, FFINSHTRACKNO_LT, FURGENT_LT, FURGENTREASON, FROWPUBLISHSTATUS, FNETWEIGHT, FSPECIALARTTYPE_TXT, FADDSUMQTY_LT, FADDSUMBASEQTY_LT, FINSPECTIONNO_LT, FTAXPRICE, FSALUNITID, FSALQTY, FSALBASEQTY, FREQSTOCKUNITID, FREQSTOCKQTY, FREQSTOCKBASEQTY, FPRICEBASEQTY, FPURBASENUM, FSTOCKBASEDEN, FSRCBIZUNITID, FTAXRATE, FAMOUNT, FPRICELISTENTRY, FSLY_LT, FGETARRIVESTATUS, FCALCULATEDATE, FCALCULATERID, FBOXNO_LT, FFABRICORDERNO_LT, FEVERPURCH, FSUPPLYLOT, FWORKSHOPID, FQDBILLNO, FQDDECLAREDATE, FBARCODE_LT, FCYLINDERNO_LT, FSUPMATID, FSUPMATNAME, FMATCHNO_LT, FFABRICSALLOGISTICNO_LT, FENCHASENUM_LT, FFABRICSOUCEFROM_LT) VALUES (11774830, 2757747, 3494484, 4, 10101, 40, 40, 10101, 40, 10101, 40, TO_DATE('2025-01-14 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 10, TO_DATE('2025-01-04 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2579992, N' ', 103006, 0, 'A', 0, NULL, 0.00, 0.00, 0, ' ', '1', 'A', N' ', ' ', '0', N'24123101', 40, 100553, 0, 0, N' ', N' ', N' ', 0.00, 0.00, 0.00, 'bb87cf081a2848f695b50c7402ac313f', N' ', N' ', ' ', NULL, 0, ' ', 0.00, 10095, ' ', 7664280, N' ', N' ', N' ', 0, NULL, 0, 'A', 0.00, 'A', NULL, 0.00, 'B', ' ', '0', 0.00, N' ', 0.00, 0.00, N' ', 0.00, 0, 0.00, 0.00, 10101, 40, 40, 40, 0.00, 0.00, 0, 0.00, 0.00, 0, 0.00, 'A', NULL, 0, N' ', N' ', '1', N' ', 0, N' ', NULL, N' ', N' ', N' ', N' ', N' ', N' ', N' ', ' ');
    14. 

  14.             INSERT INTO T_PUR_ReqEntry (FENTRYID, FID, FMATERIALID, FSEQ, FUNITID, FREQQTY, FAPPROVEQTY, FPRICEUNITID, FPRICEUNITQTY, FBASEUNITID, FBASEUNITQTY, FARRIVALDATE, FLEADTIME, FSUGGESTPURDATE, FSUGGESTSUPPLIERID, FREQTRACENO, FAUXPROPID, FBOMID, FMRPTERMINATESTATUS, FTERMINATERID, FTERMINATEDATE, FEVALUATEPRICE, FREQAMOUNT, FPURCHASEGROUPID, FENTRYSTATUS, FPLANCONFIRM, FMRPCLOSESTATUS, FENTRYNOTE, FBFLOWID, FISSPLITCANCEL, FMTONO, FBASEREQQTY, FRECEIVEDEPTID, FREQUIREDEPTID, FCHARGEPROJECTID, FSHIRTORDNO_LT, FCUSTSTYLENO_LT, FSELFSTYLENO_LT, FOUTSTOCKLMTH_LT, FOUTSTOCKLMTL_LT, FINITREQQTY_LT, FMATERIALSOURCE_LT, FDECLARELISTNO_LT, FDECLAREITEMNO_LT, FTRADEMODE_LT, FDECLARATIONDATE_LT, FDECLARATIONNO_LT, FDECLARATIONPORT_LT, FWEIGHT, FWEIGHTUNITID, FORIGINALCOUNTRY, FSTOCKERID_LT, FIDENTIFY_LT, FSTATUSCONVERTINFO_LT, FUSERDEFSTYLE_LT, FATTACHMENTCOUNTENTRY, FROWCANCELDATE, FROWCANCELERID, FROWCANCELSTATUS, FQUERYPRICEID, FHASPUBLISH, FCUTPLANDATE_LT, FFINSHTRACKNO_LT, FURGENT_LT, FURGENTREASON, FROWPUBLISHSTATUS, FNETWEIGHT, FSPECIALARTTYPE_TXT, FADDSUMQTY_LT, FADDSUMBASEQTY_LT, FINSPECTIONNO_LT, FTAXPRICE, FSALUNITID, FSALQTY, FSALBASEQTY, FREQSTOCKUNITID, FREQSTOCKQTY, FREQSTOCKBASEQTY, FPRICEBASEQTY, FPURBASENUM, FSTOCKBASEDEN, FSRCBIZUNITID, FTAXRATE, FAMOUNT, FPRICELISTENTRY, FSLY_LT, FGETARRIVESTATUS, FCALCULATEDATE, FCALCULATERID, FBOXNO_LT, FFABRICORDERNO_LT, FEVERPURCH, FSUPPLYLOT, FWORKSHOPID, FQDBILLNO, FQDDECLAREDATE, FBARCODE_LT, FCYLINDERNO_LT, FSUPMATID, FSUPMATNAME, FMATCHNO_LT, FFABRICSALLOGISTICNO_LT, FENCHASENUM_LT, FFABRICSOUCEFROM_LT) VALUES (11774831, 2757747, 3494484, 5, 10101, 50, 50, 10101, 50, 10101, 50, TO_DATE('2025-01-14 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 10, TO_DATE('2025-01-04 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), 2579992, N' ', 103006, 0, 'A', 0, NULL, 0.00, 0.00, 0, ' ', '1', 'A', N' ', ' ', '0', N'24123101', 50, 100553, 0, 0, N' ', N' ', N' ', 0.00, 0.00, 0.00, 'bb87cf081a2848f695b50c7402ac313f', N' ', N' ', ' ', NULL, 0, ' ', 0.00, 10095, ' ', 7664280, N' ', N' ', N' ', 0, NULL, 0, 'A', 0.00, 'A', NULL, 0.00, 'B', ' ', '0', 0.00, N' ', 0.00, 0.00, N' ', 0.00, 0, 0.00, 0.00, 10101, 50, 50, 50, 0.00, 0.00, 0, 0.00, 0.00, 0, 0.00, 'A', NULL, 0, N' ', N' ', '1', N' ', 0, N' ', NULL, N' ', N' ', N' ', N' ', N' ', N' ', N' ', ' ');
    15. 

  15.             DELETE FROM T_PUR_ReqEntry_L WHERE FEntryID IN (SELECT FEntryID FROM T_PUR_ReqEntry WHERE (FID IN (2757747)));
    16. 

  16.             INSERT INTO T_PUR_ReqEntry_L (FPKID, FENTRYID, FLOCALEID, FMATERIALDESC) VALUES (13650874, 11774827, 2052, N'粘合衬/3040R/非中国棉/-1/160g/110cm/100%棉');
    17. 

  17.             INSERT INTO T_PUR_ReqEntry_L (FPKID, FENTRYID, FLOCALEID, FMATERIALDESC) VALUES (13650875, 11774828, 2052, N'粘合衬/7060/非中国棉/-1/210g/110cm/100%棉');
    18. 

  18.             INSERT INTO T_PUR_ReqEntry_L (FPKID, FENTRYID, FLOCALEID, FMATERIALDESC) VALUES (13650876, 11774829, 1033, N'尺唛/SEZ金/SLIM长袖');
    19. 

  19.             INSERT INTO T_PUR_ReqEntry_L (FPKID, FENTRYID, FLOCALEID, FMATERIALDESC) VALUES (13650877, 11774829, 2052, N'尺唛/SEZ金/SLIM长袖');
    20. 

  20.             INSERT INTO T_PUR_ReqEntry_L (FPKID, FENTRYID, FLOCALEID, FMATERIALDESC) VALUES (13650878, 11774830, 1033, N'尺唛/SEZ金/SLIM长袖');
    21. 

  21.             INSERT INTO T_PUR_ReqEntry_L (FPKID, FENTRYID, FLOCALEID, FMATERIALDESC) VALUES (13650879, 11774830, 2052, N'尺唛/SEZ金/SLIM长袖');
    22. 

  22.             INSERT INTO T_PUR_ReqEntry_L (FPKID, FENTRYID, FLOCALEID, FMATERIALDESC) VALUES (13650880, 11774831, 1033, N'尺唛/SEZ金/SLIM长袖');
    23. 

  23.             INSERT INTO T_PUR_ReqEntry_L (FPKID, FENTRYID, FLOCALEID, FMATERIALDESC) VALUES (13650881, 11774831, 2052, N'尺唛/SEZ金/SLIM长袖');
    24. 

  24.             DELETE FROM LT_T_SCM_SpecialArt WHERE FEntryID IN (SELECT FEntryID FROM T_PUR_ReqEntry WHERE (FID IN (2757747)));
    25. 

  25.             DELETE FROM T_PUR_RequisitionMob WHERE (FID IN (2757747));
    26. 

  26.             INSERT INTO T_PUR_RequisitionMob (FENTRYID, FID, FISMOBBILL, FMOBISPENDING, FEXTENDFIELD, FORDERNAME) VALUES (2480143, 2757747, '0', '0', N' ', N' ');
    27. 

  27.             DELETE FROM LT_T_PUR_ReqSumEntry WHERE (FID IN (2757747));
    28. 

  28.             DELETE FROM LT_T_PUR_ReqSumEntry_L WHERE FEntryID IN (SELECT FEntryID FROM LT_T_PUR_ReqSumEntry WHERE (FID IN (2757747)));
    29. 

  29.             END;
    30. 

  30.             """
    31.