0054BC77   E8C461F9FF             call    004E1E40
0054BC7C   8B10                   mov     edx, [eax]
0054BC7E   FF5244                 call    dword ptr [edx+$44]
0054BC81   8B45FC                 mov     eax, [ebp-$04]
0054BC84   8B80A8030000           mov     eax, [eax+$03A8]
0054BC8A   8B8018020000           mov     eax, [eax+$0218]
0054BC90   83E801                 sub     eax, +$01
0054BC93   720B                   jb      0054BCA0
0054BC95   0F846C010000           jz      0054BE07
0054BC9B   E9E2020000             jmp     0054BF82* Possible String Reference to: ' SELECT wp_kapian.wp_id as 护品编号
|                                , wp_dict.WP_NAME AS 名称,wp_dict.d
|                                w as 单位, wp_kapian.xh_name AS 型?
|                                ?COUNT(wp_kapian.wp_id) AS 人数, a
|                                vg(wp_dict.dj) as 单价,  sum(int(('
|
0054BCA0   68B4EE5400             push    $0054EEB4
0054BCA5   8D9558FFFFFF           lea     edx, [ebp+$FFFFFF58]
0054BCAB   8B45D4                 mov     eax, [ebp-$2C]* Reference to: SysUtils.IntToStr(Integer):AnsiString;overload;
|
0054BCAE   E889D4EBFF             call    0040913C
0054BCB3   FFB558FFFFFF           push    dword ptr [ebp+$FFFFFF58]* Possible String Reference to: 'sum(int((-(wp_kapian.lastyear*12+wp_kapian.l
|                                astmnth))/wp_kapian.mnth)'
|
0054BCB9   686CEF5400             push    $0054EF6C* Possible String Reference to: 'sum(int((-(wp_kapian.lastyear*12+wp_kapian.l
|                                astmnth))/wp_kapian.mnth)*wp_kapian.sl) as  预测应发数量,'
|
0054BCBE   68B4EF5400             push    $0054EFB4* Possible String Reference to: ' sum((int(('
|
0054BCC3   68E0EF5400             push    $0054EFE0
0054BCC8   8D9554FFFFFF           lea     edx, [ebp+$FFFFFF54]
0054BCCE   8B45D4                 mov     eax, [ebp-$2C]* Reference to: SysUtils.IntToStr(Integer):AnsiString;overload;
|
0054BCD1   E866D4EBFF             call    0040913C
0054BCD6   FFB554FFFFFF           push    dword ptr [ebp+$FFFFFF54]* Possible String Reference to: '-(wp_kapian.lastyear*12+wp_kapian.l
|                                astmnth))'
|
0054BCDC   68F4EF5400             push    $0054EFF4* Possible String Reference to: '/wp_kapian.mnth)*wp_kapian.sl)*wp_d
|                                ict.dj) as  合计金额, wp_dict.wzbm '
|
0054BCE1   682CF05400             push    $0054F02C* Possible String Reference to: ' from (wp_kapian INNER JOIN wp_dict
|                                 ON wp_kapian.wp_id = wp_dict.WP_ID
|                                ) '
|
0054BCE6   687CF05400             push    $0054F07C* Possible String Reference to: ' INNER JOIN cl_body ON wp_kapian.ID
|                                 = cl_body.id '
|
0054BCEB   68D0F05400             push    $0054F0D0* Possible String Reference to: ' where wp_kapian.stopflag<>'停用' a
|                                nd wp_kapian.mnth>'
|
0054BCF0   680CF15400             push    $0054F10C
0054BCF5   FF75F0                 push    dword ptr [ebp-$10]* Possible String Reference to: ' and nextyear*12+nextmnth<='
|
0054BCF8   684CF15400             push    $0054F14C
0054BCFD   8D9550FFFFFF           lea     edx, [ebp+$FFFFFF50]
0054BD03   8B45D4                 mov     eax, [ebp-$2C]* Reference to: SysUtils.IntToStr(Integer):AnsiString;overload;
|
0054BD06   E831D4EBFF             call    0040913C
0054BD0B   FFB550FFFFFF           push    dword ptr [ebp+$FFFFFF50]
0054BD11   8D45F4                 lea     eax, [ebp-$0C]
0054BD14   BA0E000000             mov     edx, $0000000E* Reference to: System.@LStrCatN;
|
0054BD19   E8FA89EBFF             call    00404718
0054BD1E   833D40D6580000         cmp     dword ptr [$0058D640], +$00
0054BD25   7442                   jz      0054BD69
0054BD27   FF75F4                 push    dword ptr [ebp-$0C]* Possible String Reference to: ' and wp_kapian.wp_id like '
|
0054BD2A   6870F15400             push    $0054F170
0054BD2F   8D8548FFFFFF           lea     eax, [ebp+$FFFFFF48]
0054BD35   B994F15400             mov     ecx, $0054F194
0054BD3A   8B1540D65800           mov     edx, [$0058D640]* Reference to: System.@LStrCat3;
|
0054BD40   E85F89EBFF             call    004046A4
0054BD45   8B8548FFFFFF           mov     eax, [ebp+$FFFFFF48]
0054BD4B   8D954CFFFFFF           lea     edx, [ebp+$FFFFFF4C]* Reference to: SysUtils.QuotedStr(AnsiString):AnsiString;
|
0054BD51   E86ED0EBFF             call    00408DC4
0054BD56   FFB54CFFFFFF           push    dword ptr [ebp+$FFFFFF4C]
0054BD5C   8D45F4                 lea     eax, [ebp-$0C]
0054BD5F   BA03000000             mov     edx, $00000003* Reference to: System.@LStrCatN;
|
0054BD64   E8AF89EBFF             call    00404718
0054BD69   833D38D6580000         cmp     dword ptr [$0058D638], +$00
0054BD70   7442                   jz      0054BDB4
0054BD72   FF75F4                 push    dword ptr [ebp-$0C]* Possible String Reference to: ' and cl_body.depart_id like '
|
0054BD75   68A0F15400             push    $0054F1A0
0054BD7A   8D8540FFFFFF           lea     eax, [ebp+$FFFFFF40]
0054BD80   B994F15400             mov     ecx, $0054F194
0054BD85   8B1538D65800           mov     edx, [$0058D638]* Reference to: System.@LStrCat3;
|
0054BD8B   E81489EBFF             call    004046A4
0054BD90   8B8540FFFFFF           mov     eax, [ebp+$FFFFFF40]
0054BD96   8D9544FFFFFF           lea     edx, [ebp+$FFFFFF44]* Reference to: SysUtils.QuotedStr(AnsiString):AnsiString;
|
0054BD9C   E823D0EBFF             call    00408DC4
0054BDA1   FFB544FFFFFF           push    dword ptr [ebp+$FFFFFF44]
0054BDA7   8D45F4                 lea     eax, [ebp-$0C]
0054BDAA   BA03000000             mov     edx, $00000003* Reference to: System.@LStrCatN;
|
0054BDAF   E86489EBFF             call    00404718
0054BDB4   833D48D6580000         cmp     dword ptr [$0058D648], +$00
0054BDBB   742B                   jz      0054BDE8
0054BDBD   FF75F4                 push    dword ptr [ebp-$0C]* Possible String Reference to: ' and cl_body.gz_id='
|
0054BDC0   68C8F15400             push    $0054F1C8
0054BDC5   8D953CFFFFFF           lea     edx, [ebp+$FFFFFF3C]
0054BDCB   A148D65800             mov     eax, dword ptr [$0058D648]* Reference to: SysUtils.QuotedStr(AnsiString):AnsiString;
|
0054BDD0   E8EFCFEBFF             call    00408DC4
0054BDD5   FFB53CFFFFFF           push    dword ptr [ebp+$FFFFFF3C]
0054BDDB   8D45F4                 lea     eax, [ebp-$0C]
0054BDDE   BA03000000             mov     edx, $00000003* Reference to: System.@LStrCatN;
|
0054BDE3   E83089EBFF             call    00404718
0054BDE8   FF75F4                 push    dword ptr [ebp-$0C]* Possible String Reference to: ' GROUP BY wp_kapian.wp_id, wp_dict.
|                                WP_NAME,wp_kapian.xh_name,wp_dict.d
|                                w,wp_dict.wzbm '
|
0054BDEB   68E4F15400             push    $0054F1E4* Possible String Reference to: '  ORDER BY wp_kapian.wp_id, wp_dict
|                                .WP_NAME '
|
0054BDF0   6844F25400             push    $0054F244
0054BDF5   8D45F4                 lea     eax, [ebp-$0C]
0054BDF8   BA03000000             mov     edx, $00000003* Reference to: System.@LStrCatN;
|
0054BDFD   E81689EBFF             call    00404718
0054BE02   E97B010000             jmp     0054BF82sql语句的条件是什么值,

解决方案 »

  1.   

    主要是这句后面的值是什么结果或者说是从几个文本框来的? and nextyear*12+nextmnth<='
      

  2.   

    'sum(int((-(wp_kapian.lastyear*12+wp_kapian.l
    |                                astmnth))/wp_kapian.mnth)*wp_kapian.sl) as  预测应发数量,'
    里面的减号是干什么用的
      

  3.   

    跟踪SQL执行语句,如mssql的SQL Server profiler
      

  4.   

    谁有过解决win7UAC权限问题的经验。我的ActiveX在win7必须用管理员身份运行IE才行。各位大大有没有办法啊。