发货明细表
- 浏览:1617 - 发布时间:2008-07-06 11:28:24.0
问题版本: |
76-用友通标准版10.3 |
问题模块: |
17-销售管理 |
所属行业: |
0-通用 |
问题状态: |
2-UU通注册用户 |
关 键 字: |
发货明细表 |
适用产品: |
|
补 丁 号: |
|
开放状态: |
0-UU通注册用户 |
原问题号: |
|
提交时间: |
2008-7-6 11:28:24 |
问题名称: |
发货明细表 |
问题现象: |
发货明细表按照客户查询的时候,在发货明细表里点击格式按钮,将“客户”下移到第二行,之后在表体里“客户”一列消失了,格式里面的“客户”也没有了。 |
原因分析: |
发货明细表发生错乱,开发提供了一个补丁,见解决方法。 |
解决方案: |
--------------------------------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 ('发货明细表(货物)', '发货明细表(部门)', '发货明细表(客户)', '发货明细表(业务员)', '发货明细表(仓库)')) end GO --更新发货明细表(客户)显示 update rpt_flddef SET visible = -1 where id = 1363 and modeex = 0 and expression = '[Customer].[cCusAbbName]' GO --------------------begin 发货明细表 重新排序 Declare @ID int Declare @ID_Field int Declare @iOrderEx int Declare Glb_Cur Cursor for select ID from rpt_Glbdef where name like '发货明细表%' and SystemID = 'SA' Open Glb_Cur Fetch Next FROM Glb_Cur Into @ID WHILE @@FETCH_STATUS = 0 Begin delete from Rpt_FldDEF where id = @ID and Expression = 'cDefine22' --重新排序(显示列排在前) update Rpt_FldDEF set OrderEx = 0 where Id = @ID and modeEx = 0 and visible = 0 Set @iOrderEx = 0 Declare Fld_Cur Cursor For Select ID_Field from Rpt_FldDEF Where Id = @ID And ModeEx = 0 order by visible,OrderEx Open Fld_cur Fetch Next FROM Fld_Cur Into @ID_Field WHILE @@FETCH_STATUS = 0 Begin Set @iOrderEx = @iOrderEx + 1 Update Rpt_FldDef Set OrderEx = @iOrderEx Where Id = @ID And ModeEx = 0 And ID_Field = @ID_Field Fetch Next FROM Fld_Cur Into @ID_Field End CLOSE Fld_Cur DEALLOCATE Fld_Cur Fetch Next FROM Glb_Cur Into @ID End CLOSE Glb_Cur DEALLOCATE Glb_Cur GO --------------------end 重新排序 | |