打开材料出库单列表闪退。经查发现不是所有用户打开材料出库单列表都闪退，只是个别用户有这种现象。材料出库单列表个别栏目设置有问题，只要将栏目设置回复默认即可。所以对于能打开列表设置栏目的情况，可以进行栏目设置回复默认。如果类似这种打开列表就闪退的情况可以后台进行脚本操作。

以下是打开材料出库单列表时用到的重要脚本代码

Set Nocount on

Declare @ColumnDic Table([cKey] [nvarchar] (50)  NOT NULL ,

[cFld] [nvarchar] (100)  NOT NULL ,

[LocaleID] [nvarchar] (32)  NOT NULL,

[EnumShowType] tinyint,

[cCaption] [nvarchar](200) NULL)

insert into @ColumnDic select cKey ,cFld,LocaleID,EnumShowType,cCaption from UFMETA_915..aa_columndic_base where ckey='0412' and LocaleID='zh-CN'

insert into @columnDic select D1.cKey ,D1.cFld,D1.LocaleID,D1.EnumShowType,D1.cCaption

 from aa_columndic_base D1 left join @ColumnDic D2 on D1.cKey=D2.cKey and D1.cFld=D2.cFld and

  D1.LocaleID=D2.LocaleID  where D1.ckey='0412' and D1.LocaleID='zh-CN' and  D2.ccaption is null

Insert into #ColumnSet915F4872BF0A4DADAD417194DD2DD5A0(cKey ,cFld ,cQryField ,iColPos ,cCaption,

cSCaption,cCaptionPar,bFixed ,bDisp ,bStart,iColWidth,iAlign ,cOrder ,bLock  ,bMustSel ,bNeedSum ,

pubufts ,LocaleID ,IsEnum,EnumType ,EnumTypeString,bFilter  ,bMerge ,CanModify  ,ReferType  ,bHideInColSet  

,cSumType,iMergeCols,cProjectNO ,cSubID ,cPointBit  ,cFormat ,bIsHRField ,FormatString  ,StartProjectNO

,cEditStyle,iFieldType,bExtended,cOriginalCaption,EnumShowType,bMustInput,iLinkType,bCanModifyMustInput,

bCanModifyOrder)

 SELECT C.cKey ,C.cFld ,C.cQryField ,C.iColPos ,C.cCaption,C.cSCaption,C.cCaptionPar,C.bFixed ,C.bDisp ,C.bStart,C.iColWidth, 

 C.iAlign ,C.cOrder ,C.bLock  ,C.bMustSel ,C.bNeedSum ,Null As pubufts ,C.LocaleID ,C.IsEnum, 

 C.EnumType ,C.EnumTypeString,C.bFilter  ,C.bMerge ,C.CanModify  ,C.ReferType  ,C.bHideInColSet  ,C.cSumType,C.iMergeCols,

 C.cProjectNO ,C.cSubID ,C.cPointBit  ,C.cFormat ,C.bIsHRField ,C.FormatString  ,

 C.StartProjectNO,C.cEditStyle,C.iFieldType,C.bExtended,D.cCaption as cOriginalCaption,D.EnumShowType,

(Case When C.CanModify=1 Then (Case When isnull(S.bMustInput,C.bMustInput)=1 then 1 else C.bMustInput end) else 0 end) As bMustInput,C.iLinkType,(Case When isnull(S.bMustInput,0)=1 then 0 else isnull(C.bCanModifyMustInput,1) end) as bCanModifyMustInput,

isnull(C.bCanModifyOrder,1) as bCanModifyOrder from AA_ColumnDicCache_Detail C

 left outer join @columnDic  D on C.ckey=D.ckey and C.cFld=D.cFld and C.LocaleID=D.LocaleID 

 left outer join aa_columnset_base S on C.ckey=S.ckey and C.cfld=S.cfld and C.LocaleID=S.LocaleID and S.cUserID='U8.Pub.Col' Where C.cKey='0412' and C.LocaleID='zh-CN'

and C.cuserID='047[^]0412'

 Select * from #ColumnSet915F4872BF0A4DADAD417194DD2DD5A0 Where 1=1   and (isnull(bextended,0) in (0,3,-1) or(isnull(bextended,0)>0 and cfld in (select cextendfield from voucherextendfield where cardnumber in (select cardnumber from voucherextendtype where ',' + isnull(clistkeys,cardnumber) + ',' like '%,0412,%'))))

 And 1=1  Order By iColPos

经过分析，将后台闪退的用户相关设置 清空即可。

select 1 From UA_Operation where ID='ST021005' and UserId = '047' and IsBS =0

delete  from AA_ColumnDicCache_Detail

where cUserID ='047[^]0412'

后台操作有风险，不一定所有情况都适用本代码。注意保存备份。

承接北京用友软件服务，北京用友软件实施外包，欢迎来电