[用友维护]补丁之后的问题

 起因问题描述:

系统出现如下问题1.两条完全一样的采购入库单记录,在采购模块的采购明细中只显示一条

2.总帐系统和应收应付对帐不平,出现几分钱差额,(估计是四舍五入的问题)

 

之前我已经打了 U8-V861-21-060510120000-U861SP1

出现上面问题后,实施支持说明要打U8-V861-0541-93093 补丁,(此补丁依赖

KB-U861-0323-060901-U861SP1PackB),加上采购问题一共需要再打三个补丁.

 

分别为:

KB-U861-0323-060901-U861SP1PackB

KB-U861-0541-061110-93093

KB-U861-0349-060907-90511

 

打完补丁之后发现,直运销售中 采购订单在直运业务下,无法拷贝销售订单(不加任何过滤条件).
同样的操作而其他没有打后面三个补丁的客户端,却可以过滤出来.

 

追踪查询操作,如下为关键查询语句:

 

declare @P1 int

set @P1=180150002

declare @P2 int

set @P2=8

declare @P3 int

set @P3=1

declare @P4 int

set @P4=1

exec sp_cursoropen @P1 output, N'SELECT '''' as selcol,(copysolist.id) as imainid@@,(copysolist.csocode) as csocode,(copysolist.ddate) as ddate,(copysolist.ccuscode) as ccuscode@@,(copysolist.ccusabbname) as ccusabbname@@,(copysolist.cdepcode) as cdepcode@@,(copysolist.cdepname) as cdepname@@,(copysolist.cpersoncode) as cpersoncode@@,(copysolist.cpersonname) as cpersonname@@,(copysolist.cexch_name) as cexch_name@@,(copysolist.iexchrate) as nflat@@,(copysolist.itaxrate) as itaxrate@@,(copysolist.cmemo) as cmemo@@,(copysolist.cpaycode) as cpaycode@@,(copysolist.cpayname) as cpayname@@,(copysolist.cstcode) as cstcode,(copysolist.cstname) as cstname,(copysolist.cbustype) as cbustype,(copysolist.cdefine1) as cdefine1@@,(copysolist.cdefine2) as cdefine2@@,(copysolist.cdefine3) as cdefine3@@,(copysolist.cdefine4) as cdefine4@@,(copysolist.cdefine5) as cdefine5@@,(copysolist.cdefine6) as cdefine6@@,(copysolist.cdefine7) as cdefine7@@,(copysolist.cdefine8) as cdefine8@@,(copysolist.cdefine9) as cdefine9@@,(copysolist.cdefine10) as cdefine10@@,(copysolist.cdefine11) as cdefine11@@,(copysolist.cdefine12) as cdefine12@@,(copysolist.cdefine13) as cdefine13@@,(copysolist.cdefine14) as cdefine14@@,(copysolist.cdefine15) as cdefine15@@,(copysolist.cdefine16) as cdefine16@@,(copysolist.isosid) as isosid,(copysolist.cinvcode) as cinvcode@@,(copysolist.cinvaddcode) as cinvaddcode@@,(copysolist.cinvname) as cinvname@@,(copysolist.cinvstd) as cinvstd@@,(copysolist.cinvm_unit) as cinvm_unit@@,(isnull(copysolist.iquantity,0)) as iquantity,(copysolist.iinvexchrate) as iinvexchrate@@,(copysolist.inum) as inum,(isnull(copysolist.fpurquan,0)) as fpurquan,(copysolist.itaxrate) as ipertaxrate@@,(copysolist.iGroupType) as igrouptype@@,(copysolist.bInvEntrust) as bInvEntrust,(copysolist.cunitid) as cunitid@@,(copysolist.cinva_unit) as cinva_unit@@,(copysolist.cfree1) as cfree1@@,(copysolist.cfree2) as cfree2@@,(copysolist.cfree3) as cfree3@@,(copysolist.cfree4) as cfree4@@,(copysolist.cfree5) as cfree5@@,(copysolist.cfree6) as cfree6@@,(copysolist.cfree7) as cfree7@@,(copysolist.cfree8) as cfree8@@,(copysolist.cfree9) as cfree9@@,(copysolist.cfree10) as cfree10@@,(copysolist.cdefine22) as cdefine22@@,(copysolist.cdefine23) as cdefine23@@,(copysolist.cdefine24) as cdefine24@@,(copysolist.cdefine25) as cdefine25@@,(copysolist.cdefine26) as cdefine26@@,(copysolist.cdefine27) as cdefine27@@,(copysolist.cdefine28) as cdefine28@@,(copysolist.cdefine29) as cdefine29@@,(copysolist.cdefine30) as cdefine30@@,(copysolist.cdefine31) as cdefine31@@,(copysolist.cdefine32) as cdefine32@@,(copysolist.cdefine33) as cdefine33@@,(copysolist.cdefine34) as cdefine34@@,(copysolist.cdefine35) as cdefine35@@,(copysolist.cdefine36) as cdefine36@@,(copysolist.cdefine37) as cdefine37@@,(copysolist.citemcode) as citemcode@@,(copysolist.citemname) as citemname@@,(copysolist.citem_class) as citem_class@@,(copysolist.citem_cname) as citem_name@@,(copysolist.irowno) as irowno,(copysolist.fkyquantity) as fkyquantity@@,(copysolist.cinvdefine1) as cinvdefine1@@,(copysolist.cinvdefine2) as cinvdefine2@@,(copysolist.cinvdefine3) as cinvdefine3@@,(copysolist.cinvdefine4) as cinvdefine4@@,(copysolist.cinvdefine5) as cinvdefine5@@,(copysolist.cinvdefine6) as cinvdefine6@@,(copysolist.cinvdefine7) as cinvdefine7@@,(copysolist.cinvdefine8) as cinvdefine8@@,(copysolist.cinvdefine9) as cinvdefine9@@,(copysolist.cinvdefine10) as cinvdefine10@@,(copysolist.cinvdefine11) as cinvdefine11@@,(copysolist.cinvdefine12) as cinvdefine12@@,(copysolist.cinvdefine13) as cinvdefine13@@,(copysolist.cinvdefine14) as cinvdefine14@@,(copysolist.cinvdefine15) as cinvdefine15@@,(copysolist.cinvdefine16) as cinvdefine16@@,(copysolist.ufts) as corufts@@ from copysolist where isnull(iquantity,0)>isnull(fpurquan,0) and (1>0) AND dDate >=''2006-11-27'' AND cCusCode =''01020001'' AND cDepCode like ''%001'' and cbustype=N''直运销售'' and isnull(fpurquan,0)=0 AND bService=0 AND bInvType=0 and 1=1 ', @P2 output, @P3 output, @P4 output

select @P1, @P2, @P3, @P4

 

 

而用没打过补丁的查询出现的是下面的查询

 

declare @P2 int

set @P2=8

declare @P3 int

set @P3=1

declare @P4 int

set @P4=1

exec sp_cursoropen @P1 output, N'SELECT '''' as selcol,(copysolist.id) as imainid@@,(copysolist.csocode) as csocode,(copysolist.ddate) as ddate,(copysolist.ccuscode) as ccuscode@@,(copysolist.ccusabbname) as ccusabbname@@,(copysolist.cdepcode) as cdepcode@@,(copysolist.cdepname) as cdepname@@,(copysolist.cpersoncode) as cpersoncode@@,(copysolist.cpersonname) as cpersonname@@,(copysolist.cexch_name) as cexch_name@@,(copysolist.iexchrate) as nflat@@,(copysolist.itaxrate) as itaxrate@@,(copysolist.cmemo) as cmemo@@,(copysolist.cpaycode) as cpaycode@@,(copysolist.cpayname) as cpayname@@,(copysolist.cstcode) as cstcode,(copysolist.cstname) as cstname,(copysolist.cbustype) as cbustype,(copysolist.cdefine1) as cdefine1@@,(copysolist.cdefine2) as cdefine2@@,(copysolist.cdefine3) as cdefine3@@,(copysolist.cdefine4) as cdefine4@@,(copysolist.cdefine5) as cdefine5@@,(copysolist.cdefine6) as cdefine6@@,(copysolist.cdefine7) as cdefine7@@,(copysolist.cdefine8) as cdefine8@@,(copysolist.cdefine9) as cdefine9@@,(copysolist.cdefine10) as cdefine10@@,(copysolist.cdefine11) as cdefine11@@,(copysolist.cdefine12) as cdefine12@@,(copysolist.cdefine13) as cdefine13@@,(copysolist.cdefine14) as cdefine14@@,(copysolist.cdefine15) as cdefine15@@,(copysolist.cdefine16) as cdefine16@@,(copysolist.isosid) as isosid,(copysolist.cinvcode) as cinvcode@@,(copysolist.cinvaddcode) as cinvaddcode@@,(copysolist.cinvname) as cinvname@@,(copysolist.cinvstd) as cinvstd@@,(copysolist.cinvm_unit) as cinvm_unit@@,(isnull(copysolist.iquantity,0)) as iquantity,(copysolist.iinvexchrate) as iinvexchrate@@,(copysolist.inum) as inum,(isnull(copysolist.fpurquan,0)) as fpurquan,(copysolist.itaxrate) as ipertaxrate@@,(copysolist.iGroupType) as igrouptype@@,(copysolist.bInvEntrust) as bInvEntrust,(copysolist.cunitid) as cunitid@@,(copysolist.cinva_unit) as cinva_unit@@,(copysolist.cfree1) as cfree1@@,(copysolist.cfree2) as cfree2@@,(copysolist.cfree3) as cfree3@@,(copysolist.cfree4) as cfree4@@,(copysolist.cfree5) as cfree5@@,(copysolist.cfree6) as cfree6@@,(copysolist.cfree7) as cfree7@@,(copysolist.cfree8) as cfree8@@,(copysolist.cfree9) as cfree9@@,(copysolist.cfree10) as cfree10@@,(copysolist.cdefine22) as cdefine22@@,(copysolist.cdefine23) as cdefine23@@,(copysolist.cdefine24) as cdefine24@@,(copysolist.cdefine25) as cdefine25@@,(copysolist.cdefine26) as cdefine26@@,(copysolist.cdefine27) as cdefine27@@,(copysolist.cdefine28) as cdefine28@@,(copysolist.cdefine29) as cdefine29@@,(copysolist.cdefine30) as cdefine30@@,(copysolist.cdefine31) as cdefine31@@,(copysolist.cdefine32) as cdefine32@@,(copysolist.cdefine33) as cdefine33@@,(copysolist.cdefine34) as cdefine34@@,(copysolist.cdefine35) as cdefine35@@,(copysolist.cdefine36) as cdefine36@@,(copysolist.cdefine37) as cdefine37@@,(copysolist.citemcode) as citemcode@@,(copysolist.citemname) as citemname@@,(copysolist.citem_class) as citem_class@@,(copysolist.citem_cname) as citem_name@@,(copysolist.irowno) as irowno,(copysolist.fkyquantity) as fkyquantity@@,(copysolist.cinvdefine1) as cinvdefine1@@,(copysolist.cinvdefine2) as cinvdefine2@@,(copysolist.cinvdefine3) as cinvdefine3@@,(copysolist.cinvdefine4) as cinvdefine4@@,(copysolist.cinvdefine5) as cinvdefine5@@,(copysolist.cinvdefine6) as cinvdefine6@@,(copysolist.cinvdefine7) as cinvdefine7@@,(copysolist.cinvdefine8) as cinvdefine8@@,(copysolist.cinvdefine9) as cinvdefine9@@,(copysolist.cinvdefine10) as cinvdefine10@@,(copysolist.cinvdefine11) as cinvdefine11@@,(copysolist.cinvdefine12) as cinvdefine12@@,(copysolist.cinvdefine13) as cinvdefine13@@,(copysolist.cinvdefine14) as cinvdefine14@@,(copysolist.cinvdefine15) as cinvdefine15@@,(copysolist.cinvdefine16) as cinvdefine16@@,(copysolist.ufts) as corufts@@ from copysolist where isnull(iquantity,0)>isnull(fpurquan,0) and (1>0) AND dDate>=''2006-11-27'' and cbustype=N''直运销售'' and isnull(fpurquan,0)=0 and 1=1 ', @P2 output, @P3 output, @P4 output

select @P1, @P2, @P3, @P4

 

查看了前后(补丁前,补丁后)两个试图完全一样. 都不存在 bService 和  bInvType 这个两个字段 .

 

 

我于是重建了试图

CREATE VIEW copysolist as 

        select 0 as bService, 0 as bInvType ,

convert(char,convert(money,ufts),2) as ufts,cbustype,so_somain.id,so_somain.cstcode, 

        so_somain.ddate,so_somain.csocode,so_somain.ccuscode,so_somain.cdepcode,so_somain.cpersoncode, 

        so_somain.csccode,so_somain.cpaycode,so_somain.cexch_name,so_somain.iexchrate,so_somain.cmemo, 

        so_somain.istatus,so_somain.cmaker, 

 so_somain.cdefine1,so_somain.cdefine2,so_somain.cdefine3,so_somain.cdefine4,so_somain.cdefine5, 

        so_somain.cdefine6,so_somain.cdefine7,so_somain.cdefine8,so_somain.cdefine9,so_somain.cdefine10, 

        so_somain.cdefine11,so_somain.cdefine12,so_somain.cdefine13,so_somain.cdefine14,so_somain.cdefine15, 

        so_somain.cdefine16,customer.ccusabbname,department.cdepname,person.cpersonname,shippingchoice.cscname, 

        paycondition.cpayname,saletype.cstname, 

 so_sodetails.isosid,so_sodetails.cinvcode,inventory.cinvaddcode,inventory.cinvname,inventory.cinvstd, 

        inventory.iid as cinvAuthid,so_sodetails.cunitid,unit1.ccomunitname as cinvm_unit,inventory.igrouptype, 

        inventory.bInvEntrust, 

        case when isnull(inventory.igrouptype,0)<>0 then unit2.ccomunitname else null end as cinva_unit, 

 inventory.cinvdefine1, inventory.cinvdefine2, inventory.cinvdefine3,inventory.cinvdefine4, 

        inventory.cinvdefine5,inventory.cinvdefine6,inventory.cinvdefine7,inventory.cinvdefine8, 

        inventory.cinvdefine9,inventory.cinvdefine10,inventory.cinvdefine11,inventory.cinvdefine12, 

        inventory.cinvdefine13,inventory.cinvdefine14,inventory.cinvdefine15,inventory.cinvdefine16, 

 so_sodetails.iquantity, so_sodetails.inum,so_sodetails.iunitprice,so_sodetails.imoney, so_sodetails.itax, 

        so_sodetails.isum, so_sodetails.inatunitprice, so_sodetails.inatmoney,so_sodetails.inattax,  

        so_sodetails.inatsum,so_sodetails.fpurquan, 

 so_sodetails.cfree1,so_sodetails.cfree2,so_sodetails.cfree3,so_sodetails.cfree4,so_sodetails.cfree5, 

        so_sodetails.cfree6,so_sodetails.cfree7,so_sodetails.cfree8,so_sodetails.cfree9,so_sodetails.cfree10, 

 so_sodetails.iinvexchrate,so_sodetails.itaxunitprice,so_sodetails.itaxrate, so_sodetails.citemcode,  

        so_sodetails.citem_class,so_sodetails.citemname,so_sodetails.citem_cname, 

 so_sodetails.cdefine22, so_sodetails.cdefine23,so_sodetails.cdefine24, so_sodetails.cdefine25,  

        so_sodetails.cdefine26, so_sodetails.cdefine27, so_sodetails.cdefine28,so_sodetails.cdefine29, 

        so_sodetails.cdefine30,so_sodetails.cdefine31, 

 so_sodetails.cdefine32,so_sodetails.cdefine33,so_sodetails.cdefine34,so_sodetails.cdefine35, 

        so_sodetails.cdefine36,so_sodetails.cdefine37,so_sodetails.irowno, 

        (iquantity-isnull(ifhquantity,0)) as fkyquantity 

        FROM SO_SOMain LEFT OUTER JOIN Customer ON SO_SOMain.cCusCode = Customer.cCusCode  

        LEFT OUTER JOIN Department ON SO_SOMain.cDepCode = Department.cDepCode  

        LEFT OUTER JOIN PayCondition ON SO_SOMain.cPayCode = PayCondition.cPayCode  

        LEFT OUTER JOIN Person ON SO_SOMain.cPersonCode = Person.cPersonCode  

        LEFT OUTER JOIN SaleType ON SO_SOMain.cSTCode = SaleType.cSTCode  

        LEFT OUTER JOIN ShippingChoice ON SO_SOMain.cSCCode = ShippingChoice.cSCCode 

        inner join SO_SODetails on SO_SOMain.id=SO_SODetails.id and isnull(so_sodetails.cSCloser,N'')=N'' 

 LEFT JOIN Inventory ON SO_SODetails.cInvCode = Inventory.cInvCode  

 LEFT join ComputationUnit as Unit1 on inventory.cComUnitCode=Unit1.cComUnitCode 

   LEFT join ComputationUnit as Unit2 on so_sodetails.cunitid=Unit2.cComUnitCode 

        where isnull(so_somain.cVerifier,N'')<>N'' and isnull(so_somain.cCloser,N'')=N''  

 AND inventory.bPurchase=1

 

 

 

添加了如上的两个字段 ,  重新过滤 , 直运销售的销售订单可以过滤出来了 , 但是怕这样操作对以后会有影响 .