2010年
- 首页
- 2010年
SQL语句修改表字段名/修改字段长度/增加字段/删除字段
修改字段名Exec sp_rename 'zxchem_Suggest.End_Date','Yj_Finish_Date','Column' 修改字段长度Alter Table zxchem_Suggest Alter Column Yj_Finish_Date Varchar(10) Not Null增加字段alter table docdsp add dspcode char(200)删除字段ALTER TABLE table_NAME DROP COLUMN column_NAME修改字段类型ALTER TABLE table_name ALTER COLUMN column_name new_data_type
Mscrm4 获取lookup的值
var lookupItem = new Array; lookupItem = crmForm.all.new_buildingid.DataValue; if (lookupItem[0] != null) { crmForm.all.new_name.DataValue=lookupItem[0].name; }
mscrm 将自定义的视图在sitemap中显示
<SubArea Title="我已完成的任务"Id="nav_task01"Url="/Workplace/home_activities.aspx?type=task&viewid=%7bD70EA66D-4B41-DF11-B3AB-0026182FF465%7d"/> 如下图其中viewid可以用microsoft developer tool找到
MSCRM4 ISV.Config
<ImportExportXml version="4.0.0.0" languagecode="1033" generatedBy="OnPremise"><Entities></Entities><Roles></Roles><Workflows></Workflows> <IsvConfig> <configuration version="3.0.0000.0"> <Root><!-- This section describes how to customize the area labels in the left pane in forms. <NavBarAreas> ...
控制MSCRM4菜单栏
修改_root/bar_top.aspx文件,在文件末尾添加以下代码,可以达到隐藏菜单的效果。<script type="text/javascript">document.getElementById("mnu_new_activity").style.display="none";document.getElementById("mnu_new_record").style.display="none";document.getElementById("btn_download_olk").style.display="none";document.getElementById("help").style.display="none";document.getElementById("btn_advfind").style.display="none";documen...
MSCRM4 隐藏按钮方法
///////////////////////////////////隐藏 将现有客户收费单添加到此记录 按钮//////////////////////////////////////////newnewkhjbxxnewkhsfd//客户收费单HideAssociatedViewButtons('new_new_khjbxx_new_khsfd', ['_MBtoplocAssocOneToMany10040newnewkhjbxxnewkhsfd']); //客户证件信息HideAssociatedViewButtons('new_new_khjbxx_new_khzjxx', ['_MBtoplocAssocOneToMany10074newnewkhjbxxnewkhzjxx']);//客户帐号信息HideAssociatedViewBut...