用友u8软件发货明细表_0
技术咨询，有偿服务！
复制微信号
发货明细表
原因分析：发货明细表发生错乱，开发提供了一个补丁，见解决方法。
问题解答：--------------------------------begin 发货明细表 补丁脚本Begin Declare @cItemName varchar(20) Set @cItemName = (Select cItemName from userDef Where cID = '01') If @cItemName Is Null update rpt_flddef set Name = '自定义项1' where Expression = 'cDefine1' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表（仓库）')) else update rpt_flddef set Name = @cItemName where Expression = 'cDefine1' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表（仓库）')) Set @cItemName = (Select cItemName from userDef Where cID = '02') If @cItemName Is Null update rpt_flddef set Name = '自定义项2' where Expression = 'cDefine2' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表（仓库）')) else update rpt_flddef set Name = @cItemName where Expression = 'cDefine2' And Id In (Select ID From Rpt_GlbDEF Where SystemID = 'SA' And Name In ('发货明细表（货物）', '发货明细表（部门）', '发货明细表（客户）', '发货明细表（业务员）', '发货明细表（仓库）')) endGO--更新发货明细表（客户)显示update rpt_flddef SET visible = -1 where id = 1363 and modeex = 0 and expression = '[Customer].[cCusAbbName]'GO--------------------begin 发货明细表 重新排序Declare @ID intDeclare @ID_Field intDeclare @iOrderEx int Declare Glb_Cur Cursor forselect ID from rpt_Glbdef where name like '发货明细表%' and SystemID = 'SA'Open Glb_Cur Fetch Next FROM Glb_Cur Into @IDWHILE @@FETCH_STATUS = 0Begin delete from Rpt_FldDEF where id = @ID and Expression = 'cDefine22'--重新排序(显示列排在前)update Rpt_FldDEF set OrderEx = 0 where Id = @ID and modeEx = 0 and visible = 0Set @iOrderEx = 0 Declare Fld_Cur Cursor For Select ID_Field from Rpt_FldDEF Where Id = @ID And ModeEx = 0 order by visible,OrderExOpen Fld_cur Fetch Next FROM Fld_Cur Into @ID_FieldWHILE @@FETCH_STATUS = 0BeginSet @iOrderEx = @iOrderEx + 1Update Rpt_FldDef Set OrderEx = @iOrderEx Where Id = @ID And ModeEx = 0 And ID_Field = @ID_FieldFetch Next FROM Fld_Cur Into @ID_FieldEnd CLOSE Fld_CurDEALLOCATE Fld_Cur Fetch Next FROM Glb_Cur Into @IDEnd CLOSE Glb_CurDEALLOCATE Glb_CurGO--------------------end 重新排序