--CRM菜单关联的关联表单
--SELECT F_GNBH BH,F_GNMC MC,YXXTCDGNGL_XSXH
--FROM LSGNZD,YXXTCDGNGL
--WHERE F_GNBH=YXXTCDGNGL_GNBH AND YXXTCDGNGL_CDBH='0010411'
--ORDER BY YXXTCDGNGL_XSXH,F_GNBH
--改已关联的CRM菜单的表单名称
--SELECT * FROM LSGNZD WHERE F_GNMC='商品销售数据统计表'
--UPDATE LSGNZD SET F_GNMC ='医院纯销数据统计表' WHERE F_GNMC='商品销售数据统计表'
--SELECT * FROM SDXTMKMC
--SELECT * FROM YXXTCDZD
--SELECT * FROM YXXTCDGNGL
--SELECT * FROM GSPROLEASS
--SELECT * FROM GSPPOSASS
SELECT * FROM GSPBizObjectOp WHERE NAME ='医院纯销数据统计表'
--UPDATE GSPBizObjectOp SET NAME ='医院纯销数据统计表' WHERE NAME='商品销售数据统计表'
SELECT * FROM YXXTGXHCDGL
--SELECT * FROM LSGNZD WHERE F_GNMC='医院纯销数据统计表'
--SELECT * FROM LSGNZDEX
--SELECT * FROM GSPBizObjectOp
SELECT * FROM YXXTCDGNB WHERE GNMC ='商品销售数据统计表'
--UPDATE YXXTCDGNB SET GNMC ='医院纯销数据统计表' WHERE GNMC ='商品销售数据统计表'
/*修改菜单名称*/
SELECT * FROM LSGNZD WHERE F_GNMC='商品销售数据统计表'
--UPDATE LSGNZD SET F_GNMC ='医院纯销数据统计表' WHERE F_GNMC='商品销售数据统计表'
SELECT * FROM GSPBizObjectOp WHERE NAME ='医院纯销数据统计表'
--UPDATE GSPBizObjectOp SET NAME ='医院纯销数据统计表' WHERE NAME='商品销售数据统计表'
SELECT * FROM YXXTCDGNB WHERE GNMC ='商品销售数据统计表'
--UPDATE YXXTCDGNB SET GNMC ='医院纯销数据统计表' WHERE GNMC ='商品销售数据统计表'